-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : mer. 26 juil. 2023 à 16:37
-- Version du serveur : 8.0.33-0ubuntu0.22.04.4
-- Version de PHP : 8.1.2-1ubuntu2.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

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

CREATE TABLE `pays` (
  `pays_id` int NOT NULL,
  `pays_code` varchar(2) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `pays_lib` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf32;

--
-- Déchargement des données de la table `pays`
--

INSERT INTO `pays` (`pays_id`, `pays_code`, `pays_lib`) VALUES
(1, 'BY', 'Belarus'),
(2, 'MD', 'Moldova'),
(3, 'LT', 'Lithuania'),
(4, 'RU', 'Russia'),
(5, 'RO', 'Romania'),
(6, 'UA', 'Ukraine'),
(7, 'AD', 'Andorra'),
(8, 'HU', 'Hungary'),
(9, 'CZ', 'Czech Republic'),
(10, 'SK', 'Slovakia'),
(11, 'PT', 'Portugal'),
(12, 'RS', 'Serbia'),
(13, 'GD', 'Grenada'),
(14, 'PL', 'Poland'),
(15, 'LV', 'Latvia'),
(16, 'FI', 'Finland'),
(17, 'KR', 'South Korea'),
(18, 'FR', 'France'),
(19, 'AU', 'Australia'),
(20, 'HR', 'Croatia'),
(21, 'IE', 'Ireland'),
(22, 'LU', 'Luxembourg'),
(23, 'DE', 'Germany'),
(24, 'SI', 'Slovenia'),
(25, 'GB', 'United Kingdom'),
(26, 'DK', 'Denmark'),
(27, 'BG', 'Bulgaria'),
(28, 'ES', 'Spain'),
(29, 'BE', 'Belgium'),
(30, 'ZA', 'South Africa'),
(31, 'NZ', 'New Zealand'),
(32, 'GA', 'Gabon'),
(33, 'NA', 'Namibia'),
(34, 'CH', 'Switzerland'),
(35, 'LC', 'Saint Lucia'),
(36, 'AT', 'Austria'),
(37, 'EE', 'Estonia'),
(38, 'GR', 'Greece'),
(39, 'KZ', 'Kazakhstan'),
(40, 'CA', 'Canada'),
(41, 'NG', 'Nigeria'),
(42, 'NL', 'Netherlands'),
(43, 'UG', 'Uganda'),
(44, 'RW', 'Rwanda'),
(45, 'CL', 'Chile'),
(46, 'AR', 'Argentina'),
(47, 'BI', 'Burundi'),
(48, 'US', 'United States'),
(49, 'CY', 'Cyprus'),
(50, 'SE', 'Sweden'),
(51, 'VE', 'Venezuela'),
(52, 'PY', 'Paraguay'),
(53, 'BR', 'Brazil'),
(54, 'SL', 'Sierra Leone'),
(55, 'ME', 'Montenegro'),
(56, 'BZ', 'Belize'),
(57, 'CM', 'Cameroon'),
(58, 'BW', 'Botswana'),
(59, 'KN', 'Saint Kitts and Nevis'),
(60, 'GY', 'Guyana'),
(61, 'PE', 'Peru'),
(62, 'PA', 'Panama'),
(63, 'NU', 'Niue'),
(64, 'PW', 'Palau'),
(65, 'NO', 'Norway'),
(66, 'TZ', 'Tanzania'),
(67, 'GE', 'Georgia'),
(68, 'UY', 'Uruguay'),
(69, 'AO', 'Angola'),
(70, 'LA', 'Laos'),
(71, 'JP', 'Japan'),
(72, 'MX', 'Mexico'),
(73, 'EC', 'Ecuador'),
(74, 'DM', 'Dominica'),
(75, 'IS', 'Iceland'),
(76, 'TH', 'Thailand'),
(77, 'BA', 'Bosnia and Herzegovina'),
(78, 'ST', 'Sao Tome and Principe'),
(79, 'MT', 'Malta'),
(80, 'AL', 'Albania'),
(81, 'BS', 'Bahamas'),
(82, 'DO', 'Dominican Republic'),
(83, 'MN', 'Mongolia'),
(84, 'CV', 'Cape Verde'),
(85, 'BB', 'Barbados'),
(86, 'BF', 'Burkina Faso'),
(87, 'IT', 'Italy'),
(88, 'TT', 'Trinidad and Tobago'),
(89, 'CN', 'China'),
(90, 'MK', 'Macedonia'),
(91, 'VC', 'Saint Vincent and the Grenadines'),
(92, 'GQ', 'Equatorial Guinea'),
(93, 'SR', 'Suriname'),
(94, 'VN', 'Vietnam'),
(95, 'LS', 'Lesotho'),
(96, 'HT', 'Haiti'),
(97, 'CK', 'Cook Islands'),
(98, 'CO', 'Colombia'),
(99, 'CI', 'Ivory Coast'),
(100, 'BO', 'Bolivia'),
(101, 'SZ', 'Swaziland'),
(102, 'ZW', 'Zimbabwe'),
(103, 'SC', 'Seychelles'),
(104, 'KH', 'Cambodia'),
(105, 'PR', 'Puerto Rico'),
(106, 'AN', 'Netherlands Antilles'),
(107, 'PH', 'Philippines'),
(108, 'CR', 'Costa Rica'),
(109, 'AM', 'Armenia'),
(110, 'CU', 'Cuba'),
(111, 'NI', 'Nicaragua'),
(112, 'JM', 'Jamaica'),
(113, 'GH', 'Ghana'),
(114, 'LR', 'Liberia'),
(115, 'UZ', 'Uzbekistan'),
(116, 'TD', 'Chad'),
(117, 'AE', 'United Arab Emirates'),
(118, 'KG', 'Kyrgyzstan'),
(119, 'IN', 'India'),
(120, 'TM', 'Turkmenistan'),
(121, 'KE', 'Kenya'),
(122, 'ET', 'Ethiopia'),
(123, 'HN', 'Honduras'),
(124, 'GW', 'Guinea-Bissau'),
(125, 'ZM', 'Zambia'),
(126, 'CG', 'Republic of the Congo'),
(127, 'GT', 'Guatemala'),
(128, 'CF', 'Central African Republic'),
(129, 'KP', 'North Korea'),
(130, 'LK', 'Sri Lanka'),
(131, 'MU', 'Mauritius'),
(132, 'WS', 'Samoa'),
(133, 'CG', 'Democratic Republic of the Congo'),
(134, 'NR', 'Nauru'),
(135, 'GM', 'Gambia'),
(136, 'FM', 'Federated States of Micronesia'),
(137, 'SV', 'El Salvador'),
(138, 'FJ', 'Fiji'),
(139, 'PG', 'Papua New Guinea'),
(140, 'KI', 'Kiribati'),
(141, 'TJ', 'Tajikistan'),
(142, 'IL', 'Israel'),
(143, 'SD', 'Sudan'),
(144, 'MW', 'Malawi'),
(145, 'LB', 'Lebanon'),
(146, 'AZ', 'Azerbaijan'),
(147, 'MZ', 'Mozambique'),
(148, 'TG', 'Togo'),
(149, 'NP', 'Nepal'),
(150, 'BN', 'Brunei'),
(151, 'BJ', 'Benin'),
(152, 'SG', 'Singapore'),
(153, 'TR', 'Turkey'),
(154, 'MG', 'Madagascar'),
(155, 'SB', 'Solomon Islands'),
(156, 'TO', 'Tonga'),
(157, 'TN', 'Tunisia'),
(158, 'TV', 'Tuvalu'),
(159, 'QA', 'Qatar'),
(160, 'VU', 'Vanuatu'),
(161, 'DJ', 'Djibouti'),
(162, 'MY', 'Malaysia'),
(163, 'SY', 'Syria'),
(164, 'MV', 'Maldives'),
(165, 'ML', 'Mali'),
(166, 'ER', 'Eritrea'),
(167, 'DZ', 'Algeria'),
(168, 'IR', 'Iran'),
(169, 'OM', 'Oman'),
(171, 'MA', 'Morocco'),
(172, 'JO', 'Jordan'),
(173, 'BT', 'Bhutan'),
(174, 'GN', 'Guinea'),
(175, 'MM', 'Burma'),
(176, 'AF', 'Afghanistan'),
(177, 'SN', 'Senegal'),
(178, 'ID', 'Indonesia'),
(179, 'TL', 'Timor-Leste'),
(180, 'IQ', 'Iraq'),
(181, 'SO', 'Somalia'),
(182, 'EG', 'Egypt'),
(183, 'NE', 'Niger'),
(184, 'YE', 'Yemen'),
(185, 'KM', 'Comoros'),
(186, 'SA', 'Saudi Arabia'),
(187, 'BD', 'Bangladesh'),
(188, 'KW', 'Kuwait'),
(189, 'LY', 'Libya'),
(190, 'MR', 'Mauritania'),
(191, 'PK', 'Pakistan');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `pays`
--
ALTER TABLE `pays`
  ADD PRIMARY KEY (`pays_id`),
  ADD KEY `pays_code` (`pays_code`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `pays`
--
ALTER TABLE `pays`
  MODIFY `pays_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=192;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
