zv9TBUck

1CREATE TABLE IF NOT EXISTS `countries` (
2  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3  `name_pl` varchar(100) NOT NULL,
4  `name_en` varchar(100) NOT NULL,
5  `symbol` char(2) NOT NULL,
6  PRIMARY KEY (`id`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9INSERT INTO `countries` VALUES (null,'Afganistan','Afghanistan','AF');
10INSERT INTO `countries` VALUES (null,'Albania','Albania','AL');
11INSERT INTO `countries` VALUES (null,'Algieria','Algeria','DZ');
12INSERT INTO `countries` VALUES (null,'Andora','Andorra','AD');
13INSERT INTO `countries` VALUES (null,'Angola','Angola','AO');
14INSERT INTO `countries` VALUES (null,'Anguilla','Anguilla','AI');
15INSERT INTO `countries` VALUES (null,'Antarktyka','Antarctica','AQ');
16INSERT INTO `countries` VALUES (null,'Antigua i Barbuda','Antigua and Barbuda','AG');
17INSERT INTO `countries` VALUES (null,'Arabia Saudyjska','Saudi Arabia','SA');
18INSERT INTO `countries` VALUES (null,'Argentyna','Argentina','AR');
19INSERT INTO `countries` VALUES (null,'Armenia','Armenia','AM');
20INSERT INTO `countries` VALUES (null,'Aruba','Aruba','AW');
21INSERT INTO `countries` VALUES (null,'Australia','Australia','AU');
22INSERT INTO `countries` VALUES (null,'Austria','Austria','AT');
23INSERT INTO `countries` VALUES (null,'Azerbejdżan','Azerbaijan','AZ');
24INSERT INTO `countries` VALUES (null,'Bahamy','Bahamas','BS');
25INSERT INTO `countries` VALUES (null,'Bahrajn','Bahrain','BH');
26INSERT INTO `countries` VALUES (null,'Bangladesz','Bangladesh','BD');
27INSERT INTO `countries` VALUES (null,'Barbados','Barbados','BB');
28INSERT INTO `countries` VALUES (null,'Belgia','Belgium','BE');
29INSERT INTO `countries` VALUES (null,'Belize','Belize','BZ');
30INSERT INTO `countries` VALUES (null,'Benin','Benin','BJ');
31INSERT INTO `countries` VALUES (null,'Bermudy','Bermuda','BM');
32INSERT INTO `countries` VALUES (null,'Bhutan','Bhutan','BT');
33INSERT INTO `countries` VALUES (null,'Białoruś','Belarus','BY');
34INSERT INTO `countries` VALUES (null,'Boliwia','Bolivia, Plurinational State of','BO');
35INSERT INTO `countries` VALUES (null,'Bonaire, Sint Eustatius i Saba','Bonaire, Sint Eustatius and Saba','BQ');
36INSERT INTO `countries` VALUES (null,'Bośnia i Hercegowina','Bosnia and Herzegovina','BA');
37INSERT INTO `countries` VALUES (null,'Botswana','Botswana','BW');
38INSERT INTO `countries` VALUES (null,'Brazylia','Brazil','BR');
39INSERT INTO `countries` VALUES (null,'Brunei','Brunei Darussalam','BN');
40INSERT INTO `countries` VALUES (null,'Brytyjskie Terytorium Oceanu Indyjskiego','British Indian Ocean Territory','IO');
41INSERT INTO `countries` VALUES (null,'Brytyjskie Wyspy Dziewicze','Virgin Islands, British','VG');
42INSERT INTO `countries` VALUES (null,'Bułgaria','Bulgaria','BG');
43INSERT INTO `countries` VALUES (null,'Burkina Faso','Burkina Faso','BF');
44INSERT INTO `countries` VALUES (null,'Burundi','Burundi','BI');
45INSERT INTO `countries` VALUES (null,'Chile','Chile','CL');
46INSERT INTO `countries` VALUES (null,'Chiny','China','CN');
47INSERT INTO `countries` VALUES (null,'Chorwacja','Croatia','HR');
48INSERT INTO `countries` VALUES (null,'Curaçao','Curaçao','CW');
49INSERT INTO `countries` VALUES (null,'Cypr','Cyprus','CY');
50INSERT INTO `countries` VALUES (null,'Czad','Chad','TD');
51INSERT INTO `countries` VALUES (null,'Czarnogóra','Montenegro','ME');
52INSERT INTO `countries` VALUES (null,'Czechy','Czech Republic','CZ');
53INSERT INTO `countries` VALUES (null,'Dalekie Wyspy Mniejsze Stanów Zjednoczonych','United States Minor Outlying Islands','UM');
54INSERT INTO `countries` VALUES (null,'Dania','Denmark','DK');
55INSERT INTO `countries` VALUES (null,'Demokratyczna Republika Konga','Congo, the Democratic Republic of the','CD');
56INSERT INTO `countries` VALUES (null,'Dominika','Dominica','DM');
57INSERT INTO `countries` VALUES (null,'Dominikana','Dominican Republic','DO');
58INSERT INTO `countries` VALUES (null,'Dżibuti','Djibouti','DJ');
59INSERT INTO `countries` VALUES (null,'Egipt','Egypt','EG');
60INSERT INTO `countries` VALUES (null,'Ekwador','Ecuador','EC');
61INSERT INTO `countries` VALUES (null,'Erytrea','Eritrea','ER');
62INSERT INTO `countries` VALUES (null,'Estonia','Estonia','EE');
63INSERT INTO `countries` VALUES (null,'Etiopia','Ethiopia','ET');
64INSERT INTO `countries` VALUES (null,'Falklandy','Falkland Islands (Malvinas)','FK');
65INSERT INTO `countries` VALUES (null,'Fidżi','Fiji','FJ');
66INSERT INTO `countries` VALUES (null,'Filipiny','Philippines','PH');
67INSERT INTO `countries` VALUES (null,'Finlandia','Finland','FI');
68INSERT INTO `countries` VALUES (null,'Francja','France','FR');
69INSERT INTO `countries` VALUES (null,'Francuskie Terytoria Południowe i Antarktyczne','French Southern Territories','TF');
70INSERT INTO `countries` VALUES (null,'Gabon','Gabon','GA');
71INSERT INTO `countries` VALUES (null,'Gambia','Gambia','GM');
72INSERT INTO `countries` VALUES (null,'Georgia Południowa i Sandwich Południowy','South Georgia and the South Sandwich Islands','GS');
73INSERT INTO `countries` VALUES (null,'Ghana','Ghana','GH');
74INSERT INTO `countries` VALUES (null,'Gibraltar','Gibraltar','GI');
75INSERT INTO `countries` VALUES (null,'Grecja','Greece','GR');
76INSERT INTO `countries` VALUES (null,'Grenada','Grenada','GD');
77INSERT INTO `countries` VALUES (null,'Grenlandia','Greenland','GL');
78INSERT INTO `countries` VALUES (null,'Gruzja','Georgia','GE');
79INSERT INTO `countries` VALUES (null,'Guam','Guam','GU');
80INSERT INTO `countries` VALUES (null,'Guernsey','Guernsey','GG');
81INSERT INTO `countries` VALUES (null,'Gujana Francuska','French Guiana','GF');
82INSERT INTO `countries` VALUES (null,'Gujana','Guyana','GY');
83INSERT INTO `countries` VALUES (null,'Gwadelupa','Guadeloupe','GP');
84INSERT INTO `countries` VALUES (null,'Gwatemala','Guatemala','GT');
85INSERT INTO `countries` VALUES (null,'Gwinea Bissau','Guinea-Bissau','GW');
86INSERT INTO `countries` VALUES (null,'Gwinea Równikowa','Equatorial Guinea','GQ');
87INSERT INTO `countries` VALUES (null,'Gwinea','Guinea','GN');
88INSERT INTO `countries` VALUES (null,'Haiti','Haiti','HT');
89INSERT INTO `countries` VALUES (null,'Hiszpania','Spain','ES');
90INSERT INTO `countries` VALUES (null,'Holandia','Netherlands','NL');
91INSERT INTO `countries` VALUES (null,'Honduras','Honduras','HN');
92INSERT INTO `countries` VALUES (null,'Hongkong','Hong Kong','HK');
93INSERT INTO `countries` VALUES (null,'Indie','India','IN');
94INSERT INTO `countries` VALUES (null,'Indonezja','Indonesia','ID');
95INSERT INTO `countries` VALUES (null,'Irak','Iraq','IQ');
96INSERT INTO `countries` VALUES (null,'Iran','Iran, Islamic Republic of','IR');
97INSERT INTO `countries` VALUES (null,'Irlandia','Ireland','IE');
98INSERT INTO `countries` VALUES (null,'Islandia','Iceland','IS');
99INSERT INTO `countries` VALUES (null,'Izrael','Israel','IL');
100INSERT INTO `countries` VALUES (null,'Jamajka','Jamaica','JM');
101INSERT INTO `countries` VALUES (null,'Japonia','Japan','JP');
102INSERT INTO `countries` VALUES (null,'Jemen','Yemen','YE');
103INSERT INTO `countries` VALUES (null,'Jersey','Jersey','JE');
104INSERT INTO `countries` VALUES (null,'Jordania','Jordan','JO');
105INSERT INTO `countries` VALUES (null,'Kajmany','Cayman Islands','KY');
106INSERT INTO `countries` VALUES (null,'Kambodża','Cambodia','KH');
107INSERT INTO `countries` VALUES (null,'Kamerun','Cameroon','CM');
108INSERT INTO `countries` VALUES (null,'Kanada','Canada','CA');
109INSERT INTO `countries` VALUES (null,'Katar','Qatar','QA');
110INSERT INTO `countries` VALUES (null,'Kazachstan','Kazakhstan','KZ');
111INSERT INTO `countries` VALUES (null,'Kenia','Kenya','KE');
112INSERT INTO `countries` VALUES (null,'Kirgistan','Kyrgyzstan','KG');
113INSERT INTO `countries` VALUES (null,'Kiribati','Kiribati','KI');
114INSERT INTO `countries` VALUES (null,'Kolumbia','Colombia','CO');
115INSERT INTO `countries` VALUES (null,'Komory','Comoros','KM');
116INSERT INTO `countries` VALUES (null,'Kongo','Congo','CG');
117INSERT INTO `countries` VALUES (null,'Korea Południowa','Korea, Republic of','KR');
118INSERT INTO `countries` VALUES (null,'Korea Północna','Korea, Democratic People\'s Republic of','KP');
119INSERT INTO `countries` VALUES (null,'Kostaryka','Costa Rica','CR');
120INSERT INTO `countries` VALUES (null,'Kuba','Cuba','CU');
121INSERT INTO `countries` VALUES (null,'Kuwejt','Kuwait','KW');
122INSERT INTO `countries` VALUES (null,'Laos','Lao People\'s Democratic Republic','LA');
123INSERT INTO `countries` VALUES (null,'Lesotho','Lesotho','LS');
124INSERT INTO `countries` VALUES (null,'Liban','Lebanon','LB');
125INSERT INTO `countries` VALUES (null,'Liberia','Liberia','LR');
126INSERT INTO `countries` VALUES (null,'Libia','Libyan Arab Jamahiriya','LY');
127INSERT INTO `countries` VALUES (null,'Liechtenstein','Liechtenstein','LI');
128INSERT INTO `countries` VALUES (null,'Litwa','Lithuania','LT');
129INSERT INTO `countries` VALUES (null,'Luksemburg','Luxembourg','LU');
130INSERT INTO `countries` VALUES (null,'Łotwa','Latvia','LV');
131INSERT INTO `countries` VALUES (null,'Macedonia','Macedonia, the former Yugoslav Republic of','MK');
132INSERT INTO `countries` VALUES (null,'Madagaskar','Madagascar','MG');
133INSERT INTO `countries` VALUES (null,'Majotta','Mayotte','YT');
134INSERT INTO `countries` VALUES (null,'Makau','Macao','MO');
135INSERT INTO `countries` VALUES (null,'Malawi','Malawi','MW');
136INSERT INTO `countries` VALUES (null,'Malediwy','Maldives','MV');
137INSERT INTO `countries` VALUES (null,'Malezja','Malaysia','MY');
138INSERT INTO `countries` VALUES (null,'Mali','Mali','ML');
139INSERT INTO `countries` VALUES (null,'Malta','Malta','MT');
140INSERT INTO `countries` VALUES (null,'Mariany Północne','Northern Mariana Islands','MP');
141INSERT INTO `countries` VALUES (null,'Maroko','Morocco','MA');
142INSERT INTO `countries` VALUES (null,'Martynika','Martinique','MQ');
143INSERT INTO `countries` VALUES (null,'Mauretania','Mauritania','MR');
144INSERT INTO `countries` VALUES (null,'Mauritius','Mauritius','MU');
145INSERT INTO `countries` VALUES (null,'Meksyk','Mexico','MX');
146INSERT INTO `countries` VALUES (null,'Mikronezja','Micronesia, Federated States of','FM');
147INSERT INTO `countries` VALUES (null,'Mjanma','Myanmar','MM');
148INSERT INTO `countries` VALUES (null,'Mołdawia','Moldova, Republic of','MD');
149INSERT INTO `countries` VALUES (null,'Monako','Monaco','MC');
150INSERT INTO `countries` VALUES (null,'Mongolia','Mongolia','MN');
151INSERT INTO `countries` VALUES (null,'Montserrat','Montserrat','MS');
152INSERT INTO `countries` VALUES (null,'Mozambik','Mozambique','MZ');
153INSERT INTO `countries` VALUES (null,'Namibia','Namibia','NA');
154INSERT INTO `countries` VALUES (null,'Nauru','Nauru','NR');
155INSERT INTO `countries` VALUES (null,'Nepal','Nepal','NP');
156INSERT INTO `countries` VALUES (null,'Niemcy','Germany','DE');
157INSERT INTO `countries` VALUES (null,'Niger','Niger','NE');
158INSERT INTO `countries` VALUES (null,'Nigeria','Nigeria','NG');
159INSERT INTO `countries` VALUES (null,'Nikaragua','Nicaragua','NI');
160INSERT INTO `countries` VALUES (null,'Niue','Niue','NU');
161INSERT INTO `countries` VALUES (null,'Norfolk','Norfolk Island','NF');
162INSERT INTO `countries` VALUES (null,'Norwegia','Norway','NO');
163INSERT INTO `countries` VALUES (null,'Nowa Kaledonia','New Caledonia','NC');
164INSERT INTO `countries` VALUES (null,'Nowa Zelandia','New Zealand','NZ');
165INSERT INTO `countries` VALUES (null,'Oman','Oman','OM');
166INSERT INTO `countries` VALUES (null,'Pakistan','Pakistan','PK');
167INSERT INTO `countries` VALUES (null,'Palau','Palau','PW');
168INSERT INTO `countries` VALUES (null,'Palestyna','Palestinian Territory, Occupied','PS');
169INSERT INTO `countries` VALUES (null,'Panama','Panama','PA');
170INSERT INTO `countries` VALUES (null,'Papua-Nowa Gwinea','Papua New Guinea','PG');
171INSERT INTO `countries` VALUES (null,'Paragwaj','Paraguay','PY');
172INSERT INTO `countries` VALUES (null,'Peru','Peru','PE');
173INSERT INTO `countries` VALUES (null,'Pitcairn','Pitcairn','PN');
174INSERT INTO `countries` VALUES (null,'Polinezja Francuska','French Polynesia','PF');
175INSERT INTO `countries` VALUES (null,'Polska','Poland','PL');
176INSERT INTO `countries` VALUES (null,'Portoryko','Puerto Rico','PR');
177INSERT INTO `countries` VALUES (null,'Portugalia','Portugal','PT');
178INSERT INTO `countries` VALUES (null,'Republika Południowej Afryki','South Africa','ZA');
179INSERT INTO `countries` VALUES (null,'Republika Środkowoafrykańska','Central African Republic','CF');
180INSERT INTO `countries` VALUES (null,'Republika Zielonego PrzylÄ…dka','Cape Verde','CV');
181INSERT INTO `countries` VALUES (null,'Reunion','Réunion','RE');
182INSERT INTO `countries` VALUES (null,'Rosja','Russian Federation','RU');
183INSERT INTO `countries` VALUES (null,'Rumunia','Romania','RO');
184INSERT INTO `countries` VALUES (null,'Rwanda','Rwanda','RW');
185INSERT INTO `countries` VALUES (null,'Sahara Zachodnia','Western Sahara','EH');
186INSERT INTO `countries` VALUES (null,'Saint Kitts i Nevis','Saint Kitts and Nevis','KN');
187INSERT INTO `countries` VALUES (null,'Saint Lucia','Saint Lucia','LC');
188INSERT INTO `countries` VALUES (null,'Saint Vincent i Grenadyny','Saint Vincent and the Grenadines','VC');
189INSERT INTO `countries` VALUES (null,'Saint-Barthélemy','Saint Barthélemy','BL');
190INSERT INTO `countries` VALUES (null,'Saint-Martin','Saint Martin (French part)','MF');
191INSERT INTO `countries` VALUES (null,'Saint-Pierre i Miquelon','Saint Pierre and Miquelon','PM');
192INSERT INTO `countries` VALUES (null,'Salwador','El Salvador','SV');
193INSERT INTO `countries` VALUES (null,'Samoa Amerykańskie','American Samoa','AS');
194INSERT INTO `countries` VALUES (null,'Samoa','Samoa','WS');
195INSERT INTO `countries` VALUES (null,'San Marino','San Marino','SM');
196INSERT INTO `countries` VALUES (null,'Senegal','Senegal','SN');
197INSERT INTO `countries` VALUES (null,'Serbia','Serbia','RS');
198INSERT INTO `countries` VALUES (null,'Seszele','Seychelles','SC');
199INSERT INTO `countries` VALUES (null,'Sierra Leone','Sierra Leone','SL');
200INSERT INTO `countries` VALUES (null,'Singapur','Singapore','SG');
201INSERT INTO `countries` VALUES (null,'Sint Maarten','Sint Maarten (Dutch part)','SX');
202INSERT INTO `countries` VALUES (null,'SÅ‚owacja','Slovakia','SK');
203INSERT INTO `countries` VALUES (null,'SÅ‚owenia','Slovenia','SI');
204INSERT INTO `countries` VALUES (null,'Somalia','Somalia','SO');
205INSERT INTO `countries` VALUES (null,'Sri Lanka','Sri Lanka','LK');
206INSERT INTO `countries` VALUES (null,'Stany Zjednoczone','United States','US');
207INSERT INTO `countries` VALUES (null,'Suazi','Swaziland','SZ');
208INSERT INTO `countries` VALUES (null,'Sudan','Sudan','SD');
209INSERT INTO `countries` VALUES (null,'Sudan Południowy','South Sudan','SS');
210INSERT INTO `countries` VALUES (null,'Surinam','Suriname','SR');
211INSERT INTO `countries` VALUES (null,'Svalbard i Jan Mayen','Svalbard and Jan Mayen','SJ');
212INSERT INTO `countries` VALUES (null,'Syria','Syrian Arab Republic','SY');
213INSERT INTO `countries` VALUES (null,'Szwajcaria','Switzerland','CH');
214INSERT INTO `countries` VALUES (null,'Szwecja','Sweden','SE');
215INSERT INTO `countries` VALUES (null,'Tadżykistan','Tajikistan','TJ');
216INSERT INTO `countries` VALUES (null,'Tajlandia','Thailand','TH');
217INSERT INTO `countries` VALUES (null,'Tajwan','Taiwan, Province of China','TW');
218INSERT INTO `countries` VALUES (null,'Tanzania','Tanzania, United Republic of','TZ');
219INSERT INTO `countries` VALUES (null,'Timor Wschodni','Timor-Leste','TL');
220INSERT INTO `countries` VALUES (null,'Togo','Togo','TG');
221INSERT INTO `countries` VALUES (null,'Tokelau','Tokelau','TK');
222INSERT INTO `countries` VALUES (null,'Tonga','Tonga','TO');
223INSERT INTO `countries` VALUES (null,'Trynidad i Tobago','Trinidad and Tobago','TT');
224INSERT INTO `countries` VALUES (null,'Tunezja','Tunisia','TN');
225INSERT INTO `countries` VALUES (null,'Turcja','Turkey','TR');
226INSERT INTO `countries` VALUES (null,'Turkmenistan','Turkmenistan','TM');
227INSERT INTO `countries` VALUES (null,'Turks i Caicos','Turks and Caicos Islands','TC');
228INSERT INTO `countries` VALUES (null,'Tuvalu','Tuvalu','TV');
229INSERT INTO `countries` VALUES (null,'Uganda','Uganda','UG');
230INSERT INTO `countries` VALUES (null,'Ukraina','Ukraine','UA');
231INSERT INTO `countries` VALUES (null,'Urugwaj','Uruguay','UY');
232INSERT INTO `countries` VALUES (null,'Uzbekistan','Uzbekistan','UZ');
233INSERT INTO `countries` VALUES (null,'Vanuatu','Vanuatu','VU');
234INSERT INTO `countries` VALUES (null,'Wallis i Futuna','Wallis and Futuna','WF');
235INSERT INTO `countries` VALUES (null,'Watykan','Holy See (Vatican City State)','VA');
236INSERT INTO `countries` VALUES (null,'Wenezuela','Venezuela, Bolivarian Republic of','VE');
237INSERT INTO `countries` VALUES (null,'Węgry','Hungary','HU');
238INSERT INTO `countries` VALUES (null,'Wielka Brytania','United Kingdom','GB');
239INSERT INTO `countries` VALUES (null,'Wietnam','Viet Nam','VN');
240INSERT INTO `countries` VALUES (null,'WÅ‚ochy','Italy','IT');
241INSERT INTO `countries` VALUES (null,'Wybrzeże Kości Słoniowej','Côte d\'Ivoire','CI');
242INSERT INTO `countries` VALUES (null,'Wyspa Bouveta','Bouvet Island','BV');
243INSERT INTO `countries` VALUES (null,'Wyspa Bożego Narodzenia','Christmas Island','CX');
244INSERT INTO `countries` VALUES (null,'Wyspa Man','Isle of Man','IM');
245INSERT INTO `countries` VALUES (null,'Wyspa Świętej Heleny, Wyspa Wniebowstąpienia i Tristan da Cunha','Saint Helena, Ascension and Tristan Cunha','SH');
246INSERT INTO `countries` VALUES (null,'Wyspy Alandzkie','Ã…land Islands','AX');
247INSERT INTO `countries` VALUES (null,'Wyspy Cooka','Cook Islands','CK');
248INSERT INTO `countries` VALUES (null,'Wyspy Dziewicze Stanów Zjednoczonych','Virgin Islands, U.S.','VI');
249INSERT INTO `countries` VALUES (null,'Wyspy Heard i McDonalda','Heard Island and McDonald Islands','HM');
250INSERT INTO `countries` VALUES (null,'Wyspy Kokosowe','Cocos (Keeling) Islands','CC');
251INSERT INTO `countries` VALUES (null,'Wyspy Marshalla','Marshall Islands','MH');
252INSERT INTO `countries` VALUES (null,'Wyspy Owcze','Faroe Islands','FO');
253INSERT INTO `countries` VALUES (null,'Wyspy Salomona','Solomon Islands','SB');
254INSERT INTO `countries` VALUES (null,'Wyspy Świętego Tomasza i Książęca','Sao Tome and Principe','ST');
255INSERT INTO `countries` VALUES (null,'Zambia','Zambia','ZM');
256INSERT INTO `countries` VALUES (null,'Zimbabwe','Zimbabwe','ZW');
257INSERT INTO `countries` VALUES (null,'Zjednoczone Emiraty Arabskie','United Arab Emirates','AE');