Revision 6f266e92
Von Moritz Bunkus vor etwa 12 Jahren hinzugefügt
| sql/Pg-upgrade2/orderitems_delivery_order_items_invoice_foreign_keys.sql | ||
|---|---|---|
|
UPDATE delivery_order_items SET project_id = NULL WHERE project_id NOT IN (SELECT id FROM project);
|
||
|
UPDATE invoice SET project_id = NULL WHERE project_id NOT IN (SELECT id FROM project);
|
||
|
|
||
|
DELETE FROM orderitems WHERE trans_id NOT IN (SELECT id FROM oe);
|
||
|
|
||
|
ALTER TABLE orderitems ADD FOREIGN KEY (trans_id) REFERENCES oe (id);
|
||
|
ALTER TABLE orderitems ADD FOREIGN KEY (project_id) REFERENCES project (id);
|
||
|
ALTER TABLE orderitems ADD FOREIGN KEY (pricegroup_id) REFERENCES pricegroup (id);
|
||
Auch abrufbar als: Unified diff
Vor Fremdschlüsselzuweisung trans_id verwaiste Einträge in orderitems löschen