Diffstat (limited to 'boardvoting')
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
@@ -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
+ 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'
+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