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

try {
    // Connect to MySQL server without specifying a database
    $pdo = new PDO('mysql:host='.DB_HOST, DB_USER, DB_PASS, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    ]);

    // Create the database if it doesn't exist
    $pdo->exec("CREATE DATABASE IF NOT EXISTS " . DB_NAME . ";");
    $pdo->exec("USE " . DB_NAME . ";");

    echo "Database '" . DB_NAME . "' created or already exists.\n";

    // Packages table
    $pdo->exec("CREATE TABLE IF NOT EXISTS packages (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        price INT NOT NULL,
        duration_days INT NOT NULL,
        description TEXT,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    ) ENGINE=INNODB;");

    echo "Migration successful: 'packages' table created or already exists.\n";

    // Routers table
    $pdo->exec("CREATE TABLE IF NOT EXISTS routers (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        ip_address VARCHAR(45) NOT NULL,
        username VARCHAR(255) NOT NULL,
        password TEXT NOT NULL, -- Encrypted
        description TEXT,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        UNIQUE KEY ip_address (ip_address)
    ) ENGINE=INNODB;");

    echo "Migration successful: 'routers' table created or already exists.\n";


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