DROP TABLE IF EXISTS `Log_Spam`; CREATE TABLE `Log_Spam` ( `LogMsg` varchar(255) default NULL, `LogDate` datetime default NULL, `Account` varchar(64) NOT NULL default '', `id` bigint(12) unsigned NOT NULL auto_increment, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `Log_SendMail`; CREATE TABLE `Log_SendMail` ( `LogMsg` varchar(64) default NULL, `LogDate` datetime default NULL, `Account` varchar(128) NOT NULL default '', `id` bigint(12) unsigned NOT NULL auto_increment, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `Log_RecvMail`; CREATE TABLE `Log_RecvMail` ( `LogMsg` varchar(64) default NULL, `LogDate` datetime default NULL, `Account` varchar(128) NOT NULL default '', `id` bigint(12) unsigned NOT NULL auto_increment, PRIMARY KEY (`id`), KEY `iAccount` (`Account`), KEY `LogDate` (`LogDate`) ) DEFAULT CHARSET=latin1;