summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
authormichael pereira2011-03-06 12:59:40 +0100
committermichael pereira2011-03-06 12:59:40 +0100
commitd9e9eb09bacb86f1a86930b6cf5cafd41ce23462 (patch)
tree90bfc6f6af190f7a7de40be9b100cc2b2a205c56 /pbs.sql
parentTabelle Userconfig hinzugefuegt (diff)
parentMerge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff)
downloadpbs2-d9e9eb09bacb86f1a86930b6cf5cafd41ce23462.tar.gz
pbs2-d9e9eb09bacb86f1a86930b6cf5cafd41ce23462.tar.xz
pbs2-d9e9eb09bacb86f1a86930b6cf5cafd41ce23462.zip
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/pbs.sql b/pbs.sql
index 9e11d80..bae2325 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -289,6 +289,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 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;