GeoPlanet data - MySQL database download available

CREATE TABLE `place` (
  `woeid` bigint(20) NOT NULL,
  `country` varchar(2) NOT NULL,
  `name` varchar(255) NOT NULL,
  `language` char(3) NOT NULL,
  `place_type` bigint(20) NOT NULL,
  `parent` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`woeid`),
  KEY `parent` (`parent`),
  KEY `place_type` (`place_type`),
  KEY `country` (`country`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `places_aliases` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `woeid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_type` char(1) NOT NULL,
  `language` char(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `woeid` (`woeid`,`name_type`,`language`),
  KEY `name_type` (`name_type`),
  KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;



CREATE TABLE `places_neighbours` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `place_woeid` bigint(20) NOT NULL,
  `neigbour_woeid` bigint(20) NOT NULL,
  `place_country` char(2) NOT NULL,
  `neighbour_country` char(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `place_woeid` (`place_woeid`,`neigbour_woeid`),
  KEY `neigbour_woeid` (`neigbour_woeid`),
  KEY `place_country` (`place_country`),
  KEY `neighbour_country` (`neighbour_country`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;



CREATE TABLE `place_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


ALTER TABLE `place`
  ADD CONSTRAINT `place_ibfk_2` FOREIGN KEY (`place_type`) REFERENCES `place_type` (`id`);

ALTER TABLE `places_aliases`
  ADD CONSTRAINT `places_aliases_ibfk_1` FOREIGN KEY (`woeid`) REFERENCES `place` (`woeid`);

ALTER TABLE `places_neighbours`
  ADD CONSTRAINT `places_neighbours_ibfk_1` FOREIGN KEY (`place_woeid`) REFERENCES `place` (`woeid`),
  ADD CONSTRAINT `places_neighbours_ibfk_2` FOREIGN KEY (`neigbour_woeid`) REFERENCES `place` (`woeid`);