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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2015-11-23 02:39:59 -0800 (Mon, 23 Nov 2015)
New Revision: 9304

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Option to store a uuid for each wmc in db

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	2015-11-19 06:10:25 UTC (rev 9303)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2015-11-23 10:39:59 UTC (rev 9304)
@@ -650,3 +650,10 @@
 DROP TABLE IF EXISTS dataset_search_table;
 SELECT * INTO dataset_search_table FROM search_dataset_view;
 
+-- Column: uuid
+
+-- ALTER TABLE mb_user_wmc DROP COLUMN uuid;
+
+ALTER TABLE mb_user_wmc ADD COLUMN uuid uuid;
+
+