<?php
// 创建数据库连接
$host = 'localhost';
$dbname = 'cps3500_quiz2';
$username = 'root';
$password = '';

try {
    $pdo = new PDO("mysql:host=$host", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // 创建数据库
    $pdo->exec("CREATE DATABASE IF NOT EXISTS $dbname");
    $pdo->exec("USE $dbname");
    
    // 创建users表
    $pdo->exec("CREATE TABLE IF NOT EXISTS users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        username VARCHAR(50) NOT NULL UNIQUE,
        password VARCHAR(255) NOT NULL
    )");
    
    // 插入初始数据
    $stmt = $pdo->prepare("INSERT IGNORE INTO users (username, password) VALUES 
        (:username1, :password1),
        (:username2, :password2),
        (:username3, :password3),
        (:username4, :password4)");
    
    $stmt->execute([
        ':username1' => 'Alex',
        ':password1' => password_hash('1234', PASSWORD_DEFAULT),
        ':username2' => 'Adam',
        ':password2' => password_hash('12345', PASSWORD_DEFAULT),
        ':username3' => 'Sara',
        ':password3' => password_hash('123456', PASSWORD_DEFAULT),
        ':username4' => 'Li',
        ':password4' => password_hash('1234567', PASSWORD_DEFAULT)
    ]);
    
} catch (PDOException $e) {
    die("Database error: " . $e->getMessage());
}
?>