X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/c4563766e64c6ac8aeb460acd386dea8201a10a1..c7172f34ff94490977366ca8cad6c057ddc3da91:/sql/Pg-upgrade2/warehouse2.sql diff --git a/sql/Pg-upgrade2/warehouse2.sql b/sql/Pg-upgrade2/warehouse2.sql index 8d8e1b367..58718b66b 100644 --- a/sql/Pg-upgrade2/warehouse2.sql +++ b/sql/Pg-upgrade2/warehouse2.sql @@ -1,5 +1,5 @@ -- @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;