1 -- @tag: oe_customer_vendor_fkeys
2 -- @description: Foreign Keys für customer und vendor in oe
3 -- @depends: release_2_6_3
4 -- @timestamp: 1317380460
5 UPDATE oe SET customer_id = NULL WHERE customer_id = 0;
6 UPDATE oe SET vendor_id = NULL WHERE vendor_id = 0;
9 ALTER TABLE oe ADD FOREIGN KEY (customer_id) REFERENCES customer(id);
10 ALTER TABLE oe ADD FOREIGN KEY (vendor_id) REFERENCES vendor(id);