/[drupal]/contributions/modules/ip2cc/iso3166.mysql
ViewVC logotype

Contents of /contributions/modules/ip2cc/iso3166.mysql

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph


Revision 1.3 - (show annotations) (download)
Wed Feb 21 07:52:47 2007 UTC (2 years, 9 months ago) by sugree
Branch: MAIN
CVS Tags: HEAD
Changes since 1.2: +243 -256 lines
merged from DRUPAL-5
1 INSERT INTO {iso3166} VALUES ('AF','AFG',"Afghanistan",004);
2 INSERT INTO {iso3166} VALUES ('AL','ALB',"Albania",008);
3 INSERT INTO {iso3166} VALUES ('DZ','DZA',"Algeria",012);
4 INSERT INTO {iso3166} VALUES ('AS','ASM',"American Samoa",016);
5 INSERT INTO {iso3166} VALUES ('AD','AND',"Andorra",020);
6 INSERT INTO {iso3166} VALUES ('AO','AGO',"Angola",024);
7 INSERT INTO {iso3166} VALUES ('AI','AIA',"Anguilla",660);
8 INSERT INTO {iso3166} VALUES ('AQ','ATA',"Antarctica",010);
9 INSERT INTO {iso3166} VALUES ('AG','ATG',"Antigua And Barbuda",028);
10 INSERT INTO {iso3166} VALUES ('AR','ARG',"Argentina",032);
11 INSERT INTO {iso3166} VALUES ('AM','ARM',"Armenia",051);
12 INSERT INTO {iso3166} VALUES ('AW','ABW',"Aruba",533);
13 INSERT INTO {iso3166} VALUES ('AU','AUS',"Australia",036);
14 INSERT INTO {iso3166} VALUES ('AT','AUT',"Austria",040);
15 INSERT INTO {iso3166} VALUES ('AZ','AZE',"Azerbaijan",031);
16 INSERT INTO {iso3166} VALUES ('BS','BHS',"Bahamas",044);
17 INSERT INTO {iso3166} VALUES ('BH','BHR',"Bahrain",048);
18 INSERT INTO {iso3166} VALUES ('BD','BGD',"Bangladesh",050);
19 INSERT INTO {iso3166} VALUES ('BB','BRB',"Barbados",052);
20 INSERT INTO {iso3166} VALUES ('BY','BLR',"Belarus",112);
21 INSERT INTO {iso3166} VALUES ('BE','BEL',"Belgium",056);
22 INSERT INTO {iso3166} VALUES ('BZ','BLZ',"Belize",084);
23 INSERT INTO {iso3166} VALUES ('BJ','BEN',"Benin",204);
24 INSERT INTO {iso3166} VALUES ('BM','BMU',"Bermuda",060);
25 INSERT INTO {iso3166} VALUES ('BT','BTN',"Bhutan",064);
26 INSERT INTO {iso3166} VALUES ('BO','BOL',"Bolivia",068);
27 INSERT INTO {iso3166} VALUES ('BA','BIH',"Bosnia And Herzegowina",070);
28 INSERT INTO {iso3166} VALUES ('BW','BWA',"Botswana",072);
29 INSERT INTO {iso3166} VALUES ('BV','BVT',"Bouvet Island",074);
30 INSERT INTO {iso3166} VALUES ('BR','BRA',"Brazil",076);
31 INSERT INTO {iso3166} VALUES ('IO','IOT',"British Indian Ocean Territory",086);
32 INSERT INTO {iso3166} VALUES ('BN','BRN',"Brunei Darussalam",096);
33 INSERT INTO {iso3166} VALUES ('BG','BGR',"Bulgaria",100);
34 INSERT INTO {iso3166} VALUES ('BF','BFA',"Burkina Faso",854);
35 INSERT INTO {iso3166} VALUES ('BI','BDI',"Burundi",108);
36 INSERT INTO {iso3166} VALUES ('KH','KHM',"Cambodia",116);
37 INSERT INTO {iso3166} VALUES ('CM','CMR',"Cameroon",120);
38 INSERT INTO {iso3166} VALUES ('CA','CAN',"Canada",124);
39 INSERT INTO {iso3166} VALUES ('CV','CPV',"Cape Verde",132);
40 INSERT INTO {iso3166} VALUES ('KY','CYM',"Cayman Islands",136);
41 INSERT INTO {iso3166} VALUES ('CF','CAF',"Central African Republic",140);
42 INSERT INTO {iso3166} VALUES ('TD','TCD',"Chad",148);
43 INSERT INTO {iso3166} VALUES ('CL','CHL',"Chile",152);
44 INSERT INTO {iso3166} VALUES ('CN','CHN',"China",156);
45 INSERT INTO {iso3166} VALUES ('CX','CXR',"Christmas Island",162);
46 INSERT INTO {iso3166} VALUES ('CC','CCK',"Cocos (Keeling) Islands",166);
47 INSERT INTO {iso3166} VALUES ('CO','COL',"Colombia",170);
48 INSERT INTO {iso3166} VALUES ('KM','COM',"Comoros",174);
49 INSERT INTO {iso3166} VALUES ('CD','COD',"Congo, Democratic Republic Of (Was Zaire)",180);
50 INSERT INTO {iso3166} VALUES ('CG','COG',"Congo, People'S Republic Of",178);
51 INSERT INTO {iso3166} VALUES ('CK','COK',"Cook Islands",184);
52 INSERT INTO {iso3166} VALUES ('CR','CRI',"Costa Rica",188);
53 INSERT INTO {iso3166} VALUES ('CI','CIV',"Cote D'Ivoire",384);
54 INSERT INTO {iso3166} VALUES ('HR','HRV',"Croatia (Local Name: Hrvatska)",191);
55 INSERT INTO {iso3166} VALUES ('CU','CUB',"Cuba",192);
56 INSERT INTO {iso3166} VALUES ('CY','CYP',"Cyprus",196);
57 INSERT INTO {iso3166} VALUES ('CZ','CZE',"Czech Republic",203);
58 INSERT INTO {iso3166} VALUES ('DK','DNK',"Denmark",208);
59 INSERT INTO {iso3166} VALUES ('DJ','DJI',"Djibouti",262);
60 INSERT INTO {iso3166} VALUES ('DM','DMA',"Dominica",212);
61 INSERT INTO {iso3166} VALUES ('DO','DOM',"Dominican Republic",214);
62 INSERT INTO {iso3166} VALUES ('TL','TLS',"East Timor",626);
63 INSERT INTO {iso3166} VALUES ('EC','ECU',"Ecuador",218);
64 INSERT INTO {iso3166} VALUES ('EG','EGY',"Egypt",818);
65 INSERT INTO {iso3166} VALUES ('SV','SLV',"El Salvador",222);
66 INSERT INTO {iso3166} VALUES ('GQ','GNQ',"Equatorial Guinea",226);
67 INSERT INTO {iso3166} VALUES ('ER','ERI',"Eritrea",232);
68 INSERT INTO {iso3166} VALUES ('EE','EST',"Estonia",233);
69 INSERT INTO {iso3166} VALUES ('ET','ETH',"Ethiopia",231);
70 INSERT INTO {iso3166} VALUES ('FK','FLK',"Falkland Islands (Malvinas)",238);
71 INSERT INTO {iso3166} VALUES ('FO','FRO',"Faroe Islands",234);
72 INSERT INTO {iso3166} VALUES ('FJ','FJI',"Fiji",242);
73 INSERT INTO {iso3166} VALUES ('FI','FIN',"Finland",246);
74 INSERT INTO {iso3166} VALUES ('FR','FRA',"France",250);
75 INSERT INTO {iso3166} VALUES ('FX','FXX',"France, Metropolitan",249);
76 INSERT INTO {iso3166} VALUES ('GF','GUF',"French Guiana",254);
77 INSERT INTO {iso3166} VALUES ('PF','PYF',"French Polynesia",258);
78 INSERT INTO {iso3166} VALUES ('TF','ATF',"French Southern Territories",260);
79 INSERT INTO {iso3166} VALUES ('GA','GAB',"Gabon",266);
80 INSERT INTO {iso3166} VALUES ('GM','GMB',"Gambia",270);
81 INSERT INTO {iso3166} VALUES ('GE','GEO',"Georgia",268);
82 INSERT INTO {iso3166} VALUES ('DE','DEU',"Germany",276);
83 INSERT INTO {iso3166} VALUES ('GH','GHA',"Ghana",288);
84 INSERT INTO {iso3166} VALUES ('GI','GIB',"Gibraltar",292);
85 INSERT INTO {iso3166} VALUES ('GR','GRC',"Greece",300);
86 INSERT INTO {iso3166} VALUES ('GL','GRL',"Greenland",304);
87 INSERT INTO {iso3166} VALUES ('GD','GRD',"Grenada",308);
88 INSERT INTO {iso3166} VALUES ('GP','GLP',"Guadeloupe",312);
89 INSERT INTO {iso3166} VALUES ('GU','GUM',"Guam",316);
90 INSERT INTO {iso3166} VALUES ('GT','GTM',"Guatemala",320);
91 INSERT INTO {iso3166} VALUES ('GN','GIN',"Guinea",324);
92 INSERT INTO {iso3166} VALUES ('GW','GNB',"Guinea-Bissau",624);
93 INSERT INTO {iso3166} VALUES ('GY','GUY',"Guyana",328);
94 INSERT INTO {iso3166} VALUES ('HT','HTI',"Haiti",332);
95 INSERT INTO {iso3166} VALUES ('HM','HMD',"Heard And Mc Donald Islands",334);
96 INSERT INTO {iso3166} VALUES ('HN','HND',"Honduras",340);
97 INSERT INTO {iso3166} VALUES ('HK','HKG',"Hong Kong",344);
98 INSERT INTO {iso3166} VALUES ('HU','HUN',"Hungary",348);
99 INSERT INTO {iso3166} VALUES ('IS','ISL',"Iceland",352);
100 INSERT INTO {iso3166} VALUES ('IN','IND',"India",356);
101 INSERT INTO {iso3166} VALUES ('ID','IDN',"Indonesia",360);
102 INSERT INTO {iso3166} VALUES ('IR','IRN',"Iran (Islamic Republic Of)",364);
103 INSERT INTO {iso3166} VALUES ('IQ','IRQ',"Iraq",368);
104 INSERT INTO {iso3166} VALUES ('IE','IRL',"Ireland",372);
105 INSERT INTO {iso3166} VALUES ('IL','ISR',"Israel",376);
106 INSERT INTO {iso3166} VALUES ('IT','ITA',"Italy",380);
107 INSERT INTO {iso3166} VALUES ('JM','JAM',"Jamaica",388);
108 INSERT INTO {iso3166} VALUES ('JP','JPN',"Japan",392);
109 INSERT INTO {iso3166} VALUES ('JO','JOR',"Jordan",400);
110 INSERT INTO {iso3166} VALUES ('KZ','KAZ',"Kazakhstan",398);
111 INSERT INTO {iso3166} VALUES ('KE','KEN',"Kenya",404);
112 INSERT INTO {iso3166} VALUES ('KI','KIR',"Kiribati",296);
113 INSERT INTO {iso3166} VALUES ('KP','PRK',"Korea, Democratic People'S Republic Of",408);
114 INSERT INTO {iso3166} VALUES ('KR','KOR',"Korea, Republic Of",410);
115 INSERT INTO {iso3166} VALUES ('KW','KWT',"Kuwait",414);
116 INSERT INTO {iso3166} VALUES ('KG','KGZ',"Kyrgyzstan",417);
117 INSERT INTO {iso3166} VALUES ('LA','LAO',"Lao People'S Democratic Republic",418);
118 INSERT INTO {iso3166} VALUES ('LV','LVA',"Latvia",428);
119 INSERT INTO {iso3166} VALUES ('LB','LBN',"Lebanon",422);
120 INSERT INTO {iso3166} VALUES ('LS','LSO',"Lesotho",426);
121 INSERT INTO {iso3166} VALUES ('LR','LBR',"Liberia",430);
122 INSERT INTO {iso3166} VALUES ('LY','LBY',"Libyan Arab Jamahiriya",434);
123 INSERT INTO {iso3166} VALUES ('LI','LIE',"Liechtenstein",438);
124 INSERT INTO {iso3166} VALUES ('LT','LTU',"Lithuania",440);
125 INSERT INTO {iso3166} VALUES ('LU','LUX',"Luxembourg",442);
126 INSERT INTO {iso3166} VALUES ('MO','MAC',"Macau",446);
127 INSERT INTO {iso3166} VALUES ('MK','MKD',"Macedonia, The Former Yugoslav Republic Of",807);
128 INSERT INTO {iso3166} VALUES ('MG','MDG',"Madagascar",450);
129 INSERT INTO {iso3166} VALUES ('MW','MWI',"Malawi",454);
130 INSERT INTO {iso3166} VALUES ('MY','MYS',"Malaysia",458);
131 INSERT INTO {iso3166} VALUES ('MV','MDV',"Maldives",462);
132 INSERT INTO {iso3166} VALUES ('ML','MLI',"Mali",466);
133 INSERT INTO {iso3166} VALUES ('MT','MLT',"Malta",470);
134 INSERT INTO {iso3166} VALUES ('MH','MHL',"Marshall Islands",584);
135 INSERT INTO {iso3166} VALUES ('MQ','MTQ',"Martinique",474);
136 INSERT INTO {iso3166} VALUES ('MR','MRT',"Mauritania",478);
137 INSERT INTO {iso3166} VALUES ('MU','MUS',"Mauritius",480);
138 INSERT INTO {iso3166} VALUES ('YT','MYT',"Mayotte",175);
139 INSERT INTO {iso3166} VALUES ('MX','MEX',"Mexico",484);
140 INSERT INTO {iso3166} VALUES ('FM','FSM',"Micronesia, Federated States Of",583);
141 INSERT INTO {iso3166} VALUES ('MD','MDA',"Moldova, Republic Of",498);
142 INSERT INTO {iso3166} VALUES ('MC','MCO',"Monaco",492);
143 INSERT INTO {iso3166} VALUES ('MN','MNG',"Mongolia",496);
144 INSERT INTO {iso3166} VALUES ('MS','MSR',"Montserrat",500);
145 INSERT INTO {iso3166} VALUES ('MA','MAR',"Morocco",504);
146 INSERT INTO {iso3166} VALUES ('MZ','MOZ',"Mozambique",508);
147 INSERT INTO {iso3166} VALUES ('MM','MMR',"Myanmar",104);
148 INSERT INTO {iso3166} VALUES ('NA','NAM',"Namibia",516);
149 INSERT INTO {iso3166} VALUES ('NR','NRU',"Nauru",520);
150 INSERT INTO {iso3166} VALUES ('NP','NPL',"Nepal",524);
151 INSERT INTO {iso3166} VALUES ('NL','NLD',"Netherlands",528);
152 INSERT INTO {iso3166} VALUES ('AN','ANT',"Netherlands Antilles",530);
153 INSERT INTO {iso3166} VALUES ('NC','NCL',"New Caledonia",540);
154 INSERT INTO {iso3166} VALUES ('NZ','NZL',"New Zealand",554);
155 INSERT INTO {iso3166} VALUES ('NI','NIC',"Nicaragua",558);
156 INSERT INTO {iso3166} VALUES ('NE','NER',"Niger",562);
157 INSERT INTO {iso3166} VALUES ('NG','NGA',"Nigeria",566);
158 INSERT INTO {iso3166} VALUES ('NU','NIU',"Niue",570);
159 INSERT INTO {iso3166} VALUES ('NF','NFK',"Norfolk Island",574);
160 INSERT INTO {iso3166} VALUES ('MP','MNP',"Northern Mariana Islands",580);
161 INSERT INTO {iso3166} VALUES ('NO','NOR',"Norway",578);
162 INSERT INTO {iso3166} VALUES ('OM','OMN',"Oman",512);
163 INSERT INTO {iso3166} VALUES ('PK','PAK',"Pakistan",586);
164 INSERT INTO {iso3166} VALUES ('PW','PLW',"Palau",585);
165 INSERT INTO {iso3166} VALUES ('PS','PSE',"Palestinian Territory, Occupied",275);
166 INSERT INTO {iso3166} VALUES ('PA','PAN',"Panama",591);
167 INSERT INTO {iso3166} VALUES ('PG','PNG',"Papua New Guinea",598);
168 INSERT INTO {iso3166} VALUES ('PY','PRY',"Paraguay",600);
169 INSERT INTO {iso3166} VALUES ('PE','PER',"Peru",604);
170 INSERT INTO {iso3166} VALUES ('PH','PHL',"Philippines",608);
171 INSERT INTO {iso3166} VALUES ('PN','PCN',"Pitcairn",612);
172 INSERT INTO {iso3166} VALUES ('PL','POL',"Poland",616);
173 INSERT INTO {iso3166} VALUES ('PT','PRT',"Portugal",620);
174 INSERT INTO {iso3166} VALUES ('PR','PRI',"Puerto Rico",630);
175 INSERT INTO {iso3166} VALUES ('QA','QAT',"Qatar",634);
176 INSERT INTO {iso3166} VALUES ('RE','REU',"Reunion",638);
177 INSERT INTO {iso3166} VALUES ('RO','ROU',"Romania",642);
178 INSERT INTO {iso3166} VALUES ('RU','RUS',"Russian Federation",643);
179 INSERT INTO {iso3166} VALUES ('RW','RWA',"Rwanda",646);
180 INSERT INTO {iso3166} VALUES ('KN','KNA',"Saint Kitts And Nevis",659);
181 INSERT INTO {iso3166} VALUES ('LC','LCA',"Saint Lucia",662);
182 INSERT INTO {iso3166} VALUES ('VC','VCT',"Saint Vincent And The Grenadines",670);
183 INSERT INTO {iso3166} VALUES ('WS','WSM',"Samoa",882);
184 INSERT INTO {iso3166} VALUES ('SM','SMR',"San Marino",674);
185 INSERT INTO {iso3166} VALUES ('ST','STP',"Sao Tome And Principe",678);
186 INSERT INTO {iso3166} VALUES ('SA','SAU',"Saudi Arabia",682);
187 INSERT INTO {iso3166} VALUES ('SN','SEN',"Senegal",686);
188 INSERT INTO {iso3166} VALUES ('SC','SYC',"Seychelles",690);
189 INSERT INTO {iso3166} VALUES ('SL','SLE',"Sierra Leone",694);
190 INSERT INTO {iso3166} VALUES ('SG','SGP',"Singapore",702);
191 INSERT INTO {iso3166} VALUES ('SK','SVK',"Slovakia (Slovak Republic)",703);
192 INSERT INTO {iso3166} VALUES ('SI','SVN',"Slovenia",705);
193 INSERT INTO {iso3166} VALUES ('SB','SLB',"Solomon Islands",090);
194 INSERT INTO {iso3166} VALUES ('SO','SOM',"Somalia",706);
195 INSERT INTO {iso3166} VALUES ('ZA','ZAF',"South Africa",710);
196 INSERT INTO {iso3166} VALUES ('GS','SGS',"South Georgia And The South Sandwich Islands",239);
197 INSERT INTO {iso3166} VALUES ('ES','ESP',"Spain",724);
198 INSERT INTO {iso3166} VALUES ('LK','LKA',"Sri Lanka",144);
199 INSERT INTO {iso3166} VALUES ('SH','SHN',"St. Helena",654);
200 INSERT INTO {iso3166} VALUES ('PM','SPM',"St. Pierre And Miquelon",666);
201 INSERT INTO {iso3166} VALUES ('SD','SDN',"Sudan",736);
202 INSERT INTO {iso3166} VALUES ('SR','SUR',"Suriname",740);
203 INSERT INTO {iso3166} VALUES ('SJ','SJM',"Svalbard And Jan Mayen Islands",744);
204 INSERT INTO {iso3166} VALUES ('SZ','SWZ',"Swaziland",748);
205 INSERT INTO {iso3166} VALUES ('SE','SWE',"Sweden",752);
206 INSERT INTO {iso3166} VALUES ('CH','CHE',"Switzerland",756);
207 INSERT INTO {iso3166} VALUES ('SY','SYR',"Syrian Arab Republic",760);
208 INSERT INTO {iso3166} VALUES ('TW','TWN',"Taiwan",158);
209 INSERT INTO {iso3166} VALUES ('TJ','TJK',"Tajikistan",762);
210 INSERT INTO {iso3166} VALUES ('TZ','TZA',"Tanzania, United Republic Of",834);
211 INSERT INTO {iso3166} VALUES ('TH','THA',"Thailand",764);
212 INSERT INTO {iso3166} VALUES ('TG','TGO',"Togo",768);
213 INSERT INTO {iso3166} VALUES ('TK','TKL',"Tokelau",772);
214 INSERT INTO {iso3166} VALUES ('TO','TON',"Tonga",776);
215 INSERT INTO {iso3166} VALUES ('TT','TTO',"Trinidad And Tobago",780);
216 INSERT INTO {iso3166} VALUES ('TN','TUN',"Tunisia",788);
217 INSERT INTO {iso3166} VALUES ('TR','TUR',"Turkey",792);
218 INSERT INTO {iso3166} VALUES ('TM','TKM',"Turkmenistan",795);
219 INSERT INTO {iso3166} VALUES ('TC','TCA',"Turks And Caicos Islands",796);
220 INSERT INTO {iso3166} VALUES ('TV','TUV',"Tuvalu",798);
221 INSERT INTO {iso3166} VALUES ('UG','UGA',"Uganda",800);
222 INSERT INTO {iso3166} VALUES ('UA','UKR',"Ukraine",804);
223 INSERT INTO {iso3166} VALUES ('AE','ARE',"United Arab Emirates",784);
224 INSERT INTO {iso3166} VALUES ('GB','GBR',"United Kingdom",826);
225 INSERT INTO {iso3166} VALUES ('US','USA',"United States",840);
226 INSERT INTO {iso3166} VALUES ('UM','UMI',"United States Minor Outlying Islands",581);
227 INSERT INTO {iso3166} VALUES ('UY','URY',"Uruguay",858);
228 INSERT INTO {iso3166} VALUES ('UZ','UZB',"Uzbekistan",860);
229 INSERT INTO {iso3166} VALUES ('VU','VUT',"Vanuatu",548);
230 INSERT INTO {iso3166} VALUES ('VA','VAT',"Vatican City State (Holy See)",336);
231 INSERT INTO {iso3166} VALUES ('VE','VEN',"Venezuela",862);
232 INSERT INTO {iso3166} VALUES ('VN','VNM',"Viet Nam",704);
233 INSERT INTO {iso3166} VALUES ('VG','VGB',"Virgin Islands (British)",092);
234 INSERT INTO {iso3166} VALUES ('VI','VIR',"Virgin Islands (U.S.)",850);
235 INSERT INTO {iso3166} VALUES ('WF','WLF',"Wallis And Futuna Islands",876);
236 INSERT INTO {iso3166} VALUES ('EH','ESH',"Western Sahara",732);
237 INSERT INTO {iso3166} VALUES ('YE','YEM',"Yemen",887);
238 INSERT INTO {iso3166} VALUES ('YU','YUG',"Yugoslavia",891);
239 INSERT INTO {iso3166} VALUES ('ZM','ZMB',"Zambia",894);
240 INSERT INTO {iso3166} VALUES ('ZW','ZWE',"Zimbabwe",716);
241 INSERT INTO {iso3166} VALUES ('UK','GBR',"United Kingdom",826);
242 INSERT INTO {iso3166} VALUES ('EU','EU ',"European Union",0);
243 INSERT INTO {iso3166} VALUES ('AP','AP ',"Assigned Portable",0);

  ViewVC Help
Powered by ViewVC 1.1.2