-- phpMyAdmin SQL Dump -- version 2.6.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 14, 2008 at 08:47 PM -- Server version: 4.1.22 -- PHP Version: 4.4.8-dev -- -- Database: `***` -- -- -------------------------------------------------------- -- -- Table structure for table `zone_import` -- CREATE TABLE `zone_import` ( `zone_id` varchar(3) NOT NULL default '0', `country_code` varchar(5) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `zone_import` -- INSERT INTO `zone_import` VALUES ('5', 'AF'); INSERT INTO `zone_import` VALUES ('3', 'AL'); INSERT INTO `zone_import` VALUES ('5', 'DZ'); INSERT INTO `zone_import` VALUES ('5', 'AS'); INSERT INTO `zone_import` VALUES ('3', 'AD'); INSERT INTO `zone_import` VALUES ('5', 'AO'); INSERT INTO `zone_import` VALUES ('5', 'AI'); INSERT INTO `zone_import` VALUES ('5', 'AG'); INSERT INTO `zone_import` VALUES ('5', 'AR'); INSERT INTO `zone_import` VALUES ('5', 'AM'); INSERT INTO `zone_import` VALUES ('5', 'AW'); INSERT INTO `zone_import` VALUES ('5', 'AU'); INSERT INTO `zone_import` VALUES ('5', 'AZ'); INSERT INTO `zone_import` VALUES ('5', 'BS'); INSERT INTO `zone_import` VALUES ('4', 'BH'); INSERT INTO `zone_import` VALUES ('5', 'BD'); INSERT INTO `zone_import` VALUES ('5', 'BB'); INSERT INTO `zone_import` VALUES ('1', 'BE'); INSERT INTO `zone_import` VALUES ('5', 'BZ'); INSERT INTO `zone_import` VALUES ('5', 'BJ'); INSERT INTO `zone_import` VALUES ('5', 'BM'); INSERT INTO `zone_import` VALUES ('5', 'BT'); INSERT INTO `zone_import` VALUES ('5', 'BO'); INSERT INTO `zone_import` VALUES ('3', 'BA'); INSERT INTO `zone_import` VALUES ('5', 'BW'); INSERT INTO `zone_import` VALUES ('5', 'BR'); INSERT INTO `zone_import` VALUES ('4', 'BN'); INSERT INTO `zone_import` VALUES ('2b', 'BG'); INSERT INTO `zone_import` VALUES ('5', 'BF'); INSERT INTO `zone_import` VALUES ('5', 'BI'); INSERT INTO `zone_import` VALUES ('4', 'KH'); INSERT INTO `zone_import` VALUES ('4', 'CA'); INSERT INTO `zone_import` VALUES ('5', 'KY'); INSERT INTO `zone_import` VALUES ('5', 'CF'); INSERT INTO `zone_import` VALUES ('5', 'CL'); INSERT INTO `zone_import` VALUES ('4', 'CN'); INSERT INTO `zone_import` VALUES ('5', 'CX'); INSERT INTO `zone_import` VALUES ('5', 'CC'); INSERT INTO `zone_import` VALUES ('5', 'CO'); INSERT INTO `zone_import` VALUES ('5', 'KM'); INSERT INTO `zone_import` VALUES ('5', 'CK'); INSERT INTO `zone_import` VALUES ('5', 'CR'); INSERT INTO `zone_import` VALUES ('5', 'CU'); INSERT INTO `zone_import` VALUES ('2b', 'CY'); INSERT INTO `zone_import` VALUES ('2', 'DK'); INSERT INTO `zone_import` VALUES ('5', 'DJ'); INSERT INTO `zone_import` VALUES ('5', 'DM'); INSERT INTO `zone_import` VALUES ('5', 'DO'); INSERT INTO `zone_import` VALUES ('1', 'DE'); INSERT INTO `zone_import` VALUES ('5', 'EC'); INSERT INTO `zone_import` VALUES ('5', 'EG'); INSERT INTO `zone_import` VALUES ('5', 'SV'); INSERT INTO `zone_import` VALUES ('5', 'GQ'); INSERT INTO `zone_import` VALUES ('5', 'ER'); INSERT INTO `zone_import` VALUES ('2b', 'EE'); INSERT INTO `zone_import` VALUES ('5', 'ET'); INSERT INTO `zone_import` VALUES ('5', 'FO'); INSERT INTO `zone_import` VALUES ('5', 'FJ'); INSERT INTO `zone_import` VALUES ('4', 'PH'); INSERT INTO `zone_import` VALUES ('2b', 'FI'); INSERT INTO `zone_import` VALUES ('2', 'FR'); INSERT INTO `zone_import` VALUES ('5', 'GF'); INSERT INTO `zone_import` VALUES ('5', 'PF'); INSERT INTO `zone_import` VALUES ('5', 'GA'); INSERT INTO `zone_import` VALUES ('5', 'GM'); INSERT INTO `zone_import` VALUES ('5', 'GE'); INSERT INTO `zone_import` VALUES ('5', 'GH'); INSERT INTO `zone_import` VALUES ('3', 'GI'); INSERT INTO `zone_import` VALUES ('5', 'GD'); INSERT INTO `zone_import` VALUES ('2', 'GR'); INSERT INTO `zone_import` VALUES ('5', 'GL'); INSERT INTO `zone_import` VALUES ('5', 'GP'); INSERT INTO `zone_import` VALUES ('5', 'GU'); INSERT INTO `zone_import` VALUES ('5', 'GT'); INSERT INTO `zone_import` VALUES ('5', 'GN'); INSERT INTO `zone_import` VALUES ('5', 'GW'); INSERT INTO `zone_import` VALUES ('5', 'GY'); INSERT INTO `zone_import` VALUES ('5', 'HT'); INSERT INTO `zone_import` VALUES ('5', 'HN'); INSERT INTO `zone_import` VALUES ('2b', 'HU'); INSERT INTO `zone_import` VALUES ('4', 'HK'); INSERT INTO `zone_import` VALUES ('2', 'IE'); INSERT INTO `zone_import` VALUES ('3', 'IS'); INSERT INTO `zone_import` VALUES ('4', 'IN'); INSERT INTO `zone_import` VALUES ('4', 'ID'); INSERT INTO `zone_import` VALUES ('5', 'IQ'); INSERT INTO `zone_import` VALUES ('5', 'IR'); INSERT INTO `zone_import` VALUES ('5', 'IL'); INSERT INTO `zone_import` VALUES ('2', 'IT'); INSERT INTO `zone_import` VALUES ('5', 'CI'); INSERT INTO `zone_import` VALUES ('5', 'JM'); INSERT INTO `zone_import` VALUES ('4', 'JP'); INSERT INTO `zone_import` VALUES ('5', 'YE'); INSERT INTO `zone_import` VALUES ('5', 'JO'); INSERT INTO `zone_import` VALUES ('5', 'CV'); INSERT INTO `zone_import` VALUES ('5', 'CM'); INSERT INTO `zone_import` VALUES ('5', 'KZ'); INSERT INTO `zone_import` VALUES ('5', 'KE'); INSERT INTO `zone_import` VALUES ('5', 'KG'); INSERT INTO `zone_import` VALUES ('5', 'KI'); INSERT INTO `zone_import` VALUES ('5', 'KW'); INSERT INTO `zone_import` VALUES ('3', 'XZ'); INSERT INTO `zone_import` VALUES ('3', 'HR'); INSERT INTO `zone_import` VALUES ('5', 'LA'); INSERT INTO `zone_import` VALUES ('5', 'LS'); INSERT INTO `zone_import` VALUES ('2b', 'LV'); INSERT INTO `zone_import` VALUES ('5', 'LB'); INSERT INTO `zone_import` VALUES ('5', 'LR'); INSERT INTO `zone_import` VALUES ('5', 'LY'); INSERT INTO `zone_import` VALUES ('3', 'LI'); INSERT INTO `zone_import` VALUES ('2b', 'LT'); INSERT INTO `zone_import` VALUES ('1', 'LU'); INSERT INTO `zone_import` VALUES ('5', 'VG'); INSERT INTO `zone_import` VALUES ('5', 'VI'); INSERT INTO `zone_import` VALUES ('4', 'MO'); INSERT INTO `zone_import` VALUES ('3', 'MK'); INSERT INTO `zone_import` VALUES ('5', 'MG'); INSERT INTO `zone_import` VALUES ('5', 'MW'); INSERT INTO `zone_import` VALUES ('5', 'MV'); INSERT INTO `zone_import` VALUES ('4', 'MY'); INSERT INTO `zone_import` VALUES ('5', 'ML'); INSERT INTO `zone_import` VALUES ('2b', 'MT'); INSERT INTO `zone_import` VALUES ('5', 'MA'); INSERT INTO `zone_import` VALUES ('5', 'MH'); INSERT INTO `zone_import` VALUES ('5', 'MQ'); INSERT INTO `zone_import` VALUES ('5', 'MR'); INSERT INTO `zone_import` VALUES ('5', 'MU'); INSERT INTO `zone_import` VALUES ('5', 'YT'); INSERT INTO `zone_import` VALUES ('5', 'MX'); INSERT INTO `zone_import` VALUES ('5', 'FM'); INSERT INTO `zone_import` VALUES ('3', 'MD'); INSERT INTO `zone_import` VALUES ('3', 'MC'); INSERT INTO `zone_import` VALUES ('5', 'MN'); INSERT INTO `zone_import` VALUES ('3', 'ME'); INSERT INTO `zone_import` VALUES ('5', 'MS'); INSERT INTO `zone_import` VALUES ('5', 'MZ'); INSERT INTO `zone_import` VALUES ('5', 'MM'); INSERT INTO `zone_import` VALUES ('5', 'NA'); INSERT INTO `zone_import` VALUES ('5', 'NR'); INSERT INTO `zone_import` VALUES ('5', 'AN'); INSERT INTO `zone_import` VALUES ('5', 'NP'); INSERT INTO `zone_import` VALUES ('5', 'NI'); INSERT INTO `zone_import` VALUES ('5', 'NC'); INSERT INTO `zone_import` VALUES ('5', 'NZ'); INSERT INTO `zone_import` VALUES ('5', 'NE'); INSERT INTO `zone_import` VALUES ('5', 'NG'); INSERT INTO `zone_import` VALUES ('5', 'MP'); INSERT INTO `zone_import` VALUES ('4', 'KP'); INSERT INTO `zone_import` VALUES ('3', 'NO'); INSERT INTO `zone_import` VALUES ('5', 'NF'); INSERT INTO `zone_import` VALUES ('5', 'UG'); INSERT INTO `zone_import` VALUES ('3', 'UA'); INSERT INTO `zone_import` VALUES ('5', 'UZ'); INSERT INTO `zone_import` VALUES ('5', 'OM'); INSERT INTO `zone_import` VALUES ('2', 'AT'); INSERT INTO `zone_import` VALUES ('5', 'TL'); INSERT INTO `zone_import` VALUES ('5', 'PK'); INSERT INTO `zone_import` VALUES ('5', 'PW'); INSERT INTO `zone_import` VALUES ('5', 'XP'); INSERT INTO `zone_import` VALUES ('5', 'PA'); INSERT INTO `zone_import` VALUES ('5', 'PG'); INSERT INTO `zone_import` VALUES ('5', 'PY'); INSERT INTO `zone_import` VALUES ('5', 'PE'); INSERT INTO `zone_import` VALUES ('2b', 'PL'); INSERT INTO `zone_import` VALUES ('2', 'PT'); INSERT INTO `zone_import` VALUES ('5', 'PR'); INSERT INTO `zone_import` VALUES ('5', 'QA'); INSERT INTO `zone_import` VALUES ('5', 'RE'); INSERT INTO `zone_import` VALUES ('2b', 'RO'); INSERT INTO `zone_import` VALUES ('3', 'RUM'); INSERT INTO `zone_import` VALUES ('5', 'RUO'); INSERT INTO `zone_import` VALUES ('3', 'RUSP'); INSERT INTO `zone_import` VALUES ('5', 'RW'); INSERT INTO `zone_import` VALUES ('5', 'PM'); INSERT INTO `zone_import` VALUES ('5', 'SB'); INSERT INTO `zone_import` VALUES ('3', 'SM'); INSERT INTO `zone_import` VALUES ('5', 'ST'); INSERT INTO `zone_import` VALUES ('5', 'SA'); INSERT INTO `zone_import` VALUES ('5', 'SN'); INSERT INTO `zone_import` VALUES ('3', 'RS'); INSERT INTO `zone_import` VALUES ('5', 'SC'); INSERT INTO `zone_import` VALUES ('5', 'SL'); INSERT INTO `zone_import` VALUES ('4', 'SG'); INSERT INTO `zone_import` VALUES ('2b', 'SI'); INSERT INTO `zone_import` VALUES ('2b', 'SK'); INSERT INTO `zone_import` VALUES ('5', 'SD'); INSERT INTO `zone_import` VALUES ('5', 'SO'); INSERT INTO `zone_import` VALUES ('2', 'ES'); INSERT INTO `zone_import` VALUES ('5', 'LK'); INSERT INTO `zone_import` VALUES ('5', 'KN'); INSERT INTO `zone_import` VALUES ('5', 'LC'); INSERT INTO `zone_import` VALUES ('5', 'VC'); INSERT INTO `zone_import` VALUES ('5', 'SR'); INSERT INTO `zone_import` VALUES ('5', 'SZ'); INSERT INTO `zone_import` VALUES ('5', 'SY'); INSERT INTO `zone_import` VALUES ('5', 'TJ'); INSERT INTO `zone_import` VALUES ('5', 'PF'); INSERT INTO `zone_import` VALUES ('4', 'TW'); INSERT INTO `zone_import` VALUES ('5', 'TI'); INSERT INTO `zone_import` VALUES ('4', 'TH'); INSERT INTO `zone_import` VALUES ('5', 'TG'); INSERT INTO `zone_import` VALUES ('5', 'TA'); INSERT INTO `zone_import` VALUES ('5', 'TT'); INSERT INTO `zone_import` VALUES ('5', 'TD'); INSERT INTO `zone_import` VALUES ('2b', 'CZ'); INSERT INTO `zone_import` VALUES ('5', 'TN'); INSERT INTO `zone_import` VALUES ('3', 'TR'); INSERT INTO `zone_import` VALUES ('5', 'TM'); INSERT INTO `zone_import` VALUES ('5', 'TC'); INSERT INTO `zone_import` VALUES ('5', 'TV'); INSERT INTO `zone_import` VALUES ('5', 'UY'); INSERT INTO `zone_import` VALUES ('5', 'VU'); INSERT INTO `zone_import` VALUES ('5', 'VA'); INSERT INTO `zone_import` VALUES ('5', 'VE'); INSERT INTO `zone_import` VALUES ('5', 'AE'); INSERT INTO `zone_import` VALUES ('2', 'GB'); INSERT INTO `zone_import` VALUES ('4', 'US'); INSERT INTO `zone_import` VALUES ('4', 'VN'); INSERT INTO `zone_import` VALUES ('5', 'WF'); INSERT INTO `zone_import` VALUES ('5', 'WS'); INSERT INTO `zone_import` VALUES ('3', 'BY'); INSERT INTO `zone_import` VALUES ('5', 'ZM'); INSERT INTO `zone_import` VALUES ('5', 'ZW'); INSERT INTO `zone_import` VALUES ('4', 'KR'); INSERT INTO `zone_import` VALUES ('5', 'ZA'); INSERT INTO `zone_import` VALUES ('2', 'SE'); INSERT INTO `zone_import` VALUES ('3', 'CH');