-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 16-12-2022 a las 09:38:48
-- Versión del servidor: 8.0.31-0ubuntu0.20.04.2
-- Versión de PHP: 7.4.3

START TRANSACTION;



--
-- Base de datos: `fix`
--

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

--
-- Estructura de tabla para la tabla `global_catalog_items`
--

CREATE TABLE `global_catalog_items` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'global_users',
  `value` int NOT NULL,
  `label` varchar(250) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `catalog_code` varchar(50) NOT NULL,
  `catalog_code_dep` varchar(50) NOT NULL,
  `catalog_id_dep` int NOT NULL,
  `description` varchar(512) NOT NULL,
  `svg_image` varchar(150) DEFAULT NULL,
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `global_catalog_items` (`id`, `users_sid`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'GENERAL MANAGEMENT', 'es', 'AREA', '0', 0, 'GENERAL MANAGEMENT', NULL, 'A', '2021-07-26 16:03:34', '2022-06-07 23:17:58'),
(101, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'CEO', 'es', 'CARGO', '0', 0, 'CEO', NULL, 'A', '2021-09-01 13:50:04', '2022-06-07 23:18:10'),
(329, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'CTO', 'es', 'CARGO', '0', 0, 'CTO', NULL, 'A', '2022-06-07 23:18:20', '2022-06-07 23:18:20'),
(330, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'CRO', 'es', 'CARGO', '0', 0, 'CRO', NULL, 'A', '2022-06-07 23:18:29', '2022-06-07 23:18:29'),
(331, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'CHRO', 'es', 'CARGO', '0', 0, 'CHRO', NULL, 'A', '2022-06-07 23:18:34', '2022-06-07 23:18:34');

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

--
-- Estructura de tabla para la tabla `global_cities`
--

