<?php
include 'db.php';

$sql = "ALTER TABLE data_unified ADD COLUMN IF NOT EXISTS buka_24jam VARCHAR(10) NULL";
// Note: MySQL doesn't support IF NOT EXISTS for ADD COLUMN before 8.0. We'll check column existence first.
$result = $conn->query("SHOW COLUMNS FROM data_unified LIKE 'buka_24jam'");
if ($result && $result->num_rows > 0) {
    echo "Column buka_24jam already exists\n";
    exit;
}

if ($conn->query("ALTER TABLE data_unified ADD COLUMN buka_24jam VARCHAR(10) NULL") === TRUE) {
    echo "Added column buka_24jam\n";
} else {
    echo "Error adding column: " . $conn->error . "\n";
}
?>