<?php
require_once __DIR__ . '/../../app/core/bootstrap.php';
$pdo = crm_pdo();
try {
    $pdo->exec("ALTER TABLE project_assignments ADD COLUMN offer_filename VARCHAR(255) NULL AFTER notes");
    echo "Added offer_filename column successfully.\n";
} catch (Throwable $e) {
    if (strpos($e->getMessage(), 'Duplicate column') !== false) {
        echo "Column already exists.\n";
    } else {
        echo "Error: " . $e->getMessage() . "\n";
    }
}
