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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2016-12-29 06:26:01 -0800 (Thu, 29 Dec 2016)
New Revision: 9631

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Database adoption to allow syncing of ckan > 2.5 (mapbender groups will be mapped to ckan organizations!)

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	2016-12-29 14:20:55 UTC (rev 9630)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2016-12-29 14:26:01 UTC (rev 9631)
@@ -1526,3 +1526,8 @@
 
 ALTER TABLE wfs_service_metadata
   OWNER TO postgres;
+
+--New columns to sync metadata to arbitrary ckan instances
+ALTER TABLE mb_group ADD COLUMN mb_group_ckan_uuid uuid;
+ALTER TABLE mb_group ADD COLUMN mb_group_ckan_api_key uuid;
+