Preboot Controller eingerichtet

1 files changed, 18 insertions, 2 deletions

diff --git a/pbs.sql b/pbs.sql
index 594be86..bfac5e0 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -188,7 +188,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootiso` (
   `title` varchar(30) NOT NULL,  
   `membershipID` int(11),
   `groupID` int(11) NOT NULL,
-  `path_fbgui` varchar(30) NOT NULL,    
+  `prebootID` int(11) NOT NULL,    
   `serialnumber` int(11) NOT NULL,
   `created` VARCHAR(14) NOT NULL,
   `expires` VARCHAR(14),
@@ -200,8 +200,24 @@ CREATE TABLE IF NOT EXISTS `pbs_bootiso` (
 
 ALTER TABLE `pbs_bootiso`
   ADD CONSTRAINT `pbs_bootiso_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
-  ADD CONSTRAINT `pbs_bootiso_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
+  ADD CONSTRAINT `pbs_bootiso_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
+  ADD CONSTRAINT `pbs_bootiso_ibfk_3` FOREIGN KEY (`prebootID`) REFERENCES `pbs_preboot` (`prebootID`) ON DELETE CASCADE;
 
+CREATE TABLE IF NOT EXISTS `pbs_preboot` (
+  `prebootID` int(11) NOT NULL AUTO_INCREMENT,
+  `title` varchar(30) NOT NULL,  
+  `membershipID` int(11),
+  `groupID` int(11) NOT NULL,
+  `path_preboot` varchar(30) NOT NULL, 
+  PRIMARY KEY (`prebootID`),
+  KEY `membershipID` (`membershipID`),
+  KEY `groupID` (`groupID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+
+ALTER TABLE `pbs_preboot`
+  ADD CONSTRAINT `pbs_preboot_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
+  ADD CONSTRAINT `pbs_preboot_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
+  
 CREATE TABLE IF NOT EXISTS `pbs_client` (
   `clientID` int(11) NOT NULL AUTO_INCREMENT,
   `macadress` varchar(17) NOT NULL,