· 8 years ago · May 17, 2018, 01:32 AM
1CREATE TABLE IF NOT EXISTS stock (
2 product_id int(10) unsigned NOT NULL,
3 client_id int(10) unsigned NOT NULL,
4 warehouse_id smallint(5) unsigned NOT NULL,
5 quantity smallint(5) unsigned NOT NULL,
6 multiplier smallint(5) unsigned NOT NULL,
7 KEY item_id (product_id,warehouse_id)
8)