SQL Migrations Directory
This folder contains Flyway SQL migration files.
IMPORTANT: Agent Rules
DO NOT modify or delete any existing files in this folder.
ONLY add new migration files following the Flyway naming convention:
V{version}__{description}.sqlfor versioned migrationsU{version}__{description}.sqlfor undo migrations (optional)R__{description}.sqlfor repeatable migrations
Naming Convention Examples
V1__create_users_table.sqlV2__add_email_to_users.sqlV3__create_orders_table.sqlR__refresh_views.sql
Why This Restriction?
Flyway tracks applied migrations by checksum. Modifying an already-applied migration will cause:
- Migration failures
- Checksum mismatch errors
- Database inconsistency
If you need to change existing schema, create a NEW migration file with the next version number.