diff options
author | Simon | 2011-03-06 13:04:04 +0100 |
---|---|---|
committer | Simon | 2011-03-06 13:04:04 +0100 |
commit | 72ab13da979af7ccfc5ecbf48ffc304189edf508 (patch) | |
tree | 120ff3c43795767983042b05223d2df9e9ca6273 /pbs.sql | |
parent | Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff) | |
download | pbs2-72ab13da979af7ccfc5ecbf48ffc304189edf508.tar.gz pbs2-72ab13da979af7ccfc5ecbf48ffc304189edf508.tar.xz pbs2-72ab13da979af7ccfc5ecbf48ffc304189edf508.zip |
update
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -275,7 +275,7 @@ CREATE TABLE IF NOT EXISTS `pbs_filterentries` ( KEY `filtertypeID` (`filtertypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -ALTER TABLE `pbs_filterentries` ADD `filterentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST +ALTER TABLE `pbs_filterentries` ADD `filterentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; ALTER TABLE `pbs_filterentries` ADD CONSTRAINT `pbs_filterentries_ibfk_1` FOREIGN KEY (`filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE, ADD CONSTRAINT `pbs_filterentries_ibfk_2` FOREIGN KEY (`filtertypeID`) REFERENCES `pbs_filtertype` (`filtertypeID`) ON DELETE CASCADE; |