major-domo-database/migrations
Cal Corum eccf4d1441
All checks were successful
Build Docker Image / build (pull_request) Successful in 2m11s
feat: add migration tracking system (#81)
Adds schema_versions table and migrations.py runner to prevent
double-application and missed migrations across dev/prod environments.

- migrations/2026-03-27_add_schema_versions_table.sql: creates tracking table
- migrations.py: applies pending .sql files in sorted order, records each in schema_versions
- .gitignore: untrack migrations.py (was incorrectly ignored as legacy root file)

First run on an existing DB will apply all migrations (safe — all use IF NOT EXISTS).

Closes #81

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-03-27 05:34:13 -05:00
..
2025-12-09_add_team_salary_cap.sql Add salary_cap column to Team model (v2.2.0) 2025-12-10 07:28:16 -06:00
2026-02-06_add_player_name_index.sql Optimize player search endpoint for 30x performance improvement 2026-02-06 07:25:49 -06:00
2026-03-27_add_schema_versions_table.sql feat: add migration tracking system (#81) 2026-03-27 05:34:13 -05:00
add_custom_commands_tables.sql File cleanup 2025-10-25 20:17:02 -05:00
add_help_commands_table.sql File cleanup 2025-10-25 20:17:02 -05:00