1 -- @tag: customer_add_constraints
2 -- @description: Zusätzliche Fremdschlüssel für Sprache, Kundentyp und Zahlungskonditionen
3 -- @depends: release_2_6_3
7 -- verwaiste Zahlungsbedingungen vorher entfernen:
8 update customer set payment_id = NULL where payment_id not in (select id from payment_terms);
10 ALTER TABLE customer ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id);
11 ALTER TABLE customer ADD FOREIGN KEY (language_id) REFERENCES language (id);
12 ALTER TABLE customer ADD FOREIGN KEY (business_id) REFERENCES business (id);