/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `mod42_wc_order_product_lookup`; */
/* PRE_TABLE_NAME: `1690813095_mod42_wc_order_product_lookup`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1690813095_mod42_wc_order_product_lookup` ( `order_item_id` bigint(20) unsigned NOT NULL, `order_id` bigint(20) unsigned NOT NULL, `product_id` bigint(20) unsigned NOT NULL, `variation_id` bigint(20) unsigned NOT NULL, `customer_id` bigint(20) unsigned DEFAULT NULL, `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `product_qty` int(11) NOT NULL, `product_net_revenue` double NOT NULL DEFAULT '0', `product_gross_revenue` double NOT NULL DEFAULT '0', `coupon_amount` double NOT NULL DEFAULT '0', `tax_amount` double NOT NULL DEFAULT '0', `shipping_amount` double NOT NULL DEFAULT '0', `shipping_tax_amount` double NOT NULL DEFAULT '0', PRIMARY KEY (`order_item_id`), KEY `order_id` (`order_id`), KEY `product_id` (`product_id`), KEY `customer_id` (`customer_id`), KEY `date_created` (`date_created`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
