summaryrefslogtreecommitdiffstats
path: root/modules-available/remoteaccess/install.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'modules-available/remoteaccess/install.inc.php')
-rw-r--r--modules-available/remoteaccess/install.inc.php28
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);