text: -- phpMyAdmin SQL Dump
  -- version 4.8.5
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Apr 28, 2021 at 05:45 AM
  -- Server version: 10.1.38-MariaDB
  -- PHP Version: 7.3.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 */;
  
  --
  -- Database: `laravel8`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `brands`
  --
  
  CREATE TABLE IF NOT EXISTS `brands` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `brand_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `brand_image` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `brands`
  --
  
  INSERT INTO `brands` (`id`, `brand_name`, `brand_image`, `created_at`, `updated_at`) VALUES
  (3, 'Brand-3', 'images/brand/1697807186340483.png', '2021-04-05 23:27:41', '2021-04-22 22:18:27'),
  (4, 'Brand-2', 'images/brand/1697807170897693.png', '2021-04-05 23:28:21', '2021-04-22 22:18:13'),
  (5, 'Brand-1', 'images/brand/1697807154808589.png', '2021-04-05 23:54:47', '2021-04-22 22:17:57'),
  (7, 'Brand-4', 'images/brand/1697807202130303.png', '2021-04-22 22:18:42', NULL),
  (8, 'Brand-5', 'images/brand/1697807213093887.png', '2021-04-22 22:18:53', NULL),
  (9, 'Brand-6', 'images/brand/1697807224350350.png', '2021-04-22 22:19:04', NULL),
  (10, 'Brand-7', 'images/brand/1697807232304902.png', '2021-04-22 22:19:11', NULL),
  (11, 'Brand-8', 'images/brand/1697807240882345.png', '2021-04-22 22:19:19', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE IF NOT EXISTS `categories` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `category_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `categories`
  --
  
  INSERT INTO `categories` (`id`, `user_id`, `category_name`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (1, 2, 'Sea Fish', '2021-03-19 04:09:56', NULL, NULL),
  (2, 3, 'Women', '2021-03-19 04:11:41', NULL, NULL),
  (3, 3, 'Organic', '2021-03-19 04:14:32', '2021-03-31 01:30:50', NULL),
  (5, 3, 'Food', '2021-03-19 04:21:51', '2021-03-31 01:35:45', NULL),
  (6, 1, 'Golang', '2021-03-19 04:22:09', '2021-03-31 01:35:59', NULL),
  (8, 1, 'Jean Men', '2021-03-19 04:29:28', '2021-03-31 01:30:59', '2021-03-31 01:30:59'),
  (9, 1, 'Short', '2021-03-30 21:25:46', '2021-03-31 01:31:27', '2021-03-31 01:31:27');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contacts`
  --
  
  CREATE TABLE IF NOT EXISTS `contacts` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `email` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `phone` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `address` text COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `contacts`
  --
  
  INSERT INTO `contacts` (`id`, `email`, `phone`, `address`, `created_at`, `updated_at`) VALUES
  (1, 'info@example.com', '+1 5589 55488 51', 'A108 Adam Street New York, NY 535022', '2021-04-26 04:55:39', '2021-04-27 19:00:39');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contact_forms`
  --
  
  CREATE TABLE IF NOT EXISTS `contact_forms` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `subject` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `message` text COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `contact_forms`
  --
  
  INSERT INTO `contact_forms` (`id`, `name`, `email`, `subject`, `message`, `created_at`, `updated_at`) VALUES
  (11, 'Hà Bích Trâm', 'tramha@gmail.com', 'I need phone number!', 'Plz! sent for me the phone number, thanks!', '2021-04-26 20:59:33', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `failed_jobs`
  --
  
  CREATE TABLE IF NOT EXISTS `failed_jobs` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `uuid` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `connection` text COLLATE utf8_unicode_ci NOT NULL,
    `queue` text COLLATE utf8_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `home_abouts`
  --
  
  CREATE TABLE IF NOT EXISTS `home_abouts` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `big_title` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `title` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `short_discription` text COLLATE utf8_unicode_ci NOT NULL,
    `long_discription` text COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `home_abouts`
  --
  
  INSERT INTO `home_abouts` (`id`, `big_title`, `title`, `short_discription`, `long_discription`, `created_at`, `updated_at`) VALUES
  (1, 'ABOUT US1', 'EUM IPSAM LABORUM DELENITI VELITENA', 'Voluptatem dignissimos provident quasi corporis voluptates sit assum perenda sruen jonee trave', 'Ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum\r\n\r\nUllamco laboris nisi ut aliquip ex ea commodo consequa\r\nDuis aute irure dolor in reprehenderit in voluptate velit\r\nUllamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '2021-04-26 01:30:35', '2021-04-27 18:59:03');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE IF NOT EXISTS `migrations` (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `migration` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_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, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
  (4, '2019_08_19_000000_create_failed_jobs_table', 1),
  (5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
  (6, '2021_03_17_110518_create_sessions_table', 1),
  (7, '2021_03_18_045945_create_categories_table', 2),
  (8, '2021_04_01_025831_create_brands_table', 3),
  (9, '2021_04_06_071243_create_multipics_table', 4),
  (10, '2021_04_23_100654_create_sliders_table', 5),
  (11, '2021_04_23_122107_create_home_abouts_table', 6),
  (12, '2021_04_26_111313_create_contacts_table', 7),
  (13, '2021_04_26_122042_create_contact_forms_table', 8);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `multipics`
  --
  
  CREATE TABLE IF NOT EXISTS `multipics` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `image` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `multipics`
  --
  
  INSERT INTO `multipics` (`id`, `image`, `created_at`, `updated_at`) VALUES
  (1, 'images/multi/1697727415990533.png', '2021-04-22 01:10:33', NULL),
  (2, 'images/multi/1697727416176113.png', '2021-04-22 01:10:33', NULL),
  (3, 'images/multi/1697730452432732.png', '2021-04-22 01:58:48', NULL),
  (4, 'images/multi/1697730452538127.png', '2021-04-22 01:58:48', NULL),
  (5, 'images/multi/1697730452663537.png', '2021-04-22 01:58:49', NULL),
  (6, 'images/multi/1698248315828854.png', '2021-04-27 19:10:01', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `password_resets`
  --
  
  CREATE TABLE IF NOT EXISTS `password_resets` (
    `email` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `personal_access_tokens`
  --
  
  CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `tokenable_type` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `tokenable_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
    `abilities` text COLLATE utf8_unicode_ci,
    `last_used_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
    KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sessions`
  --
  
  CREATE TABLE IF NOT EXISTS `sessions` (
    `id` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `user_id` bigint(20) UNSIGNED DEFAULT NULL,
    `ip_address` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
    `user_agent` text COLLATE utf8_unicode_ci,
    `payload` text COLLATE utf8_unicode_ci NOT NULL,
    `last_activity` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `sessions_user_id_index` (`user_id`),
    KEY `sessions_last_activity_index` (`last_activity`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `sessions`
  --
  
  INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
  ('D4K8nGC0UD3manasVpdxUJqUf1IDppQoLSeVJOZx', 4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36', 'YTo3OntzOjM6InVybCI7YTowOnt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9jb250YWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo2OiJfdG9rZW4iO3M6NDA6IkpuamtBTGpiZHdHaUJybnlsVVFGWXNKcFNoZjRxM0l0UjN2c2Rod0kiO3M6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjQ7czoxNzoicGFzc3dvcmRfaGFzaF93ZWIiO3M6NjA6IiQyeSQxMCRsN3VRYm9WVnRzSUZZNklSNWdyTzIuTDVZcUNUT0k4eFdOUjFyYkRPSFZKQzF0TkF4dEtrSyI7czoyMToicGFzc3dvcmRfaGFzaF9zYW5jdHVtIjtzOjYwOiIkMnkkMTAkbDd1UWJvVlZ0c0lGWTZJUjVnck8yLkw1WXFDVE9JOHhXTlIxcmJET0hWSkMxdE5BeHRLa0siO30=', 1619581214);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sliders`
  --
  
  CREATE TABLE IF NOT EXISTS `sliders` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `title` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8_unicode_ci,
    `link` varchar(191) CHARACTER SET utf8 DEFAULT NULL,
    `text_button` varchar(191) CHARACTER SET utf8 DEFAULT NULL,
    `image` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `sliders`
  --
  
  INSERT INTO `sliders` (`id`, `title`, `description`, `link`, `text_button`, `image`, `created_at`, `updated_at`) VALUES
  (1, 'Welcome to Company', 'Ut velit est quam dolor ad a aliquid qui aliquid. Sequi ea ut et est quaerat sequi nihil ut aliquam. Occaecati alias dolorem mollitia ut. Similique ea voluptatem. Esse doloremque accusamus repellendus deleniti vel. Minus et tempore modi architecto.', 'https://getbootstrap.com/', NULL, 'images/slider/1697829524697632.jpg', '2021-04-23 04:13:31', '2021-04-23 05:18:09'),
  (2, 'Lorem Ipsum Dolor', 'Ut velit est quam dolor ad a aliquid qui aliquid. Sequi ea ut et est quaerat sequi nihil ut aliquam. Occaecati alias dolorem mollitia ut. Similique ea voluptatem. Esse doloremque accusamus repellendus deleniti vel. Minus et tempore modi architecto.', 'https://www.facebook.com/KenvinNguyen.CB/', 'Facebook Info', 'images/slider/1697829786595235.jpg', '2021-04-23 04:17:41', '2021-04-23 05:11:31'),
  (3, 'Sequi ea ut et est quaerat', 'Ut velit est quam dolor ad a aliquid qui aliquid. Sequi ea ut et est quaerat sequi nihil ut aliquam. Occaecati alias dolorem mollitia ut. Similique ea voluptatem. Esse doloremque accusamus repellendus deleniti vel. Minus et tempore modi architecto.', 'https://laravel.com/', 'Xem Chi Tiết', 'images/slider/1697831814874356.jpg', '2021-04-23 04:18:01', '2021-04-23 05:15:49');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE IF NOT EXISTS `users` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `two_factor_secret` text COLLATE utf8_unicode_ci,
    `two_factor_recovery_codes` text COLLATE utf8_unicode_ci,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `current_team_id` bigint(20) UNSIGNED DEFAULT NULL,
    `profile_photo_path` text COLLATE utf8_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `remember_token`, `current_team_id`, `profile_photo_path`, `created_at`, `updated_at`) VALUES
  (1, 'Kenvin Nguyen', 'nvphuc.adw@gmail.com', '2021-04-22 02:53:46', '$2y$10$cij/D.Y01wEqEYKG2I3KzOphZJjz9RKd32y/xh/B8cKR.JWDlAkPe', NULL, NULL, 'MsnQjkUIw8Q5gwRffRN4aABfXsqrWd3wxV4uvqlAkx5XD0YgzPxLzQJlbuyM', NULL, 'profile-photos/IS7TkxhMncaO0nvlJL7L24WjHcbRZ6KcIMGid6Sy.png', '2021-03-17 17:38:16', '2021-04-27 00:10:51'),
  (2, 'Teresa Teng', 'teresa@gmail.com', NULL, '$2y$10$RrTXv2woz62.AX/IFb/XLOtcRJldE/8.PPUzYuHaj/DK7PuqLYkRu', NULL, NULL, NULL, NULL, NULL, '2021-03-17 20:45:24', '2021-03-17 20:45:24'),
  (3, 'Tester', 'tester@gmail.com', NULL, '$2y$10$YdKEs3GWAvnGWNCdNbo4jOjwcat/H97V/qTOadnvhTccwJvhizvq6', NULL, NULL, NULL, NULL, NULL, '2021-03-17 21:17:16', '2021-03-17 21:17:16'),
  (4, 'Hà Bích Trâm', 'hatram@gmail.com', '2021-04-27 00:25:28', '$2y$10$l7uQboVVtsIFY6IR5grO2.L5YqCTOI8xWNR1rbDOHVJC1tNAxtKkK', NULL, NULL, NULL, NULL, NULL, '2021-04-27 00:17:44', '2021-04-27 18:34:03');
  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 */;
  