-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 14-10-2021 a las 11:07:26
-- Versión del servidor: 5.7.24
-- Versión de PHP: 7.4.20

START TRANSACTION;



--
-- Base de datos: `core_help_desk`
--

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

--
-- Estructura de tabla para la tabla `core_help_desk_person`
--

CREATE TABLE `core_help_desk_person` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `first_name` varchar(50) NOT NULL COMMENT 'The first and middle name',
  `last_name` varchar(75) NOT NULL COMMENT 'Last name',
  `phone_number` varchar(200) DEFAULT NULL,
  `intern` varchar(75) DEFAULT NULL COMMENT 'Intern number 	',
  `cargo_id` int(11) NOT NULL COMMENT 'Related to catalogs',
  `area_id` int(11) NOT NULL COMMENT 'Related to catalogs',
  `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=utf8 CONNECTION='mysql://root:0hkp455@localhost:3306/core/global_person';

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

INSERT INTO `core_help_desk_person` (`id`, `users_sid`, `first_name`, `last_name`, `phone_number`, `intern`, `cargo_id`, `area_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'José', 'Aparicio', '0', '0', 26, 7, 'A', '2021-06-24 16:09:51', '2021-07-26 16:36:38'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Franklin', 'Molina Ortiz', '0', '0', 1, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 10:19:28'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Marcos Luisiño', 'Barba Fach', '0', '104', 2, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 16:05:58'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Maria Virginia', 'Miranda Romero', '0', '313', 3, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 14:39:41'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Carola Patricia', 'Gonzales Larrain', '0', '501', 4, 2, 'A', '2021-09-01 16:04:53', '2021-09-03 14:41:47'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Miguel Antoniio', 'Chacon Bustillos', '0', '503', 5, 2, 'A', '2021-09-01 16:04:53', '2021-09-03 14:45:06'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jose Joselito', 'Guzman Clementelly', '0', '503', 6, 2, 'A', '2021-09-01 16:04:53', '2021-09-03 15:00:38'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Claudia Mery', 'Garcia Parra', '0', '503', 7, 2, 'A', '2021-09-01 16:04:53', '2021-09-03 15:00:48'),
(9, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jaquelin Sandra', 'Leyton Flores', '', '', 8, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(10, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Delia', 'Ingala Callex', '0', '1704', 9, 3, 'A', '2021-09-01 16:04:53', '2021-09-03 15:01:54'),
(11, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Pablo Abdon', 'Ramos Venegas', '0', '1705', 10, 3, 'A', '2021-09-01 16:04:53', '2021-09-03 15:02:25'),
(12, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Sandra Ivonne', 'Beatriz Duran Canelas    de  Fortun', '0', '601', 12, 4, 'A', '2021-09-01 16:04:53', '2021-09-03 16:47:19'),
(13, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Micaela Lourdes', 'Arteaga Leaño', '0', '603', 13, 4, 'A', '2021-09-01 16:04:53', '2021-09-03 15:03:39'),
(14, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Rosmery', 'Mano Urquiza', '0', '603', 15, 4, 'A', '2021-09-01 16:04:53', '2021-09-03 15:04:04'),
(15, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Eber', 'Chambi Chambi', '0', '1900', 16, 5, 'A', '2021-09-01 16:04:53', '2021-09-03 15:05:05'),
(16, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Emiliana', 'Moroco Flores', '0', '1902', 17, 5, 'A', '2021-09-01 16:04:53', '2021-09-03 15:05:35'),
(17, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Diego Armando', 'Aliaga Aparicio', '0', '1903', 18, 30, 'A', '2021-09-01 16:04:53', '2021-09-06 11:33:54'),
(18, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Carla Alejandra', 'Quispe Patiño', '0', '1906', 19, 5, 'A', '2021-09-01 16:04:53', '2021-09-03 15:20:48'),
(19, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Roxana Analia', 'Añez Valdez', '0', '1907', 20, 5, 'A', '2021-09-01 16:04:53', '2021-09-03 15:21:17'),
(20, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Wilson', 'Falcon Mamani', '0', '1908', 21, 5, 'A', '2021-09-01 16:04:53', '2021-09-03 15:21:44'),
(21, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Lady Corali', 'Zapata Alvarez', '0', '1910', 22, 5, 'A', '2021-09-01 16:04:53', '2021-09-03 15:22:13'),
(22, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Nataly Beatriz', 'Arias Ramos', '0', '1911', 23, 5, 'A', '2021-09-01 16:04:53', '2021-09-03 15:23:14'),
(23, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Chaquer David', 'Talamas Perdriel', '0', '301', 24, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 15:23:47'),
(24, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Lilia Elizabeth', 'de Gallo Quiñonez', '0', '302', 25, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 15:24:08'),
(25, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Karen', 'Tejerina Ruiz', '', '', 26, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(26, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Adrian Santiago', 'Aruni Humerez', '0', '304', 27, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 15:25:11'),
(27, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Victor Jose', 'Avendaño Rodriguez', '0', '310', 28, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 15:25:33'),
(28, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Cristian Rodriguez', 'Mendieta ', '', '', 29, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(29, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mariana', 'Caussin Coronado', '0', '309', 31, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 15:26:04'),
(30, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Joset Indira', 'Camacho Ticona', '0', '317', 32, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 15:26:37'),
(31, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Ludgi Marcia', 'Morales Soruco', '0', '312', 33, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 15:27:08'),
(32, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Limbert', 'Chipana Ramos', '0', '314', 34, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 16:03:46'),
(33, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Alvaro Antonio', 'Aldayuz Montes', '0', '316', 35, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 16:04:10'),
(34, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jorge Edwin', 'Ayala Paton', '0', '306', 36, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 16:04:27'),
(35, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Sibil Riseli', 'Luna Choque', '', '', 37, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(36, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Paulo Rene', 'Oquendo Tola', '0', '311', 38, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 16:04:54'),
(37, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Aldrin Jose', 'Ordoñez Almonte', '0', '317', 39, 6, 'A', '2021-09-01 16:04:53', '2021-09-03 16:05:11'),
(38, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mario Alberto', 'Sapiencia Arrieta', '0', '201 - 901', 40, 7, 'A', '2021-09-01 16:04:53', '2021-09-03 16:48:35'),
(39, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'María Remedios', 'Millares Murillo', '0', '202', 41, 7, 'A', '2021-09-01 16:04:53', '2021-09-03 16:23:26'),
(40, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Saul', 'Justiniano Tellez', '0', '216', 42, 16, 'A', '2021-09-01 16:04:53', '2021-09-03 16:36:10'),
(41, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Briana ', 'Rosario Barrancos Rosario', '', '', 43, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(42, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jaqueline Ursiña', 'Ibañez Laime', '0', '106', 44, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 16:06:16'),
(43, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Erika Litsy', 'Hurtado Gomez', '0', '109', 45, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 16:06:33'),
(44, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'German Martinez', 'Yujra Huanca', '0', '103', 46, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 16:06:57'),
(45, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan Carlos', 'Peralta Pachahuaya', '0', '103', 47, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 16:07:16'),
(46, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Oscar', 'Ayala Pacheco', '0', '1503', 48, 53, 'A', '2021-09-01 16:04:53', '2021-09-06 12:14:21'),
(47, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Rodnye Roman', 'Escobar Aliaga', '0', '707 - 717', 49, 22, 'A', '2021-09-01 16:04:53', '2021-09-03 17:00:02'),
(48, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Adad Vidal', 'Pinedo Usquiano', '0', '220', 50, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 16:22:32'),
(49, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jaime Julio', 'Rada Ramirez', '0', '204', 51, 15, 'A', '2021-09-01 16:04:53', '2021-09-03 16:25:46'),
(50, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Sheila Paola', 'Rojas Sanzetenea', '0', '208', 52, 15, 'A', '2021-09-01 16:04:53', '2021-09-03 16:26:07'),
(51, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Fabiola', 'Caspa Sanga', '0', '206', 53, 15, 'A', '2021-09-01 16:04:53', '2021-09-03 16:26:26'),
(52, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Alejandro', 'Vargas Fernández', '0', '214', 54, 15, 'A', '2021-09-01 16:04:53', '2021-09-03 16:26:49'),
(53, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mario Gonzalo', 'Aruquipa Lastario', '0', '209', 55, 7, 'A', '2021-09-01 16:04:53', '2021-09-03 16:27:51'),
(54, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Oscar David', 'Zurita Cossio', '0', '209', 56, 15, 'A', '2021-09-01 16:04:53', '2021-09-03 16:27:07'),
(55, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Rubén Emilio', 'Calle Illanes', '0', '234', 57, 15, 'A', '2021-09-01 16:04:53', '2021-09-03 16:27:23'),
(56, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Pablo Jaime', 'Fernandez Wieler', '0', '213', 58, 16, 'A', '2021-09-01 16:04:53', '2021-09-03 16:35:09'),
(57, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Claudia Alexandra', 'Guerrero Velasco', '0', '205', 59, 16, 'A', '2021-09-01 16:04:53', '2021-09-03 16:35:30'),
(58, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Maria Leandra', 'Gonzales Oliva', '0', '215', 60, 16, 'A', '2021-09-01 16:04:53', '2021-09-03 16:35:53'),
(59, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Julio', 'Montalvo Mamani', '', '', 62, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(60, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Eulalia Magdanevey', 'Mendoza Moscoso', '0', '1401', 63, 52, 'A', '2021-09-01 16:04:53', '2021-09-06 12:13:52'),
(61, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Enrique', 'Thompson Camacho', '0', '230', 64, 17, 'A', '2021-09-01 16:04:53', '2021-09-03 16:37:00'),
(62, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Kely Nadir', 'Peralta Callisaya', '0', '212', 65, 17, 'A', '2021-09-01 16:04:53', '2021-09-03 16:37:24'),
(63, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Harol Adalid', 'Chapi Siñani', '0', '1606', 66, 18, 'A', '2021-09-01 16:04:53', '2021-09-03 16:38:08'),
(64, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Luis Fernando', 'Romero Chavez', '0', '1606', 67, 18, 'A', '2021-09-01 16:04:53', '2021-09-03 16:38:25'),
(65, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Laura Daniela', 'Huanca Condori', '0', '227', 68, 19, 'A', '2021-09-01 16:04:53', '2021-09-03 16:39:01'),
(66, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'María Luisa', 'Rodrigo Basilio', '0', '227', 69, 19, 'A', '2021-09-01 16:04:53', '2021-09-03 16:39:16'),
(67, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Cristian Ernesto', 'Miranda  Cardenas', '0', '210', 70, 20, 'A', '2021-09-01 16:04:53', '2021-09-03 16:39:53'),
(68, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Rudy', 'Villca Mamani', '0', '210', 71, 20, 'A', '2021-09-01 16:04:53', '2021-09-03 16:40:08'),
(69, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jaime', 'Quenta Mamani', '0', '1605', 72, 18, 'A', '2021-09-01 16:04:53', '2021-09-03 16:40:45'),
(70, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Samuel', 'Puñi Condori', '0', '701', 73, 22, 'A', '2021-09-01 16:04:53', '2021-09-03 16:41:49'),
(71, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Moises', 'Cordero Rojas', '0', '702', 74, 22, 'A', '2021-09-01 16:04:53', '2021-09-03 16:42:10'),
(72, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Alex Pool', 'Ugarte Bernal', '0', '220', 75, 1, 'A', '2021-09-01 16:04:53', '2021-09-03 16:22:45'),
(73, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jorge Luis', 'Pocoaca Ali', '0', '703', 76, 22, 'A', '2021-09-01 16:04:53', '2021-09-03 16:42:58'),
(74, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Ivan Marbel', 'Andi Choquehuanca', '0', '1002', 78, 8, 'A', '2021-09-01 16:04:53', '2021-09-03 16:49:16'),
(75, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Fredi', 'Cordero Gemio', '0', '902', 80, 8, 'A', '2021-09-01 16:04:53', '2021-09-03 16:49:45'),
(76, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Xavier Eduardo', 'Barriga Sinisterra', '0', '1001', 81, 23, 'A', '2021-09-01 16:04:53', '2021-09-03 16:54:47'),
(77, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Zulma Nancy', 'Huallpa Condori', '0', '902', 82, 23, 'A', '2021-09-01 16:04:53', '2021-09-03 16:55:09'),
(78, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Diego Edwin', 'Espinoza Luna', '0', '902', 83, 23, 'A', '2021-09-01 16:04:53', '2021-09-03 16:55:31'),
(79, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Eudez Alexandra', 'Lora Velasco', '0', '1003', 84, 24, 'A', '2021-09-01 16:04:53', '2021-09-03 16:58:20'),
(80, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Elvis Alvaro', 'Siles Mojica', '0', '1006', 85, 24, 'A', '2021-09-01 16:04:53', '2021-09-03 16:57:45'),
(81, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Tito', 'Rendon Castro', '0', '1002', 86, 24, 'A', '2021-09-01 16:04:53', '2021-09-03 16:58:41'),
(82, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan Roberto', 'Machicado Botetano', '0', '1006', 87, 24, 'A', '2021-09-01 16:04:53', '2021-09-03 16:59:04'),
(83, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Ronald Max', 'Perez Gutierrez', '0', '1005', 88, 25, 'A', '2021-09-01 16:04:53', '2021-09-03 17:00:57'),
(84, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Rosario Denis', 'Coronel Chavez', '0', '1006', 89, 25, 'A', '2021-09-01 16:04:53', '2021-09-03 17:00:45'),
(85, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Giovanna', 'Zenteno Luna', '0', '1006', 90, 25, 'A', '2021-09-01 16:04:53', '2021-09-03 17:01:15'),
(86, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Herbert Julio', 'Escalante Gallardo', '0', '1006', 91, 25, 'A', '2021-09-01 16:04:53', '2021-09-03 17:01:32'),
(87, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan Antonio', 'Velasquez Revilla', '0', '1004', 92, 26, 'A', '2021-09-01 16:04:53', '2021-09-06 11:26:36'),
(88, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Luis Marcelo', 'Callejas Tito', '0', '1002', 93, 26, 'A', '2021-09-01 16:04:53', '2021-09-06 11:26:57'),
(89, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Yurguen Jesus', 'Ibarra Guerrero', '0', '1218', 94, 26, 'A', '2021-09-01 16:04:53', '2021-09-06 11:27:18'),
(90, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Silvia Ivana', 'Mejía Rocabado', '0', '1309', 95, 26, 'A', '2021-09-01 16:04:53', '2021-09-06 11:27:38'),
(91, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Victor', 'Andrade Loza', '0', '401', 96, 27, 'A', '2021-09-01 16:04:53', '2021-09-06 11:29:02'),
(92, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Freddy Gustavo', 'Velasquez Robles', '0', '405', 97, 28, 'A', '2021-09-01 16:04:53', '2021-09-06 11:29:28'),
(93, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Diego Alvaro', 'Ayala Frías', '0', '408', 98, 28, 'A', '2021-09-01 16:04:53', '2021-09-06 11:29:47'),
(94, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Romer', 'Roca Montenegro', '0', '409', 99, 28, 'A', '2021-09-01 16:04:53', '2021-09-06 11:30:05'),
(95, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jaime Armando', 'Moreno Caso', '0', '406', 100, 28, 'A', '2021-09-01 16:04:53', '2021-09-06 11:30:20'),
(96, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Igor ', 'Ismael Duran Cornejo', '0', '407', 101, 28, 'A', '2021-09-01 16:04:53', '2021-09-06 11:30:41'),
(97, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Boris Eduardo', 'Ballester Gemio', '0', '410', 102, 29, 'A', '2021-09-01 16:04:53', '2021-09-06 11:32:21'),
(98, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Carla Vanessa', 'Reque Montealegre', '0', '1304', 103, 29, 'A', '2021-09-01 16:04:53', '2021-09-06 11:32:40'),
(99, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Fredy Porfirio', 'Guarachi Laura', '0', '1302', 104, 29, 'A', '2021-09-01 16:04:53', '2021-09-06 11:33:00'),
(100, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'María Elena', 'Leyzan Caussin', '0', '4002', 106, 11, 'A', '2021-09-01 16:04:53', '2021-09-06 11:36:31'),
(101, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Francisco', 'Mariscal Zapana', '0', '4002', 107, 11, 'A', '2021-09-01 16:04:53', '2021-09-06 11:36:52'),
(102, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'David', 'Limachi Guzmán', '0', '4003', 108, 11, 'A', '2021-09-01 16:04:53', '2021-09-06 11:37:12'),
(103, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Regina Yamily', 'Salas Hussy', '0', '4100', 109, 31, 'A', '2021-09-01 16:04:53', '2021-09-06 11:37:40'),
(104, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Rodrigo Alfredo', 'Moreno Moreno', '0', '4101', 110, 32, 'A', '2021-09-01 16:04:53', '2021-09-06 11:37:59'),
(105, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Oscar', 'Cahuana Alarcon', '0', '4102', 111, 32, 'A', '2021-09-01 16:04:53', '2021-09-06 11:38:19'),
(106, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Walter Teofilo', 'Menacho Segalas', '', '', 112, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(107, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Iver', 'Patzi Saire', '0', '1909', 113, 1, 'A', '2021-09-01 16:04:53', '2021-09-06 11:35:02'),
(108, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Alejandro Daniel', 'Galoppo Pinto', '0', '4104', 114, 32, 'A', '2021-09-01 16:04:53', '2021-09-06 11:38:37'),
(109, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Pamela', 'Chambi Ramos', '0', '4120', 116, 33, 'A', '2021-09-01 16:04:53', '2021-09-06 11:41:46'),
(110, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Luis Fernando', 'Quiroz Ibañez', '0', '4123', 117, 33, 'A', '2021-09-01 16:04:53', '2021-09-06 11:42:07'),
(111, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Miguel', 'Ponce Justiniano', '0', '4121', 118, 33, 'A', '2021-09-01 16:04:53', '2021-09-06 11:42:22'),
(112, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Sergio Antonio', 'Guzman Rios', '0', '4200', 122, 34, 'A', '2021-09-01 16:04:53', '2021-09-06 11:42:50'),
(113, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Alvaro Fernando', 'Uberhuaga Robledo', '0', '4202', 124, 41, 'A', '2021-09-01 16:04:53', '2021-09-06 11:46:43'),
(114, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Omar Antonio', 'Viscarra Torrez', '0', '4207', 125, 41, 'A', '2021-09-01 16:04:53', '2021-09-06 11:47:01'),
(115, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Gustavo René', 'Sangueza Flores', '0', '4206', 126, 41, 'A', '2021-09-01 16:04:53', '2021-09-06 11:47:28'),
(116, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Gaston Ignacio', 'Aguilar Diaz', '0', '4205', 127, 41, 'A', '2021-09-01 16:04:53', '2021-09-06 11:47:50'),
(117, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Remberto', 'Quispe Gutierrez', '0', '4204', 129, 41, 'A', '2021-09-01 16:04:53', '2021-09-06 11:48:06'),
(118, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Willan Norman', 'Donaire Cardozo', '0', '1201', 132, 12, 'A', '2021-09-01 16:04:53', '2021-09-06 11:48:41'),
(119, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Noemí Sonia', 'Luján Medina', '0', '1202', 133, 12, 'A', '2021-09-01 16:04:53', '2021-09-06 11:49:01'),
(120, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan Carlos', 'Calle Callisaya', '0', '1202', 134, 12, 'A', '2021-09-01 16:04:53', '2021-09-06 11:49:20'),
(121, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mario Pablo', 'Mollisaca Mamani', '0', '1202', 135, 12, 'A', '2021-09-01 16:04:53', '2021-09-06 11:49:45'),
(122, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Adams', 'Hurtado Morales', '0', '1205', 136, 35, 'A', '2021-09-01 16:04:53', '2021-09-06 11:50:07'),
(123, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Valeria', 'Gallo Chacón', '0', '1208', 137, 35, 'A', '2021-09-01 16:04:53', '2021-09-06 11:50:28'),
(124, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan Orlando', 'Rojas Villarpando', '', '', 138, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(125, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan Reynaldo', 'Felipez Lanchipa', '0', '1208', 139, 36, 'A', '2021-09-01 16:04:53', '2021-09-06 11:50:52'),
(126, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Horacio', 'Zambrana Calvimonte', '0', '1206', 140, 37, 'A', '2021-09-01 16:04:53', '2021-09-06 11:51:08'),
(127, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Farith', 'Villalba Contreras', '0', '1212', 141, 37, 'A', '2021-09-01 16:04:53', '2021-09-06 11:51:25'),
(128, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Lindon Galo', 'Olaguivel Buitrago', '0', '1207', 142, 37, 'A', '2021-09-01 16:04:53', '2021-09-06 11:51:42'),
(129, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Edwin Zoilo', 'Miranda Saracho', '0', '1206', 143, 37, 'A', '2021-09-01 16:04:53', '2021-09-06 11:51:57'),
(130, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Carla Alejandra', 'Flores Noya', '0', '1211', 144, 38, 'A', '2021-09-01 16:04:53', '2021-09-06 11:52:37'),
(131, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Javier Abel', 'Pantoja Burgos', '0', '1217', 145, 39, 'A', '2021-09-01 16:04:53', '2021-09-06 11:52:57'),
(132, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jorge Gerardo', 'Quispe Kantuta', '0', '1220', 146, 39, 'A', '2021-09-01 16:04:53', '2021-09-06 11:53:18'),
(133, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Alberto', 'Escalante Camacho', '0', '1221', 147, 39, 'A', '2021-09-01 16:04:53', '2021-09-06 11:53:35'),
(134, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Jorge Freddy', 'Mollo Charaly', '0', '1214', 148, 39, 'A', '2021-09-01 16:04:53', '2021-09-06 11:53:54'),
(135, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Omar Silver', 'Espinoza Ariñez', '0', '1215', 150, 40, 'A', '2021-09-01 16:04:53', '2021-09-06 11:55:02'),
(136, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Sergio Mauricio', 'Tellez Von Borries', '0', '1213', 151, 40, 'A', '2021-09-01 16:04:53', '2021-09-06 11:55:19'),
(137, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Pamela Monica', 'Ramos Maldonado', '0', '1203', 152, 40, 'A', '2021-09-01 16:04:53', '2021-09-06 11:55:32'),
(138, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'José María', 'Romay Bartolini', '0', '2000', 153, 13, 'A', '2021-09-01 16:04:53', '2021-09-06 12:00:16'),
(139, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Susana Alejandra', 'Aguirre Fuentes', '0', '2001', 154, 13, 'A', '2021-09-01 16:04:53', '2021-09-06 12:00:36'),
(140, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Carlos', 'Cosme Machicado', '0', '2003', 155, 13, 'A', '2021-09-01 16:04:53', '2021-09-06 12:01:04'),
(141, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Edson', 'Huchani Chirinos', '0', '2003', 156, 13, 'A', '2021-09-01 16:04:53', '2021-09-06 12:01:20'),
(142, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Edgar Freddy', 'Caero Ayala', '0', '2100', 157, 42, 'A', '2021-09-01 16:04:53', '2021-09-06 12:01:39'),
(143, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan José', 'Quispe Peñarrieta', '0', '2101', 158, 42, 'A', '2021-09-01 16:04:53', '2021-09-06 12:03:13'),
(144, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Nelson', 'Bellott Rodriguez', '0', '2102', 159, 42, 'A', '2021-09-01 16:04:53', '2021-09-06 12:03:31'),
(145, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Raúl Alejandro', 'Vargas Aguilera', '0', '2105', 160, 42, 'A', '2021-09-01 16:04:53', '2021-09-06 12:03:52'),
(146, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Oscar Fiesta', 'Jani Jani', '0', '2107', 161, 42, 'A', '2021-09-01 16:04:53', '2021-09-06 12:04:07'),
(147, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Antonio', 'Ticona Mamani', '0', '2120', 162, 43, 'A', '2021-09-01 16:04:53', '2021-09-06 12:04:29'),
(148, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Camila', 'Heredia Bernarz', '0', '3240', 163, 43, 'A', '2021-09-01 16:04:53', '2021-09-06 12:04:55'),
(149, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Roberto', 'Zubieta Roca', '0', '2122', 164, 43, 'A', '2021-09-01 16:04:53', '2021-09-06 12:05:50'),
(150, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Severino Alejandro', 'Quispe Ramos', '0', '2200', 165, 44, 'A', '2021-09-01 16:04:53', '2021-09-06 12:06:14'),
(151, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Carmen Cecilia', 'Ramirez Villegas', '0', '2201', 166, 44, 'A', '2021-09-01 16:04:53', '2021-09-06 12:06:33'),
(152, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Carlos Raul', 'Tancara Huarachi', '0', '2222', 167, 44, 'A', '2021-09-01 16:04:53', '2021-09-06 12:06:54'),
(153, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Ruben', 'Peredo Grageda', '0', '2203', 168, 44, 'A', '2021-09-01 16:04:53', '2021-09-06 12:07:12'),
(154, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Rudy Roberto', 'Mamani Quisbert', '0', '2202', 169, 44, 'A', '2021-09-01 16:04:53', '2021-09-06 12:07:30'),
(155, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Neysa', 'Quispe Flores', '', '', 170, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(156, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Hermogenes', 'Irahola Morales', '', '', 171, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(157, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Leonardo', 'Jauregui Ramirez', '0', '2221', 172, 45, 'A', '2021-09-01 16:04:53', '2021-09-06 12:08:07'),
(158, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Fernando Misael', 'Solano Paniagua', '', '', 173, 1, 'A', '2021-09-01 16:04:53', '2021-10-11 16:01:34'),
(159, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Edmundo Boris', 'Delgado Quispe', '0', '2223', 174, 45, 'A', '2021-09-01 16:04:53', '2021-09-06 12:08:28'),
(160, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Alvaro Hernán', 'Arnez Prado', '0', '3000', 175, 14, 'A', '2021-09-01 16:04:53', '2021-09-06 12:08:52'),
(161, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'María Elena', 'Alfaro Castillo', '0', '3001', 176, 14, 'A', '2021-09-01 16:04:53', '2021-09-06 12:09:12'),
(162, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Eloy', 'Huanca Quito', '0', '3002', 177, 14, 'A', '2021-09-01 16:04:53', '2021-09-06 12:09:28'),
(163, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Juan Carlos', 'Chinche Casas', '0', '3002', 178, 14, 'A', '2021-09-01 16:04:53', '2021-09-06 12:09:56');

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

--
-- Estructura de tabla para la tabla `core_help_desk_users`
--

CREATE TABLE `core_help_desk_users` (
  `id` bigint(20) NOT NULL,
  `sid` varchar(50) DEFAULT NULL COMMENT 'uuid()',
  `person_id` int(11) NOT NULL COMMENT 'related to person table',
  `global_branch_office_id` varchar(50) DEFAULT NULL COMMENT 'global_branch_office',
  `email` varchar(255) NOT NULL COMMENT 'email',
  `password` tinytext NOT NULL COMMENT 'The password',
  `remember_token` text COMMENT 'The Token',
  `ttl` int(11) NOT NULL DEFAULT '172800' COMMENT 'The time logged in',
  `wrong_login_attempt` tinyint(4) 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=utf8 CONNECTION='mysql://root:0hkp455@localhost:3306/core/global_users';

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

INSERT INTO `core_help_desk_users` (`id`, `sid`, `person_id`, `global_branch_office_id`, `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, NULL, 'ohkmalganis@gmail.com', '$2y$10$b9LgZL6qoVZJpCD7REetU.SXsm6wceG65xl6onkjwTy6QMxB4iIOq', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOlwvXC8xMjcuMC4wLjE6ODAwMVwvYXBpXC9sb2dpbiIsImlhdCI6MTYzNDEyOTg2MCwiZXhwIjoxNjM0MjE2MjYwLCJuYmYiOjE2MzQxMjk4NjAsImp0aSI6IlVXYk9SZFlzbjBlMFVjSHIiLCJzdWIiOjEsInBydiI6IjIzYmQ1Yzg5NDlmNjAwYWRiMzllNzAxYzQwMDg3MmRiN2E1OTc2ZjcifQ.UmAX1FcuwAI571Mf-a4XtfNRAYfUHJXgxtiFuVWezfI', 86400, 0, '2021-06-25', '127.0.0.1', 'A', '2020-02-15 03:03:36', '2021-10-13 08:57:40'),
(5, '3a710926-6ef0-4c75-a102-79c9444a0ea6', 2, NULL, 'jose.aparicio@hidrocarburos.gob.bo', '$2y$10$FW2RRJzTCHOPk1URpU5w2ucH/Fi4AuBAm3NWz4BVkQAgPZmIGJXLy', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOlwvXC8xMjcuMC4wLjE6ODAwMVwvYXBpXC9sb2dpbiIsImlhdCI6MTYzMjQwODkxNCwiZXhwIjoxNjMyNDk1MzE0LCJuYmYiOjE2MzI0MDg5MTQsImp0aSI6IjVEYTkxT3FmQWFTMmwxbXEiLCJzdWIiOjUsInBydiI6IjIzYmQ1Yzg5NDlmNjAwYWRiMzllNzAxYzQwMDg3MmRiN2E1OTc2ZjcifQ.saLPvpCH6vayqYxoWKNYBk2-l6YYtvInnRoLYoS6ERs', 86400, 0, NULL, '127.0.0.1', 'A', '2021-09-23 10:09:22', '2021-09-23 10:55:14'),
(6, 'db95a360-8205-40a1-9234-6e55dbfa6a39', 3, NULL, 'luischavezcald@gmail.com', '$2y$10$r5kOzmxB0jUkJI3F8dCMw./2111CRaC5j06rxicAjTFUK8xF4qCfG', NULL, 86400, 0, NULL, '127.0.0.1', 'A', '2021-09-23 11:08:49', NULL);

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

--
-- Estructura de tabla para la tabla `core_help_desk_users_passwords`
--

CREATE TABLE `core_help_desk_users_passwords` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users sid, not who register.',
  `users_id` varchar(50) NOT NULL COMMENT 'related to users table',
  `password` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://root:0hkp455@localhost:3306/core/global_users_passwords';

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

INSERT INTO `core_help_desk_users_passwords` (`id`, `users_sid`, `users_id`, `password`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '3a710926-6ef0-4c75-a102-79c9444a0ea6', 'U2FsdGVkX19UVJVZ5oOIXgweCKenJLT6NdBMaFUrPd8=', 'A', '2021-09-23 10:09:22', '2021-09-23 10:09:22'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'db95a360-8205-40a1-9234-6e55dbfa6a39', 'U2FsdGVkX19LhrGRwIvgU54UN3N/HFtQtSu03ChTaXk=', 'A', '2021-09-23 11:08:49', '2021-09-23 11:08:49');

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

--
-- Estructura de tabla para la tabla `hye_catalog_items`
--

CREATE TABLE `hye_catalog_items` (
  `id` int(11) NOT NULL,
  `catalogs_id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `value` int(11) 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(11) 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=utf8;

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

INSERT INTO `hye_catalog_items` (`id`, `catalogs_id`, `users_sid`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(2, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 14, 'VICEMINISTERIO DE ALTAS TECNOLOGÍAS ENERGÉTICAS', 'es', 'AREA', '0', 0, 'Viceministerio de Altas Tecnologías Energéticas', NULL, 'A', '2021-07-26 16:07:10', '2021-07-26 16:07:10'),
(16, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'MINISTRO', 'es', 'CARGO', '0', 0, 'Ministro', NULL, 'A', '2021-07-26 16:08:22', '2021-07-26 16:08:22'),
(17, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'ASESOR', 'es', 'CARGO', '0', 0, 'Asesor', NULL, 'A', '2021-07-26 16:08:31', '2021-07-26 16:08:31'),
(18, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'JEFE DE GABINETE', 'es', 'CARGO', '0', 0, 'Jefe de Gabinete', NULL, 'A', '2021-07-26 16:08:41', '2021-07-26 16:08:41'),
(19, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'JEFE DE LA UNIDAD DE COMUNICACIÓN SOCIAL', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Comunicación Social', NULL, 'A', '2021-07-26 16:08:48', '2021-07-26 16:08:48'),
(20, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'PROFESIONAL DE IMAGEN Y VIDEO', 'es', 'CARGO', '0', 0, 'Profesional de Imagen y Video', NULL, 'A', '2021-07-26 16:08:56', '2021-07-26 16:08:56'),
(21, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'PROFESIONAL DE PRENSA Y WEB', 'es', 'CARGO', '0', 0, 'Profesional de Prensa y WEB', NULL, 'A', '2021-07-26 16:09:01', '2021-07-26 16:09:01'),
(22, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 'TÉCNICO EN COMUNICACIÓN Y LOGISTICA', 'es', 'CARGO', '0', 0, 'Técnico en Comunicación y Logistica', NULL, 'A', '2021-07-26 16:09:06', '2021-07-26 16:09:06'),
(23, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 8, 'JEFE DE LA UNIDAD DE AUDITORIA INTERNA', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Auditoria Interna', NULL, 'A', '2021-07-26 16:09:13', '2021-07-26 16:09:13'),
(24, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 9, 'PROFESIONAL SUPERVISOR AUDITOR INTERNO', 'es', 'CARGO', '0', 0, 'Profesional Supervisor Auditor Interno', NULL, 'A', '2021-07-26 16:09:19', '2021-07-26 16:09:19'),
(25, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 10, 'PROFESIONAL AUDITOR INTERNO', 'es', 'CARGO', '0', 0, 'Profesional Auditor Interno', NULL, 'A', '2021-07-26 16:09:24', '2021-07-26 16:09:24'),
(26, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 11, 'PROFESIONAL AUDITOR INTERNO', 'es', 'CARGO', '0', 0, 'Profesional Auditor Interno', NULL, 'A', '2021-07-26 16:09:29', '2021-07-26 16:09:29'),
(27, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 12, 'JEFE DE LA UNIDAD DE TRANSPARENCIA Y LUCHA CONTRA LA CORRUPCIÓN', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Transparencia y Lucha Contra la Corrupción', NULL, 'A', '2021-07-26 16:10:40', '2021-07-26 16:10:40'),
(28, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 13, 'DIRECTOR GENERAL DE CONTROL Y FISCALIZACIÓN', 'es', 'CARGO', '0', 0, 'Director General de Control y Fiscalización', NULL, 'A', '2021-07-26 16:10:46', '2021-07-26 16:10:46'),
(29, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 14, 'JEFE DE LA UNIDAD DE CONTROL Y FISCALIZACIÓN ENERGÉTICA', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Control y Fiscalización Energética', NULL, 'A', '2021-07-26 16:10:54', '2021-07-26 16:10:54'),
(30, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 15, 'DIRECTOR GENERAL DE ASUNTOS JURÍDICOS', 'es', 'CARGO', '0', 0, 'Director General de Asuntos Jurídicos', NULL, 'A', '2021-07-26 16:11:03', '2021-07-26 16:11:03'),
(31, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 16, 'JEFE DE LA UNIDAD DE ANÁLISIS JURÍDICO', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Análisis Jurídico', NULL, 'A', '2021-07-26 16:11:10', '2021-07-26 16:11:10'),
(32, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 17, 'JEFE DE UNIDAD DE GESTIÓN JURÍDICA', 'es', 'CARGO', '0', 0, 'Jefe de Unidad de Gestión Jurídica', NULL, 'A', '2021-07-26 16:11:20', '2021-07-26 16:11:20'),
(33, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 18, 'DIRECTOR GENERAL DE ASUNTOS ADMINISTRATIVOS', 'es', 'CARGO', '0', 0, 'Director General de Asuntos Administrativos', NULL, 'A', '2021-07-26 16:11:28', '2021-07-26 16:11:28'),
(34, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 19, 'JEFE DE LA UNIDAD FINANCIERA', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad Financiera', NULL, 'A', '2021-07-26 16:11:37', '2021-07-26 16:11:37'),
(35, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 20, 'SECRETARIA DGAA', 'es', 'CARGO', '0', 0, 'Secretaria DGAA', NULL, 'A', '2021-07-26 16:12:09', '2021-07-26 16:12:09'),
(36, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 21, 'UJIER DGAA', 'es', 'CARGO', '0', 0, 'Ujier DGAA', NULL, 'A', '2021-07-26 16:12:16', '2021-07-26 16:12:16'),
(37, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 22, 'JEFE DE LA UNIDAD DE RECURSOS HUMANOS Y ADMINISTRATIVOS', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Recursos Humanos y Administrativos', NULL, 'A', '2021-07-26 16:12:39', '2021-07-26 16:12:39'),
(38, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 23, 'PROFESIONAL DE TECNOLOGÍA DE INFORMACIÓN Y COMUNICACIÓN', 'es', 'CARGO', '0', 0, 'Profesional de Tecnología de Información y Comunicación', NULL, 'A', '2021-07-26 16:12:56', '2021-07-26 16:12:56'),
(39, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 24, 'ENCARGADO DE SOPORTE TÉCNICO E INFORMÁTICO', 'es', 'CARGO', '0', 0, 'Encargado de Soporte Técnico e Informático', NULL, 'A', '2021-07-26 16:13:03', '2021-07-26 16:13:03'),
(40, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 25, 'TÉCNICO DIGITALIZADOR', 'es', 'CARGO', '0', 0, 'Técnico Digitalizador', NULL, 'A', '2021-07-26 16:13:09', '2021-07-26 16:13:09'),
(41, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 26, 'TÉCNICO EN SOPORTE Y SISTEMAS INFORMÁTICOS', 'es', 'CARGO', '0', 0, 'Técnico en Soporte y Sistemas Informáticos', NULL, 'A', '2021-07-26 16:13:15', '2021-07-26 16:13:15'),
(42, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, 'VICEMINISTRO DE PLANIFICACIÓN Y DESARROLLO  ENERGÉTICO', 'es', 'CARGO', '0', 0, 'Viceministro de Planificación y Desarrollo  Energético', NULL, 'A', '2021-07-26 16:13:20', '2021-07-26 16:13:20'),
(43, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 28, 'DIRECTOR GENERAL DE GESTIÓN SOCIO AMBIENTAL', 'es', 'CARGO', '0', 0, 'Director General de Gestión Socio Ambiental', NULL, 'A', '2021-07-26 16:13:28', '2021-07-26 16:13:28'),
(44, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 29, 'JEFE DE LA UNIDAD DE PREVENCIÓN Y CONTROL SOCIO AMBIENTAL', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Prevención y Control Socio Ambiental', NULL, 'A', '2021-07-26 16:13:33', '2021-07-26 16:13:33'),
(45, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 30, 'JEFE DE UNIDAD DE SEGUIMIENTO Y CONTROL', 'es', 'CARGO', '0', 0, 'Jefe de Unidad de Seguimiento y Control', NULL, 'A', '2021-07-26 16:13:41', '2021-07-26 16:13:41'),
(46, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 31, 'JEFE DE UNIDAD DE CONSULTA Y PARTICIPACIÓN', 'es', 'CARGO', '0', 0, 'Jefe de Unidad de Consulta y Participación', NULL, 'A', '2021-07-26 16:13:47', '2021-07-26 16:13:47'),
(47, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 32, 'DIRECTOR GENERAL DE PLANIFCACIÓN Y DESARROLLO ENERGÉTICO', 'es', 'CARGO', '0', 0, 'Director General de Planifcación y Desarrollo Energético', NULL, 'A', '2021-07-26 16:13:52', '2021-07-26 16:13:52'),
(48, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 33, 'JEFE DE UNIDAD DE PLANIFICACIÓN Y DESARROLLO ENERGÉTICO', 'es', 'CARGO', '0', 0, 'Jefe de Unidad de Planificación y Desarrollo Energético', NULL, 'A', '2021-07-26 16:13:57', '2021-07-26 16:13:57'),
(49, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 34, 'JEFE DE UNIDAD DE ESTADISTICAS E INFORMACIÓN ENERGÉTICA', 'es', 'CARGO', '0', 0, 'Jefe de Unidad de Estadisticas e Información Energética', NULL, 'A', '2021-07-26 16:14:04', '2021-07-26 16:14:04'),
(50, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 35, 'VICEMINISTRO DE EXPLORACIÓN Y EXPLOTACIÓN DE HIDROCARBUROS', 'es', 'CARGO', '0', 0, 'Viceministro de Exploración y Explotación de Hidrocarburos', NULL, 'A', '2021-07-26 16:14:10', '2021-07-26 16:14:10'),
(51, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 36, 'DIRECTOR GENERAL DE EXPLORACIÓN Y EXPLOTACIÓN DE HIDROCARBUROS', 'es', 'CARGO', '0', 0, 'Director General de Exploración y Explotación de Hidrocarburos', NULL, 'A', '2021-07-26 16:14:16', '2021-07-26 16:14:16'),
(52, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 37, 'JEFE UNIDAD DE NORMAS Y  CONTROL TÉCNICO EN EXPLORACIÓN Y EXPLOTACIÓN DE HIDROCARBUROS', 'es', 'CARGO', '0', 0, 'Jefe Unidad de Normas y  Control Técnico en Exploración y Explotación de Hidrocarburos', NULL, 'A', '2021-07-26 16:14:21', '2021-07-26 16:14:21'),
(53, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 38, 'JEFE DE LA UNIDAD DE CONTROL TÉCNICO DE ACTIVIDADES DE EXPLORACIÓN Y EXPLOTACIÓN DE HIDROCARBUROS', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Control Técnico de Actividades de Exploración y Explotación de Hidrocarburos', NULL, 'A', '2021-07-26 16:14:29', '2021-07-26 16:14:29'),
(54, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 39, 'DIRECTOR GENERAL DE PRODUCCIÓN, RECAUDACIÓN E INCENTIVOS', 'es', 'CARGO', '0', 0, 'Director General de Producción, Recaudación e Incentivos', NULL, 'A', '2021-07-26 16:14:37', '2021-07-26 16:14:37'),
(55, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 40, 'JEFE DE LA UNIDAD DE PRODUCCIÓN, RECAUDACIÓN E INCENTIVOS', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Producción, Recaudación e Incentivos', NULL, 'A', '2021-07-26 16:14:42', '2021-07-26 16:14:42'),
(56, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 41, 'VICEMINISTRO DE INDUSTRIALIZACIÓN, COMERCIALIZACIÓN, TRANSPORTE Y ALMACENAJE DE HIDROCARBUROS', 'es', 'CARGO', '0', 0, 'Viceministro de Industrialización, Comercialización, Transporte y Almacenaje de Hidrocarburos', NULL, 'A', '2021-07-26 16:14:49', '2021-07-26 16:14:49'),
(57, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 42, 'DIRECTOR GENERAL DE INDUSTRIALIZACIÓN Y REFINACIÓN', 'es', 'CARGO', '0', 0, 'Director General de Industrialización y Refinación', NULL, 'A', '2021-07-26 16:14:54', '2021-07-26 16:14:54'),
(58, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 43, 'JEFE DE LA UNIDAD DE INDUSTRIALIZACIÓN', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Industrialización', NULL, 'A', '2021-07-26 16:15:00', '2021-07-26 16:15:00'),
(59, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 44, 'JEFE DE LA UNIDAD DE REFINACIÓN', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Refinación', NULL, 'A', '2021-07-26 16:15:05', '2021-07-26 16:15:05'),
(60, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 45, 'DIRECTOR GENERAL DE COMERCIALIZACIÓN, TRANSPORTE Y ALMACENAJE', 'es', 'CARGO', '0', 0, 'Director General de Comercialización, Transporte y Almacenaje', NULL, 'A', '2021-07-26 16:15:11', '2021-07-26 16:15:11'),
(61, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 46, 'JEFE DE LA UNIDAD DE TRANSPORTE, ALMACENAJE Y DISTRIBUCIÓN DE GAS', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Transporte, Almacenaje y Distribución de Gas', NULL, 'A', '2021-07-26 16:15:16', '2021-07-26 16:15:16'),
(62, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 47, 'JEFE DE LA UNIDAD DE COMERCIALIZACIÓN DE HIDROCARBUROS', 'es', 'CARGO', '0', 0, 'Jefe de la Unidad de Comercialización de Hidrocarburos', NULL, 'A', '2021-07-26 16:15:21', '2021-07-26 16:15:21'),
(63, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 48, 'VICEMINISTRO DE ELECTRICIDAD Y ENERGÍAS ALTERNATIVAS', 'es', 'CARGO', '0', 0, 'Viceministro de Electricidad y Energías Alternativas', NULL, 'A', '2021-07-26 16:15:27', '2021-07-26 16:15:27'),
(64, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 49, 'DIRECTOR GENERAL DE ELECTRICIDAD', 'es', 'CARGO', '0', 0, 'Director General de Electricidad', NULL, 'A', '2021-07-26 16:15:34', '2021-07-26 16:15:34'),
(65, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 50, 'JEFE UNIDAD DE EVALUACIÓN Y NORMAS', 'es', 'CARGO', '0', 0, 'Jefe Unidad de Evaluación y Normas', NULL, 'A', '2021-07-26 16:15:41', '2021-07-26 16:15:41'),
(66, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 51, 'DIRECTOR GENERAL DE ENERGIAS ALTERNATIVAS', 'es', 'CARGO', '0', 0, 'Director General de Energias Alternativas', NULL, 'A', '2021-07-26 16:15:48', '2021-07-26 16:15:48'),
(67, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 52, 'JEFE UNIDAD DESARROLLO DE INFRAESTRUCTURA Y ELECTRIFICACIÓN RURAL (PEVD)', 'es', 'CARGO', '0', 0, 'Jefe Unidad Desarrollo de Infraestructura y Electrificación Rural (PEVD)', NULL, 'A', '2021-07-26 16:15:53', '2021-07-26 16:15:53'),
(68, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 53, '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-07-26 16:15:59', '2021-07-26 16:15:59'),
(69, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 54, 'JEFE UNIDAD DE APLICACIONES Y NORMATIVA DE LITIO', 'es', 'CARGO', '0', 0, 'Jefe Unidad de Aplicaciones y Normativa de Litio', NULL, 'A', '2021-07-26 16:16:07', '2021-07-26 16:16:07'),
(70, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 55, 'DIRECTOR GENERAL DE LITIO', 'es', 'CARGO', '0', 0, 'Director General de Litio', NULL, 'A', '2021-07-26 16:16:11', '2021-07-26 16:16:11'),
(71, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 56, 'DIRECTOR GENERAL DE ENERGÍA NUCLEAR', 'es', 'CARGO', '0', 0, 'Director General de Energía Nuclear', NULL, 'A', '2021-07-26 16:16:18', '2021-07-26 16:16:18'),
(72, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 57, 'JEFE UNIDAD DE APLICACIONES Y NORMATIVA NUCLEAR', 'es', 'CARGO', '0', 0, 'Jefe Unidad de Aplicaciones y Normativa Nuclear', NULL, 'A', '2021-07-26 16:16:24', '2021-07-26 16:16:24'),
(73, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '7d85e609-c75e-404d-bf77-2169a6f2c1e6', 1, 'ALTA', 'es', 'PRIORIDAD', '0', 0, 'Alta - urgente', NULL, 'A', '2021-07-26 16:30:34', '2021-07-29 09:52:27'),
(94, 1, '7d85e609-c75e-404d-bf77-2169a6f2c1e6', 2, 'BAJA', 'es', 'PRIORIDAD', '0', 0, 'Baja', NULL, 'A', '2021-07-26 16:31:33', '2021-07-29 09:52:33'),
(95, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'MINUTOS', 'es', 'UNIDAD DE TIEMPO', '0', 0, 'Minutos', NULL, 'A', '2021-07-26 16:32:04', '2021-07-26 16:32:04'),
(97, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 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, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'URGENTE', 'es', 'PRIORIDAD', '0', 0, 'Urgente', NULL, 'A', '2021-08-04 09:42:05', '2021-08-04 09:42:05'),
(101, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'REQUERIMIENTO INMEDIATO', 'es', 'CATEGORIA', 'CATEGORIA', 3, 'REQUERIMIENTO INMEDIATO!', NULL, 'A', '2021-09-21 15:26:33', '2021-09-21 15:28:58'),
(102, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'ABIERTO - EN ESPERA', 'es', 'ESTADO DEL TICKET', '0', 0, 'ABIERTO - EN ESPERA', NULL, 'A', '2021-09-21 19:20:37', '2021-09-21 19:20:37');

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

--
-- Estructura de tabla para la tabla `hye_person_elegible`
--

CREATE TABLE `hye_person_elegible` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `person_id` int(11) NOT NULL COMMENT 'Person table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `hye_person_elegible` (`id`, `users_sid`, `person_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'X', '2021-07-26 16:47:48', '2021-09-20 16:48:10'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'X', '2021-07-26 16:47:56', '2021-09-20 16:48:07'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'X', '2021-07-26 16:48:02', '2021-09-20 16:48:05'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'X', '2021-09-21 15:56:57', '2021-09-23 10:06:59'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'A', '2021-09-23 11:09:57', '2021-09-23 11:09:57');

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

--
-- Estructura Stand-in para la vista `hye_person_phone_number`
-- (Véase abajo para la vista actual)
--
CREATE TABLE `hye_person_phone_number` (
`full_name` varchar(126)
,`phone_number` varchar(200)
,`intern` varchar(75)
,`cargo` varchar(250)
,`area` varchar(250)
);

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

--
-- Estructura de tabla para la tabla `hye_ticket`
--

CREATE TABLE `hye_ticket` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `category_id` int(11) NOT NULL COMMENT 'Related to catalogs code',
  `subcategory_id` int(11) NOT NULL COMMENT 'Related to catalogs code and code dependency',
  `priority_id` int(11) NOT NULL COMMENT 'Related to catalogs code',
  `long_description` longtext NOT NULL COMMENT 'Plain text',
  `attachments` text COMMENT 'Plain text, many files separated by commas ',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `hye_ticket` (`id`, `users_sid`, `category_id`, `subcategory_id`, `priority_id`, `long_description`, `attachments`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 1, 3, '<p>Ahora!</p>', NULL, 'A', '2021-09-20 16:23:54', '2021-09-20 16:23:54'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 1, 3, '<p>Ahora!</p>', NULL, 'A', '2021-09-21 14:22:07', '2021-09-21 14:22:07'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 1, 2, '<p>No es tan urgente</p>', NULL, 'A', '2021-09-21 14:46:39', '2021-09-21 14:46:39'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 1, 3, '<p>Ahora!</p>', NULL, 'A', '2021-09-21 14:53:54', '2021-09-21 14:53:54'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 2, 3, '<p>Ahora por favor!</p>', NULL, 'A', '2021-09-21 15:57:20', '2021-09-21 15:57:20'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 2, 3, '<h2><strong>#0.4.200 Join the user management from helpdesk to core</strong></h2><p>&nbsp;</p>', NULL, 'X', '2021-09-21 17:08:14', '2021-09-21 17:10:26'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 2, 3, '<p>Ahora por favor!</p>', NULL, 'A', '2021-09-21 17:10:37', '2021-09-21 17:10:37'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 3, 3, '<p>Ahora!!!!</p>', NULL, 'A', '2021-09-21 19:23:04', '2021-09-21 19:23:04');

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

--
-- Estructura de tabla para la tabla `hye_ticket_assigned`
--

CREATE TABLE `hye_ticket_assigned` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users',
  `ticket_id` int(11) NOT NULL COMMENT 'Related to ticket table',
  `person_id` int(11) NOT NULL COMMENT 'Person table',
  `estimated_time` decimal(10,2) NOT NULL COMMENT 'Number of estimated time',
  `time_measurement_id` int(11) NOT NULL COMMENT 'Related to catalogs table',
  `designed_by` varchar(50) DEFAULT NULL COMMENT 'Full name of the person who designed the ticket',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `hye_ticket_assigned` (`id`, `users_sid`, `ticket_id`, `person_id`, `estimated_time`, `time_measurement_id`, `designed_by`, `status`, `created_at`, `updated_at`) VALUES
(1, 'e745a400-8f5b-4fe6-9fd4-d5d78d494ca4', 5, 2, '1.00', 1, 'TIME RAIDER 0.1-alpha', 'A', '2021-09-21 15:57:20', '2021-09-21 15:57:20'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 2, '1.00', 1, 'Lenin Aparicio', 'A', '2021-09-21 16:36:30', '2021-09-21 16:36:30'),
(3, 'e745a400-8f5b-4fe6-9fd4-d5d78d494ca4', 7, 2, '1.00', 1, 'TIME RAIDER 0.1-alpha', 'A', '2021-09-21 17:10:37', '2021-09-21 17:10:37'),
(4, 'e745a400-8f5b-4fe6-9fd4-d5d78d494ca4', 8, 2, '1.00', 1, 'TIME RAIDER 0.1-alpha', 'A', '2021-09-21 19:23:04', '2021-09-21 19:23:04');

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

--
-- Estructura de tabla para la tabla `hye_ticket_feedback`
--

CREATE TABLE `hye_ticket_feedback` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `ticket_id` int(11) NOT NULL COMMENT 'Related to ticket table',
  `feedback_comments` text NOT NULL COMMENT 'Feedback comments',
  `feedback_attachments` text COMMENT 'This field could be null',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `hye_ticket_feedback` (`id`, `users_sid`, `ticket_id`, `feedback_comments`, `feedback_attachments`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, '<p>Comentario positivo</p>', NULL, 'A', '2021-09-21 17:02:14', '2021-09-21 17:02:14');

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

--
-- Estructura de tabla para la tabla `hye_ticket_finished`
--

CREATE TABLE `hye_ticket_finished` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `ticket_id` int(11) NOT NULL COMMENT 'Related to ticket table',
  `comments` text COMMENT 'This field could be null',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `hye_ticket_finished` (`id`, `users_sid`, `ticket_id`, `comments`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, NULL, 'A', '2021-09-21 16:46:16', '2021-09-21 16:46:16');

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

--
-- Estructura de tabla para la tabla `hye_ticket_progress`
--

CREATE TABLE `hye_ticket_progress` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `ticket_id` int(11) NOT NULL COMMENT 'Related to ticket table',
  `ticket_status_id` int(11) NOT NULL COMMENT 'Related to catalogs table',
  `used_time` decimal(10,2) DEFAULT NULL COMMENT 'Requires a number data',
  `time_measurement_id` int(11) DEFAULT NULL COMMENT 'Related to catalogs table',
  `ticket_comments` text COMMENT 'This field could be null',
  `ticket_attachments` text COMMENT 'This field could be null',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `hye_ticket_progress` (`id`, `users_sid`, `ticket_id`, `ticket_status_id`, `used_time`, `time_measurement_id`, `ticket_comments`, `ticket_attachments`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 1, NULL, NULL, NULL, NULL, 'A', '2021-09-21 16:40:26', '2021-09-21 16:40:26'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 1, NULL, NULL, NULL, NULL, 'A', '2021-09-21 19:19:37', '2021-09-21 19:19:37');

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

--
-- Estructura Stand-in para la vista `hye_ticket_resume`
-- (Véase abajo para la vista actual)
--
CREATE TABLE `hye_ticket_resume` (
`id` int(11)
,`created_at` datetime
,`category_id` int(11)
,`subcategory_id` int(11)
,`priority_id` int(11)
,`category` varchar(250)
,`subcategory` varchar(250)
,`priority` varchar(250)
);

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

--
-- Estructura de tabla para la tabla `hye_ticket_schedule`
--

CREATE TABLE `hye_ticket_schedule` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `ticket_id` int(11) NOT NULL COMMENT 'Related to ticket table',
  `date_schedule` date NOT NULL,
  `time_schedule` time 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=utf8;

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

--
-- Estructura de tabla para la tabla `hye_watchdog`
--

CREATE TABLE `hye_watchdog` (
  `id` int(11) NOT NULL COMMENT 'Primary Key: Unique watchdog event ID.',
  `users_sid` varchar(50) DEFAULT NULL COMMENT 'The users.uid of the user who triggered the event.',
  `type` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Type of log message, for example "user" or "page not found."',
  `message` longtext NOT NULL COMMENT 'Text of log message to be passed into the t() function.',
  `variables` longblob COMMENT 'Serialized array of variables that match the message string and that is passed into the t() function.',
  `severity` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The severity level of the event. ranges from 0 (Emergency) to 7 (Debug)',
  `link` text COMMENT 'Link to view the result of the event.',
  `location` text NOT NULL COMMENT 'URL of the origin of the event.',
  `referer` text COMMENT 'URL of referring page.',
  `hostname` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Hostname of the user who triggered the event.',
  `created_at` datetime DEFAULT NULL COMMENT 'When the user were created',
  `updated_at` datetime DEFAULT NULL COMMENT 'When the user were updated'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Table that contains logs of all system events.';

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

--
-- Estructura para la vista `hye_person_phone_number`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `hye_person_phone_number`  AS SELECT concat(`p`.`first_name`,' ',`p`.`last_name`) AS `full_name`, `p`.`phone_number` AS `phone_number`, `p`.`intern` AS `intern`, `c`.`label` AS `cargo`, `a`.`label` AS `area` FROM ((`core_help_desk_person` `p` join `hye_catalog_items` `c`) join `hye_catalog_items` `a`) WHERE ((`p`.`status` = 'A') AND (`c`.`status` = 'A') AND (`a`.`status` = 'A') AND (`p`.`cargo_id` = `c`.`value`) AND (`c`.`catalog_code` = 'CARGO') AND (`p`.`area_id` = `a`.`value`) AND (`a`.`catalog_code` = 'AREA')) ;

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

--
-- Estructura para la vista `hye_ticket_resume`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `hye_ticket_resume`  AS SELECT `t`.`id` AS `id`, `t`.`created_at` AS `created_at`, `t`.`category_id` AS `category_id`, `t`.`subcategory_id` AS `subcategory_id`, `t`.`priority_id` AS `priority_id`, `cat`.`label` AS `category`, `subcat`.`label` AS `subcategory`, `prio`.`label` AS `priority` FROM (((`hye_ticket` `t` join `hye_catalog_items` `cat`) join `hye_catalog_items` `subcat`) join `hye_catalog_items` `prio`) WHERE ((`t`.`status` = 'A') AND (`t`.`category_id` = `cat`.`value`) AND (`cat`.`catalog_code` = 'CATEGORIA') AND (`cat`.`catalog_code_dep` = 0) AND (`cat`.`catalog_id_dep` = 0) AND (`cat`.`lang` = 'es') AND (`t`.`subcategory_id` = `subcat`.`value`) AND (`subcat`.`catalog_code` = 'CATEGORIA') AND (`subcat`.`catalog_code_dep` = 'CATEGORIA') AND (`subcat`.`catalog_id_dep` = `t`.`category_id`) AND (`subcat`.`lang` = 'es') AND (`t`.`priority_id` = `prio`.`value`) AND (`prio`.`catalog_code` = 'PRIORIDAD') AND (`prio`.`catalog_code_dep` = 0) AND (`prio`.`catalog_id_dep` = 0) AND (`prio`.`lang` = 'es')) ORDER BY `t`.`id` ASC ;

--
-- Índices para tablas volcadas
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `hye_catalog_items`
--
ALTER TABLE `hye_catalog_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT de la tabla `hye_person_elegible`
--
ALTER TABLE `hye_person_elegible`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `hye_ticket`
--
ALTER TABLE `hye_ticket`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de la tabla `hye_ticket_assigned`
--
ALTER TABLE `hye_ticket_assigned`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `hye_ticket_feedback`
--
ALTER TABLE `hye_ticket_feedback`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `hye_ticket_finished`
--
ALTER TABLE `hye_ticket_finished`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `hye_ticket_progress`
--
ALTER TABLE `hye_ticket_progress`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `hye_ticket_schedule`
--
ALTER TABLE `hye_ticket_schedule`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `hye_watchdog`
--
ALTER TABLE `hye_watchdog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.';
COMMIT;

