text: -- phpMyAdmin SQL Dump
  -- version 4.7.9
  -- https://www.phpmyadmin.net/
  --
  -- Servidor: localhost
  -- Tiempo de generación: 24-01-2019 a las 21:20:58
  -- Versión del servidor: 10.1.31-MariaDB
  -- Versión de PHP: 7.2.3
  
  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: `ultra_portal`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `buildings`
  --
  
  CREATE TABLE `buildings` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `categories`
  --
  
  CREATE TABLE `categories` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `days`
  --
  
  CREATE TABLE `days` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `days`
  --
  
  INSERT INTO `days` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, 'Lunes', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (2, 'Martes', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (3, 'Miercoles', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (4, 'Jueves', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (5, 'Viernes', '2019-01-09 10:31:27', '2019-01-09 10:31:27');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `day_subject`
  --
  
  CREATE TABLE `day_subject` (
    `id` int(10) UNSIGNED NOT NULL,
    `subject_id` int(10) UNSIGNED NOT NULL,
    `day_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `day_subject`
  --
  
  INSERT INTO `day_subject` (`id`, `subject_id`, `day_id`, `created_at`, `updated_at`) VALUES
  (5, 1, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (6, 2, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (7, 3, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (8, 4, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (9, 5, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (10, 6, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (11, 7, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (12, 8, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (13, 9, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (14, 10, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (15, 11, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (16, 12, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (17, 13, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (18, 14, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (19, 15, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (20, 16, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (21, 17, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (22, 18, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (23, 19, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (24, 20, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (25, 21, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (26, 22, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (27, 23, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (28, 24, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (29, 25, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (30, 26, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (36, 27, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (37, 28, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (38, 29, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (39, 30, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (40, 31, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (41, 32, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (42, 33, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (43, 34, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (44, 35, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (45, 36, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (46, 37, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (47, 38, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (48, 39, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (49, 40, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (50, 41, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (51, 42, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (52, 43, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (53, 44, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (54, 45, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (55, 46, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (56, 47, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (57, 48, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12'),
  (58, 49, 5, '2019-01-22 10:06:12', '2019-01-22 10:06:12');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `departments`
  --
  
  CREATE TABLE `departments` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `departments`
  --
  
  INSERT INTO `departments` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, ' Root Department', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (2, 'No asignable', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (3, 'Direccion Afterschool', '2019-01-07 12:16:16', '2019-01-07 12:16:16');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `department_section`
  --
  
  CREATE TABLE `department_section` (
    `id` int(10) UNSIGNED NOT NULL,
    `department_id` int(10) UNSIGNED NOT NULL,
    `section_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `department_section`
  --
  
  INSERT INTO `department_section` (`id`, `department_id`, `section_id`, `created_at`, `updated_at`) VALUES
  (1, 1, 1, NULL, NULL),
  (2, 2, 2, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `employees`
  --
  
  CREATE TABLE `employees` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `specific_position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `employees`
  --
  
  INSERT INTO `employees` (`id`, `user_id`, `specific_position`, `created_at`, `updated_at`) VALUES
  (1, 1, 'Techonology', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (2, 3, 'Docente', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (3, 4, 'Docente', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (4, 6, 'Directora Aftershool', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (5, 7, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (6, 8, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (7, 9, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (8, 10, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (9, 11, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (10, 12, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (11, 13, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (12, 14, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (13, 15, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (14, 16, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (15, 17, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (16, 18, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (17, 19, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (18, 20, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (19, 21, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (20, 22, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (21, 23, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (22, 24, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (23, 25, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (24, 26, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (25, 27, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (26, 28, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (27, 29, 'Docente', '2019-01-07 12:16:16', '2019-01-07 12:16:16');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2013_11_27_210400_create_sections_table', 1),
  (2, '2014_09_04_210309_create_departments_table', 1),
  (3, '2014_09_04_222418_create_department_section_table', 1),
  (4, '2014_10_12_000000_create_users_table', 1),
  (5, '2014_10_12_100000_create_password_resets_table', 1),
  (6, '2018_11_26_195711_create_status_table', 1),
  (7, '2018_11_26_225049_create_employees_table', 1),
  (8, '2018_11_27_030045_create_roles_table', 1),
  (9, '2018_12_03_153323_create_students_table', 1),
  (10, '2018_12_04_192155_create_role_user_table', 1),
  (11, '2018_12_04_194813_create_places_table', 1),
  (12, '2018_12_04_194908_create_buildings_table', 1),
  (13, '2018_12_04_194958_create_place_building_table', 1),
  (14, '2018_12_04_200504_create_user_status_table', 1),
  (15, '2018_12_04_201038_create_tags_table', 1),
  (16, '2018_12_04_201146_create_years_table', 1),
  (17, '2018_12_04_201147_create_categories_table', 1),
  (18, '2018_12_04_201148_create_tickets_table', 1),
  (19, '2018_12_04_201149_create_ticket_user_table', 1),
  (20, '2018_12_04_201302_create_ticket_tag_table', 1),
  (21, '2018_12_04_201602_create_ticket_category_table', 1),
  (22, '2019_01_07_174219_create_rooms_table', 1),
  (23, '2019_01_07_175900_create_workshops_table', 1),
  (24, '2019_01_07_180115_create_days_table', 1),
  (25, '2019_01_07_182147_create_subjects_table', 1),
  (26, '2019_01_08_145830_table_workshop_enrollment', 1),
  (27, '2019_01_08_153703_table_plans', 1),
  (28, '2019_01_08_154141_table_plan_subject', 1),
  (29, '2019_01_08_154321_table_plan_student', 1),
  (30, '2019_01_10_184312_create_day_subject_table', 2),
  (35, '2019_01_13_060943_create_workshop_temps_table', 3);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `places`
  --
  
  CREATE TABLE `places` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `place_building`
  --
  
  CREATE TABLE `place_building` (
    `id` int(10) UNSIGNED NOT NULL,
    `place_id` int(10) UNSIGNED NOT NULL,
    `building_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `plans`
  --
  
  CREATE TABLE `plans` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `plans`
  --
  
  INSERT INTO `plans` (`id`, `name`, `alias`, `created_at`, `updated_at`) VALUES
  (1, 'Elementary 2A', 'E2A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (2, 'Elementary 2B', 'E2B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (3, 'Elementary 2C', 'E2C', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (4, 'Elementary 2D', 'E2D', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (5, 'Elementary 3A', 'E3A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (6, 'Elementary 3B', 'E3B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (7, 'Elementary 3C', 'E3C', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (8, 'Elementary 4A', 'E4A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (9, 'Elementary 4B', 'E4B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (10, 'Elementary 4C', 'E4C', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (11, 'Elementary 5A', 'E5A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (12, 'Elementary 5B', 'E5B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (13, 'Elementary 5C', 'E5C', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (14, 'Elementary 5D', 'E5D', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (15, 'Middle School 6A', 'MD6A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (16, 'Middle School 6B', 'MD6B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (17, 'Middle School 6C', 'MD6C', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (18, 'Middle School 7A', 'MD7A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (19, 'Middle School 7B', 'MD7B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (20, 'Middle School 7C', 'MD7C', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (21, 'Middle School 8A', 'MD8A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (22, 'Middle School 8B', 'MD8B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (23, 'Middle School 8C', 'MD8C', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (24, 'Middle School 9A', 'MD9A', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (25, 'Middle School 9B', 'MD9B', '2019-01-09 10:31:54', '2019-01-09 10:31:54'),
  (26, 'Middle School 9C', 'MD9C', '2019-01-09 10:31:54', '2019-01-09 10:31:54');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `plan_student`
  --
  
  CREATE TABLE `plan_student` (
    `id` int(10) UNSIGNED NOT NULL,
    `plan_id` int(10) UNSIGNED NOT NULL,
    `matricula` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `plan_student`
  --
  
  INSERT INTO `plan_student` (`id`, `plan_id`, `matricula`, `created_at`, `updated_at`) VALUES
  (1, 1, '13-0030-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 1, '13-0057-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 1, '13-0079-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 1, '13-0127-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 1, '13-0177-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 1, '13-0182-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 1, '13-0233-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 1, '13-0352-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 1, '13-0369-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 1, '14-0057-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (11, 1, '16-0332-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (12, 1, '16-0343-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (13, 1, '16-0348-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (14, 1, '16-0358-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (15, 1, '16-0367-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (16, 1, '16-0369-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (17, 1, '16-0388-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (18, 1, '16-0437-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (19, 1, '17-0707-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (20, 1, '17-0808-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (21, 1, '18-1007-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (22, 1, '18-1044-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (23, 2, '13-0036-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (24, 2, '13-0081-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (25, 2, '13-0114-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (26, 2, '13-0248-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (27, 2, '13-0263-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (28, 2, '13-0313-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (29, 2, '13-0342-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (30, 2, '13-0345-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (31, 2, '14-0005-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (32, 2, '14-0049-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (33, 2, '14-0096-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (34, 2, '15-0177-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (35, 2, '15-0194-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (36, 2, '15-0201-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (37, 2, '16-0308-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (38, 2, '16-0311-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (39, 2, '16-0314-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (40, 2, '16-0384-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (41, 2, '16-0410-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (42, 2, '17-0721-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (43, 2, '18-0943-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (44, 2, '18-1014-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (45, 2, '18-1027-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `plan_subject`
  --
  
  CREATE TABLE `plan_subject` (
    `id` int(10) UNSIGNED NOT NULL,
    `plan_id` int(10) UNSIGNED NOT NULL,
    `subject_id` int(10) UNSIGNED NOT NULL,
    `quota` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `plan_subject`
  --
  
  INSERT INTO `plan_subject` (`id`, `plan_id`, `subject_id`, `quota`) VALUES
  (1, 1, 1, 2),
  (2, 1, 2, 2),
  (3, 1, 3, 3),
  (4, 1, 4, 2),
  (5, 1, 5, 2),
  (6, 1, 6, 2),
  (7, 1, 7, 3),
  (8, 1, 8, 3),
  (9, 1, 9, 2),
  (10, 1, 10, 2),
  (11, 1, 11, 2),
  (12, 1, 12, 2),
  (13, 1, 13, 4),
  (14, 1, 14, 2),
  (15, 1, 15, 2),
  (16, 1, 16, 2),
  (17, 2, 1, 2),
  (18, 2, 2, 2),
  (19, 2, 3, 3),
  (20, 2, 4, 2),
  (21, 2, 5, 2),
  (22, 2, 6, 2),
  (23, 2, 7, 3),
  (24, 2, 8, 3),
  (25, 2, 9, 2),
  (26, 2, 10, 2),
  (27, 2, 11, 2),
  (28, 2, 12, 2),
  (29, 2, 13, 4),
  (30, 2, 14, 2),
  (31, 2, 15, 2),
  (32, 2, 16, 2),
  (33, 3, 1, 2),
  (34, 3, 2, 2),
  (35, 3, 3, 3),
  (36, 3, 4, 2),
  (37, 3, 5, 2),
  (38, 3, 6, 2),
  (39, 3, 7, 3),
  (40, 3, 8, 3),
  (41, 3, 9, 2),
  (42, 3, 10, 2),
  (43, 3, 11, 2),
  (44, 3, 12, 2),
  (45, 3, 13, 4),
  (46, 3, 14, 2),
  (47, 3, 15, 2),
  (48, 3, 16, 2),
  (49, 4, 1, 2),
  (50, 4, 2, 2),
  (51, 4, 3, 2),
  (52, 4, 4, 2),
  (53, 4, 5, 2),
  (54, 4, 6, 2),
  (55, 4, 7, 3),
  (56, 4, 8, 3),
  (57, 4, 9, 2),
  (58, 4, 10, 2),
  (59, 4, 11, 2),
  (60, 4, 12, 2),
  (61, 4, 13, 4),
  (62, 4, 14, 2),
  (63, 4, 15, 3),
  (64, 4, 16, 2),
  (65, 5, 1, 2),
  (66, 5, 2, 4),
  (67, 5, 3, 3),
  (68, 5, 4, 2),
  (69, 5, 5, 3),
  (70, 5, 6, 3),
  (71, 5, 7, 3),
  (72, 5, 8, 2),
  (73, 5, 9, 2),
  (74, 5, 10, 2),
  (75, 5, 11, 2),
  (76, 5, 12, 2),
  (77, 5, 48, 4),
  (78, 5, 14, 2),
  (79, 5, 15, 3),
  (80, 5, 16, 3),
  (81, 6, 1, 2),
  (82, 6, 2, 3),
  (83, 6, 3, 3),
  (84, 6, 4, 3),
  (85, 6, 5, 2),
  (86, 6, 6, 3),
  (87, 6, 7, 4),
  (88, 6, 8, 2),
  (89, 6, 9, 2),
  (90, 6, 10, 2),
  (91, 6, 11, 2),
  (92, 6, 12, 2),
  (93, 6, 48, 4),
  (94, 6, 14, 2),
  (95, 6, 15, 2),
  (96, 6, 16, 4),
  (97, 7, 1, 2),
  (98, 7, 2, 3),
  (99, 7, 3, 3),
  (100, 7, 4, 3),
  (101, 7, 5, 3),
  (102, 7, 6, 2),
  (103, 7, 7, 3),
  (104, 7, 8, 2),
  (105, 7, 9, 2),
  (106, 7, 10, 2),
  (107, 7, 11, 2),
  (108, 7, 12, 2),
  (109, 7, 48, 4),
  (110, 7, 14, 2),
  (111, 7, 15, 2),
  (112, 7, 16, 4),
  (113, 8, 17, 2),
  (114, 8, 18, 2),
  (115, 8, 19, 3),
  (116, 8, 20, 2),
  (117, 8, 21, 2),
  (118, 8, 22, 3),
  (119, 8, 23, 2),
  (120, 8, 24, 2),
  (121, 8, 25, 2),
  (122, 8, 26, 2),
  (123, 8, 27, 4),
  (124, 8, 28, 2),
  (125, 8, 29, 2),
  (126, 8, 30, 2),
  (127, 9, 17, 2),
  (128, 9, 18, 2),
  (129, 9, 19, 3),
  (130, 9, 20, 2),
  (131, 9, 21, 2),
  (132, 9, 22, 3),
  (133, 9, 23, 2),
  (134, 9, 24, 2),
  (135, 9, 25, 2),
  (136, 9, 26, 2),
  (137, 9, 27, 4),
  (138, 9, 28, 2),
  (139, 9, 29, 2),
  (140, 9, 30, 2),
  (141, 10, 17, 2),
  (142, 10, 18, 2),
  (143, 10, 19, 3),
  (144, 10, 20, 2),
  (145, 10, 21, 2),
  (146, 10, 22, 3),
  (147, 10, 23, 2),
  (148, 10, 24, 2),
  (149, 10, 25, 2),
  (150, 10, 26, 2),
  (151, 10, 27, 4),
  (152, 10, 28, 2),
  (153, 10, 29, 2),
  (154, 10, 30, 2),
  (155, 11, 17, 3),
  (156, 11, 18, 3),
  (157, 11, 19, 3),
  (158, 11, 20, 3),
  (159, 11, 21, 2),
  (160, 11, 22, 4),
  (161, 11, 23, 2),
  (162, 11, 24, 2),
  (163, 11, 25, 2),
  (164, 11, 26, 2),
  (165, 11, 49, 4),
  (166, 11, 28, 2),
  (167, 11, 29, 2),
  (168, 11, 30, 3),
  (169, 12, 17, 3),
  (170, 12, 18, 3),
  (171, 12, 19, 3),
  (172, 12, 20, 3),
  (173, 12, 21, 2),
  (174, 12, 22, 3),
  (175, 12, 23, 2),
  (176, 12, 24, 2),
  (177, 12, 25, 2),
  (178, 12, 26, 2),
  (179, 12, 49, 4),
  (180, 12, 28, 2),
  (181, 12, 29, 2),
  (182, 12, 30, 3),
  (183, 13, 17, 3),
  (184, 13, 18, 3),
  (185, 13, 19, 3),
  (186, 13, 20, 3),
  (187, 13, 21, 2),
  (188, 13, 22, 3),
  (189, 13, 23, 2),
  (190, 13, 24, 2),
  (191, 13, 25, 2),
  (192, 13, 26, 2),
  (193, 13, 49, 4),
  (194, 13, 28, 2),
  (195, 13, 29, 2),
  (196, 13, 30, 3),
  (197, 14, 17, 3),
  (198, 14, 18, 3),
  (199, 14, 19, 3),
  (200, 14, 20, 3),
  (201, 14, 21, 2),
  (202, 14, 22, 3),
  (203, 14, 23, 2),
  (204, 14, 24, 2),
  (205, 14, 25, 2),
  (206, 14, 26, 2),
  (207, 14, 49, 4),
  (208, 14, 28, 2),
  (209, 14, 29, 2),
  (210, 14, 30, 3),
  (211, 15, 31, 1),
  (212, 15, 32, 2),
  (213, 15, 33, 2),
  (214, 15, 34, 2),
  (215, 15, 35, 2),
  (216, 15, 36, 2),
  (217, 15, 37, 3),
  (218, 15, 38, 2),
  (219, 15, 39, 2),
  (220, 15, 40, 2),
  (221, 15, 41, 3),
  (222, 15, 42, 1),
  (223, 15, 43, 2),
  (224, 15, 44, 2),
  (225, 15, 45, 2),
  (226, 16, 31, 2),
  (227, 16, 32, 2),
  (228, 16, 33, 1),
  (229, 16, 34, 2),
  (230, 16, 35, 1),
  (231, 16, 36, 2),
  (232, 16, 37, 3),
  (233, 16, 38, 2),
  (234, 16, 39, 2),
  (235, 16, 40, 2),
  (236, 16, 41, 3),
  (237, 16, 42, 2),
  (238, 16, 43, 2),
  (239, 16, 44, 2),
  (240, 16, 45, 2),
  (241, 17, 31, 1),
  (242, 17, 32, 2),
  (243, 17, 33, 2),
  (244, 17, 34, 2),
  (245, 17, 35, 2),
  (246, 17, 36, 2),
  (247, 17, 37, 3),
  (248, 17, 38, 2),
  (249, 17, 39, 2),
  (250, 17, 40, 2),
  (251, 17, 41, 2),
  (252, 17, 42, 1),
  (253, 17, 43, 2),
  (254, 17, 44, 2),
  (255, 17, 45, 2),
  (256, 18, 31, 2),
  (257, 18, 32, 2),
  (258, 18, 33, 1),
  (259, 18, 34, 2),
  (260, 18, 35, 2),
  (261, 18, 36, 2),
  (262, 18, 37, 3),
  (263, 18, 38, 1),
  (264, 18, 39, 1),
  (265, 18, 40, 2),
  (266, 18, 41, 3),
  (267, 18, 42, 2),
  (268, 18, 43, 1),
  (269, 18, 44, 2),
  (270, 18, 45, 2),
  (271, 19, 31, 1),
  (272, 19, 32, 2),
  (273, 19, 33, 2),
  (274, 19, 34, 2),
  (275, 19, 35, 1),
  (276, 19, 36, 2),
  (277, 19, 37, 3),
  (278, 19, 38, 1),
  (279, 19, 39, 1),
  (280, 19, 40, 2),
  (281, 19, 41, 3),
  (282, 19, 42, 1),
  (283, 19, 43, 1),
  (284, 19, 44, 2),
  (285, 19, 45, 2),
  (286, 20, 31, 1),
  (287, 20, 32, 2),
  (288, 20, 33, 2),
  (289, 20, 34, 2),
  (290, 20, 35, 1),
  (291, 20, 36, 2),
  (292, 20, 37, 3),
  (293, 20, 38, 1),
  (294, 20, 39, 1),
  (295, 20, 40, 2),
  (296, 20, 41, 3),
  (297, 20, 42, 1),
  (298, 20, 43, 1),
  (299, 20, 44, 2),
  (300, 20, 45, 2),
  (301, 21, 31, 1),
  (302, 21, 32, 2),
  (303, 21, 33, 2),
  (304, 21, 34, 2),
  (305, 21, 35, 2),
  (306, 21, 36, 2),
  (307, 21, 46, 3),
  (308, 21, 38, 2),
  (309, 21, 39, 1),
  (310, 21, 40, 2),
  (311, 21, 47, 3),
  (312, 21, 42, 1),
  (313, 21, 43, 1),
  (314, 21, 44, 2),
  (315, 21, 45, 2),
  (316, 22, 31, 1),
  (317, 22, 32, 2),
  (318, 22, 33, 2),
  (319, 22, 34, 2),
  (320, 22, 35, 2),
  (321, 22, 36, 2),
  (322, 22, 46, 3),
  (323, 22, 38, 2),
  (324, 22, 39, 1),
  (325, 22, 40, 2),
  (326, 22, 47, 3),
  (327, 22, 42, 1),
  (328, 22, 43, 1),
  (329, 22, 44, 2),
  (330, 22, 45, 2),
  (331, 23, 31, 1),
  (332, 23, 32, 2),
  (333, 23, 33, 2),
  (334, 23, 34, 2),
  (335, 23, 35, 2),
  (336, 23, 36, 2),
  (337, 23, 46, 2),
  (338, 23, 38, 2),
  (339, 23, 39, 1),
  (340, 23, 40, 2),
  (341, 23, 47, 3),
  (342, 23, 42, 1),
  (343, 23, 43, 1),
  (344, 23, 44, 2),
  (345, 23, 45, 2),
  (346, 24, 31, 1),
  (347, 24, 32, 2),
  (348, 24, 33, 2),
  (349, 24, 34, 2),
  (350, 24, 35, 2),
  (351, 24, 36, 2),
  (352, 24, 46, 3),
  (353, 24, 38, 2),
  (354, 24, 39, 1),
  (355, 24, 40, 2),
  (356, 24, 47, 3),
  (357, 24, 42, 1),
  (358, 24, 43, 1),
  (359, 24, 44, 2),
  (360, 24, 45, 2),
  (361, 25, 31, 1),
  (362, 25, 32, 2),
  (363, 25, 33, 2),
  (364, 25, 34, 2),
  (365, 25, 35, 2),
  (366, 25, 36, 2),
  (367, 25, 46, 3),
  (368, 25, 38, 2),
  (369, 25, 39, 1),
  (370, 25, 40, 2),
  (371, 25, 47, 3),
  (372, 25, 42, 1),
  (373, 25, 43, 1),
  (374, 25, 44, 2),
  (375, 25, 45, 2),
  (376, 26, 31, 1),
  (377, 26, 32, 2),
  (378, 26, 33, 2),
  (379, 26, 34, 2),
  (380, 26, 35, 2),
  (381, 26, 36, 2),
  (382, 26, 46, 2),
  (383, 26, 38, 2),
  (384, 26, 39, 1),
  (385, 26, 40, 2),
  (386, 26, 47, 3),
  (387, 26, 42, 1),
  (388, 26, 43, 1),
  (389, 26, 44, 2),
  (390, 26, 45, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `roles`
  --
  
  CREATE TABLE `roles` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `roles`
  --
  
  INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES
  (1, 'root', 'Root', 'Administrador completo del sitio', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (2, 'docente', 'Docente', 'Usuario de tipo Docente', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (3, 'estandar', 'Estandar', 'Panel de vistas', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (4, 'admin', 'Administrador', 'Administrador para usuarios', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (5, 'alumno', 'Alumno', 'Usuario de tipo alumno', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (6, 'afterschool_principal', 'Direccion Afterschool', 'Usuario que puede manipular el portal para inscripciones a workshops y a clases de afterschool para alumnos.', '2019-01-07 12:16:16', '2019-01-07 12:16:16');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `role_user`
  --
  
  CREATE TABLE `role_user` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `role_user`
  --
  
  INSERT INTO `role_user` (`id`, `user_id`, `role_id`) VALUES
  (1, 1, 1),
  (2, 2, 3),
  (3, 4, 3),
  (4, 4, 2),
  (5, 5, 5);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `rooms`
  --
  
  CREATE TABLE `rooms` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `long_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `sections`
  --
  
  CREATE TABLE `sections` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `sections`
  --
  
  INSERT INTO `sections` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, 'Root Section', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (2, 'Elementary', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (3, 'Afterschool', '2019-01-07 12:16:16', '2019-01-07 12:16:16');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `status`
  --
  
  CREATE TABLE `status` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `students`
  --
  
  CREATE TABLE `students` (
    `id` int(11) NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `homeroom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `matricula` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `group` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `grade` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `students`
  --
  
  INSERT INTO `students` (`id`, `user_id`, `homeroom`, `matricula`, `code`, `group`, `grade`, `created_at`, `updated_at`) VALUES
  (5, 31, '2A', '13-0030-1', '13-0030-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (29, 56, '2B', '13-0036-1', '13-0036-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (8, 34, '2A', '13-0057-2', '13-0057-2', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (3, 29, '2A', '13-0079-1', '13-0079-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (26, 53, '2B', '13-0081-1', '13-0081-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (32, 59, '2B', '13-0114-1', '13-0114-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (9, 35, '2A', '13-0127-2', '13-0127-2', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (4, 30, '2A', '13-0177-1', '13-0177-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (10, 36, '2A', '13-0182-1', '13-0182-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (7, 33, '2A', '13-0233-2', '13-0233-2', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (25, 52, '2B', '13-0248-1', '13-0248-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (27, 54, '2B', '13-0263-1', '13-0263-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (31, 58, '2B', '13-0313-1', '13-0313-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (30, 57, '2B', '13-0342-1', '13-0342-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (28, 55, '2B', '13-0345-1', '13-0345-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (6, 32, '2A', '13-0352-2', '13-0352-2', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (11, 37, '2A', '13-0369-1', '13-0369-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (33, 60, '2B', '14-0005-2', '14-0005-2', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (41, 68, '2B', '14-0049-2', '14-0049-2', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (12, 38, '2A', '14-0057-1', '14-0057-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (34, 61, '2B', '14-0096-1', '14-0096-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (35, 62, '2B', '15-0177-1', '15-0177-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (37, 64, '2B', '15-0194-2', '15-0194-2', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (36, 63, '2B', '15-0201-1', '15-0201-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (38, 65, '2B', '16-0308-1', '16-0308-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (39, 66, '2B', '16-0311-1', '16-0311-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (40, 67, '2B', '16-0314-1', '16-0314-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (14, 40, '2A', '16-0332-1', '16-0332-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (15, 41, '2A', '16-0343-1', '16-0343-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (16, 42, '2A', '16-0348-1', '16-0348-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (17, 43, '2A', '16-0358-2', '16-0358-2', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (19, 45, '2A', '16-0367-1', '16-0367-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (18, 44, '2A', '16-0369-1', '16-0369-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (42, 69, '2B', '16-0384-1', '16-0384-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (20, 46, '2A', '16-0388-1', '16-0388-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (44, 71, '2B', '16-0410-1', '16-0410-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (13, 39, '2A', '16-0437-1', '16-0437-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (22, 48, '2A', '17-0707-2', '17-0707-2', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (45, 72, '2B', '17-0721-1', '17-0721-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (21, 47, '2A', '17-0808-1', '17-0808-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (46, 73, '2B', '18-0943-1', '18-0943-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (23, 49, '2A', '18-1007-1', '18-1007-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (47, 74, '2B', '18-1014-1', '18-1014-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (43, 70, '2B', '18-1027-1', '18-1027-1', 'B', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (24, 50, '2A', '18-1044-1', '18-1044-1', 'A', '2', '2019-01-09 10:31:26', '2019-01-09 10:31:26');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `subjects`
  --
  
  CREATE TABLE `subjects` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `workshop_id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `start_time` time NOT NULL,
    `end_time` time NOT NULL,
    `year_id` int(10) UNSIGNED NOT NULL,
    `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `gender` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `subjects`
  --
  
  INSERT INTO `subjects` (`id`, `user_id`, `workshop_id`, `name`, `start_time`, `end_time`, `year_id`, `category`, `gender`, `created_at`, `updated_at`) VALUES
  (1, 8, 1, 'Acuarela Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (2, 9, 7, 'Ajedrez Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (3, 10, 16, 'Atletismo Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (4, 11, 24, 'Body Elementary 2 y 3 ', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (5, 12, 4, 'Dibujo Elementary 2 y 3 ', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (6, 13, 2, 'Flamenco Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (7, 14, 3, 'Futbol Elementary 2 y 3  ', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (8, 15, 17, 'Gimnasia Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (9, 16, 18, 'Guitarra Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (10, 17, 8, 'Hip hop Elementary 2 y 3', '11:40:00', '12:40:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (11, 18, 9, 'Jazz Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (12, 14, 6, 'Karate Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (13, 28, 15, 'Plastilina Elementary 2', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (14, 21, 14, 'Tambores Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (15, 22, 25, 'Tenis Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (16, 29, 5, 'Tocho Elementary 2 y 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (17, 9, 7, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (18, 24, 20, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (19, 10, 11, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (20, 12, 4, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (21, 19, 12, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (22, 14, 3, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (23, 15, 17, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (24, 16, 19, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (25, 17, 8, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (26, 18, 9, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (27, 28, 15, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (28, 21, 14, 'Elementary 4 y 5 ', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (29, 13, 23, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (30, 29, 5, 'Elementary 4 y 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (31, 9, 7, 'AJD 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (32, 10, 11, 'ATL 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (33, 24, 20, 'ARTV 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (34, 19, 12, 'DFP 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (35, 12, 13, 'DIBM 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (36, 25, 22, 'ENFIS 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (37, 14, 3, 'FUT 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (38, 15, 17, 'GIMN 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (39, 16, 19, 'GUIUK 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (40, 17, 9, 'JAZZ 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (41, 20, 15, 'PLST 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (42, 27, 10, 'ROBT 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (43, 21, 14, 'TAMB 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (44, 13, 21, 'RD 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (45, 29, 5, 'TCHBN 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (46, 28, 15, 'PLST 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (47, 26, 3, 'FUT 6 a 9', '13:45:00', '14:35:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (48, 20, 15, 'Elementary Plastilina 3', '11:40:00', '12:20:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (49, 20, 15, 'Elementary 5', '12:20:00', '13:00:00', 2, '0000', 'A', '2019-01-07 12:16:16', '2019-01-07 12:16:16');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tags`
  --
  
  CREATE TABLE `tags` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tickets`
  --
  
  CREATE TABLE `tickets` (
    `id` int(10) UNSIGNED NOT NULL,
    `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `send_datetime` datetime NOT NULL,
    `end_datetime` datetime NOT NULL,
    `avg_datetime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `civil_protection` int(11) NOT NULL,
    `bind_ticket` int(10) UNSIGNED NOT NULL,
    `status_id` int(10) UNSIGNED NOT NULL,
    `solution` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `year_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `ticket_category`
  --
  
  CREATE TABLE `ticket_category` (
    `id` int(10) UNSIGNED NOT NULL,
    `ticket_id` int(10) UNSIGNED NOT NULL,
    `category_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `ticket_tag`
  --
  
  CREATE TABLE `ticket_tag` (
    `id` int(10) UNSIGNED NOT NULL,
    `ticket_id` int(10) UNSIGNED NOT NULL,
    `tag_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `ticket_user`
  --
  
  CREATE TABLE `ticket_user` (
    `id` int(10) UNSIGNED NOT NULL,
    `ticket_id` int(10) UNSIGNED NOT NULL,
    `send_user_id` int(10) UNSIGNED NOT NULL,
    `receive_user_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `second_last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `birthday` date NOT NULL,
    `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `gender` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `department_id` int(10) UNSIGNED NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `last_name`, `second_last_name`, `birthday`, `nationality`, `gender`, `password`, `department_id`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'Pablo', 'vieyrapez@gmail.com', 'Vieyra', 'Lopez', '2019-01-09', 'Mexicano', 'M', '$2y$10$6z6rWqTskqZ.tz.C0LgQdOB.nMUhPYPxeMaRVKQEMw7QKjdP0jgWS', 1, 'xDnlX7iBo2whP6ncsylrjEbCO9ayRMg09OqR2Buw8CgGx0WVUr3tHAGpqYIK', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (2, 'John', 'student@student.itjvallereal.edu.mx', 'Bonachon', NULL, '2019-01-09', 'Mexicano', 'M', '$2y$10$wrY8RTPHjINXSQ6Ue34S4.p2g7Ap2H8A/iJjDCcvDPzZx/MWIWJoS', 1, 'KofIgn9D540reBd8sYkt6ydfMZZfV4oJ4JFJ0qULIF56qL8oHrIHekO50dPM', '2019-01-09 10:31:26', '2019-01-09 10:31:26'),
  (3, 'Jules', 'jules@gmail.com', 'Winnfield', NULL, '1988-08-03', 'Mexicano', 'M', '$2y$10$AiT01Xf6IHPYPmmFA.1qLO/Do9f7wAFUjMFni5HnHRS9Puqkoz8jW', 2, NULL, '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (4, 'Johnette', 'johnette@gmail.com', 'Napolitano', NULL, '1990-05-25', 'Mexicano', 'F', '$2y$10$cwZMIVljRWTuA6jYbKUPSeoJZ4Keb437cZMwJyXg1SHZLSO.JUIIi', 2, NULL, '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (5, 'Mia', 'mwallace@student.itjvallereal.edu.mx', 'Wallace', NULL, '2010-01-22', 'Mexicano', 'F', '$2y$10$/bJgM7ZnMnBveFGb7eA2sufepkFbTI7pTgDqW4YQvvQjKIY3zczAO', 2, 'sIgyhSVndKQDz9lPeRcfFhQbFrQdVWmSsVd59wp4OmVV8s2tucdi7e29LXLY', '2019-01-09 10:31:27', '2019-01-09 10:31:27'),
  (6, 'Ruth', 'ychavez@itjvallereal.edu.mx', 'Chavez', 'Delgado', '1990-12-12', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 3, 'rYHqkK8UiJ61hipl6U55aMxyxwa0Vl1SLs8iQKzOdt8qP7H5e5Yu8O9weXuj', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (7, 'Saskia', 'savalos@itjvallereal.edu.mx', 'Avalos', 'Tamayo', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 3, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (8, 'Paulina', 'plancaster@itjvallereal.edu.mx', 'Lancaster', 'Jones Campero', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (9, 'Alfonso', 'arodriguez@itjvallereal.edu.mx', 'Rodriguez', 'Sanchez', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '9tVCBFktN1STulXz1oahsXdDYBZCsD88flITCpZ4Zq2P45p7uRiHNLzheUKx', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (10, 'Hugo Enrique', 'hguerrero@itjvallereal.edu.mx', 'Guerrero', 'Carreon', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (11, 'Carolina', 'cperezc@itjvallereal.edu.mx', 'Perez', 'Campos', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (12, 'Jose Humberto', 'jruvalcaba@itjvallereal.edu.mx', 'Ruvalcaba', 'Perez', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (13, 'Sofia', 'ssolorzano@itjvallereal.edu.mx', 'Solorzano', 'Palomar', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (14, 'Victor Roberto m', 'vmorales@itjvallereal.edu.mx', 'Morales', 'Godinez', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (15, 'Gabriela', 'gvillada@itjvallereal.edu.mx', 'Villada', '', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (16, 'Adriana ', 'aramiro@itjvallereal.edu.mx', 'Ramiro', 'Canchola', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (17, 'Ana Luz', 'areyna@itjvallereal.edu.mx', 'Reyna', 'Talamantes', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (18, 'Nahyeli', 'nreyes@itjvallereal.edu.mx', 'Reyes', '', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (19, 'Victor Alfredo', 'vchavez@itjvallereal.edu.mx', 'Chavez', 'Chavez', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (20, 'Tania', 'tmedina@itjvallereal.edu.mx', 'Medina', 'Valdez', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (21, 'Roger', 'rvazquez@itjvallereal.edu.mx', 'Vazquez', 'Morales', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (22, 'Alejandro', 'acastorena@itjvallereal.edu.mx', 'Castorena', 'De Alba', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (23, 'Tocho', 'tocho@itjvallereal.edu.mx', 'Bandera', '', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (24, 'Claudio Antonio', 'crincon@itjvallereal.edu.mx', 'Arellano', 'Rincon', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (25, 'Marcelo', 'mtpadilla@itjvallereal.edu.mx', 'Torres', 'Padilla', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (26, 'Christian Emmanuel', 'crosales@itjvallereal.edu.mx', 'Rosales', '', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (27, 'Play', 'playrobot@itjvallereal.edu.mx', 'Robot', '', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (28, 'Gabriela rey', 'greyes@itjvallereal.edu.mx', 'Reyes', 'Novoa', '1990-11-26', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (29, 'Pendiente', 'pendiente@itjvallereal.edu.mx', 'Por Definir', '', '1990-11-26', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'r5LmGVFTlbkAU7Z4l2z9LrEMFyIVSZx5T29UXZC6Xvo35pjyYzxtiOI5NA4Z', '2019-01-17 00:41:37', '2019-01-17 00:41:37'),
  (30, 'Ximena', 'ximenaaguirrec@student.itjvallereal.edu.mx', 'Aguirre', 'Corona', '0000-00-00', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (31, 'Juan Manuel', 'juanmanuelaramburog@student.itjvallereal.edu.mx', 'Aramburo', 'Garcia', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'nmPdqGkzsjxO5r18t3nTUgN96iLxSOto1VBh3qr1mXsRCD4UKVM4t59z7cN3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (32, 'Efrain', 'efrainlozanor@student.itjvallereal.edu.mx', 'Lozano', 'Romero', '2011-05-10', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (33, 'Alejandro', 'alejandronuneze@student.itjvallereal.edu.mx', 'Nunez', 'Espinosa', '0001-04-10', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (34, 'Adrian', 'adrianochoag@student.itjvallereal.edu.mx', 'Ochoa', 'Garcia', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'korAMqv0BKoVvX4ryi4lMN40WSArbv9KK6HNLrv1cYBS3rG3QghK0rolI292', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (35, 'Alvaro', 'alvaroortiza@student.itjvallereal.edu.mx', 'Ortiz', 'Agnesi', '0007-03-10', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (36, 'Michelle Alejandra', 'michellealejandraperezf@student.itjvallereal.edu.mx', 'Perez', 'Flores', '0007-12-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (37, 'Alejandro', 'alejandrovadilloa@student.itjvallereal.edu.mx', 'Vadillo', 'Alvarez', '0009-04-10', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (38, 'Isabella', 'isabellacesneks@student.itjvallereal.edu.mx', 'Cesnek', 'Suarez', '0009-11-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (39, 'Joseph Alexander', 'josephalexanderbrillh@student.itjvallereal.edu.mx', 'Brill', 'Herrera', '0001-05-10', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (40, 'Regina', 'reginaplascenciav@student.itjvallereal.edu.mx', 'Plascencia', 'Villaverde', '0002-11-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (41, 'Alvaro', 'alvarocardenasd@student.itjvallereal.edu.mx', 'Cardenas', 'De La Cruz', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (42, 'Alejandro', 'alejandrogarzac@student.itjvallereal.edu.mx', 'Garza', 'Castillo', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (43, 'Maria Fernanda', 'mariafernandaarroyog@student.itjvallereal.edu.mx', 'Arroyo', 'Garcia', '2012-02-09', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (44, 'Galo', 'galogutierrezh@student.itjvallereal.edu.mx', 'Gutierrez', 'Hidalgo', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (45, 'Becky De Jesus', 'beckydejesuscastellanosc@student.itjvallereal.edu.mx', 'Castellanos', 'Castro', '0003-11-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (46, 'Minerva', 'minervade la torrea@student.itjvallereal.edu.mx', 'De La Torre', 'Anaya', '2011-07-09', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (47, 'Oviya', 'oviyaanithkumar@student.itjvallereal.edu.mx', 'Anithkumar', '', '0000-00-00', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (48, 'Camila', 'camilaaguilam@student.itjvallereal.edu.mx', 'Aguila', 'Mendivil', '0000-00-00', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'ACU0kfCyMMjhoAoU1gPJc2528zyqU4HfebaA8GaOQHqbzzcl8MUAQQMaRlvA', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (49, 'Matias', 'matiasperezh@student.itjvallereal.edu.mx', 'Perez', 'Hernandez', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '6W4ZJyqGA8p51j6Qepw4TmEaL0xKwhAGgx9Az3N1VLt71cDNJGcgsYeCPBUM', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (50, 'Regina', 'reginamanona@student.itjvallereal.edu.mx', 'Manon', 'Ampudia', '2011-08-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'hnMknM1513TEU8CWfHO2U3R78uXXLTa4ZFBhlCrGUMyKvHS5CvxVSSDdOuey', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (51, 'Thiago', 'thiagomaldonado@student.itjvallereal.edu.mx', 'Maldonado', '', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'RksV6tfSCM6171KpBaeCDtINKAXGniZRAzVjgCB7WbLr42S8Uq0bf6AjVtR9', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (52, 'Diego', 'diegoquinonesr@student.itjvallereal.edu.mx', 'Quinones', 'Rodriguez', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '5Hr4xItcbCuCvr8E7ou1sp4q2OVt3NbpdtORssbh4ue9S2o1Q656xDu73eWr', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (53, 'Matias', 'matiasgonzalezg@student.itjvallereal.edu.mx', 'Gonzalez', 'Gomez', '0009-05-09', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '9ZRMOEb54f4KJ0ubZ7JQ952HTld9Rc45kHY4mbSJw5IdkWuAXewXpLCsSQqH', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (54, 'Carlos David', 'carlosdavidmirandam@student.itjvallereal.edu.mx', 'Miranda', 'Manjarrez', '0008-05-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'QgBKI8cpxQhGZ7RzMSG8BQRzlB51RV3MrDS4swtRcAwwVaqBGAAm9IMSZy1j', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (55, 'Emiliano Andre', 'emilianoandrereyesz@student.itjvallereal.edu.mx', 'Reyes', 'Zorrilla', '2012-10-09', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'L2Mqg3dfJ5ZPguqpmnFUmREQOhRxrFGa2wVaMDSNHwoD09aYgmj3XXT0yKyx', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (56, 'Tayde Emiliano', 'taydeemilianoaispurot@student.itjvallereal.edu.mx', 'Aispuro', 'Tostado', '0009-07-10', 'Estadounidense', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (57, 'Fernanda', 'fernandaarellanoh@student.itjvallereal.edu.mx', 'Arellano', 'Heredia', '0008-03-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (58, 'Carlos Santiago', 'carlossantiagohuertam@student.itjvallereal.edu.mx', 'Huerta', 'Martinez', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (59, 'Andrea', 'andreasamanog@student.itjvallereal.edu.mx', 'Samano', 'Gutierrez', '0000-00-00', 'Estadounidense', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (60, 'Valentina', 'valentinasanabriam@student.itjvallereal.edu.mx', 'Sanabria', 'Macias', '0001-12-10', 'Estadounidense', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'zpBvOitIINA3i9z4aj5kv4TAhIENV1DOWmPvS2C1Poupa1tbDXxMG2WsVY3Y', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (61, 'Saori Alexandra', 'saorialexandragonzalezt@student.itjvallereal.edu.mx', 'Gonzalez', 'Tenorio', '0000-00-00', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'RsNCIylWye4v4wwjQFPK5dycF6aVxokPVoGwPj6PwTGfWrHAAeHbCpvVWpcb', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (62, 'Jesus Adriel', 'jesusadrielgomezz@student.itjvallereal.edu.mx', 'Gomez', 'Zaragoza', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (63, 'Maria Jose', 'mariajosefloresg@student.itjvallereal.edu.mx', 'Flores', 'Gutierrez', '0003-07-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (64, 'Valentina', 'valentinadelatorrer@student.itjvallereal.edu.mx', 'De La Torre', 'Ramirez', '0001-09-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (65, 'Paola', 'paolaalvarezg@student.itjvallereal.edu.mx', 'Alvarez', 'Gonzalez', '0000-00-00', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (66, 'Santiago', 'santiagomorettv@student.itjvallereal.edu.mx', 'Morett', 'Vela', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (67, 'Mariana Sofia', 'marianasofiamendozaa@student.itjvallereal.edu.mx', 'Mendoza', 'Aguila', '0000-00-00', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (68, 'Pablo', 'pablogonzalezp@student.itjvallereal.edu.mx', 'Gonzalez', 'Padilla', '0005-11-10', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '3RBqcK01mWhamMpRsrEs2tIHPje1hCWfjZZos9Tyh0eaGJPE1CGJjTsbsd6T', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (69, 'Emilio', 'emiliomorav@student.itjvallereal.edu.mx', 'Mora', 'Vazquez', '0000-00-00', 'Mexicana', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, 'IGtd37hUTylod4kWbZjLnPsELZFwV1yIcwDoDo5jMZi6XAm1UFrowBM2LNFM', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (70, 'Giuliana', 'giulianaochoan@student.itjvallereal.edu.mx', 'Ochoa', 'Nuccio', '0000-00-00', 'Mexicana  Estadounidense', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (71, 'Claudia Sofia', 'claudiasofiamontesm@student.itjvallereal.edu.mx', 'Montes', 'Margarito', '0000-00-00', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (72, 'Aaron Servando', 'aaronservandomas@student.itjvallereal.edu.mx', 'Ma', 'Sepulveda', '0000-00-00', 'Mexicana  Estadounidense', 'M', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (73, 'Gabrielle Frances', 'gabriellefrancescapulongl@student.itjvallereal.edu.mx', 'Capulong', 'Lopez', '0000-00-00', 'Filipina', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (74, 'Maria Nataly', 'marianatalyramosa@student.itjvallereal.edu.mx', 'Ramos', 'Alvarez', '2011-11-10', 'Mexicana', 'F', '$2y$10$ipsrcNT6PotBTrAlxa4s/uyXd5gM8ILNdrgAArEQaEaaAF84Z.tZm', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `user_status`
  --
  
  CREATE TABLE `user_status` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `status_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `workshops`
  --
  
  CREATE TABLE `workshops` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `picture` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `workshops`
  --
  
  INSERT INTO `workshops` (`id`, `name`, `description`, `picture`, `created_at`, `updated_at`) VALUES
  (1, 'Acuarela', 'Clase de acuarela', 'acuarela.jpg', '2019-01-09 10:45:13', '2019-01-09 10:45:13'),
  (2, 'Flamenco', 'Taller cultural de Flamenco', 'flamenco.jpg', '2019-01-09 10:45:13', '2019-01-09 10:45:13'),
  (3, 'Futbol', 'Taller deportivo de futbol', 'futbol.jpg', '2019-01-09 10:45:13', '2019-01-09 10:45:13'),
  (4, 'Dibujo', 'Taller clase de dibujo', 'dibujo.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (5, 'Tocho Bandera', 'Taller de Tocho Bandera', 'tocho.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (6, 'Karate', 'Taller de Karate', 'karate.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (7, 'Ajedrez', 'Taller de Ajedrez', 'ajedrez.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (8, 'Hip-hop', 'Taller de Hip-hop', 'hiphop.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (9, 'Jazz', 'Taller de jazz', 'jazz.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (10, 'Robotica', 'Taller de Robotica', 'robotica.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (11, 'Atletismo', 'Taller de Atletismo', 'atletismo.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (12, 'Defensa Personal', 'Taller de defensa personal', 'defensa.jpg', '2019-01-07 12:16:16', '2019-01-07 12:16:16'),
  (13, 'Dibujo Manga', 'Taller de dibujo manga', 'dibujo_manga.jpg', '2019-01-19 02:09:08', '2019-01-19 02:09:08'),
  (14, 'Tambores', 'Taller de tambores', 'tambores.jpg', '2019-01-19 02:17:35', '2019-01-19 02:17:35'),
  (15, 'Plastilina', 'Taller de plastilina', 'plastilina.jpg', '2019-01-19 02:22:10', '2019-01-19 02:22:10'),
  (16, 'Atletismo', 'demo', 'atletismo.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (17, 'Gimnasia', 'Clase de gimnasia', 'gimnasia.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (18, 'Guitarra', 'Clase de guitarra', 'guitarra.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (19, 'Guitarra y Ukulele', 'Clase de guitarra y ukulele', 'ukulele.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (20, 'Artes Visuales', 'Clase de artes visuales', 'artes.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (21, 'Radio', 'Clase de radio', 'radio.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (22, 'Entrenamiento Fisico', 'Clase de entrenamiento fisico', 'entrenamiento.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (23, 'Teatro', 'Clase de teatro', 'teatro.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (24, 'Body Mind', 'Clase de Body Mind Challenges', 'body.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11'),
  (25, 'Tenis', 'Clase de tenis', 'tenis.jpg', '2019-01-19 02:24:11', '2019-01-19 02:24:11');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `workshop_enrollment`
  --
  
  CREATE TABLE `workshop_enrollment` (
    `id` int(10) UNSIGNED NOT NULL,
    `matricula` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `subject_id` int(10) UNSIGNED NOT NULL,
    `year_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `workshop_temps`
  --
  
  CREATE TABLE `workshop_temps` (
    `id` int(10) UNSIGNED NOT NULL,
    `matricula` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `subject_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `years`
  --
  
  CREATE TABLE `years` (
    `id` int(10) UNSIGNED NOT NULL,
    `year` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `current_year` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `years`
  --
  
  INSERT INTO `years` (`id`, `year`, `current_year`, `created_at`, `updated_at`) VALUES
  (1, '2017-2018', 0, '2019-01-09 10:52:25', '2019-01-09 10:52:25'),
  (2, '2018-2019', 1, '2019-01-09 10:52:25', '2019-01-09 10:52:25');
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `buildings`
  --
  ALTER TABLE `buildings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `days`
  --
  ALTER TABLE `days`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `day_subject`
  --
  ALTER TABLE `day_subject`
    ADD PRIMARY KEY (`id`),
    ADD KEY `day_subject_subject_id_foreign` (`subject_id`),
    ADD KEY `day_subject_day_id_foreign` (`day_id`);
  
  --
  -- Indices de la tabla `departments`
  --
  ALTER TABLE `departments`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `department_section`
  --
  ALTER TABLE `department_section`
    ADD PRIMARY KEY (`id`),
    ADD KEY `department_section_department_id_foreign` (`department_id`),
    ADD KEY `department_section_section_id_foreign` (`section_id`);
  
  --
  -- Indices de la tabla `employees`
  --
  ALTER TABLE `employees`
    ADD PRIMARY KEY (`id`),
    ADD KEY `employees_user_id_foreign` (`user_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 `places`
  --
  ALTER TABLE `places`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `place_building`
  --
  ALTER TABLE `place_building`
    ADD PRIMARY KEY (`id`),
    ADD KEY `place_building_place_id_foreign` (`place_id`),
    ADD KEY `place_building_building_id_foreign` (`building_id`);
  
  --
  -- Indices de la tabla `plans`
  --
  ALTER TABLE `plans`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `plan_student`
  --
  ALTER TABLE `plan_student`
    ADD PRIMARY KEY (`id`),
    ADD KEY `plan_student_plan_id_foreign` (`plan_id`),
    ADD KEY `plan_student_matricula_foreign` (`matricula`);
  
  --
  -- Indices de la tabla `plan_subject`
  --
  ALTER TABLE `plan_subject`
    ADD PRIMARY KEY (`id`),
    ADD KEY `plan_subject_plan_id_foreign` (`plan_id`),
    ADD KEY `plan_subject_subject_id_foreign` (`subject_id`);
  
  --
  -- Indices de la tabla `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `roles_name_unique` (`name`);
  
  --
  -- Indices de la tabla `role_user`
  --
  ALTER TABLE `role_user`
    ADD PRIMARY KEY (`id`),
    ADD KEY `role_user_user_id_foreign` (`user_id`),
    ADD KEY `role_user_role_id_foreign` (`role_id`);
  
  --
  -- Indices de la tabla `rooms`
  --
  ALTER TABLE `rooms`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `sections`
  --
  ALTER TABLE `sections`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `status`
  --
  ALTER TABLE `status`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `students`
  --
  ALTER TABLE `students`
    ADD PRIMARY KEY (`matricula`),
    ADD KEY `students_user_id_foreign` (`user_id`);
  
  --
  -- Indices de la tabla `subjects`
  --
  ALTER TABLE `subjects`
    ADD PRIMARY KEY (`id`),
    ADD KEY `subjects_user_id_foreign` (`user_id`),
    ADD KEY `subjects_workshop_id_foreign` (`workshop_id`),
    ADD KEY `subjects_year_id_foreign` (`year_id`);
  
  --
  -- Indices de la tabla `tags`
  --
  ALTER TABLE `tags`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `tickets`
  --
  ALTER TABLE `tickets`
    ADD PRIMARY KEY (`id`),
    ADD KEY `tickets_status_id_foreign` (`status_id`),
    ADD KEY `tickets_year_id_foreign` (`year_id`);
  
  --
  -- Indices de la tabla `ticket_category`
  --
  ALTER TABLE `ticket_category`
    ADD PRIMARY KEY (`id`),
    ADD KEY `ticket_category_ticket_id_foreign` (`ticket_id`),
    ADD KEY `ticket_category_category_id_foreign` (`category_id`);
  
  --
  -- Indices de la tabla `ticket_tag`
  --
  ALTER TABLE `ticket_tag`
    ADD PRIMARY KEY (`id`),
    ADD KEY `ticket_tag_ticket_id_foreign` (`ticket_id`),
    ADD KEY `ticket_tag_tag_id_foreign` (`tag_id`);
  
  --
  -- Indices de la tabla `ticket_user`
  --
  ALTER TABLE `ticket_user`
    ADD PRIMARY KEY (`id`),
    ADD KEY `ticket_user_ticket_id_foreign` (`ticket_id`),
    ADD KEY `ticket_user_send_user_id_foreign` (`send_user_id`),
    ADD KEY `ticket_user_receive_user_id_foreign` (`receive_user_id`);
  
  --
  -- Indices de la tabla `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`),
    ADD KEY `users_department_id_foreign` (`department_id`);
  
  --
  -- Indices de la tabla `user_status`
  --
  ALTER TABLE `user_status`
    ADD PRIMARY KEY (`id`),
    ADD KEY `user_status_user_id_foreign` (`user_id`),
    ADD KEY `user_status_status_id_foreign` (`status_id`);
  
  --
  -- Indices de la tabla `workshops`
  --
  ALTER TABLE `workshops`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `workshop_enrollment`
  --
  ALTER TABLE `workshop_enrollment`
    ADD PRIMARY KEY (`id`),
    ADD KEY `workshop_enrollment_matricula_foreign` (`matricula`),
    ADD KEY `workshop_enrollment_subject_id_foreign` (`subject_id`),
    ADD KEY `workshop_enrollment_year_id_foreign` (`year_id`);
  
  --
  -- Indices de la tabla `workshop_temps`
  --
  ALTER TABLE `workshop_temps`
    ADD PRIMARY KEY (`id`),
    ADD KEY `workshop_temps_matricula_foreign` (`matricula`),
    ADD KEY `workshop_temps_subject_id_foreign` (`subject_id`);
  
  --
  -- Indices de la tabla `years`
  --
  ALTER TABLE `years`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `buildings`
  --
  ALTER TABLE `buildings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `days`
  --
  ALTER TABLE `days`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT de la tabla `day_subject`
  --
  ALTER TABLE `day_subject`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;
  
  --
  -- AUTO_INCREMENT de la tabla `departments`
  --
  ALTER TABLE `departments`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT de la tabla `department_section`
  --
  ALTER TABLE `department_section`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `employees`
  --
  ALTER TABLE `employees`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
  
  --
  -- AUTO_INCREMENT de la tabla `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
  
  --
  -- AUTO_INCREMENT de la tabla `places`
  --
  ALTER TABLE `places`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `place_building`
  --
  ALTER TABLE `place_building`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `plans`
  --
  ALTER TABLE `plans`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
  
  --
  -- AUTO_INCREMENT de la tabla `plan_student`
  --
  ALTER TABLE `plan_student`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
  
  --
  -- AUTO_INCREMENT de la tabla `plan_subject`
  --
  ALTER TABLE `plan_subject`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=391;
  
  --
  -- AUTO_INCREMENT de la tabla `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT de la tabla `role_user`
  --
  ALTER TABLE `role_user`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT de la tabla `rooms`
  --
  ALTER TABLE `rooms`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `sections`
  --
  ALTER TABLE `sections`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT de la tabla `status`
  --
  ALTER TABLE `status`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `subjects`
  --
  ALTER TABLE `subjects`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
  
  --
  -- AUTO_INCREMENT de la tabla `tags`
  --
  ALTER TABLE `tags`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `tickets`
  --
  ALTER TABLE `tickets`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `ticket_category`
  --
  ALTER TABLE `ticket_category`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `ticket_tag`
  --
  ALTER TABLE `ticket_tag`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `ticket_user`
  --
  ALTER TABLE `ticket_user`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;
  
  --
  -- AUTO_INCREMENT de la tabla `user_status`
  --
  ALTER TABLE `user_status`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `workshops`
  --
  ALTER TABLE `workshops`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
  
  --
  -- AUTO_INCREMENT de la tabla `workshop_enrollment`
  --
  ALTER TABLE `workshop_enrollment`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `workshop_temps`
  --
  ALTER TABLE `workshop_temps`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `years`
  --
  ALTER TABLE `years`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- Restricciones para tablas volcadas
  --
  
  --
  -- Filtros para la tabla `day_subject`
  --
  ALTER TABLE `day_subject`
    ADD CONSTRAINT `day_subject_day_id_foreign` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `day_subject_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `department_section`
  --
  ALTER TABLE `department_section`
    ADD CONSTRAINT `department_section_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `department_section_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `employees`
  --
  ALTER TABLE `employees`
    ADD CONSTRAINT `employees_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `place_building`
  --
  ALTER TABLE `place_building`
    ADD CONSTRAINT `place_building_building_id_foreign` FOREIGN KEY (`building_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `place_building_place_id_foreign` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `plan_student`
  --
  ALTER TABLE `plan_student`
    ADD CONSTRAINT `plan_student_matricula_foreign` FOREIGN KEY (`matricula`) REFERENCES `students` (`matricula`) ON DELETE CASCADE,
    ADD CONSTRAINT `plan_student_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `plan_subject`
  --
  ALTER TABLE `plan_subject`
    ADD CONSTRAINT `plan_subject_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `plan_subject_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `role_user`
  --
  ALTER TABLE `role_user`
    ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `students`
  --
  ALTER TABLE `students`
    ADD CONSTRAINT `students_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `subjects`
  --
  ALTER TABLE `subjects`
    ADD CONSTRAINT `subjects_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `subjects_workshop_id_foreign` FOREIGN KEY (`workshop_id`) REFERENCES `workshops` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `subjects_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `years` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `tickets`
  --
  ALTER TABLE `tickets`
    ADD CONSTRAINT `tickets_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `tickets_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `years` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `ticket_category`
  --
  ALTER TABLE `ticket_category`
    ADD CONSTRAINT `ticket_category_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `ticket_category_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `ticket_tag`
  --
  ALTER TABLE `ticket_tag`
    ADD CONSTRAINT `ticket_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `ticket_tag_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `ticket_user`
  --
  ALTER TABLE `ticket_user`
    ADD CONSTRAINT `ticket_user_receive_user_id_foreign` FOREIGN KEY (`receive_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `ticket_user_send_user_id_foreign` FOREIGN KEY (`send_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `ticket_user_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `users`
  --
  ALTER TABLE `users`
    ADD CONSTRAINT `users_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `user_status`
  --
  ALTER TABLE `user_status`
    ADD CONSTRAINT `user_status_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `user_status_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `workshop_enrollment`
  --
  ALTER TABLE `workshop_enrollment`
    ADD CONSTRAINT `workshop_enrollment_matricula_foreign` FOREIGN KEY (`matricula`) REFERENCES `students` (`matricula`) ON DELETE CASCADE,
    ADD CONSTRAINT `workshop_enrollment_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `workshop_enrollment_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `years` (`id`) ON DELETE CASCADE;
  
  --
  -- Filtros para la tabla `workshop_temps`
  --
  ALTER TABLE `workshop_temps`
    ADD CONSTRAINT `workshop_temps_matricula_foreign` FOREIGN KEY (`matricula`) REFERENCES `students` (`matricula`) ON DELETE CASCADE,
    ADD CONSTRAINT `workshop_temps_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE 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 */;
  