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

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