╔══════════════════════════════════════════╗
║  Strata: JSON → SQLite Migration v1.0   ║
╚══════════════════════════════════════════╝

Backed up existing DB to: /home/strataapps/public_html/deck-data/strata.db.backup-20260430-001625
Schema initialized.

1. Migrating reps...
  ERROR migrating rep admin: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: reps.id
  ERROR migrating rep rep_david: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: reps.id
  ERROR migrating rep rep_abby: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: reps.id
  ERROR migrating rep rep_demo: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: reps.id
  ERROR migrating rep rep_alyssa: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: reps.id
  ERROR migrating rep rep_c63ac85d: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: reps.id
  Done: 0 reps

2. Migrating tokens...
  ERROR migrating token t_5c729281b1aa: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: tokens.id
  ERROR migrating token t_10410f21ca1b: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: tokens.id
  ERROR migrating token t_7c3f5e7b6773: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: tokens.id
  ERROR migrating token t_847eabfe164e: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: tokens.id
  ERROR migrating token t_c248a2f64383: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: tokens.id
  ERROR migrating token t_3519edf9252b: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: tokens.id
  ERROR migrating token t_b243e4104a53: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: tokens.id
  Done: 0 tokens

3. Migrating token deck overrides...
  Done: 3 token deck overrides

4. Migrating analytics...
  Done: 446 events

5. Migrating AI insights...
  ERROR migrating insight 0: SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed
  ERROR migrating insight 1: SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed
  ERROR migrating insight 2: SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed
  ERROR migrating insight 3: SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed
  Done: 1 insights

6. Migrating slide content...
  Done: 30 slide content records

7. Migrating slide media...
  Done: 34 slide media records

8. Migrating slide order...
  Done: 0 slide orders

9. Migrating slide visibility...
  Done: 6 visibility records

10. Migrating quiz responses...
  Done: 16 quiz responses

11. Migrating transcripts...
  Done: 1 transcripts

12. Migrating comments...
  Done: 21 comments

13. Migrating playbook...
  Done: 1 playbook entries

14. Migrating slide bank...
  Done: 0 slide bank entries

15. Migrating settings...
  Done: 0 settings

16. Migrating deck profiles...
  Done: 5 deck profiles

╔══════════════════════════════════════════╗
║            MIGRATION SUMMARY             ║
╠══════════════════════════════════════════╣
║  Reps:                    0             ║
║  Tokens:                  0             ║
║  Token Deck Overrides:    3             ║
║  Analytics Events:      446             ║
║  AI Insights:             1             ║
║  Slide Content:          30             ║
║  Slide Media:            34             ║
║  Slide Order:             0             ║
║  Slide Visibility:        6             ║
║  Quiz Responses:         16             ║
║  Transcripts:             1             ║
║  Comments:               21             ║
║  Playbook Entries:        1             ║
║  Slide Bank:              0             ║
║  Settings:                0             ║
║  Deck Profiles:           5             ║
╠══════════════════════════════════════════╣
║  TOTAL RECORDS:         564             ║
║  ERRORS:               5375             ║
╚══════════════════════════════════════════╝

Migration complete WITH ERRORS. Review output above.
Do NOT switch backends until all errors are resolved.

Database size: 25884 KB (/home/strataapps/public_html/deck-data/strata.db)