text: -- phpMyAdmin SQL Dump
  -- version 4.6.5.2
  -- https://www.phpmyadmin.net/
  --
  -- Servidor: 127.0.0.1
  -- Tiempo de generación: 11-07-2017 a las 08:08:37
  -- Versión del servidor: 10.1.21-MariaDB
  -- Versión de PHP: 7.1.1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Base de datos: `laravelcrud`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `alumnos`
  --
  
  CREATE TABLE `alumnos` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
    `surname` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
    `year` enum('2015','2016','2017') 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 `alumnos`
  --
  
  INSERT INTO `alumnos` (`id`, `name`, `surname`, `year`, `created_at`, `updated_at`) VALUES
  (3, 'Pepa', 'Flores', '2016', NULL, NULL),
  (5, 'rosa', 'martinez', '2017', '2017-07-05 02:48:11', '2017-07-05 02:54:23'),
  (7, 'Maria', 'delMonte', '2015', '2017-07-05 02:54:37', '2017-07-05 02:54:37');
  
  -- --------------------------------------------------------
  
  --
  -- 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
  (9, '2014_10_12_000000_create_users_table', 1),
  (10, '2014_10_12_100000_create_password_resets_table', 1),
  (11, '2017_07_04_031432_create_table_pasteles_table', 2),
  (12, '2017_07_05_032031_create_table_alumnos', 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 `pasteles`
  --
  
  CREATE TABLE `pasteles` (
    `id` int(10) UNSIGNED NOT NULL,
    `nombre` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
    `sabor` enum('chocolate','vainilla','cheesecake') 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 `pasteles`
  --
  
  INSERT INTO `pasteles` (`id`, `nombre`, `sabor`, `created_at`, `updated_at`) VALUES
  (5, 'pastelito creadito', 'cheesecake', '2017-07-04 03:24:42', '2017-07-04 03:24:42'),
  (6, 'mirwerewrwerwerwe', 'chocolate', '2017-07-04 03:24:51', '2017-07-04 03:25:20'),
  (7, 'easeaseaseas', 'cheesecake', '2017-07-04 03:25:31', '2017-07-04 03:25:31');
  
  -- --------------------------------------------------------
  
  --
  -- 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,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `username`) VALUES
  (1, 'Administrator', 'admin@admin.com', '$2y$10$auMZt13sLNm18IuTSVsjEeTZKCycd5O0V9Onoycl.Cn679i47wZyu', NULL, '2017-07-05 03:03:18', '2017-07-05 03:03:18', 'admin'),
  (2, 'ruth', 'rqvaquero@gmail.com', '$2y$10$8fT8exsjjAKzkO6aTtYtDuGerNiQBOKi13OLmoJbLIljFnA7Gd.oe', '9YnbNJDj2GshodxX2GpqJoGhliF2lb914w1DRvUaW37JInUViA6qKgoW8j95', '2017-07-05 03:12:04', '2017-07-05 03:12:04', 'ruth');
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `alumnos`
  --
  ALTER TABLE `alumnos`
    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 `pasteles`
  --
  ALTER TABLE `pasteles`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `alumnos`
  --
  ALTER TABLE `alumnos`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  --
  -- AUTO_INCREMENT de la tabla `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  --
  -- AUTO_INCREMENT de la tabla `pasteles`
  --
  ALTER TABLE `pasteles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  --
  -- AUTO_INCREMENT de la tabla `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  /*!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 */;
  