diff options
| author | P. Christeas <p_christ@hol.gr> | 2009-01-14 10:03:35 +0200 |
|---|---|---|
| committer | P. Christeas <p_christ@hol.gr> | 2009-01-14 10:03:35 +0200 |
| commit | f97bae5c3e98ae91a30397a1927144c3f22f4d80 (patch) | |
| tree | f832fefbaf271f5abf0afe147b87febc2de5765a /sql | |
| parent | 50b323cc67b1d9bbb17e2aa9105e9aea3d1a730a (diff) | |
SQL: help script to clean after missing ref data..
In devel environments, db elements get messy. Clean some.
bzr revid: p_christ@hol.gr-20090114080335-xtfb13e3qcekh7fr
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/clean-model.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/clean-model.sql b/sql/clean-model.sql new file mode 100644 index 00000000000..7328f6b4909 --- /dev/null +++ b/sql/clean-model.sql @@ -0,0 +1,4 @@ + +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 |