StEP #2472

Merge request studip/studip!2296

1 files changed, 27 insertions, 0 deletions

diff --git a/db/migrations/5.5.22_add_feedback_anonymous_entries.php b/db/migrations/5.5.22_add_feedback_anonymous_entries.php
new file mode 100644
index 0000000..2e557b5
--- /dev/null
+++ b/db/migrations/5.5.22_add_feedback_anonymous_entries.php
@@ -0,0 +1,27 @@
+<?php
+final class AddFeedbackAnonymousEntries extends Migration
+{
+    public function description()
+    {
+        return 'Extend feedback tables for anonymous entries';
+    }
+
+    public function up()
+    {
+        \DBManager::get()->exec("ALTER TABLE `feedback` 
+            ADD `anonymous_entries` TINYINT(1) NOT NULL DEFAULT 0 
+            AFTER `commentable`
+        ");
+
+        \DBManager::get()->exec("ALTER TABLE `feedback_entries` 
+            ADD `anonymous` TINYINT(1) NOT NULL DEFAULT 0
+            AFTER `rating`
+        ");
+    }
+
+    public function down()
+    {
+        \DBManager::get()->exec("ALTER TABLE `feedback` DROP `anonymous_entries`");
+        \DBManager::get()->exec("ALTER TABLE `feedback_entries` DROP `anonymous`");
+    }
+}