diff options
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/deploy/build_server_token_seeds.sql | 11 | ||||
| -rw-r--r-- | sqitch/revert/build_server_token_seeds.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/verify/build_server_token_seeds.sql | 7 |
4 files changed, 26 insertions, 0 deletions
diff --git a/sqitch/deploy/build_server_token_seeds.sql b/sqitch/deploy/build_server_token_seeds.sql new file mode 100644 index 0000000..3333b10 --- /dev/null +++ b/sqitch/deploy/build_server_token_seeds.sql @@ -0,0 +1,11 @@ +-- Deploy guix-data-service:build_server_token_seeds to pg + +BEGIN; + +CREATE TABLE build_server_token_seeds ( + build_server_id integer REFERENCES build_servers(id), + token_seed varchar NOT NULL, + PRIMARY KEY (build_server_id, token_seed) +); + +COMMIT; diff --git a/sqitch/revert/build_server_token_seeds.sql b/sqitch/revert/build_server_token_seeds.sql new file mode 100644 index 0000000..8c0fa0e --- /dev/null +++ b/sqitch/revert/build_server_token_seeds.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:build_server_token_seeds from pg + +BEGIN; + +DROP TABLE build_server_token_seeds; + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 027d337..d3d9c7a 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -27,3 +27,4 @@ add_retry_value_to_job_event_enum 2019-10-02T19:13:52Z Christopher Baines <mail@ remove_guix_revision_duplicates 2019-10-05T08:00:14Z Christopher Baines <mail@cbaines.net> # Remove duplicates in the guix_revisions table package_derivations_by_guix_revision_range 2019-11-09T19:09:48Z Christopher Baines <mail@cbaines.net> # Add package_derivations_by_guix_revision_range channel_news_tables 2019-11-15T07:32:07Z Christopher Baines <mail@cbaines.net> # Add tables to store channel news +build_server_token_seeds 2019-11-23T09:26:48Z Christopher Baines <mail@cbaines.net> # Add build_server_token_seeds table diff --git a/sqitch/verify/build_server_token_seeds.sql b/sqitch/verify/build_server_token_seeds.sql new file mode 100644 index 0000000..96ea6c1 --- /dev/null +++ b/sqitch/verify/build_server_token_seeds.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:build_server_token_seeds on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |