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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2014-05-26 05:37:48 -0700 (Mon, 26 May 2014)
New Revision: 8908

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Update mb_user_wmc to allow management of metadata for integrated geoJSON objects

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	2014-05-26 12:32:42 UTC (rev 8907)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-05-26 12:37:48 UTC (rev 8908)
@@ -441,4 +441,28 @@
 ALTER TABLE search_wms_view
   OWNER TO postgres;
 
+-- Column: wmc_local_data_public
 
+-- ALTER TABLE mb_user_wmc DROP COLUMN wmc_local_data_public;
+
+ALTER TABLE mb_user_wmc ADD COLUMN wmc_local_data_public integer;
+UPDATE mb_user_wmc SET wmc_local_data_public = 0 WHERE wmc_local_data_public IS NULL;
+ALTER TABLE mb_user_wmc ALTER COLUMN wmc_local_data_public SET DEFAULT 0;
+
+-- Column: wmc_local_data_size
+
+-- ALTER TABLE mb_user_wmc DROP COLUMN wmc_local_data_size;
+
+ALTER TABLE mb_user_wmc ADD COLUMN wmc_local_data_size varchar(50);
+UPDATE mb_user_wmc SET wmc_local_data_size = '0' WHERE wmc_local_data_size IS NULL;
+ALTER TABLE mb_user_wmc ALTER COLUMN wmc_local_data_size SET DEFAULT '0';
+
+-- Column: wmc_has_local_data
+
+-- ALTER TABLE mb_user_wmc DROP COLUMN wmc_has_local_data;
+
+ALTER TABLE mb_user_wmc ADD COLUMN wmc_has_local_data integer;
+UPDATE mb_user_wmc SET wmc_has_local_data = 0 WHERE wmc_has_local_data IS NULL;
+ALTER TABLE mb_user_wmc ALTER COLUMN wmc_has_local_data SET DEFAULT 0;
+
+