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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2010-03-14 10:07:57 -0400 (Sun, 14 Mar 2010)
New Revision: 5755

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
changed sql statements for inserting standard gui gui_wfs_conf entries for search

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-03-12 16:52:24 UTC (rev 5754)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-03-14 14:07:57 UTC (rev 5755)
@@ -1328,9 +1328,16 @@
 --INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES(
 --'gui_digitize', 'body', 'print_css', '../css/print_div.css', '' ,'file/css');
 
--- gui_wfs_conf entries for search
-INSERT INTO gui_wfs_conf (fkey_gui_id, fkey_wfs_conf_id) VALUES ('gui', 1);
-INSERT INTO gui_wfs_conf (fkey_gui_id, fkey_wfs_conf_id) VALUES ('gui2', 1);
+-- standard gui gui_wfs_conf entries for search
+INSERT INTO  gui_wfs_conf(fkey_gui_id, fkey_wfs_conf_id) 
+SELECT 'gui',wfs_conf_id from wfs_conf WHERE wfs_conf_id = 1 
+AND wfs_conf_id
+NOT IN (SELECT fkey_wfs_conf_id FROM gui_wfs_conf WHERE fkey_gui_id = 'gui');
 
+INSERT INTO  gui_wfs_conf(fkey_gui_id, fkey_wfs_conf_id) 
+SELECT 'gui2',wfs_conf_id from wfs_conf WHERE wfs_conf_id = 1 
+AND wfs_conf_id
+NOT IN (SELECT fkey_wfs_conf_id FROM gui_wfs_conf WHERE fkey_gui_id = 'gui2');
+
 -- remove obsolete attributes from savewmc
 UPDATE gui_element SET e_attributes = '' WHERE e_id = 'savewmc';