whitelabelMigrations: [
{
"slug": "example_1",
"name": "Example Migration #1",
"description": "Simple migration that demonstrates how to author a migration",
"dependencies": [],
"status": "pending",
"checkSql": "SELECT EXISTS (\n SELECT FROM information_schema.tables\n WHERE table_schema = 'public' \n AND table_name = 'example_migration_table_1'\n);",
"executeSql": "CREATE TABLE example_migration_table_1(\n id SERIAL PRIMARY KEY,\n message TEXT NOT NULL\n);\n\nINSERT INTO example_migration_table_1 (message) \nVALUES ('Hello Alice'), ('Hello Beth'), ('Hello Charles');",
"revertSql": "DROP TABLE example_migration_table_1",
"id": 1,
"createdOn": "2025-05-30T23:19:05.266Z",
"updatedOn": "2025-05-30T23:19:05.266Z",
"archived": false,
"archivedOn": null
},
{
"slug": "example_2",
"name": "Example Migration #2",
"description": "Simple migration that demonstrates migration dependency",
"dependencies": [
"example_1"
],
"status": "pending",
"checkSql": "SELECT EXISTS (\n SELECT FROM example_migration_table_1\n WHERE message = 'Hello David'\n);",
"executeSql": "INSERT INTO example_migration_table_1 (message) \nVALUES ('Hello David');",
"revertSql": "DELETE FROM example_migration_table_1 WHERE message = 'Hello David'",
"id": 2,
"createdOn": "2025-05-30T23:19:05.266Z",
"updatedOn": "2025-05-30T23:19:05.266Z",
"archived": false,
"archivedOn": null
},
{
"slug": "example_3",
"name": "Example Migration #3",
"description": "Simple migration that demonstrates migration dependency",
"dependencies": [
"example_1",
"example_2"
],
"status": "pending",
"checkSql": "SELECT EXISTS (\n SELECT FROM example_migration_table_1\n WHERE message = 'Hello Edith'\n);",
"executeSql": "INSERT INTO example_migration_table_1 (message) \nVALUES ('Hello Edith');",
"revertSql": "DELETE FROM example_migration_table_1 WHERE message = 'Hello Edith'",
"id": 3,
"createdOn": "2025-05-30T23:19:05.266Z",
"updatedOn": "2025-05-30T23:19:05.266Z",
"archived": false,
"archivedOn": null
}
]