StEP 1596, closes #1596

Closes #1596

Merge request studip/studip!1038

1 files changed, 33 insertions, 0 deletions

diff --git a/db/migrations/5.3.15_add_accessibility_receiver_email_config.php b/db/migrations/5.3.15_add_accessibility_receiver_email_config.php
new file mode 100644
index 0000000..d3d73c2
--- /dev/null
+++ b/db/migrations/5.3.15_add_accessibility_receiver_email_config.php
@@ -0,0 +1,33 @@
+<?php
+
+class AddAccessibilityReceiverEmailConfig extends Migration
+{
+    public function description()
+    {
+        return 'Adds the configuration ACCESSIBILITY_RECEIVER_EMAIL, if it doesn\'t exist yet.';
+    }
+
+    protected function up()
+    {
+        $db = DBManager::get();
+
+        $db->exec(
+            "INSERT IGNORE INTO `config`
+             (`field`, `type`, `range`, `value`, `section`, `description`, `mkdate`, `chdate`)
+             VALUES
+             (
+                 'ACCESSIBILITY_RECEIVER_EMAIL', 'array', 'global', '', 'accessibility',
+                 'Die E-Mail-Adressen der Personen, die beim Melden einer Barriere benachrichtigt werden sollen.',
+                 UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
+             )"
+        );
+    }
+
+    protected function down()
+    {
+        $db = DBManager::get();
+
+        $db->exec("DELETE FROM `config_values` WHERE `field` = 'ACCESSIBILITY_RECEIVER_EMAIL'");
+        $db->exec("DELETE FROM `config` WHERE `field` = 'ACCESSIBILITY_RECEIVER_EMAIL'");
+    }
+}