-- https://www.phpmyadmin.net/
--
-- Versión del servidor: 10.1.37-MariaDB
-- Versión de PHP: 7.3.1


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;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2014_10_12_200000_modify_users_table', 1);


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;

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` enum('admin','editor','author') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'author',
  `gender` enum('male','female','other') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` int(10) UNSIGNED DEFAULT NULL,
  `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`id`, `name`, `email`, `role`, `gender`, `age`, `profession`, `email_verified_at`, `password`, `remember_token`, `last_login_at`, `created_at`, `updated_at`) VALUES
(1, 'foo', 'foo@mail.com', 'admin', 'other', 37, 'web admin', NULL, '$2y$10$2dyXLmUkQbHemU/2R0ZXCOFCZO2W1axWS5hU72fXZPhR2Yy5E/nm.', NULL, NULL, '2019-08-29 22:00:00', '2019-08-30 21:06:54'),
(2, 'baz', 'baz@mail.com', 'editor', NULL, 23, 'developer', NULL, '$2y$10$T88njV/ubokwnec.nWEANeKZqREeyb/SZ7RDC7j6S3seVUPgqHZGe', NULL, NULL, '2019-08-30 21:06:54', '2019-08-30 21:06:54'),
(3, 'au', 'au@mail.com', 'author', 'female', 16, 'blogger', NULL, '$2y$10$yZuJ3Un2vE.Z9SbvjvfA/uITyVvRZjtBhOX2tKuaQP6txHsEG950a', NULL, '2019-08-29 22:00:00', '2019-08-30 21:06:54', '2019-08-30 21:06:54'),
(4, 'xxx', 'xxx@mail.com', 'author', NULL, 18, 'blogger', NULL, '$2y$10$oiulGAyjeADkbnHu3qk0XOkTh8HWJzoMkgIYGke2h3cFqIBjAXBKO', NULL, NULL, '2019-08-30 21:06:54', '2019-08-30 21:06:54'),
(5, 'zzz', 'zzz@mail.com', 'author', 'male', 18, 'architect', NULL, '$2y$10$Q8PUP2ed5FDtTm.BjrezseUiEbB61N1A2GBzF1e6fWfAD1isnKqvC', NULL, NULL, '2019-08-30 21:06:54', '2019-08-30 21:06:54');


ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;
