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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-10-19 05:26:18 -0700 (Thu, 19 Oct 2017)
New Revision: 9805

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Add ckan catalogue conf attribute to mb_group table

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-10-09 15:52:00 UTC (rev 9804)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-10-19 12:26:18 UTC (rev 9805)
@@ -2020,3 +2020,9 @@
 --ergänze Eintrag ckan_sync_collection in Target von Element menu_metadata in Administration_DE
 UPDATE gui_element SET e_target = replace(e_target, 'dataset_metadata_collection', 'dataset_metadata_collection,ckan_sync_collection') WHERE fkey_gui_id = 'Administration_DE' AND e_id = 'menu_metadata' AND e_target = 'dataset_metadata_collection';
 
+-- Column: mb_group_ckan_catalogues
+
+-- ALTER TABLE mb_group DROP COLUMN mb_group_ckan_catalogues;
+
+ALTER TABLE mb_group ADD COLUMN mb_group_ckan_catalogues text;
+