soroban-abacus-flashcards/apps/web/drizzle
Thomas Hallock 3bae00b9a9 feat: add drizzle migration for room_game_configs table
Creates migration 0011 to:
- Create room_game_configs table with proper schema
- Add unique index on (room_id, game_name)
- Migrate existing game_config data from arcade_rooms table

Migration is idempotent and safe to run on any database state:
- Uses IF NOT EXISTS for table and index creation
- Uses INSERT OR IGNORE to avoid duplicate data
- Will work on both fresh databases and existing production

This ensures production will automatically get the new table structure
when the migration runs on deployment.

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-10-15 13:40:40 -05:00
..
meta feat: add drizzle migration for room_game_configs table 2025-10-15 13:40:40 -05:00
0000_third_carnage.sql
0001_friendly_stingray.sql
0002_loose_ultimatum.sql
0003_naive_reptil.sql
0004_shiny_madelyne_pryor.sql
0005_flimsy_squadron_sinister.sql
0005_jazzy_mimic.sql
0006_pretty_invaders.sql
0007_access_modes.sql
0008_make_room_name_nullable.sql feat: improve room creation UX and add password support for share links 2025-10-14 07:09:22 -05:00
0009_add_display_password.sql fix(migrations): add migration 0009 for display_password column 2025-10-14 09:56:26 -05:00
0010_make_game_name_nullable.sql refactor: make game_name nullable to support in-room game selection 2025-10-14 11:30:27 -05:00
0011_add_room_game_configs.sql feat: add drizzle migration for room_game_configs table 2025-10-15 13:40:40 -05:00