<?php
require_once __DIR__ . '/../../app/core/bootstrap.php';
$pdo = crm_pdo();
$tables = ['project_assignments', 'project_payments', 'project_equipment', 'project_photos', 'project_visits'];
foreach ($tables as $t) {
    echo "Table $t:\n";
    $stmt = $pdo->query("SHOW CREATE TABLE $t");
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    echo $row['Create Table'] . "\n\n";
}
