From ebdcf88fbb49e4136d281b3d07f6b212d94223fe Mon Sep 17 00:00:00 2001 From: michael pereira Date: Mon, 7 Mar 2011 13:06:41 +0100 Subject: Bootmenuentries DB geaendert --- pbs.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'pbs.sql') diff --git a/pbs.sql b/pbs.sql index aa2d14c..6c60837 100644 --- a/pbs.sql +++ b/pbs.sql @@ -158,12 +158,14 @@ ALTER TABLE `pbs_bootmenu` ADD CONSTRAINT `pbs_bootmenu_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` ( + `bootmenuentriesID` int(11) NOT NULL AUTO_INCREMENT, `bootosID` int(11) NOT NULL, `bootmenuID` int(11) NOT NULL, `title` varchar(30) NOT NULL, `kcl` varchar(140), `configID` int(11) NOT NULL, `order` int(11) NOT NULL, + PRIMARY KEY (`bootmenuentriesID`), KEY `bootosID` (`bootosID`), KEY `bootmenuID` (`bootmenuID`), KEY `configID` (`configID`) -- cgit v1.2.3-55-g7522