· 8 years ago · Dec 06, 2017, 04:02 PM
1CREATE TABLE IF NOT EXISTS `jos_vm_order_item` (
2 `order_item_id` int(11) NOT NULL AUTO_INCREMENT,
3 `order_id` int(11) DEFAULT NULL,
4 `user_info_id` varchar(32) DEFAULT NULL,
5 `vendor_id` int(11) DEFAULT NULL,
6 `product_id` int(11) DEFAULT NULL,
7 `order_item_sku` varchar(64) NOT NULL DEFAULT '',
8 `order_item_name` varchar(64) NOT NULL DEFAULT '',
9 `product_quantity` int(11) DEFAULT NULL,
10 `product_item_price` decimal(15,5) DEFAULT NULL,
11 `product_final_price` decimal(12,2) NOT NULL DEFAULT '0.00',
12 `order_item_currency` varchar(16) DEFAULT NULL,
13 `order_status` char(1) DEFAULT NULL,
14 `cdate` int(11) DEFAULT NULL,
15 `mdate` int(11) DEFAULT NULL,
16 `product_attribute` text,
17 PRIMARY KEY (`order_item_id`),
18 KEY `idx_order_item_order_id` (`order_id`),
19 KEY `idx_order_item_user_info_id` (`user_info_id`),
20 KEY `idx_order_item_vendor_id` (`vendor_id`)
21) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores all items (products) which are part of an order' AUTO_INCREMENT=23 ;