[Mapbender-commits] r6061 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2010-05-03 08:17:56 -0400 (Mon, 03 May 2010)
New Revision: 6061

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
new table

layer_md_topic category

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-05-03 11:59:02 UTC (rev 6060)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-05-03 12:17:56 UTC (rev 6061)
@@ -2439,3 +2439,20 @@
       ON UPDATE CASCADE ON DELETE CASCADE
 )
 WITH OIDS;
+
+-- Table: layer_md_topic_category
+
+CREATE TABLE layer_md_topic_category
+(
+  fkey_layer_id integer NOT NULL,
+  fkey_md_topic_category_id integer NOT NULL,
+  CONSTRAINT layer_md_topic_category_fkey_layer_id_fkey FOREIGN KEY 
+(fkey_layer_id)
+      REFERENCES layer (layer_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT layer_md_topic_category_fkey_md_topic_category_id_fkey FOREIGN 
+KEY (fkey_md_topic_category_id)
+      REFERENCES md_topic_category (md_topic_category_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITHOUT OIDS;