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

Mon Jun 20 06:43:12 PDT 2016

Author: armin11
Date: 2016-06-20 06:43:11 -0700 (Mon, 20 Jun 2016)
New Revision: 9524

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
SQL for catalogue maintenance tools

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-06-20 13:28:48 UTC (rev 9523)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2016-06-20 13:43:11 UTC (rev 9524)
@@ -1133,5 +1133,35 @@
 ALTER TABLE search_dataset_view
   OWNER TO postgres;
 
+--maintenance tools for catalogue
 
+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('PortalAdmin_DE','Start_Monitor_for_WMS',2,1,'Start Monitor for WMS','Start Monitor for WMS','a','','href = "../php/mod_catalogueMaintenance.php?sessionID&resourceType=wms&maintenanceFunction=monitor"',80,15,210,20,5,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','Start Monitor for WMS','a','','','','','http://www.mapbender.org/');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('PortalAdmin_DE', 'Start_Monitor_for_WMS', 'file css', '../css/administration_alloc.css', 'file 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('PortalAdmin_DE','Start_Monitor_for_WMS_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',0,160,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','Start_Monitor_for_WMS,Start_Monitor_for_WMS_icon','','');
+
+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('PortalAdmin_DE','Start_Monitor_for_WMS_icon',2,1,'icon','','img','../img/gnome/system-run.png','',0,0,NULL ,NULL ,2,'','','','','','','','');
+
+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('PortalAdmin_DE','reindexDATASET',2,1,'Reindex search DATASET','Reindex search DATASET','a','','href = "../php/mod_catalogueMaintenance.php?sessionID&resourceType=dataset&maintenanceFunction=reindex"',80,15,210,20,5,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','Reindex search DATASET','a','','','','','http://www.mapbender.org/');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('PortalAdmin_DE', 'reindexDATASET', 'file css', '../css/administration_alloc.css', 'file 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('PortalAdmin_DE','reindexDATASET_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',0,120,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','reindexDATASET,reindexDATASET_icon','','');
+
+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('PortalAdmin_DE','reindexDATASET_icon',2,1,'icon','','img','../img/gnome/system-run.png','',0,0,NULL ,NULL ,2,'','','','','','','','');
+
+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('PortalAdmin_DE','reindexWFS',2,1,'Reindex search WFS','Reindex search WFS','a','','href = "../php/mod_catalogueMaintenance.php?sessionID&resourceType=wfs&maintenanceFunction=reindex"',80,15,210,20,5,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','Reindex search WFS','a','','','','','http://www.mapbender.org/');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('PortalAdmin_DE', 'reindexWFS', 'file css', '../css/administration_alloc.css', 'file 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('PortalAdmin_DE','reindexWFS_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',0,80,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','reindexWFS,reindexWFS_icon','','');
+
+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('PortalAdmin_DE','reindexWFS_icon',2,1,'icon','','img','../img/gnome/system-run.png','',0,0,NULL ,NULL ,2,'','','','','','','','');
+
+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('PortalAdmin_DE','reindexWMS',2,1,'Reindex search WMS','Reindex search WMS','a','','href = "../php/mod_catalogueMaintenance.php?sessionID&resourceType=wms&maintenanceFunction=reindex"',80,15,210,20,5,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','Reindex search WMS','a','','','','','http://www.mapbender.org/');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('PortalAdmin_DE', 'reindexWMS', 'file css', '../css/administration_alloc.css', 'file 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('PortalAdmin_DE','reindexWMS_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',0,40,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','reindexWMS,reindexWMS_icon','','');
+
+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('PortalAdmin_DE','reindexWMS_icon',2,1,'icon','','img','../img/gnome/system-run.png','',0,0,NULL ,NULL ,2,'','','','','','','','');
+
+UPDATE gui_element SET e_target = 'editMaintenance_collection, reindexWMS_collection,reindexWFS_collection,reindexDATASET_collection,Start_Monitor_for_WMS_collection' WHERE fkey_gui_id = 'PortalAdmin_DE' AND e_id = 'menu_maintenance';
+

