-- $Id$

-- This file is the result of an export of the zipcodes table from a Drupal 6 installation
-- with the contributed location module installed and the zipcodes.us.mysql file imported.

--
-- Table structure for table `zipcodes`
--

CREATE TABLE IF NOT EXISTS `zipcodes` (
  `zip` varchar(16) NOT NULL DEFAULT '0',
  `city` varchar(30) NOT NULL DEFAULT '',
  `state` varchar(30) NOT NULL DEFAULT '',
  `latitude` decimal(10,6) NOT NULL DEFAULT '0.000000',
  `longitude` decimal(10,6) NOT NULL DEFAULT '0.000000',
  `timezone` tinyint(4) NOT NULL DEFAULT '0',
  `dst` tinyint(4) NOT NULL DEFAULT '0',
  `country` char(3) NOT NULL DEFAULT '',
  KEY `pc` (`country`,`zip`),
  KEY `zip` (`zip`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`),
  KEY `country` (`country`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- United States of America version.
-- America! Yeah!
-- Dumping data for table `zipcodes`
--

INSERT INTO zipcodes VALUES ('00210','Portsmouth','NH','43.005895','-71.013202',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00211','Portsmouth','NH','43.005895','-71.013202',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00212','Portsmouth','NH','43.005895','-71.013202',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00213','Portsmouth','NH','43.005895','-71.013202',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00214','Portsmouth','NH','43.005895','-71.013202',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00215','Portsmouth','NH','43.005895','-71.013202',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00501','Holtsville','NY','40.922326','-72.637078',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00544','Holtsville','NY','40.922326','-72.637078',-5,1,'USA');
INSERT INTO zipcodes VALUES ('00601','Adjuntas','PR','18.180103','-66.749470',-4,0,'USA');
INSERT INTO zipcodes VALUES ('00602','Aguada','PR','18.363285','-67.180240',-4,0,'USA');
INSERT INTO zipcodes VALUES ('00603','Aguadilla','PR','18.448619','-67.134220',-4,0,'USA');
INSERT INTO zipcodes VALUES ('00604','Aguadilla','PR','18.498987','-67.136990',-4,0,'USA');
INSERT INTO zipcodes VALUES ('00605','Aguadilla','PR','18.465162','-67.141486',-4,0,'USA');
INSERT INTO zipcodes VALUES ('00606','Maricao','PR','18.182151','-66.958800',-4,0,'USA');
INSERT INTO zipcodes VALUES ('00607','Aguas Buenas','PR','18.256995','-66.104657',-4,0,'USA');