<?php
require 'config/database.php';
$tables = $pdo->query("SHOW TABLES")->fetchAll(PDO::FETCH_COLUMN);
echo "TABLES:\n";
foreach ($tables as $table) {
    echo "- $table\n";
}

echo "\nVEHICLES COLUMNS:\n";
foreach ($pdo->query("SHOW COLUMNS FROM vehicles") as $col) {
    echo $col['Field'] . ' ' . $col['Type'] . '\n';
}

echo "\nDRIVERS COLUMNS:\n";
foreach ($pdo->query("SHOW COLUMNS FROM drivers") as $col) {
    echo $col['Field'] . ' ' . $col['Type'] . '\n';
}
