Resolve "Erweiterung und Optimierung der von der ILIAS-Schnittstelle angelegten Strukturkategorien"

Closes #4270

Merge request studip/studip!4215

1 files changed, 43 insertions, 0 deletions

diff --git a/db/migrations/6.1.7_step_4270.php b/db/migrations/6.1.7_step_4270.php
new file mode 100644
index 0000000..7178d5b
--- /dev/null
+++ b/db/migrations/6.1.7_step_4270.php
@@ -0,0 +1,43 @@
+<?php
+
+/**
+ * Adds namespace values to UserFilter database entries that already existed pre-6.0.
+ */
+final class Step4270 extends Migration
+{
+
+    public function description()
+    {
+        return 'Add additional field to table object_contentmodules';
+    }
+
+    public function up()
+    {
+        DBManager::get()->execute(
+            "ALTER TABLE `object_contentmodules` 
+             ADD `object_type` VARCHAR(32) NOT NULL DEFAULT '' AFTER `module_type`, 
+             ADD `object_parent_id` VARCHAR(32) NOT NULL DEFAULT '' AFTER `object_type`, 
+             ADD `object_parent_type` VARCHAR(32) NOT NULL DEFAULT '' AFTER `object_parent_id`"
+        );
+        DBManager::get()->execute(
+            "ALTER TABLE `object_contentmodules`
+             DROP PRIMARY KEY, 
+             ADD PRIMARY KEY (`object_id`, `module_id`, `system_type`, `object_parent_id`)"
+        );
+    }
+
+    public function down()
+    {
+        DBManager::get()->execute(
+            "ALTER TABLE `object_contentmodules`
+             DROP PRIMARY KEY, 
+             ADD PRIMARY KEY (`object_id`, `module_id`, `system_type`)"
+        );
+        DBManager::get()->execute(
+            "ALTER TABLE `object_contentmodules`
+             DROP `object_type`,
+             DROP `object_parent_id`,
+             DROP `object_parent_type`;"
+        );
+    }
+}