SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Structure de la table `pays`
--

DROP TABLE IF EXISTS `pays`;
CREATE TABLE IF NOT EXISTS `pays` (
  `code` smallint(3) unsigned NOT NULL,
  `iso2` char(2) NOT NULL,
  `nom` varchar(100) NOT NULL,
  PRIMARY KEY (`code`),
  KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Liste des pays';

--
-- Contenu de la table `pays`
--

INSERT INTO `pays` (`code`, `iso2`, `nom`) VALUES
(4, 'af', 'Afghanistan'),
(8, 'al', 'Albania, People\'s Socialist Republic Of'),
(10, 'aq', 'Antarctica'),
(12, 'dz', 'Algeria, People\'s Democratic Republic Of'),
(16, 'as', 'American Samoa'),
(20, 'ad', 'Andorra, Principality Of'),
(24, 'ao', 'Angola, Republic Of'),
(28, 'ag', 'Antigua And Barbuda'),
(31, 'az', 'Azerbaijan, Republic Of'),
(32, 'ar', 'Argentina, Argentine Republic'),
(36, 'au', 'Australia, Commonwealth Of'),
(40, 'at', 'Austria, Republic Of'),
(44, 'bs', 'Bahamas, Commonwealth Of The'),
(48, 'bh', 'Bahrain, Kingdom Of'),
(50, 'bd', 'Bangladesh, People\'s Republic Of'),
(51, 'am', 'Armenia'),
(52, 'bb', 'Barbados'),
(56, 'be', 'Belgium, Kingdom Of'),
(60, 'bm', 'Bermuda'),
(64, 'bt', 'Bhutan, Kingdom Of'),
(68, 'bo', 'Bolivia, Republic Of'),
(70, 'ba', 'Bosnia And Herzegovina'),
(72, 'bw', 'Botswana, Republic Of'),
(74, 'bv', 'Bouvet Island'),
(76, 'br', 'Brazil, Federative Republic Of'),
(84, 'bz', 'Belize'),
(86, 'io', 'British Indian Ocean Territory'),
(90, 'sb', 'Solomon Islands'),
(92, 'vg', 'British Virgin Islands'),
(96, 'bn', 'Brunei Darussalam'),
(100, 'bg', 'Bulgaria, People\'s Republic Of'),
(104, 'mm', 'Myanmar'),
(108, 'bi', 'Burundi, Republic Of'),
(112, 'by', 'Belarus'),
(116, 'kh', 'Cambodia, Kingdom Of'),
(120, 'cm', 'Cameroon, United Republic Of'),
(124, 'ca', 'Canada'),
(132, 'cv', 'Cape Verde, Republic Of'),
(136, 'ky', 'Cayman Islands'),
(140, 'cf', 'Central African Republic'),
(144, 'lk', 'Sri Lanka, Democratic Socialist Republic Of'),
(148, 'td', 'Chad, Republic Of'),
(152, 'cl', 'Chile, Republic Of'),
(156, 'cn', 'China, People\'s Republic Of'),
(158, 'tw', 'Taiwan, Province Of China'),
(162, 'cx', 'Christmas Island'),
(166, 'cc', 'Cocos Islands'),
(170, 'co', 'Colombia, Republic Of'),
(174, 'km', 'Comoros, Union Of The'),
(175, 'yt', 'Mayotte'),
(178, 'cg', 'Congo, People\'s Republic Of'),
(180, 'cd', 'Congo, Democratic Republic Of'),
(184, 'ck', 'Cook Islands'),
(188, 'cr', 'Costa Rica, Republic Of'),
(191, 'hr', 'Hrvatska'),
(192, 'cu', 'Cuba, Republic Of'),
(196, 'cy', 'Cyprus, Republic Of'),
(203, 'cz', 'Czech Republic'),
(204, 'bj', 'Benin, People\'s Republic Of'),
(208, 'dk', 'Denmark, Kingdom Of'),
(212, 'dm', 'Dominica, Commonwealth Of'),
(214, 'do', 'Dominican Republic'),
(218, 'ec', 'Ecuador, Republic Of'),
(222, 'sv', 'El Salvador, Republic Of'),
(226, 'gq', 'Equatorial Guinea, Republic Of'),
(231, 'et', 'Ethiopia'),
(232, 'er', 'Eritrea'),
(233, 'ee', 'Estonia'),
(234, 'fo', 'Faeroe Islands'),
(238, 'fk', 'Falkland Islands'),
(239, 'gs', 'South Georgia And The South Sandwich Islands'),
(242, 'fj', 'Fiji, Republic Of The Fiji Islands'),
(246, 'fi', 'Finland, Republic Of'),
(248, 'ax', 'Åland Islands'),
(250, 'fr', 'France, French Republic'),
(254, 'gf', 'French Guiana'),
(258, 'pf', 'French Polynesia'),
(260, 'tf', 'French Southern Territories'),
(262, 'dj', 'Djibouti, Republic Of'),
(266, 'ga', 'Gabon, Gabonese Republic'),
(268, 'ge', 'Georgia'),
(270, 'gm', 'Gambia, Republic Of The'),
(275, 'ps', 'Palestinian Territory, Occupied'),
(276, 'de', 'Germany'),
(288, 'gh', 'Ghana, Republic Of'),
(292, 'gi', 'Gibraltar'),
(296, 'ki', 'Kiribati, Republic Of'),
(300, 'gr', 'Greece, Hellenic Republic'),
(304, 'gl', 'Greenland'),
(308, 'gd', 'Grenada'),
(312, 'gp', 'Guadaloupe'),
(316, 'gu', 'Guam'),
(320, 'gt', 'Guatemala, Republic Of'),
(324, 'gn', 'Guinea, Revolutionary People\'s Rep\'c Of'),
(328, 'gy', 'Guyana, Republic Of'),
(332, 'ht', 'Haiti, Republic Of'),
(334, 'hm', 'Heard And Mcdonald Islands'),
(336, 'va', 'Holy See'),
(340, 'hn', 'Honduras, Republic Of'),
(344, 'hk', 'Hong Kong, Special Administrative Region Of China'),
(348, 'hu', 'Hungary, Hungarian People\'s Republic'),
(352, 'is', 'Iceland, Republic Of'),
(356, 'in', 'India, Republic Of'),
(360, 'id', 'Indonesia, Republic Of'),
(364, 'ir', 'Iran, Islamic Republic Of'),
(368, 'iq', 'Iraq, Republic Of'),
(372, 'ie', 'Ireland'),
(376, 'il', 'Israel, State Of'),
(380, 'it', 'Italy, Italian Republic'),
(384, 'ci', 'Ivory Coast, Republic Of The'),
(388, 'jm', 'Jamaica'),
(392, 'jp', 'Japan'),
(398, 'kz', 'Kazakhstan, Republic Of'),
(400, 'jo', 'Jordan, Hashemite Kingdom Of'),
(404, 'ke', 'Kenya, Republic Of'),
(408, 'kp', 'Korea, Democratic People\'s Republic Of'),
(410, 'kr', 'Korea, Republic Of'),
(414, 'kw', 'Kuwait, State Of'),
(417, 'kg', 'Kyrgyz Republic'),
(418, 'la', 'Lao People\'s Democratic Republic'),
(422, 'lb', 'Lebanon, Lebanese Republic'),
(426, 'ls', 'Lesotho, Kingdom Of'),
(428, 'lv', 'Latvia'),
(430, 'lr', 'Liberia, Republic Of'),
(434, 'ly', 'Libyan Arab Jamahiriya'),
(438, 'li', 'Liechtenstein, Principality Of'),
(440, 'lt', 'Lithuania'),
(442, 'lu', 'Luxembourg, Grand Duchy Of'),
(446, 'mo', 'Macao, Special Administrative Region Of China'),
(450, 'mg', 'Madagascar, Republic Of'),
(454, 'mw', 'Malawi, Republic Of'),
(458, 'my', 'Malaysia'),
(462, 'mv', 'Maldives, Republic Of'),
(466, 'ml', 'Mali, Republic Of'),
(470, 'mt', 'Malta, Republic Of'),
(474, 'mq', 'Martinique'),
(478, 'mr', 'Mauritania, Islamic Republic Of'),
(480, 'mu', 'Mauritius'),
(484, 'mx', 'Mexico, United Mexican States'),
(492, 'mc', 'Monaco, Principality Of'),
(496, 'mn', 'Mongolia, Mongolian People\'s Republic'),
(498, 'md', 'Moldova, Republic Of'),
(499, 'me', 'Montenegro'),
(500, 'ms', 'Montserrat'),
(504, 'ma', 'Morocco, Kingdom Of'),
(508, 'mz', 'Mozambique, People\'s Republic Of'),
(512, 'om', 'Oman, Sultanate Of'),
(516, 'na', 'Namibia'),
(520, 'nr', 'Nauru, Republic Of'),
(524, 'np', 'Nepal, Kingdom Of'),
(528, 'nl', 'Netherlands, Kingdom Of The'),
(530, 'an', 'Netherlands Antilles'),
(533, 'aw', 'Aruba'),
(540, 'nc', 'New Caledonia'),
(548, 'vu', 'Vanuatu'),
(554, 'nz', 'New Zealand'),
(558, 'ni', 'Nicaragua, Republic Of'),
(562, 'ne', 'Niger, Republic Of The'),
(566, 'ng', 'Nigeria, Federal Republic Of'),
(570, 'nu', 'Niue, Republic Of'),
(574, 'nf', 'Norfolk Island'),
(578, 'no', 'Norway, Kingdom Of'),
(580, 'mp', 'Northern Mariana Islands'),
(581, 'um', 'United States Minor Outlying Islands'),
(583, 'fm', 'Micronesia, Federated States Of'),
(584, 'mh', 'Marshall Islands'),
(585, 'pw', 'Palau'),
(586, 'pk', 'Pakistan, Islamic Republic Of'),
(591, 'pa', 'Panama, Republic Of'),
(598, 'pg', 'Papua New Guinea'),
(600, 'py', 'Paraguay, Republic Of'),
(604, 'pe', 'Peru, Republic Of'),
(608, 'ph', 'Philippines, Republic Of The'),
(612, 'pn', 'Pitcairn Island'),
(616, 'pl', 'Poland, Polish People\'s Republic'),
(620, 'pt', 'Portugal, Portuguese Republic'),
(624, 'gw', 'Guinea-bissau, Republic Of'),
(626, 'tl', 'Timor-leste, Democratic Republic Of'),
(630, 'pr', 'Puerto Rico'),
(634, 'qa', 'Qatar, State Of'),
(638, 're', 'Reunion'),
(642, 'ro', 'Romania, Socialist Republic Of'),
(643, 'ru', 'Russian Federation'),
(646, 'rw', 'Rwanda, Rwandese Republic'),
(652, 'bl', 'Saint Barthélemy'),
(654, 'sh', 'St. Helena'),
(659, 'kn', 'St. Kitts And Nevis'),
(660, 'ai', 'Anguilla'),
(662, 'lc', 'St. Lucia'),
(663, 'mf', 'Saint Martin'),
(666, 'pm', 'St. Pierre And Miquelon'),
(670, 'vc', 'St. Vincent And The Grenadines'),
(674, 'sm', 'San Marino, Republic Of'),
(678, 'st', 'Sao Tome And Principe, Democratic Republic Of'),
(682, 'sa', 'Saudi Arabia, Kingdom Of'),
(686, 'sn', 'Senegal, Republic Of'),
(688, 'rs', 'Serbia'),
(690, 'sc', 'Seychelles, Republic Of'),
(694, 'sl', 'Sierra Leone, Republic Of'),
(702, 'sg', 'Singapore, Republic Of'),
(703, 'sk', 'Slovakia'),
(704, 'vn', 'Viet Nam, Socialist Republic Of'),
(705, 'si', 'Slovenia'),
(706, 'so', 'Somalia, Somali Republic'),
(710, 'za', 'South Africa, Republic Of'),
(716, 'zw', 'Zimbabwe'),
(724, 'es', 'Spain, Spanish State'),
(732, 'eh', 'Western Sahara'),
(736, 'sd', 'Sudan, Democratic Republic Of The'),
(740, 'sr', 'Suriname, Republic Of'),
(744, 'sj', 'Svalbard & Jan Mayen Islands'),
(748, 'sz', 'Swaziland, Kingdom Of'),
(752, 'se', 'Sweden, Kingdom Of'),
(756, 'ch', 'Switzerland, Swiss Confederation'),
(760, 'sy', 'Syrian Arab Republic'),
(762, 'tj', 'Tajikistan'),
(764, 'th', 'Thailand, Kingdom Of'),
(768, 'tg', 'Togo, Togolese Republic'),
(772, 'tk', 'Tokelau'),
(776, 'to', 'Tonga, Kingdom Of'),
(780, 'tt', 'Trinidad And Tobago, Republic Of'),
(784, 'ae', 'United Arab Emirates'),
(788, 'tn', 'Tunisia, Republic Of'),
(792, 'tr', 'Turkey, Republic Of'),
(795, 'tm', 'Turkmenistan'),
(796, 'tc', 'Turks And Caicos Islands'),
(798, 'tv', 'Tuvalu'),
(800, 'ug', 'Uganda, Republic Of'),
(804, 'ua', 'Ukraine'),
(807, 'mk', 'Macedonia, The Former Yugoslav Republic Of'),
(818, 'eg', 'Egypt, Arab Republic Of'),
(826, 'gb', 'United Kingdom Of Great Britain & N. Ireland'),
(831, 'gg', 'Guernsey'),
(832, 'je', 'Jersey'),
(833, 'im', 'Isle Of Man'),
(834, 'tz', 'Tanzania, United Republic Of'),
(840, 'us', 'United States Of America'),
(850, 'vi', 'Us Virgin Islands'),
(854, 'bf', 'Burkina Faso'),
(858, 'uy', 'Uruguay, Eastern Republic Of'),
(860, 'uz', 'Uzbekistan'),
(862, 've', 'Venezuela, Bolivarian Republic Of'),
(876, 'wf', 'Wallis And Futuna Islands'),
(882, 'ws', 'Samoa, Independent State Of'),
(887, 'ye', 'Yemen'),
(894, 'zm', 'Zambia, Republic Of');
SET FOREIGN_KEY_CHECKS=1;