From 9ff2e9adc74f804023ed751a5afe264b596bf93a Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 24 Jun 2015 18:31:59 +0200
Subject: [server] Fnished image-related methods so far, started implementing
 lecture-related ones....

---
 dozentenmodulserver/setup/sat-01-schema.sql | 14 +-------------
 1 file changed, 1 insertion(+), 13 deletions(-)

(limited to 'dozentenmodulserver/setup')

diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql
index e6de9010..08a63be8 100644
--- a/dozentenmodulserver/setup/sat-01-schema.sql
+++ b/dozentenmodulserver/setup/sat-01-schema.sql
@@ -187,6 +187,7 @@ CREATE TABLE IF NOT EXISTS `lecture` (
   `updaterid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
   `runscript` text DEFAULT NULL,
   `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,
   `hasinternetaccess` tinyint(1) NOT NULL,
   `caneditdefault` tinyint(1) NOT NULL,
@@ -197,16 +198,6 @@ CREATE TABLE IF NOT EXISTS `lecture` (
   KEY `fk_lecture_3_idx` (`updaterid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
-CREATE TABLE IF NOT EXISTS `lecturenetrule` (
-  `ruleid` int(11) NOT NULL AUTO_INCREMENT,
-  `lectureid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `direction` enum('IN','OUT') NOT NULL,
-  `host` varchar(45) NOT NULL,
-  `port` INT NULL,
-  PRIMARY KEY (`ruleid`),
-  KEY `fk_lecturenetrule_1_idx` (`lectureid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-
 CREATE TABLE IF NOT EXISTS `lecturepermission` (
   `lectureid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
   `userid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
@@ -314,9 +305,6 @@ ALTER TABLE `lecture`
   ADD CONSTRAINT `fk_lecture_owner` FOREIGN KEY (`ownerid`) REFERENCES `user` (`userid`) ON UPDATE CASCADE,
   ADD CONSTRAINT `fk_lecture_updater` FOREIGN KEY (`updaterid`) REFERENCES `user` (`userid`) ON UPDATE CASCADE;
 
-ALTER TABLE `lecturenetrule`
-  ADD CONSTRAINT `fk_lecturenetrule_1` FOREIGN KEY (`lectureid`) REFERENCES `lecture` (`lectureid`) ON UPDATE CASCADE ON DELETE CASCADE;
-
 ALTER TABLE `lecturepermission`
   ADD CONSTRAINT `fk_lecturepermission_1` FOREIGN KEY (`lectureid`) REFERENCES `lecture` (`lectureid`) ON UPDATE CASCADE ON DELETE CASCADE,
   ADD CONSTRAINT `fk_lecturepermission_2` FOREIGN KEY (`userid`) REFERENCES `user` (`userid`) ON UPDATE CASCADE ON DELETE CASCADE;
-- 
cgit v1.2.3-55-g7522