-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 14, 2025 at 03:11 PM
-- Server version: 5.7.42-cll-lve
-- PHP Version: 8.1.31

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 */;

--
-- Database: `bdmaco_dhl`
--

-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `country_code` varchar(10) NOT NULL,
  `country_name` varchar(100) NOT NULL,
  `idp_convention` varchar(255) DEFAULT NULL,
  `region` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`country_code`, `country_name`, `idp_convention`, `region`, `created_at`) VALUES
('AD', 'ANDORRA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('AE', 'UNITED ARAB EMIRATES', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('AF', 'AFGHANISTAN', NULL, NULL, '2025-09-13 08:41:16'),
('AG', 'ANTIGUA', NULL, NULL, '2025-09-13 08:41:16'),
('AI', 'ANGUILLA', NULL, NULL, '2025-09-13 08:41:16'),
('AL', 'ALBANIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('AM', 'ARMENIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('AO', 'ANGOLA', NULL, NULL, '2025-09-13 08:41:16'),
('AR', 'ARGENTINA', 'Argentina has signed 1949 UN Convention on Road Traffic. ITCA will Issue 1949 version of the Booklet', NULL, '2025-09-13 08:41:16'),
('AS', 'AMERICAN SAMOA', NULL, NULL, '2025-09-13 08:41:16'),
('AT', 'AUSTRIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('AU', 'AUSTRALIA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('AW', 'ARUBA', NULL, NULL, '2025-09-13 08:41:16'),
('AZ', 'AZERBAIJAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BA', 'BOSNIA AND HERZEGOVINA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BB', 'BARBADOS', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('BD', 'BANGLADESH', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('BE', 'BELGIUM', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BF', 'BURKINA FASO', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('BG', 'BULGARIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BH', 'BAHRAIN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BI', 'BURUNDI', NULL, NULL, '2025-09-13 08:41:16'),
('BJ', 'BENIN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BL', 'SAINT BARTHELEMY', NULL, NULL, '2025-09-13 08:41:16'),
('BM', 'BERMUDA', NULL, NULL, '2025-09-13 08:41:16'),
('BN', 'BRUNEI', NULL, NULL, '2025-09-13 08:41:16'),
('BO', 'BOLIVIA', NULL, NULL, '2025-09-13 08:41:16'),
('BR', 'BRAZIL', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BS', 'BAHAMAS', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BT', 'BHUTAN', NULL, NULL, '2025-09-13 08:41:16'),
('BW', 'BOTSWANA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('BY', 'BELARUS', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('BZ', 'BELIZE', NULL, NULL, '2025-09-13 08:41:16'),
('CA', 'CANADA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF', NULL, NULL, '2025-09-13 08:41:16'),
('CF', 'CENTRAL AFRICAN REPUBLIC', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('CG', 'CONGO', NULL, NULL, '2025-09-13 08:41:16'),
('CH', 'SWITZERLAND', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('CI', 'COTE D IVOIRE', NULL, NULL, '2025-09-13 08:41:16'),
('CK', 'COOK ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('CL', 'CHILE', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('CM', 'CAMEROON', NULL, NULL, '2025-09-13 08:41:16'),
('CN', 'CHINA, PEOPLES REPUBLIC', NULL, NULL, '2025-09-13 08:41:16'),
('CO', 'COLOMBIA', NULL, NULL, '2025-09-13 08:41:16'),
('CR', 'COSTA RICA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('CU', 'CUBA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('CV', 'CAPE VERDE', NULL, NULL, '2025-09-13 08:41:16'),
('CY', 'CYPRUS', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('CZ', 'CZECH REPUBLIC, THE', NULL, NULL, '2025-09-13 08:41:16'),
('DE', 'GERMANY', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('DJ', 'DJIBOUTI', NULL, NULL, '2025-09-13 08:41:16'),
('DK', 'DENMARK', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('DM', 'DOMINICA', NULL, NULL, '2025-09-13 08:41:16'),
('DO', 'DOMINICAN REPUBLIC', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('DZ', 'ALGERIA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('EC', 'ECUADOR', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('EE', 'ESTONIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('EG', 'EGYPT', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('EH', 'WESTERN SAHARA', NULL, NULL, '2025-09-13 08:41:16'),
('ER', 'ERITREA', NULL, NULL, '2025-09-13 08:41:16'),
('ES', 'SPAIN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('ET', 'ETHIOPIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('FI', 'FINLAND', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('FJ', 'FIJI', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('FK', 'FALKLAND ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('FM', 'MICRONESIA, FEDERATED STATES OF', NULL, NULL, '2025-09-13 08:41:16'),
('FO', 'FAROE ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('FR', 'FRANCE', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('GA', 'GABON', NULL, NULL, '2025-09-13 08:41:16'),
('GB', 'UNITED KINGDOM', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('GD', 'GRENADA', NULL, NULL, '2025-09-13 08:41:16'),
('GE', 'GEORGIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('GF', 'FRENCH GUYANA', NULL, NULL, '2025-09-13 08:41:16'),
('GG', 'GUERNSEY', NULL, NULL, '2025-09-13 08:41:16'),
('GH', 'GHANA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('GI', 'GIBRALTAR', NULL, NULL, '2025-09-13 08:41:16'),
('GL', 'GREENLAND', NULL, NULL, '2025-09-13 08:41:16'),
('GM', 'GAMBIA', NULL, NULL, '2025-09-13 08:41:16'),
('GN', 'GUINEA REPUBLIC', NULL, NULL, '2025-09-13 08:41:16'),
('GP', 'GUADELOUPE', NULL, NULL, '2025-09-13 08:41:16'),
('GQ', 'GUINEA-EQUATORIAL', NULL, NULL, '2025-09-13 08:41:16'),
('GR', 'GREECE', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('GT', 'GUATEMALA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('GU', 'GUAM', NULL, NULL, '2025-09-13 08:41:16'),
('GW', 'GUINEA-BISSAU', NULL, NULL, '2025-09-13 08:41:16'),
('GY', 'GUYANA (BRITISH)', NULL, NULL, '2025-09-13 08:41:16'),
('HK', 'HONG KONG SAR, CHINA', NULL, NULL, '2025-09-13 08:41:16'),
('HN', 'HONDURAS', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('HR', 'CROATIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('HT', 'HAITI', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('HU', 'HUNGARY', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('IC', 'CANARY ISLANDS, THE', NULL, NULL, '2025-09-13 08:41:16'),
('ID', 'INDONESIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('IE', 'IRELAND, REPUBLIC OF', NULL, NULL, '2025-09-13 08:41:16'),
('IL', 'ISRAEL', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('IN', 'INDIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('IQ', 'IRAQ', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('IR', 'IRAN (ISLAMIC REPUBLIC OF)', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('IS', 'ICELAND', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('IT', 'ITALY', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('JE', 'JERSEY', NULL, NULL, '2025-09-13 08:41:16'),
('JM', 'JAMAICA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('JO', 'JORDAN', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('JP', 'JAPAN', 'NOT VALID - DO NOT APPLY', NULL, '2025-09-13 08:41:16'),
('KE', 'KENYA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('KG', 'KYRGYZSTAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('KH', 'CAMBODIA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('KI', 'KIRIBATI', NULL, NULL, '2025-09-13 08:41:16'),
('KM', 'COMOROS', NULL, NULL, '2025-09-13 08:41:16'),
('KN', 'SAINT KITTS AND NEVIS', NULL, NULL, '2025-09-13 08:41:16'),
('KP', 'KOREA, THE D.P.R OF (NORTH K.)', NULL, NULL, '2025-09-13 08:41:16'),
('KR', 'KOREA, REPUBLIC OF (SOUTH K.)', NULL, NULL, '2025-09-13 08:41:16'),
('KV', 'KOSOVO', NULL, NULL, '2025-09-13 08:41:16'),
('KW', 'KUWAIT', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('KY', 'CAYMAN ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('KZ', 'KAZAKHSTAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('LA', 'LAO PEOPLES DEMOCRATIC REPUBLIC', NULL, NULL, '2025-09-13 08:41:16'),
('LB', 'LEBANON', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('LC', 'SAINT LUCIA', NULL, NULL, '2025-09-13 08:41:16'),
('LI', 'LIECHTENSTEIN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('LK', 'SRI LANKA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('LR', 'LIBERIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('LS', 'LESOTHO', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('LT', 'LITHUANIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('LU', 'LUXEMBOURG', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('LV', 'LATVIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('LY', 'LIBYA', NULL, NULL, '2025-09-13 08:41:16'),
('MA', 'MOROCCO', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('MC', 'MONACO', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('MD', 'MOLDOVA, REPUBLIC OF', NULL, NULL, '2025-09-13 08:41:16'),
('ME', 'MONTENEGRO, REPUBLIC OF', NULL, NULL, '2025-09-13 08:41:16'),
('MF', 'SAINT MARTIN', NULL, NULL, '2025-09-13 08:41:16'),
('MG', 'MADAGASCAR', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('MH', 'MARSHALL ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('ML', 'MALI', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('MM', 'MYANMAR', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('MN', 'MONGOLIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('MO', 'MACAO SAR, CHINA', NULL, NULL, '2025-09-13 08:41:16'),
('MP', 'COMMONWEALTH NO. MARIANA ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('MQ', 'MARTINIQUE', NULL, NULL, '2025-09-13 08:41:16'),
('MR', 'MAURITANIA', NULL, NULL, '2025-09-13 08:41:16'),
('MS', 'MONTSERRAT', NULL, NULL, '2025-09-13 08:41:16'),
('MT', 'MALTA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('MU', 'MAURITIUS', NULL, NULL, '2025-09-13 08:41:16'),
('MV', 'MALDIVES', NULL, NULL, '2025-09-13 08:41:16'),
('MW', 'MALAWI', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('MX', 'MEXICO', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('MY', 'MALAYSIA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('MZ', 'MOZAMBIQUE', NULL, NULL, '2025-09-13 08:41:16'),
('NA', 'NAMIBIA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('NC', 'NEW CALEDONIA', NULL, NULL, '2025-09-13 08:41:16'),
('NE', 'NIGER', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('NF', 'NORFOLK ISLAND', NULL, NULL, '2025-09-13 08:41:16'),
('NG', 'NIGERIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('NI', 'NICARAGUA', NULL, NULL, '2025-09-13 08:41:16'),
('NL', 'NETHERLANDS, THE', NULL, NULL, '2025-09-13 08:41:16'),
('NO', 'NORWAY', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('NP', 'NEPAL', NULL, NULL, '2025-09-13 08:41:16'),
('NR', 'NAURU, REPUBLIC OF', NULL, NULL, '2025-09-13 08:41:16'),
('NU', 'NIUE', NULL, NULL, '2025-09-13 08:41:16'),
('NZ', 'NEW ZEALAND', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('OM', 'OMAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('PA', 'PANAMA', NULL, NULL, '2025-09-13 08:41:16'),
('PE', 'PERU', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('PG', 'PAPUA NEW GUINEA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('PH', 'PHILIPPINES', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('PK', 'PAKISTAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('PL', 'POLAND', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('PM', 'SAINT PIERRE AND MIQUELON', NULL, NULL, '2025-09-13 08:41:16'),
('PR', 'PUERTO RICO', NULL, NULL, '2025-09-13 08:41:16'),
('PS', 'PALESTINIAN TERRITORIES', NULL, NULL, '2025-09-13 08:41:16'),
('PT', 'PORTUGAL', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('PW', 'PALAU', NULL, NULL, '2025-09-13 08:41:16'),
('PY', 'PARAGUAY', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('QA', 'QATAR', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('RE', 'REUNION', NULL, NULL, '2025-09-13 08:41:16'),
('RO', 'ROMANIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('RS', 'SERBIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('RU', 'RUSSIAN FEDERATION', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('RW', 'RWANDA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('SA', 'SAUDI ARABIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SB', 'SOLOMON ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('SC', 'SEYCHELLES', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SD', 'SUDAN', NULL, NULL, '2025-09-13 08:41:16'),
('SE', 'SWEDEN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SG', 'SINGAPORE', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('SI', 'SLOVENIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SK', 'SLOVAKIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SL', 'SIERRA LEONE', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('SM', 'SAN MARINO', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SN', 'SENEGAL', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SO', 'SOMALIA', NULL, NULL, '2025-09-13 08:41:16'),
('SR', 'SURINAME', NULL, NULL, '2025-09-13 08:41:16'),
('SS', 'SOUTH SUDAN', NULL, NULL, '2025-09-13 08:41:16'),
('ST', 'SAO TOME AND PRINCIPE', NULL, NULL, '2025-09-13 08:41:16'),
('SV', 'EL SALVADOR', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('SX', 'SINT MAARTEN', NULL, NULL, '2025-09-13 08:41:16'),
('SY', 'SYRIAN ARAB REPUBLIC', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('SZ', 'ESWATINI', NULL, NULL, '2025-09-13 08:41:16'),
('TC', 'TURKS AND CAICOS ISLANDS', NULL, NULL, '2025-09-13 08:41:16'),
('TD', 'CHAD', NULL, NULL, '2025-09-13 08:41:16'),
('TG', 'TOGO', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('TH', 'THAILAND', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('TJ', 'TAJIKISTAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('TK', 'TOKELAU', NULL, NULL, '2025-09-13 08:41:16'),
('TL', 'TIMOR-LESTE', NULL, NULL, '2025-09-13 08:41:16'),
('TM', 'TURKMENISTAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('TN', 'TUNISIA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('TO', 'TONGA', NULL, NULL, '2025-09-13 08:41:16'),
('TR', 'TURKEY', NULL, NULL, '2025-09-13 08:41:16'),
('TT', 'TRINIDAD AND TOBAGO', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('TV', 'TUVALU', NULL, NULL, '2025-09-13 08:41:16'),
('TW', 'TAIWAN', NULL, NULL, '2025-09-13 08:41:16'),
('TZ', 'TANZANIA', NULL, NULL, '2025-09-13 08:41:16'),
('UA', 'UKRAINE', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('UG', 'UGANDA', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16'),
('US', 'UNITED STATES', NULL, NULL, '2025-09-13 08:41:16'),
('UY', 'URUGUAY', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('UZ', 'UZBEKISTAN', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('VC', 'SAINT VINCENT AND THE GRENADINES', NULL, NULL, '2025-09-13 08:41:16'),
('VE', 'VENEZUELA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('VG', 'VIRGIN ISLANDS (BRITISH)', NULL, NULL, '2025-09-13 08:41:16'),
('VI', 'VIRGIN ISLANDS (USA)', NULL, NULL, '2025-09-13 08:41:16'),
('VN', 'VIET NAM', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('VU', 'VANUATU', NULL, NULL, '2025-09-13 08:41:16'),
('WF', 'WALLIS AND FUTUNA', NULL, NULL, '2025-09-13 08:41:16'),
('WS', 'SAMOA', NULL, NULL, '2025-09-13 08:41:16'),
('XB', 'BONAIRE', NULL, NULL, '2025-09-13 08:41:16'),
('XC', 'CURACAO', NULL, NULL, '2025-09-13 08:41:16'),
('XG', 'GLOBAL MAIL BILLING', NULL, NULL, '2025-09-13 08:41:16'),
('XN', 'NEVIS', NULL, NULL, '2025-09-13 08:41:16'),
('YE', 'YEMEN', NULL, NULL, '2025-09-13 08:41:16'),
('YT', 'MAYOTTE', NULL, NULL, '2025-09-13 08:41:16'),
('ZA', 'SOUTH AFRICA', '1968 Vienna Convention (Annex 7 IDP / Annex 6 DDP)', NULL, '2025-09-13 08:41:16'),
('ZM', 'ZAMBIA', NULL, NULL, '2025-09-13 08:41:16'),
('ZW', 'ZIMBABWE', '1949 Geneva Convention (Annex 10 IDP)', NULL, '2025-09-13 08:41:16');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`country_code`);
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 */;