X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fwarehouse2.sql;h=58718b66b5e5726e619c5a33088c223e722cf59c;hb=fa0c33348c090ddc68edb8ca9131c70fd1365095;hp=8d8e1b367cd5707380c9465b245d98b8312d05cc;hpb=c4563766e64c6ac8aeb460acd386dea8201a10a1;p=kivitendo-erp.git 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;