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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2011-07-13 05:34:18 -0700 (Wed, 13 Jul 2011)
New Revision: 7934

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 update_frequency

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 12:32:25 UTC (rev 7933)
+++ 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:34:18 UTC (rev 7934)
@@ -98,3 +98,9 @@
 --
 ALTER TABLE mb_metadata ADD COLUMN responsible_party_name character varying(100);
 
+-- ALTER TABLE mb_metadata DROP COLUMN update_frequency;
+-- mb_metadata
+-- new column update_frequency
+
+ALTER TABLE mb_metadata ADD COLUMN update_frequency character varying(100);
+