Here some confs.
DROP TABLE IF EXISTS `Smtpd`;
CREATE TABLE IF NOT EXISTS `Smtpd` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ReportedTime` datetime NOT NULL,
`MessageTime` varchar(40) NOT NULL,
`Host` text NOT NULL,
`Process` varchar(40) NOT NULL,
`ProcessID` int(11) NOT NULL,
`Message` text NOT NULL,
`ClientHost` varchar(255) NOT NULL,
`ClientIP` varchar(15) NOT NULL,
`MailFrom` varchar(255) NOT NULL,
`MailTo` varchar(255) NOT NULL,
`MessageID` varchar(40) NOT NULL,
`Status` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1453 ;
CREATE TABLE IF NOT EXISTS `Smtpd` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ReportedTime` datetime NOT NULL,
`MessageTime` varchar(40) NOT NULL,
`Host` text NOT NULL,
`Process` varchar(40) NOT NULL,
`ProcessID` int(11) NOT NULL,
`Message` text NOT NULL,
`ClientHost` varchar(255) NOT NULL,
`ClientIP` varchar(15) NOT NULL,
`MailFrom` varchar(255) NOT NULL,
`MailTo` varchar(255) NOT NULL,
`MessageID` varchar(40) NOT NULL,
`Status` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1453 ;