-- phpMyAdmin SQL Dump -- version 4.9.3 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost:3306 -- Tiempo de generación: 21-06-2026 a las 22:36:55 -- Versión del servidor: 5.7.26 -- Versión de PHP: 7.4.1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `rkm7` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `audit_logs` -- CREATE TABLE `audit_logs` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `module` varchar(100) NOT NULL, `action` varchar(50) NOT NULL, `description` text, `ip_address` varchar(45) DEFAULT NULL, `created_at` datetime DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `mail_queue` -- CREATE TABLE `mail_queue` ( `id` int(10) UNSIGNED NOT NULL, `to_email` varchar(200) NOT NULL, `subject` varchar(200) NOT NULL, `body` text NOT NULL, `status` varchar(20) NOT NULL DEFAULT 'pending', `created_at` datetime DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `notifications` -- CREATE TABLE `notifications` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED DEFAULT NULL, `title` varchar(200) NOT NULL, `message` text NOT NULL, `channel` varchar(50) NOT NULL, `status` varchar(20) NOT NULL DEFAULT 'sent', `created_at` datetime DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `permissions` -- CREATE TABLE `permissions` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Volcado de datos para la tabla `permissions` -- INSERT INTO `permissions` (`id`, `name`) VALUES (1, 'dashboard_view'), (6, 'migrations_manage'), (2, 'notifications_view'), (3, 'permissions_manage'), (5, 'roles_manage'), (4, 'users_manage'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `roles` -- CREATE TABLE `roles` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Volcado de datos para la tabla `roles` -- INSERT INTO `roles` (`id`, `name`) VALUES (1, 'admin'), (2, 'user'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `role_permissions` -- CREATE TABLE `role_permissions` ( `id` int(10) UNSIGNED NOT NULL, `role_id` int(10) UNSIGNED NOT NULL, `permission_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Volcado de datos para la tabla `role_permissions` -- INSERT INTO `role_permissions` (`id`, `role_id`, `permission_id`) VALUES (1, 1, 1), (2, 1, 2), (3, 1, 3), (6, 1, 4), (5, 1, 5), (4, 1, 6), (7, 2, 1), (8, 2, 2); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(120) NOT NULL, `email` varchar(150) NOT NULL, `password_hash` varchar(255) NOT NULL, `role` varchar(50) NOT NULL DEFAULT 'user', `status` tinyint(4) NOT NULL DEFAULT '1', `created_at` datetime DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Volcado de datos para la tabla `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password_hash`, `role`, `status`, `created_at`) VALUES (1, 'Administrador', 'rjaquers@gmail.com', '$2y$10$UQaxZ0VQlPH5Hx./5xRy4.jl9.DJkCAu7eDfGlkSn9MZJlZpeN8ae', 'admin', 1, '2026-06-21 22:35:04'); -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `audit_logs` -- ALTER TABLE `audit_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_user_created` (`user_id`,`created_at`); -- -- Indices de la tabla `mail_queue` -- ALTER TABLE `mail_queue` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`), ADD KEY `idx_user_id` (`user_id`); -- -- Indices de la tabla `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`); -- -- Indices de la tabla `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`); -- -- Indices de la tabla `role_permissions` -- ALTER TABLE `role_permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_role_perm` (`role_id`,`permission_id`), ADD KEY `permission_id` (`permission_id`); -- -- Indices de la tabla `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `audit_logs` -- ALTER TABLE `audit_logs` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `mail_queue` -- ALTER TABLE `mail_queue` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `notifications` -- ALTER TABLE `notifications` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `permissions` -- ALTER TABLE `permissions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT de la tabla `roles` -- ALTER TABLE `roles` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT de la tabla `role_permissions` -- ALTER TABLE `role_permissions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT de la tabla `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Restricciones para tablas volcadas -- -- -- Filtros para la tabla `role_permissions` -- ALTER TABLE `role_permissions` ADD CONSTRAINT `role_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_permissions_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE; /*!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 */;