<?php
require_once 'core/Database.php';

echo "TABLE: roles\n";
try {
    $stmt = db()->query("DESCRIBE roles"); // Or PRAGMA table_info('roles') for SQLite
    $cols = $stmt->fetchAll();
    foreach ($cols as $col) {
        print_r($col);
    }
} catch (Exception $e) {
    try {
        $stmt = db()->query("PRAGMA table_info('roles')");
        $cols = $stmt->fetchAll();
        foreach ($cols as $col) {
            print_r($col);
        }
    } catch (Exception $e2) {
        echo "Error: " . $e2->getMessage();
    }
}
