aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2023-03-13 06:25:13 +0300
committerFrederick Muriuki Muriithi2023-03-13 06:25:13 +0300
commit3dee24dc1e05893b49ace052ab61899e49a03bb7 (patch)
treea53e02f1c89288ed9808ff058fe9b258d6c39c56 /migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
parent08ab26292b9ed2da9e91a683f38c6e1f532af4ee (diff)
downloadgenenetwork3-3dee24dc1e05893b49ace052ab61899e49a03bb7.tar.gz
Add 'ON UPDATE/DELETE' clauses to foreign keys.
Diffstat (limited to 'migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py')
-rw-r--r--migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py8
1 files changed, 6 insertions, 2 deletions
diff --git a/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py b/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
index 2deff10..a4d7806 100644
--- a/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
+++ b/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
@@ -23,8 +23,10 @@ steps = [
group_id TEXT NOT NULL,
role_id TEXT NOT NULL,
PRIMARY KEY(group_id, role_id),
- FOREIGN KEY(group_id) REFERENCES groups(group_id),
+ FOREIGN KEY(group_id) REFERENCES groups(group_id)
+ ON UPDATE CASCADE ON DELETE RESTRICT,
FOREIGN KEY(role_id) REFERENCES roles(role_id)
+ ON UPDATE CASCADE ON DELETE RESTRICT
) WITHOUT ROWID
"""),
step(
@@ -34,8 +36,10 @@ steps = [
group_id TEXT NOT NULL,
role_id TEXT NOT NULL,
UNIQUE (group_id, role_id),
- FOREIGN KEY(group_id) REFERENCES groups(group_id),
+ FOREIGN KEY(group_id) REFERENCES groups(group_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 group_roles"),