╔═══════════════════════════════════════════════════════════════╗
║                  MIGRATION QUICK CHECKLIST                    ║
╠═══════════════════════════════════════════════════════════════╣
║                                                               ║
║  □ 1. CREATE BACKUP                                          ║
║      pg_dump -U postgres -d taf_db > backup.sql              ║
║                                                               ║
║  □ 2. RUN MIGRATION (from TAF root directory)               ║
║      cd /home/kevin_admin/projects/TAF                      ║
║      psql -U postgres -d taf_db -f                           ║
║        migrations/20251005_live_db_migration.sql             ║
║                                                               ║
║  □ 3. POPULATE MODULES                                       ║
║      psql -U postgres -d taf_db -f sql/modules.sql          ║
║                                                               ║
║  □ 4. HARD REFRESH BROWSER                                   ║
║      Press Ctrl+Shift+R (or Cmd+Shift+R)                    ║
║                                                               ║
║  □ 5. TEST LOGIN                                             ║
║      Login as admin and regular user                         ║
║                                                               ║
║  □ 6. TEST CASE MANAGEMENT                                   ║
║      □ Open module                                           ║
║      □ Select a case                                         ║
║      □ Check Documents tab                                   ║
║      □ Upload a document                                     ║
║      □ Create a folder                                       ║
║      □ Click Back button                                     ║
║                                                               ║
║  □ 7. MONITOR (24 hours)                                     ║
║      Watch for errors in logs                                ║
║                                                               ║
║  □ 8. CLEANUP (after 7 days)                                 ║
║      DROP TABLE _backup_* CASCADE;                           ║
║                                                               ║
╠═══════════════════════════════════════════════════════════════╣
║  ⏱️  Estimated time: ~10 minutes                              ║
║  📁 Backups created: 28 tables                               ║
║     (8 core + 20 user_* authentication/permission tables)    ║
║  ⚡ Zero data loss                                           ║
║  🔄 Easy rollback available                                  ║
╚═══════════════════════════════════════════════════════════════╝

ROLLBACK (if needed):
  psql -U postgres -d taf_db < backup.sql