/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpk9bt_wc_order_stats`; */
/* PRE_TABLE_NAME: `1741599259_wpk9bt_wc_order_stats`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1741599259_wpk9bt_wc_order_stats` ( `order_id` bigint(20) unsigned NOT NULL, `parent_id` bigint(20) unsigned NOT NULL DEFAULT 0, `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `num_items_sold` int(11) NOT NULL DEFAULT 0, `total_sales` double NOT NULL DEFAULT 0, `tax_total` double NOT NULL DEFAULT 0, `shipping_total` double NOT NULL DEFAULT 0, `net_total` double NOT NULL DEFAULT 0, `returning_customer` tinyint(1) DEFAULT NULL, `status` varchar(200) NOT NULL, `customer_id` bigint(20) unsigned NOT NULL, `date_paid` datetime DEFAULT '0000-00-00 00:00:00', `date_completed` datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`order_id`), KEY `date_created` (`date_created`), KEY `customer_id` (`customer_id`), KEY `status` (`status`(191))) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `1741599259_wpk9bt_wc_order_stats` (`order_id`, `parent_id`, `date_created`, `date_created_gmt`, `num_items_sold`, `total_sales`, `tax_total`, `shipping_total`, `net_total`, `returning_customer`, `status`, `customer_id`, `date_paid`, `date_completed`) VALUES (6451,0,'2025-02-26 11:17:36','2025-02-26 11:17:36',1,50,0,0,50,0,'wc-cancelled',1,NULL,NULL),(6454,0,'2025-02-26 11:53:06','2025-02-26 11:53:06',1,50,0,0,50,0,'wc-cancelled',2,NULL,NULL),(6452,0,'2025-02-26 11:21:29','2025-02-26 11:21:29',1,50,0,0,50,0,'wc-cancelled',3,NULL,NULL),(6453,0,'2025-02-26 11:50:38','2025-02-26 11:50:38',1,50,0,0,50,0,'wc-cancelled',3,NULL,NULL),(6462,0,'2025-03-03 13:51:35','2025-03-03 13:51:35',1,50,0,0,50,0,'wc-processing',4,'2025-03-03 13:51:35',NULL),(6461,0,'2025-03-03 13:46:15','2025-03-03 13:46:15',1,500,0,0,500,1,'wc-cancelled',4,NULL,NULL),(6480,0,'2025-03-07 06:52:16','2025-03-07 06:52:16',1,569,0,0,569,0,'wc-cancelled',1,NULL,NULL),(6481,0,'2025-03-07 09:12:14','2025-03-07 09:12:14',1,50,0,0,50,0,'wc-cancelled',3,NULL,NULL);
