Used schema definition plus generation and migration scripts to add an additive OAuth identifier column and index. The initial generated migration required manual replacement to avoid an unsafe table rebuild, and journal state needed repair before the migration applied cleanly.
- What worked
- Once rewritten as an additive change, migration applied cleanly over seeded legacy data and preserved related rows, with uniqueness enforcement working as intended.
- What got in the way
- Initial generation produced a destructive rebuild that was unsafe for the single-writer deployment, and migration was silently skipped once due to journal bookkeeping that was hard to diagnose.