X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcustomer_add_constraints.sql;h=65d3386454bd12ec5de385cfb782a307d5d6487b;hb=37ffd321a8511ad03a0ce80bfe5680481767f0e6;hp=6505efdb171e8c608e72292d9f0fc57595c593d7;hpb=b9043da3207903443bc94320b5f5f981f20c3698;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/customer_add_constraints.sql b/sql/Pg-upgrade2/customer_add_constraints.sql
index 6505efdb1..65d338645 100644
--- a/sql/Pg-upgrade2/customer_add_constraints.sql
+++ b/sql/Pg-upgrade2/customer_add_constraints.sql
@@ -4,6 +4,11 @@
 -- @charset: utf-8
 -- @ignore: 0
 
+-- verwaiste Einträge vorher entfernen
+UPDATE customer SET payment_id  = NULL WHERE payment_id  NOT IN (SELECT id FROM payment_terms);
+UPDATE customer SET language_id = NULL WHERE language_id NOT IN (SELECT id FROM language);
+UPDATE customer SET business_id = NULL WHERE business_id NOT IN (SELECT id FROM business);
+
 ALTER TABLE customer ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id);
 ALTER TABLE customer ADD FOREIGN KEY (language_id) REFERENCES language (id);
 ALTER TABLE customer ADD FOREIGN KEY (business_id) REFERENCES business (id);