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 data for table `geo_region` -- INSERT INTO `geo_region` VALUES(1, 14, 'Victoria', 'VI', 'AS07'); INSERT INTO `geo_region` VALUES(2, 14, 'Tasmania', 'TS', 'AS06'); INSERT INTO `geo_region` VALUES(3, 14, 'Queensland', 'QL', 'AS04'); INSERT INTO `geo_region` VALUES(4, 14, 'New South Wales', 'NS', 'AS02'); INSERT INTO `geo_region` VALUES(5, 14, 'South Australia', 'SA', 'AS05'); INSERT INTO `geo_region` VALUES(6, 14, 'Western Australia', 'WA', 'AS08'); INSERT INTO `geo_region` VALUES(7, 14, 'Northern Territory', 'NT', 'AS03'); Full file: uploads/georegions.txt