diff options
author | michael pereira | 2011-03-29 12:10:44 +0200 |
---|---|---|
committer | michael pereira | 2011-03-29 12:10:44 +0200 |
commit | d008a1c77392885c4ee57b8e95512c6dd0be0f73 (patch) | |
tree | ff2b5a5f602c9149ed511095eb21097a8bf7919d /pbs.sql | |
parent | Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff) | |
download | pbs2-d008a1c77392885c4ee57b8e95512c6dd0be0f73.tar.gz pbs2-d008a1c77392885c4ee57b8e95512c6dd0be0f73.tar.xz pbs2-d008a1c77392885c4ee57b8e95512c6dd0be0f73.zip |
sql fixed
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -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, @@ -359,7 +359,7 @@ INSERT INTO `pbs_rightcategory` (`rightcategoryID`, `title`) VALUES (11, 'Filter'); -- Insert rights -INSERT INTO `pbs`.`pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES +INSERT INTO `pbs`.`pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES -- Person -- Eigene Personendetails ändern (NULL, '1', '', 'Edit own profiledetails', NULL), |