diff options
author | Christopher Baines <mail@cbaines.net> | 2021-03-30 09:27:54 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2021-03-30 09:27:54 +0100 |
commit | 163a95d3e95ddc05c20eadac096e9ba2923b4ad6 (patch) | |
tree | 38768573c7cdad3d028c458517d28c8a3c17c9e6 /sqitch/sqlite | |
parent | 8ebe604c62acb424f899c01724347bf0f115b73e (diff) | |
download | build-coordinator-163a95d3e95ddc05c20eadac096e9ba2923b4ad6.tar build-coordinator-163a95d3e95ddc05c20eadac096e9ba2923b4ad6.tar.gz |
Fix
Diffstat (limited to 'sqitch/sqlite')
3 files changed, 26 insertions, 0 deletions
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; |