I want to manually clean my database (Odoo V7). Reason: There are some products, I want to get rid of and deleting products is impossible via UI if they are used at least one time. Therefore, I would like to interchange product_id of account_invoice_line with another one. My problem is, that I do not know what are the dependencies to other tables when doing that.
What I have just tried, is do do:
alter table account_invoice_line disable trigger all
update account_invoice_line set product_id = 100 where product_id = 2
I am familiar with SQL, that is not problem - but I do not know if this change is enough as I can estimate the dependencies to other models. Could anybody guide me in clearing my database of undesired products already used?