CREATE TABLE `PREFIX_alexa` (
  `alexaid` int(10) unsigned NOT NULL auto_increment,
  `times` int(11) NOT NULL default '0',
  `lastpage` varchar(255) NOT NULL default '',
  `counts` int(11) NOT NULL default '0',
  `types` int(11) NOT NULL default '0',
  `http_user_agent` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`alexaid`),
  KEY `keyword` (`times`,`counts`,`types`)
) TYPE=MyISAM;