From 8ad025dd99468f71d2fa5c49e0bcf359b055ec97 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 23 Jun 2015 19:10:48 +0200
Subject: [server] More methods implemented

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

(limited to 'dozentenmodulserver/setup/sat-01-schema.sql')

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` (
-- 
cgit v1.2.3-55-g7522

