<?php
require_once '../includes/db.php';

echo "Columns in result_configurations table:\n";
$stmt = $pdo->query('DESCRIBE result_configurations');
while($row = $stmt->fetch()) {
    echo $row['Field'] . ' - ' . $row['Type'] . "\n";
}

echo "\nSample data from result_configurations for event 3:\n";
$stmt = $pdo->prepare('SELECT * FROM result_configurations WHERE event_id = ? LIMIT 3');
$stmt->execute([3]);
$configs = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach($configs as $config) {
    echo "Config: " . json_encode($config) . "\n";
}
?>
