diff options
| author | xrg <> | 2009-11-20 20:01:04 +0530 |
|---|---|---|
| committer | Harry (Open ERP) <hmo@tinyerp.com> | 2009-11-20 20:01:04 +0530 |
| commit | dad1ff955b636ccbad687f2f3f731ee8f512bd6f (patch) | |
| tree | e3405d96ef59f72094e5e300db24fb713e2b8838 /sql/clean-model.sql | |
| parent | b2a9a804ebf6c93ebe98751dd6b1008b8fe09306 (diff) | |
| parent | f566ea57a83bab87a8c7fa9743d190b4520c89e2 (diff) | |
[merge] merge from lp:~xrg/openobject-server/optimize-5.0 and removed some confilts
bzr revid: hmo@tinyerp.com-20091120143104-tb6136unkdw7yfy9
Diffstat (limited to 'sql/clean-model.sql')
| -rw-r--r-- | sql/clean-model.sql | 24 |
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 |