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

$tables = ['payments', 'properties', 'allocations'];

foreach ($tables as $table) {
    try {
        $stmt = $pdo->query("DESCRIBE $table");
        $columns = $stmt->fetchAll(PDO::FETCH_COLUMN);
        if (in_array('status', $columns)) {
            echo "$table: OK (has status)\n";
        } else {
            echo "$table: MISSING status column\n";
            echo "Columns: " . implode(", ", $columns) . "\n";
        }
    } catch (Exception $e) {
        echo "$table: Error - " . $e->getMessage() . "\n";
    }
}
?>