text: -- phpMyAdmin SQL Dump
  -- version 4.8.5
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Dec 01, 2019 at 10:37 PM
  -- Server version: 10.1.40-MariaDB
  -- PHP Version: 7.3.5
  
  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: `ecommerce`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admins`
  --
  
  CREATE TABLE `admins` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Super Admin' COMMENT 'Admin|Super Admin',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `admins`
  --
  
  INSERT INTO `admins` (`id`, `name`, `email`, `password`, `phone_no`, `avatar`, `remember_token`, `type`, `created_at`, `updated_at`) VALUES
  (2, 'Farhan Israk', 'farhanisrak.yen29@gmail.com', '$2y$10$2IEyNA9Ix98ML9xCkSjm.eZf.RvN3STMQVXkEwBlij.FKhkK0LP2K', '01969279140', NULL, '9MAgKV1Ily0J5Zwq1xcr9pe5IYscdnQvy2oPob68z7RxCJOsyNp470YQ6wzH', 'Super Admin', '2019-09-04 10:29:22', '2019-09-06 08:45:46');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `brands`
  --
  
  CREATE TABLE `brands` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `brands`
  --
  
  INSERT INTO `brands` (`id`, `name`, `description`, `image`, `created_at`, `updated_at`) VALUES
  (1, 'Indra', 'adsa asd asd', '1564511335.jpg', '2019-07-30 12:28:55', '2019-07-30 12:28:55');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `carts`
  --
  
  CREATE TABLE `carts` (
    `id` int(10) UNSIGNED NOT NULL,
    `product_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED DEFAULT NULL,
    `order_id` int(10) UNSIGNED DEFAULT NULL,
    `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `product_quantity` int(11) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `carts`
  --
  
  INSERT INTO `carts` (`id`, `product_id`, `user_id`, `order_id`, `ip_address`, `product_quantity`, `created_at`, `updated_at`) VALUES
  (1, 8, 8, 6, '127.0.0.1', 3, '2019-10-25 13:53:35', '2019-10-25 13:54:34'),
  (2, 7, 8, 6, '127.0.0.1', 1, '2019-10-25 13:53:42', '2019-10-25 13:54:34');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE `categories` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `categories`
  --
  
  INSERT INTO `categories` (`id`, `name`, `description`, `image`, `parent_id`, `created_at`, `updated_at`) VALUES
  (2, 'Balloons', NULL, '1564357526.png', NULL, '2019-07-28 17:45:26', '2019-07-28 17:45:26'),
  (3, 'Foil Balloons', NULL, '1564357567.jpg', 2, '2019-07-28 17:46:08', '2019-07-28 17:46:08'),
  (4, 'Light', 'asd sadas', '1564426956.jpg', NULL, '2019-07-29 13:02:36', '2019-07-29 13:02:36'),
  (5, 'Fairy Lights', 'asd asd asd', '1564426988.jpg', 4, '2019-07-29 13:03:08', '2019-07-29 13:03:08');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `districts`
  --
  
  CREATE TABLE `districts` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `division_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `districts`
  --
  
  INSERT INTO `districts` (`id`, `name`, `division_id`, `created_at`, `updated_at`) VALUES
  (2, 'Dhaka', 2, '2019-08-11 18:00:31', '2019-08-11 18:00:31'),
  (3, 'Faridpur', 2, '2019-08-11 18:00:46', '2019-08-11 18:00:46'),
  (4, 'Gazipur', 2, '2019-08-11 18:00:57', '2019-08-11 18:00:57'),
  (5, 'Gopalganj', 2, '2019-08-11 18:01:12', '2019-08-11 18:01:12');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `divisions`
  --
  
  CREATE TABLE `divisions` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `priority` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `divisions`
  --
  
  INSERT INTO `divisions` (`id`, `name`, `priority`, `created_at`, `updated_at`) VALUES
  (2, 'Dhaka', 1, '2019-08-11 17:55:38', '2019-08-11 17:55:38'),
  (3, 'Barishal', 2, '2019-08-11 17:57:14', '2019-08-11 17:57:14'),
  (4, 'Chottogram', 3, '2019-08-11 17:57:34', '2019-08-11 17:57:34'),
  (5, 'Khulna', 4, '2019-08-11 17:57:54', '2019-08-11 17:57:54'),
  (6, 'Mymensingh', 5, '2019-08-11 17:58:14', '2019-08-11 17:58:14'),
  (7, 'Rajshahi', 6, '2019-08-11 17:58:29', '2019-08-11 17:58:29'),
  (8, 'Rangpur', 7, '2019-08-11 17:58:42', '2019-08-11 17:58:42'),
  (9, 'Sylhet', 8, '2019-08-11 17:59:00', '2019-08-11 17:59:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `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;
  
  --
  -- 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', 2),
  (3, '2019_06_02_105705_create_admins_table', 3),
  (4, '2019_07_26_230005_create_categories_table', 3),
  (5, '2019_07_26_230046_create_products_table', 3),
  (6, '2019_07_26_230104_create_brands_table', 3),
  (7, '2019_07_26_230143_create_product_images_table', 3),
  (8, '2019_07_26_230207_create_divisions_table', 3),
  (9, '2019_07_26_230225_create_districts_table', 3),
  (10, '2019_07_26_230242_create_orders_table', 4),
  (11, '2019_07_26_230257_create_carts_table', 4),
  (12, '2019_07_26_230315_create_settings_table', 4),
  (13, '2019_07_26_230332_create_payments_table', 5),
  (14, '2019_07_26_230347_create_sliders_table', 5);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `orders`
  --
  
  CREATE TABLE `orders` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED DEFAULT NULL,
    `payment_id` int(10) UNSIGNED DEFAULT NULL,
    `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `shipping_address` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `message` text COLLATE utf8mb4_unicode_ci,
    `is_paid` tinyint(1) NOT NULL DEFAULT '0',
    `is_completed` tinyint(1) NOT NULL DEFAULT '0',
    `is_seen_by_admin` tinyint(1) NOT NULL DEFAULT '0',
    `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `shipping_charge` int(11) NOT NULL DEFAULT '100',
    `custom_discount` int(11) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `orders`
  --
  
  INSERT INTO `orders` (`id`, `user_id`, `payment_id`, `ip_address`, `name`, `phone_no`, `shipping_address`, `email`, `message`, `is_paid`, `is_completed`, `is_seen_by_admin`, `transaction_id`, `created_at`, `updated_at`, `shipping_charge`, `custom_discount`) VALUES
  (1, 8, 1, '::1', 'Israk', '1969279140', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 'hydro.toluyn@gmail.com', NULL, 0, 0, 1, NULL, '2019-09-06 17:39:57', '2019-09-06 17:40:51', 100, 0),
  (2, 8, 1, '::1', 'Farhan Israk', '1969279140', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 'hydro.toluyn@gmail.com', NULL, 0, 0, 1, NULL, '2019-09-06 17:51:30', '2019-09-06 18:03:44', 100, 50),
  (3, 8, 1, '::1', 'Farhan Israk', '1969279140', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 'hydro.toluyn@gmail.com', NULL, 0, 0, 1, NULL, '2019-09-07 14:31:40', '2019-09-07 14:32:12', 100, 0),
  (4, 8, 2, '::1', 'Farhan Israk', '1969279140', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 'hydro.toluyn@gmail.com', NULL, 0, 0, 1, '123123123123', '2019-09-08 09:24:12', '2019-09-08 09:24:59', 100, 0),
  (5, NULL, 1, '127.0.0.1', 'Farhan Israk', '1969279140', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 'hydro.toluyn@gmail.com', NULL, 0, 0, 0, NULL, '2019-09-22 10:37:48', '2019-09-22 10:37:48', 100, 0),
  (6, 8, 1, '127.0.0.1', 'Farhan Israk', '1969279140', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 'hydro.toluyn@gmail.com', NULL, 0, 0, 0, NULL, '2019-10-25 13:54:34', '2019-10-25 13:54:34', 100, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payments`
  --
  
  CREATE TABLE `payments` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `priority` tinyint(4) NOT NULL DEFAULT '1',
    `short_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Payment No',
    `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'agent|personal',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `payments`
  --
  
  INSERT INTO `payments` (`id`, `name`, `image`, `priority`, `short_name`, `no`, `type`, `created_at`, `updated_at`) VALUES
  (1, 'Cash On Delivery', 'cash.jpg', 1, 'cash_in', NULL, NULL, NULL, NULL),
  (2, 'Bkash', 'bkash.jpg', 2, 'bkash', '01969279140', 'Personal', '2019-09-06 23:24:28', '2019-09-06 23:24:28'),
  (3, 'Rocket', 'rocket.jpg', 3, 'rocket', '01969279140', 'Personal', '2019-09-06 23:26:05', '2019-09-06 23:26:05'),
  (4, 'Nogod', 'nogod.jpg', 4, 'nogod', '01969279140', 'Personal', '2019-09-06 23:27:11', '2019-09-06 23:27:11');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `products`
  --
  
  CREATE TABLE `products` (
    `id` int(10) UNSIGNED NOT NULL,
    `category_id` int(10) UNSIGNED NOT NULL,
    `brand_id` int(10) UNSIGNED NOT NULL,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `quantity` int(11) NOT NULL DEFAULT '1',
    `price` int(11) NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '0',
    `offer_price` int(11) DEFAULT NULL,
    `admin_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `products`
  --
  
  INSERT INTO `products` (`id`, `category_id`, `brand_id`, `title`, `description`, `slug`, `quantity`, `price`, `status`, `offer_price`, `admin_id`, `created_at`, `updated_at`) VALUES
  (6, 2, 1, 'A', 'asdad', 'a', 12, 12000, 0, NULL, 1, '2019-08-20 13:31:48', '2019-08-20 13:31:48'),
  (7, 2, 1, 'B', 'dad', 'b', 1, 11000, 0, NULL, 1, '2019-08-20 13:32:15', '2019-08-20 13:32:15'),
  (8, 3, 1, 'C', 'safsdfgsd', 'c', 2, 10000, 0, NULL, 1, '2019-08-20 13:32:39', '2019-08-20 13:32:39'),
  (9, 5, 1, 'D', 'dasdas asfsad', 'd', 5, 12000, 0, NULL, 1, '2019-09-08 14:13:18', '2019-09-08 14:13:18');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_images`
  --
  
  CREATE TABLE `product_images` (
    `id` int(10) UNSIGNED NOT NULL,
    `product_id` int(10) UNSIGNED NOT NULL,
    `image` varchar(255) 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;
  
  --
  -- Dumping data for table `product_images`
  --
  
  INSERT INTO `product_images` (`id`, `product_id`, `image`, `created_at`, `updated_at`) VALUES
  (1, 3, '1564344545.jpg', '2019-07-28 14:09:06', '2019-07-28 14:09:06'),
  (2, 3, '1564344546.jpg', '2019-07-28 14:09:07', '2019-07-28 14:09:07'),
  (3, 4, '1564344592.jpg', '2019-07-28 14:09:53', '2019-07-28 14:09:53'),
  (4, 4, '1564344593.jpg', '2019-07-28 14:09:53', '2019-07-28 14:09:53'),
  (5, 1, '1564347468.jpg', '2019-07-28 14:57:49', '2019-07-28 14:57:49'),
  (6, 5, '1564511385.jpg', '2019-07-30 12:29:45', '2019-07-30 12:29:45'),
  (7, 6, '1566329509.jpg', '2019-08-20 13:31:49', '2019-08-20 13:31:49'),
  (8, 7, '1566329535.jpg', '2019-08-20 13:32:15', '2019-08-20 13:32:15'),
  (9, 8, '1566329559.jpg', '2019-08-20 13:32:39', '2019-08-20 13:32:39'),
  (10, 9, '15679735980.jpg', '2019-09-08 14:13:19', '2019-09-08 14:13:19');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `settings`
  --
  
  CREATE TABLE `settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `shipping_cost` int(10) UNSIGNED NOT NULL DEFAULT '100',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sliders`
  --
  
  CREATE TABLE `sliders` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `button_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `button_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `priority` tinyint(3) UNSIGNED NOT NULL DEFAULT '10',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `street_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `division_id` int(10) UNSIGNED NOT NULL COMMENT 'Division Table ID',
    `district_id` int(10) UNSIGNED NOT NULL COMMENT 'District Table ID',
    `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0=Inactive|1=Active|2=Ban',
    `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `shipping_address` text COLLATE utf8mb4_unicode_ci,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `phone_no`, `email`, `password`, `street_address`, `division_id`, `district_id`, `status`, `ip_address`, `avatar`, `shipping_address`, `remember_token`, `created_at`, `updated_at`) VALUES
  (8, 'Farhan', 'Israk', 'farhanisrak', '1969279140', 'hydro.toluyn@gmail.com', '$2y$10$zSF7yxhF.IR90HtdrPVxBen.8h5M3bjtsf3XcSQuOGoaFmrn9baPa', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 2, 2, 1, '::1', NULL, '75/1,SharatGupta Road,Narinda,Dhaka-1100', 'VrdhcoQJ4RjuhPjavby2XqjerTB8uDWspZPmkNbMB9PMTEg1zi7ug2qvtwrt', '2019-08-17 17:58:04', '2019-09-06 17:04:09'),
  (10, 'ABC', 'Israk', 'abcisrak', '19692791400', 'farhanisrak.yen29@gmail.com', '$2y$10$K37h5jROHbHcK.RcI40feeX14h.7NO90BKYVWzolZK8cx4TUvlyfK', '75/1,SharatGupta Road,Narinda,Dhaka-1100', 2, 2, 1, '::1', NULL, NULL, '9c2mnNZErf0ZFSX5mxwr4GF4NlGByG2YkwJrHzBw2WxEdwj73sBo83SdMESS', '2019-08-17 18:03:34', '2019-08-17 18:04:01');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `admins`
  --
  ALTER TABLE `admins`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `email` (`email`);
  
  --
  -- Indexes for table `brands`
  --
  ALTER TABLE `brands`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `carts`
  --
  ALTER TABLE `carts`
    ADD PRIMARY KEY (`id`),
    ADD KEY `carts_user_id_foreign` (`user_id`),
    ADD KEY `carts_product_id_foreign` (`product_id`),
    ADD KEY `carts_order_id_foreign` (`order_id`);
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `districts`
  --
  ALTER TABLE `districts`
    ADD PRIMARY KEY (`id`),
    ADD KEY `districts_division_id_foreign` (`division_id`);
  
  --
  -- Indexes for table `divisions`
  --
  ALTER TABLE `divisions`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `orders`
  --
  ALTER TABLE `orders`
    ADD PRIMARY KEY (`id`),
    ADD KEY `user_id` (`user_id`),
    ADD KEY `orders_ibfk_1` (`payment_id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `email` (`email`(191)),
    ADD KEY `email_2` (`email`(191));
  
  --
  -- Indexes for table `payments`
  --
  ALTER TABLE `payments`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `short_name` (`short_name`);
  
  --
  -- Indexes for table `products`
  --
  ALTER TABLE `products`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_images`
  --
  ALTER TABLE `product_images`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `settings`
  --
  ALTER TABLE `settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `sliders`
  --
  ALTER TABLE `sliders`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `id` (`id`),
    ADD UNIQUE KEY `username` (`username`),
    ADD UNIQUE KEY `email` (`email`),
    ADD UNIQUE KEY `phone_no` (`phone_no`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `admins`
  --
  ALTER TABLE `admins`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `brands`
  --
  ALTER TABLE `brands`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `carts`
  --
  ALTER TABLE `carts`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `districts`
  --
  ALTER TABLE `districts`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `divisions`
  --
  ALTER TABLE `divisions`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
  
  --
  -- AUTO_INCREMENT for table `orders`
  --
  ALTER TABLE `orders`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `payments`
  --
  ALTER TABLE `payments`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `products`
  --
  ALTER TABLE `products`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT for table `product_images`
  --
  ALTER TABLE `product_images`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT for table `settings`
  --
  ALTER TABLE `settings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `sliders`
  --
  ALTER TABLE `sliders`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `carts`
  --
  ALTER TABLE `carts`
    ADD CONSTRAINT `carts_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `carts_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `districts`
  --
  ALTER TABLE `districts`
    ADD CONSTRAINT `districts_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `orders`
  --
  ALTER TABLE `orders`
    ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE;
  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 */;
  