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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2016-01-19 03:04:36 -0800 (Tue, 19 Jan 2016)
New Revision: 9373

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
New attributes to allow wfs owsproxy getfeature logging

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	2016-01-18 16:01:54 UTC (rev 9372)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2016-01-19 11:04:36 UTC (rev 9373)
@@ -772,3 +772,27 @@
 
 ALTER TABLE mb_user ADD COLUMN mb_user_aldigest text DEFAULT null;
 
+-- Column: wfs_proxylog
+
+-- ALTER TABLE wfs DROP COLUMN wfs_proxylog;
+
+ALTER TABLE wfs ADD COLUMN wfs_proxylog integer DEFAULT 0;
+
+-- Column: wfs_pricevolume
+
+-- ALTER TABLE wfs DROP COLUMN wfs_pricevolume;
+
+ALTER TABLE wfs ADD COLUMN wfs_pricevolume integer DEFAULT 0;
+
+-- Column: fkey_wfs_id
+
+-- ALTER TABLE mb_proxy_log DROP COLUMN fkey_wfs_id;
+
+ALTER TABLE mb_proxy_log ADD COLUMN fkey_wfs_id integer;
+
+-- Column: features
+
+-- ALTER TABLE mb_proxy_log DROP COLUMN features;
+
+ALTER TABLE mb_proxy_log ADD COLUMN features integer;
+