[Mapbender-commits] r7441 - trunk/mapbender/resources/db

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2011-01-13 08:32:07 -0800 (Thu, 13 Jan 2011)
New Revision: 7441

Modified:
   trunk/mapbender/resources/db/materialize_wms_view.sql
Log:
Bugfix - some resources have never been loaded - therefor the load_count have to be 0 not NULL

Modified: trunk/mapbender/resources/db/materialize_wms_view.sql
===================================================================
--- trunk/mapbender/resources/db/materialize_wms_view.sql	2011-01-13 16:27:23 UTC (rev 7440)
+++ trunk/mapbender/resources/db/materialize_wms_view.sql	2011-01-13 16:32:07 UTC (rev 7441)
@@ -5,6 +5,8 @@
 
 ALTER TABLE wms_search_table_tmp RENAME TO  wms_search_table;
 
+UPDATE wms_search_table SET load_count=0 WHERE load_count is NULL;
+
 -- Index: gist_wst_the_geom
 
 -- DROP INDEX gist_wst_the_geom;