mysql> show create table sorted_1;
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sorted_1 | CREATE TABLE `sorted_1` (
  `ip` varchar(20) NOT NULL default '',
  `local_in` int(25) unsigned default '0',
  `local_out` int(25) unsigned default '0',
  `lt_in` int(25) unsigned default '0',
  `lt_out` int(25) unsigned default '0',
  `inet_in` int(25) unsigned default '0',
  `inet_out` int(25) unsigned default '0',
  `date` varchar(10) NOT NULL default '',
  `hour` tinyint(2) unsigned NOT NULL default '0',
  `minute` tinyint(2) unsigned NOT NULL default '0',
  KEY `idx_date` (`date`,`hour`,`minute`),
  KEY `idx_lt` (`lt_in`,`lt_out`),
  KEY `idx_local` (`local_in`,`local_out`),
  KEY `idx_ip` (`ip`),
  KEY `idx_inet` (`inet_in`,`inet_out`)
) TYPE=MyISAM MAX_ROWS=4294967295 |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)