-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdialer_target.sql
50 lines (42 loc) · 8.99 KB
/
dialer_target.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
-- MySQL dump 10.9
--
-- Host: localhost Database: dialer_target
-- ------------------------------------------------------
-- Server version 4.1.20
/*!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 `countrycodes`
--
DROP TABLE IF EXISTS `countrycodes`;
CREATE TABLE `countrycodes` (
`name` varchar(64) default NULL,
`alpha2` char(2) NOT NULL default '',
`alpha3` char(3) NOT NULL default '',
`numeric_code` int(3) default NULL,
KEY `name` (`name`),
KEY `alpha2` (`alpha2`),
KEY `alpha3` (`alpha3`),
KEY `numeric_code` (`numeric_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `countrycodes`
--
/*!40000 ALTER TABLE `countrycodes` DISABLE KEYS */;
LOCK TABLES `countrycodes` WRITE;
INSERT INTO `countrycodes` VALUES ('AFGHANISTAN','AF','AFG',4),('ALBANIA','AL','ALB',8),('ALGERIA','DZ','DZA',12),('AMERICAN SAMOA','AS','ASM',16),('ANDORRA','AD','AND',20),('ANGOLA','AO','AGO',24),('ANGUILLA','AI','AIA',660),('ANTARCTICA','AQ','ATA',10),('ANTIGUA AND BARBUDA','AG','ATG',28),('ARGENTINA','AR','ARG',32),('ARMENIA','AM','ARM',51),('ARUBA','AW','ABW',533),('AUSTRALIA','AU','AUS',36),('AUSTRIA','AT','AUT',40),('AZERBAIJAN','AZ','AZE',31),('BAHAMAS','BS','BHS',44),('BAHRAIN','BH','BHR',48),('BANGLADESH','BD','BGD',50),('BARBADOS','BB','BRB',52),('BELARUS','BY','BLR',112),('BELGIUM','BE','BEL',56),('BELIZE','BZ','BLZ',84),('BENIN','BJ','BEN',204),('BERMUDA','BM','BMU',60),('BHUTAN','BT','BTN',64),('BOLIVIA','BO','BOL',68),('BOSNIA AND HERZEGOWINA','BA','BIH',70),('BOTSWANA','BW','BWA',72),('BOUVET ISLAND','BV','BVT',74),('BRAZIL','BR','BRA',76),('BRITISH INDIAN OCEAN TERRITORY','IO','IOT',86),('BRUNEI DARUSSALAM','BN','BRN',96),('BULGARIA','BG','BGR',100),('BURKINA FASO','BF','BFA',854),('BURUNDI','BI','BDI',108),('CAMBODIA','KH','KHM',116),('CAMEROON','CM','CMR',120),('CANADA','CA','CAN',124),('CAPE VERDE','CV','CPV',132),('CAYMAN ISLANDS','KY','CYM',136),('CENTRAL AFRICAN REPUBLIC','CF','CAF',140),('CHAD','TD','TCD',148),('CHILE','CL','CHL',152),('CHINA','CN','CHN',156),('CHRISTMAS ISLAND','CX','CXR',162),('COCOS (KEELING) ISLANDS','CC','CCK',166),('COLOMBIA','CO','COL',170),('COMOROS','KM','COM',174),('CONGO, Democratic Republic of (was Zaire)','CD','COD',180),('CONGO, People\'s Republic of','CG','COG',178),('COOK ISLANDS','CK','COK',184),('COSTA RICA','CR','CRI',188),('COTE D\'IVOIRE','CI','CIV',384),('CROATIA (local name: Hrvatska)','HR','HRV',191),('CUBA','CU','CUB',192),('CYPRUS','CY','CYP',196),('CZECH REPUBLIC','CZ','CZE',203),('DENMARK','DK','DNK',208),('DJIBOUTI','DJ','DJI',262),('DOMINICA','DM','DMA',212),('DOMINICAN REPUBLIC','DO','DOM',214),('EAST TIMOR','TL','TLS',626),('ECUADOR','EC','ECU',218),('EGYPT','EG','EGY',818),('EL SALVADOR','SV','SLV',222),('EQUATORIAL GUINEA','GQ','GNQ',226),('ERITREA','ER','ERI',232),('ESTONIA','EE','EST',233),('ETHIOPIA','ET','ETH',231),('FALKLAND ISLANDS (MALVINAS)','FK','FLK',238),('FAROE ISLANDS','FO','FRO',234),('FIJI','FJ','FJI',242),('FINLAND','FI','FIN',246),('FRANCE','FR','FRA',250),('FRANCE, METROPOLITAN','FX','FXX',249),('FRENCH GUIANA','GF','GUF',254),('FRENCH POLYNESIA','PF','PYF',258),('FRENCH SOUTHERN TERRITORIES','TF','ATF',260),('GABON','GA','GAB',266),('GAMBIA','GM','GMB',270),('GEORGIA','GE','GEO',268),('GERMANY','DE','DEU',276),('GHANA','GH','GHA',288),('GIBRALTAR','GI','GIB',292),('GREECE','GR','GRC',300),('GREENLAND','GL','GRL',304),('GRENADA','GD','GRD',308),('GUADELOUPE','GP','GLP',312),('GUAM','GU','GUM',316),('GUATEMALA','GT','GTM',320),('GUINEA','GN','GIN',324),('GUINEA-BISSAU','GW','GNB',624),('GUYANA','GY','GUY',328),('HAITI','HT','HTI',332),('HEARD AND MC DONALD ISLANDS','HM','HMD',334),('HONDURAS','HN','HND',340),('HONG KONG','HK','HKG',344),('HUNGARY','HU','HUN',348),('ICELAND','IS','ISL',352),('INDIA','IN','IND',356),('INDONESIA','ID','IDN',360),('IRAN (ISLAMIC REPUBLIC OF)','IR','IRN',364),('IRAQ','IQ','IRQ',368),('IRELAND','IE','IRL',372),('ISRAEL','IL','ISR',376),('ITALY','IT','ITA',380),('JAMAICA','JM','JAM',388),('JAPAN','JP','JPN',392),('JORDAN','JO','JOR',400),('KAZAKHSTAN','KZ','KAZ',398),('KENYA','KE','KEN',404),('KIRIBATI','KI','KIR',296),('KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','KP','PRK',408),('KOREA, REPUBLIC OF','KR','KOR',410),('KUWAIT','KW','KWT',414),('KYRGYZSTAN','KG','KGZ',417),('LAO PEOPLE\'S DEMOCRATIC REPUBLIC','LA','LAO',418),('LATVIA','LV','LVA',428),('LEBANON','LB','LBN',422),('LESOTHO','LS','LSO',426),('LIBERIA','LR','LBR',430),('LIBYAN ARAB JAMAHIRIYA','LY','LBY',434),('LIECHTENSTEIN','LI','LIE',438),('LITHUANIA','LT','LTU',440),('LUXEMBOURG','LU','LUX',442),('MACAU','MO','MAC',446),('MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','MK','MKD',807),('MADAGASCAR','MG','MDG',450),('MALAWI','MW','MWI',454),('MALAYSIA','MY','MYS',458),('MALDIVES','MV','MDV',462),('MALI','ML','MLI',466),('MALTA','MT','MLT',470),('MARSHALL ISLANDS','MH','MHL',584),('MARTINIQUE','MQ','MTQ',474),('MAURITANIA','MR','MRT',478),('MAURITIUS','MU','MUS',480),('MAYOTTE','YT','MYT',175),('MEXICO','MX','MEX',484),('MICRONESIA, FEDERATED STATES OF','FM','FSM',583),('MOLDOVA, REPUBLIC OF','MD','MDA',498),('MONACO','MC','MCO',492),('MONGOLIA','MN','MNG',496),('MONTSERRAT','MS','MSR',500),('MOROCCO','MA','MAR',504),('MOZAMBIQUE','MZ','MOZ',508),('MYANMAR','MM','MMR',104),('NAMIBIA','NA','NAM',516),('NAURU','NR','NRU',520),('NEPAL','NP','NPL',524),('NETHERLANDS','NL','NLD',528),('NETHERLANDS ANTILLES','AN','ANT',530),('NEW CALEDONIA','NC','NCL',540),('NEW ZEALAND','NZ','NZL',554),('NICARAGUA','NI','NIC',558),('NIGER','NE','NER',562),('NIGERIA','NG','NGA',566),('NIUE','NU','NIU',570),('NORFOLK ISLAND','NF','NFK',574),('NORTHERN MARIANA ISLANDS','MP','MNP',580),('NORWAY','NO','NOR',578),('OMAN','OM','OMN',512),('PAKISTAN','PK','PAK',586),('PALAU','PW','PLW',585),('PALESTINIAN TERRITORY, Occupied','PS','PSE',275),('PANAMA','PA','PAN',591),('PAPUA NEW GUINEA','PG','PNG',598),('PARAGUAY','PY','PRY',600),('PERU','PE','PER',604),('PHILIPPINES','PH','PHL',608),('PITCAIRN','PN','PCN',612),('POLAND','PL','POL',616),('PORTUGAL','PT','PRT',620),('PUERTO RICO','PR','PRI',630),('QATAR','QA','QAT',634),('REUNION','RE','REU',638),('ROMANIA','RO','ROU',642),('RUSSIAN FEDERATION','RU','RUS',643),('RWANDA','RW','RWA',646),('SAINT KITTS AND NEVIS','KN','KNA',659),('SAINT LUCIA','LC','LCA',662),('SAINT VINCENT AND THE GRENADINES','VC','VCT',670),('SAMOA','WS','WSM',882),('SAN MARINO','SM','SMR',674),('SAO TOME AND PRINCIPE','ST','STP',678),('SAUDI ARABIA','SA','SAU',682),('SENEGAL','SN','SEN',686),('SEYCHELLES','SC','SYC',690),('SIERRA LEONE','SL','SLE',694),('SINGAPORE','SG','SGP',702),('SLOVAKIA (Slovak Republic)','SK','SVK',703),('SLOVENIA','SI','SVN',705),('SOLOMON ISLANDS','SB','SLB',90),('SOMALIA','SO','SOM',706),('SOUTH AFRICA','ZA','ZAF',710),('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','GS','SGS',239),('SPAIN','ES','ESP',724),('SRI LANKA','LK','LKA',144),('ST. HELENA','SH','SHN',654),('ST. PIERRE AND MIQUELON','PM','SPM',666),('SUDAN','SD','SDN',736),('SURINAME','SR','SUR',740),('SVALBARD AND JAN MAYEN ISLANDS','SJ','SJM',744),('SWAZILAND','SZ','SWZ',748),('SWEDEN','SE','SWE',752),('SWITZERLAND','CH','CHE',756),('SYRIAN ARAB REPUBLIC','SY','SYR',760),('TAIWAN','TW','TWN',158),('TAJIKISTAN','TJ','TJK',762),('TANZANIA, UNITED REPUBLIC OF','TZ','TZA',834),('THAILAND','TH','THA',764),('TOGO','TG','TGO',768),('TOKELAU','TK','TKL',772),('TONGA','TO','TON',776),('TRINIDAD AND TOBAGO','TT','TTO',780),('TUNISIA','TN','TUN',788),('TURKEY','TR','TUR',792),('TURKMENISTAN','TM','TKM',795),('TURKS AND CAICOS ISLANDS','TC','TCA',796),('TUVALU','TV','TUV',798),('UGANDA','UG','UGA',800),('UKRAINE','UA','UKR',804),('UNITED ARAB EMIRATES','AE','ARE',784),('UNITED KINGDOM','GB','GBR',826),('UNITED STATES','US','USA',840),('UNITED STATES MINOR OUTLYING ISLANDS','UM','UMI',581),('URUGUAY','UY','URY',858),('UZBEKISTAN','UZ','UZB',860),('VANUATU','VU','VUT',548),('VATICAN CITY STATE (HOLY SEE)','VA','VAT',336),('VENEZUELA','VE','VEN',862),('VIET NAM','VN','VNM',704),('VIRGIN ISLANDS (BRITISH)','VG','VGB',92),('VIRGIN ISLANDS (U.S.)','VI','VIR',850),('WALLIS AND FUTUNA ISLANDS','WF','WLF',876),('WESTERN SAHARA','EH','ESH',732),('YEMEN','YE','YEM',887),('YUGOSLAVIA','YU','YUG',891),('ZAMBIA','ZM','ZMB',894),('ZIMBABWE','ZW','ZWE',716);
UNLOCK TABLES;
/*!40000 ALTER TABLE `countrycodes` 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 */;