diff options
| author | Simon Rettberg | 2015-06-23 19:10:48 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-06-23 19:10:48 +0200 |
| commit | 8ad025dd99468f71d2fa5c49e0bcf359b055ec97 (patch) | |
| tree | 6208ff7d598116e36b21882e5a018a99d2506103 /dozentenmodulserver/setup | |
| parent | fix bwLehrpool logo not beeing read from the resources (diff) | |
| download | tutor-module-8ad025dd99468f71d2fa5c49e0bcf359b055ec97.tar.gz tutor-module-8ad025dd99468f71d2fa5c49e0bcf359b055ec97.tar.xz tutor-module-8ad025dd99468f71d2fa5c49e0bcf359b055ec97.zip | |
[server] More methods implemented
Diffstat (limited to 'dozentenmodulserver/setup')
| -rw-r--r-- | dozentenmodulserver/setup/sat-01-schema.sql | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql index 3dbf5317..e6de9010 100644 --- a/dozentenmodulserver/setup/sat-01-schema.sql +++ b/dozentenmodulserver/setup/sat-01-schema.sql @@ -51,9 +51,9 @@ CREATE TABLE IF NOT EXISTS `imagebase` ( `currentversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL COMMENT 'Reference to current version of this image. This is redundant as it can be determined from the imageversion table, but the query to get all images with their current version would be very slow then, which is not what we want, as it is fired quite often.', `latestversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `displayname` varchar(100) NOT NULL, - `description` text NOT NULL, - `osid` int(11) NOT NULL, - `virtid` varchar(10) NOT NULL, + `description` TEXT NULL DEFAULT NULL, + `osid` INT NULL DEFAULT NULL, + `virtid` VARCHAR(10) NULL DEFAULT NULL, `createtime` bigint(20) NOT NULL, `updatetime` bigint(20) NOT NULL, `ownerid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, @@ -227,7 +227,8 @@ CREATE TABLE IF NOT EXISTS `organization` ( `organizationid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `displayname` varchar(255) NOT NULL, `canlogin` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`organizationid`) + PRIMARY KEY (`organizationid`), + KEY `loginkey` (`canlogin`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `os_x_virt` ( |