Resolve "Timeout bei großen Blubber Threads"

Closes #5313

Merge request studip/studip!4001

1 files changed, 20 insertions, 0 deletions

diff --git a/db/migrations/5.3.29_add_index_blubber_comments_mkdate.php b/db/migrations/5.3.29_add_index_blubber_comments_mkdate.php
new file mode 100644
index 0000000..1d7ed7a
--- /dev/null
+++ b/db/migrations/5.3.29_add_index_blubber_comments_mkdate.php
@@ -0,0 +1,20 @@
+<?php
+
+class AddIndexBlubberCommentsMkdate extends Migration
+{
+
+    public function description()
+    {
+        return 'Adds index for mkdate to blubber_comments';
+    }
+
+    public function up()
+    {
+        DBManager::get()->exec("ALTER TABLE `blubber_comments` ADD INDEX mkdate (`mkdate`)");
+    }
+
+    public function down()
+    {
+        DBManager::get()->exec("ALTER TABLE `blubber_comments` DROP INDEX (`mkdate`)");
+    }
+}