From 066fbb38fb409c5801b70fc7d43f4e9190d295ff Mon Sep 17 00:00:00 2001
From: =?utf8?q?Jan=20B=C3=BCren?= <jan@lx-office-hosting.de>
Date: Wed, 12 Oct 2011 16:44:33 +0200
Subject: [PATCH] =?utf8?q?Einheiten=20die=20Waren=20zugeordnet=20sind=20en?=
 =?utf8?q?tsprechend=20als=20Fremdschl=C3=BCssel=20verkn=C3=BCpfen.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 sql/Pg-upgrade2/parts_add_unit_foreign_key.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/Pg-upgrade2/parts_add_unit_foreign_key.sql

diff --git a/sql/Pg-upgrade2/parts_add_unit_foreign_key.sql b/sql/Pg-upgrade2/parts_add_unit_foreign_key.sql
new file mode 100644
index 000000000..0c6fc1d57
--- /dev/null
+++ b/sql/Pg-upgrade2/parts_add_unit_foreign_key.sql
@@ -0,0 +1,6 @@
+-- @tag: parts_add_unit_foreign_key
+-- @description: Einheiten die Waren zugeordnet sind entsprechend als Fremdschlüssel verknüpfen.
+-- @depends: release_2_6_3
+-- @charset: utf-8
+-- @ignore: 0
+ALTER TABLE parts ADD FOREIGN KEY (unit) REFERENCES units(name);
-- 
2.20.1