Database Migrations

Sprint 1
Migration Status
Migration File Date Status
20240101_create_core_tables.sql 2024-01-01 Executed
20240102_create_bonus_tables.sql 2024-01-02 Executed
20240103_insert_initial_data.sql 2024-01-03 Executed
20240104_fix_purchase_status_enum.sql 2024-01-04 Executed
20240105_create_migration_log.sql 2024-01-05 Executed
20240106_add_dispute_status.sql 2024-01-06 Executed
20240107_add_subscription_fields.sql 2024-01-07 Executed
20240108_add_subscription_cancelled_status.sql 2024-01-08 Executed
20240109_fix_subscription_cancelled_enum.sql 2024-01-09 Executed
All migrations are up to date!
Home System Test
Instructions:
  • Migration files should be placed in /migrations/ directory
  • Filename format: YYYYMMDD_description.sql
  • Example: 20240101_create_users_table.sql
  • Migrations are executed in chronological order
  • Each migration is logged to prevent re-execution