extend size of db-column hobby in user_info, closes #2869

Closes #2869

Merge request studip/studip!1942

1 files changed, 23 insertions, 0 deletions

diff --git a/db/migrations/5.4.11_exend_user_info_hobby_size.php b/db/migrations/5.4.11_exend_user_info_hobby_size.php
new file mode 100644
index 0000000..5856aff
--- /dev/null
+++ b/db/migrations/5.4.11_exend_user_info_hobby_size.php
@@ -0,0 +1,23 @@
+<?php
+
+final class ExendUserInfoHobbySize extends Migration
+{
+    public function description()
+    {
+        return 'Increase max lenghth of column hobby in user_info';
+    }
+
+    public function up()
+    {
+        DBManager::get()->exec(
+            "ALTER TABLE `user_info` CHANGE `hobby` `hobby` mediumtext NOT NULL"
+        );
+    }
+
+    public function down()
+    {
+        DBManager::get()->exec(
+            "ALTER TABLE `user_info` CHANGE `hobby` `hobby` VARCHAR(255) NOT NULL DEFAULT ''"
+        );
+    }
+}