#!/usr/bin/env php
===========================================
X.1.0 Database Cleanup Verification
===========================================
Database: globalgala_2026_dev
Host: localhost
-------------------------------------------

[PASS] Event #1 exists with correct attributes
[FAIL] Event #1 has 1,517 seats with unique UUIDs
       Error: Event #1 should have 1,517 seats, got 1882
[PASS] Venue #1 exists with relationships
[FAIL] Orders table empty with intact schema
       Error: Orders table should be empty, got 709
[FAIL] Seat reservations table empty
       Error: Seat reservations should be empty, got 3599
[FAIL] No orphaned foreign key references
       Error: Should have exactly 1 venue, got 9
[PASS] Event #1 pricing data accessible
[PASS] Seat data shape for simulation

-------------------------------------------
RESULTS: 4 passed, 4 failed
-------------------------------------------

Failed tests:
  - Event #1 has 1,517 seats with unique UUIDs
  - Orders table empty with intact schema
  - Seat reservations table empty
  - No orphaned foreign key references