╔═══════════════════════════════════════════════════════════════╗
║           📋 PRE-DEPLOYMENT DATABASE CHECKER                 ║
╚═══════════════════════════════════════════════════════════════╝

🔍 Checking database: trueid
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

1️⃣  CHECKING CRITICAL TABLES
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  ✅ users
  ✅ qr_codes
  ✅ products
  ✅ customers
  ❌ agents - MISSING!
  ✅ sellers
  ✅ sites
  ✅ jobs
  ✅ migrations

⚠️  WARNING: Missing tables detected!

2️⃣  CHECKING QR_CODES TABLE SCHEMA
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  ✅ id
  ✅ serial
  ✅ qr_pin
  ✅ status
  ✅ used_at
  ✅ assigned_to_id
  ✅ assigned_to_type
  ✅ last_exported_at
  ✅ product_id
  ✅ is_lucky
  ✅ attempts
  ✅ batch_id
  ✅ verified_by_customer_id
  ✅ created_at
  ✅ updated_at

✅ All required columns exist in qr_codes table

3️⃣  CHECKING MIGRATIONS STATUS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  📁 Migration files in /database/migrations: 13
  ✅ Ran migrations in database: 14

  ✅ All migrations have been run

4️⃣  CHECKING QR_CODES TABLE INDEXES
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  ✅ qr_codes_serial_unique
  ✅ qr_codes_qr_pin_unique
  ✅ qr_codes_serial_index
  ✅ qr_codes_status_index
  ✅ qr_codes_attempts_index
  ⚠️  serial_qrpin_composite_idx - Missing (may affect performance)

  Total indexes found: 18

5️⃣  DEPLOYMENT CHECKLIST
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  ⚠️  ISSUES FOUND:
     • Missing tables: agents

  ⚠️  FIX THESE ISSUES BEFORE DEPLOYING!
     Run: php artisan migrate

6️⃣  EXPORTING SCHEMA FOR COMPARISON
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  ✅ Schema exported to: C:\laragon\www\trueid/storage/app/local-schema-2025-12-10-132604.json
  📝 You can compare this with your live site schema

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
✅ Check complete!
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━