diff options
author | Simon | 2011-03-29 11:22:04 +0200 |
---|---|---|
committer | Simon | 2011-03-29 11:22:04 +0200 |
commit | 0017ec00ed872a1cac818e7194f8e7b626ff604d (patch) | |
tree | 0bbec1661ccfb6e4634df5d3ec67a38b496a3abe /pbs.sql | |
parent | shortcut für rechte vorbereitet (diff) | |
parent | Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff) | |
download | pbs2-0017ec00ed872a1cac818e7194f8e7b626ff604d.tar.gz pbs2-0017ec00ed872a1cac818e7194f8e7b626ff604d.tar.xz pbs2-0017ec00ed872a1cac818e7194f8e7b626ff604d.zip |
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 8 |
1 files changed, 2 insertions, 6 deletions
@@ -140,7 +140,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, @@ -148,7 +148,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` @@ -168,7 +167,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` ( @@ -183,7 +182,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 ; @@ -191,8 +189,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, |