-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` int(10) UNSIGNED NOT NULL,
  `brand_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand_native_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand_logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `campaigns`
--

CREATE TABLE `campaigns` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) 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 `campaigns`
--

INSERT INTO `campaigns` (`id`, `title`, `image`, `meta_image`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Halloween Discount', 'banner_image_5f9f9d2d869b9.png', 'meta_image5f9f9c1b00fe5.png', NULL, NULL, 1, '2020-11-02 05:41:47', '2020-11-02 05:46:21'),
(2, 'Hot Deal Offers', 'banner_image_5f9fac3622aad.png', 'meta_image5f9fac36275af.png', NULL, NULL, 1, '2020-11-02 06:50:30', '2020-11-02 06:50:30');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_native_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home_view` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) 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 `categories`
--

INSERT INTO `categories` (`id`, `category_name`, `category_native_name`, `icon`, `home_view`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ladies', 'Nari', '5f97c0b8d78f5.png', 1, 1, '2020-09-22 11:24:10', '2020-10-27 06:39:52'),
(2, 'Gents', 'Purush', '5f97bf4d65ff3.png', 1, 1, '2020-09-22 11:24:27', '2020-10-27 06:33:49'),
(3, 'Baby', 'child', '5f97bf3e4cb3e.png', 1, 1, '2020-09-22 11:24:45', '2020-10-27 06:33:34'),
(4, 'Home', 'kitchen', '5f97bf37d18bc.png', 1, 1, '2020-09-22 11:25:05', '2020-10-27 06:33:27'),
(5, 'Food', 'khabar', '5f97bf1d8e236.png', 1, 1, '2020-09-22 11:25:23', '2020-10-27 06:33:01'),
(6, 'Gadgets', 'GA', '5f97bf2e4e025.png', 1, 1, '2020-09-22 11:25:42', '2020-10-27 06:33:18'),
(7, 'Sports', 'Khela Dula', '5f97bf25d7af2.png', 1, 1, '2020-09-22 11:33:15', '2020-10-27 06:33:09'),
(8, 'Travels', 'Travels', '5f97bf15a6592.png', 1, 1, '2020-09-22 11:38:28', '2020-10-27 06:32:53');

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

--
-- Table structure for table `colors`
--

CREATE TABLE `colors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color_code` varchar(191) 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 `colors`
--

INSERT INTO `colors` (`id`, `name`, `color_code`, `created_at`, `updated_at`) VALUES
(1, 'Blue', '#5ab0d1', '2020-10-27 10:14:38', '2020-10-27 10:14:38'),
(2, 'white', '#ffffff', '2020-10-27 10:14:57', '2020-10-27 10:14:57'),
(3, 'Ofwhite', '#e2e1e0', '2020-10-27 10:15:29', '2020-10-27 10:15:29'),
(4, 'Black', '#000000', '2020-10-28 05:47:06', '2020-10-28 05:47:06'),
(5, 'Brown', '#febc41', '2020-10-28 05:47:24', '2020-10-28 05:47:24'),
(6, 'Navy Blue', '#004080', '2020-10-28 05:47:45', '2020-10-28 05:47:45'),
(7, 'Green', '#008000', '2020-10-28 05:48:22', '2020-10-28 05:48:22'),
(8, 'light pink', '#ffb3d9', '2020-11-01 06:33:17', '2020-11-01 06:33:17'),
(9, 'of red', '#ad3437', '2020-11-01 06:33:59', '2020-11-01 06:33:59'),
(10, 'Fresh', '#80ffff', '2020-11-01 06:39:51', '2020-11-01 06:39:51');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `coupon_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 for Amount, 2 for percentage',
  `amount` double NOT NULL,
  `max_amount_limit` double DEFAULT NULL,
  `valid_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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 `coupons`
--

INSERT INTO `coupons` (`id`, `coupon_code`, `amount_type`, `amount`, `max_amount_limit`, `valid_date`, `status`, `created_at`, `updated_at`) VALUES
(1, 'LLLLLL', 1, 67, 67, '2020-10-16', 1, '2020-10-06 06:48:10', '2020-10-06 06:48:10');

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = inactive 1 = active',
  `status` tinyint(4) 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 `currency`
--

INSERT INTO `currency` (`id`, `country`, `currency`, `code`, `symbol`, `currency_status`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Albania', 'Leke', 'ALL', 'Lek', 0, 1, NULL, NULL),
(2, 'America', 'Dollars', 'USD', '$', 1, 1, NULL, NULL),
(3, 'Afghanistan', 'Afghanis', 'AFN', 'AFN', 0, 1, NULL, NULL),
(4, 'Argentina', 'Pesos', 'ARS', '$', 0, 1, NULL, NULL),
(5, 'Aruba', 'Guilders', 'AWG', 'ƒ', 0, 1, NULL, NULL),
(6, 'Australia', 'Dollars', 'AUD', '$', 0, 1, NULL, NULL),
(7, 'Azerbaijan', 'New Manats', 'AZN', 'ман', 0, 1, NULL, NULL),
(8, 'Bahamas', 'Dollars', 'BSD', '$', 0, 1, NULL, NULL),
(9, 'Barbados', 'Dollars', 'BBD', '$', 0, 1, NULL, NULL),
(10, 'Belarus', 'Rubles', 'BYR', 'p.', 0, 1, NULL, NULL),
(11, 'Belgium', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(12, 'Beliz', 'Dollars', 'BZD', 'BZ$', 0, 1, NULL, NULL),
(13, 'Bermuda', 'Dollars', 'BMD', '$', 0, 1, NULL, NULL),
(14, 'Bolivia', 'Bolivianos', 'BOB', 'b', 0, 1, NULL, NULL),
(15, 'Bosnia and Herzegovina', 'Convertible Marka', 'BAM', 'KM', 0, 1, NULL, NULL),
(16, 'Botswana', 'Pula', 'BWP', 'P', 0, 1, NULL, NULL),
(17, 'Bulgaria', 'Leva', 'BGN', 'лв', 0, 1, NULL, NULL),
(18, 'Brazil', 'Reais', 'BRL', 'R$', 0, 1, NULL, NULL),
(19, 'Britain (United Kingdom)', 'Pounds', 'GBP', '£', 0, 1, NULL, NULL),
(20, 'Brunei Darussalam', 'Dollars', 'BND', '$', 0, 1, NULL, NULL),
(21, 'Cambodia', 'Riels', 'KHR', '៛', 0, 1, NULL, NULL),
(22, 'Canada', 'Dollars', 'CAD', '$', 0, 1, NULL, NULL),
(23, 'Cayman Islands', 'Dollars', 'KYD', '$', 0, 1, NULL, NULL),
(24, 'Chile', 'Pesos', 'CLP', '$', 0, 1, NULL, NULL),
(25, 'China', 'Yuan Renminbi', 'CNY', '¥', 0, 1, NULL, NULL),
(26, 'Colombia', 'Pesos', 'COP', '$', 0, 1, NULL, NULL),
(27, 'Costa Rica', 'Colón', 'CRC', '₡', 0, 1, NULL, NULL),
(28, 'Croatia', 'Kuna', 'HRK', 'kn', 0, 1, NULL, NULL),
(29, 'Cuba', 'Pesos', 'CUP', '₱', 0, 1, NULL, NULL),
(30, 'Cyprus', 'Euro', 'EUR', '€', 0, 1, NULL, '2020-05-11 23:19:27'),
(31, 'Czech Republic', 'Koruny', 'CZK', 'Kč', 0, 1, NULL, NULL),
(32, 'Denmark', 'Kroner', 'DKK', 'kr', 0, 1, NULL, NULL),
(33, 'Dominican Republic', 'Pesos', 'DOP ', 'RD$', 0, 1, NULL, NULL),
(34, 'East Caribbean', 'Dollars', 'XCD', '$', 0, 1, NULL, NULL),
(35, 'Egypt', 'Pounds', 'EGP', '£', 0, 1, NULL, NULL),
(36, 'El Salvador', 'Colones', 'SVC', '$', 0, 1, NULL, NULL),
(37, 'England (United Kingdom)', 'Pounds', 'GBP', '£', 0, 1, NULL, NULL),
(38, 'Euro', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(39, 'Falkland Islands', 'Pounds', 'FKP', '£', 0, 1, NULL, NULL),
(40, 'Fiji', 'Dollars', 'FJD', '$', 0, 1, NULL, NULL),
(41, 'France', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(42, 'Ghana', 'Cedis', 'GHC', '¢', 0, 1, NULL, NULL),
(43, 'Gibraltar', 'Pounds', 'GIP', '£', 0, 1, NULL, NULL),
(44, 'Greece', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(45, 'Guatemala', 'Quetzales', 'GTQ', 'Q', 0, 1, NULL, NULL),
(46, 'Guernsey', 'Pounds', 'GGP', '£', 0, 1, NULL, NULL),
(47, 'Guyana', 'Dollars', 'GYD', '$', 0, 1, NULL, NULL),
(48, 'Holland (Netherlands)', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(49, 'Honduras', 'Lempiras', 'HNL', 'L', 0, 1, NULL, NULL),
(50, 'Hong Kong', 'Dollars', 'HKD', '$', 0, 1, NULL, NULL),
(51, 'Hungary', 'Forint', 'HUF', 'Ft', 0, 1, NULL, NULL),
(52, 'Iceland', 'Kronur', 'ISK', 'kr', 0, 1, NULL, NULL),
(53, 'India', 'Rupees', 'INR', 'Rp', 0, 1, NULL, NULL),
(54, 'Indonesia', 'Rupiahs', 'IDR', 'Rp', 0, 1, NULL, NULL),
(55, 'Iran', 'Rials', 'IRR', '﷼', 0, 1, NULL, NULL),
(56, 'Ireland', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(57, 'Isle of Man', 'Pounds', 'IMP', '£', 0, 1, NULL, NULL),
(58, 'Israel', 'New Shekels', 'ILS', '₪', 0, 1, NULL, NULL),
(59, 'Italy', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(60, 'Jamaica', 'Dollars', 'JMD', 'J$', 0, 1, NULL, NULL),
(61, 'Japan', 'Yen', 'JPY', '¥', 0, 1, NULL, NULL),
(62, 'Jersey', 'Pounds', 'JEP', '£', 0, 1, NULL, NULL),
(63, 'Kazakhstan', 'Tenge', 'KZT', 'лв', 0, 1, NULL, NULL),
(64, 'Korea (North)', 'Won', 'KPW', '₩', 0, 1, NULL, NULL),
(65, 'Korea (South)', 'Won', 'KRW', '₩', 0, 1, NULL, NULL),
(66, 'Kyrgyzstan', 'Soms', 'KGS', 'лв', 0, 1, NULL, NULL),
(67, 'Laos', 'Kips', 'LAK', '₭', 0, 1, NULL, NULL),
(68, 'Latvia', 'Lati', 'LVL', 'Ls', 0, 1, NULL, NULL),
(69, 'Lebanon', 'Pounds', 'LBP', '£', 0, 1, NULL, NULL),
(70, 'Liberia', 'Dollars', 'LRD', '$', 0, 1, NULL, NULL),
(71, 'Liechtenstein', 'Switzerland Francs', 'CHF', 'CHF', 0, 1, NULL, NULL),
(72, 'Lithuania', 'Litai', 'LTL', 'Lt', 0, 1, NULL, NULL),
(73, 'Luxembourg', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(74, 'Macedonia', 'Denars', 'MKD', 'ден', 0, 1, NULL, NULL),
(75, 'Malaysia', 'Ringgits', 'MYR', 'RM', 0, 1, NULL, NULL),
(76, 'Malta', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(77, 'Mauritius', 'Rupees', 'MUR', '₨', 0, 1, NULL, NULL),
(78, 'Mexico', 'Pesos', 'MXN', '$', 0, 1, NULL, NULL),
(79, 'Mongolia', 'Tugriks', 'MNT', '₮', 0, 1, NULL, NULL),
(80, 'Mozambique', 'Meticais', 'MZN', 'MT', 0, 1, NULL, NULL),
(81, 'Namibia', 'Dollars', 'NAD', '$', 0, 1, NULL, NULL),
(82, 'Nepal', 'Rupees', 'NPR', '₨', 0, 1, NULL, NULL),
(83, 'Netherlands Antilles', 'Guilders', 'ANG', 'ƒ', 0, 1, NULL, NULL),
(84, 'Netherlands', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(85, 'New Zealand', 'Dollars', 'NZD', '$', 0, 1, NULL, NULL),
(86, 'Nicaragua', 'Cordobas', 'NIO', 'C$', 0, 1, NULL, NULL),
(87, 'Nigeria', 'Nairas', 'NGN', '₦', 0, 1, NULL, NULL),
(88, 'North Korea', 'Won', 'KPW', '₩', 0, 1, NULL, NULL),
(89, 'Norway', 'Krone', 'NOK', 'kr', 0, 1, NULL, NULL),
(90, 'Oman', 'Rials', 'OMR', '﷼', 0, 1, NULL, NULL),
(91, 'Pakistan', 'Rupees', 'PKR', '₨', 0, 1, NULL, NULL),
(92, 'Panama', 'Balboa', 'PAB', 'B/.', 0, 1, NULL, NULL),
(93, 'Paraguay', 'Guarani', 'PYG', 'Gs', 0, 1, NULL, NULL),
(94, 'Peru', 'Nuevos Soles', 'PEN', 'S/.', 0, 1, NULL, NULL),
(95, 'Philippines', 'Pesos', 'PHP', 'Php', 0, 1, NULL, NULL),
(96, 'Poland', 'Zlotych', 'PLN', 'zł', 0, 1, NULL, NULL),
(97, 'Qatar', 'Rials', 'QAR', '﷼', 0, 1, NULL, NULL),
(98, 'Romania', 'New Lei', 'RON', 'lei', 0, 1, NULL, NULL),
(99, 'Russia', 'Rubles', 'RUB', 'руб', 0, 1, NULL, NULL),
(100, 'Saint Helena', 'Pounds', 'SHP', '£', 0, 1, NULL, NULL),
(101, 'Saudi Arabia', 'Riyals', 'SAR', '﷼', 0, 1, NULL, NULL),
(102, 'Serbia', 'Dinars', 'RSD', 'Дин.', 0, 1, NULL, NULL),
(103, 'Seychelles', 'Rupees', 'SCR', '₨', 0, 1, NULL, NULL),
(104, 'Singapore', 'Dollars', 'SGD', '$', 0, 1, NULL, NULL),
(105, 'Slovenia', 'Euro', 'EUR', '€', 0, 1, NULL, NULL),
(106, 'Solomon Islands', 'Dollars', 'SBD', '$', 0, 1, NULL, NULL),
(107, 'Somalia', 'Shillings', 'SOS', 'S', 0, 1, NULL, NULL),
(108, 'South Africa', 'Rand', 'ZAR', 'R', 0, 1, NULL, NULL),
(109, 'South Korea', 'Won', 'KRW', '₩', 0, 1, NULL, NULL),
(110, 'Spain', 'Euro', 'EUR', '€', 0, 1, NULL, '2020-02-08 18:13:59'),
(111, 'Sri Lanka', 'Rupees', 'LKR', '₨', 0, 1, NULL, '2020-02-02 20:18:58'),
(112, 'Sweden', 'Kronor', 'SEK', 'kr', 0, 1, NULL, NULL),
(113, 'Switzerland', 'Francs', 'CHF', 'CHF', 0, 1, NULL, '2020-02-02 22:35:58'),
(114, 'Suriname', 'Dollars', 'SRD', '$', 0, 1, NULL, NULL),
(115, 'Syria', 'Pounds', 'SYP', '£', 0, 1, NULL, NULL),
(116, 'Taiwan', 'New Dollars', 'TWD', 'NT$', 0, 1, NULL, NULL),
(117, 'Thailand', 'Baht', 'THB', '฿', 0, 1, NULL, NULL),
(118, 'Trinidad and Tobago', 'Dollars', 'TTD', 'TT$', 0, 1, NULL, NULL),
(119, 'Turkey', 'Lira', 'TRY', 'TL', 0, 1, NULL, NULL),
(120, 'Turkey', 'Liras', 'TRL', '£', 0, 1, NULL, NULL),
(121, 'Tuvalu', 'Dollars', 'TVD', '$', 0, 1, NULL, NULL),
(122, 'Ukraine', 'Hryvnia', 'UAH', '₴', 0, 1, NULL, NULL),
(123, 'United Kingdom', 'Pounds', 'GBP', '£', 0, 1, NULL, NULL),
(124, 'United States of America', 'Dollars', 'USD', '$', 1, 1, NULL, '2020-05-12 09:55:30'),
(125, 'Uruguay', 'Pesos', 'UYU', 'u', 0, 1, NULL, '2020-02-02 19:20:55'),
(126, 'Uzbekistan', 'Sums', 'UZS', 'лв', 0, 1, NULL, NULL),
(127, 'Vatican City', 'Euro', 'EUR', '€', 0, 1, NULL, '2020-02-03 17:44:40'),
(128, 'Venezuela', 'Bolivares Fuertes', 'VEF', 'Bs', 0, 1, NULL, '2020-02-02 20:18:46'),
(129, 'Vietnam', 'Dong', 'VND', '₫', 0, 1, NULL, '2020-02-08 18:14:06'),
(130, 'Yemen', 'Rials', 'YER', '﷼', 0, 1, NULL, NULL),
(131, 'Zimbabwe', 'Zimbabwe Dollars', 'ZWD', 'Z$', 0, 1, NULL, '2020-02-02 19:20:40'),
(133, 'Bangladesh', 'bangladeshi taka', 'BDT', '৳', 0, 1, '2020-02-02 18:38:33', '2020-05-12 09:55:30');

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

--
-- Table structure for table `current_currencies`
--

CREATE TABLE `current_currencies` (
  `id` int(10) UNSIGNED NOT NULL,
  `currency_id` int(11) NOT NULL,
  `currency_sign` varchar(191) 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;

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) 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;

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

--
-- Table structure for table `delivery_slot_settings`
--

CREATE TABLE `delivery_slot_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date_interval` int(11) NOT NULL DEFAULT 0 COMMENT 'slot date start from after  this interval',
  `date_end` int(11) NOT NULL DEFAULT 0 COMMENT 'slot date will be disabled after this day',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'date time slot will show = 1  or not = 0',
  `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 `delivery_slot_settings`
--

INSERT INTO `delivery_slot_settings` (`id`, `date_interval`, `date_end`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 7, 0, NULL, '2020-10-06 06:45:51');

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

--
-- Table structure for table `delivery_time_s_lots`
--

CREATE TABLE `delivery_time_s_lots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slot_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expired_at` time NOT NULL COMMENT 'slot will be expired if current time greater then this time for same date',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'active or not',
  `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 `delivery_time_s_lots`
--

INSERT INTO `delivery_time_s_lots` (`id`, `slot_name`, `expired_at`, `status`, `created_at`, `updated_at`) VALUES
(1, '08am - 9am', '07:30:00', 1, NULL, NULL),
(3, '9am - 10am', '08:30:00', 1, NULL, '2020-10-06 05:31:42'),
(4, '10am - 11am', '09:00:00', 1, NULL, NULL),
(5, '11am - 12pm', '10:20:00', 1, NULL, NULL),
(6, '12pm - 01pm', '11:00:00', 1, NULL, NULL),
(7, '2pm - 3pm', '13:20:00', 1, '2020-10-05 11:47:59', '2020-10-06 05:28:19'),
(9, '4pm - 5pm', '15:30:00', 1, '2020-10-06 05:30:14', '2020-10-06 05:30:14'),
(10, '5pm - 6pm', '16:30:00', 1, '2020-10-06 05:31:14', '2020-10-06 05:31:14');

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `google_analytics`
--

CREATE TABLE `google_analytics` (
  `id` int(10) UNSIGNED NOT NULL,
  `app_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `installtion_settings`
--

CREATE TABLE `installtion_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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 `installtion_settings`
--

INSERT INTO `installtion_settings` (`id`, `purchase_code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'shakhwathossainpurchasecodefroloremispumdolorsuitimor', 1, '2020-10-01 06:31:26', '2020-10-01 06:31:26');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `president` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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 `menus`
--

