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

[svn_mapbender at osgeo.org]

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

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Extent wfs information model for different values of the parameter outputFormat

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 13:11:31 UTC (rev 9041)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-08-11 13:28:08 UTC (rev 9042)
@@ -500,4 +500,23 @@
 );
 ALTER TABLE wfs_featuretype_output_formats
   OWNER TO postgres;
+--have also to be done for wfs itself parameter outputFormat 
 
+-- Table: wfs_output_formats
+
+-- DROP TABLE wfs_output_formats;
+
+CREATE TABLE wfs_output_formats
+(
+  fkey_wfs_id integer NOT NULL DEFAULT 0,
+  output_format character varying(50) NOT NULL DEFAULT ''::character varying,
+  CONSTRAINT wfs_output_formats_ibfk_1 FOREIGN KEY (fkey_wfs_id)
+      REFERENCES wfs (wfs_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE wfs_output_formats
+  OWNER TO postgres;
+