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

try {
    // Check if column exists
    $stmt = $db->query("SHOW COLUMNS FROM guilds LIKE 'recruitment_status'");
    if (!$stmt->fetch()) {
        $db->exec("ALTER TABLE guilds ADD COLUMN recruitment_status ENUM('ouvert', 'validation', 'ferme') DEFAULT 'ouvert'");
        echo "Column 'recruitment_status' added to 'guilds' table.\n";
    } else {
        echo "Column 'recruitment_status' already exists.\n";
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}