<?php
require_once 'includes/db.php';

try {
    // Add agent_id column to allocations table
    $sql = "ALTER TABLE allocations ADD COLUMN agent_id BIGINT(20) UNSIGNED NULL AFTER user_id";
    $pdo->exec($sql);
    echo "Column agent_id added successfully.\n";
    
    // Add foreign key constraint (optional but good practice)
    // $sql = "ALTER TABLE allocations ADD CONSTRAINT fk_allocations_agent FOREIGN KEY (agent_id) REFERENCES users(id) ON DELETE SET NULL";
    // $pdo->exec($sql);
    // echo "Foreign key added successfully.\n";

} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>