From 8df3db566a3a937b45ebf11adb90d265e6f5e2d4 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
Date: Sun, 17 Nov 2019 20:45:02 +0100
Subject: initial checking of customized version 1.0rc9

---
 setup/upgrade/1.0/varchartotext.php | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 setup/upgrade/1.0/varchartotext.php

(limited to 'setup/upgrade/1.0/varchartotext.php')

diff --git a/setup/upgrade/1.0/varchartotext.php b/setup/upgrade/1.0/varchartotext.php
new file mode 100644
index 0000000..3bba5ea
--- /dev/null
+++ b/setup/upgrade/1.0/varchartotext.php
@@ -0,0 +1,17 @@
+<?php
+if ($conf['database']['dbtype'] == 'pgsql') {
+    $db->query('ALTER TABLE {prefs} ALTER COLUMN pref_value TYPE text');
+    $db->query('ALTER TABLE {prefs} ALTER COLUMN pref_value SET DEFAULT \'\'');    
+}
+elseif($db->dbtype=='mysqli' || $db->dbtype=='mysql') {
+    $sinfo=$db->dblink->serverInfo();
+    if(isset($sinfo['version']) && version_compare($sinfo['version'], '5.5.3')>=0 ){
+        $db->query('ALTER TABLE {prefs} CHANGE `pref_value` `pref_value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL');
+    }else{
+        $db->query('ALTER TABLE {prefs} CHANGE `pref_value` `pref_value` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL');
+    }
+}
+else{
+    $db->query('ALTER TABLE {prefs} CHANGE `pref_value` `pref_value` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL');   
+}
+?>
-- 
cgit v1.2.3-54-g00ecf