CREATE TABLE `access_auth` ( `authenticated_id` varchar(64) NOT NULL default '', `action` varchar(64) NOT NULL default '', `sender_host_address` varchar(64) NOT NULL default '', `asn` varchar(64) NOT NULL default '', `country` char(2) NOT NULL default '', `continent` char(2) NOT NULL default '', `received_ip_address` varchar(64) NOT NULL default '', `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `expired_on` datetime NOT NULL default '0000-00-00 00:00:00', `smtp_message` varchar(256) NOT NULL default '', `log_message` varchar(256) NOT NULL default '', KEY `authenticated_id` (`authenticated_id`,`expired_on`) );