drop config option for disabling the ckeditor, fixes #3227

Closes #3227

Merge request studip/studip!2276

1 files changed, 39 insertions, 0 deletions

diff --git a/db/migrations/5.5.5_drop_wysiwyg_config.php b/db/migrations/5.5.5_drop_wysiwyg_config.php
new file mode 100644
index 0000000..ae86e59
--- /dev/null
+++ b/db/migrations/5.5.5_drop_wysiwyg_config.php
@@ -0,0 +1,39 @@
+<?php
+
+class DropWysiwygConfig extends Migration
+{
+    public function description()
+    {
+        return 'Drop config option for disabling the ckeditor';
+    }
+
+    public function up()
+    {
+        $settings = [
+            'WYSIWYG',
+            'WYSIWYG_DISABLED'
+        ];
+
+        $query = 'DELETE `config`, `config_values`
+                  FROM `config` LEFT JOIN `config_values` USING (`field`)
+                  WHERE `field` IN (?)';
+        DBManager::get()->execute($query, [$settings]);
+    }
+
+    public function down()
+    {
+        $query = 'INSERT INTO `config` (`field`, `value`, `type`, `range`, `section`, `mkdate`, `chdate`, `description`)
+                  VALUES (:name, :value, :type, :range, :section, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), :description)';
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([
+            ':name'        => 'WYSIWYG',
+            ':description' => 'Aktiviert den WYSIWYG Editor im JavaScript.',
+            ':section'     => 'global',
+            ':range'       => 'global',
+            ':type'        => 'boolean',
+            ':value'       => '1'
+        ]);
+
+        // WYSIWYG_DISABLED did not exist as a setting in the DB
+    }
+}