-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Mar 17, 2021 at 11:36 AM
-- Server version: 5.7.31
-- PHP Version: 7.4.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;

--
-- Database: `telegram`
--

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

--
-- Table structure for table `case_steps`
--

DROP TABLE IF EXISTS `case_steps`;
CREATE TABLE IF NOT EXISTS `case_steps` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `step` int(11) DEFAULT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `case_steps`
--

INSERT INTO `case_steps` (`id`, `name`, `step`, `type`, `url`, `created_at`, `updated_at`) VALUES
(1, '/start', 1, 'send', 'sendmessage?chat_id=$chat_id&text=$message&reply_markup=$kb2', NULL, NULL),
(2, '/menu', 1, 'send', 'sendmessage?chat_id=$chat_id&text=$message&reply_markup=$kb2', NULL, NULL),
(3, 'menu', 1, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(4, 'products', 2, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(5, 'social', 4, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(6, 'cat1', 6, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(7, 'cat2', 6, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(8, 'cat3', 6, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(9, 'cat4', 7, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(10, 'cat5', 7, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(11, 'cat6', 8, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(12, 'kar1', 9, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(13, 'kar2', 9, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(14, 'kar3', 9, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(15, 'kar4', 9, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(16, 'kar5', 9, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(17, 'kar6', 9, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(18, 'cat6_1', 10, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(19, 'cat6_2', 10, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(20, 'cat6_3', 10, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(21, 'cat6_4', 10, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(22, 'kaf', 11, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(23, 'divar', 11, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(24, 'color1', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(25, 'color2', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(26, 'color3', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(27, 'color4', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(28, 'color5', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(29, 'color6', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(30, 'color7', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(31, 'color8', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(32, 'color9', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(33, 'color10', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(34, 'color11', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(35, 'color12', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(36, 'color13', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(37, 'color14', 12, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(38, 'sabk1', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(39, 'sabk2', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(40, 'sabk3', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(41, 'sabk4', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(42, 'sabk5', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(43, 'sabk6', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(44, 'sabk7', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(45, 'sabk8', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(46, 'sabk9', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL),
(47, 'sabk10', 13, 'edit', 'editmessagetext?chat_id=$chat_id&message_id=$message_id&text=$message&reply_markup=$kb2', NULL, NULL);

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

--
-- Table structure for table `case_step_details`
--

DROP TABLE IF EXISTS `case_step_details`;
CREATE TABLE IF NOT EXISTS `case_step_details` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `case_step_id` int(11) DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci,
  `callback` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chunk` int(11) DEFAULT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `case_step_details`
--

INSERT INTO `case_step_details` (`id`, `case_step_id`, `message`, `callback`, `chunk`, `type`, `created_at`, `updated_at`) VALUES
(1, 1, 'سلام  $FirstName $LastName  عزیز!  $line_url به ربات سرام پخش خوش آمدید. 😍', '/start', 1, 'send', NULL, NULL),
(3, 4, 'سرام پخش را در شبکه های اجتماعی حمایت کنید  😍', 'menu', 2, 'edit', NULL, NULL),
(4, 1, 'لطفا یکی از گزینه های زیر را انتخاب کنید 👇 ', '/start', 1, 'edit', NULL, NULL),
(5, 2, 'لطفا دسته بندی مورد نظر خود را انتخاب کنید 👇', 'menu', 2, 'edit', NULL, NULL),
(6, 6, 'لطفا کاربری مورد نظر خود را انتخاب کنید 👇', 'products', 2, 'edit', NULL, NULL),
(7, 7, '🔍 در حال جستجوی اطلاعات مورد نظر شما هستیم. $line_url ⏳ لطفا منتظر بمانید', 'products', 2, 'edit', NULL, NULL),
(8, 8, 'لطفا دسته بندی مورد نظر خود را انتخاب کنید 👇', 'products', 2, 'edit', NULL, NULL),
(9, 9, 'لطفا محل نصب مورد نظر خود را انتخاب کنید 👇', 'kar1', 2, 'edit', NULL, NULL),
(10, 10, '🔍 در حال جستجوی اطلاعات مورد نظر شما هستیم. $line_url ⏳ لطفا منتظر بمانید', '', 2, 'edit', NULL, NULL),
(11, 11, 'لطفا رنگ مورد نظر خود را انتخاب کنید 👇', '', 2, 'edit', NULL, NULL),
(12, 12, 'لطفا طرح مورد نظر خود را انتخاب کنید 👇', '', 2, 'edit', NULL, NULL),
(13, 13, '🔍 در حال جستجوی اطلاعات مورد نظر شما هستیم. $line_url ⏳ لطفا منتظر بمانید', '', 2, 'edit', NULL, NULL);

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

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `inline_keyboard_menus`
--

DROP TABLE IF EXISTS `inline_keyboard_menus`;
CREATE TABLE IF NOT EXISTS `inline_keyboard_menus` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `case_step_id` int(11) NOT NULL,
  `case_step_detail_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `callback` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` text COLLATE utf8mb4_unicode_ci,
  `orderby` int(11) DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inline_keyboard_menus`
--

INSERT INTO `inline_keyboard_menus` (`id`, `case_step_id`, `case_step_detail_id`, `name`, `callback`, `url`, `orderby`, `slug`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'لیست محصولات', 'products', NULL, 1, NULL, NULL, NULL),
(2, 1, 1, 'شبکه های اجتماعی', 'social', NULL, 2, NULL, NULL, NULL),
(3, 4, 3, 'وب سایت', NULL, 'https://cerampakhsh.com', 1, NULL, NULL, NULL),
(4, 4, 3, 'اینستاگرام', NULL, 'https://instagram.com/cerampakhsh', 2, NULL, NULL, NULL),
(5, 4, 3, 'تلگرام', NULL, 'https://t.me/cerampakhsh_iran', 3, NULL, NULL, NULL),
(6, 4, 3, 'یوتیوب', NULL, 'https://youtube.com/cerampakhsh', 4, NULL, NULL, NULL),
(7, 4, 3, 'آپارات', NULL, 'https://aparat.com/cerampakhsh', 5, NULL, NULL, NULL),
(8, 4, 3, 'نماشا', NULL, 'https://namasha.com/cerampakhsh', 6, NULL, NULL, NULL),
(9, 4, 3, 'تماشا', NULL, 'https://tamasha.com/cerampakhsh', 7, NULL, NULL, NULL),
(10, 4, 3, 'پینترست', NULL, 'https://pinterest.com/cerampakhsh', 8, NULL, NULL, NULL),
(11, 4, 3, 'فیسبوک', NULL, 'https://facebook.com/Cerampakhsh', 9, NULL, NULL, NULL),
(12, 4, 3, 'لینکدین', NULL, 'https://linkedin.com/in/cerampakhsh', 10, NULL, NULL, NULL),
(13, 4, 3, '↩️ برگشت', 'menu', NULL, 11, NULL, NULL, NULL),
(14, 2, 4, 'کاشی و سرامیک', 'cat1', NULL, 1, NULL, NULL, NULL),
(15, 2, 4, 'سنگ و موزاییک', 'cat2', NULL, 2, NULL, NULL, NULL),
(18, 2, 4, 'چینی بهداشتی', 'cat5', NULL, 5, NULL, NULL, NULL),
(16, 2, 4, 'پرسلان', 'cat3', NULL, 3, NULL, NULL, NULL),
(17, 2, 4, 'اکسسوری و شیرآلات', 'cat4', NULL, 4, NULL, NULL, NULL),
(19, 2, 4, 'ابزارآلات نصب', 'cat6', NULL, 6, NULL, NULL, NULL),
(20, 2, 4, '↩️ برگشت', 'menu', NULL, 7, NULL, NULL, NULL),
(21, 6, 6, 'آشپزخانه', 'kar1', NULL, 1, NULL, NULL, NULL),
(22, 6, 6, 'دستشویی و حمام', 'kar2', NULL, 2, NULL, NULL, NULL),
(23, 6, 6, 'اتاق و پذیرایی', 'kar3', NULL, 3, NULL, NULL, NULL),
(24, 6, 6, 'نما و راهرو', 'kar4', NULL, 4, NULL, NULL, NULL),
(25, 6, 6, 'تجاری و پارکینگ', 'kar5', NULL, 5, NULL, NULL, NULL),
(26, 6, 6, 'مینیاتوری و استخری', 'kar6', NULL, 6, NULL, NULL, NULL),
(27, 6, 6, '↩️ برگشت', 'products', NULL, 7, NULL, NULL, NULL),
(28, 7, 7, '↩️ برگشت', 'products', NULL, 1, NULL, NULL, NULL),
(29, 8, 8, 'تخریب و محاسبه', 'cat6_1', NULL, 1, NULL, NULL, NULL),
(30, 8, 8, 'مصالح', 'cat6_2', NULL, 2, NULL, NULL, NULL),
(31, 8, 8, 'تجهیزات نصب', 'cat6_3', NULL, 3, NULL, NULL, NULL),
(32, 8, 8, 'نظافت', 'cat6_4', NULL, 4, NULL, NULL, NULL),
(33, 8, 8, '↩️ برگشت', 'products', NULL, 5, NULL, NULL, NULL),
(34, 9, 9, 'کف', 'kaf', NULL, 1, NULL, NULL, NULL),
(35, 9, 9, 'دیوار', 'divar', NULL, 2, NULL, NULL, NULL),
(36, 9, 9, '↩️ برگشت', 'cat1', NULL, 3, NULL, NULL, NULL),
(37, 10, 10, '↩️ برگشت', 'products', NULL, 1, NULL, NULL, NULL),
(38, 11, 11, 'سفید', 'color1', NULL, 1, NULL, NULL, NULL),
(39, 11, 11, 'خاکستری', 'color2', NULL, 2, NULL, NULL, NULL),
(40, 11, 11, 'سبز', 'color3', NULL, 3, NULL, NULL, NULL),
(41, 11, 11, 'کرم', 'color4', NULL, 4, NULL, NULL, NULL),
(42, 11, 11, 'بژ', 'color5', NULL, 5, NULL, NULL, NULL),
(43, 11, 11, 'صورتی', 'color6', NULL, 6, NULL, NULL, NULL),
(44, 11, 11, 'آبی', 'color7', NULL, 7, NULL, NULL, NULL),
(45, 11, 11, 'زرد', 'color8', NULL, 8, NULL, NULL, NULL),
(46, 11, 11, 'قرمز', 'color9', NULL, 9, NULL, NULL, NULL),
(47, 11, 11, 'قهوه ای', 'color10', NULL, 10, NULL, NULL, NULL),
(48, 11, 11, 'نارنجی', 'color11', NULL, 11, NULL, NULL, NULL),
(49, 11, 11, 'بنفش', 'color12', NULL, 12, NULL, NULL, NULL),
(50, 11, 11, 'سیاه', 'color13', NULL, 12, NULL, NULL, NULL),
(51, 11, 11, 'چندرنگ', 'color14', NULL, 13, NULL, NULL, NULL),
(52, 11, 11, '↩️ برگشت', 'kar1', NULL, 1, NULL, NULL, NULL),
(53, 12, 12, 'چوب', 'sabk1', NULL, 1, NULL, NULL, NULL),
(54, 12, 12, 'آجر و بتن', 'sabk2', NULL, 2, NULL, NULL, NULL),
(55, 12, 12, 'هندسی', 'sabk3', NULL, 3, NULL, NULL, NULL),
(56, 12, 12, 'سنگ', 'sabk4', NULL, 4, NULL, NULL, NULL),
(57, 12, 12, 'کاغذ دیواری', 'sabk5', NULL, 5, NULL, NULL, NULL),
(58, 12, 12, 'طرح فلز', 'sabk6', NULL, 6, NULL, NULL, NULL),
(59, 12, 12, 'ساده', 'sabk7', NULL, 7, NULL, NULL, NULL),
(60, 12, 12, 'پریکات', 'sabk8', NULL, 8, NULL, NULL, NULL),
(61, 12, 12, 'بوک مچ', 'sabk9', NULL, 9, NULL, NULL, NULL),
(62, 12, 12, 'تزئینی', 'sabk10', NULL, 10, NULL, NULL, NULL),
(63, 12, 12, '↩️ برگشت', 'kaf', NULL, 11, NULL, NULL, NULL),
(64, 13, 13, '↩️ برگشت', 'color1', NULL, 1, NULL, NULL, NULL);

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

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

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, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2021_03_16_080250_create_case_steps_table', 1),
(5, '2021_03_16_080407_create_case_step_details_table', 1),
(6, '2021_03_16_080603_create_inline_keyboard_menus_table', 1);

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

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE IF NOT EXISTS `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,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT 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,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
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 */;
