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

svn_mapbender at osgeo.org svn_mapbender at osgeo.org
Sun Dec 12 11:12:42 EST 2010 

Author: astrid_emde
Date: 2010-12-12 08:12:42 -0800 (Sun, 12 Dec 2010)
New Revision: 7301

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
element aus admin1 deleted: CreateTreeGDE

new gui: 'layout_with_map_and_toolbar'

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-12-12 15:56:58 UTC (rev 7300)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-12-12 16:12:42 UTC (rev 7301)
@@ -3347,8 +3347,181 @@
 gui_layer_maxscale,gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title
  FROM gui_layer WHERE fkey_gui_id = 'gui' AND gui_layer_wms_id = 250);
 
+-------------
+--germany
+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 
+'template_openlayers', fkey_wms_id, 1, 
+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 = 'gui' AND fkey_wms_id = 893);
+
+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 
+'template_openlayers', 
+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 = 'gui' AND gui_layer_wms_id = 893);
+
 INSERT into gui_gui_category VALUES ('template_openlayers', 2);
 --
 --
 --
 --Insert Template OpenLayers END
+
+
+--
+--
+--
+--Insert Template layout_with_map_and_toolbar
+INSERT INTO gui (gui_id, gui_name, gui_description, gui_public) VALUES ('layout_with_map_and_toolbar','layout_with_map_and_toolbar','This application uses the jQuery UI Layout plugin to create a layout with columns and rows',1);
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_position',1,1,'jQuery UI position','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.position.min.js','','','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_upload',1,1,'','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../plugins/jq_upload.js','','','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','body',1,1,'body (obligatory)','','body','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','','','','');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','body','favicon','../img/favicon.png','favicon','php_var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','body','popupcss','../css/popup.css','file css','file/css');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','body','tablesortercss','../css/tablesorter.css','file css','file/css');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','body','use_load_message','true','show splash screen while the application is loading','php_var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','body','jq_ui_theme','../extensions/jquery-ui-1.7.2.custom/css/smoothness/jquery-ui-1.7.2.custom.css','UI Theme from Themeroller','file/css');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','body','includeWhileLoading','../include/mapbender_logo_splash.php','show splash screen while the application is loading','php_var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui',1,1,'jQuery UI core','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.core.min.js','','','');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','jq_ui','css','../extensions/jquery-ui-1.8.1.custom/css/ui-lightness/jquery-ui-1.8.1.custom.css','','file/css');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_layout',1,1,'This jQuery plugin can create a sophisticated pane layout ','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery.layout.all-1.2.0/jquery.layout.min.js','','','http://layout.jquery-dev.net');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_widget',1,1,'jQuery UI widget','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.widget.min.js','','','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_datatables',1,1,'Includes the jQuery plugin datatables, use like this
+$(selector).datatables(options)','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','../plugins/jq_datatables.js','../extensions/dataTables-1.5/media/js/jquery.dataTables.min.js','','','http://www.datatables.net/');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','jq_datatables','defaultCss','../extensions/dataTables-1.5/media/css/demo_table_jui.css','','file/css');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','i18n',1,1,'Internationalization module, collects data from all elements and sends them to the server in a single POST request. The strings are translated via gettext only.','Internationalization','div','','',NULL ,NULL,NULL ,NULL,NULL ,'','','div','../plugins/mb_i18n.js','','','','http://www.mapbender.org/Gettext');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','toolbar',1,1,'This toolbar appends all its target elements to its container','Toolbar','div','','class=''mb-toolbar'' style=''background:url(../img/Mapbender_logo_and_text_200x50.png) no-repeat 10px 10px''',NULL ,NULL,NULL ,NULL,NULL ,'','','div','../plugins/mb_toolbar.js','','pan1,zoomFull, showCoords_div, featureInfoTunnel,measure_widget','','');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','toolbar','css','.mb-toolbar ul, .mb-toolbar li {
+   display: inline;
+}
+
+.mb-toolbar ul {
+   float: right;
+}
+
+.mb-toolbar li {
+   margin:2px
+}','','text/css');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','pane',2,1,'','','div','','',NULL ,NULL,NULL ,NULL,NULL ,'height:100%;width:100%','','div','../plugins/mb_pane.js','','','jq_layout','http://layout.jquery-dev.net');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','pane','center','mapframe1','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','pane','css','../extensions/jquery.layout.all-1.2.0/jquery.layout.css','','file/css');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','pane','east','','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','pane','layoutOptions','{
+south__minSize:60
+}','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','pane','north','toolbar','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','pane','south','statusBar','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','pane','west','treeGDE','','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','statusBar',2,1,'','','div','','',NULL ,NULL,NULL ,NULL,NULL ,'','','div','','','','','');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','statusBar','displayTarget','statusBar','','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_mouse',2,1,'jQuery UI mouse','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.mouse.min.js','','jq_ui_widget','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','doubleclickZoom',2,1,'adds doubleclick zoom to map module (target).
+Deactivates the browser contextmenu!!!','Doubleclick zoom','div','','',NULL ,NULL,NULL ,NULL,NULL ,'','','div','mod_doubleclickZoom.js','','mapframe1','','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','showCoords_div',2,1,'displays coodinates by onmouseover','Koordinaten anzeigen','img','../img/button_blue_red/coords_off.png','onmouseover = "mb_regButton(''init_mod_showCoords_div'')" ',NULL ,NULL,NULL ,NULL,1,'','','','mod_coords_div.php','','mapframe1','','http://www.mapbender.org/index.php/ShowCoords_div');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','showCoords_div','displayTarget','statusBar','','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','zoomFull',2,1,'zoom to full extent button','gesamte Karte anzeigen','img','../img/button_blue_red/zoomFull_off.png','',NULL ,NULL,NULL ,NULL,2,'','','','mod_zoomFull.js','','mapframe1','','http://www.mapbender.org/index.php/ZoomFull');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','featureInfoTunnel',2,1,'FeatureInfoRequest with local path','Query','img','../img/button_blue_red/query_off.png','onmouseover = "mb_regButton(''init_featureInfoTunnel'')"',NULL ,NULL,NULL ,NULL,1,'','','','mod_featureInfoTunnel.php','popup.js','mapframe1','','http://www.mapbender.org/index.php/FeatureInfoTunnel');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','featureInfoTunnel','featureInfoLayerPopup','true','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','featureInfoTunnel','featureInfoPopupHeight','300','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','featureInfoTunnel','featureInfoPopupPosition','[100,100]','position of the featureInfoPopup','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','featureInfoTunnel','featureInfoPopupWidth','340','','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','pan1',2,1,'pan','Pan','img','../img/button_blue_red/pan_off.png','',NULL ,NULL,NULL ,NULL,1,'','','','mod_pan.js','','mapframe1','','http://www.mapbender.org/index.php/Pan');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','measure_widget',2,1,'Measure','Measure distance','img','../img/button_blue_red/measure_off.png','',NULL ,NULL,NULL ,NULL,1,'','','','../plugins/mb_measure_widget.php','../widgets/w_measure.js,../extensions/RaphaelJS/raphael-1.4.7.min.js','mapframe1','jq_ui_dialog,jq_ui_widget','http://www.mapbender.org/index.php/Measure');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','lineStrokeDefault','#C9F','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','lineStrokeSnapped','#F30','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','lineStrokeWidthDefault','3','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','lineStrokeWidthSnapped','5','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','measurePointDiameter','7','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','opacity','0.4','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','pointFillDefault','#CCF','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','pointFillSnapped','#F90','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','polygonFillDefault','#FFF','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','polygonFillSnapped','#FC3','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','polygonStrokeWidthDefault','1','','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','measure_widget','polygonStrokeWidthSnapped','5','','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','treeGDE',2,1,'new treegde2 - directory tree, checkbox for visible, checkbox for querylayer
+for more infos have a look at http://www.mapbender.org/index.php/TreeGDE2','Karten','div','','class="ui-widget"',NULL ,NULL,NULL ,NULL,NULL ,'visibility:visible;overflow:scroll','','div','../html/mod_treefolderPlain.php','jsTree.js','mapframe1','mapframe1','http://www.mapbender.org/index.php/TreeGde');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','menu','opacity_up,opacity_down,zoom,hide,wms_up,wms_down,layer_up,layer_down,remove','context menu elements','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','alerterror','true','alertbox for wms loading error','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','ficheckbox','true','checkbox for featureInfo requests','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','imagedir','../img/tree_new','image directory','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','showstatus','true','show status in folderimages','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','switchwms','true','enables/disables all layer of a wms','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','metadatalink','false','link for layer-metadata','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','wmsbuttons','false','wms management buttons','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','css','../css/treeGDE2.css','','file/css');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','treeGDE','openfolder','0','initial open folder','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','mapframe1',3,1,'frame for a map','','div','','',NULL ,NULL,NULL ,NULL,2,'overflow:hidden;background-color:#ffffff','','div','../plugins/mb_map.js','../../lib/history.js,map_obj.js,map.js,wms.js,wfs_obj.js,initWmcObj.php','','','http://www.mapbender.org/index.php/Mapframe');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','mapframe1','skipWmsIfSrsNotSupported','0','if set to 1, it skips the WMS request if the current SRS is not supported by the WMS; if set to 0, the WMS is always queried. Default is 0, because of backwards compatibility','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','mapframe1','slippy','1','1 = Activates an animated, pseudo slippy map','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','mapframe1_mousewheelZoom',4,1,'adds mousewheel zoom to map module (target)','Mousewheel zoom','div','','',NULL ,NULL,NULL ,NULL,NULL ,'','','div','mod_mousewheelZoom.js','../extensions/jquery.mousewheel.min.js','mapframe1','','');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','mapframe1_mousewheelZoom','factor','2','The factor by which the map is zoomed on each mousewheel unit','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_droppable',4,1,'jQuery UI droppable','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.droppable.min.js','','jq_ui,jq_ui_widget,jq_ui_mouse,jq_ui_draggable','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_button',4,1,'jQuery UI button','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.button.min.js','','jq_ui,jq_ui_widget','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','mapframe1_zoomBar',4,1,'zoom bar - slider to handle navigation, define zoom level with an element var','Zoom to scale','div','','',30,100,NULL ,200,100,'','','div','../plugins/mb_zoomBar.js','','mapframe1','mapframe1, jq_ui_slider','');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','mapframe1_zoomBar','defaultLevel','1','define the default level for application start','var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('layout_with_map_and_toolbar','mapframe1_zoomBar','level','[2500,5000,10000,50000,100000,500000,1000000,3000000,5000000,10000000]','define an array of levels for the slider (element_var has to be defined)','var');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','mapframe1_navigation',4,1,'Adds navigation arrows on top of the map','Navigation','div','','',20,30,NULL ,NULL,100,'','','div','../plugins/mb_navigation.js','','mapframe1','mapframe1','http://www.mapbender.org/Navigation');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_slider',5,1,'slider from the jQuery UI framework','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.slider.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_draggable',5,1,'Draggable from the jQuery UI framework','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.draggable.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','http://jqueryui.com/demos/draggable/');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_dialog',5,1,'Dialog from jQuery UI framework','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.dialog.min.js','','jq_ui,jq_ui_widget,jq_ui_button,jq_ui_draggable,jq_ui_mouse,jq_ui_position,jq_ui_resizable','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_resizable',5,1,'Resizable from the jQuery UI framework','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','../plugins/jq_ui_resizable.js','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.resizable.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('layout_with_map_and_toolbar','jq_ui_tabs',5,1,'horizontal tabs from the jQuery UI framework','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.tabs.min.js','','jq_ui,jq_ui_widget','');
+
+--demis 
+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 
+'layout_with_map_and_toolbar', 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 = 'gui' AND fkey_wms_id = 250);
+
+
+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 
+'layout_with_map_and_toolbar', 
+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 = 'gui' AND gui_layer_wms_id = 250);
+
+-------------
+--germany
+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 
+'layout_with_map_and_toolbar', fkey_wms_id, 1, 
+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 = 'gui' AND fkey_wms_id = 893);
+
+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 
+'layout_with_map_and_toolbar', 
+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 = 'gui' AND gui_layer_wms_id = 893);
+
+INSERT into gui_mb_user (fkey_gui_id , fkey_mb_user_id , mb_user_type) VALUES ('layout_with_map_and_toolbar',1,'owner');
+
+INSERT into gui_gui_category VALUES ('layout_with_map_and_toolbar', 2);
+--
+--
+--
+--Insert Template layout_with_map_and_toolbar END
+--
+
+DELETE FROM gui_element where fkey_gui_id = 'admin1' AND e_id = 'CreateTreeGDE';
+

More information about the Mapbender_commits mailing list