aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20221219_01_CI3tN-create-oauth2-clients-table.py
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/auth/20221219_01_CI3tN-create-oauth2-clients-table.py')
-rw-r--r--migrations/auth/20221219_01_CI3tN-create-oauth2-clients-table.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/migrations/auth/20221219_01_CI3tN-create-oauth2-clients-table.py b/migrations/auth/20221219_01_CI3tN-create-oauth2-clients-table.py
index 8ab7be4..475be01 100644
--- a/migrations/auth/20221219_01_CI3tN-create-oauth2-clients-table.py
+++ b/migrations/auth/20221219_01_CI3tN-create-oauth2-clients-table.py
@@ -18,6 +18,7 @@ steps = [
user_id TEXT NOT NULL,
PRIMARY KEY(client_id),
FOREIGN KEY(user_id) REFERENCES users(user_id)
+ ON UPDATE CASCADE ON DELETE RESTRICT
) WITHOUT ROWID
""",
"DROP TABLE IF EXISTS oauth2_clients")