<?php
require_once 'config.php';

try {
    $pdo = db();
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Create users table
    $sql = "CREATE TABLE IF NOT EXISTS users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        username VARCHAR(50) NOT NULL UNIQUE,
        password VARCHAR(255) NOT NULL,
        email VARCHAR(100) NOT NULL UNIQUE,
        no_hp VARCHAR(20),
        role ENUM('admin', 'player') NOT NULL DEFAULT 'player',
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    )";
    $pdo->exec($sql);

    // Check if admin user exists
    $stmt = $pdo->prepare("SELECT id FROM users WHERE username = ?");
    $stmt->execute(['admin']);
    if ($stmt->fetchColumn() === false) {
        // Insert a default admin user if it doesn't exist
        $adminPassword = password_hash('admin123', PASSWORD_DEFAULT);
        $adminEmail = 'admin@example.com';
        $adminStmt = $pdo->prepare("INSERT INTO users (username, password, email, role) VALUES (?, ?, ?, ?)");
        $adminStmt->execute(['admin', $adminPassword, $adminEmail, 'admin']);
        echo "Default admin user created successfully.<br>";
    }

    echo "Database setup completed successfully!";

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