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

try {
    $db = getDB();

    echo "Users table columns:\n";
    $stmt = $db->query('DESCRIBE users');
    $columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($columns as $col) {
        echo $col['Field'] . ' - ' . $col['Type'] . "\n";
    }

    echo "\nResearcher profiles table columns:\n";
    $stmt = $db->query('DESCRIBE researcher_profiles');
    $columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($columns as $col) {
        echo $col['Field'] . ' - ' . $col['Type'] . "\n";
    }

} catch (Exception $e) {
    echo 'Error: ' . $e->getMessage() . "\n";
}
?>