diff options
| author | P. Christeas <p_christ@hol.gr> | 2009-01-26 22:27:21 +0200 |
|---|---|---|
| committer | P. Christeas <p_christ@hol.gr> | 2009-01-26 22:27:21 +0200 |
| commit | 3b59f2eed07b9dac16dc01c789215fc03c445c25 (patch) | |
| tree | 557f31c13d63e0476331962d85fcfc238aa051c1 /sql | |
| parent | 1f6278b32c2e675bcf316478ca0f0f886be14721 (diff) | |
Better sql cleaners.
bzr revid: p_christ@hol.gr-20090126202721-txt4sh40tbid59ae
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/clean-model.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/clean-model.sql b/sql/clean-model.sql index 9d1f2a8fb79..59b492aab2d 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 |