SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `Outages` (
  `id` bigint(20) NOT NULL,
  `count` bigint(20) NOT NULL,
  `average` bigint(20) NOT NULL,
  `lastoutage` date NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `count` (`count`,`average`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Towns` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `lat` varchar(12) NOT NULL,
  `long` varchar(12) NOT NULL,
  `zip` varchar(5) default NULL,
  `provider` enum('BHE','CMP') default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `lat` (`lat`),
  UNIQUE KEY `long` (`long`),
  UNIQUE KEY `name` (`name`),
  KEY `zip` (`zip`,`provider`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;