Verwaiste Zahlungsbedingungen in vc vorher auf NULL setzen und danach den neuen Fremd...

diff --git a/sql/Pg-upgrade2/customer_add_constraints.sql b/sql/Pg-upgrade2/customer_add_constraints.sql
index 6505efdb171e8c608e72292d9f0fc57595c593d7..89ca9d62854f06cf285ab3f702320494aaa281f6 100644 (file)
--- a/sql/Pg-upgrade2/customer_add_constraints.sql
+++ b/sql/Pg-upgrade2/customer_add_constraints.sql
@@ -4,6 +4,9 @@
 -- @charset: utf-8
 -- @ignore: 0
 
 -- @charset: utf-8
 -- @ignore: 0
 

+-- verwaiste Zahlungsbedingungen vorher entfernen:
+update customer set payment_id = NULL where payment_id not in (select id from payment_terms);
+

 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);
 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);

diff --git a/sql/Pg-upgrade2/vendor_add_constraints.sql b/sql/Pg-upgrade2/vendor_add_constraints.sql
index 7b707c0fabd92774bcf6704ac5cfc14b516b82d9..3d3a81657cfbed6856af7de159847f85ae9f5359 100644 (file)
--- a/sql/Pg-upgrade2/vendor_add_constraints.sql
+++ b/sql/Pg-upgrade2/vendor_add_constraints.sql
@@ -4,6 +4,10 @@
 -- @charset: utf-8
 -- @ignore: 0
 
 -- @charset: utf-8
 -- @ignore: 0
 

+-- verwaiste Zahlungsbedingungen vorher entfernen
+update vendor set payment_id = NULL where payment_id not in (select id from payment_terms);
+
+

 ALTER TABLE vendor ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id);
 ALTER TABLE vendor ADD FOREIGN KEY (language_id) REFERENCES language (id);
 ALTER TABLE vendor ADD FOREIGN KEY (business_id) REFERENCES business (id);
 ALTER TABLE vendor ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id);
 ALTER TABLE vendor ADD FOREIGN KEY (language_id) REFERENCES language (id);
 ALTER TABLE vendor ADD FOREIGN KEY (business_id) REFERENCES business (id);