INSERT INTO `menus` (`id`, `parent_id`, `name`, `icon`, `menu_url`, `president`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 'Administration', 'fa-sitemap', NULL, 1, 0, NULL, NULL),
(2, 0, 'Product', 'fa-diamond', NULL, 2, 0, NULL, NULL),
(3, 0, 'Offers & Coupon', 'fa-fire', NULL, 3, 0, NULL, NULL),
(4, 0, 'Order', 'fa-first-order', NULL, 4, 0, NULL, NULL),
(5, 0, 'Customer', 'fa-group', 'customer.index', 5, 0, NULL, NULL),
(6, 0, 'General Setting', 'fa-cog', NULL, 6, 0, NULL, NULL),
(7, 0, 'Emailing User', 'fa-envelope', 'email.index', 7, 0, NULL, NULL),
(8, 1, 'Role', NULL, 'role.index', 1, 0, NULL, NULL),
(9, 1, 'Manage Admin', NULL, 'admin.index', 2, 0, NULL, NULL),
(10, 2, 'Category', NULL, 'category.index', 1, 0, NULL, NULL),
(11, 2, 'Brand', NULL, 'brand.index', 3, 0, NULL, NULL),
(12, 2, 'Sub Category', NULL, 'sub-category.index', 2, 0, NULL, NULL),
(13, 2, 'Product', NULL, 'product.index', 5, 0, NULL, NULL),
(14, 3, 'Campaign', NULL, 'offer.index', 1, 0, NULL, NULL),
(15, 6, 'Currency Setting', NULL, 'currency.index', 1, 0, NULL, NULL),
(16, 6, 'Pyament Gateway Setting', NULL, 'gateway.index', 2, 0, NULL, NULL),
(17, 6, 'Social Login Setting', NULL, 'social.index', 3, 0, NULL, NULL),
(18, 6, 'Shop Setting', NULL, 'shop.index', 4, 0, NULL, NULL),
(19, 6, 'Page Seting', NULL, 'pages.index', 5, 0, NULL, NULL),
(20, 6, 'Seo Setting', NULL, 'seo.index', 6, 0, NULL, NULL),
(21, 6, 'Messenger & Google Analytics', NULL, 'message.analytics', 7, 0, NULL, NULL),
(22, 6, 'Mail Setting', NULL, 'email-setting.index', 8, 0, NULL, NULL),
(23, 6, 'Shipping Cost Setting', NULL, 'shipping.index', 2, 0, NULL, NULL),
(24, 0, 'Report', 'fa-fire', NULL, 9, 0, NULL, NULL),
(25, 24, 'Stock Report', NULL, 'stock.report', 1, 0, NULL, NULL),
(26, 24, 'Sales Report', NULL, 'sales.report', 2, 0, NULL, NULL),
(27, 24, 'Invoice Report', NULL, 'invoice.report', 3, 0, NULL, NULL),
(28, 6, 'Order Area', NULL, 'order-area.index', 9, 0, NULL, NULL),
(29, 4, 'All Order', NULL, 'order.index', 1, 0, NULL, NULL),
(30, 4, 'My Area\'s Order', NULL, 'areawiseorder.index', 2, 0, NULL, NULL),
(31, 24, 'Account Report', NULL, 'transection.report', 4, 0, NULL, NULL),
(32, 2, 'Sub Sub Category', NULL, 'sub-sub-category.index', 4, 1, NULL, NULL),
(33, 6, 'Slider', NULL, 'slider.index', 10, 1, '2020-07-10 03:35:22', '2020-07-10 03:35:23'),
(34, 2, 'Color', NULL, 'product-color.index', 7, 0, NULL, NULL),
(35, 2, 'Size', NULL, 'product-size.index', 6, 0, NULL, NULL),
(36, 3, 'Coupon', NULL, 'coupon.index', 3, 0, NULL, NULL),
(37, 3, 'Send Coupon', NULL, 'send-coupon.index', 4, 0, NULL, NULL),
(38, 6, 'Trial', NULL, 'trial.index', 11, 1, NULL, NULL),
(39, 6, 'Date Slot', NULL, 'slot.index', 12, 1, NULL, NULL);

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

--
-- Table structure for table `messengers`
--

