diff options
author | michael pereira | 2011-03-07 17:53:57 +0100 |
---|---|---|
committer | michael pereira | 2011-03-07 17:53:57 +0100 |
commit | d3b22c724dfdf275f7feb981182d54a18310bcc0 (patch) | |
tree | c56c1c61cf1a276ce0b6753bf51ee737388c1e90 /pbs.sql | |
parent | Bootmenuentries DB geaendert (diff) | |
download | pbs2-d3b22c724dfdf275f7feb981182d54a18310bcc0.tar.gz pbs2-d3b22c724dfdf275f7feb981182d54a18310bcc0.tar.xz pbs2-d3b22c724dfdf275f7feb981182d54a18310bcc0.zip |
BootMenuEntries fertig
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 5 |
1 files changed, 3 insertions, 2 deletions
@@ -163,9 +163,10 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` ( `bootmenuID` int(11) NOT NULL, `title` varchar(30) NOT NULL, `kcl` varchar(140), - `configID` int(11) NOT NULL, + `configID` int(11), `order` int(11) NOT NULL, PRIMARY KEY (`bootmenuentriesID`), + UNIQUE KEY `bootmenuIDbootosID` (`bootmenuID`,`bootosID`), KEY `bootosID` (`bootosID`), KEY `bootmenuID` (`bootmenuID`), KEY `configID` (`configID`) @@ -174,7 +175,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` ( 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 CASCADE; + ADD CONSTRAINT `pbs_bootmenuentries_ibfk_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`); CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( `bootisoID` int(11) NOT NULL AUTO_INCREMENT, |