-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 10-08-2023 a las 14:30:10
-- Versión del servidor: 10.4.28-MariaDB-cll-lve
-- Versión de PHP: 7.3.33

START TRANSACTION;



--
-- Base de datos: `beeinsur_beecms`
--

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

--
-- Estructura de tabla para la tabla `ads`
--

CREATE TABLE `ads` (
  `id_ads` int(11) NOT NULL,
  `name_ads` varchar(100) NOT NULL,
  `image_ads` varchar(100) NOT NULL,
  `description_ads` text NOT NULL,
  `link_ads` varchar(100) NOT NULL,
  `id_section` int(11) NOT NULL,
  `click_ads` int(11) NOT NULL DEFAULT 0,
  `id_status` int(11) NOT NULL DEFAULT 1,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `advisers`
--

CREATE TABLE `advisers` (
  `id_adviser` int(11) NOT NULL,
  `id_agency` int(11) NOT NULL,
  `code_ibo` int(11) DEFAULT NULL,
  `name_adviser` varchar(100) NOT NULL,
  `surname_adviser` varchar(100) NOT NULL,
  `email_adviser` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT 1,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `pass_adviser` text DEFAULT NULL,
  `token` text DEFAULT NULL,
  `token_adviser` text DEFAULT NULL,
  `sesion_token` varchar(100) DEFAULT NULL,
  `date_sesion` date DEFAULT NULL,
  `login_token` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `advisers` (`id_adviser`, `id_agency`, `code_ibo`, `name_adviser`, `surname_adviser`, `email_adviser`, `id_status`, `id_user`, `create_date`, `pass_adviser`, `token`, `token_adviser`, `sesion_token`, `date_sesion`, `login_token`) VALUES
(4, 16, NULL, 'Nestor', 'Caballero', 'caballero.nestor.10@gmail.com', 1, 11, '2022-02-24 11:54:17', '$2y$12$CyckMUZWYegWQcXfSlgZJ.DQ4CFmMVqB8brLYOa9lTfRwzZXK2Aje', '8f4435e82208651cb633a7e7c6e5acd9', '$2y$12$KWOAW7CJVTB5ndrj5i6EpOKxRYbMq2zJbrY2Osu3xdOVVcPOu5KRq', '66525fabe15a1b78c2a9d392690695bf', '2022-08-30', NULL),
(7, 16, NULL, 'Yoward', 'Diaz', 'yoward05@gmail.com', 1, 16, '2022-04-05 17:05:36', '$2y$12$dnVUgDCdHea4yApQllemO.aYHRe.PSS8kcj2LWJ0TkNUfcny2EF5a', '04eb79e86d40bf503d681117a8dde433', '$2y$12$.C79rlbxZ07GGLml0Jw26O0i1tMp0XEDxVBXX9fdn2JHn5kGbFPUq', '315e62950638e21c7bb11827a64952da', '2022-08-18', NULL),
(8, 19, NULL, 'Tivisay Haidee', 'Hernandez Leon', 'tivisayhernandez@hotmail.com', 1, 19, '2022-03-22 08:29:54', '$2y$12$MHWUKBnoOed0Fsto93Z60eJbrXUQRVHo5GW.CH1am53Tpo.WeQLUC', NULL, NULL, NULL, NULL, NULL),
(9, 18, NULL, 'Anilus', 'Mata Mata', 'aniluzmata18@gmail.com', 1, 18, '2022-08-19 09:53:38', '$2y$12$2JxtRHmNbvByhvxRGhaeU.4e9W3.gzvjB880/r.c1tUrzHHxXhiSq', '35cac02342319e3729ed236755668dad', '$2y$12$qy5ZiNipdoZyF0XrM9wkJ.rFgYZK/r1dyRVPlFNB9Wld3JpZZ7itq', 'b14efa6746d5ee632992ab0f7b14710a', '2022-08-19', NULL),
(11, 18, NULL, 'Maria Elisa', 'Ortiz Majano', 'mariaelisaortiz@gmail.com', 1, 18, '2022-08-19 09:54:14', '$2y$12$SBPcTyKLJKxaCoirCjiQfOUKm6JKrmJfVQbV8j6Ww1Ef8.LRDJXMG', NULL, NULL, NULL, NULL, NULL),
(12, 18, NULL, 'Marianela Josefina', 'Velasquez Delgado', 'mnelavd@gmail.com', 1, 18, '2022-08-19 09:54:38', '$2y$12$MVET0qkqTqu/9uSuKJKwy.dEE4uFz7POQW0P8ItWb2pATfdfN7VIa', 'ad2f8dd749b841db808a32b9e39a58d4', '$2y$12$sz4NtYReoaBEJh8TsEBMMekMav4x7R7J7PHvNBhKY.ZwgWaAFIj62', '082dfbf0fcc23903a10ad67a7574bd72', '2022-05-29', NULL),
(13, 18, NULL, 'Antonio Rafael', 'Velasquez Delgado', 'anvede@gmail.com', 1, 18, '2022-08-19 09:54:50', '$2y$12$o5bfPcCwXYGaH3YVKf412uWxZ72j46m.5WiVQkkbDY0Sfgc8TGdMu', '3cd8dfda94e1ed7a6377d7526c9819f2', '$2y$12$xDlvlLuivpBGxtwqnpPxmex.F5Ojtf.U6nwwdGpVTwg08.FkL46Eq', 'b390a0152cc00df02fc2555b93986b0b', '2022-03-22', NULL),
(14, 18, NULL, 'Arisbel del Valle', 'Ferreiro Rodriguez', 'aferreiro.seguros@gmail.com', 1, 18, '2022-08-19 09:55:01', '$2y$12$s7.PyUGpQKJsi/LCntfmz.z.CPPTNben8BQTmvnBi0F/VbcSv6A6S', NULL, NULL, NULL, NULL, NULL),
(16, 26, NULL, 'ARNEIDA', 'INSURANCE', 'arneida.rodriguez.73@gmail.com', 1, 26, '2022-10-04 11:53:36', '$2y$12$XyNmkQGEJQeq9uTqfcmfy.ie69TFdZmaGM1YiK4oGuSyekWQldf7K', 'cc43bb44af41d5bfcc9e3de110c158b2', '$2y$12$ZluxeOqc6Xvxgh1ANUjDiuBvE5XzrQECpjMkhBSVEu2AQrChLLFum', 'f04da3807679782fc07b83338561a8bd', '2022-10-03', NULL),
(17, 26, NULL, 'MARIA GRACIA', 'G INSURANCE', 'mgarcia@serviciosintegralesapis.com.ve', 1, 26, '2022-10-04 11:53:50', '$2y$12$vN6q33qsK8VH039HJpERoudmvvLgzJDhlzdkPzTWjaGjFQn9U78Aq', '212e4dcf903e8c102fb0545b13d42991', '$2y$12$5d/dJrhofnlhabp7GUFiJeb.PAElsP95BUHOiU04wxvYJqhTO/uGe', 'b4d8925cde9a4a6798a98cdceaa21ec5', '2022-09-13', NULL),
(18, 16, NULL, 'Enrique', 'Diaz', 'diazbasket5@hotmail.com', 1, 16, '2022-04-12 12:28:13', '$2y$12$P3KQtKcP6hP2BK4zJBrKCuc5PdkQDPPZYx94XYwiMAuq37vqzWviy', 'aea37491744b2d1e8e016ea50cede453', '$2y$12$eaOPhdWaDx9IwSbdgW0zhOIeBJ3TIze8LUEMKZyRHOkQpYez59wOC', '7e84a4e6b946790d28d14d68384790a4', '2022-04-12', NULL),
(19, 44, NULL, 'José Rafael ', 'Hernández Revilla ', 'jhernandezrevilla@gmail.com', 1, 44, '2022-04-13 16:34:18', '$2y$12$6l7cyLVyz4IbMfS2kUqyIuFobCJafOrjXELWfsV2DSwtQwHJ4G6pK', 'e4c2a979f8eda55ea79872aaa5090ef3', '$2y$12$qqurJ.Mq3VtnHDwq7idCoOqQujkYl.HBX6rZFxI.uxUvkNI0VZcBG', 'a9995c9aa55cd89e1d50367f148e52d9', '2022-07-10', NULL),
(20, 50, NULL, 'LUIS ENRIQUE', 'ASCANIO RUIZ', 'learcas21@gmail.com', 1, 50, '2022-04-18 15:25:44', '$2y$12$naNw1IKqUFgFeq6WmYOy9OlV0NEsvC07WixsZE90.9MQ1kAm97hUW', '6fd74b40c23f545f5af21caf577d9a78', '$2y$12$7.z.3rKFSWb7X0U5cOa5t.E2uI9guN3Oh2HiqV1goq4ibLA.QvAFi', '7c2d8c030eb36b9791ec4a7c5773e537', '2022-06-07', NULL),
(21, 48, NULL, 'DANIELA', 'LOPEZ', 'danielalopezvirla@gmail.com', 1, 48, '2022-10-13 18:28:13', '$2y$12$bGnEZtEYViTAtUm/IDUalePYjo9oxRJTfo.Tl3fnroCH.9uBgx5Y2', '8c54e414b93f66d568fc038891b15b49', '$2y$12$7w2OcJvH/N1xVcXX2Mqaxunt/eQOPZxAKJX6Yr2pCekEjM1vSTqom', 'fa4fabd4374afbe2c27d016f0047dc7e', '2022-04-18', NULL),
(22, 48, NULL, 'NORITZA', 'ZABALA', 'comercialmcbohc@gmail.com', 1, 48, '2023-02-20 11:47:37', '$2y$12$QB5onO5wMjBZFNuwyZpHYeu/DmaTsBvwLD7D98oEsS/8afHfi7fYm', NULL, NULL, NULL, NULL, NULL),
(23, 41, NULL, 'Maribell ', 'Sousa', 'maribells@gmail.com', 1, 41, '2022-07-19 20:36:57', '$2y$12$r0Bd3JoAbXafpr3bZWNAm.Q/VLuwzDT1kc4x6LMtIVqONX056oShG', '068dbb387a2d1eed3c4c4a8882888d54', '$2y$12$eifmp28GMXBlj0ICkvhmf.iP/469UBDkSv3whTvH7vpTatH5WsZ92', '67a5f4598c526b6e68213b10cea20964', '2022-05-01', NULL),
(24, 48, NULL, 'ANGELICA ', 'PERDOMO', 'angelica.perdomo.ap@gmail.com', 1, 48, '2022-10-13 19:55:43', '$2y$12$60BTAe6N5TMhhZUTy6O83uyFlnGx.EnVMo8Yf83cEFCSZ2rTKV5Di', '2af92996ff857c5c97d6250a110ee07c', '$2y$12$vh64P/3wh1c6Bo7uqL4ivuRAMlpGz.pvJlO9WuLMPueVKp/CCXZ4q', '56d92e1da59103c0558433ff6b8408e1', '2022-04-20', NULL),
(25, 48, NULL, 'ASTRID CAROLINA', 'LOPEZ', 'astridclopez1@gmail.com', 1, 48, '2022-10-13 19:56:36', '$2y$12$NZFHPrjt4jc3w707SvECGevURcUMo1cIfa4tvgLuzfvRnbNOxgVIK', NULL, NULL, NULL, NULL, NULL),
(26, 48, NULL, 'JANETH', 'DUARTE', 'janethduarte_68@hotmail.com', 1, 48, '2022-10-13 19:56:58', '$2y$12$PX2qCMkfh4XviTh7BAGatuLHuwN2TGyrAiPUCK27xMb64ui/sRe7m', NULL, NULL, NULL, NULL, NULL),
(27, 48, NULL, 'GUILLERMO ', 'TEXIER', 'texiercorredores@hotmail.com', 1, 48, '2022-10-13 19:57:19', '$2y$12$zxZYzH/zXg.MrI.5AfGt4efRJq0ZsI2lejT5jhYiFpULRl/Y7CEj6', NULL, NULL, NULL, NULL, NULL),
(28, 48, NULL, 'LUIS ALFREDO ', 'GARCIA', 'luisgarcia.c.s@gmail.com', 1, 48, '2022-10-13 19:59:03', '$2y$12$QBgIZILrbDo3zoZcdxQgm.NkOgqtUMTteRpGacHWiCWzvWguRxkVi', NULL, NULL, NULL, NULL, NULL),
(29, 53, NULL, 'Francys', 'Newman', 'francysnewman@gmail.com', 1, 53, '2022-04-20 11:56:14', '$2y$12$ax6YshC6Pe6UwIMq.lLImuFlUPqC2oZ7pkr2qTnYVRssS01IMd/GK', NULL, NULL, NULL, NULL, NULL),
(30, 53, NULL, 'winifer', 'Pereira', 'winiferpereira@gmail.com', 1, 53, '2022-04-20 11:59:40', '$2y$12$qpy21FBMo18Sh03c8gt04.WZjT4kWF1L/.AhdDfs7DlsZts2GW4Z2', 'a883cbf3692cc89919f7cbdd2502a9aa', '$2y$12$GIDUwKn9Dkxz.RVI7qzDR.37k7wNAZeRKUKcI.qzXzoknVOqrxuI2', '5d5f9960b748ac23daa9bcd00ce9127e', '2022-04-20', NULL),
(32, 53, NULL, 'Williandry', 'Pereira', 'williandrypereira@gmail.com', 1, 53, '2022-04-21 11:51:26', '$2y$12$Kql.wdyzFMiFWfa15NgT9eD7Go9iJMGQUpT9ULjpnc2fQ6qCHlQoG', '8207f48d2329e71a8a3f0a075bb6a113', '$2y$12$FVa0ftjIOJe5tDtqBkQoKOGHugBDIfKe2OQuVGFCwsGpIbVrSBJQi', '3d1201d8ae043c5d2ad9bd00c48e2ef1', '2022-04-21', NULL),
(34, 41, NULL, 'Felipe ', 'Uncein', 'felipeu@gmail.com', 1, 41, '2022-07-19 20:36:50', '$2y$12$XnFXLLtleYLlcV9AtqJvw.vLom8zv9GIwyZDRsVwNCsmiHNNX8raC', '643ebe525ff92c96c635b3633f9b2eae', '$2y$12$rTD1Kc76wpBfsu5YzGqAf.GwLpOpUQymtQA02JcNKI5OBfjGDP95a', 'e6d697e30dd3e940494aadffd82ad2bf', '2022-04-30', NULL),
(35, 50, NULL, 'RAFAEL JESUS', 'GUERRERO ANGULO', 'rafaelgchn@hotmail.com', 1, 50, '2022-04-25 08:58:44', '$2y$12$cfTfN71wdbq2F1qzI4FKf.WjtydcSvNAZ9lXsblG0G0xU0CKjki7W', NULL, NULL, NULL, NULL, NULL),
(36, 61, NULL, 'Jenny', 'Aponte', 'apontejs@gmail.com', 1, 61, '2022-04-25 10:51:50', '$2y$12$naNxjIs4f0xf4sxh.w/Aw.qAOEXG0YnxyQoDwa4aK7iPHMstC5Vgy', NULL, NULL, NULL, NULL, NULL),
(37, 61, NULL, 'Linda Andreina', 'Nuñez Gomez', 'lindagomezna@gmail.com', 1, 61, '2022-04-25 10:52:47', '$2y$12$RrnsUucreT6fp5RjDs/DK.IbKKbeaIIO1MuYYD7aG3vGNla2bPLUO', NULL, NULL, NULL, NULL, NULL),
(38, 61, NULL, 'Maria E', 'Portillo', 'portillomariu@gmail.com', 1, 61, '2022-04-25 10:53:55', '$2y$12$z3TlDJRI7rLtF1esWR30oumnkUz3oujxg8AsBCbTxqw4rk3pviZja', NULL, NULL, NULL, NULL, NULL),
(40, 61, NULL, 'Walter Junior', 'Fernandez Suarez', 'walmediamcbo@gmail.com', 1, 61, '2022-04-25 10:57:09', '$2y$12$Uzsi2/mRRXcs79KpUWa8AuVn2YXBk7VhjbAFrUNBoPP72ax7L0Y7a', 'adbe0adbe151c60cc11dddd52f72a9ba', '$2y$12$H16y7J5a0D4sz12OGOBaC.8DsVXwVqAN9sjTQ7p3W9JL9VZIaYNte', '055427a637c55e6255b8ca100b4c457d', '2022-04-27', NULL),
(41, 44, NULL, 'PABLO ', 'VELASQUEZ', 'segurosvelasquez@gmail.com', 1, 44, '2022-04-26 11:51:41', '$2y$12$7Qw3C0RSa8suBbk63aAWI.mR1y.RawA1VOJNwi0urUpeaXq8jDk.O', '1671a3d3db585c2b49aa3b972dacdcde', '$2y$12$j2mww82fK8K4oLz.8f01HuRMnSAQ.i3iKLLkuz0cT32msrSxRL8z6', '141ef28c7aac820da31885fc0bb30813', '2022-05-02', NULL),
(42, 63, NULL, 'William ', 'Morillo Marín', 'willianmorillo41@gmail.com', 1, 63, '2022-04-27 12:46:59', '$2y$12$gqob4.cvJw8g7TD6VJmiFuuOF4rU8yuC3hajKHFy.lY3pMkuAoav6', NULL, NULL, NULL, NULL, NULL),
(43, 61, NULL, 'Rita ', 'Ferrer', 'jackieferreru06@gmail.com', 1, 61, '2022-04-27 15:37:49', '$2y$12$GRpDG1whZ1uHkGGyiCTi4.DZBPoH0aYusms3SWvH9bxTYKSrGdSGG', NULL, NULL, NULL, NULL, NULL),
(44, 60, NULL, 'Jairo Guillermo', 'Achique', 'jachique@gmail.com', 1, 60, '2022-04-27 17:08:04', '$2y$12$os/rRKrQUfIxJp.9Ds7ejus4rZ/PYYKm2MSTUPO4VP2oQT9iI6wF.', 'e81aae85372878a517bbc3eba434b6fa', '$2y$12$xgrHVKCHmbft/ar.gSxIbeRBr51JKdHs1gDnRJ.UE3p7L4ZUSLyuu', '0dcfe48f6dafd53a09c04673344ebb1a', '2022-06-30', NULL),
(45, 60, NULL, 'Jose Luis', 'Valera Perez', 'joseluisvalera71@gmail.com', 1, 60, '2022-04-27 17:16:16', '$2y$12$ji7g7m6kVFTg7Ub1I8CyTuZ4/QEUoEUQMzjeVEi4anwXvYFinTSeK', '17cb60ee4b7098457ed1b4dd50bbd7ec', '$2y$12$fCuGXhjB7Ms8JtBV..NJwe8IKeeEDwNg8oemjd.1xQJW.jg1tRgGe', '90d50b9f9335f298f47f115b0ed9a0ad', '2022-05-06', NULL),
(46, 64, NULL, 'GUSTAVO', 'AÑEZ', 'gustavoanes28@gmail.com', 1, 64, '2023-04-02 16:18:18', '$2y$12$fHwUa5DiNGeA0/fjwuXnVud8Lsk6UjfiFO7a3PAb2CswkBre1XwBy', 'aefd40ffcf04099abb136bc085c6a2ff', '$2y$12$2aJ/QhUp5CvUb9eM/KDsSu4tQy3/eRcwoPXsAqI.i8KoUls2GkYO.', '50a8530afa658d076b0b4be81c403ac1', '2022-05-14', NULL),
(47, 64, NULL, 'ENRIQUE ', 'LANDAETA', 'enjolandinsurance@gmail.com', 1, 64, '2023-04-02 16:18:30', '$2y$12$h4YO4RMpmQpAQ5ttztvpr.vLB8ALQ8KTfL89aqJiQIzogKoYXewFC', 'b14af01501e14a2a0467a586a19a3dc3', '$2y$12$kibtaigcS7cehPnwvBfJzOuuaS0NGNFvEtufwUiDEgzi9KXfSN5Qy', 'a04a5c3873d491e69785f42077d8224e', '2023-03-15', NULL),
(48, 64, NULL, 'ADRIAN ', 'COLLADO', 'colladolive@gmail.com', 1, 64, '2023-04-02 16:18:01', '$2y$12$Gb1aY2faEIBq4ASwL7jZOuEZEqi9ms7XSc6/lperruMUZfEUBalOO', '884e015886ced1c36b17f167896bb870', '$2y$12$iIBguh.hvuIfRQUFmOMIIeDEfmp3SKT7P2iTlmOrCcC9jzqQrYSSq', 'bb65c308dd129371c4bd82430c493a96', '2022-04-28', NULL),
(49, 64, NULL, 'CARLOS ', 'ZAMBRANO', 'zambranolopezseguro@gmail.com', 1, 64, '2023-04-02 16:19:00', '$2y$12$ZosfFeB4EVLWLEfNjKYWDOtuf7mQvt.VY2vK5Me5psBE5VcQdUOiu', '0b531f0e2261fba8c8a28601e7195290', '$2y$12$CQ3l.yXhbV1bLfHycM11iuZUp5H4EO3.OEUuu/2H57idyr6jauyje', '9c9de227aad154e896ca8556156c6bb4', '2022-05-08', NULL),
(50, 64, NULL, 'ALEXANDER DEL CARMEN', 'REDONDO ROMERO', 'arinversiones@gmail.com', 1, 64, '2022-04-28 15:08:58', '$2y$12$Tl4U6LvxVaUcB.A7vvKJH.DWpmwrSXIsRTXi9nd.ySG.RHwdSnXRG', '353cdfee0ba857ecab00e4fed253b71b', '$2y$12$4A8xyit2z77ClxtcWeGr7ewuW4ucK9YQMkvJEH9ngZNmd8lIeEEFm', '1545923a9cc86ac63a9f830303a36a9f', '2023-03-08', NULL),
(51, 64, NULL, 'CARMELO ENRIQUE', 'REDONDO ROMERO', 'credondo.seguros@gmail.com', 1, 64, '2022-04-28 15:09:38', '$2y$12$e4x8T2Wc/h8UB8wDCmrptuokhwl3syESRTf0K6AAV1PUQHBJCEyrS', '80cac23062938ebe7e70c2819943d436', '$2y$12$J.Id1WR96A8qqjJLa0SB5ukmEYTiNZrqpJ6McQr3QnhfRfVpR38ai', '9b8ab609037d2c1695cd114702aee472', '2022-08-02', NULL),
(52, 62, NULL, 'Maria Andreina', 'Villasmil', 'mvconsultores71@gmail.com', 1, 62, '2022-05-09 10:33:58', '$2y$12$0ikRYFIyoIeMhhJ4bOO5.Ogw0KrfF6FaOFmi21zAUIBOkQKAY/j56', '6414be68da246b01ec90fc887bd0c86d', '$2y$12$Ki1HswCiNpLi71IhJu5xuePKMerBvL7gVCuokghrrdHeiDtTaxGlS', '2ac0c35a51d81b5fa1dbde4a401eff57', '2022-04-29', NULL),
(54, 51, NULL, 'Laura', 'Mictil Freites', 'laura@paratiseguros.com', 1, 51, '2022-08-29 10:17:57', '$2y$12$IfgazrmhZK6Sxx9yquhTIuBN/ynktKuGrLrF7MG.UP7fVd1dUGifK', NULL, NULL, NULL, NULL, NULL),
(55, 19, NULL, 'MARIA EUGENIA', 'DEVIA GAVINI', 'MEDEVIAGAVINI@GMAIL.COM', 1, 19, '2022-05-02 11:00:08', '$2y$12$55qaCj1Tf0YiuZbNEdYDsu.RegqTuWVSNrNq7lTOggJNeYUj0IoT.', NULL, NULL, NULL, NULL, NULL),
(56, 19, NULL, 'ANGIE VARQUELINE', 'TORRES SERRANO', 'TORRESANGIE50@GMAIL.COM', 1, 19, '2022-05-02 11:03:57', '$2y$12$Q2mN6.4QA9giQ/tHePSouOBVlEoEQgCD8o0CkIBqo2Z03EocQf2vC', NULL, NULL, NULL, NULL, NULL),
(57, 51, NULL, 'Joao David ', 'Sousa De Sousa', 'jdavidsousa@gmail.com', 1, 51, '2022-08-29 10:18:12', '$2y$12$1lqRVGowvV1h7dTXkizFWezOi9q9ZF.AvmeNAiHXMKts1JYVsGwQm', 'ee867d45e21447b8bf11dbd5507abe94', '$2y$12$izDy1Ecm2yWmxRv2CCXqeO8QIGHkVTKhCGDjzr6QK7mVEc3EuCexO', 'c34f59af006c81a721635d3f071b4385', '2022-05-03', NULL),
(58, 51, NULL, 'Ricardo Antonio', 'Guzman', 'ricmar.ricardo@gmail.com', 1, 51, '2022-08-29 10:18:22', '$2y$12$trvEBJKxmtJzubqQRf62M.aRh3GvQmThZiiOfypvgZpB9CG7Ly/gO', '00fc88ecb2a191f06aa5da0166155ef9', '$2y$12$l1A3iNCcClKS0y/wJlv.mu4KGoGFgqfs7E9czcOJ5qYNIfPu8C1wi', '14f150c6e5d6f1359d532baaf89deff0', '2023-03-20', NULL),
(59, 20, NULL, 'Felipe', 'Uncein', 'fgseguros.asesores@gmail.com', 1, 20, '2022-05-06 11:35:31', '$2y$12$Nn2Kx5ZKGXU3qhKFgx/GguGoZgNUex9J9hGgpyF6MPoEgJrdxwviG', NULL, NULL, NULL, NULL, NULL),
(60, 51, NULL, 'Jutssel', 'Vera', 'jutsselvera@gmail.com', 1, 51, '2022-08-29 10:18:29', '$2y$12$3ikkC.wJs4MI7qdErCRzLO.Q83hzceBJ7D8FmhOYPMCRjckp1Wigu', 'b165e466f626bb8147566d4f46e33d27', '$2y$12$wJK4MwJjH3gfWyRBMo89Iu6QLdoy/TXOPcTvZkkUZau1xxC/mCCEy', '28de46dc7c766534c68be327868e1bbe', '2022-11-14', NULL),
(61, 63, NULL, 'Miguel', 'Figueredo', 'mfigueredo1@gmail.com', 1, 63, '2022-05-11 08:28:36', '$2y$12$c20Yhu49UiTu9FOFiqMm0uCL7HrlWQZgP5E2l2tUoJdkr0KaC9kga', NULL, NULL, NULL, NULL, NULL),
(62, 20, NULL, 'Fernando Jose', 'Romero Romero', 'fromerca@gmail.com', 1, 20, '2022-05-11 17:13:33', '$2y$12$KCCeloJL2IXthsD5NoX8xOkjec0qj7/20j.bT8lnyBh5lGVFHfGJe', '85374fbbbaec7cb9f5388d20ad876e2a', '$2y$12$JS93cDgW7aajOxQ1XWFnmusIlRZLCnYnOsYYWmQ3A8QQ5eiDOYsia', '8a0716a96567c2dee333dedc4cea39e5', '2022-05-16', NULL),
(63, 62, NULL, 'Esteban F.', 'Kalmanchey', 'efkalmanchey@gmail.com', 1, 62, '2022-05-12 12:15:16', '$2y$12$sIzo2mQ5M/ch/YKAibtv.uD6EwhmDYPV66hxQiAeeRQKcr1CCSGey', '389663d38727b5af3818f50f1f534dbe', '$2y$12$1KebQSW4hfywu5QsCP8Sr.K/bJUC1WFLdPhEcq9jjzqG46GRKuHX2', '76527b6af2ec82f2690b484c6f410948', '2022-05-12', NULL),
(65, 51, NULL, 'Nestor Emilio', 'Rincon Wolfschoon', 'nestoremilio1955@gmail.com', 1, 51, '2022-08-29 10:18:39', '$2y$12$o1tklHB071yrRI9yjBaE4ud7zw8TgFrHZJj.P85E208zxI3qp4VR2', NULL, NULL, NULL, NULL, NULL),
(66, 51, NULL, 'Juan Carlos', 'Perez Escalona', 'gestionalo007@gmail.com', 1, 51, '2022-08-29 10:18:45', '$2y$12$Urz4fGxQfu5NMkD27OfareDI4pf7Pw.BFmx6t5U0YBgoGDo66r2bq', 'a9f82a4883cffdfe5d3c24ac497be60f', '$2y$12$56NLc5ofA4i8KLIdnP8Dbe.43qQsjm9xEbtNtYyOLD1C4hNCYXTw.', '6ca42b2c53bf62a272f7b08e4ea5ae13', '2022-05-13', NULL),
(67, 67, NULL, 'Maria Isabel', 'Padron Canelon', 'ecmariapadroncanelon@gmail.com', 1, 67, '2022-05-13 13:03:41', '$2y$12$QGieVdF3uqxAH03865IF0uSCcJL3gzc0xbtDrXKgrID.XmKnTOJiO', '0194e85046b49ac123a847f7e3785e33', '$2y$12$sZw0hSVK7aXblitg9dXu0OKLKSRgd/y3rEsRmocf69QAzlnJc4V7u', '4e2ee87fa9634b3f585e112c7f19dd44', '2023-02-16', NULL),
(70, 62, NULL, 'Luis Felipe', 'Morillo Villasmil', 'luisfelipemorillovillasmil@gmail.com', 1, 62, '2022-05-16 11:18:28', '$2y$12$Rd6aJrJ2.zfJr6LZJvAdNeOxgu1/TCI0KlgIdz7eyKXZncWSrd1Iu', NULL, NULL, NULL, NULL, NULL),
(71, 34, NULL, 'Alexis Alberto', 'Valles Díaz', 'vow.asesoriaenseguros@gmail.com', 1, 34, '2022-05-26 15:20:34', '$2y$12$iHWGFLS.DRCxso/iy1aPju2zADkPoL6ICHZtjJdgRYs5kstDQar5i', NULL, NULL, NULL, NULL, NULL),
(72, 34, NULL, 'María Elizabeth', 'Dos Reis Lares', 'ely.dosreis@gmail.com', 1, 34, '2022-05-26 15:27:58', '$2y$12$P/jDKnyOktpQihPRNtD9Ge4m6ou0hnfAeXzWuYjH6QPRHgJ.zIY7m', '0d8042711cd342707e2578f48a152490', '$2y$12$8UvjqhJw1nJvAgNtkz3OS.C2umCnngASRsOCa5keEGmK.a2Ax5Hn.', '64d758f2ab7651bf2c19f7e8f8faa902', '2023-01-27', NULL),
(73, 57, NULL, 'Dismar Andreina', 'Brito Raymond', 'dismardabr@hotmail.com', 1, 57, '2022-05-27 12:53:09', '$2y$12$bBVQFAV32kqMeenbpO7MW.kVPV0FKk9qLAyI8zAukZ/4P39gxCAUy', NULL, NULL, NULL, NULL, NULL),
(74, 18, NULL, 'Alejandra', 'Perez', 'alejandra10061985@gmail.com', 1, 18, '2022-08-19 09:55:13', '$2y$12$z.0z1m0IgU5CohImkA9nuO/v/g8uFcXNGKRA6h0.BSK.TE.B8P3gy', '18bc176151719b357e51e55804e7933c', '$2y$12$ebtPxpxXGWyPhKS2AoBPDOrsRkrDheEn90ivqJu/vgF0ADcyzA9cS', '5b7e92a6fa8c2df742bf53c5b45ae859', '2022-06-28', NULL),
(75, 51, NULL, 'Alejandro', 'Yepez', 'Segurosalejandro66@gmail.com', 1, 51, '2022-08-29 10:18:53', '$2y$12$fSBV.1sTqJrswBjcasFTWevo14C4KJVi5sroYZY56TWB574LweUW2', '95e3215d25384e41da23ca411431e483', '$2y$12$lSB3NVIVb3XnDKf5otMpmuXxRtisXCVOqVVMSRweolMzvSvR3qo0q', '22107a5d7f471f6f85ea8ea79a16b815', '2022-06-06', NULL),
(76, 51, NULL, 'Norelis', 'Aranda', 'norelys_aranda@hotmail.com', 1, 51, '2022-08-29 10:19:01', '$2y$12$Bvr.82ovsZyyF6DR9w5cD.faZ/XEzMt19trdj9uxr4LJNOmYtf7Ii', 'e92dcd30e211ebeda46e8e6ceafbe299', '$2y$12$8/Ii86ne52z.h2Y9HagQZOcb5mSnaAr0GkQNjPW2BKLUhLkfCF1me', 'cdc0e0ab91181cd42a36c4d7fdab6f91', '2022-06-06', NULL),
(77, 34, NULL, 'Vereniz ', 'Dávila Orozco', 'verenizdavila.seguros@gmail.com', 1, 34, '2022-06-13 09:18:22', '$2y$12$dgkisNFsOBxkK7uQ5LmN2OzUU7.McgjJcdQqKln0OBNtdQiXeupOm', 'ef9a82799a6467bd046d809c54a7e826', '$2y$12$QzzJO/Ga.vHXYdN/W.XMOeZ9.WxDT/rq9ao6qiHzgR4clfiywvf3.', '529ab4b589e96e9f0d832ca081161874', '2022-06-14', NULL),
(78, 20, NULL, 'Ignacio', 'Perozo', 'ignacioperozo@gmail.com', 1, 20, '2022-06-07 12:34:29', '$2y$12$U1IVkSBJ/agdM48Yxg1q3uP6DcH4.8SEWK54kinok8rRvPSBQX2oi', NULL, NULL, NULL, NULL, NULL),
(79, 20, NULL, 'Daviana', 'Morillo', 'asesordavianamorillo@gmail.com', 1, 20, '2022-06-07 21:36:07', '$2y$12$FG4KLn.w0pzuNJXPuOfkkenx.iqzg7mPkELHyqD6vetysJ49fN6jS', '2c143ba9d5746c76aa76d80bbb22fead', '$2y$12$wq/SOEejEbzF/vZPrW8FGuSaJimuqIhYnXdRCnb4M.KMks85eZmHW', '7d27a6a47adda2dfbe94126381f00d2a', '2023-01-10', NULL),
(81, 20, NULL, 'Jesus E', 'Struve F', 'jesuss1967@gmail.com', 1, 20, '2022-06-09 12:30:26', '$2y$12$0.YF/MaAC8dgP.34FS20eeAYqDporD/QEOtOk0PdwIClbEo4SmfDm', 'd37663ac3bb31299894d169b0723f261', '$2y$12$rOieakbC2Nv/JCmdyCGhSON3Wijf0TmkOIfyYuTlsWMokaAqsxi46', '2a126c9234eb316716df4f7a20fd199e', '2022-06-09', NULL),
(82, 48, NULL, 'VICTOR ', 'RODRIGUEZ', 'vrodriguezampmargarita@gmail.com', 1, 48, '2022-10-13 19:59:28', '$2y$12$sYE6ZuCTmQifi1lC5I1fUOTP3HZu4qtw0uXJhdP0K1ln1GL37GCFy', NULL, NULL, NULL, NULL, NULL),
(84, 24, NULL, 'AGENTE', 'NP', 'ASESORESNP@GMAIL.COM', 1, 24, '2022-06-10 13:07:57', '$2y$12$KljD7s3WhQeemHkaTVKD3.Q0dvwMrv.IZHW9w3EKePi6.doHpxTcu', 'b0e9cc0a94743578e1c890a1a43313df', '$2y$12$/kj73WvYpVjPZs9rBfznJeB642Tvyd14tQZX0sN0txSYiL5v31Wx2', '53342ab427eed1e6c002b6fc60eef912', '2022-06-30', NULL),
(85, 68, NULL, 'LEONARDO JOSE', 'DE MARTINO SATURNO', 'ldm070179@gmail.com', 1, 68, '2022-06-10 15:13:54', '$2y$12$Rnw8fMo7x8QOg.0uBub55u2FAm10ghqVWqChQkJ1V1SMDXz0mVlFO', '35050b5e9f35b3b785a73e8132649513', '$2y$12$NurTVGK.5uKxfQIV5K6.Vu3zuq1naMijoZ05qnwFO8jYVXBnugiky', 'f34186cc8fe8fd5c8d4632fc7883a116', '2022-06-15', NULL),
(86, 58, NULL, 'Rosaria Erika', 'Amico', 'eamico45@gmail.com', 1, 58, '2022-06-16 12:10:54', '$2y$12$IKrlEcDps5OROW4NIDLUaehD1qIIe/98ppv3vydsco4x31x9QTtNe', NULL, NULL, NULL, NULL, NULL),
(87, 73, NULL, 'YUSDELQUIS JOSEFINA', 'SANCHEZ BLANCO', 'yujosaba1979@gmail.com', 1, 73, '2022-06-21 15:03:21', '$2y$12$aVLEegOo2zMkH3qNo4fQwOQNT9k8GRG15TJvkpRRuSG53b1HcgEuO', '995f348242956bba3f7108a6dc2710cb', '$2y$12$gEVCbxq14SQhsBg3S2Pj9Ouu7nvBMsdMze/cyfhI//vFOdRlfX73G', '77fefe93720d9e98d1818329c33514ac', '2022-06-28', NULL),
(88, 73, NULL, 'DAYANA DAMELYS', 'HERNANDEZ MARTINEZ', 'dayanahernandezasesor@gmail.com', 1, 73, '2022-06-21 15:08:08', '$2y$12$vI/1zsuarrvQprrJ9fstNO2RVjw05RO3IKq9HTqd32No8LvySFaUW', NULL, NULL, NULL, NULL, NULL),
(90, 75, NULL, 'JENIFER', 'BARROS URBINA', 'jbu6jj@gmail.com', 1, 75, '2022-06-29 11:00:30', '$2y$12$XQKWZsmyE3Z2VuoNt7mMJej6YmJtOBcI56j26gMlpqj7x7j8ec3fy', NULL, NULL, NULL, NULL, NULL),
(91, 13, NULL, 'Ernesto Geronimo', 'Borga', 'gborga.asesores@gmail.com', 1, 13, '2022-06-30 08:54:03', '$2y$12$aKaD6Qi1r4aBz6aVN5ZVKOVJQOiup8ffSOsaS13XwwJ5thHhrUSfm', NULL, NULL, NULL, NULL, NULL),
(92, 63, NULL, 'Noris ', 'Mata', 'noris.mataprince@gmail.com', 1, 63, '2022-06-30 10:31:11', '$2y$12$ySWXzkdP1xsG.y5s2IWHQO.Ld9I6ZetVgF4UR/lCKXX3ObtM9qy.C', NULL, NULL, NULL, NULL, NULL),
(93, 63, NULL, 'Jean Carlos', 'Villamizar', 'jeansvillavilla@gmail.com', 1, 63, '2022-06-30 10:33:06', '$2y$12$pKa77tlrnLnTitdfru4JJ./Y/g5k9MbOm1d7PANY5QIBTmMqOdClS', NULL, NULL, NULL, NULL, NULL),
(95, 63, NULL, 'Carlos ', 'Gonzalez', 'cgra031276@gmail.com', 1, 63, '2022-07-02 15:01:55', '$2y$12$2QjtRFcUj552m3x2io/Y7uaZf9OqwjfFPHO/I.UcmZVTqgLiBV7Hy', NULL, NULL, NULL, NULL, NULL),
(96, 97, NULL, 'Morela Carolina', 'Perdomo Reyes', 'caroperdomoreyes@gmail.com', 1, 97, '2022-07-02 19:12:50', '$2y$12$0DqQ24Z/LC9CNMRNRuKDY..skpJ/Gry5ucXvCDHrFjPY6mKuqX/nu', '0b18cf81d208397678c4f8ed8bfb07c2', '$2y$12$SGHBlJ6/Yi4LH33fXi.SGOtGdjqWQ9ooYJwnOcIKxpyj9aAy6saj.', 'fb8c6b9d2a4c2b82e148b1ca531213b0', '2022-07-12', NULL),
(97, 97, NULL, 'Eldiver Engelvis', 'Saavedra Rueda', 'eldiversaavedra@gmail.com', 1, 97, '2022-07-02 19:13:59', '$2y$12$dxyKzkCFR2ozRXRCbqSVX.ST.JJGb5x6xquM930cBZCu./xkYesti', 'd9351dc960a6f465e94be5fd37c2193c', '$2y$12$Zc2uyq8wGC3EyTxW8oun/OcnZ5O35iyJwV1rAwWl1KHWj6tpJtLZm', '1041fec9938ff3ae0b6f5ed719e1d3be', '2022-08-15', NULL),
(98, 97, NULL, 'Eiver Endelvis', 'Saavedra Rueda', 'eiversaavedr@gmail.com', 1, 97, '2022-07-02 19:15:23', '$2y$12$kQXVKCjp1lMEIpB7/16E0.pWX2I/Xk9NsICw99BYRT2Tl7fTrt0lG', '7e842c5bd21a8a7479d7832ffaa64968', '$2y$12$srzTbgbGM0WjbDOi6Vnt3OHcZq7kNXwi0c0LvPYkeCpKSObrayXGK', '003d514bf131b54e6c740db4b13891e9', '2022-07-02', NULL),
(99, 97, NULL, 'Mariana Vanessa', 'Villegas Hernandez', 'marianita.villegas7@gmail.com', 1, 97, '2022-07-02 19:16:23', '$2y$12$SUI2KyLQO0WYAngUQVcpJeCTIYrS7PBn91QQl0fkv8NYIo/DsRUmi', 'af48ad4099a6360c725f1d8902356917', '$2y$12$IE9Yozx9COJNZfxBTTCAtuxn.iyl.Wn3ou5nVxmrbFz9QmizpJE4K', '36735dc7b09a5f7646c7e31810a27317', '2022-07-02', NULL),
(101, 97, NULL, 'Adriana del Carmen', 'Sosa Bermudez', 'adrianasosa56@gmail.com', 1, 97, '2022-07-02 19:19:33', '$2y$12$1E5zFuxCAX9AcGPyiAfkH.snJxDnvtMSLmOadPC0NTkER70lqtxKK', '643ae2c4a1204629976faac7fb6b909b', '$2y$12$sFg2PebY0soJTwf05jIVxe4trml/JuhhuVf4lRfSGu1z3SriuUVLW', '38baabc50b782eb208caa16680f1969f', '2022-07-03', NULL),
(102, 97, NULL, 'Gino Salvatore', 'Della Luna Morillo', 'tenshogino@gmail.com', 1, 97, '2022-07-02 19:21:03', '$2y$12$LmR/I55WXKWfXeDmFxv5aOPNlWsIm2wfjqfWSN5SvU9Li9Tj51nOm', 'f59693adf13768ff443b4facee1c1e64', '$2y$12$clrH0jF19sDsmzWiPIjOZOgq.gf/grUe26LqFRVLnD9LJ5N9OafXC', 'df775366a590666a2687baf2bd1105d5', '2022-07-02', NULL),
(103, 97, NULL, 'Wilmer  Ramon ', 'Cabrita Mejia', 'wuilcabri@gmail.com', 1, 97, '2022-07-02 19:25:44', '$2y$12$4kZLwOoWW//dnYGwtqvQAOHi06P87cO2feXzTxBFTuhLmnvq9lZWS', '19476245ab133afa57129eaa0d92a58e', '$2y$12$ZX1IbOaGuGj7OoYU1HpRtexztLKR7O/JcjZ80XJI/HYHnf/Cr1iD2', '790ffd954fa429cb18cd4cebf10e41e4', '2022-07-02', NULL),
(104, 97, NULL, 'Cecilia Coromoto', 'Romero de Cabrita', 'ceciliaromero2105@gmail.com', 1, 97, '2022-07-02 19:33:11', '$2y$12$c/tP8VpexEV2X7oEqpl9DOsg1vzB1mlYsn0CstIkJjVYtfklbPhTO', NULL, NULL, NULL, NULL, NULL),
(105, 97, NULL, 'Kelvin Enrique', 'Angel Torres', 'keelangeltorres@gmail.com', 1, 97, '2022-07-02 19:34:39', '$2y$12$7vZaNnmRRhxQONbDoAFODu37adAZvlMkfrpxcv0IK8gMr/9Bxvp8S', '332db40712a6aef1eb5d18f7a45ddd56', '$2y$12$zkPdmLhDb9/9Ymqj74FsbO2HNR4kqh8E7GXn3tzFpUaEfqaBbL992', 'da8d2389a1190e1933c129157b952897', '2022-07-02', NULL),
(106, 97, NULL, 'Victor Frank', 'Suárez Basabe', 'franksuarez2014trujillo@hotmail.com', 1, 97, '2022-07-02 19:45:10', '$2y$12$dDz/f0bDQelWg2016QYQuOCOa/oJFJ7S2YOZfU/PYPDTigBoXkhju', '2bb9a78ea2bf5db34dac6dde18f30a23', '$2y$12$59T8.zd98djt5UGvZ6AHVeEBNUM36ggNp/BtCv2Dd3R/LD5f4ibWC', 'bae27afc8b31cc853686b431a2f3c5ba', '2022-07-02', NULL),
(107, 97, NULL, 'Estefanía', 'Araujo Mendoza', 'stefiaraujo89@gmail.com', 1, 97, '2022-07-02 19:52:17', '$2y$12$gPSln.dOduX60CPRAfTBDOQx6F8WrHxjvhbP4YhWEWDUKuzgrnaJO', 'c8564166d3f1844bd6c60f8a0e761179', '$2y$12$B7J7cjwpJPX3jAR.mMli2eqsQ/KWzJ5jZHPPepvarN1hCZ8V7bU5W', 'c8ada02962e7a0f02735210946aba0d6', '2022-07-04', NULL),
(108, 97, NULL, 'Gisela Octavina', 'Ramírez Pabón', 'giselarami2001@gmail.com', 1, 97, '2022-07-04 11:27:45', '$2y$12$elcGxz4Gd5134lYqtH79p.Sa1qdNBGjjHppxIJnl0/znH0MYiQnhu', '680895946321bba9a4a1386bac8f6b06', '$2y$12$6EhCgVJtz.WSIHi8Gd5os.j2wZAZtJbDvFopAIlgc3oPEx./4WoBG', '4b92a08850c8f5114712f272461e84bd', '2022-07-04', NULL),
(109, 97, NULL, 'Ana Luisa', 'Linares de Urbina', 'analinares.321@gmail.com', 1, 97, '2022-07-04 11:29:39', '$2y$12$2hlfWDuixz6ggJPyJKkxou5tovqHyQFjr.rqCsOJ3hLU8UHVvMyhy', NULL, NULL, NULL, NULL, NULL),
(110, 48, NULL, 'JORGE ', 'CABRALES', 'cabralesjorge@hotmail.com', 1, 48, '2022-10-13 20:11:04', '$2y$12$yvZ0m6shG5kpMR5BUj7Qy.iyAfbFfB1t.YaZCYO3AEePNkclN/tSm', 'ebce53cc729d9ca186812ef17eba08f2', '$2y$12$lW6bz4m6U/jwQ14DRRY5a..4uNZdhZkP/SSAAk4LcL2.c9F9o1Kyi', 'a572bd7b1e40c12ee65122a0f2982cd7', '2022-07-10', NULL),
(111, 97, NULL, 'Mariu Anmari', 'Hernandez Buitrago', 'mariuhernandezzbu@gmail.com', 1, 97, '2022-07-06 10:04:59', '$2y$12$FiWoqSKKi2qlaq2yIkxOw.Gzg6dGwLExUZQQM4BHjWZAMfj/wR/vy', '452bf32ce5683728def44a7a49e47f69', '$2y$12$UXFpeEr0D4Y0Qn7UW1ZitOfdM1180nU7Lwcu779.XwpCukeREmE22', '15071d47363f9b614972ad0c61dea87b', '2022-07-06', NULL),
(112, 48, NULL, 'DANIEL ', 'POTILLO', 'daportillo@portilloseguros.com.ve', 1, 48, '2022-10-13 20:11:16', '$2y$12$RCOpbE6fMR9EYUKCVeO/l.9GSwrEl.7bR.nwbeI3NVb7HERyPL6k2', 'b9d1cf62a04f92a199cd0317fdc7f7e9', '$2y$12$zih9hJa2vnkBVpGo9HNu/en1UcTCnFuI/pXqlXgWiDV9K.wRz0EDm', '0c4bc6abe3a4ae10c46dcc6f57778601', '2022-09-01', NULL),
(113, 48, NULL, 'ROSENDO', 'SOT0', 'rssoto1970@gmail.com', 1, 48, '2022-09-01 11:16:21', '$2y$12$E43nvJkNPTdiZiYwaFY7g.vq4oo6v2hULCrOqo3xYcXwV/q50.ECC', NULL, NULL, NULL, NULL, NULL),
(114, 48, NULL, 'EUCLIDES ', 'CUELLO', 'euclidescuello49@gmail.com', 1, 48, '2022-10-13 20:11:43', '$2y$12$27LxfZzo9qfyb1jDX5jBrevmRZV8WjGU0GepXGW/uVkUhOC393O8S', '5a2666fef67fb6061f340cf4905a7dd5', '$2y$12$b5Y5tvMPQSa7L9arAlztf.PMv4tl6pBBysttl7y0G4Q2bW87IgMj.', 'ad9e41f49742d66b00a4ba6e9c167724', '2022-08-25', NULL),
(115, 45, NULL, 'ANNA VANESSA', 'LAFILACANE VALENCIA', 'annalafilacane35@gmail.com', 1, 45, '2022-07-18 06:59:40', '$2y$12$pcOmyBo7x.qacoYF0PwiAuaylvtKOlTBSWGnVwU/2zWUchGszegaG', '7479283867cfc14f534ac5939cec5cf2', '$2y$12$VC8s4xvu1zoPw89FFVqkduBCOxosSqcjNoUUIZhbClVQAlTSOjZ5K', '30421df06adfd014f5529a534591d586', '2022-08-11', NULL),
(116, 45, NULL, 'LORENA MARIA', 'LAFILACANE VALENCIA', 'mftravel2020@gmail.com', 1, 45, '2022-07-18 06:59:26', '$2y$12$GRVFk/ks3D7k5k1bB0D7FuNxyCMpRm9Oc56a5QipQ4UZizLagbzXe', NULL, NULL, NULL, NULL, NULL),
(117, 45, NULL, 'NESTOR ANDRES', 'RIVAS RIVERO', 'nestor_911@hotmail.com', 1, 45, '2022-07-18 06:59:53', '$2y$12$DkmAf8Cv4985fqt/RYE5i.P1.wjdNBH96VrxX15uBHfVTCDLcY4ea', NULL, NULL, NULL, NULL, NULL),
(118, 45, NULL, 'RUTH MARINA', 'BATTE JIMENEZ', 'agenciadeviajesvive@hotmail.com', 1, 45, '2022-07-18 07:00:05', '$2y$12$/TwjWe6HPQreuQdWtl26M.vzEHSFC58SHkadVF1Xt5oHhihmmJH9a', '63f0581ce72f15c66760fc751b49c484', '$2y$12$Cvyd0UNoG4vgzKu.kijsPecJ08EDZyDgqDPs.80LZzJDL0sHCGoBG', '4762fe26b5937aa703c22746a250419b', '2022-10-21', NULL),
(119, 63, NULL, 'José Ramón ', 'Méndez', 'jrmendez37@gmail.com', 1, 63, '2022-07-08 16:17:23', '$2y$12$vjT4MDpt0ucr77hgvmZ2MeMxRtH9lFVtIW9ZHDCvoayvK9HKbbFZu', 'f88c5ddb7c1197b0677315082da95b65', '$2y$12$wlV84yPNYpEmPS3vA/V8oOW8vbfDKcCWQ6KrXnCItu3eGueyB0i6q', 'e51668c8e4ca0fd86d2044e4537f5213', '2022-08-03', NULL),
(121, 51, NULL, 'German Alfonso', 'Loyo Villegas', 'germanloyoasesor@gmail.com', 1, 51, '2022-08-29 10:19:07', '$2y$12$IF/7ecyWIhHhHOG25LWFrOzG3mjsn8Fst/MkuO0EEE.EPxgPyY2.C', 'f9f6b016d66156ed639c8e6968fef966', '$2y$12$dJLjXmVQKPaFv4BUgx1tguEfBBFUjaBfLcfE33Duir6UJQ48iQRSW', 'daa5b09fe429e92ab479767d1ca6bc69', '2023-01-23', NULL),
(122, 63, NULL, 'Edgar', 'Campos', 'edgarcampos020@gmail.com', 1, 63, '2022-07-09 14:45:58', '$2y$12$uQ8StLqhRGLtPlyQWccuY.aFxXqJ90IpPFFMbyTknhvWNkOKWdX3C', '642defd3b3ad09b8df0d32c0d4c0dd4e', '$2y$12$jDywsg37ZpMDwSVurRlgj.2i3hqH3MAKQko2XrOH6wdeqRRaxSDK6', 'bd93d7a0690457d7127df1f32ed4eeb2', '2022-07-24', NULL),
(123, 85, NULL, 'LEONARDO ULISES ', 'PEROZO RIVAS', 'LEO18LPR@GMAIL.COM', 1, 85, '2022-07-11 17:46:40', '$2y$12$2NBv1WTPyunqavE.Bj4Lz.ts/nYuQpwmdWhhlsYBqxjq27VyrsrKe', 'a8a1253e8d88b72add86e5b652692136', '$2y$12$EJRieh8qG.TPjM1vSPmUCOSuQSBSunNrGp7OGwnGh2L6L6I5JzM16', '620cfa19f5d2fbe2df405e9a7f0eb8a9', '2022-07-11', NULL),
(124, 69, NULL, 'MERLY', 'RIVAS', 'mrtasesores@hotmail.com', 1, 69, '2022-07-13 10:07:05', '$2y$12$7L7BR5HJfX/axK68Ut.eJuw9V2TJYBAdMRlVm4T/sJRP96L.HLsX6', 'd717106cb433f607a2ee63db1d57fc5c', '$2y$12$HB53dwVOqT5HEXNNrn5xvu1L.RSPxu/dyyz0nuw.btx73RoEZO0ny', '59efd687cbc36b83c1e03d648a986bf0', '2022-08-26', NULL),
(125, 46, NULL, 'Vittorio', 'De Pasquale', 'vdpserviceseguros@gmail.com', 1, 46, '2022-07-13 14:07:39', '$2y$12$N42/ELg4UHz2d96BZbvbP.xEN6M7M9bJVyGdGjSHd7VAAfEQhzejm', NULL, NULL, NULL, NULL, NULL),
(126, 69, NULL, 'JORGE LUIS', 'DELLA SALA SATURNO', 'dellasalajorge@gmail.com', 1, 69, '2022-07-13 14:50:05', '$2y$12$Am5MnnsJ1Xj5978OpexYc.ez3InZF.Z0tePywu573xntXSBDHbgyS', NULL, NULL, NULL, NULL, NULL),
(127, 49, NULL, 'Betty ', 'Ferrer', 'BettyFerrer1973@hotmail.com', 1, 49, '2022-07-15 09:48:33', '$2y$12$rgKwPQpGDRfSfDxO5aPdlOQLP7AnLtbhR/4xpxWCDPY2Sql3aJCoy', '95a47005239306ecdd7e1a8f9d480722', '$2y$12$B.utylb1mOMhzj1fcmdeGuG8J63lvfHZGEndBPtbvyS1OXrAeMuW2', '18dae187397e8baafdb28883671974e0', '2022-07-15', NULL),
(128, 83, NULL, 'Ana', 'Gutierrez', 'comercial@mildestinos.net', 1, 83, '2022-07-15 11:16:48', '$2y$12$IX.pLFui4eHKUd32YscokO/G7F8Kf7KFykJlUuQ6t0nk5iwyOW6YK', NULL, NULL, NULL, NULL, NULL),
(129, 83, NULL, 'Maria Elena ', 'Zerpa', 'gerencia@mildestinos.net', 1, 83, '2022-07-15 11:17:31', '$2y$12$Mce9PC3Vyd44aRA.rSUD6OcHiaATJqJ5qALUANoShisYOLL3yHWwK', NULL, NULL, NULL, NULL, NULL),
(130, 83, NULL, 'Alberto', 'Mattey', 'albertjavier20011981@gmail.com', 1, 83, '2022-07-15 11:19:23', '$2y$12$8tGFg2u/PQZq1NaLlD5CXe9ZdyIgy.MURC/4ludaIZjnORUTp4ISm', '0f632a507e5282e60abd341f30a7e546', '$2y$12$tL/HXbF..lGNfsR4LDZRuex2Qf9FPgMFeFT/wup4rZBvryKgFVWHO', '6a6147b87a4c989e4b17b0b8f7a91364', '2022-07-15', NULL),
(131, 83, NULL, 'Randy', 'Granadillo', '26086340jj@gmail.com', 1, 83, '2022-07-15 11:20:14', '$2y$12$nEypDLYLsmU2xsjmZL0IkeQTsn2yFzQY3onrpgYeROHktU9RrqpSy', NULL, NULL, NULL, NULL, NULL),
(132, 83, NULL, 'Alejandro', 'Tovar', 'alejandro.tovar25@gmail.com', 1, 83, '2022-07-15 11:20:53', '$2y$12$ne8.FWvq5DEQGIKDyXyMCe59KYAHitgm38TpcsrQ/Xbdv2R2A03qG', NULL, NULL, NULL, NULL, NULL),
(133, 45, NULL, 'YUSANAI COROMOTO', 'GUILLEN CORDERO', 'yusanaiguillen@gmail.com', 1, 45, '2022-07-18 07:01:14', '$2y$12$1VmhKRzuY1Bu4asdm6mfC.T9n5qROYUJUsDimv2brHRdwGlKFCOdG', NULL, NULL, NULL, NULL, NULL),
(134, 45, NULL, 'PEDRO JOSE ', 'ESCOBAR SUAREZ', 'transporte2020@gmail.com', 1, 45, '2022-07-18 07:02:48', '$2y$12$Ody8X/M5u06AMfKbolgcWeOh2ZtN37fk.mH3A1vRq8JxN5hST3Kpy', NULL, NULL, NULL, NULL, NULL),
(135, 34, NULL, 'Joaquin Alí', 'Parada Ramírez', 'joaquin.parada55@gmail.com', 1, 34, '2022-07-18 11:33:05', '$2y$12$F8LEl2LxTt3HqkavwJ.pPOeDaFohWH8maFPSqOiaoRrbeEbdjCWRK', NULL, NULL, NULL, NULL, NULL),
(136, 34, NULL, 'Nancy', 'Gaviria Valbuena', 'ngaviriav7@gmail.com', 1, 34, '2022-07-18 11:35:29', '$2y$12$WKFSVVeH1.9JKuCONsbXkea3ypIUiOpcsP52M2lvRZ2Wul/dw6izG', '85c2cbcc41d3c04f1bdce34f910f953f', '$2y$12$pSQ8nSWl2gDy4qmKlZGkBeS36cUlzWpduCkCy3C8qSeZ0X7ziIzcC', '3be1d394b98e52566bc85dd3b7a9b040', '2022-07-19', NULL),
(137, 34, NULL, 'Oswald Edinson', 'Lugo Rey', 'lugoswald@gmail.com', 1, 34, '2022-07-18 11:37:17', '$2y$12$LTj/1BVPgPs8jUlG2ejHGO.Coj6rY0AzDWi2UrvZCsbj5gy/cHaHO', NULL, NULL, NULL, NULL, NULL),
(138, 34, NULL, 'Gustavo Antonio', 'León González', 'galeong1972@gmail.com', 1, 34, '2022-07-18 11:38:46', '$2y$12$FcYK6WL6rp8TGrNdRg5xGeQNpvGn00joUJj5L1Nqsl6xCQvVj0DoG', 'a0c011affecf03fe53113b449c8ae98e', '$2y$12$M1z2.KNaWjqAaAwdXqHjQOFP2z/SOkPC0fsPTuFyoNuYCazwFMO4O', '68026a70b3de8c47a5baf5096268a00a', '2023-01-30', NULL),
(139, 34, NULL, 'Yineira Karkesmy', 'Romero Quintero', 'karkesleyder@gmail.com', 1, 34, '2022-07-18 11:40:42', '$2y$12$G91YRt75kIJ3eskqhmBCQeHWkkMEFGS/lEKGhRZCVXmqO.e9CPylK', NULL, NULL, NULL, NULL, NULL),
(140, 25, NULL, 'DOUGLAS JOSE', 'MENDOZA TREJO', 'abogado083@gmail.com', 1, 25, '2022-08-11 09:34:29', '$2y$12$jAPwOBIdDRsz0hCHeiWQy.p5pQnDWKba78ymewJFIuIQUad8ITd3u', 'a1c97389c422dd6eff762dbfd2ece10a', '$2y$12$zfYdIf5j1x.tLVyIxu8GwewWhYz22KhT8smHalWsy3GQzqf.7tgji', '5ad9b4592527cd412016775e65a60716', '2022-07-20', NULL),
(141, 20, NULL, 'Oscar', 'Coraspe', 'oscarlct30@gmail.com', 1, 20, '2022-07-20 20:16:28', '$2y$12$piE1/9nuHm8oHqKf1OC3KOJmSCIyB9APE4.rIQI5uqyCkOtJpuwvK', 'cffe41c3f54b07fd24abda79441db0eb', '$2y$12$UVtMT51LPZYqDYyquW27juBQuhpFjR19aPfuaCCKJhyYU9MFd9kH6', 'da9a5116da3fd4fae48d6d656e29052a', '2022-07-28', NULL),
(142, 51, NULL, 'Flor ', 'Montenegro De Padron', 'flordepadron@yahoo.com', 1, 51, '2022-08-29 10:19:31', '$2y$12$nOiMeb/wApROteYGMHKi/uGGUJeOHqXXDeM8PclGtroC1cXgj.eRC', NULL, NULL, NULL, NULL, NULL),
(143, 34, NULL, 'Andreina De Jesús', 'Morillo Amatina', 'andreina.morillo@gmail.com', 1, 34, '2022-07-25 10:01:01', '$2y$12$EDLjVtrdhN1Ey9o8xLl3u.AQ7v4YYfYbMlyd8Rw.RxdkXoEpQbySW', NULL, NULL, NULL, NULL, NULL),
(144, 34, NULL, 'Audry Adrianey', 'González García', 'aug2092@gmail.com', 1, 34, '2022-07-25 10:04:37', '$2y$12$NhS1OE3XRj7S2rrlaU4elO13fp/43T5S4f.uEHxNHFIIEQETZJjLK', '941ec6530fb661f8b928cc7dc1cbe15e', '$2y$12$yGKWHoGy3FgOWONXNoDbKOmQo3KZb3IMRND08pPZwYhIvsTTbwhTq', 'c331dec44bb343b1a6d124ba3d71825f', '2022-08-23', NULL),
(145, 51, NULL, 'Yelitza Maria ', 'Martinez Issa', 'y.martinez.issa@gmail.com', 1, 51, '2022-08-29 10:19:25', '$2y$12$cGE2jHTdXe/qm3AgsUd8feX96Kcn1vWJEOk58q214d3blSUiTSIM2', '48d29085b45e7de5bc8d7ae4df472574', '$2y$12$OuHlcKKfSghdT5AIIB9lC.SMfuFSmq6pJyIKFoS10P6hPaR1F2bpK', '88ac5c5777120fa5f894b65892e40f4a', '2022-11-17', NULL),
(146, 78, NULL, 'LEONIDA', 'GIL', 'leonidagil@yahoo.com', 1, 78, '2022-07-25 15:40:54', '$2y$12$tvBd9LV1K.PVY7mF8iyKvOu6K8ZaUzSsrAzi8tB5vpaXGf8C/4Ap2', NULL, NULL, NULL, NULL, NULL),
(147, 78, NULL, 'MERCEDES', 'GUTIERREZ', 'gutimercedes09@gmail.com', 1, 78, '2022-07-25 15:41:44', '$2y$12$L/uxNIMfLt0CTDg37OwFVetL7Fk6TsHNR69vD13.ZBt9hhCRgQx7S', '6bebac86542ee74b8cafee546c4f371d', '$2y$12$Y9LKIC2Ml74g8xHu9P3iS.mas24oWaBJG3IqgjFuHcAuXecrmVjlW', 'eab2d105cb12f6579e26dd85d86070a4', '2022-11-29', NULL),
(148, 78, NULL, 'MARICARMEN', 'DEVERA', 'mcdcorredoresasociados@gmail.com', 1, 78, '2022-07-25 15:43:07', '$2y$12$UxDZ5xWoNwHp/v5AH1gZiOlyP5JM59PLXuzWHQRiDRznsTihCARrO', NULL, NULL, NULL, NULL, NULL),
(149, 78, NULL, 'NORBERTO', 'MEDINA', 'norberto_medina@yahoo.com', 1, 78, '2022-07-25 15:44:09', '$2y$12$QeO2UMOHjiRBBkG.AQrBduH85v/sOFXStQyAdzdgdo/pcvPtBKipW', NULL, NULL, NULL, NULL, NULL),
(150, 78, NULL, 'CARLOS', 'ARGUINZONES', 'carlosarguinzonescss@hotmail.com', 1, 78, '2022-07-25 15:45:18', '$2y$12$64t/EjAm46k1y3WiJBtSp.BUQoa7WVOWWQ7Wyz95owhBUZ.glL7bi', '206b4f0e37a0d89eda9baa03c27a0cf2', '$2y$12$LWCEX1E4.79Sm0IQOtk/6ehEKDipwGuYgITFPDsGHK.8sE.rtxUD.', '8623faf02a2f7f33b2d57b872065013a', '2023-02-07', NULL),
(151, 78, NULL, 'PETER', 'VARGAS', 'petervargar@gmail.com', 1, 78, '2022-07-25 15:46:24', '$2y$12$fKxXs2qKmOVKNsTw3Czqw.evJohgHt.9oZnRQyxoHaw0XZBZMPELa', NULL, NULL, NULL, NULL, NULL),
(152, 34, NULL, 'Alberto José', 'Escalante Sojo', 'aljoesso1159@hotmail.com', 1, 34, '2022-07-26 09:42:09', '$2y$12$M/VYEr26jUTLpbfgoAg3ouPUQSuyiBc7mh/KpwUumss3kh7kFVxCq', '78239a0d5155dcd82e1175332311dac6', '$2y$12$7s2GF3FNEZDIcPHBKELSyeUhBXvgQFShez.Fv4JJBlXxQ1WgOMfgW', '0d56f0000029f7e0ec5f3f76f8e6d254', '2022-09-19', NULL),
(153, 34, NULL, 'Sócrates Jesús', 'García Rico', 'socratesgarcia.asesor.seguros@gmail.com', 1, 34, '2022-07-26 09:44:47', '$2y$12$ZC9cHQBUljZf2l1L3TBF5eH4lggZDR7T8q4bY6BTBjqQWwWdPiWbS', '934a9f7f2c2ef51eb8281b8d2f0a5b68', '$2y$12$bkvlKY4Oafa3vhWSgHCKE.S2IlcykxPzoREj22tpVHQGEbLP8ozMO', '704ef8a13004f257b60b8645b1e0a273', '2022-10-13', NULL),
(154, 34, NULL, 'Esther Cecilia', 'Carpio Acevedo', 'ecarpio.asesordeseguros@gmail.com', 1, 34, '2022-07-26 09:46:42', '$2y$12$KGGr7pGTwHh3zDb.duqmB.xWwbbb/YZoyPMRoLGtlMw7SzkMa5JWu', '9d996ee045569e219ffbeeabe64ac955', '$2y$12$FMPzXTB1fyB8mkuHXL4n6.EKf5f.0eho0F6hcf8l4kdWsB.5l5lN2', '4155bd08eabce90edd7e6bccb49aee60', '2022-07-26', NULL),
(155, 34, NULL, 'Noah', 'González', 'ncggm_86@hotmail.com', 1, 34, '2022-07-26 09:48:43', '$2y$12$rkSy3Qs3JHuxO2.5gyQ7VOjNVin4q9yATMSphXP9Tj8ok.O7QuWNq', NULL, NULL, NULL, NULL, NULL),
(156, 34, NULL, 'Yamira', 'Caballero', 'caballeroyamira@hotmail.com', 1, 34, '2022-07-26 09:50:58', '$2y$12$NJp1qhtHeUBYmr3yEEhFX.WO4tDaxQoPos0aLI1nrVfTmRY8BjDPS', '3a33cb56f38c449069df68742f2835b1', '$2y$12$8FoEurlAcrDpruwbM6ISruN5hQncHX//FxjmABskPp3eILw/n14w.', '7d80668254db2ea5c5129758eaeeab06', '2022-08-25', NULL),
(157, 34, NULL, 'Viviana', 'Naguanagua', 'vivianaasesora1@gmail.com', 1, 34, '2022-07-26 14:50:20', '$2y$12$kcJhJOSaKuqme6mxfpt8M.C3Anu6mP50w5W6sOGJXV4EEGSNANhAy', '171028481647b88316689828c473ba20', '$2y$12$DlcX.I8LAZhi37yUE21ece2s4LS2aF0wFAxO42k6FbwCpzQeGJ7Yy', '8d8415b6a10cac73a8811ca905dbcc78', '2022-07-28', NULL),
(158, 78, NULL, 'MARIA ALEJANDRA', 'BARRETO ARAUJO', 'mariaabarreto@gmail.com', 1, 78, '2022-08-09 17:47:12', '$2y$12$pgTvDWg3NCvulcsY7LsxcO02nOKRKHZwj9am11GbjcpeRW7IgTMba', '6ce54ed926dc071231feda559b4f4108', '$2y$12$2lg952fJp3DZ9H4Z61lPz.O2AwezwQ/Odiloiq9y7osu073bivo5K', '2385d0ccc7b21ce15c876e9cf432cf66', '2022-08-30', NULL),
(159, 78, NULL, 'RAMON ALBERTO', 'PEREZ DELGADO', '6909.perez@gmail.com', 1, 78, '2022-07-26 14:56:09', '$2y$12$afBs5uX3apWQ.tob5DDmluhs0sBx2ZrX5GbABNUeeRWRw4ssEfLUi', '59ba8d806966d3f258e3da3377f5689d', '$2y$12$jpRBDPeVJBJz42UatDO95OEjewSFsIXazeBEHtHX2LFsXvT.WS/VW', '36a0c892125bb1ae0a8e7f4e5c2041ae', '2022-07-26', NULL),
(160, 78, NULL, 'JOHAN ENRIQUE', 'ACOSTA GONZALEZ', 'j.acosta.asesordeseguros@gmail.com', 1, 78, '2022-09-21 13:53:02', '$2y$12$Dxh76fgdhiTsCrnezs3uKuUYi2dl08w1IWAZcRVU5o.5shTA9nF/S', NULL, NULL, NULL, NULL, NULL),
(161, 78, NULL, 'LUCILA ', 'JIMENEZ DE PEREZ', 'lucijim2018@gmail.com', 1, 78, '2022-07-26 14:58:00', '$2y$12$j62MRF5EUpv8eqJFOT3l6ul/4j6vNxgpxNpcX1v6AB6x.jX8AFwga', 'd03a48e15a85e5b59af5325cf756dfa6', '$2y$12$PMKCDG9o3u0MBaQRVacBS.DFEjUSbfp6Kq4UBCNWQalAdihln4xzC', '83b6533c84fcce2f7e3764e57b048543', '2022-07-26', NULL),
(162, 78, NULL, 'INDIRA MERCEDES', 'GUTIERREZ TRIANA', 'indira.triana31@gmail.com', 1, 78, '2022-07-26 14:58:54', '$2y$12$DdixHu69kZ.75jX11TD.jOVYCZObDN18UJaXxWoqpHnLnByTwzfh2', '0d4c04e941bc28a7ec566e2d496e30b3', '$2y$12$fTGE3OnrJgQWB8KR0UFn7eI6ppl34awmQON3dQM8.UAJBucDkKF3i', '253f5b8d3c3cd802a7030b7060248807', '2022-08-12', NULL),
(163, 78, NULL, 'KILENNY AUXILIADORA', 'UZCATEGUI LARA', 'kiluzcategui@hotmail.com', 1, 78, '2022-07-26 14:59:45', '$2y$12$PnTcByTonQRp1hAJP3iLtuBrAKr3CJ2/QCyKmAmzd1WSAXwiEmm8.', NULL, NULL, NULL, NULL, NULL),
(164, 78, NULL, 'JOHANA MARILIN', 'MARIN CUADROS', 'johanamarin241@gmail.com', 1, 78, '2022-07-26 15:00:32', '$2y$12$b2x5sJnDKuDo7mN4kkjZJuFnOlKdenWVH1uba2vhqBOldNUAW4gcG', NULL, NULL, NULL, NULL, NULL),
(165, 25, NULL, 'NEISIS PATRICIA', 'GARCIA ALMANZA', 'neigarcia012@gmail.com', 1, 25, '2022-07-27 16:59:20', '$2y$12$1Za0QSrQhlO.7Y.IkWuHzO0DMjDxuxkcSFFT/hrAMGanudJ99q7uy', '31e5c5dcd60de86ac07a5fd5fa2796fb', '$2y$12$DxYjor/Q3G7USFbjqjsLueKG9eoROuvCQWp1MOz9DjzN.vGkpXGn.', '2b7e012bbb85d9b63342b61ce45aa1ee', '2023-03-01', NULL),
(167, 85, NULL, 'ISABEL CRISTINA ', 'PEROZO MORON', 'isabelelestadonet@gmail.com', 1, 85, '2022-07-27 17:47:35', '$2y$12$BQdjMquCytLNFmHa6E2I0uweH7zvnoHF6Gf1h.UEjUmqeIMplQlKC', NULL, NULL, NULL, NULL, NULL),
(168, 25, NULL, 'GILBERTO JESUS', 'PERDOMO FREITES', 'gpinsurance@hotmail.com', 1, 25, '2022-07-28 13:31:55', '$2y$12$v.4xX/CVepW/H9EzdfwraeWJaJQhGfLyIBpEJSCWOQzrivZEavTrK', 'fa1159e3724a93758f847c291687e9c1', '$2y$12$bUTyuPMKLvTDSDhMLiMdDeeZUusj0TZhsYKxsbZaW6GbhTPIEp0Ca', 'd1065a4370e594bbdfabfc3e19a43dfc', '2022-08-11', NULL),
(169, 36, NULL, 'JOHANALY', 'RAMIREZ', 'johana.dag7@gmail.com', 1, 36, '2022-08-29 13:18:53', '$2y$12$gvwv4q9tF4tqjJAKR0dS2.lqDEvXb2h5vEqhH6QyZnFpEI8614N4.', 'ee7df067dd1fbbb87c60779d8b2024b8', '$2y$12$MSPadGvVBgEHhAnRcBVJSu23h1u3AaBmJ0/geqPxnRjDtiPwxa5Hu', '7e4af1e988dfc29a21cbc66ae3478113', '2022-08-12', NULL),
(170, 48, NULL, 'AURA MARIA ', 'MARTINEZ', 'aury10_12@hotmail.com', 1, 48, '2022-09-01 11:16:41', '$2y$12$cH0iF2tMKTQr28WAJ9gB0ueIaBlFzE0gL6twIyDeAIfv/P9SCGzHm', 'd2e3e8384ad04e8d62a1bd69c295d73c', '$2y$12$4RG4iFq3lvZh.4q/fRrIzOkGi9RvNcJ2Owu8eCQ6cu7iOJkeacvka', 'cac1859b36ba78c0763e37acf4fa745e', '2022-09-30', NULL),
(171, 48, NULL, 'MARIA C', 'ARTEAGA', 'mariacleoarteaga@hotmail.com', 1, 48, '2022-10-13 20:12:28', '$2y$12$7Ff35/XOAqBVbbxzk3SZHOcWWlEgUTAJMnQNdToJpzuCMg3oXBtM2', '6ad1edc8db88886676dda26b5a85e3aa', '$2y$12$sZGKIOzK.Y6piyLL5SOjOeHGO4z9IwO/irfHEi0jD8gPZmpTYfPSC', '1435d91f9313b01eea22959c0e86fa0f', '2022-08-08', NULL),
(172, 96, NULL, 'LEIDA MARIANA ', 'DIAZ MONTEZUNA', 'leidad330@gmail.com', 1, 96, '2022-08-04 15:16:44', '$2y$12$W.uKzMXgb6TjQusIN/VyCOoOi3rb/d1kIO5U4mq7v7S5olZAA1fxm', NULL, NULL, NULL, NULL, NULL),
(173, 96, NULL, 'LUIS SIMON', 'PAEZ MENDEZ', 'luissimon0429@gmail.com', 1, 96, '2022-08-04 15:17:38', '$2y$12$rmjEJdVTZBW/OqxKj.XeYuhth5zodhZV.ZKc1BKwcuWTSfOhm9/b6', NULL, NULL, NULL, NULL, NULL),
(174, 96, NULL, 'JEXIMAR NATALY', 'ZERPA HERNANDEZ', 'jexi25@gmail.com', 1, 96, '2022-08-04 15:24:11', '$2y$12$hE7qmtFsuaOy1Q2rm8b8nuQMo5azABzhNmNzlwGH6i5Kc/NHKzm2i', NULL, NULL, NULL, NULL, NULL),
(175, 96, NULL, 'YENNI YORAIMA', 'GARCIA', 'yenniygarcia@gmail.com', 1, 96, '2022-08-04 15:25:02', '$2y$12$T7mhjDwhjH99v88TjAzoW.Ei8tvenEwqHI1SyMwceJrStYMABuyJC', NULL, NULL, NULL, NULL, NULL),
(176, 96, NULL, 'ANGELICA MARIA', 'OLIVARES GIL', 'agenteinternacoliv@gmail.com', 1, 96, '2022-08-04 15:25:58', '$2y$12$Cr4oxyfUDz59DKvv4E2dg.xoPr7SM9tmRIYx6HvcqMLgKM.23fl8q', '21ef9265cfba266fd38639bd5045b1ab', '$2y$12$GKv1KQkzk3ndWbDM1r0y2.TmDbcMVJR2osuM/xSrvbk0yrv5pMv02', '70901fd25f6ad25f1f59220399d35511', '2023-01-24', NULL),
(177, 64, NULL, 'ROSANNY ', 'MILANO', 'ROSANNYMILANOSEGUROS@GMAIL.COM', 1, 64, '2023-04-02 16:19:17', '$2y$12$KSIEpUw1c/bUeotXOXM/k.D3u1LZHV2Ag6JDHIj65rcTw6TfKbty6', '847f24de97efe33daecc38d5358c3c50', '$2y$12$PyLyVjbAkbzumrs.nSwLF.j1WUKi9vHl9ZRadlr.xFuZexwbi7n3S', 'a895a21bf1433487e1848684827ca755', '2022-08-05', NULL),
(178, 69, NULL, 'ALONSO', 'RODRIGUEZ CASADO', 'alrodriguezc2011@gmail.com', 1, 69, '2022-08-10 18:25:46', '$2y$12$B/c2T1dB/Wt6tuPz8x0rP.Ud7MMrWtiiOa6SOi/zUPCYctewsx0Vy', 'be2a765e689fb49a3fc6df93dc68b9fe', '$2y$12$A.7bmNUECsxABL4S/0exTezbxxyFai39DJCHtemxiCGRJ44ZkGoe6', 'b15ab7295b9bbd5c97534f22432c64a3', '2022-08-11', NULL),
(179, 69, NULL, 'GUILLERMO', 'SAAVEDRA SALCEDO', 'TUPREVESEG@GMAIL.COM', 1, 69, '2022-08-10 19:06:07', '$2y$12$A2NRVtCcBovytcSea/YpEeVoRTQXb5KbYf8FmHyEkoM16ISy4LofC', NULL, NULL, NULL, NULL, NULL),
(180, 69, NULL, 'OFICINA ALIADA COMERCIAL', 'G&M, C.A.', 'ofic.aliada_comercialgym@outlook.com', 1, 69, '2022-08-10 22:26:03', '$2y$12$Cb4U4HRqeAOXFYxkcdkPNuOI4p2ha24d7EWpbptbSvznuG1PJT6Q2', NULL, NULL, NULL, NULL, NULL),
(181, 69, NULL, 'SALOMON ', 'SANCHEZ AGUILAR', 'salantonio01@yahoo.es', 1, 69, '2022-08-10 23:01:08', '$2y$12$xTIS498844K7BjNzO1cSPebCUYHcvDr0AGLs9B16Px3gxoGmFrbNC', NULL, NULL, NULL, NULL, NULL),
(182, 69, NULL, 'GILDREDD', 'ROCHE TOVAR', 'gildredd@gmail.com', 1, 69, '2022-08-10 23:09:47', '$2y$12$TXkWPcIn0gOtAloim9WfYuefVZBM5noHjJobn6/MWVuhZLz.S230y', 'd8b48c9309d6a2324781869507311bd1', '$2y$12$30AYjobqIU9FyX7pJZOc9ObDEeaj3s4vbQYL6JHJM4UhNttuP2/sG', 'c8780cf4f4f80aafcced15f0df7c5769', '2022-08-15', NULL),
(183, 78, NULL, 'DAYANA CAROLINA', 'YEPEZ VEGA', 'dayakelster@gmail.com', 1, 78, '2022-08-15 11:48:54', '$2y$12$VKuUVsb7jAKtsxZY1FT3xub6yIsxNuu2JcAcH2ZoiIbJzJWzL8Ixu', '9b37160c67f278140074cd60affa8140', '$2y$12$fOE0rytzTMmi1GW5iDvdP.pnVE.e0uxPUmOjy9OyPhAd6w5Z51St2', '998f761dc316e01f2427965be53dbd37', '2022-08-15', NULL),
(184, 25, NULL, 'ALBA NELLY', 'VILLEGAS ROJAS', 'villegasalba@gmail.com', 1, 25, '2022-08-15 16:26:51', '$2y$12$eLS1XDfWOE7PR1KxQhC8qOaSgtLD69U6HulPhICYuTfLwl/sLkp.2', 'f1ddbef5cd3b1300aaf6761006e60cee', '$2y$12$9YWr4.9Rx4ZbNYDvuiVK6OywAwAtrFUOn7ECAKw7gYgIuVYn25rau', '2676b583689f2e98f1284664a49726c1', '2022-10-18', NULL),
(185, 18, NULL, 'OLANTI JOSEFINA', 'BARRIOS TORRES', 'olantibarrios.17@gmail.com', 1, 18, '2022-08-17 16:33:21', '$2y$12$wrf3lRw8E869LkeBP4C.I.Ov9XEJzB/2txliy.d.0Y4qZGPibRbj2', NULL, NULL, NULL, NULL, NULL),
(186, 75, NULL, 'YADIRA', 'ROMERO BRAVO', 'yadiraromero25bravo@gmail.com', 1, 75, '2022-08-18 10:49:24', '$2y$12$s7OVu3H2Fixz674KE12teOq35JVeSLzLolWkDdnM19.3fWhEsQIre', NULL, NULL, NULL, NULL, NULL),
(187, 18, NULL, 'MARIA CAROLINA', 'MARTINEZ', 'carolinamartinez06@hotmail.com', 1, 18, '2022-08-18 14:49:56', '$2y$12$hXcS2oiveo1XCnRRbm.wIeyaFNXbQtp.W6EsjXKYoaIjYpB3eBE.K', '23a07e8fe5ab89052b3025737242ce9c', '$2y$12$/2GEDhLtfep53XvnHaXJSuQLlK0Pw6fdoHUp1bgO35n/bLYcXaa4i', '020a99ae618f428c0fa836c890781e1c', '2022-11-10', NULL),
(188, 18, NULL, 'VERONICA JOSEFINA', 'ALFONZO CASTRO', 'veroalfonzo@gmail.com', 1, 18, '2022-08-18 14:49:41', '$2y$12$VWDMjuFhu3pBD9SYhn9YN.IpwKmM3PQmcbCfhZwhEtN1LtUlM810G', NULL, NULL, NULL, NULL, NULL),
(189, 18, NULL, 'LENNYS ALEXA', 'MARTINEZ ANDRADE', 'lennys.seguros@gmail.com', 1, 18, '2022-08-18 14:56:16', '$2y$12$xk1Xea9LGZl12qcenYmG4.B5sO5VSVaihb6hsYJxh6ljJrE4xjH1G', '3f065d729858857a86d586ff931a272b', '$2y$12$XxObjei7ZcxsaVTSCi92GO6ebCosv07ni6K/j2rJzz3vzgR.SdYrW', '7979cedc1db581cfa2b63d8ee995d368', '2022-08-26', NULL),
(190, 74, NULL, 'ALEXANDER ', 'BENITEZ RODRIGUEZ', 'alexbenitez36@yahoo.com', 1, 74, '2022-08-18 15:19:11', '$2y$12$z0BLnHLUKfug5s14gENzFOMFyu.YknC7uqjsSaAb/PAVdDKYlPduS', '331ca9d82d368d588994357dddc4d3a7', '$2y$12$IApB4gHtCzjDwmTe1bUr9Oc486onsEA5Vo4Q74ot6oh./9DS97Ks.', 'df4ea5c181128bfe55afc02d37c3776e', '2022-08-18', NULL),
(191, 74, NULL, 'JUAN JOSE', 'MADRIZ MENDEZ', 'madrizasegurador@gmail.com', 1, 74, '2022-08-18 15:19:32', '$2y$12$SI3gr2njiIbOhnvRDi/c6epSjAD6bsHU08qv69lbXJPnOgNnho7PK', 'ef6091d8ad8c5defb84834d4da3bbf9b', '$2y$12$93KJPLmpknZRKim31znKnetokqoEeWQ9PPtrluvyLMNLjwU7tUh2a', '3a8eb46a5921deff098c68b9273fea77', '2022-12-05', NULL),
(192, 74, NULL, 'FRANK JOSE', 'MONTILLA DURAN', 'frankjosemontilla@gmail.com', 1, 74, '2022-08-18 15:20:52', '$2y$12$oBuupVOAXu7HVARYy4RNiumv3vcpy57x0T3qZ9LEGTXlxzjOm28kG', NULL, NULL, NULL, NULL, NULL),
(193, 74, NULL, 'SABRINA AUXILIADORA', 'HERNANDEZ VASQUEZ', 'sabrinahernandez@hotmail.com', 1, 74, '2022-08-18 15:22:32', '$2y$12$8bxuRp3hhfE/r0Tq08NVn.Rio6.y/eAgtKpbBfE8dwf7vuZ7WQxgO', NULL, NULL, NULL, NULL, NULL),
(194, 74, NULL, 'ARLINDO JOSE', 'MONTILLA DURAN', 'arlindomontilla@gmail.com', 1, 74, '2022-08-18 15:23:27', '$2y$12$cU7GwMU77yJilM7T7sHdTubZIybkyQdbxHGe/9lZ3QJ/6zd6RD8wO', '9ee0e4df6b77061a0766fcdce18d59d7', '$2y$12$vkeghBS74XDJAhVSzQIUfO4paZjYfnS0JmXHaWlyDBfbDFYsaEl6C', 'fda27b06363347d79061c83beb858950', '2022-09-16', NULL),
(195, 74, NULL, 'DANIEL ', 'DINAMARCA WELLINGTON', 'danieldinamarcaw@gmail.com', 1, 74, '2022-08-18 15:24:26', '$2y$12$HgueimtJJasU8cHgFW6gqOijV0c3IYV9MWuNGNhlzFDss/zRt1.lS', NULL, NULL, NULL, NULL, NULL),
(196, 74, NULL, 'JOSE OMAR', 'PEÑA BLANCO', 'joseopena@gmail.com', 1, 74, '2022-08-18 15:25:23', '$2y$12$BQnj96Qbv2ugixI45Je7sO/sAEROwTtSQ6vME1/JZvbUrXhVEXJMO', '518d52bf40ce5b60c928c8dba4894d80', '$2y$12$pPFuPbTRhVZ6vsb9N15MIOJIcg4eWQD9F5x45nlCCYNtmzG9pc99i', 'f5c2c3bedfa2586be5786a9490c4e7ab', '2022-10-26', NULL),
(197, 105, NULL, 'LEOMERCE J.', 'RUIZ M.', 'ventas@armisglobal.com', 1, 105, '2022-08-23 11:59:50', '$2y$12$RuegNRcmf8.fN3lSquLW5emFgy10CcxGzcnWDIK53g2c5PUqqvhyq', NULL, NULL, NULL, NULL, NULL),
(198, 105, NULL, 'KATRINS ANDREA', 'ROMERO ARVELO', 'katrins.romero@gmail.com', 1, 105, '2022-08-23 12:00:10', '$2y$12$xF/fwE6QlKoXpfFKWf7fa./OdcfqWEdA3.T3yAK7Y4sbXYwHoHpru', NULL, NULL, NULL, NULL, NULL),
(199, 51, NULL, 'Olga', 'Camacho Garcia', 'Camachoseguros86@gmail.com', 1, 51, '2023-02-01 21:25:12', '$2y$12$vB1X1CLHsFDkH/Io86nvEuxw9Jo/GnNtEjlJ2lqUP1rIcK3D/S6hi', 'c05012d8eb2860f70cb465aa67621332', '$2y$12$aOdhDkZsJ3l8Vp7ClddUc.ZGnVoDRHF6upa10J.c.zpZBR1E5yvZ6', 'bc2670ef2e7bca008e31d34a2f931ac9', '2022-09-20', NULL),
(200, 74, NULL, 'ALEXANDER', 'GARCIA', 'alexandergarcia29@gmail.com', 1, 74, '2022-08-30 14:00:06', '$2y$12$I8vF.mB9ZYIUQ7mfQb9oMeZzdImSvfUpVxT0X4OqF/YVuBmV02Sri', NULL, NULL, NULL, NULL, NULL),
(201, 74, NULL, 'JOSE GREGORIO', 'SCIACCA HERNANDEZ', 'josegsciacca67@gmail.com', 1, 74, '2022-08-30 14:00:02', '$2y$12$neFdmcwVvwsDuov84gy4ne2fkC70L5MtKcrj7/TDuYNudDUWwUa1K', NULL, NULL, NULL, NULL, NULL),
(202, 75, NULL, 'SERGIO', 'RODRIGUEZ', 'sergiolibradorp@gmail.com', 1, 75, '2022-08-29 16:10:33', '$2y$12$YNjuG9aFRdhUOTWkiBnpWe5zeCskBg1PT7KrMx/Qz/DpMte5ltjCG', NULL, NULL, NULL, NULL, NULL),
(203, 74, NULL, 'JORGE ANTONIO', 'SUAREZ CUMACHE', 'jorgesuarezcumache@gmail.com', 1, 74, '2022-09-16 09:41:36', '$2y$12$tQrTrurk2W.eloRPaa2HLODOIrr6K1Wtd0sopE7A4wd83Q.IwXNpS', NULL, NULL, NULL, NULL, NULL),
(204, 18, NULL, 'BARBARA GABRIELA', 'MENDOZA MENDOZA', 'barbaramendoza1605@gmail.com', 1, 18, '2022-08-31 14:54:50', '$2y$12$WPRqnbvBy2z3tzg.AFLq.uWnpwmUvDEnHdoHddUlnnNESAVvzSdr.', '3cb2e7f4d5145a32c54837a3a834fa1d', '$2y$12$Prd8.a/2shc7ZAQt//WNvOPcfraFoj7XtgD6gBmKuXkctXLMZ6VPW', '7e97e99acbbd7af7c7f88057b0463a29', '2023-02-17', NULL),
(205, 20, NULL, 'Jose Trinidad', 'Pinzón Villamizar ', 'consultor1ero@gmail.com', 1, 20, '2022-09-01 11:53:03', '$2y$12$7FraoENzquH7j1vGF0jcoeQRZE48JhQ5UlZkc8cn1IgNHQq23XfjO', '08dc545e39c03d4163efc8faba89e7f6', '$2y$12$uxhNgBUNfGLmSEVTo3nU3eoP7Nswd.eFLX5ZUuZiE4F5ZO0Gnghh2', '300dd1870293f8cb0f3a0e94bd63b6f9', '2022-09-01', NULL);
INSERT INTO `advisers` (`id_adviser`, `id_agency`, `code_ibo`, `name_adviser`, `surname_adviser`, `email_adviser`, `id_status`, `id_user`, `create_date`, `pass_adviser`, `token`, `token_adviser`, `sesion_token`, `date_sesion`, `login_token`) VALUES
(206, 26, NULL, 'LUIS HILARIO', 'GOMEZ FIGUEROA', 'luhigo29@gmail.com', 1, 26, '2022-10-04 11:54:03', '$2y$12$ySZj0qnPExIV4yjvs0dI7.h5xvPXPEHR18U9Ljx2c3Mm.YZwu4xva', '826907c91374903aa3ee7d8b342684d3', '$2y$12$FC5fJ2.yH71KJQr5jJp7DuQse3hCNMop3Ult5YKfylfZEhawjVMnC', 'a719ba77f78582fc0ca4502e74cb0059', '2022-10-19', NULL),
(209, 48, NULL, 'VICTOR ', 'VIRLA', 'aury1012.69@gmail.com', 1, 48, '2022-09-12 16:33:33', '$2y$12$BXl0i51YsbwTSLd9lMnPUeBmBrccux9HjfCkiKJYatSj/qNitHRZG', '68ab6547e9f4a77f97e6d718deaebf77', '$2y$12$uMVaGsHOgFZ5R/KuBCbuAeFTprZ7OubD89Dc6DFyWv7dA9yqCPPvS', '4a507c76afb1b72f648ddc8537ab65aa', '2023-02-06', NULL),
(210, 48, NULL, 'LIDIS ', 'POMPA ', 'lpvanezca@gmail.com', 1, 48, '2022-10-13 20:13:02', '$2y$12$fEX3I0HHi3LrBfeXVXWfOu0wiMpiou9e8e4pUkvag1ArXXCdxvSiC', NULL, NULL, NULL, NULL, NULL),
(211, 74, NULL, 'JOSE ANTONIO', 'CHACON PARRA', 'jachaconpa1@gmail.com', 1, 74, '2022-09-27 10:03:06', '$2y$12$Ihpd.2VoZzLWMqS72fddGeHh7Fm/JHCFhclU8C68XlfPhfLeO8edq', 'c622a5c2d9fe00eb052d47a9ca6fa6bc', '$2y$12$L2cxbPVpdAl91Y2YVmgAieOutpfZeyfXyEsf2jPnO6fLERjWmW/wi', 'c1a6e17ff4b7ff56669f224db532119a', '2022-09-27', NULL),
(212, 74, NULL, 'JAVIER JOSE', 'ROSARIO MANRIQUE', 'jjrosariom@gmail.com', 1, 74, '2022-09-16 16:20:36', '$2y$12$esiD.MSto3shVWO7p54cZuZFQr0z0ZHmMbKkDz3tD7eF6Fwb8uBD.', NULL, NULL, NULL, NULL, NULL),
(213, 74, NULL, 'ELISEO', 'ROJAS SOLER', 'erojassoler@gmail.com', 1, 74, '2022-09-16 16:22:16', '$2y$12$hn7hDiiq7nJ01HKQFWB7ieoPWq2ftSJvQrIIAufdGhK80lHzcMP2m', NULL, NULL, NULL, NULL, NULL),
(214, 74, NULL, 'ISRAEL ENRIQUE', 'CABRERA VERDE', 'israelcabrera99@hotmail.com', 1, 74, '2022-09-16 16:23:32', '$2y$12$UXimvIcgiiBksqzZLvzCYORWdoaz8j0jzucXvuAuR5s1tAFRpy.tu', '71cb29d5b97482ea1a9ca6faa42af482', '$2y$12$o/F3nTwbDP97IAxXclN4s.jxsa9Sgz1741XlBVaGJPIfMs2SjDS22', '6aef85732298a811cf0be8e77e7044bb', '2023-02-28', NULL),
(215, 20, NULL, 'Paola Gabriela', 'Ramirez Arrieta', 'paolafemme@gmail.com', 1, 20, '2022-09-22 12:38:47', '$2y$12$fPhemxM7TBcVxegeFuleEe8JwZSjQQfqk1pMSW6l0FYOHq8S2/MAS', 'dc1a04e489553df308edd200c9540030', '$2y$12$X1HWP/awxLSTRfPK9iXFiuEngR8KzuxS0Yj1t.XYxKBzYUja2.haW', '5562f160386e2a887e605498e6db4355', '2022-09-22', NULL),
(216, 62, NULL, 'Jorge Alberto ', 'Montilla Toro', 'eskalaconjorge@gmail.com', 1, 62, '2022-10-04 16:22:00', '$2y$12$Epbzfu.MI8zh7Xj/aqFVUOmvTNtofGn1U7iHZb9IRqJ9fTNTIRUM.', 'ccd31e2e3d9a44b15d6542e9c684b9c5', '$2y$12$LV9EhNXgsAK8KUZ075ZSr.G.l2/gm9VznthhxLnMBaE/fjgG3a0wW', '5673567aedc0781cf82dc4f09015bfe2', '2023-02-02', NULL),
(217, 48, NULL, 'JOSE', 'CAHUAO', 'josecahuao79@gmail.com', 1, 48, '2022-10-14 09:53:08', '$2y$12$ykgmuhdkG9MlUYmf.DKwbO2Iyf5N6hwPxQ0TknpMlNiF4Ti/yrop.', NULL, NULL, NULL, NULL, NULL),
(218, 96, NULL, 'CLARY BEL', 'ROBLES PEINADO', 'tuasesor.cr@gmail.com', 1, 96, '2022-10-20 10:14:25', '$2y$12$08itVlPvH5aglOacDxvxXe/IElycGlu2pgxVAlR3sWoghCs3Cvzwq', 'b5e2d6130f84a59d7a0110e8cf673608', '$2y$12$ZBPKvK6Fmc3oG2lIlfIKteEawYiB1FwSNegmquGhvd2Wyrq9CYFbi', '872834678b51f903329275e7f0098d10', '2022-11-23', NULL),
(219, 115, NULL, 'Jose ', 'Ruiz ', 'jose2rseguros@gmail.com', 1, 115, '2022-10-31 15:35:43', '$2y$12$UQN9Hy2nOEpOZv4sH3lMeulY4sU6mqFYLCujnPHLcguA1FlHBiK8a', 'ef4a3029a00f52ddeb66b8df03a5e423', '$2y$12$AACOVLK9Z80L3WhNK.Tijey4C6Ctghy9SkQ5Wy8i8CbTsGZsmQAES', 'b521af6d5a8506d4354d85bf4fc98b85', '2023-02-01', NULL),
(220, 64, NULL, 'EYILDA JOSEFINA', 'QUIJADA LISBOA', 'eyildaquijada123@gmail.com', 1, 64, '2023-04-02 16:19:29', '$2y$12$AXV8cM1unwJA3IlloD1tNORX7rjwgANWnvi97nhNLtujGhveknUhm', '49d58536eb9ce5994ae104582a1e77cc', '$2y$12$k83LoFJuvPyCFDDQK/fpROHEGJ/d3xG0kFfPNtnKITLDdqWwyKuZm', 'bc6e4b2db15926a11a9c1a726f625de3', '2022-11-15', NULL),
(221, 64, NULL, 'YETCIS DEL VALLE', 'VILLAROEL ARCAS', 'yecivilla@hotmail.com', 1, 64, '2023-04-02 16:19:39', '$2y$12$CM10UNoeX/1oZN3RLgyaI.WjRRtEcjtrrk/zoetjrQN9Tithg/Dw2', '492ee4d221deaa41c030664b06ad6484', '$2y$12$7xGDNRwxSBX2RB9lHthELuNNpUN7VQsCtTP..8WCpwai.9HVTwx8i', 'b80c929e57aec06db38fd860eb1d05af', '2022-11-22', NULL),
(222, 51, NULL, 'Edgar', 'Laprea', 'edgarlap@gmail.com', 1, 51, '2022-11-22 20:00:01', '$2y$12$C8LIEF/tlfL5J6VH7EzWnexV6RNmx.5Mzc0UA4ncVrMQWdgSWUTvm', 'de75908d02bc85359b657850e28eaf2f', '$2y$12$ApV2p4AC6SRuFVfcWYz71u4Yp23EPc1JNp8I8IitGlWxEFqX5llWm', '06b296fba971b61d9df76e4c0ac5b694', '2022-11-23', NULL),
(223, 25, NULL, 'OMAR JOSE', 'TOVAR', 'tovarvende@gmail.com', 1, 25, '2022-11-23 11:32:50', '$2y$12$7nSM0nWdlK22qX8jXS1a5OCeuy2sK5Vcf23ruzy9qcuNfW9BuJ5Za', 'd37b35528efe7e8087edd65c94468e53', '$2y$12$f1dHbDb8HFAjtTQiLQ5p/O0OLBO//mrfOSPepukB6FrHz0Tf/NZdu', 'ddbb4fb8cabd9880d905aaa1b5bd91eb', '2022-11-24', NULL),
(224, 48, NULL, 'Rosibeth', 'Martinez', 'rosibethkmartinez@gmail.com', 1, 48, '2022-11-24 11:28:42', '$2y$12$.An7OVCh6HGECPJWGQQCfOv2DpX6Op/P/R01FcrXJKik5oQbnwutG', NULL, NULL, NULL, NULL, NULL),
(225, 25, NULL, 'LEYKY NOHEMI ', 'DELMAR GASCON', 'NOHEMI.DELMAR@GMAIL.COM', 1, 25, '2022-11-29 14:16:37', '$2y$12$p.qg1Q3KS7tsyQTMHGjTb.ivH/8HBKJCKd9c9MNbWVOjrj404q6RG', '9a0377cedcbf952dc869806a843fdcae', '$2y$12$x1Auy87kbmTojeGtN7sUbO.16W2xEwcr61xdM5BJxiBkv9PCYZko.', 'd4cb466173682869c042794ae344b952', '2023-03-14', NULL),
(226, 25, NULL, 'LUDMILA ROMERO', ' CANTOR', 'ludmiromerocantor@hotmail.com', 1, 25, '2022-12-01 10:20:11', '$2y$12$9cmZ8d65zCdxUZ2VB7xcGuOHD5Sg9O54aOZh.QTQlNcsBd4FQWhaO', 'd5ac626ef9efccb5abe5cc270c93dc96', '$2y$12$Bpol13t43tONtmhPBk8Es.ArGcbaxdrlsK9esp2H.aCxFkczJM7xK', 'f91869816fd5ec7b3c6d2c34563b6635', '2022-11-30', NULL),
(227, 23, NULL, 'Carmen', 'De Oliveira', 'carmucha60@gmail.com', 1, 23, '2022-12-20 08:42:25', '$2y$12$YNYLYfMXuIH.Dt7kwyc/6e1gaBi9jug77E6Gta9NrbSvdD9Angy9O', '78ab8b88a8834e0338f11d1378601f04', '$2y$12$sdFYjUGb3ziuWIUVJ4TsrOLWKgZ7mEcAecUnp4xaS0S8Kl9PqgQw2', '04ea5a487a9f0be1dff967179b84d04d', '2023-01-11', NULL),
(228, 20, NULL, 'Roberto Jose', 'Rincon Carreño', 'robertorincon_rr@hotmail.com', 1, 20, '2023-01-18 12:11:40', '$2y$12$shavegWKWnnFbXwuK.pwLu5yrxOpNXRosXScATv8dN74R2uunMuLq', 'ce3354bd296d1595d5f7c8bf363c87ac', '$2y$12$DuPc6YD55u.Xz2av30yDJuyNb4QongjXPsExdTENjgOsuXr0W1z/.', 'f07794a7c6ddcaf4455a420af133311c', '2023-01-18', NULL),
(229, 96, NULL, 'NANCY COROMOTO', 'ALEJOS MUÑOZ', 'nancyalejos9595@gmail.com', 1, 96, '2023-01-18 14:01:39', '$2y$12$5D4vUg/X5LZZ3Jq32WbElupLXUSNu/7gxgvw5uA4LBN5EoQLWo2I2', '967f38566d52105d6b733364e557ac68', '$2y$12$V3DYB9iqv40Hua4YIWiABOoYG0ObkqpegdvtwSJbOselR8EEnH34a', '14a9ec5a9d0e6437dcc6caec30ed1887', '2023-01-25', NULL),
(230, 96, NULL, 'LUIS ERNESTO', 'GONZALEZ JOSEPH', 'gonzalezjulio@gmail.com', 1, 96, '2023-01-18 14:05:18', '$2y$12$U5JM56amwkovl8Q4A0dDdOCZX0NRIuN2U86zQ8bzsD.oSUVArrU.2', NULL, NULL, NULL, NULL, NULL),
(231, 20, NULL, 'Marisela', 'Hernandez', 'hernandezmarisela1@gmail.com', 1, 20, '2023-01-19 15:46:57', '$2y$12$fZrIWvyyaf9zyEkqsSSoge2FDSf9yMg7DA3NUH6D.rCO2mq13EH3C', 'fe16568cde355ebd2e99cb6a2eede4c6', '$2y$12$c9vCwRldhsgPUlisYYZcMuOF4xyFMXrJz6xlcBBTwWHRFkYtnw0Jq', 'df06f6829a8d1e1c4f58913ce37d25c2', '2023-01-24', NULL),
(232, 48, NULL, 'MARISELA ', 'VARELA', 'segurosvarela2014@hotmail.com', 1, 48, '2023-01-20 16:26:27', '$2y$12$FkRFzdWbc.8F/xQxuKcGAucsNx8XkZUqTkKlTnNpFDfaW45kb/a/S', '38374c94dd7aef43ecd182d07176c758', '$2y$12$ZjD321Gs0lxYQL6/tqR3H.iAXtXbombLm6COfghljQAo9N.PO3fhW', '3f55603c344c269c2ee63efdd865c56d', '2023-01-24', NULL),
(233, 73, NULL, 'HORTENSIA DE JESUS', 'FAJARDO MONTE', 'titafajardoasesora@gmail.com', 1, 73, '2023-01-24 09:08:23', '$2y$12$qO.SQ/Q5PWfaBNsVp6THUeEDIH8tyQoHcagagPgTPBObynSXRYOk6', NULL, NULL, NULL, NULL, NULL),
(234, 25, NULL, 'JOSE ANTONIO', 'ROMERO HERNANDEZ', 'jaromeroh69@gmail.com', 1, 25, '2023-01-24 09:12:34', '$2y$12$Zd4m0C.tGV3yeXBwuB22WOazILodEtVPDynhCXCU5i4G.MmnOLnlC', '6dcd8d8e9f43e614d4de2e91431022dc', '$2y$12$P3TInmDE8M460PEHSFYsZ.3mGeVL4ohfLkMLpYNeZXNGueevkimCm', '9c5565e37852925a069e848918cd1a38', '2023-01-26', NULL),
(235, 48, NULL, 'NICOLAS ', 'RAMIREZ', 'nicseg17@gmail.com', 1, 48, '2023-01-25 15:27:38', '$2y$12$pjO3ruh18rbVoIEMrzcus.jjx52bSwtWT1dOZFq8vNxdcKm3Y98Ty', NULL, NULL, NULL, NULL, NULL),
(238, 25, NULL, 'NINA PRISCILLA', 'PEÑA RAMIREZ', 'ninaramirez0411@gmail.com', 1, 25, '2023-01-26 13:34:05', '$2y$12$V72L4NBIis6OQ1v8X.YaI.hdzCDpUaMjGzqphQ6z0Q0qi4wmTKqoq', '583e61304c3ec4952e5bec7ad0cdc82f', '$2y$12$sePRVIbpZtGus/nEdihdQO8uUJ5DWUf/YSRvUDLFuEO0D8npjz3wO', '3d739e8c596661af3558e0d6b344b315', '2023-02-11', NULL),
(239, 25, NULL, 'GABRIELA ', 'VILORIA', 'gabydaboin@gmail.com', 1, 25, '2023-01-26 13:38:05', '$2y$12$cdIfZ4vqx4Xac.9iCVoi3.g//mWIhHQxGmtlCCeZEJ2gWyharXLF2', NULL, NULL, NULL, NULL, NULL),
(240, 25, NULL, 'SARA VANESA', 'RODRIGUEZ RAMIREZ', 'saravane748@gmail.com', 1, 25, '2023-01-26 13:39:54', '$2y$12$cBXMae1m/7k0FAoEG8.jxOb1jUJ2SVxxdSYCyFQ5ywELAi8Ts80/e', NULL, NULL, NULL, NULL, NULL),
(241, 25, NULL, 'MANUEL   ALEJANDRO', 'MOLEDO  GUTIERREZ', 'manuelmoledo11@gmail.com', 1, 25, '2023-01-26 13:41:42', '$2y$12$GVcOYt2wvq5sr1SdCIkv9e8eQGKPjLBWWsaXEbt6eLAKJJER8juY.', NULL, NULL, NULL, NULL, NULL),
(242, 25, NULL, 'JOSE ALEJANDRO ', 'FIGUERA', 'didecoinmueble@gmail.com', 1, 25, '2023-01-31 15:51:21', '$2y$12$QKTh0BBqm.8xEoaXVnOIH.Xc/o86h1jnDXmUwQQlFofDqpF5VGV0G', 'aff9d3d28adb817c5e3c8af6289bdd39', '$2y$12$hM2GfLQNCx70C8dQK0oUlexSgKHtJrYdAs/WQw5sW7KnNZ/Njopaq', '0a2b3ecdab1b91b23c3a7f49fdcb0b58', '2023-03-21', NULL),
(243, 25, NULL, 'ALEJANDRA NATHALY', 'REALES SERRANO', 'nathalireales1210@gmail.com', 1, 25, '2023-01-31 15:52:35', '$2y$12$s60RIi1Lw0du8PCaTdiXeOd7TQRadlLe7T0DjLjsUnTmOKsqOJqqq', NULL, NULL, NULL, NULL, NULL),
(244, 25, NULL, 'ARANZA ', 'MORENO PEREZ', 'aranzamoreno@gmail.com', 1, 25, '2023-01-31 15:58:57', '$2y$12$qsFUHel2XBVQ8Kxu6EGSSeLP9Upb4cJyY04KyiJXvH4CYu1rIIgcW', 'a06eaa3e181bc541c42eafe3f8f96eb8', '$2y$12$Wk3vDVRsMIhGGEM1IBMKROUcpYeCETxwlxCb.5eaYAQ8ek/CNnZ3a', 'd5e04c821b8ecc3607f19731c91b63cf', '2023-02-06', NULL),
(245, 25, NULL, 'JENNY BEATRIZ', 'ROJAS CISNEROS', 'jennyrojcis@gmail.com', 1, 25, '2023-01-31 16:00:53', '$2y$12$tGekS14TlZptmgXy4X5cmuD/kpfpJ7Ra69CYh90YgLW9Q2s87GPH2', NULL, NULL, NULL, NULL, NULL),
(246, 25, NULL, 'MIREYA DEL VALLE', 'VIANA', 'mireyaviana14@gmail.com', 1, 25, '2023-01-31 16:03:25', '$2y$12$3WlGRLSbbkR4N88OTUoXWOm8wlbjLfvoaILPwT0KUxnzRubDMFl1S', NULL, NULL, NULL, NULL, NULL),
(247, 25, NULL, 'ANTHONY JOSHUE', 'MEZA ', 'anthojoshmeza@gmail.com', 1, 25, '2023-01-31 16:04:50', '$2y$12$U1zKQtJx8uBqeU5qjp5nHOjsD9kUbiBIHc1c9KEboVsIIkwSD/yeq', NULL, NULL, NULL, NULL, NULL),
(248, 25, NULL, '12345', 'Felipe', 'felipe@visiontravel.net', 1, 25, '2023-02-06 11:34:55', '$2y$12$BGWwVyg9DwX7/JA5dFQrM.XbJum.hbvTedEE8ezPYNrCdVrfuc7tm', '78968d24bb950f2fc186442d460b58ff', '$2y$12$dsCvizAl7XLkWE5uFG4iBen6BZyCRHNPV56bmoBjE0V.V1X.i1WQ.', '76f28cd68e3bf27647e36d9968749ea2', '2023-02-06', NULL),
(249, 48, NULL, 'Karin L', 'Andrade Sulbaran', 'kariman42@hotmail.com', 1, 48, '2023-02-17 10:26:50', '$2y$12$7l2mDSgQ/rfmaL.64Uvaf.mL5lyNCnYirZx2kGUmssoyyKgIkCZV6', NULL, NULL, NULL, NULL, NULL),
(250, 25, NULL, 'GAES', 'INSURANCE', 'gaetanocensullo92@gmail.com', 1, 25, '2023-03-03 11:10:20', '$2y$12$/UnVKyVu0HaPpnxHCmYEOulcyVaSowE3Ur1YQxeT3/pPb1ir7di.m', '630ae40e37dfbc868f3358033828f45d', '$2y$12$zU13GGIYtre8f4VLMkRShuhLvwQsrILgvvub4qQImaGvm.2jG2MmK', 'fbbab7b575535804a8176b8716aba706', '2023-03-03', NULL),
(251, 125, NULL, 'Vision', 'travel', 'Diana@visiontravel.net', 1, 125, '2023-02-28 09:39:28', '$2y$12$jqBYu3NAxvbh7Mc1BJxtZeI2GvdJYKA5BRogEs3aNpM7sHHUYAcga', '12e95f5ba61832876f9280ac82be737e', '$2y$12$fEdj1ERcw9E8KlQcq/KT9uOqW7MGNdn57v2O3OqzLzhM5BDCIFh0a', 'bbfc84e58fe5add6ba53b71d01d3d0ac', '2023-03-16', NULL),
(252, 125, NULL, 'Mayerli', 'Graterol', 'm.graterol@visiontravelmail.net', 1, 125, '2023-02-28 09:38:54', '$2y$12$eCt30OhnJVfY4wIsj9HVTOHbf/63aZDjeHgHmXoqls3l52KZNuaEu', '370114eaf124682471539834cb2c2987', '$2y$12$irOxZdEaUyhlq7lMvMIO7ukTe8zOgotqDkfCTuvvKWfn/V72oRW52', 'bf8720ef5f916c9e62fc4e2b6c70688c', '2023-03-20', NULL),
(258, 125, 1430, 'Ana Maria', 'Gomez Sepulveda', 'anamaria05gmz@gmail.com', 1, 125, '2023-06-22 18:32:56', '$2y$12$1fho8wlv9xRqvqLGvhdh/eKLXEp4c7UYCQLPEq1cPIQ10KQFPbr/m', NULL, NULL, NULL, NULL, 'visionbiz'),
(259, 125, 227027, 'LIDIANNIS', 'REYES', 'lidiannysr@gmail.com', 1, 125, '2023-06-27 16:35:33', '$2y$12$EmATZ2PqMKiCFJCL.nz2ROaIImO6AcCI7u9LZTDmzcFAXzHrugBiW', NULL, NULL, NULL, NULL, 'visionbiz'),
(260, 125, 49922, 'Flor', 'Sapienza', 'florsapienza12@gmail.com', 1, 125, '2023-06-28 19:21:30', '$2y$12$dFBE7m76IUI9UEkBHgxFJuva5Y0iRarGtsZBFtzcCAIVomRfutOIK', NULL, NULL, NULL, NULL, 'visionbiz'),
(261, 125, 42709, 'Aura Maritza', 'Montilla Gavidia', 'manayuve@gmail.com', 1, 125, '2023-06-28 22:38:14', '$2y$12$aIRQNiIaD8tYngiGziVUM.5ooWor2Xz6IgVk/yH.qP3sVKOh5y1Am', NULL, NULL, NULL, NULL, 'visionbiz'),
(262, 125, 187204, 'SOBEIDA', 'HURTADO', 'sobeidah@gmail.com', 1, 125, '2023-06-30 16:22:47', '$2y$12$stgW7vCA3.Z6R.I5GO1Q7uPbhDImlFmJ/CmxlcHoA/GbQ/c64bSRe', NULL, NULL, NULL, NULL, 'visionbiz'),
(263, 125, 225058, 'ELOY GREGORIO', 'ALCALA JIMENEZ', 'eloy.ar2018@hotmail.com', 1, 125, '2023-07-03 11:01:06', '$2y$12$CoF12iGri1sfFiJcvFatH.uRsH2XEVpyXiZs5jp3FTHKQFsWNhHz.', NULL, NULL, NULL, NULL, 'visionbiz'),
(264, 125, 83314, 'LILIANA', 'DE ANDRADE', 'ita83314@gmail.com', 1, 125, '2023-07-03 21:32:17', '$2y$12$GYuAaqKMUMrVOfGSIDo/Su9kb1BarPGYmjXveiLiihcoVluxrrtyC', NULL, NULL, NULL, NULL, 'visionbiz'),
(265, 125, 180753, 'ADRIANA EMILIA', 'MARCANO QUIJADA', 'adrianamarcano2022@gmail.com', 1, 125, '2023-07-06 17:15:08', '$2y$12$CgXWR5gjGHpiNqNwAiOkdOIc/gnfSdCM5loKcPer9knToVZZmthfK', NULL, NULL, NULL, NULL, 'visionbiz'),
(266, 125, 28224, 'Yosmari ', 'Mejias ', 'yosmarymejias@gmail.com', 1, 125, '2023-07-06 18:23:08', '$2y$12$GPGy6DjPo3j7/mekCS9NX.o49PtTmpyzkNH1JmGry.eX4pZHAF7wa', NULL, NULL, NULL, NULL, 'visionbiz'),
(267, 125, 46847, 'Jetsaly', 'Moreno', 'jetsalym@hotmail.com', 1, 125, '2023-07-08 22:09:27', '$2y$12$r658r13489vWkGZn51scf.xDADeOyo52o5hQLszu4eL/A1PEDwdS.', NULL, NULL, NULL, NULL, 'visionbiz'),
(268, 125, 228580, 'Esmelin Jose', 'Abraham Muradas', 'nurseabram@gmail.com', 1, 125, '2023-07-10 08:15:51', '$2y$12$LD/HJRYCQcnL.xJxXsG4y.NzBTXt/z5CobOQBKFJbL.d4.L6LM.xe', NULL, NULL, NULL, NULL, 'visionbiz'),
(269, 125, 210190, 'IMELDA BELGRISME', 'YANEZ TORRES', 'yanezimelda2@gmail.com', 1, 125, '2023-07-11 11:30:46', '$2y$12$jN7u5WK4JzBXvY2rP0qNsu79Ei7fc9FKt7xJgcuz0j2OcrXd2vAba', NULL, NULL, NULL, NULL, 'visionbiz'),
(270, 125, 228477, 'PAOLA ANDREA', 'GIRALDO GOMEZ', 'paogiraldo.10@gmail.com', 1, 125, '2023-07-11 21:35:09', '$2y$12$3lal/DlupnEK7eoCZLZx.eRAuEFfzuwRi0ifhtUNpoYRJmBlZiCaS', NULL, NULL, NULL, NULL, 'visionbiz'),
(271, 125, 210486, 'ADA ROALIM', 'TROCONIS BRAVO', 'adatroconisvisionbiz@gmail.com', 1, 125, '2023-07-12 18:35:28', '$2y$12$.gn3E9hL7l.6Pstjx1isYO5KCa9TLzRw66NT1lGPCxJ39AiJBbSTe', NULL, NULL, NULL, NULL, 'visionbiz'),
(272, 125, 61965, 'Iraida', 'Parejo', 'viajandoando1reservaciones@gmail.com', 1, 125, '2023-07-13 10:18:53', '$2y$12$j/ATSGXIpQAwX1bf/PVRyOjNsy6CSvJbyw7h9h/LtfBwiUq5mEzMy', NULL, NULL, NULL, NULL, 'visionbiz'),
(273, 125, 82862, 'Yamelis', 'Rodriguez', 'yamelis.edscar@gmail.com', 1, 125, '2023-07-13 10:19:23', '$2y$12$WSc.XF/GkDeIli6mAt9u4.P4VOEQoM6ZHFIx/H6vI7QvTHbkyL5dq', NULL, NULL, NULL, NULL, 'visionbiz'),
(274, 125, 80174, 'Ines Alejandra', 'Abreu Silva', 'funtravel.ve@gmail.com', 1, 125, '2023-07-13 10:27:54', '$2y$12$n75.1EF3VjOf38doGCKcI.AI25/Fob4UvB93C7o0i41du4sNPR3d2', NULL, NULL, NULL, NULL, 'visionbiz'),
(275, 125, 180858, 'Estefany Beatriz', 'Mejias Pozzo', 'emejias058@gmail.com', 1, 125, '2023-07-13 19:03:07', '$2y$12$n/yHaaAfXOeCgefyzEksCuClhX/1nxNPZvMlqy97astxQhI80xoB.', NULL, NULL, NULL, NULL, 'visionbiz'),
(276, 125, 171164, 'ALICIA', 'PEREZ', 'ali92perez@hotmail.com', 1, 125, '2023-07-17 11:44:06', '$2y$12$ybvp9wlJKudhPc3Vq65o.uDfS2k9TlaecP291uHxoxSxNSEEVS2Zu', NULL, NULL, NULL, NULL, 'visionbiz'),
(277, 125, 103801, 'Alexander  ', ' Escobar Morales ', 'solucionestraveltime@gmail.com', 1, 125, '2023-07-17 12:07:25', '$2y$12$xHZ0AO/k9CyBmu/6in5cI.fF.nS77XB0ilpVNIlxQpsrJhu4xriES', NULL, NULL, NULL, NULL, 'visionbiz'),
(278, 125, 90252, 'Zeina', 'Barakat De Ali', 'zenaka128@gmail.com', 1, 125, '2023-07-17 16:44:38', '$2y$12$ueqQvQ9/CDBDjIwWUTZGZueH4pkXMjkD7qivt7xDPiz.VVAZ27OCO', NULL, NULL, NULL, NULL, 'visionbiz'),
(279, 125, 44540, 'Glenda', 'Maurera Mora', 'glenviajes@gmail.com', 1, 125, '2023-07-18 20:47:59', '$2y$12$oJEQbYf8jJxaqOEEXHZO4.iEEXqzQUYVaOTRNgxF/2ukDSGHDncT6', NULL, NULL, NULL, NULL, 'visionbiz'),
(280, 125, 229368, 'JOAN MANUEL', 'ESPIDEL MEZA', 'joanespidel903@gmail.com', 1, 125, '2023-07-19 17:15:37', '$2y$12$Bs6KSqGL2/dpGdwVBfdouewrmaexQE98P6FFGGKn.2vKUd3UxrE.O', NULL, NULL, NULL, NULL, 'visionbiz'),
(281, 125, 143440, 'Tibisay DelValle', 'Bonalde Salas', 'aventuratravel75@gmail.com', 1, 125, '2023-07-25 11:28:10', '$2y$12$EMp7TLxJ9eCaw9cJ/NOBu.VJko8dq5qATQsFBb4sy4yBpX1zRrBMW', NULL, NULL, NULL, NULL, 'visionbiz'),
(282, 125, 220997, 'Mariana', 'Herrera', 'mhc.desk076@gmail.com', 1, 125, '2023-07-26 20:59:04', '$2y$12$yIRcOzqKNJk1XPneM1j80ehrlO1jM1QJyy6XtdvSbVyiXYRwXrs/W', NULL, NULL, NULL, NULL, 'visionbiz'),
(283, 125, 58630, 'Joan Manuel', 'Barrios', 'joanmanuel.barrios@gmail.com', 1, 125, '2023-07-26 21:03:55', '$2y$12$ZeuJgTPoKh5UWR0lnlqYZuv/Xevh4LhiUwyJLu2hK8tmV10EHroMW', NULL, NULL, NULL, NULL, 'visionbiz'),
(284, 125, 29795, 'Gaudys', 'Colmenares', 'gaudyscolmena@gmail.com', 1, 125, '2023-07-28 18:45:49', '$2y$12$NIR0dbUvWt3OBxRmVjXGxuoh4owe1j8W5tYIf1B.elpl8lOIrMQaO', NULL, NULL, NULL, NULL, 'visionbiz'),
(285, 125, 67653, 'CAROLINA ', 'FERNANDEZ', 'carolinafleal@gmail.com', 1, 125, '2023-08-03 09:39:13', '$2y$12$dTclg2OX0KfOZGE5m6qG2OOc7TuZm0ZDKczpU4wXXxEbRPby2Rqy2', NULL, NULL, NULL, NULL, 'visionbiz'),
(286, 125, 151365, 'Dayana', 'Munoz Semeco', 'damunsem@gmail.com', 1, 125, '2023-08-05 17:37:52', '$2y$12$s/yyoKbaSZb8VPVwTgOi6.HV/hECpNPklB2DLelIDrJeQANYXufJq', NULL, NULL, NULL, NULL, 'visionbiz'),
(287, 125, 42001, 'Edgar Enrique', 'Materan Maldonado', 'edgarmateran22@gmail.com', 1, 125, '2023-08-05 20:04:01', '$2y$12$AYiXa4Q9DFwdpqdug.hSSuHSDH3wv/rqaQd3pyo74htUfKwKpjpd6', NULL, NULL, NULL, NULL, 'visionbiz'),
(289, 48, NULL, 'ELIO RAFAEL', 'VILLADIEGO', 'villadiegoelio5@gmail.com', 1, 48, '2023-08-08 14:28:49', '$2y$12$PCOqFSYMh5kY5Zfpwt1iyeerGGvL.1ipahths4GqQR.vJaD9S82Y.', NULL, NULL, NULL, NULL, NULL),
(290, 125, 61449, ' Jesmin', 'Sayago Garcia', 'platinumtravels5@gmail.com', 1, 125, '2023-08-06 22:57:07', '$2y$12$otVooohMQ87Qbzd7QjErCOCRs7A60SE.NUq8ILPU.3AX2cuWWVjMW', NULL, NULL, NULL, NULL, 'visionbiz');

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

--
-- Estructura de tabla para la tabla `advisers_commissions`
--

CREATE TABLE `advisers_commissions` (
  `id_adviser` int(11) NOT NULL,
  `id_product` int(11) NOT NULL,
  `commission` double(20,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `advisers_commissions` (`id_adviser`, `id_product`, `commission`) VALUES
(4, 3, 1.00),
(4, 5, 1.00),
(7, 3, 26.25),
(7, 4, 30.60),
(7, 5, 20.21),
(8, 3, 20.00),
(8, 4, 20.00),
(8, 5, 15.00),
(9, 3, 20.00),
(9, 4, 20.00),
(9, 5, 15.00),
(11, 3, 20.00),
(11, 4, 20.00),
(11, 5, 15.00),
(12, 3, 15.00),
(12, 4, 15.00),
(12, 5, 10.00),
(13, 3, 15.00),
(13, 4, 15.00),
(13, 5, 10.00),
(14, 3, 15.00),
(14, 4, 15.00),
(14, 5, 10.00),
(16, 3, 20.00),
(16, 4, 20.00),
(16, 5, 15.00),
(17, 3, 20.00),
(17, 4, 20.00),
(17, 5, 15.00),
(18, 3, 30.00),
(18, 4, 32.35),
(18, 5, 23.80),
(19, 3, 25.00),
(19, 4, 25.00),
(19, 5, 20.00),
(20, 3, 20.00),
(20, 4, 20.00),
(20, 5, 15.00),
(21, 3, 20.00),
(21, 4, 20.00),
(21, 5, 15.00),
(22, 3, 25.00),
(22, 4, 25.00),
(22, 5, 15.00),
(23, 3, 20.00),
(23, 4, 20.00),
(23, 5, 15.00),
(24, 3, 20.00),
(24, 4, 25.00),
(24, 5, 15.00),
(25, 3, 20.00),
(25, 4, 25.00),
(25, 5, 15.00),
(26, 3, 20.00),
(26, 4, 25.00),
(26, 5, 15.00),
(27, 3, 20.00),
(27, 4, 20.00),
(27, 5, 15.00),
(28, 3, 25.00),
(28, 4, 25.00),
(28, 5, 20.00),
(29, 3, 20.00),
(29, 4, 20.00),
(29, 5, 15.00),
(30, 3, 15.00),
(30, 4, 15.00),
(30, 5, 10.00),
(32, 3, 15.00),
(32, 4, 15.00),
(32, 5, 10.00),
(34, 3, 20.00),
(34, 4, 20.00),
(34, 5, 15.00),
(35, 3, 20.00),
(35, 4, 20.00),
(35, 5, 15.00),
(36, 3, 20.00),
(36, 4, 20.00),
(36, 5, 15.00),
(37, 3, 20.00),
(37, 4, 20.00),
(37, 5, 15.00),
(38, 3, 20.00),
(38, 4, 20.00),
(38, 5, 15.00),
(40, 3, 20.00),
(40, 4, 20.00),
(40, 5, 15.00),
(41, 3, 20.00),
(41, 4, 20.00),
(41, 5, 15.00),
(42, 3, 20.00),
(42, 4, 20.00),
(42, 5, 15.00),
(43, 3, 20.00),
(43, 4, 20.00),
(43, 5, 15.00),
(44, 3, 20.00),
(44, 5, 15.00),
(45, 3, 20.00),
(45, 5, 15.00),
(46, 3, 20.00),
(46, 4, 20.00),
(46, 5, 15.00),
(47, 3, 20.00),
(47, 4, 20.00),
(47, 5, 15.00),
(48, 3, 25.00),
(48, 4, 25.00),
(48, 5, 20.00),
(49, 3, 20.00),
(49, 4, 20.00),
(49, 5, 15.00),
(50, 3, 30.00),
(50, 4, 30.00),
(50, 5, 25.00),
(51, 3, 30.00),
(51, 4, 30.00),
(51, 5, 25.00),
(52, 3, 20.00),
(52, 4, 20.00),
(52, 5, 15.00),
(54, 3, 20.00),
(54, 5, 15.00),
(55, 3, 20.00),
(55, 4, 20.00),
(55, 5, 15.00),
(56, 3, 20.00),
(56, 4, 20.00),
(56, 5, 15.00),
(57, 3, 20.00),
(57, 5, 15.00),
(58, 3, 20.00),
(58, 5, 15.00),
(59, 3, 25.00),
(59, 4, 25.00),
(59, 5, 15.00),
(60, 3, 20.00),
(60, 5, 15.00),
(61, 3, 20.00),
(61, 4, 20.00),
(61, 5, 15.00),
(62, 3, 20.00),
(62, 4, 20.00),
(62, 5, 15.00),
(63, 3, 15.00),
(63, 4, 15.00),
(63, 5, 10.00),
(65, 3, 20.00),
(65, 5, 15.00),
(66, 3, 20.00),
(66, 5, 15.00),
(67, 3, 20.00),
(67, 5, 15.00),
(70, 3, 20.00),
(70, 4, 20.00),
(70, 5, 15.00),
(71, 3, 20.00),
(71, 4, 20.00),
(71, 5, 15.00),
(72, 3, 20.00),
(72, 4, 20.00),
(72, 5, 15.00),
(73, 3, 20.00),
(73, 4, 20.00),
(73, 5, 15.00),
(74, 3, 20.00),
(74, 4, 20.00),
(74, 5, 15.00),
(75, 3, 20.00),
(75, 5, 15.00),
(76, 3, 20.00),
(76, 5, 15.00),
(77, 3, 20.00),
(77, 4, 20.00),
(77, 5, 15.00),
(78, 3, 20.00),
(78, 4, 20.00),
(78, 5, 15.00),
(79, 3, 20.00),
(79, 4, 20.00),
(79, 5, 15.00),
(81, 3, 20.00),
(81, 4, 20.00),
(81, 5, 15.00),
(82, 3, 20.00),
(82, 4, 20.00),
(82, 5, 15.00),
(84, 3, 25.00),
(84, 4, 30.00),
(84, 5, 20.00),
(85, 3, 20.00),
(85, 4, 20.00),
(85, 5, 15.00),
(86, 3, 20.00),
(86, 4, 20.00),
(86, 5, 15.00),
(87, 3, 20.00),
(87, 4, 20.00),
(87, 5, 15.00),
(88, 3, 20.00),
(88, 4, 20.00),
(88, 5, 15.00),
(90, 3, 15.00),
(90, 4, 15.00),
(90, 5, 10.00),
(91, 3, 20.00),
(91, 4, 20.00),
(91, 5, 15.00),
(92, 3, 20.00),
(92, 4, 20.00),
(92, 5, 15.00),
(93, 3, 20.00),
(93, 4, 20.00),
(93, 5, 15.00),
(95, 3, 20.00),
(95, 4, 20.00),
(95, 5, 15.00),
(96, 3, 20.00),
(96, 4, 20.00),
(96, 5, 15.00),
(97, 3, 20.00),
(97, 4, 20.00),
(97, 5, 15.00),
(98, 3, 20.00),
(98, 4, 20.00),
(98, 5, 15.00),
(99, 3, 20.00),
(99, 4, 20.00),
(99, 5, 15.00),
(101, 3, 20.00),
(101, 4, 20.00),
(101, 5, 15.00),
(102, 3, 20.00),
(102, 4, 20.00),
(102, 5, 15.00),
(103, 3, 20.00),
(103, 4, 20.00),
(103, 5, 15.00),
(104, 3, 20.00),
(104, 4, 20.00),
(104, 5, 15.00),
(105, 3, 20.00),
(105, 4, 20.00),
(105, 5, 15.00),
(106, 3, 20.00),
(106, 4, 20.00),
(106, 5, 15.00),
(107, 3, 20.00),
(107, 4, 20.00),
(107, 5, 15.00),
(108, 3, 20.00),
(108, 4, 20.00),
(108, 5, 15.00),
(109, 3, 20.00),
(109, 4, 20.00),
(109, 5, 15.00),
(110, 3, 20.00),
(110, 4, 20.00),
(110, 5, 15.00),
(111, 3, 20.00),
(111, 4, 20.00),
(111, 5, 15.00),
(112, 3, 25.00),
(112, 4, 25.00),
(112, 5, 20.00),
(113, 3, 25.00),
(113, 4, 25.00),
(113, 5, 20.00),
(114, 3, 20.00),
(114, 4, 20.00),
(114, 5, 15.00),
(115, 3, 20.00),
(115, 4, 20.00),
(115, 5, 20.00),
(116, 3, 20.00),
(116, 4, 20.00),
(116, 5, 20.00),
(117, 3, 20.00),
(117, 4, 20.00),
(117, 5, 20.00),
(118, 3, 20.00),
(118, 4, 20.00),
(118, 5, 20.00),
(119, 3, 20.00),
(119, 4, 20.00),
(119, 5, 15.00),
(121, 3, 20.00),
(121, 5, 15.00),
(122, 3, 22.50),
(122, 4, 22.50),
(122, 5, 18.00),
(123, 3, 20.00),
(123, 4, 20.00),
(123, 5, 15.00),
(124, 3, 22.00),
(124, 4, 22.00),
(124, 5, 17.00),
(125, 3, 23.00),
(125, 4, 23.00),
(125, 5, 21.00),
(126, 3, 20.00),
(126, 4, 20.00),
(126, 5, 15.00),
(127, 3, 20.00),
(127, 4, 20.00),
(127, 5, 15.00),
(128, 3, 7.50),
(128, 4, 7.50),
(128, 5, 6.00),
(129, 3, 7.50),
(129, 4, 7.50),
(129, 5, 6.00),
(130, 3, 7.50),
(130, 4, 7.50),
(130, 5, 6.00),
(131, 3, 7.50),
(131, 4, 7.50),
(131, 5, 6.00),
(132, 3, 7.50),
(132, 4, 7.50),
(132, 5, 6.00),
(133, 3, 20.00),
(133, 4, 20.00),
(133, 5, 20.00),
(133, 6, 20.00),
(134, 3, 20.00),
(134, 4, 20.00),
(134, 5, 20.00),
(134, 6, 20.00),
(135, 3, 20.00),
(135, 4, 20.00),
(135, 5, 15.00),
(135, 6, 28.00),
(136, 3, 20.00),
(136, 4, 20.00),
(136, 5, 15.00),
(136, 6, 28.00),
(137, 3, 20.00),
(137, 4, 20.00),
(137, 5, 15.00),
(137, 6, 28.00),
(138, 3, 20.00),
(138, 4, 20.00),
(138, 5, 15.00),
(138, 6, 28.00),
(139, 3, 20.00),
(139, 4, 20.00),
(139, 5, 15.00),
(139, 6, 28.00),
(140, 3, 20.00),
(140, 4, 20.00),
(140, 5, 15.00),
(140, 6, 30.00),
(141, 3, 20.00),
(141, 4, 20.00),
(141, 5, 15.00),
(141, 6, 25.00),
(142, 3, 20.00),
(142, 5, 15.00),
(142, 6, 30.00),
(143, 3, 20.00),
(143, 4, 20.00),
(143, 5, 15.00),
(143, 6, 28.00),
(144, 3, 20.00),
(144, 4, 20.00),
(144, 5, 15.00),
(144, 6, 28.00),
(145, 3, 20.00),
(145, 5, 15.00),
(145, 6, 30.00),
(146, 3, 20.00),
(146, 4, 20.00),
(146, 5, 15.00),
(147, 3, 20.00),
(147, 4, 20.00),
(147, 5, 15.00),
(148, 3, 20.00),
(148, 4, 20.00),
(148, 5, 15.00),
(149, 3, 20.00),
(149, 4, 20.00),
(149, 5, 15.00),
(150, 3, 20.00),
(150, 4, 20.00),
(150, 5, 15.00),
(151, 3, 20.00),
(151, 4, 20.00),
(151, 5, 15.00),
(152, 3, 20.00),
(152, 4, 20.00),
(152, 5, 15.00),
(152, 6, 28.00),
(153, 3, 20.00),
(153, 4, 20.00),
(153, 5, 15.00),
(153, 6, 28.00),
(154, 3, 20.00),
(154, 4, 20.00),
(154, 5, 15.00),
(154, 6, 28.00),
(155, 3, 20.00),
(155, 4, 20.00),
(155, 5, 15.00),
(155, 6, 28.00),
(156, 3, 20.00),
(156, 4, 20.00),
(156, 5, 15.00),
(156, 6, 28.00),
(157, 3, 20.00),
(157, 4, 20.00),
(157, 5, 15.00),
(157, 6, 28.00),
(158, 3, 20.00),
(158, 4, 20.00),
(158, 5, 15.00),
(159, 3, 20.00),
(159, 4, 20.00),
(159, 5, 15.00),
(160, 3, 20.00),
(160, 4, 20.00),
(160, 5, 15.00),
(161, 3, 20.00),
(161, 4, 20.00),
(161, 5, 15.00),
(162, 3, 20.00),
(162, 4, 20.00),
(162, 5, 15.00),
(163, 3, 20.00),
(163, 4, 20.00),
(163, 5, 15.00),
(164, 3, 20.00),
(164, 4, 20.00),
(164, 5, 15.00),
(165, 3, 20.00),
(165, 4, 20.00),
(165, 5, 15.00),
(165, 6, 30.00),
(167, 3, 20.00),
(167, 4, 20.00),
(167, 5, 15.00),
(168, 3, 20.00),
(168, 4, 20.00),
(168, 5, 15.00),
(168, 6, 30.00),
(169, 3, 12.00),
(169, 4, 12.00),
(169, 5, 12.00),
(170, 3, 20.00),
(170, 4, 20.00),
(170, 5, 20.00),
(171, 3, 20.00),
(171, 4, 20.00),
(171, 5, 15.00),
(172, 3, 20.00),
(172, 4, 20.00),
(172, 5, 15.00),
(173, 3, 20.00),
(173, 4, 20.00),
(173, 5, 15.00),
(174, 3, 20.00),
(174, 4, 20.00),
(174, 5, 15.00),
(175, 3, 20.00),
(175, 4, 20.00),
(175, 5, 15.00),
(176, 3, 20.00),
(176, 4, 20.00),
(176, 5, 15.00),
(177, 3, 20.00),
(177, 4, 20.00),
(177, 5, 15.00),
(178, 3, 20.00),
(178, 4, 20.00),
(178, 5, 15.00),
(179, 3, 20.00),
(179, 4, 20.00),
(179, 5, 15.00),
(180, 3, 18.00),
(180, 4, 18.00),
(180, 5, 13.00),
(181, 3, 18.00),
(181, 4, 18.00),
(181, 5, 13.00),
(182, 3, 20.00),
(182, 4, 20.00),
(182, 5, 15.00),
(183, 3, 20.00),
(183, 4, 20.00),
(183, 5, 15.00),
(183, 6, 30.00),
(184, 3, 20.00),
(184, 4, 20.00),
(184, 5, 15.00),
(184, 6, 30.00),
(185, 3, 20.00),
(185, 4, 20.00),
(185, 5, 15.00),
(186, 3, 15.00),
(186, 4, 15.00),
(186, 5, 10.00),
(187, 3, 20.00),
(187, 4, 20.00),
(187, 5, 15.00),
(188, 3, 20.00),
(188, 4, 20.00),
(188, 5, 15.00),
(188, 6, 30.00),
(189, 3, 20.00),
(189, 4, 20.00),
(189, 5, 15.00),
(189, 6, 30.00),
(190, 3, 20.00),
(190, 4, 20.00),
(190, 5, 15.00),
(190, 6, 30.00),
(191, 3, 20.00),
(191, 4, 20.00),
(191, 5, 15.00),
(191, 6, 30.00),
(192, 3, 20.00),
(192, 4, 20.00),
(192, 5, 15.00),
(192, 6, 30.00),
(193, 3, 20.00),
(193, 4, 20.00),
(193, 5, 15.00),
(193, 6, 30.00),
(194, 3, 20.00),
(194, 4, 20.00),
(194, 5, 15.00),
(194, 6, 30.00),
(195, 3, 20.00),
(195, 4, 20.00),
(195, 5, 15.00),
(195, 6, 30.00),
(196, 3, 20.00),
(196, 4, 20.00),
(196, 5, 15.00),
(196, 6, 30.00),
(9, 6, 30.00),
(11, 6, 30.00),
(12, 6, 30.00),
(13, 6, 30.00),
(14, 6, 30.00),
(74, 6, 30.00),
(197, 3, 20.00),
(197, 4, 20.00),
(197, 5, 15.00),
(197, 6, 30.00),
(198, 3, 20.00),
(198, 4, 20.00),
(198, 5, 15.00),
(198, 6, 30.00),
(199, 3, 20.00),
(199, 5, 15.00),
(199, 6, 20.00),
(54, 6, 30.00),
(57, 6, 30.00),
(58, 6, 30.00),
(60, 6, 30.00),
(65, 6, 30.00),
(66, 6, 30.00),
(75, 6, 30.00),
(76, 6, 30.00),
(121, 6, 30.00),
(169, 6, 30.00),
(200, 3, 20.00),
(200, 4, 20.00),
(200, 5, 15.00),
(200, 6, 30.00),
(201, 3, 20.00),
(201, 4, 20.00),
(201, 5, 15.00),
(201, 6, 30.00),
(202, 3, 15.00),
(202, 4, 15.00),
(202, 5, 10.00),
(203, 3, 20.00),
(203, 4, 20.00),
(203, 5, 15.00),
(203, 6, 30.00),
(204, 3, 20.00),
(204, 4, 20.00),
(204, 5, 15.00),
(204, 6, 30.00),
(21, 6, 20.00),
(22, 6, 30.00),
(24, 6, 20.00),
(25, 6, 20.00),
(26, 6, 20.00),
(27, 6, 20.00),
(28, 6, 20.00),
(82, 6, 20.00),
(110, 6, 20.00),
(112, 6, 30.00),
(113, 6, 30.00),
(114, 6, 20.00),
(170, 6, 30.00),
(171, 6, 20.00),
(205, 3, 20.00),
(205, 4, 20.00),
(205, 5, 15.00),
(205, 6, 25.00),
(206, 3, 20.00),
(206, 4, 20.00),
(206, 5, 15.00),
(206, 6, 30.00),
(209, 3, 25.00),
(209, 4, 25.00),
(209, 5, 20.00),
(209, 6, 25.00),
(210, 3, 20.00),
(210, 4, 20.00),
(210, 5, 15.00),
(210, 6, 25.00),
(211, 3, 20.00),
(211, 4, 20.00),
(211, 5, 15.00),
(211, 6, 30.00),
(212, 3, 20.00),
(212, 4, 20.00),
(212, 5, 15.00),
(212, 6, 30.00),
(213, 3, 20.00),
(213, 4, 20.00),
(213, 5, 15.00),
(213, 6, 30.00),
(214, 3, 20.00),
(214, 4, 20.00),
(214, 5, 15.00),
(214, 6, 30.00),
(160, 6, 35.00),
(215, 3, 20.00),
(215, 4, 20.00),
(215, 5, 15.00),
(215, 6, 25.00),
(16, 6, 30.00),
(17, 6, 30.00),
(216, 3, 20.00),
(216, 4, 20.00),
(216, 5, 15.00),
(216, 6, 25.00),
(217, 3, 20.00),
(217, 4, 20.00),
(217, 5, 15.00),
(217, 6, 20.00),
(218, 3, 20.00),
(218, 4, 20.00),
(218, 5, 15.00),
(218, 6, 30.00),
(219, 3, 20.00),
(219, 4, 20.00),
(219, 5, 20.00),
(219, 6, 30.00),
(220, 3, 20.00),
(220, 4, 20.00),
(220, 5, 15.00),
(221, 3, 20.00),
(221, 4, 20.00),
(221, 5, 15.00),
(222, 3, 20.00),
(222, 5, 15.00),
(222, 6, 20.00),
(223, 3, 20.00),
(223, 4, 20.00),
(223, 5, 15.00),
(223, 6, 30.00),
(224, 3, 15.00),
(224, 4, 15.00),
(224, 5, 15.00),
(224, 6, 20.00),
(225, 3, 20.00),
(225, 4, 20.00),
(225, 5, 15.00),
(225, 6, 30.00),
(226, 3, 20.00),
(226, 4, 20.00),
(226, 5, 15.00),
(226, 6, 30.00),
(227, 3, 20.00),
(227, 4, 20.00),
(227, 5, 17.00),
(227, 6, 20.00),
(228, 3, 20.00),
(228, 4, 20.00),
(228, 5, 15.00),
(228, 6, 30.00),
(229, 3, 20.00),
(229, 4, 20.00),
(229, 5, 15.00),
(229, 6, 30.00),
(230, 3, 20.00),
(230, 4, 20.00),
(230, 5, 15.00),
(230, 6, 30.00),
(231, 3, 20.00),
(231, 4, 20.00),
(231, 5, 15.00),
(231, 6, 30.00),
(232, 3, 20.00),
(232, 4, 20.00),
(232, 5, 15.00),
(232, 6, 20.00),
(233, 3, 20.00),
(233, 4, 20.00),
(233, 5, 15.00),
(233, 6, 30.00),
(234, 3, 20.00),
(234, 4, 20.00),
(234, 5, 15.00),
(234, 6, 30.00),
(235, 3, 20.00),
(235, 4, 12.00),
(235, 5, 15.00),
(235, 6, 25.00),
(238, 3, 20.00),
(238, 4, 20.00),
(238, 5, 15.00),
(238, 6, 30.00),
(239, 3, 20.00),
(239, 4, 20.00),
(239, 5, 15.00),
(239, 6, 30.00),
(240, 3, 20.00),
(240, 4, 20.00),
(240, 5, 15.00),
(240, 6, 30.00),
(241, 3, 20.00),
(241, 4, 20.00),
(241, 5, 15.00),
(241, 6, 30.00),
(242, 3, 20.00),
(242, 4, 20.00),
(242, 5, 15.00),
(242, 6, 30.00),
(243, 3, 20.00),
(243, 4, 20.00),
(243, 5, 15.00),
(243, 6, 30.00),
(244, 3, 20.00),
(244, 4, 20.00),
(244, 5, 15.00),
(244, 6, 30.00),
(245, 3, 20.00),
(245, 4, 20.00),
(245, 5, 15.00),
(245, 6, 30.00),
(246, 3, 20.00),
(246, 4, 20.00),
(246, 5, 15.00),
(246, 6, 30.00),
(247, 3, 20.00),
(247, 4, 20.00),
(247, 5, 15.00),
(247, 6, 30.00),
(248, 3, 1.00),
(248, 4, 1.00),
(248, 5, 1.00),
(248, 6, 1.00),
(249, 3, 20.00),
(249, 4, 30.00),
(249, 5, 15.00),
(249, 6, 20.00),
(250, 3, 20.00),
(250, 4, 20.00),
(250, 5, 15.00),
(250, 6, 30.00),
(251, 3, 1.50),
(251, 5, 1.00),
(251, 6, 2.00),
(252, 3, 1.50),
(252, 5, 1.00),
(252, 6, 2.00),
(48, 6, 30.00),
(46, 6, 25.00),
(47, 6, 25.00),
(49, 6, 25.00),
(177, 6, 25.00),
(220, 6, 25.00),
(221, 6, 25.00),
(258, 3, 30.00),
(258, 5, 25.00),
(258, 6, 40.00),
(259, 3, 30.00),
(259, 5, 25.00),
(259, 6, 40.00),
(260, 3, 30.00),
(260, 5, 25.00),
(260, 6, 40.00),
(261, 3, 30.00),
(261, 5, 25.00),
(261, 6, 40.00),
(262, 3, 30.00),
(262, 5, 25.00),
(262, 6, 40.00),
(263, 3, 30.00),
(263, 5, 25.00),
(263, 6, 40.00),
(264, 3, 30.00),
(264, 5, 25.00),
(264, 6, 40.00),
(265, 3, 30.00),
(265, 5, 25.00),
(265, 6, 40.00),
(266, 3, 30.00),
(266, 5, 25.00),
(266, 6, 40.00),
(267, 3, 30.00),
(267, 5, 25.00),
(267, 6, 40.00),
(268, 3, 30.00),
(268, 5, 25.00),
(268, 6, 40.00),
(269, 3, 30.00),
(269, 5, 25.00),
(269, 6, 40.00),
(270, 3, 30.00),
(270, 5, 25.00),
(270, 6, 40.00),
(271, 3, 30.00),
(271, 5, 25.00),
(271, 6, 40.00),
(272, 3, 30.00),
(272, 5, 25.00),
(272, 6, 40.00),
(273, 3, 30.00),
(273, 5, 25.00),
(273, 6, 40.00),
(274, 3, 30.00),
(274, 5, 25.00),
(274, 6, 40.00),
(275, 3, 30.00),
(275, 5, 25.00),
(275, 6, 40.00),
(276, 3, 30.00),
(276, 5, 25.00),
(276, 6, 40.00),
(277, 3, 30.00),
(277, 5, 25.00),
(277, 6, 40.00),
(278, 3, 30.00),
(278, 5, 25.00),
(278, 6, 40.00),
(279, 3, 30.00),
(279, 5, 25.00),
(279, 6, 40.00),
(280, 3, 30.00),
(280, 5, 25.00),
(280, 6, 40.00),
(281, 3, 30.00),
(281, 5, 25.00),
(281, 6, 40.00),
(282, 3, 30.00),
(282, 5, 25.00),
(282, 6, 40.00),
(283, 3, 30.00),
(283, 5, 25.00),
(283, 6, 40.00),
(284, 3, 30.00),
(284, 5, 25.00),
(284, 6, 40.00),
(285, 3, 30.00),
(285, 5, 25.00),
(285, 6, 40.00),
(286, 3, 30.00),
(286, 5, 25.00),
(286, 6, 40.00),
(287, 3, 30.00),
(287, 5, 25.00),
(287, 6, 40.00),
(289, 3, 25.00),
(289, 4, 20.00),
(289, 5, 20.00),
(289, 6, 20.00),
(290, 3, 30.00),
(290, 5, 25.00),
(290, 6, 40.00);

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

--
-- Estructura de tabla para la tabla `advisers_schedules`
--

CREATE TABLE `advisers_schedules` (
  `id_schedule` int(11) NOT NULL,
  `id_adviser` int(11) NOT NULL,
  `date_schedule` date NOT NULL,
  `event_schedule` varchar(150) NOT NULL,
  `color_event` varchar(100) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `advisers_schedules` (`id_schedule`, `id_adviser`, `date_schedule`, `event_schedule`, `color_event`, `create_date`) VALUES
(2, 7, '2022-03-08', 'Nuevo', 'rgb(186, 139, 0)', '2022-03-08 03:59:21'),
(3, 67, '2022-05-26', 'Alejandro', 'rgb(0, 102, 211)', '2022-05-13 15:47:41'),
(4, 119, '2022-07-08', 'Yoel salas ', 'rgb(0, 123, 255)', '2022-07-08 16:42:06'),
(6, 114, '2022-08-22', ' Primer día ', 'rgb(186, 139, 0)', '2022-08-22 16:07:26'),
(7, 114, '2022-08-22', 'Primer día ', 'rgb(186, 139, 0)', '2022-08-22 16:06:06'),
(8, 226, '2022-12-22', 'Cumpleaños ', 'rgb(0, 86, 179)', '2022-11-30 10:53:03'),
(9, 251, '2023-05-15', 'viaje', 'rgb(0, 106, 219)', '2023-03-30 21:47:17'),
(10, 251, '2023-05-29', 'retorno', 'rgb(0, 103, 213)', '2023-03-30 21:47:40'),
(11, 251, '2023-04-28', 'Bee 4 in 1', 'rgb(0, 120, 249)', '2023-04-27 19:48:48'),
(12, 251, '2023-04-28', 'Bee 4 in 1', 'rgb(186, 139, 0)', '2023-04-27 20:05:02'),
(13, 281, '2023-07-25', 'Cotizar', 'rgb(0, 86, 179)', '2023-07-25 11:28:56'),
(14, 282, '2023-08-23', 'Se', 'rgb(0, 86, 179)', '2023-08-09 19:23:16');

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

--
-- Estructura de tabla para la tabla `agencies`
--

CREATE TABLE `agencies` (
  `id_agency` int(11) NOT NULL,
  `name_agency` varchar(100) NOT NULL,
  `level_agency` int(11) NOT NULL,
  `id_father` int(11) DEFAULT NULL,
  `id_status` int(11) NOT NULL DEFAULT 1,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `email_agency` varchar(100) NOT NULL,
  `phones_agency` varchar(50) NOT NULL,
  `pass_agency` text DEFAULT NULL,
  `token` text DEFAULT NULL,
  `token_agency` text DEFAULT NULL,
  `sesion_token` varchar(100) DEFAULT NULL,
  `date_sesion` date DEFAULT NULL,
  `id_profile` int(11) NOT NULL,
  `id_reference` varchar(30) DEFAULT NULL,
  `names_reference` varchar(100) DEFAULT NULL,
  `comision_fee` double(20,2) DEFAULT NULL,
  `login_token` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `agencies` (`id_agency`, `name_agency`, `level_agency`, `id_father`, `id_status`, `id_user`, `create_date`, `email_agency`, `phones_agency`, `pass_agency`, `token`, `token_agency`, `sesion_token`, `date_sesion`, `id_profile`, `id_reference`, `names_reference`, `comision_fee`, `login_token`) VALUES
(1, 'Bee Insurance Agency LLC', 0, NULL, 1, 3, '2022-01-31 12:11:09', 'beesist@bee-insurance.com', '0584248943284', '$2y$12$bkSsbM8muaN4X7MgdBgEvelvRX1sra6AEVa9sTJyCN0lPd8eJ4zmW', '3304eea4d7425f09117c5f0c95be8457', '$2y$12$Y/coi.7A6pfj78NDXLGNref6Tzj5vPisIjoWSqYnVFnjZ2YjYGpMu', '96b523662643ab2c83f50c2f07d2be89', '2023-03-03', 3, NULL, NULL, NULL, NULL),
(13, 'BENEFITS', 1, 1, 1, 1, '2022-07-08 18:14:28', 'danitineo1969@gmail.com', '04143618802', '$2y$12$kmYk.cTBmgFmCs.T6VxBKeh6O1c/Zbr5xxluqJu4O5miP.o.3uUYO', 'b0a0539ec325f11adef029cb7f3ce835', '$2y$12$7elDi5sNcNlmWclGd8YyD.kI7U6CA4vP5UCr0hFdplYhxPX..Gdze', 'e2220af252fd2f01449570e016718222', '2022-10-07', 4, NULL, NULL, 0.00, NULL),
(14, 'JB INTERNATIONAL INSURANCE', 1, 1, 1, 1, '2022-08-18 14:42:14', 'manmarcorretaje@gmail.com', '04122134031', '$2y$12$e6q4dq7UWy1nPpWmwkse4.YhuRxxprXGUYMvPTtpc.B0YQMzWcKnu', '86f95d8db062b43af78863a12fce4aff', '$2y$12$mqy2Imxzo/48gpw2A.LnF.7ZA1HWlutVZPeAis5iXDf1TfluRZDni', '22497cd67c5e304a2b7c925de58b1695', '2022-09-27', 4, NULL, NULL, 0.00, NULL),
(15, 'Development Soft', 1, 1, 1, 1, '2022-03-08 03:09:31', 'developmentsoft@hotmail.com', '123456789', '$2y$12$CyckMUZWYegWQcXfSlgZJ.DQ4CFmMVqB8brLYOa9lTfRwzZXK2Aje', '33d7796dc2e222159ad5697baab2bb63', '$2y$12$Gh64rZnDv4ScOCsiea77t.Q1OIl6DOLDv0G2fDdSsaYKhB9vgO1w6', 'bc9ee8dd73228f60946b5f812c5388ee', '2022-04-29', 4, NULL, NULL, NULL, NULL),
(16, 'Development Agencias', 2, 15, 1, 15, '2022-04-05 17:02:20', 'developmentagencias@hotmail.com', '123456789', '$2y$12$CyckMUZWYegWQcXfSlgZJ.DQ4CFmMVqB8brLYOa9lTfRwzZXK2Aje', 'd3d5a4071fd4ac0e31c63e158df37a72', '$2y$12$U7ou5fWMH0YiFAkqEzlZfODwxWv8OTp20BMZQSUCCqmYxBxjmXGyu', 'ec5cd7b72bab6cbcfe7df6589c1a6070', '2022-06-22', 5, NULL, NULL, NULL, NULL),
(17, 'NP INTERNACIONAL', 1, 1, 1, 1, '2022-07-08 18:16:11', 'nadeskapina@gmail.com', '+584143372914', '$2y$12$WIKqly/2ADxvaXZn8UrviOD4QxIDaRzigkIg2oPBX7a.a2SJZHrXC', '086eca3cdf100054f9453ed7077b79d3', '$2y$12$bkqWYMCK95vno1sUMKPPGeDGbKi84jrwR6zieF1ZvQszrBhy0f39S', 'fe20c9a6e8f767220267382ccc35d3a1', '2023-03-07', 4, NULL, NULL, 0.00, NULL),
(18, 'Almary Valera', 2, 14, 1, 14, '2022-08-19 09:47:58', 'almaryfianzas@gmail.com', '04122134031', '$2y$12$c5Va07yiCZ61V6VMph.Tnet2D0j2TCqSP.Jp1Ein.eA55ol2/NWlW', '3c03b9c4e6879c2f96e52dce72dcf95e', '$2y$12$4DBAycbynwMlAv79SwR8a.zA0/pW5rNppMWywbkkL1nOBDCrxTz7a', '5ac326d1581ba861ce45fc2137fe1af7', '2023-03-06', 5, NULL, NULL, 0.00, NULL),
(19, 'Jerry Gil', 2, 14, 1, 14, '2022-08-19 09:48:37', 'jerrygilseguros@gmail.com', '04126084199', '$2y$12$85lhlFDLiVYP6KIDTHFxU.GzSoVZcH1yZQ82gl7674sXzzww0F/vi', 'f5c002225ac9e0fd6c5361bce42ff408', '$2y$12$pxzHNl7AOIcBv9Oy47tFHeszmYlrz66r9MFwUuymacFGmDUPjUzMe', '84743974530a3f892d5fe612b109d048', '2023-02-06', 5, NULL, NULL, 0.00, NULL),
(20, 'BENEFITS II', 1, 1, 1, 1, '2022-07-08 18:14:45', 'benefitsasesores@gmail.com', '04122338737', '$2y$12$/q/xpK.UHoiKBPuoJz1VLucPEu1wYLhPc6zK3mvhr4FVQWkhy5Yiy', 'b259a4e208d7ce3f4467fcd65d128766', '$2y$12$xZE0DnwNnHdN6cOiNBU.q.jcCF3zeRJDoLiq1fDtzF3MmLqIwLeGu', 'b2c9dd28eca28b69cc8fdaf5a754ffac', '2023-02-08', 4, NULL, NULL, 0.00, NULL),
(21, 'PAULINO RAFAEL ORTEGA O.', 1, 1, 1, 1, '2022-07-08 18:16:32', 'director@prooadvisors.com', '04122508465', '$2y$12$ympwX2FpIbMDQRiH3BhjVezbXQnj1cmT34Fiag9ocpxXKDCjQSsrS', '3b52604369a06292f343eb7e58b409bf', '$2y$12$8iv1vbr.DYU9jtQFNKyCzurdHqnDX9BCFfzHQKio2rSAcTr1nZ90.', 'e8601c4dc19444a13930b995074e44d9', '2022-07-13', 4, NULL, NULL, 0.00, NULL),
(22, 'PREVENTIVA GLOBAL ASSIST, C.A.', 1, 1, 1, 1, '2022-07-08 18:17:11', 'aredondoseguros@gmail.com', '04148335089', '$2y$12$1ftL4iv0onqSJBaejWeZUe8DaEKzyXxey5wyAafOooAnxxC3WOX8u', '07101d544bbdf3233930a2fbe64448fb', '$2y$12$ubp14fOZFPoGFSsrM1y/.eHB/OawepkE26Dq/TskdWjJed0cVkQE2', '0ae7647d682a13a37e2ea28557ac9e4a', '2023-03-08', 4, NULL, NULL, 0.00, NULL),
(23, 'VILLASMIL & ASOCIADOS', 1, 1, 1, 1, '2022-07-08 18:17:49', 'villasyasocs@gmail.com', '04142418734', '$2y$12$.5LHtyBoJWctZj/HbxrW1.1GF6IsMoRDbHEFSIdFwOA.KngQxTWye', '676b5a45011ba98a94aa8e6cb1e75cdd', '$2y$12$hybFGQ86pz7tuRTIbCJXiOjHL4pyjZw0DnhWB4cRp8D9SlJfzkpxK', '8be6e6a247b9c6d965df60c4730bf3c3', '2023-02-14', 4, NULL, NULL, 0.00, NULL),
(24, 'BELISARIO INTERNACIONAL', 2, 17, 1, 17, '2022-03-21 14:23:48', 'kbelisario90@gmail.com', '04241386447', '$2y$12$U3cN3RFpeAQ.H8b41CekiOz2elnoYE43x.CNcUcYnI0WNJvuqpwfG', '4f74e9236d69458fcdab583d57174ba2', '$2y$12$4juTym/a3hwap05MULrWe.YHdTG1tfFQkS1LmIQlZ6R.lQWe256Qy', 'f36919d4f6edb18fdc616758acd340b8', '2022-06-10', 5, NULL, NULL, NULL, NULL),
(25, 'BEE AGENCY MASTER', 1, 1, 1, 1, '2022-07-08 16:45:15', 'dpacheco@bee-insurance.com', '+1 (786) 7825313', '$2y$12$GyiiSp77Gtt9wnAIuneHx.DO6BJGLC3Z30hkHMNq5CXjRkqjt9Ks.', 'a0b0a0624ed9aefdaf08ffc5e4eebd7a', '$2y$12$h3s1lP19R3M7yiURNpRBu.5CsFotCfJHm0yFMiJnAje7c8/swqNcS', 'e3288e1769d212c86df792273ac5319b', '2023-03-08', 4, NULL, NULL, 0.00, NULL),
(26, 'YCH INSURANCE', 2, 25, 1, 25, '2022-08-15 08:57:34', 'yennychaffardet@gmail.com', '04142308428', '$2y$12$l8IgsofVC7yITMpOCBx1c.dqynO2VC3iD9VewmN0yAmThfmnYcUYK', '37be9ac91eb5f9e21a59d69d32908aac', '$2y$12$41oi4eWcsA09bfjE2Kz4yepGN.ffQhQpBiENMJvfiIcIF6r0z5Akm', '3ba856bfdc98920f39c2917659d7e6be', '2023-02-24', 5, NULL, NULL, 0.00, NULL),
(27, 'Griselda M. Aguilar D.', 2, 25, 1, 25, '2022-08-15 08:57:49', 'grisvic2015@gmail.com', '04142055112', '$2y$12$aVPsnMgSttbLJt5nzKoc0u8bMSAIINHCZ4h2SFLuRw4RkRdWIL0ie', '2006d3e29f7ee4dc26a40615815e9afb', '$2y$12$urInQurtzuAYRG6ikZxe0.tG7ixr4sRmJvoSRmf/eRkt4i5U9QpC6', '1465b135132cea2b51fcff7d78aa0402', '2022-03-23', 5, NULL, NULL, 0.00, NULL),
(30, 'Yoward Agencia', 2, 15, 1, 15, '2022-04-05 17:07:48', 'diazbasket5@hotmail.com', '12345678', '$2y$12$NphZs7s5rIJbMhR7nQclpO8uJSjD0WTcY2pRmZYrA8AOCHVtcBKV6', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL),
(31, 'ABP ADVISOR', 1, 1, 1, 1, '2022-07-08 18:13:52', 'advisors.int.services@gmail.com', '04243127885', '$2y$12$iRdkyhjMiRO6Nu0ke3.ZR.MEIdNVR0WxHAWnsH06aEZq9/rDvioYe', '526322e8ee1441330b7c7847e531888c', '$2y$12$xWjWMZ3PzYc/RQ21QPXJiuHlv23xSOAbSQfJ0jjywB3DpenpFdLry', 'd3fae5dc1cd152cbda31238c66147ecd', '2023-01-23', 4, NULL, NULL, 0.00, NULL),
(32, 'SC VALENCIA', 1, 1, 1, 1, '2022-07-08 18:17:29', 'amibarra1961@gmail.com', '04244176011', '$2y$12$GPn2t8f9LsFC9pIYFsSxq.Zt1I.TgbvOt4pubhMmWZlP7bA/Ab9aW', '34d219108c7b4a12dff05a7345a2e973', '$2y$12$YT2chFakUdcx0nuiQdYBgu9moDOUt782nVtcyB72cQ23i6Z0vc.Y6', '9e7ab7be7245b3ebd6068efe3655b97c', '2023-03-06', 4, NULL, NULL, 0.00, NULL),
(34, 'MAX ASESORES', 1, 1, 1, 1, '2022-07-08 18:15:48', 'maxasesores.seguros@gmail.com', '04143232481', '$2y$12$3xspk5YLw6WQxnMKJM28NOb1n5SWo/FhLmr8dIvNsmEElgRGU1eeu', 'b2563d396ac1a7cfab119897e71aa91b', '$2y$12$DAfVwADK5KXkLGANbExPCu3mZZCxuhEMlu/KzER9YcE8AvirYbZP.', '27e00bca281f248d6b8bffdc709b703b', '2023-02-02', 4, NULL, NULL, 0.00, NULL),
(35, 'CARMEN HINESTROZA', 1, 1, 1, 1, '2022-07-08 18:14:59', 'hinestrozaconsultores01@gmail.com', '04246770824', '$2y$12$M9Ow.LlUOXkWc2.MUtJWouRd..NMkGEnq602MbrH1.kKxyf0wAKyu', '2d13048224ca68dda3e76ed49694e380', '$2y$12$PuC3w1eaqwdKse0U/Pr.6.fdsB0jzA5xjwsayE5iX3AmZGdFJiO1W', 'c2a11754acc52a3269776ffa845a9187', '2023-02-20', 4, NULL, NULL, 0.00, NULL),
(36, 'AASP', 2, 25, 1, 25, '2022-08-15 08:58:03', 'aasp3010@gmail.com', '04149821476', '$2y$12$CyckMUZWYegWQcXfSlgZJ.DQ4CFmMVqB8brLYOa9lTfRwzZXK2Aje', 'bcd12517b0abf747d32fdfe8095b9546', '$2y$12$xKsICFVqzdrLTEJQ8w8iVuBWD0dO.HnAI6etpxQuK/CEcL/IESG2y', '30bea03086c873c5118e42ae4e2dac04', '2022-11-09', 5, NULL, NULL, 0.00, NULL),
(41, 'Benefits 2 Agencia ', 2, 20, 1, 20, '2022-05-06 11:32:55', 'sousitagold@gmail.com', '+584122338737', '$2y$12$R2xM1tk6fM2ByenkpxhwDeNJZfzQJZy.Anh8U2GwqP7d0LA68YkS2', 'b0c7e6893e428430cd7221e980c15c9e', '$2y$12$2tOSngp72HvGdd04FBQw6ePu1fNZImKb7Q.pzWBbi/G8PSMi2BXD.', '8673361ab15a9f5745269d845ba01ed0', '2022-07-22', 5, NULL, NULL, NULL, NULL),
(43, 'Bellcorp Assist - Lizbecth Belloso', 2, 13, 1, 13, '2022-05-27 12:53:02', 'bellcorpassist@gmail.com', '4246486473', '$2y$12$/Ha3QRFKARn/v/K1zUBN3u/riuugjqfxAVNz3pKsFZiFzsMU8xMoK', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL),
(44, 'JOSE RAFAEL HERNANDEZ REVILLA', 2, 22, 1, 22, '2022-04-13 12:44:06', 'jhernandezrevilla@gmail.com', '+584248294120', '$2y$12$6l7cyLVyz4IbMfS2kUqyIuFobCJafOrjXELWfsV2DSwtQwHJ4G6pK', '28ed6872841b230597c1783f998265b4', '$2y$12$a5/iawCJPkB9FCHmMvgdA.NeIi6k9PaMgevrB824zoeFScwP5zuQu', 'a1a6ed3f36a60d449716ff0feaee602d', '2022-07-10', 5, NULL, NULL, NULL, NULL),
(45, 'AGUILAR & ASOCIADOS', 1, 1, 1, 1, '2022-07-08 18:14:07', 'aguilaryasociadosca@gmail.com', '04143448251', '$2y$12$LkcHDMjUrHZNWsvePQZWZOlslg8sH0Rh9FxTkrWGtch/w.WHA.fGG', '41942ee292a321599c07f15755bb5df9', '$2y$12$io7ngoqyH8seBShHDFMDSOfdi1bM0DgFiMRsgFxgKQi1iLisuybFW', '2db64a2193c2fce44131dd0b7e626b2c', '2023-01-25', 4, NULL, NULL, 0.00, NULL),
(46, 'PEDRO FIGUERA', 2, 31, 1, 31, '2022-07-02 16:13:42', 'pfpseguros@gmail.com', '+584141449030', '$2y$12$lPEsN8yUH7BuuuIX/v1Bfem2wX6KZoXLxZBuNGuhtzLr2qvM4OzOG', '6b0a003db77877224b896116070154b5', '$2y$12$lmtCw3DKPayjBTsgi.mwf.AIWVYehPDOqcLEb4ENpUivzT4r5geza', '33408288e1e0d6db1ed143dfac147e97', '2023-01-24', 5, NULL, NULL, 0.00, NULL),
(48, 'CARMEN HINESTROZA', 2, 35, 1, 35, '2022-11-24 12:42:02', 'consultoresinternhc@gmail.com', '04246770824', '$2y$12$jJbG/4VaWbQupiDPTlZvvu4uER1Bfz9qLZ/wKX9r4mm.Zdi26VFzO', '991683df248a30ac5881cb08abe629f4', '$2y$12$9TLTW6ngejdyDQ2LbAo9fO5ml.ouqzYeycIz1XoTnb52PZVyu2rRO', '4ede9bd67e723b73bbdce3c55ad3a0bd', '2023-03-06', 5, NULL, NULL, 0.00, NULL),
(49, ' MILAGROS CUADRADO', 2, 35, 1, 35, '2022-10-14 09:50:31', 'yamilagros@hotmail.com', '0424-6749916', '$2y$12$fusdaX4Spm9VywUkOA9KWeX9.BTXajaTrPY/5yLUSUuaG4yU8ITSe', 'cc76087efb92b7f3d46e8622b59570d6', '$2y$12$RPn8I4c3pABYSmHLoOT0u.Gr6xWOAp.hqBAu9wITJETu04a/7zLA2', 'f00a9922baf4b1d0c702e168ea3ed02c', '2022-07-15', 5, NULL, NULL, 0.00, NULL),
(50, 'AGENTES BEE', 2, 25, 1, 25, '2022-08-15 08:58:11', 'beeinsuracephone@gmail.com', '04248943284', '$2y$12$Q30iS8ZmI0jasmkX.hCRputimrBKGAP4kwlSwX7Y7DPyHkPbODyMa', '532f5af5b83d697ceec691f3e0aa21f3', '$2y$12$bBvyoMdtM4TJT.3.j8yiaemjvObbEyPjGVVTtW1ODnYmBJqsMx2Te', '66006234f61936aef88264cdc53e981b', '2023-01-24', 5, NULL, NULL, 0.00, NULL),
(51, 'GLOBAL ASSISTANCE INSURANCE', 1, 1, 1, 1, '2022-07-08 18:15:15', 'Globalassistanceinsurance@gmail.com', '+1(305)9272928', '$2y$12$EwRPL1UMT.Una4tXoieMA.pYWdYdbmjAQxeF06Wscr48DwPBxE0g2', '0b2a1a9edecac4f13a13dc9023daf3cf', '$2y$12$URlwxhSlCbp3Uz.CikBQpe9a9y1dNxycu1Rkvjj4lo4cJotHt/RXa', '63c51831fdb8f0844f09a8fd626eef99', '2023-02-01', 4, NULL, NULL, 0.00, NULL),
(52, 'RAFAEL ANDRADE', 2, 35, 1, 35, '2022-10-14 09:49:02', 'marc.intl.insurance@gmail.com', '0414-3605005', '$2y$12$7gRSFLWCcYl/NiadXYjoLO7zf4muKekQkgAe19.3TmCePHyYlA/we', '07d3a0c2ad48593b9951fd1699667a56', '$2y$12$rQN9Pb5ZhJhG1o61bOhoE.KFno3aODPE74sXwpzNG0qSxugyEdDbC', '356494fb0eaf238493eedc05424d0145', '2022-11-24', 5, NULL, NULL, 0.00, NULL),
(53, 'Villasmil & Asociados ', 2, 23, 1, 23, '2022-04-20 11:52:30', 'villas55@gmail.com', '04142418734', '$2y$12$t66PXJRCkR5ISuFJCFQ2mOPNeiWm8e/6xLl0RRVr7PHNhpYS14d/C', 'ac4a267c4729fbdd4ad4559d7a8009b1', '$2y$12$EDxn9CTGzvp/0sGG6G5Rnu8BdZHqgaWKbzttWYLvTwbk6Y.kcORza', 'f91be689f26f91bef9740da2efdde737', '2022-04-20', 5, NULL, NULL, NULL, NULL),
(54, 'CARLOS ZAMBRANO ', 2, 35, 1, 35, '2022-11-24 12:42:38', 'carloszambrano_9@hotmail.com', '04143617752', '$2y$12$BIRA9cxZMIWqRSsRYLTUcOWNS5jUVGh6wl8sOUQmv5d747uNUs/G2', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(55, 'EVSEGUROS', 2, 22, 1, 22, '2022-04-20 18:06:47', 'algise.betancourt@evseguro.com', '+584128756000', '$2y$12$bKt9ngP6cgQzn2Jj67piLuQ1w6aFaMAqwWhSkYUKWvbHyEc7qgRU2', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL),
(56, 'LIDERES EN SEGUROS', 2, 22, 1, 22, '2022-04-20 18:10:35', 'lideresenseguros.1@gmail.com', '+584140951011', '$2y$12$76QbswkX7WtHDrSJ5zQwaeH0behvdrF23Dx4Rv3Zij0VFReHIVdBS', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL),
(57, 'MAYRA HERRAN', 2, 13, 1, 13, '2022-04-21 17:03:55', 'mayra.herran@gmail.com', '4143650310', '$2y$12$4IHAaIayk/iajEsqgybkeOGiqu2QrYmX/y2jU12W6FPgIkfIdP0gW', 'dbfa62d2685fa8e3a3da04ca0bf0a656', '$2y$12$tMnypx9TbkN2o5nf6GOWDuSiLZyJNmbc/4g3UbGwNM6fepHcHp3Im', '0fdc0403a5fa15b3dcee4a0849a46ad6', '2022-05-27', 5, NULL, NULL, NULL, NULL),
(58, 'MARTHA ZAPATA', 2, 13, 1, 13, '2022-04-21 17:05:37', 'marthazapata2007@hotmail.com', '4141712820', '$2y$12$FYorUXlJvKdlY8fmHhv0C.sLv/7Phq/AQ/FgZ.mWYV3BSksCJFk5q', '181023b2cafb206c3ae8e388c5aadf9e', '$2y$12$Tif8CtjP/UIR66IYfWWDdutLiu/wd1eZ8RbnxN0cLTlaO.t3Le/KG', '02d377038a251eb9023fdfb248a95b4c', '2022-06-20', 5, NULL, NULL, NULL, NULL),
(60, 'Global Assistance Agencia', 2, 51, 1, 51, '2022-04-22 14:49:17', 'moises@paratiseguros.com', '954259965', '$2y$12$adPwUUO64wJrUFXQKy5nQuxhK49zSf7r4zut.GY9RGmNs.ePBdZ4S', '249aa3b22a08cf7de8a07c8e94f756bc', '$2y$12$hY.UywwvhnZuTWpwj7l1EOQJ3475p8DdWFeKzZo1QWsbzGt7A36T.', '9069322808a251db0b4c6129a49d7189', '2022-12-13', 5, NULL, NULL, NULL, NULL),
(61, 'Patricia Sulbaran', 2, 20, 1, 20, '2022-04-22 16:30:10', 'sivcasoluciones@gmail.com', '+584146578534', '$2y$12$/n/81Fn5oNOQtM0CxszSoerJNPzsH8/YF0MxjBE47nj7GVw7/B0dq', '05138471cc407dccb13f970cff57855d', '$2y$12$5YdkniJytU7Ba.MiStEK4e5gQROlHDZXLhlGwfKr4HlxBfxVhzZWK', '016c09bf4f4b4a99ba183b5df671a508', '2022-05-31', 5, NULL, NULL, NULL, NULL),
(62, 'MV Consultores', 2, 20, 1, 20, '2022-10-04 16:02:39', 'mvconsultores7@gmail.com', '+584146827375', '$2y$12$1j6Afj22BggrzDybxziZd.ta69Nynv2nCF9HqtEoCBJEaeIEz11lW', 'f10bf58afbd95bb6fa9972ee3feabcc7', '$2y$12$ANYoyIyUfHfYbtjqW9U3zeIqAMzFIMXjj9h0hxa9O5wCGchtm5ycS', '0fb716dd986603e696e43270b4099c78', '2022-12-29', 5, NULL, NULL, 0.00, NULL),
(63, 'JULIO CARRERO', 2, 22, 1, 22, '2022-04-25 15:23:13', 'jcarrerom@gmail.com', '+584141038566', '$2y$12$kBY8.yJ28NMvWM1ZItbcZOggHCkTKRw/52ovHn2v6AVpnJ3rTQzDm', '6061d65e31579fa8ffebe278b76b0ea2', '$2y$12$ejP0Ip.xgQXYtLq5NLXcFeTndAEYPy7pAOSdVNy70G.CfgtDv1QZe', '149b71172cd900a201444f069d687cf4', '2022-07-13', 5, NULL, NULL, NULL, NULL),
(64, 'AREDONDO SEGUROS', 2, 22, 1, 22, '2023-04-02 16:13:53', 'aredondo19@GMAIL.COM', '+584148335089', '$2y$12$kiIPjLdoQlUYcWV5QtEKkupVvSOUeqKGdT/dAgTDm74diH1dU2U4i', 'ae7cf038c8a35a067d7cf4e172df26d2', '$2y$12$X6t4mFg6jhO4fxTiYxPTJOOyQrnqpTOJpuiyU7Lnn2YRi0ZMXdQu6', 'fda63ba43f922cbb19f3b48edbf31db5', '2022-11-16', 5, NULL, NULL, 0.00, NULL),
(65, 'Aitor N Ibarra B', 2, 32, 1, 32, '2022-05-02 11:35:15', 'aitoribarrab@gmail.com', '04124431702', '$2y$12$xCtXx9QjCpCaWaJw.y8eQuRYYNJkZhozeu8eZWUP3lS/MGwmLPMaq', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL),
(66, 'YV INSURANCE SOLUTIONS', 1, 1, 1, 1, '2022-07-08 18:18:07', 'yv.insurance.solutions@gmail.com', '+178658.9329', '$2y$12$UZhvvUCvfB6f8Ri79pU0ce/sRDz3IQ22oSxYsUTxa0dkFO2Yz9ekW', 'e442890b222c5bae2f443cbce7c84bb6', '$2y$12$Jafqol15zxqqiYAMlbknp.f1v/jvtOZAucqAvXkP4dgnrXmOCDovW', '21c0dcbb44ed85f1e2301137c4b39295', '2023-02-16', 4, NULL, NULL, 0.00, NULL),
(67, 'ELYBETH COLMENARES', 2, 51, 1, 51, '2022-05-03 13:52:15', 'Elybethcolmenares.fbg@gmail.com', '+12393848116', '$2y$12$l3I54cky1EG6D.MIajkUSu1IOn8UrkyXnYzBX0X6Ba8eF.cfWB1MW', '953b48debede295c909440dcde13a66c', '$2y$12$LUH8jXTzb0U2ExQc/kC8oOyo05YTAwxUK4x1P8VwEx2a01wtuI3Li', 'a05c441d77748b4d06ec36e915bc6e60', '2022-08-21', 5, NULL, NULL, NULL, NULL),
(68, 'Manuel Isaac Rodriguez Fernandez', 2, 66, 1, 66, '2022-08-15 11:20:14', 'manuel.Rodriguezf1968@gmail.com', '+584141176966', '$2y$12$89ZG1LjSiqLLvXZ7qv42guyHjVLGb5q6zxiCa2FCC1ieKB6EQC.pG', 'e66b985f381f5e0b4567f9351a16969d', '$2y$12$XkFMFjw5WH6GTbM1cHq/.OaqGtEamxXAUJBiXpSiNGmX9/MP7ONtS', '627d0ac00794c5b64209846c34238e87', '2022-07-08', 5, NULL, NULL, 0.00, NULL),
(69, 'Belkis Ines Carrion Mendez', 2, 66, 1, 66, '2022-08-15 11:20:22', 'belkiscarrion03@gmail.com', '+584242141970', '$2y$12$V1LA/SCspQaZQpqtxoWPneZVR/V4WDxS3tUpNQd7aAI1ixn9656su', '4b956a1d0fb1f0e81a857c7a5f0c7570', '$2y$12$Uh.y.cxivzQ0LsrhhGpku.ClLkoL8Q87Q4BQdIWDJznClNcPZpWOy', '5bd1acee74547edff3bb7e777af0b53a', '2022-09-23', 5, NULL, NULL, 0.00, NULL),
(70, 'Antonio Maria Arguello La Torre', 2, 66, 1, 66, '2022-08-15 11:20:33', 'antarguello@gmail.com', '+584142257613', '$2y$12$.ZaIt/ObLVJUERqPuC9lN.4pIhdk65q7MNzurESLKgL1MdqGbMQ9W', '984d2aad19e5ae1f1279ee4a9548c911', '$2y$12$/omjM71umATKPTxpHyj3tOrYMyRSOttumNV620grAhPnaPqTLwpAK', 'b1d4a574af067b9ce10a5734669c2524', '2022-05-08', 5, NULL, NULL, 0.00, NULL),
(71, 'Zenovia Deyanira Moreno Diaz', 2, 66, 1, 66, '2022-08-15 11:20:40', 'zenoviadeyanira@gmail.com', '+5491155096765', '$2y$12$PhWhnaMI71mfcqu1yfftl.Ox/CKk0/AphjWLUIO14SGyS1sqOqFGe', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(72, 'Olga verde Rivera', 2, 66, 1, 66, '2022-08-15 11:20:46', '100preseguro.viajes@gmail.com', '+584141268670', '$2y$12$X/2pbojTmWcNpV71hfAfqeAbANb3/xiHBgtMUkEO2kcGdmUqGihx6', '43d854d61124b6590992887df34c4d1f', '$2y$12$MLoo0WxviawaeAdh0bpZaObg79tSmGNkPzZG/5.H5nQ2isQSvQiGu', 'ed88b10b59d9bef6c14e889f65e1d5d8', '2022-06-23', 5, NULL, NULL, 0.00, NULL),
(73, 'Armando Jose Rosal Delgado', 2, 66, 1, 66, '2022-08-15 11:20:54', 'armandorosalasesor@gmail.com', '+584244558222', '$2y$12$XAOJmDOsMumFCH60nUjg6uSNBxbvJSjaVFbGxCWTbnJgWkdC6XIAS', 'fb673838aa4cfb3df0ff2085c5365abd', '$2y$12$9MaeemfxnpkxEre3oG7tIuFHAXaHpJAuY4CfOPthAv4ejQM5E9Rb2', '31c1ef0e19a57b664ff39f972a22c749', '2023-02-18', 5, NULL, NULL, 0.00, NULL),
(74, 'Alberto Jesus Burger Anato', 2, 66, 1, 66, '2022-08-15 11:21:02', 'burger.alberto@gmail.com', '+584243849351', '$2y$12$WqtRSX91r5qpX73nOgWPyOLllaFKwInkaCLWG.6hMq4aNmLfDXLGa', 'b8f1d810a98e439ef6659bbb33987992', '$2y$12$.ARkqIe.qI5IBb.X2OOE7.i09TNThYqU94xgeOtjitfqq5WL2UE12', 'a437256c8d3a27f563941669c23a2d55', '2022-12-08', 5, NULL, NULL, 0.00, NULL),
(75, 'Alicia Moran', 2, 20, 1, 20, '2022-05-31 15:31:15', 'infoaliciaconsulting@gmail.com', '+584246910859', '$2y$12$bcDWFNZFXtuSuvIoCbg42egWKW/P56Mqp0CJtMfOhpdm0myJgTGWO', '688dd018892b13f4bbe73574966bad5d', '$2y$12$4CGTatKFlLWQOGuDSgVX5OY8kTRmZ3IwJqT4Zby74cQDLwVJZJ.k2', 'ecb941a0b167aa4c9e3f21e9ed8d7116', '2023-02-15', 5, NULL, NULL, NULL, NULL),
(76, 'Lina Mercedes Salazar Serrano', 2, 66, 1, 66, '2022-08-15 11:21:12', 'linamercedes440@gmail.com', '+19783051731', '$2y$12$T6EDIqyCjCYxsJ2gsr0NruyRX3FOJpZghMwSvu/IHQrRc4ucPeKlO', '3a02a033368ed0cdb7eb4b4f93cda742', '$2y$12$5zvRgE9Ff3TVkREaMiw7he6OYZxkjxqYI3N0jLuYSasHJgZc6tuJ.', '3b8e24474d8a371fee89b71caccaa48d', '2022-05-16', 5, NULL, NULL, 0.00, NULL),
(77, 'Pablo Bello', 2, 20, 1, 20, '2022-05-31 15:31:34', 'bellopa@gmail.com', '+584146388239', '$2y$12$tSbls1KPXZZan9rUwKOUG.6iLYjsuCDyppG2RrhMCmvn5FbCcYImy', '8a43a65f3aecbffc2800660837967f25', '$2y$12$Mf.9yULFYEuHjNpGROJdwO1oxbZVyClNUvIYsw0F8tkl.bdYALkQu', '2977815e46668a9ec47e82a31b844edc', '2022-07-25', 5, NULL, NULL, NULL, NULL),
(78, 'Ten Assist', 2, 66, 1, 66, '2022-08-15 11:21:17', 'insurers.tenassist@gmail.com', '+584125848265', '$2y$12$/Q52iNeu6wRNmheBLQuecu1Lw1a/xtpiX27maS8YxfIwnLzOdjDRO', 'e7202e4a64f96b6213cfe24e421f1c48', '$2y$12$o9AOtoudTprYIHFrWOEP1.ZyacpxViwW/px4YyIikK0/BhIRCsIJm', 'c782de1aee2deded3d282c623c576ec3', '2022-11-03', 5, NULL, NULL, 0.00, NULL),
(79, 'Aronaid Isairth  Moron Camacaro', 2, 66, 1, 66, '2022-08-15 11:21:23', 'aronaidmc@gmail.com', '+58 4127747552', '$2y$12$ALJD7cJGGXE1VlJzp4zA0ehEZ0Cyz3931ph0/h76gLK6lWxywyl9G', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(80, 'Claudia Maggi Moro', 2, 66, 1, 66, '2022-08-15 11:21:35', 'cmaggimseguros@gmail.com', '+58 4143100865', '$2y$12$UIrfpCzNQ2ESbOAUJuOBwO.MBRn9aP//1pFEOzg0iKAliaXWeIv0a', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(81, 'RODOLFO GARCIA', 2, 31, 1, 31, '2022-07-14 17:25:25', 'asesoresintegrales03@gmail.com', '+584244939986', '$2y$12$W9DV61F0JF0cG.zVpzxLduDQWLsG3GtESVTuSfhEJaayLpdt8541G', '5bdc56e2e897b169e51e310cf8c1dd8e', '$2y$12$rdD0B6B83cX4TT463wZno.qpna6Y5FndsyZJL3l.lgX4YvKikcLPW', 'fdbe4654f52ff694671a4a7194d5a142', '2022-05-31', 5, NULL, NULL, 0.00, NULL),
(82, 'ZAIDA LISBETH SABINO CASTILLO', 2, 25, 1, 25, '2022-09-05 15:21:57', 'sabinoseguros8@gmail.com', '04123712741', '$2y$12$y25BZiI5.oFL9U/1RHqCEeA4DJOid64VlV6lv/MLb7dKGX3SXOW4e', '9b24d473990b242511c13d0dcfae393a', '$2y$12$AUakUp/UVjaUBf6wwH9ulObNeeo6lcet4sSHO6arQRFXuDK8nmBWC', '0d43cb6188726c786ad57123977c56ec', '2022-08-04', 5, NULL, NULL, 0.00, NULL),
(83, 'Hector Villasmil', 2, 20, 1, 20, '2022-05-31 15:31:25', 'hvillasmil@gmail.com', '+584123133111', '$2y$12$8MRjFwh3fUPLrRY8n//jou8TwGogOOAS5KknUSHl1X534g2nziSxS', '483fe1c37f5fbf02ee700bf4d13e0000', '$2y$12$p/ru3nSPYq6heZ5qQ1v7c.ro9cizDE2EZwqyEI7EdrvakBqDhedKi', '8659f783782de79a7b8023777bc4b303', '2022-07-21', 5, NULL, NULL, NULL, NULL),
(84, 'Andrea Estrada', 2, 20, 1, 20, '2022-05-31 16:12:29', 'totyestrada@gmail.com', '+584146399714', '$2y$12$PWUnU4F6.9iPCjwWVDwI7.wbOYT7RjinkkW/iWsg4Kq3McJZrmKX.', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL),
(85, 'Ninoska Esther Perozo Rivas', 2, 66, 1, 66, '2022-08-15 11:21:45', 'npasesoriaintegraldeseguros@hotmail.com', '04149702506', '$2y$12$f/V.KsuTEQpbjkZofM2yyeTBVGWsYXKcNCTYLRPe5C43lMJMyppJy', 'e95341d96e4527303afd70dcf7b54538', '$2y$12$BiFSCd9LR6GWaIibvQVYkOM41kdhZH9dHE2ec8lzvYRMHEA1aVRFO', 'b28aa2440d5d187641450f131cc01df5', '2022-10-17', 5, NULL, NULL, 0.00, NULL),
(86, 'OSCAR DE LIMA', 2, 25, 1, 25, '2022-08-15 08:58:29', 'oscardelima@francadelima.com', '04140191593', '$2y$12$VCy8j6il6gPbFsqsJNMsT.iScTBLX2JmqVDdNfRmgt5pfR5gLvVvC', 'b7f3838d8248b87725d05d8f0e5f0d52', '$2y$12$SyR3pCkO/4SEJSRgopTA0uzxoeua0S8cGiWJqgV.r5xnHAGc1C95O', 'b1b355ddbe918f5c191d0f32808b8ee3', '2022-10-07', 5, NULL, NULL, 0.00, NULL),
(89, 'Pedro Villasmil', 0, NULL, 1, 3, '2022-06-03 00:00:00', 'pfvillasmil@gmail.com', '+13054970965', '$2y$12$VREDtOg4c38wmDidW4xQbuNE7KojEE2Vh7PvcWCBZFFL9EMPK0Bya', '53861716ad1b3a801db0e8639ae779c0', '$2y$12$1tg3jNajfwDu73BFtdf0HOJPzchD0Gu3RqkOwX.kXh56BF78f55dq', 'b4e999f92d94e37ae4af50c606e6f4ef', '2023-03-06', 3, NULL, NULL, NULL, NULL),
(90, 'Jhonny matute', 0, NULL, 1, 3, '2022-06-03 00:00:00', 'jmatute@bee-insurance.com', '04142333380', '$2y$12$VREDtOg4c38wmDidW4xQbuNE7KojEE2Vh7PvcWCBZFFL9EMPK0Bya', 'c0ec7f96b1c2db045cbeaa0d7f5f13c8', '$2y$12$3hjLSu4all9pGQP64oiTbep5dk3Y9mPhmaw6axSg9lA.qr20/4ZLq', '1b51072095ed9bb6d4297fa206d4c3f3', '2022-08-19', 3, NULL, NULL, NULL, NULL),
(91, 'Freddy Belisario', 0, NULL, 1, 3, '2022-06-03 00:00:00', 'fbelisario@bee-insurance.com', '04141293904', '$2y$12$x9cla27fbjW54PYaZq1GZ.OuEv8H/88Z/ezrdK4KB65S85X9WNcYe', 'e3bf08b9caf1f52445aafcc74756644f', '$2y$12$9t9Ulm/juKKaXup0TwyFSOPtzteYVL9EJ589W17OtyJQh.HBIo8.e', 'fc22e81b296ffd5c6af1aa8917b259f8', '2023-03-07', 3, NULL, NULL, NULL, NULL),
(92, 'Nory Eusebia Davila Moncada', 2, 20, 1, 20, '2022-07-01 19:37:11', 'nory_davila@hotmail.com', '+584146126186', '$2y$12$MY7xIyPms/ubiPW/d/5WhuVQ8yjuYiLtON7lEGrWrQLZbLKMQvx0C', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(93, 'PEDRO NAMIAS MEZA', 1, 1, 1, 1, '2022-07-08 18:16:52', 'pedronams@hotmail.com', '04144817379', '$2y$12$JNxGlIr0kRGC77rTnrKKnOKPGQltQJwi10uuowJN7cHys3avfP8pm', 'b90f3a68683d2e09fd3658d11c198a23', '$2y$12$mrC99QfmdeDstxM2HHH7T.BYnFQoKOLoLPJGOccUuuMdrZxZ3FKhm', '193647807b1abd0b1b85f29b25a0547d', '2022-06-13', 4, NULL, NULL, 0.00, NULL),
(94, 'Global Solutions Service, LLc', 2, 66, 1, 66, '2022-08-15 11:21:53', 'info@segurosgss.com', '+6465463801', '$2y$12$11EqRydAogQnSQ9P3z7Zyu78jEKPoGGkepMRp00aSD2GlrDcyEy0q', 'fb0e1a12456136ed8d7183bc0ef322cb', '$2y$12$a5pjNe9Esk7J6bGRzb.5WO6M87xbU6P4VFt9U/xs2mPkHxVUzK6XO', '06d4de27adef12d94ea1b631e4683c96', '2022-11-14', 5, NULL, NULL, 0.00, NULL),
(95, 'ATANOR DE SEGUROS, C.A.', 2, 25, 1, 25, '2022-08-15 08:58:36', 'rfontalvo@atanordeseguros.com.ve', '04241712754', '$2y$12$YaKMhXpLaEk8yDluAhLGO.B.nWsLPfbFS5JRF2JpZoiFBmuqJMHbm', 'c26c115054063d5a22a94cd3f2836770', '$2y$12$S1JqYi05ttyKQZHthlgFM.rm0fjYDj9rFgfGTvmWD04ELLIczbKwq', '4e642abbf48cb9fa5ea1e1be4c433474', '2022-07-08', 5, NULL, NULL, 0.00, NULL),
(96, 'Evany Surquelis Quintana Brom', 2, 66, 1, 66, '2022-08-15 11:22:04', 'agenteinternac@gmail.com', '0424 1611712', '$2y$12$kAqVXw6oMDk15Kb4r55tzujJwhaXnE4Y0DDxy.2n0kZBv2n.htI0W', 'a70b26a7b5c08c010189513ba2e10dd5', '$2y$12$tV5DsyE4GwOyiG3mQoXjyehyh0wjq5YvtvEM8L9EF2uuNUHbvw6fy', '6033374b7f20f381130cac562e87335d', '2023-01-18', 5, NULL, NULL, 0.00, NULL),
(97, 'Joaquin Aguilar', 2, 20, 1, 20, '2022-06-27 10:44:07', 'aguilar.joaquine@gmail.com', '+584147290301', '$2y$12$kH.lqGwBL1PQcSecjneCnehftXyFgh3xOyfqWDOBsg.Z2oirbWjGe', 'd9f9265ed1241689104e3665f72c5ad3', '$2y$12$kcFpQ6NgfD9i0THH9OzOXeue38v.Zx4ywM/LxIJklnLAw2U8YQ6Zq', '6591d1dc5e59cb5c16b25a8f96e27bf5', '2022-08-15', 5, NULL, NULL, 0.00, NULL),
(98, 'JORGE IRAGORRY', 2, 13, 1, 13, '2022-06-30 09:43:22', 'jorgeiragorry@iragorryasociados.com', '58 414 0640750', '$2y$12$S/FpFim0xzy0CGNo2v9b6.b8rTbReG79fGyR3qi2QsbC5gDW30dy2', '40ded730e01af3a7fcd3c2987006ad36', '$2y$12$iePmdmv2HS3YFR6gLVAQ1OroshvYDGofw/Mz6fM/NSy4Xkg6QzvqK', 'df047c2d4828f3386365b4dde2d09e26', '2022-07-18', 5, NULL, NULL, 0.00, NULL),
(99, 'ALEJANDRO FERNANDEZ', 2, 13, 1, 13, '2022-06-30 09:44:04', 'alejandrof.insurance@gmail.com', '58 414 6183177', '$2y$12$akV0P91rfThonz818KmA7.GrqT/Em.xq3s11cxpSwIrB1Z4d8Z.ly', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(100, 'MANUEL F SANTIAGO', 2, 25, 1, 25, '2022-08-15 08:58:44', 'manuelfsantiagob@gmail.com', '+1(832)3223207', '$2y$12$wOemNueqne7gbW9ogZjRPOEllxCd66.znYTyhxE1/F3OFB54NcX46', 'dab36eb72f99e251737910ff00fc3590', '$2y$12$i.VyLLeoVPtmbamVx9K9/.6il4LiN0U.piLHyMNDLkQBvSZazBhg2', 'c28a67126e1576d1825ca4fc0af2ecec', '2022-08-29', 5, NULL, NULL, 0.00, NULL),
(101, 'JUAN CARLOS CONTRERAS VILORIA', 2, 45, 1, 45, '2022-07-08 06:55:29', 'infotuvidaasegurada@gmail.com', '+58 414-5840686', '$2y$12$C7gDGcj7qZWtMPE6KPgbt.lDMCHxUo3H3ntAFXNZi4P2SDJeIQIhu', '41031fef4fa056db878ac934b28a4bf8', '$2y$12$05k5avTyVVvoe4ixTkkbDutFoRO5.9YZj6Vn63Mn2Rc3vuRAQX30K', '3a9efe868ea9743b24a9cfa464cc5219', '2022-07-11', 5, NULL, NULL, 0.00, NULL),
(102, 'GLOBAL IMAGEN', 1, 1, 1, 1, '2022-07-25 11:30:52', 'carlosgramirezg@gmail.com', '04166151516', '$2y$12$D7fpT72WHXy.Y7eApWoUPuaSVsmaSU8cmEGKF4b9W9U.NgIM15o1u', '7e2f5753e2f2e97c16790f7e863d3cd1', '$2y$12$IxMUFD267bV7pqi.DYTeheYHiKiHYvupK85Q/6NQbclpP29d6WSyy', '3872ebc704a2851ed871ed09f3c75d8e', '2022-08-08', 4, NULL, NULL, 0.00, NULL),
(103, 'Maria Consuelo Chacin', 2, 32, 1, 32, '2022-07-25 09:44:39', 'mcchacin@gmail.com', '584244905423', '$2y$12$LZ0I.K7eTroFGXwJjvj/ze2TL76kt4WgIL.UGKXZhjSzO4L3MlDWi', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(104, 'Zhaira Hernandez', 2, 32, 1, 32, '2022-07-28 13:43:41', 'zhairitah@gmail.com', '584144368836', '$2y$12$UInsBK0nnUIv8EFoioJwm.iDsTFnzPwTlUkxLAlrNylXXyhyCsMvO', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(105, 'KATRINS HAIDY ARVELO', 2, 25, 1, 25, '2022-08-23 11:55:47', 'harvelo@armisglobal.com', '04242483690', '$2y$12$vcCGN67MWBadI1nJP2l8uegq0fbkKIPsS8SCoOSM0JWbfpcVEPeD.', '6bbeae099a363c515111312a211a8ec8', '$2y$12$Q0GnezRzVWOya2e96TeKw.OiwslotQp1J.M54QwgR//bTnI/bZ0Oq', '11ada64e0c2872c88aa6aa0868f0537b', '2023-02-26', 5, NULL, NULL, 0.00, NULL),
(106, 'jhonny', 2, 1, 1, 1, '2022-08-12 10:00:06', 'netjhonny@hotmail.com', '04142333380', '$2y$12$wcEBX62Myz8zsR0FqQjzluy1oByia.TZsP/D/gLfCY6QbeHdId52e', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(107, 'Andreinaa reyes', 0, NULL, 1, 3, '2022-08-19 15:03:47', 'areyes@bee-insurance.com', '04143897539', '$2y$12$48sMaxT1gHBtzk4bYNVsf.OekkWAwafnOBqx4YqEUqAm50pX1GWzy', 'bf56b43b07c079764850e29168284b1d', '$2y$12$5PAsLa1PenJyFqwwBADLC.J2QuQSFwdbD.2cJZIFUPIOmiCmcaxA6', '69d260d2c4da23cced767f01d5e28c6b', '2022-08-19', 11, NULL, NULL, NULL, NULL),
(110, 'DEYANIRA ESTHER CAICEDO COHEN', 2, 25, 1, 25, '2022-09-27 10:30:06', 'cohenasesores@gmail.com', '04242246061', '$2y$12$irIpW.PMNmi8rY4Scbrga.FlY0yFZQnrR6dxbgz7vdRMe0jjwHe0W', '87ecf87cd9c7b1cc32414b7d2937c537', '$2y$12$5s8CKgsJfzX8PQSsFPzMduX/we43vXmm2jz8AuPL9xDmlCpjAQIlC', 'a43d8531be07f38f7d9db44138f1a140', '2022-10-07', 5, NULL, NULL, 0.00, NULL),
(111, 'ROGERS ALEXANDER PORRLLO BREA', 2, 25, 1, 25, '2022-09-02 14:22:47', 'gerencia@bienestarconsultores.com', '+1(829)9815931', '$2y$12$KCLm9cHU0M0CY33Df.M4vePADcpbRGl4RM0Qy8vMzBUyc8FOf9Qv6', '35ebabbfd6df8f72543738e3f929e41c', '$2y$12$sVjeg3uUKEK4VbKfojkepuCSjMJmwYBc.uxxqoYYSpyzK9yRkVNgS', '2851b0f59711250f5c2e20c6069e23e4', '2022-11-09', 5, NULL, NULL, 0.00, NULL),
(112, 'Development', 0, NULL, 1, 3, '2022-06-03 00:00:00', 'development@gmail.com', '+123456789', '$2y$12$LSX2ILQYk17hdgFLXy/LKeYcuNqteW/Vt93WxtELgWOasTanDv3Qm', '04e6b7f4c3f90719c9fac78a8daea0bb', '$2y$12$5rYQzHo7DIdVKSXOG.rukOjQw47qvS.3ug.nR3Enhz3P2druWxngm', '57c24d07f039ce4b3a35438cf6284524', '2022-09-14', 3, NULL, NULL, NULL, NULL),
(113, 'JULIO C MELO H', 2, 14, 1, 14, '2022-09-27 10:28:23', 'juliomelo2012@gmail.com', '04122857309', '$2y$12$cHm2.PZsrgObIiaAKwgCzuIz4dxFZ978c4d6SpQsz.lo5OyhlIKsG', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(114, 'Miguel Angel Da Silva', 2, 17, 1, 17, '2022-10-14 14:12:54', 'm.dasilvars@gmail.com', '04143157322', '$2y$12$mnf91dlpR8Qkee.g56NjuODCvem4nVASfSihK4ltjvvxHTKWB99Rm', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(115, 'AIP BROKERS', 1, 1, 1, 1, '2022-10-17 14:38:18', 'rbproyectoaip@gmail.com', '04142472463', '$2y$12$ZKu0.bBDqQYqtXyAf3xKKuDlZVXnYJlyaQZwe41WEk3mNBfX9gSei', 'e5ce60ca1ddb2f8bf7dcb94a3a117812', '$2y$12$g3nlloG4hDgBGTRiApCBJeqNXXMU3OdKcZKm9NQ99wzUtFHJLjSyC', '9ce3439ad83196545ab47cdb8961f58e', '2023-01-26', 4, NULL, NULL, 2.00, NULL),
(116, 'QUINTANA Y ASOCIADOS, C.A.', 1, 1, 1, 1, '2022-11-02 11:56:12', 'quintana.asociados1992@gmail.com', '04129057222', '$2y$12$8mIenfeYyAMSZ5FkfYg.J.nhw/aSoZywKcHIfMn6o4g4JKTAm7M9e', '036f6d6d31240b92150dc9596eea8c1a', '$2y$12$wAj1QY1WorBHrPA3osoFFOEkL8U3dFZAE7gYodrdwCznY28.oBczq', '75bb9f7b7aa36b03331c7a6e39f7bdbe', '2022-11-02', 4, NULL, NULL, 0.00, NULL),
(117, 'HECTOR LEANDRO RODRIGUEZ PALMA', 2, 25, 1, 25, '2022-11-15 14:19:32', 'leanrod7496@gmail.com', '04241771274', '$2y$12$zNcdNUsgOOAMxNkISGv.WujbziLacvmJ3Vq2SK6Ihv1aG/hdnEXZe', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(118, 'MARLA COROMOTO GONZALEZ ESCALANTE', 2, 25, 1, 25, '2022-11-15 14:24:18', 'escalantemarla231@gmail.com', '04126253933', '$2y$12$1UPH9yGBAlCgXm0FyjCGm.xX86qRhirDVjY.nftZ4NdbCwLGnxGoW', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(122, 'JUAN EDUARDO MONTES DE OCA', 2, 35, 1, 35, '2023-01-20 15:56:58', 'jmontes1aseca@gmail.com', '+584146196198', '$2y$12$ZkoEj4EgeggPa3gGPIHI.eY3WQAPps9vBjo6Nm.pgs.pi67/UqyFa', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL),
(123, 'AGENCIA TORRES ASESORIAS', 1, 1, 1, 1, '2023-01-24 16:36:25', 'yuryatorres@gmail.com', '0424-2259038', '$2y$12$bH/pnhqIHV79EdFn8SbYNeZMbIGWh1CaqJmsq1fYGzBaReOV3XpMi', '6dd67e11716f9b48ff008c861ab36976', '$2y$12$PxhWKIO2PS9V8mvy4LRP2.UPp3G7PmqUQJpu.uOmkfWgg3lAUOV/K', '494b7eac8ceefa039d74f443ba0cbfe0', '2023-02-06', 4, NULL, NULL, 0.00, NULL),
(124, 'CARMEN LUISA MALAVE ROMERO', 1, 1, 1, 1, '2023-01-24 16:39:03', 'cmalave@bee-insurance.com', '0424-8153602', '$2y$12$ZNkIp9t3E/QpZs9DEFFtLOdGQjhverSJY89mZVT.uLuSla3vgRnJ6', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00, NULL),
(125, 'VISION BUSINESS', 1, 1, 1, 1, '2023-01-26 10:55:53', 'info@visionbusiness.us', '+1(305)5828276', '$2y$12$Q.8cUBCA8xRbvC7yZknppO1tDc9E6o3dcYNC3MDUbDOjvmhylCEeS', '09c73d475940be91ea7b563f19ceb3ae', '$2y$12$Y6v2IU4LGejN1Ke3h3t3XeJQAHwfgg1gfAWwwrQSG1SJKUSLrm9Xy', 'a14b45cbab008bb16f3cd1bcf6b9520c', '2023-03-02', 4, NULL, NULL, 0.00, 'visionbiz'),
(126, 'Safeguard Bee Insurance', 2, 125, 1, 125, '2023-03-30 10:58:07', 'lfvillegas@gmail.com', '3055828276', '$2y$12$n06x8Z43ve6whLije0mdBeO6.sl9/EDK/4ZSsFrjV5NzzFeISwQ6q', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00, NULL);

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

--
-- Estructura de tabla para la tabla `agencies_commissions`
--

CREATE TABLE `agencies_commissions` (
  `id_agency` int(11) NOT NULL,
  `id_product` int(11) NOT NULL,
  `commission` double(20,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `agencies_commissions` (`id_agency`, `id_product`, `commission`) VALUES
(13, 3, 30.00),
(13, 4, 35.00),
(13, 5, 25.00),
(14, 3, 30.00),
(14, 4, 30.00),
(14, 5, 25.00),
(15, 3, 35.00),
(15, 4, 38.00),
(15, 5, 28.00),
(16, 3, 30.50),
(16, 4, 32.35),
(16, 5, 23.80),
(1, 3, 35.00),
(1, 4, 37.00),
(1, 5, 30.00),
(17, 3, 30.00),
(17, 4, 30.00),
(17, 5, 25.00),
(18, 3, 25.00),
(18, 4, 25.00),
(18, 5, 20.00),
(19, 3, 25.00),
(19, 4, 25.00),
(19, 5, 20.00),
(20, 3, 30.00),
(20, 4, 30.00),
(20, 5, 25.00),
(21, 3, 30.00),
(21, 4, 30.00),
(21, 5, 25.00),
(22, 3, 30.00),
(22, 4, 30.00),
(22, 5, 25.00),
(23, 3, 30.00),
(23, 4, 30.00),
(23, 5, 25.00),
(24, 3, 25.00),
(24, 4, 30.00),
(24, 5, 20.00),
(25, 3, 30.00),
(25, 4, 30.00),
(25, 5, 25.00),
(26, 3, 25.00),
(26, 4, 25.00),
(26, 5, 20.00),
(27, 3, 25.00),
(27, 4, 25.00),
(27, 5, 20.00),
(30, 3, 35.00),
(30, 4, 38.00),
(30, 5, 28.00),
(31, 3, 30.00),
(31, 4, 32.50),
(31, 5, 25.00),
(32, 3, 30.00),
(32, 4, 30.00),
(32, 5, 25.00),
(34, 3, 30.00),
(34, 4, 30.00),
(34, 5, 25.00),
(35, 3, 30.00),
(35, 4, 30.00),
(35, 5, 25.00),
(36, 3, 30.00),
(36, 4, 30.00),
(36, 5, 25.00),
(41, 3, 25.00),
(41, 4, 25.00),
(41, 5, 20.00),
(43, 3, 25.00),
(43, 4, 25.00),
(43, 5, 20.00),
(44, 3, 25.00),
(44, 4, 25.00),
(44, 5, 20.00),
(45, 3, 30.00),
(45, 4, 30.00),
(45, 5, 25.00),
(46, 3, 25.00),
(46, 4, 25.00),
(46, 5, 22.00),
(48, 3, 30.00),
(48, 4, 30.00),
(48, 5, 25.00),
(49, 3, 25.00),
(49, 4, 25.00),
(49, 5, 20.00),
(50, 3, 25.00),
(50, 4, 25.00),
(50, 5, 20.00),
(1, 6, 45.00),
(51, 3, 30.00),
(51, 5, 25.00),
(52, 3, 30.00),
(52, 4, 30.00),
(52, 5, 25.00),
(53, 3, 30.00),
(53, 4, 30.00),
(53, 5, 25.00),
(54, 3, 25.00),
(54, 4, 27.00),
(54, 5, 20.00),
(55, 3, 25.00),
(55, 4, 25.00),
(55, 5, 20.00),
(56, 3, 25.00),
(56, 4, 25.00),
(56, 5, 20.00),
(57, 3, 25.00),
(57, 4, 25.00),
(57, 5, 20.00),
(58, 3, 25.00),
(58, 4, 25.00),
(58, 5, 20.00),
(60, 3, 30.00),
(60, 5, 25.00),
(61, 3, 25.00),
(61, 4, 25.00),
(61, 5, 20.00),
(62, 3, 25.00),
(62, 4, 25.00),
(62, 5, 20.00),
(63, 3, 25.00),
(63, 4, 25.00),
(63, 5, 20.00),
(64, 3, 30.00),
(64, 4, 30.00),
(64, 5, 25.00),
(65, 3, 25.00),
(65, 4, 25.00),
(65, 5, 20.00),
(66, 3, 30.00),
(66, 4, 30.00),
(66, 5, 25.00),
(67, 3, 25.00),
(67, 5, 20.00),
(68, 3, 25.00),
(68, 4, 25.00),
(68, 5, 20.00),
(69, 3, 25.00),
(69, 4, 25.00),
(69, 5, 20.00),
(70, 3, 25.00),
(70, 4, 25.00),
(70, 5, 20.00),
(71, 3, 25.00),
(71, 4, 25.00),
(71, 5, 20.00),
(72, 3, 25.00),
(72, 4, 25.00),
(72, 5, 20.00),
(73, 3, 25.00),
(73, 4, 25.00),
(73, 5, 20.00),
(74, 3, 25.00),
(74, 4, 25.00),
(74, 5, 20.00),
(75, 3, 22.00),
(75, 4, 22.00),
(75, 5, 18.00),
(76, 3, 25.00),
(76, 4, 25.00),
(76, 5, 20.00),
(77, 3, 25.00),
(77, 4, 25.00),
(77, 5, 20.00),
(78, 3, 25.00),
(78, 4, 25.00),
(78, 5, 20.00),
(79, 3, 25.00),
(79, 4, 25.00),
(79, 5, 20.00),
(80, 3, 25.00),
(80, 4, 25.00),
(80, 5, 20.00),
(81, 3, 25.00),
(81, 4, 26.00),
(81, 5, 20.00),
(82, 3, 25.00),
(82, 4, 20.00),
(82, 5, 25.00),
(83, 3, 25.00),
(83, 4, 25.00),
(83, 5, 20.00),
(84, 3, 25.00),
(84, 4, 25.00),
(84, 5, 20.00),
(85, 3, 25.00),
(85, 4, 25.00),
(85, 5, 20.00),
(86, 3, 25.00),
(86, 4, 25.00),
(86, 5, 20.00),
(92, 3, 25.00),
(92, 4, 25.00),
(92, 5, 20.00),
(93, 3, 30.00),
(93, 4, 30.00),
(93, 5, 25.00),
(94, 3, 25.00),
(94, 4, 25.00),
(94, 5, 20.00),
(95, 3, 25.00),
(95, 4, 25.00),
(95, 5, 20.00),
(96, 3, 25.00),
(96, 4, 25.00),
(96, 5, 20.00),
(97, 3, 25.00),
(97, 4, 25.00),
(97, 5, 20.00),
(98, 3, 25.00),
(98, 4, 30.00),
(98, 5, 20.00),
(99, 3, 25.00),
(99, 4, 30.00),
(99, 5, 20.00),
(100, 3, 25.00),
(100, 4, 25.00),
(100, 5, 20.00),
(101, 3, 22.00),
(101, 4, 22.00),
(101, 5, 22.00),
(25, 6, 40.00),
(31, 6, 40.00),
(45, 6, 40.00),
(13, 6, 40.00),
(20, 6, 40.00),
(35, 6, 40.00),
(51, 6, 40.00),
(14, 6, 40.00),
(34, 6, 40.00),
(17, 6, 40.00),
(21, 6, 40.00),
(93, 6, 40.00),
(22, 6, 40.00),
(32, 6, 40.00),
(23, 6, 40.00),
(66, 6, 40.00),
(1, 7, 26.00),
(1, 8, 46.00),
(102, 7, 25.00),
(102, 8, 25.00),
(103, 3, 25.00),
(103, 4, 25.00),
(103, 5, 20.00),
(103, 6, 25.00),
(104, 3, 25.00),
(104, 4, 25.00),
(104, 5, 20.00),
(104, 6, 25.00),
(105, 3, 25.00),
(105, 4, 25.00),
(105, 5, 20.00),
(105, 6, 35.00),
(106, 3, 30.00),
(106, 4, 30.00),
(106, 5, 25.00),
(106, 6, 35.00),
(106, 7, 1.00),
(106, 8, 1.00),
(26, 6, 35.00),
(27, 6, 35.00),
(36, 6, 35.00),
(50, 6, 35.00),
(82, 6, 35.00),
(86, 6, 35.00),
(95, 6, 35.00),
(100, 6, 35.00),
(78, 6, 35.00),
(68, 6, 35.00),
(69, 6, 35.00),
(70, 6, 35.00),
(71, 6, 35.00),
(72, 6, 35.00),
(73, 6, 35.00),
(74, 6, 35.00),
(76, 6, 35.00),
(79, 6, 35.00),
(80, 6, 35.00),
(85, 6, 35.00),
(94, 6, 35.00),
(96, 6, 35.00),
(18, 6, 35.00),
(19, 6, 35.00),
(48, 6, 40.00),
(49, 6, 25.00),
(52, 6, 40.00),
(54, 6, 30.00),
(110, 3, 25.00),
(110, 4, 25.00),
(110, 5, 20.00),
(110, 6, 35.00),
(111, 3, 25.00),
(111, 4, 25.00),
(111, 5, 20.00),
(111, 6, 35.00),
(113, 3, 25.00),
(113, 4, 25.00),
(113, 5, 20.00),
(113, 6, 35.00),
(62, 6, 35.00),
(114, 3, 25.00),
(114, 4, 25.00),
(114, 5, 20.00),
(114, 6, 35.00),
(115, 3, 30.00),
(115, 4, 30.00),
(115, 5, 25.00),
(115, 6, 40.00),
(116, 3, 30.00),
(116, 4, 30.00),
(116, 5, 25.00),
(116, 6, 40.00),
(1, 9, 31.00),
(117, 3, 25.00),
(117, 4, 25.00),
(117, 5, 20.00),
(117, 6, 30.00),
(118, 3, 25.00),
(118, 4, 25.00),
(118, 5, 20.00),
(118, 6, 35.00),
(122, 3, 25.00),
(122, 4, 25.00),
(122, 5, 20.00),
(122, 6, 30.00),
(123, 3, 30.00),
(123, 4, 35.00),
(123, 5, 25.00),
(123, 6, 40.00),
(124, 3, 30.00),
(124, 4, 35.00),
(124, 5, 25.00),
(124, 6, 40.00),
(125, 3, 30.00),
(125, 5, 25.00),
(125, 6, 40.00),
(126, 3, 10.00),
(126, 5, 8.00),
(126, 6, 13.00),
(64, 6, 40.00),
(1, 10, 22.00);

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

--
-- Estructura de tabla para la tabla `agencies_ibo`
--

CREATE TABLE `agencies_ibo` (
  `id_agency_ibo` int(11) NOT NULL,
  `name_agency` varchar(100) NOT NULL,
  `token` text NOT NULL,
  `token_encrypt` text NOT NULL,
  `logo` varchar(80) DEFAULT NULL,
  `id_user` int(11) NOT NULL,
  `id_status` int(11) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `agencies_ibo` (`id_agency_ibo`, `name_agency`, `token`, `token_encrypt`, `logo`, `id_user`, `id_status`, `create_date`) VALUES
(1, 'Safeguard', 'Safeguard20226dghha8shs', 'WmhXZlVaSGZCRlUkaFBqby9wenI3dDh6OGhUYXJZTkVHWXZUZ0JVOVJPTGJ5bW1ZODlvYXJEYUM3NFIrZEE9PQ', 'Agency_ibo_1.png', 0, 1, '2022-10-28 03:11:44');

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

--
-- Estructura de tabla para la tabla `agencies_ibo_products`
--

CREATE TABLE `agencies_ibo_products` (
  `id_insurance` int(11) NOT NULL,
  `id_agency_ibo` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `agencies_ibo_products` (`id_insurance`, `id_agency_ibo`) VALUES
(5, 1),
(7, 1),
(3, 1);

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

--
-- Estructura de tabla para la tabla `age_groups`
--

CREATE TABLE `age_groups` (
  `id_group` int(11) NOT NULL,
  `start_age` int(11) NOT NULL,
  `end_age` int(11) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT 1,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `age_groups` (`id_group`, `start_age`, `end_age`, `id_status`, `id_user`, `create_date`) VALUES
(1, 18, 45, 1, 3, '2022-05-23 01:19:16'),
(2, 46, 74, 1, 3, '2022-05-23 01:16:43');

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

--
-- Estructura de tabla para la tabla `authorization_api`
--

CREATE TABLE `authorization_api` (
  `id_authorization` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` text NOT NULL,
  `token_bee` varchar(100) NOT NULL,
  `password_test` text DEFAULT NULL,
  `token_bee_test` varchar(100) DEFAULT NULL,
  `mode` int(11) NOT NULL DEFAULT 1,
  `id_status` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `authorization_api` (`id_authorization`, `username`, `password`, `token_bee`, `password_test`, `token_bee_test`, `mode`, `id_status`, `id_user`, `create_date`) VALUES
(1, 'visiontravel', '$2y$12$eU9x1fJwhFjUFKXWW2H8rOZ1B4sHEgKEX/50ChqJP67ZM6wXS5Pk6', 'visiontravelhYA95iZ5rji9]3', NULL, NULL, 1, 1, 3, '2022-04-26 00:00:00'),
(2, 'visiontravel', '$2y$12$zQMdcUZ/HEe6xa9xm22YXescCXlkWCw.tYplhE9AQqAgQwe5Tnp9S', 'visiontravelbcb04b7e103a0*', NULL, NULL, 0, 1, 3, '2022-04-26 00:00:00');

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

--
-- Estructura de tabla para la tabla `banners`
--

CREATE TABLE `banners` (
  `id_banner` int(11) NOT NULL,
  `name_banner` varchar(100) NOT NULL,
  `image_banner` varchar(100) NOT NULL,
  `description_banner` text NOT NULL,
  `link_banner` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT 1,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `language` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `banners` (`id_banner`, `name_banner`, `image_banner`, `description_banner`, `link_banner`, `id_status`, `id_user`, `create_date`, `language`) VALUES
(1, 'It goes with you, as you wish', 'Goes_With_You.jpg', 'We are here to support you', 'Insurance', 1, 5, '2022-03-04 17:53:01', 'EN'),
(2, 'Goes with you, wherever you want', 'Bee_Insurance_Corp.jpg', ' Goes with you, wherever you want', 'Bee Travel', 1, 5, '2022-03-04 17:52:54', 'EN'),
(3, 'Goes with you, at any<br> time', 'Goes_with_you,_anytime.jpg', 'Goes with you, anytime', 'insurance', 1, 5, '2022-03-04 17:57:33', 'EN'),
(4, 'Va contigo, como quieras', 'Goes_With_You.jpg', 'We are here to support you', 'Insurance', 1, 5, '0000-00-00 00:00:00', 'ES'),
(5, 'Va contigo, donde quieras', 'Bee_Insurance_Corp.jpg', ' Goes with you, wherever you want', 'Bee Travel', 1, 5, '0000-00-00 00:00:00', 'ES'),
(6, 'Va contigo, en cualquier<br> momento', 'Goes_with_you,_anytime.jpg', 'Goes with you, anytime', 'insurance', 1, 5, '0000-00-00 00:00:00', 'ES');

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

--
-- Estructura de tabla para la tabla `blogs`
--

CREATE TABLE `blogs` (
  `id_blog` int(11) NOT NULL,
  `title_blog` varchar(200) NOT NULL,
  `title_blog_en` varchar(200) NOT NULL,
  `description_blog` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description_blog_en` longtext NOT NULL,
  `coverpage_blog` varchar(200) NOT NULL,
  `coverpage_blog_en` varchar(200) NOT NULL,
  `alt_img` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT 1,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `language` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `blogs` (`id_blog`, `title_blog`, `title_blog_en`, `description_blog`, `description_blog_en`, `coverpage_blog`, `coverpage_blog_en`, `alt_img`, `id_status`, `id_user`, `create_date`, `language`) VALUES
(4, 'Bee Insurance is SINOASIA MEMBER', '', '<h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\">\r\n\r\n\r\n\r\n\r\n\r\n<!--StartFragment-->\r\n\r\n</h4><h3 style=\"margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; direction: ltr; unicode-bidi: embed; word-break: normal;\"><span style=\"font-size: 28pt; font-family: Arimo;\"><span style=\"font-family: Arial;\">SINOASIA\r\nGROUP</span><span style=\"font-family: Arial;\"> is a group of experienced risk management, insurance and reinsurance\r\ncompanies with a vision to grow from Asia to serve with a global perspective.</span></span><span style=\"font-size: 28pt; font-family: Arimo;\"><br></span><span style=\"font-size: 28pt; font-family: Arial;\">Our\r\nbroad geographic coverage allows us to identify and respond quickly to new\r\ninternational trends and opportunities.<br></span><span style=\"font-size: 28pt; font-family: Arial;\">We\r\nhave a wide network of member companies which allows us to access the worldwide\r\nreinsurance market, offering alternatives in the different lines of business.</span></h3><span style=\"font-family: Arial;\">\r\n\r\n</span><span style=\"font-family: Arial;\">\r\n\r\n</span><p style=\"margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; direction: ltr; unicode-bidi: embed; word-break: normal;\"></p><span style=\"font-family: Arial;\">\r\n\r\n</span>\r\n\r\n<!--EndFragment-->', '', 'Bee_Insurance_es_miembro_SINOASIA.jpg', '', 'SINOASIA BEE INSURANCE', 1, 6, '2023-04-11 12:18:33', 'EN'),
(5, '@beeinsurance_ FOLLOW US and keep it in touch', '', '<p>\r\n\r\n\r\n\r\n\r\n\r\n<!--StartFragment-->\r\n\r\n\r\n\r\n<!--EndFragment--></p><h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\"><span style=\"font-size: 28pt; font-family: Arimo; background-color: rgb(255, 255, 255);\"><span style=\"font-family: Arial;\">NOW\r\nWE ARE MORE COMMUNICATED,</span><span style=\"font-family: Arial;\"> we connect with our community in latin america, we want to share with\r\nall our customers, resellers and policyholders; that we have our official\r\nprofile on Instagram @beeinsurance_ there we will keep you informed with our\r\noriginal content and the news of our company.</span></span></h4>\r\n\r\n<!--EndFragment-->', '', '@beeinsurance__FOLLOW_US_and_keep_it_in_touch.jpg', '', 'BEE INSURANCE LATINOAMERICA ', 1, 6, '2023-04-11 12:18:44', 'EN'),
(6, 'First touch IN LATAM', '', '<h3><span style=\"font-family: Arial;\">1st Bee Insurance Corp. Convention&nbsp;</span></h3><h3><br></h3><h3><span style=\"font-family: Arial;\">\"Goes with you\" Convention.</span><br><span style=\"font-family: Arial;\">On Monday, March 14, 2.022 at the Olio Restaurant in the Altamira Village Shopping Center in Caracas Venezuela, the 1st Convention of Bee Insurance Corp. was held, being this the official launching of the brand to present its international products and its WebSite. This as the first phase of the expansion to all of Latin America incluyed all caribbean island.</span></h3><h3><span style=\"font-family: Arial;\"><br></span><br><span style=\"font-family: Arial;\">The event started with the words of Humberto Martinez CEO of Bee Insurance Corp:</span><br><span style=\"font-family: Arial;\">\"The insurance market in Latin America moved forward and we must have a company ready to work and represent Venezuelans in the Latin American market.&nbsp;</span><br><span style=\"font-family: Arial;\">We are working on systems, technology, human resources and the personnel that accompany us. We work on something fundamental for all of you to be here, and that is our products.&nbsp;</span><br><span style=\"font-family: Arial;\">We are looking for innovative products that will change the traditional scheme of how to sell a life product that is in line with the realities of Latin America, that is different from the conventional life insurance policy, in line with the needs that we contemplate today and that at the same time can solve a problem with immediacy\".</span><br><span style=\"font-family: Arial;\">Three senior executives of the brand: Pedro Villasmil, Rafael Villasmil and Carlos Lorenzo reinforce the three important premises of the product: \"easy to understand, easy to buy and easy to pay\". They highlight the competitive value of the product in the Latin American market that is marketed via the web, which are: Bee Life, Bee Travel and Bee 4 in 1.&nbsp;</span></h3><h3><span style=\"font-family: Arial;\"><br></span><br><span style=\"font-family: Arial;\">The event was highlighted with surprises for the guests such as raffles and the Bee Gift as credibility and commitment with the allies present.&nbsp;</span></h3><p></p>', '', 'FIRST_TOUCH_in_Latam.png', '', 'FIRST TOUCH in Latam', 1, 6, '2023-04-11 12:16:19', 'EN'),
(9, 'Interview with our Chief Operating Officer Pedro Villasmil.', '', '<h3><span style=\"font-family: Arial;\">🔷How did the name Bee Insurance Corp come about?</span></h3><p><br><span style=\"font-family: Arial;\">The Bee Insurance Corp, is the result of 3 proposed names; but we really liked Bee. Because phonetically it has to do with being and being, in addition to the work philosophy of the Bees, always in a group, tireless workers, in favor of the same goal, etc.</span><br><br><span style=\"font-family: Arial;\">🔷 Why do you decide to market in Latin America?</span><br><br><span style=\"font-family: Arial;\">Because at Bee Insurance we have understood the needs of this market and we are producing advanced products that cover the insurance needs of the bulk of the population, with products that are easy to understand and buy, at very reasonable prices.</span><br><br><span style=\"font-family: Arial;\">🔷 After the pandemic, what did you learn?</span><br><br><span style=\"font-family: Arial;\">We have no limits to reinvent ourselves. I understood that the world has changed and that we have to be agile to adapt to the new times that the post-pandemic brings us. There is much to do and the sky is the limit.</span><br><br><span style=\"font-family: Arial;\">🔷 Is there an expansion plan in Latin America or are you working on it?</span><br><br><span style=\"font-family: Arial;\">Yes, we have it divided into several phases, the first has already started with our massive sale market, however, we are preparing hard to enter the reinsurance market throughout Latin America.</span><br><br><span style=\"font-family: Arial;\">🔷 Is the product portfolio designed for the region?</span><br><br><span style=\"font-family: Arial;\">Absolutely; We understand the insurance needs of the region and we want to be pioneers in it with easy and practical products that fulfill the most important thing, which is to be there with you when you need it.</span><br><br><span style=\"font-family: Arial;\">🔷 What challenges do you consider taking on running the company? (Inflation, globalization, technology)</span><br><br><span style=\"font-family: Arial;\">The main challenge is to continue promoting the company to have an important name in the entire Latin American market, firstly using the great experience of our work team and secondly using the best technology that we can apply.</span><br><br><span style=\"font-family: Arial;\">🔷 We are experiencing complex times around the world, what advice do you give to your allies and policyholders?</span><br><br><span style=\"font-family: Arial;\">Do not lose focus of what is being done, work as a concentrated team to achieve your goals. In today&apos;s competitive and globalized world, it&apos;s easy to succumb to presentations and lose your way.</span><br><br><span style=\"font-family: Arial;\">Trust in yourself and your team; knowing how to listen and learn.</span><br><br><span style=\"font-family: Arial;\">🔶 Pedro Villasmil.</span><br><br><span style=\"font-family: Arial;\">COO – Bee Insurance Corporation🔶</span><br></p>', '', 'Interview_with_our_Chief_Operating_Officer_Pedro_Villasmil..jpeg', '', 'Img pedro', 1, 6, '2023-04-11 12:15:58', 'EN'),
(10, 'We get everywhere, but with you it will be better', '', '<h3></h3><h3 style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\"><span style=\"font-size: 13.5pt; font-family: Arial, sans-serif;\"><span style=\"font-family: Arial;\">We want to work together.<br></span></span><span style=\"font-size: 13.5pt; font-family: Arial, sans-serif;\"><span style=\"font-family: Arial;\">Connect with us on all our social networks and also on our WhatsApp, +1 (786) 782 53 13. We will be here to chat with you.&nbsp;We are also looking for insurance agencies that want to sell all our policies for the entire American continent.<br></span></span><span style=\"font-size: 13.5pt; font-family: Arial, sans-serif;\"><span style=\"font-family: Arial;\">We have all the products to preserve the life of your family and your clients, call us together we will be unstoppable.<br></span></span><span style=\"font-size: 13.5pt; font-family: Arial, sans-serif;\"><span style=\"font-family: Arial;\">If you are in Latin America, we also speak Spanish.</span></span></h3>', '', 'We_get_everywhere,_but_with_you_it_will_be_better.jpg', '', 'Lets work together', 1, 6, '2023-04-11 12:18:18', 'EN'),
(12, 'SOMOS MIEMBROS DE SINOASIA GROUP', '', '<h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\">\r\n<!--StartFragment-->\r\n</h4><h3 style=\"margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; direction: ltr; unicode-bidi: embed; word-break: normal;\"><span style=\"font-size: 28pt; font-family: Arimo;\"><span style=\"font-family: Arial;\">SOMOS MIEMBROS DE SINOASIA GROUP</span><span style=\"font-family: Arial;\"> Es un grupo de compañías de seguros y reaseguros con experiencia en gestión de riesgos con la visión de crecer desde Asia para servir con una perspectiva global.</span></span><span style=\"font-size: 28pt; font-family: Arimo;\"><br></span><span style=\"font-size: 28pt; font-family: Arial;\">Nuestra amplia cobertura geográfica nos permite identificar y responder rápidamente a las nuevas tendencias y oportunidades internacionales.<br></span><span style=\"font-size: 28pt; font-family: Arial;\">Contamos con una amplia red de empresas asociadas que nos permite acceder al mercado mundial de reaseguros, ofreciendo alternativas en las diferentes líneas de negocio.</span></h3><span style=\"font-family: Arial;\">\r\n</span><span style=\"font-family: Arial;\">\r\n</span><p style=\"margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; direction: ltr; unicode-bidi: embed; word-break: normal;\"></p><span style=\"font-family: Arial;\">\r\n</span>\r\n<!--EndFragment-->', '', 'Blog_12.jpg', '', 'SINOASIA BEE INSURANCE', 1, 6, '2023-04-11 12:14:27', 'ES'),
(13, 'AHORA ESTAMOS MAS COMUNICADOS.', '', '<p>\r\n\r\n\r\n\r\n\r\n\r\n<!--StartFragment-->\r\n\r\n\r\n\r\n<!--EndFragment--></p><h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\"><p class=\"MsoNormal\"><span style=\"font-size:10.5pt;font-family:&quot;Calibri&quot;,sans-serif;\r\nmso-ascii-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\r\nminor-latin;color:#333333\">Nos conectamos con la respetada comunidad\r\nlatinoamericana, queremos compartir con todos nuestros clientes, revendedores y\r\nasegurados; que tenemos un perfil oficial en Instagram @beeinsurance_ ahí los\r\nmantendremos informados con nuestro contenido original y las novedades de\r\nnuestra empresa.<o:p></o:p></span></p></h4>\r\n\r\n<!--EndFragment-->', '', 'Blog_13.jpg', '', 'instagram', 1, 6, '2023-04-11 12:20:24', 'ES'),
(14, '1RA CONVENCIÓN DE BEE INSURANCE CORP EN LATINOAMERICA.', '', '<p>\r\n\r\n\r\n\r\n\r\n\r\n<!--StartFragment-->\r\n\r\n\r\n\r\n<!--EndFragment--></p><h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\"><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Convención \"Va\r\ncontigo\".<o:p></o:p></span></p><p class=\"MsoNormal\">\r\n\r\n</p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">El lunes 14 de marzo de\r\n2.022 en el Restaurante Olio del Centro Comercial Altamira Village en Caracas\r\nVenezuela, se llevó a cabo la 1ra Convención de Bee Insurance Corp., siendo\r\neste el lanzamiento oficial de la marca para presentar sus productos\r\ninternacionales y su Sitio Web. Esta como primera fase de la expansión a toda\r\nAmérica Latina incluía todo el Caribe insular.<o:p></o:p></span></p></h4>\r\n\r\n<!--EndFragment-->', '', 'Blog_14.png', '', 'seguros', 1, 6, '2023-04-11 12:21:54', 'ES'),
(15, 'ENTREVISTA A PEDRO VILLASMIL – COO BEE INSURANCE CORP.', '', '<p>\r\n\r\n\r\n\r\n\r\n\r\n<!--StartFragment-->\r\n\r\n\r\n\r\n<!--EndFragment--></p><h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\"><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔷</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\">¿Cómo surgió el nombre Bee Insurance\r\nCorp?<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">The Bee Insurance Corp,\r\nes el resultado de 3 nombres propuestos; pero nos gustó mucho Bee. Porque\r\nfonéticamente tiene que ver con ser y estar, además de la filosofía de trabajo\r\nde las Abejas, siempre en grupo, trabajadoras incansables, a favor de un mismo\r\nfin, etc.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔷</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\"> ¿Por qué decides comercializar en\r\nLatinoamérica?<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Porque en Bee Insurance\r\nhemos entendido las necesidades de este mercado y estamos elaborando productos\r\navanzados que cubren las necesidades aseguradoras del grueso de la población,\r\ncon productos fáciles de entender y comprar, a precios muy razonables.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span><span style=\"color: rgb(13, 13, 13); font-family: Calibri, sans-serif; font-size: 1.5rem;\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔷</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\"> Después de la pandemia, ¿qué\r\naprendiste?<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">No tenemos límites para reinventarnos.\r\nEntendí que el mundo ha cambiado y que tenemos que ser ágiles para adaptarnos a\r\nlos nuevos tiempos que nos trae la pospandemia. Hay mucho por hacer y el cielo\r\nes el límite.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔷</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\"> ¿Hay plan de expansión en\r\nLatinoamérica o están trabajando en ello?<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Sí, lo tenemos dividido\r\nen varias fases, la primera ya empezó con nuestro mercado de venta masiva, sin\r\nembargo, nos estamos preparando fuerte para entrar al mercado de reaseguros en\r\ntoda Latinoamérica.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔷</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\"> ¿El portafolio de productos está\r\ndiseñado para la región?<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Absolutamente; Entendemos\r\nlas necesidades de seguros de la región y queremos ser pioneros en ello con\r\nproductos fáciles y prácticos que cumplan con lo más importante, que es estar\r\ncontigo cuando lo necesites.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔷</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\"> ¿Qué retos te planteas asumir al\r\ndirigir la empresa? (Inflación, globalización, tecnología)<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">El principal desafío es\r\nseguir impulsando a la empresa para que tenga un nombre importante en todo el\r\nmercado latinoamericano, primero utilizando la gran experiencia de nuestro\r\nequipo de trabajo y segundo utilizando la mejor tecnología que podamos aplicar.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔷</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\"> Estamos viviendo tiempos complejos en\r\ntodo el mundo, ¿qué consejo les das a tus aliados y asegurados?<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">No pierdas el foco de lo\r\nque se está haciendo, trabaja en equipo concentrado para lograr tus objetivos.\r\nEn el mundo competitivo y globalizado de hoy, es fácil sucumbir a las\r\npresentaciones y perder el rumbo.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Confía en ti mismo y en\r\ntu equipo; saber escuchar y aprender.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Apple Color Emoji&quot;;mso-bidi-font-family:\r\n&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">🔶</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:minor-latin;\r\nmso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;color:#0D0D0D;\r\nmso-themecolor:text1;mso-themetint:242\">Pedro Villasmil.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">&nbsp;</span></p><p class=\"MsoNormal\">\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n</p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Director de Operaciones –\r\nBee Insurance Corporation</span><span style=\"font-family:&quot;Apple Color Emoji&quot;;\r\nmso-bidi-font-family:&quot;Apple Color Emoji&quot;;color:#0D0D0D;mso-themecolor:text1;\r\nmso-themetint:242\">🔶</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif;\r\nmso-ascii-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\r\nminor-latin;color:#0D0D0D;mso-themecolor:text1;mso-themetint:242\"><o:p></o:p></span></p></h4>\r\n\r\n<!--EndFragment-->', '', 'Blog_15.jpg', '', 'entrevista', 1, 6, '2023-04-11 12:25:47', 'ES'),
(16, 'QUEREMOS TRABAJAR JUNTOS.', '', '<p>\r\n\r\n\r\n\r\n\r\n\r\n<!--StartFragment-->\r\n\r\n\r\n\r\n<!--EndFragment--></p><h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\"><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Conéctate con nosotros en\r\ntodas nuestras redes sociales y también en nuestro WhatsApp, +1 (786) 782 53\r\n13. Estaremos aquí para chatear contigo. También buscamos agencias de seguros\r\nque quieran vender todas nuestras pólizas para todo el continente americano.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Contamos con todos los\r\nproductos para preservar la vida de tu familia y la de tus clientes, llámanos\r\njuntos seremos imparables.<o:p></o:p></span></p><p class=\"MsoNormal\"><span style=\"font-family:&quot;Calibri&quot;,sans-serif;mso-ascii-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin;\r\ncolor:#0D0D0D;mso-themecolor:text1;mso-themetint:242\">Si estás en América\r\nLatina, también hablamos español.</span></p></h4>\r\n\r\n<!--EndFragment-->', '', 'Blog_16.jpg', '', 'equipo', 1, 6, '2023-04-11 12:28:21', 'ES'),
(17, 'VISÍTA BEE TV, EN YOUTUBE', '', '<p>\r\n\r\n\r\n\r\n\r\n\r\n<!--StartFragment-->\r\n\r\n\r\n\r\n<!--EndFragment--></p><h4 style=\"language:es-VE;margin-top:0pt;margin-bottom:0pt;margin-left:0in;\r\ntext-align:left;direction:ltr;unicode-bidi:embed;mso-line-break-override:none;\r\nword-break:normal;punctuation-wrap:hanging\"><p class=\"MsoNormal\"><span style=\"font-size: 13.5pt; font-family: Calibri, sans-serif; color: rgb(22, 6, 71); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Hemos creado un canal de Youtube para ayudar a\r\nexplicar los productos y ofrecer consejos útiles a nuestros clientes.</span><span style=\"font-family:&quot;Calibri&quot;,sans-serif\"><o:p></o:p></span></p>\r\n\r\n<p class=\"MsoNormal\"><span style=\"color: rgb(22, 6, 71); font-family: Calibri, sans-serif; font-size: 13.5pt;\">Compruébelo clickeando cualquier de nuestros\r\nvideos en https://www.youtube.com/@beetv1069</span></p></h4>\r\n\r\n<!--EndFragment-->', '', 'Blog_17.jpg', '', 'youtube', 1, 6, '2023-04-11 12:31:53', 'ES'),
(18, 'Latinoamerica, da pasos gigantes en la industria', '', '<p>La conferencia \"Hablemos De Seguros y Fianzas 2023\" recibió la participación del distinguido invitado Pedro Villasmil, Director General de Operaciones de Bee Insurance Corp. La cumbre, llevada a cabo el pasado 28 de Junio en el Hotel Eurobuilding de Caracas, reunió a altos ejecutivos de las más importantes empresas de Seguros en Latinoamerica.</p><p>Durante su discurso, Villasmil compartió sus conocimientos y experiencia sobre la industria de los seguros, ofreciendo perspectivas valiosas sobre la evolución y el futuro del mercado. El evento fue una oportunidad única para la comunidad de seguros para conectarse, aprender y formar alianzas estratégicas.</p><p>La participación de Villasmil en el foro fue altamente elogiada por los asistentes y ha establecido la marca de Bee Insurance Corp. como un actor clave en la industria de los seguros en Latinoamerica. La empresa espera continuar colaborando con otras empresas y actores en el futuro para perseverar en su misión de proporcionar soluciones innovadoras y de calidad en el campo de los seguros.</p>', '', 'Blog_18.jpeg', '', 'Pedro Villasmil - COO Bee Insurance Corp', 1, 6, '2023-07-02 19:48:30', 'ES'),
(19, 'Latin-America advance on insurance industry', '', '<p>The conference \"Let&apos;s Talk About Insurance and Bonds 2023\" received the participation of the distinguished guest Pedro Villasmil, Chief Officer of Operations of Bee Insurance Corp. The summit, held on June 28 at the Eurobuilding Hotel in Caracas, brought together senior executives one of the most important insurance companies in Latin America.</p><p><br></p><p>During his speech, Villasmil shared his knowledge and experience of the insurance industry, offering valuable perspectives on the evolution and future of the market. The event was a unique opportunity for the insurance community to connect, learn and form strategic alliances.</p><p><br></p><p>Villasmil&apos;s participation in the forum was highly praised by attendees and he has established the Bee Insurance Corp. brand as a key player in the Latin American insurance industry. The company hopes to continue collaborating with other companies and players in the future to persevere in its mission of providing quality and innovative solutions in the field of insurance.</p>', '', 'Blog_19.jpeg', '', 'Pedro Villasmil, COO Bee Insurance', 1, 6, '2023-07-03 10:35:34', 'EN');

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

--
-- Estructura de tabla para la tabla `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id_category` int(11) NOT NULL,
  `id_blog` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `blog_categories` (`id_category`, `id_blog`) VALUES
(3, 12),
(7, 9),
(6, 6),
(6, 10),
(6, 4),
(6, 5),
(3, 13),
(3, 14),
(4, 15),
(3, 16),
(3, 17),
(7, 18),
(3, 19);

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

--
-- Estructura de tabla para la tabla `blog_tags`
--

CREATE TABLE `blog_tags` (
  `id_tag` int(11) NOT NULL,
  `id_blog` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `blog_tags` (`id_tag`, `id_blog`) VALUES
(4, 5),
(5, 4),
(4, 6),
(4, 9),
(4, 10),
(5, 12),
(8, 13),
(4, 14),
(4, 15),
(8, 15),
(8, 16),
(4, 17),
(4, 18),
(8, 19);

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

--
-- Estructura de tabla para la tabla `campaigns`
--

CREATE TABLE `campaigns` (
  `id_campaign` int(11) NOT NULL,
  `name_campaign` varchar(100) NOT NULL,
  `subject_campaign` varchar(100) NOT NULL,
  `send_date` date NOT NULL,
  `description_campaign` longtext NOT NULL,
  `id_status` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `campaigns` (`id_campaign`, `name_campaign`, `subject_campaign`, `send_date`, `description_campaign`, `id_status`, `id_user`, `create_date`) VALUES
(1, 'Extensión de póliza de vida', 'Es tu oportunidad para extender tu póliza de vida con BEE INSURANCE', '2022-04-11', '<p>prueba de campaña 1&nbsp;</p><p><br></p><p><img src=\"https://bee.dsinternacional.com/dist/products_img/Bee_4in1.jpg\" style=\"width: 600px;\"><br></p><p>blabla lscjsbvhbvhouiv&nbsp; <a href=\"https://bee-insurance.com/\" target=\"_blank\">&nbsp;link aui&nbsp;</a></p>', 3, 5, '2022-04-11 14:20:35'),
(2, 'Extensión de póliza de vida Duplicada', 'Es tu oportunidad para extender tu póliza de vida con BEE INSURANCE', '2022-04-11', '<p>prueba de campaña DUPLICACION con cambio de lista</p><p><br></p><p><img src=\"https://bee.dsinternacional.com/dist/products_img/Bee_4in1.jpg\" style=\"width: 600px;\"><br></p><p>blabla lscjsbvhbvhouiv&nbsp; <a href=\"https://bee-insurance.com/\" target=\"_blank\">&nbsp;link aui&nbsp;</a></p>', 3, 5, '2022-04-11 14:27:23'),
(3, 'Bienvenida', 'Boletin 1', '2022-07-11', '<p>correo de prueba&nbsp;</p><p>por favor notifica a jhonny Matute por whatsapp que recibiste este correo.</p><p>gracias&nbsp;</p>', 3, 5, '2022-07-11 10:59:47');
INSERT INTO `campaigns` (`id_campaign`, `name_campaign`, `subject_campaign`, `send_date`, `description_campaign`, `id_status`, `id_user`, `create_date`) VALUES
(4, 'Nuevos Medios de pago', 'Buena noticia, tenemos nuevo medio de pago. Bee Insurance Boletín 1', '2022-07-12', '<p><span style=\"background-color: rgb(255, 255, 0);\">esto es una&nbsp; prueba por favor informar a jhonny M o Derdlim P , la recepción de este correo</span></p><p>_________________________________________________________________________________________________</p><p><br></p><p>Hola&nbsp;{{Nombres}}, Traemos una buena noticia para tí...</p><h2>Con <span style=\"background-color: rgb(255, 239, 198);\">Ubiipagos</span> nos adaptamos a ti con las diferentes billeteras que facilitan tus transacciones, ofreciendo <span style=\"color: rgb(57, 132, 198);\">un servicio</span> de pago nacional e internacional para nuestros clientes, siendo a su vez una herramienta de venta para nuestro Network.&nbsp;</h2><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src=\"data:image/jpeg;base64,[encoded data, 204436 characters]\" style=\"width: 905px;\" data-filename=\"IMG-20220712-WA0031.jpg\"></p><p style=\"text-align: right; \"><b>Para mayor información sobre nuestros productos haz</b>&nbsp;<a href=\"http://www.bee-insurance.com/#\" target=\"_blank\" style=\"background-color: rgb(255, 255, 255);\">click aquí</a>.</p><p><br></p><h1 style=\"text-align: center; \"><span style=\"color: rgb(57, 132, 198); font-weight: bold;\">1110 Brickell Ave, suite 406, Miami,FL<br>33131</span></h1><p style=\"text-align: center; \">Te invitamos a seguirmos en instagram:&nbsp;<a href=\"https://instagram.com/beeinsurance_?igshid=YmMyMTA2M2Y=\" target=\"_blank\">beeinsurance_</a></p><p style=\"text-align: center; \">También puedes contactarnos por whatsapp&nbsp;<a href=\"https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapi.whatsapp.com%2Fsend%3Fphone%3D17867825313&amp;data=05%7C01%7C%7Ccbeb4741f0c84a5f323b08da60ef183c%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637928877307831322%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=Mk4kpY7VozEvJpnjJIG1vwU8QZ1fv50AXnZr8d6jECY%3D&amp;reserved=0\" style=\"font-family: Calibri, sans-serif; font-size: 11pt; background-color: rgb(255, 255, 255); text-align: left;\">+17867825313</a></p><p><br></p>', 3, 5, '2022-07-12 14:48:27');
INSERT INTO `campaigns` (`id_campaign`, `name_campaign`, `subject_campaign`, `send_date`, `description_campaign`, `id_status`, `id_user`, `create_date`) VALUES
(5, 'prueba', 'Mira todo lo que puedes lograr con solo USD 29', '2022-08-02', '<p>Prueba de Push masivo 1, <span style=\"background-color: rgb(0, 255, 0);\">por favor notifica a jhonny vía guasáp el recibido de este correo</span></p><p>Hola&nbsp;{{Nombres}}</p><p><span style=\"font-size: 1rem;\">Muerte Accidental USD. 1.000</span></p><p>Invalidéz Total y Parcial USD. 1.000</p><p>Vida - Muerte Cualquier causa USD. 1.000</p><p>Servicio Funerario USD 2.000</p><p><span style=\"font-size: 1rem;\">Haz click aquí para adquirir tu póliza<a href=\"http://bee-insurance.com/emision.php?product=9\" target=\"_blank\"> 3in1</a></span></p><p><span style=\"background-color: rgb(0, 255, 0);\"><br></span></p><p>{{Nombres}}<span style=\"background-color: rgb(0, 255, 0);\"><br></span></p><p><span style=\"background-color: rgb(0, 255, 0);\">tambièn puedes hacer click <a href=\"http://bee-insurance.com/emision.php?product=8\" target=\"_blank\">aqui</a> y obtener tu pòliza temporal de vida desde USD 59</span></p>', 3, 5, '2022-08-02 11:31:55'),
(6, 'prueba Duplicada', 'Mira todo lo que puedes lograr con solo USD 29', '2022-08-02', '<p>Prueba de Push masivo 1, <span style=\"background-color: rgb(0, 255, 0);\">por favor notifica a jhonny vía guasáp el recibido de este correo</span></p><p>Hola&nbsp;{{Nombres}}</p><p><span style=\"font-size: 1rem;\">Muerte Accidental USD. 1.000</span></p><p>Invalidéz Total y Parcial USD. 1.000</p><p>Vida - Muerte Cualquier causa USD. 1.000</p><p>Servicio Funerario USD 2.000</p><p><span style=\"font-size: 1rem;\">Haz click aquí para adquirir tu póliza<a href=\"http://bee-insurance.com/emision.php?product=9\" target=\"_blank\"> 3in1</a></span></p><p><span style=\"background-color: rgb(0, 255, 0);\"><br></span></p><p>{{Nombres}}<span style=\"background-color: rgb(0, 255, 0);\"><br></span></p><p><span style=\"background-color: rgb(0, 255, 0);\">tambièn puedes hacer click <a href=\"http://bee-insurance.com/emision.php?product=8\" target=\"_blank\">aqui</a> y obtener tu pòliza temporal de vida desde USD 59</span></p>', 3, 5, '2022-08-02 13:47:57'),
(7, 'prueba Duplicada Duplicada', 'Mira todo lo que puedes lograr con solo USD 29', '2022-08-02', '<p>Prueba de Push masivo 1, <span style=\"background-color: rgb(0, 255, 0);\">por favor notifica a jhonny vía guasáp el recibido de este correo</span></p><p>Hola&nbsp;{{Nombres}}</p><p><span style=\"font-size: 1rem;\">Muerte Accidental USD. 1.000</span></p><p>Invalidéz Total y Parcial USD. 1.000</p><p>Vida - Muerte Cualquier causa USD. 1.000</p><p>Servicio Funerario USD 2.000</p><p><span style=\"font-size: 1rem;\">Haz click aquí para adquirir tu póliza<a href=\"https://bee-insurance.com/emision.php?product=9\" target=\"_blank\"> 3in1</a></span></p><p><br></p>', 3, 5, '2022-08-02 15:16:39');
INSERT INTO `campaigns` (`id_campaign`, `name_campaign`, `subject_campaign`, `send_date`, `description_campaign`, `id_status`, `id_user`, `create_date`) VALUES
(8, 'Prueba previa Masivo 2 ', 'Protege a tu familia por sólo USD 29/año', '2022-08-08', '<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img src=\"data:image/jpeg;base64,[encoded data, 114712 characters]\" data-filename=\"Campaña emailing Bee 01_azul.jpg\" style=\"width: 723px;\"></p><h1 style=\"text-align: center; \"><span style=\"color: rgb(8, 82, 148); font-weight: 700;\"><a href=\"https://linktr.ee/beeinsurance_\" target=\"_blank\">CLICK AQUÍ&nbsp;</a>&nbsp;</span></h1>', 3, 9, '2022-08-08 15:09:59');
