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