From 3a71088684697a1580c946d96fe081f720388971 Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Thu, 16 Jan 2020 15:01:28 +0100 Subject: [sysconfig] install: contents column text -> longblob --- modules-available/sysconfig/install.inc.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/modules-available/sysconfig/install.inc.php b/modules-available/sysconfig/install.inc.php index 9322578e..f7ff4405 100644 --- a/modules-available/sysconfig/install.inc.php +++ b/modules-available/sysconfig/install.inc.php @@ -16,7 +16,7 @@ $update[] = tableCreate('configtgz_module', " `title` varchar(200) NOT NULL, `moduletype` varchar(16) NOT NULL, `filepath` varchar(250) NOT NULL, - `contents` text NOT NULL, + `contents` longblob NOT NULL, `version` int(10) unsigned NOT NULL DEFAULT '0', `status` enum('OK','MISSING','OUTDATED') NOT NULL DEFAULT 'MISSING', `dateline` int(10) unsigned NOT NULL DEFAULT '0', @@ -107,6 +107,9 @@ if (!tableHasColumn('configtgz', 'dateline')) { } } +// 2020-01-16: Change contents column type +Database::exec("ALTER TABLE `configtgz_module` CHANGE `contents` `contents` LONGBLOB NOT NULL"); + // ----- rebuild configs ------ // TEMPORARY HACK; Rebuild configs.. move somewhere else? Module::isAvailable('sysconfig'); -- cgit v1.2.3-55-g7522