// migrations_data.zig - manually maintained migration list
//
// when adding a new migration:
// 1. create migrations/NNN_description/ directory
// 2. add sqlite.sql and postgres.sql files
// 3. add entry to `all` array below

pub const Migration = struct {
    id: []const u8,
    sqlite_sql: []const u8,
    postgres_sql: []const u8,
};

pub const all = [_]Migration{
    .{
        .id = "001_initial",
        .sqlite_sql = @embedFile("migrations/001_initial/sqlite.sql"),
        .postgres_sql = @embedFile("migrations/001_initial/postgres.sql"),
    },
    .{
        .id = "002_state_transition_id",
        .sqlite_sql = @embedFile("migrations/002_state_transition_id/sqlite.sql"),
        .postgres_sql = @embedFile("migrations/002_state_transition_id/postgres.sql"),
    },
    .{
        .id = "003_concurrency_limits",
        .sqlite_sql = @embedFile("migrations/003_concurrency_limits/sqlite.sql"),
        .postgres_sql = @embedFile("migrations/003_concurrency_limits/postgres.sql"),
    },
    .{
        .id = "004_log_table",
        .sqlite_sql = @embedFile("migrations/004_log_table/sqlite.sql"),
        .postgres_sql = @embedFile("migrations/004_log_table/postgres.sql"),
    },
    .{
        .id = "005_automations",
        .sqlite_sql = @embedFile("migrations/005_automations/sqlite.sql"),
        .postgres_sql = @embedFile("migrations/005_automations/postgres.sql"),
    },
};