projects
/
order_line_extra.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Call hooks on split.
[order_line_extra.git]
/
sql
/
create_denorm_qoh.sql
1
CREATE TABLE 0_denorm_qoh (
2
id INT AUTO_INCREMENT,
3
stock_id VARCHAR(20),
4
loc_code VARCHAR(20),
5
quantity DOUBLE, -- quantity in the order
6
primary key (id),
7
key stock_id (stock_id, loc_code)
8
)
9
;