aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-11-17 13:35:29 +0300
committerFrederick Muriuki Muriithi2022-11-17 13:35:29 +0300
commitfb885e810f568a69e6703939062e532acf649a38 (patch)
tree9517a90b8072a85d0b61e2c33df7ebf361ec930d /migrations/auth
parent1bcc1033174127f165776f1b9c99ec75f1b49b4b (diff)
downloadgenenetwork3-fb885e810f568a69e6703939062e532acf649a38.tar.gz
Migrations: Create `group_users` table
* migrations/auth/20221117_02_fmuZh-create-group-users-table.py: new migration * tests/unit/auth/test_migrations_create_tables.py: test new migration * tests/unit/auth/test_migrations_indexes.py: test new migration
Diffstat (limited to 'migrations/auth')
-rw-r--r--migrations/auth/20221117_02_fmuZh-create-group-users-table.py25
1 files changed, 25 insertions, 0 deletions
diff --git a/migrations/auth/20221117_02_fmuZh-create-group-users-table.py b/migrations/auth/20221117_02_fmuZh-create-group-users-table.py
new file mode 100644
index 0000000..92885ef
--- /dev/null
+++ b/migrations/auth/20221117_02_fmuZh-create-group-users-table.py
@@ -0,0 +1,25 @@
+"""
+Create 'group_users' table.
+"""
+
+from yoyo import step
+
+__depends__ = {'20221117_01_RDlfx-modify-group-roles-add-group-role-id'}
+
+steps = [
+ step(
+ """
+ CREATE TABLE IF NOT EXISTS group_users(
+ group_id TEXT NOT NULL,
+ user_id TEXT NOT NULL UNIQUE, -- user can only be in one group
+ PRIMARY KEY(group_id, user_id)
+ ) WITHOUT ROWID
+ """,
+ "DROP TABLE IF EXISTS group_users"),
+ step(
+ """
+ CREATE INDEX IF NOT EXISTS tbl_group_users_cols_group_id
+ ON group_users(group_id)
+ """,
+ "DROP INDEX IF EXISTS tbl_group_users_cols_group_id")
+]