CREATE TABLE `wp_ajug_wc_orders` (  `id` bigint(20) unsigned NOT NULL,  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,  `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci 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) COLLATE utf8mb4_unicode_520_ci 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) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,  `payment_method_title` text COLLATE utf8mb4_unicode_520_ci,  `transaction_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,  `ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,  `user_agent` text COLLATE utf8mb4_unicode_520_ci,  `customer_note` text COLLATE utf8mb4_unicode_520_ci,  PRIMARY KEY (`id`),  KEY `status` (`status`),  KEY `date_created` (`date_created_gmt`),  KEY `customer_id_billing_email` (`customer_id`,`billing_email`),  KEY `billing_email` (`billing_email`),  KEY `type_status` (`type`,`status`),  KEY `parent_order_id` (`parent_order_id`),  KEY `date_updated` (`date_updated_gmt`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40000 ALTER TABLE `wp_ajug_wc_orders` DISABLE KEYS */;
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
/*!40000 ALTER TABLE `wp_ajug_wc_orders` ENABLE KEYS */;
SET FOREIGN_KEY_CHECKS = 1;
SET UNIQUE_CHECKS = 1;
