Anonymous

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)