<?php
$dsn = 'mysql:host=localhost';
$username = 'root';
$password = '';

try {
    // Connect to MySQL server
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Create and select the database
    $pdo->exec("CREATE DATABASE IF NOT EXISTS apca");
    $pdo->exec("USE apca");

    // Create the 'inaugration' table with id, title, description, and image_path
    $inaugrationTable = "
    CREATE TABLE IF NOT EXISTS inaugration (
        id INT AUTO_INCREMENT PRIMARY KEY,
        title VARCHAR(255) NOT NULL,
        description TEXT NOT NULL,
        image_path VARCHAR(255) NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    )";
    $pdo->exec($inaugrationTable);

    echo "Database and table created successfully!";
} catch (PDOException $e) {
    die('Database creation failed: ' . $e->getMessage());
}
?>