diff options
| author | Simon Rettberg | 2022-11-03 16:20:33 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2022-11-03 16:20:33 +0100 |
| commit | c89d75f78d98da0dfe4c44b283b509dcdc1bcd3c (patch) | |
| tree | f6677d819c278a9367d92d04563d5520cbe3f078 /modules-available/minilinux/install.inc.php | |
| parent | [dozmod] Add field to configure maximum VM image size (diff) | |
| download | slx-admin-c89d75f78d98da0dfe4c44b283b509dcdc1bcd3c.tar.gz slx-admin-c89d75f78d98da0dfe4c44b283b509dcdc1bcd3c.tar.xz slx-admin-c89d75f78d98da0dfe4c44b283b509dcdc1bcd3c.zip | |
[minilinux] Add support for branch colors and changelogs
Diffstat (limited to 'modules-available/minilinux/install.inc.php')
| -rw-r--r-- | modules-available/minilinux/install.inc.php | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/modules-available/minilinux/install.inc.php b/modules-available/minilinux/install.inc.php index e71e3c10..12b5c69c 100644 --- a/modules-available/minilinux/install.inc.php +++ b/modules-available/minilinux/install.inc.php @@ -14,6 +14,7 @@ $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, + `color` varchar(7) NOT NULL, `description` blob NOT NULL, PRIMARY KEY (`branchid`), KEY (`title`) @@ -22,6 +23,7 @@ $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, + `description` blob NOT NULL, `dateline` int(10) UNSIGNED NOT NULL, `data` blob NOT NULL, `orphan` tinyint(3) UNSIGNED NOT NULL, @@ -39,4 +41,21 @@ $result[] = tableAddConstraint('minilinux_version', 'branchid', 'minilinux_branc $result[] = tableAddConstraint('minilinux_branch', 'sourceid', 'minilinux_source', 'sourceid', 'ON UPDATE CASCADE ON DELETE SET NULL'); +// 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) { + $result[] = UPDATE_DONE; + } else { + finalResponse(UPDATE_FAILED, Database::lastError()); + } +} +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) { + $result[] = UPDATE_DONE; + } else { + finalResponse(UPDATE_FAILED, Database::lastError()); + } +} + responseFromArray($result); |