diff options
Diffstat (limited to 'dozentenmodulserver/setup')
-rw-r--r-- | dozentenmodulserver/setup/sat-01-schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql index d0585db2..b0966e73 100644 --- a/dozentenmodulserver/setup/sat-01-schema.sql +++ b/dozentenmodulserver/setup/sat-01-schema.sql @@ -99,7 +99,7 @@ CREATE TABLE IF NOT EXISTS `lecture` ( `lectureid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `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.', + `imageversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin 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) 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', |