summaryrefslogtreecommitdiff
path: root/boardvoting
diff options
context:
space:
mode:
authorJan Dittberner <jandd@cacert.org>2020-04-14 23:23:23 +0200
committerJan Dittberner <jandd@cacert.org>2020-04-14 23:25:11 +0200
commit58898b29a7bd0c2f2e7417b2f713a0eda2cb36f4 (patch)
tree347c2c5aa30cd4ac0ff33f9d2abac1ed80f1f198 /boardvoting
parent6c9bf09f1a4bd12fc1f91419a3de9242a5c1cb2c (diff)
downloadcacert-boardvoting-58898b29a7bd0c2f2e7417b2f713a0eda2cb36f4.tar.gz
cacert-boardvoting-58898b29a7bd0c2f2e7417b2f713a0eda2cb36f4.tar.xz
cacert-boardvoting-58898b29a7bd0c2f2e7417b2f713a0eda2cb36f4.zip
Add new table user_roles
This commit adds a new database table user_roles to prepare for the introduction of a voter management system. All existing enabled voters are added to the VOTER role.
Diffstat (limited to 'boardvoting')
-rw-r--r--boardvoting/migrations/20200414225500_add_roles_table.sql34
1 files changed, 34 insertions, 0 deletions
diff --git a/boardvoting/migrations/20200414225500_add_roles_table.sql b/boardvoting/migrations/20200414225500_add_roles_table.sql
new file mode 100644
index 0000000..c36b66c
--- /dev/null
+++ b/boardvoting/migrations/20200414225500_add_roles_table.sql
@@ -0,0 +1,34 @@
+/*
+ Copyright 2020 Jan Dittberner
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this program except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+-- +migrate Up
+-- SQL in section 'Up' is executed when this migration is applied
+CREATE TABLE user_roles
+(
+ id INTEGER PRIMARY KEY AUTOINCREMENT,
+ voter_id VARCHAR(255) NOT NULL REFERENCES voters (id),
+ role VARCHAR(8) NOT NULL,
+ created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ UNIQUE (voter_id, role)
+);
+INSERT INTO user_roles (voter_id, role)
+SELECT id, 'VOTER'
+FROM voters
+WHERE enabled = true;
+
+-- +migrate Down
+-- SQL section 'Down' is executed when this migration is rolled back
+DROP TABLE user_roles; \ No newline at end of file