X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/c4563766e64c6ac8aeb460acd386dea8201a10a1..0ed9d7317f58878a38b6f3e1ac5ba052f4798538:/sql/Pg-upgrade2/warehouse2.sql?ds=sidebyside 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;