0UT1S's

// Create tables
$queries = [
    "CREATE TABLE IF NOT EXISTS admins (
        id INT PRIMARY KEY AUTO_INCREMENT,
        username VARCHAR(50) NOT NULL UNIQUE,
        password VARCHAR(255) NOT NULL
    )",
    
    "CREATE TABLE IF NOT EXISTS posts (
        id INT PRIMARY KEY AUTO_INCREMENT,
        title VARCHAR(255) NOT NULL,
        slug VARCHAR(255) NOT NULL UNIQUE,
        content TEXT NOT NULL,
        meta_title VARCHAR(60),
        meta_description VARCHAR(160),
        tags VARCHAR(255),
        image VARCHAR(255),
        status ENUM('draft', 'published') DEFAULT 'draft',
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )"
];

foreach ($queries as $query) {
    $db->query($query);
}

// Create admin user
$password = password_hash('admin123', PASSWORD_DEFAULT);
$db->query("INSERT IGNORE INTO admins (username, password) VALUES ('admin', '$password')");
?>