<?php
require __DIR__ . '/../vendor/autoload.php';

use App\Config\AppConfig;
use App\Support\Database;

AppConfig::loadEnv(__DIR__ . '/..');

$db = Database::getConnection(
    AppConfig::get('DB_HOST'),
    AppConfig::get('DB_NAME'),
    AppConfig::get('DB_USER'),
    AppConfig::get('DB_PASS')
);

echo "=== Columns in locations table ===\n\n";

$stmt = $db->query('DESCRIBE locations');
$columns = $stmt->fetchAll();

foreach ($columns as $col) {
    echo "Field: {$col['Field']}\n";
    echo "  Type: {$col['Type']}\n";
    echo "  Null: {$col['Null']}\n";
    echo "  Key: {$col['Key']}\n";
    echo "  Default: " . ($col['Default'] ?? 'NULL') . "\n";
    echo "  Extra: {$col['Extra']}\n\n";
}