From 8e444863bdb91f7b8109ff7c15c29673fe67d4d6 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 2 Sep 2015 12:09:23 +0200
Subject: [server] Serve vmchooser-compatible lecture list via http

---
 dozentenmodulserver/setup/sat-01-schema.sql | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'dozentenmodulserver/setup')

diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql
index f030298a..d0585db2 100644
--- a/dozentenmodulserver/setup/sat-01-schema.sql
+++ b/dozentenmodulserver/setup/sat-01-schema.sql
@@ -100,8 +100,9 @@ CREATE TABLE IF NOT EXISTS `lecture` (
   `displayname` varchar(100) NOT NULL,
   `description` text NOT NULL,
   `imageversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL COMMENT 'We reference a specific image version here, not the base image.\nOn update of an image, we update the lecture table for all matching lectures that used the current image version.\nThis way, a tutor can explicitly switch back to an older version of an image.',
-  `autoupdate` tinyint(1) NOT NULL,
-  `isenabled` tinyint(1) NOT NULL,
+  `autoupdate` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
+  `isenabled` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
+  `isprivate` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Only users from the lectureuser table can start this lecture',
   `starttime` bigint(20) NOT NULL,
   `endtime` bigint(20) NOT NULL,
   `lastused` bigint(20) NOT NULL DEFAULT '0',
@@ -120,7 +121,8 @@ CREATE TABLE IF NOT EXISTS `lecture` (
   PRIMARY KEY (`lectureid`),
   KEY `fk_lecture_1_idx` (`imageversionid`),
   KEY `fk_lecture_2_idx` (`ownerid`),
-  KEY `fk_lecture_3_idx` (`updaterid`)
+  KEY `fk_lecture_3_idx` (`updaterid`),
+  KEY `list_lookup` (`isenabled`,`isexam`,`isprivate`,`endtime`,`starttime`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
 CREATE TABLE IF NOT EXISTS `lecturepermission` (
-- 
cgit v1.2.3-55-g7522