<?php
require 'includes/db.php';
try {
    $tables = ['employees', 'suppliers', 'buyers', 'users'];
    foreach ($tables as $table) {
        echo "\nIndexes for $table:\n";
        $stmt = $pdo->query("SHOW INDEX FROM $table");
        print_r($stmt->fetchAll());
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
