Delete all emails and permissions when deleting a user

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/database.sql b/src/database.sql
index 294925a6849628b4a31951823d0cc1bc0a8ac1a9..8ebe9260eb2092cd1e43dd6d007d5f2af7d3b790 100644 (file)
--- a/src/database.sql
+++ b/src/database.sql
@@ -3294,7 +3294,7 @@ ALTER TABLE ONLY uploads
 --
 
 ALTER TABLE ONLY users_emails
-    ADD CONSTRAINT users_emails_user_id FOREIGN KEY (user_id) REFERENCES users(id);
+    ADD CONSTRAINT users_emails_user_id FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;
 
 
 --
@@ -3302,7 +3302,7 @@ ALTER TABLE ONLY users_emails
 --
 
 ALTER TABLE ONLY users_permissions
-    ADD CONSTRAINT users_permissions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
+    ADD CONSTRAINT users_permissions_user_id FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;
 
 
 --