remove forum abos and favorites upon user deletion and add a migration that cleans up the current state in the tables, fixes #2289

Closes #2289

Merge request studip/studip!1513

1 files changed, 20 insertions, 0 deletions

diff --git a/db/migrations/5.1.43_cleanup_forum_tables.php b/db/migrations/5.1.43_cleanup_forum_tables.php
new file mode 100644
index 0000000..6f07469
--- /dev/null
+++ b/db/migrations/5.1.43_cleanup_forum_tables.php
@@ -0,0 +1,20 @@
+<?php
+final class CleanupForumTables extends Migration
+{
+    protected function up()
+    {
+        $query = "DELETE FROM `forum_abo_users`
+                  WHERE `user_id` NOT IN (
+                      SELECT `user_id`
+                      FROM `auth_user_md5`
+                  )";
+        DBManager::get()->exec($query);
+
+        $query = "DELETE FROM `forum_favorites`
+                  WHERE `user_id` NOT IN (
+                      SELECT `user_id`
+                      FROM `auth_user_md5`
+                  )";
+        DBManager::get()->exec($query);
+    }
+}