aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
diff options
context:
space:
mode:
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.py1
1 files changed, 1 insertions, 0 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 7115bc3..2deff10 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
@@ -33,6 +33,7 @@ steps = [
group_role_id TEXT PRIMARY KEY,
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(role_id) REFERENCES roles(role_id)
) WITHOUT ROWID