zzstoatzz.io
prefect server in zig
1// migrations_data.zig - manually maintained migration list
2//
3// when adding a new migration:
4// 1. create migrations/NNN_description/ directory
5// 2. add sqlite.sql and postgres.sql files
6// 3. add entry to `all` array below
7
8pub const Migration = struct {
9 id: []const u8,
10 sqlite_sql: []const u8,
11 postgres_sql: []const u8,
12};
13
14pub const all = [_]Migration{
15 .{
16 .id = "001_initial",
17 .sqlite_sql = @embedFile("migrations/001_initial/sqlite.sql"),
18 .postgres_sql = @embedFile("migrations/001_initial/postgres.sql"),
19 },
20 .{
21 .id = "002_state_transition_id",
22 .sqlite_sql = @embedFile("migrations/002_state_transition_id/sqlite.sql"),
23 .postgres_sql = @embedFile("migrations/002_state_transition_id/postgres.sql"),
24 },
25 .{
26 .id = "003_concurrency_limits",
27 .sqlite_sql = @embedFile("migrations/003_concurrency_limits/sqlite.sql"),
28 .postgres_sql = @embedFile("migrations/003_concurrency_limits/postgres.sql"),
29 },
30 .{
31 .id = "004_log_table",
32 .sqlite_sql = @embedFile("migrations/004_log_table/sqlite.sql"),
33 .postgres_sql = @embedFile("migrations/004_log_table/postgres.sql"),
34 },
35 .{
36 .id = "005_automations",
37 .sqlite_sql = @embedFile("migrations/005_automations/sqlite.sql"),
38 .postgres_sql = @embedFile("migrations/005_automations/postgres.sql"),
39 },
40};