db/migrations/6.0.5_remove_old_evaluation.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
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);
    }
}