datenbank erweitert, BootMenu, Config fertig

1 files changed, 30 insertions, 7 deletions

diff --git a/pbs.sql b/pbs.sql
index ccc452a..feeda70 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -105,19 +105,24 @@ 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,
   `shellscript` text NOT NULL,
+  `created` VARCHAR(14) NOT NULL,
   PRIMARY KEY (`configID`),
-  KEY `groupID` (`groupID`)
+  KEY `groupID` (`groupID`),
+  KEY `membershipID` (`membershipID`)
 ) 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`) ON DELETE CASCADE;
+  ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`),
+  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 ;
@@ -130,6 +135,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` (
   `bootosID` int(11) NOT NULL AUTO_INCREMENT,
   `configID` int(11),
   `groupID` int(11) NOT NULL,
+  `membershipID` int(11),
   `title` varchar(30) NOT NULL,
   `description` varchar(140),
   `path_init` varchar(140) NOT NULL,
@@ -140,25 +146,42 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` (
   `public` int(11) NOT NULL,
   PRIMARY KEY (`bootosID`),
   KEY `configID` (`configID`),
-  KEY `groupID` (`groupID`)
+  KEY `groupID` (`groupID`),
+  KEY `membershipID` (`membershipID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_bootos`
   ADD CONSTRAINT `pbs_bootos_ibfk_1` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`),
-  ADD CONSTRAINT `pbs_bootos_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
+  ADD CONSTRAINT `pbs_bootos_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
+  ADD CONSTRAINT `pbs_bootos_ibfk_3` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`);
 
 CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
   `bootmenuID` int(11) NOT NULL AUTO_INCREMENT,
-  `membershipID` int(11) NOT NULL,
+  `membershipID` int(11),
+  `groupID` int(11) NOT NULL,
   `title` varchar(30) NOT NULL,
-  `time` varchar(14) NOT NULL,
+  `created` varchar(14) NOT NULL,
   PRIMARY KEY (`bootmenuID`),
+  KEY `groupID` (`groupID`),
   KEY `membershipID` (`membershipID`)
 ) 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`) ON DELETE CASCADE;
+  ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`),
+  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,