[Mapbender_dev] [Mapbender] #813: Clean 'layer_load_count'

[Mapbender]

#813: Clean 'layer_load_count'
-------------------------------------------+--------------------------------
 Reporter:  frankjaeger                    |       Owner:  dev          
     Type:  defect                         |      Status:  new          
 Priority:  minor                          |   Milestone:  2.7.2 release
Component:  database                       |     Version:  2.7.1        
 Keywords:  Foreign-Key, layer_load_count  |  
-------------------------------------------+--------------------------------
 File:
 /resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql

 Line 2688:

 The forein key cannot be built, when 'layer_load_count' has Layer-IDs that
 has been deletet in table 'layer'.

 Insert before:

 {{{
   DELETE
   FROM layer_load_count
   WHERE not exists
   ( SELECT layer.layer_id
     FROM layer
     WHERE layer_load_count.fkey_layer_id = layer.layer_id );
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/mapbender/ticket/813>
Mapbender <http://www.mapbender.org/>
Mapbender