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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2015-08-20 01:33:45 -0700 (Thu, 20 Aug 2015)
New Revision: 9279

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
2 new columns for using mapbender ac geoportal

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-08-18 11:24:42 UTC (rev 9278)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2015-08-20 08:33:45 UTC (rev 9279)
@@ -597,3 +597,21 @@
 
 ALTER TABLE mb_metadata ALTER column uuid type varchar(300);
 ALTER TABLE mb_metadata ALTER column link type varchar(400);
+
+ALTER TABLE mb_user ADD COLUMN mb_user_newsletter boolean;
+ALTER TABLE mb_user ALTER COLUMN mb_user_newsletter SET DEFAULT false;
+
+-- Column: mb_user_allow_survey
+
+-- ALTER TABLE mb_user DROP COLUMN mb_user_allow_survey;
+
+ALTER TABLE mb_user ADD COLUMN mb_user_allow_survey boolean;
+ALTER TABLE mb_user ALTER COLUMN mb_user_allow_survey SET DEFAULT false;
+
+-- Initialize values
+UPDATE mb_user SET mb_user_newsletter = true WHERE mb_user_newsletter IS NULL;
+UPDATE mb_user SET mb_user_allow_survey = true WHERE mb_user_allow_survey IS NULL;
+
+
+
+