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

try {
    // Add customization columns to the manual_room_allocations table
    $sql = "
    ALTER TABLE manual_room_allocations 
    ADD COLUMN font_size INT DEFAULT 14,
    ADD COLUMN text_color VARCHAR(7) DEFAULT '#000000',
    ADD COLUMN font_weight VARCHAR(10) DEFAULT 'normal'
    ";
    
    $pdo->exec($sql);
    
    echo "Customization columns added successfully!";
    
} catch (PDOException $e) {
    // Check if columns already exist
    if (strpos($e->getMessage(), 'Duplicate column name') !== false) {
        echo "Customization columns already exist!";
    } else {
        echo "Error: " . $e->getMessage();
    }
}
?>