/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpk9bt_wc_order_product_lookup`; */
/* PRE_TABLE_NAME: `1741599259_wpk9bt_wc_order_product_lookup`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1741599259_wpk9bt_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `1741599259_wpk9bt_wc_order_product_lookup` (`order_item_id`, `order_id`, `product_id`, `variation_id`, `customer_id`, `date_created`, `product_qty`, `product_net_revenue`, `product_gross_revenue`, `coupon_amount`, `tax_amount`, `shipping_amount`, `shipping_tax_amount`) VALUES (2,6451,6192,0,1,'2025-02-26 11:17:36',1,50,50,0,0,0,0),(5,6454,6192,0,2,'2025-02-26 11:53:06',1,50,50,0,0,0,0),(3,6452,6192,0,3,'2025-02-26 11:21:29',1,50,50,0,0,0,0),(4,6453,6192,0,3,'2025-02-26 11:50:38',1,50,50,0,0,0,0),(7,6462,6192,0,4,'2025-03-03 13:51:35',1,50,50,0,0,0,0),(6,6461,6456,0,4,'2025-03-03 13:46:15',1,500,500,0,0,0,0),(8,6480,6456,0,1,'2025-03-07 06:52:16',1,569,569,0,0,0,0),(9,6481,6192,0,3,'2025-03-07 09:12:14',1,50,50,0,0,0,0);
