Resolve "ILIAS-Arbeitsbereiche über Stud.IP verwalten und anzeigen"

Closes #4269

Merge request studip/studip!4214

1 files changed, 33 insertions, 0 deletions

diff --git a/db/migrations/6.1.3_step_4269.php b/db/migrations/6.1.3_step_4269.php
new file mode 100644
index 0000000..0b2f65d
--- /dev/null
+++ b/db/migrations/6.1.3_step_4269.php
@@ -0,0 +1,33 @@
+<?php
+class Step4269 extends Migration
+{
+    public function description()
+    {
+        return "Adds ilias workgroup member request table.";
+    }
+
+    public function up()
+    {
+        $db = \DBManager::get();
+
+        $db->exec(
+            "CREATE TABLE `ilias_workgroup_request`(
+                 `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+                 `workgroup_id` INT(11) NOT NULL,
+                 `ilias_index` VARCHAR(32) NOT NULL,
+                 `user_id` CHAR(32) COLLATE latin1_bin NOT NULL,
+                 `valid_until` INT(11) UNSIGNED NOT NULL,
+                 `mkdate` INT(11) UNSIGNED NOT NULL,
+                 `chdate` INT(11) UNSIGNED NOT NULL,
+                 PRIMARY KEY(`id`),
+                 UNIQUE KEY `workgroup_user` (`ilias_index`,`user_id`,`workgroup_id`)
+             )"
+        );
+    }
+
+    public function down()
+    {
+        $db = \DBManager::get();
+        $db->exec('DROP TABLE IF EXISTS `ilias_workgroup_request`');
+    }
+}
\ No newline at end of file