diff options
Diffstat (limited to 'sqitch')
7 files changed, 45 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/add_fixed_output_to_derivations.sql b/sqitch/pg/deploy/add_fixed_output_to_derivations.sql new file mode 100644 index 0000000..b2c6755 --- /dev/null +++ b/sqitch/pg/deploy/add_fixed_output_to_derivations.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:add_fixed_output_to_derivations to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/add_fixed_output_to_derivations.sql b/sqitch/pg/revert/add_fixed_output_to_derivations.sql new file mode 100644 index 0000000..7402822 --- /dev/null +++ b/sqitch/pg/revert/add_fixed_output_to_derivations.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:add_fixed_output_to_derivations from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/add_fixed_output_to_derivations.sql b/sqitch/pg/verify/add_fixed_output_to_derivations.sql new file mode 100644 index 0000000..f6a1eca --- /dev/null +++ b/sqitch/pg/verify/add_fixed_output_to_derivations.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:add_fixed_output_to_derivations on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index a793617..7df0842 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -20,3 +20,4 @@ builds_created_at 2020-06-27T18:30:32Z Christopher Baines <mail@cbaines.net> # A build_starts 2020-06-27T20:23:38Z Christopher Baines <mail@cbaines.net> # Add build_starts table add_builds_end_time 2020-06-27T20:58:01Z Christopher Baines <mail@cbaines.net> # Add builds.end_time field build_allocation_agent_requested_systems 2020-07-02T19:45:02Z Christopher Baines <mail@cbaines.net> # Add new build_allocation_agent_requested_systems table +add_fixed_output_to_derivations 2020-07-18T14:49:51Z Christopher Baines <mail@cbaines.net> # Add derivations.fixed_output diff --git a/sqitch/sqlite/deploy/add_fixed_output_to_derivations.sql b/sqitch/sqlite/deploy/add_fixed_output_to_derivations.sql new file mode 100644 index 0000000..992ee06 --- /dev/null +++ b/sqitch/sqlite/deploy/add_fixed_output_to_derivations.sql @@ -0,0 +1,9 @@ +-- Deploy guix-build-coordinator:add_fixed_output_to_derivations to sqlite + +BEGIN; + +ALTER TABLE derivations + ADD COLUMN fixed_output BOOLEAN + CHECK (fixed_output IN (0,1)); + +COMMIT; diff --git a/sqitch/sqlite/revert/add_fixed_output_to_derivations.sql b/sqitch/sqlite/revert/add_fixed_output_to_derivations.sql new file mode 100644 index 0000000..4d92fb7 --- /dev/null +++ b/sqitch/sqlite/revert/add_fixed_output_to_derivations.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:add_fixed_output_to_derivations from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/add_fixed_output_to_derivations.sql b/sqitch/sqlite/verify/add_fixed_output_to_derivations.sql new file mode 100644 index 0000000..b4aacf1 --- /dev/null +++ b/sqitch/sqlite/verify/add_fixed_output_to_derivations.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:add_fixed_output_to_derivations on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |