#
# Table structure for table `readings`
#

DROP TABLE IF EXISTS `readings`;
CREATE TABLE `readings` (
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `down` tinyint(1) NOT NULL default '0',
  `speed` float NOT NULL default '0',
  `ip` text NOT NULL,
  `name` text NOT NULL,
  `browser` text NOT NULL,
  PRIMARY KEY  (`date`,`ip`(16)),
  KEY `down` (`down`),
  KEY `date` (`date`),
  KEY `ip` (`ip`(16))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
