From e05b8d340be3f8b7516ae37f4532977d3860c10d Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Thu, 6 Oct 2011 18:47:06 +0200 Subject: [PATCH] =?utf8?q?Verwaiste=20Zahlungsbedingungen=20in=20vc=20vorh?= =?utf8?q?er=20auf=20NULL=20setzen=20und=20danach=20den=20neuen=20Fremdsch?= =?utf8?q?l=C3=BCssel?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/customer_add_constraints.sql | 3 +++ sql/Pg-upgrade2/vendor_add_constraints.sql | 4 ++++ 2 files changed, 7 insertions(+) diff --git a/sql/Pg-upgrade2/customer_add_constraints.sql b/sql/Pg-upgrade2/customer_add_constraints.sql index 6505efdb1..89ca9d628 100644 --- 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 +-- 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); diff --git a/sql/Pg-upgrade2/vendor_add_constraints.sql b/sql/Pg-upgrade2/vendor_add_constraints.sql index 7b707c0fa..3d3a81657 100644 --- 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 +-- 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); -- 2.20.1