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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2014-08-11 06:11:31 -0700 (Mon, 11 Aug 2014)
New Revision: 9041

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Extend information model for different wfs featuretype outputformats

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-08-11 10:39:14 UTC (rev 9040)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-08-11 13:11:31 UTC (rev 9041)
@@ -482,3 +482,22 @@
       REFERENCES termsofuse (termsofuse_id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE RESTRICT;
 -- ************************************************************
+-- Handle different outputformats for wfs featuretypes 
+-- Table: wfs_featuretype_output_formats
+
+-- DROP TABLE wfs_featuretype_output_formats;
+
+CREATE TABLE wfs_featuretype_output_formats
+(
+  fkey_featuretype_id integer NOT NULL DEFAULT 0,
+  output_format character varying(50) NOT NULL DEFAULT ''::character varying,
+  CONSTRAINT wfs_featuretype_output_formats_ibfk_1 FOREIGN KEY (fkey_featuretype_id)
+      REFERENCES wfs_featuretype (featuretype_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE wfs_featuretype_output_formats
+  OWNER TO postgres;
+