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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-02-10 03:16:01 -0800 (Thu, 10 Feb 2011)
New Revision: 7551

Modified:
   trunk/mapbender/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: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-02-10 11:08:15 UTC (rev 7550)
+++ trunk/mapbender/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)
@@ -117,13 +117,21 @@
 $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' 
@@ -132,4 +140,4 @@
 --
 --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';