From c89d75f78d98da0dfe4c44b283b509dcdc1bcd3c Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Thu, 3 Nov 2022 16:20:33 +0100
Subject: [minilinux] Add support for branch colors and changelogs

---
 modules-available/minilinux/install.inc.php | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'modules-available/minilinux/install.inc.php')

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);
-- 
cgit v1.2.3-55-g7522