CREATE TABLE `messengers` (
  `id` int(10) UNSIGNED NOT NULL,
  `app_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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 `messengers`
--

INSERT INTO `messengers` (`id`, `app_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '147855768574821', 1, NULL, '2020-08-10 16:21:24');

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

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

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;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(44, '2014_10_12_000000_create_users_table', 1),
(45, '2014_10_12_100000_create_password_resets_table', 1),
(46, '2019_08_19_000000_create_failed_jobs_table', 1),
(47, '2019_12_24_062500_create_categories_table', 1),
(48, '2019_12_24_063542_create_sub_categories_table', 1),
(49, '2019_12_24_063938_create_products_table', 1),
(50, '2019_12_24_083508_create_currencies_table', 1),
(51, '2019_12_24_084148_create_current_currencies_table', 1),
(52, '2019_12_24_094706_create_brands_table', 1),
(53, '2019_12_26_112745_create_admins_table', 1),
(54, '2020_01_05_102155_create_sub_category_brands_table', 1),
(55, '2020_01_14_105633_create_product_keywords_table', 1),
(56, '2020_01_19_062248_create_product_images_table', 1),
(57, '2020_01_27_100851_create_campaigns_table', 1),
(58, '2020_02_03_111021_create_social_creadentials_table', 1),
(59, '2020_02_04_055030_create_payment_settings_table', 1),
(60, '2020_02_05_094536_create_pages_table', 1),
(61, '2020_02_06_073208_create_seo_settings_table', 1),
(62, '2020_02_06_073820_create_seo_keywords_table', 1),
(63, '2020_02_09_083433_create_shop_settings_table', 1),
(64, '2020_02_11_094321_create_orders_table', 1),
(65, '2020_02_11_094510_create_order_details_table', 1),
(66, '2020_02_11_121923_create_messengers_table', 1),
(67, '2020_02_11_122454_create_google_analytics_table', 1),
(68, '2020_02_13_062611_create_shipping_costs_table', 1),
(69, '2020_02_23_054824_create_roles_table', 1),
(70, '2020_02_23_055338_create_menus_table', 1),
(71, '2020_02_23_055421_create_permissions_table', 1),
(72, '2020_02_25_123355_create_emails_table', 1),
(73, '2020_03_07_150336_create_customers_table', 1),
(74, '2020_03_22_182842_create_subscribers_table', 1),
(75, '2020_04_03_115233_create_shipping_areas_table', 1),
(76, '2020_05_19_083351_create_sub_sub_categories_table', 1),
(77, '2020_06_04_113657_create_o_t_p_s_table', 1),
(78, '2020_06_09_115052_create_stockhistories_table', 1),
(79, '2020_07_10_101352_create_sliders_table', 1),
(80, '2020_08_25_042045_create_sizes_table', 1),
(81, '2020_08_25_042139_create_colors_table', 1),
(82, '2020_08_31_100235_create_product_size_table', 1),
(83, '2020_08_31_100901_create_product_color_table', 1),
(84, '2020_09_07_074204_create_coupons_table', 1),
(85, '2020_09_07_075554_create_user_coupon_table', 1),
(86, '2020_09_07_154623_create_trial_products_table', 1),
(87, '2020_09_28_133437_create_pwa_settings_table', 2),
(88, '2020_09_30_113719_create_installtion_settings_table', 3),
(89, '2020_09_27_124921_create_trials_table', 4),
(90, '2020_10_05_122452_create_delivery_slot_settings_table', 5),
(91, '2020_10_05_122710_create_delivery_time_s_lots_table', 5);

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

--
-- Table structure for table `mobile_otp`
--

CREATE TABLE `mobile_otp` (
  `id` int(10) UNSIGNED NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'customer id',
  `location_id` int(11) DEFAULT 0,
  `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_area_id` int(11) DEFAULT NULL COMMENT 'shipping area id',
  `shipping_amount` double NOT NULL DEFAULT 0,
  `total_item` int(11) NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL,
  `total_buying_amount` double NOT NULL DEFAULT 0,
  `cupon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cash_back` double DEFAULT NULL,
  `discount` double NOT NULL DEFAULT 0,
  `coupon_discount` double NOT NULL DEFAULT 0,
  `payment_id` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_id` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 not paid 1 = paid',
  `payment_method` tinyint(4) NOT NULL DEFAULT 0,
  `card_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `validation_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_delivery_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_delivery_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivered_by` int(11) NOT NULL DEFAULT 0,
  `confirmed_by` int(11) NOT NULL DEFAULT 0,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 pending,1=on process,2=on delivery,3 = delivered',
  `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 `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `location_id`, `customer_name`, `phone`, `email`, `address`, `shipping_area_id`, `shipping_amount`, `total_item`, `total_amount`, `total_buying_amount`, `cupon`, `cash_back`, `discount`, `coupon_discount`, `payment_id`, `payer_id`, `payment_status`, `payment_method`, `card_type`, `validation_id`, `order_date`, `customer_delivery_date`, `customer_delivery_time`, `payment_date`, `delivery_date`, `delivered_by`, `confirmed_by`, `note`, `status`, `created_at`, `updated_at`) VALUES
(1001, 3, 0, 'Customers', '01301270203', NULL, 'lorem ispum odlor', 1, 40, 1, 450, 550, NULL, NULL, 0, 0, NULL, NULL, 0, 0, NULL, NULL, '2020-11-01', NULL, NULL, NULL, NULL, 0, 0, NULL, 0, '2020-11-01 12:36:34', '2020-11-01 12:36:34'),
(1002, 3, 0, 'Customers', '01301270203', NULL, 'lorem ispum odlor', 2, 40, 3, 1021, 780, NULL, NULL, 9, 0, NULL, NULL, 1, 4, 'BKASH-BKash', '2102151648421RFhzO38570hYw9', '2021-02-15', NULL, NULL, '2021-02-15', NULL, 0, 0, NULL, 0, '2021-02-15 10:43:57', '2021-02-15 10:44:10');

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `sub_sub_category_id` int(11) DEFAULT 0,
  `brand_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL,
  `color_id` int(11) DEFAULT 0,
  `size_id` int(11) DEFAULT 0,
  `user_id` int(11) NOT NULL COMMENT 'customer_id',
  `quantity` int(11) NOT NULL,
  `selling_price` double NOT NULL,
  `buying_price` double NOT NULL,
  `total_buying_price` double NOT NULL,
  `total_selling_price` double NOT NULL,
  `unit_discount` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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 `order_details`
--

INSERT INTO `order_details` (`id`, `order_id`, `category_id`, `sub_category_id`, `sub_sub_category_id`, `brand_id`, `product_id`, `color_id`, `size_id`, `user_id`, `quantity`, `selling_price`, `buying_price`, `total_buying_price`, `total_selling_price`, `unit_discount`, `total_discount`, `status`, `created_at`, `updated_at`) VALUES
(14, 1001, 2, 13, NULL, 0, 21, NULL, 6, 3, 1, 450, 550, 550, 450, 0, 0, 0, '2020-11-01 12:36:34', '2020-11-01 12:36:34'),
(15, 1002, 2, 13, NULL, 0, 16, NULL, 8, 3, 1, 441, 340, 340, 441, 9, 9, 0, '2021-02-15 10:43:57', '2021-02-15 10:43:57'),
(16, 1002, 2, 9, NULL, 0, 10, NULL, NULL, 3, 1, 340, 220, 220, 340, 0, 0, 0, '2021-02-15 10:43:57', '2021-02-15 10:43:57'),
(17, 1002, 2, 13, NULL, 0, 6, 3, 7, 3, 1, 240, 220, 220, 240, 0, 0, 0, '2021-02-15 10:43:57', '2021-02-15 10:43:57');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` tinyint(4) 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;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(11) NOT NULL,
  `menu_id` 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;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES
