Resolve "Autor darf keine neue Diskussion starten"

Closes #5724

Merge request studip/studip!4355

1 files changed, 24 insertions, 0 deletions

diff --git a/db/migrations/6.1.15_add_user_id_to_forum_discussions.php b/db/migrations/6.1.15_add_user_id_to_forum_discussions.php
new file mode 100644
index 0000000..97df7ce
--- /dev/null
+++ b/db/migrations/6.1.15_add_user_id_to_forum_discussions.php
@@ -0,0 +1,24 @@
+<?php
+
+final class AddUserIdToForumDiscussions extends Migration
+{
+    public function up()
+    {
+        DBManager::get()->exec("ALTER TABLE forum_discussions Add COLUMN user_id CHAR(32) COLLATE latin1_bin NOT NULL AFTER topic_id");
+        DBManager::get()->exec("
+            UPDATE forum_discussions AS discussions
+            SET user_id = (
+                SELECT postings.user_id
+                FROM forum_postings AS postings
+                WHERE postings.discussion_id = discussions.discussion_id
+                ORDER BY mkdate ASC
+                LIMIT 1
+            );
+        ");
+    }
+
+    public function down()
+    {
+        DBManager::get()->exec("ALTER TABLE forum_discussions DROP COLUMN user_id");
+    }
+}