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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2010-12-20 03:31:10 -0800 (Mon, 20 Dec 2010)
New Revision: 7340

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
* fees TYPE text instead of varchar(255)
* coordsLookup - refer to php instead of js

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-17 16:54:42 UTC (rev 7339)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-12-20 11:31:10 UTC (rev 7340)
@@ -2818,7 +2818,7 @@
 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 ('gui','coordsLookup',
 10,1,'','Coordinate lookup','div','','',1,1,NULL ,NULL ,NULL ,
-'z-index:9999;visibility:hidden','','div','mod_coordsLookup.js','',
+'z-index:9999;visibility:hidden','','div','mod_coordsLookup.php','',
 'mapframe1','','http://www.mapbender.org/coordsLookup');
 INSERT INTO gui_element_vars (fkey_gui_id, fkey_e_id, var_name,
 var_value, context, var_type) VALUES ('gui', 'coordsLookup',
@@ -2829,6 +2829,7 @@
 '' ,'var');
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui', 'tabs', 'tab_frameHeight[7]', '240', '' ,'var');
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui', 'tabs', 'tab_ids[7]', 'coordsLookup', '' ,'php_var');
+Update gui_element set e_js_file = 'mod_coordsLookup.php' where  e_id = 'coordsLookup';
 
 
 
@@ -3529,4 +3530,10 @@
 Delete from wms where wms_id = 883 AND wms_title LIKE 'SICAD/SD-IMS V5.1-Luftbilder';
 Delete from wms where wms_id = 902 AND wms_title LIKE 'DNM 100/2';
 Delete from wms where wms_id = 843 AND wms_title LIKE 'WMS Map Server';
-Delete from wms where wms_id = 904 AND wms_title LIKE 'DNM 250/2';
\ No newline at end of file
+Delete from wms where wms_id = 904 AND wms_title LIKE 'DNM 250/2';
+
+--
+-- fee - changed colum datatype to text
+--
+ALTER TABLE wms ALTER COLUMN fees TYPE text;
+ALTER TABLE wfs ALTER COLUMN fees TYPE text;