Running DB Migrations on " . (ENVIRONMENT === 'production' ? 'PRODUCTION' : 'DEVELOPMENT') . " Database...";
echo "";
try {
// Check if column registration_number already exists
$check = $pdo->query("SHOW COLUMNS FROM `affiliation_applications` LIKE 'registration_number'")->fetch();
if ($check) {
echo "- Column registration_number already exists. Skipping.
";
} else {
$pdo->exec("ALTER TABLE `affiliation_applications` ADD COLUMN `registration_number` VARCHAR(100) DEFAULT ''");
echo "- Column registration_number added successfully!
";
}
} catch (Exception $e) {
echo "- Error adding registration_number: " . htmlspecialchars($e->getMessage()) . "
";
}
echo "
";
echo "DB Migrations Completed!
";