Tabelle Userconfig hinzugefuegt

1 files changed, 16 insertions, 2 deletions

diff --git a/pbs.sql b/pbs.sql
index bc8d5d3..9e11d80 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -103,15 +103,29 @@ ALTER TABLE `pbs_membership`
 
 CREATE TABLE IF NOT EXISTS `pbs_config` (
   `configID` int(11) NOT NULL AUTO_INCREMENT,
-  `membershipID` int(11) NOT NULL,
+  `title` varchar(30) NOT NULL,
+  `groupID` int(11) NOT NULL,
   `shellscript` text NOT NULL,
   PRIMARY KEY (`configID`),
-  KEY `membershipID` (`membershipID`)
+  KEY `groupID` (`groupID`)
 ) 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;
 
+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,
+  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,
   `configID` int(11),