BootMenuEntries angelegt

1 files changed, 8 insertions, 30 deletions

diff --git a/pbs.sql b/pbs.sql
index 5cbe84f..aa2d14c 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -105,7 +105,7 @@ CREATE TABLE IF NOT EXISTS `pbs_config` (
   `configID` int(11) NOT NULL AUTO_INCREMENT,
   `title` varchar(30) NOT NULL,
   `groupID` int(11) NOT NULL,
-  `membershipID` int(11) NOT NULL,
+  `membershipID` int(11),
   `shellscript` text NOT NULL,
   `created` VARCHAR(14) NOT NULL,
   PRIMARY KEY (`configID`),
@@ -114,22 +114,9 @@ CREATE TABLE IF NOT EXISTS `pbs_config` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_config`
-  ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`),
+  ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
 
-CREATE TABLE IF NOT EXISTS `pbs_userconfig` (
-  `userconfigID` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(30) NOT NULL,
-  `membershipID` int(11) NOT NULL,
-  `shellscript` text NOT NULL,
-  `created` VARCHAR(14) NOT NULL,
-  PRIMARY KEY (`userconfigID`),
-  KEY `membershipID` (`membershipID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
-ALTER TABLE `pbs_userconfig`
-  ADD CONSTRAINT `pbs_userconfig_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE;
-  
   
 CREATE TABLE IF NOT EXISTS `pbs_bootos` (
   `bootosID` int(11) NOT NULL AUTO_INCREMENT,
@@ -167,34 +154,25 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_bootmenu`
-  ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`),
+  ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_bootmenu_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
 
- CREATE TABLE IF NOT EXISTS `pbs_userbootmenu` (
-  `userbootmenuID` int(11) NOT NULL AUTO_INCREMENT,
-  `membershipID` int(11) NOT NULL,
-  `title` varchar(30) NOT NULL,
-  `created` varchar(14) NOT NULL,
-  PRIMARY KEY (`userbootmenuID`),
-  KEY `membershipID` (`membershipID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
-ALTER TABLE `pbs_userbootmenu`
-  ADD CONSTRAINT `pbs_userbootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE;
-  
 CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` (
   `bootosID` int(11) NOT NULL,
   `bootmenuID` int(11) NOT NULL,
   `title` varchar(30) NOT NULL,
   `kcl` varchar(140),
+  `configID` int(11) NOT NULL,
   `order` int(11) NOT NULL,
   KEY `bootosID` (`bootosID`),
-  KEY `bootmenuID` (`bootmenuID`)
+  KEY `bootmenuID` (`bootmenuID`),
+  KEY `configID` (`configID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_bootmenuentries`
   ADD CONSTRAINT `pbs_bootmenuentries_ibfk_1` FOREIGN KEY (`bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE,
-  ADD CONSTRAINT `pbs_bootmenuentries_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE;
+  ADD CONSTRAINT `pbs_bootmenuentries_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE,
+  ADD CONSTRAINT `pbs_bootmenuentries_ibfk_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE CASCADE;
 
 CREATE TABLE IF NOT EXISTS `pbs_bootiso` (
   `bootisoID` int(11) NOT NULL AUTO_INCREMENT,