text: -- phpMyAdmin SQL Dump
  -- version 4.7.4
  -- https://www.phpmyadmin.net/
  --
  -- Servidor: 127.0.0.1
  -- Tiempo de generación: 30-11-2020 a las 20:15:04
  -- Versión del servidor: 10.1.26-MariaDB
  -- Versión de PHP: 7.1.9
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  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: `estres`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `alumnos`
  --
  
  CREATE TABLE `alumnos` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `nombres` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `apellidos` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `cuestionarios`
  --
  
  CREATE TABLE `cuestionarios` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `respuesta_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_10` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_11` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `respuesta_12` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `total` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_at` date NOT NULL,
    `user_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (23, '2019_07_03_170109_create_role_users_table', 2),
  (49, '2019_09_05_165404_create_respuestas_table', 6),
  (50, '2019_09_05_170641_create_respuestas_table', 7),
  (57, '2019_07_08_215913_create_role_users_table', 8),
  (65, '2019_10_08_195851_create_tipos_table', 9),
  (69, '2014_10_12_000000_create_users_table', 10),
  (70, '2014_10_12_100000_create_password_resets_table', 10),
  (71, '2019_07_02_210139_create_alumnos_table', 10),
  (72, '2019_07_03_165604_create_roles_table', 10),
  (73, '2019_07_03_170109_create_role_user_table', 10),
  (74, '2019_09_09_163043_create_respuestas_table', 10),
  (75, '2019_10_08_200420_create_usuarios_table', 10),
  (76, '2019_10_08_205446_create_cuestionarios_table', 10),
  (77, '2019_10_08_205507_create_seguimientos_table', 10);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `roles`
  --
  
  CREATE TABLE `roles` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `roles`
  --
  
  INSERT INTO `roles` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
  (1, 'admin', 'Administrador', '2019-10-15 07:14:45', '2019-10-15 07:14:45'),
  (2, 'user', 'User', '2019-10-15 07:14:45', '2019-10-15 07:14:45');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `role_user`
  --
  
  CREATE TABLE `role_user` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `role_user`
  --
  
  INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`) VALUES
  (1, 2, 1, '2019-10-15 07:14:46', '2019-10-15 07:14:46'),
  (2, 1, 2, '2019-10-15 07:14:46', '2019-10-15 07:14:46');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `seguimientos`
  --
  
  CREATE TABLE `seguimientos` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `usuarios_id` bigint(20) UNSIGNED NOT NULL,
    `cuestionarios_id` bigint(20) UNSIGNED NOT NULL,
    `created_at` date NOT NULL,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tipos`
  --
  
  CREATE TABLE `tipos` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `tipos`
  --
  
  INSERT INTO `tipos` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, 'Docente', NULL, NULL),
  (2, 'Administrativo', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `users`
  --
  
  CREATE TABLE `users` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'User', 'user@example.com', NULL, '$2y$10$BsDbnmjH.gICkuZ6YLNQpOE7H9xAg1Cczwr1SfAYWv8Ly6ajV/faS', NULL, '2019-10-15 07:14:46', '2019-10-15 07:14:46'),
  (2, 'Admin', 'admin@example.com', NULL, '$2y$10$PDohv4QauT5vJtRmUGrimeFU8XNexCstmzXsHbQCJbVCq80GNMZxa', NULL, '2019-10-15 07:14:46', '2019-10-15 07:14:46');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `usuarios`
  --
  
  CREATE TABLE `usuarios` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `nombre` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `apellido_paterno` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `apellido_materno` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `tipos_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `usuarios`
  --
  
  INSERT INTO `usuarios` (`id`, `nombre`, `apellido_paterno`, `apellido_materno`, `tipos_id`, `user_name`, `password`, `created_at`, `updated_at`) VALUES
  (1, 'Ivette', 'Vazquez', 'vAZXCNZKJ', 'ADMINISTRATIVO', 'IVETTE', 'IVETTE', '2020-11-04 06:00:00', '2020-11-04 06:00:00');
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `alumnos`
  --
  ALTER TABLE `alumnos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `cuestionarios`
  --
  ALTER TABLE `cuestionarios`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indices de la tabla `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `role_user`
  --
  ALTER TABLE `role_user`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `seguimientos`
  --
  ALTER TABLE `seguimientos`
    ADD PRIMARY KEY (`id`),
    ADD KEY `seguimientos_usuarios_id_foreign` (`usuarios_id`),
    ADD KEY `seguimientos_cuestionarios_id_foreign` (`cuestionarios_id`);
  
  --
  -- Indices de la tabla `tipos`
  --
  ALTER TABLE `tipos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- Indices de la tabla `usuarios`
  --
  ALTER TABLE `usuarios`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `alumnos`
  --
  ALTER TABLE `alumnos`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `cuestionarios`
  --
  ALTER TABLE `cuestionarios`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=155;
  
  --
  -- AUTO_INCREMENT de la tabla `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
  
  --
  -- AUTO_INCREMENT de la tabla `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `role_user`
  --
  ALTER TABLE `role_user`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `seguimientos`
  --
  ALTER TABLE `seguimientos`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
  
  --
  -- AUTO_INCREMENT de la tabla `tipos`
  --
  ALTER TABLE `tipos`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `users`
  --
  ALTER TABLE `users`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `usuarios`
  --
  ALTER TABLE `usuarios`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- Restricciones para tablas volcadas
  --
  
  --
  -- Filtros para la tabla `seguimientos`
  --
  ALTER TABLE `seguimientos`
    ADD CONSTRAINT `seguimientos_cuestionarios_id_foreign` FOREIGN KEY (`cuestionarios_id`) REFERENCES `cuestionarios` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `seguimientos_usuarios_id_foreign` FOREIGN KEY (`usuarios_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  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 */;
  