-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 19-10-2023 a las 20:15:15
-- Versión del servidor: 10.4.28-MariaDB
-- Versión de PHP: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: `dbwhatsapp`
--

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

--
-- Estructura de tabla para la tabla `catalog_template`
--

CREATE TABLE `catalog_template` (
  `id` int(11) NOT NULL,
  `template_id` text NOT NULL,
  `parameters` varchar(100) NOT NULL,
  `provider` varchar(50) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `catalog_template` (`id`, `template_id`, `parameters`, `provider`, `description`) VALUES
(1, '%7B%22id%22:%22b7d92113-4287-44fb-a11a-be5a42d616c0%22', 'la clave de acceso para tu APP Pideaky es: *\".rand_str(6).\"* ', 'gushup', 'Envio de NIP para APP '),
(2, '%7B%22id%22:%22d928d4b5-2b86-4ab5-94f6-57650a444919%22', 'Daniel valentina Samantha', 'gushup', 'recordar pago al día de hoy');

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

--
-- Estructura de tabla para la tabla `otp_whatsapp`
--

CREATE TABLE `otp_whatsapp` (
  `id` int(6) NOT NULL,
  `timestamp` datetime NOT NULL DEFAULT current_timestamp(),
  `sendrequest_id` int(3) NOT NULL,
  `NIP` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `otp_whatsapp` (`id`, `timestamp`, `sendrequest_id`, `NIP`) VALUES
(1, '2023-10-19 08:47:17', 0, 0),
(2, '2023-10-19 08:48:41', 20, 578547),
(3, '2023-10-19 10:49:51', 21, 676425),
(4, '2023-10-19 11:16:16', 22, 215986);

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

--
-- Estructura de tabla para la tabla `sendrequests`
--

CREATE TABLE `sendrequests` (
  `id` int(11) NOT NULL,
  `timestamp` datetime NOT NULL DEFAULT current_timestamp(),
  `username` varchar(25) NOT NULL,
  `sender` varchar(25) NOT NULL,
  `destination` varchar(15) NOT NULL,
  `template_id` int(3) NOT NULL,
  `parameters` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `sendrequests` (`id`, `timestamp`, `username`, `sender`, `destination`, `template_id`, `parameters`) VALUES
(1, '2023-10-18 21:55:44', '', '0', '', 0, ''),
(2, '2023-10-18 21:55:54', '', '0', '', 0, ''),
(3, '2023-10-18 21:56:39', '', '0', '', 0, ''),
(4, '2023-10-18 22:01:05', '', '0', '', 0, ''),
(5, '2023-10-18 22:05:17', '', '0', '5610919097', 1, ''),
(6, '2023-10-18 22:05:52', '', 'APP', '5610919097', 1, ''),
(7, '2023-10-18 22:06:07', '', 'APP', '5610919097', 2, ''),
(8, '2023-10-18 22:07:34', '', 'APP', '5610919097', 2, 'Oscar PideAKy'),
(9, '2023-10-18 22:07:48', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *216960'),
(10, '2023-10-18 22:08:32', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *698129*. '),
(11, '2023-10-19 08:26:36', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *161652*. '),
(12, '2023-10-19 08:26:46', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *041875*. '),
(13, '2023-10-19 08:30:03', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *249161*. '),
(14, '2023-10-19 08:30:31', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *591070*. '),
(15, '2023-10-19 08:30:52', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *421090*. '),
(16, '2023-10-19 08:35:38', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *106920*. '),
(17, '2023-10-19 08:35:47', '', 'APP', '5610919097', 0, 'Oscar PideAKy'),
(18, '2023-10-19 08:36:06', '', 'APP', '5610919097', 0, 'Oscar PideAKy'),
(19, '2023-10-19 08:48:37', '', 'APP', '5610919097', 0, 'Oscar PideAKy'),
(20, '2023-10-19 08:48:41', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *578547*. '),
(21, '2023-10-19 10:49:51', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *676425*. '),
(22, '2023-10-19 11:16:16', '', 'APP', '5610919097', 1, 'la clave de acceso para tu APP Pideaky es: *215986*. ');

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

--
-- Estructura de tabla para la tabla `sendresults`
--

CREATE TABLE `sendresults` (
  `id` int(11) NOT NULL,
  `timestamp` datetime NOT NULL DEFAULT current_timestamp(),
  `sendrequest_id` int(3) NOT NULL,
  `result` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `sendresults` (`id`, `timestamp`, `sendrequest_id`, `result`) VALUES
(1, '2023-10-19 08:28:15', 0, ''),
(2, '2023-10-19 08:30:04', 13, 'Array'),
(3, '2023-10-19 08:30:32', 14, 'Array'),
(4, '2023-10-19 08:30:53', 15, '{\n  \"messageId\": \"63aba4a6-f091-448c-ab29-5d172d453970\",\n  \"status\": \"submitted\"\n}'),
(5, '2023-10-19 08:35:38', 16, '{\n  \"messageId\": \"32629b7c-b51b-4d53-90e0-b7cb649c0ea1\",\n  \"status\": \"submitted\"\n}'),
(6, '2023-10-19 08:35:47', 17, 'json_encode(Array)'),
(7, '2023-10-19 08:36:06', 18, '{\"Result\":{\"responseWhatsapp\":\"Fail\"}}'),
(8, '2023-10-19 08:48:37', 19, '{\"Result\":{\"responseWhatsapp\":\"Fail\"}}'),
(9, '2023-10-19 08:48:42', 20, '{\n  \"messageId\": \"bda494fd-5c6b-4945-bd56-68343bf5f808\",\n  \"status\": \"submitted\"\n}'),
(10, '2023-10-19 10:49:52', 21, '{\n  \"messageId\": \"8a182b8a-d5b7-40f3-92e0-7996edb41566\",\n  \"status\": \"submitted\"\n}'),
(11, '2023-10-19 11:16:17', 22, '{\n  \"messageId\": \"a7401dc2-4ac1-4010-b200-301c6da0034f\",\n  \"status\": \"submitted\"\n}');

--
-- Índices para tablas volcadas
--

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

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

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

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `catalog_template`
--
ALTER TABLE `catalog_template`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `otp_whatsapp`
--
ALTER TABLE `otp_whatsapp`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `sendrequests`
--
ALTER TABLE `sendrequests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT de la tabla `sendresults`
--
ALTER TABLE `sendresults`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
