CREATE TABLE `greylist` ( `sender_host_address` varchar(15) NOT NULL default '', `sender_address` varchar(64) NOT NULL default '', `recipient_address` varchar(64) NOT NULL default '', `block_expires` datetime NOT NULL default '0000-00-00 00:00:00', `record_expires` datetime NOT NULL default '0000-00-00 00:00:00', `blocked_count` int(11) NOT NULL default '0', `passed_count` int(11) NOT NULL default '0', `aborted_count` int(11) NOT NULL default '0', `origin_type` enum('AUTO') NOT NULL default 'AUTO', `create_time` datetime NOT NULL default '0000-00-00 00:00:00', `last_update` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`sender_host_address`,`sender_address`,`recipient_address`), KEY `record_expires` (`record_expires`) ) ENGINE=MyISAM;