18 lines
550 B
PHP
18 lines
550 B
PHP
<?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";
|
|
}
|
|
|