Website Summary Files Commits Branches @commit @diff @stats
path: root / migrations / 00-initial.sql
diff options
context:
space:
mode:
Commit0e4f90e6a82f0fc275d65bf0e4f4c2842052dde9 (patch)
Author
 Syndamia <kamen@syndamia.com>
2025-02-02 13:43:26 +0200
Committer
 Syndamia <kamen@syndamia.com>
2025-02-02 13:43:26 +0200
Files892ccf952d364f03734ed95950845037fef26179 /migrations/00-initial.sql
nowayforward_human-0e4f90e6a82f0fc275d65bf0e4f4c2842052dde9.tar
nowayforward_human-0e4f90e6a82f0fc275d65bf0e4f4c2842052dde9.tar.gz
nowayforward_human-0e4f90e6a82f0fc275d65bf0e4f4c2842052dde9.zip
Parent168abc2c8512343f2a65461c6791ae852ae64665 (diff)
feat(views/user): Implement account deletion
1 files changed, 1 insertions, 1 deletions
-rw-r--r--migrations/00-initial.sql2
diff --git a/migrations/00-initial.sql b/migrations/00-initial.sql
index 879b5f1..a4b999f 100644
--- a/migrations/00-initial.sql
+++ b/migrations/00-initial.sql
@@ -15,7 +15,7 @@ CREATE TABLE IF NOT EXISTS Cookies (
Token CHAR(36) NOT NULL,
Expires DATETIME,
PRIMARY KEY (UID, Token),
- FOREIGN KEY (UID) REFERENCES Users(UID)
+ FOREIGN KEY (UID) REFERENCES Users(UID) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS Webpages (