MySQL database for geographical regions

<br /> CREATE TABLE `geo_region` (<br /> `RegionId` int(10) unsigned NOT NULL default ‘0’,<br /> `CountryId` int(10) unsigned NOT NULL default ‘0’,<br /> `Region` varchar(100) NOT NULL default ”,<br /> `Code` char(2) NOT NULL default ”,<br /> `ADM1Code` varchar(4) NOT NULL default ”,<br /> PRIMARY KEY (`RegionId`),<br /> KEY `CountryId` (`CountryId`),<br /> KEY `Region` (`Region`)<br /> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=’Regions from GeoBytes’;</p> <p>—<br /> — Dumping data for table `geo_region`<br /> —</p> <p>INSERT INTO `geo_region` VALUES(1, 14, ‘Victoria’, ‘VI’, ‘AS07’);<br /> INSERT INTO `geo_region` VALUES(2, 14, ‘Tasmania’, ‘TS’, ‘AS06’);<br /> INSERT INTO `geo_region` VALUES(3, 14, ‘Queensland’, ‘QL’, ‘AS04’);<br /> INSERT INTO `geo_region` VALUES(4, 14, ‘New South Wales’, ‘NS’, ‘AS02’);<br /> INSERT INTO `geo_region` VALUES(5, 14, ‘South Australia’, ‘SA’, ‘AS05’);<br /> INSERT INTO `geo_region` VALUES(6, 14, ‘Western Australia’, ‘WA’, ‘AS08’);<br /> INSERT INTO `geo_region` VALUES(7, 14, ‘Northern Territory’, ‘NT’, ‘AS03’);<br />
Full file: uploads/georegions.txt