<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

require_once 'db.php';

// Query ya kuongeza column ikiwa haipo
$sql = "ALTER TABLE users ADD COLUMN IF NOT EXISTS status ENUM('active','blocked') DEFAULT 'active'";

if ($conn->query($sql) === TRUE) {
    echo "✅ Column 'status' added successfully (or already exists)!";
} else {
    echo "❌ Error: " . $conn->error;
}

$conn->close();