Datenbank-Upgrade-Skripte für Release 3.5.7-Abhängigkeiten

[mfinanz.git] / sql / Pg-upgrade2 / warehouse2.sql

diff --git a/sql/Pg-upgrade2/warehouse2.sql b/sql/Pg-upgrade2/warehouse2.sql
index 8d8e1b367cd5707380c9465b245d98b8312d05cc..58718b66b5e5726e619c5a33088c223e722cf59c 100644 (file)
--- a/sql/Pg-upgrade2/warehouse2.sql
+++ b/sql/Pg-upgrade2/warehouse2.sql
@@ -1,5 +1,5 @@
 -- @tag: warehouse2
 -- @tag: warehouse2

--- @description: Defaultwert für onhand
+-- @description: Defaultwert für onhand

 -- @depends: warehouse
 UPDATE parts SET onhand = COALESCE((SELECT SUM(qty) FROM inventory WHERE inventory.parts_id = parts.id), 0);
 ALTER TABLE parts ALTER COLUMN onhand SET DEFAULT 0;
 -- @depends: warehouse
 UPDATE parts SET onhand = COALESCE((SELECT SUM(qty) FROM inventory WHERE inventory.parts_id = parts.id), 0);
 ALTER TABLE parts ALTER COLUMN onhand SET DEFAULT 0;