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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2013-06-03 01:28:31 -0700 (Mon, 03 Jun 2013)
New Revision: 8641

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
Log:
db changes for wfs 2.0.0 integration

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2013-06-03 08:26:54 UTC (rev 8640)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2013-06-03 08:28:31 UTC (rev 8641)
@@ -239,8 +239,42 @@
         update_timestamp_column();
 -- maybe some other information needed?
 
+--------------------- db changes for wfs 2.0 integration ----------------------------------------
+ALTER TABLE wfs_conf ADD COLUMN stored_query_id character varying(255);
+ALTER TABLE wfs_conf ALTER COLUMN g_label TYPE character varying(255);
 
+-- new table wfs_operation
+CREATE TABLE wfs_operation
+(
+  wfs_op_id serial NOT NULL,
+  fkey_wfs_id integer NOT NULL DEFAULT 0,
+  op_name character varying(255),
+  op_http_get character varying(255),
+  op_http_post character varying(255),
+  CONSTRAINT pk_wfs_op_id PRIMARY KEY (wfs_op_id ),
+  CONSTRAINT wfs_op_ibfk_1 FOREIGN KEY (fkey_wfs_id)
+      REFERENCES wfs (wfs_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+);
 
+-- new table wfs_stored_query_params
+CREATE TABLE wfs_stored_query_params
+(
+  query_param_id serial NOT NULL,
+  fkey_wfs_conf_id integer NOT NULL DEFAULT 0,
+  stored_query_id character varying(255),
+  query_param_name character varying(255),
+  query_param_type character varying(255),
+  CONSTRAINT pk_query_param_id PRIMARY KEY (query_param_id ),
+  CONSTRAINT query_params_ibfk_1 FOREIGN KEY (fkey_wfs_conf_id)
+      REFERENCES wfs_conf (wfs_conf_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+);
+--------------------- end of db changes for wfs 2.0 integration ----------------------------------------
 
 
 
+
+
+
+