From 7a873d6f83ce3d0fdd846d436221c38d2ff98c83 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Fri, 5 Mar 2021 15:52:12 +0100
Subject: [remoteaccess] Allow changing client-side VNC port

References #3823
---
 modules-available/remoteaccess/install.inc.php | 10 ++++++++++
 1 file changed, 10 insertions(+)

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

diff --git a/modules-available/remoteaccess/install.inc.php b/modules-available/remoteaccess/install.inc.php
index 11656218..2e248282 100644
--- a/modules-available/remoteaccess/install.inc.php
+++ b/modules-available/remoteaccess/install.inc.php
@@ -21,6 +21,7 @@ $dbret[] = tableCreate('remoteaccess_machine', "
 	`machineuuid` char(36) CHARACTER SET ascii NOT NULL,
 	`password` char(8) CHARACTER SET ascii NULL DEFAULT NULL,
 	`woltime` int(10) UNSIGNED NOT NULL DEFAULT '0',
+	`vncport` smallint(5) UNSIGNED NOT NULL DEFAULT '5900',
 	PRIMARY KEY (`machineuuid`)
 ");
 
@@ -57,4 +58,13 @@ if (tableExists('remoteaccess_location')
 	Database::exec("DROP TABLE remoteaccess_location");
 }
 
+// 2021-03-05: Add vncport column to machine table
+if (!tableHasColumn('remoteaccess_machine', 'vncport')) {
+	$ret = Database::exec("ALTER TABLE remoteaccess_machine ADD COLUMN `vncport` smallint(5) UNSIGNED NOT NULL DEFAULT '5900'");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, Database::lastError());
+	}
+	$dbret[] = UPDATE_DONE;
+}
+
 responseFromArray($dbret);
-- 
cgit v1.2.3-55-g7522