18 lines
561 B
PHP
18 lines
561 B
PHP
<?php
|
|
require_once __DIR__ . '/config.php';
|
|
|
|
try {
|
|
$db = db();
|
|
// Check if column already exists
|
|
$columns = $db->query("SHOW COLUMNS FROM game_resources LIKE 'show_in_header'")->fetchAll();
|
|
if (empty($columns)) {
|
|
$db->exec("ALTER TABLE game_resources ADD COLUMN show_in_header TINYINT(1) DEFAULT 0");
|
|
echo "Column 'show_in_header' added successfully to 'game_resources'.\n";
|
|
} else {
|
|
echo "Column 'show_in_header' already exists.\n";
|
|
}
|
|
} catch (PDOException $e) {
|
|
echo "Error: " . $e->getMessage() . "\n";
|
|
}
|
|
|