Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `product_stock` (
- `product_id` int(11) unsigned NOT NULL,
- `stock_level` int(11) NOT NULL DEFAULT '0',
- `minimum_cart_quantity` int(11) unsigned NOT NULL,
- `maximum_cart_quantity` int(11) unsigned NOT NULL DEFAULT '0',
- `minimum_stock_level` int(11) NOT NULL DEFAULT '0',
- `alert_level_reached_at` datetime DEFAULT NULL,
- `alert_level` int(11) DEFAULT NULL,
- PRIMARY KEY (`product_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Add Comment
Please, Sign In to add comment