CREATE TABLE IF NOT EXISTS `bo_hourly` (
  `time` int(15) NOT NULL,
  `strikes` int(6) NOT NULL,
  `st_strikes` int(8) NOT NULL,
  UNIQUE KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `bo_stat` (
  `date` date NOT NULL,
  `strikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
  `maxdist` int(6) NOT NULL DEFAULT '0',
  `mindist` int(6) NOT NULL DEFAULT '999999',
  `maxstrikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
  `maxtime` int(15) unsigned NOT NULL DEFAULT '0',
  `maxusers` int(6) NOT NULL DEFAULT '0',
  `st_strikes` int(8) NOT NULL,
  `st_mindist` int(6) NOT NULL DEFAULT '999999',
  `st_maxdist` int(6) NOT NULL DEFAULT '0',
  `st_max` int(6) NOT NULL,
  `st_maxtime` int(15) NOT NULL,
  KEY `time` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `bo_strikes` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `timestamp` int(15) NOT NULL,
  `lat` decimal(9,6) NOT NULL,
  `lon` decimal(9,6) NOT NULL,
  `distance` int(8) NOT NULL,
  `bearing` decimal(4,1) DEFAULT NULL,
  `deviation` smallint(5) unsigned NOT NULL,
  `current` decimal(10,2) NOT NULL,
  `part` int(11) NOT NULL,
  `stations` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `time` (`time`),
  KEY `station` (`part`),
  KEY `distance` (`distance`),
  KEY `timestamps` (`timestamp`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=69343 ;