-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 06-06-2026 a las 21:17:28
-- Versión del servidor: 10.11.16-MariaDB
-- Versión de PHP: 8.4.20

START TRANSACTION;



--
-- Base de datos: `alphares_certif`
--

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

--
-- Estructura de tabla para la tabla `auth_groups`
--

CREATE TABLE `auth_groups` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `auth_groups` (`id`, `name`, `description`) VALUES
(1, 'superadmin', 'Usuarios con control total del sistema'),
(2, 'admin', 'Usuarios administradores con permisos avanzados'),
(3, 'estandar', 'Usuarios estándar con permisos limitados');

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

--
-- Estructura de tabla para la tabla `auth_groups_users`
--

CREATE TABLE `auth_groups_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `group` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `auth_groups_users` (`id`, `user_id`, `group`, `created_at`) VALUES
(1, 1, '1', '2025-02-28 11:28:42'),
(12, 57, '2', '2025-03-16 23:22:36'),
(16, 61, '1', '2025-03-18 23:40:13');

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

--
-- Estructura de tabla para la tabla `auth_identities`
--

CREATE TABLE `auth_identities` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `secret` varchar(255) NOT NULL,
  `secret2` varchar(255) DEFAULT NULL,
  `expires` datetime DEFAULT NULL,
  `extra` text DEFAULT NULL,
  `force_reset` tinyint(1) NOT NULL DEFAULT 0,
  `last_used_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `auth_identities` (`id`, `user_id`, `type`, `name`, `secret`, `secret2`, `expires`, `extra`, `force_reset`, `last_used_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'email_password', NULL, 'admin@email.com', '$2y$12$.SY09AXjRtDAUcQ4ygVSiuDdOFIPlbgteILiZuDn2EIi/lljv4IuK', NULL, NULL, 0, '2026-06-03 18:37:05', '2025-02-25 10:46:09', '2026-06-03 18:37:05'),
(42, 57, 'email_password', NULL, 'super@correo.com', '$2y$10$00HWbIdDp9aSkifOxZurG.7cxcRTzmx0VzcziDdOf/49tGdm43Yxa', NULL, NULL, 0, NULL, '2025-03-16 23:22:36', '2025-06-11 22:31:03'),
(46, 61, 'email_password', NULL, 'test7@engie.com', '$2y$12$hRVX/3.3B0s8DKlH24pi3OUI5CVwKzHral5BGe11bYXFay0Wj6hTK', NULL, NULL, 0, NULL, '2025-03-18 23:40:12', '2025-06-11 22:25:48');

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

--
-- Estructura de tabla para la tabla `auth_logins`
--

CREATE TABLE `auth_logins` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `date` datetime NOT NULL,
  `success` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `auth_logins` (`id`, `ip_address`, `user_agent`, `id_type`, `identifier`, `user_id`, `date`, `success`) VALUES
(1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-25 10:54:10', 0),
(2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-25 10:56:51', 0),
(3, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-25 11:00:01', 0),
(4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-25 11:02:19', 0),
(5, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-26 01:43:29', 0),
(6, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-26 08:58:10', 0),
(7, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-26 09:00:13', 0),
(8, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 09:38:04', 0),
(9, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 09:55:35', 0),
(10, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 09:55:51', 0),
(11, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 09:59:44', 0),
(12, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 10:01:47', 0),
(13, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 10:08:20', 0),
(14, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 10:19:24', 0),
(15, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 10:26:40', 0),
(16, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 10:30:27', 0),
(17, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 10:54:22', 0),
(18, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 10:59:27', 0),
(19, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 11:01:19', 0),
(20, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 11:03:31', 0),
(21, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 11:05:19', 0),
(22, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 11:07:26', 0),
(23, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 11:13:53', 0),
(24, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-28 01:08:57', 0),
(25, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 20:23:25', 0),
(26, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'email_password', 'admin', NULL, '2025-02-27 20:44:06', 0),
(27, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-02-27 21:07:50', 1),
(28, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-02-28 05:52:02', 1),
(29, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-03 11:11:01', 1),
(30, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-03 13:37:45', 1),
(31, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-03 17:20:16', 1),
(32, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-04 07:40:35', 1),
(33, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-04 11:48:41', 1),
(34, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-04 17:16:47', 1),
(35, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-04 20:00:16', 1),
(36, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-05 19:27:14', 1),
(37, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-06 04:11:13', 1),
(38, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-06 19:37:44', 1),
(39, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-07 04:28:51', 1),
(40, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-07 05:34:03', 1),
(41, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-07 20:37:00', 1),
(42, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-08 05:26:23', 1),
(43, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-09 06:07:06', 1),
(44, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-10 19:07:52', 1),
(45, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-11 18:41:46', 1),
(46, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-12 18:46:17', 1),
(47, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 'username', 'admin', 1, '2025-03-12 21:33:44', 1),
(48, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-13 18:42:12', 1),
(49, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 'username', 'admin', 1, '2025-03-13 19:26:12', 1),
(50, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-15 08:51:39', 1),
(51, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-15 12:40:27', 1),
(52, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-15 20:10:33', 1),
(53, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', 'username', 'admin', 1, '2025-03-16 07:40:19', 1),
(54, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-16 09:45:15', 1),
(55, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-16 16:49:40', 1),
(56, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-16 23:03:26', 1),
(57, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-17 00:06:50', 1),
(58, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-17 00:14:10', 1),
(59, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-17 18:42:50', 1),
(60, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-18 19:21:08', 1),
(61, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-19 18:53:22', 1),
(62, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-19 21:12:57', 1),
(63, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-20 19:05:54', 1),
(64, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-20 19:46:19', 1),
(65, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-20 19:47:57', 1),
(66, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-20 23:37:24', 1),
(67, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-22 12:08:59', 1),
(68, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-22 16:42:42', 1),
(69, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-23 22:15:08', 1),
(70, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-24 18:47:30', 1),
(71, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-25 03:14:11', 1),
(72, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-25 20:03:01', 1),
(73, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-26 19:10:29', 1),
(74, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-27 19:11:32', 1),
(75, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-28 19:55:41', 1),
(76, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-29 07:58:00', 1),
(77, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-30 09:36:10', 1),
(78, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-30 13:10:46', 1),
(79, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-30 21:35:42', 1),
(80, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-03-31 18:54:13', 1),
(81, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-01 18:55:05', 1),
(82, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-02 19:29:16', 1),
(83, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-02 20:31:04', 1),
(84, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-03 18:53:15', 1),
(85, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-04 22:38:53', 1),
(86, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-04 22:45:19', 1),
(87, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-05 12:51:29', 1),
(88, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-05 20:54:11', 1),
(89, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-06 10:44:34', 1),
(90, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-06 16:18:57', 1),
(91, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', 'username', 'admin', 1, '2025-04-06 22:20:32', 1),
(92, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-10 19:37:35', 1),
(93, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-14 19:08:44', 1),
(94, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-14 21:09:52', 1),
(95, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-15 19:59:14', 1),
(96, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-17 18:32:01', 1),
(97, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-18 16:22:52', 1),
(98, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-18 18:55:11', 1),
(99, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-19 07:59:39', 1),
(100, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-19 19:30:39', 1),
(101, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-20 08:16:28', 1),
(102, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-21 19:12:29', 1),
(103, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-21 21:36:59', 1),
(104, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-22 18:40:56', 1),
(105, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-23 18:45:56', 1),
(106, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', 'username', 'admin', 1, '2025-04-24 19:02:18', 1),
(107, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-15 20:20:48', 1),
(108, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-15 21:07:21', 1),
(109, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-15 21:25:19', 1),
(110, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-15 21:28:30', 1),
(111, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-15 21:40:54', 1),
(112, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-15 21:42:02', 1),
(113, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-15 21:47:26', 1),
(114, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-16 19:07:24', 1),
(115, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-17 10:33:02', 1),
(116, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-19 19:46:40', 1),
(117, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-20 04:49:58', 1),
(118, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-20 21:40:40', 1),
(119, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-21 19:35:00', 1),
(120, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-22 19:00:51', 1),
(121, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', NULL, '2025-05-26 20:08:36', 0),
(122, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', NULL, '2025-05-26 20:16:01', 0),
(123, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admi', NULL, '2025-05-26 20:25:59', 0),
(124, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'username', 'admin', 1, '2025-05-26 20:26:16', 1),
(125, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'asdsad@sdsdf.com', NULL, '2025-05-28 19:32:53', 0),
(126, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'asdsad@sdsdf.com', NULL, '2025-05-28 19:33:26', 0),
(127, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'admin@email.com', 1, '2025-05-28 19:45:17', 1),
(128, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'sadas@enie.com', NULL, '2025-05-29 20:33:21', 0),
(129, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'asd@sada.com', NULL, '2025-05-29 20:36:08', 0),
(130, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'admin@email.com', 1, '2025-05-29 20:57:45', 1),
(131, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'admin@email.com', 1, '2025-05-29 21:50:05', 1),
(132, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'admin@email.com', 1, '2025-05-29 22:38:23', 1),
(133, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'admin@email.com', 1, '2025-05-29 22:41:04', 1),
(134, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'admin@email.com', 1, '2025-05-29 22:42:26', 1),
(135, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:138.0) Gecko/20100101 Firefox/138.0', 'email_password', 'admin@email.com', 1, '2025-05-30 19:39:28', 1),
(136, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:139.0) Gecko/20100101 Firefox/139.0', 'email_password', 'admin@email.com', 1, '2025-06-01 13:13:03', 1),
(137, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:139.0) Gecko/20100101 Firefox/139.0', 'email_password', 'admin@email.com', 1, '2025-06-02 19:05:42', 1),
(138, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:139.0) Gecko/20100101 Firefox/139.0', 'email_password', 'admin@email.com', 1, '2025-06-11 22:07:15', 1),
(139, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:139.0) Gecko/20100101 Firefox/139.0', 'email_password', 'admin@email.com', 1, '2025-06-11 22:09:51', 1),
(140, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:139.0) Gecko/20100101 Firefox/139.0', 'email_password', 'admin@email.com', 1, '2025-06-16 20:33:44', 1),
(141, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'admin@admin.com', NULL, '2026-04-06 22:12:25', 0),
(142, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'admin@admin.com', NULL, '2026-04-06 22:14:53', 0),
(143, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'supervisor@gmail.com', NULL, '2026-04-06 22:15:40', 0),
(144, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'supervisor@gmail.com', NULL, '2026-04-06 22:15:46', 0),
(145, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'admin@email.com', 1, '2026-04-06 22:16:36', 1),
(146, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'admin@email.com', 1, '2026-04-09 20:36:16', 1),
(147, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'admin@email.com', 1, '2026-04-10 21:10:32', 1),
(148, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'email_password', 'admin@email.com', 1, '2026-04-13 19:43:25', 1),
(149, '181.176.85.162', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:149.0) Gecko/20100101 Firefox/149.0', 'email_password', 'admin@email.com', 1, '2026-04-14 13:42:00', 1),
(150, '138.84.38.189', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-14 14:07:06', 1),
(151, '181.176.100.230', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:149.0) Gecko/20100101 Firefox/149.0', 'email_password', 'admin@email.com', 1, '2026-04-14 16:47:01', 1),
(152, '138.84.38.189', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-14 17:07:15', 1),
(153, '38.253.189.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-14 17:24:27', 1),
(154, '38.253.189.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-15 18:20:12', 1),
(155, '132.184.161.19', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-15 23:51:36', 1),
(156, '38.253.189.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-16 17:45:53', 1),
(157, '38.253.189.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-17 12:23:48', 1),
(158, '181.176.82.117', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:149.0) Gecko/20100101 Firefox/149.0', 'email_password', 'admin@email.com', 1, '2026-04-17 19:51:27', 1),
(159, '38.253.189.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-17 22:29:19', 1),
(160, '181.176.45.81', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:149.0) Gecko/20100101 Firefox/149.0', 'email_password', 'admin@email.com', 1, '2026-04-19 06:25:45', 1),
(161, '38.253.189.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-19 18:15:48', 1),
(162, '179.6.144.32', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-19 19:54:17', 1),
(163, '181.176.105.136', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:149.0) Gecko/20100101 Firefox/149.0', 'email_password', 'admin@email.com', 1, '2026-04-19 20:38:46', 1),
(164, '38.253.189.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-20 00:10:53', 1),
(165, '138.84.39.249', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-20 15:26:07', 1),
(166, '179.6.144.79', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-22 10:52:32', 1),
(167, '179.7.180.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-23 11:56:11', 1),
(168, '179.6.144.79', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-23 11:58:39', 1),
(169, '179.7.180.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-23 20:45:36', 1),
(170, '179.7.180.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-04-24 00:10:37', 1),
(171, '181.176.82.5', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:150.0) Gecko/20100101 Firefox/150.0', 'email_password', 'admin@email.com', 1, '2026-05-07 12:59:52', 1),
(172, '138.84.38.195', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-05-07 13:00:27', 1),
(173, '132.184.160.196', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-05-07 15:17:15', 1),
(174, '190.119.58.188', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-05-07 19:17:35', 1),
(175, '181.176.97.205', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:150.0) Gecko/20100101 Firefox/150.0', 'email_password', 'admin@email.com', 1, '2026-05-16 20:44:14', 1),
(176, '181.176.97.145', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:150.0) Gecko/20100101 Firefox/150.0', 'email_password', 'admin@email.com', 1, '2026-05-24 19:40:30', 1),
(177, '132.184.161.240', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-05-27 18:26:26', 1),
(178, '132.184.160.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-05-27 20:46:02', 1),
(179, '181.176.81.187', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:150.0) Gecko/20100101 Firefox/150.0', 'email_password', 'admin@email.com', 1, '2026-05-28 19:02:26', 1),
(180, '132.184.161.214', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-05-29 19:33:56', 1),
(181, '181.176.83.17', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:150.0) Gecko/20100101 Firefox/150.0', 'email_password', 'admin@email.com', 1, '2026-05-29 21:01:02', 1),
(182, '179.7.180.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-06-02 18:48:10', 1),
(183, '179.7.180.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-06-03 09:14:01', 1),
(184, '179.7.180.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-06-03 17:35:52', 1),
(185, '179.7.180.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-06-03 17:36:31', 1),
(186, '132.184.160.222', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-06-03 18:36:55', 1),
(187, '132.184.160.222', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'email_password', 'admin@email.com', 1, '2026-06-03 18:36:55', 1),
(188, '216.9.224.107', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.85 Safari/537.36', 'email_password', 'nnglniel@immenseignite.info', NULL, '2026-06-05 14:00:07', 0);

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

--
-- Estructura de tabla para la tabla `auth_permissions_users`
--

CREATE TABLE `auth_permissions_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `permission` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `auth_remember_tokens`
--

CREATE TABLE `auth_remember_tokens` (
  `id` int(11) UNSIGNED NOT NULL,
  `selector` varchar(255) NOT NULL,
  `hashedValidator` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `expires` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `auth_remember_tokens` (`id`, `selector`, `hashedValidator`, `user_id`, `expires`, `created_at`, `updated_at`) VALUES
(9, '2beeb39e846f36463a15fd2f', 'b3d281c1bd518c4524f408f573e84301efeb028b15b59949a0fdb21e3c7696ec', 1, '2026-07-07 00:51:09', '2026-06-03 17:36:31', '2026-06-06 19:51:09');

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

--
-- Estructura de tabla para la tabla `auth_token_logins`
--

CREATE TABLE `auth_token_logins` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `date` datetime NOT NULL,
  `success` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `migrations`
--

CREATE TABLE `migrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2020-12-28-223112', 'CodeIgniter\\Shield\\Database\\Migrations\\CreateAuthTables', 'default', 'CodeIgniter\\Shield', 1740016496, 1),
(2, '2021-07-04-041948', 'CodeIgniter\\Settings\\Database\\Migrations\\CreateSettingsTable', 'default', 'CodeIgniter\\Settings', 1740016496, 1),
(3, '2021-11-14-143905', 'CodeIgniter\\Settings\\Database\\Migrations\\AddContextColumn', 'default', 'CodeIgniter\\Settings', 1740016496, 1);

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

--
-- Estructura de tabla para la tabla `settings`
--

CREATE TABLE `settings` (
  `id` int(9) NOT NULL,
  `class` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `type` varchar(31) NOT NULL DEFAULT 'string',
  `context` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `tb_certificados`
--

CREATE TABLE `tb_certificados` (
  `id_certificado` int(11) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `dni` varchar(20) NOT NULL,
  `codigo` varchar(255) NOT NULL,
  `fecha_emision` date NOT NULL,
  `fecha_vigencia` date NOT NULL,
  `archivo_pdf` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `tb_certificados` (`id_certificado`, `nombre`, `dni`, `codigo`, `fecha_emision`, `fecha_vigencia`, `archivo_pdf`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'MAMANI CHAYÑA WILIAN YUNIOR', '74081570', '26AR-PA00001', '2026-04-12', '2027-04-12', '74081570.pdf', '2026-05-07 16:00:10', '2026-06-03 18:45:13', '2026-06-03 18:45:13'),
(2, 'MOLLOCONDO CONDORI ROLAND ERICK', '44488677', '26AR-PA0002', '2026-04-12', '2027-04-12', '44488677_26AR-PA0002.pdf', '2026-05-07 16:08:55', '2026-05-27 18:27:16', '2026-05-27 18:27:16'),
(3, 'HUAMAN CHARA AMBROCIO', '25220037', '26AR-PA0003', '2026-03-27', '2027-03-27', '25220037_26AR-PA0003.pdf', '2026-05-08 10:19:02', '2026-05-08 10:19:02', NULL),
(4, 'TAPARA CLAVERIAS ELVIS DANDY', '74379932', '26AR-PA0004', '2026-03-27', '2027-03-27', '74379932_26AR-PA0004.pdf', '2026-05-08 10:45:06', '2026-05-08 10:45:06', NULL),
(5, 'LAURA  CLAVERIAS  BRAYAN', '74379917', '26AR-PA0005', '2026-03-27', '2027-03-27', '74379917_26AR-PA0005.pdf', '2026-05-08 10:49:40', '2026-05-08 10:49:40', NULL),
(6, 'PACCO MERMA JENRRE', '74249479', '26AR-PA0006', '2026-03-27', '2027-03-27', '74249479_26AR-PA0006.pdf', '2026-05-08 11:02:15', '2026-05-08 11:02:15', NULL),
(7, 'CHURA ANAHUA JESUS EDDY', '44501975', '26AR-PA0007', '2026-03-27', '2027-03-27', '44501975_26AR-PA0007.pdf', '2026-05-08 11:05:53', '2026-05-08 11:05:53', NULL),
(8, 'CHAMBI HUAHUASONCCO MICHAEL RUBEN', '71861930', '26AR-PA0008', '2026-03-27', '2027-03-27', '71861930_26AR-PA0008.pdf', '2026-05-08 11:10:51', '2026-05-08 11:10:51', NULL),
(9, 'APOLINARIO PABLO JENNER JOSUE', '71621184', '26AR-PA0009', '2026-03-27', '2027-03-27', '71621184_26AR-PA0009.pdf', '2026-05-08 11:16:17', '2026-05-08 11:16:17', NULL),
(10, 'QUISPE VILCA MIGUEL DONATO', '73250734', '26AR-PA0010', '2026-04-12', '2027-04-12', '73250734_26AR-PA0010.pdf', '2026-05-08 11:21:27', '2026-05-08 11:21:27', NULL),
(11, 'SOLIS MORMONTOY MARCOS', '73744901', '26AR-PA0011', '2026-04-12', '2027-04-12', '73744901_26AR-PA0011.pdf', '2026-05-08 11:34:00', '2026-05-08 11:34:00', NULL),
(12, 'HUAMAN GUTIÉRREZ YUORK EDYSON', '74598537', '26AR-PA0012', '2026-04-12', '2027-04-12', '74598537_26AR-PA0012.pdf', '2026-05-08 11:38:28', '2026-05-08 11:38:28', NULL),
(13, 'HUAHUASONCCO CHAMBI RUTH SORAIDA', '71864729', '26AR-PA0013', '2026-04-12', '2027-04-12', '71864729_26AR-PA0013.pdf', '2026-05-08 11:46:18', '2026-05-08 11:46:18', NULL),
(14, 'AYHUASI HUARAHUARA DANIEL', '42348236', '26AR-PA0014', '2026-04-12', '2027-04-12', '42348236_26AR-PA0014.pdf', '2026-05-08 11:50:02', '2026-05-08 11:50:02', NULL),
(15, 'MUÑOZ PACCO GUIDO PAUL', '71847798', '26AR-PA0015', '2026-04-12', '2027-04-12', '71847798_26AR-PA0015.pdf', '2026-05-08 12:00:17', '2026-05-27 18:28:27', '2026-05-27 18:28:27'),
(16, 'ARCE  PACHARI PAUL ARTIDORO', '42098308', '26AR-PA0016', '2026-03-27', '2027-03-27', '42098308_26AR-PA0016.pdf', '2026-05-08 12:07:05', '2026-06-03 10:31:31', '2026-06-03 10:31:31'),
(17, 'QUISPE SUCARI BERNANDINO CEFERINO', '48535120', '26AR-PA0017', '2026-03-27', '2027-03-27', '48535120_26AR-PA0017.pdf', '2026-05-08 12:12:31', '2026-05-08 12:12:31', NULL),
(18, 'CANAZA APAZA JUAN DIEGO', '73146499', '26AR-PA0018', '2026-04-12', '2027-04-12', '73146499_26AR-PA0018.pdf', '2026-05-08 12:17:02', '2026-05-27 18:29:19', '2026-05-27 18:29:19'),
(19, 'SALAZAR MAMANI MANUEL', '47924262', '26AR-PA0019', '2026-04-12', '2027-04-12', '47924262_26AR-PA0019.pdf', '2026-05-08 12:20:25', '2026-05-27 18:29:29', '2026-05-27 18:29:29'),
(20, 'CCARITA VILCA WARTER', '71925261', '26AR-PA0020', '2026-04-12', '2027-04-12', '71925261_26AR-PA0020.pdf', '2026-05-08 12:23:42', '2026-05-08 12:23:42', NULL),
(21, 'LOPEZ RIVERA PIO JESUS', '73669316', '26AR-PA0021', '2026-04-12', '2027-04-12', '73669316_26AR-PA0021.pdf', '2026-05-08 12:26:50', '2026-05-08 12:26:50', NULL),
(22, 'PICHARDO CERAS KENNEDY', '70312049', '26AR-PA0022', '2026-05-03', '2027-05-03', '70312049_26AR-PA0022.pdf', '2026-05-08 12:30:26', '2026-05-27 18:27:41', '2026-05-27 18:27:41'),
(23, 'MAMANI APAZA FRANKLIN JHONATAN', '73447131', '26AR-PA0023', '2026-05-03', '2027-05-03', '73447131_26AR-PA0023.pdf', '2026-05-08 12:34:23', '2026-05-08 12:34:23', NULL),
(24, 'ARISACA  ROQUE  YUBHERT UBALDO ', '73744733', '26AR-PA0024', '2026-05-03', '2027-05-03', '73744733_26AR-PA0024.pdf', '2026-05-08 12:37:57', '2026-05-08 12:37:57', NULL),
(25, 'CONDORI MOROCO FRANS YON', '71857154', '26AR-PA0025', '2026-05-03', '2027-05-03', '71857154_26AR-PA0025.pdf', '2026-05-08 12:49:45', '2026-05-08 12:49:45', NULL),
(26, 'QQUELCCA FERNANDEZ ROMULO AMERICO', '77691856', '26AR-PA0026', '2026-05-03', '2027-05-03', '77691856_26AR-PA0026.pdf', '2026-05-08 13:06:34', '2026-05-08 13:06:34', NULL),
(27, 'QUISPE VILCA VICTOR JHONNY', '73142192', '26AR-PA0027', '2026-05-03', '2027-05-03', '73142192_26AR-PA0027.pdf', '2026-05-08 13:11:32', '2026-05-08 13:11:32', NULL),
(28, 'ZIRENA CONDORI JULIO CÉSAR', '73704877', '26AR-PA0028', '2026-05-03', '2027-05-03', '73704877_26AR-PA0028.pdf', '2026-05-08 13:15:04', '2026-05-27 20:46:10', '2026-05-27 20:46:10'),
(29, 'CHUCHI MOROCCO YEFERSON', '70389717', '26AR-PA0029', '2026-05-03', '2027-05-03', '70389717_26AR-PA0029.pdf', '2026-05-08 13:18:50', '2026-05-08 13:18:50', NULL),
(30, 'NAVARRO  PACHA DIMAR', '74598945', '26AR-PA0030', '2026-05-03', '2027-05-03', '74598945_26AR-PA0030.pdf', '2026-05-08 13:22:25', '2026-05-08 13:22:25', NULL),
(31, 'VALERIANO TURPO MIGUEL ANGEL', '70772534', '26AR-PA0031', '2026-05-03', '2027-05-03', '70772534_26AR-PA0031.pdf', '2026-05-08 13:25:39', '2026-05-08 13:25:39', NULL),
(32, 'MAMANI POCCOHUANCA EDWIN', '73704899', '26AR-PA0032', '2026-05-03', '2027-05-03', '73704899_26AR-PA0032.pdf', '2026-05-08 13:28:55', '2026-05-27 20:46:28', '2026-05-27 20:46:28'),
(33, 'RIVERA BRAVO REYNER JAVIER', '41868503', '26AR-PA0033', '2026-05-10', '2027-05-10', '41868503_26AR-PA0033.pdf', '2026-05-19 18:20:48', '2026-05-27 18:26:58', '2026-05-27 18:26:58'),
(34, 'QUISPE FARFAN HAYDEE', '72307964', '26AR-PA0034', '2026-05-10', '2027-05-10', '72307964_26AR-PA0034.pdf', '2026-05-29 19:35:44', '2026-05-29 19:35:44', NULL),
(35, 'NAVARRO  PACHA  GLADYS', '79135426', '26AR-PA0035', '2026-05-10', '2027-05-10', '79135426_26AR-PA0035.pdf', '2026-05-29 19:44:44', '2026-05-29 19:44:44', NULL),
(36, 'CCARITA  TUTACANO  MARÍA', '44075675', '26AR-PA0036', '2026-05-10', '2027-05-10', '44075675_26AR-PA0036.pdf', '2026-05-29 20:09:59', '2026-05-29 20:09:59', NULL),
(37, 'HUAHUASONCCO CONDORI MAYUMI SHARETH', '73819762', '26AR-PA0037', '2026-05-10', '2027-05-10', '73819762_26AR-PA0037.pdf', '2026-05-29 20:33:54', '2026-05-29 20:33:54', NULL),
(38, 'QUISPE  CHUQUELUQUE  CLINTON  ANTONIO', '73818942', '26AR-PA0038', '2026-05-10', '2027-05-10', '73818942_26AR-PA0038.pdf', '2026-05-29 20:59:54', '2026-05-29 20:59:54', NULL),
(39, 'QUISPE  MACHACA  JESÚS EDWIN', '75483031', '26AR-PA0039', '2026-05-10', '2027-05-10', '75483031_26AR-PA0039.pdf', '2026-05-29 21:15:29', '2026-05-29 21:15:29', NULL),
(40, 'TAPARA  JARATA  ALDAIR  LENIN', '60067875', '26AR-PA0040', '2026-05-10', '2027-05-10', '60067875_26AR-PA0040.pdf', '2026-05-29 21:35:02', '2026-05-29 21:35:02', NULL),
(41, 'VILCA  VILCA GONZALO  VIDMER', '71883288', '26AR-PA0041', '2026-05-10', '2027-05-10', '71883288_26AR-PA0041.pdf', '2026-05-29 21:41:35', '2026-05-29 21:41:35', NULL),
(42, 'TURPO  HUALLIPE  FREDY', '75535192', '26AR-PA0042', '2026-05-10', '2027-05-10', '75535192_26AR-PA0042.pdf', '2026-05-29 21:49:39', '2026-05-29 21:49:39', NULL),
(43, 'CHOQUELUQUE  DE LA CRUZ  ELIFAZ ', '70282694', '26AR-PA0043', '2026-05-10', '2027-05-10', '70282694_26AR-PA0043.pdf', '2026-05-29 23:21:58', '2026-05-29 23:21:58', NULL),
(44, 'HUAMAN  DE  LA CRUZ  PERCY', '41317200', '26AR-PA0044', '2026-05-10', '2027-05-10', '41317200_26AR-PA0044.pdf', '2026-05-29 23:31:11', '2026-05-29 23:31:11', NULL),
(45, 'BARRIONUEVO  HANCCO  JESÚS  LENIN', '76815057', '26AR-PA0045', '2026-05-10', '2027-05-10', '76815057_26AR-PA0045.pdf', '2026-05-29 23:46:04', '2026-05-29 23:46:04', NULL),
(46, 'MAMANI FARFAN MARTIR CHRISTIAN', '71027565', '26AR-PA0046', '2026-05-23', '2027-05-23', '71027565.pdf', '2026-05-29 23:53:26', '2026-05-30 09:01:15', NULL),
(47, 'HUAMAN  CANALES  PAUL  TOMY', '91209017', '26AR-PA0047', '2026-05-23', '2027-05-23', '91209017.pdf', '2026-05-30 00:01:26', '2026-05-30 09:00:45', NULL),
(48, 'QUILCCA QUIRO RUBEN', '71864635 ', '26AR-PA0048', '2026-05-23', '2027-05-23', '71864635 .pdf', '2026-05-30 00:05:56', '2026-05-30 09:01:47', NULL),
(49, 'QUISPE  JARPA  JHONATAN  RICHARD', '76059781', '26AR-PA0049', '2026-05-23', '2027-05-23', '76059781.pdf', '2026-05-30 00:12:00', '2026-05-30 09:03:38', NULL),
(50, 'CCANCCAPA  CHURA  KATERIN  YESSI', '77353402', '26AR-PA0050', '2026-05-23', '2027-05-23', '77353402.pdf', '2026-05-30 00:18:12', '2026-05-30 09:04:34', NULL),
(51, 'QUILCA  QUISPE  EDY  JESUS', '71864634', '26AR-PA0051', '2026-05-23', '2027-05-23', '71864634.pdf', '2026-05-30 00:24:58', '2026-05-30 09:05:23', NULL),
(52, 'CHURA  ANAHUA  YHORSON', '75170133', '26AR-PA0052', '2026-05-23', '2027-05-23', '75170133_26AR-PA0052.pdf', '2026-05-30 00:33:03', '2026-05-30 00:33:03', NULL),
(53, 'PERALTA  HUMALLA  YONY  ELIAS', '70389747', '26AR-PA0053', '2026-10-23', '2027-10-23', '70389747_26AR-PA0053.pdf', '2026-05-30 00:38:02', '2026-05-30 00:38:02', NULL),
(54, 'MAMANI APAZA FRANKLIN JHONATAN', '73447131', '26AR-LCI0001', '2026-05-24', '2027-05-24', '73447131.pdf', '2026-05-31 17:49:24', '2026-05-31 20:59:45', NULL),
(55, 'SOLIS  MORMONTOY  MARCOS', '73744901', '26AR-LCI0002', '2026-05-24', '2027-05-24', '73744901.pdf', '2026-05-31 17:58:57', '2026-05-31 21:00:10', NULL),
(56, 'ARISACA  ROQUE  YUBHERT  UBALDO', '73744733', '26AR-LCI0003', '2026-05-24', '2027-05-24', '73744733.pdf', '2026-05-31 18:19:39', '2026-05-31 21:00:33', NULL),
(57, 'TURPO  HUALLIPE  FREDY', '73535192 ', '26AR-LCI0004', '2026-05-24', '2027-05-24', '73535192 .pdf', '2026-05-31 18:24:53', '2026-05-31 21:00:57', NULL),
(58, 'QUISPE VILCA VICTOR JHONNY', '73142192', '26AR-LCI0005', '2026-05-24', '2027-05-24', '73142192.pdf', '2026-05-31 18:30:35', '2026-05-31 21:01:19', NULL),
(59, 'BARRIONUEVO  HANCCO  JESÚS  LENIN', '76815057', '26AR-LCI0006', '2026-05-24', '2027-05-24', '76815057.pdf', '2026-05-31 18:36:24', '2026-05-31 21:01:45', NULL),
(60, 'MAMANI FARFAN MARTIR CHRISTIAN', '71027565', '26AR-LCI0007', '2026-05-24', '2027-05-24', '71027565.pdf', '2026-05-31 18:46:38', '2026-05-31 21:02:06', NULL),
(61, 'MAMANI POCCOHUANCA EDWIN', '73704899 ', '26AR-LCI0008', '2026-05-24', '2027-05-24', '73704899 .pdf', '2026-05-31 18:51:26', '2026-05-31 21:02:33', NULL),
(62, 'HUAMAN  CANALES  PAUL  TOMY', '91209017 ', '26AR-LCI0009', '2026-05-24', '2027-05-24', '91209017 .pdf', '2026-05-31 18:57:23', '2026-05-31 21:02:58', NULL),
(63, 'QUISPE  JARPA  JHONATAN  RICHARD', '76059781', '26AR-LCI0010', '2026-05-24', '2027-05-24', '76059781.pdf', '2026-05-31 19:02:38', '2026-05-31 21:03:20', NULL),
(64, 'CCANCCAPA  CHURA  KATERIN YESSY', '77353402', '26AR-LCI0011', '2026-05-24', '2027-05-24', '77353402.pdf', '2026-05-31 19:07:16', '2026-05-31 21:03:44', NULL),
(65, 'PERALTA  HUMALLA  YONY  ELIAS', '70389747', '26AR-LCI0012', '2026-05-24', '2027-05-24', '70389747.pdf', '2026-05-31 19:11:53', '2026-05-31 21:04:16', NULL),
(66, 'GUERRA PANDURO GEANMARCO', '76613223', '26AR-PA0054', '2026-05-31', '2027-05-31', '76613223_26AR-PA0054.pdf', '2026-06-03 18:42:03', '2026-06-03 18:42:03', NULL),
(67, 'MAMANI CHAYÑA WILIAN YUNIOR', '74081570', '26AR-PA0001', '2026-04-12', '2027-04-12', '74081570_26AR-PA0001.pdf', '2026-06-03 18:47:53', '2026-06-03 18:47:53', NULL),
(68, 'GUERRA PANDURO GEANMARCO', '76613223', '26AR-PA0054', '2026-05-31', '2027-05-31', '76613223_26AR-PA0054.pdf', '2026-06-03 20:28:56', '2026-06-03 20:28:56', NULL),
(69, 'QUISPE CCARITA  OSCAR  MIGUEL', '77127682', '26AR-PA0055', '2026-05-31', '2027-05-31', '77127682_26AR-PA0055.pdf', '2026-06-03 20:35:56', '2026-06-03 20:35:56', NULL),
(70, 'JUAREZ CARMEN KERWIN JUNIOR', '72748199', '26AR-PA0056', '2026-05-31', '2027-05-31', '72748199.pdf', '2026-06-03 20:44:35', '2026-06-03 20:46:48', '2026-06-03 20:46:48'),
(71, 'JUAREZ CARMEN KERWIN JUNIOR', '72748199', '26AR-PA0056', '2026-05-31', '2027-05-31', '72748199_26AR-PA0056.pdf', '2026-06-03 20:48:31', '2026-06-03 20:48:31', NULL),
(72, 'CCANCCAPA RAMOS  ABSALÓN  RONY', '71893032', '26AR-PA0057', '2026-05-31', '2027-05-31', '71893032_26AR-PA0057.pdf', '2026-06-03 20:55:04', '2026-06-03 20:55:04', NULL),
(73, 'QUISPE VILCA DARIO MARCOS', '72289841', '26AR-PA0058', '2026-05-31', '2027-05-31', '72289841_26AR-PA0058.pdf', '2026-06-03 21:00:22', '2026-06-03 21:00:22', NULL);

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

--
-- Estructura de tabla para la tabla `tb_clientes`
--

CREATE TABLE `tb_clientes` (
  `id_cliente` int(11) NOT NULL,
  `nombre` varchar(100) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `sector` varchar(50) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `estado` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `tb_clientes` (`id_cliente`, `nombre`, `logo`, `sector`, `descripcion`, `estado`) VALUES
(1, 'Safety&Mining', 'safetymining.png', 'Mineria', 'Safety&Mining es una consultora peruana especializada en Seguridad y Salud Ocupacional para la industria minera pública y privada', 1),
(2, 'PACSI INGENIEROS', 'pacsi-ingenieros.jpeg', 'Mineria', 'PACSI INGENIEROS S.A.C. es una compañía que brinda servicios para el Sector Minero, Hidrocarburos y Construcción', 1),
(3, 'Hidrodiesel Peru', 'hidrodiesel-peru.jpeg', 'Hidrocarburos', 'Una empresa conformada por un equipo multidisciplinario de profesionales calificados en la elaboración e implementación de planes de seguridad.', 1),
(4, 'Kahintercorp', 'kahintercorp.jpeg', 'Construcción', 'Empresa dedicada a la construcción de edificios.', 1),
(5, 'sostenimiento y voladura', 'sostenimiento-y-voladura.jpeg', 'Mineria', 'Empresa especializada en sostenimiento y voladura para minería y construcción civil', 1);

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

--
-- Estructura de tabla para la tabla `tb_personal`
--

CREATE TABLE `tb_personal` (
  `id_personal` int(11) NOT NULL,
  `nombre` varchar(150) NOT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `colegiatura` varchar(50) DEFAULT NULL,
  `perfil_profesional` text DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `linkedin_url` varchar(255) DEFAULT NULL,
  `estado` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `tb_personal` (`id_personal`, `nombre`, `cargo`, `colegiatura`, `perfil_profesional`, `foto`, `linkedin_url`, `estado`) VALUES
(1, 'Paul Arce Pachari', 'Instructor / Ingeniero Industrial', '297968', 'Ingeniero Industrial con experiencia en Gestión de Seguridad y Salud en el Trabajo, enfocado en la prevención de riesgos, supervisión de operaciones y cumplimiento de normas de seguridad. Cuenta con conocimientos en identificación de peligros, evaluación de riesgos, capacitaciones al personal e implementación de medidas preventivas orientadas a proteger a los trabajadores y garantizar ambientes laborales seguros y eficientes.', '1780206805_6b3db8765642f1cf5b5b.jpg', 'https://www.linkedin.com/in/paul-arce-pachari/', 1);

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

--
-- Estructura de tabla para la tabla `tb_servicios_detalle`
--

CREATE TABLE `tb_servicios_detalle` (
  `id_servicio` int(11) NOT NULL,
  `id_personal` int(11) DEFAULT NULL,
  `slug` varchar(100) NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `subtitulo` varchar(255) DEFAULT NULL,
  `descripcion_corta` text DEFAULT NULL,
  `teoria_completa` longtext DEFAULT NULL,
  `imagen_principal` varchar(255) DEFAULT NULL,
  `normativa` varchar(255) DEFAULT NULL,
  `certificacion` varchar(255) DEFAULT NULL,
  `duracion` varchar(100) DEFAULT NULL,
  `modalidad` varchar(50) DEFAULT NULL,
  `costo` decimal(10,2) DEFAULT 0.00,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `campos_extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`campos_extra`)),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `tb_servicios_detalle` (`id_servicio`, `id_personal`, `slug`, `titulo`, `subtitulo`, `descripcion_corta`, `teoria_completa`, `imagen_principal`, `normativa`, `certificacion`, `duracion`, `modalidad`, `costo`, `meta_title`, `meta_description`, `campos_extra`, `updated_at`) VALUES
