#!/usr/bin/env php
=== Fixing Migration Syntax ===

Scanning 297 migration files...

✓ 032_add_sales_forecasting_columns.sql - Fixed 21 issue(s)
  - 7 ADD INDEX
  - 14 ADD COLUMN
✓ 032_add_sales_forecasting_columns_v2.sql - Fixed 17 issue(s)
  - 6 ADD INDEX
  - 11 ADD COLUMN
✓ 033_add_overhead_allocation_to_opportunities.sql - Fixed 6 issue(s)
  - 2 ADD INDEX
  - 4 ADD COLUMN
✓ 034_add_location_to_opportunities.sql - Fixed 2 issue(s)
  - 1 ADD INDEX
  - 1 ADD COLUMN
✓ 145_refactor_security_to_positions.sql - Fixed 1 issue(s)
  - 1 ADD COLUMN
✓ 192_add_employee_photos_and_documents.sql - Fixed 2 issue(s)
  - 2 ADD COLUMN
✓ 199_add_notification_support_fields.sql - Fixed 53 issue(s)
  - 21 ADD INDEX
  - 32 ADD COLUMN
✓ 205_add_routing_columns_to_menu_items.sql - Fixed 6 issue(s)
  - 2 ADD INDEX
  - 4 ADD COLUMN
✓ 206_add_email_alias_to_users.sql - Fixed 2 issue(s)
  - 1 CREATE INDEX
  - 1 ADD COLUMN
✓ 208_add_email_performance_indexes.sql - Fixed 9 issue(s)
  - 9 CREATE INDEX
✓ 223_enhance_job_applications_comprehensive.sql - Fixed 88 issue(s)
  - 5 CREATE INDEX
  - 83 ADD COLUMN
✓ 229_enhance_contact_fields.sql - Fixed 43 issue(s)
  - 5 ADD INDEX
  - 38 ADD COLUMN
✓ 230_add_county_to_contacts.sql - Fixed 2 issue(s)
  - 2 ADD COLUMN
✓ 231_add_address_fields_to_suppliers.sql - Fixed 4 issue(s)
  - 4 ADD COLUMN
✓ 232_enhance_company_addresses.sql - Fixed 10 issue(s)
  - 2 CREATE INDEX
  - 8 ADD COLUMN
✓ 241_m1_sidebar_missing_tables.sql - Fixed 6 issue(s)
  - 6 ADD INDEX
✓ 243_file_upload_enhancements.sql - Fixed 4 issue(s)
  - 4 CREATE INDEX
✓ 248_employee_portal_phase1.sql - Fixed 2 issue(s)
  - 2 CREATE INDEX
✓ 253_enhance_sales_orders.sql - Fixed 20 issue(s)
  - 5 CREATE INDEX
  - 15 ADD COLUMN
✓ 259_add_user_menu_support.sql - Fixed 2 issue(s)
  - 1 ADD INDEX
  - 1 ADD COLUMN
✓ 267_add_sub_location_id_to_inventory_tables.sql - Fixed 8 issue(s)
  - 4 ADD INDEX
  - 4 ADD COLUMN
✓ 268_add_opportunity_financials.sql - Fixed 13 issue(s)
  - 4 ADD INDEX
  - 9 ADD COLUMN
✓ 268_add_profile_social_contact_fields.sql - Fixed 12 issue(s)
  - 12 ADD COLUMN
✓ 269_deploy_financial_report_production.sql - Fixed 13 issue(s)
  - 4 ADD INDEX
  - 9 ADD COLUMN
✓ 270_add_pipedrive_tracking_fields.sql - Fixed 14 issue(s)
  - 6 ADD INDEX
  - 8 ADD COLUMN
✓ 278_add_soft_delete_to_additional_modules.sql - Fixed 14 issue(s)
  - 7 CREATE INDEX
  - 7 ADD COLUMN
✓ 280_add_military_service_fields.sql - Fixed 8 issue(s)
  - 8 ADD COLUMN

=== Summary ===
Files modified: 27
Total fixes: 382

✓ Migration files have been fixed!
Note: The original 'IF NOT EXISTS' logic is no longer present.
If you need idempotent migrations, you'll need to add explicit checks.