...
| Codeblock | ||||||
|---|---|---|---|---|---|---|
| ||||||
DELETE FROM ir_translation WHERE name LIKE 'product.template,%' AND COALESCE(res_id,0) > 0 AND res_id NOT IN (SELECT id FROM product_template);
DELETE FROM ir_translation WHERE (name = 'res.partner.title,name' OR name = 'res.partner.title,shortcut') AND res_id > 0; |
| Codeblock | ||||||
|---|---|---|---|---|---|---|
| ||||||
DELETE FROM account_account WHERE user_type = 2 AND type = 'receivable' AND CAST(code as int) > 10000; |
...