SET NAMES utf8;

DROP TABLE IF EXISTS "countries";

CREATE TABLE "countries" (
  "id" int(11) NOT NULL,
  "name" varchar(75) NOT NULL DEFAULT "",
  "alpha_2" char(2) NOT NULL DEFAULT "",
  "alpha_3" char(3) NOT NULL DEFAULT "",
  PRIMARY KEY ("id")
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO "countries" ("id", "name", "alpha_2", "alpha_3") VALUES
(4,"Afghánistán","af","afg"),
(8,"Albánie","al","alb"),
(12,"Alžírsko","dz","dza"),
(20,"Andorra","ad","and"),
(24,"Angola","ao","ago"),
(28,"Antigua a Barbuda","ag","atg"),
(32,"Argentina","ar","arg"),
(51,"Arménie","am","arm"),
(36,"Austrálie","au","aus"),
(31,"Ázerbájdžán","az","aze"),
(44,"Bahamy","bs","bhs"),
(48,"Bahrajn","bh","bhr"),
(50,"Bangladéš","bd","bgd"),
(52,"Barbados","bb","brb"),
(56,"Belgie","be","bel"),
(84,"Belize","bz","blz"),
(112,"Bělorusko","by","blr"),
(204,"Benin","bj","ben"),
(64,"Bhútán","bt","btn"),
(68,"Bolívie","bo","bol"),
(70,"Bosna a Hercegovina","ba","bih"),
(72,"Botswana","bw","bwa"),
(76,"Brazílie","br","bra"),
(96,"Brunej","bn","brn"),
(100,"Bulharsko","bg","bgr"),
(854,"Burkina Faso","bf","bfa"),
(108,"Burundi","bi","bdi"),
(148,"Čad","td","tcd"),
(499,"Černá Hora","me","mne"),
(203,"Česko","cz","cze"),
(156,"Čína","cn","chn"),
(208,"Dánsko","dk","dnk"),
(180,"Demokratická republika Kongo","cd","cod"),
(212,"Dominika","dm","dma"),
(214,"Dominikánská republika","do","dom"),
(262,"Džibutsko","dj","dji"),
(818,"Egypt","eg","egy"),
(218,"Ekvádor","ec","ecu"),
(232,"Eritrea","er","eri"),
(233,"Estonsko","ee","est"),
(231,"Etiopie","et","eth"),
(242,"Fidži","fj","fji"),
(608,"Filipíny","ph","phl"),
(246,"Finsko","fi","fin"),
(250,"Francie","fr","fra"),
(266,"Gabon","ga","gab"),
(270,"Gambie","gm","gmb"),
(288,"Ghana","gh","gha"),
(308,"Grenada","gd","grd"),
(268,"Gruzie","ge","geo"),
(320,"Guatemala","gt","gtm"),
(324,"Guinea","gn","gin"),
(624,"Guinea-Bissau","gw","gnb"),
(328,"Guyana","gy","guy"),
(332,"Haiti","ht","hti"),
(340,"Honduras","hn","hnd"),
(152,"Chile","cl","chl"),
(191,"Chorvatsko","hr","hrv"),
(356,"Indie","in","ind"),
(360,"Indonésie","id","idn"),
(368,"Irák","iq","irq"),
(364,"Írán","ir","irn"),
(372,"Irsko","ie","irl"),
(352,"Island","is","isl"),
(380,"Itálie","it","ita"),
(376,"Izrael","il","isr"),
(388,"Jamajka","jm","jam"),
(392,"Japonsko","jp","jpn"),
(887,"Jemen","ye","yem"),
(710,"Jihoafrická republika","za","zaf"),
(410,"Jižní Korea","kr","kor"),
(728,"Jižní Súdán","ss","ssd"),
(400,"Jordánsko","jo","jor"),
(116,"Kambodža","kh","khm"),
(120,"Kamerun","cm","cmr"),
(124,"Kanada","ca","can"),
(132,"Kapverdy","cv","cpv"),
(634,"Katar","qa","qat"),
(398,"Kazachstán","kz","kaz"),
(404,"Keňa","ke","ken"),
(296,"Kiribati","ki","kir"),
(170,"Kolumbie","co","col"),
(174,"Komory","km","com"),
(178,"Kongo","cg","cog"),
(188,"Kostarika","cr","cri"),
(192,"Kuba","cu","cub"),
(414,"Kuvajt","kw","kwt"),
(196,"Kypr","cy","cyp"),
(417,"Kyrgyzstán","kg","kgz"),
(418,"Laos","la","lao"),
(426,"Lesotho","ls","lso"),
(422,"Libanon","lb","lbn"),
(430,"Libérie","lr","lbr"),
(434,"Libye","ly","lby"),
(438,"Lichtenštejnsko","li","lie"),
(440,"Litva","lt","ltu"),
(428,"Lotyšsko","lv","lva"),
(442,"Lucembursko","lu","lux"),
(450,"Madagaskar","mg","mdg"),
(348,"Maďarsko","hu","hun"),
(458,"Malajsie","my","mys"),
(454,"Malawi","mw","mwi"),
(462,"Maledivy","mv","mdv"),
(466,"Mali","ml","mli"),
(470,"Malta","mt","mlt"),
(504,"Maroko","ma","mar"),
(584,"Marshallovy ostrovy","mh","mhl"),
(480,"Mauricius","mu","mus"),
(478,"Mauritánie","mr","mrt"),
(484,"Mexiko","mx","mex"),
(583,"Mikronésie","fm","fsm"),
(498,"Moldavsko","md","mda"),
(492,"Monako","mc","mco"),
(496,"Mongolsko","mn","mng"),
(508,"Mosambik","mz","moz"),
(104,"Myanmar","mm","mmr"),
(516,"Namibie","na","nam"),
(520,"Nauru","nr","nru"),
(276,"Německo","de","deu"),
(524,"Nepál","np","npl"),
(562,"Niger","ne","ner"),
(566,"Nigérie","ng","nga"),
(558,"Nikaragua","ni","nic"),
(528,"Nizozemsko","nl","nld"),
(578,"Norsko","no","nor"),
(554,"Nový Zéland","nz","nzl"),
(512,"Omán","om","omn"),
(586,"Pákistán","pk","pak"),
(585,"Palau","pw","plw"),
(591,"Panama","pa","pan"),
(598,"Papua Nová Guinea","pg","png"),
(600,"Paraguay","py","pry"),
(604,"Peru","pe","per"),
(384,"Pobřeží slonoviny","ci","civ"),
(616,"Polsko","pl","pol"),
(620,"Portugalsko","pt","prt"),
(40,"Rakousko","at","aut"),
(226,"Rovníková Guinea","gq","gnq"),
(642,"Rumunsko","ro","rou"),
(643,"Rusko","ru","rus"),
(646,"Rwanda","rw","rwa"),
(300,"Řecko","gr","grc"),
(222,"Salvador","sv","slv"),
(882,"Samoa","ws","wsm"),
(674,"San Marino","sm","smr"),
(682,"Saúdská Arábie","sa","sau"),
(686,"Senegal","sn","sen"),
(408,"Severní Korea","kp","prk"),
(807,"Severní Makedonie","mk","mkd"),
(690,"Seychely","sc","syc"),
(694,"Sierra Leone","sl","sle"),
(702,"Singapur","sg","sgp"),
(703,"Slovensko","sk","svk"),
(705,"Slovinsko","si","svn"),
(706,"Somálsko","so","som"),
(784,"Spojené arabské emiráty","ae","are"),
(826,"Spojené království Velké Británie a Severního Irska","gb","gbr"),
(840,"Spojené státy americké","us","usa"),
(688,"Srbsko","rs","srb"),
(144,"Srí Lanka","lk","lka"),
(140,"Středoafrická republika","cf","caf"),
(729,"Súdán","sd","sdn"),
(740,"Surinam","sr","sur"),
(662,"Svatá Lucie","lc","lca"),
(659,"Svatý Kryštof a Nevis","kn","kna"),
(678,"Svatý Tomáš a Princův ostrov","st","stp"),
(670,"Svatý Vincenc a Grenadiny","vc","vct"),
(748,"Svazijsko","sz","swz"),
(760,"Sýrie","sy","syr"),
(90,"Šalomounovy ostrovy","sb","slb"),
(724,"Španělsko","es","esp"),
(752,"Švédsko","se","swe"),
(756,"Švýcarsko","ch","che"),
(762,"Tádžikistán","tj","tjk"),
(834,"Tanzanie","tz","tza"),
(764,"Thajsko","th","tha"),
(768,"Togo","tg","tgo"),
(776,"Tonga","to","ton"),
(780,"Trinidad a Tobago","tt","tto"),
(788,"Tunisko","tn","tun"),
(792,"Turecko","tr","tur"),
(795,"Turkmenistán","tm","tkm"),
(798,"Tuvalu","tv","tuv"),
(800,"Uganda","ug","uga"),
(804,"Ukrajina","ua","ukr"),
(858,"Uruguay","uy","ury"),
(860,"Uzbekistán","uz","uzb"),
(548,"Vanuatu","vu","vut"),
(862,"Venezuela","ve","ven"),
(704,"Vietnam","vn","vnm"),
(626,"Východní Timor","tl","tls"),
(894,"Zambie","zm","zmb"),
(716,"Zimbabwe","zw","zwe")