projects
/
order_line_extra.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
8f685dde527bd9225f52786e24ba0950d5571c62
[order_line_extra.git]
/
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
;