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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-08-01 02:54:15 -0700 (Tue, 01 Aug 2017)
New Revision: 9757

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
New possibility to store some information about external csw catalogues for each mapbender group. It is be used to sync distributed ckan installations.

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-07-27 16:14:27 UTC (rev 9756)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-08-01 09:54:15 UTC (rev 9757)
@@ -2003,3 +2003,10 @@
   ON json_schema
   FOR EACH ROW
   EXECUTE PROCEDURE update_json_schema_updated_column();
+
+-- Column: mb_group_csw_catalogues
+
+-- ALTER TABLE mb_group_csw_catalogues DROP COLUMN mb_group_csw_catalogues;
+
+ALTER TABLE mb_group ADD COLUMN mb_group_csw_catalogues text;
+