aboutsummaryrefslogtreecommitdiff
path: root/sqitch/deploy/build_server_token_seeds.sql
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/deploy/build_server_token_seeds.sql
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/deploy/build_server_token_seeds.sql')
-rw-r--r--sqitch/deploy/build_server_token_seeds.sql11
1 files changed, 11 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;