diff options
| author | P. Christeas <p_christ@hol.gr> | 2009-01-16 10:53:14 +0200 |
|---|---|---|
| committer | P. Christeas <p_christ@hol.gr> | 2009-01-16 10:53:14 +0200 |
| commit | 114872c3d74749377097df4ac5974989a3606288 (patch) | |
| tree | e7ee7206f5ad305249344b88fbb1556d643ecce0 /sql/clean-model.sql | |
| parent | f97bae5c3e98ae91a30397a1927144c3f22f4d80 (diff) | |
Some more example queries for SQL data clean.
bzr revid: p_christ@hol.gr-20090116085314-xktvy3v7i5y5a0z6
Diffstat (limited to 'sql/clean-model.sql')
| -rw-r--r-- | sql/clean-model.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/sql/clean-model.sql b/sql/clean-model.sql index 7328f6b4909..9d1f2a8fb79 100644 --- a/sql/clean-model.sql +++ b/sql/clean-model.sql @@ -1,4 +1,9 @@ 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);
\ No newline at end of file + AND NOT EXISTS (SELECT 1 FROM ir_act_window 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 |