From b9043da3207903443bc94320b5f5f981f20c3698 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Thu, 6 Oct 2011 17:26:57 +0200 Subject: [PATCH] =?utf8?q?Zus=C3=A4tzliche=20Fremdschl=C3=BCssel=20f=C3=BC?= =?utf8?q?r=20Sprache,=20Kundentyp=20und=20Zahlungskonditionen=20bei=20Kun?= =?utf8?q?den=20hinzugef=C3=BCgt.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/customer_add_constraints.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/Pg-upgrade2/customer_add_constraints.sql diff --git a/sql/Pg-upgrade2/customer_add_constraints.sql b/sql/Pg-upgrade2/customer_add_constraints.sql new file mode 100644 index 000000000..6505efdb1 --- /dev/null +++ b/sql/Pg-upgrade2/customer_add_constraints.sql @@ -0,0 +1,9 @@ +-- @tag: customer_add_constraints +-- @description: Zusätzliche Fremdschlüssel für Sprache, Kundentyp und Zahlungskonditionen +-- @depends: release_2_6_3 +-- @charset: utf-8 +-- @ignore: 0 + +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); -- 2.20.1