1 files changed, 1 insertions, 0 deletions
diff --git a/migrations/auth/20221103_02_sGrIs-create-user-credentials-table.py b/migrations/auth/20221103_02_sGrIs-create-user-credentials-table.py
index 3f72f3e..48bd663 100644
--- a/migrations/auth/20221103_02_sGrIs-create-user-credentials-table.py
+++ b/migrations/auth/20221103_02_sGrIs-create-user-credentials-table.py
@@ -13,6 +13,7 @@ steps = [
             user_id TEXT PRIMARY KEY,
             password TEXT NOT NULL,
             FOREIGN KEY(user_id) REFERENCES users(user_id)
+              ON UPDATE CASCADE ON DELETE RESTRICT
         ) WITHOUT ROWID
         """,
         "DROP TABLE IF EXISTS user_credentials")