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

try {
    $db = db();
    $sql = file_get_contents(__DIR__ . '/migrations/001_initial_schema.sql');
    $db->exec($sql);
    echo "Database schema created successfully.";
} catch (PDOException $e) {
    die("Database setup failed: " . $e->getMessage());
}