summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql18
1 files changed, 16 insertions, 2 deletions
diff --git a/pbs.sql b/pbs.sql
index f969cce..bae2325 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),