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