Migration Archive Audit — 2026-10-16
Connection: globalgala_2026_dev@localhost

SUMMARY
  files scanned: 49
  no-DDL: 12
  ❌ MISSING:         6
  ⚠️  PARTIAL:     10
  🔄 REPLACED:       0
  ✅ EXISTS:          7
  alter OK: 13
  drops: 13
  raw DDL flagged: 5

=== MISSING / PARTIAL ===

❌ 2026_01_09_000001_create_permission_overrides_table
    - table `permission_overrides` MISSING on DB
    - drop on `permission_overrides` — already dropped

❌ 2026_01_09_000003_create_access_logs_table
    - table `access_logs` MISSING on DB
    - drop on `access_logs` — already dropped

❌ 2026_01_11_184508_create_features_table
    - table `features` MISSING on DB
    - drop on `features` — already dropped

❌ 2026_01_12_160000_create_gala_state_transitions_table
    - table `gala_state_transitions` MISSING on DB
    - drop on `gala_state_transitions` — already dropped

❌ 2026_01_13_113402_create_template_versions_table
    - table `template_versions` MISSING on DB
    - drop on `template_versions` — already dropped

❌ 2026_01_22_190152_create_notification_preferences_table
    - table `notification_preferences` MISSING on DB
    - drop on `notification_preferences` — already dropped

⚠️ 2026_01_08_140000_add_currency_to_orders_and_normalize_events
    - alter on `orders` — MISSING columns: currency (of 1 expected)
    - ⚠️  contains 1 raw DB::statement call(s) — manual review needed

⚠️ 2026_01_11_173700_add_category_id_to_events_table
    - alter on `events` — MISSING columns: category_id (of 1 expected)

⚠️ 2026_01_11_183523_add_tax_rate_snapshot_to_orders_table
    - alter on `orders` — MISSING columns: tax_rate_snapshot (of 1 expected)

⚠️ 2026_01_11_184508_add_original_price_at_booking_to_order_line_items_table
    - alter on `order_line_items` — MISSING columns: original_price_at_booking (of 1 expected)

⚠️ 2026_01_11_223244_add_gala_columns_to_booking_access_codes
    - alter on `booking_access_codes` — MISSING columns: type, allowed_seats, price_override (of 3 expected)

⚠️ 2026_01_12_110000_add_venue_fork_data_to_events_table
    - alter on `events` — MISSING columns: venue_fork_data (of 1 expected)

⚠️ 2026_01_12_130000_add_fk_venue_fork_data_template_id
    - alter on `events` — MISSING columns: source_template_id (of 1 expected)

⚠️ 2026_01_13_115548_add_publishing_fields_to_venue_templates
    - alter on `venue_templates` — MISSING columns: is_published, published_at (of 2 expected)

⚠️ 2026_01_13_120000_add_template_lock_fields_to_venue_templates
    - alter on `venue_templates` — MISSING columns: locked_at, locked_reason (of 2 expected)

⚠️ 2026_01_22_220000_add_tracking_columns_to_email_logs
    - alter on `email_logs` — MISSING columns: tracking_id, smtp_message_id, bounce_reason, bounced_at, spam_report, spam_reported_at, delivered_at, opened_at, clicked_at, clicked_link (of 10 expected)