diff options
| author | Simon Rettberg | 2015-09-02 12:09:23 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-09-02 12:09:23 +0200 |
| commit | 8e444863bdb91f7b8109ff7c15c29673fe67d4d6 (patch) | |
| tree | 41b8a00754f6b67b5e6392edcf5762ca5b9477b1 /dozentenmodulserver/setup | |
| parent | .....aaaaand it's gone (diff) | |
| download | tutor-module-8e444863bdb91f7b8109ff7c15c29673fe67d4d6.tar.gz tutor-module-8e444863bdb91f7b8109ff7c15c29673fe67d4d6.tar.xz tutor-module-8e444863bdb91f7b8109ff7c15c29673fe67d4d6.zip | |
[server] Serve vmchooser-compatible lecture list via http
Diffstat (limited to 'dozentenmodulserver/setup')
| -rw-r--r-- | dozentenmodulserver/setup/sat-01-schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
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` ( |