(1, 1, 'primeros-auxilios', 'Primeros Auxilios', 'capacitación en Primeros Auxilios.', 'Curso práctico de primeros auxilios orientado a brindar conocimientos básicos para actuar de manera rápida y segura ante emergencias en el entorno laboral. Los participantes aprenderán técnicas esenciales de atención inmediata, evaluación inicial del paciente y respuesta frente a accidentes comunes, priorizando la protección de la vida hasta la llegada de asistencia especializada.', '<p><strong>Modalidad</strong></p>\r\n\r\n<p>Curso autogestionado dise&ntilde;ado para que cada participante avance a su propio ritmo. El contenido estar&aacute; disponible en la plataforma virtual, permitiendo acceder en cualquier momento desde cualquier dispositivo. El participante podr&aacute; revisar las lecciones, materiales complementarios y rendir la evaluaci&oacute;n final seg&uacute;n su disponibilidad.</p>\r\n\r\n<p><strong>Certificaci&oacute;n</strong></p>\r\n\r\n<p>Al finalizar el curso y aprobar la evaluaci&oacute;n correspondiente, el participante recibir&aacute; un certificado digital de participaci&oacute;n y aprobaci&oacute;n, v&aacute;lido como constancia de capacitaci&oacute;n en primeros auxilios.</p>\r\n\r\n<p><strong>Beneficios</strong></p>\r\n\r\n<ul>\r\n	<li>Acceso al curso 100% virtual y disponible en cualquier momento.</li>\r\n	<li>Avance flexible seg&uacute;n el ritmo de aprendizaje del participante.</li>\r\n	<li>Formaci&oacute;n pr&aacute;ctica enfocada en situaciones reales de emergencia.</li>\r\n	<li>Desarrollo de habilidades para actuar de forma r&aacute;pida y segura ante accidentes.</li>\r\n	<li>Evaluaci&oacute;n final disponible dentro de la plataforma.</li>\r\n	<li>Certificaci&oacute;n digital al finalizar satisfactoriamente el curso</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n', '1779676302_373982aab023c550c9bf.png', 'Anexo 6', '', '8 horas', '', 120.00, NULL, '', NULL, '2026-05-24 21:59:05');

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

