u8FcrSdD

1SET NAMES utf8;
2SET time_zone = '+00:00';
3SET foreign_key_checks = 0;
4SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
5
6DROP TABLE IF EXISTS `blast_email_log`;
7CREATE TABLE `blast_email_log` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `order_number` varchar(20) NOT NULL,
10  `status` int(11) NOT NULL DEFAULT '0',
11  `response` text,
12  `date_created` datetime NOT NULL,
13  `date_send` datetime DEFAULT NULL,
14  `template` varchar(200) DEFAULT NULL,
15  PRIMARY KEY (`id`),
16  KEY `order_number_idx` (`order_number`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;