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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2012-02-10 04:53:41 -0800 (Fri, 10 Feb 2012)
New Revision: 8240

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
layer_style and gui_layer changed column to handle longer values

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-02-09 07:01:31 UTC (rev 8239)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-02-10 12:53:41 UTC (rev 8240)
@@ -194,3 +194,10 @@
 gui_element.fkey_gui_id
 NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'legend' AND var_name = 'reverse');
 
+--
+-- change datatype from 50 to 256 to handle longer style names
+--
+ALTER TABLE layer_style ALTER COLUMN name TYPE character varying(256);
+ALTER TABLE gui_layer ALTER COLUMN gui_layer_style TYPE character varying(256);
+
+