Database-cleaning-script

From MapbenderWiki

Jump to: navigation, search
  • Script cleans Mapbender 2.4.1 installations from spurious and obsolete data
Marco Lechner und Steffen Vogt, 2007-06-08, Physical Geography, Uni Freiburg 
DELETE FROM layer WHERE NOT EXISTS (SELECT * FROM wms WHERE layer.fkey_wms_id = wms.wms_id); 
DELETE FROM layer_epsg WHERE NOT EXISTS (SELECT * FROM layer WHERE layer_epsg.fkey_layer_id = layer.layer_id); 
DELETE FROM gui_element_vars WHERE NOT EXISTS (SELECT * FROM gui_element 
WHERE (gui_element_vars.fkey_gui_id =  gui_element.fkey_gui_id) AND (gui_element_vars.fkey_e_id = gui_element.e_id )); 
DELETE FROM layer_style WHERE NOT EXISTS (SELECT * FROM layer WHERE layer_style.fkey_layer_id = layer.layer_id); 
DELETE FROM gui_layer WHERE NOT EXISTS (SELECT * FROM layer WHERE gui_layer.fkey_layer_id = layer.layer_id); 
DELETE FROM wms_format WHERE NOT EXISTS (SELECT * FROM wms WHERE wms_format.fkey_wms_id = wms.wms_id); 
DELETE FROM wms_srs WHERE NOT EXISTS (SELECT * FROM wms WHERE wms_srs.fkey_wms_id = wms.wms_id);
Retrieved from "http://www.mapbender.org/Database-cleaning-script"
Personal tools