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

[svn_mapbender at osgeo.org]

Author: marc
Date: 2011-02-22 10:25:17 -0800 (Tue, 22 Feb 2011)
New Revision: 7635

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
Log:
#784

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-02-22 16:57:49 UTC (rev 7634)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-02-22 18:25:17 UTC (rev 7635)
@@ -7,7 +7,7 @@
 --new function to get the load_count of wmc which are stored in the mapbender database
 --
 -- Function: f_wmc_load_count(integer)
-
+de
 CREATE OR REPLACE FUNCTION f_wmc_load_count(integer)
   RETURNS integer AS
 $BODY$
@@ -1591,3 +1591,77 @@
 UPDATE gui set gui_description = 'Administration for WFS metadata' where gui_id = 'admin_wfs_metadata';
 UPDATE gui set gui_description = 'Administration for WMC metadata' where gui_id = 'admin_wmc_metadata';
 
+--
+-- change position of some ui element 
+--
+UPDATE gui_element set e_pos='2' WHERE e_id='jq_ui_position' AND fkey_gui_id IN ('admin_wms_metadata','admin_wmc_metadata','admin_wfs_metadata');
+UPDATE gui_element set e_pos='2' WHERE e_id='jq_ui_widget' AND fkey_gui_id IN ('admin_wms_metadata','admin_wmc_metadata','admin_wfs_metadata');
+UPDATE gui_element set e_pos='3' WHERE e_id='jq_ui_mouse' AND fkey_gui_id IN ('admin_wms_metadata','admin_wmc_metadata','admin_wfs_metadata');
+
+--
+--Put a Map (germany to admin applications)
+--WMS germany gui_wms 
+--admin_wms_metadata
+--
+INSERT INTO gui_wms (fkey_gui_id,fkey_wms_id,gui_wms_position,gui_wms_mapformat,
+gui_wms_featureinfoformat,gui_wms_exceptionformat,gui_wms_epsg,gui_wms_visible,gui_wms_opacity,gui_wms_sldurl) 
+(SELECT 
+'admin_wms_metadata', fkey_wms_id, 0, 
+gui_wms_mapformat,gui_wms_featureinfoformat,
+gui_wms_exceptionformat,gui_wms_epsg,1 as gui_wms_visible,gui_wms_opacity,gui_wms_sldurl
+FROM gui_wms WHERE fkey_gui_id = 'gui1' AND fkey_wms_id = 893);
+-- WMS germany gui_layer
+INSERT INTO gui_layer (fkey_gui_id,fkey_layer_id,gui_layer_wms_id,gui_layer_status,gui_layer_selectable,
+gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,gui_layer_maxscale,
+gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title)
+(SELECT 
+'admin_wms_metadata', 
+fkey_layer_id,gui_layer_wms_id ,gui_layer_status,gui_layer_selectable,
+gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,
+gui_layer_maxscale,gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title
+ FROM gui_layer WHERE fkey_gui_id = 'gui1' AND gui_layer_wms_id = 893);
+
+--
+--WMS germany gui_wms 
+--admin_wfs_metadata
+--
+INSERT INTO gui_wms (fkey_gui_id,fkey_wms_id,gui_wms_position,gui_wms_mapformat,
+gui_wms_featureinfoformat,gui_wms_exceptionformat,gui_wms_epsg,gui_wms_visible,gui_wms_opacity,gui_wms_sldurl) 
+(SELECT 
+'admin_wfs_metadata', fkey_wms_id, 0, 
+gui_wms_mapformat,gui_wms_featureinfoformat,
+gui_wms_exceptionformat,gui_wms_epsg,1 as gui_wms_visible,gui_wms_opacity,gui_wms_sldurl
+FROM gui_wms WHERE fkey_gui_id = 'gui1' AND fkey_wms_id = 893);
+-- WMS germany gui_layer
+INSERT INTO gui_layer (fkey_gui_id,fkey_layer_id,gui_layer_wms_id,gui_layer_status,gui_layer_selectable,
+gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,gui_layer_maxscale,
+gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title)
+(SELECT 
+'admin_wfs_metadata', 
+fkey_layer_id,gui_layer_wms_id ,gui_layer_status,gui_layer_selectable,
+gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,
+gui_layer_maxscale,gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title
+ FROM gui_layer WHERE fkey_gui_id = 'gui1' AND gui_layer_wms_id = 893);
+
+--
+--WMS germany gui_wms 
+--admin_wmc_metadata
+--
+INSERT INTO gui_wms (fkey_gui_id,fkey_wms_id,gui_wms_position,gui_wms_mapformat,
+gui_wms_featureinfoformat,gui_wms_exceptionformat,gui_wms_epsg,gui_wms_visible,gui_wms_opacity,gui_wms_sldurl) 
+(SELECT 
+'admin_wmc_metadata', fkey_wms_id, 0, 
+gui_wms_mapformat,gui_wms_featureinfoformat,
+gui_wms_exceptionformat,gui_wms_epsg,1 as gui_wms_visible,gui_wms_opacity,gui_wms_sldurl
+FROM gui_wms WHERE fkey_gui_id = 'gui1' AND fkey_wms_id = 893);
+-- WMS germany gui_layer
+INSERT INTO gui_layer (fkey_gui_id,fkey_layer_id,gui_layer_wms_id,gui_layer_status,gui_layer_selectable,
+gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,gui_layer_maxscale,
+gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title)
+(SELECT 
+'admin_wmc_metadata', 
+fkey_layer_id,gui_layer_wms_id ,gui_layer_status,gui_layer_selectable,
+gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,
+gui_layer_maxscale,gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title
+ FROM gui_layer WHERE fkey_gui_id = 'gui1' AND gui_layer_wms_id = 893);
+