<?php
header('Content-Type: text/plain');
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once __DIR__ . '/config.php';
require_once __DIR__ . '/includes/db.php';

try {
    $pdo = getDB();
    $row = $pdo->query("SHOW CREATE TABLE `affiliation_applications`")->fetch(PDO::FETCH_ASSOC);
    
    echo "=== CREATE TABLE DEFINITION ===\n";
    echo $row['Create Table'] . "\n";
} catch (Exception $e) {
    echo "Error executing query: " . $e->getMessage() . "\n";
}