-- phpMyAdmin SQL Dump

-- version 4.5.4.1deb2ubuntu2

-- http://www.phpmyadmin.net

--

-- Хост: localhost

-- Время создания: Ноя 16 2017 г., 20:48

-- Версия сервера: 5.7.20-0ubuntu0.16.04.1

-- Версия PHP: 7.0.22-0ubuntu0.16.04.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 */;



--

-- База данных: `tabtech`

--



-- --------------------------------------------------------



--

-- Структура таблицы `categories`

--



CREATE TABLE `categories` (

  `id` int(11) NOT NULL,

  `name` varchar(100) NOT NULL,

  `json_characteristics` text NOT NULL,

  `updated_at` timestamp NULL DEFAULT NULL,

  `created_at` timestamp NULL DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--

-- Дамп данных таблицы `categories`

--



INSERT INTO `categories` (`id`, `name`, `json_characteristics`, `updated_at`, `created_at`) VALUES

(1, 'All', '["Price","Description"]', NULL, NULL),

(10, 'Notebooks', '[["Processor",["i3","i5","i7"]],["Graphics",["GTX 1050TI","GTX 1080"]],"Other"]', '2017-11-04 19:44:24', '2017-11-04 19:44:24');



-- --------------------------------------------------------



--

-- Структура таблицы `failed_jobs`

--



CREATE TABLE `failed_jobs` (

  `id` bigint(20) UNSIGNED NOT NULL,

  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,

  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,

  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- --------------------------------------------------------



--

-- Структура таблицы `jobs`

--



CREATE TABLE `jobs` (

  `id` bigint(20) UNSIGNED NOT NULL,

  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

  `attempts` tinyint(3) UNSIGNED NOT NULL,

  `reserved_at` int(10) UNSIGNED DEFAULT NULL,

  `available_at` int(10) UNSIGNED NOT NULL,

  `created_at` int(10) UNSIGNED NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- Дамп данных таблицы `jobs`

--



INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES

(1, 'default', '{"displayName":"App\\\\Jobs\\\\SendVerificationEmail","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\SendVerificationEmail","command":"O:30:\\"App\\\\Jobs\\\\SendVerificationEmail\\":6:{s:7:\\"\\u0000*\\u0000user\\";O:45:\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\":3:{s:5:\\"class\\";s:8:\\"App\\\\User\\";s:2:\\"id\\";i:12;s:10:\\"connection\\";s:5:\\"mysql\\";}s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:5:\\"delay\\";i:10;s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1510838042, 1510838032);



-- --------------------------------------------------------



--

-- Структура таблицы `migrations`

--



CREATE TABLE `migrations` (

  `id` int(10) UNSIGNED NOT NULL,

  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `batch` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- Дамп данных таблицы `migrations`

--



INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES

(2, '2014_10_12_100000_create_password_resets_table', 1),

(5, '2014_10_12_000000_create_users_table', 2),

(7, '2017_11_02_193143_create_jobs_table', 3),

(8, '2017_11_02_193152_create_failed_jobs_table', 3),

(12, '2017_11_03_211041_create_products_table', 4),

(13, '2017_11_16_123701_add_secret_quest', 5);



-- --------------------------------------------------------



--

-- Структура таблицы `password_resets`

--



CREATE TABLE `password_resets` (

  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `token_check` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `token_reset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `created_at` timestamp NULL DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- Дамп данных таблицы `password_resets`

--



INSERT INTO `password_resets` (`email`, `token_check`, `token_reset`, `created_at`) VALUES

('pavel-levshin@mail.ru', '$2y$10$daASeHZmVt2Xbl6TBh/FJud.1nrvaJN2ySypOnky7poJPscOh6OtS', '$2y$10$fUo32/SZmudCB0VZIOnRiuLg30OF0eFoxB8RC1uV6.yOKO4sN5BJ6', NULL);



-- --------------------------------------------------------



--

-- Структура таблицы `products`

--



CREATE TABLE `products` (

  `id` int(10) UNSIGNED NOT NULL,

  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `description` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,

  `category` int(11) NOT NULL,

  `price` 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;



-- --------------------------------------------------------



--

-- Структура таблицы `users`

--



CREATE TABLE `users` (

  `id` int(10) UNSIGNED NOT NULL,

  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `verified` tinyint(4) NOT NULL DEFAULT '0',

  `email_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `created_at` timestamp NULL DEFAULT NULL,

  `updated_at` timestamp NULL DEFAULT NULL,

  `isAdmin` tinyint(1) DEFAULT '0',

  `secret_question` text COLLATE utf8mb4_unicode_ci NOT NULL,

  `answer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- Дамп данных таблицы `users`

--



INSERT INTO `users` (`id`, `name`, `email`, `password`, `verified`, `email_token`, `remember_token`, `created_at`, `updated_at`, `isAdmin`, `secret_question`, `answer`) VALUES

(9, 'Pavel', 'pavel210995@gmail.com', '$2y$10$CAt.69xcpMW8rNVWfwy7yOf676LALMqV8wXxiEqCuVGOjBfbNfeN6', 1, 'cGF2ZWwyMTA5OTVAZ21haWwuY29t', 'jcTf4GrkTJ2v6q1KYVh6hYsVSIHFGmVgrLEsh8uycuG5FA1N9fCRHIlM02b8', '2017-11-02 18:15:23', '2017-11-02 18:19:17', 1, '', ''),

(19, 'Pavel', 'pavel-levshin@mail.ru', '$2y$10$c3Sl30MSq/EMCzgjVMXHfuLgtaHVm9Md0tzXo33V8C5Lc2pphPVrC', 0, NULL, 'qAO1ZI3hnDSr9HARkmAkIaae0La5cGxuR4tBQ7lYwmK6J52FXeRng3XbuF89', '2017-11-16 13:17:55', '2017-11-16 13:17:55', 0, 'MyName', '$2y$10$locg3MG7oxbB4r4v6Sy6ZegCSGigo5IYMLv9QqnMS3s7QuieFVNPG'),

(20, 'Pavel', 'pavel-levshin@mail.rus', '$2y$10$fk/EmbVoVr.MkQ9edI.wZeBNixlNYV6UsyhlZO4PxpyEHO7IabDQu', 0, NULL, 'o7bbvP8KXih6RYuFlPkF4Sio2bsd0MaIEUe2tkCUHyQeU4BWPEJYOSW13uSi', '2017-11-16 13:57:47', '2017-11-16 13:57:47', 0, 'qq', '$2y$10$FHgrjG1Mgm44fIc7hAxMfeO9dX0SC1OZytzxOzjcZHU1VpG2c0/Ey');



--

-- Индексы сохранённых таблиц

--



--

-- Индексы таблицы `categories`

--

ALTER TABLE `categories`

  ADD PRIMARY KEY (`id`);



--

-- Индексы таблицы `failed_jobs`

--

ALTER TABLE `failed_jobs`

  ADD PRIMARY KEY (`id`);



--

-- Индексы таблицы `jobs`

--

ALTER TABLE `jobs`

  ADD PRIMARY KEY (`id`),

  ADD KEY `jobs_queue_index` (`queue`);



--

-- Индексы таблицы `migrations`

--

ALTER TABLE `migrations`

  ADD PRIMARY KEY (`id`);



--

-- Индексы таблицы `password_resets`

--

ALTER TABLE `password_resets`

  ADD KEY `password_resets_email_index` (`email`);



--

-- Индексы таблицы `products`

--

ALTER TABLE `products`

  ADD PRIMARY KEY (`id`);



--

-- Индексы таблицы `users`

--

ALTER TABLE `users`

  ADD PRIMARY KEY (`id`),

  ADD UNIQUE KEY `users_email_unique` (`email`);



--

-- AUTO_INCREMENT для сохранённых таблиц

--



--

-- AUTO_INCREMENT для таблицы `categories`

--

ALTER TABLE `categories`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--

-- AUTO_INCREMENT для таблицы `failed_jobs`

--

ALTER TABLE `failed_jobs`

  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--

-- AUTO_INCREMENT для таблицы `jobs`

--

ALTER TABLE `jobs`

  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--

-- AUTO_INCREMENT для таблицы `migrations`

--

ALTER TABLE `migrations`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--

-- AUTO_INCREMENT для таблицы `products`

--

ALTER TABLE `products`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--

-- AUTO_INCREMENT для таблицы `users`

--

ALTER TABLE `users`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

/*!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 */;