<?php
require_once __DIR__ . '/../config.php';

try {
    $pdo = db();
    // Check if the column already exists
    $stmt = $pdo->query("SHOW COLUMNS FROM `service_requests` LIKE 'contract_id'");
    if ($stmt->rowCount() == 0) {
        $sql = "
        ALTER TABLE service_requests
        ADD COLUMN contract_id INT NULL,
        ADD CONSTRAINT fk_contract_id
        FOREIGN KEY (contract_id)
        REFERENCES contracts(id)
        ON DELETE SET NULL;
        ";
        $pdo->exec($sql);
        echo "Column 'contract_id' added to 'service_requests' table." . PHP_EOL;
    } else {
        echo "Column 'contract_id' already exists in 'service_requests' table." . PHP_EOL;
    }
} catch (PDOException $e) {
    die("DB ERROR: " . $e->getMessage());
}