Resolve #3893 "Performance des persönlichen Kalenders / Gruppenkalender ist schlecht"

Closes #3893

Merge request studip/studip!2746

1 files changed, 25 insertions, 0 deletions

diff --git a/db/migrations/5.5.28_biest3893_performance_calendar.php b/db/migrations/5.5.28_biest3893_performance_calendar.php
new file mode 100644
index 0000000..82a86fe
--- /dev/null
+++ b/db/migrations/5.5.28_biest3893_performance_calendar.php
@@ -0,0 +1,25 @@
+<?php
+
+final class Biest3893PerformanceCalendar extends Migration
+{
+    public function description()
+    {
+        return 'add index to calendar tables';
+    }
+
+    public function up()
+    {
+        $db = DBManager::get();
+        $db->exec("DELETE FROM `calendar_date_exceptions` WHERE `date` = '1970-01-01'");
+        $db->exec("ALTER TABLE `calendar_date_exceptions` ADD INDEX(`calendar_date_id`)");
+        $db->exec("ALTER TABLE `calendar_dates` ADD INDEX `repetition_type` (`repetition_type`, `repetition_end`)");
+        $db->exec("ALTER TABLE `calendar_dates` ADD INDEX `begin` (`begin`)");
+        try {
+            $db->exec("ALTER TABLE `calendar_dates` DROP INDEX `uid`");
+        } catch (PDOException $exception) {}
+    }
+
+    public function down()
+    {
+    }
+}