From 163a95d3e95ddc05c20eadac096e9ba2923b4ad6 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Tue, 30 Mar 2021 09:27:54 +0100 Subject: Fix --- sqitch/pg/deploy/fix_allocated_builds_attempt_2.sql | 7 +++++++ sqitch/pg/revert/fix_allocated_builds_attempt_2.sql | 7 +++++++ sqitch/pg/verify/fix_allocated_builds_attempt_2.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/sqlite/deploy/fix_allocated_builds_attempt_2.sql | 12 ++++++++++++ sqitch/sqlite/revert/fix_allocated_builds_attempt_2.sql | 7 +++++++ sqitch/sqlite/verify/fix_allocated_builds_attempt_2.sql | 7 +++++++ 7 files changed, 48 insertions(+) create mode 100644 sqitch/pg/deploy/fix_allocated_builds_attempt_2.sql create mode 100644 sqitch/pg/revert/fix_allocated_builds_attempt_2.sql create mode 100644 sqitch/pg/verify/fix_allocated_builds_attempt_2.sql create mode 100644 sqitch/sqlite/deploy/fix_allocated_builds_attempt_2.sql create mode 100644 sqitch/sqlite/revert/fix_allocated_builds_attempt_2.sql create mode 100644 sqitch/sqlite/verify/fix_allocated_builds_attempt_2.sql (limited to 'sqitch') 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 # Add add_dynamic_auth_tokens 2021-02-28T15:21:24Z Christopher Baines # Add dynamic_auth_tokens use_numeric_primary_keys 2021-03-28T09:55:40Z Christopher Baines # Use numeric primary keys fix_allocated_builds 2021-03-30T08:19:18Z Christopher Baines # Fix allocated_builds +fix_allocated_builds_attempt_2 2021-03-30T08:27:18Z Christopher Baines # 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; -- cgit v1.2.3