diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrations/6.0.51_step5383_new_data_field_types_for_mvv.php | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/db/migrations/6.0.51_step5383_new_data_field_types_for_mvv.php b/db/migrations/6.0.51_step5383_new_data_field_types_for_mvv.php new file mode 100644 index 0000000..537b71c --- /dev/null +++ b/db/migrations/6.0.51_step5383_new_data_field_types_for_mvv.php @@ -0,0 +1,29 @@ +<?php +final class Step5383NewDataFieldTypesForMvv extends Migration +{ + public function description() + { + return 'Adds new data field types related to StgteilAbschnitModul and ModulteilStgteilAbschnitt objects'; + } + + public function up() + { + $query = "ALTER TABLE `datafields` + CHANGE `object_type` `object_type` ENUM('sem','inst','user', + 'userinstrole','usersemdata','roleinstdata','moduldeskriptor', + 'modulteildeskriptor','studycourse', + 'stgteilabschnittmodul','modulteilstgteilabschnitt') + NULL DEFAULT NULL"; + DBManager::get()->exec($query); + } + + public function down() + { + $query = "ALTER TABLE `datafields` + CHANGE `object_type` `object_type` ENUM('sem','inst','user', + 'userinstrole','usersemdata','roleinstdata','moduldeskriptor', + 'modulteildeskriptor','studycourse') + NULL DEFAULT NULL"; + DBManager::get()->exec($query); + } +} |
