projects
/
order_line_extra.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Merge branch 'master' of bb:elax/fa-order_line_extra
[order_line_extra.git]
/
sql
/
create_denorm_order_details_queue.sql
1
CREATE TABLE 0_denorm_order_details_queue (
2
id INT,
3
stock_id VARCHAR(20),
4
order_id INT,
5
quantity DOUBLE, -- quantity in the order
6
quantity_before DOUBLE, -- sum of quantity of other orders which have priority
7
priority DATETIME,
8
primary key (id),
9
key stock_id (stock_id, priority)
10
)
11
;