/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpk9bt_wc_orders`; */
/* PRE_TABLE_NAME: `1741599259_wpk9bt_wc_orders`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1741599259_wpk9bt_wc_orders` ( `id` bigint(20) unsigned NOT NULL, `status` varchar(20) DEFAULT NULL, `currency` varchar(10) DEFAULT NULL, `type` varchar(20) DEFAULT NULL, `tax_amount` decimal(26,8) DEFAULT NULL, `total_amount` decimal(26,8) DEFAULT NULL, `customer_id` bigint(20) unsigned DEFAULT NULL, `billing_email` varchar(320) DEFAULT NULL, `date_created_gmt` datetime DEFAULT NULL, `date_updated_gmt` datetime DEFAULT NULL, `parent_order_id` bigint(20) unsigned DEFAULT NULL, `payment_method` varchar(100) DEFAULT NULL, `payment_method_title` text DEFAULT NULL, `transaction_id` varchar(100) DEFAULT NULL, `ip_address` varchar(100) DEFAULT NULL, `user_agent` text DEFAULT NULL, `customer_note` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `date_created` (`date_created_gmt`), KEY `customer_id_billing_email` (`customer_id`,`billing_email`(171)), KEY `billing_email` (`billing_email`(191)), KEY `type_status_date` (`type`,`status`,`date_created_gmt`), KEY `parent_order_id` (`parent_order_id`), KEY `date_updated` (`date_updated_gmt`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
