From bcaeaf2b6722a5d04bec7a83b06987895d95e0b6 Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Sun, 3 Dec 2017 12:58:31 +0100 Subject: [locationinfo] Expand locationds colum --- modules-available/locationinfo/install.inc.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'modules-available/locationinfo/install.inc.php') diff --git a/modules-available/locationinfo/install.inc.php b/modules-available/locationinfo/install.inc.php index 7c47ac90..5e78349f 100644 --- a/modules-available/locationinfo/install.inc.php +++ b/modules-available/locationinfo/install.inc.php @@ -26,7 +26,7 @@ $t2 = $res[] = tableCreate('locationinfo_coursebackend', ' $t3 = $res[] = tableCreate('locationinfo_panel', " `paneluuid` char(36) CHARACTER SET ascii NOT NULL, `panelname` varchar(30) NOT NULL, - `locationids` varchar(20) CHARACTER SET ascii NOT NULL, + `locationids` varchar(100) CHARACTER SET ascii NOT NULL, `paneltype` enum('DEFAULT','SUMMARY', 'URL') NOT NULL, `panelconfig` blob NOT NULL, `lastchange` int(10) UNSIGNED NOT NULL DEFAULT 0, @@ -71,6 +71,9 @@ if ($t1 === UPDATE_DONE) { if ($t3 === UPDATE_NOOP) { Database::exec("ALTER TABLE `locationinfo_panel` CHANGE `paneltype` `paneltype` ENUM('DEFAULT', 'SUMMARY', 'URL') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL"); + // 2017-12-02 expand locationids column + Database::exec("ALTER TABLE `locationinfo_panel` CHANGE `locationids` + `locationids` varchar(100) CHARACTER SET ascii NOT NULL"); } // 2017-07-26 Add servername key -- cgit v1.2.3-55-g7522