Resolve "Feststehende Bennenung "OER Campus""

Closes #1420

Merge request studip/studip!884

1 files changed, 46 insertions, 0 deletions

diff --git a/db/migrations/5.3.2_remove_oer_title.php b/db/migrations/5.3.2_remove_oer_title.php
new file mode 100644
index 0000000..2df3e96
--- /dev/null
+++ b/db/migrations/5.3.2_remove_oer_title.php
@@ -0,0 +1,46 @@
+<?php
+
+
+class RemoveOerTitle extends Migration
+{
+    public function description()
+    {
+        return 'Removes the option OER_TITLE from the config';
+    }
+
+
+    public function up()
+    {
+        DBManager::get()->exec(
+            "DELETE FROM `config_values`
+            WHERE `field` = 'OER_TITLE'"
+        );
+        DBManager::get()->exec(
+            "DELETE FROM `config`
+            WHERE `field` = 'OER_TITLE'"
+        );
+    }
+
+
+    public function down()
+    {
+        $query = "INSERT INTO `config`
+                  SET `field` = :field,
+                      `value` = :value,
+                      `type` = :type,
+                      `range` = :range,
+                      `section` = :section,
+                      `mkdate` = UNIX_TIMESTAMP(),
+                      `chdate` = UNIX_TIMESTAMP(),
+                      `description` = :description";
+        $config_statement = DBManager::get()->prepare($query);
+        $config_statement->execute([
+            ':field'       => 'OER_TITLE',
+            ':value'       => 'OER Campus',
+            ':type'        => 'string',
+            ':range'       => 'global',
+            ':section'     => 'OERCampus',
+            ':description' => 'Name des OER Campus in Stud.IP',
+        ]);
+    }
+}