From 2439123788ab61a9eb21547c4854b14df70b1466 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Jan=20B=C3=BCren?= <jan@lx-office-hosting.de>
Date: Thu, 4 Mar 2010 10:22:51 +0100
Subject: [PATCH] =?utf8?q?Zusatz=20f=C3=BCr=20Bugfix=201289=20Alle=20onhan?=
 =?utf8?q?ds=20in=20parts=20nochmal=20neu=20setzen,=20sodass=20der=20Lager?=
 =?utf8?q?bestand=20i.O.=20ist.=20@moritz=20bitte=20kurze=20qs=20jan?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

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

diff --git a/sql/Pg-upgrade2/warehouse3.sql b/sql/Pg-upgrade2/warehouse3.sql
new file mode 100644
index 000000000..73c88c54d
--- /dev/null
+++ b/sql/Pg-upgrade2/warehouse3.sql
@@ -0,0 +1,5 @@
+-- @tag: warehouse3
+-- @description: Defaultwert für onhand nochmal erneut setzen nach Bugfix für 1289 Gutschriften auf Rechnungen lösen Lagerbewegung aus
+-- @depends: warehouse2 release_2_6_0
+-- @charset: UTF-8
+UPDATE parts SET onhand = COALESCE((SELECT SUM(qty) FROM inventory WHERE inventory.parts_id = parts.id), 0);
-- 
2.20.1