[remoteaccess] Add support for remote edit (reservation and scp task trigger)remote-edit-vm

1 files changed, 28 insertions, 0 deletions

diff --git a/modules-available/remoteaccess/install.inc.php b/modules-available/remoteaccess/install.inc.php
index 2e248282..1eeaf7e8 100644
--- a/modules-available/remoteaccess/install.inc.php
+++ b/modules-available/remoteaccess/install.inc.php
@@ -67,4 +67,32 @@ if (!tableHasColumn('remoteaccess_machine', 'vncport')) {
 	$dbret[] = UPDATE_DONE;
 }
 
+
+// 2021-08-21: Add Columns for reserving clients
+if (!tablehasColumn('remoteaccess_machine', 'lectureid')) {
+	$ret = Database::exec("ALTER TABLE remoteaccess_machine ADD COLUMN `lectureid` char(36)");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, DATABASE::lastError());
+	}
+	$dbret[] = UPDATE_DONE;
+}
+
+// 2021-08-21: Timestamp to see when the client was reserved (timeout)
+if (!tablehasColumn('remoteaccess_machine', 'timestamp')) {
+	$ret = Database::exec("ALTER TABLE remoteaccess_machine ADD COLUMN `timestamp` int unsigned");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, DATABASE::lastError());
+	}
+	$dbret[] = UPDATE_DONE;
+}
+
+// 2021-11-27: Add column for an edit session id
+if (!tablehasColumn('remoteaccess_machine', 'editid')) {
+	$ret = Database::exec("ALTER TABLE remoteaccess_machine ADD COLUMN `editid` char(36)");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, DATABASE::lastError());
+	}
+	$dbret[] = UPDATE_DONE;
+}
+
 responseFromArray($dbret);