diff options
author | michael pereira | 2011-03-29 10:59:15 +0200 |
---|---|---|
committer | michael pereira | 2011-03-29 10:59:15 +0200 |
commit | 03b4da383449c290ea01723095d1a87fa257fea5 (patch) | |
tree | 4943185a212ced33465b92811cd070bf8e45b717 /pbs.sql | |
parent | updatebutton geadded (diff) | |
download | pbs2-03b4da383449c290ea01723095d1a87fa257fea5.tar.gz pbs2-03b4da383449c290ea01723095d1a87fa257fea5.tar.xz pbs2-03b4da383449c290ea01723095d1a87fa257fea5.zip |
Preboot User Controller fertig, ACL fehlt noch
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 8 |
1 files changed, 2 insertions, 6 deletions
@@ -129,7 +129,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` ( `description` varchar(140), `path_init` varchar(140) NOT NULL, `path_kernel` varchar(140) NOT NULL, - `defaultkcl` varchar(255) NOT NULL, + `defaultkcl` varchar(255), `created` VARCHAR(14) NOT NULL, `expires` VARCHAR(14), `public` int(11) NOT NULL, @@ -137,7 +137,6 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` ( KEY `configID` (`configID`), KEY `groupID` (`groupID`), KEY `membershipID` (`membershipID`), - KEY `defaultkcl` (`defaultkcl`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; ALTER TABLE `pbs_bootos` @@ -157,7 +156,7 @@ 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`) ON DELETE CASCADE, + ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL, ADD CONSTRAINT `pbs_bootmenu_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` ( @@ -172,7 +171,6 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` ( PRIMARY KEY (`bootmenuentriesID`), KEY `bootosID` (`bootosID`), KEY `bootmenuID` (`bootmenuID`), - KEY `kcl` (`kcl`), KEY `configID` (`configID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; @@ -180,8 +178,6 @@ 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_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL, - ADD CONSTRAINT `pbs_bootmenuentries_ibfk_4` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON DELETE CASCADE, - ADD CONSTRAINT `pbs_bootmenuentries_ibfk_5` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON UPDATE CASCADE; CREATE TABLE IF NOT EXISTS `pbs_preboot` ( `prebootID` int(11) NOT NULL AUTO_INCREMENT, |