-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 19-09-2023 a las 18:31:02
-- Versión del servidor: 10.4.28-MariaDB
-- Versión de PHP: 8.2.4

START TRANSACTION;



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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `campaigns` (`id_campaign`, `name_campaign`, `subject_campaign`, `send_date`, `description_campaign`, `id_status`, `id_user`, `create_date`) VALUES
(1, 'Extensión de póliza de vida', 'Es tu oportunidad para extender tu póliza de vida con BEE INSURANCE', '2022-04-11', '<p>prueba de campaña 1&nbsp;</p><p><br></p><p><img src=\"https://bee.dsinternacional.com/dist/products_img/Bee_4in1.jpg\" style=\"width: 600px;\"><br></p><p>blabla lscjsbvhbvhouiv&nbsp; <a href=\"https://bee-insurance.com/\" target=\"_blank\">&nbsp;link aui&nbsp;</a></p>', 3, 5, '2022-04-11 14:20:35'),
(2, 'Extensión de póliza de vida Duplicada', 'Es tu oportunidad para extender tu póliza de vida con BEE INSURANCE', '2022-04-11', '<p>prueba de campaña DUPLICACION con cambio de lista</p><p><br></p><p><img src=\"https://bee.dsinternacional.com/dist/products_img/Bee_4in1.jpg\" style=\"width: 600px;\"><br></p><p>blabla lscjsbvhbvhouiv&nbsp; <a href=\"https://bee-insurance.com/\" target=\"_blank\">&nbsp;link aui&nbsp;</a></p>', 3, 5, '2022-04-11 14:27:23'),
(3, 'Bienvenida', 'Boletin 1', '2022-07-11', '<p>correo de prueba&nbsp;</p><p>por favor notifica a jhonny Matute por whatsapp que recibiste este correo.</p><p>gracias&nbsp;</p>', 3, 5, '2022-07-11 10:59:47');
INSERT INTO `campaigns` (`id_campaign`, `name_campaign`, `subject_campaign`, `send_date`, `description_campaign`, `id_status`, `id_user`, `create_date`) VALUES
(4, 'Nuevos Medios de pago', 'Buena noticia, tenemos nuevo medio de pago. Bee Insurance Boletín 1', '2022-07-12', '<p><span style=\"background-color: rgb(255, 255, 0);\">esto es una&nbsp; prueba por favor informar a jhonny M o Derdlim P , la recepción de este correo</span></p><p>_________________________________________________________________________________________________</p><p><br></p><p>Hola&nbsp;{{Nombres}}, Traemos una buena noticia para tí...</p><h2>Con <span style=\"background-color: rgb(255, 239, 198);\">Ubiipagos</span> nos adaptamos a ti con las diferentes billeteras que facilitan tus transacciones, ofreciendo <span style=\"color: rgb(57, 132, 198);\">un servicio</span> de pago nacional e internacional para nuestros clientes, siendo a su vez una herramienta de venta para nuestro Network.&nbsp;</h2><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src=\"data:image/jpeg;base64,[BLOB]\" 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,[BLOB]\" 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');
INSERT INTO `campaigns` (`id_campaign`, `name_campaign`, `subject_campaign`, `send_date`, `description_campaign`, `id_status`, `id_user`, `create_date`) VALUES
(9, 'Prueba 2 previa Masivo 2', 'Aprovecha y protege a tu familia por solo 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;<img src=\"data:image/jpeg;base64,[BLOB]