X-Git-Url: http://git.inspyration.org/?a=blobdiff_plain;f=sql%2Fclean-model.sql;h=59b492aab2da69a2ee3b4a0897fed73e08a0093d;hb=26a58b22f29fc94d98fac14391b8f98b186aa38c;hp=9d1f2a8fb79ccd7e8bded745c05f6c533d35d4b2;hpb=114872c3d74749377097df4ac5974989a3606288;p=odoo%2Fodoo.git

diff --git a/sql/clean-model.sql b/sql/clean-model.sql
index 9d1f2a8..59b492a 100644
--- a/sql/clean-model.sql
+++ b/sql/clean-model.sql
@@ -4,6 +4,21 @@ SELECT model, res_id, module FROM ir_model_data
 	  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