1 files changed, 3 insertions, 1 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
index d9532dc..e0de751 100644
--- a/migrations/auth/20221114_05_hQun6-create-user-roles-table.py
+++ b/migrations/auth/20221114_05_hQun6-create-user-roles-table.py
@@ -13,8 +13,10 @@ steps = [
             user_id TEXT NOT NULL,
             role_id TEXT NOT NULL,
             PRIMARY KEY(user_id, role_id),
-            FOREIGN KEY(user_id) REFERENCES users(user_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"),