diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrations/6.0.52_rename_dummy_teacher_to_dummy_lecturer.php | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/db/migrations/6.0.52_rename_dummy_teacher_to_dummy_lecturer.php b/db/migrations/6.0.52_rename_dummy_teacher_to_dummy_lecturer.php new file mode 100644 index 0000000..15b2b64 --- /dev/null +++ b/db/migrations/6.0.52_rename_dummy_teacher_to_dummy_lecturer.php @@ -0,0 +1,34 @@ +<?php +final class RenameDummyTeacherToDummyLecturer extends Migration +{ + public function description() + { + return 'Renames configuration DUMMY_TEACHER_ID to DUMMY_LECTURER_ID'; + } + + public function up() + { + $query = "UPDATE `config` + SET `field` = 'DUMMY_LECTURER_ID' + WHERE `field` = 'DUMMY_TEACHER_ID'"; + DBManager::get()->exec($query); + + $query = "UPDATE `config_values` + SET `field` = 'DUMMY_LECTURER_ID' + WHERE `field` = 'DUMMY_TEACHER_ID'"; + DBManager::get()->exec($query); + } + + protected function down() + { + $query = "UPDATE `config_values` + SET `field` = 'DUMMY_TEACHER_ID' + WHERE `field` = 'DUMMY_LECTURER_ID'"; + DBManager::get()->exec($query); + + $query = "UPDATE `config` + SET `field` = 'DUMMY_TEACHER_ID' + WHERE `field` = 'DUMMY_LECTURER_ID'"; + DBManager::get()->exec($query); + } +} |
