From a4fce26ecdececd74cf1c63de7dcc959083d7e6c Mon Sep 17 00:00:00 2001 From: Niclas Zimmermann Date: Tue, 18 Dec 2012 11:19:04 +0100 Subject: [PATCH] =?utf8?q?Fremdschl=C3=BCssel=20f=C3=BCr=20tax=5Fid=20in?= =?utf8?q?=20acc=5Ftrans?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Dieser Commit fügt einen Fremdschlüssel für die Spalte tax_id in der acc_trans zu der Spalte id in tax ein. --- sql/Pg-upgrade2/add_fkey_tax_id_to_acc_trans.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/Pg-upgrade2/add_fkey_tax_id_to_acc_trans.sql diff --git a/sql/Pg-upgrade2/add_fkey_tax_id_to_acc_trans.sql b/sql/Pg-upgrade2/add_fkey_tax_id_to_acc_trans.sql new file mode 100644 index 000000000..a61001129 --- /dev/null +++ b/sql/Pg-upgrade2/add_fkey_tax_id_to_acc_trans.sql @@ -0,0 +1,5 @@ +-- @tag: add_fkey_tax_id_to_acc_trans +-- @description: Setzt einen Fremdschlüssel zu der Tabellenspalte tax_id in der acc_trans +-- @depends: release_3_0_0 + +ALTER TABLE acc_trans ADD FOREIGN KEY (tax_id) REFERENCES tax(id); -- 2.20.1