-- https://www.phpmyadmin.net/
--
-- Servidor: mysql1005.mochahost.com:3306
-- Tiempo de generación: 17-08-2023 a las 13:55:09
-- Versión del servidor: 10.3.31-MariaDB
-- Versión de PHP: 8.1.16

START TRANSACTION;



--
-- Base de datos: `ingccs_lamundial`
--

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

--
-- Estructura de tabla para la tabla `account_numbers`
--

CREATE TABLE `account_numbers` (
  `id_account` int(11) NOT NULL,
  `id_adviser` int(11) DEFAULT NULL,
  `profile` int(11) NOT NULL,
  `id_agency` int(11) DEFAULT NULL,
  `id_country` int(11) NOT NULL,
  `account_number` varchar(50) NOT NULL,
  `bank` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `identification_document` varchar(30) NOT NULL,
  `id_status` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `account_numbers` (`id_account`, `id_adviser`, `profile`, `id_agency`, `id_country`, `account_number`, `bank`, `address`, `identification_document`, `id_status`, `id_user`, `create_date`) VALUES
(2, 7, 3, NULL, 232, '013485678557996554', 'Banesco', 'Caracas', '242198756', 1, 0, '2022-11-08 13:35:56'),
(3, NULL, 2, 36, 65, 'erffdfdff', 'Banreserva', 'fdfdfdf', '674848', 1, 0, '2022-11-08 13:38:46');

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

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

CREATE TABLE `ads` (
  `id_ads` int(11) NOT NULL,
  `name_ads` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `image_ads` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description_ads` text COLLATE utf8_unicode_ci NOT NULL,
  `link_ads` varchar(100) COLLATE utf8_unicode_ci 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,
  `name_adviser` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `surname_adviser` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email_adviser` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT 1,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL,
  `pass_adviser` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `token` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `token_adviser` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `sesion_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_sesion` date 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`, `name_adviser`, `surname_adviser`, `email_adviser`, `id_status`, `id_user`, `create_date`, `pass_adviser`, `token`, `token_adviser`, `sesion_token`, `date_sesion`) VALUES
(1, 3, 'Yoward', 'Diaz', 'yoward05@gmail.com', 1, 3, '2023-02-23 13:04:06', '$2y$12$YR/3.SuucxkIE/UVRAk.au77uwhGjUTb1KyuEfhXyo0r/crBgALji', '89657217eba0129edd3f3df5658657e1', '$2y$12$9i0VqI5SUc9etwNFcsUJ2.7nVyew8ymgUQ2Nat8oF3.6fBAdVU2gq', '28985c1940ca4172b4293c697af48ff7', '2023-02-23'),
(3, 12, 'Jorge ', 'Montilla', 'eskalaconjorge@gmail.com', 1, 12, '2023-04-26 16:47:34', '$2y$12$nvZ3aDZwkcGsAipfFyH.S.sbJnUPZhXOg/zMYHltRpJupT4NOxWIW', 'af8618a0d527dbbfab83ab9adff6b90f', '$2y$12$NfK3qNQPscA74C9AUrK07efL0sQ3TTzQN9FaxACaRFOQuCts/UFQa', '91c4f42b106ef5b24be6be0ae0dfa2b1', '2023-04-26'),
(4, 12, 'Patricia ', 'Sulbaran', 'sulbaranyasesores@gmail.com', 1, 12, '2023-04-27 12:31:49', '$2y$12$kWXoXGfi8Jr.ycII72ykneRvMAn02rRCB0xzbWdJcSpp/js8WqoUK', '86d754d43b76901f9956c3f346fa1167', '$2y$12$d5bH2LXWPpNNXzmryczyhu2M9x/Vy/1nHbCFI/qV8y3lyakuJXtXm', '2f9a57087532b3e781dc50dc7ac061d2', '2023-04-27'),
(5, 22, 'Belkis', 'Carrion', 'belkiscarrion03@gmail.com', 1, 22, '2023-04-27 19:07:40', '$2y$12$695Pgo0Ki45oxlOqN8.Qh.mmFYuEbHZ.3AzL7GqWKCDzEQ7E.FIgq', '5471814d6d352b99f93f01d051e3fbc1', '$2y$12$RyCz.lRmkOShBrlimJ5YDer9cadXy.OmDhfLRZvvqHJns8sTpHcve', '8aaf23eb206a12da0bc394710f173d5a', '2023-06-09'),
(6, 22, 'Elizabeth', 'Lemoine', 'elizabeth.lemoine@gmail.com', 1, 22, '2023-04-28 08:37:48', '$2y$12$DgAcX7QgWfzqxBjWjfFcTePIjzIn2YHanea7lCkQTqKbdVGHgLq2i', '49cb912b0ab6ed4c874ad999728f9057', '$2y$12$Xo8a39KrstWuhgkDG8VIoutodXj7/hKUMos6WI.Y8cKg6ji2JvyDy', '2b92ec45bb80ad705520c5c4ebade8e6', '2023-04-28'),
(8, 10, 'JERRY  JOSE ', 'GIL ESCALANTE', 'JERRYGILSEGUROS@GMAIL.COM', 1, 10, '2023-04-28 16:17:39', '$2y$12$lCZ3YHgvxMG4XNQLsfR4qem4uPz2KOJugNn/ALCVioocT8JQunx/6', '39cd87b0154734b0f92a67b1bcaf7a01', '$2y$12$tioKvYOAyKMon70kNL9Ig.17xoLcdkU.JbjzpVBfbjl/68M9Za2KW', 'ffbb21739f0c97382e0e355e79c01f5d', '2023-08-11'),
(10, 10, 'MARIA ANDREINA', 'VILLASMIL', 'MVCONSULTORES7@GMAIL.COM', 1, 10, '2023-04-28 16:29:11', '$2y$12$WJO8R1Eu76KY69CQMHNLyuC3oAJJDzFl4Sid/EmURiRjQloMbnKki', '17346d7874ee6364a9d564a0decc411f', '$2y$12$LPhLQOJFrve7gT4aYFmnS.kymkqJauHxSnwuue5ikMVVxs3C7dLf.', '80957f206d163088ed70efd5fe466291', '2023-04-28'),
(11, 22, 'Armando', 'Rosal', 'armando_rosal@hotmail.com', 1, 22, '2023-05-03 15:52:15', '$2y$12$JlQajDtsfPVW6Dug7ezoJOCaXAwZQVkX3w59x3NFU0yyc5ph9D.vS', 'ba1da15b32b2eac421011db3ee3c6743', '$2y$12$lIEeJ.1S0SzUu7biCXfmIuoaVEUoj4Ir4qeAo0NF5Z0T07ioUwBii', '332f59fd02eaf39cb5ed810b4a15bb7d', '2023-08-15'),
(12, 14, 'WALESKA', 'LOVERA', 'adanalovera2016@gmail.com', 1, 14, '2023-06-08 11:04:07', '$2y$12$WenS3uq2KX.WAk8wqlPr8udy/sVFlpplYNAO5KcJykCNXOgV.qA5m', '008b7c7681a068a8134726eb18c9a02a', '$2y$12$fA8F9B2ttRfENy7yu0vYketZrxnSqqXN.5umARcCswQZYPdVOC.Te', '0cd732b4082e308172c8cb602d1cfe65', '2023-07-20'),
(13, 14, 'MAURO JOSE ', 'PEREZ LOZADA', 'maurojoseperezl@gmail.com', 1, 14, '2023-05-15 18:05:18', '$2y$12$wwfu.5Udhi93YrpGAoFpnuG5.CvfYwR3c3Jacq4U/ODxCoAfhN8GG', '29eef68700a8b741808f359032788021', '$2y$12$qjsRtvIhw2ryfXMmMKfZHew3GuCJzTe2fBiDaN1u2L.6gKDKZiQJ6', 'abc94f49507c1e385c4984da8d553970', '2023-08-04'),
(14, 14, 'MARCIAL', 'DURAN', 'marciald61@gmail.com', 1, 14, '2023-05-16 08:06:27', '$2y$12$j1ugqN44sWDdxgUaYMfICukxoOv67VC3lUPrbE4a9Yw9BCj34rsDO', '021b2c7d174f728d840547cf2c80adea', '$2y$12$z0AyXfGildKtTuv1e2Nb1OIEt2LfQRBwBbkb4I2pMwiPWYN8b/37a', 'f850ab605a55e9c425075b8886ed8580', '2023-05-16'),
(15, 93, 'MARTHA LUZ', 'SAÑUDO BEDOYA', 'V12954903@gmail.com', 1, 93, '2023-05-19 15:15:15', '$2y$12$9mc55FtWQncRr85S9h840u4ONB2vo6MkBceSb4/0ox.4ZmRSjZN7O', '953f9240a7ab5c1f55829836661159a5', '$2y$12$qyEz1wu0X46loYszVqUDm.qhjoi7ckov2ZLkw7luSkARRuikcwtSu', 'c6bc00ab9fb61ab6523c8aec3affcd6d', '2023-06-15'),
(16, 93, 'YOSELIN JOSEFINA', 'MEJÍAS TORREALBA', 'jyoselinmt@gmail.com', 1, 93, '2023-05-19 15:45:03', '$2y$12$HvtYfojjKCo0NMbPqyrEuO90mak2idRi4bP7JkOYhtS3ZHAHExzVa', '3d7f6a3e75d35ae3c4e37c0d83410855', '$2y$12$V3HW6zFazaeMxA7rcM9mvOuklLXdACqZxypNOWkA8zmvZDiHqfHOq', '555bac98a7ec6cca172de68dbf8d0266', '2023-06-15'),
(17, 14, 'ROSALINDA', 'GOMEZ', 'prof.rosalindagomez@gmail.com', 1, 14, '2023-05-23 09:03:52', '$2y$12$toxm2YkfnnKDoK87INNlzeGCCFMYE7DvPu3/3tvtatbieEUfnubjq', '12694d85ab7d2c57296e3c392032d3b6', '$2y$12$vEf3yznzwAqKZZy3F8NEMuwJ2XO/zySZTKykdQ.j2avcl0Ostzq2W', 'a613cb6da4f312e472a239fcc4b11498', '2023-06-12'),
(18, 14, 'MARIA EUGENIA', 'GUILLEN DORDELLY', 'aseguramegd.vzla@gmail.com', 1, 14, '2023-05-23 10:46:09', '$2y$12$4D1fVfBFhh6o5mTCsodQ4O8L1VJ9Ih03.P6C5gI2dexaJ36DTZ3tm', '0e3bfa56c7a3e3e49948013a9515593a', '$2y$12$mx8CsxIrhW.rEtQ7UNKHCewDpN5xUNJu1IVhsatVuq1IQF4f76SsK', 'b80b7b255660e8ca238e29c0228fb4fc', '2023-08-08'),
(19, 8, 'A M ', 'FAST', 'gerente.mercadeo@fastmed.com.ve', 1, 8, '2023-05-30 14:27:10', '$2y$12$BAuQPh68M7p8lfmSkO7lUuVEUTiVU45XVigedgwDa.dOTwYX.Wiri', '26f1d53d42cd085fae588266f0f33698', '$2y$12$TeWVs775PAIuKiVNgCRA9.jfW/wR/DulIwyfMwhFbeH00WlqN1yJ2', '783505d7d7ff71164f86aecce6ef26db', '2023-05-30'),
(20, 108, 'ALONSO ', 'RODRIGUEZ CASADO', 'alrodriguezc2011@gmail.com', 1, 108, '2023-06-15 11:24:12', '$2y$12$mM4srrw1nYCIWPj5iL6X8OfXnB/jss2eysMcdGpcYi.IOXAfnyyoO', '5fce31f08a2cc6fb474ef4b755c0b373', '$2y$12$Ki2l2MEHv8EKhB4cfUi5B.FDKBfbxWeUgTSKWCSKHr1gCMchU8zoa', '1dee572e475d9ef4bcebf58bba1012b7', '2023-08-11'),
(21, 25, 'Marisol', 'Chavez Paz', 'produccion@ibas.com.ve', 1, 25, '2023-06-20 11:32:31', '$2y$12$U0JYj/evrVIWMsyMU1zKB.mzRmfu2XNHtcj.ITpiz..DsKGN7k8D2', '5036b26f6f123e2d10f0c6d8b068f71c', '$2y$12$Sjjlfrdm4zqFu7Hs9d0aw.sJGU/CT1lS8mbpHda2bPSkexI8vUkcK', '3d78ba732e1e800ef542f1baf50d3c37', '2023-07-28'),
(22, 8, 'MARILYN', 'MARTINEZ', 'marilynmartinezr5@gmail.com', 1, 8, '2023-06-27 12:13:53', '$2y$12$gO.uLNJvkfmmz/fK6QzrVebPg6tXQ.osC3lFI2zsOMCR/EMbye4iW', '52f8d208a3259d98928e051d49361801', '$2y$12$IZlw6.PdRCGMOoS5jbNfTOpuQzQH.SZfxnV5seueTc.XIOGN4Ubwe', '059ea39861b041b4ef99f807252adf8c', '2023-06-27'),
(23, 4, 'MAKEILA', 'CASTILLO', 'mcastillo@lamundialdeseguros.com', 1, 4, '2023-07-13 14:55:06', '$2y$12$y9lEVZ067a9qb7svgHuWHOONhapYmAoMEbxUtZ.9hMSQ1IDMWjNnK', '5e97d3dc2a55c06c6bd0b4d5ea08ad1a', '$2y$12$kNAFhwCcEm1XB/iP/ertGu4UeubanVdZAF77G14wvboCcjM44wuFu', '787081b470c5454a7c81f03b23c29d9e', '2023-08-16'),
(24, 70, 'Letty Del Valle', 'Sarmiento Paredes', 'Lsarmi.88@gmail.com', 1, 70, '2023-07-22 13:39:45', '$2y$12$Vl4XypEtAtV5MkOdvxAluOYhm.Jb.IsptEJwxRMenUVsKD8I3w3H2', NULL, NULL, NULL, NULL),
(25, 8, 'GABRIELA', 'NIEVES', 'gabinieves1208@gmail.com', 1, 8, '2023-07-26 13:43:46', '$2y$12$IYxgIMxPgRPX4amr56ffauVb9UtySdSJR6MVpXgGkZhw5OkSvJrW.', NULL, NULL, NULL, NULL),
(26, 8, 'KIMBERLY', 'VELASQUEZ', 'kimberlyvlsz@gmail.com', 1, 8, '2023-07-26 13:53:11', '$2y$12$GmRDWBC/plLuGGrgGhOmreE3UaW8VA9aFeLMyRsItxTpbp4zpCYny', NULL, NULL, NULL, NULL),
(27, 8, 'CARMEN', 'FIGUEROA', 'carmenjfi@gmail.com', 1, 8, '2023-07-26 13:54:01', '$2y$12$a.xJqCDuhkcEFbuh5NWxH.ewKtrIf65uCL6MwR4AGn3ofUNQ/WCFG', '48143145805775cbd6c6efa247f49b17', '$2y$12$Y2C3bTETuzF13ErYnM1pD.LT6bc1n5QPBcTIDGt6UaN4yMYvv1rn2', 'fcbfa9470c6e6df844e0651cdee720ab', '2023-07-26'),
(28, 8, 'MARLENE ', 'MALAVE', 'kykamarle@gmail.com', 1, 8, '2023-07-26 13:54:53', '$2y$12$teu5MfOS4Z7eaz3rcoMSoO3AUZdJGd/l5GhwkGLrU3q7ZJZrzybGO', 'b716c6ae29878f5a90baec3f72c1823b', '$2y$12$lzQhbTLYk2v/pHBFsUvIrekRfcNEUPHA3fCpOMV5im6GOkzGtnrSK', '30be7b0f6febbdde4af95dd331354c0c', '2023-07-26'),
(29, 8, 'ANILUS', 'MATA', 'aniluzfianzas@gmail.com', 1, 8, '2023-07-26 13:55:29', '$2y$12$gauHffNwiKhjfTF6WPRXW.k7Qx.vhTsdPZXJcp7NgE8P5FmChPTfS', '42a76ca9ae1fa4a472170d07744dbd25', '$2y$12$DbBaLvOZzzdtfNkZ4fgnCuqZak9Q.ZTWU3vgWEElQE7ZE/zPTjr7a', 'c88af05a2b33d3bf173cab0e7490b375', '2023-08-10'),
(30, 8, 'CRISTIAN', 'RONDON', 'rondonmarrero@gmail.com', 1, 8, '2023-07-26 13:56:10', '$2y$12$d/VtiB26LCKgSv9/nfHvROjpAu3pxbipp0RyylxCruorSpcc8ykee', '6046f7fbf6254443fc50ca95f075d932', '$2y$12$PiGQDOFIzAycXyV2zb4xC.RzcjaZdwKXPNVfo9AdvRQfEan4cjay.', 'b513f3eb701e1cc2534de2db46a36792', '2023-08-10'),
(32, 151, 'Lorena', 'Soles', 'lorenasoles46@gmail.com', 1, 151, '2023-08-14 17:32:40', '$2y$12$Z52zDHPltz1s2K17/TsBE.eAm15s3Y3mdvAfsjVwOwF7ecQrR13vC', NULL, NULL, NULL, NULL);

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

--
-- 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
(1, 3, 25.00),
(1, 4, 30.00),
(1, 5, 25.00),
(1, 6, 33.00),
(1, 7, 25.00),
(1, 8, 25.00),
(1, 9, 30.00),
(1, 10, 30.00),
(1, 11, 40.00),
(1, 13, 22.00),
(1, 14, 22.00),
(1, 15, 30.00),
(3, 3, 1.00),
(3, 5, 1.00),
(3, 10, 1.00),
(3, 13, 1.00),
(3, 14, 1.00),
(3, 15, 1.00),
(4, 3, 1.00),
(4, 5, 1.00),
(4, 10, 1.00),
(4, 13, 1.00),
(4, 14, 1.00),
(4, 15, 1.00),
(5, 3, 16.00),
(5, 5, 13.00),
(5, 10, 13.00),
(5, 13, 7.00),
(5, 14, 7.00),
(5, 15, 5.00),
(6, 3, 16.00),
(6, 5, 13.00),
(6, 10, 13.00),
(6, 13, 7.00),
(6, 14, 7.00),
(6, 15, 5.00),
(8, 3, 1.00),
(8, 5, 25.00),
(8, 9, 1.00),
(8, 10, 1.00),
(8, 13, 1.00),
(8, 14, 1.00),
(8, 15, 10.00),
(10, 3, 1.00),
(10, 5, 25.00),
(10, 9, 1.00),
(10, 10, 1.00),
(10, 13, 1.00),
(10, 14, 1.00),
(10, 15, 10.00),
(11, 3, 16.00),
(11, 5, 13.00),
(11, 10, 13.00),
(11, 13, 7.00),
(11, 14, 7.00),
(11, 15, 5.00),
(12, 3, 18.00),
(12, 5, 15.00),
(12, 10, 15.00),
(12, 13, 9.00),
(12, 14, 9.00),
(12, 15, 6.00),
(13, 3, 18.00),
(13, 5, 15.00),
(13, 10, 15.00),
(13, 13, 9.00),
(13, 14, 9.00),
(13, 15, 6.00),
(14, 3, 18.00),
(14, 5, 15.00),
(14, 10, 15.00),
(14, 13, 9.00),
(14, 14, 9.00),
(14, 15, 6.00),
(15, 3, 1.00),
(15, 5, 1.00),
(15, 10, 1.00),
(15, 13, 1.00),
(15, 14, 1.00),
(15, 15, 1.00),
(16, 3, 1.00),
(16, 5, 1.00),
(16, 10, 1.00),
(16, 13, 1.00),
(16, 14, 1.00),
(16, 15, 1.00),
(17, 3, 18.00),
(17, 5, 15.00),
(17, 10, 15.00),
(17, 13, 9.00),
(17, 14, 9.00),
(17, 15, 6.00),
(18, 3, 18.00),
(18, 5, 15.00),
(18, 10, 15.00),
(18, 13, 9.00),
(18, 14, 9.00),
(18, 15, 6.00),
(19, 3, 1.00),
(19, 5, 1.00),
(19, 10, 1.00),
(19, 13, 1.00),
(19, 14, 1.00),
(19, 15, 10.00),
(20, 3, 30.00),
(20, 5, 25.00),
(20, 10, 25.00),
(20, 13, 15.00),
(20, 14, 15.00),
(20, 15, 10.00),
(21, 3, 1.00),
(21, 5, 1.00),
(21, 10, 1.00),
(21, 13, 1.00),
(21, 14, 1.00),
(21, 15, 1.00),
(22, 3, 18.00),
(22, 5, 15.00),
(22, 10, 15.00),
(22, 13, 9.00),
(22, 14, 9.00),
(22, 15, 6.00),
(23, 3, 1.00),
(23, 5, 1.00),
(23, 10, 1.00),
(23, 13, 1.00),
(23, 14, 1.00),
(23, 15, 1.00),
(24, 3, 30.00),
(24, 5, 25.00),
(24, 10, 25.00),
(24, 13, 15.00),
(24, 14, 15.00),
(24, 15, 10.00),
(25, 3, 18.00),
(25, 5, 15.00),
(25, 10, 15.00),
(25, 13, 9.00),
(25, 14, 9.00),
(25, 15, 6.00),
(26, 3, 18.00),
(26, 5, 15.00),
(26, 10, 15.00),
(26, 13, 9.00),
(26, 14, 9.00),
(26, 15, 6.00),
(27, 3, 18.00),
(27, 5, 15.00),
(27, 10, 15.00),
(27, 13, 9.00),
(27, 14, 9.00),
(27, 15, 6.00),
(28, 3, 18.00),
(28, 5, 15.00),
(28, 10, 15.00),
(28, 13, 9.00),
(28, 14, 9.00),
(28, 15, 6.00),
(29, 3, 18.00),
(29, 5, 15.00),
(29, 10, 15.00),
(29, 13, 9.00),
(29, 14, 9.00),
(29, 15, 6.00),
(30, 3, 18.00),
(30, 5, 15.00),
(30, 10, 15.00),
(30, 13, 9.00),
(30, 14, 9.00),
(30, 15, 6.00),
(32, 3, 30.00),
(32, 5, 25.00),
(32, 10, 25.00),
(32, 13, 15.00),
(32, 14, 15.00),
(32, 15, 10.00),
(32, 21, 10.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) COLLATE utf8_unicode_ci NOT NULL,
  `color_event` varchar(100) COLLATE utf8_unicode_ci 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
(8, 12, '2023-05-17', '17 de Mayo', 'rgb(186, 139, 0)', '2023-05-05 17:35:17'),
(9, 12, '2023-05-08', '7am ', 'rgb(0, 123, 255)', '2023-05-05 18:07:33'),
(10, 12, '2023-05-25', 'zoom', 'rgb(0, 86, 179)', '2023-05-24 16:22:56'),
(11, 12, '2023-05-25', 'zoom seguros altamira', 'rgb(0, 86, 179)', '2023-05-24 16:23:24'),
(12, 20, '2023-07-03', 'REUNION CAMARA INMOBILIARIA', 'rgb(0, 102, 212)', '2023-06-16 12:28:25'),
(13, 20, '2023-07-12', 'REUNION FLEXOVEN', 'rgb(25, 105, 44)', '2023-07-12 05:43:45');

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

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

CREATE TABLE `agencies` (
  `id_agency` int(11) NOT NULL,
  `name_agency` varchar(100) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci NOT NULL,
  `phones_agency` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pass_agency` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `token` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `token_agency` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `sesion_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_sesion` date DEFAULT NULL,
  `id_profile` int(11) NOT NULL,
  `id_reference` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `names_reference` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comision_fee` double(20,2) 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`) VALUES
(1, 'La mundial de seguros', 0, NULL, 1, 3, '2022-01-31 12:11:09', 'info@lamundialdeseguros.com', '0584248943284', '$2y$12$VFb6a7Bo3NnZ57N98SQnleFZjaspoIkV9kgK2S8Azxsun8cPrxVD.', '24c60a6919d0e26250d462de5d0cdead', '$2y$12$DOBG7cCO0lNXqEsPeGLUHujX4L1/sz2PietYBiuR7FxpgIfU8wKY.', 'aed053f07c2cc4b680a65eb14fe7626d', '2023-08-17', 3, NULL, NULL, NULL),
(2, 'Development', 1, 1, 1, 1, '2023-02-23 11:49:09', 'ydsystemsvzla@gmail.com', '12345678', '$2y$12$Lk4vyK8MDvYY2Jc3na66v.DXNkXNsli00Vq8tVc2AA/ddYB2gpi4W', 'b91b1ba9e3ac868bf5289d09b19cc12e', '$2y$12$Hj0Nfe68h.Obeo0VUwSOUOAIA3iv8kOPMUE7UJYvSEKFnreiAWVQG', 'f1e5a2f66327b4e3807d533bdec4bc0c', '2023-06-07', 4, NULL, NULL, 0.00),
(3, 'Development agencias', 2, 2, 1, 2, '2023-02-23 12:48:27', 'diazbasket5@hotmail.com', '12345678', '$2y$12$TbT.u14Vp6jWbOa6XGv2g..c/gv8RSrlz..AGzgId/HiWq.hbtk.2', '960245616b5f269c0b78f6ba67b8535e', '$2y$12$5095SdWuX4ttfaCxq/Zeu.2EzkSw/HhDWjIayJ3xoJUvOcuLSjH72', '50da28a74dccf81752d4497d240605e7', '2023-03-14', 5, NULL, NULL, 0.00),
(4, 'DEPM', 1, 1, 1, 1, '2023-05-26 09:33:17', 'depm2905@hotmail.com', '04248943284', '$2y$12$AMIgsCiyjzVS/6ZpkQI4c.TkyfmEBj7jtSl2R/4AVEWu2UwWmTG22', '1a4b256fc2f353b599f19500c7146c81', '$2y$12$C5VMxtXnOK5aAR6oVIngte1qznREMRR75a1xFk7v6roYHKmNeEYBu', '40836282ff246f0b21263b953d61aed2', '2023-08-16', 4, NULL, NULL, 0.00),
(5, 'CARMEN MALAVE', 1, 1, 1, 1, '2023-03-17 10:54:20', 'cmalave1@lamundialdeseguros.com', '04248153602', '$2y$12$b8AXQNfVN9wQG3HlmyPNIOCKiclOdCQOt3ICx.l3eIAk/CviamS/a', '27d65d65d7db5d38e5a3a0042b656ca1', '$2y$12$BE5EKsd/ksO0YpWvbYkpu.hZE5CCOpsORtDppWyiGor5nzhNWinxe', '7ad6272b0b64f6ed68b5a48d285f0c6a', '2023-03-06', 4, NULL, NULL, 0.00),
(6, 'CARLOS AZOCAR', 1, 1, 1, 1, '2023-03-17 10:54:30', 'cazocar1@lamundialdeseguros.com', '04144537707', '$2y$12$xPwCHNXrWIUKTV4GVhnCB.lFUblcjbq3enhTyPYjJEU4EnCp4eEMG', '9018bbc96f88545f222182ed132df383', '$2y$12$RK9dX7pwArDd8nD0N6lODuHdzBSdYSLLWVl06446nHT8OdzeVPJ6y', '890f361ea1ee858b27713770f5ae3040', '2023-08-01', 4, NULL, NULL, 0.00),
(7, 'RAFAEL VILLASMIL', 1, 1, 1, 1, '2023-03-14 10:27:27', 'rvillasmil@lamundialdeseguros.com', '04123130575', '$2y$12$uYmrwRVL8laFz/1AYuPEoeGMUYdFi9kqAAbxmzLRTe2a64OEGkcv6', '1e2aa29751fd2406eec641777c65dfa0', '$2y$12$9OTMkqoWAZafJ1wSMrN6Y.fOYXTM6AmCpFTUOXlc6OTl0mipvQwLa', '0ad88927ed03ff85bc268bc8d71a655e', '2023-07-04', 4, NULL, NULL, 0.00),
(8, '215 MANMAR SOCIEDAD DE CORRETAJE', 1, 1, 1, 1, '2023-08-04 16:12:33', 'manmarcorretaje@gmail.com', '04122134031', '$2y$12$4BjlQ7MoANJmr.v4ImTF8e5ozw2HPwIQKcu8zZR9Now5G/gxSLDju', '200eb9519fef27daa1da99c25d19d3b8', '$2y$12$YRrXZ.nsLKG2QpzlyJ1KrugrPAhHE6MM47UQrdf6guB1fF/d5lxN6', '5388bc34447bfddbb7558e8bebf8e0f0', '2023-08-16', 4, NULL, NULL, 0.00),
(9, 'carmen', 2, 5, 1, 5, '2023-03-06 11:44:33', 'carmen_malav@hotmail.com', '04248153602', '$2y$12$0AribH/SKzF4QWDsYwWCPuk5SMJGeiIZGQ0xzOMzvJgKxirT1L3le', '810b787249244a30192808cc9b08750c', '$2y$12$8SAEZ5p7p41.xOsZC3VFduuoW3m5KdND2KNyGKiYImfw3KpmrCa7S', '4373a51f2e5336ded22e28917288cde5', '2023-08-08', 5, NULL, NULL, 0.00),
(10, 'RED COLMENA  NG', 2, 8, 1, 8, '2023-08-04 16:13:52', 'ngarcia@lamundialdeseguros.com', '04242330703', '$2y$12$horBwDUaJ48qM97ODtcaP.0gTCJZQ.vsEGc.yDBVzouE8.mQEt4oy', '0d83287aadc1d99bbe0e118247860c22', '$2y$12$B5oORzE3dwiDVCySOGg9w.97UFXBiBzJKL2IYtbLP4kzysaqNmClG', 'fc2cef6dc3d5a2b6842443b0739a8f0a', '2023-08-17', 5, NULL, NULL, 0.00),
(11, '80076 GUSTAVO LEON', 1, 1, 1, 1, '2023-03-14 15:41:12', 'galeong1972@gmail.com', '04129145292', '$2y$12$wnVEdI/oGN9MGhEzrpwh6utULYW.WaOK1MVcSDEjibxbggh5QZm2u', '788f70246ec9c96ac6fb06960b9ed115', '$2y$12$CIgJ2tvIZsZfXnEDvZbsHOp6ACCuxw3h.9IjPd.5SL7gnP3pF3sl2', '88902fc68f6ff09411b5dd63a5ddb373', '2023-08-01', 4, NULL, NULL, 0.00),
(12, 'Manmar Occidente', 2, 8, 1, 8, '2023-03-17 10:46:34', 'manmaroccidente@gmail.com', '04122338737', '$2y$12$.x0QKq12qqVZ46hkOcgQ9e3Pe0v12wbOpuUgCfYpHwae92XqT31pK', '2d483c3d44b0b75b825e150a84b72709', '$2y$12$ODqo/aY7CzVKP.AgYUa6q.MZg0BescJ3Du63og2sRvdLHjSDdKGiy', '286c51f3f2b5ef5bfd6d750f267f5f41', '2023-08-15', 5, NULL, NULL, 0.00),
(13, 'Manmar Oriente', 2, 8, 1, 8, '2023-03-17 11:27:28', 'cmalave@lamundialdeseguros.com', '04248153602', '$2y$12$ZaP43K/qvBwN9wXZUiAAMOAN20EAcrxAOBjfEM7LF3100LqdNzYGi', '4043a85b1dbb836ecc48fdff43535963', '$2y$12$9oYYef1rK3KP9ResplWQEuAMiB36DQ33UYiVrc.jPvPsHplLd.9ya', '5de09a7c769042e6f806443826b4aa0b', '2023-03-17', 5, NULL, NULL, 0.00),
(14, 'Manmar Centro', 2, 8, 1, 8, '2023-03-17 11:27:19', 'cazocar@lamundialdeseguros.com', '04144537707', '$2y$12$gi54Tvd6wViRswCxSU98AeBwhUCYuaOSHGsf4G2u0urGT1pnKa4pe', 'fb91b205ca524b4c101e078438de33d7', '$2y$12$OCIt5PIv0jAkYWo96K.mLOY8r8./QuqPlsWEig1V0AVmSAZmhrAKy', 'f01d9600942463d380a1c79125f8174d', '2023-08-16', 5, NULL, NULL, 0.00),
(15, '214 JOSE ALIRIO GARCIA', 1, 1, 1, 1, '2023-03-23 12:51:10', 'operaciones@corredordeseguros.com.ve', '                       04241970569', '$2y$12$Lh9zC2B.35I0t1Hsh5rmdO1qhAgDAWbNBySarSocxXAU0qk4ro1A6', 'dd3dce1df1abaf349c615069b759e7e7', '$2y$12$LEXT8kxhV9jIhB.uxsGLTecYrvXvNUW9qcqSUH5NLSB9be5VbdjK2', '933a372e7b0ddc56a0c58a5bd132857e', '2023-06-14', 4, NULL, NULL, 0.00),
(16, '206 WILFREDO BAEZ', 1, 1, 1, 1, '2023-05-08 15:09:39', 'merida.wilfredo210@gmail.com', '04244958805', '$2y$12$1P4k3dVmq/e/37kDPJrKN.TQXJTewvSa0wF/kk0iGv16WQcpVoyHG', 'd0b274a2da33f123b8b89b7519e2dd75', '$2y$12$73hT/2Mnv.Up8tHcEBAn5OaRcLEZmSW0HKKgIJ64jujmc6ZybzrhO', 'ee3baf264a1c632f18b3a3582fcb1be8', '2023-08-10', 4, NULL, NULL, 0.00),
(17, '10814 DOUGLAS MENDOZA', 1, 1, 1, 1, '2023-06-28 14:53:28', 'agenteinsurancevip@gmail.com', '04125954218', '$2y$12$oHc0hRifPDCzs8Mo4F2e0eGA5wXWr9NtxSX/cjy.rXlxqc/pmLrMu', 'bf65bc083543e00a924bc261d4ab266a', '$2y$12$ct3B.seTQzJtllFVznSR1ec783V3oeU2X6mRvfiARHl2KRN5sMo02', '6c840832be49f408b2ccdca38a34a861', '2023-06-21', 4, NULL, NULL, 0.00),
(18, '216 LUIS SERRANO', 1, 1, 1, 1, '2023-04-10 16:26:30', 'lserranoseg@hotmail.com', '04143800090', '$2y$12$.RWdcdB41mDcmntnQLscreO58SwVIvUcm9PO1viiTxVLiqcfX0rWa', 'bd199e74caa8bce88c49d47577d08f55', '$2y$12$uKUAyfPo0u9bEnuY/ldcfOScDWYAd77Po2J1MKRh.1XiH3O44RELa', '12f2a0fe33d8e512844766cabb08afb1', '2023-04-11', 4, NULL, NULL, 0.00),
(19, 'ARMANDO', 2, 8, 2, 8, '2023-04-21 13:29:17', 'armandorosalasesor@gmail.com', 'ROSAL', '$2y$12$tpKCI15ttM5gltAkMZqTKOJeQR/sJyQiWmM3lOF8h/5ArIQDceKp.', 'd015a79a6606f8172e9596c02ced010d', '$2y$12$KksyEHDeklTqsmGtMycyJuoVP7AReEwo4HUhA36KkSdog2PsYaeEq', 'b954b660c17b8fc59040ef23969e7e64', '2023-04-21', 5, NULL, NULL, 0.00),
(20, 'Administración', 0, NULL, 1, 3, '2023-04-18 21:17:57', 'administracion123@lamundial.com', '1', NULL, '06cde18117e4d278ff33c65f42a6747e', '$2y$12$1O5IadJqDQNzjCBRzEcXKu/VhfRl9fqoRqh3UPgBvXmxSCDnuVym.', '2dedd765f4baed220993198380e234bd', '2023-05-12', 3, NULL, NULL, NULL),
(21, 'JD PRUEBA', 1, 1, 1, 1, '2023-04-20 15:31:25', 'jdtorrealba1203@gmail.com', '04242656185', '$2y$12$4PSam7qhHjmSts0TmA/IcelyFGqQ8XV0nIXhIOCyvnoEbJ/J9kBUW', 'cc2f0b98d672e113b0c9f75ce731f9db', '$2y$12$yRu05Kt5N1EHpSCpE8ieA.YYHoVCfDXaWpPJQlua/9fmkNrUIc8FG', 'e4f4d239ffb1d5b3c887574cdee77c3e', '2023-08-15', 4, NULL, NULL, 0.00),
(22, 'YV Solutions', 2, 8, 1, 8, '2023-04-21 16:10:59', 'yv.insurance.solutions@gmail.com', '+17867845503', '$2y$12$xcAoqiz7hiWNisGahsyaXOcvflFgeUtz7SSrobB7bViVXrb5pfrNy', '2b4772af5644246dab75e3304c94fa25', '$2y$12$QuQpdOt3eG3EF8.jYr1VAO2oPf5MtG8aPPIyqzs2uG0Zy1o0DOl1u', '1825fd5b013ea021883502ecc1ecf953', '2023-06-21', 5, NULL, NULL, 0.00),
(23, '207 PEDRO NAMIAS', 1, 1, 1, 1, '2023-04-24 11:08:48', 'pedronams@hotmail.com', '04144817379', '$2y$12$QkCz./DHVzf2/oNXy/9W0ODL19f99kq6qB.hmviICV90./EI6VG5K', '926d48f4eaad78aed356c869d28630ac', '$2y$12$BkzDqB3P/vTfJN4Y9Q8Xt.qRP.0d/kd52Cc3gF482fxuqciayERLS', 'e5d6de8697cf8a9a200f8c42272fcf05', '2023-04-27', 4, NULL, NULL, 0.00),
(24, '239 MIGUEL GIL', 1, 1, 1, 1, '2023-04-24 11:10:14', 'segugil@hotmail.com', '04244075044', '$2y$12$qsNKPAauNOFfXsqFf9gV6uJrZhFfjFqM0/Whonr8yTSxKU54til1a', '99a866e46407cf85881e183182475744', '$2y$12$.N9bCGELokwdFpRKo7Zw/esYPLfdPOGtiHg19LdTkIdjIVpSjPgK6', '26e690f96c8889fc97e2707632bc0d48', '2023-04-24', 4, NULL, NULL, 0.00),
(25, '132 IBARRA C.A. (SOCIEDAD DE CORRETAJE)', 1, 1, 1, 1, '2023-06-19 10:35:05', 'andres.ibarra@ibas.com.ve', '04244176011', '$2y$12$b0nDeo7hqKN86PhO/dgdLeyaBXLaixgUwLgSX/cVH23u93fy0A1tW', '08c61876043b67d966fdd7614f820391', '$2y$12$EKJCuHJxnnT6PkoIHF9x0.eyICmip7kUH/vkaniOvXlwzubntO2y6', '2a61a0ec8cac0beaad50841908b8a6ec', '2023-06-20', 4, NULL, NULL, 0.00),
(26, '203 LUIS JOSE GREGORIO ALVAREZ', 1, 1, 1, 1, '2023-05-08 15:13:10', 'ljsegu@gmail.com', '04144131775', '$2y$12$ziVLKMNAxcqyvWmBe2OCXeuj0HFY04f3Ruz5gmZdXiURbZVfF.kJq', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(28, '212 RAFAEL ARTURO SILVERA CHAVEZ', 1, 1, 1, 1, '2023-04-24 11:43:46', 'corredorrsilvera@gmail.com', '0414-4118574', '$2y$12$4DMauETZzEhzw3h0aAwcWeDHcZ/5mOg1I5Unz.3xB6dR7o7s3YtGa', '4b8d12ee6abfd2f49721eb70da7445ee', '$2y$12$TFa86uoaQeYL6kgxS/svC.8zHnFxGu5fqGWhWRrXjUZkEljKBmxGO', 'fccc95b35b4671fcb754649eb32ce1d0', '2023-05-11', 4, NULL, NULL, 0.00),
(29, '222 YUSANAI COROMOTO GUILLEN CORDERO', 1, 1, 1, 1, '2023-04-24 11:47:30', 'yusanaiguillen@gmail.com', '04143484619', '$2y$12$zWmRv3JHDKrP6JY71O1kheedC9KmaEdNCQlvdceNb6bc2oHnMXPLG', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(30, '226 GABRIELA LANDAETA', 1, 1, 1, 1, '2023-04-24 11:49:51', 'gabrielagonzalez35@hotmail.com', '04143411065', '$2y$12$hYjV1Qx8SI3c7iQHTVTRsuJYTp6tdeqmbIp8y.y0.o79lg3G0C9VC', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(31, '229 FERMIN GAERSTE', 1, 1, 1, 1, '2023-04-24 11:54:58', 'gaersteasesores@hotmail.com', '04243335765', '$2y$12$4RxgHs9IoU4P98BM6YT4jOBsXfNuoLfTlI4DLJbW7MXjQLVNR7aLS', '915b0aa204a284afd7159acface9b241', '$2y$12$LG1R0WrBh4QjWH.2Ji7hwey/6BP/BK7jcSacAcV6yzi3qDQeIASTm', '50321d54092ecc8b0a70f5f5cddd7e69', '2023-05-15', 4, NULL, NULL, 0.00),
(32, '20078 ROBERTO JOSE FUENTES BRITO', 1, 1, 1, 1, '2023-04-24 11:57:31', 'robertofuentes145@gmail.com', '04144252601', '$2y$12$haI2Tm4.eRt0FnR23yoOkOnb2XNO2FCs3flJ0EzalnsQs7Bs7Z8RC', '7c149e81d097b073c4c75b7f18a9a24d', '$2y$12$Cn7s7YRnNX/5W9j5mULhDejdz7sUSy0JTxhQHZrHwxx2itATrFhfq', 'a0ac0685242575162435b2398b28a779', '2023-08-10', 4, NULL, NULL, 0.00),
(33, '247 DANIEL BIZAMON', 1, 1, 1, 1, '2023-04-24 12:00:00', 'danielbizamon@hotmail.com', '04144354403', '$2y$12$7h5VExPdzRfE9XYQ7o/ozueFw.Q7NePFoNbDbRW/5OyPdWCdRDKgG', '594779f0c66c657f04a189584debc19b', '$2y$12$mbrWAqIfUV0pGjwuDT0kpu86fSiKGfb//Rr9TE.yYnIeM/EfZudPi', '94faa1858567a8da6ceba1fa5468dcd8', '2023-04-24', 4, NULL, NULL, 0.00),
(34, '1087 SEGUROS LAS DELICIAS SOC.DE CORRETAJE', 1, 1, 1, 1, '2023-04-24 13:21:20', 'seguroslasdelicias@hotmail.com', '02432422169', '$2y$12$rfe7nfHT/COn/qoqDXZMeu5vxkgvwAp2hnfhwpHXF9xDFdhKl/ElC', '973def3c5ad993f413b600f23041b91d', '$2y$12$A/Q/uxSOximn8ldTo2j88uZ/jKCY.tjNAnriXwmMGjuia4NXvKclO', '78eff3c4acc709a5765e663cc8e119fb', '2023-08-16', 4, NULL, NULL, 0.00),
(35, '80078 ANTONIO ZUBILLAGA', 1, 1, 1, 1, '2023-04-24 14:36:03', 'Segucorpo01@gmail.com', '0414-5194927', '$2y$12$G6vUA0ZsMZkAKeicvj2Wnepfy48B9jidtQVNjpqBptdzxQ86lJLBO', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(36, '227 A&O ASESORES SOC.CORRETAJE DE SEGUROS C.A', 1, 1, 1, 1, '2023-04-24 14:42:07', 'Mcanton@aoasesores.net', '04241804544', '$2y$12$Hv52uzCNEnVhWRSvualUKeevDY0vmrG8LdbGg1289vM3p3uRDYqSe', '4854a4acb1e456112a9a20ed4730b081', '$2y$12$wnmKcBVeHUgVjYLX1ButMONkIFSTs.1hks4Fe6TrprG3xK.riFTFK', 'b65432a4ade7e2ef66806a5a13ca7b10', '2023-04-27', 4, NULL, NULL, 0.00),
(37, '205 DEYANIRA ESTHER CAICEDO COHEN', 1, 1, 1, 1, '2023-04-24 14:46:28', 'cohenasesores@gmail.com', '424-2246061', '$2y$12$LaOBFJLVcJuAJHmAUoLZ7.dqcZBHQZslMpFED5Gj22Y4.4M4bcsUC', '1a8d9ae809a09edbf2b960e29949e85a', '$2y$12$06wmo4V70rFuKaSNAzZJOeWrrBNUMa9MgJgGF4VU3j0PsvoWsRFT2', '9940e3cbcb35bc8a96f17bc8816a05e3', '2023-08-08', 4, NULL, NULL, 0.00),
(38, '213 QUINTANA & ASOCIADOS', 1, 1, 1, 1, '2023-04-24 14:49:39', 'quintana.asociados1992@gmail.com', '412-9057222', '$2y$12$U/SGRLHbF996U2HmY1S7/ey0EC9yQ18wOh4s14YXVjIMKSMLR3kP2', '50fadea897553692f47c69062d466d7b', '$2y$12$Ldbwy8cJ5eylblXe9L66iOkCpnjHNDXDs9aDz8GrE/4HUCAAsCDgC', 'ea7a49bec5ce2f9c9112422ba990efe3', '2023-08-04', 4, NULL, NULL, 0.00),
(39, '225 JAVIER PIÑA', 1, 1, 1, 1, '2023-04-24 15:35:01', 'jepvpina@hotmail.com', '0414-1379420', '$2y$12$3JXrA8RIVNHxXJ9E17viZexAa8ZSKQa65d1wT37Ah5/s1GeGJCy12', '3de379bd86fb1a15f80bd6ff1a8e1542', '$2y$12$lh7bz1NcpBq6tDo5niItvO9mnCnmPFlLsZfpY4qzSAFea1QGqwUo6', '0ab57004e9ec2cda4f4d66332413fae8', '2023-04-27', 4, NULL, NULL, 0.00),
(40, '233 JOSE RODRIGUEZ GOITIA', 1, 1, 1, 1, '2023-04-24 15:37:59', 'jomyrogseguros@gmail.com', '414-3159641', '$2y$12$t5Lc13DRPU3aKz2VRbRxH.ATHezgJQaD6/QhpHCSq6TWD1Zq4/45y', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(41, '234 ZAIDA SABINO', 1, 1, 1, 1, '2023-04-24 15:40:37', 'sabinoseguros@gmail.com', '412-3712741', '$2y$12$xnUEyqc7ay5Q79kXJ5VtW.QpCR69djfPh4GByzOY6Igs7yuyCO9c2', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(42, '11137 HUGO LEAL', 1, 1, 1, 1, '2023-04-24 15:44:24', 'hleal@insertconsultingtraining.com', '414-6197228', '$2y$12$qUf/44nuljVHPGDGgbA7zO5EkxTi9hecG6AQgxPiQ0dIiqyycMkJS', '3ce79f7e188699f3109e1493aadc0ebe', '$2y$12$7fQhY9fl8Ildzl8lk11qHughjg594p3PjG3QNbkEbRaIPmxa0L2Jy', '73927381379762f98553490873f29ea8', '2023-05-22', 4, NULL, NULL, 0.00),
(43, '60008 YURI TORRES', 1, 1, 1, 1, '2023-04-24 15:46:52', 'yuryatorres@gmail.com', '424-2259038', '$2y$12$5V/I2mErX.T8Joi0VufOBewTIuVEQRdapBvLH6G7N1IQlYIO.DwBm', '6f2a658ecc01bc523c463e2bebd69e7b', '$2y$12$OJKtpf9t9ZgwUKwTPzFGA.E00NGUPDuyc5zwYO8SJTQafwBiezm5y', '94be24e33432acace59512ecb91a046c', '2023-07-16', 4, NULL, NULL, 0.00),
(44, '80077 LUIS ENRIQUE RODRIGUEZ RODRIGUEZ', 1, 1, 1, 1, '2023-04-24 15:49:15', 'luisproyectoaip@gmail.com', '0424-2259122', '$2y$12$ji/l7cnq2Lt9zf1mWtsjsuaXDfQaJ2RrjIw7vZcBNDYpWNyRo/TR6', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(45, '208 RICHARD DOMINGO OLIVA ROMERO ', 1, 1, 1, 1, '2023-04-24 15:56:34', 'richard.oliva.romero@gmail.com', '0414-0188134', '$2y$12$a4YvgT5qh6U2CJDoHJb.K.TcMLY1mwh7HLu77GziH/fSSe4e.yBam', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(46, '235 GAETANO RAMON  CENSULLO DE PALMA', 1, 1, 1, 1, '2023-04-24 15:59:36', 'gaetanocensullo92@gmail.com', '4144527799', '$2y$12$OMGATMzcSy9uMXloZpqjXOVoWu3WZ58Qm/DOLNZP6Wm3WlgETN3yG', 'd70cb9e91ed9adfcad2290a1e3e26fd6', '$2y$12$1jCb07DAlegq6kohmKeZC.mTS8v/mr51IIuuaFR9MAmW.hy2IM9La', '77e658c2e38d8228b9ba7bd5227290cf', '2023-05-02', 4, NULL, NULL, 0.00),
(47, '236 JUDITH DAVILA', 1, 1, 1, 1, '2023-07-19 15:14:52', 'juditdavila.asesorseguros@gmail.com', '0412-3216844', '$2y$12$g8/UM9WagH9SdfOBmnZ1lOqL2LChk.n1jErziiZA9y95bYtE4HOy2', 'd980af7fbd44762ba2d6c08d48a73357', '$2y$12$b/42s3knRYRNiVmJwbQ.puJSD8thQSgfjvUmPuvwEto7Afi1NVbZK', '1ef9d0ec3aa7137e95d3d5fc6c16dab2', '2023-08-01', 4, NULL, NULL, 0.00),
(48, '238 JOSE SAYEGH', 1, 1, 1, 1, '2023-04-24 16:07:41', 'lalvarado@sayegh.com.ve', '0414-1535913', '$2y$12$641x6iqXGw7AL.5OhSIWMewuXzu5wDsAjZ3r5hdGTnP7.EVDlXoa6', 'bc41f0ff5be35451b53ec01ca4fd103c', '$2y$12$RvFVwvOFcHC2F3CceiYNIuF9VX6k4DPC0gF6Pkca3d4f/J6CDCNLa', '14074c97cede17b0dfe78777413dc3a8', '2023-07-20', 4, NULL, NULL, 0.00),
(49, '240 DANIEL DINAMARCA', 1, 1, 1, 1, '2023-04-24 16:10:07', 'danieldinamarcaw@gmail.com', '424-9335597', '$2y$12$TyTj7fVEi3lYpbB.nvZf1uAY.KxfP7gCAoQElPhhVw7FxaH.WgtSW', '37f7edd59ec99491ce5682a60104ca54', '$2y$12$XB4Kai.UJQvc2K3rnZiUnOC/Xqw7QTKQkxnLX9jn5Y9pInlD47.46', '7c2de67d3daeb7878b33fe1f744c4435', '2023-06-26', 4, NULL, NULL, 0.00),
(50, '241 LUIS MIGUEL AVILA MERINO', 1, 1, 1, 1, '2023-07-14 10:12:24', 'msalcedo@pfpplan.com', '0412-8250748', '$2y$12$0pcw0RRp6DcJXxsmS0IJl.C8/yDLqAp0ecSfX3WKoZCW7bWWdhHjK', 'f719681bfa20c7be028f22535ceb201a', '$2y$12$ATTm1f2SGZSiDdB3Ic7TNuphl2/f8PN8xNxUNa6wIo71k/H5OjDoi', 'ee9cfb7e867f11bc2e7ddd23ee0e70f2', '2023-08-02', 4, NULL, NULL, 0.00),
(51, '242 OSCAR ANTONIO DE LIMA CORVINO', 1, 1, 1, 1, '2023-04-24 16:16:07', 'oscardelima@francadelima.com', '4140191593', '$2y$12$9Rq45WHKU.ypwBiHO.AwXu/XQtrz00mbXJCLaFmQd/JIvsgr2Ye6u', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(52, '988 JUAN RAMON BRAVO LABRADOR', 1, 1, 1, 1, '2023-04-24 16:21:22', 'jblcorredor@gmail.com', '0416-6219309', '$2y$12$Qvp8Iv.jB/f/8tpG5taO9O6vsDCTsa7JMKhfm2svRUrLwJkXikgcu', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(53, '243 ARTURO SEGUNDO VELASQUEZ GONZALEZ ', 1, 1, 1, 1, '2023-04-24 16:23:41', 'artuve1952@gmail.com', '0414-3336691', '$2y$12$rXfph7bX2pbKbCvtWoJZGufadZ3JnrJBiJPQ5k05UoSbBfww/OAbi', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(54, '244 MASTER SOCIEDAD DE CORRETAJE', 1, 1, 1, 1, '2023-04-24 16:27:15', 'master@mastercorretaje.com', '0424-1754785', '$2y$12$hQP1UGr.jkL6rsU5TTJih.mJ1KXW1CFlUSdTeAwR61/I4yBpvQldG', '22e279eaf39a024d695475428976c484', '$2y$12$vp8E8YvBf.Ada1iVroXsUuGrRplsqEBTYOVTJdrvNzzVBinc0mw.K', '1b4a1b8cddcbc3a2f3e738b88026ab27', '2023-06-20', 4, NULL, NULL, 0.00),
(55, '202 LUIS PINTO', 1, 1, 1, 1, '2023-04-25 08:10:27', 'lupinto1@hotmail.com', '414-4609972', '$2y$12$fmbjUp/QJYFCTkm22EbTq.jCyT6or86FSK.Tf68UiYDatQWLkhh6S', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(56, '70051 MICHAEL ENRIQUE CUADROS JAIMES', 1, 1, 1, 1, '2023-04-25 09:57:34', 'michaelcuadrosj@gmail.com', '0414-1342700', '$2y$12$YpSPY1vhwlNu9PvGjZ4.uexKLcL6uU5O/tBpcT8A.ko7eyT7IEJo.', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(57, '245 MARIANA JOSEFINA TORRES PARRA', 1, 1, 1, 1, '2023-04-25 10:46:43', 'jcam598@hotmail.com', '0414-2103844', '$2y$12$arfwcrUnbG5A2exYII0BLuE1RRdX53Z//2NzjeettqU0uPsbdnagu', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(58, '246 JUAN RAMON SILVA', 1, 1, 1, 1, '2023-04-25 10:06:30', 'sinversiones2030@gmail.com', '0412-1204260 ', '$2y$12$OoVhWHL8nlhXxk7NLQomduTvnZAFI4UYAtozjAnM39p/w0MVQG3hO', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(59, '20050 CARLOS ENRIQUE SILVERA BLANCO ', 1, 1, 1, 1, '2023-05-31 13:49:05', 'carlosilvera05@gmail.com', '0426-5678763', '$2y$12$Lum2Len6FJ..vSUOLG2.pu.glKDP3cufjXHzSgqqsjRpFJ9NHoO8e', '1bc58db1cbb0a0ba6bbd54e728829df3', '$2y$12$1hziEfMcCzVzXGKWE7Rmf.DwxH0mdwAER9p1eX2Iu1gp99Agtax9u', '052022bae510651483b31e5cab0c9318', '2023-08-15', 4, NULL, NULL, 0.00),
(60, '219 SERGIO SELIVANENKO CASADIEGO', 1, 1, 1, 1, '2023-04-25 10:15:28', 'sscseguros10@hotmail.com', '0414-3543191', '$2y$12$FzDtkoLPGcCQDJ2A7K.eN.EIy46CXht9NXySh8LkcUSKXOBsYVoOS', '7756db50c7739ddc0efb58c6657c13e2', '$2y$12$Hz3LpPNuUwSI3xlLs9XV9e4tZG..4Y6BLR4KMp6oNhG5Z6yXcSdH6', '17e4e10e619b4aca074e0ef31fd55478', '2023-05-09', 4, NULL, NULL, 0.00),
(61, '200 NELSON SOTO', 1, 1, 1, 1, '2023-04-25 15:00:39', 'sgasesordeseguros@gmail.com', '414-0841582', '$2y$12$gldvmvCWH08OWJZS38ZsvuFD4zWm0JaGW1ommesnTy..xZbBX9fa6', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(62, '201 JESUS E. SALAZAR A.', 1, 1, 1, 1, '2023-04-25 15:03:11', 'salazar775@gmail.com', '414-3945100', '$2y$12$bC4fu.kbX40bPyiKDzGuierUdYxxbO72clC08eTlIspf3YiojwhjW', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(63, '80015 WILIIAMS DIAZ', 1, 1, 1, 1, '2023-04-25 15:05:08', 'willians.diaz@gmail.com', '414-7855938', '$2y$12$CaMr6h2GOjJZKpF2BkGasuQHRuq79i0gqmQyDrwbdNJCjekcOkvSG', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(64, '80075 ANEVIS LAREZ', 1, 1, 1, 1, '2023-04-25 15:07:23', 'anevislarez@hotmail.com', '414-0863762', '$2y$12$ZfbGHk1Nj8H6H45SzNO.ied04GutSkb9YUzO2Z1JLZsyH/JsD3bVO', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(65, '211 JOSE CAMINO', 1, 1, 1, 1, '2023-04-25 15:20:09', 'j.f.c.seguro@gmail.com', '424-8860600', '$2y$12$pudJYuWEjKAFAvnXqkmMLe5Jos4fQY2Un4aP382yyGHlX1fMDxpRi', '267244e52432852e88c405da6c282ac9', '$2y$12$abzwB9B3NXmjK82Z6vPDm.aNnf5mkipzHQSkj9aXlo13bw51yn4qy', 'b1eec91538508ea7f6f2448c0c9d1e44', '2023-04-28', 4, NULL, NULL, 0.00),
(66, '220 MARY CARMEN ROMERO', 1, 1, 1, 1, '2023-04-25 15:23:17', 'oficinamre@gmail.com', '424-1792248', '$2y$12$WQDFVwT6rX5tgTnsvGFUAOi09q0udzl1HhKdIHdHxqgpz/bw/qGpi', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(67, '228 JAVIER MENDOZA ', 1, 1, 1, 1, '2023-04-25 15:40:00', 'javier_josemendoza@hotmail.com', '424-8697542', '$2y$12$nfdmYHNlGoN.VTgHskOUFOHBdQTmGusYY7M6FhInkKZVxewpIqBRu', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(68, '231 YONNEL GUSTAVO RAMIREZ DIAZ', 1, 1, 1, 1, '2023-04-25 15:28:51', 'yonnelr@gmail.com', '424-8043064', '$2y$12$oXUvZTTaUtLA4V8lkJ8Oju/v.gPYJmbIS60p2qRmcLlYNbbLNWkzW', '5b4cdac89286a00a6154275fe44c7bf8', '$2y$12$0m.n9ohEEUgl5SiaWO/IWO2iqbby87Sw2UNWsoMRLjzzWM.KiJHOi', '895342a3ee9e55286b0bebd5b894ed24', '2023-04-26', 4, NULL, NULL, 0.00),
(69, '80049 JONATHAN JOSE SIFONTES', 1, 1, 1, 1, '2023-04-25 15:32:05', 'jonathansifontes@hotmail.com', '04248679710', '$2y$12$iEoU9Jm3NzAVBQjhy3Z6x.dLgdzKz9jbXLaUFkg3OK6ewhPWxEQT.', 'e00d9163660dd73f8f5e309e159bfa94', '$2y$12$VlzDtRYQrZ9LhfHVlMLCsuuz32g3oUJm5OLb/9KWO50wA84Zqkd6O', '4cc0946102ad6f54bc82eedc32a512a7', '2023-05-07', 4, NULL, NULL, 0.00),
(70, '80079 ALEXANDER DEL CARMEN REDONDO ROMERO', 1, 1, 1, 1, '2023-04-25 15:42:26', 'aredondoseguros@gmail.com', '0414-8335089', '$2y$12$.2YjEjx3kqEirb82Q5CUVu.negikffpjzZzGtLasETwVuQqS4ZBfW', '3995842e90c265b3ce3901eba7113f49', '$2y$12$Dv5lYqVLoKBqYcMW4bdxJeFxmfa2peib/DMqW.ZU308gtUEXqCgEG', '1904046d93b9310a7458f1dd5abe24c2', '2023-08-16', 4, NULL, NULL, 0.00),
(71, '248 GRECIA CAROLINA MOREIRA ARCHILA', 1, 1, 1, 1, '2023-04-27 10:08:42', 'grecia.moreira1212@gmail.com', '04123976387', '$2y$12$CiSfUmTvV6XqOGeB.KJMK.KDtwxHpmU9rXCtuaO4AhwmpM/Aay5a6', '94087e7c484fd6ef307382ae678492cb', '$2y$12$.ffV9LjgF615v5GoolZIY.E2Q5UypxUoITXOoPso6JiAvs5ZWa49O', 'f47d071de83ef1f7327398b85a093e1b', '2023-07-26', 4, NULL, NULL, 0.00),
(72, '250 RAFAEL EDUARDO ARES PALMA', 1, 1, 1, 1, '2023-04-27 15:46:36', 'arespalma1@gmail.com', '04143247276', '$2y$12$dUy0PsR/.B/OmApnLCbQ1uNSWGtDH3fTLrp2ZAmptWldXavfZ1YmO', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(73, '252 JOSE JAIME GARCES JARAMILLO', 1, 1, 1, 1, '2023-05-02 14:04:13', 'jaimegarcesj@gmail.com', '0414-1311363', '$2y$12$bd7RcFYPiEBdLg0CD91f7.CH47I6DS3/6rzhS.J8p666SolYSr4be', '03725ac623ca27678b166b8f05c08571', '$2y$12$3kq9qVQrATr0O8koHJWRTuIMl71GjdYhcjSp0NNJEcntwd79W8GB.', '4f747bb5b3ab5b17effa037b4291c258', '2023-07-28', 4, NULL, NULL, 0.00),
(74, '251- EDRED MARTIN GONZALEZ SANCHEZ', 1, 1, 1, 1, '2023-05-10 08:16:30', 'edredgs@gmail.com', '04123022362', '$2y$12$ZNECtFi.z4Ymjm5TkC9LjOlrHTTFmG3pzHIFca.yGKn9GmS.bsv4u', '6a3ce75e31fae7d5092f19e32464e197', '$2y$12$Izyo2W6rWxQ6pi2plfdER.41z7qTBa4.aFdxys2.u1QcT/2LzuBOy', '04a03fba4022ee858f29c6f301f64662', '2023-08-10', 4, NULL, NULL, 0.00),
(75, '253 ANGEL RAFAEL FERREIRA FIGUEROA', 1, 1, 1, 1, '2023-05-08 09:44:03', 'angelferreiraseguros@gmail.com', '0414-4248568', '$2y$12$Db22dZnermVxTe1llUo.LeU0RbZrWqdguRHp0WLN.Yq8NeTU3BjBm', 'd558f7f5a7e601dfff9559a4503efc5d', '$2y$12$O/81AqRzHMJwTeYKmGFd8udYkvSp3S0RJ9aVIf7Y0Wz1NN5A.VnkK', '554db78c655b341fff6ab0c41225342c', '2023-05-08', 4, NULL, NULL, 0.00),
(76, '254 JESUS ANDRES HEREDIA ESPINOZA', 1, 1, 1, 1, '2023-05-08 10:42:59', 'jesusherediacorredor@gmail.com', '0412-4293024', '$2y$12$2HhmikG6.dgS.fhY6OIR0eZANi41DN39eQ0Ow.onqW26rhUzRTptG', '535f9c4334d39de6ede1fcb18ca5df2d', '$2y$12$uU2m8N68VhNupxlhVyemlOPLjjw2YKWVTfwI6StiBLVyFSpfi2IAK', 'ac83d694f930cad0221305c48cd62e36', '2023-05-17', 4, NULL, NULL, 0.00),
(77, '255 CESAR AUGUSTO HERNANDEZ SANCHEZ', 1, 1, 1, 1, '2023-05-08 15:13:26', 'cahs.corr3dor@gmail.com', '0414-5137721', '$2y$12$EkvdhZwAokvpyRFTJkQ/t.Nm1U1Mfg7mvgDnEvCECi2TMKeLCBThO', '7e534eb0f9d422fb1e7d7dc29b37aebe', '$2y$12$6Ly4otpH32Ajr7aDR2o4jeeU2Wut9yam/T83pvxlt6I0YpZKRiXo.', 'a052b338b1e4175c2d2bb7a16a0f3185', '2023-05-30', 4, NULL, NULL, 0.00),
(78, '256 FRESCIA ELENA GONZALEZ MARTINEZ', 1, 1, 1, 1, '2023-05-08 16:10:02', 'frescia.fg@gmail.com', '0414-7656862', '$2y$12$uZUv7tNxaBWO0f4EgqF84eL0DD9t2v4AY.94Bmct9JF.VbgI1jHaK', 'bef53ea07bb09ed05bdbdc55c42aa6e7', '$2y$12$.ezNEWsXrBzA6Ovg6gSAVuxpKfV5OL66geoNR5DhoWn8XDdKFdnha', 'f491943468b7000ae359c778206392e1', '2023-05-09', 4, NULL, NULL, 0.00),
(79, '80042 FRANCIA DEL CARMEN BORGES MEDINA', 1, 1, 1, 1, '2023-05-11 10:18:37', 'franciaborges@gmail.com', '0412-3809122', '$2y$12$yHwzfUKrRzx2ERlCLz4JQu8PF4HJvCPqLsxVZakFIF0l3HUDQ5SQq', '21f8ed94a6812fb4dab66067c6e8526a', '$2y$12$V7Eo2GyD.8zEF2Uz8Y90guob6sf/NwmRYqlbKqKNPCjOurc4irb7y', '218c53fe13082d3a57cb9b47a2b5e679', '2023-08-01', 4, NULL, NULL, 0.00),
(80, '70097 NUSHKY MARISOL GARCIA RAMOS', 1, 1, 1, 1, '2023-07-18 12:14:34', 'trenardgarciacorredores@gmail.com', '0424-3659830', '$2y$12$tYXM9NGWPRADB0xXC7meXOIGefXkb/E484EjSYw5qWCkm//RJMPTy', '5208096f40d6371161d55b5d48c00ece', '$2y$12$.Xi6vGdAQN6By0yw3Yq0JOR7wGIsh8eqWZKbXWNjU1ijBcO/sXQuW', 'b1157a251838b76f0d552f87442e67f7', '2023-08-14', 4, NULL, NULL, 0.00),
(81, '257 EFREN OCTAVIO DIAZ PRAOLINI', 1, 1, 1, 1, '2023-05-12 10:07:43', 'diazefren1969@gmail.com', '0414-4637570', '$2y$12$sT/jgETjig1BB3are9G.2ujahbHEJTjyR6IDEW/PuNnxW.B1zqBD2', '2eb1804625a6f0092b4cdd72c2057dc3', '$2y$12$cllHxfKTrAg928Hb6hj0DeMH0B165X41mB7zrhph5hEM9g/56Z8v.', '544b19a2afd710fabfd327d3c743c7fe', '2023-07-26', 4, NULL, NULL, 0.00),
(82, '258 RUIZ RAMIREZ RODRIGO', 1, 1, 1, 1, '2023-05-12 10:22:20', 'rcasociados110@gmail.com', '0414-3454158', '$2y$12$RI5UwL3naeu/rodpez05O.TAHEwhCMdQKoJAUl0Iyd3rhnOYj3lnO', 'e4a3ee955b425be1c72c79e649e9b1c1', '$2y$12$tBeYStzTBhWrPEvey1AaJOmIe4YkvrIBRUKo0JHj.W7xr4lZuKzFy', '7c4b648fb59bcb12144030c9e9bb8485', '2023-08-14', 4, NULL, NULL, 0.00),
(83, '259 JOSE MARIA LOPEZ GUTIERREZ', 1, 1, 1, 1, '2023-05-15 09:40:36', 'jmlgseguros@gmail.com', '0414-4336188', '$2y$12$Gtxv/OkjyH7V17/2oVYvvuUNdXE..syShy4nUXF1jMC3tW40yiWxe', '3fb889ce4e9c4a346d11a657b88598a4', '$2y$12$sMEkD7a1XPso9KbCf5Q6SO8ezN8dA2X9C5e.FsYmR69Zzj7BY6kMK', '9ce3b3a03f37a666faff18b83d91a860', '2023-06-21', 4, NULL, NULL, 0.00),
(84, '70082 VICTOR HUGO COLMENARES GARCIA', 1, 1, 1, 1, '2023-05-15 09:48:32', 'operativoseguros@gmail.com', '0424-4930725', '$2y$12$gegvvVZKXeta/zmUMJQsE.MSzMnf/jPcm5oQNCuS6oP1eO35EOLMK', 'cb2165f7a0b1eea0acab130f142f6605', '$2y$12$WH16NlpM9NeB0aJ36WwK3.Cq5miZAaov6Ua880rAliN7n5yLhY5Dm', 'c092d90e724da1510fb3f884fbb67834', '2023-08-15', 4, NULL, NULL, 0.00),
(85, '260 EDUARDO JOSE CEDEÑO SALAZAR', 1, 1, 1, 1, '2023-05-15 11:09:38', 'cedenoeduardo20@gmail.com', '0424-8593220', '$2y$12$xwt8RrHrBxsE3I6LxqeX6OopyJ52UKaT0Dy97SSSPkZxk0Q.qM0Ye', '6ee6bc7ce522a5c952b685142c811dc9', '$2y$12$g801kW1vfLePB6Mrl3bQAeJZVGVNfulgLJIhaygYKLE3cbO9iU8mm', 'ba2fd2bc179a44d6dada5a743b61ce3f', '2023-05-15', 4, NULL, NULL, 0.00),
(86, '261 WILFREDO JOSE PEREZ RNDON', 1, 1, 1, 1, '2023-05-15 11:54:43', 'perezr47@hotmail.com', '0414-4804193', '$2y$12$HgkIKLVpN.Xc4UTniA4OK.81X.bUILq56Oe76Llhwxk7l2boayQza', '9016ef2ec141f8682bfb32f21a46251f', '$2y$12$CfQ9yhSkvMkEl03Wd6xQ4OFBhHuPFBYXwRJsQTWqdu5VJCS7IfS2C', '123b78509cfcf75fb3576fdaa76fbc37', '2023-06-26', 4, NULL, NULL, 0.00),
(87, '262 LUIS EDGARDO BURLANDO GAERSTE', 1, 1, 1, 1, '2023-05-16 08:22:35', 'burlando.60@hotmail.com', '0414-4194601', '$2y$12$C6c/ph.IimVscKOpsal.LuP.yQ1sYi2uIyA6akulPUT0upKZsO0cC', '8a99cecaf7a5f62efc4daf2f2a37ed4c', '$2y$12$E1FgVK0SGaxB/39DCknZ8.jrgwAvJG87IagSSXN74vQg8dd5ddNeq', 'a0930388f5d0cea32e4b1b04812b4994', '2023-06-21', 4, NULL, NULL, 0.00),
(88, '263-JULIO CESAR PADRON CODALLO', 1, 1, 1, 1, '2023-05-16 10:27:10', 'jpadron80@gmail.com', '0412-2487808', '$2y$12$X7C5NrUjubp0R54XVtf0M.eG0DzhkZ1ZWQa/ls70OjjO5bRU4n3RK', 'b0a1f45cf739eb474ef7f5165546d452', '$2y$12$KkupSteFtTH/H..0AMnk0uHPXWJmhY2cdC8njNCFmeOghHt9kIpDO', 'd178beede99d679f00c26196401f503d', '2023-06-01', 4, NULL, NULL, 0.00),
(89, '264 NOEL JOSE CEDEÑO MARCANO', 1, 1, 1, 1, '2023-05-17 13:48:06', 'njcm31@gmail.com', '04122990224', '$2y$12$a9gQIoRxo3dd8oT3Wfu28eiemSq0KowMBwuQRvcdCJLrL5/Fw.2s.', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(90, '265 GRENDYS DEL VALLE FARIAS GOMEZ', 1, 1, 1, 1, '2023-05-30 16:10:38', 'greudys.farias@gmail.com', '0424-8037415', '$2y$12$GiqGk7E4r6nco/KNifp6T.Navm8ruNaGJm7dxInh55/GMqT6OfUD2', '8700446650cea4b43ddf03aeea7034eb', '$2y$12$Rz9vnfZ4d5CVDoeYW8.mG.Z6nsVfV6VANzVJxKBy74kXDmRQJTo32', 'e924a30856c940cbe04d2e9c4c04eec2', '2023-08-15', 4, NULL, NULL, 0.00),
(91, '739 DIONISIO ARCANO D NICOLA', 1, 1, 1, 1, '2023-05-17 13:53:59', 'dionisioarcano.gerencia@gmail.com', '0414-3440046', '$2y$12$y0zvpc1xD1rEN0wlQoJiiuKMLdAcLSmLacmRKi4G6Ea0wj6e58gI2', '8f4e6b4fe325a89433294fb3f64a296d', '$2y$12$6HjPEmCDynjbRhIhlkDQUOyZRAziyQwqXLK.lPnzwAUVx7HGc/DAK', '9c83c13bd5c3f003d03c59bb00770975', '2023-07-27', 4, NULL, NULL, 0.00),
(92, '266 ANTONIO MARIA ARGUELLO LA TORRE', 1, 1, 1, 1, '2023-05-18 15:03:21', 'antarguello@gmail.com', '414-2257613', '$2y$12$hhOdqeKOy8RPtFXLVCCvnun8elUOqD7z9UV6jXjOUF1aFTyLSvaSa', 'f4bed1c4ce1cd83a8f6a5d55f5a99a3e', '$2y$12$97Firb3TCnDr60AHW8Jl7uKn9RO/78Rz5jJWODDbGpkZri3SyFku6', '437a238bae9dc91238952be19b122293', '2023-07-11', 4, NULL, NULL, 0.00),
(93, 'YCASTILLO', 2, 8, 1, 8, '2023-05-19 14:16:02', 'yaneidycastillog@gmail.com', '4129711734', '$2y$12$Wr3kYH1swZpr1L2ei0g/wea8oLjjehS8LUpFeWXyxnYcpctX6qBqC', '5fa9e514bf92e002b90447b015a33cab', '$2y$12$khu.lo8Vr.NfyEhqX/mXOek7DUPuA9NF8s9s50TktRg22t7P6nmfC', '7e123f928084a74dd39170d6c64a3745', '2023-08-09', 5, NULL, NULL, 0.00),
(94, '268-PEDRO RAFAEL MENDEZ CUMACHE', 1, 1, 1, 1, '2023-05-19 12:00:32', 'mendezcorretaje@gmail.com', '414-8128228', '$2y$12$x1Kr534SUp5KdckuK4fGAOGmiaF1YzViVEhR/iyoKwsX4uekKN3l2', '530919bc737094fcdbf612ed271e5853', '$2y$12$pnI.JN/sJ5P4dlS2vIJGIOuJSTXRv.Mw5bkQFt3BnFIdv.8hIECvW', '736e962347932671826500a84b28d481', '2023-07-18', 4, NULL, NULL, 0.00),
(95, '269 MIGUEL ALFREDO FIGUEREDO CHABASQUEN', 1, 1, 1, 1, '2023-06-22 10:35:51', 'mfigueredo1@gmail.com', '412-8349583', '$2y$12$ytsqcIGKh5/7TjQ2qA8cqurmiuUPV.Dj5tNPhXd4xTpD.oWSFJVVS', 'bb8a8cd62dff53632bf13a4f802901fb', '$2y$12$4TFaOxclndgEZ3hMSdOTh.mS8BQvip2v.onIZ4PyKvFbTyHJk7M7q', '274945114986cd9749db55629dfb1ac3', '2023-08-12', 4, NULL, NULL, 0.00),
(96, 'POLISUR', 2, 94, 1, 94, '2023-05-20 07:41:58', 'memdezcorretaje@gmail.com', '04129442699', '$2y$12$7TEZNosH1WRQyp0QVzzLFenyFDZCXm/gBBvNiHaDJzKNNQBEPFv3q', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00),
(97, '270 MARCOS GLOVANI CASTILLO RUIZ', 1, 1, 1, 1, '2023-05-29 10:23:08', 'suscripcion.mcr@gmail.com', '414-4606899', '$2y$12$Bih9CmPtNGXLff1cQ7HnnOcUCqNTBYJLwjYSMjVk9cIY3B0CaR85u', 'ffc6dffaaa9aba6a65bfb7d00849f088', '$2y$12$nS/aZc2lwkO6nFRKPOwKoehOJQbZR31NcPlkN2KOp5FUT6RoIlLoO', 'f0d8b77191474414f6c8f0e1ed05181f', '2023-08-16', 4, NULL, NULL, 0.00),
(98, '272 ALEXIS RAFAEL FIGUERA LANDONI', 1, 1, 1, 1, '2023-05-25 11:09:20', 'alexisfiguera@gmail.com', '414-5880593', '$2y$12$x0AKrb1UWOyTjO4nEnaeN.FvMk3B3UhHEWAJflUuugx82VO80MsFC', '9894a56bbd57e7e1c148071461238e33', '$2y$12$4Mx1rM/FzMcC013bLGPK1ujJXw9Jezgx3OSF4aTTnYYoEJTLZjOFW', '8613feef27bb31d0580ad50790835ae2', '2023-06-08', 4, NULL, NULL, 0.00),
(99, '1092 RONTARCA WILL, C.A ', 1, 1, 1, 1, '2023-08-08 15:00:33', 'AffinityVenezuela@willistowerswatson.com', '0212-2045290', '$2y$12$sbPqr7DjMfzepCY74uKax.EIAoXl86NiYJ5ETLHJwSx2lpcTqdUSW', '205e2bcb2c6ae20f1fe902af949583c9', '$2y$12$p1FAtU.en5YPxtkEf1iGzOcxeRyZq1zm6Z2WjGztDjiRS/G75tGB2', '7693f0b2b09dde4a6b43ef6ce9bb097b', '2023-08-16', 4, NULL, NULL, 0.00),
(100, '273 RAFAEL DE JESUS REINA MARQUEZ', 1, 1, 1, 1, '2023-05-30 13:46:25', 'rafaelreina57@gmail.com', '414-3402835', '$2y$12$E3tE3BcwYLTsiNLDs5pfP.sFwny0CYHhl7ylYhG39GtBw8TkTgqQa', 'd92d5ccb1ff83795a6e405a93d8ba000', '$2y$12$cOC3UiWBvo3c9GsgBgSs9u8LXeZcB1YvY2/ZNqZfec/OeHxwfXtwa', '60cf8baebc2d7a65914df838c2040cbd', '2023-07-28', 4, NULL, NULL, 0.00),
(101, '50040 JOSE ALFREDO MENDEZ SALCEDO ', 1, 1, 1, 1, '2023-05-31 14:39:07', 'josealfredoasesor@gmail.com', '0414-3769471', '$2y$12$FQYdmWyRJm4pPeoLMfoXz.H1ali3NK1C6Xz3UOs1ylpnrmOje0o5W', '5fc7449c9cbbd9167918cb4046628ade', '$2y$12$SeLOMgES77IGRjhrHnlG8.y2zTuSpa6knYiLYrVGQwK9apo42DR6K', '779d0ec8e2b6a5a1792d2c68816499ad', '2023-06-09', 4, NULL, NULL, 0.00),
(102, '50017 NADESKA CAROLINA PIÑA GARRIDO', 1, 1, 1, 1, '2023-06-01 10:23:01', 'nadeskapina@gmail.com', '0414-3372914', '$2y$12$Ya7pK2z.AwQiMeXcdVTuxewSRLCmWfavEFOuK/q3gKImdTQO9PYFq', '3aa10eeff22227429f016cff797f9da8', '$2y$12$/aSvxp8LiCGRd1pTfO.9ceb7Q7fUk9rlZJb0oEa.3vnglpwX5IqR.', 'ba2c7240f5c0eec45c444f96e7db5241', '2023-08-11', 4, NULL, NULL, 0.00),
(103, '70049 FRANKLIN SAUL GUILLEN SANCHEZ', 1, 1, 1, 1, '2023-06-02 15:19:12', 'franklinsguillen@hotmail.com', '424-3092950', '$2y$12$4.VorRA7.PlPtRu9F8TX9u.KEh9HjIypUA5JmNgC8C3fLduKBVqgC', '48ec47e5d7e652f891a52a39529bb580', '$2y$12$znwDrNJneXIWrtwntbqqcO9VkcFC9LSVDsoRK4GHdWqfILFQrtBna', '44a8bb63456b81a6e87b57ca83bce263', '2023-06-20', 4, NULL, NULL, 0.00),
(104, '50013 WILMER RICARDO HERNANDEZ PADRON', 1, 1, 1, 1, '2023-06-07 14:03:44', 'whernandezpadron@gmail.com', '0412-8979983', '$2y$12$BxvtFgntjpIroAkH5M2.4uw4owURoM.NYpjBXS.hcGdAenD4NKYy2', '2983fd186a4261b95fce23225d998fb6', '$2y$12$6Ym4kR1qAuoyoUP8SNgkV.znAEyNDkzfZFOFz1eJtrLS4c6vTy6nu', '5a005eaa30ed7ea4f3ea87aeeab9da71', '2023-08-15', 4, NULL, NULL, 0.00),
(105, '20013 NERIS CANOVAS', 1, 1, 1, 1, '2023-06-09 08:28:19', 'neriscanovas@gmail.com', '414-8064144', '$2y$12$.s31ZGqjd5sfqBPBpH/MXugqrPA7W1mpc1mRZJnw0EKVPwKCpLN86', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(106, '274 CARLOS ENRIQUE LAIRET OTERO', 1, 1, 1, 1, '2023-06-09 16:00:17', 'carlos.lairet@gmail.com', '424-5247381', '$2y$12$uU7CZvkX1tQkiARGSVhZ1u1qrWCYaLhprMrSlQX7dSWqxOuo0mv/.', '7557f677dbc85f1aec5908cb1dacc16f', '$2y$12$V1ibuusJ9yfhcjQ5xBaQ/.Qqrrha/ikvoac0xeZgEkxFQrbFBia5e', 'a73f6c446f51f34b225428a9c90c8185', '2023-07-18', 4, NULL, NULL, 0.00),
(107, '275 SANDRA COROMOTO IDROGO QUINTERO', 1, 1, 1, 1, '2023-06-12 14:31:25', 'sandraidrogo.seguros@gmail.com', '414-9188280', '$2y$12$mx5KqKwWJYHNUcGqKPCXaeX3nto9mIwpyQ3K2awegXG9NvdXeC156', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(108, '276 LENIN EDILMO GUTIERREZ CARDENAS', 1, 1, 1, 1, '2023-06-12 15:28:38', 'lenin.1012@hotmail.com', '414-4354703', '$2y$12$1gykLC4K5r7hIU/qaYYEGePKD6XZWUE3d1LaqrVoAmMBH4.FGiDpy', '1b61a0e352c9b649469bde4faf693cd1', '$2y$12$95A5go03juhIrZqtRybnM.IZcfeYR042ycBmYGTVMZvrSyBg57f/q', 'b7ca97f90f57be7a9a440d0327d67ac0', '2023-08-11', 4, NULL, NULL, 0.00),
(109, 'VisionBiz', 2, 8, 1, 8, '2023-06-14 08:55:11', 'Info@visionbusiness.us', '+1 (305) 582-8276', '$2y$12$lut1Swykn20uyrKXa5cJO.dlQVSQcx9wzFbShM6W7t3JbPyrQwHnm', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00),
(110, '277 EDGAR DAVID GALLARDO ARIAS', 1, 1, 1, 1, '2023-06-23 10:50:34', 'edgaroas@gmail.com', '414-3784454', '$2y$12$9INSVIvOkuOPdWvveko4SO4p/O1DELy4o9jkO6xeuYzEiJsfAuUEG', '835d8b1d74262a5de8587a141622a0f8', '$2y$12$3Fwro/5Q70Zuh.bgVvDYqOhJ/v2kPJjcKMEGm9s9.ucUuPd6NJOky', 'be08c189ec220908c8b77c4f95917f22', '2023-07-30', 4, NULL, NULL, 0.00),
(111, '278 SIMON ISAAC SANCHEZ CORRO', 1, 1, 1, 1, '2023-06-16 15:37:44', 'siempreseguroparati@gmail.com', '412-9626683', '$2y$12$7Aq6aYBuxtNA1RHYfwgC3ezFdCD3S/w22giu9iMNnJcqq.AaSSf/e', '0f138274f3c4694424142be55d6f824d', '$2y$12$ZuhTz8oxwARSB2bGypokteSxEjyLvpDh7DZnHKvqk.Z43E.DGHXOi', '21b457aba371b836b7ee586f7ea05d0d', '2023-08-15', 4, NULL, NULL, 0.00),
(112, '279 DANIELA ELIZABETH LOPEZ VIRLA', 1, 1, 1, 1, '2023-06-23 10:23:20', 'danielalopezvirla@gmail.com', '424-6813488', '$2y$12$1ljXDEdjqK7ObcwzoyWSzeS84VX/XPL/exyfVpQBzXzv63L3ZcOI6', '120f103d4231dea47e2b7750c65c346f', '$2y$12$NefJcSml3BQUm/pUhRR48O8TP11oMfhZfZ7uCumxRVmUlH7TMcRVW', '8f024986b6011600b10acc1f5a48154f', '2023-06-22', 4, NULL, NULL, 0.00),
(113, '280 ALFREDO DE LA CRUZ QUINTERO', 1, 1, 1, 1, '2023-06-20 08:54:28', 'quintero030559@gmail.com', '412-6387200', '$2y$12$cG6QUDtKVguWzRqesStIyOt/LWW9/OStNsGDqNwBxteBzkD9oq/eO', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(114, '281 DAVILA DE FREITES ANGELA AURORA', 1, 1, 1, 1, '2023-06-21 14:30:37', 'angeladf1302@gmail.com', '+1(786) 8305558', '$2y$12$57ZQKPnHMuMIBPiEZpVS2uLmwxUoKfx0QWYumF0XvFWH5ujs8EKp.', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(115, '282- GERARDINE GUARIGLIA HERNANDEZ', 1, 1, 1, 1, '2023-06-23 10:27:53', 'gerardineguariglia@gmail.com', '414-3150813', '$2y$12$0GyPWA99iYqzzvzZ7X47bO5DWGSNgdLy2md/lA/kr79ELkjAcR05u', '8fe00c8c95332aa8d590db24eb4fbda6', '$2y$12$fu2QkRRWFUaiYEoRjCFc4OvafOww5FTehj66nziKNMfW3.vRVGUXa', '1d6767110f76a4c13df46e5623518523', '2023-06-28', 4, NULL, NULL, 0.00),
(116, '283 ZULDY LESLIE SALAZAR CARRIAZCO', 1, 1, 1, 1, '2023-06-27 13:17:17', 'zuldyleslie1@gmail.com', '0424-4692413', '$2y$12$OhUeAXkj6YjWkZbXUdQXoeM8MK94mKa9WL8WmXBt2V313uB5VUNi.', '1e48b0102c6ed35f2ac7e750912cb06d', '$2y$12$SxJvr6jdf7O7iDjrGmJbxeM4B5/ERhLoCcVo3uGYS9yDZ6v5cjooa', '5525c1e4f65fd807a3c5eda89cbab369', '2023-08-17', 4, NULL, NULL, 0.00),
(117, '284 LUIS ENRIQUE ROJAS RAMIREZ', 1, 1, 1, 1, '2023-06-28 14:53:54', 'laoficinadeseguros@hotmail.com', '0414-0315961', '$2y$12$umt2X.JpbHoASVeIWNbdJ.v5598VSFeWbYaIIVaUWaPL11LqDGY.O', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(118, '285 ELISEO ROJAS SOLER', 1, 1, 1, 1, '2023-07-03 10:14:11', 'erojassoler@gmail.com', '414-2347042', '$2y$12$///bD3q5FslYc57PBjC4bOBCO/cv5BC7/hFa3UyjCZEeJnv3Fk0HK', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(119, '286 ALEJANDRO CASTRO SILVA', 1, 1, 1, 1, '2023-07-03 10:16:27', 'alseguro@hotmail.com', '0414-2880989', '$2y$12$Jp2J1qo.zkoH9yAqkTJz7eyIQd6KjfB2sanKv4gcYFlBlO1VbBrum', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(120, '287 BLANCA MAGALI DAVILA MARQUEZ', 1, 1, 1, 1, '2023-07-03 10:23:24', 'blancadavila3@gmail.com', '0414-2459226', '$2y$12$FglCgUOU5l.ocyaer2XwauqRld0DibjApX0MRv4k8KzvA8k8ICaVu', 'a3806c3df73fd0b7c79dc13f89f5f0b6', '$2y$12$SdpIW7gdatyHa0Lk9EI.5u0eKXr.F/jtZZ4q5RNorkZpvmIxTTw06', '723496d106398d5d3ae8183c9b708b31', '2023-07-03', 4, NULL, NULL, 0.00),
(121, '288 NORY EUSEBIA DAVILA MONCADA', 1, 1, 1, 1, '2023-07-07 10:11:49', 'nory_davila@hotmail.com', '0414-6126186', '$2y$12$D63OlBVFBIobOfQgvNAJhekFIPEk9.9DgYZmfjtQZfy5H9JXGxXbO', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(122, '289 JUAN CARLOS SALVATIERRA BERROTERAN', 1, 1, 1, 1, '2023-07-13 13:42:49', 'jcarlossalvatierra22@gmail.com', '0424-2316871', '$2y$12$qACrCXgnOa2BCtuFvC3dn.xmT7D5X.Vo/iCyLSbjwsYk7ZHuVhWIq', '8a26e0747c094418e44eb5b26b208ec3', '$2y$12$gJY0OR8eZFZ3WHZhsBt.1eMZXcAZQySlBhNj2YwVOB4bRN8a/J9.a', '6abbeaf4b6b6cff776e2a2f70dc98326', '2023-07-28', 4, NULL, NULL, 0.00),
(123, '70040 JUAN EDUARDO MONTES DE OCA OMAÑA', 1, 1, 1, 1, '2023-07-13 13:44:52', 'jmontes1aseca@gmail.com', '0424-6070401', '$2y$12$kayx9S80fSQDzknTI2nnVeqxCp9p5hXEauHawfN/5kP7lzYSsmlHm', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(124, '40054 EDITO BETANCOURT PEREZ', 1, 1, 1, 1, '2023-07-13 16:14:41', 'editoseguros@gmail.com', '0414-5017370', '$2y$12$f8t4u4ZzN4DtPsT.Cwy6wucaDVcE3GRHe1A2FUxS1gP5krHQeLzfe', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(125, '290 CARLOS MARCIAL CAMEJO DE LIMA', 1, 1, 1, 1, '2023-07-18 09:49:53', 'carlosxuc687@gmail.com', '414-4490354', '$2y$12$/O9sPeUD3VNQnFW3VcXLrOcbEhaS7ycuxP22hP/79KwHTanrMpO9a', '0f04b4578dad26deb39cb7206322a184', '$2y$12$L5ekbv162J5fI5jrSKCC3.iu/ujl1Uio0BgoVnwvHpYjqmmADuRSS', 'fe47f65c39bdd4e27fb992ebe4ca5112', '2023-08-08', 4, NULL, NULL, 0.00),
(126, '291- GLAYMAR BEATRIZ MEDINA RIVERO', 1, 1, 1, 1, '2023-07-18 10:09:56', 'glaymarmedina@gmail.com', '0412-6877939', '$2y$12$Oj6oAYALo9vOUJS8RBwmOufUbDxASGW0c8ydkTS.wWBhwHchfG7gm', 'd33dff94f6061ba7faf7fe8fd0c86a89', '$2y$12$GivBJnXcHLicXvnaliv4PeNQk20Yz2JlPqU6Hx1JGqIgkLhu0ve72', '80fbe2728de502a720021baa3604c8e9', '2023-08-16', 4, NULL, NULL, 0.00),
(127, '292-VENICIA DORELYS ATACHO VELAZCO', 1, 1, 1, 1, '2023-07-18 13:55:07', 'veniciaatacho@gmail.com', '0424-4117910', '$2y$12$g0jwUcwRm7cNrvJ3W7eEyOSFGlw1ABpR1ehkrJuWGw35kg1UYiCWa', 'e88d9ac6ac8c70f251d168621af600b1', '$2y$12$LZuSUOBrmeOrUa2A71afLONNbyO6jnI86DwGyqs9PVGxZcOZRwzI6', 'bd30d0cf33ddfb3ca0ca2bb71b5531ee', '2023-07-18', 4, NULL, NULL, 0.00),
(128, '294- SIMON FELIX ANGARITA SIVIRA', 1, 1, 1, 1, '2023-07-19 09:08:38', 'simon.angarita@gmail.com', '424-8072307', '$2y$12$h1CEhBrqL6tlGNf/e0a3ROLkVkTecFJYDBe4w3xl4d3oVbyXthviq', 'bd408c1aca72f90dfc71c4b1298fa2b8', '$2y$12$2AhpcSlAVz6DSsvR7TFe9uILxoEHyIJHO6zNQv/9mht.YiH3gJUjy', 'd710f9cda0c8cb41fedf2637cf1d4120', '2023-07-19', 4, NULL, NULL, 0.00),
(129, '293- LUCIO SIMON RODRIGUEZ BENITEZ', 1, 1, 1, 1, '2023-07-25 10:51:34', 'luciosimonrodriguez4@gmail.com', '0414-4903430', '$2y$12$Yz.DnW5ALLEqMSUvZ4Povud82jX2IefDmNtM2Qd8vuoPxkd6bBJGG', 'a56cd007a713795740a3f0b770fed2d3', '$2y$12$K02DQRGh1o07igx4Jg8TPOa/DiSWCmlqjKpFq/ZTlQj5HaikqdjYC', '2c613b37cf340bd4faf3399f71f7bcfc', '2023-08-14', 4, NULL, NULL, 0.00),
(130, 'JORGE  CHAGUAS', 2, 8, 1, 8, '2023-07-20 16:08:02', 'jchagua@gmail.com', '4126216012', '$2y$12$SnsW81q7NJZS0f02zw50q.6J4508bMFQeuCsTRWRztnFInAEL7kk6', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00),
(131, '295-JORGE CARMELO THOMAS MUÑOZ', 1, 1, 1, 1, '2023-07-21 09:16:23', 'jorgethomas612@gmail.com', '0412-5288366', '$2y$12$mlS.QC58RdcB803xsLvR6.LeoU0pHanqIGMaOBScQwqJC7ZRAX08m', '503752a8cfce060f37a764feb52c5f60', '$2y$12$tlfsZ8CBabtK3GE/KbQtAeKj/3O9Mch7WZh/IWddt7WQm01tAmIei', 'a3068a020b75a94239dc5314d4d1833e', '2023-07-21', 4, NULL, NULL, 0.00),
(132, '296 NESTOR ANDRES RIVAS RIVERO', 1, 1, 1, 1, '2023-07-21 09:20:42', 'corredordeseguros2023@gmail.com', '0414-6989929', '$2y$12$FUKT0d/zBlbGLo10uN0ZpudqaZCmnf8zohGWKuasQ1gil2HVHiTcm', 'e88c49f7674eb37c82802bb900a91a3b', '$2y$12$PZveqnZUWBhUbfKV93uD6.gI.PVOnEzvnmJuyXkw3HllSzRq12zHG', '10aafb1360c88596e60d144bc05209ed', '2023-08-10', 4, NULL, NULL, 0.00),
(133, '60079 GUILLERMO SAAVEDRA SALCEDO', 1, 1, 1, 1, '2023-07-21 11:52:35', 'saasagui@gmail.com', '0414-9124320', '$2y$12$VH8.93/8qLVIIfPhuSws1eDvQ2RG44xqHngVqeitJNlUqynSFOM8O', '389ca6c31637842451ea12ab21ec1909', '$2y$12$iTy72To6GhQNAH6AwZHkhOj4s2eVAqUDK92/eOGUytB9DC1Vh1id.', '7b1bc20625193ab49ce0e19eaf0f00b8', '2023-08-15', 4, NULL, NULL, 0.00),
(134, '20042 SANDRA EMPERATRIZ DAVILA ARAUJO', 1, 1, 1, 1, '2023-07-25 13:40:42', 'sandradavila_01@hotmail.com', '0414-6613379', '$2y$12$IrRdvGeN424j51gIj6.JZeo2D/8QiDaHUBLn2kJ0iMbnfITM9z.XG', 'a1b839e07d63ed4a035aa6f50d1a4b6b', '$2y$12$VXDw19Gdv6A4MHHS12wwHu883GA1bY1NAKNfsSjlvS4u9plJOrhrC', '27a30b6fe2b920b2edd9a44c73908168', '2023-07-25', 4, NULL, NULL, 0.00),
(135, '299 CARLOS JUNIOR SCOTT GUTIERREZ', 1, 1, 1, 1, '2023-07-31 15:30:51', 'scottcorretajedeseguros@gmail.com', '0424-2056777', '$2y$12$GrlEGz8enQJYOkxXIqNMneZ756ELlbbke4obi.s.AfT6pL0FZGs4m', 'fd1ff5c5a4a60036399209c76353a9d3', '$2y$12$HTo00Vqzt9/hkGD78uPq9e4JYkLOM0yZxojuZlDswKOEIbJZ.Ncuq', 'e388e5a94fbd36ab65c24a4e24c86f19', '2023-07-31', 4, NULL, NULL, 0.00),
(136, '963 ALEXIS RAMON QUINTERO CARMONA', 1, 1, 1, 1, '2023-07-31 15:34:39', 'vc2andrade@gmail.com', '0424-7106222', '$2y$12$GnRxa3Dg7AQPs/Vxqgin3O5X8OqUqfEx.wtFJBG1UoNwC/MFhZkDu', '702f9649eba74f10ee87ab11ab6d95a4', '$2y$12$DpXdb2sTWSq.io1fYXFY7ufh4j.zVaDyreQnMXKJ/8QuScecej3Qy', '02d70368793ae15fac0933bcd5c449ff', '2023-07-31', 4, NULL, NULL, 0.00),
(137, '298  JAVIER MENDEZ GONZALEZ', 1, 1, 1, 1, '2023-08-01 08:43:56', 'javiermendezseguros@hotmail.com', '0414-4406465', '$2y$12$4.FFtuu6bOHcQeBeApbP7.y5WV0rWwCz7t5nG7PP3lK8A5Q/PIf1W', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(138, '301 CHARLIE MANUEL CORREA TOVAR', 1, 1, 1, 1, '2023-08-01 16:11:49', 'ccorrea.mt@gmail.com', '0414-3705116', '$2y$12$rfBdDyQ0AjJH6mksyocE..J8SJPAqVvgNMci2TFLbWp/WyOin6Zy6', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(139, '300 FELIX RAFAEL LEAL TEJERA', 1, 1, 1, 1, '2023-08-02 11:01:55', 'felixlealt@gmail.com', '0414-3248008', '$2y$12$vnfjps57E9c4d9IZ9Wbky.aBtXTGE.qc0ry9zMMcAJvntcWQTIE1.', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(140, '302 RAFAEL ORANGEL OLIVERO MARTINEZ', 1, 1, 1, 1, '2023-08-02 11:03:45', 'tuasesorpuntual@gmail.com', '04141961642', '$2y$12$lCh/.Nhhf3nfSjFMsYnka.Oe6ghupNVsGGxo.uZhNtz/Mbp9FGf9q', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(141, '303  VICTOR MANUEL DELGADO BAUTA', 1, 1, 1, 1, '2023-08-03 14:10:03', 'vdasesores@gmail.com', '0414-4389632', '$2y$12$jxMl3vdA7WbZK0v3XU4I3upWPVOg6pvK03tWU6drS156LgAx6UVtK', 'aeadb4561e99ccec807a966dc960b282', '$2y$12$mODjMZ.mP1THm6BDJr6NL.lyIelqkHL8NUZtEQK1cpKiLH9r2lo5q', 'a6c78da181f0c8d1be023c270710042e', '2023-08-10', 4, NULL, NULL, 0.00),
(142, 'RED COLMENA MC', 2, 8, 1, 8, '2023-08-04 16:17:47', 'me80castillo@gmail.com', '04141327678', '$2y$12$kdAChBESqZgmM0IRAXkDg.WEQagS8xLi3ABvNx.fcmPquq1Cqdmda', NULL, NULL, NULL, NULL, 5, NULL, NULL, 0.00),
(143, '304 CARLOS MIGUEL CONDE HERNANDEZ', 1, 1, 1, 1, '2023-08-07 14:06:04', 'miguelconde45@gmail.com', '0414-3937247', '$2y$12$27vY3lFe2oBgkht3B3PcEOfalpFpFYMEa.u5qbn7Rhc.gOeLwIKiW', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(144, '297 SIMON ALBERTO STELLA MIRABAL', 1, 1, 1, 1, '2023-08-07 14:08:51', 'simonalbertostella@gmail.com', '0414-9009543', '$2y$12$khEddYTbujKvZRG3lIHSB.WBfq5R/kCPMMg4SzJd1VELLnNHXim5y', 'baa12febaf0ee95d15eb798f956e9ccc', '$2y$12$LTOvUD69mLeZdm2km7sxG.eylfoI4z1HwTEWpSG/KGNt/0zjQC8Sm', '9ad4179a1285800c2b5e7c6091bf28b1', '2023-08-12', 4, NULL, NULL, 0.00),
(145, '306 YUSTY YONIRAY GIL CURA', 1, 1, 1, 1, '2023-08-10 10:08:42', 'yustygil.se22@gmail.com', '04143037291', '$2y$12$sRvidhCLCYOrDAtjYSBIreBQyVCYWZpLryfcW1eA2osFSKejnmDVq', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(146, '307- CORRETAJE DE SEGUROS TECSEVEN C.A', 1, 1, 1, 1, '2023-08-10 15:12:02', 'administracion@tecsevensc.com', '04122369407', '$2y$12$xd8L4c8PIMTOovxIKSic6ugUmpQXodVPA7YrujiatzHaCv/4uf0ea', '3d16b4a5ef55cc62d8c672d7cfce6599', '$2y$12$5rvK42VzEQtbDdPM36GwnODCk.Q7KDtqcW3p8O1CxAba2EUconNc2', '8f957b2b748c9bb2b753900c84c50735', '2023-08-10', 4, NULL, NULL, 0.00),
(147, '308 WLADIMIR ALBERTO AZUAJE RAMIREZ', 1, 1, 1, 1, '2023-08-10 15:41:48', 'decanasesores@gmail.com', '0424-2164040', '$2y$12$6vDLVUEnXmWEcPD2yPow0egO2YOhToP5IsO/T6bf6rWC1HVJoj9y2', NULL, NULL, NULL, NULL, 4, NULL, NULL, 0.00),
(148, '309 WILLIAM ENRIQUE LUGO VELASCO', 1, 1, 1, 1, '2023-08-11 08:29:09', 'suscripcion.wlvseguro@gmail.com', '0414-6998370', '$2y$12$2z5tM9AuVQDKeAqwA4vnQuDas5QZyvLRLmLHMmFbICt9m.ryt6dJO', '2bd17b4c0d82aed832e781ebf41204b5', '$2y$12$i.TdA6HpwJ8fZYgzwvKGzeVV2MTVdh8wuZHqr0IVW7ZcVW5KCcGuO', 'de5878d0baa8c9b6dee375dbf3c33533', '2023-08-11', 4, NULL, NULL, 0.00),
(149, '310 ELIA ISABEL URBANI GONZALEZ', 1, 1, 1, 1, '2023-08-14 14:11:50', 'eliangelurbani@hotmail.com', '0414-0101307', '$2y$12$iq06y5FyWuv5yVFNyEVJxuQZo4G8jasJCftYWQvp7zONYkP4FGty2', '91852d9106d92c86a866c7829fe3674e', '$2y$12$9NOluaSaGJgisfXkphneHuh2te1GMIRL.xuQ26c0g5c/Z8gUc.t.u', 'c100e08c92c7fcd2182b953f0430cbfa', '2023-08-14', 4, NULL, NULL, 0.00),
(150, '311 ALBERTO CABRERA HERNANDEZ', 1, 1, 1, 1, '2023-08-14 15:18:49', 'mundoseguros.prima@gmail.com', '0414-1603171', '$2y$12$pixXWiSvXyRsPw3gTG18lu6NQWxQ96eS4xwsSvrWpaZxbm3jaj./e', '59636ee37c2fe4672eb8856a1dea76a4', '$2y$12$XEztkabxr0YE05IQYi/XWOXEq2LhfFdJkEy.sO0OnHGVhDTwzd0Re', '93f1ce7ad6528c350cb40f11cc4c0086', '2023-08-15', 4, NULL, NULL, 0.00),
(151, '313 NEIDA YOLIMAR GUEVARA SEQUERA', 1, 1, 1, 1, '2023-08-14 15:43:27', 'ngasesordeseguros@gmail.com', '0424-1084040', '$2y$12$7vvtdwL1NgcgMTfAN.sk4eIQDUPL5iciASZDG/g3TepISxHn6mO1W', 'a4f6b9b3b04b47993aa2617996b7648f', '$2y$12$T5ENyq8q.xAMwCbK7EHrIOF2i43sa6A6WzUH34xBSIfXt7U1TrH/m', '9a05d1134232462be4bcdf8bdd7ceb7d', '2023-08-14', 4, NULL, NULL, 0.00),
(152, 'CC USUARIO1', 2, 99, 1, 99, '2023-08-15 16:12:04', 'ccusuario1@lamundialdeseguros.com', '02127726762', '$2y$12$GTc8mS1CJ5iMdeq3HUbp7e5d89E.FzRdw3QfoNv0KI2kqzV1ppAgS', '41fcd2ef8daef3befa88f2ad78344832', '$2y$12$T0yLuSNw.hOU3gIhNuWhYO0tEXMD644vUjncKOFxuCUTbbbkGCqUW', '4d47707fcec109a3e898b624867ff951', '2023-08-17', 5, NULL, NULL, 0.00);

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

--
-- 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
(1, 3, 35.00),
(1, 4, 37.00),
(1, 5, 30.00),
(1, 6, 45.00),
(1, 7, 26.00),
(1, 8, 46.00),
(1, 9, 32.00),
(1, 10, 32.00),
(1, 11, 41.00),
(1, 12, 31.00),
(1, 13, 23.00),
(1, 14, 23.00),
(1, 15, 31.00),
(2, 3, 30.00),
(2, 4, 35.00),
(2, 5, 25.00),
(2, 6, 38.00),
(2, 7, 25.00),
(2, 8, 25.00),
(2, 9, 30.00),
(2, 10, 30.00),
(2, 11, 40.00),
(2, 13, 22.00),
(2, 14, 22.00),
(2, 15, 30.00),
(3, 3, 25.00),
(3, 4, 30.00),
(3, 5, 25.00),
(3, 6, 33.00),
(3, 7, 25.00),
(3, 8, 25.00),
(3, 9, 30.00),
(3, 10, 30.00),
(3, 11, 40.00),
(3, 13, 22.00),
(3, 14, 22.00),
(3, 15, 30.00),
(4, 3, 30.00),
(4, 5, 25.00),
(4, 10, 30.00),
(4, 13, 22.00),
(4, 14, 22.00),
(4, 15, 30.00),
(5, 3, 30.00),
(5, 5, 25.00),
(5, 6, 40.00),
(5, 10, 30.00),
(5, 13, 22.00),
(5, 14, 22.00),
(5, 15, 30.00),
(6, 3, 30.00),
(6, 5, 25.00),
(6, 10, 30.00),
(6, 13, 22.00),
(6, 14, 22.00),
(6, 15, 30.00),
(7, 3, 30.00),
(7, 5, 25.00),
(7, 10, 30.00),
(7, 13, 22.00),
(7, 14, 22.00),
(7, 15, 30.00),
(8, 3, 30.00),
(8, 5, 25.00),
(8, 10, 25.00),
(8, 13, 15.00),
(8, 14, 15.00),
(8, 15, 10.00),
(9, 3, 30.00),
(9, 5, 25.00),
(9, 6, 40.00),
(9, 9, 30.00),
(9, 10, 30.00),
(9, 13, 22.00),
(9, 14, 22.00),
(9, 15, 30.00),
(10, 3, 1.00),
(10, 5, 25.00),
(10, 9, 1.00),
(10, 10, 1.00),
(10, 13, 1.00),
(10, 14, 1.00),
(10, 15, 10.00),
(11, 3, 30.00),
(11, 5, 25.00),
(11, 10, 25.00),
(11, 13, 15.00),
(11, 14, 15.00),
(11, 15, 10.00),
(12, 3, 21.00),
(12, 5, 17.50),
(12, 10, 17.50),
(12, 13, 10.50),
(12, 14, 10.50),
(12, 15, 7.00),
(13, 3, 18.00),
(13, 5, 15.00),
(13, 10, 15.00),
(13, 13, 9.00),
(13, 14, 9.00),
(13, 15, 6.00),
(14, 3, 18.00),
(14, 5, 15.00),
(14, 10, 15.00),
(14, 13, 9.00),
(14, 14, 9.00),
(14, 15, 6.00),
(15, 5, 25.00),
(15, 10, 25.00),
(15, 13, 15.00),
(15, 14, 15.00),
(15, 15, 10.00),
(1, 16, 32.00),
(1, 17, 32.00),
(16, 3, 30.00),
(16, 5, 25.00),
(16, 10, 25.00),
(16, 13, 15.00),
(16, 14, 15.00),
(16, 15, 10.00),
(17, 3, 30.00),
(17, 5, 25.00),
(17, 10, 25.00),
(17, 13, 15.00),
(17, 14, 15.00),
(17, 15, 10.00),
(18, 3, 30.00),
(18, 5, 25.00),
(18, 10, 25.00),
(18, 13, 15.00),
(18, 14, 15.00),
(18, 15, 10.00),
(19, 3, 18.00),
(19, 5, 15.00),
(19, 10, 15.00),
(19, 13, 9.00),
(19, 14, 9.00),
(19, 15, 6.00),
(21, 3, 30.00),
(21, 5, 25.00),
(21, 10, 25.00),
(21, 13, 15.00),
(21, 14, 15.00),
(21, 15, 10.00),
(22, 3, 18.00),
(22, 5, 15.00),
(22, 10, 15.00),
(22, 13, 9.00),
(22, 14, 9.00),
(22, 15, 6.00),
(23, 3, 30.00),
(23, 5, 25.00),
(23, 10, 25.00),
(23, 13, 15.00),
(23, 14, 15.00),
(23, 15, 10.00),
(24, 3, 30.00),
(24, 5, 25.00),
(24, 10, 25.00),
(24, 13, 15.00),
(24, 14, 15.00),
(24, 15, 10.00),
(25, 3, 30.00),
(25, 5, 25.00),
(25, 10, 25.00),
(25, 13, 15.00),
(25, 14, 15.00),
(25, 15, 10.00),
(26, 3, 30.00),
(26, 5, 25.00),
(26, 10, 25.00),
(26, 13, 15.00),
(26, 14, 15.00),
(26, 15, 10.00),
(28, 3, 30.00),
(28, 5, 25.00),
(28, 10, 25.00),
(28, 13, 15.00),
(28, 14, 15.00),
(28, 15, 10.00),
(29, 3, 30.00),
(29, 5, 25.00),
(29, 10, 25.00),
(29, 13, 15.00),
(29, 14, 15.00),
(29, 15, 10.00),
(30, 3, 30.00),
(30, 5, 25.00),
(30, 10, 25.00),
(30, 13, 15.00),
(30, 14, 15.00),
(30, 15, 10.00),
(31, 3, 30.00),
(31, 5, 25.00),
(31, 10, 25.00),
(31, 13, 15.00),
(31, 14, 15.00),
(31, 15, 10.00),
(32, 3, 30.00),
(32, 5, 25.00),
(32, 10, 25.00),
(32, 13, 15.00),
(32, 14, 15.00),
(32, 15, 10.00),
(33, 3, 30.00),
(33, 5, 25.00),
(33, 10, 25.00),
(33, 13, 15.00),
(33, 14, 15.00),
(33, 15, 10.00),
(34, 3, 30.00),
(34, 5, 25.00),
(34, 10, 25.00),
(34, 13, 15.00),
(34, 14, 15.00),
(34, 15, 10.00),
(35, 3, 30.00),
(35, 5, 25.00),
(35, 10, 25.00),
(35, 13, 15.00),
(35, 14, 15.00),
(35, 15, 10.00),
(36, 3, 30.00),
(36, 5, 25.00),
(36, 10, 25.00),
(36, 13, 15.00),
(36, 14, 15.00),
(36, 15, 10.00),
(37, 3, 30.00),
(37, 5, 25.00),
(37, 10, 25.00),
(37, 13, 15.00),
(37, 14, 15.00),
(37, 15, 10.00),
(38, 3, 30.00),
(38, 5, 25.00),
(38, 10, 25.00),
(38, 13, 15.00),
(38, 14, 15.00),
(38, 15, 10.00),
(39, 3, 30.00),
(39, 5, 25.00),
(39, 10, 25.00),
(39, 13, 15.00),
(39, 14, 15.00),
(39, 15, 10.00),
(40, 3, 30.00),
(40, 5, 25.00),
(40, 10, 25.00),
(40, 13, 15.00),
(40, 14, 15.00),
(40, 15, 10.00),
(41, 3, 30.00),
(41, 5, 25.00),
(41, 10, 25.00),
(41, 13, 15.00),
(41, 14, 15.00),
(41, 15, 10.00),
(42, 3, 30.00),
(42, 5, 25.00),
(42, 10, 25.00),
(42, 13, 15.00),
(42, 14, 15.00),
(42, 15, 10.00),
(43, 3, 30.00),
(43, 5, 25.00),
(43, 10, 25.00),
(43, 13, 15.00),
(43, 14, 15.00),
(43, 15, 10.00),
(44, 3, 30.00),
(44, 5, 25.00),
(44, 10, 25.00),
(44, 13, 15.00),
(44, 14, 15.00),
(44, 15, 10.00),
(45, 3, 30.00),
(45, 5, 25.00),
(45, 10, 25.00),
(45, 13, 15.00),
(45, 14, 15.00),
(45, 15, 10.00),
(46, 3, 30.00),
(46, 5, 25.00),
(46, 10, 25.00),
(46, 13, 15.00),
(46, 14, 15.00),
(46, 15, 10.00),
(47, 3, 30.00),
(47, 5, 25.00),
(47, 10, 25.00),
(47, 13, 15.00),
(47, 14, 15.00),
(47, 15, 10.00),
(48, 3, 30.00),
(48, 5, 25.00),
(48, 10, 25.00),
(48, 13, 15.00),
(48, 14, 15.00),
(48, 15, 10.00),
(49, 3, 30.00),
(49, 5, 25.00),
(49, 10, 25.00),
(49, 13, 15.00),
(49, 14, 15.00),
(49, 15, 10.00),
(50, 3, 30.00),
(50, 5, 25.00),
(50, 10, 25.00),
(50, 13, 15.00),
(50, 14, 15.00),
(50, 15, 10.00),
(51, 3, 30.00),
(51, 5, 25.00),
(51, 10, 25.00),
(51, 13, 15.00),
(51, 14, 15.00),
(51, 15, 10.00),
(52, 3, 30.00),
(52, 5, 25.00),
(52, 10, 25.00),
(52, 13, 15.00),
(52, 14, 15.00),
(52, 15, 10.00),
(53, 3, 30.00),
(53, 5, 25.00),
(53, 10, 25.00),
(53, 13, 15.00),
(53, 14, 15.00),
(53, 15, 10.00),
(54, 3, 30.00),
(54, 5, 25.00),
(54, 10, 25.00),
(54, 13, 15.00),
(54, 14, 15.00),
(54, 15, 10.00),
(55, 3, 30.00),
(55, 5, 25.00),
(55, 10, 25.00),
(55, 13, 15.00),
(55, 14, 15.00),
(55, 15, 10.00),
(56, 3, 30.00),
(56, 5, 25.00),
(56, 10, 25.00),
(56, 13, 15.00),
(56, 14, 15.00),
(56, 15, 10.00),
(57, 3, 30.00),
(57, 5, 25.00),
(57, 10, 25.00),
(57, 13, 15.00),
(57, 14, 15.00),
(57, 15, 10.00),
(58, 3, 30.00),
(58, 5, 25.00),
(58, 10, 25.00),
(58, 13, 15.00),
(58, 14, 15.00),
(58, 15, 10.00),
(59, 3, 30.00),
(59, 5, 25.00),
(59, 10, 25.00),
(59, 13, 15.00),
(59, 14, 15.00),
(59, 15, 10.00),
(60, 3, 30.00),
(60, 5, 25.00),
(60, 10, 25.00),
(60, 13, 15.00),
(60, 14, 15.00),
(60, 15, 10.00),
(61, 3, 30.00),
(61, 5, 25.00),
(61, 10, 25.00),
(61, 13, 15.00),
(61, 14, 15.00),
(61, 15, 10.00),
(62, 3, 30.00),
(62, 5, 25.00),
(62, 10, 25.00),
(62, 13, 15.00),
(62, 14, 15.00),
(62, 15, 10.00),
(63, 3, 30.00),
(63, 5, 25.00),
(63, 10, 25.00),
(63, 13, 15.00),
(63, 14, 15.00),
(63, 15, 10.00),
(64, 3, 30.00),
(64, 5, 25.00),
(64, 10, 25.00),
(64, 13, 15.00),
(64, 14, 15.00),
(64, 15, 10.00),
(65, 3, 30.00),
(65, 5, 25.00),
(65, 10, 25.00),
(65, 13, 15.00),
(65, 14, 15.00),
(65, 15, 10.00),
(66, 3, 30.00),
(66, 5, 25.00),
(66, 10, 25.00),
(66, 13, 15.00),
(66, 14, 15.00),
(66, 15, 10.00),
(67, 3, 30.00),
(67, 5, 25.00),
(67, 10, 25.00),
(67, 13, 15.00),
(67, 14, 15.00),
(67, 15, 10.00),
(68, 3, 30.00),
(68, 5, 25.00),
(68, 10, 25.00),
(68, 13, 15.00),
(68, 14, 15.00),
(68, 15, 10.00),
(69, 3, 30.00),
(69, 5, 25.00),
(69, 10, 25.00),
(69, 13, 15.00),
(69, 14, 15.00),
(69, 15, 10.00),
(70, 3, 30.00),
(70, 5, 25.00),
(70, 10, 25.00),
(70, 13, 15.00),
(70, 14, 15.00),
(70, 15, 10.00),
(71, 3, 30.00),
(71, 5, 25.00),
(71, 10, 25.00),
(71, 13, 15.00),
(71, 14, 15.00),
(71, 15, 10.00),
(72, 3, 30.00),
(72, 5, 25.00),
(72, 10, 25.00),
(72, 13, 15.00),
(72, 14, 15.00),
(72, 15, 10.00),
(73, 3, 30.00),
(73, 5, 25.00),
(73, 10, 25.00),
(73, 13, 15.00),
(73, 14, 15.00),
(73, 15, 10.00),
(74, 3, 30.00),
(74, 5, 25.00),
(74, 10, 25.00),
(74, 13, 15.00),
(74, 14, 15.00),
(74, 15, 10.00),
(75, 3, 30.00),
(75, 5, 25.00),
(75, 10, 25.00),
(75, 13, 15.00),
(75, 14, 15.00),
(75, 15, 10.00),
(76, 3, 30.00),
(76, 5, 25.00),
(76, 10, 25.00),
(76, 13, 15.00),
(76, 14, 15.00),
(76, 15, 10.00),
(77, 3, 30.00),
(77, 5, 25.00),
(77, 10, 25.00),
(77, 13, 15.00),
(77, 14, 15.00),
(77, 15, 10.00),
(78, 3, 30.00),
(78, 5, 25.00),
(78, 10, 25.00),
(78, 13, 15.00),
(78, 14, 15.00),
(78, 15, 10.00),
(79, 3, 30.00),
(79, 5, 25.00),
(79, 10, 25.00),
(79, 13, 15.00),
(79, 14, 15.00),
(79, 15, 10.00),
(80, 3, 30.00),
(80, 5, 25.00),
(80, 10, 25.00),
(80, 13, 15.00),
(80, 14, 15.00),
(81, 3, 30.00),
(81, 5, 25.00),
(81, 10, 25.00),
(81, 13, 15.00),
(81, 14, 15.00),
(81, 15, 10.00),
(82, 3, 30.00),
(82, 5, 25.00),
(82, 10, 25.00),
(82, 13, 15.00),
(82, 14, 15.00),
(82, 15, 10.00),
(83, 3, 30.00),
(83, 5, 25.00),
(83, 10, 25.00),
(83, 13, 15.00),
(83, 14, 15.00),
(83, 15, 10.00),
(84, 3, 30.00),
(84, 5, 25.00),
(84, 10, 25.00),
(84, 13, 15.00),
(84, 14, 15.00),
(84, 15, 10.00),
(85, 3, 30.00),
(85, 5, 25.00),
(85, 10, 25.00),
(85, 13, 15.00),
(85, 14, 15.00),
(85, 15, 10.00),
(86, 3, 30.00),
(86, 5, 25.00),
(86, 10, 25.00),
(86, 13, 15.00),
(86, 14, 15.00),
(86, 15, 10.00),
(87, 3, 30.00),
(87, 5, 25.00),
(87, 10, 25.00),
(87, 13, 15.00),
(87, 14, 15.00),
(87, 15, 10.00),
(88, 3, 30.00),
(88, 5, 25.00),
(88, 10, 25.00),
(88, 13, 15.00),
(88, 14, 15.00),
(88, 15, 10.00),
(89, 3, 30.00),
(89, 5, 25.00),
(89, 10, 25.00),
(89, 13, 15.00),
(89, 14, 15.00),
(89, 15, 10.00),
(90, 3, 30.00),
(90, 5, 25.00),
(90, 10, 25.00),
(90, 13, 15.00),
(90, 14, 15.00),
(90, 15, 10.00),
(91, 3, 30.00),
(91, 5, 25.00),
(91, 10, 25.00),
(91, 13, 15.00),
(91, 14, 15.00),
(91, 15, 10.00),
(92, 3, 30.00),
(92, 5, 25.00),
(92, 10, 25.00),
(92, 13, 15.00),
(92, 14, 15.00),
(92, 15, 10.00),
(93, 3, 1.00),
(93, 5, 1.00),
(93, 10, 1.00),
(93, 13, 1.00),
(93, 14, 1.00),
(93, 15, 1.00),
(94, 3, 30.00),
(94, 5, 25.00),
(94, 10, 25.00),
(94, 13, 15.00),
(94, 14, 15.00),
(94, 15, 10.00),
(95, 3, 30.00),
(95, 5, 25.00),
(95, 10, 25.00),
(95, 13, 15.00),
(95, 14, 15.00),
(95, 15, 10.00),
(96, 3, 30.00),
(96, 5, 25.00),
(96, 10, 25.00),
(96, 13, 15.00),
(96, 14, 15.00),
(96, 15, 10.00),
(97, 3, 30.00),
(97, 5, 25.00),
(97, 10, 25.00),
(97, 13, 15.00),
(97, 14, 15.00),
(97, 15, 10.00),
(98, 3, 30.00),
(98, 5, 25.00),
(98, 10, 25.00),
(98, 13, 15.00),
(98, 14, 15.00),
(98, 15, 10.00),
(99, 3, 30.00),
(99, 5, 25.00),
(99, 10, 25.00),
(99, 13, 15.00),
(99, 14, 15.00),
(100, 3, 30.00),
(100, 5, 25.00),
(100, 10, 25.00),
(100, 13, 15.00),
(100, 14, 15.00),
(100, 15, 10.00),
(101, 3, 30.00),
(101, 5, 25.00),
(101, 10, 25.00),
(101, 13, 15.00),
(101, 14, 15.00),
(101, 15, 10.00),
(102, 3, 30.00),
(102, 5, 25.00),
(102, 10, 25.00),
(102, 13, 15.00),
(102, 14, 15.00),
(102, 15, 10.00),
(103, 3, 30.00),
(103, 5, 25.00),
(103, 10, 25.00),
(103, 13, 15.00),
(103, 14, 15.00),
(103, 15, 10.00),
(104, 3, 30.00),
(104, 5, 25.00),
(104, 10, 25.00),
(104, 13, 15.00),
(104, 14, 15.00),
(104, 15, 10.00),
(105, 3, 30.00),
(105, 5, 25.00),
(105, 10, 25.00),
(105, 13, 15.00),
(105, 14, 15.00),
(105, 15, 10.00),
(1, 18, 35.00),
(1, 19, 35.00),
(1, 20, 35.00),
(106, 3, 30.00),
(106, 5, 25.00),
(106, 10, 25.00),
(106, 13, 15.00),
(106, 14, 15.00),
(106, 15, 10.00),
(107, 3, 30.00),
(107, 5, 25.00),
(107, 10, 25.00),
(107, 13, 15.00),
(107, 14, 15.00),
(107, 15, 10.00),
(108, 3, 30.00),
(108, 5, 25.00),
(108, 10, 25.00),
(108, 13, 15.00),
(108, 14, 15.00),
(108, 15, 10.00),
(109, 3, 30.00),
(109, 5, 25.00),
(109, 10, 25.00),
(109, 13, 15.00),
(109, 14, 15.00),
(109, 15, 10.00),
(110, 3, 30.00),
(110, 5, 25.00),
(110, 10, 25.00),
(110, 13, 15.00),
(110, 14, 15.00),
(110, 15, 10.00),
(111, 3, 30.00),
(111, 5, 25.00),
(111, 10, 25.00),
(111, 13, 15.00),
(111, 14, 15.00),
(111, 15, 10.00),
(112, 3, 30.00),
(112, 5, 25.00),
(112, 10, 25.00),
(112, 13, 15.00),
(112, 14, 15.00),
(112, 15, 10.00),
(113, 3, 30.00),
(113, 5, 25.00),
(113, 10, 25.00),
(113, 13, 15.00),
(113, 14, 15.00),
(113, 15, 10.00),
(114, 3, 30.00),
(114, 5, 25.00),
(114, 10, 25.00),
(114, 13, 15.00),
(114, 14, 15.00),
(114, 15, 10.00),
(115, 3, 30.00),
(115, 5, 25.00),
(115, 10, 25.00),
(115, 13, 15.00),
(115, 14, 15.00),
(115, 15, 10.00),
(1, 21, 16.00),
(116, 3, 30.00),
(116, 5, 25.00),
(116, 10, 25.00),
(116, 13, 15.00),
(116, 14, 15.00),
(116, 15, 10.00),
(1, 22, 27.00),
(1, 23, 17.00),
(117, 3, 30.00),
(117, 5, 25.00),
(117, 10, 25.00),
(117, 13, 15.00),
(117, 14, 15.00),
(117, 15, 10.00),
(1, 24, 27.00),
(118, 3, 30.00),
(118, 5, 25.00),
(118, 10, 25.00),
(118, 13, 15.00),
(118, 14, 15.00),
(118, 15, 10.00),
(119, 3, 30.00),
(119, 5, 25.00),
(119, 10, 25.00),
(119, 13, 15.00),
(119, 14, 15.00),
(119, 15, 10.00),
(120, 3, 30.00),
(120, 5, 25.00),
(120, 10, 25.00),
(120, 13, 15.00),
(120, 14, 15.00),
(120, 15, 10.00),
(121, 3, 30.00),
(121, 5, 25.00),
(121, 10, 25.00),
(121, 13, 15.00),
(121, 14, 15.00),
(121, 15, 10.00),
(122, 3, 30.00),
(122, 5, 25.00),
(122, 10, 25.00),
(122, 13, 15.00),
(122, 14, 15.00),
(122, 15, 10.00),
(123, 3, 30.00),
(123, 5, 25.00),
(123, 10, 25.00),
(123, 13, 15.00),
(123, 14, 15.00),
(123, 15, 10.00),
(124, 3, 30.00),
(124, 5, 25.00),
(124, 10, 25.00),
(124, 13, 15.00),
(124, 14, 15.00),
(124, 15, 10.00),
(125, 3, 30.00),
(125, 5, 25.00),
(125, 10, 25.00),
(125, 13, 15.00),
(125, 14, 15.00),
(125, 15, 10.00),
(126, 3, 30.00),
(126, 5, 25.00),
(126, 10, 25.00),
(126, 13, 15.00),
(126, 14, 15.00),
(126, 15, 10.00),
(80, 15, 10.00),
(127, 3, 30.00),
(127, 5, 25.00),
(127, 10, 25.00),
(127, 13, 15.00),
(127, 14, 15.00),
(127, 15, 10.00),
(128, 3, 30.00),
(128, 5, 25.00),
(128, 10, 25.00),
(128, 13, 15.00),
(128, 14, 15.00),
(128, 15, 10.00),
(129, 3, 30.00),
(129, 5, 25.00),
(129, 10, 25.00),
(129, 13, 15.00),
(129, 14, 15.00),
(129, 21, 10.00),
(130, 3, 30.00),
(130, 5, 25.00),
(130, 10, 25.00),
(130, 13, 15.00),
(130, 14, 15.00),
(130, 15, 10.00),
(131, 3, 30.00),
(131, 5, 25.00),
(131, 10, 25.00),
(131, 13, 15.00),
(131, 14, 15.00),
(131, 15, 10.00),
(132, 3, 30.00),
(132, 5, 10.00),
(132, 10, 25.00),
(132, 13, 15.00),
(132, 14, 15.00),
(132, 15, 10.00),
(133, 3, 30.00),
(133, 5, 25.00),
(133, 10, 25.00),
(133, 13, 15.00),
(133, 14, 15.00),
(133, 15, 10.00),
(129, 15, 10.00),
(134, 3, 30.00),
(134, 5, 25.00),
(134, 10, 25.00),
(134, 13, 15.00),
(134, 14, 15.00),
(134, 15, 10.00),
(134, 21, 10.00),
(135, 3, 30.00),
(135, 5, 25.00),
(135, 10, 25.00),
(135, 13, 15.00),
(135, 14, 15.00),
(135, 15, 10.00),
(135, 21, 10.00),
(136, 3, 30.00),
(136, 5, 25.00),
(136, 10, 25.00),
(136, 13, 15.00),
(136, 14, 15.00),
(136, 15, 10.00),
(136, 21, 10.00),
(137, 3, 30.00),
(137, 5, 25.00),
(137, 10, 25.00),
(137, 13, 15.00),
(137, 14, 15.00),
(137, 15, 10.00),
(137, 21, 10.00),
(138, 3, 30.00),
(138, 5, 25.00),
(138, 10, 25.00),
(138, 13, 15.00),
(138, 14, 15.00),
(138, 15, 10.00),
(138, 21, 10.00),
(139, 3, 30.00),
(139, 5, 25.00),
(139, 10, 25.00),
(139, 13, 15.00),
(139, 14, 15.00),
(139, 15, 10.00),
(139, 21, 10.00),
(140, 3, 30.00),
(140, 5, 25.00),
(140, 10, 25.00),
(140, 13, 15.00),
(140, 14, 15.00),
(140, 15, 10.00),
(140, 21, 10.00),
(141, 3, 30.00),
(141, 5, 25.00),
(141, 10, 25.00),
(141, 13, 15.00),
(141, 14, 15.00),
(141, 15, 10.00),
(141, 21, 10.00),
(8, 21, 10.00),
(10, 21, 10.00),
(142, 3, 1.00),
(142, 5, 25.00),
(142, 10, 1.00),
(142, 13, 1.00),
(142, 14, 1.00),
(142, 15, 10.00),
(142, 21, 10.00),
(143, 3, 30.00),
(143, 5, 25.00),
(143, 10, 25.00),
(143, 13, 15.00),
(143, 14, 15.00),
(143, 15, 10.00),
(143, 21, 10.00),
(144, 3, 30.00),
(144, 5, 25.00),
(144, 10, 25.00),
(144, 13, 15.00),
(144, 14, 15.00),
(144, 15, 10.00),
(144, 21, 10.00),
(99, 15, 10.00),
(99, 21, 10.00),
(145, 3, 30.00),
(145, 5, 25.00),
(145, 10, 25.00),
(145, 13, 15.00),
(145, 14, 15.00),
(145, 15, 10.00),
(145, 21, 10.00),
(146, 3, 30.00),
(146, 5, 25.00),
(146, 10, 25.00),
(146, 13, 15.00),
(146, 14, 15.00),
(146, 15, 10.00),
(146, 21, 10.00),
(147, 3, 30.00),
(147, 5, 25.00),
(147, 10, 25.00),
(147, 13, 15.00),
(147, 14, 15.00),
(147, 15, 10.00),
(147, 21, 10.00),
(148, 3, 30.00),
(148, 5, 25.00),
(148, 10, 25.00),
(148, 13, 15.00),
(148, 14, 15.00),
(148, 15, 10.00),
(148, 21, 10.00),
(1, 25, 26.00),
(149, 3, 30.00),
(149, 5, 25.00),
(149, 10, 25.00),
(149, 13, 15.00),
(149, 14, 15.00),
(149, 15, 10.00),
(149, 21, 10.00),
(150, 3, 30.00),
(150, 5, 25.00),
(150, 10, 25.00),
(150, 13, 15.00),
(150, 14, 15.00),
(150, 15, 10.00),
(150, 21, 10.00),
(151, 3, 30.00),
(151, 5, 25.00),
(151, 10, 25.00),
(151, 13, 15.00),
(151, 14, 15.00),
(151, 15, 10.00),
(151, 21, 10.00),
(152, 3, 1.00),
(152, 5, 1.00),
(152, 10, 1.00),
(152, 13, 1.00),
(152, 14, 1.00),
(152, 15, 10.00),
(152, 21, 10.00);

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

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

CREATE TABLE `agencies_ibo` (
  `id_agency_ibo` int(11) NOT NULL,
  `name_agency` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `token` text COLLATE utf8_unicode_ci NOT NULL,
  `token_encrypt` text COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(80) COLLATE utf8_unicode_ci 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
(7, 'Safeguard 1', 'BF2Odwp1HAeRqSm', 'WFhUVzI1MjNKbDQkWmxzQkZKV0IyRXY5SnVGQmRoMnRnRVhxQm5jUkR3K0loazFvR3VBPQ', 'Agency_ibo_7.png', 0, 1, '2022-10-28 01:11:13');

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

--
-- 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;

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

--
-- 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'),
(3, 0, 19, 1, 3, '2023-01-28 12:17:57'),
(4, 20, 65, 1, 3, '2023-01-30 10:15:24'),
(5, 66, 85, 1, 3, '2023-01-28 12:18:53');

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

--
-- Estructura de tabla para la tabla `api_clients`
--

CREATE TABLE `api_clients` (
  `id_authorization` int(11) NOT NULL,
  `name_client` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email_client` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `payment` int(11) NOT NULL,
  `identification` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` text COLLATE utf8_unicode_ci NOT NULL,
  `token_bee` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `password_test` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `token_bee_test` varchar(100) COLLATE utf8_unicode_ci DEFAULT 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 `api_clients`
--

INSERT INTO `api_clients` (`id_authorization`, `name_client`, `email_client`, `payment`, `identification`, `username`, `password`, `token_bee`, `password_test`, `token_bee_test`, `id_status`, `id_user`, `create_date`) VALUES
(1, 'Chinchin', 'agonzalez@pagochinchin.com', 2, '123456', 'chinchin', '$2y$12$.VBpEhu.SCUXV7hwK0pFLOFWi/MXGEPiyxmqYasCm.ytB25UkU24y', 'P97sXFifa85Eou*MNDR3', '$2y$12$HnnSDNWPWTJbx3reB23T2.ZHHnWSkvDSI3Da8BJ7I.GivErDiSPLS', 'fKkuPjtq26RJNBUceXZL', 1, 0, '2023-02-01 10:44:06'),
(3, 'Development Soft', 'diazbasket5@hotmail.com', 1, '12345678', 'developmentsoft', '$2y$12$aStfiiDBx4gsmvL4gjsSeeeKRjUA.qSL8VQMAzQm6dQCfnFkp6bdi', '9mVkHyRcF5oq3x2ZAjLf', '$2y$12$eHTFeEvmtf108sj8bxQoCeK0UM/D3M34mVOj2FodOftVGr1DpMCyG', '17jEruRo5gJzA9WSmIQ3', 1, 0, '2023-02-01 10:18:43'),
(4, 'Bancamiga inactivo', 'cvizcaya@gmail.com', 2, 'bancamigAPI', 'bancamigAPI', '$2y$12$PpR1a7NpcDMYopw7A5sKU.Wms.JcBaevGsFqpEYnsyB1NAQj.JiZC', 'IDr9Ah\r\ndWJBcempoRHT', '$2y$12$wgwocPK0GS1LGscyBBMATuEPpC6F8RgcyNpTkNXEuwlVzlLmhSPfm', 'vQad.23SfFWlqmVHX*hi', 2, 5, '2023-01-30 10:28:54'),
(5, 'Freddy Belisario', 'freddybelisario@gmail.com', 2, '55665221', 'Fbelisario', '$2y$12$mXTKA6MHd3tJ9rD5INk1C.EZVE0jHasxU8B/l6fQa2PmabVvzRkz.', '}nMuJ1QrWe#xCK	aS{t4', '$2y$12$LvgTQ2o1pdpEQ0orwKV4GO6pNj9djZ09uW9XjOphaJorp.ruvnWV6', 'pFbVxA+fLgUR35G42OtT', 1, 5, '2023-01-30 09:54:05'),
(6, 'Carlos López ', 'cvizcaya@sitca-ve.com', 1, '12456', 'BancaAmig', '$2y$12$JeDa27wNuwWf1sp4Mksoqe4iCRAVJhXnyRRlIZ5XgJdW2mDptl.XK', '2irIlB78x	hAmo#ftCvZ', '$2y$12$eMaTRTF.SRsyn8l0rgKteuV6oFhBsA0ng1oS4W7g0bdhgJb.erT1e', '36qfFsBKZJGxTgP7leyY', 1, 5, '2023-01-30 10:31:19'),
(7, 'Nélson Villasmil', 'mvillasmil@grupo-previsegura.com', 2, '9881692', 'PreviLife', '$2y$12$Gpdrm6NizN49n4o00pkKgOY62zteL/e2g4TffDHvvDXY/pdnrp4tS', 'OhX7i9uz0DqeNZ1L4Jl6', '$2y$12$djkmvb9zSvDwkbBRTIT74.dk1xGdU0R/iaZN4sZdonJ1EzHu1BTRi', 'DayPhfzO6ZNr.FEXI*2M', 2, 5, '2023-02-07 14:49:21'),
(8, 'Nelson Villasmil', 'npvillasmil@gmail.com', 2, '9881962', 'Previseg2', '$2y$12$HPGBYRdEbx95PnqzEeQiyutSGNEh1DxYa7LoB5LafHlCUSsbMufOC', '6AYUbj1tcTZ3mGC7zSNh', '$2y$12$Y2ILfkZxx7XzOpUBG17S3ubbdtM5KY8ZuPgnZxlTVVNrdIYac3buC', 'lV.krwX0cPaL3B4vEAhJ', 2, 5, '2023-02-09 08:42:05'),
(9, 'Rafael Guerrero', 'rafaelgchn@hotmail.com', 2, '12', 'Previseg3', '$2y$12$94/AQO8.EGx97UR/8eT32eXXHe6Sob5YQfV9dKjDb8lWHVfnNUKiC', 'o6wpsQ.f9l2Iqi*gvErX', '$2y$12$qWmManihFzQIBsquyTOqpuFTOfDw62vKzT0JtII4TbdkqZtJkrnNe', 'D2vZkF67z8NsYKVjp3xo', 1, 5, '2023-02-09 08:44:40'),
(10, 'nicolas', 'ideavalor@gmail.com', 1, '12323434', 'LoteGua', '$2y$12$Jzob2QhnQ.uooKBd8eZVIus.UE47fQf5p69l4CY693Tegjesuj3nW', 'STglopdI10xjHtaU6.yA', '$2y$12$VI/E.vZ1XR3CaTlPi85sle1cBaM7OWRzvAuS9AyuVeNZhEqUsgNxe', 'hbAo*SI7vHzuYW0lap4r', 1, 5, '2023-04-10 13:46:37');

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

--
-- Estructura de tabla para la tabla `api_products`
--

CREATE TABLE `api_products` (
  `id_authorization` int(11) NOT NULL,
  `id_insurance` int(11) NOT NULL,
  `commission` double(20,2) NOT NULL,
  `id_user` int(11) NOT NULL,
  `create_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `api_products` (`id_authorization`, `id_insurance`, `commission`, `id_user`, `create_date`) VALUES
(1, 5, 1.00, 3, '2023-01-27 09:59:25'),
(1, 9, 1.00, 3, '2023-01-27 09:59:25'),
(1, 10, 1.00, 3, '2023-01-27 09:59:25'),
(1, 11, 1.00, 3, '2023-01-27 09:59:25'),
(1, 12, 1.00, 3, '2023-01-27 09:59:25'),
(3, 3, 1.00, 3, '2023-02-01 09:34:17'),
(3, 5, 1.00, 3, '2023-02-01 09:34:17'),
(3, 10, 1.00, 3, '2023-02-01 09:34:17'),
(3, 11, 5.00, 3, '2023-02-01 09:34:17'),
(4, 10, 10.00, 5, '2023-01-30 10:28:54'),
(5, 10, 35.00, 5, '2023-01-30 09:54:05'),
(6, 10, 5.00, 5, '2023-01-30 10:31:19'),
(6, 14, 10.00, 5, '2023-01-30 10:31:19'),
(7, 8, 1.00, 5, '2023-02-07 14:49:21'),
(8, 8, 1.00, 5, '2023-02-09 08:42:05'),
(9, 3, 1.00, 5, '2023-02-09 08:44:40'),
(10, 12, 1.00, 5, '2023-04-10 13:46:37');

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

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

CREATE TABLE `banners` (
  `id_banner` int(11) NOT NULL,
  `name_banner` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `image_banner` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description_banner` text COLLATE utf8_unicode_ci NOT NULL,
  `link_banner` varchar(100) COLLATE utf8_unicode_ci 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 `banners`
--

INSERT INTO `banners` (`id_banner`, `name_banner`, `image_banner`, `description_banner`, `link_banner`, `id_status`, `id_user`, `create_date`) VALUES
(1, 'Goes with you, as you want', 'Goes_With_You.jpg', 'We are here to support you', 'Insurance', 1, 5, '2022-03-04 17:53:01'),
(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'),
(3, 'Goes with you, anytime', 'Goes_with_you,_anytime.jpg', 'Goes with you, anytime', 'insurance', 1, 5, '2022-03-04 17:57:33');

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

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

CREATE TABLE `blogs` (
  `id_blog` int(11) NOT NULL,
  `title_blog` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `description_blog` longtext CHARACTER SET utf8mb4 NOT NULL,
  `coverpage_blog` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `alt_img` varchar(100) COLLATE utf8_unicode_ci 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 `blogs`
--

INSERT INTO `blogs` (`id_blog`, `title_blog`, `description_blog`, `coverpage_blog`, `alt_img`, `id_status`, `id_user`, `create_date`) 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<p 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;\"><b>SINOASIA\r\nGROUP</b> 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></p><p 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;\"><br></span></p>\r\n\r\n<p 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;\">Our\r\nbroad geographic coverage allows us to identify and respond quickly to new\r\ninternational trends and opportunities.</span></p>\r\n\r\n<p style=\"margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; direction: ltr; unicode-bidi: embed; word-break: normal;\"></p>\r\n\r\n<p 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;\">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></p>\r\n\r\n<!--EndFragment--></h4>', 'Bee_Insurance_es_miembro_SINOASIA.jpg', 'SINOASIA BEE INSURANCE', 1, 6, '2022-07-14 10:38:40'),
(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><p 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:28.0pt;\r\nfont-family:Arimo;mso-ascii-font-family:Arimo;mso-fareast-font-family:Arimo;\r\nmso-bidi-font-family:Arimo;color:black;mso-color-index:1;mso-font-kerning:12.0pt;\r\nlanguage:es-VE;mso-style-textfill-type:solid;mso-style-textfill-fill-themecolor:\r\ntext1;mso-style-textfill-fill-color:black;mso-style-textfill-fill-alpha:100.0%\"><b>NOW\r\nWE ARE MORE COMMUNICATED,</b> 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></p>\r\n\r\n<!--EndFragment-->', '@beeinsurance__FOLLOW_US_and_keep_it_in_touch.jpg', 'BEE INSURANCE LATINOAMERICA ', 1, 6, '2022-07-14 10:38:54'),
(6, 'First touch IN LATAM', '<h3><b>1st Bee Insurance Corp. Convention&nbsp;</b></h3><h3><br>\"Goes with you\" Convention.</h3><h3><br>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.</h3><h3><br>The event started with the words of Humberto Martinez CEO of Bee Insurance Corp:<br>\"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;<br>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;</h3><h3><br>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\".<br>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;</h3><h3><br>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;</h3><p></p>', 'FIRST_TOUCH_in_Latam.png', 'FIRST TOUCH in Latam', 1, 6, '2022-06-30 14:32:28'),
(9, 'Interview with our Chief Operating Officer Pedro Villasmil.', '<p>🔷How did the name Bee Insurance Corp come about?<br><br>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.<br><br>🔷 Why do you decide to market in Latin America?<br><br>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.<br><br>🔷 After the pandemic, what did you learn?<br><br>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.<br><br>🔷 Is there an expansion plan in Latin America or are you working on it?<br><br>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.<br><br>🔷 Is the product portfolio designed for the region?<br><br>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.<br><br>🔷 What challenges do you consider taking on running the company? (Inflation, globalization, technology)<br><br>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.<br><br>🔷 We are experiencing complex times around the world, what advice do you give to your allies and policyholders?<br><br>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.<br><br>Trust in yourself and your team; knowing how to listen and learn.<br><br>🔶 Pedro Villasmil.<br><br>COO – Bee Insurance Corporation🔶<br></p>', 'Interview_with_our_Chief_Operating_Officer_Pedro_Villasmil..jpeg', 'Img pedro', 1, 6, '2022-07-14 10:39:01'),
(10, 'We get everywhere, but with you it will be better', '<p>We want to work together.</p><p>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;<span style=\"font-family: &quot;Source Sans Pro&quot;, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;; font-size: 1rem;\">We are also looking for insurance agencies that want to sell all our policies for the entire American continent.</span></p><p>We have all the products to preserve the life of your family and your clients, call us together we will be unstoppable.</p><p><span style=\"font-family: &quot;Source Sans Pro&quot;, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;; font-size: 1rem;\">If you are in Latin America, we also speak Spanish.</span></p>', 'We_get_everywhere,_but_with_you_it_will_be_better.jpg', 'Lets work together', 1, 6, '2022-07-14 10:51:32'),
(11, 'Asegurate por tan sólo USD 29/año', '<h1 style=\"text-align: center; \">Compra <a href=\"https://bee-insurance.com/emision.php?product=9\" target=\"_blank\">aquí&nbsp;</a></h1>', 'Blog_11.jpeg', 'Bee 3in1', 1, 3, '2022-08-18 13:45:09');

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

--
-- 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, 4),
(3, 5),
(3, 6),
(4, 9),
(3, 10),
(5, 11);

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

--
-- 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),
(1, 11),
(6, 11),
(7, 11),
(8, 11);

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

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

CREATE TABLE `campaigns` (
  `id_campaign` int(11) NOT NULL,
  `name_campaign` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `subject_campaign` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `send_date` date NOT NULL,
  `description_campaign` longtext COLLATE utf8_unicode_ci 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');
