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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-07-08 00:30:17 -0700 (Fri, 08 Jul 2011)
New Revision: 7919

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
Log:
new column for mb_metadata responsible_party_name

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-07-08 07:29:28 UTC (rev 7918)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-07-08 07:30:17 UTC (rev 7919)
@@ -107,4 +107,11 @@
 SELECT gui_element.fkey_gui_id, 'printPDF', 'logType', 'file', 'log mode can be set to file or db' ,'php_var'
 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 = 'logType' AND fkey_e_id = 'printPDF');
\ No newline at end of file
+WHERE var_name = 'logType' AND fkey_e_id = 'printPDF');
+
+
+--
+-- mb_metadata
+-- new column responsible_party_name
+-- 
+ALTER TABLE mb_metadata ADD COLUMN responsible_party_name character varying(100);