CREATE TABLE `global_cities` (
  `id` mediumint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` mediumint UNSIGNED NOT NULL,
  `state_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` mediumint UNSIGNED NOT NULL,
  `country_code` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '2014-01-01 01:01:01',
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `flag` tinyint(1) NOT NULL DEFAULT '1',
  `wikiDataId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Rapid API GeoDB Cities'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

INSERT INTO `global_cities` (`id`, `name`, `state_id`, `state_code`, `country_id`, `country_code`, `latitude`, `longitude`, `created_at`, `updated_on`, `flag`, `wikiDataId`) VALUES
(9825, 'Abapó', 3377, 'S', 27, 'BO', '-18.88279000', '-63.38026000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q305531'),
(9826, 'Achacachi', 3380, 'L', 27, 'BO', '-16.05000000', '-68.68333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1553175'),
(9827, 'Aiquile', 3381, 'C', 27, 'BO', '-18.20408000', '-65.18068000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1617416'),
(9828, 'Amarete', 3380, 'L', 27, 'BO', '-15.23675000', '-68.98462000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q454982'),
(9829, 'Arani', 3381, 'C', 27, 'BO', '-17.56854000', '-65.76883000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1026281'),
(9830, 'Ascención de Guarayos', 3377, 'S', 27, 'BO', '-15.89299000', '-63.18855000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1026281'),
(9831, 'Ascensión', 3377, 'S', 27, 'BO', '-15.70000000', '-63.08333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1026281'),
(9832, 'Atocha', 3383, 'P', 27, 'BO', '-20.93515000', '-66.22139000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q637550'),
(9833, 'Batallas', 3380, 'L', 27, 'BO', '-16.30000000', '-68.53333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q810710'),
(9834, 'Bermejo', 3378, 'T', 27, 'BO', '-22.73206000', '-64.33724000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q634479'),
(9835, 'Betanzos', 3383, 'P', 27, 'BO', '-19.55293000', '-65.45395000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q634479'),
(9836, 'Bolivar', 3381, 'C', 27, 'BO', '-17.96667000', '-66.53333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q785395'),
(9837, 'Boyuibe', 3377, 'S', 27, 'BO', '-20.43227000', '-63.28147000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q896073'),
(9838, 'Buena Vista', 3377, 'S', 27, 'BO', '-17.45830000', '-63.67126000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1001758'),
(9839, 'Camargo', 3382, 'H', 27, 'BO', '-20.64064000', '-65.20893000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1642851'),
(9840, 'Camiri', 3377, 'S', 27, 'BO', '-20.03849000', '-63.51833000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1026256'),
(9841, 'Capinota', 3381, 'C', 27, 'BO', '-17.71113000', '-66.26082000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1034638'),
(9842, 'Caranavi', 3380, 'L', 27, 'BO', '-15.83652000', '-67.56901000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1034638'),
(9843, 'Challapata', 3376, 'O', 27, 'BO', '-18.90208000', '-66.77048000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q2307361'),
(9844, 'Charagua', 3377, 'S', 27, 'BO', '-19.79151000', '-63.19864000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q598031'),
(9845, 'Chimoré', 3381, 'C', 27, 'BO', '-16.99417000', '-65.15330000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q990746'),
(9846, 'Chulumani', 3380, 'L', 27, 'BO', '-16.40855000', '-67.52940000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1766619'),
(9847, 'Cliza', 3381, 'C', 27, 'BO', '-17.58777000', '-65.93253000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q780815'),
(9848, 'Cobija', 3379, 'N', 27, 'BO', '-11.02671000', '-68.76918000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q34995'),
(9849, 'Cochabamba', 3381, 'C', 27, 'BO', '-17.38950000', '-66.15680000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q34995'),
(9850, 'Colchani', 3381, 'C', 27, 'BO', '-17.31667000', '-66.71667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q34995'),
(9851, 'Colchani', 3383, 'P', 27, 'BO', '-20.30000000', '-66.93333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1107702'),
(9852, 'Colomi', 3381, 'C', 27, 'BO', '-17.35000000', '-65.86667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q990698'),
(9853, 'Colquechaca', 3383, 'P', 27, 'BO', '-18.70031000', '-66.00397000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q338235'),
(9854, 'Colquiri', 3380, 'L', 27, 'BO', '-17.38918000', '-67.12671000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1014448'),
(9855, 'Comarapa', 3377, 'S', 27, 'BO', '-17.91537000', '-64.53163000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1002560'),
(9856, 'Concepción', 3377, 'S', 27, 'BO', '-16.43333000', '-60.90000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1002560'),
(9857, 'Coripata', 3380, 'L', 27, 'BO', '-16.30000000', '-67.60000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1014537'),
(9858, 'Coroico', 3380, 'L', 27, 'BO', '-16.19386000', '-67.72998000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1026263'),
(9859, 'Cotoca', 3377, 'S', 27, 'BO', '-17.81667000', '-63.05000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1641337'),
(9860, 'Curahuara de Carangas', 3380, 'L', 27, 'BO', '-17.86667000', '-68.43333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q647877'),
(9861, 'Enrique Baldivieso', 3383, 'P', 27, 'BO', '-21.38323000', '-67.60368000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q647877'),
(9862, 'Entre Ríos', 3378, 'T', 27, 'BO', '-21.52661000', '-64.17299000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q328674'),
(9863, 'Eucaliptus', 3380, 'L', 27, 'BO', '-17.58333000', '-67.51667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1016533'),
(9864, 'German Busch', 3377, 'S', 27, 'BO', '-17.77317000', '-63.19087000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1016533'),
(9865, 'Guanay', 3380, 'L', 27, 'BO', '-15.49756000', '-67.88332000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q959746'),
(9866, 'Guarayos', 3377, 'S', 27, 'BO', '-15.82132000', '-63.24280000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q959746'),
(9867, 'Guayaramerín', 3375, 'B', 27, 'BO', '-10.82580000', '-65.35810000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1026253'),
(9868, 'Huanuni', 3376, 'O', 27, 'BO', '-18.28900000', '-66.83583000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1632857'),
(9869, 'Huarina', 3380, 'L', 27, 'BO', '-16.20000000', '-68.63333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1591297'),
(9870, 'Huatajata', 3380, 'L', 27, 'BO', '-16.20000000', '-68.68333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q21801004'),
(9871, 'Independencia', 3381, 'C', 27, 'BO', '-17.08389000', '-66.81804000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1661081'),
(9872, 'Irpa Irpa', 3381, 'C', 27, 'BO', '-17.71667000', '-66.26667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1673170'),
(9873, 'Jorochito', 3377, 'S', 27, 'BO', '-18.05514000', '-63.42821000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q976975'),
(9874, 'José Manuel Pando', 3380, 'L', 27, 'BO', '-16.18970000', '-67.72664000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q976975'),
(9875, 'La Bélgica', 3377, 'S', 27, 'BO', '-17.55000000', '-63.21667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1798658'),
(9876, 'La Paz', 3380, 'L', 27, 'BO', '-16.50000000', '-68.15000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1491'),
(9877, 'Lahuachaca', 3380, 'L', 27, 'BO', '-17.37054000', '-67.67501000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1800652'),
(9878, 'Limoncito', 3377, 'S', 27, 'BO', '-18.03104000', '-63.40523000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1804166'),
(9879, 'Litoral de Atacama', 3376, 'O', 27, 'BO', '-18.76071000', '-68.24295000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1804166'),
(9880, 'Llallagua', 3383, 'P', 27, 'BO', '-18.42426000', '-66.58388000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q283043'),
(9881, 'Los Negros', 3377, 'S', 27, 'BO', '-17.73333000', '-63.43333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q283043'),
(9882, 'Machacamarca', 3376, 'O', 27, 'BO', '-18.17251000', '-67.02099000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1312330'),
(9883, 'Mairana', 3377, 'S', 27, 'BO', '-18.11919000', '-63.95965000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1003511'),
(9884, 'Mapiri', 3380, 'L', 27, 'BO', '-15.25000000', '-68.16667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1014433'),
(9885, 'Mineros', 3377, 'S', 27, 'BO', '-17.11876000', '-63.23100000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1153550'),
(9886, 'Mizque', 3381, 'C', 27, 'BO', '-17.94101000', '-65.34016000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1896917'),
(9887, 'Monteagudo', 3382, 'H', 27, 'BO', '-19.79989000', '-63.95461000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1819486'),
(9888, 'Montero', 3377, 'S', 27, 'BO', '-17.33866000', '-63.25050000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q990706'),
(9889, 'Nor Carangas Province', 3376, 'O', 27, 'BO', '-17.83750000', '-67.94330000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q990706'),
(9890, 'Okinawa Número Uno', 3377, 'S', 27, 'BO', '-17.23333000', '-62.81667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1108266'),
(9891, 'Oruro', 3376, 'O', 27, 'BO', '-17.98333000', '-67.15000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q35246'),
(9892, 'Padilla', 3382, 'H', 27, 'BO', '-19.30878000', '-64.30273000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1584051'),
(9893, 'Pailón', 3377, 'S', 27, 'BO', '-17.65000000', '-62.75000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1725562'),
(9894, 'Patacamaya', 3380, 'L', 27, 'BO', '-17.23580000', '-67.92169000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q490991'),
(9895, 'Paurito', 3377, 'S', 27, 'BO', '-17.88333000', '-62.96667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1368696'),
(9896, 'Poopó', 3376, 'O', 27, 'BO', '-18.38026000', '-66.96695000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1368696'),
(9897, 'Portachuelo', 3377, 'S', 27, 'BO', '-17.35168000', '-63.39282000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1626079'),
(9898, 'Potosí', 3383, 'P', 27, 'BO', '-19.58361000', '-65.75306000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q35045'),
(9899, 'Provincia Abuná', 3379, 'N', 27, 'BO', '-10.50000000', '-66.50000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1471235'),
(9900, 'Provincia Alonzo de Ibáñez', 3383, 'P', 27, 'BO', '-18.50000000', '-66.33333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1360913'),
(9901, 'Provincia Andrés Ibáñez', 3377, 'S', 27, 'BO', '-17.75000000', '-63.25000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q582935'),
(9902, 'Provincia Arani', 3381, 'C', 27, 'BO', '-17.50000000', '-65.50000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1325748'),
(9903, 'Provincia Arce', 3378, 'T', 27, 'BO', '-22.16667000', '-64.33333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q679350'),
(9904, 'Provincia Aroma', 3380, 'L', 27, 'BO', '-17.50000000', '-68.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q490997'),
(9905, 'Provincia Arque', 3381, 'C', 27, 'BO', '-17.75000000', '-66.66667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1366072'),
(9906, 'Provincia Avaroa', 3376, 'O', 27, 'BO', '-19.00000000', '-66.66667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1366072'),
(9907, 'Provincia Avilez', 3378, 'T', 27, 'BO', '-21.66667000', '-65.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1366072'),
(9908, 'Provincia Ayopaya', 3381, 'C', 27, 'BO', '-16.50000000', '-66.58333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1365999'),
(9909, 'Provincia Azurduy', 3382, 'H', 27, 'BO', '-20.00000000', '-64.50000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1477938'),
(9910, 'Provincia Bautista Saavedra', 3380, 'L', 27, 'BO', '-15.00000000', '-68.91667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1166108'),
(9911, 'Provincia Belisario Boeto', 3382, 'H', 27, 'BO', '-18.91667000', '-64.33333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q638697'),
(9912, 'Provincia Camacho', 3380, 'L', 27, 'BO', '-15.50000000', '-69.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q638697'),
(9913, 'Provincia Campero', 3381, 'C', 27, 'BO', '-18.33333000', '-65.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q638697'),
(9914, 'Provincia Capinota', 3381, 'C', 27, 'BO', '-17.83333000', '-66.16667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1366004'),
(9915, 'Provincia Carangas', 3376, 'O', 27, 'BO', '-18.33333000', '-67.75000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1420332'),
(9916, 'Provincia Carrasco', 3381, 'C', 27, 'BO', '-17.50000000', '-65.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1366060'),
(9917, 'Provincia Cercado', 3376, 'O', 27, 'BO', '-17.91667000', '-67.08333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q590859'),
(9918, 'Provincia Cercado', 3381, 'C', 27, 'BO', '-17.33333000', '-66.16667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q200795'),
(9919, 'Provincia Cercado', 3378, 'T', 27, 'BO', '-21.58333000', '-64.58333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q328661'),
(9920, 'Provincia Cercado', 3375, 'B', 27, 'BO', '-14.50000000', '-64.33333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q328661'),
(9921, 'Provincia Chaparé', 3381, 'C', 27, 'BO', '-16.50000000', '-65.50000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1434538'),
(9922, 'Provincia Charcas', 3383, 'P', 27, 'BO', '-18.33333000', '-65.83333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q936944'),
(9923, 'Provincia Chayanta', 3383, 'P', 27, 'BO', '-18.91667000', '-66.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q733870'),
(9924, 'Provincia Chiquitos', 3377, 'S', 27, 'BO', '-18.00000000', '-60.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1147271'),
(9925, 'Provincia Cordillera', 3377, 'S', 27, 'BO', '-19.00000000', '-61.50000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q652371'),
(9926, 'Provincia Daniel Campos', 3383, 'P', 27, 'BO', '-20.25000000', '-68.25000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q938354'),
(9927, 'Provincia Esteban Arce', 3381, 'C', 27, 'BO', '-17.66667000', '-66.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q283889'),
(9928, 'Provincia Florida', 3377, 'S', 27, 'BO', '-18.00000000', '-63.91667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q818'),
(9929, 'Provincia Franz Tamayo', 3380, 'L', 27, 'BO', '-14.50000000', '-68.33333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1355903'),
(9930, 'Provincia General Bilbao', 3383, 'P', 27, 'BO', '-18.08333000', '-66.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1355903'),
(9931, 'Provincia General Federico Román', 3379, 'N', 27, 'BO', '-10.33333000', '-65.88333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1473313'),
(9932, 'Provincia General José Ballivián', 3375, 'B', 27, 'BO', '-14.00000000', '-67.08333000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1473313'),
(9933, 'Provincia Germán Jordán', 3381, 'C', 27, 'BO', '-17.58333000', '-65.91667000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q1295948'),
(9934, 'Provincia Gran Chaco', 3378, 'T', 27, 'BO', '-21.66667000', '-63.00000000', '2019-10-05 18:34:52', '2022-05-30 16:31:03', 1, 'Q267695'),
(9935, 'Provincia Gualberto Villarroel', 3380, 'L', 27, 'BO', '-17.58333000', '-68.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q267695'),
(9936, 'Provincia Hernando Siles', 3382, 'H', 27, 'BO', '-20.16667000', '-64.25000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q267695'),
(9937, 'Provincia Ichilo', 3377, 'S', 27, 'BO', '-17.00000000', '-64.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1215525'),
(9938, 'Provincia Ingavi', 3380, 'L', 27, 'BO', '-16.83333000', '-68.66667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1355971'),
(9939, 'Provincia Inquisivi', 3380, 'L', 27, 'BO', '-17.00000000', '-67.08333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1325725'),
(9940, 'Provincia Iturralde', 3380, 'L', 27, 'BO', '-13.00000000', '-68.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1325725'),
(9941, 'Provincia Iténez', 3375, 'B', 27, 'BO', '-13.41667000', '-63.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1325725'),
(9942, 'Provincia Ladislao Cabrera', 3376, 'O', 27, 'BO', '-19.50000000', '-67.66667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1420326'),
(9943, 'Provincia Larecaja', 3380, 'L', 27, 'BO', '-15.50000000', '-68.33333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1325760'),
(9944, 'Provincia Linares', 3383, 'P', 27, 'BO', '-19.83333000', '-65.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1325760'),
(9945, 'Provincia Loayza', 3380, 'L', 27, 'BO', '-17.00000000', '-67.66667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1424412'),
(9946, 'Provincia Los Andes', 3380, 'L', 27, 'BO', '-16.33333000', '-68.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1355950'),
(9947, 'Provincia Luis Calvo', 3382, 'H', 27, 'BO', '-20.66667000', '-63.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1355950'),
(9948, 'Provincia Madre de Dios', 3379, 'N', 27, 'BO', '-11.58333000', '-67.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q241217'),
(9949, 'Provincia Mamoré', 3375, 'B', 27, 'BO', '-13.00000000', '-64.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q241217'),
(9950, 'Provincia Manco Kapac', 3380, 'L', 27, 'BO', '-16.00000000', '-69.16667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1325738'),
(9951, 'Provincia Manuel María Caballero', 3377, 'S', 27, 'BO', '-17.83333000', '-64.41667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1215606'),
(9952, 'Provincia Manuripi', 3379, 'N', 27, 'BO', '-11.33333000', '-67.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1473356'),
(9953, 'Provincia Marbán', 3375, 'B', 27, 'BO', '-15.66667000', '-64.33333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1473356'),
(9954, 'Provincia Mizque', 3381, 'C', 27, 'BO', '-17.90655000', '-65.39440000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1427763'),
(9955, 'Provincia Modesto Omiste', 3383, 'P', 27, 'BO', '-21.91667000', '-65.58333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q120514'),
(9956, 'Provincia Moxos', 3375, 'B', 27, 'BO', '-15.16667000', '-65.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q120514'),
(9957, 'Provincia Murillo', 3380, 'L', 27, 'BO', '-16.33333000', '-68.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q120514'),
(9958, 'Provincia Muñecas', 3380, 'L', 27, 'BO', '-15.33333000', '-68.66667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1355881'),
(9959, 'Provincia Méndez', 3378, 'T', 27, 'BO', '-21.16667000', '-64.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1355881'),
(9960, 'Provincia Nicolás Suárez', 3379, 'N', 27, 'BO', '-11.33333000', '-68.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1473307'),
(9961, 'Provincia Nor Chichas', 3383, 'P', 27, 'BO', '-20.66667000', '-66.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1360821'),
(9962, 'Provincia Nor Cinti', 3382, 'H', 27, 'BO', '-20.33333000', '-65.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1420337'),
(9963, 'Provincia Nor Lípez', 3383, 'P', 27, 'BO', '-20.50000000', '-67.83333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1319477'),
(9964, 'Provincia Nor Yungas', 3380, 'L', 27, 'BO', '-16.00000000', '-67.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q389311'),
(9965, 'Provincia Omasuyos', 3380, 'L', 27, 'BO', '-15.91667000', '-68.83333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q951271'),
(9966, 'Provincia Oropeza', 3382, 'H', 27, 'BO', '-18.66667000', '-65.16667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q21799670'),
(9967, 'Provincia O’Connor', 3378, 'T', 27, 'BO', '-21.58333000', '-64.16667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q21799670'),
(9968, 'Provincia Pacajes', 3380, 'L', 27, 'BO', '-17.50000000', '-69.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1355941'),
(9969, 'Provincia Pantaleón Dalence', 3376, 'O', 27, 'BO', '-18.33333000', '-66.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1355941'),
(9970, 'Provincia Poopó', 3376, 'O', 27, 'BO', '-18.50000000', '-66.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1420274'),
(9971, 'Provincia Punata', 3381, 'C', 27, 'BO', '-17.50000000', '-65.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1420274'),
(9972, 'Provincia Quijarro', 3383, 'P', 27, 'BO', '-20.00000000', '-66.33333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1360766'),
(9973, 'Provincia Quillacollo', 3381, 'C', 27, 'BO', '-17.50000000', '-66.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1360766'),
(9974, 'Provincia Rafael Bustillo', 3383, 'P', 27, 'BO', '-18.33333000', '-66.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1360897'),
(9975, 'Provincia Saavedra', 3383, 'P', 27, 'BO', '-19.25000000', '-65.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q339416'),
(9976, 'Provincia Sabaya', 3376, 'O', 27, 'BO', '-19.00000000', '-68.58333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1425469'),
(9977, 'Provincia Sajama', 3376, 'O', 27, 'BO', '-18.20000000', '-68.55000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1427724'),
(9978, 'Provincia San Pedro de Totora', 3376, 'O', 27, 'BO', '-17.83333000', '-68.20000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1427704'),
(9979, 'Provincia Santiesteban', 3377, 'S', 27, 'BO', '-16.50000000', '-63.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1427704'),
(9980, 'Provincia Sara', 3377, 'S', 27, 'BO', '-16.83333000', '-63.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1215541'),
(9981, 'Provincia Saucari', 3376, 'O', 27, 'BO', '-18.25000000', '-67.41667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1427714'),
(9982, 'Provincia Sud Chichas', 3383, 'P', 27, 'BO', '-21.50000000', '-66.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1427714'),
(9983, 'Provincia Sud Cinti', 3382, 'H', 27, 'BO', '-20.91667000', '-64.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1427714'),
(9984, 'Provincia Sud Lípez', 3383, 'P', 27, 'BO', '-22.00000000', '-67.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q537564'),
(9985, 'Provincia Sud Yungas', 3380, 'L', 27, 'BO', '-16.50000000', '-67.50000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q609394'),
(9986, 'Provincia Tapacarí', 3381, 'C', 27, 'BO', '-17.51146000', '-66.61965000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q277886'),
(9987, 'Provincia Tomina', 3382, 'H', 27, 'BO', '-19.50000000', '-64.16667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q277886'),
(9988, 'Provincia Tomás Barron', 3376, 'O', 27, 'BO', '-17.83333000', '-68.25000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q658062'),
(9989, 'Provincia Tomás Frías', 3383, 'P', 27, 'BO', '-19.33333000', '-66.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1339683'),
(9990, 'Provincia Vaca Diez', 3375, 'B', 27, 'BO', '-11.66667000', '-66.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1339683'),
(9991, 'Provincia Vallegrande', 3377, 'S', 27, 'BO', '-18.50000000', '-64.16667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1215562'),
(9992, 'Provincia Velasco', 3377, 'S', 27, 'BO', '-15.50000000', '-61.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1215518'),
(9993, 'Provincia Warnes', 3377, 'S', 27, 'BO', '-17.33333000', '-63.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1215506'),
(9994, 'Provincia Yacuma', 3375, 'B', 27, 'BO', '-13.50000000', '-66.00000000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1215506'),
(9995, 'Provincia Yamparáez', 3382, 'H', 27, 'BO', '-19.16667000', '-64.91667000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1420314'),
(9996, 'Provincia Zudáñez', 3382, 'H', 27, 'BO', '-18.91667000', '-64.83333000', '2019-10-05 18:34:53', '2022-05-30 16:31:03', 1, 'Q1420314'),
(9997, 'Provincia Ángel Sandoval', 3377, 'S', 27, 'BO', '-17.50000000', '-58.50000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1215599'),
(9998, 'Provincia Ñuflo de Chávez', 3377, 'S', 27, 'BO', '-15.91667000', '-62.50000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1215592'),
(9999, 'Puerto Quijarro', 3377, 'S', 27, 'BO', '-17.78333000', '-57.76667000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2117434'),
(10000, 'Puerto de Mejillones', 3376, 'O', 27, 'BO', '-18.99266000', '-68.68446000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2117434'),
(10001, 'Puesto de Pailas', 3377, 'S', 27, 'BO', '-17.65000000', '-62.80000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1506112'),
(10002, 'Punata', 3381, 'C', 27, 'BO', '-17.54234000', '-65.83472000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1026219'),
(10003, 'Quillacollo', 3381, 'C', 27, 'BO', '-17.39228000', '-66.27838000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1002090'),
(10004, 'Quime', 3380, 'L', 27, 'BO', '-16.98333000', '-67.21667000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q590404'),
(10005, 'Reyes', 3375, 'B', 27, 'BO', '-14.29520000', '-67.33624000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q913102'),
(10006, 'Riberalta', 3375, 'B', 27, 'BO', '-11.00654000', '-66.06312000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q941357'),
(10007, 'Roboré', 3377, 'S', 27, 'BO', '-18.33473000', '-59.76142000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q941418'),
(10008, 'Rurrenabaque', 3375, 'B', 27, 'BO', '-14.44125000', '-67.52781000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q749372'),
(10009, 'Sacaba', 3381, 'C', 27, 'BO', '-17.39799000', '-66.03825000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q995727'),
(10010, 'Samaipata', 3377, 'S', 27, 'BO', '-18.18005000', '-63.87552000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1014461'),
(10011, 'San Borja', 3375, 'B', 27, 'BO', '-14.81667000', '-66.85000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2307472'),
(10012, 'San Carlos', 3377, 'S', 27, 'BO', '-17.40000000', '-63.75000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2307472'),
(10013, 'San Ignacio de Velasco', 3377, 'S', 27, 'BO', '-16.36667000', '-60.95000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q995752'),
(10014, 'San Juan del Surutú', 3377, 'S', 27, 'BO', '-17.48333000', '-63.70000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q995752'),
(10015, 'San Julian', 3377, 'S', 27, 'BO', '-17.78333000', '-62.86667000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q995752'),
(10016, 'San Matías', 3377, 'S', 27, 'BO', '-16.36667000', '-58.40000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q176823'),
(10017, 'San Pablo', 3380, 'L', 27, 'BO', '-16.21667000', '-68.83333000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2068055'),
(10018, 'San Pedro', 3377, 'S', 27, 'BO', '-18.28333000', '-59.81667000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2068055'),
(10019, 'San Pedro', 3380, 'L', 27, 'BO', '-16.23717000', '-68.85063000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1753041'),
(10020, 'San Ramón', 3375, 'B', 27, 'BO', '-13.28333000', '-64.71667000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q849354'),
(10021, 'Santa Ana de Yacuma', 3375, 'B', 27, 'BO', '-13.74406000', '-65.42688000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q849354'),
(10022, 'Santa Bárbara', 3383, 'P', 27, 'BO', '-20.91667000', '-66.05000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q258809'),
(10023, 'Santa Cruz de la Sierra', 3377, 'S', 27, 'BO', '-17.78629000', '-63.18117000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q170688'),
(10024, 'Santa Rita', 3377, 'S', 27, 'BO', '-17.96667000', '-63.35000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q170688'),
(10025, 'Santa Rosa', 3375, 'B', 27, 'BO', '-14.16667000', '-66.88333000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q170688'),
(10026, 'Santa Rosa del Sara', 3377, 'S', 27, 'BO', '-17.10916000', '-63.59514000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2223250'),
(10027, 'Santiago del Torno', 3377, 'S', 27, 'BO', '-17.98674000', '-63.38118000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q21794389'),
(10028, 'Sebastian Pagador Province', 3376, 'O', 27, 'BO', '-19.21667000', '-66.21667000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q21794389'),
(10029, 'Sipe Sipe', 3381, 'C', 27, 'BO', '-17.45000000', '-66.38333000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q990709'),
(10030, 'Sorata', 3380, 'L', 27, 'BO', '-15.77305000', '-68.64973000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1428069'),
(10031, 'Sucre', 3382, 'H', 27, 'BO', '-19.03332000', '-65.26274000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q2907'),
(10032, 'Sud Carangas Province', 3376, 'O', 27, 'BO', '-18.50000000', '-68.25000000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1360805'),
(10033, 'Tarabuco', 3382, 'H', 27, 'BO', '-19.18168000', '-64.91517000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1982115'),
(10034, 'Tarata', 3381, 'C', 27, 'BO', '-17.60898000', '-66.02135000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q1016289'),
(10035, 'Tarija', 3378, 'T', 27, 'BO', '-21.53549000', '-64.72956000', '2019-10-05 18:34:54', '2022-05-30 16:31:03', 1, 'Q35004'),
(10036, 'Tiahuanaco', 3380, 'L', 27, 'BO', '-16.55228000', '-68.67953000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q61750'),
(10037, 'Tiquipaya', 3381, 'C', 27, 'BO', '-17.33801000', '-66.21579000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q1020288'),
(10038, 'Tiraque Province', 3381, 'C', 27, 'BO', '-17.33333000', '-65.91667000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q979768'),
(10039, 'Totora', 3381, 'C', 27, 'BO', '-17.72662000', '-65.19320000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q2038566'),
(10040, 'Totoral', 3376, 'O', 27, 'BO', '-18.49587000', '-66.87380000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q2038566'),
(10041, 'Trinidad', 3375, 'B', 27, 'BO', '-14.83333000', '-64.90000000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q34986'),
(10042, 'Tupiza', 3383, 'P', 27, 'BO', '-21.44345000', '-65.71875000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q1014481'),
(10043, 'Urubichá', 3377, 'S', 27, 'BO', '-15.39286000', '-62.94661000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q1805205'),
(10044, 'Uyuni', 3383, 'P', 27, 'BO', '-20.45967000', '-66.82503000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q1014511'),
(10045, 'Vallegrande', 3377, 'S', 27, 'BO', '-18.48923000', '-64.10609000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q735765'),
(10046, 'Villa Yapacaní', 3377, 'S', 27, 'BO', '-17.40000000', '-63.83333000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q1506556'),
(10047, 'Villamontes', 3378, 'T', 27, 'BO', '-21.26235000', '-63.46903000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q1014504'),
(10048, 'Villazón', 3383, 'P', 27, 'BO', '-22.08659000', '-65.59422000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q431553'),
(10049, 'Viloco', 3380, 'L', 27, 'BO', '-16.95000000', '-67.55000000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q2526299'),
(10050, 'Warnes', 3377, 'S', 27, 'BO', '-17.51630000', '-63.16778000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q973385'),
(10051, 'Yacuiba', 3378, 'T', 27, 'BO', '-22.01643000', '-63.67753000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q990743'),
(10052, 'Yumani', 3380, 'L', 27, 'BO', '-16.03574000', '-69.14843000', '2019-10-05 18:34:55', '2022-05-30 16:31:03', 1, 'Q21801305');

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

--
-- Estructura de tabla para la tabla `global_configuration`
--

CREATE TABLE `global_configuration` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `enable_register` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `area_id` int DEFAULT NULL COMMENT 'Related to catalogs	= AREA',
  `cargo_id` int DEFAULT NULL COMMENT 'Related to catalogs	= CARGO',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `global_configuration` (`relative`, `users_sid`, `enable_register`, `area_id`, `cargo_id`, `status`, `created_at`, `updated_at`) VALUES
('d23c071d-4211-4ef4-8add-5e0fb695ec04', '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Y', 1, 2, 'A', '2022-06-08 22:45:27', '2022-06-08 22:45:27');

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

--
-- Estructura de tabla para la tabla `global_countries`
--

CREATE TABLE `global_countries` (
  `id` mediumint UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso3` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso2` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phonecode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `native` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emoji` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emojiU` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `flag` tinyint(1) NOT NULL DEFAULT '1',
  `wikiDataId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Rapid API GeoDB Cities'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `global_countries` (`id`, `name`, `iso3`, `iso2`, `phonecode`, `capital`, `currency`, `native`, `emoji`, `emojiU`, `created_at`, `updated_at`, `flag`, `wikiDataId`) VALUES
(1, 'Afghanistan', 'AFG', 'AF', '93', 'Kabul', 'AFN', 'افغانستان', '🇦🇫', 'U+1F1E6 U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q889'),
(2, 'Aland Islands', 'ALA', 'AX', '+358-18', 'Mariehamn', 'EUR', 'Åland', '🇦🇽', 'U+1F1E6 U+1F1FD', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(3, 'Albania', 'ALB', 'AL', '355', 'Tirana', 'ALL', 'Shqipëria', '🇦🇱', 'U+1F1E6 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q222'),
(4, 'Algeria', 'DZA', 'DZ', '213', 'Algiers', 'DZD', 'الجزائر', '🇩🇿', 'U+1F1E9 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q262'),
(5, 'American Samoa', 'ASM', 'AS', '+1-684', 'Pago Pago', 'USD', 'American Samoa', '🇦🇸', 'U+1F1E6 U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(6, 'Andorra', 'AND', 'AD', '376', 'Andorra la Vella', 'EUR', 'Andorra', '🇦🇩', 'U+1F1E6 U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q228'),
(7, 'Angola', 'AGO', 'AO', '244', 'Luanda', 'AOA', 'Angola', '🇦🇴', 'U+1F1E6 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q916'),
(8, 'Anguilla', 'AIA', 'AI', '+1-264', 'The Valley', 'XCD', 'Anguilla', '🇦🇮', 'U+1F1E6 U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(9, 'Antarctica', 'ATA', 'AQ', '', '', '', 'Antarctica', '🇦🇶', 'U+1F1E6 U+1F1F6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(10, 'Antigua And Barbuda', 'ATG', 'AG', '+1-268', 'St. John\'s', 'XCD', 'Antigua and Barbuda', '🇦🇬', 'U+1F1E6 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q781'),
(11, 'Argentina', 'ARG', 'AR', '54', 'Buenos Aires', 'ARS', 'Argentina', '🇦🇷', 'U+1F1E6 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q414'),
(12, 'Armenia', 'ARM', 'AM', '374', 'Yerevan', 'AMD', 'Հայաստան', '🇦🇲', 'U+1F1E6 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q399'),
(13, 'Aruba', 'ABW', 'AW', '297', 'Oranjestad', 'AWG', 'Aruba', '🇦🇼', 'U+1F1E6 U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(14, 'Australia', 'AUS', 'AU', '61', 'Canberra', 'AUD', 'Australia', '🇦🇺', 'U+1F1E6 U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q408'),
(15, 'Austria', 'AUT', 'AT', '43', 'Vienna', 'EUR', 'Österreich', '🇦🇹', 'U+1F1E6 U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q40'),
(16, 'Azerbaijan', 'AZE', 'AZ', '994', 'Baku', 'AZN', 'Azərbaycan', '🇦🇿', 'U+1F1E6 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q227'),
(17, 'Bahamas The', 'BHS', 'BS', '+1-242', 'Nassau', 'BSD', 'Bahamas', '🇧🇸', 'U+1F1E7 U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q778'),
(18, 'Bahrain', 'BHR', 'BH', '973', 'Manama', 'BHD', '‏البحرين', '🇧🇭', 'U+1F1E7 U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q398'),
(19, 'Bangladesh', 'BGD', 'BD', '880', 'Dhaka', 'BDT', 'Bangladesh', '🇧🇩', 'U+1F1E7 U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q902'),
(20, 'Barbados', 'BRB', 'BB', '+1-246', 'Bridgetown', 'BBD', 'Barbados', '🇧🇧', 'U+1F1E7 U+1F1E7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q244'),
(21, 'Belarus', 'BLR', 'BY', '375', 'Minsk', 'BYN', 'Белару́сь', '🇧🇾', 'U+1F1E7 U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q184'),
(22, 'Belgium', 'BEL', 'BE', '32', 'Brussels', 'EUR', 'België', '🇧🇪', 'U+1F1E7 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q31'),
(23, 'Belize', 'BLZ', 'BZ', '501', 'Belmopan', 'BZD', 'Belize', '🇧🇿', 'U+1F1E7 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q242'),
(24, 'Benin', 'BEN', 'BJ', '229', 'Porto-Novo', 'XOF', 'Bénin', '🇧🇯', 'U+1F1E7 U+1F1EF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q962'),
(25, 'Bermuda', 'BMU', 'BM', '+1-441', 'Hamilton', 'BMD', 'Bermuda', '🇧🇲', 'U+1F1E7 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(26, 'Bhutan', 'BTN', 'BT', '975', 'Thimphu', 'BTN', 'ʼbrug-yul', '🇧🇹', 'U+1F1E7 U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q917'),
(27, 'Bolivia', 'BOL', 'BO', '591', 'Sucre', 'BOB', 'Bolivia', '🇧🇴', 'U+1F1E7 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q750'),
(28, 'Bosnia and Herzegovina', 'BIH', 'BA', '387', 'Sarajevo', 'BAM', 'Bosna i Hercegovina', '🇧🇦', 'U+1F1E7 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q225'),
(29, 'Botswana', 'BWA', 'BW', '267', 'Gaborone', 'BWP', 'Botswana', '🇧🇼', 'U+1F1E7 U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q963'),
(30, 'Bouvet Island', 'BVT', 'BV', '', '', 'NOK', 'Bouvetøya', '🇧🇻', 'U+1F1E7 U+1F1FB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(31, 'Brazil', 'BRA', 'BR', '55', 'Brasilia', 'BRL', 'Brasil', '🇧🇷', 'U+1F1E7 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q155'),
(32, 'British Indian Ocean Territory', 'IOT', 'IO', '246', 'Diego Garcia', 'USD', 'British Indian Ocean Territory', '🇮🇴', 'U+1F1EE U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(33, 'Brunei', 'BRN', 'BN', '673', 'Bandar Seri Begawan', 'BND', 'Negara Brunei Darussalam', '🇧🇳', 'U+1F1E7 U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q921'),
(34, 'Bulgaria', 'BGR', 'BG', '359', 'Sofia', 'BGN', 'България', '🇧🇬', 'U+1F1E7 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q219'),
(35, 'Burkina Faso', 'BFA', 'BF', '226', 'Ouagadougou', 'XOF', 'Burkina Faso', '🇧🇫', 'U+1F1E7 U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q965'),
(36, 'Burundi', 'BDI', 'BI', '257', 'Bujumbura', 'BIF', 'Burundi', '🇧🇮', 'U+1F1E7 U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q967'),
(37, 'Cambodia', 'KHM', 'KH', '855', 'Phnom Penh', 'KHR', 'Kâmpŭchéa', '🇰🇭', 'U+1F1F0 U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q424'),
(38, 'Cameroon', 'CMR', 'CM', '237', 'Yaounde', 'XAF', 'Cameroon', '🇨🇲', 'U+1F1E8 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1009'),
(39, 'Canada', 'CAN', 'CA', '1', 'Ottawa', 'CAD', 'Canada', '🇨🇦', 'U+1F1E8 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q16'),
(40, 'Cape Verde', 'CPV', 'CV', '238', 'Praia', 'CVE', 'Cabo Verde', '🇨🇻', 'U+1F1E8 U+1F1FB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1011'),
(41, 'Cayman Islands', 'CYM', 'KY', '+1-345', 'George Town', 'KYD', 'Cayman Islands', '🇰🇾', 'U+1F1F0 U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(42, 'Central African Republic', 'CAF', 'CF', '236', 'Bangui', 'XAF', 'Ködörösêse tî Bêafrîka', '🇨🇫', 'U+1F1E8 U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q929'),
(43, 'Chad', 'TCD', 'TD', '235', 'N\'Djamena', 'XAF', 'Tchad', '🇹🇩', 'U+1F1F9 U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q657'),
(44, 'Chile', 'CHL', 'CL', '56', 'Santiago', 'CLP', 'Chile', '🇨🇱', 'U+1F1E8 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q298'),
(45, 'China', 'CHN', 'CN', '86', 'Beijing', 'CNY', '中国', '🇨🇳', 'U+1F1E8 U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q148'),
(46, 'Christmas Island', 'CXR', 'CX', '61', 'Flying Fish Cove', 'AUD', 'Christmas Island', '🇨🇽', 'U+1F1E8 U+1F1FD', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(47, 'Cocos (Keeling) Islands', 'CCK', 'CC', '61', 'West Island', 'AUD', 'Cocos (Keeling) Islands', '🇨🇨', 'U+1F1E8 U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(48, 'Colombia', 'COL', 'CO', '57', 'Bogota', 'COP', 'Colombia', '🇨🇴', 'U+1F1E8 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q739'),
(49, 'Comoros', 'COM', 'KM', '269', 'Moroni', 'KMF', 'Komori', '🇰🇲', 'U+1F1F0 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q970'),
(50, 'Congo', 'COG', 'CG', '242', 'Brazzaville', 'XAF', 'République du Congo', '🇨🇬', 'U+1F1E8 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q971'),
(51, 'Congo The Democratic Republic Of The', 'COD', 'CD', '243', 'Kinshasa', 'CDF', 'République démocratique du Congo', '🇨🇩', 'U+1F1E8 U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q974'),
(52, 'Cook Islands', 'COK', 'CK', '682', 'Avarua', 'NZD', 'Cook Islands', '🇨🇰', 'U+1F1E8 U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q26988'),
(53, 'Costa Rica', 'CRI', 'CR', '506', 'San Jose', 'CRC', 'Costa Rica', '🇨🇷', 'U+1F1E8 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q800'),
(54, 'Cote D\'Ivoire (Ivory Coast)', 'CIV', 'CI', '225', 'Yamoussoukro', 'XOF', NULL, '🇨🇮', 'U+1F1E8 U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1008'),
(55, 'Croatia (Hrvatska)', 'HRV', 'HR', '385', 'Zagreb', 'HRK', 'Hrvatska', '🇭🇷', 'U+1F1ED U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q224'),
(56, 'Cuba', 'CUB', 'CU', '53', 'Havana', 'CUP', 'Cuba', '🇨🇺', 'U+1F1E8 U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q241'),
(57, 'Cyprus', 'CYP', 'CY', '357', 'Nicosia', 'EUR', 'Κύπρος', '🇨🇾', 'U+1F1E8 U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q229'),
(58, 'Czech Republic', 'CZE', 'CZ', '420', 'Prague', 'CZK', 'Česká republika', '🇨🇿', 'U+1F1E8 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q213'),
(59, 'Denmark', 'DNK', 'DK', '45', 'Copenhagen', 'DKK', 'Danmark', '🇩🇰', 'U+1F1E9 U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q35'),
(60, 'Djibouti', 'DJI', 'DJ', '253', 'Djibouti', 'DJF', 'Djibouti', '🇩🇯', 'U+1F1E9 U+1F1EF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q977'),
(61, 'Dominica', 'DMA', 'DM', '+1-767', 'Roseau', 'XCD', 'Dominica', '🇩🇲', 'U+1F1E9 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q784'),
(62, 'Dominican Republic', 'DOM', 'DO', '+1-809 and 1-829', 'Santo Domingo', 'DOP', 'República Dominicana', '🇩🇴', 'U+1F1E9 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q786'),
(63, 'East Timor', 'TLS', 'TL', '670', 'Dili', 'USD', 'Timor-Leste', '🇹🇱', 'U+1F1F9 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q574'),
(64, 'Ecuador', 'ECU', 'EC', '593', 'Quito', 'USD', 'Ecuador', '🇪🇨', 'U+1F1EA U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q736'),
(65, 'Egypt', 'EGY', 'EG', '20', 'Cairo', 'EGP', 'مصر‎', '🇪🇬', 'U+1F1EA U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q79'),
(66, 'El Salvador', 'SLV', 'SV', '503', 'San Salvador', 'USD', 'El Salvador', '🇸🇻', 'U+1F1F8 U+1F1FB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q792'),
(67, 'Equatorial Guinea', 'GNQ', 'GQ', '240', 'Malabo', 'XAF', 'Guinea Ecuatorial', '🇬🇶', 'U+1F1EC U+1F1F6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q983'),
(68, 'Eritrea', 'ERI', 'ER', '291', 'Asmara', 'ERN', 'ኤርትራ', '🇪🇷', 'U+1F1EA U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q986'),
(69, 'Estonia', 'EST', 'EE', '372', 'Tallinn', 'EUR', 'Eesti', '🇪🇪', 'U+1F1EA U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q191'),
(70, 'Ethiopia', 'ETH', 'ET', '251', 'Addis Ababa', 'ETB', 'ኢትዮጵያ', '🇪🇹', 'U+1F1EA U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q115'),
(71, 'Falkland Islands', 'FLK', 'FK', '500', 'Stanley', 'FKP', 'Falkland Islands', '🇫🇰', 'U+1F1EB U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(72, 'Faroe Islands', 'FRO', 'FO', '298', 'Torshavn', 'DKK', 'Føroyar', '🇫🇴', 'U+1F1EB U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(73, 'Fiji Islands', 'FJI', 'FJ', '679', 'Suva', 'FJD', 'Fiji', '🇫🇯', 'U+1F1EB U+1F1EF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q712'),
(74, 'Finland', 'FIN', 'FI', '358', 'Helsinki', 'EUR', 'Suomi', '🇫🇮', 'U+1F1EB U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q33'),
(75, 'France', 'FRA', 'FR', '33', 'Paris', 'EUR', 'France', '🇫🇷', 'U+1F1EB U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q142'),
(76, 'French Guiana', 'GUF', 'GF', '594', 'Cayenne', 'EUR', 'Guyane française', '🇬🇫', 'U+1F1EC U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(77, 'French Polynesia', 'PYF', 'PF', '689', 'Papeete', 'XPF', 'Polynésie française', '🇵🇫', 'U+1F1F5 U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(78, 'French Southern Territories', 'ATF', 'TF', '', 'Port-aux-Francais', 'EUR', 'Territoire des Terres australes et antarctiques fr', '🇹🇫', 'U+1F1F9 U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(79, 'Gabon', 'GAB', 'GA', '241', 'Libreville', 'XAF', 'Gabon', '🇬🇦', 'U+1F1EC U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1000'),
(80, 'Gambia The', 'GMB', 'GM', '220', 'Banjul', 'GMD', 'Gambia', '🇬🇲', 'U+1F1EC U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1005'),
(81, 'Georgia', 'GEO', 'GE', '995', 'Tbilisi', 'GEL', 'საქართველო', '🇬🇪', 'U+1F1EC U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q230'),
(82, 'Germany', 'DEU', 'DE', '49', 'Berlin', 'EUR', 'Deutschland', '🇩🇪', 'U+1F1E9 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q183'),
(83, 'Ghana', 'GHA', 'GH', '233', 'Accra', 'GHS', 'Ghana', '🇬🇭', 'U+1F1EC U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q117'),
(84, 'Gibraltar', 'GIB', 'GI', '350', 'Gibraltar', 'GIP', 'Gibraltar', '🇬🇮', 'U+1F1EC U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(85, 'Greece', 'GRC', 'GR', '30', 'Athens', 'EUR', 'Ελλάδα', '🇬🇷', 'U+1F1EC U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q41'),
(86, 'Greenland', 'GRL', 'GL', '299', 'Nuuk', 'DKK', 'Kalaallit Nunaat', '🇬🇱', 'U+1F1EC U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(87, 'Grenada', 'GRD', 'GD', '+1-473', 'St. George\'s', 'XCD', 'Grenada', '🇬🇩', 'U+1F1EC U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q769'),
(88, 'Guadeloupe', 'GLP', 'GP', '590', 'Basse-Terre', 'EUR', 'Guadeloupe', '🇬🇵', 'U+1F1EC U+1F1F5', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(89, 'Guam', 'GUM', 'GU', '+1-671', 'Hagatna', 'USD', 'Guam', '🇬🇺', 'U+1F1EC U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(90, 'Guatemala', 'GTM', 'GT', '502', 'Guatemala City', 'GTQ', 'Guatemala', '🇬🇹', 'U+1F1EC U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q774'),
(91, 'Guernsey and Alderney', 'GGY', 'GG', '+44-1481', 'St Peter Port', 'GBP', 'Guernsey', '🇬🇬', 'U+1F1EC U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(92, 'Guinea', 'GIN', 'GN', '224', 'Conakry', 'GNF', 'Guinée', '🇬🇳', 'U+1F1EC U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1006'),
(93, 'Guinea-Bissau', 'GNB', 'GW', '245', 'Bissau', 'XOF', 'Guiné-Bissau', '🇬🇼', 'U+1F1EC U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1007'),
(94, 'Guyana', 'GUY', 'GY', '592', 'Georgetown', 'GYD', 'Guyana', '🇬🇾', 'U+1F1EC U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q734'),
(95, 'Haiti', 'HTI', 'HT', '509', 'Port-au-Prince', 'HTG', 'Haïti', '🇭🇹', 'U+1F1ED U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q790'),
(96, 'Heard and McDonald Islands', 'HMD', 'HM', ' ', '', 'AUD', 'Heard Island and McDonald Islands', '🇭🇲', 'U+1F1ED U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(97, 'Honduras', 'HND', 'HN', '504', 'Tegucigalpa', 'HNL', 'Honduras', '🇭🇳', 'U+1F1ED U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q783'),
(98, 'Hong Kong S.A.R.', 'HKG', 'HK', '852', 'Hong Kong', 'HKD', '香港', '🇭🇰', 'U+1F1ED U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(99, 'Hungary', 'HUN', 'HU', '36', 'Budapest', 'HUF', 'Magyarország', '🇭🇺', 'U+1F1ED U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q28'),
(100, 'Iceland', 'ISL', 'IS', '354', 'Reykjavik', 'ISK', 'Ísland', '🇮🇸', 'U+1F1EE U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q189'),
(101, 'India', 'IND', 'IN', '91', 'New Delhi', 'INR', 'भारत', '🇮🇳', 'U+1F1EE U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q668'),
(102, 'Indonesia', 'IDN', 'ID', '62', 'Jakarta', 'IDR', 'Indonesia', '🇮🇩', 'U+1F1EE U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q252'),
(103, 'Iran', 'IRN', 'IR', '98', 'Tehran', 'IRR', 'ایران', '🇮🇷', 'U+1F1EE U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q794'),
(104, 'Iraq', 'IRQ', 'IQ', '964', 'Baghdad', 'IQD', 'العراق', '🇮🇶', 'U+1F1EE U+1F1F6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q796'),
(105, 'Ireland', 'IRL', 'IE', '353', 'Dublin', 'EUR', 'Éire', '🇮🇪', 'U+1F1EE U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q27'),
(106, 'Israel', 'ISR', 'IL', '972', 'Jerusalem', 'ILS', 'יִשְׂרָאֵל', '🇮🇱', 'U+1F1EE U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q801'),
(107, 'Italy', 'ITA', 'IT', '39', 'Rome', 'EUR', 'Italia', '🇮🇹', 'U+1F1EE U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q38'),
(108, 'Jamaica', 'JAM', 'JM', '+1-876', 'Kingston', 'JMD', 'Jamaica', '🇯🇲', 'U+1F1EF U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q766'),
(109, 'Japan', 'JPN', 'JP', '81', 'Tokyo', 'JPY', '日本', '🇯🇵', 'U+1F1EF U+1F1F5', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q17'),
(110, 'Jersey', 'JEY', 'JE', '+44-1534', 'Saint Helier', 'GBP', 'Jersey', '🇯🇪', 'U+1F1EF U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q785'),
(111, 'Jordan', 'JOR', 'JO', '962', 'Amman', 'JOD', 'الأردن', '🇯🇴', 'U+1F1EF U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q810'),
(112, 'Kazakhstan', 'KAZ', 'KZ', '7', 'Astana', 'KZT', 'Қазақстан', '🇰🇿', 'U+1F1F0 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q232'),
(113, 'Kenya', 'KEN', 'KE', '254', 'Nairobi', 'KES', 'Kenya', '🇰🇪', 'U+1F1F0 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q114'),
(114, 'Kiribati', 'KIR', 'KI', '686', 'Tarawa', 'AUD', 'Kiribati', '🇰🇮', 'U+1F1F0 U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q710'),
(115, 'Korea North', 'PRK', 'KP', '850', 'Pyongyang', 'KPW', '북한', '🇰🇵', 'U+1F1F0 U+1F1F5', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q423'),
(116, 'Korea South', 'KOR', 'KR', '82', 'Seoul', 'KRW', '대한민국', '🇰🇷', 'U+1F1F0 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q884'),
(117, 'Kuwait', 'KWT', 'KW', '965', 'Kuwait City', 'KWD', 'الكويت', '🇰🇼', 'U+1F1F0 U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q817'),
(118, 'Kyrgyzstan', 'KGZ', 'KG', '996', 'Bishkek', 'KGS', 'Кыргызстан', '🇰🇬', 'U+1F1F0 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q813'),
(119, 'Laos', 'LAO', 'LA', '856', 'Vientiane', 'LAK', 'ສປປລາວ', '🇱🇦', 'U+1F1F1 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q819'),
(120, 'Latvia', 'LVA', 'LV', '371', 'Riga', 'EUR', 'Latvija', '🇱🇻', 'U+1F1F1 U+1F1FB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q211'),
(121, 'Lebanon', 'LBN', 'LB', '961', 'Beirut', 'LBP', 'لبنان', '🇱🇧', 'U+1F1F1 U+1F1E7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q822'),
(122, 'Lesotho', 'LSO', 'LS', '266', 'Maseru', 'LSL', 'Lesotho', '🇱🇸', 'U+1F1F1 U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1013'),
(123, 'Liberia', 'LBR', 'LR', '231', 'Monrovia', 'LRD', 'Liberia', '🇱🇷', 'U+1F1F1 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1014'),
(124, 'Libya', 'LBY', 'LY', '218', 'Tripolis', 'LYD', '‏ليبيا', '🇱🇾', 'U+1F1F1 U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1016'),
(125, 'Liechtenstein', 'LIE', 'LI', '423', 'Vaduz', 'CHF', 'Liechtenstein', '🇱🇮', 'U+1F1F1 U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q347'),
(126, 'Lithuania', 'LTU', 'LT', '370', 'Vilnius', 'EUR', 'Lietuva', '🇱🇹', 'U+1F1F1 U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q37'),
(127, 'Luxembourg', 'LUX', 'LU', '352', 'Luxembourg', 'EUR', 'Luxembourg', '🇱🇺', 'U+1F1F1 U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q32'),
(128, 'Macau S.A.R.', 'MAC', 'MO', '853', 'Macao', 'MOP', '澳門', '🇲🇴', 'U+1F1F2 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(129, 'Macedonia', 'MKD', 'MK', '389', 'Skopje', 'MKD', 'Северна Македонија', '🇲🇰', 'U+1F1F2 U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q221'),
(130, 'Madagascar', 'MDG', 'MG', '261', 'Antananarivo', 'MGA', 'Madagasikara', '🇲🇬', 'U+1F1F2 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1019'),
(131, 'Malawi', 'MWI', 'MW', '265', 'Lilongwe', 'MWK', 'Malawi', '🇲🇼', 'U+1F1F2 U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1020'),
(132, 'Malaysia', 'MYS', 'MY', '60', 'Kuala Lumpur', 'MYR', 'Malaysia', '🇲🇾', 'U+1F1F2 U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q833'),
(133, 'Maldives', 'MDV', 'MV', '960', 'Male', 'MVR', 'Maldives', '🇲🇻', 'U+1F1F2 U+1F1FB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q826'),
(134, 'Mali', 'MLI', 'ML', '223', 'Bamako', 'XOF', 'Mali', '🇲🇱', 'U+1F1F2 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q912'),
(135, 'Malta', 'MLT', 'MT', '356', 'Valletta', 'EUR', 'Malta', '🇲🇹', 'U+1F1F2 U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q233'),
(136, 'Man (Isle of)', 'IMN', 'IM', '+44-1624', 'Douglas, Isle of Man', 'GBP', 'Isle of Man', '🇮🇲', 'U+1F1EE U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(137, 'Marshall Islands', 'MHL', 'MH', '692', 'Majuro', 'USD', 'M̧ajeļ', '🇲🇭', 'U+1F1F2 U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q709'),
(138, 'Martinique', 'MTQ', 'MQ', '596', 'Fort-de-France', 'EUR', 'Martinique', '🇲🇶', 'U+1F1F2 U+1F1F6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(139, 'Mauritania', 'MRT', 'MR', '222', 'Nouakchott', 'MRO', 'موريتانيا', '🇲🇷', 'U+1F1F2 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1025'),
(140, 'Mauritius', 'MUS', 'MU', '230', 'Port Louis', 'MUR', 'Maurice', '🇲🇺', 'U+1F1F2 U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1027'),
(141, 'Mayotte', 'MYT', 'YT', '262', 'Mamoudzou', 'EUR', 'Mayotte', '🇾🇹', 'U+1F1FE U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(142, 'Mexico', 'MEX', 'MX', '52', 'Mexico City', 'MXN', 'México', '🇲🇽', 'U+1F1F2 U+1F1FD', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q96'),
(143, 'Micronesia', 'FSM', 'FM', '691', 'Palikir', 'USD', 'Micronesia', '🇫🇲', 'U+1F1EB U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q702'),
(144, 'Moldova', 'MDA', 'MD', '373', 'Chisinau', 'MDL', 'Moldova', '🇲🇩', 'U+1F1F2 U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q217'),
(145, 'Monaco', 'MCO', 'MC', '377', 'Monaco', 'EUR', 'Monaco', '🇲🇨', 'U+1F1F2 U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(146, 'Mongolia', 'MNG', 'MN', '976', 'Ulan Bator', 'MNT', 'Монгол улс', '🇲🇳', 'U+1F1F2 U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q711'),
(147, 'Montenegro', 'MNE', 'ME', '382', 'Podgorica', 'EUR', 'Црна Гора', '🇲🇪', 'U+1F1F2 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q236'),
(148, 'Montserrat', 'MSR', 'MS', '+1-664', 'Plymouth', 'XCD', 'Montserrat', '🇲🇸', 'U+1F1F2 U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(149, 'Morocco', 'MAR', 'MA', '212', 'Rabat', 'MAD', 'المغرب', '🇲🇦', 'U+1F1F2 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1028'),
(150, 'Mozambique', 'MOZ', 'MZ', '258', 'Maputo', 'MZN', 'Moçambique', '🇲🇿', 'U+1F1F2 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1029'),
(151, 'Myanmar', 'MMR', 'MM', '95', 'Nay Pyi Taw', 'MMK', 'မြန်မာ', '🇲🇲', 'U+1F1F2 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q836'),
(152, 'Namibia', 'NAM', 'NA', '264', 'Windhoek', 'NAD', 'Namibia', '🇳🇦', 'U+1F1F3 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1030'),
(153, 'Nauru', 'NRU', 'NR', '674', 'Yaren', 'AUD', 'Nauru', '🇳🇷', 'U+1F1F3 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q697'),
(154, 'Nepal', 'NPL', 'NP', '977', 'Kathmandu', 'NPR', 'नपल', '🇳🇵', 'U+1F1F3 U+1F1F5', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q837'),
(155, 'Netherlands Antilles', 'ANT', 'AN', '', '', '', NULL, NULL, NULL, '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(156, 'Netherlands The', 'NLD', 'NL', '31', 'Amsterdam', 'EUR', 'Nederland', '🇳🇱', 'U+1F1F3 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q55'),
(157, 'New Caledonia', 'NCL', 'NC', '687', 'Noumea', 'XPF', 'Nouvelle-Calédonie', '🇳🇨', 'U+1F1F3 U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(158, 'New Zealand', 'NZL', 'NZ', '64', 'Wellington', 'NZD', 'New Zealand', '🇳🇿', 'U+1F1F3 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q664'),
(159, 'Nicaragua', 'NIC', 'NI', '505', 'Managua', 'NIO', 'Nicaragua', '🇳🇮', 'U+1F1F3 U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q811'),
(160, 'Niger', 'NER', 'NE', '227', 'Niamey', 'XOF', 'Niger', '🇳🇪', 'U+1F1F3 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1032'),
(161, 'Nigeria', 'NGA', 'NG', '234', 'Abuja', 'NGN', 'Nigeria', '🇳🇬', 'U+1F1F3 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1033'),
(162, 'Niue', 'NIU', 'NU', '683', 'Alofi', 'NZD', 'Niuē', '🇳🇺', 'U+1F1F3 U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q34020'),
(163, 'Norfolk Island', 'NFK', 'NF', '672', 'Kingston', 'AUD', 'Norfolk Island', '🇳🇫', 'U+1F1F3 U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(164, 'Northern Mariana Islands', 'MNP', 'MP', '+1-670', 'Saipan', 'USD', 'Northern Mariana Islands', '🇲🇵', 'U+1F1F2 U+1F1F5', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(165, 'Norway', 'NOR', 'NO', '47', 'Oslo', 'NOK', 'Norge', '🇳🇴', 'U+1F1F3 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q20'),
(166, 'Oman', 'OMN', 'OM', '968', 'Muscat', 'OMR', 'عمان', '🇴🇲', 'U+1F1F4 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q842'),
(167, 'Pakistan', 'PAK', 'PK', '92', 'Islamabad', 'PKR', 'Pakistan', '🇵🇰', 'U+1F1F5 U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q843'),
(168, 'Palau', 'PLW', 'PW', '680', 'Melekeok', 'USD', 'Palau', '🇵🇼', 'U+1F1F5 U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q695'),
(169, 'Palestinian Territory Occupied', 'PSE', 'PS', '970', 'East Jerusalem', 'ILS', 'فلسطين', '🇵🇸', 'U+1F1F5 U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(170, 'Panama', 'PAN', 'PA', '507', 'Panama City', 'PAB', 'Panamá', '🇵🇦', 'U+1F1F5 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q804'),
(171, 'Papua new Guinea', 'PNG', 'PG', '675', 'Port Moresby', 'PGK', 'Papua Niugini', '🇵🇬', 'U+1F1F5 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q691'),
(172, 'Paraguay', 'PRY', 'PY', '595', 'Asuncion', 'PYG', 'Paraguay', '🇵🇾', 'U+1F1F5 U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q733'),
(173, 'Peru', 'PER', 'PE', '51', 'Lima', 'PEN', 'Perú', '🇵🇪', 'U+1F1F5 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q419'),
(174, 'Philippines', 'PHL', 'PH', '63', 'Manila', 'PHP', 'Pilipinas', '🇵🇭', 'U+1F1F5 U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q928'),
(175, 'Pitcairn Island', 'PCN', 'PN', '870', 'Adamstown', 'NZD', 'Pitcairn Islands', '🇵🇳', 'U+1F1F5 U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(176, 'Poland', 'POL', 'PL', '48', 'Warsaw', 'PLN', 'Polska', '🇵🇱', 'U+1F1F5 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q36'),
(177, 'Portugal', 'PRT', 'PT', '351', 'Lisbon', 'EUR', 'Portugal', '🇵🇹', 'U+1F1F5 U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q45'),
(178, 'Puerto Rico', 'PRI', 'PR', '+1-787 and 1-939', 'San Juan', 'USD', 'Puerto Rico', '🇵🇷', 'U+1F1F5 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(179, 'Qatar', 'QAT', 'QA', '974', 'Doha', 'QAR', 'قطر', '🇶🇦', 'U+1F1F6 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q846'),
(180, 'Reunion', 'REU', 'RE', '262', 'Saint-Denis', 'EUR', 'La Réunion', '🇷🇪', 'U+1F1F7 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(181, 'Romania', 'ROU', 'RO', '40', 'Bucharest', 'RON', 'România', '🇷🇴', 'U+1F1F7 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q218'),
(182, 'Russia', 'RUS', 'RU', '7', 'Moscow', 'RUB', 'Россия', '🇷🇺', 'U+1F1F7 U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q159'),
(183, 'Rwanda', 'RWA', 'RW', '250', 'Kigali', 'RWF', 'Rwanda', '🇷🇼', 'U+1F1F7 U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1037'),
(184, 'Saint Helena', 'SHN', 'SH', '290', 'Jamestown', 'SHP', 'Saint Helena', '🇸🇭', 'U+1F1F8 U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(185, 'Saint Kitts And Nevis', 'KNA', 'KN', '+1-869', 'Basseterre', 'XCD', 'Saint Kitts and Nevis', '🇰🇳', 'U+1F1F0 U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q763'),
(186, 'Saint Lucia', 'LCA', 'LC', '+1-758', 'Castries', 'XCD', 'Saint Lucia', '🇱🇨', 'U+1F1F1 U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q760'),
(187, 'Saint Pierre and Miquelon', 'SPM', 'PM', '508', 'Saint-Pierre', 'EUR', 'Saint-Pierre-et-Miquelon', '🇵🇲', 'U+1F1F5 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(188, 'Saint Vincent And The Grenadines', 'VCT', 'VC', '+1-784', 'Kingstown', 'XCD', 'Saint Vincent and the Grenadines', '🇻🇨', 'U+1F1FB U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q757'),
(189, 'Saint-Barthelemy', 'BLM', 'BL', '590', 'Gustavia', 'EUR', 'Saint-Barthélemy', '🇧🇱', 'U+1F1E7 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(190, 'Saint-Martin (French part)', 'MAF', 'MF', '590', 'Marigot', 'EUR', 'Saint-Martin', '🇲🇫', 'U+1F1F2 U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(191, 'Samoa', 'WSM', 'WS', '685', 'Apia', 'WST', 'Samoa', '🇼🇸', 'U+1F1FC U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q683'),
(192, 'San Marino', 'SMR', 'SM', '378', 'San Marino', 'EUR', 'San Marino', '🇸🇲', 'U+1F1F8 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q238'),
(193, 'Sao Tome and Principe', 'STP', 'ST', '239', 'Sao Tome', 'STD', 'São Tomé e Príncipe', '🇸🇹', 'U+1F1F8 U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1039'),
(194, 'Saudi Arabia', 'SAU', 'SA', '966', 'Riyadh', 'SAR', 'العربية السعودية', '🇸🇦', 'U+1F1F8 U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q851'),
(195, 'Senegal', 'SEN', 'SN', '221', 'Dakar', 'XOF', 'Sénégal', '🇸🇳', 'U+1F1F8 U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1041'),
(196, 'Serbia', 'SRB', 'RS', '381', 'Belgrade', 'RSD', 'Србија', '🇷🇸', 'U+1F1F7 U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q403'),
(197, 'Seychelles', 'SYC', 'SC', '248', 'Victoria', 'SCR', 'Seychelles', '🇸🇨', 'U+1F1F8 U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1042'),
(198, 'Sierra Leone', 'SLE', 'SL', '232', 'Freetown', 'SLL', 'Sierra Leone', '🇸🇱', 'U+1F1F8 U+1F1F1', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1044'),
(199, 'Singapore', 'SGP', 'SG', '65', 'Singapur', 'SGD', 'Singapore', '🇸🇬', 'U+1F1F8 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q334'),
(200, 'Slovakia', 'SVK', 'SK', '421', 'Bratislava', 'EUR', 'Slovensko', '🇸🇰', 'U+1F1F8 U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q214'),
(201, 'Slovenia', 'SVN', 'SI', '386', 'Ljubljana', 'EUR', 'Slovenija', '🇸🇮', 'U+1F1F8 U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q215'),
(202, 'Solomon Islands', 'SLB', 'SB', '677', 'Honiara', 'SBD', 'Solomon Islands', '🇸🇧', 'U+1F1F8 U+1F1E7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q685'),
(203, 'Somalia', 'SOM', 'SO', '252', 'Mogadishu', 'SOS', 'Soomaaliya', '🇸🇴', 'U+1F1F8 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1045'),
(204, 'South Africa', 'ZAF', 'ZA', '27', 'Pretoria', 'ZAR', 'South Africa', '🇿🇦', 'U+1F1FF U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q258'),
(205, 'South Georgia', 'SGS', 'GS', '', 'Grytviken', 'GBP', 'South Georgia', '🇬🇸', 'U+1F1EC U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(206, 'South Sudan', 'SSD', 'SS', '211', 'Juba', 'SSP', 'South Sudan', '🇸🇸', 'U+1F1F8 U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q958'),
(207, 'Spain', 'ESP', 'ES', '34', 'Madrid', 'EUR', 'España', '🇪🇸', 'U+1F1EA U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q29'),
(208, 'Sri Lanka', 'LKA', 'LK', '94', 'Colombo', 'LKR', 'śrī laṃkāva', '🇱🇰', 'U+1F1F1 U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q854'),
(209, 'Sudan', 'SDN', 'SD', '249', 'Khartoum', 'SDG', 'السودان', '🇸🇩', 'U+1F1F8 U+1F1E9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1049'),
(210, 'Suriname', 'SUR', 'SR', '597', 'Paramaribo', 'SRD', 'Suriname', '🇸🇷', 'U+1F1F8 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q730'),
(211, 'Svalbard And Jan Mayen Islands', 'SJM', 'SJ', '47', 'Longyearbyen', 'NOK', 'Svalbard og Jan Mayen', '🇸🇯', 'U+1F1F8 U+1F1EF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(212, 'Swaziland', 'SWZ', 'SZ', '268', 'Mbabane', 'SZL', 'Swaziland', '🇸🇿', 'U+1F1F8 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1050'),
(213, 'Sweden', 'SWE', 'SE', '46', 'Stockholm', 'SEK', 'Sverige', '🇸🇪', 'U+1F1F8 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q34'),
(214, 'Switzerland', 'CHE', 'CH', '41', 'Berne', 'CHF', 'Schweiz', '🇨🇭', 'U+1F1E8 U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q39'),
(215, 'Syria', 'SYR', 'SY', '963', 'Damascus', 'SYP', 'سوريا', '🇸🇾', 'U+1F1F8 U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q858'),
(216, 'Taiwan', 'TWN', 'TW', '886', 'Taipei', 'TWD', '臺灣', '🇹🇼', 'U+1F1F9 U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q865'),
(217, 'Tajikistan', 'TJK', 'TJ', '992', 'Dushanbe', 'TJS', 'Тоҷикистон', '🇹🇯', 'U+1F1F9 U+1F1EF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q863'),
(218, 'Tanzania', 'TZA', 'TZ', '255', 'Dodoma', 'TZS', 'Tanzania', '🇹🇿', 'U+1F1F9 U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q924'),
(219, 'Thailand', 'THA', 'TH', '66', 'Bangkok', 'THB', 'ประเทศไทย', '🇹🇭', 'U+1F1F9 U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q869'),
(220, 'Togo', 'TGO', 'TG', '228', 'Lome', 'XOF', 'Togo', '🇹🇬', 'U+1F1F9 U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q945'),
(221, 'Tokelau', 'TKL', 'TK', '690', '', 'NZD', 'Tokelau', '🇹🇰', 'U+1F1F9 U+1F1F0', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(222, 'Tonga', 'TON', 'TO', '676', 'Nuku\'alofa', 'TOP', 'Tonga', '🇹🇴', 'U+1F1F9 U+1F1F4', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q678'),
(223, 'Trinidad And Tobago', 'TTO', 'TT', '+1-868', 'Port of Spain', 'TTD', 'Trinidad and Tobago', '🇹🇹', 'U+1F1F9 U+1F1F9', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q754'),
(224, 'Tunisia', 'TUN', 'TN', '216', 'Tunis', 'TND', 'تونس', '🇹🇳', 'U+1F1F9 U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q948'),
(225, 'Turkey', 'TUR', 'TR', '90', 'Ankara', 'TRY', 'Türkiye', '🇹🇷', 'U+1F1F9 U+1F1F7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q43'),
(226, 'Turkmenistan', 'TKM', 'TM', '993', 'Ashgabat', 'TMT', 'Türkmenistan', '🇹🇲', 'U+1F1F9 U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q874'),
(227, 'Turks And Caicos Islands', 'TCA', 'TC', '+1-649', 'Cockburn Town', 'USD', 'Turks and Caicos Islands', '🇹🇨', 'U+1F1F9 U+1F1E8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(228, 'Tuvalu', 'TUV', 'TV', '688', 'Funafuti', 'AUD', 'Tuvalu', '🇹🇻', 'U+1F1F9 U+1F1FB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q672'),
(229, 'Uganda', 'UGA', 'UG', '256', 'Kampala', 'UGX', 'Uganda', '🇺🇬', 'U+1F1FA U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q1036'),
(230, 'Ukraine', 'UKR', 'UA', '380', 'Kiev', 'UAH', 'Україна', '🇺🇦', 'U+1F1FA U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q212'),
(231, 'United Arab Emirates', 'ARE', 'AE', '971', 'Abu Dhabi', 'AED', 'دولة الإمارات العربية المتحدة', '🇦🇪', 'U+1F1E6 U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q878'),
(232, 'United Kingdom', 'GBR', 'GB', '44', 'London', 'GBP', 'United Kingdom', '🇬🇧', 'U+1F1EC U+1F1E7', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q145'),
(233, 'United States', 'USA', 'US', '1', 'Washington', 'USD', 'United States', '🇺🇸', 'U+1F1FA U+1F1F8', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q30'),
(234, 'United States Minor Outlying Islands', 'UMI', 'UM', '1', '', 'USD', 'United States Minor Outlying Islands', '🇺🇲', 'U+1F1FA U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(235, 'Uruguay', 'URY', 'UY', '598', 'Montevideo', 'UYU', 'Uruguay', '🇺🇾', 'U+1F1FA U+1F1FE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q77'),
(236, 'Uzbekistan', 'UZB', 'UZ', '998', 'Tashkent', 'UZS', 'O‘zbekiston', '🇺🇿', 'U+1F1FA U+1F1FF', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q265'),
(237, 'Vanuatu', 'VUT', 'VU', '678', 'Port Vila', 'VUV', 'Vanuatu', '🇻🇺', 'U+1F1FB U+1F1FA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q686'),
(238, 'Vatican City State (Holy See)', 'VAT', 'VA', '379', 'Vatican City', 'EUR', 'Vaticano', '🇻🇦', 'U+1F1FB U+1F1E6', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q237'),
(239, 'Venezuela', 'VEN', 'VE', '58', 'Caracas', 'VEF', 'Venezuela', '🇻🇪', 'U+1F1FB U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q717'),
(240, 'Vietnam', 'VNM', 'VN', '84', 'Hanoi', 'VND', 'Việt Nam', '🇻🇳', 'U+1F1FB U+1F1F3', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q881'),
(241, 'Virgin Islands (British)', 'VGB', 'VG', '+1-284', 'Road Town', 'USD', 'British Virgin Islands', '🇻🇬', 'U+1F1FB U+1F1EC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(242, 'Virgin Islands (US)', 'VIR', 'VI', '+1-340', 'Charlotte Amalie', 'USD', 'United States Virgin Islands', '🇻🇮', 'U+1F1FB U+1F1EE', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(243, 'Wallis And Futuna Islands', 'WLF', 'WF', '681', 'Mata Utu', 'XPF', 'Wallis et Futuna', '🇼🇫', 'U+1F1FC U+1F1EB', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(244, 'Western Sahara', 'ESH', 'EH', '212', 'El-Aaiun', 'MAD', 'الصحراء الغربية', '🇪🇭', 'U+1F1EA U+1F1ED', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, NULL),
(245, 'Yemen', 'YEM', 'YE', '967', 'Sanaa', 'YER', 'اليَمَن', '🇾🇪', 'U+1F1FE U+1F1EA', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q805'),
(246, 'Zambia', 'ZMB', 'ZM', '260', 'Lusaka', 'ZMW', 'Zambia', '🇿🇲', 'U+1F1FF U+1F1F2', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q953'),
(247, 'Zimbabwe', 'ZWE', 'ZW', '263', 'Harare', 'ZWL', 'Zimbabwe', '🇿🇼', 'U+1F1FF U+1F1FC', '2018-07-20 20:11:03', '2022-05-30 16:31:17', 1, 'Q954'),
(248, 'Kosovo', 'XKX', 'XK', '383', 'Pristina', 'EUR', 'Republika e Kosovës', '🇽🇰', 'U+1F1FD U+1F1F0', '2020-08-15 15:33:50', '2022-05-30 16:31:17', 1, 'Q1246');

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

--
-- Estructura de tabla para la tabla `global_currency`
--

CREATE TABLE `global_currency` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users sid',
  `currency` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `code` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `usd_dollar` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `countries_id` mediumint UNSIGNED NOT NULL COMMENT 'related to countries table',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `global_currency` (`id`, `users_sid`, `currency`, `code`, `usd_dollar`, `countries_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Dolar americano', '$USD', 'Y', 233, 'A', '2021-07-11 13:21:50', '2021-07-11 17:20:37'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Boliviano', '$BOB', 'N', 27, 'A', '2021-07-11 13:22:16', '2021-07-11 17:21:53');

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

--
-- Estructura de tabla para la tabla `global_exchange_rate`
--

CREATE TABLE `global_exchange_rate` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users sid',
  `exchange_date` date NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `exchange` decimal(10,5) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `global_exchange_rate` (`id`, `users_sid`, `exchange_date`, `currency_id`, `exchange`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2021-07-11', 1, '1.00000', 'A', '2021-07-11 13:24:22', '2021-07-11 17:24:04'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2021-07-11', 2, '6.96000', 'A', '2021-07-11 13:24:32', '2021-07-11 17:24:24');

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

--
-- Estructura de tabla para la tabla `global_holidays`
--

CREATE TABLE `global_holidays` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `holiday_date` date NOT NULL,
  `holiday_name` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `global_holidays` (`id`, `users_sid`, `holiday_date`, `holiday_name`, `status`, `created_at`, `updated_at`) VALUES
(13, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-01-01', 'Año Nuevo', 'A', '2022-04-21 02:14:47', '2022-04-21 02:14:47'),
(14, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-01-22', 'Día del Estado Plurinacional', 'A', '2022-04-21 02:15:02', '2022-04-21 02:15:02'),
(15, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-02-28', 'Carnaval', 'A', '2022-04-21 02:15:15', '2022-04-21 02:15:15'),
(16, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-03-01', 'Carnaval', 'A', '2022-04-21 02:15:21', '2022-04-21 02:15:21'),
(17, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-04-15', 'Viernes Santo', 'A', '2022-04-21 02:15:31', '2022-04-21 02:15:31'),
(18, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-05-01', 'Día del Trabajo', 'A', '2022-04-21 02:15:47', '2022-04-21 02:15:47'),
(19, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-06-16', 'Corpus Christi', 'A', '2022-04-21 02:16:05', '2022-04-21 02:16:05'),
(20, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-06-21', 'Año Nuevo Aymara', 'A', '2022-04-21 02:16:17', '2022-04-21 02:16:17'),
(21, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-08-06', 'Día de la Independencia', 'A', '2022-04-21 02:16:31', '2022-04-21 02:16:31'),
(22, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-11-02', 'Día de Todos los Difuntos', 'A', '2022-04-21 02:16:43', '2022-04-21 02:16:43'),
(23, '69abe0de-7812-41bd-9124-6a7238aee7d1', '2022-12-25', 'Navidad', 'A', '2022-04-21 02:16:54', '2022-04-21 02:16:54');

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

--
-- Estructura de tabla para la tabla `global_person`
--

CREATE TABLE `global_person` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `first_name` varchar(50) NOT NULL COMMENT 'The first and middle name',
  `last_name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Last name',
  `phone_number` varchar(200) DEFAULT NULL,
  `cargo_id` int NOT NULL COMMENT 'Related to catalogs',
  `area_id` int NOT NULL COMMENT 'Related to catalogs',
  `country_id` mediumint UNSIGNED DEFAULT NULL COMMENT 'Related to country table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `global_person` (`id`, `users_sid`, `first_name`, `last_name`, `phone_number`, `cargo_id`, `area_id`, `country_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jose', 'Aparicio', '76108443', 1, 1, 27, 'A', '2022-06-06 22:17:19', NULL);

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

--
-- Estructura de tabla para la tabla `global_rol`
--

CREATE TABLE `global_rol` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'related to users table',
  `rol_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `rol_description` tinytext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `global_rol` (`id`, `users_sid`, `rol_name`, `rol_description`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '*', 'General access', 'A', '2022-06-06 22:23:33', NULL);

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

--
-- Estructura de tabla para la tabla `global_rol_perm`
--

CREATE TABLE `global_rol_perm` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'related to users table',
  `global_rol_id` int NOT NULL COMMENT 'global rol',
  `module_uri` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `local_uri` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `global_rol_perm` (`id`, `users_sid`, `global_rol_id`, `module_uri`, `local_uri`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '*', 'global', 'A', '2022-06-07 21:02:06', NULL);

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

--
-- Estructura de tabla para la tabla `global_users_passwords`
--

CREATE TABLE `global_users_passwords` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users sid, not who register.',
  `users_id` varchar(50) NOT NULL COMMENT 'related to users table',
  `password` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `global_users_rol`
--

CREATE TABLE `global_users_rol` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'global_users',
  `global_rol_id` int NOT NULL COMMENT 'global_rol'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `global_users_rol` (`id`, `users_sid`, `global_rol_id`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1);

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

--
-- Estructura de tabla para la tabla `global_zones`
--

CREATE TABLE `global_zones` (
  `id` mediumint UNSIGNED NOT NULL,
  `cities_id` int NOT NULL COMMENT 'Related to global cities table',
  `zone_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `range_area` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Estructura de tabla para la tabla `up_appointment`
--

CREATE TABLE `up_appointment` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `customer_id` int NOT NULL COMMENT 'Related to customer table',
  `specialty_id` int NOT NULL COMMENT 'Related to catalogs = SPECIALITY',
  `work_description` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `appointment_day` date NOT NULL,
  `appointment_hour` time NOT NULL,
  `appointment_day_time_negotiable` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'Y',
  `payment_way_available` enum('Cash','QR','Bank transfer') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'Cash',
  `attachments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `stage` enum('U','D','C','E') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'U' COMMENT 'U=unattended, D=designed, C=Confirmed, E=Ended',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Estructura de tabla para la tabla `up_appointment_commission`
--

CREATE TABLE `up_appointment_commission` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `appointment_id` int NOT NULL COMMENT 'Related to appointment table',
  `commission_ammount` decimal(10,2) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `payment_received` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'Y',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Estructura de tabla para la tabla `up_appointment_feedback`
--

CREATE TABLE `up_appointment_feedback` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `appointment_id` int NOT NULL COMMENT 'Related to appointment table',
  `wsc` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N' COMMENT 'work satisfactorily completed',
  `comments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `request_again` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'Y' COMMENT 'Would you request this service again?',
  `times_visited` smallint NOT NULL DEFAULT '1' COMMENT 'how many times you was visited to complete the job',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Estructura de tabla para la tabla `up_appointment_progress`
--

CREATE TABLE `up_appointment_progress` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `appointment_id` int NOT NULL COMMENT 'Related to appointment table',
  `worker_id` int NOT NULL COMMENT 'Related to worker table',
  `rate` decimal(10,2) NOT NULL COMMENT 'The price of the work, estimated only',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `estimated_labor_time` time NOT NULL,
  `requeriments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Requirements to perform the work',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Estructura de tabla para la tabla `up_customer`
--

CREATE TABLE `up_customer` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `first_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The first and middle name',
  `last_name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Last name',
  `country_id` mediumint UNSIGNED DEFAULT NULL COMMENT 'Related to country table',
  `city_id` mediumint UNSIGNED NOT NULL COMMENT 'Related to cities table',
  `zone_id` mediumint UNSIGNED DEFAULT NULL COMMENT 'Related to global zones table',
  `phone_number` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Multiple phone numbers, separated by commas',
  `whatsapp` enum('Y','N') NOT NULL DEFAULT 'Y',
  `address` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'This should be filled before they could made an appointment',
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `birthday_date` date DEFAULT NULL,
  `location_lat` point DEFAULT NULL,
  `location_long` point DEFAULT NULL,
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `up_worker`
--

CREATE TABLE `up_worker` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `picture` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `fullname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `address` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `multiple_specialty_id` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to catalogs = SPECIALITY - Separated by commas',
  `main_specialty_id` int NOT NULL COMMENT 'Related to catalogs	= SPECIALITY',
  `country_id` mediumint UNSIGNED NOT NULL COMMENT 'Related to country table',
  `city_id` mediumint UNSIGNED NOT NULL COMMENT 'Related to city table',
  `zone_id` mediumint UNSIGNED DEFAULT NULL COMMENT 'Related to global zones table',
  `phone_number` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Multiple phone numbers, separated by commas',
  `whatsapp` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'Y',
  `specialty_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `gender` enum('M','F') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'M',
  `birthday_date` date DEFAULT NULL,
  `years_of_experience` smallint NOT NULL DEFAULT '0' COMMENT 'How many year of experience ',
  `attachments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Estructura de tabla para la tabla `up_worker_days_available`
--

CREATE TABLE `up_worker_days_available` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `worker_id` int NOT NULL COMMENT 'Related to worker table',
  `saturday_available` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'Y',
  `sunday_available` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `hollidays_available` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `hour_available_since` time NOT NULL,
  `hour_available_until` time NOT NULL,
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Estructura de tabla para la tabla `up_worker_rank`
--

CREATE TABLE `up_worker_rank` (
  `id` int NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `worker_id` int NOT NULL COMMENT 'Related to worker table',
  `rating` decimal(10,2) NOT NULL,
  `how_many_rates` int NOT NULL COMMENT 'Votes quantity',
  `rank_average` decimal(10,2) NOT NULL,
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `global_catalog_items`
--
ALTER TABLE `global_catalog_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `value` (`value`),
  ADD KEY `fk_users_sid_ci` (`users_sid`);

--
-- Indices de la tabla `global_cities`
--
ALTER TABLE `global_cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_test_ibfk_1` (`state_id`),
  ADD KEY `cities_test_ibfk_2` (`country_id`);

--
-- Indices de la tabla `global_configuration`
--
ALTER TABLE `global_configuration`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `global_configuration.relative` (`relative`);

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

--
-- Indices de la tabla `global_currency`
--
ALTER TABLE `global_currency`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_currency` (`users_sid`),
  ADD KEY `fk_countries_currency` (`countries_id`);

--
-- Indices de la tabla `global_exchange_rate`
--
ALTER TABLE `global_exchange_rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_exchange_rate` (`users_sid`),
  ADD KEY `fk_currency_id_exchange_rate` (`currency_id`);

--
-- Indices de la tabla `global_holidays`
--
ALTER TABLE `global_holidays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_holidays` (`users_sid`);

--
-- Indices de la tabla `global_person`
--
ALTER TABLE `global_person`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_person` (`users_sid`),
  ADD KEY `fk_cargo_id_person` (`cargo_id`),
  ADD KEY `fk_area_id_person` (`area_id`),
  ADD KEY `fk_country_id_person` (`country_id`);

--
-- Indices de la tabla `global_rol`
--
ALTER TABLE `global_rol`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_rol` (`users_sid`);

--
-- Indices de la tabla `global_rol_perm`
--
ALTER TABLE `global_rol_perm`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_rolperm` (`users_sid`),
  ADD KEY `fk_global_rol_id_rolperm` (`global_rol_id`);

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

--
-- Indices de la tabla `global_users_rol`
--
ALTER TABLE `global_users_rol`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_urol` (`users_sid`),
  ADD KEY `fk_rol_id_urol` (`global_rol_id`);

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

--
-- Indices de la tabla `up_appointment`
--
ALTER TABLE `up_appointment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_appointment` (`users_sid`),
  ADD KEY `fk_customer_id_appointment` (`customer_id`),
  ADD KEY `fk_specialty_id_appointment` (`specialty_id`);

--
-- Indices de la tabla `up_appointment_commission`
--
ALTER TABLE `up_appointment_commission`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_appointment_commission` (`users_sid`),
  ADD KEY `fk_appointment_id_appointment_commission` (`appointment_id`),
  ADD KEY `fk_currency_id_appointment_commission` (`currency_id`);

--
-- Indices de la tabla `up_appointment_feedback`
--
ALTER TABLE `up_appointment_feedback`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_appointment_feedback` (`users_sid`),
  ADD KEY `fk_appointment_id_appointment_feedback` (`appointment_id`);

--
-- Indices de la tabla `up_appointment_progress`
--
ALTER TABLE `up_appointment_progress`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_appointment_progress` (`users_sid`),
  ADD KEY `fk_appointment_id_appointment_progress` (`appointment_id`),
  ADD KEY `fk_worker_id_appointment_progress` (`worker_id`),
  ADD KEY `fk_currency_id_appointment_progress` (`currency_id`);

--
-- Indices de la tabla `up_customer`
--
ALTER TABLE `up_customer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_customer` (`users_sid`),
  ADD KEY `fk_countries_customer` (`country_id`),
  ADD KEY `fk_cities_id_customer` (`city_id`),
  ADD KEY `fk_zones_id_customer` (`zone_id`);

--
-- Indices de la tabla `up_worker`
--
ALTER TABLE `up_worker`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_worker` (`users_sid`),
  ADD KEY `fk_main_specialty_id_worker` (`main_specialty_id`),
  ADD KEY `fk_country_id_worker` (`country_id`),
  ADD KEY `fk_city_id_worker` (`city_id`),
  ADD KEY `fk_zone_id_worker` (`zone_id`);

--
-- Indices de la tabla `up_worker_days_available`
--
ALTER TABLE `up_worker_days_available`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_days_available` (`users_sid`),
  ADD KEY `fk_worker_id_days_available` (`worker_id`);

--
-- Indices de la tabla `up_worker_rank`
--
ALTER TABLE `up_worker_rank`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_rank` (`users_sid`),
  ADD KEY `fk_worker_id_rank` (`worker_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `global_catalog_items`
--
ALTER TABLE `global_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=332;

--
-- AUTO_INCREMENT de la tabla `global_cities`
--
ALTER TABLE `global_cities`
  MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=146133;

--
-- AUTO_INCREMENT de la tabla `global_countries`
--
ALTER TABLE `global_countries`
  MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=249;

--
-- AUTO_INCREMENT de la tabla `global_currency`
--
ALTER TABLE `global_currency`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `global_exchange_rate`
--
ALTER TABLE `global_exchange_rate`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `global_holidays`
--
ALTER TABLE `global_holidays`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT de la tabla `global_person`
--
ALTER TABLE `global_person`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `global_rol`
--
ALTER TABLE `global_rol`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `global_rol_perm`
--
ALTER TABLE `global_rol_perm`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `global_users_passwords`
--
ALTER TABLE `global_users_passwords`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `global_users_rol`
--
ALTER TABLE `global_users_rol`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `global_zones`
--
ALTER TABLE `global_zones`
  MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_appointment`
--
ALTER TABLE `up_appointment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_appointment_commission`
--
ALTER TABLE `up_appointment_commission`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_appointment_feedback`
--
ALTER TABLE `up_appointment_feedback`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_appointment_progress`
--
ALTER TABLE `up_appointment_progress`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_customer`
--
ALTER TABLE `up_customer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_worker`
--
ALTER TABLE `up_worker`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_worker_days_available`
--
ALTER TABLE `up_worker_days_available`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `up_worker_rank`
--
ALTER TABLE `up_worker_rank`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `global_catalog_items`
--
ALTER TABLE `global_catalog_items`
  ADD CONSTRAINT `fk_users_sid_ci` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `global_cities`
--
ALTER TABLE `global_cities`
  ADD CONSTRAINT `fk_countries_id_cities` FOREIGN KEY (`country_id`) REFERENCES `global_countries` (`id`);

--
-- Filtros para la tabla `global_currency`
--
ALTER TABLE `global_currency`
  ADD CONSTRAINT `fk_countries_currency` FOREIGN KEY (`countries_id`) REFERENCES `global_countries` (`id`),
  ADD CONSTRAINT `fk_users_sid_currency` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `global_exchange_rate`
--
ALTER TABLE `global_exchange_rate`
  ADD CONSTRAINT `fk_currency_id_exchange_rate` FOREIGN KEY (`currency_id`) REFERENCES `global_currency` (`id`),
  ADD CONSTRAINT `fk_users_sid_exchange_rate` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `global_holidays`
--
ALTER TABLE `global_holidays`
  ADD CONSTRAINT `fk_users_sid_holidays` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `global_person`
--
ALTER TABLE `global_person`
  ADD CONSTRAINT `fk_area_id_person` FOREIGN KEY (`area_id`) REFERENCES `global_catalog_items` (`value`),
  ADD CONSTRAINT `fk_cargo_id_person` FOREIGN KEY (`cargo_id`) REFERENCES `global_catalog_items` (`value`),
  ADD CONSTRAINT `fk_country_id_person` FOREIGN KEY (`country_id`) REFERENCES `global_countries` (`id`),
  ADD CONSTRAINT `fk_users_sid_person` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `global_rol`
--
ALTER TABLE `global_rol`
  ADD CONSTRAINT `fk_users_sid_rol` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `global_rol_perm`
--
ALTER TABLE `global_rol_perm`
  ADD CONSTRAINT `fk_global_rol_id_rolperm` FOREIGN KEY (`global_rol_id`) REFERENCES `global_rol` (`id`),
  ADD CONSTRAINT `fk_users_sid_rolperm` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `global_users_rol`
--
ALTER TABLE `global_users_rol`
  ADD CONSTRAINT `fk_rol_id_urol` FOREIGN KEY (`global_rol_id`) REFERENCES `global_rol` (`id`),
  ADD CONSTRAINT `fk_users_sid_urol` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `up_appointment`
--
ALTER TABLE `up_appointment`
  ADD CONSTRAINT `fk_customer_id_appointment` FOREIGN KEY (`customer_id`) REFERENCES `up_customer` (`id`),
  ADD CONSTRAINT `fk_specialty_id_appointment` FOREIGN KEY (`specialty_id`) REFERENCES `global_catalog_items` (`value`),
  ADD CONSTRAINT `fk_users_sid_appointment` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `up_appointment_commission`
--
ALTER TABLE `up_appointment_commission`
  ADD CONSTRAINT `fk_appointment_id_appointment_commission` FOREIGN KEY (`appointment_id`) REFERENCES `up_appointment` (`id`),
  ADD CONSTRAINT `fk_currency_id_appointment_commission` FOREIGN KEY (`currency_id`) REFERENCES `global_currency` (`id`),
  ADD CONSTRAINT `fk_users_sid_appointment_commission` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `up_appointment_feedback`
--
ALTER TABLE `up_appointment_feedback`
  ADD CONSTRAINT `fk_appointment_id_appointment_feedback` FOREIGN KEY (`appointment_id`) REFERENCES `up_appointment` (`id`),
  ADD CONSTRAINT `fk_users_sid_appointment_feedback` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`);

--
-- Filtros para la tabla `up_appointment_progress`
--
ALTER TABLE `up_appointment_progress`
  ADD CONSTRAINT `fk_appointment_id_appointment_progress` FOREIGN KEY (`appointment_id`) REFERENCES `up_appointment` (`id`),
  ADD CONSTRAINT `fk_currency_id_appointment_progress` FOREIGN KEY (`currency_id`) REFERENCES `global_currency` (`id`),
  ADD CONSTRAINT `fk_users_sid_appointment_progress` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`),
  ADD CONSTRAINT `fk_worker_id_appointment_progress` FOREIGN KEY (`worker_id`) REFERENCES `up_worker` (`id`);

--
-- Filtros para la tabla `up_customer`
--
ALTER TABLE `up_customer`
  ADD CONSTRAINT `fk_cities_id_customer` FOREIGN KEY (`city_id`) REFERENCES `global_cities` (`id`),
  ADD CONSTRAINT `fk_countries_customer` FOREIGN KEY (`country_id`) REFERENCES `global_countries` (`id`),
  ADD CONSTRAINT `fk_users_sid_customer` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`),
  ADD CONSTRAINT `fk_zones_id_customer` FOREIGN KEY (`zone_id`) REFERENCES `global_zones` (`id`);

--
-- Filtros para la tabla `up_worker`
--
ALTER TABLE `up_worker`
  ADD CONSTRAINT `fk_city_id_worker` FOREIGN KEY (`city_id`) REFERENCES `global_cities` (`id`),
  ADD CONSTRAINT `fk_country_id_worker` FOREIGN KEY (`country_id`) REFERENCES `global_countries` (`id`),
  ADD CONSTRAINT `fk_main_specialty_id_worker` FOREIGN KEY (`main_specialty_id`) REFERENCES `global_catalog_items` (`value`),
  ADD CONSTRAINT `fk_users_sid_worker` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`),
  ADD CONSTRAINT `fk_zone_id_worker` FOREIGN KEY (`zone_id`) REFERENCES `global_zones` (`id`);

--
-- Filtros para la tabla `up_worker_days_available`
--
ALTER TABLE `up_worker_days_available`
  ADD CONSTRAINT `fk_users_sid_days_available` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`),
  ADD CONSTRAINT `fk_worker_id_days_available` FOREIGN KEY (`worker_id`) REFERENCES `up_worker` (`id`);

--
-- Filtros para la tabla `up_worker_rank`
--
ALTER TABLE `up_worker_rank`
  ADD CONSTRAINT `fk_users_sid_rank` FOREIGN KEY (`users_sid`) REFERENCES `global_users` (`sid`),
  ADD CONSTRAINT `fk_worker_id_rank` FOREIGN KEY (`worker_id`) REFERENCES `up_worker` (`id`);
COMMIT;

