-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `core_warehouse`
--

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

--
-- Table structure for table `core_supplier_vendors`
--

CREATE TABLE `core_supplier_vendors` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `country_id` int NOT NULL COMMENT 'Related to country table',
  `code` varchar(100) DEFAULT NULL,
  `full_name` varchar(250) NOT NULL,
  `nit` varchar(50) NOT NULL DEFAULT '0',
  `email` varchar(100) DEFAULT NULL,
  `social_media` text,
  `phones` varchar(150) DEFAULT NULL,
  `address` varchar(512) DEFAULT NULL,
  `references` mediumtext,
  `photo` varchar(250) DEFAULT NULL COMMENT 'Photo from customer',
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb3 CONNECTION='mysql://root:Ma!9an1s@localhost:3306/core_supplier/supplier_vendors';

--
-- Dumping data for table `core_supplier_vendors`
--

INSERT INTO `core_supplier_vendors` (`relative`, `users_sid`, `global_branch_office_id`, `country_id`, `code`, `full_name`, `nit`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `status`, `created_at`, `updated_at`) VALUES
('2a3e7ce5-0ecb-478c-9df0-6f73f5898058', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'INGCO BOLIVIA', '2312360019', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2023-06-09 07:20:21', '2023-06-09 07:20:21'),
('52695997-eef8-45b0-b2d0-21ce78e11e0f', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 31, '0006', 'Proveedor Brasil', '9876541254', NULL, NULL, NULL, NULL, NULL, '1674951350-5542437-9719f239-3c8d-42e6-b777-bf336e8e637d.png', 'A', '2023-01-28 20:15:50', '2023-01-28 20:15:50'),
('56bc1547-6955-44a3-8891-11adc5963971', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'Amaszonas', '12312312312312', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2022-04-21 14:26:21', '2022-04-21 14:26:21'),
('5d03e5ca-9515-41ce-b799-e341e4b281fe', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'TRYDENT SERVICES', '4807414019', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2023-06-09 08:21:41', '2023-06-09 08:21:41'),
('8b1de46a-3e96-457b-b18d-dbfd51aebcd1', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, 'BOA-01', 'Boliviana de Aviacion (BOA)', '154422029', 'ventasweb@boa.bo', 'https://fb.com/boa', '2 2166500', 'Av. Camacho, La Paz', NULL, '1646314625-3196550-06787d19-416f-448d-840a-6792c525cfaf.png', 'A', '2022-03-03 09:37:05', '2022-03-03 09:37:05'),
('95d29aff-582e-4c21-87ae-34edbf7ff498', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'Proveedor boliviano', '0', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2022-03-15 10:10:52', '2022-03-15 10:10:52'),
('e76efee0-8ec6-482c-8e33-82c4d4933e5d', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, '00005', 'Nuevo proveedor', '541236987', 'nuevo@nuevo.com', NULL, '+59174215863', 'Sin direccion conocida', 'Sin referencias conocidas', '1674945344-9828063-6c048919-bb57-4326-9b58-c34093e24ffb.png', 'A', '2023-01-28 18:35:44', '2023-01-28 18:35:44');

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

--
-- Table structure for table `core_warehouse_catalog_items`
--

CREATE TABLE `core_warehouse_catalog_items` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'global_users',
  `global_branch_office_id` varchar(50) DEFAULT NULL COMMENT 'global_branch_office',
  `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=FEDERATED DEFAULT CHARSET=utf8mb3 CONNECTION='mysql://root:Ma!9an1s@localhost:3306/core/global_catalog_items';

--
-- Dumping data for table `core_warehouse_catalog_items`
--

INSERT INTO `core_warehouse_catalog_items` (`id`, `users_sid`, `global_branch_office_id`, `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', NULL, 1, 'DESPACHO DEL MINISTRO', 'es', 'AREA', '0', 0, 'Despacho del Ministro', NULL, 'A', '2021-07-26 16:03:34', '2021-07-26 16:03:34'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'UNIDAD DE COMUNICACIÓN SOCIAL - UCOS', 'es', 'AREA', '0', 0, 'Unidad de Comunicación Social - UCOS', NULL, 'A', '2021-07-26 16:03:45', '2021-07-26 16:03:45'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'UNIDAD DE AUDITORÍA INTERNA - UAI', 'es', 'AREA', '0', 0, 'Unidad de Auditoría Interna - UAI', NULL, 'A', '2021-07-26 16:03:52', '2021-07-26 16:03:52'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 4, 'UNIDAD DE TRANSPARENCIA Y LUCHA CONTRA LA CORRUPCIÓN - UTRA', 'es', 'AREA', '0', 0, 'Unidad de Transparencia y Lucha Contra la Corrupción - UTRA', NULL, 'A', '2021-07-26 16:04:01', '2021-07-26 16:04:01'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 5, 'DIRECCIÓN GENERAL DE CONTROL Y FISCALIZACIÓN - DGCF', 'es', 'AREA', '0', 0, 'Dirección General de Control y Fiscalización - DGCF', NULL, 'A', '2021-07-26 16:04:24', '2021-07-26 16:04:24'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 6, 'DIRECCIÓN GENERAL DE ASUNTOS JURÍDICOS - DGAJ', 'es', 'AREA', '0', 0, 'Dirección General de Asuntos Jurídicos - DGAJ', NULL, 'A', '2021-07-26 16:04:38', '2021-07-26 16:04:38'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 7, 'DIRECCIÓN GENERAL DE ASUNTOS ADMINISTRATIVOS - DGAA', 'es', 'AREA', '0', 0, 'Dirección General de Asuntos Administrativos - DGAA', NULL, 'A', '2021-07-26 16:04:47', '2021-07-26 16:04:47'),
(9, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8, 'VICEMINISTERIO DE PLANIFICACIÓN Y DESARROLLO ENERGÉTICO - VMPDE', 'es', 'AREA', '0', 0, 'Viceministerio de Planificación y Desarrollo Energético - VMPDE', NULL, 'A', '2021-07-26 16:05:26', '2021-07-26 16:05:26'),
(10, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 9, 'VICEMINISTERIO DE PLANIFICACIÓN Y DESARROLLO ENERGÉTICO - VMPDE', 'es', 'AREA', '0', 0, 'Viceministerio de Planificación y Desarrollo Energético - VMPDE', NULL, 'A', '2021-07-26 16:05:34', '2021-07-26 16:05:34'),
(11, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 10, 'VICEMINISTERIO DE PLANIFICACIÓN Y DESARROLLO ENERGÉTICO - VMPDE', 'es', 'AREA', '0', 0, 'Viceministerio de Planificación y Desarrollo Energético - VMPDE', NULL, 'A', '2021-07-26 16:05:39', '2021-07-26 16:05:39'),
(12, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 11, 'VICEMINISTERIO DE EXPLORACIÓN Y EXPLOTACIÓN DE HIDROCARBUROS - VMEEH', 'es', 'AREA', '0', 0, 'Viceministerio de Exploración y Explotación de Hidrocarburos - VMEEH', NULL, 'A', '2021-07-26 16:05:47', '2021-07-26 16:06:09'),
(13, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 12, 'VICEMINISTERIO DE INDUSTRIALIZACIÓN, COMERCIALIZACION, TRANSPORTE Y ALMACENAJE DE HIDROCARBUROS - VMICTAH', 'es', 'AREA', '0', 0, 'Viceministerio de Industrialización, Comercializacion, Transporte y Almacenaje de Hidrocarburos - VMICTAH', NULL, 'A', '2021-07-26 16:06:40', '2021-07-26 16:06:40'),
(14, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 13, 'VICEMINISTERIO DE ELECTRICIDAD Y ENERGÌAS ALTERNATIVAS VMEEA', 'es', 'AREA', '0', 0, 'Viceministerio de Electricidad y Energìas Alternativas VMEEA', NULL, 'A', '2021-07-26 16:06:52', '2021-07-26 16:06:52'),
(15, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 14, 'VICEM. DE ALTAS TECNOLOGIAS ENERGETICAS - VMATE', 'es', 'AREA', '0', 0, 'VICEM. DE ALTAS TECNOLOGIAS ENERGETICAS - VMATE', NULL, 'A', '2021-07-26 16:07:10', '2021-09-06 11:57:42'),
(73, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'REUNIONES, APOYO Y SEGUIMIENTO', 'es', 'CATEGORIA', '0', 0, 'Reuniones, apoyo y seguimiento', NULL, 'A', '2021-07-26 16:17:16', '2021-07-26 16:20:18'),
(74, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'ASISTENCIA TECNICA REMOTA', 'es', 'CATEGORIA', '0', 0, 'Asistencia técnica remota', NULL, 'A', '2021-07-26 16:17:39', '2021-07-26 16:17:39'),
(75, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'ASISTENCIA TECNICA INMEDIATA', 'es', 'CATEGORIA', '0', 0, 'Asistencia ténica inmediata', NULL, 'A', '2021-07-26 16:18:05', '2021-07-26 16:18:05'),
(76, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 4, 'MANTENIMIENTO PREVENTIVO CORRECTIVO', 'es', 'CATEGORIA', '0', 0, 'Mantenimiento preventivo correctivo', NULL, 'A', '2021-07-26 16:18:26', '2021-07-26 16:18:26'),
(77, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 5, 'OFIMATICA, IMPRESIONES, OTROS', 'es', 'CATEGORIA', '0', 0, 'Ofimática, impresiones y otros', NULL, 'A', '2021-07-26 16:18:55', '2021-07-26 16:18:55'),
(78, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 6, 'INTERNET, WIFI, CAMARAS DE SEGURIDAD', 'es', 'CATEGORIA', '0', 0, 'Internet, wifi, cámaras de seguridad', NULL, 'A', '2021-07-26 16:19:46', '2021-07-26 16:19:46'),
(79, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'PARAFERNALIA REQUERIDA PARA UNA REUNION EXITOSA', 'es', 'CATEGORIA', 'CATEGORIA', 1, 'Parafernalia requerida para una reunión exitosa', NULL, 'A', '2021-07-26 16:21:26', '2021-07-26 16:21:26'),
(80, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'SEGUIMIENTO A REUNION PRESENCIAL O VIRTUAL', 'es', 'CATEGORIA', 'CATEGORIA', 1, 'Seguimiento a reunión presencial o virtual', NULL, 'A', '2021-07-26 16:21:53', '2021-07-26 16:21:53'),
(81, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'APOYO LOGISTICO', 'es', 'CATEGORIA', 'CATEGORIA', 1, 'Apoyo logístico', NULL, 'A', '2021-07-26 16:22:04', '2021-07-26 16:22:04'),
(82, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'ASISTENCIA TECNICA TELEFONICA', 'es', 'CATEGORIA', 'CATEGORIA', 2, 'Asistencia técnica telefónica', NULL, 'A', '2021-07-26 16:22:44', '2021-07-26 16:22:44'),
(83, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'ASISTENCIA TECNICA POR INTERNET', 'es', 'CATEGORIA', 'CATEGORIA', 2, 'Asistencia técnica por internet', NULL, 'A', '2021-07-26 16:23:02', '2021-07-26 16:23:02'),
(84, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'ASISTENCIA TECNICA PRESENCIAL INMEDIATA', 'es', 'CATEGORIA', 'CATEGORIA', 3, 'Asistencia técnica presencial inmediata', NULL, 'A', '2021-07-26 16:23:28', '2021-07-26 16:23:28'),
(85, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'DIAGNOSTICO, MANTENIMIENTO PREVENTIVO CORRECTIVO', 'es', 'CATEGORIA', 'CATEGORIA', 4, 'Diagnóstico, mantenimiento preventivo correctivo', NULL, 'A', '2021-07-26 16:24:54', '2021-07-26 16:24:54'),
(86, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'REPARACION, REEMPLAZO O COMPRA DE EQUIPO', 'es', 'CATEGORIA', 'CATEGORIA', 4, 'Reparación, reemplazo o compra de equipo', NULL, 'A', '2021-07-26 16:25:53', '2021-07-26 16:25:53'),
(87, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'SOPORTE EN OFIMATICA (OFFICE, WINDOWS, OTROS PROGRAMAS)', 'es', 'CATEGORIA', 'CATEGORIA', 5, 'Soporte en ofimática', NULL, 'A', '2021-07-26 16:26:43', '2021-07-26 16:26:43'),
(88, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'IMPRESION DE DOCUMENTOS, CONFIGURACION DE IMPRESORAS O FAX', 'es', 'CATEGORIA', 'CATEGORIA', 5, 'Impresión de documentos', NULL, 'A', '2021-07-26 16:27:17', '2021-07-26 16:27:17'),
(89, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'SOPORTE PROGRAMAS DE PAGO DE TERCEROS', 'es', 'CATEGORIA', 'CATEGORIA', 5, 'Soporte programas de pago', NULL, 'A', '2021-07-26 16:27:45', '2021-07-26 16:27:45'),
(90, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'DIAGNOSTICO, CONEXION O RE-CONEXION DE INTERNET', 'es', 'CATEGORIA', 'CATEGORIA', 6, 'DIAGNOSTICO, CONEXION O RE-CONEXION DE INTERNET', NULL, 'A', '2021-07-26 16:29:01', '2021-07-26 16:29:01'),
(91, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'DIAGNOSTICO, CONEXION, RE-CONEXCION, REPARACION DE REDES WIFI', 'es', 'CATEGORIA', 'CATEGORIA', 6, 'DIAGNOSTICO, CONEXION, RE-CONEXCION, REPARACION DE REDES WIFI', NULL, 'A', '2021-07-26 16:29:30', '2021-07-26 16:29:30'),
(92, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'CONFIGURACION, MANTENIMIENTO, REPARACION O REEMPLAZO DE CAMARAS DE SEGURIDAD', 'es', 'CATEGORIA', 'CATEGORIA', 6, 'CONFIGURACION, MANTENIMIENTO, REPARACION O REEMPLAZO DE CAMARAS DE SEGURIDAD', NULL, 'A', '2021-07-26 16:29:55', '2021-07-26 16:29:55'),
(93, '7d85e609-c75e-404d-bf77-2169a6f2c1e6', NULL, 1, 'ALTA', 'es', 'PRIORIDAD', '0', 0, 'Alta - urgente', NULL, 'A', '2021-07-26 16:30:34', '2021-07-29 09:52:27'),
(94, '7d85e609-c75e-404d-bf77-2169a6f2c1e6', NULL, 2, 'BAJA', 'es', 'PRIORIDAD', '0', 0, 'Baja', NULL, 'A', '2021-07-26 16:31:33', '2021-07-29 09:52:33'),
(95, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'HORA(S)', 'es', 'UNIDAD DE TIEMPO', '0', 0, 'Hora(s)', NULL, 'A', '2021-07-26 16:31:55', '2021-07-26 16:31:55'),
(96, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'MINUTOS', 'es', 'UNIDAD DE TIEMPO', '0', 0, 'Minutos', NULL, 'A', '2021-07-26 16:32:04', '2021-07-26 16:32:04'),
(97, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'ABIERTO - TRABAJO EN CURSO', 'es', 'ESTADO DEL TICKET', '0', 0, 'Trabajo en curso', NULL, 'A', '2021-07-26 16:33:16', '2021-07-26 16:33:16'),
(98, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'ABIERTO - COTIZACION DE REPUESTOS', 'es', 'ESTADO DEL TICKET', '0', 0, 'Cotización de respuestos', NULL, 'A', '2021-07-26 16:34:18', '2021-07-26 16:34:18'),
(99, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'CERRADO - A LA ESPERA DE CONFORMIDAD', 'es', 'ESTADO DEL TICKET', '0', 0, 'CERRADO - A LA ESPERA DE CONFORMIDAD', NULL, 'A', '2021-07-26 16:35:09', '2021-07-26 16:35:09'),
(100, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'URGENTE', 'es', 'PRIORIDAD', '0', 0, 'Urgente', NULL, 'A', '2021-08-04 09:42:05', '2021-08-04 09:42:05'),
(101, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'Ministro ', 'es', 'CARGO', '0', 0, 'Ministro de Estado', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(102, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'Asesor ', 'es', 'CARGO', '0', 0, 'Jefe Unidad I - Asesor', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(103, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'Jefe de Gabinete ', 'es', 'CARGO', '0', 0, 'Jefe de Unidad II - Jefe de Gabinete', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(104, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 4, 'Jefe de la Unidad de Comunicación Social', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(105, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 5, 'Profesional de Imagen y Video', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(106, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 6, 'Profesional de Prensa y WEB', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(107, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 7, 'Técnico en Comunicación y Logistica', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(108, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8, 'Jefe de la Unidad de Auditoria Interna', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(109, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 9, 'Profesional Supervisor Auditor Interno ', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(110, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 10, 'Profesional Auditor Interno ', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(111, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 11, 'Profesional Auditor Interno ', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(112, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 12, 'Jefe de la Unidad de Transparencia y Lucha Contra la Corrupción', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(113, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 13, 'Profesional en Análisis Económico Financiero del MHE', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(114, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 14, 'Profesional Analista Jurídico de Transaparencia', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(115, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 15, 'Asistente de Transparencia', 'es', 'CARGO', '0', 0, 'Administrativo III - Ujier Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(116, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 16, 'Director General de Control y Fiscalización', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(117, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 17, 'Secretaria DGCF', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(118, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 18, 'Asistente de Control y Fiscalización', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(119, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 19, 'Jefe de la Unidad de Control y Fiscalización Energética', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(120, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 20, 'Profesional en Derecho Regulatorio de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(121, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 21, 'Profesional en Derecho Regulatorio de Energía', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(122, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 22, 'Profesional Analista Técnico de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(123, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 23, 'Profesional Analista Técnico de Energía', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(124, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 24, 'Director General de Asuntos Jurídicos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(125, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 25, 'Secretaria DGAJ', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(126, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 26, 'Ujier DGAJ', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(127, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 27, 'Jefe de la Unidad de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(128, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 28, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(129, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 29, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(130, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 30, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(131, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 31, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(132, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 32, 'Técnico de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(133, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 33, 'Jefe de Unidad de Gestión Jurídica    ', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(134, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 34, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(135, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 35, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(136, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 36, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(137, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 37, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(138, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 38, 'Técnico Procesalista', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(139, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 39, 'Procurador Abogado', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(140, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 40, 'Director General de Asuntos Administrativos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(141, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 41, 'Secretaria DGAA', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(142, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 42, 'Ujier DGAA', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(143, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 43, 'Asistente DGAA - (oficina Regional Santa Cruz)', 'es', 'CARGO', '0', 0, 'Administrativo IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(144, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 44, 'Técnico Ejecutivo de Despacho Ministro', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(145, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 45, 'Secretaria Despacho Ministro', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(146, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 46, 'Chofer Despacho Ministro', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(147, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 47, 'Ujier Despacho Ministro', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(148, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 48, 'Asistente Administrativo Despacho - Santa Cruz', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(149, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 49, 'Asistente de Archivo Despacho', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(150, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 50, 'Encargado Atención Ventanilla Unica', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(151, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 51, 'Jefe de la Unidad Financiera', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(152, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 52, 'Profesional  Financiero', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(153, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 53, 'Contador General', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(154, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 54, 'Profesional de Tesorería', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(155, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 55, 'Encargado de Pasajes y Viáticos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(156, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 56, 'Profesional de Presupuestos', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(157, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 57, 'Técnico de Presupuestos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(158, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 58, 'Jefe de la Unidad de Recursos Humanos y Administrativos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(159, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 59, 'Profesional en Recursos Humanos y Normas', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(160, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 60, 'Habilitado de Planillas', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(161, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 61, 'Técnico en Recursos Humanos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(162, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 62, 'Telefonista', 'es', 'CARGO', '0', 0, 'Auxiliar I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(163, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 63, 'Portero Almacén TARIJA', 'es', 'CARGO', '0', 0, 'Auxiliar I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(164, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 64, 'Profesional de Contrataciones', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(165, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 65, 'Técnico en Compras y Contrataciones', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(166, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 66, 'Encargado de Archivo Central', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(167, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 67, 'Asistente de Archivo Central', 'es', 'CARGO', '0', 0, 'Administrativo IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(168, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 68, 'Encargado de Servicios Generales', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(169, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 69, 'Técnico de  Servicios Generales', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(170, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 70, 'Encargado de Activos Fijos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(171, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 71, 'Técnico de Activos Fijos', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(172, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 72, 'Encargado Almacén Central', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(173, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 73, 'Profesional de Tecnología de Información y Comunicación', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(174, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 74, 'Encargado de Soporte Técnico e Informático', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(175, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 75, 'Técnico Digitalizador', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(176, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 76, 'Técnico en Soporte y Sistemas Informáticos', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(177, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 77, 'Viceministro de Planificación y Desarrollo  Energético', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(178, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 78, 'Secretaria VMPDE', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(179, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 79, 'Chofer VMPDE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(180, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 80, 'Ujier VMPDE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(181, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 81, 'Director General de Gestión Socio Ambiental', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(182, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 82, 'Secretaria DGGSA', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(183, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 83, 'Ujier DGGSA', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(184, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 84, 'Jefe de la Unidad de Prevención y Control Socio Ambiental', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(185, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 85, 'Profesional en Prevención y Control Socio Ambiental UPSTREAM', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(186, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 86, 'Profesional en Prevención y Control Socio Ambiental DOWNSTREAM', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(187, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 87, 'Profesional en Prevención Socio Ambiental', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(188, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 88, 'Jefe de Unidad de Seguimiento y Control', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(189, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 89, 'Profesional de Pasivos Ambientales', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(190, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 90, 'Profesional en Seguimiento y Control Ambiental UPSTREAM', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(191, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 91, 'Profesional en Seguimiento y Control Ambiental DOWNSTREAM', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(192, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 92, 'Jefe de Unidad de Consulta y Participación', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(193, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 93, 'Profesional  en Gestión Socio Ambiental y Conflictos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(194, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 94, 'Profesional  Administrativo Financiero Socio Ambiental', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(195, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 95, 'Profesional en Consulta y Participación', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(196, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 96, 'Director General de Planifcación y Desarrollo Energético', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(197, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 97, 'Jefe de Unidad de Planificación y Desarrollo Energético', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(198, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 98, 'Responsable en Planificación Sectorial y Estratégica', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(199, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 99, 'Profesional en Planificación y Evaluación de Proyectos', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(200, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 100, 'Profesional en Planificación y Prospectiva Energética', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(201, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 101, 'Profesional en Planificación Operativa', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(202, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 102, 'Jefe de Unidad de Estadisticas e Información Energética', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(203, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 103, 'Profesional en Balance Energético', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(204, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 104, 'Profesional en Estadisticas e Información Energética', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(205, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 105, 'Viceministro de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(206, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 106, 'Secretaria VMEEH', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(207, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 107, 'Chofer VMEEH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(208, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 108, 'Ujier VMEEH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(209, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 109, 'Director General de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(210, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 110, 'Jefe Unidad de Normas y  Control Técnico en Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(211, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 111, 'Profesional  en Normativa de Exploración de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(212, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 112, 'Profesional en Análisis Económico de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(213, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 113, 'Profesional Legal en Normativa de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(214, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 114, 'Profesional  en Análisis Econométrico', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(215, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 115, 'Profesional  en Análisis Técnico Exploración y Explotación', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(216, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 116, 'Jefe de la Unidad de Control Técnico de Actividades de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(217, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 117, 'Profesional en Seguimiento a Reservas y Operaciones de Pozo y Planta', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(218, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 118, 'Profesional en Evaluación de Areas de Interés Hidrocarburifero y Reconocimiento Superficial', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(219, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 119, 'Profesional en Seguimiento a Inversiones y Costos de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(220, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 120, 'Profesional en Control Cartográfico de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(221, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 121, 'Profesional en Seguimiento a Actividades de Exploración y Explotacion de Hidrocarburos ', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(222, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 122, 'Director General de Producción, Recaudación e Incentivos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(223, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 123, 'Jefe de la Unidad de Producción, Recaudación e Incentivos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(224, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 124, 'Profesional en Ingresos por la Producción de Gas Natural', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(225, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 125, 'Profesional en Ingresos por la Producción de Hidrocarburos Líquidos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(226, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 126, 'Profesional en Análisis y Supervisión de Costos Generados por Incentivos ', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(227, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 127, 'Profesional  en Análisis y Control de Incentivos por Producción', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(228, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 128, 'Profesional en Control y Seguimiento de la Producción Fiscalizada', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(229, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 129, 'Profesional en Desarrollo y Administración de Información de Producción y Recaudaciones', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(230, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 130, 'Profesional  en Análisis y Supervisión de Costos Generados por Incentivos y Recaudaciones', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(231, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 131, 'Profesional para el Control de Recaudaciones Petroleras', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(232, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 132, 'Viceministro de Industrialización, Comercialización, Transporte y Almacenaje de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(233, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 133, 'Secretaria VMICTAH', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(234, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 134, 'Chofer VMICTAH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(235, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 135, 'Ujier VMICTAH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(236, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 136, 'Director General de Industrialización y Refinación', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(237, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 137, 'Profesional Economico de Industrialización y Refinación', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(238, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 138, 'Jefe de la Unidad de Industrialización', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(239, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 139, 'Profesional en Fertilizantes Nitrogenados', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(240, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 140, 'Jefe de la Unidad de Refinación', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(241, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 141, 'Profesional en Proyectos de Refinación', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(242, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 142, 'Profesional en Plantas de Separación de Licuables', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(243, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 143, 'Técnico en Procesos de Refinación    ', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(244, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 144, 'Director General de Comercialización, Transporte y Almacenaje', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(245, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 145, 'Jefe de la Unidad de Transporte, Almacenaje y Distribución de Gas', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(246, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 146, 'Profesional en Logistica de Hidrocarburos ', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(247, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 147, 'Profesional en Sistemas de Gas Natural', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(248, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 148, 'Profesional de Transporte por Ductos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(249, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 149, 'Jefe de la Unidad de Comercialización de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(250, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 150, 'Profesional  Económico en Determinación de Subsidio de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(251, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 151, 'Profesional Económico en Comercialización de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(252, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 152, 'Profesional en Comercialización de Combustibles Líquidos', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(253, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 153, 'Viceministro de Electricidad y Energías Alternativas', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(254, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 154, 'Secretaria VMEEA', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(255, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 155, 'Ujier VMEEA', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(256, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 156, 'Chofer VMEEA', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-10-22 09:11:59'),
(257, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 157, 'Director General de Electricidad', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(258, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 158, 'Profesional  en Evaluación y Seguimiento Técnico en Proyectos de Transmision e Interconexión', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(259, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 159, 'Profesional  en Mercados Energéticos  y Transacciones Internacionales', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(260, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 160, 'Profesional  en Evaluación y Seguimiento Técnico en Proyectos de Generación', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(261, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 161, 'Profesional  en Proyectos Hidroeléctricos (Construcción de Presas, Embalses, Tuneles y Obras Civiles)', 'es', 'CARGO', '0', 0, 'Responsable II - Profesional I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(262, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 162, 'Jefe Unidad de Evaluación y Normas', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(263, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 163, 'Profesional en Evaluación y Monitoreo', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(264, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 164, 'Profesional de la Normativa de Generación y Transporte', 'es', 'CARGO', '0', 0, 'Responsable II - Profesional I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(265, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 165, 'Director General de Energias Alternativas', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(266, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 166, 'Profesional  en Energías Alternativas', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(267, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 167, 'Profesional  en Seguimiento de Proyectos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(268, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 168, 'Profesional  en Eficiencia Energética', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(269, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 169, 'Profesional  en Energías Renovables no Convencionales', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(270, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 170, 'Profesional de Normas, Reglamentos Técnicos y Convenios para Energías Alternativas', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(271, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 171, 'Jefe Unidad Desarrollo de Infraestructura y Electrificación Rural', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(272, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 172, 'Profesional en Gestión de la Información Geográfica del Sector Eléctrico y Cobertura', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(273, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 173, 'Profesional  en Gestión de Financiamiento y Seguimiento Institucional', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(274, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 174, 'Profesional en Sistemas Aislados', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(275, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 175, 'VICEMINISTRO DE ALTAS TECNOLOGÍAS ENERGÉTICAS (LITIO, ENERGÍA NUCLEAR)', 'es', 'CARGO', '0', 0, 'VICEMINISTRO DE ALTAS TECNOLOGÍAS ENERGÉTICAS (LITIO, ENERGÍA NUCLEAR)', NULL, 'A', '2021-09-01 13:50:04', '2022-06-10 10:50:48'),
(276, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 176, 'Secretaria VMATE', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(277, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 177, 'Chofer VMATE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(278, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 178, 'Ujier VMATE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(279, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 179, 'UNIDAD FINANCIERA - UFIN', 'es', 'CARGO', '0', 0, 'Unidad financiera - UFIN', NULL, 'A', '2021-09-03 16:24:22', '2021-09-03 16:24:22'),
(280, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 15, 'UNIDAD FINANCIERA - UFIN', 'es', 'AREA', '0', 0, 'Unidad financiera - UFIN', NULL, 'A', '2021-09-03 16:25:27', '2021-09-03 16:25:27');
INSERT INTO `core_warehouse_catalog_items` (`id`, `users_sid`, `global_branch_office_id`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(281, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 16, 'UNIDAD DE RECURSOS HUMANOS Y ADMINISTRATIVOS - URHA', 'es', 'AREA', '0', 0, 'UNIDAD DE RECURSOS HUMANOS Y ADMINISTRATIVOS - URHA', NULL, 'A', '2021-09-03 16:34:54', '2021-09-03 16:34:54'),
(282, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 17, 'AREA DE COMPRAS Y CONTRATACIONES', 'es', 'AREA', '0', 0, 'AREA DE COMPRAS Y CONTRATACIONES', NULL, 'A', '2021-09-03 16:36:48', '2021-09-03 16:36:48'),
(283, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 18, 'ARCHIVO CENTRAL', 'es', 'AREA', '0', 0, 'ARCHIVO CENTRAL', NULL, 'A', '2021-09-03 16:37:49', '2021-09-03 16:37:49'),
(284, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 19, 'SERVICIOS GENERALES', 'es', 'AREA', '0', 0, 'SERVICIOS GENERALES', NULL, 'A', '2021-09-03 16:38:39', '2021-09-03 16:38:39'),
(285, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 20, 'ACTIVOS FIJOS', 'es', 'AREA', '0', 0, 'ACTIVOS FIJOS', NULL, 'A', '2021-09-03 16:39:31', '2021-09-03 16:39:31'),
(286, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 21, 'ARCHIVO CENTRAL', 'es', 'AREA', '0', 0, 'ARCHIVO CENTRAL', NULL, 'A', '2021-09-03 16:40:25', '2021-09-03 16:40:25'),
(287, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 22, 'AREA DE TECNOLOGIAS DE INFORMACION Y COMUNICACIÓN - ATIC', 'es', 'AREA', '0', 0, 'AREA DE TECNOLOGIAS DE INFORMACION Y COMUNICACIÓN - ATIC', NULL, 'A', '2021-09-03 16:41:23', '2021-09-03 16:41:23'),
(288, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 23, 'DIRECCIÓN GENERAL DE GESTIÓN SOCIO AMBIENTAL- DGGSA', 'es', 'AREA', '0', 0, 'DIRECCIÓN GENERAL DE GESTIÓN SOCIO AMBIENTAL- DGGSA', NULL, 'A', '2021-09-03 16:54:35', '2021-09-03 16:54:35'),
(289, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 24, 'UNIDAD DE PREVENCION Y CONTROL SOCIO AMBIENTAL- UPCSA', 'es', 'AREA', '0', 0, 'UNIDAD DE PREVENCION Y CONTROL SOCIO AMBIENTAL- UPCSA', NULL, 'A', '2021-09-03 16:57:20', '2021-09-03 16:57:20'),
(290, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 25, 'UNIDAD DE SEGUIMIENTO Y CONTROL - USC', 'es', 'AREA', '0', 0, 'UNIDAD DE SEGUIMIENTO Y CONTROL - USC', NULL, 'A', '2021-09-03 17:00:20', '2021-09-03 17:00:20'),
(291, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 26, 'UNIDAD DE CONSULTA Y PARTICIPACION - UCP', 'es', 'AREA', '0', 0, 'UNIDAD DE CONSULTA Y PARTICIPACION - UCP', NULL, 'A', '2021-09-06 11:26:23', '2021-09-06 11:26:23'),
(292, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 27, 'DIREC GRAL DE PLANIFICACIÓN Y DESARROLLO ENERGETICO - DGPDE', 'es', 'AREA', '0', 0, 'DIREC GRAL DE PLANIFICACIÓN Y DESARROLLO ENERGETICO - DGPDE', NULL, 'A', '2021-09-06 11:28:16', '2021-09-06 11:28:16'),
(293, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 28, 'UNIDAD DE PLANIFICACION Y DESARROLLO ENERGETICO - UPDE', 'es', 'AREA', '0', 0, 'UNIDAD DE PLANIFICACION Y DESARROLLO ENERGETICO - UPDE', NULL, 'A', '2021-09-06 11:28:32', '2021-09-06 11:28:32'),
(294, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 29, 'UNIDAD DE ESTADISTICAS E INFORMACION ENERGETICA - UEIE', 'es', 'AREA', '0', 0, 'UNIDAD DE ESTADISTICAS E INFORMACION ENERGETICA - UEIE', NULL, 'A', '2021-09-06 11:31:26', '2021-09-06 11:31:26'),
(295, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 30, 'DIREC GRAL DE CONTROL Y FISCAL. ENERGÉTICA- DGCFE', 'es', 'AREA', '0', 0, 'DIREC GRAL DE CONTROL Y FISCAL. ENERGÉTICA- DGCFE', NULL, 'A', '2021-09-06 11:31:50', '2021-09-06 11:31:50'),
(296, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 31, 'DIRECCIÓN GENERAL DE E&E DE HIDROCARBUROS - DGEEH', 'es', 'AREA', '0', 0, 'DIRECCIÓN GENERAL DE E&E DE HIDROCARBUROS - DGEEH', NULL, 'A', '2021-09-06 11:35:32', '2021-09-06 11:35:32'),
(297, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 32, 'UNIDAD DE POL. Y NOR. EN E&E DE HIDROC. - UPNEEH', 'es', 'AREA', '0', 0, 'UNIDAD DE POL. Y NOR. EN E&E DE HIDROC. - UPNEEH', NULL, 'A', '2021-09-06 11:35:50', '2021-09-06 11:35:50'),
(298, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 33, 'UNIDAD DE CON. TÉC. DE ACT. DE E&E HIDROC. - UNCTAEEH', 'es', 'AREA', '0', 0, 'UNIDAD DE CON. TÉC. DE ACT. DE E&E HIDROC. - UNCTAEEH', NULL, 'A', '2021-09-06 11:39:05', '2021-09-06 11:39:05'),
(299, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 34, 'DIREC. GRAL. DE PROD. RECAUDACION E INCENTIVOS - DGPRI', 'es', 'AREA', '0', 0, 'DIREC. GRAL. DE PROD. RECAUDACION E INCENTIVOS - DGPRI', NULL, 'A', '2021-09-06 11:39:22', '2021-09-06 11:39:22'),
(300, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 35, 'DIREC. GRAL. DE INDUSTRIALIZACIÓN Y REFINACIÓN - DGIR', 'es', 'AREA', '0', 0, 'DIREC. GRAL. DE INDUSTRIALIZACIÓN Y REFINACIÓN - DGIR', NULL, 'A', '2021-09-06 11:39:49', '2021-09-06 11:39:49'),
(301, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 36, 'UNIDAD DE  INDUSTRIALIZACIÓN - UIN', 'es', 'AREA', '0', 0, 'UNIDAD DE  INDUSTRIALIZACIÓN - UIN', NULL, 'A', '2021-09-06 11:40:00', '2021-09-06 11:40:00'),
(302, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 37, 'UNIDAD DE REFINACIÓN - URE', 'es', 'AREA', '0', 0, 'UNIDAD DE REFINACIÓN - URE', NULL, 'A', '2021-09-06 11:40:13', '2021-09-06 11:40:13'),
(303, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 38, 'DIREC GRAL. COMERCIALIZACION Y TRASPORTE Y ALMACENAJE - DGCTA', 'es', 'AREA', '0', 0, 'DIREC GRAL. COMERCIALIZACION Y TRASPORTE Y ALMACENAJE - DGCTA', NULL, 'A', '2021-09-06 11:40:29', '2021-09-06 11:40:29'),
(304, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 39, 'UNIDAD DE TRASP. ALMAC. Y DISTRIB. DE GAS - UTADG', 'es', 'AREA', '0', 0, 'UNIDAD DE TRASP. ALMAC. y DISTRIB. DE GAS - UTADG', NULL, 'A', '2021-09-06 11:40:42', '2021-09-06 11:40:42'),
(305, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 40, 'UNIDAD DE COMERCIALIZACION DE HIDROCARBUROS - UCOH', 'es', 'AREA', '0', 0, 'UNIDAD DE COMERCIALIZACION DE HIDROCARBUROS - UCOH', NULL, 'A', '2021-09-06 11:41:00', '2021-09-06 11:41:00'),
(306, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 41, 'UNIDAD DE PROD, RECAUDACION E INCENTIVOS - UPRI', 'es', 'AREA', '0', 0, 'UNIDAD DE PROD, RECAUDACION E INCENTIVOS - UPRI', NULL, 'A', '2021-09-06 11:46:19', '2021-09-06 11:46:19'),
(307, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 42, 'DIRECCION GENERAL DE ELECTRICIDAD - DGE', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE ELECTRICIDAD - DGE', NULL, 'A', '2021-09-06 11:56:40', '2021-09-06 11:56:40'),
(308, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 43, 'UNIDAD DE EVALUACION Y NORMAS - UEN', 'es', 'AREA', '0', 0, 'UNIDAD DE EVALUACION Y NORMAS - UEN', NULL, 'A', '2021-09-06 11:56:49', '2021-09-06 11:56:49'),
(309, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 44, 'DIRECCION GENERAL DE ENERGIAS ALTERNATIVAS - DGEA', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE ENERGIAS ALTERNATIVAS - DGEA', NULL, 'A', '2021-09-06 11:57:01', '2021-09-06 11:57:01'),
(310, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 45, 'UNIDAD DE DESARROLLO DE INFRAE. Y ELECTRIF. RURAL - UDIE', 'es', 'AREA', '0', 0, 'UNIDAD DE DESARROLLO DE INFRAE. Y ELECTRIF. RURAL - UDIE', NULL, 'A', '2021-09-06 11:57:13', '2021-09-06 11:57:13'),
(311, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 46, 'DIRECCION GENERAL DE LITIO - DGL', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE LITIO - DGL', NULL, 'A', '2021-09-06 11:57:58', '2021-09-06 11:57:58'),
(312, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 47, 'UNIDAD DE APLICACIONES Y NORMATIVAS DE LITIO - UANL', 'es', 'AREA', '0', 0, 'UNIDAD DE APLICACIONES Y NORMATIVAS DE LITIO - UANL', NULL, 'A', '2021-09-06 11:58:13', '2021-09-06 11:58:13'),
(313, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 48, 'DIRECCION GENERAL DE ENERGIA NUCLEAR - DGEN', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE ENERGIA NUCLEAR - DGEN', NULL, 'A', '2021-09-06 11:58:28', '2021-09-06 11:58:28'),
(314, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 49, 'UNIDAD DE APLICACIONES Y NORMATIVAS NUCLEAR - UANN', 'es', 'AREA', '0', 0, 'UNIDAD DE APLICACIONES Y NORMATIVAS NUCLEAR - UANN', NULL, 'A', '2021-09-06 11:58:43', '2021-09-06 11:58:43'),
(315, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 50, 'PROGRAMA PNUMA', 'es', 'AREA', '0', 0, 'PROGRAMA PNUMA', NULL, 'A', '2021-09-06 11:58:58', '2021-09-06 11:58:58'),
(316, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 51, 'PROGRAMA AFD', 'es', 'AREA', '0', 0, 'PROGRAMA AFD', NULL, 'A', '2021-09-06 11:59:10', '2021-09-06 11:59:10'),
(317, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 52, 'OFICINAS TARIJA', 'es', 'AREA', '0', 0, 'OFICINAS TARIJA', NULL, 'A', '2021-09-06 11:59:20', '2021-09-06 11:59:20'),
(318, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 53, 'OFICINAS SANTA CRUZ', 'es', 'AREA', '0', 0, 'OFICINAS SANTA CRUZ', NULL, 'A', '2021-09-06 11:59:30', '2021-09-06 11:59:30'),
(319, '937f7af1-55a1-4ecd-a439-364613c75833', NULL, 180, 'CONSULTOR', 'es', 'CARGO', '0', 0, 'CONSULTOR', NULL, 'A', '2021-11-04 10:21:45', '2021-11-04 10:21:45'),
(320, '937f7af1-55a1-4ecd-a439-364613c75833', NULL, 54, 'CONSULTORA', 'es', 'AREA', '0', 0, 'CONSULTORA', NULL, 'A', '2021-11-04 10:22:00', '2021-11-04 10:22:00'),
(321, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8001, 'Core user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:06:47', '2022-02-18 12:06:47'),
(322, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8002, 'HelpDesk user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:09:07', '2022-02-18 12:09:07'),
(323, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8003, 'Pyv user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:09:34', '2022-02-18 12:09:34'),
(324, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8004, 'Hotel user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:01', '2022-02-18 12:11:01'),
(325, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8010, 'Sivir user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:01', '2022-02-18 12:11:01'),
(326, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8011, 'Customer user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:02', '2022-02-18 12:11:02'),
(327, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8012, 'Supplier user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:02', '2022-02-18 12:11:02'),
(328, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8013, 'Employee user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:02', '2022-02-18 12:11:02'),
(329, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8014, 'GERENCIA', 'es', 'AREA', '0', 0, 'GERENCIA', NULL, 'A', '2023-05-02 09:08:27', '2023-05-02 09:08:27'),
(330, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 181, 'ENCARGADO DE LOGISTICA', 'es', 'CARGO', '0', 0, 'ENCARGADO DE LOGISTICA', NULL, 'A', '2023-05-02 09:08:42', '2023-05-02 09:08:42');

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

--
-- Table structure for table `core_warehouse_currency`
--

CREATE TABLE `core_warehouse_currency` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `currency` varchar(50) NOT NULL,
  `code` varchar(15) NOT NULL,
  `usd_dollar` enum('Y','N') NOT NULL DEFAULT 'N',
  `global_countries_id` int NOT NULL COMMENT 'global_countries',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb3 CONNECTION='mysql://root:Ma!9an1s@localhost:3306/core/global_currency';

--
-- Dumping data for table `core_warehouse_currency`
--

INSERT INTO `core_warehouse_currency` (`id`, `users_sid`, `currency`, `code`, `usd_dollar`, `global_countries_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Dolar', '$USD', 'Y', 233, 'A', '2021-07-11 13:21:50', '2022-12-15 03:21:46'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Bolivianos', 'Bs', 'N', 27, 'A', '2021-07-11 13:22:16', '2022-12-15 04:06:31'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Real', 'R$', 'N', 31, 'X', '2021-07-11 13:23:32', '2021-07-11 17:22:18'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Peso Chileno', '$CLP', 'N', 44, 'X', '2021-08-20 11:17:34', '2021-11-16 08:08:02'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'YUAN, RENMINBI', '¥ CNY', 'N', 45, 'A', '2022-09-29 23:47:48', '2022-09-30 00:12:04');

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

--
-- Table structure for table `core_warehouse_person`
--

CREATE TABLE `core_warehouse_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,
  `intern` varchar(75) DEFAULT NULL COMMENT '	Intern number',
  `cargo_id` int NOT NULL COMMENT 'Related to catalogs',
  `area_id` int NOT NULL COMMENT 'Related to catalogs',
  `country_id` int 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=FEDERATED DEFAULT CHARSET=utf8mb3 CONNECTION='mysql://root:Ma!9an1s@localhost:3306/core/global_person';

--
-- Dumping data for table `core_warehouse_person`
--

INSERT INTO `core_warehouse_person` (`id`, `users_sid`, `first_name`, `last_name`, `phone_number`, `intern`, `cargo_id`, `area_id`, `country_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'José', 'Aparicio', '76108443', '0', 76, 7, 27, 'A', '2021-06-24 16:09:51', '2021-10-22 09:39:28'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Franklin', 'Molina Ortiz', '0', '0', 1, 1, NULL, 'A', '2021-09-01 16:04:53', '2021-10-11 10:19:28'),
(38, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mario Alberto', 'Sapiencia Arrieta', '0', '201 - 901', 40, 7, NULL, 'A', '2021-09-01 16:04:53', '2021-09-03 16:48:35'),
(53, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mario Gonzalo', 'Aruquipa Lastario', '0', '209', 55, 7, NULL, 'A', '2021-09-01 16:04:53', '2021-09-03 16:27:51'),
(164, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Bill', 'Gates', '0', '666', 73, 7, NULL, 'A', '2021-10-28 11:58:10', '2021-10-29 15:21:20'),
(221, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Nueva', 'Persona de Prueba', '741585210', NULL, 180, 54, NULL, 'A', '2023-04-12 16:09:34', '2023-04-12 16:09:34'),
(222, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'MAYBER', 'APARICIO', '70000000', '0', 181, 8014, NULL, 'A', '2023-05-02 09:09:31', '2023-05-02 09:09:31');

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

--
-- Table structure for table `core_warehouse_users`
--

CREATE TABLE `core_warehouse_users` (
  `id` bigint NOT NULL,
  `sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'uuid()',
  `person_id` int NOT NULL COMMENT 'related to person table',
  `global_branch_office_id` varchar(50) DEFAULT NULL COMMENT 'global_branch_office',
  `profile_picture` varchar(50) DEFAULT NULL COMMENT 'The complete filename',
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'email',
  `password` tinytext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The password',
  `remember_token` text COMMENT 'The Token',
  `ttl` int NOT NULL DEFAULT '172800' COMMENT 'The time logged in',
  `wrong_login_attempt` tinyint NOT NULL DEFAULT '0' COMMENT 'Times wrong',
  `date_wrong_login_attempt` date DEFAULT NULL COMMENT 'Date when wrong',
  `client_ip` varchar(50) DEFAULT NULL COMMENT 'the clients IP',
  `status` enum('A','X','B') NOT NULL,
  `created_at` timestamp NOT NULL COMMENT 'When the user were created',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'When the user were updated'
) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb3 CONNECTION='mysql://root:Ma!9an1s@localhost:3306/core/global_users';

--
-- Dumping data for table `core_warehouse_users`
--

INSERT INTO `core_warehouse_users` (`id`, `sid`, `person_id`, `global_branch_office_id`, `profile_picture`, `email`, `password`, `remember_token`, `ttl`, `wrong_login_attempt`, `date_wrong_login_attempt`, `client_ip`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'profile-8.jpeg', 'ohkmalganis@gmail.com', '$2y$10$b9LgZL6qoVZJpCD7REetU.SXsm6wceG65xl6onkjwTy6QMxB4iIOq', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vMTI3LjAuMC4xOjgwMDEvYXBpL2xvZ2luIiwiaWF0IjoxNjg3MTcxMjU2LCJleHAiOjE2ODcyNTc2NTYsIm5iZiI6MTY4NzE3MTI1NiwianRpIjoiVkVmVjdDZE1BNFZVNnNCUSIsInN1YiI6IjEiLCJwcnYiOiIyM2JkNWM4OTQ5ZjYwMGFkYjM5ZTcwMWM0MDA4NzJkYjdhNTk3NmY3In0.WahEnXTrH5wXHIrwqjZ_-ZGOxMENoJoBigg8z7fGOgY', 86400, 0, '2023-04-23', '127.0.0.1', 'A', '2021-11-30 10:51:40', '2023-06-19 11:13:47'),
(7, '2d26be27-1fcb-4ee7-a2e6-2df956717ec9', 2, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 'fmolina@hidrocarburos.gob.bo', '$2y$10$ESMLnyVzefc.SELEEecoPuPc9tD0XbiIGTvG5WIerC5G4.ANBoCHS', NULL, 86400, 0, '2021-11-03', '127.0.0.1', 'A', '2023-03-23 12:52:01', '2022-06-14 09:03:05'),
(9, '937f7af1-55a1-4ecd-a439-364613c75833', 164, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'profile-25.jpeg', 'lenin.aparicio@gmail.com', '$2y$10$FIESxxSv/3/ECOI16ASwm.4zGd0.Ybk4FiMrE0yplU0ciD8YyfIU6', NULL, 86400, 0, '2022-11-21', '127.0.0.1', 'A', '2023-03-23 12:52:01', '2022-11-21 14:40:02'),
(45, '7ce7a7a9-5ddf-4727-8d0b-1ec2dc2cf8cb', 38, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'profile-25.jpeg', 'msapiencia@hidrocarburos.gob.bo', '$2y$10$V3VHEXL1Vvj4FwBfgNOEQeTQVC4pbPliefiBL9IH1K0dzPB03SDRi', NULL, 86400, 0, NULL, '127.0.0.1', 'A', '2023-03-23 12:52:01', '2022-12-15 11:51:45'),
(59, 'eeef3815-11de-4a4a-a6ac-8619b4e9b4ca', 53, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'profile-9.jpeg', 'garuquipa@hidrocarburos.gob.bo', '$2y$10$Mh8xwBllTLOFc3jNeLpPeeGgr181VMq9Jd2x6bp3Ucx2cDgp/f6J6', NULL, 86400, 0, '2022-04-28', '127.0.0.1', 'A', '2023-03-23 12:52:01', '2023-05-02 19:45:18'),
(220, 'd86120fb-11ef-48b1-a085-59a796974d8b', 222, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 'heraldomayber@gmail.com', '$2y$10$XyErd9koicLoga8uyuLpjOxB1qln8qvLEIcO8ciUrTHEzPI4mvJYK', NULL, 86400, 0, NULL, '127.0.0.1', 'A', '2023-05-02 09:10:39', '2023-05-02 14:45:29');

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

--
-- Table structure for table `warehouse_catalog_items`
--

CREATE TABLE `warehouse_catalog_items` (
  `id` int NOT NULL,
  `catalogs_id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `value` int NOT NULL,
  `label` varchar(250) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `orden` int DEFAULT 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;

--
-- Dumping data for table `warehouse_catalog_items`
--

INSERT INTO `warehouse_catalog_items` (`id`, `catalogs_id`, `users_sid`, `global_branch_office_id`, `value`, `label`, `lang`, `orden`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ALMACEN DE INSUMOS', 'es', NULL, 'TIPOALMACEN', '0', 0, 'ALMACEN DE INSUMOS', NULL, 'A', '2022-04-24 21:29:37', '2022-04-24 21:29:37'),
(2, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'ALMACEN DE COMPRA Y VENTA', 'es', NULL, 'TIPOALMACEN', '0', 0, 'ALMACEN DE COMPRA Y VENTA', NULL, 'A', '2022-04-24 21:35:37', '2022-04-24 21:35:37'),
(3, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'GENERICO', 'es', NULL, 'BRAND', '0', 0, 'GENERICO', NULL, 'A', '2022-05-13 12:21:32', '2022-05-13 12:21:32'),
(4, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'COLOR', 'es', NULL, 'ASSISTANT', '0', 0, 'COLOR', NULL, 'A', '2022-05-13 12:21:43', '2022-05-13 12:21:43'),
(5, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'TALLA', 'es', NULL, 'ASSISTANT', '0', 0, 'TALLA', NULL, 'A', '2022-05-13 12:21:50', '2022-05-13 12:21:50'),
(6, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'UNIDAD', 'es', NULL, 'MEASUREMENT', '0', 0, 'UNIDAD', NULL, 'A', '2022-05-13 12:22:47', '2022-05-13 12:22:47'),
(7, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'AJUSTE DE INVENTARIO', 'es', NULL, 'DROPS', '0', 0, 'AJUSTE DE INVENTARIO', NULL, 'A', '2022-05-13 12:22:58', '2022-05-13 12:22:58'),
(9, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'VARIOS', 'es', 1000, 'CATEGORY', '0', 0, 'VARIOS', NULL, 'A', '2022-05-13 12:38:24', '2022-06-26 22:39:24'),
(10, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'COCA COLA', 'es', -1, 'BRAND', '0', 0, 'COCA COLA', NULL, 'A', '2022-06-26 19:09:39', '2022-06-26 19:09:39'),
(11, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NESCAFE', 'es', -1, 'BRAND', '0', 0, 'NESCAFE', NULL, 'A', '2022-06-26 19:11:06', '2022-06-26 19:11:06'),
(12, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'XIAOMI', 'es', -1, 'BRAND', '0', 0, 'XIAOMI', NULL, 'A', '2022-06-26 19:12:52', '2022-06-26 19:12:52'),
(13, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PRODUCTOS VARIOS', 'es', 1001, 'CATEGORY', 'CATEGORY', 2, 'PRODUCTOS VARIOS', NULL, 'A', '2022-06-26 22:39:17', '2022-06-26 22:39:17'),
(14, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'ALMACEN DE ACTIVOS FIJOS', 'es', NULL, 'TIPOALMACEN', '0', 0, 'ALMACEN DE ACTIVOS FIJOS', NULL, 'A', '2022-06-30 19:04:44', '2022-06-30 19:04:44'),
(15, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'KILOGRAMO (KG)', 'es', NULL, 'WEIGHT', '0', 0, 'Kilogramo (kg)', NULL, 'A', '2023-01-26 21:32:58', '2023-01-26 21:32:58'),
(16, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'GRAMO (G)', 'es', NULL, 'WEIGHT', '0', 0, 'Gramo (g)', NULL, 'A', '2023-01-26 21:33:09', '2023-01-26 21:33:09'),
(17, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'MILIGRAMO (MG)', 'es', NULL, 'WEIGHT', '0', 0, 'Miligramo (mg)', NULL, 'A', '2023-01-26 21:33:19', '2023-01-26 21:33:19'),
(18, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'TONELADA (T)', 'es', NULL, 'WEIGHT', '0', 0, 'Tonelada (t)', NULL, 'A', '2023-01-26 21:33:26', '2023-01-26 21:33:26'),
(19, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'LIBRA (LB)', 'es', NULL, 'WEIGHT', '0', 0, 'Libra (lb)', NULL, 'A', '2023-01-26 21:33:33', '2023-01-26 21:33:33'),
(20, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'ONZA (OZ)', 'es', NULL, 'WEIGHT', '0', 0, 'Onza (oz)', NULL, 'A', '2023-01-26 21:33:39', '2023-01-26 21:33:39'),
(21, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 'STONE (ST)', 'es', NULL, 'WEIGHT', '0', 0, 'Stone (st)', NULL, 'A', '2023-01-26 21:33:50', '2023-01-26 21:33:50'),
(22, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 8, 'QUILATE (CT)', 'es', NULL, 'WEIGHT', '0', 0, 'Quilate (ct)', NULL, 'A', '2023-01-26 21:33:56', '2023-01-26 21:33:56'),
(23, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 9, 'TONELADA MÉTRICA (T)', 'es', NULL, 'WEIGHT', '0', 0, 'Tonelada métrica (t)', NULL, 'A', '2023-01-26 21:34:33', '2023-01-26 21:34:33'),
(24, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 10, 'TONELADA CORTA (TN)', 'es', NULL, 'WEIGHT', '0', 0, 'Tonelada corta (tn)', NULL, 'A', '2023-01-26 21:34:39', '2023-01-26 21:34:39'),
(25, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '1001 VALOR FOB', 'es', NULL, 'COSTS', '0', 0, '1001 VALOR FOB', NULL, 'A', '2023-01-31 18:18:06', '2023-01-31 18:18:06'),
(26, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '1014 FLETE DE TRANSPORTE TERRESTRE', 'es', NULL, 'COSTS', '0', 0, '1014 FLETE DE TRANSPORTE TERRESTRE', NULL, 'A', '2023-01-31 18:18:37', '2023-01-31 18:18:37'),
(27, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '1009 ESTIBAJE Y DESCARGA', 'es', NULL, 'COSTS', '0', 0, '1009 ESTIBAJE Y DESCARGA', NULL, 'A', '2023-01-31 18:18:50', '2023-01-31 18:18:50');

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

--
-- Table structure for table `warehouse_configuration`
--

CREATE TABLE `warehouse_configuration` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `decimals` smallint NOT NULL,
  `currency_id` int NOT NULL DEFAULT '1' COMMENT 'Related to currency table',
  `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;

--
-- Dumping data for table `warehouse_configuration`
--

INSERT INTO `warehouse_configuration` (`relative`, `users_sid`, `global_branch_office_id`, `decimals`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
('9c307433-e41c-4205-982d-b715f5779b98', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 2, 'A', '2022-04-26 21:30:28', '2022-04-26 21:30:28');

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

--
-- Table structure for table `warehouse_enterprise`
--

CREATE TABLE `warehouse_enterprise` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `fullname` varchar(250) NOT NULL,
  `economic_activity` mediumtext NOT NULL,
  `owner` varchar(250) NOT NULL,
  `address` mediumtext NOT NULL,
  `phones` varchar(150) NOT NULL,
  `branch_office` varchar(200) DEFAULT NULL,
  `branch_code` varchar(25) DEFAULT NULL,
  `city` tinytext NOT NULL,
  `photo` varchar(250) DEFAULT 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;

--
-- Dumping data for table `warehouse_enterprise`
--

INSERT INTO `warehouse_enterprise` (`relative`, `users_sid`, `global_branch_office_id`, `fullname`, `economic_activity`, `owner`, `address`, `phones`, `branch_office`, `branch_code`, `city`, `photo`, `status`, `created_at`, `updated_at`) VALUES
('d1c463d9-4219-40f1-b410-8df570eb4859', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 'TRYDENT SERVICES', 'Desarrollo de aplicaciones web', 'Ing. Jose Aparicio', 'Descripcion del sistema', '+591-76108443', 'Casa matriz', '1', 'La Paz', '1650934826-7142650-da69c7b4-ee88-410a-a4a3-7b908747fcdf.jpeg', 'A', '2022-04-25 21:00:26', '2022-04-25 21:03:19');

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

--
-- Table structure for table `warehouse_products`
--

CREATE TABLE `warehouse_products` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `internal_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Internal code',
  `fullname` varchar(250) NOT NULL,
  `description` mediumtext NOT NULL,
  `category_id` smallint NOT NULL COMMENT 'Related to Catalogs item = CATEGORY',
  `subcategory_id` smallint DEFAULT NULL COMMENT 'Related to Catalogs item = CATEGORY | SUBCATEGORY',
  `product_pictures` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Many URL separated by | on each data',
  `barcode` varchar(50) NOT NULL,
  `inventory_method` enum('PEPS','UEPS','PEPP','UEPP') NOT NULL DEFAULT 'UEPS',
  `enabled` enum('Y','N') NOT NULL DEFAULT 'Y',
  `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;

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

--
-- Table structure for table `warehouse_products_assistant`
--

CREATE TABLE `warehouse_products_assistant` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to catalogs = BRANCH',
  `provisional` varchar(50) DEFAULT NULL,
  `product_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Related to product table',
  `assistant_id` smallint NOT NULL COMMENT 'Related to catalogs = ASSISTANT	',
  `specification` varchar(200) 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;

--
-- Dumping data for table `warehouse_products_assistant`
--

INSERT INTO `warehouse_products_assistant` (`id`, `users_sid`, `global_branch_office_id`, `provisional`, `product_id`, `assistant_id`, `specification`, `status`, `created_at`, `updated_at`) VALUES
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '47c7b8cc-6ef2-4665-b351-c4f7025f62c0', NULL, 1, 'ROJO', 'A', '2023-01-25 11:43:41', '2023-01-31 12:56:29');

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

--
-- Table structure for table `warehouse_products_lot`
--

CREATE TABLE `warehouse_products_lot` (
  `relative` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to product table',
  `lot` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `generic` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N' COMMENT 'Lot generated by the system',
  `initial_quantity` decimal(10,5) NOT NULL,
  `quantity` decimal(10,5) NOT NULL,
  `measurement_id` smallint NOT NULL COMMENT 'Related to catalogs items = MEASUREMENT',
  `brand_id` smallint NOT NULL COMMENT 'Related to catalogs = BRAND',
  `unit_cost` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `expires` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'If the product expires',
  `expiration_date` date DEFAULT NULL COMMENT 'The expiration date',
  `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;

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

--
-- Table structure for table `warehouse_products_lot_adjustment`
--

CREATE TABLE `warehouse_products_lot_adjustment` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to product table',
  `lot_id` varchar(50) NOT NULL COMMENT 'Related to lot table',
  `previous_quantity` decimal(10,5) NOT NULL,
  `quantity` decimal(10,5) NOT NULL,
  `type` enum('I','E') NOT NULL DEFAULT 'I',
  `drops_id` smallint NOT NULL COMMENT 'Related to catalogs items = ''DROPS''',
  `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;

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

--
-- Table structure for table `warehouse_products_lot_history`
--

CREATE TABLE `warehouse_products_lot_history` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `warehouse_id` varchar(50) NOT NULL COMMENT 'Related to warehouse table',
  `lot` varchar(50) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to catalogs prod (MEASUREMENT)',
  `quantity` decimal(10,2) NOT NULL,
  `unit_cost` decimal(10,5) NOT NULL,
  `currency_id` varchar(50) NOT NULL COMMENT 'Related to global currency',
  `total_price` 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;

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

--
-- Table structure for table `warehouse_products_lot_kardex`
--

CREATE TABLE `warehouse_products_lot_kardex` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to products table',
  `lot_id` varchar(50) NOT NULL COMMENT 'Related to lot table',
  `iet` enum('I','E','T') NOT NULL DEFAULT 'I',
  `quantity` decimal(10,5) NOT NULL,
  `detail` 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;

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

--
-- Table structure for table `warehouse_products_metadata`
--

CREATE TABLE `warehouse_products_metadata` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to product table',
  `meta_title` varchar(200) NOT NULL,
  `meta_keywords` varchar(200) NOT NULL,
  `meta_description` 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;

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

--
-- Table structure for table `warehouse_products_price`
--

CREATE TABLE `warehouse_products_price` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `price` decimal(10,5) NOT NULL,
  `currency_id` varchar(50) NOT NULL COMMENT 'related to currency table',
  `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;

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

--
-- Table structure for table `warehouse_products_price_history`
--

CREATE TABLE `warehouse_products_price_history` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `price` decimal(10,5) NOT NULL,
  `currency_id` varchar(50) NOT NULL COMMENT 'related to currency table',
  `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;

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

--
-- Table structure for table `warehouse_products_stock`
--

CREATE TABLE `warehouse_products_stock` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to product table',
  `quantity` decimal(10,5) NOT NULL,
  `measurement_id` smallint NOT NULL COMMENT 'Related to catalogs items = ''MEASUREMENT''',
  `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;

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

--
-- Table structure for table `warehouse_products_stock_history`
--

CREATE TABLE `warehouse_products_stock_history` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to global_branch_office',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to products table',
  `quantity` decimal(10,2) NOT NULL,
  `measurement_id` int NOT NULL COMMENT 'Related to catalogs prod (MEASUREMENT)',
  `price` decimal(10,5) DEFAULT NULL,
  `currency_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Related to global currency',
  `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;

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

--
-- Table structure for table `warehouse_purchase_costs`
--

CREATE TABLE `warehouse_purchase_costs` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office table',
  `provisional` varchar(50) NOT NULL COMMENT 'The provisional data',
  `fob` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Is FOB or not',
  `costs_id` int NOT NULL COMMENT 'related to catalogs items, Catalogs code=COSTS',
  `cost` decimal(10,5) NOT NULL COMMENT 'The cost quantity',
  `currency_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to currency table',
  `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;

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

--
-- Table structure for table `warehouse_purchase_international`
--

CREATE TABLE `warehouse_purchase_international` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `kind` enum('DIM','DUI') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'DIM=Declaracion de importacion de mercancias, DUI=Declaracion unica de importacion ',
  `supplier_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to supplier database, supplier vendors table UUID',
  `dim_dui_date` date NOT NULL COMMENT 'Date of the document',
  `voucher_number` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `total_items` int DEFAULT NULL,
  `packages` int DEFAULT NULL,
  `weight` int DEFAULT NULL,
  `weight_id` int DEFAULT NULL COMMENT 'Related to catalogs items weight catalog code',
  `total_cost` decimal(10,5) NOT NULL,
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `comments` text,
  `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;

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

--
-- Table structure for table `warehouse_purchase_local`
--

CREATE TABLE `warehouse_purchase_local` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users sid',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `kind` enum('FC','FL','FM','OD') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'FC=Factura computarizada C7, FL=Factura en linea, \r\nFM=Factura manual\r\nOD=Otro documento',
  `supplier_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to supplier database, supplier vendors table UUID	',
  `voucher_number` varchar(50) NOT NULL,
  `purchase_date` date NOT NULL,
  `autorization_code_cuf` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `control_code` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `total_cost` decimal(10,5) NOT NULL,
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `warehouse_purchase_previous_inventory`
--

CREATE TABLE `warehouse_purchase_previous_inventory` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `supplier_id` varchar(50) NOT NULL COMMENT 'Related to supplier database, supplier vendors table UUID',
  `following_number` varchar(50) NOT NULL,
  `comments` text,
  `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;

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

--
-- Table structure for table `warehouse_purchase_production_order`
--

CREATE TABLE `warehouse_purchase_production_order` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `production_order_voucher` varchar(50) NOT NULL COMMENT 'Production order',
  `total_items` int DEFAULT NULL COMMENT 'Total items',
  `total_cost` decimal(10,5) NOT NULL COMMENT 'Total cost',
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `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;

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

--
-- Table structure for table `warehouse_warehouse`
--

CREATE TABLE `warehouse_warehouse` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `kind_id` int NOT NULL COMMENT 'Related to catalogs items=TIPOALMACEN',
  `warehouse` varchar(200) NOT NULL,
  `warehouse_description` mediumtext,
  `warehouse_location` varchar(200) 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;

--
-- Dumping data for table `warehouse_warehouse`
--

INSERT INTO `warehouse_warehouse` (`id`, `users_sid`, `global_branch_office_id`, `kind_id`, `warehouse`, `warehouse_description`, `warehouse_location`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'Almacen general - A1', 'Lorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta).', 'Almacen La Paz - CV', 'A', '2022-05-04 09:13:56', '2022-06-30 19:05:53'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'Almacen de materias primas C1', 'Lorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta) desconocido usó una galería de textos y los mezcló de tal manera que logró hacer un libro de textos especimen.', 'Almacen La Paz - CV', 'A', '2022-05-04 09:33:17', '2022-06-30 19:06:49'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'Almacen B1', 'Lorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta).', 'Segundo galpon B1', 'A', '2022-06-30 19:05:43', '2022-06-30 19:05:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `warehouse_catalog_items`
--
ALTER TABLE `warehouse_catalog_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warehouse_configuration`
--
ALTER TABLE `warehouse_configuration`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `configuration.relative` (`relative`);

--
-- Indexes for table `warehouse_enterprise`
--
ALTER TABLE `warehouse_enterprise`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `sivir_enterprise.relative` (`relative`);

--
-- Indexes for table `warehouse_products`
--
ALTER TABLE `warehouse_products`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indexes for table `warehouse_products_assistant`
--
ALTER TABLE `warehouse_products_assistant`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warehouse_products_lot`
--
ALTER TABLE `warehouse_products_lot`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_lot.relative` (`relative`);

--
-- Indexes for table `warehouse_products_lot_adjustment`
--
ALTER TABLE `warehouse_products_lot_adjustment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warehouse_products_lot_history`
--
ALTER TABLE `warehouse_products_lot_history`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indexes for table `warehouse_products_lot_kardex`
--
ALTER TABLE `warehouse_products_lot_kardex`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warehouse_products_metadata`
--
ALTER TABLE `warehouse_products_metadata`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warehouse_products_price`
--
ALTER TABLE `warehouse_products_price`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `sivir_products_price.relative` (`relative`);

--
-- Indexes for table `warehouse_products_price_history`
--
ALTER TABLE `warehouse_products_price_history`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `sivir_products_price.relative` (`relative`);

--
-- Indexes for table `warehouse_products_stock`
--
ALTER TABLE `warehouse_products_stock`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warehouse_products_stock_history`
--
ALTER TABLE `warehouse_products_stock_history`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indexes for table `warehouse_purchase_costs`
--
ALTER TABLE `warehouse_purchase_costs`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `sivir_costs.relative` (`relative`);

--
-- Indexes for table `warehouse_purchase_international`
--
ALTER TABLE `warehouse_purchase_international`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_purchase_international.relative` (`relative`) USING BTREE;

--
-- Indexes for table `warehouse_purchase_local`
--
ALTER TABLE `warehouse_purchase_local`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_purchase_local.relative` (`relative`);

--
-- Indexes for table `warehouse_purchase_previous_inventory`
--
ALTER TABLE `warehouse_purchase_previous_inventory`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_purchase_previous_inventory.relative` (`relative`) USING BTREE;

--
-- Indexes for table `warehouse_purchase_production_order`
--
ALTER TABLE `warehouse_purchase_production_order`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indexes for table `warehouse_warehouse`
--
ALTER TABLE `warehouse_warehouse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kind_id` (`kind_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `warehouse_catalog_items`
--
ALTER TABLE `warehouse_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `warehouse_products_assistant`
--
ALTER TABLE `warehouse_products_assistant`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `warehouse_products_lot_adjustment`
--
ALTER TABLE `warehouse_products_lot_adjustment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warehouse_products_lot_kardex`
--
ALTER TABLE `warehouse_products_lot_kardex`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warehouse_products_metadata`
--
ALTER TABLE `warehouse_products_metadata`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warehouse_products_stock`
--
ALTER TABLE `warehouse_products_stock`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warehouse_warehouse`
--
ALTER TABLE `warehouse_warehouse`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

