· 7 years ago · Oct 15, 2018, 09:20 PM
1-- Adminer 3.3.1 MySQL dump
2
3SET NAMES utf8;
4SET foreign_key_checks = 0;
5SET time_zone = 'SYSTEM';
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `countries`;
9CREATE TABLE `countries` (
10 `id` int(11) NOT NULL,
11 `code` char(2) NOT NULL,
12 `name` varchar(200) default NULL,
13 `prefix` varchar(50) default NULL,
14 PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16
17INSERT INTO `countries` (`id`, `code`, `name`, `prefix`) VALUES
18(1, 'AF', 'Afghanistan', '+93'),
19(2, 'AL', 'Albania', '+355'),
20(3, 'DZ', 'Algeria', '+213'),
21(4, 'AD', 'Andorra', '+376'),
22(5, 'AO', 'Angola', '+244'),
23(6, 'AG', 'Antigua and Barbuda', '+1-268'),
24(7, 'AR', 'Argentina', '+54'),
25(8, 'AM', 'Armenia', '+374'),
26(9, 'AU', 'Australia', '+61'),
27(10, 'AT', 'Austria', '+43'),
28(11, 'AZ', 'Azerbaijan', '+994'),
29(12, 'BS', 'Bahamas, The', '+1-242'),
30(13, 'BH', 'Bahrain', '+973'),
31(14, 'BD', 'Bangladesh', '+880'),
32(15, 'BB', 'Barbados', '+1-246'),
33(16, 'BY', 'Belarus', '+375'),
34(17, 'BE', 'Belgium', '+32'),
35(18, 'BZ', 'Belize', '+501'),
36(19, 'BJ', 'Benin', '+229'),
37(20, 'BT', 'Bhutan', '+975'),
38(21, 'BO', 'Bolivia', '+591'),
39(22, 'BA', 'Bosnia and Herzegovina', '+387'),
40(23, 'BW', 'Botswana', '+267'),
41(24, 'BR', 'Brazil', '+55'),
42(25, 'BN', 'Brunei', '+673'),
43(26, 'BG', 'Bulgaria', '+359'),
44(27, 'BF', 'Burkina Faso', '+226'),
45(28, 'BI', 'Burundi', '+257'),
46(29, 'KH', 'Cambodia', '+855'),
47(30, 'CM', 'Cameroon', '+237'),
48(31, 'CA', 'Canada', '+1'),
49(32, 'CV', 'Cape Verde', '+238'),
50(33, 'CF', 'Central African Republic', '+236'),
51(34, 'TD', 'Chad', '+235'),
52(35, 'CL', 'Chile', '+56'),
53(36, 'CN', 'China, People\'s Republic of', '+86'),
54(37, 'CO', 'Colombia', '+57'),
55(38, 'KM', 'Comoros', '+269'),
56(39, 'CD', 'Congo, Democratic Republic of the (Congo ? Kinshasa)', '+243'),
57(40, 'CG', 'Congo, Republic of the (Congo ? Brazzaville)', '+242'),
58(41, 'CR', 'Costa Rica', '+506'),
59(42, 'CI', 'Cote d\'Ivoire (Ivory Coast)', '+225'),
60(43, 'HR', 'Croatia', '+385'),
61(44, 'CU', 'Cuba', '+53'),
62(45, 'CY', 'Cyprus', '+357'),
63(46, 'CZ', 'Czech Republic', '+420'),
64(47, 'DK', 'Denmark', '+45'),
65(48, 'DJ', 'Djibouti', '+253'),
66(49, 'DM', 'Dominica', '+1-767'),
67(50, 'DO', 'Dominican Republic', '+1-809 and 1-829'),
68(51, 'EC', 'Ecuador', '+593'),
69(52, 'EG', 'Egypt', '+20'),
70(53, 'SV', 'El Salvador', '+503'),
71(54, 'GQ', 'Equatorial Guinea', '+240'),
72(55, 'ER', 'Eritrea', '+291'),
73(56, 'EE', 'Estonia', '+372'),
74(57, 'ET', 'Ethiopia', '+251'),
75(58, 'FJ', 'Fiji', '+679'),
76(59, 'FI', 'Finland', '+358'),
77(60, 'FR', 'France', '+33'),
78(61, 'GA', 'Gabon', '+241'),
79(62, 'GM', 'Gambia, The', '+220'),
80(63, 'GE', 'Georgia', '+995'),
81(64, 'DE', 'Germany', '+49'),
82(65, 'GH', 'Ghana', '+233'),
83(66, 'GR', 'Greece', '+30'),
84(67, 'GD', 'Grenada', '+1-473'),
85(68, 'GT', 'Guatemala', '+502'),
86(69, 'GN', 'Guinea', '+224'),
87(70, 'GW', 'Guinea-Bissau', '+245'),
88(71, 'GY', 'Guyana', '+592'),
89(72, 'HT', 'Haiti', '+509'),
90(73, 'HN', 'Honduras', '+504'),
91(74, 'HU', 'Hungary', '+36'),
92(75, 'IS', 'Iceland', '+354'),
93(76, 'IN', 'India', '+91'),
94(77, 'ID', 'Indonesia', '+62'),
95(78, 'IR', 'Iran', '+98'),
96(79, 'IQ', 'Iraq', '+964'),
97(80, 'IE', 'Ireland', '+353'),
98(81, 'IL', 'Israel', '+972'),
99(82, 'IT', 'Italy', '+39'),
100(83, 'JM', 'Jamaica', '+1-876'),
101(84, 'JP', 'Japan', '+81'),
102(85, 'JO', 'Jordan', '+962'),
103(86, 'KZ', 'Kazakhstan', '+7'),
104(87, 'KE', 'Kenya', '+254'),
105(88, 'KI', 'Kiribati', '+686'),
106(89, 'KP', 'Korea, Democratic People\'s Republic of (North Korea)', '+850'),
107(90, 'KR', 'Korea, Republic of (South Korea)', '+82'),
108(91, 'KW', 'Kuwait', '+965'),
109(92, 'KG', 'Kyrgyzstan', '+996'),
110(93, 'LA', 'Laos', '+856'),
111(94, 'LV', 'Latvia', '+371'),
112(95, 'LB', 'Lebanon', '+961'),
113(96, 'LS', 'Lesotho', '+266'),
114(97, 'LR', 'Liberia', '+231'),
115(98, 'LY', 'Libya', '+218'),
116(99, 'LI', 'Liechtenstein', '+423'),
117(100, 'LT', 'Lithuania', '+370'),
118(101, 'LU', 'Luxembourg', '+352'),
119(102, 'MK', 'Macedonia', '+389'),
120(103, 'MG', 'Madagascar', '+261'),
121(104, 'MW', 'Malawi', '+265'),
122(105, 'MY', 'Malaysia', '+60'),
123(106, 'MV', 'Maldives', '+960'),
124(107, 'ML', 'Mali', '+223'),
125(108, 'MT', 'Malta', '+356'),
126(109, 'MH', 'Marshall Islands', '+692'),
127(110, 'MR', 'Mauritania', '+222'),
128(111, 'MU', 'Mauritius', '+230'),
129(112, 'MX', 'Mexico', '+52'),
130(113, 'FM', 'Micronesia', '+691'),
131(114, 'MD', 'Moldova', '+373'),
132(115, 'MC', 'Monaco', '+377'),
133(116, 'MN', 'Mongolia', '+976'),
134(117, 'ME', 'Montenegro', '+382'),
135(118, 'MA', 'Morocco', '+212'),
136(119, 'MZ', 'Mozambique', '+258'),
137(120, 'MM', 'Myanmar (Burma)', '+95'),
138(121, 'NA', 'Namibia', '+264'),
139(122, 'NR', 'Nauru', '+674'),
140(123, 'NP', 'Nepal', '+977'),
141(124, 'NL', 'Netherlands', '+31'),
142(125, 'NZ', 'New Zealand', '+64'),
143(126, 'NI', 'Nicaragua', '+505'),
144(127, 'NE', 'Niger', '+227'),
145(128, 'NG', 'Nigeria', '+234'),
146(129, 'NO', 'Norway', '+47'),
147(130, 'OM', 'Oman', '+968'),
148(131, 'PK', 'Pakistan', '+92'),
149(132, 'PW', 'Palau', '+680'),
150(133, 'PA', 'Panama', '+507'),
151(134, 'PG', 'Papua New Guinea', '+675'),
152(135, 'PY', 'Paraguay', '+595'),
153(136, 'PE', 'Peru', '+51'),
154(137, 'PH', 'Philippines', '+63'),
155(138, 'PL', 'Poland', '+48'),
156(139, 'PT', 'Portugal', '+351'),
157(140, 'QA', 'Qatar', '+974'),
158(141, 'RO', 'Romania', '+40'),
159(142, 'RU', 'Russia', '+7'),
160(143, 'RW', 'Rwanda', '+250'),
161(144, 'KN', 'Saint Kitts and Nevis', '+1-869'),
162(145, 'LC', 'Saint Lucia', '+1-758'),
163(146, 'VC', 'Saint Vincent and the Grenadines', '+1-784'),
164(147, 'WS', 'Samoa', '+685'),
165(148, 'SM', 'San Marino', '+378'),
166(149, 'ST', 'Sao Tome and Principe', '+239'),
167(150, 'SA', 'Saudi Arabia', '+966'),
168(151, 'SN', 'Senegal', '+221'),
169(152, 'RS', 'Serbia', '+381'),
170(153, 'SC', 'Seychelles', '+248'),
171(154, 'SL', 'Sierra Leone', '+232'),
172(155, 'SG', 'Singapore', '+65'),
173(156, 'SK', 'Slovakia', '+421'),
174(157, 'SI', 'Slovenia', '+386'),
175(158, 'SB', 'Solomon Islands', '+677'),
176(159, 'SO', 'Somalia', '+252'),
177(160, 'ZA', 'South Africa', '+27'),
178(161, 'ES', 'Spain', '+34'),
179(162, 'LK', 'Sri Lanka', '+94'),
180(163, 'SD', 'Sudan', '+249'),
181(164, 'SR', 'Suriname', '+597'),
182(165, 'SZ', 'Swaziland', '+268'),
183(166, 'SE', 'Sweden', '+46'),
184(167, 'CH', 'Switzerland', '+41'),
185(168, 'SY', 'Syria', '+963'),
186(169, 'TJ', 'Tajikistan', '+992'),
187(170, 'TZ', 'Tanzania', '+255'),
188(171, 'TH', 'Thailand', '+66'),
189(172, 'TL', 'Timor-Leste (East Timor)', '+670'),
190(173, 'TG', 'Togo', '+228'),
191(174, 'TO', 'Tonga', '+676'),
192(175, 'TT', 'Trinidad and Tobago', '+1-868'),
193(176, 'TN', 'Tunisia', '+216'),
194(177, 'TR', 'Turkey', '+90'),
195(178, 'TM', 'Turkmenistan', '+993'),
196(179, 'TV', 'Tuvalu', '+688'),
197(180, 'UG', 'Uganda', '+256'),
198(181, 'UA', 'Ukraine', '+380'),
199(182, 'AE', 'United Arab Emirates', '+971'),
200(183, 'GB', 'United Kingdom', '+44'),
201(184, 'US', 'United States', '+1'),
202(185, 'UY', 'Uruguay', '+598'),
203(186, 'UZ', 'Uzbekistan', '+998'),
204(187, 'VU', 'Vanuatu', '+678'),
205(188, 'VA', 'Vatican City', '+379'),
206(189, 'VE', 'Venezuela', '+58'),
207(190, 'VN', 'Viet Nam', '+84'),
208(191, 'YE', 'Yemen', '+967'),
209(192, 'ZM', 'Zambia', '+260'),
210(193, 'ZW', 'Zimbabwe', '+263'),
211(194, 'GE', 'Abkhazia', '+995'),
212(195, 'TW', 'China, Republic of (Taiwan)', '+886'),
213(196, 'AZ', 'Nagorno-Karabakh', '+374-97'),
214(197, 'CY', 'Northern Cyprus', '+90-392'),
215(198, 'MD', 'Pridnestrovie (Transnistria)', '+373-533'),
216(199, 'SO', 'Somaliland', '+252'),
217(200, 'GE', 'South Ossetia', '+995'),
218(201, 'AU', 'Ashmore and Cartier Islands', ''),
219(202, 'CX', 'Christmas Island', '+61'),
220(203, 'CC', 'Cocos (Keeling) Islands', '+61'),
221(204, 'AU', 'Coral Sea Islands', ''),
222(205, 'HM', 'Heard Island and McDonald Islands', ''),
223(206, 'NF', 'Norfolk Island', '+672'),
224(207, 'NC', 'New Caledonia', '+687'),
225(208, 'PF', 'French Polynesia', '+689'),
226(209, 'YT', 'Mayotte', '+269'),
227(210, 'PM', 'Saint Pierre and Miquelon', '+508'),
228(211, 'WF', 'Wallis and Futuna', '+681'),
229(212, 'TF', 'French Southern and Antarctic Lands', ''),
230(213, 'PF', 'Clipperton Island', ''),
231(214, '', 'French Scattered Islands in the Indian Ocean', ''),
232(215, 'BV', 'Bouvet Island', ''),
233(216, 'CK', 'Cook Islands', '+682'),
234(217, 'NU', 'Niue', '+683'),
235(218, 'TK', 'Tokelau', '+690'),
236(219, 'GG', 'Guernsey', '+44'),
237(220, 'IM', 'Isle of Man', '+44'),
238(221, 'JE', 'Jersey', '+44'),
239(222, 'AI', 'Anguilla', '+1-264'),
240(223, 'BM', 'Bermuda', '+1-441'),
241(224, 'IO', 'British Indian Ocean Territory', '+246'),
242(225, '', 'British Sovereign Base Areas', '+357'),
243(226, 'VG', 'British Virgin Islands', '+1-284'),
244(227, 'KY', 'Cayman Islands', '+1-345'),
245(228, 'FK', 'Falkland Islands (Islas Malvinas)', '+500'),
246(229, 'GI', 'Gibraltar', '+350'),
247(230, 'MS', 'Montserrat', '+1-664'),
248(231, 'PN', 'Pitcairn Islands', ''),
249(232, 'SH', 'Saint Helena', '+290'),
250(233, 'GS', 'South Georgia and the South Sandwich Islands', ''),
251(234, 'TC', 'Turks and Caicos Islands', '+1-649'),
252(235, 'MP', 'Northern Mariana Islands', '+1-670'),
253(236, 'PR', 'Puerto Rico', '+1-787 and 1-939'),
254(237, 'AS', 'American Samoa', '+1-684'),
255(238, 'UM', 'Baker Island', ''),
256(239, 'GU', 'Guam', '+1-671'),
257(240, 'UM', 'Howland Island', ''),
258(241, 'UM', 'Jarvis Island', ''),
259(242, 'UM', 'Johnston Atoll', ''),
260(243, 'UM', 'Kingman Reef', ''),
261(244, 'UM', 'Midway Islands', ''),
262(245, 'UM', 'Navassa Island', ''),
263(246, 'UM', 'Palmyra Atoll', ''),
264(247, 'VI', 'U.S. Virgin Islands', '+1-340'),
265(248, 'UM', 'Wake Island', ''),
266(249, 'HK', 'Hong Kong', '+852'),
267(250, 'MO', 'Macau', '+853'),
268(251, 'FO', 'Faroe Islands', '+298'),
269(252, 'GL', 'Greenland', '+299'),
270(253, 'GF', 'French Guiana', '+594'),
271(254, 'GP', 'Guadeloupe', '+590'),
272(255, 'MQ', 'Martinique', '+596'),
273(256, 'RE', 'Reunion', '+262'),
274(257, 'AX', 'Aland', '+358-18'),
275(258, 'AW', 'Aruba', '+297'),
276(259, 'AN', 'Netherlands Antilles', '+599'),
277(260, 'SJ', 'Svalbard', '+47'),
278(261, 'AC', 'Ascension', '+247'),
279(262, 'TA', 'Tristan da Cunha', ''),
280(263, 'AQ', 'Antarctica', ''),
281(264, 'CS', 'Kosovo', '+381'),
282(265, 'PS', 'Palestinian Territories (Gaza Strip and West Bank)', '+970'),
283(266, 'EH', 'Western Sahara', '+212'),
284(267, 'AQ', 'Australian Antarctic Territory', ''),
285(268, 'AQ', 'Ross Dependency', ''),
286(269, 'AQ', 'Peter I Island', ''),
287(270, 'AQ', 'Queen Maud Land', ''),
288(271, 'AQ', 'British Antarctic Territory', '');
289
290-- 2011-08-17 14:19:26