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

INSERT INTO `countries` (`id`, `acro_2`, `name`, `iso31661`, `acro_3`, `importance`) VALUES
(1, 'AD', 'Andorra', 20, 'AND', '0.00'),
(2, 'AE', 'Emiratos Árabes Unidos', 784, 'ARE', '0.00'),
(3, 'AF', 'Afganistán', 4, 'AFG', '0.00'),
(4, 'AG', 'Antigua y Barbuda', 28, 'ATG', '0.00'),
(5, 'AI', 'Anguila', 660, 'AIA', '0.00'),
(6, 'AL', 'Albania', 8, 'ALB', '0.00'),
(7, 'AM', 'Armenia', 51, 'ARM', '0.00'),
(8, 'AN', 'Antillas Holandesas', 530, 'ANT', '0.00'),
(9, 'AO', 'Angola', 24, 'AGO', '0.00'),
(10, 'AQ', 'Antártida', 10, 'ATA', '0.00'),
(11, 'AR', 'Argentina', 32, 'ARG', '0.00'),
(12, 'AS', 'Samoa Americana', 16, 'ASM', '0.00'),
(13, 'AT', 'Austria', 40, 'AUT', '0.00'),
(14, 'AU', 'Australia', 36, 'AUS', '0.00'),
(15, 'AW', 'Aruba', 533, 'ABW', '0.00'),
(16, 'AX', 'Islas Åland', 248, 'ALA', '0.00'),
(17, 'AZ', 'Azerbaiyán', 31, 'AZE', '0.00'),
(18, 'BA', 'Bosnia y Herzegovina', 70, 'BIH', '0.00'),
(19, 'BB', 'Barbados', 52, 'BRB', '0.00'),
(20, 'BD', 'Bangladesh', 50, 'BGD', '0.00'),
(21, 'BE', 'Bélgica', 56, 'BEL', '0.00'),
(22, 'BF', 'Burkina Faso', 854, 'BFA', '0.00'),
(23, 'BG', 'Bulgaria', 100, 'BGR', '0.00'),
(24, 'BH', 'Baréin', 48, 'BHR', '0.00'),
(25, 'BI', 'Burundi', 108, 'BDI', '0.00'),
(26, 'BJ', 'Bení­n', 204, 'BEN', '0.00'),
(27, 'BL', 'San Bartolomé', 652, 'BLM', '0.00'),
(28, 'BM', 'Bermudas', 60, 'BMU', '0.00'),
(29, 'BN', 'Brunéi', 96, 'BRN', '0.00'),
(30, 'BO', 'Bolivia', 68, 'BOL', '0.00'),
(31, 'BR', 'Brasil', 76, 'BRA', '0.00'),
(32, 'BS', 'Bahamas', 44, 'BHS', '0.00'),
(33, 'BT', 'Bután', 64, 'BTN', '0.00'),
(34, 'BV', 'Isla Bouvet', 74, 'BVT', '0.00'),
(35, 'BW', 'Botsuana', 72, 'BWA', '0.00'),
(36, 'BY', 'Bielorrusia', 112, 'BLR', '0.00'),
(37, 'BZ', 'Belice', 84, 'BLZ', '0.00'),
(38, 'CA', 'Canadá', 124, 'CAN', '0.00'),
(39, 'CC', '<NAME>', 166, 'CCK', '0.00'),
(40, 'CF', 'República Centro-Africana', 140, 'CAF', '0.00'),
(41, 'CG', 'Congo', 178, 'COG', '0.00'),
(42, 'CH', 'Suiza', 756, 'CHE', '0.00'),
(43, 'CI', '<NAME>', 384, 'CIV', '0.00'),
(44, 'CK', '<NAME>', 184, 'COK', '0.00'),
(45, 'CL', 'Chile', 152, 'CHL', '0.00'),
(46, 'CM', 'Camerún', 120, 'CMR', '0.00'),
(47, 'CN', 'China', 156, 'CHN', '0.00'),
(48, 'CO', 'Colombia', 170, 'COL', '0.00'),
(49, 'CR', '<NAME>', 188, 'CRI', '0.00'),
(50, 'CU', 'Cuba', 192, 'CUB', '0.00'),
(51, 'CV', '<NAME>', 132, 'CPV', '0.00'),
(52, 'CX', '<NAME>', 162, 'CXR', '0.00'),
(53, 'CY', 'Chipre', 196, 'CYP', '0.00'),
(54, 'CZ', 'República Checa', 203, 'CZE', '0.00'),
(55, 'DE', 'Alemania', 276, 'DEU', '0.00'),
(56, 'DJ', 'Yibuti', 262, 'DJI', '0.00'),
(57, 'DK', 'Dinamarca', 208, 'DNK', '0.00'),
(58, 'DM', 'Dominica', 212, 'DMA', '0.00'),
(59, 'DO', 'República Dominicana', 214, 'DOM', '0.00'),
(60, 'DZ', 'Argelia', 12, 'DZA', '0.00'),
(61, 'EC', 'Ecuador', 218, 'ECU', '0.00'),
(62, 'EE', 'Estonia', 233, 'EST', '0.00'),
(63, 'EG', 'Egipto', 818, 'EGY', '0.00'),
(64, 'EH', 'Sahara Occidental', 732, 'ESH', '0.00'),
(65, 'ER', 'Eritrea', 232, 'ERI', '0.00'),
(66, 'ES', 'España', 724, 'ESP', '0.00'),
(67, 'ET', 'Etiopí­a', 231, 'ETH', '0.00'),
(68, 'FI', 'Finlandia', 246, 'FIN', '0.00'),
(69, 'FJ', 'Fiji', 242, 'FJI', '0.00'),
(70, 'FK', 'Islas Malvinas', 238, 'KLK', '0.00'),
(71, 'FM', 'Micronesia', 583, 'FSM', '0.00'),
(72, 'FO', '<NAME>', 234, 'FRO', '0.00'),
(73, 'FR', 'Francia', 250, 'FRA', '0.00'),
(74, 'GA', 'Gabón', 266, 'GAB', '0.00'),
(75, 'GB', 'Reino Unido', 826, 'GBR', '0.00'),
(76, 'GD', 'Granada', 308, 'GRD', '0.00'),
(77, 'GE', 'Georgia', 268, 'GEO', '0.00'),
(78, 'GF', '<NAME>', 254, 'GUF', '0.00'),
(79, 'GG', 'Guernsey', 831, 'GGY', '0.00'),
(80, 'GH', 'Ghana', 288, 'GHA', '0.00'),
(81, 'GI', 'Gibraltar', 292, 'GIB', '0.00'),
(82, 'GL', 'Groenlandia', 304, 'GRL', '0.00'),
(83, 'GM', 'Gambia', 270, 'GMB', '0.00'),
(84, 'GN', 'Guinea', 324, 'GIN', '0.00'),
(85, 'GP', 'Guadalupe', 312, 'GLP', '0.00'),
(86, 'GQ', 'Guinea Ecuatorial', 226, 'GNQ', '0.00'),
(87, 'GR', 'Grecia', 300, 'GRC', '0.00'),
(88, 'GS', 'Georgia del Sur', 239, 'SGS', '0.00'),
(89, 'GT', 'Guatemala', 320, 'GTM', '0.00'),
(90, 'GU', 'Guam', 316, 'GUM', '0.00'),
(91, 'GW', 'Guinea-Bissau', 624, 'GNB', '0.00'),
(92, 'GY', 'Guayana', 328, 'GUY', '0.00'),
(93, 'HK', 'Hong Kong', 344, 'HKG', '0.00'),
(94, 'HM', '<NAME>', 334, 'HMD', '0.00'),
(95, 'HN', 'Honduras', 340, 'HND', '0.00'),
(96, 'HR', 'Croacia', 191, 'HRV', '0.00'),
(97, 'HT', 'Haití', 332, 'HTI', '0.00'),
(98, 'HU', 'Hungrí­a', 348, 'HUN', '0.00'),
(99, 'ID', 'Indonesia', 360, 'IDN', '0.00'),
(100, 'IE', 'Irlanda', 372, 'IRL', '0.00'),
(101, 'IL', 'Israel', 376, 'ISR', '0.00'),
(102, 'IM', 'Is<NAME>', 833, 'IMN', '0.00'),
(103, 'IN', 'India', 356, 'IND', '0.00'),
(104, 'EN', 'Inglaterra', 0, 'ENG', '0.00'),
(105, 'IQ', 'Irak', 368, 'IRQ', '0.00'),
(106, 'IR', 'Irán', 364, 'IRN', '0.00'),
(107, 'IS', 'Islandia', 352, 'ISL', '0.00'),
(108, 'IT', 'Italia', 380, 'ITA', '0.00'),
(109, 'JE', 'Jersey', 832, 'JEY', '0.00'),
(110, 'JM', 'Jamaica', 388, 'JAM', '0.00'),
(111, 'JO', 'Jordania', 400, 'JOR', '0.00'),
(112, 'JP', 'Japón', 392, 'JPN', '0.00'),
(113, 'KE', 'Kenia', 404, 'KEN', '0.00'),
(114, 'KG', 'Kirguistán', 417, 'KGZ', '0.00'),
(115, 'KH', 'Camboya', 116, 'KHM', '0.00'),
(116, 'KI', 'Kiribati', 296, 'KIR', '0.00'),
(117, 'KM', 'Comoras', 174, 'COM', '0.00'),
(118, 'KN', 'San Cristóbal y Nieves', 659, 'KNA', '0.00'),
(119, 'KP', 'Corea del Norte', 408, 'PRK', '0.00'),
(120, 'KR', 'Corea del Sur', 410, 'KOR', '0.00'),
(121, 'KW', 'Kuwait', 414, 'KWT', '0.00'),
(122, 'KY', '<NAME>', 136, 'CYM', '0.00'),
(123, 'KZ', 'Kazajistán', 398, 'KAZ', '0.00'),
(124, 'LA', 'Laos', 418, 'LAO', '0.00'),
(125, 'LB', 'Lí­bano', 422, 'LBN', '0.00'),
(126, 'LC', '<NAME>', 662, 'LCA', '0.00'),
(127, 'LI', 'Liechtenstein', 438, 'LIE', '0.00'),
(128, 'LK', '<NAME>', 144, 'LKA', '0.00'),
(129, 'LR', 'Liberia', 430, 'LBR', '0.00'),
(130, 'LS', 'Lesotho', 426, 'LSO', '0.00'),
(131, 'LT', 'Lituania', 440, 'LTU', '0.00'),
(132, 'LU', 'Luxemburgo', 442, 'LUX', '0.00'),
(133, 'LV', 'Letonia', 428, 'LVA', '0.00'),
(134, 'LY', 'Libia', 434, 'LBY', '0.00'),
(135, 'MA', 'Marruecos', 504, 'MAR', '0.00'),
(136, 'MC', 'Mónaco', 492, 'MCO', '0.00'),
(137, 'MD', 'Moldova', 498, 'MDA', '0.00'),
(138, 'ME', 'Montenegro', 499, 'MNE', '0.00'),
(139, 'MG', 'Madagascar', 450, 'MDG', '0.00'),
(140, 'MH', '<NAME>', 584, 'MHL', '0.00'),
(141, 'MK', 'Macedonia', 807, 'MKD', '0.00'),
(142, 'ML', 'Mali', 466, 'MLI', '0.00'),
(143, 'MM', 'Myanmar', 104, 'MMR', '0.00'),
(144, 'MN', 'Mongolia', 496, 'MNG', '0.00'),
(145, 'MO', 'Macao', 446, 'MAC', '0.00'),
(146, 'MQ', 'Martinica', 474, 'MTQ', '0.00'),
(147, 'MR', 'Mauritania', 478, 'MRT', '0.00'),
(148, 'MS', 'Montserrat', 500, 'MSR', '0.00'),
(149, 'MT', 'Malta', 470, 'MLT', '0.00'),
(150, 'MU', 'Mauricio', 480, 'MUS', '0.00'),
(151, 'MV', 'Maldivas', 462, 'MDV', '0.00'),
(152, 'MW', 'Malawi', 454, 'MWI', '0.00'),
(153, 'MX', 'México', 484, 'MEX', '0.00'),
(154, 'MY', 'Malasia', 458, 'MYS', '0.00'),
(155, 'MZ', 'Mozambique', 508, 'MOZ', '0.00'),
(156, 'NA', 'Namibia', 516, 'NAM', '0.00'),
(157, 'NC', '<NAME>', 540, 'NCL', '0.00'),
(158, 'NE', 'Ní­ger', 562, 'NER', '0.00'),
(159, 'NF', '<NAME>', 574, 'NFK', '0.00'),
(160, 'NG', 'Nigeria', 566, 'NGA', '0.00'),
(161, 'NI', 'Nicaragua', 558, 'NIC', '0.00'),
(162, 'NL', 'Holanda', 528, 'NLD', '0.00'),
(163, 'NO', 'Noruega', 578, 'NOR', '0.00'),
(164, 'NP', 'Nepal', 524, 'NPL', '0.00'),
(165, 'NR', 'Nauru', 520, 'NRU', '0.00'),
(166, 'NU', 'Niue', 570, 'NIU', '0.00'),
(167, 'NZ', '<NAME>', 554, 'NZL', '0.00'),
(168, 'OM', 'Omán', 512, 'OMN', '0.00'),
(169, 'PA', 'Panamá', 591, 'PAN', '0.00'),
(170, 'PE', 'Perú', 604, 'PER', '0.00'),
(171, 'PF', 'Pol<NAME>', 258, 'PYF', '0.00'),
(172, 'PG', '<NAME>', 598, 'PNG', '0.00'),
(173, 'PH', 'Filipinas', 608, 'PHL', '0.00'),
(174, 'PK', 'Pakistán', 586, 'PAK', '0.00'),
(175, 'PL', 'Polonia', 616, 'POL', '0.00'),
(176, 'PM', '<NAME>', 666, 'SPM', '0.00'),
(177, 'PN', 'Is<NAME>', 612, 'PCN', '0.00'),
(178, 'PR', '<NAME>', 630, 'PRI', '0.00'),
(179, 'PS', 'Palestina', 275, 'PSE', '0.00'),
(180, 'PT', 'Portugal', 620, 'PRT', '0.00'),
(181, 'PW', '<NAME>', 585, 'PLW', '0.00'),
(182, 'PY', 'Paraguay', 600, 'PRY', '0.00'),
(183, 'QA', 'Qatar', 634, 'QAT', '0.00'),
(184, 'RE', 'Reunión', 638, 'REU', '0.00'),
(185, 'RO', 'Rumania', 642, 'ROU', '0.00'),
(186, 'RS', 'Serbia', 688, 'SRB', '0.00'),
(187, 'RU', 'Rusia', 643, 'RUS', '0.00'),
(188, 'RW', 'Ruanda', 646, 'RWA', '0.00'),
(189, 'SA', '<NAME>', 682, 'SAU', '0.00'),
(190, 'SB', '<NAME>', 90, 'SLB', '0.00'),
(191, 'SC', 'Seychelles', 690, 'SYC', '0.00'),
(192, 'SD', 'Sudán', 736, 'SDN', '0.00'),
(193, 'SE', 'Suecia', 752, 'SWE', '0.00'),
(194, 'SG', 'Singapur', 702, 'SGP', '0.00'),
(195, 'SH', 'Santa Elena', 654, 'SHN', '0.00'),
(196, 'SI', 'Eslovenia', 705, 'SVN', '0.00'),
(197, 'SJ', '<NAME> y <NAME>', 744, 'SJM', '0.00'),
(198, 'SK', 'Eslovaquia', 703, 'SVK', '0.00'),
(199, 'SL', 'Sierra Leona', 694, 'SLE', '0.00'),
(200, 'SM', 'San Marino', 674, 'SMR', '0.00'),
(201, 'SN', 'Senegal', 686, 'SEN', '0.00'),
(202, 'SO', 'Somalia', 706, 'SOM', '0.00'),
(203, 'SR', 'Surinam', 740, 'SUR', '0.00'),
(204, 'ST', 'Santo Tomé y Príncipe', 678, 'STP', '0.00'),
(205, 'SV', 'El Salvador', 222, 'SLV', '0.00'),
(206, 'SY', 'Siria', 760, 'SYR', '0.00'),
(207, 'SZ', 'Suazilandia', 748, 'SWZ', '0.00'),
(208, 'TC', 'Islas Turcas y Caicos', 796, 'TCA', '0.00'),
(209, 'TD', 'Chad', 148, 'TCD', '0.00'),
(210, 'TF', 'Territorios Australes Franceses', 260, 'ATF', '0.00'),
(211, 'TG', 'Togo', 768, 'TGO', '0.00'),
(212, 'TH', 'Tailandia', 764, 'THA', '0.00'),
(213, 'TZ', 'Tanzania', 834, 'TZA', '0.00'),
(214, 'TJ', 'Tayikistán', 762, 'TJK', '0.00'),
(215, 'TK', 'Tokelau', 772, 'TKL', '0.00'),
(216, 'TL', 'Timor-Leste', 626, 'TLS', '0.00'),
(217, 'TM', 'Turkmenistán', 795, 'TKM', '0.00'),
(218, 'TN', 'Túnez', 788, 'TUN', '0.00'),
(219, 'TO', 'Tonga', 776, 'TON', '0.00'),
(220, 'TR', 'Turquía', 792, 'TUR', '0.00'),
(221, 'TT', 'Trinidad y Tobago', 780, 'TTO', '0.00'),
(222, 'TV', 'Tuvalu', 798, 'TUV', '0.00'),
(223, 'TW', 'Taiwán', 158, 'TWN', '0.00'),
(224, 'UA', 'Ucrania', 804, 'UKR', '0.00'),
(225, 'UG', 'Uganda', 800, 'UGA', '0.00'),
(226, 'US', 'Estados Unidos', 840, 'USA', '0.00'),
(227, 'UY', 'Uruguay', 858, 'URY', '0.00'),
(228, 'UZ', 'Uzbekistán', 860, 'UZB', '0.00'),
(229, 'VA', 'Ciudad del Vaticano', 336, 'VAT', '0.00'),
(230, 'VC', 'San Vicente y las Granadinas', 670, 'VCT', '0.00'),
(231, 'VE', 'Venezuela', 862, 'VEN', '0.00'),
(232, 'VG', 'Islas Vírgenes Británicas', 92, 'VGB', '0.00'),
(233, 'VI', 'Islas Vírgenes de EE.UU', 850, 'VIR', '0.00'),
(234, 'VN', 'Vietnam', 704, 'VNM', '0.00'),
(235, 'VU', 'Vanuatu', 548, 'VUT', '0.00'),
(236, 'WF', 'Wallis y Futuna', 876, 'WLF', '0.00'),
(237, 'WS', 'Samoa', 882, 'WSM', '0.00'),
(238, 'YE', 'Yemen', 887, 'YEM', '0.00'),
(239, 'YT', 'Mayotte', 175, 'MYT', '0.00'),
(240, 'ZA', 'Sudáfrica', 710, 'ZAF', '0.00'),
(241, 'IN', 'Internacional', 1, 'INT', '0.00'),
(242, 'NA', 'Norteamérica', 1, 'NAM', '0.00'),
(243, 'SA', 'Sudamérica', 0, 'SAM', '0.00'),
(244, 'EU', 'Asia', 0, 'EUR', '0.00'),
(245, 'EU', 'Europa', 0, 'EUR', '0.00'),
(246, 'AF', 'África', 1, 'AFR', '0.00'),
(247, 'OC', 'Oceanía', 0, 'OCE', '0.00'),
(248, 'SC', 'Escocia', 1, 'SCO', '0.00'),
(249, 'gl', 'Galicia', 0, 'glc', '0.00'),
(250, 'ko', 'Kosovo', 0, 'kos', '0.00'),
(251, 'cn', 'Chipre del Norte', 0, 'chn', '0.00'),
(252, 'wa', 'Gales', 0, 'wal', '0.00'),
(253, 'in', 'Irlanda del Norte', 0, 'irn', '0.00');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=254;
COMMIT;