summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql5
1 files changed, 3 insertions, 2 deletions
diff --git a/pbs.sql b/pbs.sql
index 6c60837..10dc0d5 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -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,