Naming Convention: V{version}__{description}.sql

• Version: Sequential number (V1, V2, V3...)
• Description: Underscore-separated description
• Example: V1__Initial_schema.sql, V2__Add_user_email_index.sql

Generate Initial Schema:

• Option A: Temporarily set spring.jpa.hibernate.ddl-auto=update, start app, then export schema from database
• Option B: Use Hibernate SchemaExport tool
• Option C: Manually write SQL based on your JPA entities

Creating New Migrations:

# Create new migration file
touch src/main/resources/db/migration/V{N}__{description}.sql

Write your SQL changes in the file.