diff options
| author | Christopher Baines <mail@cbaines.net> | 2019-11-23 11:30:36 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2019-11-23 11:30:36 +0000 |
| commit | 9a3dbb1d5b408fbac700d38c22690c2c4ec4a85c (patch) | |
| tree | c5f10a9642f521fe8c9ac349ee956c5a82b240ea | |
| parent | 6fad559b3256dd528dc01061043290455a0b6141 (diff) | |
| download | data-service-9a3dbb1d5b408fbac700d38c22690c2c4ec4a85c.tar data-service-9a3dbb1d5b408fbac700d38c22690c2c4ec4a85c.tar.gz | |
Add new table to store token seeds for build servers
| -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; |