<?php
require_once __DIR__ . '/../config/database.php';

echo "Manual Room Allocations Table Structure:\n";
echo "=========================================\n";

$stmt = $pdo->query("DESCRIBE manual_room_allocations");
while ($row = $stmt->fetch()) {
    echo $row['Field'] . ": " . $row['Type'];
    if ($row['Default'] !== null) {
        echo " (Default: " . $row['Default'] . ")";
    }
    echo "\n";
}
?>