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

try {
    $db = getDB();

    // Add time column to calendar_events table
    $sql = "ALTER TABLE calendar_events ADD COLUMN event_time TIME DEFAULT '09:00' AFTER event_date";

    $db->exec($sql);
    echo "Time column added to calendar_events table successfully!\n";

} catch (PDOException $e) {
    echo "Error adding time column: " . $e->getMessage() . "\n";
}
?>