Resolve "Forum3: Forumskonfigurationen von Veranstaltungskategorien entfernen"

Closes #5794

Merge request studip/studip!4415

1 files changed, 22 insertions, 0 deletions

diff --git a/db/migrations/6.1.16_remove_forum_configurations_from_sem_classes_table.php b/db/migrations/6.1.16_remove_forum_configurations_from_sem_classes_table.php
new file mode 100644
index 0000000..05fabd2
--- /dev/null
+++ b/db/migrations/6.1.16_remove_forum_configurations_from_sem_classes_table.php
@@ -0,0 +1,22 @@
+<?php
+
+final class RemoveForumConfigurationsFromSemClassesTable extends Migration
+{
+    public function up()
+    {
+        DBManager::get()->exec("
+            ALTER TABLE `sem_classes`
+                DROP COLUMN `write_access_nobody`,
+                DROP COLUMN `topic_create_autor`
+        ");
+    }
+
+    public function down()
+    {
+        DBManager::get()->exec("
+            ALTER TABLE `sem_classes`
+                ADD COLUMN `write_access_nobody` TINYINT(3) UNSIGNED NOT NULL AFTER `show_browse`,
+                ADD COLUMN `topic_create_autor` TINYINT(3) UNSIGNED NOT NULL AFTER `write_access_nobody`
+        ");
+    }
+}