CREATE TABLE `wpfb_followup_coupon_logs` (  `id` bigint(20) NOT NULL AUTO_INCREMENT,  `coupon_id` bigint(20) NOT NULL,  `coupon_name` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,  `email_name` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,  `email_address` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,  `coupon_code` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,  `coupon_used` int(1) NOT NULL DEFAULT 0,  `date_sent` datetime NOT NULL,  `date_used` datetime NOT NULL,  `email_id` bigint(20) DEFAULT NULL,  PRIMARY KEY (`id`),  KEY `coupon_id` (`coupon_id`),  KEY `date_sent` (`date_sent`),  KEY `email_id` (`email_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40000 ALTER TABLE `wpfb_followup_coupon_logs` DISABLE KEYS */;
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
/*!40000 ALTER TABLE `wpfb_followup_coupon_logs` ENABLE KEYS */;
SET FOREIGN_KEY_CHECKS = 1;
SET UNIQUE_CHECKS = 1;
