<?php
require_once 'config.php';

try {
    $pdo = db();
    
    // Migration for servers table
    $pdo->exec("CREATE TABLE IF NOT EXISTS servers (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        owner_id INT NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (owner_id) REFERENCES users(id)
    ) ENGINE=INNODB;");

    // Migration for server_members table
    $pdo->exec("CREATE TABLE IF NOT EXISTS server_members (
        id INT AUTO_INCREMENT PRIMARY KEY,
        server_id INT NOT NULL,
        user_id INT NOT NULL,
        joined_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (server_id) REFERENCES servers(id) ON DELETE CASCADE,
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
        UNIQUE KEY (server_id, user_id)
    ) ENGINE=INNODB;");

    echo "Database migration completed successfully! Tables 'servers' and 'server_members' are ready.";

} catch (PDOException $e) {
    die("Database migration failed: " . $e->getMessage());
}