Explain Flyway's naming convention for migration files.

Beginner

Answer

Flyway uses a strict naming convention:
Format: <Prefix><Version>__<Description>.<Suffix>

  • Prefix: V (versioned), R (repeatable), U (undo)
  • Version: Dots or underscores separated (V1, V1.1, V1_2_1)
  • Separator: Double underscore (__)
  • Description: Descriptive text with underscores
  • Suffix: .sql (default)
    Examples:
V1__Initial_schema.sql
V1.1__Add_user_email.sql
V2__Create_orders_table.sql
R__Update_statistics_view.sql