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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2013-03-26 08:07:44 -0700 (Tue, 26 Mar 2013)
New Revision: 8590

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
Log:
Possibility to store admin lavel info (e.g. NUTS) at mb group object

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2013-03-26 15:03:39 UTC (rev 8589)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2013-03-26 15:07:44 UTC (rev 8590)
@@ -81,3 +81,12 @@
 -- add new element vars for resizemapSize to gui2
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui2', 'resizeMapsize', 'max_height', '700', 'define a max mapframe width (units pixel) f.e. 700 or false' ,'var');
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui2', 'resizeMapsize', 'max_width', '700', 'define a max mapframe width (units pixel) f.e. 700 or false' ,'var');
+
+-- Column: mb_group_admin_code
+
+-- ALTER TABLE mb_group DROP COLUMN mb_group_admin_code;
+-- e.g. NUTS 1 (federal state), NUTS 2, NUTS 3, LAU 1, LAU 2 - for european use case
+
+ALTER TABLE mb_group ADD COLUMN mb_group_admin_code character varying(255);
+ALTER TABLE mb_group ALTER COLUMN mb_group_admin_code SET DEFAULT ''::character varying;
+