-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 09-09-2024 a las 16:23:20
-- Versión del servidor: 10.11.6-MariaDB-0+deb12u1
-- Versión de PHP: 7.4.33

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

--
-- Base de datos: `cyan_backoffice_ecommerce`
--

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

--
-- Estructura de tabla para la tabla `maestro_pais`
--

CREATE TABLE `maestro_pais` (
  `id_pais` int(11) NOT NULL,
  `cod_dian` varchar(3) NOT NULL,
  `idioma` varchar(10) DEFAULT NULL,
  `nombre` varchar(40) NOT NULL,
  `codigo_iso2` varchar(2) NOT NULL COMMENT 'Formtato interncional ISO-2',
  `estado` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Volcado de datos para la tabla `maestro_pais`
--

INSERT INTO `maestro_pais` (`id_pais`, `cod_dian`, `idioma`, `nombre`, `codigo_iso2`, `estado`) VALUES
(1, '037', NULL, 'ANDORRA', 'AD', 1),
(2, '244', NULL, 'UNITED ARAB EMIRATES', 'AE', 1),
(3, '', NULL, 'AFGHANISTAN', 'AF', 1),
(4, '043', NULL, 'ANTIGUA AND BARBUDA', 'AG', 1),
(5, '041', NULL, 'ANGUILLA', 'AI', 1),
(6, '017', NULL, 'ALBANIA', 'AL', 1),
(7, '026', NULL, 'ARMENIA', 'AM', 1),
(8, '047', NULL, 'NETHERLANDS ANTILLES', 'AN', 1),
(9, '040', NULL, 'ANGOLA', 'AO', 1),
(10, '063', NULL, 'ARGENTINA', 'AR', 1),
(11, '690', NULL, 'AMERICAN SAMOA', 'AS', 1),
(12, '072', NULL, 'AUSTRIA', 'AT', 1),
(13, '069', NULL, 'AUSTRALIA', 'AU', 1),
(14, '027', NULL, 'ARUBA', 'AW', 1),
(15, '074', NULL, 'AZERBAIJAN', 'AZ', 1),
(16, '029', NULL, 'BOSNIA AND HERZEGOVINA', 'BA', 1),
(17, '083', NULL, 'BARBADOS', 'BB', 1),
(18, '081', NULL, 'BANGLADESH', 'BD', 1),
(19, '087', NULL, 'BELGIUM', 'BE', 1),
(20, '031', NULL, 'BURKINA FASO', 'BF', 1),
(21, '111', NULL, 'BULGARIA', 'BG', 1),
(22, '080', NULL, 'BAHRAIN', 'BH', 1),
(23, '115', NULL, 'BURUNDI', 'BI', 1),
(24, '229', NULL, 'BENIN', 'BJ', 1),
(25, '090', NULL, 'BERMUDA', 'BM', 1),
(26, '108', NULL, 'BRUNEI DARUSSALAM', 'BN', 1),
(27, '097', NULL, 'BOLIVIA', 'BO', 1),
(28, '105', NULL, 'BRAZIL', 'BR', 1),
(29, '077', NULL, 'BAHAMAS', 'BS', 1),
(30, '119', NULL, 'BHUTAN', 'BT', 1),
(31, '101', NULL, 'BOTSWANA', 'BW', 1),
(32, '091', NULL, 'BELARUS', 'BY', 1),
(33, '088', NULL, 'BELIZE', 'BZ', 1),
(34, '149', NULL, 'CANADA', 'CA', 1),
(35, '177', NULL, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD', 1),
(36, '640', NULL, 'CENTRAL AFRICAN REPUBLIC', 'CF', 1),
(37, '177', NULL, 'CONGO', 'CG', 1),
(38, '767', NULL, 'SWITZERLAND', 'CH', 1),
(39, '193', NULL, 'COTE D IVOIRE', 'CI', 1),
(40, '183', NULL, 'COOK ISLANDS', 'CK', 1),
(41, '211', NULL, 'CHILE', 'CL', 1),
(42, '145', NULL, 'CAMEROON', 'CM', 1),
(43, '215', NULL, 'CHINA', 'CN', 1),
(44, '169', NULL, 'COLOMBIA', 'CO', 1),
(45, '196', NULL, 'COSTA RICA', 'CR', 1),
(46, '199', NULL, 'CUBA', 'CU', 1),
(47, '127', NULL, 'CAPE VERDE', 'CV', 1),
(48, '511', NULL, 'CHRISTMAS ISLAND', 'CX', 1),
(49, '221', NULL, 'CYPRUS', 'CY', 1),
(50, '644', NULL, 'CZECH REPUBLIC', 'CZ', 1),
(51, '023', NULL, 'GERMANY', 'DE', 1),
(52, '783', NULL, 'DJIBOUTI', 'DJ', 1),
(53, '232', NULL, 'DENMARK', 'DK', 1),
(54, '235', NULL, 'DOMINICA', 'DM', 1),
(55, '647', NULL, 'DOMINICAN REPUBLIC', 'DO', 1),
(56, '059', NULL, 'ALGERIA', 'DZ', 1),
(57, '239', NULL, 'ECUADOR', 'EC', 1),
(58, '251', NULL, 'ESTONIA', 'EE', 1),
(59, '240', NULL, 'EGYPT', 'EG', 1),
(60, '685', NULL, 'WESTERN SAHARA', 'EH', 1),
(61, '243', NULL, 'ERITREA', 'ER', 1),
(62, '245', NULL, 'SPAIN', 'ES', 1),
(63, '253', NULL, 'ETHIOPIA', 'ET', 1),
(64, '271', NULL, 'FINLAND', 'FI', 1),
(65, '870', NULL, 'FIJI', 'FJ', 1),
(66, '', NULL, 'FALKLAND ISLANDS (MALVINAS)', 'FK', 1),
(67, '494', NULL, 'MICRONESIA, FEDERATED STATES OF', 'FM', 1),
(68, '259', NULL, 'FAROE ISLANDS', 'FO', 1),
(69, '275', NULL, 'FRANCE', 'FR', 1),
(70, '281', NULL, 'GABON', 'GA', 1),
(71, '628', NULL, 'UNITED KINGDOM', 'GB', 1),
(72, '297', NULL, 'GRENADA', 'GD', 1),
(73, '287', NULL, 'GEORGIA', 'GE', 1),
(74, '325', NULL, 'FRENCH GUIANA', 'GF', 1),
(75, '289', NULL, 'GHANA', 'GH', 1),
(76, '293', NULL, 'GIBRALTAR', 'GI', 1),
(77, '305', NULL, 'GREENLAND', 'GL', 1),
(78, '285', NULL, 'GAMBIA', 'GM', 1),
(79, '329', NULL, 'GUINEA', 'GN', 1),
(80, '309', NULL, 'GUADELOUPE', 'GP', 1),
(81, '331', NULL, 'EQUATORIAL GUINEA', 'GQ', 1),
(82, '301', NULL, 'GREECE', 'GR', 1),
(83, '', NULL, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISL', 'GS', 1),
(84, '317', NULL, 'GUATEMALA', 'GT', 1),
(85, '313', NULL, 'GUAM', 'GU', 1),
(86, '334', NULL, 'GUINEA-BISSAU', 'GW', 1),
(87, '', NULL, 'GUYANA', 'GY', 1),
(88, '351', NULL, 'HONG KONG', 'HK', 1),
(89, '345', NULL, 'HONDURAS', 'HN', 1),
(90, '198', NULL, 'CROATIA', 'HR', 1),
(91, '341', NULL, 'HAITI', 'HT', 1),
(92, '355', NULL, 'HUNGARY', 'HU', 1),
(93, '365', NULL, 'INDONESIA', 'ID', 1),
(94, '375', NULL, 'IRELAND', 'IE', 1),
(95, '383', NULL, 'ISRAEL', 'IL', 1),
(96, '361', NULL, 'INDIA', 'IN', 1),
(97, '369', NULL, 'IRAQ', 'IQ', 1),
(98, '372', NULL, 'IRAN, ISLAMIC REPUBLIC OF', 'IR', 1),
(99, '379', NULL, 'ICELAND', 'IS', 1),
(100, '386', NULL, 'ITALY', 'IT', 1),
(101, '391', NULL, 'JAMAICA', 'JM', 1),
(102, '403', NULL, 'JORDAN', 'JO', 1),
(103, '399', NULL, 'JAPAN', 'JP', 1),
(104, '410', NULL, 'KENYA', 'KE', 1),
(105, '412', NULL, 'KYRGYZSTAN', 'KG', 1),
(106, '141', NULL, 'CAMBODIA', 'KH', 1),
(107, '411', NULL, 'KIRIBATI', 'KI', 1),
(108, '173', NULL, 'COMOROS', 'KM', 1),
(109, '695', NULL, 'SAINT KITTS AND NEVIS', 'KN', 1),
(110, '187', NULL, 'KOREA, DEMOCRATIC PEOPLE S REPUBLIC OF', 'KP', 1),
(111, '190', NULL, 'KOREA, REPUBLIC OF', 'KR', 1),
(112, '413', NULL, 'KUWAIT', 'KW', 1),
(113, '137', NULL, 'CAYMAN ISLANDS', 'KY', 1),
(114, '406', NULL, 'KAZAKHSTAN', 'KZ', 1),
(115, '420', NULL, 'LAO PEOPLE S DEMOCRATIC REPUBLIC', 'LA', 1),
(116, '431', NULL, 'LEBANON', 'LB', 1),
(117, '715', NULL, 'SAINT LUCIA', 'LC', 1),
(118, '440', NULL, 'LIECHTENSTEIN', 'LI', 1),
(119, '750', NULL, 'SRI LANKA', 'LK', 1),
(120, '434', NULL, 'LIBERIA', 'LR', 1),
(121, '426', NULL, 'LESOTHO', 'LS', 1),
(122, '443', NULL, 'LITHUANIA', 'LT', 1),
(123, '445', NULL, 'LUXEMBOURG', 'LU', 1),
(124, '429', NULL, 'LATVIA', 'LV', 1),
(125, '438', NULL, 'LIBYAN ARAB JAMAHIRIYA', 'LY', 1),
(126, '474', NULL, 'MOROCCO', 'MA', 1),
(127, '498', NULL, 'MONACO', 'MC', 1),
(128, '496', NULL, 'MOLDOVA, REPUBLIC OF', 'MD', 1),
(129, '450', NULL, 'MADAGASCAR', 'MG', 1),
(130, '472', NULL, 'MARSHALL ISLANDS', 'MH', 1),
(131, '', NULL, 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC ', 'MK', 1),
(132, '464', NULL, 'MALI', 'ML', 1),
(133, '093', NULL, 'MYANMAR', 'MM', 1),
(134, '497', NULL, 'MONGOLIA', 'MN', 1),
(135, '447', NULL, 'MACAO', 'MO', 1),
(136, '469', NULL, 'NORTHERN MARIANA ISLANDS', 'MP', 1),
(137, '477', NULL, 'MARTINIQUE', 'MQ', 1),
(138, '488', NULL, 'MAURITANIA', 'MR', 1),
(139, '', NULL, 'MONTSERRAT', 'MS', 1),
(140, '467', NULL, 'MALTA', 'MT', 1),
(141, '485', NULL, 'MAURITIUS', 'MU', 1),
(142, '461', NULL, 'MALDIVES', 'MV', 1),
(143, '458', NULL, 'MALAWI', 'MW', 1),
(144, '493', NULL, 'MEXICO', 'MX', 1),
(145, '455', NULL, 'MALAYSIA', 'MY', 1),
(146, '505', NULL, 'MOZAMBIQUE', 'MZ', 1),
(147, '507', NULL, 'NAMIBIA', 'NA', 1),
(148, '542', NULL, 'NEW CALEDONIA', 'NC', 1),
(149, '525', NULL, 'NIGER', 'NE', 1),
(150, '535', NULL, 'NORFOLK ISLAND', 'NF', 1),
(151, '528', NULL, 'NIGERIA', 'NG', 1),
(152, '521', NULL, 'NICARAGUA', 'NI', 1),
(153, '573', NULL, 'NETHERLANDS', 'NL', 1),
(154, '538', NULL, 'NORWAY', 'NO', 1),
(155, '517', NULL, 'NEPAL', 'NP', 1),
(156, '531', NULL, 'NIUE', 'NU', 1),
(157, '548', NULL, 'NEW ZEALAND', 'NZ', 1),
(158, '556', NULL, 'OMAN', 'OM', 1),
(159, '580', NULL, 'PANAMA', 'PA', 1),
(160, '589', NULL, 'PERU', 'PE', 1),
(161, '599', NULL, 'FRENCH POLYNESIA', 'PF', 1),
(162, '545', NULL, 'PAPUA NEW GUINEA', 'PG', 1),
(163, '267', NULL, 'PHILIPPINES', 'PH', 1),
(164, '576', NULL, 'PAKISTAN', 'PK', 1),
(165, '603', NULL, 'POLAND', 'PL', 1),
(166, '700', NULL, 'SAINT PIERRE AND MIQUELON', 'PM', 1),
(167, '593', NULL, 'PITCAIRN', 'PN', 1),
(168, '611', NULL, 'PUERTO RICO', 'PR', 1),
(169, '', NULL, 'PALESTINIAN TERRITORY, OCCUPIED', 'PS', 1),
(170, '607', NULL, 'PORTUGAL', 'PT', 1),
(171, '578', NULL, 'PALAU', 'PW', 1),
(172, '586', NULL, 'PARAGUAY', 'PY', 1),
(173, '618', NULL, 'QATAR', 'QA', 1),
(174, '660', NULL, 'REUNION', 'RE', 1),
(175, '670', NULL, 'ROMANIA', 'RO', 1),
(176, '676', NULL, 'RUSSIAN FEDERATION', 'RU', 1),
(177, '675', NULL, 'RWANDA', 'RW', 1),
(178, '053', NULL, 'SAUDI ARABIA', 'SA', 1),
(179, '677', NULL, 'SOLOMON ISLANDS', 'SB', 1),
(180, '731', NULL, 'SEYCHELLES', 'SC', 1),
(181, '759', NULL, 'SUDAN', 'SD', 1),
(182, '764', NULL, 'SWEDEN', 'SE', 1),
(183, '741', NULL, 'SINGAPORE', 'SG', 1),
(184, '710', NULL, 'SAINT HELENA', 'SH', 1),
(185, '247', NULL, 'SLOVENIA', 'SI', 1),
(186, '', NULL, 'SVALBARD AND JAN MAYEN', 'SJ', 1),
(187, '246', NULL, 'SLOVAKIA', 'SK', 1),
(188, '735', NULL, 'SIERRA LEONE', 'SL', 1),
(189, '697', NULL, 'SAN MARINO', 'SM', 1),
(190, '728', NULL, 'SENEGAL', 'SN', 1),
(191, '748', NULL, 'SOMALIA', 'SO', 1),
(192, '770', NULL, 'SURINAME', 'SR', 1),
(193, '720', NULL, 'SAO TOME AND PRINCIPE', 'ST', 1),
(194, '242', NULL, 'EL SALVADOR', 'SV', 1),
(195, '744', NULL, 'SYRIAN ARAB REPUBLIC', 'SY', 1),
(196, '', NULL, 'SWAZILAND', 'SZ', 1),
(197, '823', NULL, 'TURKS AND CAICOS ISLANDS', 'TC', 1),
(198, '203', NULL, 'CHAD', 'TD', 1),
(199, '', NULL, 'FRENCH SOUTHERN TERRITORIES', 'TF', 1),
(200, '800', NULL, 'TOGO', 'TG', 1),
(201, '776', NULL, 'THAILAND', 'TH', 1),
(202, '', NULL, 'TAJIKISTAN', 'TJ', 1),
(203, '788', NULL, 'TIMOR-LESTE', 'TL', 1),
(204, '825', NULL, 'TURKMENISTAN', 'TM', 1),
(205, '', NULL, 'TUNISIA', 'TN', 1),
(206, '810', NULL, 'TONGA', 'TO', 1),
(207, '827', NULL, 'TURKEY', 'TR', 1),
(208, '815', NULL, 'TRINIDAD AND TOBAGO', 'TT', 1),
(209, '828', NULL, 'TUVALU', 'TV', 1),
(210, '', NULL, 'TAIWAN, PROVINCE OF CHINA', 'TW', 1),
(211, '780', NULL, 'TANZANIA, UNITED REPUBLIC OF', 'TZ', 1),
(212, '830', NULL, 'UKRAINE', 'UA', 1),
(213, '833', NULL, 'UGANDA', 'UG', 1),
(214, '249', NULL, 'UNITED STATES', 'US', 1),
(215, '845', NULL, 'URUGUAY', 'UY', 1),
(216, '847', NULL, 'UZBEKISTAN', 'UZ', 1),
(217, '705', NULL, 'SAINT VINCENT AND THE GRENADINES', 'VC', 1),
(218, '850', NULL, 'VENEZUELA', 'VE', 1),
(219, '863', NULL, 'VIRGIN ISLANDS, BRITISH', 'VG', 1),
(220, '866', NULL, 'VIRGIN ISLANDS, U.S.', 'VI', 1),
(221, '855', NULL, 'VIET NAM', 'VN', 1),
(222, '551', NULL, 'VANUATU', 'VU', 1),
(223, '875', NULL, 'WALLIS AND FUTUNA', 'WF', 1),
(224, '687', NULL, 'SAMOA', 'WS', 1),
(225, '880', NULL, 'YEMEN', 'YE', 1),
(226, '', NULL, 'MAYOTTE', 'YT', 1),
(227, '756', NULL, 'SOUTH AFRICA', 'ZA', 1),
(228, '890', NULL, 'ZAMBIA', 'ZM', 1),
(229, '665', NULL, 'ZIMBABWE', 'ZW', 1);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `maestro_pais`
--
ALTER TABLE `maestro_pais`
  ADD PRIMARY KEY (`id_pais`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `maestro_pais`
--
ALTER TABLE `maestro_pais`
  MODIFY `id_pais` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=230;
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 */;
