<?php
define('DB_HOST', 'localhost');
define('DB_NAME', 'olive188_mvptimer');
define('DB_USER', 'olive188_mvptimer');
define('DB_PASS', 'Cobotoeiti1!');

try {
    $pdo = new PDO(
        "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8",
        DB_USER,
        DB_PASS,
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );
} catch (PDOException $e) {
    http_response_code(500);
    die(json_encode(['error' => 'Erro de conexao: ' . $e->getMessage()]));
}

$pdo->exec("
    CREATE TABLE IF NOT EXISTS timers (
        mvp_id INT PRIMARY KEY,
        mvp_name VARCHAR(100) NOT NULL,
        death_time BIGINT NOT NULL,
        respawn_minutes INT NOT NULL,
        killed_by VARCHAR(100) DEFAULT '',
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )
");
?>