[Mapbender-commits] r7552 - branches/2.7/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-02-10 03:19:50 -0800 (Thu, 10 Feb 2011)
New Revision: 7552

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
Log:
define uuid columns as character varying if PostgreSQL version < 8.3

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-02-10 11:16:01 UTC (rev 7551)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-02-10 11:19:50 UTC (rev 7552)
@@ -117,14 +117,27 @@
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE;
 
---new columns with uuids for resources wms, layer, wfs, featuretype - is needed to generate konsistent metadatasets
---you need a postgres >= 8.3 cause the new datatype uuid is used!
+--
+-- new columns with uuids for resources wms, layer, wfs, featuretype - is needed to generate konsistent metadatasets
+-- you need a postgres >= 8.3 cause the new datatype uuid is used!
+-- 
 ALTER TABLE wms ADD COLUMN uuid UUID;
 ALTER TABLE layer ADD COLUMN uuid UUID;
 ALTER TABLE wfs ADD COLUMN uuid UUID;
 ALTER TABLE wfs_featuretype ADD COLUMN uuid UUID;
 
+ALTER TABLE wms ADD COLUMN uuid character varying;
+ALTER TABLE layer ADD COLUMN uuid character varying;
+ALTER TABLE wfs ADD COLUMN uuid character varying;
+ALTER TABLE wfs_featuretype ADD COLUMN uuid character varying;
+
+
+-- enlarge the size of the featureinfo dialog window
+UPDATE gui_element_vars 
+SET var_value = 400 WHERE fkey_gui_id = 'gui1' 
+AND fkey_e_id = 'featureInfo1' AND var_name IN ('featureInfoPopupHeight','featureInfoPopupWidth');
+
 --
 --deactivate OnEarth Web Map Server in gui_digitize 
 --
-UPDATE gui_layer SET gui_layer_visible='0' where fkey_gui_id='gui_digitize' AND gui_layer_wms_id='640';
\ No newline at end of file
+UPDATE gui_layer SET gui_layer_visible='0' where fkey_gui_id='gui_digitize' AND gui_layer_wms_id='640';