diff options
Diffstat (limited to 'sqitch')
-rw-r--r-- | sqitch/pg/deploy/fix_allocated_builds_attempt_2.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/fix_allocated_builds_attempt_2.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/fix_allocated_builds_attempt_2.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/fix_allocated_builds_attempt_2.sql | 12 | ||||
-rw-r--r-- | sqitch/sqlite/revert/fix_allocated_builds_attempt_2.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/fix_allocated_builds_attempt_2.sql | 7 |
7 files changed, 48 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/fix_allocated_builds_attempt_2.sql b/sqitch/pg/deploy/fix_allocated_builds_attempt_2.sql new file mode 100644 index 0000000..8a5c82d --- /dev/null +++ b/sqitch/pg/deploy/fix_allocated_builds_attempt_2.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:fix_allocated_builds_attempt_2 to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/fix_allocated_builds_attempt_2.sql b/sqitch/pg/revert/fix_allocated_builds_attempt_2.sql new file mode 100644 index 0000000..f6b78ba --- /dev/null +++ b/sqitch/pg/revert/fix_allocated_builds_attempt_2.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_allocated_builds_attempt_2 from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/fix_allocated_builds_attempt_2.sql b/sqitch/pg/verify/fix_allocated_builds_attempt_2.sql new file mode 100644 index 0000000..ac0cbf8 --- /dev/null +++ b/sqitch/pg/verify/fix_allocated_builds_attempt_2.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_allocated_builds_attempt_2 on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 85b7580..af81ea8 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -30,3 +30,4 @@ add_agent_names 2021-02-28T14:04:24Z Christopher Baines <mail@cbaines.net> # Add add_dynamic_auth_tokens 2021-02-28T15:21:24Z Christopher Baines <mail@cbaines.net> # Add dynamic_auth_tokens use_numeric_primary_keys 2021-03-28T09:55:40Z Christopher Baines <mail@cbaines.net> # Use numeric primary keys fix_allocated_builds 2021-03-30T08:19:18Z Christopher Baines <mail@cbaines.net> # Fix allocated_builds +fix_allocated_builds_attempt_2 2021-03-30T08:27:18Z Christopher Baines <mail@cbaines.net> # Fix allocated_builds diff --git a/sqitch/sqlite/deploy/fix_allocated_builds_attempt_2.sql b/sqitch/sqlite/deploy/fix_allocated_builds_attempt_2.sql new file mode 100644 index 0000000..b9b8e90 --- /dev/null +++ b/sqitch/sqlite/deploy/fix_allocated_builds_attempt_2.sql @@ -0,0 +1,12 @@ +-- Deploy guix-build-coordinator:fix_allocated_builds_attempt_2 to sqlite + +BEGIN; + +DROP TABLE allocated_builds; + +CREATE TABLE allocated_builds ( + build_id INTEGER PRIMARY KEY NOT NULL REFERENCES builds (id), + agent_id TEXT NOT NULL REFERENCES agents (id) +); + +COMMIT; diff --git a/sqitch/sqlite/revert/fix_allocated_builds_attempt_2.sql b/sqitch/sqlite/revert/fix_allocated_builds_attempt_2.sql new file mode 100644 index 0000000..71c0d63 --- /dev/null +++ b/sqitch/sqlite/revert/fix_allocated_builds_attempt_2.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_allocated_builds_attempt_2 from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/fix_allocated_builds_attempt_2.sql b/sqitch/sqlite/verify/fix_allocated_builds_attempt_2.sql new file mode 100644 index 0000000..016232a --- /dev/null +++ b/sqitch/sqlite/verify/fix_allocated_builds_attempt_2.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_allocated_builds_attempt_2 on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |