summaryrefslogtreecommitdiff
path: root/boardvoting/migrations/20200414225500_add_roles_table.sql
diff options
context:
space:
mode:
Diffstat (limited to 'boardvoting/migrations/20200414225500_add_roles_table.sql')
-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