[MERGE]

bzr revid: hmo@tinyerp.com-20091126063020-6kuq4ph29esf0fwe

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/clean-model.sql b/sql/clean-model.sql
new file mode 100644
index 00000000000..59b492aab2d
--- /dev/null
+++ b/sql/clean-model.sql
@@ -0,0 +1,24 @@
+
+SELECT model, res_id, module FROM ir_model_data 
+	WHERE model = 'ir.actions.act_window' 
+	  AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id);
+
+
+SELECT model, res_id, module FROM ir_model_data 
+	WHERE model = 'ir.ui.menu' 
+	  AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id);
+
+SELECT model, res_id, module FROM ir_model_data 
+	WHERE model = 'ir.ui.view' 
+	  AND NOT EXISTS (SELECT 1 FROM ir_ui_view WHERE id = ir_model_data.res_id);
+
+DONT DELETE FROM ir_model_data 
+	WHERE model = 'ir.actions.act_window' 
+	  AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id);
+	  
+DONT DELETE FROM ir_model_data 
+	WHERE model = 'ir.ui.menu' 
+	  AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id);
+-- Other cleanups:
+-- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.view' AND NOT EXISTS( SELECT 1 FROM ir_ui_view WHERE ir_ui_view.id = ir_model_data.res_id);
+-- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.menu' AND NOT EXISTS( SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id);
\ No newline at end of file