-- MySQL city Table
-- infos can be found at http://geoloc.polytechnique.org/bdville/

CREATE TABLE `city` (
  `id` int(11) NOT NULL default '0',
  `alias` char(1) NOT NULL default '',
  `name` varchar(200) NOT NULL default '',
  `sort_name` varchar(200) NOT NULL default '',
  `prefix` varchar(30) NOT NULL default '',
  `lat` float(8,7) NOT NULL default '0.0000000',
  `lon` float(8,7) NOT NULL default '0.0000000',
  `country` char(2) NOT NULL default '',
  `region` char(2) NOT NULL default '',
  `adm2` varchar(200) NOT NULL default '',
  `postcode` varchar(8) NOT NULL default '',
  `level` tinyint(4) NOT NULL default '5',
  `population` int(11) NOT NULL default '0',
  `modify_date` date NOT NULL default '0000-00-00',
  `char_type` tinyint(4) NOT NULL default '1',
  PRIMARY KEY (`id`, `alias`),
  KEY `lat` (`lat`),
  KEY `lon` (`lon`),
  KEY `famous` (`level`, `sort_name`),
  KEY `name` (`country`, `sort_name`),
  KEY `postcode` (`country`, `postcode`)
) TYPE=MyISAM;