[server] Fnished image-related methods so far, started implementing lecture-related ones....

1 files changed, 1 insertions, 13 deletions

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;