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

try {
    $conn = db();
    $sql = "ALTER TABLE events ADD COLUMN created_by INT(11) NULL, ADD FOREIGN KEY (created_by) REFERENCES users(id)";
    $conn->exec($sql);
    echo "Migration successful: 'created_by' column added to 'events' table." . PHP_EOL;
} catch (PDOException $e) {
    echo "Migration failed: " . $e->getMessage() . PHP_EOL;
}