mathie's bits

Category: database

  • MySQL database of geographical countries

    CREATE TABLE `geo_country` ( `CountryId` int(10) unsigned NOT NULL default ‘0’, `Country` varchar(100) NOT NULL default ”, `FIPS104` char(2) NOT NULL default ”, `ISO2` char(2) NOT NULL default ”, `ISO3` char(3) NOT NULL default ”, `ISON` int(10) unsigned NOT NULL default ‘0’, `Internet` char(2) NOT NULL default ”, `Capital` varchar(100) NOT NULL default ”, `MapReference`…

  • MySQL database for geographical regions

    CREATE TABLE `geo_region` ( `RegionId` int(10) unsigned NOT NULL default ‘0’, `CountryId` int(10) unsigned NOT NULL default ‘0’, `Region` varchar(100) NOT NULL default ”, `Code` char(2) NOT NULL default ”, `ADM1Code` varchar(4) NOT NULL default ”, PRIMARY KEY (`RegionId`), KEY `CountryId` (`CountryId`), KEY `Region` (`Region`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=’Regions from GeoBytes’; — — Dumping…

  • Geographical city MySQL database

    CREATE TABLE `geo_city` ( `CityId` int(10) unsigned NOT NULL default ‘0’, `CountryId` int(10) unsigned NOT NULL default ‘0’, `RegionId` int(10) unsigned NOT NULL default ‘0’, `City` varchar(100) NOT NULL default ”, `Latitude` float NOT NULL default ‘0’, `Longitude` float NOT NULL default ‘0’, `TimeZone` varchar(6) NOT NULL default ”, `DmaId` int(10) unsigned NOT NULL default…

  • US zipcode database in SQL format

    Don’t remember where I got this file, but might be useful for some: us.zipcodes.sql

  • SQL World Cities Database

    Some data sets about world cities we no longer use — Generation Time: Feb 13, 2007 at 02:12 AM CREATE TABLE cities ( ID int(11) NOT NULL auto_increment, Name char(35) NOT NULL default ”, CountryCode char(3) NOT NULL default ”, District char(20) NOT NULL default ”, Population int(11) NOT NULL default ‘0’, PRIMARY KEY (ID)…