diff options
Diffstat (limited to 'sqitch')
-rw-r--r-- | sqitch/pg/deploy/output_metadata.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/output_metadata.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/output_metadata.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/output_metadata.sql | 13 | ||||
-rw-r--r-- | sqitch/sqlite/revert/output_metadata.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/output_metadata.sql | 7 |
7 files changed, 49 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/output_metadata.sql b/sqitch/pg/deploy/output_metadata.sql new file mode 100644 index 0000000..f730ca6 --- /dev/null +++ b/sqitch/pg/deploy/output_metadata.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:output_metadata to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/output_metadata.sql b/sqitch/pg/revert/output_metadata.sql new file mode 100644 index 0000000..dcff1c5 --- /dev/null +++ b/sqitch/pg/revert/output_metadata.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:output_metadata from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/output_metadata.sql b/sqitch/pg/verify/output_metadata.sql new file mode 100644 index 0000000..f6abae8 --- /dev/null +++ b/sqitch/pg/verify/output_metadata.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:output_metadata on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 487fdf4..1e4414f 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -8,3 +8,4 @@ initial_agent_tables 2020-04-09T20:03:53Z Christopher Baines <mail@cbaines.net> build_allocation_tables 2020-04-10T19:26:36Z Christopher Baines <mail@cbaines.net> # Create initial tables for allocating builds build_results 2020-04-12T19:59:27Z Christopher Baines <mail@cbaines.net> # Create table for storing build results setup_failures 2020-04-13T13:05:29Z Christopher Baines <mail@cbaines.net> # Create table for storing setup_failures +output_metadata 2020-04-23T14:26:15Z Christopher Baines <mail@cbaines.net> # Create table for storing output metadata diff --git a/sqitch/sqlite/deploy/output_metadata.sql b/sqitch/sqlite/deploy/output_metadata.sql new file mode 100644 index 0000000..a7c0124 --- /dev/null +++ b/sqitch/sqlite/deploy/output_metadata.sql @@ -0,0 +1,13 @@ +-- Deploy guix-build-coordinator:output_metadata to sqlite + +BEGIN; + +CREATE TABLE output_metadata ( + build_id TEXT NOT NULL REFERENCES builds (uuid), + derivation_output_id INTEGER NOT NULL REFERENCES derivation_outputs (id), + hash TEXT NOT NULL, + size INTEGER NOT NULL, + store_references TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/output_metadata.sql b/sqitch/sqlite/revert/output_metadata.sql new file mode 100644 index 0000000..bee5fd1 --- /dev/null +++ b/sqitch/sqlite/revert/output_metadata.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:output_metadata from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/output_metadata.sql b/sqitch/sqlite/verify/output_metadata.sql new file mode 100644 index 0000000..e1669ec --- /dev/null +++ b/sqitch/sqlite/verify/output_metadata.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:output_metadata on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |