From 9a3dbb1d5b408fbac700d38c22690c2c4ec4a85c Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sat, 23 Nov 2019 11:30:36 +0000 Subject: Add new table to store token seeds for build servers --- sqitch/deploy/build_server_token_seeds.sql | 11 +++++++++++ sqitch/revert/build_server_token_seeds.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/verify/build_server_token_seeds.sql | 7 +++++++ 4 files changed, 26 insertions(+) create mode 100644 sqitch/deploy/build_server_token_seeds.sql create mode 100644 sqitch/revert/build_server_token_seeds.sql create mode 100644 sqitch/verify/build_server_token_seeds.sql 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 # Remove duplicates in the guix_revisions table package_derivations_by_guix_revision_range 2019-11-09T19:09:48Z Christopher Baines # Add package_derivations_by_guix_revision_range channel_news_tables 2019-11-15T07:32:07Z Christopher Baines # Add tables to store channel news +build_server_token_seeds 2019-11-23T09:26:48Z Christopher Baines # 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; -- cgit v1.2.3