<?php
require_once __DIR__ . '/config.php';
$db = db();

$db->exec("CREATE TABLE IF NOT EXISTS site_settings (
    `key` VARCHAR(50) PRIMARY KEY,
    `value` TEXT,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;");

// Insert default logo placeholder if not exists
$stmt = $db->prepare("INSERT IGNORE INTO site_settings (`key`, `value`) VALUES ('project_logo', 'assets/images/logo_placeholder.png')");
$stmt->execute();

echo "Table site_settings créée ou déjà existante.\n";