(76, 1, 8, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(77, 1, 9, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(78, 1, 1, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(79, 1, 31, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(80, 1, 25, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(81, 1, 27, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(82, 1, 26, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(83, 1, 24, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(84, 1, 7, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(85, 1, 33, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(86, 1, 38, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(87, 1, 28, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(88, 1, 39, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(89, 1, 15, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(90, 1, 16, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(91, 1, 17, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(92, 1, 18, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(93, 1, 19, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(94, 1, 20, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(95, 1, 21, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(96, 1, 22, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(97, 1, 23, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(98, 1, 6, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(99, 1, 5, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(100, 1, 29, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(101, 1, 30, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(102, 1, 4, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(103, 1, 14, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(104, 1, 37, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(105, 1, 36, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(106, 1, 3, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(107, 1, 32, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(108, 1, 34, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(109, 1, 35, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(110, 1, 10, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(111, 1, 13, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(112, 1, 12, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(113, 1, 11, '2020-10-06 09:24:52', '2020-10-06 09:24:52'),
(114, 1, 2, '2020-10-06 09:24:52', '2020-10-06 09:24:52');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `sub_sub_category_id` int(11) DEFAULT 0,
  `brand_id` int(11) DEFAULT 0,
  `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_native_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_thumb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_keyword` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock_quantity` int(11) NOT NULL DEFAULT 0,
  `current_quantity` int(11) NOT NULL DEFAULT 0,
  `quantity_unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `buying_price` double NOT NULL,
  `selling_price` double NOT NULL,
  `total_view` int(11) NOT NULL DEFAULT 0,
  `total_sold` int(11) NOT NULL DEFAULT 0,
  `price` double NOT NULL DEFAULT 0,
  `discount_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 is amount 2 is percent',
  `discount_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = no discount , 1= discount',
  `discount` double NOT NULL DEFAULT 0,
  `discount_amount` double NOT NULL DEFAULT 0,
  `campaign_id` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `home_view` tinyint(4) NOT NULL DEFAULT 1,
  `hot_deal` tinyint(4) NOT NULL DEFAULT 0,
  `trialable` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) 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 `products`
--

INSERT INTO `products` (`id`, `category_id`, `sub_category_id`, `sub_sub_category_id`, `brand_id`, `product_name`, `product_native_name`, `product_image`, `product_thumb`, `product_description`, `product_keyword`, `stock_quantity`, `current_quantity`, `quantity_unit`, `buying_price`, `selling_price`, `total_view`, `total_sold`, `price`, `discount_type`, `discount_status`, `discount`, `discount_amount`, `campaign_id`, `created_by`, `updated_by`, `home_view`, `hot_deal`, `trialable`, `status`, `created_at`, `updated_at`) VALUES
(5, 1, 7, NULL, NULL, 'indian kurty - three pieces', 'lorem ispm', '5f97eb2b167dd.jpeg', NULL, '<p>lorem ispum dolor suit imro</p>', 'kurti, ladies dress, indian kurti', 120, 120, 'pc', 220, 230, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-10-27 09:40:59', '2020-10-27 09:40:59'),
(6, 2, 13, NULL, NULL, 'Full sleeves stylish  shirt', 'Full sleeves stylish  shirt', '5f97f1e6015c1.jpeg', NULL, 'null', 'shirt, sleevless', 12, 11, 'pieces', 220, 240, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, '2020-10-27 10:09:42', '2021-02-15 10:43:57'),
(7, 1, 10, NULL, NULL, 'Stylish long belt bag ladis', 'ladis bag', '5f97fcbf16e47.webp', NULL, '<p>Computer Science Graduate, Software Engineer , Open Source Contributor , Envato Author</p>', 'bag, ladis bag', 12, 12, 'pieces', 220, 240, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-10-27 10:55:59', '2020-10-27 10:55:59'),
(8, 1, 1, NULL, NULL, 'Women Huddi Jacket', 'huddi jacket', '5f9805461baef.jpeg', NULL, '<p>lorem ispum dolor suit imor simply dummy text</p>', 'huddy, jacket, winter collection', 120, 120, 'per pieces', 220, 320, 0, 0, 0, 1, 1, 20, 20, 1, 1, NULL, 1, 0, 0, 1, '2020-10-27 11:32:22', '2020-11-02 05:46:21'),
(9, 1, 5, NULL, NULL, 'Bulldog skin care', 'skin care', '5f99103b18a6c.jpeg', NULL, '<p>bulldog </p><p>lorem ispum</p><p>dolor suit</p><p>imor </p><p>simply dummy text</p>', 'man screen, beatuy', 12, 12, '300 gm', 220, 340, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 1, 1, 1, '2020-10-28 06:31:23', '2020-10-28 06:37:46'),
(10, 2, 9, NULL, NULL, 'Man Sun sea surf Yellow t shirt', 'T shirt', '5f99119661747.webp', NULL, '<p>lorem ispumo door suit imor simply dummy test</p><p>lorem</p><p>ispum dolor suit imor simply</p><p>dujmmy text</p>', 't shirt, yellow', 22, 21, NULL, 220, 340, 0, 1, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 1, 1, 1, '2020-10-28 06:37:10', '2021-02-15 10:43:57'),
(11, 2, 9, NULL, NULL, 'T Shirt Red', 'T shirt Red', '5f9912f13f5f4.jpeg', NULL, NULL, 't shi, genji', 220, 220, NULL, 340, 440, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(12, 2, 9, NULL, NULL, 'Man Full Black T shirt', 'Man Full Black T shirt', '5f99148d513ee.jpeg', NULL, '<p>lorem ispum dolor man</p>', 'man, t shirt', 120, 120, 'null', 320, 430, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, '2020-10-28 06:49:49', '2020-10-29 07:02:48'),
(13, 1, 5, NULL, NULL, 'Misco ladies makeover box', 'makeover box', '5f9a5dff886ac.jpeg', NULL, '<p>The <strong>history</strong> of <strong>cosmetics</strong> spans at least 7,000 years and is present in almost every society on earth. ...</p><p> It is known that some women in ancient Rome invented <strong>make up</strong> including lead-based formulas, to whiten the skin, and kohl was used to line the eyes.</p>', 'ladies, box, makeup', 12, 12, '1 pieces', 220, 320, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 0, 1, '2020-10-29 06:15:27', '2020-10-29 06:15:27'),
(14, 6, 20, NULL, NULL, 'Apple i phone 11 pro', 'i phone 11 pro', '5f9e679021d6b.jpeg', NULL, '<p>Made from a blend of optically clear polycarbonate and flexible TPU materials, the iPhone 11 Clear Case provides a solid, comfortable feel. The back ...</p><p>* Check website for latest pricing and availability.&nbsp;Images may be subject to copyright</p>', 'apple, iphone, iphone11', 120, 120, 'null', 2300, 4300, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, '2020-10-29 06:36:17', '2020-11-01 07:45:20'),
(15, 6, 20, NULL, NULL, 'Apple ipone 12 pro max', 'apple iphone 12 pro max', '5f9a690747b2e.jpeg', NULL, '<p>Yes, in some circumstances, it is possible to use a copyright-protected work without infringing the owner’s copyright. For more about this, you may wish to learn about <a href=\"http://www.dmlp.org/legal-guide/fair-use\" rel=\"noopener noreferrer\" target=\"_blank\">fair use</a>. It is important to note that your content can be removed in response to a claim of copyright infringement, even if you have...</p><ul><li>Given credit to the copyright owner</li><li>Refrained from monetizing the infringing content</li><li>Charged for a copy of the content in question</li><li>Noticed similar content that appear elsewhere on the internet</li><li>Purchased the content including a hard or digital copy</li><li>Recorded the content yourself from TV, a movie theater, or the radio</li><li>Copied the content yourself from a textbook, a movie poster or photograph</li><li>Stated that “no copyright infringement is intended”</li></ul><p><br></p>', 'apple iphone 12, iphone12', 12, 12, 'null', 2000, 2500, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, '2020-10-29 07:02:31', '2020-10-29 07:02:42'),
(16, 2, 13, NULL, NULL, 'Men\'s Shirt Napped Cotton', 'Men\'s Shirt Napped Cotton', '5f9a744cecf4c.jpeg', NULL, '<p>$103.44* · Brand: Manufactum</p><p>100% cotton (fabric weight 164 g/m²), fabric made in Portugal. Contains non-textile elements of animal origin: mother-of-pearl buttons. Garment made ...</p>', 'shirt, mans, man fashion', 18, 17, NULL, 340, 450, 0, 1, 0, 2, 1, 2, 9, 0, 1, NULL, 1, 1, 1, 1, '2020-10-29 07:50:37', '2021-02-15 10:43:57'),
(17, 2, 13, NULL, NULL, 'Full Sleeve Cotton Shirt for Men - 160', 'Full Sleeve Cotton Shirt for Men - 160', '5f9a7568cce10.jpeg', NULL, '<p>Brand: M&amp;N Fashion. Product Type: Men’s Shirt. Fabric &amp; Material: 100% Cotton. 100% Export Quality. Gender: Men. Made In: Bangladesh.</p>', 'shirt, man shirt', 15, 15, 'null', 540, 650, 0, 0, 0, 2, 1, 7, 45.5, 1, 1, 1, 1, 0, 1, 1, '2020-10-29 07:55:20', '2020-11-02 05:46:21'),
(18, 2, 13, NULL, NULL, 'Bird Print Shirt Mens, Slim Fit', 'Bird Print Shirt Mens, Slim Fit', '5f9a7645e6584.jpeg', NULL, '<p>Contemporary bird printed shirt with button placket and korean cut collar., Breathable fabric made with 100% Cotton</p><p>Contemporary bird printed shirt with button placket and korean cut collar., Breathable fabric made with 100% Cotton</p><p>Contemporary bird printed shirt with button placket and korean cut collar., Breathable fabric made with 100% Cotton</p><p>Contemporary bird printed shirt with button placket and korean cut collar., Breathable fabric made with 100% Cotton</p><p>Contemporary bird printed shirt with button placket and korean cut collar., Breathable fabric made with 100% Cotton</p><p>Contemporary bird printed shirt with button placket and korean cut collar., Breathable fabric made with 100% Cotton</p>', NULL, 123, 123, NULL, 220, 320, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 1, 1, 1, '2020-10-29 07:59:01', '2020-10-29 07:59:58'),
(19, 2, 9, NULL, NULL, 'Men\'s Slim Fit Polo T-Shirt', 'Men\'s Slim Fit Polo T-Shir', '5f9a87317e31b.jpeg', NULL, '<p>Exclusive Collection 95% Cotton 5% Spandex Short Sleeve Polo Slim Fit T-Shirt, Bigg Boss Brand Gents T-Shirt Shop for the latest Men’s T-shirt fashion</p><p>Exclusive Collection 95% Cotton 5% Spandex Short Sleeve Polo Slim Fit T-Shirt, Bigg Boss Brand Gents T-Shirt Shop for the latest Men’s T-shirt fashion</p><p>Exclusive Collection 95% Cotton 5% Spandex Short Sleeve Polo Slim Fit T-Shirt, Bigg Boss Brand Gents T-Shirt Shop for the latest Men’s T-shirt fashion</p><p>Exclusive Collection 95% Cotton 5% Spandex Short Sleeve Polo Slim Fit T-Shirt, Bigg Boss Brand Gents T-Shirt Shop for the latest Men’s T-shirt fashion</p><p>Exclusive Collection 95% Cotton 5% Spandex Short Sleeve Polo Slim Fit T-Shirt, Bigg Boss Brand Gents T-Shirt Shop for the latest Men’s T-shirt fashion</p>', 't shirt, man tshirt', 120, 120, NULL, 330, 420, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 0, 1, '2020-10-29 09:11:13', '2020-10-29 09:11:13'),
(20, 2, 9, NULL, NULL, 'Blue World T Shirt / Pi', 'Blue World', '5f9e42138c490.jpeg', NULL, '<p>A <strong>T</strong>-<strong>shirt</strong>, or <strong>tee shirt</strong>, is a style of fabric <strong>shirt named</strong> after the <strong>T</strong> shape of its body and sleeves. ... V-necks were introduced so that the neckline of the <strong>shirt</strong> does not show when worn beneath an outer <strong>shirt</strong>, as would that of a crew neck <strong>shirt</strong>.</p>', 't shirt, man fasion', 123, 123, 'null', 230, 250, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, '2020-11-01 05:03:02', '2020-11-01 06:17:52'),
(21, 2, 13, NULL, NULL, 'Shirt Brown Ceck and steps', 'Shirt Brown Ceck and steps', '5f9e452683bb5.jpeg', NULL, '<p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p><p>A shirt is a cloth garment for the upper body. Originally an undergarment worn exclusively by men, it has become, in American English, a catch-all term for a broad variety of upper-body garments and undergarments</p>', NULL, 120, 119, NULL, 550, 450, 0, 1, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-11-01 05:18:30', '2020-11-01 12:36:34'),
(22, 1, 10, NULL, NULL, 'Exlcusive ladies hand bag', 'stylish ladies handbag', '5f9e5688ae8c2.jpeg', NULL, '<p>pink and red</p>', 'bag, ladies', 123, 123, NULL, 420, 540, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, '2020-11-01 06:32:40', '2020-11-01 06:34:49'),
(23, 1, 10, NULL, NULL, 'Prada Women Bag', 'Prada Women Bag', '5f9e58a5a8242.jpeg', NULL, '<p>Excellent question! When you upload a JPEG file, the image is analyzed. Textures, patterns and colours are <strong>automatically identified</strong>. The encoder creates an optimally compressed JPEG file based on that information. The final result is compared with the original and fine-tuned. Distracting JPEG artifacts are minimized <strong>without big sacrifices in file size</strong>. Unnecessary metadata is stripped as well. You will get an optimal image, every time!</p>', 'bag, women, women fashion', 120, 120, NULL, 230, 340, 0, 0, 0, 1, 1, 60, 60, 0, 1, NULL, 1, 0, 1, 1, '2020-11-01 06:41:41', '2020-11-01 09:42:53'),
(24, 1, 10, NULL, NULL, '4 In 1 Pu Leather Handbag Set - White And Brown', '4 In 1 Pu Leather Handbag Set - White And Brown', '5f9e67637d243.jpeg', NULL, '<p><a href=\"https://www.google.com/url?sa=i&amp;url=https%3A%2F%2Fwww.jumia.co.ke%2Ffashion-4-in-1-pu-leather-handbag-set-white-and-brown-6021768.html&amp;psig=AOvVaw2HaxImkB0CoTvVoRxY8gPL&amp;ust=1604299039791000&amp;source=images&amp;cd=vfe&amp;ved=0CA0QjhxqFwoTCKjyveXd4OwCFQAAAAAdAAAAABBJ\" rel=\"noopener noreferrer\" target=\"_blank\">4 In 1 Pu Leather Handbag Set - White And Brown</a></p>', 'bag, women', 12, 12, NULL, 340, 440, 0, 0, 0, 2, 1, 15, 66, 0, 1, 1, 1, 0, 1, 1, '2020-11-01 07:35:21', '2020-11-01 09:42:12'),
(25, 1, 10, NULL, NULL, 'Ladies bag with simple design', 'Ladies bag with simple design', '5f9e688c4b6ac.jpeg', NULL, '<p>Ladies bag with simple designLadies bag with simple designLadies bag with simple design</p><p>Ladies bag with simple design</p><p>Ladies bag with simple design</p><p>Ladies bag with simple design</p><p>Ladies bag with simple design</p><p>Ladies bag with simple designLadies bag with simple design</p><p>Ladies bag with simple design</p><p>Ladies bag with simple design</p><p>Ladies bag with simple design</p><p>Ladies bag with simple design</p>', 'bag, women bag', 122, 122, NULL, 120, 320, 0, 0, 0, 1, 1, 20, 20, 0, 1, NULL, 1, 0, 0, 1, '2020-11-01 07:49:32', '2020-11-01 09:41:17'),
(26, 1, 10, NULL, NULL, 'Women Casual Cross Body Handbag', 'Women Casual Cross Body Handbag', '5f9e6a6671009.jpeg', NULL, '<p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body HandbagWomen Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p><p>Women Casual Cross Body Handbag</p>', 'bag, ladies bag', 23, 23, 'null', 220, 320, 0, 0, 0, 1, 1, 60, 60, 0, 1, 1, 1, 0, 0, 1, '2020-11-01 07:54:29', '2020-11-01 09:42:37'),
(27, 1, 2, NULL, NULL, 'Women Casual Shoes', 'Casual Puppie Shoes', '5f9e80f11b04b.jpeg', NULL, '<p>Women Casual Shoes</p><p>Women Casual Shoes</p><p>Women Casual Shoes</p><p>Women Casual Shoes</p><p>Women Casual ShoesWomen Casual Shoes</p><p>Women Casual Shoes</p><p>Women Casual ShoesWomen Casual Shoes</p>', 'shoes, women fashion', 234, 234, NULL, 234, 432, 0, 0, 0, 1, 1, 7, 7, 2, 1, NULL, 1, 0, 0, 1, '2020-11-01 09:33:37', '2020-11-02 06:50:30'),
(28, 1, 2, NULL, NULL, 'Women White Stylish Shoes', 'Women White Stylish Shoes', '5f9e81f30520d.jpeg', NULL, NULL, 'shoes', 33, 33, 'Pair', 220, 340, 0, 0, 0, 1, 0, 4, 4, 0, 1, NULL, 1, 0, 0, 1, '2020-11-01 09:37:55', '2020-11-01 12:27:26'),
(29, 1, 2, NULL, NULL, 'Black Stylish Puppies shoes', 'Black Stylish Puppies shoes', '5f9e82a0dd175.jpeg', NULL, NULL, 'black shoes, women shoes', 123, 123, NULL, 432, 543, 0, 0, 0, 1, 1, 7, 7, 2, 1, NULL, 1, 0, 1, 1, '2020-11-01 09:40:48', '2020-11-02 06:50:30'),
(30, 1, 2, NULL, NULL, 'Golden Smart Hill For Women', 'Golden Smart Hill For Women', '5f9e83a303f3a.jpeg', NULL, '<p>Golden Smart Hill For WomenvGolden Smart Hill For Women</p><p>Golden Smart Hill For Women</p><p>Golden Smart Hill For Women</p><p>Golden Smart Hill For Women</p><p>Golden Smart Hill For Women</p><p>Golden Smart Hill For Women</p><p>Golden Smart Hill For Women</p>', 'golden shoes', 23, 23, NULL, 530, 660, 0, 0, 0, 2, 1, 3, 19.8, 0, 1, NULL, 1, 0, 0, 1, '2020-11-01 09:45:07', '2020-11-01 09:45:17'),
(31, 1, 2, NULL, NULL, 'Women cades casual', 'Women cades casual', '5f9e849bb8a91.jpeg', NULL, NULL, NULL, 33, 33, NULL, 554, 590, 0, 0, 0, 2, 1, 2, 11.8, 0, 1, NULL, 1, 0, 1, 1, '2020-11-01 09:49:15', '2020-11-01 11:00:48'),
(32, 1, 2, NULL, NULL, 'Wildfire GORE-TEX® Women\'s Shoes', 'Wildfire GORE-TEX® Women\'s Shoes', '5f9e8538e5830.jpeg', NULL, '<p>The Wildfire GTX is a comfortable tech approach shoe, equipped with a versatile POMOCA Speed MTN sole for grip, traction and sure-footed climbing</p>', 'sheos', 33, 33, NULL, 234, 334, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-11-01 09:51:52', '2020-11-01 09:51:52'),
(33, 1, 1, NULL, NULL, 'Good Quality & Attractive Party Dress For Girls', 'Good Quality & Attractive Party Dress For Girls', '5f9e954ee8062.png', NULL, '<p>Good Quality &amp; Attractive Party Dress For Girls</p><p>Good Quality &amp; Attractive Party Dress For Girls</p><p>Good Quality &amp; Attractive Party Dress For Girls</p><p>Good Quality &amp; Attractive Party Dress For Girls</p><p>Good Quality &amp; Attractive Party Dress For Girls</p><p>Good Quality &amp; Attractive Party Dress For GirlsGood Quality &amp; Attractive Party Dress For Girls</p><p><br></p>', 'gown', 23, 23, NULL, 340, 440, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-11-01 11:00:31', '2020-11-01 11:00:31'),
(34, 1, 1, NULL, NULL, 'Good Quality & Attractive Party Dress For Girls Maroon Color', 'Good Quality & Attractive Party Dress For Girls Maroon Color', '5f9e95ef2a737.png', NULL, NULL, 'gown, woemn party', 322, 322, NULL, 554, 664, 0, 0, 0, 2, 1, 3, 3, 0, 1, NULL, 1, 0, 0, 1, '2020-11-01 11:03:11', '2020-11-01 11:03:52'),
(35, 1, 1, NULL, NULL, 'Designer Clothes, Shoes & Bags for Women', 'Designer Clothes, Shoes & Bags for Women', '5f9e97f47aeea.jpeg', NULL, '<p>A gown, from the Saxon word, gunna, is a usually loose outer garment from knee- to full-length worn by men and women in Europe from the Early Middle Ages to the 17th century, and continuing today i</p>', 'four set, 4 set', 222, 222, NULL, 342, 443, 0, 0, 0, 2, 1, 3, 3, 2, 1, NULL, 1, 0, 0, 1, '2020-11-01 11:11:48', '2020-11-02 06:50:30'),
(36, 1, 1, NULL, NULL, 'Gorgeous Black Gown for women', 'Gorgeous Black Gown for women', '5f9e9892e69da.jpeg', NULL, '<p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p><p>Gorgeous Black Gown for women</p>', 'gown, women gown', 122, 122, NULL, 433, 556, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 0, 1, '2020-11-01 11:14:26', '2020-11-01 11:14:26'),
(37, 3, 17, NULL, NULL, 'Children Long Dress Rainbow Unicorn', '2020 Children Long Dress Rainbow Unicorn', '5f9f9690dab48.jpeg', NULL, '<p>Children Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow UnicornChildren Long Dress Rainbow Unicorn</p>', 'girls, baby dress, girls dress', 12, 12, NULL, 453, 556, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-11-02 05:18:09', '2020-11-02 05:18:09'),
(38, 3, 17, NULL, NULL, 'Cute Baby Dress', 'Cute Baby Dress', '5f9fae074320b.jpeg', NULL, '<p>Cute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby Dress</p><p>Cute Baby DressCute Baby Dress</p><p>Cute Baby Dress</p><p>Cute Baby DressCute Baby Dress</p><p>Cute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby DressCute Baby Dress</p>', 'baby dress, girls dress', 1223, 1223, NULL, 240, 432, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 1, 1, '2020-11-02 06:58:15', '2020-11-02 06:58:15'),
(39, 3, 18, NULL, NULL, 'Cute Baby Dress II', 'Cute Baby Dress II', '5f9fb144cfbad.jpeg', NULL, '<p>Cute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress IICute Baby Dress II</p>', 'baby, dress', 12, 12, NULL, 340, 440, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 0, 1, '2020-11-02 07:12:04', '2020-11-02 07:12:04'),
(40, 6, 21, NULL, NULL, 'Azarbozo Optical Mouse', 'Azarbozo Optical Mouse', '5f9fb8ea5f3b0.jpeg', NULL, '<p>Azarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical MouseAzarbozo Optical Mouse</p>', 'mouse, optical mouse', 123, 123, NULL, 450, 650, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 0, 1, '2020-11-02 07:44:42', '2020-11-02 07:44:42'),
(41, 6, 21, NULL, NULL, 'Primax Optomacanical Mouse', 'Primax', '5f9fb987aa3d4.jpeg', NULL, 'null', 'primax, Computer Accessories', 332, 332, 'null', 300, 340, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, '2020-11-02 07:47:19', '2020-11-02 07:58:09'),
(42, 6, 21, NULL, NULL, 'RAPOO 8200M Multi-mode Wireless Keyboard & Mouse', 'RAPOO 8200M Multi-mode Wireless Keyboard & Mouse', '5f9fba058e49f.jpeg', NULL, '<p>RAPOO 8200M Multi-mode Wireless Keyboard &amp; Mouse</p><p>RAPOO 8200M Multi-mode Wireless Keyboard &amp; Mouse</p><p>RAPOO 8200M Multi-mode Wireless Keyboard &amp; Mouse</p><p>RAPOO 8200M Multi-mode Wireless Keyboard &amp; Mouse</p><p><br></p><p>RAPOO 8200M Multi-mode Wireless Keyboard &amp; Mouse</p><p><br></p><p>RAPOO 8200M Multi-mode Wireless Keyboard &amp; Mouse</p><p>RAPOO 8200M Multi-mode Wireless Keyboard &amp; Mouse</p>', 'RAPOO, Computer Accessories', 34, 34, 'null', 223, 330, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, '2020-11-02 07:49:25', '2020-11-02 07:57:50'),
(43, 6, 21, NULL, NULL, 'MICROLAB M660BT BLUETOOTH MULTIMEDIA SPEAKER', 'MICROLAB M660BT BLUETOOTH MULTIMEDIA SPEAKER', '5f9fbb2d99306.jpeg', NULL, '<p>Double-cavity subwoofer for stronger and deeper bass effects, Glossy metallic trim strip design on bass reflex tunnel and satellites, Satellites</p><p>Double-cavity subwoofer for stronger and deeper bass effects, Glossy metallic trim strip design on bass reflex tunnel and satellites, Satellites</p><p>Double-cavity subwoofer for stronger and deeper bass effects, Glossy metallic trim strip design on bass reflex tunnel and satellites, Satellites</p><p>Double-cavity subwoofer for stronger and deeper bass effects, Glossy metallic trim strip design on bass reflex tunnel and satellites, Satellites</p><p>Double-cavity subwoofer for stronger and deeper bass effects, Glossy metallic trim strip design on bass reflex tunnel and satellites, Satellites</p><p>Double-cavity subwoofer for stronger and deeper bass effects, Glossy metallic trim strip design on bass reflex tunnel and satellites, Satellites</p><p>Double-cavity subwoofer for stronger and deeper bass effects, Glossy metallic trim strip design on bass reflex tunnel and satellites, Satellites</p>', 'soudn box, speaker, Computer Accessories', 223, 223, 'null', 110, 123, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, '2020-11-02 07:54:21', '2020-11-02 07:57:31'),
(44, 6, 21, NULL, NULL, 'Gaming Headset RZE-G902H', 'Gaming Headset RZE-G902H', '5f9fbbc764c09.jpeg', NULL, '<p>Immerse yourself in Dreams!, Every day new and new games are designed with extraordinary audio performances and for any Gamer, the demand for a</p>', 'gaming, headphone, Computer Accessories', 20, 20, NULL, 340, 440, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, '2020-11-02 07:56:55', '2020-11-02 08:13:48'),
(45, 6, 21, NULL, NULL, 'JBL Tune 600NC Bluetooth Headphone', 'JBL Tune 600NC Bluetooth Headphon', '5f9fbc9abf09c.jpeg', NULL, NULL, 'computer items, headphone', 33, 33, NULL, 340, 440, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 1, 0, 1, '2020-11-02 08:00:26', '2020-11-02 08:13:49'),
(46, 6, 21, NULL, NULL, 'Gigabyte Intel H410 Intel Socket 1200 Micro ATX Motherboard', 'Gigabyte Intel H410 Intel Socket 1200 Micro ATX Motherboard', '5f9fbf8225f12.jpeg', NULL, '<p><strong>Brand </strong>: Gigabyte</p><p><strong>Processor </strong>: INTEL</p><p><strong>ATX </strong>: 1200 Micro</p><p><strong>Warranty </strong>: 2 Years</p>', 'gigabytes', 23, 23, NULL, 4500, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 1, 0, 0, 1, '2020-11-02 08:12:50', '2020-11-02 08:12:50'),
(47, 7, 22, NULL, NULL, 'Brcalona Jersey Light Green', 'Brcalona Jersey Green', '5f9fd33188132.jpeg', NULL, 'null', 'jersey, bercelona, t shirt, genji', 123, 123, 'null', 40, 45, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, '2020-11-02 09:36:49', '2020-11-02 09:39:52'),
(48, 7, 22, NULL, NULL, 'Barcelona Jersey Blue', 'Barcelona Jersey Blue', '5f9fd3abd8779.jpeg', NULL, 'null', 'jursey, t shirt, shirt', 123, 123, 'null', 233, 334, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, '2020-11-02 09:38:51', '2020-11-02 09:39:32'),
(49, 7, 22, NULL, NULL, 'Real Madrid Jersey White', 'Real Madrid Jersey White', '5f9fdd74c9bba.jpeg', NULL, '<p><br></p><ol><li>&nbsp;&nbsp;&nbsp;One (1) Excavator-0.9m3, monthly rent (For 240 hour monthly and 08 hours Daily) Tk 2,85, 000.00 (Two Lac &amp; Eighty Five Thousand Taka Only).</li><li>&nbsp;&nbsp;&nbsp;Equipment working time: 8 AM-5 PM (Including 01 hour lunch break).</li><li>&nbsp;&nbsp;&nbsp;After 5 PM, any working will be counted as over time and over time working hour(s) rate will be counted as per regular hourly rate. </li><li>&nbsp;&nbsp;Operator and helper fooding Tk1,500.00 (For daily 8 hours).</li><li>&nbsp;&nbsp;&nbsp;If operator and helper work more than 08 hours or work after 5 PM, overtime will be counted as per ratio. </li><li>&nbsp;&nbsp;&nbsp;Operator’s accommodation will be provided by 2nd party.</li><li>&nbsp;&nbsp;&nbsp;Agreement period is for Six month.</li><li>&nbsp;&nbsp;&nbsp;2nd party will pay Mobilization payment.</li><li>&nbsp;&nbsp;If equipment works less than 720 hours, 2nd party will pay demobilization also.</li><li>&nbsp;&nbsp;&nbsp;Due to any kind of machinery’s problem, if the job stopped, 2nd party doesn’t pay any payment for those days or moments.</li><li>&nbsp;&nbsp;&nbsp;2nd party will bear all machinery’s security.</li><li>&nbsp;&nbsp;&nbsp;2nd party has to arrange Fuel, Equipment safety and working environment.</li><li>&nbsp;&nbsp;&nbsp;If 2nd party does any illegal job, 1st party will not be responsible for that type of job.</li><li>&nbsp;&nbsp;&nbsp;1st Party holds the right to bring the equipment back anytime if 2nd party doesn’t comply with the agreement properly.</li><li>&nbsp;&nbsp;&nbsp;After getting invoice, 2nd party will pay monthly bill within 10 days.</li><li>&nbsp;&nbsp;&nbsp;This rate is excluding VAT and AIT.</li></ol>', 'jersey, real madrid, t shirt, genji', 123, 123, 'null', 50, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, '2020-11-02 10:20:36', '2020-11-04 08:19:50');

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

--
-- Table structure for table `product_color`
--

CREATE TABLE `product_color` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `color_id` int(11) NOT NULL,
  `quantity` int(11) DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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_color`
--

INSERT INTO `product_color` (`id`, `product_id`, `color_id`, `quantity`, `status`, `created_at`, `updated_at`) VALUES
(3, 6, 1, 0, 1, '2020-10-27 10:17:29', '2020-10-27 10:17:29'),
(4, 6, 3, 0, 1, '2020-10-27 10:17:29', '2020-10-27 10:17:29'),
(17, 22, 8, 0, 1, '2020-11-01 06:34:49', '2020-11-01 06:34:49'),
(18, 22, 9, 0, 1, '2020-11-01 06:34:49', '2020-11-01 06:34:49'),
(19, 23, 6, 0, 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(20, 23, 10, 0, 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(21, 23, 4, 0, 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(48, 14, 1, 0, 1, '2020-11-01 07:45:20', '2020-11-01 07:45:20'),
(49, 14, 3, 0, 1, '2020-11-01 07:45:20', '2020-11-01 07:45:20'),
(50, 14, 2, 0, 1, '2020-11-01 07:45:20', '2020-11-01 07:45:20'),
(51, 14, 9, 0, 1, '2020-11-01 07:45:20', '2020-11-01 07:45:20'),
(52, 25, 5, 0, 1, '2020-11-01 07:49:32', '2020-11-01 07:49:32'),
(55, 26, 4, 0, 1, '2020-11-01 07:57:26', '2020-11-01 07:57:26'),
(56, 29, 4, 0, 1, '2020-11-01 09:40:48', '2020-11-01 09:40:48'),
(59, 24, 3, 0, 1, '2020-11-01 09:41:56', '2020-11-01 09:41:56'),
(60, 24, 9, 0, 1, '2020-11-01 09:41:56', '2020-11-01 09:41:56'),
(61, 32, 7, 0, 1, '2020-11-01 09:51:52', '2020-11-01 09:51:52'),
(62, 33, 6, 0, 1, '2020-11-01 11:00:31', '2020-11-01 11:00:31'),
(63, 34, 9, 0, 1, '2020-11-01 11:03:11', '2020-11-01 11:03:11'),
(64, 36, 4, 0, 1, '2020-11-01 11:14:26', '2020-11-01 11:14:26');

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `image_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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 `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image_name`, `status`, `created_at`, `updated_at`) VALUES
(5, 6, '1603793849_2326.jpg', 1, '2020-10-27 10:17:29', '2020-10-27 10:17:29'),
(6, 11, '1603867377_1131.jpg', 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(7, 14, '1603953377_2762.jpg', 1, '2020-10-29 06:36:17', '2020-10-29 06:36:17'),
(8, 14, '1603953377_1260.jpg', 1, '2020-10-29 06:36:17', '2020-10-29 06:36:17'),
(9, 14, '1603953377_3536.jpg', 1, '2020-10-29 06:36:17', '2020-10-29 06:36:17'),
(10, 14, '1603953377_3563.jpg', 1, '2020-10-29 06:36:17', '2020-10-29 06:36:17'),
(11, 19, '1603962673_3556.jpg', 1, '2020-10-29 09:11:13', '2020-10-29 09:11:13'),
(12, 21, '1604207910_2585.JPG', 1, '2020-11-01 05:18:30', '2020-11-01 05:18:30'),
(13, 22, '1604212360_3138.jpg', 1, '2020-11-01 06:32:40', '2020-11-01 06:32:40'),
(14, 23, '1604212901_2470.jpg', 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(15, 23, '1604212901_3197.jpg', 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(16, 24, '1604216121_1277.jpg', 1, '2020-11-01 07:35:21', '2020-11-01 07:35:21'),
(17, 24, '1604216675_3403.jpg', 1, '2020-11-01 07:44:35', '2020-11-01 07:44:35'),
(18, 39, '1604301124_3099.jpg', 1, '2020-11-02 07:12:04', '2020-11-02 07:12:04'),
(19, 41, '1604303239_3851.jpg', 1, '2020-11-02 07:47:19', '2020-11-02 07:47:19'),
(20, 45, '1604304026_2110.jpg', 1, '2020-11-02 08:00:26', '2020-11-02 08:00:26'),
(21, 44, '1604304035_1175.jpg', 1, '2020-11-02 08:00:35', '2020-11-02 08:00:35');

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

--
-- Table structure for table `product_keywords`
--

CREATE TABLE `product_keywords` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `keyword_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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 `product_keywords`
--

INSERT INTO `product_keywords` (`id`, `product_id`, `keyword_name`, `status`, `created_at`, `updated_at`) VALUES
(9, 5, 'kurti', 1, '2020-10-27 09:40:59', '2020-10-27 09:40:59'),
(10, 5, 'ladies dress', 1, '2020-10-27 09:40:59', '2020-10-27 09:40:59'),
(11, 5, 'indian kurti', 1, '2020-10-27 09:40:59', '2020-10-27 09:40:59'),
(14, 6, 'shirt', 1, '2020-10-27 10:17:29', '2020-10-27 10:17:29'),
(15, 6, 'sleevless', 1, '2020-10-27 10:17:29', '2020-10-27 10:17:29'),
(16, 7, 'bag', 1, '2020-10-27 10:55:59', '2020-10-27 10:55:59'),
(17, 7, 'ladis bag', 1, '2020-10-27 10:55:59', '2020-10-27 10:55:59'),
(18, 8, 'huddy', 1, '2020-10-27 11:32:22', '2020-10-27 11:32:22'),
(19, 8, 'jacket', 1, '2020-10-27 11:32:22', '2020-10-27 11:32:22'),
(20, 8, 'winter collection', 1, '2020-10-27 11:32:22', '2020-10-27 11:32:22'),
(21, 9, 'man screen', 1, '2020-10-28 06:31:23', '2020-10-28 06:31:23'),
(22, 9, 'beatuy', 1, '2020-10-28 06:31:23', '2020-10-28 06:31:23'),
(23, 10, 't shirt', 1, '2020-10-28 06:37:10', '2020-10-28 06:37:10'),
(24, 10, 'yellow', 1, '2020-10-28 06:37:10', '2020-10-28 06:37:10'),
(25, 11, 't shi', 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(26, 11, 'genji', 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(29, 13, 'ladies', 1, '2020-10-29 06:15:27', '2020-10-29 06:15:27'),
(30, 13, 'box', 1, '2020-10-29 06:15:27', '2020-10-29 06:15:27'),
(31, 13, 'makeup', 1, '2020-10-29 06:15:27', '2020-10-29 06:15:27'),
(37, 15, 'apple iphone 12', 1, '2020-10-29 07:02:42', '2020-10-29 07:02:42'),
(38, 15, 'iphone12', 1, '2020-10-29 07:02:42', '2020-10-29 07:02:42'),
(39, 12, 'man', 1, '2020-10-29 07:02:48', '2020-10-29 07:02:48'),
(40, 12, 't shirt', 1, '2020-10-29 07:02:48', '2020-10-29 07:02:48'),
(41, 16, 'shirt', 1, '2020-10-29 07:50:37', '2020-10-29 07:50:37'),
(42, 16, 'mans', 1, '2020-10-29 07:50:37', '2020-10-29 07:50:37'),
(43, 16, 'man fashion', 1, '2020-10-29 07:50:37', '2020-10-29 07:50:37'),
(46, 19, 't shirt', 1, '2020-10-29 09:11:13', '2020-10-29 09:11:13'),
(47, 19, 'man tshirt', 1, '2020-10-29 09:11:13', '2020-10-29 09:11:13'),
(54, 20, 't shirt', 1, '2020-11-01 06:17:52', '2020-11-01 06:17:52'),
(55, 20, 'man fasion', 1, '2020-11-01 06:17:52', '2020-11-01 06:17:52'),
(60, 22, 'bag', 1, '2020-11-01 06:34:49', '2020-11-01 06:34:49'),
(61, 22, 'ladies', 1, '2020-11-01 06:34:49', '2020-11-01 06:34:49'),
(62, 23, 'bag', 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(63, 23, 'women', 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(64, 23, 'women fashion', 1, '2020-11-01 06:41:41', '2020-11-01 06:41:41'),
(71, 17, 'shirt', 1, '2020-11-01 06:48:58', '2020-11-01 06:48:58'),
(72, 17, 'man shirt', 1, '2020-11-01 06:48:58', '2020-11-01 06:48:58'),
(77, 14, 'apple', 1, '2020-11-01 07:45:20', '2020-11-01 07:45:20'),
(78, 14, 'iphone', 1, '2020-11-01 07:45:20', '2020-11-01 07:45:20'),
(79, 14, 'iphone11', 1, '2020-11-01 07:45:20', '2020-11-01 07:45:20'),
(80, 25, 'bag', 1, '2020-11-01 07:49:32', '2020-11-01 07:49:32'),
(81, 25, 'women bag', 1, '2020-11-01 07:49:32', '2020-11-01 07:49:32'),
(84, 26, 'bag', 1, '2020-11-01 07:57:26', '2020-11-01 07:57:26'),
(85, 26, 'ladies bag', 1, '2020-11-01 07:57:26', '2020-11-01 07:57:26'),
(86, 27, 'shoes', 1, '2020-11-01 09:33:37', '2020-11-01 09:33:37'),
(87, 27, 'women fashion', 1, '2020-11-01 09:33:37', '2020-11-01 09:33:37'),
(88, 28, 'shoes', 1, '2020-11-01 09:37:55', '2020-11-01 09:37:55'),
(89, 29, 'black shoes', 1, '2020-11-01 09:40:48', '2020-11-01 09:40:48'),
(90, 29, 'women shoes', 1, '2020-11-01 09:40:48', '2020-11-01 09:40:48'),
(91, 24, 'bag', 1, '2020-11-01 09:41:56', '2020-11-01 09:41:56'),
(92, 24, 'women', 1, '2020-11-01 09:41:56', '2020-11-01 09:41:56'),
(93, 30, 'golden shoes', 1, '2020-11-01 09:45:07', '2020-11-01 09:45:07'),
(94, 32, 'sheos', 1, '2020-11-01 09:51:52', '2020-11-01 09:51:52'),
(95, 33, 'gown', 1, '2020-11-01 11:00:31', '2020-11-01 11:00:31'),
(96, 34, 'gown', 1, '2020-11-01 11:03:11', '2020-11-01 11:03:11'),
(97, 34, 'woemn party', 1, '2020-11-01 11:03:11', '2020-11-01 11:03:11'),
(98, 35, 'four set', 1, '2020-11-01 11:11:48', '2020-11-01 11:11:48'),
(99, 35, '4 set', 1, '2020-11-01 11:11:48', '2020-11-01 11:11:48'),
(100, 36, 'gown', 1, '2020-11-01 11:14:26', '2020-11-01 11:14:26'),
(101, 36, 'women gown', 1, '2020-11-01 11:14:26', '2020-11-01 11:14:26'),
(102, 37, 'girls', 1, '2020-11-02 05:18:09', '2020-11-02 05:18:09'),
(103, 37, 'baby dress', 1, '2020-11-02 05:18:09', '2020-11-02 05:18:09'),
(104, 37, 'girls dress', 1, '2020-11-02 05:18:09', '2020-11-02 05:18:09'),
(105, 38, 'baby dress', 1, '2020-11-02 06:58:15', '2020-11-02 06:58:15'),
(106, 38, 'girls dress', 1, '2020-11-02 06:58:15', '2020-11-02 06:58:15'),
(107, 39, 'baby', 1, '2020-11-02 07:12:04', '2020-11-02 07:12:04'),
(108, 39, 'dress', 1, '2020-11-02 07:12:04', '2020-11-02 07:12:04'),
(109, 40, 'mouse', 1, '2020-11-02 07:44:42', '2020-11-02 07:44:42'),
(110, 40, 'optical mouse', 1, '2020-11-02 07:44:42', '2020-11-02 07:44:42'),
(117, 43, 'soudn box', 1, '2020-11-02 07:57:31', '2020-11-02 07:57:31'),
(118, 43, 'speaker', 1, '2020-11-02 07:57:31', '2020-11-02 07:57:31'),
(119, 43, 'Computer Accessories', 1, '2020-11-02 07:57:31', '2020-11-02 07:57:31'),
(123, 42, 'RAPOO', 1, '2020-11-02 07:57:50', '2020-11-02 07:57:50'),
(124, 42, 'Computer Accessories', 1, '2020-11-02 07:57:50', '2020-11-02 07:57:50'),
(125, 41, 'primax', 1, '2020-11-02 07:58:09', '2020-11-02 07:58:09'),
(126, 41, 'Computer Accessories', 1, '2020-11-02 07:58:09', '2020-11-02 07:58:09'),
(127, 45, 'computer items', 1, '2020-11-02 08:00:26', '2020-11-02 08:00:26'),
(128, 45, 'headphone', 1, '2020-11-02 08:00:26', '2020-11-02 08:00:26'),
(129, 44, 'gaming', 1, '2020-11-02 08:00:35', '2020-11-02 08:00:35'),
(130, 44, 'headphone', 1, '2020-11-02 08:00:35', '2020-11-02 08:00:35'),
(131, 44, 'Computer Accessories', 1, '2020-11-02 08:00:35', '2020-11-02 08:00:35'),
(132, 46, 'gigabytes', 1, '2020-11-02 08:12:50', '2020-11-02 08:12:50'),
(136, 48, 'jursey', 1, '2020-11-02 09:39:32', '2020-11-02 09:39:32'),
(137, 48, 't shirt', 1, '2020-11-02 09:39:32', '2020-11-02 09:39:32'),
(138, 48, 'shirt', 1, '2020-11-02 09:39:32', '2020-11-02 09:39:32'),
(139, 47, 'jersey', 1, '2020-11-02 09:39:52', '2020-11-02 09:39:52'),
(140, 47, 'bercelona', 1, '2020-11-02 09:39:52', '2020-11-02 09:39:52'),
(141, 47, 't shirt', 1, '2020-11-02 09:39:52', '2020-11-02 09:39:52'),
(142, 47, 'genji', 1, '2020-11-02 09:39:52', '2020-11-02 09:39:52'),
(147, 49, 'jersey', 1, '2020-11-04 08:19:50', '2020-11-04 08:19:50'),
(148, 49, 'real madrid', 1, '2020-11-04 08:19:50', '2020-11-04 08:19:50'),
(149, 49, 't shirt', 1, '2020-11-04 08:19:50', '2020-11-04 08:19:50'),
(150, 49, 'genji', 1, '2020-11-04 08:19:50', '2020-11-04 08:19:50');

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

--
-- Table structure for table `product_size`
--

CREATE TABLE `product_size` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `size_id` int(11) NOT NULL,
  `quantity` int(11) DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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_size`
--

INSERT INTO `product_size` (`id`, `product_id`, `size_id`, `quantity`, `status`, `created_at`, `updated_at`) VALUES
(1, 6, 8, 0, 1, '2020-10-27 10:17:28', '2020-10-27 10:17:28'),
(2, 6, 7, 0, 1, '2020-10-27 10:17:28', '2020-10-27 10:17:28'),
(3, 6, 4, 0, 1, '2020-10-27 10:17:28', '2020-10-27 10:17:28'),
(4, 8, 3, 0, 1, '2020-10-27 11:32:22', '2020-10-27 11:32:22'),
(5, 11, 6, 0, 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(6, 11, 8, 0, 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(7, 11, 4, 0, 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(8, 11, 7, 0, 1, '2020-10-28 06:42:57', '2020-10-28 06:42:57'),
(11, 12, 8, 0, 1, '2020-10-29 07:02:48', '2020-10-29 07:02:48'),
(12, 12, 7, 0, 1, '2020-10-29 07:02:48', '2020-10-29 07:02:48'),
(13, 16, 8, 0, 1, '2020-10-29 07:50:37', '2020-10-29 07:50:37'),
(14, 16, 6, 0, 1, '2020-10-29 07:50:37', '2020-10-29 07:50:37'),
(18, 18, 8, 0, 1, '2020-10-29 07:59:01', '2020-10-29 07:59:01'),
(19, 18, 6, 0, 1, '2020-10-29 07:59:01', '2020-10-29 07:59:01'),
(20, 19, 8, 0, 1, '2020-10-29 09:11:13', '2020-10-29 09:11:13'),
(21, 19, 7, 0, 1, '2020-10-29 09:11:13', '2020-10-29 09:11:13'),
(31, 21, 8, 0, 1, '2020-11-01 05:18:30', '2020-11-01 05:18:30'),
(32, 21, 6, 0, 1, '2020-11-01 05:18:30', '2020-11-01 05:18:30'),
(33, 21, 4, 0, 1, '2020-11-01 05:18:30', '2020-11-01 05:18:30'),
(34, 20, 6, 0, 1, '2020-11-01 06:17:52', '2020-11-01 06:17:52'),
(35, 20, 7, 0, 1, '2020-11-01 06:17:52', '2020-11-01 06:17:52'),
(36, 20, 8, 0, 1, '2020-11-01 06:17:52', '2020-11-01 06:17:52'),
(37, 17, 8, 0, 1, '2020-11-01 06:48:58', '2020-11-01 06:48:58'),
(38, 17, 6, 0, 1, '2020-11-01 06:48:58', '2020-11-01 06:48:58'),
(39, 17, 4, 0, 1, '2020-11-01 06:48:58', '2020-11-01 06:48:58'),
(40, 30, 12, 0, 1, '2020-11-01 09:45:07', '2020-11-01 09:45:07'),
(41, 30, 10, 0, 1, '2020-11-01 09:45:07', '2020-11-01 09:45:07'),
(42, 30, 9, 0, 1, '2020-11-01 09:45:07', '2020-11-01 09:45:07'),
(43, 31, 12, 0, 1, '2020-11-01 09:49:15', '2020-11-01 09:49:15'),
(44, 31, 10, 0, 1, '2020-11-01 09:49:15', '2020-11-01 09:49:15'),
(45, 33, 3, 0, 1, '2020-11-01 11:00:31', '2020-11-01 11:00:31'),
(46, 33, 1, 0, 1, '2020-11-01 11:00:31', '2020-11-01 11:00:31'),
(51, 48, 14, 0, 1, '2020-11-02 09:39:32', '2020-11-02 09:39:32'),
(52, 48, 5, 0, 1, '2020-11-02 09:39:32', '2020-11-02 09:39:32'),
(53, 48, 13, 0, 1, '2020-11-02 09:39:32', '2020-11-02 09:39:32'),
(54, 47, 5, 0, 1, '2020-11-02 09:39:52', '2020-11-02 09:39:52'),
(55, 47, 14, 0, 1, '2020-11-02 09:39:52', '2020-11-02 09:39:52'),
(59, 49, 14, 0, 1, '2020-11-04 08:19:50', '2020-11-04 08:19:50'),
(60, 49, 5, 0, 1, '2020-11-04 08:19:50', '2020-11-04 08:19:50'),
(61, 49, 15, 0, 1, '2020-11-04 08:19:50', '2020-11-04 08:19:50');

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

--
-- Table structure for table `pwa_settings`
--

CREATE TABLE `pwa_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `app_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_short_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) 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 `pwa_settings`
--

INSERT INTO `pwa_settings` (`id`, `app_name`, `app_short_name`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Limmerz Shop', 'Limmerz', 'icon-512x512.png', '2020-09-28 11:31:01', '2020-09-28 11:31:01'),
(2, 'Limmerz Shop', 'Limmerz', 'icon-512x512.png', '2020-09-29 10:00:47', '2020-09-29 10:00:47'),
(3, 'Limmerz Shop', 'Limmerz', 'icon-512x512.png', '2020-09-29 10:01:26', '2020-09-29 10:01:26');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_name` varchar(191) 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 `roles`
--

INSERT INTO `roles` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', NULL, NULL);

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

--
-- Table structure for table `seo_keywords`
--

CREATE TABLE `seo_keywords` (
  `id` int(10) UNSIGNED NOT NULL,
  `seo_setting_id` int(11) NOT NULL,
  `keyword` varchar(191) 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;

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

--
-- Table structure for table `seo_settings`
--

CREATE TABLE `seo_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sitemap_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keyword` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text 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 `seo_settings`
--

INSERT INTO `seo_settings` (`id`, `title`, `meta_image`, `sitemap_link`, `keyword`, `author`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Limmerz | Start Your Own Ecommerce Today', '5ed50b0000acd.jpeg', 'sitemap.com', 'Limmex Groce, grocery, ecommerce, home applience, lacommerz, lacommerz, La commerz, La commerz, Limmex ecommerce, Limmex ecommerce, Limmex Automation, Limmex Automation, limmerz', 'Limmex Automation', 'Limmerz is an ecommerce solution for both grocery and lifestyle based on laravel and vue.js', '2020-02-08 18:05:09', '2020-06-01 02:04:49');

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

--
-- Table structure for table `shipping_areas`
--

CREATE TABLE `shipping_areas` (
  `id` int(10) UNSIGNED NOT NULL,
  `city` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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 `shipping_areas`
--

INSERT INTO `shipping_areas` (`id`, `city`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Area 1', 1, '2020-09-27 09:19:12', '2020-09-27 09:19:12'),
(2, 'Area 2', 1, '2020-09-27 09:19:17', '2020-09-27 09:19:17'),
(3, 'Area 3', 1, '2020-09-27 09:19:24', '2020-09-27 09:19:24');

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

--
-- Table structure for table `shipping_costs`
--

CREATE TABLE `shipping_costs` (
  `id` int(10) UNSIGNED NOT NULL,
  `minimum_order_amount` double DEFAULT NULL,
  `shipping_amount` double NOT NULL,
  `order_amount` double NOT NULL,
  `discount_amount` double NOT NULL,
  `shipping_status` tinyint(4) NOT NULL DEFAULT 0,
  `discount_status` tinyint(4) NOT NULL DEFAULT 0,
  `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 `shipping_costs`
--

INSERT INTO `shipping_costs` (`id`, `minimum_order_amount`, `shipping_amount`, `order_amount`, `discount_amount`, `shipping_status`, `discount_status`, `created_at`, `updated_at`) VALUES
(1, 200, 40, 1500, 20, 1, 1, '2020-04-18 14:48:42', '2020-10-06 07:13:01');

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

--
-- Table structure for table `shop_settings`
--

CREATE TABLE `shop_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `shop_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shop_short_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `facebook` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_header` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo_footer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favicon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme_color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hot_deal_status` tinyint(4) DEFAULT 1,
  `slider_status` tinyint(4) DEFAULT 1,
  `onsale_status` tinyint(4) DEFAULT 1,
  `sidemenu_status` tinyint(4) 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 `shop_settings`
--

INSERT INTO `shop_settings` (`id`, `shop_name`, `shop_short_name`, `address`, `footer_text`, `phone`, `email`, `facebook`, `twitter`, `youtube`, `logo_header`, `logo_footer`, `favicon`, `theme_color`, `hot_deal_status`, `slider_status`, `onsale_status`, `sidemenu_status`, `created_at`, `updated_at`) VALUES
(1, 'Limmerz', NULL, '219 muktobangla complex , Dhaka-1205', '2020 all right reserve by@LimmexAutomation', '01312447767', 'business@limmexbd.com', 'https://facebook.com', 'https://twitter.com', 'https://youtube.com', '5ed50bc056bf0.png', '5ed50bc05fd25.png', '5ed50bc066add.png', '#E3106E', 1, 1, 1, 0, '2020-02-09 21:00:06', '2020-11-02 06:34:07');

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

--
-- Table structure for table `sizes`
--

CREATE TABLE `sizes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint(20) DEFAULT 0,
  `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 `sizes`
--

INSERT INTO `sizes` (`id`, `name`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 'XL', 1, '2020-10-27 10:13:23', '2020-10-27 10:13:23'),
(2, 'S', 1, '2020-10-27 10:13:32', '2020-10-27 10:13:32'),
(3, 'SM', 1, '2020-10-27 10:13:39', '2020-10-27 10:13:39'),
(4, 'XXL', 2, '2020-10-27 10:13:45', '2020-10-27 10:13:45'),
(5, 'XL', 7, '2020-10-27 10:13:51', '2020-10-27 10:13:51'),
(6, 'XLL', 2, '2020-10-27 10:13:58', '2020-10-27 10:13:58'),
(7, 'L', 2, '2020-10-27 10:14:06', '2020-10-27 10:14:06'),
(8, 'S', 2, '2020-10-27 10:14:17', '2020-10-27 10:14:17'),
(9, '7', 1, '2020-11-01 09:33:55', '2020-11-01 09:33:55'),
(10, '8', 1, '2020-11-01 09:34:04', '2020-11-01 09:34:04'),
(11, '9', 1, '2020-11-01 09:34:09', '2020-11-01 09:34:09'),
(12, '10', 1, '2020-11-01 09:34:16', '2020-11-01 09:34:16'),
(13, 'L', 7, '2020-11-02 09:37:08', '2020-11-02 09:37:08'),
(14, 'M', 7, '2020-11-02 09:37:48', '2020-11-02 09:37:48'),
(15, 'XXL', 7, '2020-11-02 09:37:55', '2020-11-02 09:37:55');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slider_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `back_link_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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 `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `slider_image`, `back_link_url`, `description`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Hot Deal', 'slider_banner5f9fa68add660.png', NULL, NULL, 1, '2020-11-02 06:00:41', '2020-11-02 06:26:18'),
(3, 'Grand Opening Discount', 'slider_banner5f9fab5f8ed6c.png', NULL, NULL, 1, '2020-11-02 06:46:55', '2020-11-02 06:46:55');

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

--
-- Table structure for table `stockhistories`
--

CREATE TABLE `stockhistories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_brand` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_sub_category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `added_new_stock` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(191) 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;

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_category_native_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home_view` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) 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 `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `category_id`, `sub_category_name`, `sub_category_native_name`, `icon`, `home_view`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Gown', 'Gown', '5f69eef3877ca.png', 1, 1, '2020-09-22 12:01:18', '2020-09-22 12:32:51'),
(2, 1, 'Shoes', NULL, '5f69e7bc2e576.png', 1, 1, '2020-09-22 12:02:04', '2020-09-22 12:02:04'),
(5, 1, 'Cosmetics', 'makeup', '5f69ed5d4267f.png', 1, 1, '2020-09-22 12:26:05', '2020-09-22 12:26:29'),
(6, 1, 'Hijab', 'Hijab', '5f69ee29df2e4.png', 1, 1, '2020-09-22 12:28:23', '2020-09-22 12:29:29'),
(7, 1, 'Kurti', 'kurti', '5f69efd5b67a6.png', 1, 1, '2020-09-22 12:30:18', '2020-09-22 12:36:37'),
(8, 1, 'Skirt', 'Skirt', '5f69ef397dcb5.png', 1, 1, '2020-09-22 12:30:30', '2020-09-22 12:34:01'),
(9, 2, 'T-Shirt', 'Tshirt', '5f69f357e7055.png', 1, 1, '2020-09-22 12:40:44', '2020-09-22 12:51:35'),
(10, 1, 'Bag', 'bag', '5f69f1468f7e9.png', 1, 1, '2020-09-22 12:42:46', '2020-09-22 12:42:46'),
(11, 1, 'Watch', 'Watch', '5f69f28538312.png', 1, 1, '2020-09-22 12:44:38', '2020-09-22 12:48:05'),
(12, 2, 'Polo Shirt', 'Polo Shirt', '5f69f316a740a.png', 1, 1, '2020-09-22 12:50:30', '2020-09-22 12:50:30'),
(13, 2, 'Shirt', 'Shirt', '5f69f5100e148.png', 1, 1, '2020-09-22 12:56:03', '2020-09-22 12:58:56'),
(14, 2, 'Pant', 'Pant', '5f69f520290a3.png', 1, 1, '2020-09-22 12:59:12', '2020-09-22 12:59:12'),
(15, 2, 'Jacket', 'Jacket', '5f69f55c19338.png', 1, 1, '2020-09-22 13:00:12', '2020-09-22 13:00:12'),
(16, 3, 'Baby Food', 'Baby Food', '5f69f6882da9e.png', 1, 1, '2020-09-22 13:05:12', '2020-09-22 13:05:12'),
(17, 3, 'Girls\' Dress', 'Girls Dress', '5f69f73703c86.png', 1, 1, '2020-09-22 13:08:07', '2020-09-22 13:08:07'),
(18, 3, 'Boys\' Dress', 'Boys\' Dress', '5f69f74bcce8b.png', 1, 1, '2020-09-22 13:08:27', '2020-09-22 13:08:27'),
(19, 3, 'Diapers', 'Diapers', '5f69f8234e70e.png', 1, 1, '2020-09-22 13:12:03', '2020-09-22 13:12:03'),
(20, 6, 'Smartphone', 'Smartmobile', '5f9a5fa905625.png', 1, 1, '2020-10-29 06:22:33', '2020-10-29 06:22:33'),
(21, 6, 'Computer Accessories', 'sss', '5f9fb8ad0a414.png', 1, 1, '2020-11-02 07:43:41', '2020-11-02 07:43:41'),
(22, 7, 'Jursey', 'Jursey', '5f9fd100a88d5.png', 1, 1, '2020-11-02 09:27:28', '2020-11-02 09:27:28'),
(23, 7, 'Gym Item', 'Gym Item', '5f9fd14f7dc9b.png', 1, 1, '2020-11-02 09:28:47', '2020-11-02 09:28:47');

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

--
-- Table structure for table `sub_category_brands`
--

CREATE TABLE `sub_category_brands` (
  `id` int(10) UNSIGNED NOT NULL,
  `sub_sub_category_id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `sub_sub_categories`
--

CREATE TABLE `sub_sub_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `sub_sub_category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_sub_category_native_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `trials`
--

CREATE TABLE `trials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_in_cart` int(11) NOT NULL DEFAULT 0,
  `max_trial_item` int(11) NOT NULL,
  `trial_charge_per_item` double NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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 `trials`
--

INSERT INTO `trials` (`id`, `product_in_cart`, `max_trial_item`, `trial_charge_per_item`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 0, 1, NULL, '2020-10-27 06:25:07');

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

--
-- Table structure for table `trial_products`
--

CREATE TABLE `trial_products` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `sub_sub_category_id` int(11) DEFAULT 0,
  `brand_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL,
  `color_id` int(11) DEFAULT 0,
  `size_id` int(11) DEFAULT 0,
  `user_id` int(11) NOT NULL COMMENT 'customer_id',
  `quantity` int(11) NOT NULL,
  `selling_price` double NOT NULL,
  `buying_price` double NOT NULL,
  `total_buying_price` double NOT NULL,
  `total_selling_price` double NOT NULL,
  `unit_discount` double NOT NULL DEFAULT 0,
  `total_discount` double NOT NULL DEFAULT 0,
  `trialed` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = not trialed , 1 = trialed',
  `invoiced` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = not invoiced, 1 = invoiced',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `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 `user_coupon`
--

CREATE TABLE `user_coupon` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `coupon_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valid_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_used` tinyint(4) NOT NULL DEFAULT 0,
  `is_applied` tinyint(4) NOT NULL DEFAULT 0,
  `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 `user_coupon`
--

INSERT INTO `user_coupon` (`id`, `user_id`, `coupon_code`, `valid_date`, `is_used`, `is_applied`, `created_at`, `updated_at`) VALUES
(1, 3, 'LLLLLL', '2020-10-16', 1, 1, '2020-10-06 06:48:26', '2020-10-06 06:49:03');

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `campaigns`
--
ALTER TABLE `campaigns`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `colors`
--
ALTER TABLE `colors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `currency`
--
ALTER TABLE `currency`
  ADD PRIMARY KEY (`id`),
  ADD KEY `currency_currency_status_index` (`currency_status`);

--
-- Indexes for table `current_currencies`
--
ALTER TABLE `current_currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `delivery_slot_settings`
--
ALTER TABLE `delivery_slot_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `delivery_time_s_lots`
--
ALTER TABLE `delivery_time_s_lots`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `google_analytics`
--
ALTER TABLE `google_analytics`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `installtion_settings`
--
ALTER TABLE `installtion_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messengers`
--
ALTER TABLE `messengers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mobile_otp`
--
ALTER TABLE `mobile_otp`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_color`
--
ALTER TABLE `product_color`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_keywords`
--
ALTER TABLE `product_keywords`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_size`
--
ALTER TABLE `product_size`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pwa_settings`
--
ALTER TABLE `pwa_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `seo_keywords`
--
ALTER TABLE `seo_keywords`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `seo_settings`
--
ALTER TABLE `seo_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shipping_areas`
--
ALTER TABLE `shipping_areas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shipping_costs`
--
ALTER TABLE `shipping_costs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shop_settings`
--
ALTER TABLE `shop_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sizes`
--
ALTER TABLE `sizes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `stockhistories`
--
ALTER TABLE `stockhistories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscribers_email_unique` (`email`);

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sub_category_brands`
--
ALTER TABLE `sub_category_brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sub_sub_categories`
--
ALTER TABLE `sub_sub_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trials`
--
ALTER TABLE `trials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trial_products`
--
ALTER TABLE `trial_products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_coupon`
--
ALTER TABLE `user_coupon`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `campaigns`
--
ALTER TABLE `campaigns`
  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=10;

--
-- AUTO_INCREMENT for table `colors`
--
ALTER TABLE `colors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `currency`
--
ALTER TABLE `currency`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=134;

--
-- AUTO_INCREMENT for table `current_currencies`
--
ALTER TABLE `current_currencies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `delivery_slot_settings`
--
ALTER TABLE `delivery_slot_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `delivery_time_s_lots`
--
ALTER TABLE `delivery_time_s_lots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `google_analytics`
--
ALTER TABLE `google_analytics`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `installtion_settings`
--
ALTER TABLE `installtion_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `messengers`
--
ALTER TABLE `messengers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;

--
-- AUTO_INCREMENT for table `mobile_otp`
--
ALTER TABLE `mobile_otp`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `product_color`
--
ALTER TABLE `product_color`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `product_keywords`
--
ALTER TABLE `product_keywords`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT for table `product_size`
--
ALTER TABLE `product_size`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `pwa_settings`
--
ALTER TABLE `pwa_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `seo_keywords`
--
ALTER TABLE `seo_keywords`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `seo_settings`
--
ALTER TABLE `seo_settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `shipping_areas`
--
ALTER TABLE `shipping_areas`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `shipping_costs`
--
ALTER TABLE `shipping_costs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `shop_settings`
--
ALTER TABLE `shop_settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sizes`
--
ALTER TABLE `sizes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `stockhistories`
--
ALTER TABLE `stockhistories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `sub_category_brands`
--
ALTER TABLE `sub_category_brands`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sub_sub_categories`
--
ALTER TABLE `sub_sub_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trials`
--
ALTER TABLE `trials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `trial_products`
--
ALTER TABLE `trial_products`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_coupon`
--
ALTER TABLE `user_coupon`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

