diff options
Diffstat (limited to 'pbs.sql')
| -rw-r--r-- | pbs.sql | 37 |
1 files changed, 30 insertions, 7 deletions
@@ -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, |