diff options
| author | Vo Minh Thu <vmt@openerp.com> | 2011-10-03 17:35:09 +0200 |
|---|---|---|
| committer | Vo Minh Thu <vmt@openerp.com> | 2011-10-03 17:35:09 +0200 |
| commit | d9b6f5e2d0d0c30e4e55bc72454b6ec4b720232c (patch) | |
| tree | 14eb229c961e3413abd06b6ad1a86d64d2d3a2ab /history/clean-model.sql | |
| parent | fbb6e5e56aaf36ff652edbec0181a0fcb95a3601 (diff) | |
| parent | bf3d0d604c89edfd709603c8ca261d020e9ac748 (diff) | |
[MERGE] merged trunk.
bzr revid: vmt@openerp.com-20111003153509-8mbfg1t8hm92pult
Diffstat (limited to 'history/clean-model.sql')
| -rw-r--r-- | history/clean-model.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/history/clean-model.sql b/history/clean-model.sql new file mode 100644 index 00000000000..59b492aab2d --- /dev/null +++ b/history/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 |