aboutsummaryrefslogtreecommitdiff
path: root/sqitch
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2019-11-23 11:30:36 +0000
committerChristopher Baines <mail@cbaines.net>2019-11-23 11:30:36 +0000
commit9a3dbb1d5b408fbac700d38c22690c2c4ec4a85c (patch)
treec5f10a9642f521fe8c9ac349ee956c5a82b240ea /sqitch
parent6fad559b3256dd528dc01061043290455a0b6141 (diff)
downloaddata-service-9a3dbb1d5b408fbac700d38c22690c2c4ec4a85c.tar
data-service-9a3dbb1d5b408fbac700d38c22690c2c4ec4a85c.tar.gz
Add new table to store token seeds for build servers
Diffstat (limited to 'sqitch')
-rw-r--r--sqitch/deploy/build_server_token_seeds.sql11
-rw-r--r--sqitch/revert/build_server_token_seeds.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/verify/build_server_token_seeds.sql7
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;