Created
November 10, 2009 10:04
-
-
Save mattfawcett/230783 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | |
-- -------------------------------------------------------- | |
-- | |
-- Table structure for table `dialing_codes` | |
-- | |
CREATE TABLE IF NOT EXISTS `dialing_codes` ( | |
`Country` varchar(128) NOT NULL, | |
`Code` varchar(64) NOT NULL, | |
PRIMARY KEY (`Country`) | |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; | |
-- | |
-- Dumping data for table `dialing_codes` | |
-- | |
INSERT INTO `dialing_codes` (`Country`, `Code`) VALUES | |
('Afghanistan', '+93'), | |
('Albania', '+355'), | |
('Algeria', '+213'), | |
('Andorra ', '+376'), | |
('Angola ', '+244'), | |
('Antarctica', '+672'), | |
('Argentina', '+54'), | |
('Armenia ', '+374'), | |
('Aruba', '+297'), | |
('Ascension', '+247'), | |
('Australia ', '+61'), | |
('Australian External Territories', '+672'), | |
('Austria', '+43'), | |
('Azerbaijan', '+994'), | |
('Bahrain', '+973'), | |
('Bangladesh', '+880'), | |
('Belarus', '+375'), | |
('Belgium', '+32'), | |
('Belize', '+501'), | |
('Benin', '+229'), | |
('Bhutan', '+975'), | |
('Bolivia ', '+591'), | |
('Bosnia & Herzegovina ', '+387'), | |
('Botswana ', '+267'), | |
('Brazil ', '+55'), | |
('Brunei Darussalam', '+673'), | |
('Bulgaria', '+359'), | |
('Burkina Faso ', '+226'), | |
('Burundi', '+257'), | |
('Cambodia', '+855'), | |
('Cameroon', '+237'), | |
('Canada', '+1'), | |
('Cape Verde Islands', '+238'), | |
('Central African Republic', '+236'), | |
('Chad ', '+235'), | |
('Chatham Island (New Zealand)', '+64'), | |
('Chile ', '+56'), | |
('China (PRC)', '+86'), | |
('Christmas Island', '+61-8'), | |
('Cocos-Keeling Islands', '+61'), | |
('Colombia ', '+57'), | |
('Comoros', '+269'), | |
('Congo', '+242'), | |
('Congo, Dem. Rep. of? (former Zaire) ', '+243'), | |
('Cook Islands', '+682'), | |
('Costa Rica', '+506'), | |
('Cote d''Ivoire (Ivory Coast)', '+225'), | |
('Croatia', '+385'), | |
('Cuba', '+53'), | |
('Cuba (Guantanamo Bay)', '+5399'), | |
('Curacao', '+599'), | |
('Cyprus', '+357'), | |
('Czech Republic', '+420'), | |
('Denmark', '+45'), | |
('Diego Garcia', '+246'), | |
('Djibouti', '+253'), | |
('East Timor', '+670'), | |
('Easter Island', '+56'), | |
('Ecuador ', '+593'), | |
('Egypt', '+20'), | |
('El Salvador', '+503'), | |
('Equatorial Guinea', '+240'), | |
('Eritrea', '+291'), | |
('Estonia', '+372'), | |
('Ethiopia', '+251'), | |
('Falkland Islands (Malvinas)', '+500'), | |
('Faroe Islands', '+298'), | |
('Fiji Islands', '+679'), | |
('Finland', '+358'), | |
('France', '+33'), | |
('French Antilles', '+596'), | |
('French Guiana', '+594'), | |
('French Polynesia', '+689'), | |
('Gabonese Republic', '+241'), | |
('Gambia', '+220'), | |
('Georgia', '+995'), | |
('Germany', '+49'), | |
('Ghana ', '+233'), | |
('Gibraltar ', '+350'), | |
('Greece ', '+30'), | |
('Greenland ', '+299'), | |
('Guadeloupe', '+590'), | |
('Guantanamo Bay', '+5399'), | |
('Guatemala ', '+502'), | |
('Guinea-Bissau ', '+245'), | |
('Guinea', '+224'), | |
('Guyana', '+592'), | |
('Haiti ', '+509'), | |
('Honduras', '+504'), | |
('Hong Kong', '+852'), | |
('Hungary ', '+36'), | |
('Iceland', '+354'), | |
('India', '+91'), | |
('Indonesia', '+62'), | |
('Iran', '+98'), | |
('Iraq', '+964'), | |
('Ireland', '+353'), | |
('Israel ', '+972'), | |
('Italy ', '+39'), | |
('Japan ', '+81'), | |
('Jordan', '+962'), | |
('Kazakhstan', '+7'), | |
('Kenya', '+254'), | |
('Kiribati ', '+686'), | |
('Korea (North)', '+850'), | |
('Korea (South)', '+82'), | |
('Kuwait ', '+965'), | |
('Kyrgyz Republic', '+996'), | |
('Laos', '+856'), | |
('Latvia ', '+371'), | |
('Lebanon', '+961'), | |
('Lesotho', '+266'), | |
('Liberia', '+231'), | |
('Libya', '+218'), | |
('Liechtenstein', '+423'), | |
('Lithuania ', '+370'), | |
('Luxembourg', '+352'), | |
('Macao', '+853'), | |
('Macedonia (Former Yugoslav Rep of.)', '+389'), | |
('Madagascar', '+261'), | |
('Malawi ', '+265'), | |
('Malaysia', '+60'), | |
('Maldives', '+960'), | |
('Mali Republic', '+223'), | |
('Malta', '+356'), | |
('Marshall Islands', '+692'), | |
('Martinique', '+596'), | |
('Mauritania', '+222'), | |
('Mauritius', '+230'), | |
('Mayotte Island', '+269'), | |
('Mexico', '+52'), | |
('Micronesia, (Federal States of)', '+691'), | |
('Moldova ', '+373'), | |
('Monaco', '+377'), | |
('Mongolia ', '+976'), | |
('Montenegro', '+382'), | |
('Morocco', '+212'), | |
('Mozambique', '+258'), | |
('Myanmar', '+95'), | |
('Namibia', '+264'), | |
('Nauru', '+674'), | |
('Nepal ', '+977'), | |
('Netherlands', '+31'), | |
('Netherlands Antilles', '+599'), | |
('New Caledonia', '+687'), | |
('New Zealand', '+64'), | |
('Nicaragua', '+505'), | |
('Niger', '+227'), | |
('Nigeria', '+234'), | |
('Niue', '+683'), | |
('Norfolk Island', '+672'), | |
('Norway ', '+47'), | |
('Oman', '+968'), | |
('Pakistan', '+92'), | |
('Palau', '+680'), | |
('Palestinian Settlements', '+970'), | |
('Panama', '+507'), | |
('Papua New Guinea', '+675'), | |
('Paraguay', '+595'), | |
('Peru', '+51'), | |
('Philippines', '+63'), | |
('Poland', '+48'), | |
('Portugal', '+351'), | |
('Qatar', '+974'), | |
('R?union Island', '+262'), | |
('Romania', '+40'), | |
('Russia', '+7'), | |
('Rwandese Republic', '+250'), | |
('St. Helena', '+290'), | |
('St. Pierre & Miquelon', '+508'), | |
('Samoa', '+685'), | |
('San Marino', '+378'), | |
('S?o Tom? and Principe', '+239'), | |
('Saudi Arabia', '+966'), | |
('Senegal ', '+221'), | |
('Serbia', '+381'), | |
('Seychelles Republic', '+248'), | |
('Sierra Leone', '+232'), | |
('Singapore', '+65'), | |
('Slovak Republic', '+421'), | |
('Slovenia ', '+386'), | |
('Solomon Islands', '+677'), | |
('Somali Democratic Republic', '+252'), | |
('South Africa', '+27'), | |
('Spain', '+34'), | |
('Sri Lanka', '+94'), | |
('Sudan', '+249'), | |
('Suriname ', '+597'), | |
('Swaziland', '+268'), | |
('Sweden', '+46'), | |
('Switzerland', '+41'), | |
('Syria', '+963'), | |
('Taiwan', '+886'), | |
('Tajikistan', '+992'), | |
('Tanzania', '+255'), | |
('Thailand', '+66'), | |
('Timor Leste', '+670'), | |
('Togolese Republic', '+228'), | |
('Tokelau', '+690'), | |
('Tonga Islands', '+676'), | |
('Tunisia', '+216'), | |
('Turkey', '+90'), | |
('Turkmenistan ', '+993'), | |
('Tuvalu', '+688'), | |
('Uganda', '+256'), | |
('Ukraine', '+380'), | |
('United Arab Emirates', '+971'), | |
('United Kingdom', '+44'), | |
('United States of America', '+1'), | |
('Universal Personal Telecommunications (UPT)', '+878'), | |
('Uruguay', '+598'), | |
('Uzbekistan', '+998'), | |
('Vanuatu', '+678'), | |
('Vatican City', '+39'), | |
('Venezuela', '+58'), | |
('Vietnam', '+84'), | |
('Wake Island', '+808'), | |
('Wallis and Futuna Islands', '+681'), | |
('Yemen', '+967'), | |
('Zambia ', '+260'), | |
('Zanzibar', '+255'), | |
('Zimbabwe ', '+263'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment