diff options
Diffstat (limited to 'sqitch')
-rw-r--r-- | sqitch/pg/deploy/build_starts.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/build_starts.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/build_starts.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/build_starts.sql | 12 | ||||
-rw-r--r-- | sqitch/sqlite/revert/build_starts.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/build_starts.sql | 7 |
7 files changed, 48 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_starts.sql b/sqitch/pg/deploy/build_starts.sql new file mode 100644 index 0000000..77c0f85 --- /dev/null +++ b/sqitch/pg/deploy/build_starts.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_starts to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_starts.sql b/sqitch/pg/revert/build_starts.sql new file mode 100644 index 0000000..d71c169 --- /dev/null +++ b/sqitch/pg/revert/build_starts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_starts.sql b/sqitch/pg/verify/build_starts.sql new file mode 100644 index 0000000..248f602 --- /dev/null +++ b/sqitch/pg/verify/build_starts.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 5623d5b..e0712ce 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -17,3 +17,4 @@ build_results_result_index 2020-05-10T17:27:00Z Christopher Baines <mail@cbaines more_indexes_on_builds_and_derivation_inputs 2020-05-11T08:38:28Z Christopher Baines <mail@cbaines.net> # Add a couple more indexes build_tags 2020-05-31T13:54:41Z Christopher Baines <mail@cbaines.net> # Support tagging builds builds_created_at 2020-06-27T18:30:32Z Christopher Baines <mail@cbaines.net> # Add builds.created_at +build_starts 2020-06-27T20:23:38Z Christopher Baines <mail@cbaines.net> # Add build_starts table diff --git a/sqitch/sqlite/deploy/build_starts.sql b/sqitch/sqlite/deploy/build_starts.sql new file mode 100644 index 0000000..fbf8e8c --- /dev/null +++ b/sqitch/sqlite/deploy/build_starts.sql @@ -0,0 +1,12 @@ +-- Deploy guix-build-coordinator:build_starts to sqlite + +BEGIN; + +CREATE TABLE build_starts ( + id INTEGER PRIMARY KEY ASC, + build_id TEXT NOT NULL REFERENCES builds (uuid), + agent_id TEXT NOT NULL REFERENCES agents (id), + start_time TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_starts.sql b/sqitch/sqlite/revert/build_starts.sql new file mode 100644 index 0000000..49d8eea --- /dev/null +++ b/sqitch/sqlite/revert/build_starts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_starts.sql b/sqitch/sqlite/verify/build_starts.sql new file mode 100644 index 0000000..e4d9460 --- /dev/null +++ b/sqitch/sqlite/verify/build_starts.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |