-- 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_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_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_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 `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,[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]