aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrations/6.0.51_step5383_new_data_field_types_for_mvv.php29
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);
+ }
+}