diff options
Diffstat (limited to 'modules-available/minilinux/install.inc.php')
-rw-r--r-- | modules-available/minilinux/install.inc.php | 17 |
1 files changed, 12 insertions, 5 deletions
diff --git a/modules-available/minilinux/install.inc.php b/modules-available/minilinux/install.inc.php index 12b5c69c..7ef82d74 100644 --- a/modules-available/minilinux/install.inc.php +++ b/modules-available/minilinux/install.inc.php @@ -2,7 +2,7 @@ $result[] = tableCreate('minilinux_source', " `sourceid` varchar(8) CHARACTER SET ascii NOT NULL, - `title` varchar(100) NOT NULL, + `title` varchar(150) NOT NULL, `url` varchar(200) NOT NULL, `lastupdate` int(10) UNSIGNED NOT NULL DEFAULT '0', `taskid` char(36) CHARACTER SET ascii DEFAULT NULL, @@ -13,7 +13,7 @@ $result[] = tableCreate('minilinux_source', " $result[] = tableCreate('minilinux_branch', " `sourceid` varchar(8) CHARACTER SET ascii DEFAULT NULL, `branchid` varchar(40) CHARACTER SET ascii NOT NULL, - `title` varchar(100) NOT NULL, + `title` varchar(150) NOT NULL, `color` varchar(7) NOT NULL, `description` blob NOT NULL, PRIMARY KEY (`branchid`), @@ -22,7 +22,7 @@ $result[] = tableCreate('minilinux_branch', " $result[] = tableCreate('minilinux_version', " `branchid` varchar(40) CHARACTER SET ascii NOT NULL, `versionid` varchar(72) CHARACTER SET ascii NOT NULL, - `title` varchar(100) NOT NULL, + `title` varchar(150) NOT NULL, `description` blob NOT NULL, `dateline` int(10) UNSIGNED NOT NULL, `data` blob NOT NULL, @@ -43,7 +43,7 @@ $result[] = tableAddConstraint('minilinux_branch', 'sourceid', 'minilinux_source // 2022-10-17: Add color to branch, description to version if (!tableHasColumn('minilinux_branch', 'color')) { - if (Database::exec("ALTER TABLE minilinux_branch ADD COLUMN `color` varchar(7) NOT NULL DEFAULT '' AFTER `title`") !== false) { + if (Database::exec("ALTER TABLE `minilinux_branch` ADD COLUMN `color` varchar(7) NOT NULL DEFAULT '' AFTER `title`") !== false) { $result[] = UPDATE_DONE; } else { finalResponse(UPDATE_FAILED, Database::lastError()); @@ -51,11 +51,18 @@ if (!tableHasColumn('minilinux_branch', 'color')) { } if (!tableHasColumn('minilinux_version', 'description')) { // BLOB/TEXT cannot have non-NULL default on older MariaDB - if (Database::exec("ALTER TABLE minilinux_version ADD COLUMN `description` blob NULL DEFAULT NULL AFTER `title`") !== false) { + if (Database::exec("ALTER TABLE `minilinux_version` ADD COLUMN `description` blob NULL DEFAULT NULL AFTER `title`") !== false) { $result[] = UPDATE_DONE; } else { finalResponse(UPDATE_FAILED, Database::lastError()); } } +// 2023-07-17: Make title columns larger +foreach (['minilinux_source', 'minilinux_branch', 'minilinux_version'] as $table) { + if (stripos(tableColumnType($table, 'title'), 'varchar(150)') === false) { + Database::exec("ALTER TABLE `$table` MODIFY `title` varchar(150) NOT NULL"); + } +} + responseFromArray($result); |