remove old evaluation, fixes #3787

Closes #3787

Merge request studip/studip!2661

1 files changed, 33 insertions, 0 deletions

diff --git a/db/migrations/6.0.5_remove_old_evaluation.php b/db/migrations/6.0.5_remove_old_evaluation.php
new file mode 100644
index 0000000..ff1a26e
--- /dev/null
+++ b/db/migrations/6.0.5_remove_old_evaluation.php
@@ -0,0 +1,33 @@
+<?php
+
+final class RemoveOldEvaluation extends Migration
+{
+    public function description()
+    {
+        return 'removes old evaluation tables';
+    }
+
+    public function up()
+    {
+        DBManager::get()->exec('DROP TABLE `eval`');
+        DBManager::get()->exec('DROP TABLE `eval_group_template`');
+        DBManager::get()->exec('DROP TABLE `eval_range`');
+        DBManager::get()->exec('DROP TABLE `eval_templates`');
+        DBManager::get()->exec('DROP TABLE `eval_templates_eval`');
+        DBManager::get()->exec('DROP TABLE `eval_templates_user`');
+        DBManager::get()->exec('DROP TABLE `eval_user`');
+        DBManager::get()->exec('DROP TABLE `evalanswer`');
+        DBManager::get()->exec('DROP TABLE `evalanswer_user`');
+        DBManager::get()->exec('DROP TABLE `evalgroup`');
+        DBManager::get()->exec('DROP TABLE `evalquestion`');
+
+        $query = "DELETE `config`, `config_values`
+                  FROM `config`
+                  LEFT JOIN `config_values` USING (`field`)
+                  WHERE field IN (
+                    'EVAL_AUSWERTUNG_GRAPH_FORMAT',
+                    'EVAL_ENABLE', 'EVAL_AUSWERTUNG_CONFIG_ENABLE'
+                  )";
+        DBManager::get()->exec($query);
+    }
+}