· 9 years ago · Jan 13, 2017, 03:48 AM
1drop table if exists tblemail;
2create table `tblemail` (
3 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4 `data` text DEFAULT NULL COMMENT 'change to TEXT if mysql version <5.7',
5 `queue_status` varchar(1) NOT NULL DEFAULT 'q',
6 `sent` tinyint(1) NOT NULL DEFAULT '0',
7 `sent_ts` int(11) unsigned DEFAULT NULL,
8 `failed` tinyint(1) NOT NULL DEFAULT '0',
9 `created` int(11) unsigned NOT NULL,
10 `error` text,
11 `message` text DEFAULT NULL,
12 `status_changed` int(11) unsigned NOT NULL,
13 PRIMARY KEY (`id`)
14);