mysql> SHOW CREATE TABLE VastRuns; +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------+ | Table | Create Table | +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------+ | VastRuns | CREATE TABLE `VastRuns` ( `ip` char(16) NOT NULL default '', `datetime` char(32) NOT NULL default '', PRIMARY KEY (`ip`,`datetime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------+ 1 row in set (0.00 sec) mysql> SHOW CREATE TABLE VastRuns; +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | VastRuns | CREATE TABLE `VastRuns` ( `ip` char(16) NOT NULL default '', `datetime` char(32) NOT NULL default '', PRIMARY KEY (`ip`,`datetime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SHOW CREATE TABLE scanssh; +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | scanssh | CREATE TABLE `scanssh` ( `ip` char(16) default NULL, `datetime` char(32) default NULL, `portid` char(16) default NULL, `text` text, KEY `ip` (`ip`,`datetime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SHOW CREATE TABLE ping; +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ping | CREATE TABLE `ping` ( `ip` char(16) default NULL, `datetime` char(32) default NULL, `ttl` char(128) default NULL, `connect` char(128) default NULL, KEY `ip` (`ip`,`datetime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)