summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
authorSimon2011-03-29 12:11:07 +0200
committerSimon2011-03-29 12:11:07 +0200
commit045bb9611f572ecb0b251eb116a221ff9b8a96d4 (patch)
treea31117e6b8965152ebf6e9b42c49c88a226ea366 /pbs.sql
parentShortcuts zu rechten hinzugefĆ¼gt (diff)
parentsql fixed (diff)
downloadpbs2-045bb9611f572ecb0b251eb116a221ff9b8a96d4.tar.gz
pbs2-045bb9611f572ecb0b251eb116a221ff9b8a96d4.tar.xz
pbs2-045bb9611f572ecb0b251eb116a221ff9b8a96d4.zip
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/pbs.sql b/pbs.sql
index 6c2af35..d45b47e 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -147,7 +147,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` (
PRIMARY KEY (`bootosID`),
KEY `configID` (`configID`),
KEY `groupID` (`groupID`),
- KEY `membershipID` (`membershipID`),
+ KEY `membershipID` (`membershipID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_bootos`
@@ -188,7 +188,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 SET NULL,
+ ADD CONSTRAINT `pbs_bootmenuentries_ibfk_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL;
CREATE TABLE IF NOT EXISTS `pbs_preboot` (
`prebootID` int(11) NOT NULL AUTO_INCREMENT,