--
-- Estructura de tabla para la tabla `tb_usuarios`
--

CREATE TABLE `tb_usuarios` (
  `id_usuario` int(11) NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `apellidos` varchar(100) NOT NULL,
  `dni` varchar(20) NOT NULL,
  `telefono` varchar(20) DEFAULT NULL,
  `imagen` varchar(255) DEFAULT NULL,
  `fecha_registro` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `tb_usuarios` (`id_usuario`, `user_id`, `nombre`, `apellidos`, `dni`, `telefono`, `imagen`, `fecha_registro`, `deleted_at`, `updated_at`) VALUES
(1, 1, 'Ronald', 'Chacondori', '23232323', '987654321', 'uploads/imagenes/1749698715_11358bde419d40304125.png', '2025-03-16 07:55:32', NULL, '2025-06-11 22:25:15'),
(3, 57, 'Ronald', 'Ronald', '23232323', '987654321', 'uploads/imagenes/1749698728_59c9e3b6feface6804f6.png', '2025-03-17 00:00:40', NULL, '2025-06-11 22:31:03'),
(4, 59, 'sofia123', 'sofia', '14141414', '987654321', '', '2025-03-17 00:45:22', '2025-03-18 23:19:06', '2025-03-18 23:19:06'),
(5, 58, 'darkness', 'dark', '34343434', '987654321', 'uploads/imagenes/1742347585_7e3e2a0006e5b7c3338c.jpg', '2025-03-18 20:25:58', '2025-03-18 23:27:14', '2025-03-18 23:27:14'),
(6, 60, 'ssofia', 'ssofia', '45454545', '987654321', 'uploads/imagenes/1742358959_6d1c5afa88dcd5276d14.jpg', '2025-03-18 23:35:59', '2025-03-18 23:36:08', '2025-03-18 23:36:08'),
(7, 61, 'test4', 'test6', '23232323', '987654321', 'uploads/imagenes/1749698748_ff94012f7e1f56a2b4c5.png', '2025-03-18 23:40:13', NULL, '2025-06-11 22:25:48');

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

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE `users` (
  `id` int(11) UNSIGNED NOT NULL,
  `username` varchar(30) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `status_message` varchar(255) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `last_active` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `username`, `status`, `status_message`, `active`, `last_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'admin', NULL, NULL, 1, NULL, '2025-02-25 10:46:08', '2025-06-11 22:25:15', NULL),
(57, 'supervisor', NULL, NULL, 1, NULL, '2025-03-16 23:22:35', '2025-06-11 22:31:03', NULL),
(58, 'Darkness', NULL, NULL, 1, NULL, '2025-03-17 00:37:42', '2025-03-18 23:27:14', '2025-03-18 23:27:14'),
(59, 'sofia23', NULL, NULL, 1, NULL, '2025-03-17 00:45:22', '2025-03-18 23:19:06', '2025-03-18 23:19:06'),
(60, 'ssofia', NULL, NULL, 1, NULL, '2025-03-18 23:35:59', '2025-03-18 23:36:08', '2025-03-18 23:36:08'),
(61, 'test6', NULL, NULL, 1, NULL, '2025-03-18 23:40:12', '2025-06-11 22:25:48', NULL);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `auth_groups`
--
ALTER TABLE `auth_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indices de la tabla `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auth_groups_users_user_id_foreign` (`user_id`);

--
-- Indices de la tabla `auth_identities`
--
ALTER TABLE `auth_identities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `type_secret` (`type`,`secret`),
  ADD KEY `user_id` (`user_id`);

--
-- Indices de la tabla `auth_logins`
--
ALTER TABLE `auth_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_type_identifier` (`id_type`,`identifier`),
  ADD KEY `user_id` (`user_id`);

--
-- Indices de la tabla `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auth_permissions_users_user_id_foreign` (`user_id`);

--
-- Indices de la tabla `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `selector` (`selector`),
  ADD KEY `auth_remember_tokens_user_id_foreign` (`user_id`);

--
-- Indices de la tabla `auth_token_logins`
--
ALTER TABLE `auth_token_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_type_identifier` (`id_type`,`identifier`),
  ADD KEY `user_id` (`user_id`);

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

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

--
-- Indices de la tabla `tb_certificados`
--
ALTER TABLE `tb_certificados`
  ADD PRIMARY KEY (`id_certificado`);

--
-- Indices de la tabla `tb_clientes`
--
ALTER TABLE `tb_clientes`
  ADD PRIMARY KEY (`id_cliente`);

--
-- Indices de la tabla `tb_personal`
--
ALTER TABLE `tb_personal`
  ADD PRIMARY KEY (`id_personal`);

--
-- Indices de la tabla `tb_servicios_detalle`
--
ALTER TABLE `tb_servicios_detalle`
  ADD PRIMARY KEY (`id_servicio`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `id_personal` (`id_personal`);

--
-- Indices de la tabla `tb_usuarios`
--
ALTER TABLE `tb_usuarios`
  ADD PRIMARY KEY (`id_usuario`),
  ADD UNIQUE KEY `user_id` (`user_id`);

--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

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

--
-- AUTO_INCREMENT de la tabla `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT de la tabla `auth_identities`
--
ALTER TABLE `auth_identities`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT de la tabla `auth_logins`
--
ALTER TABLE `auth_logins`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=189;

--
-- AUTO_INCREMENT de la tabla `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de la tabla `auth_token_logins`
--
ALTER TABLE `auth_token_logins`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(9) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tb_certificados`
--
ALTER TABLE `tb_certificados`
  MODIFY `id_certificado` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT de la tabla `tb_clientes`
--
ALTER TABLE `tb_clientes`
  MODIFY `id_cliente` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `tb_personal`
--
ALTER TABLE `tb_personal`
  MODIFY `id_personal` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `tb_servicios_detalle`
--
ALTER TABLE `tb_servicios_detalle`
  MODIFY `id_servicio` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `tb_usuarios`
--
ALTER TABLE `tb_usuarios`
  MODIFY `id_usuario` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  ADD CONSTRAINT `auth_groups_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `auth_identities`
--
ALTER TABLE `auth_identities`
  ADD CONSTRAINT `auth_identities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  ADD CONSTRAINT `auth_permissions_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  ADD CONSTRAINT `auth_remember_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tb_servicios_detalle`
--
ALTER TABLE `tb_servicios_detalle`
  ADD CONSTRAINT `tb_servicios_detalle_ibfk_1` FOREIGN KEY (`id_personal`) REFERENCES `tb_personal` (`id_personal`);

--
-- Filtros para la tabla `tb_usuarios`
--
ALTER TABLE `tb_usuarios`
  ADD CONSTRAINT `fk_tb_usuarios_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

