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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2013-10-24 03:29:48 -0700 (Thu, 24 Oct 2013)
New Revision: 8732

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
for backwards-compatibility

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	2013-10-24 10:21:49 UTC (rev 8731)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2013-10-24 10:29:48 UTC (rev 8732)
@@ -1,5 +1,5 @@
 -- new file for db changes to 2.8.0
 -- new option to allow edited categories to be overwritten by service information (wms 1.3.0 - layer categories) 
 ALTER TABLE scheduler ADD COLUMN scheduler_overwrite_categories integer;
-
-
+-- for those who have already used the scheduler ;-)
+UPDATE scheduler SET scheduler_overwrite_categories = 0 WHERE scheduler_overwrite_categories IS NULL;