diff options
| -rw-r--r-- | Zotlabs/Update/_1259.php | 30 | ||||
| -rw-r--r-- | boot.php | 2 | ||||
| -rw-r--r-- | install/schema_mysql.sql | 2 |
3 files changed, 32 insertions, 2 deletions
diff --git a/Zotlabs/Update/_1259.php b/Zotlabs/Update/_1259.php new file mode 100644 index 000000000..235ca62f9 --- /dev/null +++ b/Zotlabs/Update/_1259.php @@ -0,0 +1,30 @@ +<?php + +namespace Zotlabs\Update; + +class _1259 { + + function run() { + + dbq("START TRANSACTION"); + + + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { + $r = true; + } + + if(ACTIVE_DBTYPE == DBTYPE_MYSQL) { + $r = dbq("ALTER TABLE cache MODIFY COLUMN v MEDIUMTEXT NOT NULL"); + } + + if($r) { + dbq("COMMIT"); + return UPDATE_SUCCESS; + } + + q("ROLLBACK"); + return UPDATE_FAILED; + + } + +} @@ -63,7 +63,7 @@ define('PLATFORM_NAME', 'hubzilla'); define('STD_VERSION', '8.7.4'); define('ZOT_REVISION', '6.0'); -define('DB_UPDATE_VERSION', 1258); +define('DB_UPDATE_VERSION', 1259); define('PROJECT_BASE', __DIR__); diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 570ac6c86..b17b62962 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -217,7 +217,7 @@ CREATE TABLE IF NOT EXISTS `auth_codes` ( CREATE TABLE IF NOT EXISTS `cache` ( `k` char(191) NOT NULL DEFAULT '', - `v` text NOT NULL, + `v` mediumtext NOT NULL, `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |