-- MySQL dump 10.9 -- -- Host: localhost Database: scratch -- ------------------------------------------------------ -- Server version 4.1.18-max-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `missing2` -- DROP TABLE IF EXISTS `missing2`; CREATE TABLE `missing2` ( `country_code` char(2) default NULL, `admin1_code` varchar(5) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `missing2` -- /*!40000 ALTER TABLE `missing2` DISABLE KEYS */; LOCK TABLES `missing2` WRITE; INSERT INTO `missing2` VALUES ('','00'),('AE',''),('AF',''),('AL','09'),('AL','21'),('AM',''),('AN',''),('AO',''),('AQ',''),('AR',''),('AS',''),('AT',''),('AU',''),('AW','00'),('AZ',''),('BA',''),('BB',''),('BD',''),('BE',''),('BF',''),('BG',''),('BJ',''),('BO',''),('BR',''),('BS',''),('BW',''),('BY',''),('CA','null'),('CA',''),('CD',''),('CF',''),('CG',''),('CH',''),('CI',''),('CK',''),('CL',''),('CM',''),('CN',''),('CO',''),('CR',''),('CS',''),('CU',''),('CV',''),('CX',''),('CY',''),('CZ',''),('DE',''),('DE','25'),('DJ',''),('DK',''),('DK','17'),('DK','18'),('DK','19'),('DK','20'),('DK','21'),('DM',''),('DO','35'),('DO','34'),('DO','36'),('DO','37'),('DO',''),('DZ',''),('EC',''),('EE',''),('EG',''),('EH',''),('ER',''),('ES',''),('ES','A9'),('ES','11'),('ET',''),('FI',''),('FJ',''),('FR',''),('FR','52'),('FR','03,B4'),('FR','09,B4'),('FR','05'),('FR','22'),('FR','32'),('FR','04'),('FR','07'),('GA',''),('GB',''),('GE',''),('GF',''),('GG','00'),('GH',''),('GI',''),('GL',''),('GM',''),('GN',''),('GP',''),('GQ',''),('GR',''),('GT',''),('GW',''),('GY',''),('HK',''),('HN',''),('HR',''),('HT',''),('HU',''),('HU','41'),('HU','42'),('ID',''),('IE',''),('IL',''),('IN',''),('IO','00'),('IO',''),('IQ',''),('IR',''),('IS',''),('IT',''),('JO',''),('JP',''),('KE',''),('KG',''),('KH',''),('KI',''),('KM',''),('KP',''),('KR',''),('KW',''),('KY',''),('KZ',''),('LA',''),('LB',''),('LK',''),('LS',''),('LT',''),('LU',''),('LV',''),('LY',''),('MA',''),('MD',''),('MG',''),('MH',''),('MK',''),('ML',''),('MM',''),('MN',''),('MO',''),('MR',''),('MU',''),('MV',''),('MW',''),('MX',''),('MY',''),('MZ',''),('NA',''),('NC',''),('NE',''),('NG',''),('NI',''),('NL',''),('NO',''),('NP',''),('NR',''),('NZ',''),('OM',''),('PA',''),('PE',''),('PF',''),('PG',''),('PH',''),('PK',''),('PL',''),('PM',''),('PR',''),('PS',''),('PT',''),('PY',''),('QA',''),('RE',''),('RO',''),('RU',''),('RW',''),('RW','11'),('RW','12'),('RW','13'),('RW','14'),('RW','15'),('SA',''),('SB',''),('SC',''),('SD',''),('SE','01'),('SE',''),('SE','11'),('SG',''),('SH',''),('SI',''),('SK',''),('SN',''),('SO','19'),('SO','20'),('SO','18'),('SO',''),('SO','21'),('SO','22'),('SR',''),('ST',''),('SV',''),('SY',''),('SZ',''),('TC',''),('TD',''),('TG',''),('TH',''),('TJ',''),('TL',''),('TM',''),('TN',''),('TO',''),('TR',''),('TT',''),('TV',''),('TW',''),('TZ',''),('UA',''),('UG','18'),('UG',''),('US',''),('US','VI'),('US','GU'),('UY',''),('UZ',''),('VC',''),('VE',''),('VG',''),('VN',''),('VU',''),('WS',''),('YE',''),('ZA',''),('ZM',''),('ZW',''),('','0Z'),('',''),('','20'); UNLOCK TABLES; /*!40000 ALTER TABLE `missing2` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;