projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Presenter Code - gl_transaction aus invoice wieder entfernt
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
warehouse2.sql
1
-- @tag: warehouse2
2
-- @description: Defaultwert für onhand
3
-- @depends: warehouse
4
UPDATE parts SET onhand = COALESCE((SELECT SUM(qty) FROM inventory WHERE inventory.parts_id = parts.id), 0);
5
ALTER TABLE parts ALTER COLUMN onhand SET DEFAULT 0;