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