From d68ab42fdec2a7263ea4cf9c762a5e7585b7eb40 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Sun, 13 Sep 2015 16:37:01 +0200
Subject: [server] Minor tweaks and fixes

- Logging format
- Catch unchecked exceptions in web server and return internal server error
- fix: insert os-virt-mappings to db
---
 dozentenmodulserver/setup/sat-01-schema.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'dozentenmodulserver/setup')

diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql
index c6caef39..eadd5e4d 100644
--- a/dozentenmodulserver/setup/sat-01-schema.sql
+++ b/dozentenmodulserver/setup/sat-01-schema.sql
@@ -75,7 +75,7 @@ CREATE TABLE IF NOT EXISTS `imageversion` (
   `isprocessed` tinyint(1) NOT NULL,
   `mastersha1` binary(20) DEFAULT NULL,
   `virtualizerconfig` blob NULL DEFAULT NULL COMMENT 'Specific configuration of the virtualizer for this image. For vmware, this is basically a dump of the *.vmx.',
-  `deletestate` ENUM( 'KEEP', 'SHOULD_DELETE', 'WANT_DELETE' ) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT 'KEEP'
+  `deletestate` ENUM( 'KEEP', 'SHOULD_DELETE', 'WANT_DELETE' ) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT 'KEEP',
   PRIMARY KEY (`imageversionid`),
   KEY `version_access` (`imagebaseid`,`isvalid`,`createtime`),
   KEY `fk_imageversion_2_idx` (`uploaderid`),
@@ -116,6 +116,7 @@ CREATE TABLE IF NOT EXISTS `lecture` (
   `nics` VARCHAR(200) CHARACTER SET ascii COLLATE ascii_bin NULL COMMENT 'Freeform text field for future extendability. Format is specified at application layer.',
   `netrules` text DEFAULT NULL COMMENT 'user defined firewall rules, applied at the linux base system.',
   `isexam` tinyint(1) NOT NULL,
+  `iswhitelistonly` tinyint(1) NOT NULL DEFAULT '0',
   `hasinternetaccess` tinyint(1) NOT NULL,
   `caneditdefault` tinyint(1) NOT NULL,
   `canadmindefault` tinyint(1) NOT NULL,
-- 
cgit v1.2.3-55-g7522