· 7 years ago · Feb 26, 2019, 09:28 PM
1CREATE TABLE IF NOT EXISTS `email_log` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `subject` varchar(500) NOT NULL DEFAULT 'subject not defined',
4 `from` varchar(500) DEFAULT 'from not defined',
5 `to` text NOT NULL,
6 `body` text NOT NULL,
7 `sent_status` tinyint(1) DEFAULT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;