about summary refs log tree commit diff
path: root/migrations/auth/20221114_05_hQun6-create-user-roles-table.py
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/auth/20221114_05_hQun6-create-user-roles-table.py')
-rw-r--r--migrations/auth/20221114_05_hQun6-create-user-roles-table.py29
1 files changed, 0 insertions, 29 deletions
diff --git a/migrations/auth/20221114_05_hQun6-create-user-roles-table.py b/migrations/auth/20221114_05_hQun6-create-user-roles-table.py
deleted file mode 100644
index e0de751..0000000
--- a/migrations/auth/20221114_05_hQun6-create-user-roles-table.py
+++ /dev/null
@@ -1,29 +0,0 @@
-"""
-Create 'user_roles' table.
-"""
-
-from yoyo import step
-
-__depends__ = {'20221114_04_tLUzB-initialise-basic-roles'}
-
-steps = [
-    step(
-        """
-        CREATE TABLE IF NOT EXISTS user_roles(
-            user_id TEXT NOT NULL,
-            role_id TEXT NOT NULL,
-            PRIMARY KEY(user_id, role_id),
-            FOREIGN KEY(user_id) REFERENCES users(user_id)
-              ON UPDATE CASCADE ON DELETE RESTRICT,
-            FOREIGN KEY(role_id) REFERENCES roles(role_id)
-              ON UPDATE CASCADE ON DELETE RESTRICT
-        ) WITHOUT ROWID
-        """,
-        "DROP TABLE IF EXISTS user_roles"),
-    step(
-        """
-        CREATE INDEX IF NOT EXISTS idx_tbl_user_roles_cols_user_id
-        ON user_roles(user_id)
-        """,
-        "DROP INDEX IF EXISTS idx_tbl_user_roles_cols_user_id")
-]