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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2012-05-24 07:00:54 -0700 (Thu, 24 May 2012)
New Revision: 8364

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
Possibility to decide if wfs_featuretypes or wms_layer should be used to generate inspire pre defined datasets automatically.

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-05-24 13:58:31 UTC (rev 8363)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-05-24 14:00:54 UTC (rev 8364)
@@ -428,3 +428,10 @@
 -- Fix: Ticket #870, http://trac.osgeo.org/mapbender/ticket/870
 UPDATE gui_element set e_attributes='frameborder="1" onmouseover="this.style.zIndex=300;this.style.width=''350px'';" onmouseout="this.style.zIndex=3;this.style.width=''200px'';"' where fkey_gui_id='gui' and e_id='legend';
 
+-- add possibility to define if inspire download should be possible for wms layers and wfs featuretypes 
+ALTER TABLE wfs_featuretype ADD COLUMN inspire_download integer;
+UPDATE wfs_featuretype SET inspire_download = 0 WHERE inspire_download IS NULL;
+
+ALTER TABLE layer ADD COLUMN inspire_download integer;
+UPDATE layer SET inspire_download = 0 WHERE inspire_download IS NULL;
+