[Mapbender-commits] r7438 - trunk/mapbender/resources/db

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2011-01-12 05:52:15 -0800 (Wed, 12 Jan 2011)
New Revision: 7438

Added:
   trunk/mapbender/resources/db/materialize_wms_view.sql
Modified:
   trunk/mapbender/resources/db/new_admin_gui.sql
Log:
Some changes from geoportal.rlp

Added: trunk/mapbender/resources/db/materialize_wms_view.sql
===================================================================
--- trunk/mapbender/resources/db/materialize_wms_view.sql	                        (rev 0)
+++ trunk/mapbender/resources/db/materialize_wms_view.sql	2011-01-12 13:52:15 UTC (rev 7438)
@@ -0,0 +1,68 @@
+select * into wms_search_table_tmp from search_wms_view;
+
+
+DROP TABLE wms_search_table;
+
+ALTER TABLE wms_search_table_tmp RENAME TO  wms_search_table;
+
+-- Index: gist_wst_the_geom
+
+-- DROP INDEX gist_wst_the_geom;
+
+CREATE INDEX gist_wst_the_geom
+  ON wms_search_table
+  USING gist
+  (the_geom);
+
+-- Index: idx_wst_department
+
+-- DROP INDEX idx_wst_department;
+
+CREATE INDEX idx_wst_department
+  ON wms_search_table
+  USING btree
+  (department);
+-- Index: idx_wst_md_topic_cats
+
+-- DROP INDEX idx_wst_md_topic_cats;
+
+CREATE INDEX idx_wst_md_topic_cats
+  ON wms_search_table
+  USING btree
+  (md_topic_cats);
+-- Index: idx_wst_layer_id
+
+-- DROP INDEX idx_wst_layer_id;
+
+CREATE INDEX idx_wst_layer_id
+  ON wms_search_table
+  USING btree
+  (layer_id);
+
+-- Index: idx_wst_load_count
+
+-- DROP INDEX idx_wst_load_count;
+
+CREATE INDEX idx_wst_load_count
+  ON wms_search_table
+  USING btree
+  (load_count);
+-- Index: idx_wst_searchtext
+
+-- DROP INDEX idx_wst_searchtext;
+
+CREATE INDEX idx_wst_searchtext
+  ON wms_search_table
+  USING btree
+  (searchtext);
+
+-- Index: idx_wst_wms_timestamp
+
+-- DROP INDEX idx_wst_wms_timestamp;
+
+CREATE INDEX idx_wst_wms_timestamp
+  ON wms_search_table
+  USING btree
+  (wms_timestamp);
+--vacuum analyze;
+--VACUUM ANALYZE wms_search_table;

Modified: trunk/mapbender/resources/db/new_admin_gui.sql
===================================================================
--- trunk/mapbender/resources/db/new_admin_gui.sql	2011-01-12 08:49:31 UTC (rev 7437)
+++ trunk/mapbender/resources/db/new_admin_gui.sql	2011-01-12 13:52:15 UTC (rev 7438)
@@ -124,7 +124,7 @@
 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 ('Administration','filteredGroup_User_icon',2,1,'icon','','img','../img/gnome/myGroupUser.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 ('Administration','filteredGui_filteredGroup_icon',2,1,'icon','','img','../img/gnome/myGuiMyGroup.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 ('Administration','filteredGui_filteredGroup_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','','filteredGui_filteredGroup,filteredGui_filteredGroup_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 ('Administration','menu_auth',2,1,'GUI admin menu','Authentication','div','','',NULL ,NULL,NULL ,NULL,NULL ,'','','div','../plugins/mb_div_collection.js','','filteredGui_user_collection,filteredGui_group_collection,filteredGui_filteredGroup_collection','','');
+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 ('Administration','menu_auth',2,1,'GUI admin menu','Authorization','div','','',NULL ,NULL,NULL ,NULL,NULL ,'','','div','../plugins/mb_div_collection.js','','filteredGui_user_collection,filteredGui_group_collection,filteredGui_filteredGroup_collection','','');
 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 ('Administration','jq_ui_mouse',2,1,'jQuery UI mouse','','','','',NULL ,NULL,NULL ,NULL,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/jquery.ui.mouse.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 ('Administration','loadWMS_icon',2,1,'icon','','img','../img/gnome/document-save.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 ('Administration','editGUI_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,120,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','editGUI_WMS,editGUI_WMS_icon','','');