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

START TRANSACTION;





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

INSERT INTO `core_hotel_branch_office` (`relative`, `users_sid`, `license_server_id`, `global_system_id`, `enterprise`, `branch_office`, `global_countries_id`, `global_cities_id`, `exp`, `status`, `created_at`, `updated_at`) VALUES
('5a8a131f-fc34-4f6c-90a9-3d9a7613d9e1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 7, '32 BITS', 'Sucursal hotel', 27, 9848, '2026-12-31', 'A', '2021-08-22 10:02:58', '2021-08-22 10:02:58'),
('9f25c5f0-dcdf-4beb-bb0a-ed64a2da4d10', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 9, 'Ministerio de hidrocarburos y energías', 'Oficina central', 27, 9876, '2026-12-31', 'A', '2021-09-14 11:13:26', '2021-09-14 11:13:26'),
('d2e12937-1250-46bd-9654-8716835741ff', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 10, 'Ministerio de Hidrocarburos y Energías', 'Oficina central', 27, 9876, '2026-12-31', 'A', '2021-09-22 10:04:58', '2021-09-22 10:04:58'),
('d408ca98-cd00-4d66-84ea-7ef5b7469d96', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 3, '32 BITS', 'Sucursal 1', 27, 9848, '2026-12-31', 'X', '2021-08-19 09:38:59', '2021-08-19 09:38:59'),
('d499ab66-9842-4244-a27e-06e916ad2695', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 8, '32 BITS', 'Sucursal clientes', 27, 9848, '2026-12-31', 'X', '2021-08-22 10:03:20', '2021-08-22 10:03:20'),
('edf361f4-a4ca-4a9d-92be-cac4c591c78e', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 2, '32 BITS', 'Sucursal servicios', 27, 9876, '2026-12-31', 'X', '2021-08-22 10:02:31', '2021-08-22 10:02:31');



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

INSERT INTO `core_hotel_dosage` (`id`, `users_sid`, `global_branch_office_id`, `nit`, `autorizacion`, `inicio`, `limite`, `llave`, `rubro`, `leyenda`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'd408ca98-cd00-4d66-84ea-7ef5b7469d96', '4807414019', '369401600011766', '2020-08-24', '2021-02-26', 'JUplXFYqKHFcS1RKRm1TTCQ9SD0rZ0BdamZ2QU5BakFtUzZfayNNOWgrKU5lYzNDMnFFWGtnJSpCLTczVlc4QQ==', 'Desarrollo de Sistemas, Servicios informáticos en general, compra y venta de equipos informáticos.', 'Ley N° 453: Tienes derecho a recibir información sobre las características y contenidos de los productos que consumes.', 'A', '2020-08-25 10:48:51', '2020-08-25 13:17:08'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'd408ca98-cd00-4d66-84ea-7ef5b7469d96', '4807414019', '3216549876565', '2021-08-20', '2022-02-22', 'i4y2t34iyu23t4iu2y3t4iu2y34ti2yu34it23u42', 'Desarrollo de Sistemas, Servicios informáticos en general, compra y venta de equipos informáticos.', 'Ley N° 453: Tienes derecho a recibir información sobre las características y contenidos de los productos que consumes.', 'A', '2021-08-20 13:54:57', '2021-08-20 14:10:22');



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

INSERT INTO `core_hotel_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 `hotel_booking`
--

CREATE TABLE `hotel_booking` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT 'related to branch office table',
  `hotel_room_id` int(11) NOT NULL COMMENT 'related to hotel room table',
  `since` date NOT NULL,
  `until` date NOT NULL,
  `type` enum('R','O') NOT NULL DEFAULT 'R',
  `reserved_fullname` varchar(250) NOT NULL,
  `cellphone_number` varchar(250) NOT NULL,
  `pickup_on` int(11) NOT NULL COMMENT 'related to catalogs items table',
  `adults` int(11) NOT NULL COMMENT 'how many adults',
  `kids` int(11) DEFAULT NULL COMMENT '0-17 years',
  `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=latin1;

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

--
-- Estructura de tabla para la tabla `hotel_catalog_items`
--

CREATE TABLE `hotel_catalog_items` (
  `id` int(11) NOT NULL,
  `catalogs_id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `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;

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

--
-- Estructura de tabla para la tabla `hotel_checkout`
--

CREATE TABLE `hotel_checkout` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table ',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to hotel table ',
  `hotel_sell_id` int(11) NOT NULL COMMENT 'related to hotel sell table',
  `hotel_booking_id` varchar(250) NOT NULL COMMENT 'Multiple hotel booking related',
  `quantity` decimal(10,2) DEFAULT NULL,
  `measurement_id` int(11) NOT NULL COMMENT 'Related to catalogs items',
  `short_description` varchar(250) DEFAULT NULL,
  `subtotal` decimal(10,4) NOT NULL,
  `currency_id` int(11) 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=latin1;

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

--
-- Estructura de tabla para la tabla `hotel_client`
--

CREATE TABLE `hotel_client` (
  `id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to hotel table',
  `hotel_booking_id` int(11) NOT NULL COMMENT 'booking table',
  `first_name` varchar(250) NOT NULL,
  `middle_name` varchar(250) DEFAULT NULL COMMENT 'could be null',
  `last_name` varchar(250) NOT NULL,
  `nacionality_id` int(11) NOT NULL COMMENT 'related to countries table',
  `arrives_from` int(11) NOT NULL COMMENT 'related to countries table',
  `document_type` int(11) NOT NULL COMMENT 'related to catalogs items',
  `document_number` varchar(250) NOT NULL,
  `room_owner` enum('Y','N') NOT NULL DEFAULT 'N',
  `vip_guest` enum('Y','N') NOT NULL DEFAULT 'N',
  `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;

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

--
-- Estructura de tabla para la tabla `hotel_dosage`
--

CREATE TABLE `hotel_dosage` (
  `id` int(11) 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',
  `global_dosage_id` int(11) NOT NULL COMMENT 'related to global dosage 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=latin1;

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

--
-- Estructura de tabla para la tabla `hotel_enterprise`
--

CREATE TABLE `hotel_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 global system',
  `fullname` varchar(250) NOT NULL,
  `logo` varchar(200) DEFAULT NULL,
  `owner` varchar(200) DEFAULT NULL,
  `country_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `address` text NOT NULL,
  `hotel_description` longtext,
  `hotel_photos` text,
  `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=latin1;

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

--
-- Estructura de tabla para la tabla `hotel_kind`
--

CREATE TABLE `hotel_kind` (
  `id` int(11) 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 id',
  `kind` varchar(250) NOT NULL,
  `capacity_id` int(11) NOT NULL COMMENT 'related to catalogs items',
  `pricetag` decimal(10,4) NOT NULL,
  `currency_id` int(11) 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=latin1;

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

--
-- Estructura de tabla para la tabla `hotel_room`
--

CREATE TABLE `hotel_room` (
  `id` int(11) 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 id',
  `block_id` int(11) NOT NULL COMMENT 'related to catalogs items',
  `floor_id` int(11) NOT NULL COMMENT 'related to catalogs items',
  `room` varchar(50) NOT NULL,
  `beds` int(11) NOT NULL DEFAULT '1',
  `room_description` text,
  `kind_id` int(11) NOT NULL COMMENT 'related to catalogs items',
  `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;

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

--
-- Estructura de tabla para la tabla `hotel_sell`
--

CREATE TABLE `hotel_sell` (
  `id` int(11) 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 \r\n table',
  `hotel_date` date NOT NULL,
  `datetime_checkout` datetime NOT NULL,
  `fullname` varchar(250) NOT NULL,
  `nit` varchar(50) DEFAULT NULL,
  `total` decimal(10,4) NOT NULL,
  `currency_id` int(11) 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=latin1;

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

--
-- Estructura de tabla para la tabla `hotel_watchdog`
--

CREATE TABLE `hotel_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.',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `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.';

--
-- Índices para tablas volcadas
--

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

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

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

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

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

--
-- Indices de la tabla `hotel_enterprise`
--
ALTER TABLE `hotel_enterprise`
  ADD PRIMARY KEY (`relative`);

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

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

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

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

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

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

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

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

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

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

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

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

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

