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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2011-07-13 05:32:25 -0700 (Wed, 13 Jul 2011)
New Revision: 7933

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
Log:
add column responsible_party_name

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-07-13 09:20:56 UTC (rev 7932)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-07-13 12:32:25 UTC (rev 7933)
@@ -91,3 +91,10 @@
 FROM gui_element WHERE gui_element.e_id = 'printPDF' AND gui_element.e_js_file = '../plugins/mb_print.php' AND gui_element.fkey_gui_id
 NOT IN (SELECT fkey_gui_id FROM gui_element_vars
 WHERE var_name = 'timeout' AND fkey_e_id = 'printPDF');
+
+--
+-- mb_metadata
+-- new column responsible_party_name
+--
+ALTER TABLE mb_metadata ADD COLUMN responsible_party_name character varying(100);
+