1 -- @tag: vendor_add_constraints
2 -- @description: Zusätzliche Fremdschlüssel für Sprache, Lieferantentyp und Zahlungskonditionen
3 -- @depends: release_2_6_3
7 -- verwaiste Einträge vorher entfernen
8 UPDATE vendor SET payment_id = NULL WHERE payment_id NOT IN (SELECT id FROM payment_terms);
9 UPDATE vendor SET language_id = NULL WHERE language_id NOT IN (SELECT id FROM language);
10 UPDATE vendor SET business_id = NULL WHERE business_id NOT IN (SELECT id FROM business);
12 ALTER TABLE vendor ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id);
13 ALTER TABLE vendor ADD FOREIGN KEY (language_id) REFERENCES language (id);
14 ALTER TABLE vendor ADD FOREIGN KEY (business_id) REFERENCES business (id);