[encoded data, 30723 characters]\" style=\"width: 754.722px;\" data-filename=\"acX2JyotwR.jpg\"><br></p>', NULL, '2650', '250', '2050', 1, '2450', 100, NULL, '2023-08-28-64ecdc3888c8a.png', 1, 0, 31, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-08-28 11:41:12', '2024-01-25 01:48:52', NULL, NULL);
INSERT INTO `products` (`id`, `author_id`, `user_id`, `brand_id`, `slug`, `title`, `short_description`, `full_description`, `spec`, `regular_price`, `whole_price`, `buying_price`, `dis_type`, `discount_price`, `quantity`, `unit`, `image`, `shipping_charge`, `point`, `reach`, `status`, `is_aproved`, `type`, `download_able`, `download_limit`, `download_expire`, `sheba`, `book`, `isbn`, `edition`, `pages`, `country`, `language`, `book_file`, `refer`, `video`, `video_thumb`, `yvideo`, `created_at`, `updated_at`, `sku`, `prdct_extra_msg`) VALUES
(701, NULL, 1, 293, '69706159778058', 'Huawei Y5 (2019) Software Development', NULL, '<p>Huawei Y5 (2019) Software Development&nbsp;<br></p>', NULL, '1750', '1500', '0', 1, '1500', 95, NULL, '2023-08-29-64edc286323c3.png', 1, 0, 35, 1, 1, 0, 1, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, '2023-08-29 04:03:50', '2023-09-10 12:01:56', NULL, NULL),
(702, NULL, 1, 295, '848962218007945', 'Samsung Galaxy J7 Back Part - Phone Back Cover', '<p><span style=\"color: rgb(55, 65, 81); font-family: Söhne, ui-sans-serif, system-ui, -apple-system, &quot;Segoe UI&quot;, Roboto, Ubuntu, Cantarell, &quot;Noto Sans&quot;, sans-serif, &quot;Helvetica Neue&quot;, Arial, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: pre-wrap; background-color: rgb(247, 247, 248); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">Enhance the protection and style of your Samsung Galaxy J7 with our premium Back Part Phone Back Cover. Crafted with precision to fit your device perfectly.<br></span></p>', '<p>Enhance the protection and style of your Samsung Galaxy J7 with our premium Back Part Phone Back Cover. Crafted with precision to fit your device perfectly, this sleek and durable cover shields your phone from scratches, bumps, and everyday wear. Its slim design maintains the phone\'s slim profile while offering full access to ports and buttons. Express your personal style with a range of colors and textures. Elevate your Galaxy J7\'s look and safeguard it in style with our Back Part Phone Back Cover.<br></p>', NULL, '110', '105', '100', 1, NULL, 10, NULL, '2023-09-05-64f793e4da9af.jpg', 1, 0, 17, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-09-05-64f794ac2a0b8.png', NULL, '2023-09-05 14:47:33', '2024-01-24 23:40:06', NULL, NULL),
(703, NULL, 1, 293, '116571807278252', 'Cotton Short Sleeve T-Shirt for Women', '<div id=\"module_product_title_1\" class=\"pdp-block module\"><div class=\"pdp-product-title\"><div class=\"pdp-mod-product-badge-wrapper\">মহিলাদের জন্য সুতির ছোট হাতা টি-শার্ট</div></div></div><p></p>', '<div class=\"html-content pdp-product-highlights\" data-spm-anchor-id=\"a2a0e.pdp.product_detail.i0.6db67ac0xWamX9\"><ul class=\"\"><li class=\"\">Product Type: Stylish Half Sleeve T-Shirt For Women</li><li class=\"\">Colour: Pink</li><li class=\"\">Material: Cotton</li><li class=\"\">Gender: Women</li><li class=\"\">Stylish Design</li><li class=\"\">High Quality Cotton Fabric</li><li class=\"\">Fabric: 100% Cotton</li><li class=\"\">Fabrication: 120+ GSM</li></ul></div><p></p>', NULL, '130', '120', '100', 1, NULL, 10, NULL, '2023-09-11-64ff038a46ac3.jpg', 1, 0, 1, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:09:46', '2023-09-11 06:12:23', NULL, NULL),
(704, NULL, 1, 293, '524389047792841', 'New Arrivals Women White T Shirt Fashion Belle Bubble Gum', '<p>নতুন আগত মহিলাদের সাদা টি শার্ট ফ্যাশন বেলে বাবল গাম<br></p>', '<p>New Arrivals Women White T Shirt Fashion Belle Bubble Gum<br></p>', NULL, '170', '160', '150', 1, NULL, 10, NULL, '2023-09-11-64ff06f43c8af.jpg', 1, 1700, 1, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:24:20', '2023-09-11 06:31:06', NULL, NULL),
(705, NULL, 1, 293, '70314329941904', 'Cotton Short-Sleeved T-Shirt Women′ S Summer Round Neck Loose Large Size Bottoming Shirt', '<p>সুতির খাটো-হাতা টি-শার্ট মহিলাদের গ্রীষ্মকালীন গোল গলা ঢিলেঢালা বড় সাইজের নিচের শার্ট<br></p>', '<p>Cotton Short-Sleeved T-Shirt Women′ S Summer Round Neck Loose Large Size Bottoming Shirt <br></p>', NULL, '530', '520', '500', 1, NULL, 10, NULL, '2023-09-11-64ff08384e9eb.jpg', 1, 0, 4, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:29:44', '2024-01-31 22:25:21', NULL, NULL),
(706, NULL, 1, 293, '695440100617689', 'Factory Customized Supply Logo Design Soft Girls High Quality Cheap Unisex T Shirt', '<p>ফ্যাক্টরি কাস্টমাইজড সাপ্লাই লোগো ডিজাইন নরম মেয়েদের উচ্চ মানের সস্তা ইউনিসেক্স টি শার্ট<br></p>', '<p>Factory Customized Supply Logo Design Soft Girls High Quality Cheap Unisex T Shirt<br></p>', NULL, '220', '210', '200', 1, NULL, 10, NULL, '2023-09-11-64ff091550232.jpg', 1, 0, 0, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:33:25', '2023-09-11 06:33:25', NULL, NULL),
(707, NULL, 1, 293, '231289214664771', 'SMILE statement t-shirt/shirt tees printed TSHIRT FOR WOMEN', '<p>স্মাইল স্টেটমেন্ট টি-শার্ট/শার্ট টিস প্রিন্ট করা টিশার্ট মহিলাদের জন্য<br></p>', '<p><a rel=\"noopener\" target=\"_blank\" href=\"https://www.lazada.com.ph/products/smile-statement-t-shirtshirt-tees-printed-tshirt-for-women-i3678169125.html\" data-ved=\"0CBIQjhxqFwoTCNjinKnIooEDFQAAAAAdAAAAABAJ\" class=\"gQtke indIKd\"><h3 class=\"MCLffc cS4Vcb-pGL6qe-fwJd0c\">SMILE statement t-shirt/shirt tees printed TSHIRT FOR WOMEN </h3></a></p>', NULL, '140', '130', '120', 1, NULL, 10, NULL, '2023-09-11-64ff096d84850.jpg', 1, 0, 0, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:34:53', '2023-09-11 06:34:53', NULL, NULL),
(708, NULL, 1, 293, '630512530465001', 'Zealcafe Instant Tea (Lemon) -500gm', '<p>জিলক্যাফে ইনস্ট্যান্ট চা (লেবু)-500 গ্রাম<br></p>', '<p>Zealcafe Instant Tea (Lemon) -500gm<br></p>', NULL, '135', '130', '125', 1, NULL, 10, NULL, '2023-09-11-64ff0bc522100.png', 1, 0, 2, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:44:53', '2024-01-25 01:49:03', NULL, NULL),
(709, NULL, 1, 293, '336811718673058', 'Twinings Pure Camomile Tea Bags 80 Pack-Australia', '<p>টুইনিংস পিওর ক্যামোমাইল টি ব্যাগ 80 প্যাক-অস্ট্রেলিয়া<br></p>', '<p>Twinings Pure Camomile Tea Bags 80 Pack-Australia<br></p>', NULL, '130', '120', '110', 1, NULL, 19, NULL, '2023-09-11-64ff0c11ea3d6.png', 1, 0, 2, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:46:10', '2024-03-25 03:55:43', NULL, NULL),
(710, NULL, 1, 293, '137215454653210', 'The Spicy For Red Tea By Arafah -50Gm', '<p>আরাফাহ - ৫০ গ্রাম লাল চায়ের জন্য মশলাদার<br></p>', '<p>The Spicy For Red Tea By Arafah -50Gm<br></p>', NULL, '120', '110', '100', 1, NULL, 9, NULL, '2023-09-11-64ff0c44a1184.png', 1, 0, 3, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:47:00', '2024-02-05 22:29:02', NULL, NULL),
(711, NULL, 1, 293, '971506338628169', 'BadgeMilk Tea 15gm- 12PCS ( 4 in 1 Tea- Refresh Cafe )', '<p>ব্যাজ মিল্ক চা 15 গ্রাম- 12 পিসিএস ( 1 টি চা- রিফ্রেশ ক্যাফে )<br></p>', '<p>BadgeMilk Tea 15gm- 12PCS ( 4 in 1 Tea- Refresh Cafe )<br></p>', NULL, '16', '12', '10', 1, NULL, 10, NULL, '2023-09-11-64ff0c76eb4d6.png', 1, 0, 11, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:47:51', '2024-02-04 07:20:00', NULL, NULL),
(712, NULL, 1, 293, '755110922357103', 'COFFEE-MATE Coffee Creamer - 1kg', '<p>কফি-মেট কফি ক্রিমার - 1 কেজি<br></p>', '<p>COFFEE-MATE Coffee Creamer - 1kg<br></p>', NULL, '65', '55', '50', 1, NULL, 20, NULL, '2023-09-11-64ff0ca991149.png', 1, 0, 1, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '2023-09-11 06:48:41', '2024-01-21 01:38:21', NULL, NULL),
(713, NULL, 1, 293, '364474460397951', 'Mustard Flower Honey 1 kg (Glass Jar) Maag Honey', '<p>সরিষা ফুলের মধু 1 কেজি (গ্লাস জার) মাগ মধু<br></p>', '<p>Mustard Flower Honey 1 kg (Glass Jar) Maag Honey<br></p>', NULL, '35', '30', '25', 1, NULL, 10, NULL, '2023-09-11-64ff0cd658940.png', 1, 0, 9, 1, 1, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, '2023-09-11 06:49:26', '2024-04-04 04:52:17', 'MFH001', NULL);

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

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

CREATE TABLE `product_images` (
  `id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `color_attri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `color_attri`, `name`, `created_at`, `updated_at`) VALUES
(259, 683, NULL, '2023-08-23-64e5bd9b93943.png', '2023-08-23 02:04:43', '2023-08-23 02:04:43'),
(263, 684, NULL, '2023-08-23-64e5c18e054d3.png', '2023-08-23 02:21:34', '2023-08-23 02:21:34'),
(285, 697, NULL, '2023-08-28-64ec5ad5a8b98.png', '2023-08-28 02:29:09', '2023-08-28 02:29:09'),
(286, 698, NULL, '2023-08-28-64ec766d41a04.png', '2023-08-28 04:26:53', '2023-08-28 04:26:53'),
(287, 698, NULL, '2023-08-28-64ec766d4878b.png', '2023-08-28 04:26:53', '2023-08-28 04:26:53'),
(288, 698, NULL, '2023-08-28-64ec766d4c42f.png', '2023-08-28 04:26:53', '2023-08-28 04:26:53'),
(289, 698, 'black', '2023-08-28-64ec766d4e719.png', '2023-08-28 04:26:53', '2023-08-28 04:26:53'),
(290, 683, NULL, '2023-08-28-64ec8515a97f8.png', '2023-08-28 05:29:25', '2023-08-28 05:29:25'),
(291, 683, NULL, '2023-08-28-64ec8515af75a.png', '2023-08-28 05:29:25', '2023-08-28 05:29:25'),
(292, 683, NULL, '2023-08-28-64ec8515b07d1.png', '2023-08-28 05:29:25', '2023-08-28 05:29:25'),
(293, 683, NULL, '2023-08-28-64ec8515b38a1.png', '2023-08-28 05:29:25', '2023-08-28 05:29:25'),
(297, 683, NULL, '2023-08-28-64ec8590b4464.png', '2023-08-28 05:31:28', '2023-08-28 05:31:28'),
(301, 683, 'orange', '2023-08-28-64ec867d87db6.png', '2023-08-28 05:35:25', '2023-08-28 05:35:25'),
(302, 683, 'black', '2023-08-28-64ec867d8b7c0.png', '2023-08-28 05:35:25', '2023-08-28 05:35:25'),
(310, 684, NULL, '2023-08-28-64ec8a6eeee49.png', '2023-08-28 05:52:14', '2023-08-28 05:52:14'),
(311, 684, NULL, '2023-08-28-64ec8a6ef18a2.png', '2023-08-28 05:52:14', '2023-08-28 05:52:14'),
(312, 684, NULL, '2023-08-28-64ec8a6ef3f98.png', '2023-08-28 05:52:15', '2023-08-28 05:52:15'),
(313, 684, NULL, '2023-08-28-64ec8a6f00cf8.png', '2023-08-28 05:52:15', '2023-08-28 05:52:15'),
(314, 684, NULL, '2023-08-28-64ec8a6f01c01.png', '2023-08-28 05:52:15', '2023-08-28 05:52:15'),
(315, 684, NULL, '2023-08-28-64ec8a6f029a5.png', '2023-08-28 05:52:15', '2023-08-28 05:52:15'),
(316, 684, NULL, '2023-08-28-64ec8a6f03832.png', '2023-08-28 05:52:15', '2023-08-28 05:52:15'),
(327, 700, NULL, '2023-08-28-64ecdc395513d.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(328, 700, NULL, '2023-08-28-64ecdc39569fb.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(329, 700, NULL, '2023-08-28-64ecdc3957ddb.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(330, 700, NULL, '2023-08-28-64ecdc39591d8.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(331, 700, NULL, '2023-08-28-64ecdc395ec96.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(332, 700, NULL, '2023-08-28-64ecdc39636dd.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(333, 700, NULL, '2023-08-28-64ecdc3967182.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(334, 700, NULL, '2023-08-28-64ecdc396a475.png', '2023-08-28 11:41:13', '2023-08-28 11:41:13'),
(343, 699, NULL, '2023-08-28-64ecdf5334d13.png', '2023-08-28 11:54:27', '2023-08-28 11:54:27'),
(344, 699, NULL, '2023-08-28-64ecdf533a6e2.png', '2023-08-28 11:54:27', '2023-08-28 11:54:27'),
(345, 699, NULL, '2023-08-28-64ecdf533bcbc.png', '2023-08-28 11:54:27', '2023-08-28 11:54:27'),
(346, 699, NULL, '2023-08-28-64ecdf533cbc3.png', '2023-08-28 11:54:27', '2023-08-28 11:54:27'),
(347, 699, NULL, '2023-08-28-64ecdf533db32.png', '2023-08-28 11:54:27', '2023-08-28 11:54:27'),
(348, 699, 'white', '2023-08-28-64ecdf533eac2.png', '2023-08-28 11:54:27', '2023-08-28 11:54:27'),
(349, 699, 'black', '2023-08-28-64ecdf534076f.png', '2023-08-28 11:54:27', '2023-08-28 11:54:27'),
(350, 701, NULL, '2023-08-29-64edc2877ea43.png', '2023-08-29 04:03:51', '2023-08-29 04:03:51'),
(351, 702, 'nutmeg', '2023-09-05-64f793e5101ba.jpg', '2023-09-05 14:47:33', '2023-09-05 14:47:33'),
(352, 702, 'olive', '2023-09-05-64f793e512525.jpg', '2023-09-05 14:47:33', '2023-09-05 14:47:33'),
(353, 697, NULL, '2023-09-05-64f79ae32d338.png', '2023-09-05 15:17:23', '2023-09-05 15:17:23'),
(354, 693, NULL, '2023-09-05-64f79b96ebab8.jpg', '2023-09-05 15:20:22', '2023-09-05 15:20:22'),
(357, 689, NULL, '2023-09-11-64fed15c58a37.jpg', '2023-09-11 02:35:40', '2023-09-11 02:35:40'),
(358, 688, NULL, '2023-09-11-64fed1db8f896.jpg', '2023-09-11 02:37:47', '2023-09-11 02:37:47'),
(359, 687, NULL, '2023-09-11-64feecf9eb8a6.jpg', '2023-09-11 04:33:29', '2023-09-11 04:33:29'),
(360, 686, NULL, '2023-09-11-64fef1f8782de.jpg', '2023-09-11 04:54:48', '2023-09-11 04:54:48'),
(361, 685, NULL, '2023-09-11-64fef4d063216.jpg', '2023-09-11 05:06:56', '2023-09-11 05:06:56'),
(362, 685, NULL, '2023-09-11-64ff01ab11866.jpg', '2023-09-11 06:01:47', '2023-09-11 06:01:47'),
(363, 703, NULL, '2023-09-11-64ff038a683ae.jpg', '2023-09-11 06:09:46', '2023-09-11 06:09:46'),
(364, 704, NULL, '2023-09-11-64ff06f449632.jpg', '2023-09-11 06:24:20', '2023-09-11 06:24:20'),
(365, 705, NULL, '2023-09-11-64ff0838630d2.jpg', '2023-09-11 06:29:44', '2023-09-11 06:29:44'),
(366, 691, NULL, '2023-09-11-64ff08bc53228.jpg', '2023-09-11 06:31:56', '2023-09-11 06:31:56'),
(367, 706, NULL, '2023-09-11-64ff09155f1fb.jpg', '2023-09-11 06:33:25', '2023-09-11 06:33:25'),
(368, 707, NULL, '2023-09-11-64ff096d916a8.jpg', '2023-09-11 06:34:53', '2023-09-11 06:34:53'),
(369, 690, NULL, '2023-09-11-64ff0acae73ee.jpg', '2023-09-11 06:40:42', '2023-09-11 06:40:42'),
(370, 687, NULL, '2023-09-11-64ff0b0582899.jpg', '2023-09-11 06:41:41', '2023-09-11 06:41:41'),
(371, 708, NULL, '2023-09-11-64ff0bc53ab13.png', '2023-09-11 06:44:53', '2023-09-11 06:44:53'),
(372, 709, NULL, '2023-09-11-64ff0c12f3f68.png', '2023-09-11 06:46:11', '2023-09-11 06:46:11'),
(373, 710, NULL, '2023-09-11-64ff0c44b36f7.png', '2023-09-11 06:47:00', '2023-09-11 06:47:00'),
(374, 711, NULL, '2023-09-11-64ff0c77101db.png', '2023-09-11 06:47:51', '2023-09-11 06:47:51'),
(375, 712, NULL, '2023-09-11-64ff0ca9aa51e.png', '2023-09-11 06:48:41', '2023-09-11 06:48:41'),
(376, 713, NULL, '2023-09-11-64ff0cd672b91.png', '2023-09-11 06:49:26', '2023-09-11 06:49:26');

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint UNSIGNED 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 `product_size`
--

CREATE TABLE `product_size` (
  `id` bigint UNSIGNED NOT NULL,
  `size_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED 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 `product_sub_category`
--

CREATE TABLE `product_sub_category` (
  `id` bigint UNSIGNED NOT NULL,
  `sub_category_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_sub_category`
--

INSERT INTO `product_sub_category` (`id`, `sub_category_id`, `product_id`, `created_at`, `updated_at`) VALUES
(297, 55, 330, NULL, NULL),
(298, 55, 331, NULL, NULL),
(299, 55, 332, NULL, NULL),
(300, 55, 333, NULL, NULL),
(301, 55, 334, NULL, NULL),
(302, 55, 335, NULL, NULL),
(303, 55, 336, NULL, NULL),
(304, 55, 337, NULL, NULL),
(305, 55, 338, NULL, NULL),
(306, 55, 339, NULL, NULL),
(307, 55, 340, NULL, NULL),
(308, 55, 341, NULL, NULL),
(309, 55, 342, NULL, NULL),
(310, 55, 343, NULL, NULL),
(311, 55, 344, NULL, NULL),
(312, 55, 345, NULL, NULL),
(313, 55, 346, NULL, NULL),
(314, 55, 347, NULL, NULL),
(315, 55, 348, NULL, NULL),
(316, 55, 349, NULL, NULL),
(317, 55, 350, NULL, NULL),
(318, 55, 351, NULL, NULL),
(319, 55, 352, NULL, NULL),
(320, 55, 353, NULL, NULL),
(321, 55, 354, NULL, NULL),
(322, 55, 355, NULL, NULL),
(323, 55, 356, NULL, NULL),
(324, 55, 357, NULL, NULL),
(325, 55, 358, NULL, NULL),
(326, 55, 359, NULL, NULL),
(327, 75, 360, NULL, NULL),
(328, 75, 361, NULL, NULL),
(329, 75, 362, NULL, NULL),
(330, 75, 363, NULL, NULL),
(331, 75, 364, NULL, NULL),
(332, 75, 365, NULL, NULL),
(333, 75, 366, NULL, NULL),
(334, 75, 367, NULL, NULL),
(335, 75, 368, NULL, NULL),
(336, 75, 369, NULL, NULL),
(337, 75, 370, NULL, NULL),
(338, 75, 371, NULL, NULL),
(339, 75, 372, NULL, NULL),
(340, 75, 373, NULL, NULL),
(341, 75, 374, NULL, NULL),
(342, 75, 375, NULL, NULL),
(343, 75, 376, NULL, NULL),
(344, 75, 377, NULL, NULL),
(345, 75, 378, NULL, NULL),
(346, 75, 379, NULL, NULL),
(347, 75, 380, NULL, NULL),
(348, 75, 381, NULL, NULL),
(349, 75, 382, NULL, NULL),
(350, 75, 383, NULL, NULL),
(351, 75, 384, NULL, NULL),
(352, 75, 385, NULL, NULL),
(353, 75, 386, NULL, NULL),
(354, 75, 387, NULL, NULL),
(355, 75, 388, NULL, NULL),
(356, 75, 389, NULL, NULL),
(357, 75, 390, NULL, NULL),
(358, 75, 391, NULL, NULL),
(359, 75, 392, NULL, NULL),
(360, 75, 393, NULL, NULL),
(361, 75, 394, NULL, NULL),
(362, 75, 395, NULL, NULL),
(363, 75, 396, NULL, NULL),
(364, 75, 397, NULL, NULL),
(365, 75, 398, NULL, NULL),
(366, 75, 399, NULL, NULL),
(428, 24, 476, NULL, NULL),
(429, 24, 477, NULL, NULL),
(430, 24, 478, NULL, NULL),
(431, 24, 479, NULL, NULL),
(432, 24, 480, NULL, NULL),
(433, 24, 481, NULL, NULL),
(434, 24, 482, NULL, NULL),
(435, 24, 483, NULL, NULL),
(436, 24, 484, NULL, NULL),
(437, 24, 485, NULL, NULL),
(438, 24, 486, NULL, NULL),
(439, 24, 487, NULL, NULL),
(440, 24, 488, NULL, NULL),
(441, 24, 489, NULL, NULL),
(442, 24, 490, NULL, NULL),
(443, 24, 491, NULL, NULL),
(444, 24, 492, NULL, NULL),
(445, 24, 493, NULL, NULL),
(446, 24, 494, NULL, NULL),
(447, 24, 495, NULL, NULL),
(448, 24, 496, NULL, NULL),
(449, 24, 497, NULL, NULL),
(450, 24, 498, NULL, NULL),
(451, 24, 499, NULL, NULL),
(545, 24, 594, NULL, NULL),
(546, 24, 595, NULL, NULL),
(547, 24, 596, NULL, NULL),
(548, 24, 597, NULL, NULL),
(549, 24, 598, NULL, NULL),
(550, 24, 599, NULL, NULL),
(808, 71, 1056, NULL, NULL),
(809, 24, 600, NULL, NULL),
(810, 9, 601, NULL, NULL),
(811, 9, 602, NULL, NULL),
(812, 9, 603, NULL, NULL),
(813, 9, 604, NULL, NULL),
(814, 9, 605, NULL, NULL),
(815, 9, 607, NULL, NULL),
(816, 9, 608, NULL, NULL),
(818, 55, 610, NULL, NULL),
(819, 72, 611, NULL, NULL),
(823, 24, 612, NULL, NULL),
(824, 24, 614, NULL, NULL),
(825, 24, 616, NULL, NULL),
(827, 9, 609, NULL, NULL),
(828, 9, 617, NULL, NULL),
(829, 9, 618, NULL, NULL),
(830, 97, 620, NULL, NULL),
(831, 98, 621, NULL, NULL),
(833, 99, 622, NULL, NULL),
(835, 98, 623, NULL, NULL),
(837, 15, 624, NULL, NULL),
(838, 15, 625, NULL, NULL),
(839, 15, 627, NULL, NULL),
(840, 15, 628, NULL, NULL),
(841, 15, 629, NULL, NULL),
(842, 3, 630, NULL, NULL),
(847, 98, 634, NULL, NULL),
(849, 98, 633, NULL, NULL),
(850, 98, 632, NULL, NULL),
(851, 98, 631, NULL, NULL),
(852, 102, 635, NULL, NULL),
(854, 103, 636, NULL, NULL),
(855, 104, 637, NULL, NULL),
(857, 105, 638, NULL, NULL),
(858, 105, 639, NULL, NULL),
(859, 105, 640, NULL, NULL),
(860, 105, 641, NULL, NULL),
(861, 106, 642, NULL, NULL),
(862, 106, 643, NULL, NULL),
(863, 105, 644, NULL, NULL),
(864, 105, 645, NULL, NULL),
(865, 105, 646, NULL, NULL),
(866, 105, 647, NULL, NULL),
(867, 105, 648, NULL, NULL),
(868, 105, 649, NULL, NULL),
(869, 105, 650, NULL, NULL),
(870, 102, 651, NULL, NULL),
(871, 102, 652, NULL, NULL),
(872, 102, 653, NULL, NULL),
(882, 105, 663, NULL, NULL),
(883, 2, 662, NULL, NULL),
(884, 2, 661, NULL, NULL),
(885, 3, 660, NULL, NULL),
(887, 2, 658, NULL, NULL),
(888, 2, 657, NULL, NULL),
(889, 14, 656, NULL, NULL),
(890, 14, 655, NULL, NULL),
(891, 11, 654, NULL, NULL),
(892, 107, 672, NULL, NULL),
(893, 107, 673, NULL, NULL),
(894, 109, 659, NULL, NULL),
(895, 2, 674, NULL, NULL),
(896, 113, 682, NULL, NULL),
(897, 113, 683, NULL, NULL),
(898, 105, 684, NULL, NULL),
(899, 114, 686, NULL, NULL),
(900, 113, 698, NULL, NULL),
(901, 115, 699, NULL, NULL),
(902, 115, 700, NULL, NULL),
(904, 116, 702, NULL, NULL);

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

--
-- Table structure for table `product_tag`
--

CREATE TABLE `product_tag` (
  `id` bigint UNSIGNED NOT NULL,
  `tag_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_tag`
--

INSERT INTO `product_tag` (`id`, `tag_id`, `product_id`, `created_at`, `updated_at`) VALUES
(1, 4, 815, NULL, NULL),
(2, 6, 821, NULL, NULL),
(3, 6, 823, NULL, NULL),
(4, 6, 824, NULL, NULL),
(5, 7, 952, NULL, NULL),
(6, 7, 953, NULL, NULL),
(7, 7, 958, NULL, NULL),
(8, 3, 614, NULL, NULL),
(9, 3, 615, NULL, NULL),
(10, 8, 365, NULL, NULL),
(11, 8, 619, NULL, NULL),
(12, 10, 620, NULL, NULL),
(13, 11, 621, NULL, NULL),
(14, 12, 621, NULL, NULL),
(15, 12, 622, NULL, NULL),
(16, 12, 623, NULL, NULL),
(17, 11, 623, NULL, NULL),
(18, 13, 623, NULL, NULL),
(19, 14, 624, NULL, NULL),
(20, 15, 624, NULL, NULL),
(21, 15, 625, NULL, NULL),
(22, 14, 625, NULL, NULL),
(23, 15, 626, NULL, NULL),
(24, 14, 626, NULL, NULL),
(25, 15, 627, NULL, NULL),
(26, 14, 627, NULL, NULL),
(27, 15, 628, NULL, NULL),
(28, 14, 628, NULL, NULL),
(29, 15, 629, NULL, NULL),
(30, 14, 629, NULL, NULL),
(31, 16, 630, NULL, NULL),
(32, 17, 630, NULL, NULL),
(33, 13, 631, NULL, NULL),
(34, 12, 631, NULL, NULL),
(35, 11, 631, NULL, NULL),
(36, 13, 632, NULL, NULL),
(37, 12, 632, NULL, NULL),
(38, 11, 632, NULL, NULL),
(39, 13, 633, NULL, NULL),
(40, 12, 633, NULL, NULL),
(41, 11, 633, NULL, NULL),
(42, 13, 634, NULL, NULL),
(43, 12, 634, NULL, NULL),
(44, 11, 634, NULL, NULL),
(45, 13, 621, NULL, NULL),
(46, 18, 635, NULL, NULL),
(47, 19, 635, NULL, NULL),
(74, 43, 642, NULL, NULL),
(75, 44, 642, NULL, NULL),
(76, 45, 642, NULL, NULL),
(77, 46, 642, NULL, NULL),
(78, 47, 642, NULL, NULL),
(79, 46, 643, NULL, NULL),
(80, 48, 643, NULL, NULL),
(81, 49, 643, NULL, NULL),
(82, 50, 643, NULL, NULL),
(83, 51, 643, NULL, NULL),
(84, 29, 644, NULL, NULL),
(85, 28, 644, NULL, NULL),
(86, 52, 644, NULL, NULL),
(87, 53, 644, NULL, NULL),
(88, 53, 645, NULL, NULL),
(89, 52, 645, NULL, NULL),
(90, 29, 645, NULL, NULL),
(91, 28, 645, NULL, NULL),
(92, 38, 646, NULL, NULL),
(93, 37, 646, NULL, NULL),
(94, 54, 646, NULL, NULL),
(95, 55, 646, NULL, NULL),
(96, 38, 647, NULL, NULL),
(97, 37, 647, NULL, NULL),
(98, 56, 647, NULL, NULL),
(99, 57, 647, NULL, NULL),
(100, 58, 647, NULL, NULL),
(101, 59, 647, NULL, NULL),
(102, 38, 648, NULL, NULL),
(103, 37, 648, NULL, NULL),
(104, 60, 648, NULL, NULL),
(105, 61, 648, NULL, NULL),
(106, 62, 648, NULL, NULL),
(107, 38, 649, NULL, NULL),
(108, 37, 649, NULL, NULL),
(109, 63, 649, NULL, NULL),
(110, 64, 649, NULL, NULL),
(111, 38, 650, NULL, NULL),
(112, 37, 650, NULL, NULL),
(113, 65, 650, NULL, NULL),
(114, 66, 650, NULL, NULL),
(197, 102, 663, NULL, NULL),
(198, 101, 663, NULL, NULL),
(199, 100, 663, NULL, NULL),
(200, 99, 663, NULL, NULL),
(201, 98, 663, NULL, NULL),
(202, 36, 663, NULL, NULL),
(203, 29, 663, NULL, NULL),
(204, 28, 663, NULL, NULL),
(205, 103, 663, NULL, NULL),
(206, 60, 659, NULL, NULL),
(207, 103, 682, NULL, NULL);

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

--
-- Table structure for table `product_user`
--

CREATE TABLE `product_user` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED 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 `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `order_id` int DEFAULT NULL,
  `rating` int NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file5` varchar(255) CHARACTER SET utf8mb4 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 `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 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 `settings`
--

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `settings`
--

INSERT INTO `settings` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES
(25, 'copy_right_text', '© Lems Copyright', '2021-04-30 05:44:50', '2024-01-14 06:52:56'),
(26, 'logo', 'logo.png', '2021-04-30 05:44:50', '2023-09-05 14:16:50'),
(27, 'auth_logo', 'auth_logo.jpg', '2021-04-30 05:44:50', '2023-09-05 11:36:28'),
(28, 'favicon', 'favicon.jpg', '2021-04-30 05:44:50', '2023-09-05 11:36:29'),
(31, 'email', 'contact@finvasoft.com', NULL, '2023-09-05 11:43:45'),
(32, 'shop_commission', '0', NULL, '2023-08-22 22:35:33'),
(33, 'bkash', '01925015919', NULL, '2023-09-05 11:43:45'),
(34, 'nagad', '01925015919', NULL, '2023-09-05 11:43:45'),
(35, 'rocket', '01925015919', NULL, '2023-09-05 11:43:45'),
(36, 'bank_name', 'Brac Bank', NULL, '2023-08-22 22:35:33'),
(37, 'holder_name', 'Finva Soft', NULL, '2023-09-05 11:43:45'),
(38, 'bank_account', '101010', NULL, '2023-09-05 11:43:45'),
(39, 'branch_name', 'Mirpur 6, Dhaka', NULL, '2023-09-05 11:43:45'),
(40, 'routing', '060820738', NULL, '2023-08-22 22:35:33'),
(41, 'footer_description', 'In today\'s digital landscape, multivendor ecommerce platforms are transforming the way we shop and do business. Let\'s delve into LEMS, an innovative solution that\'s reshaping the ecommerce game.', NULL, '2023-09-05 11:43:45'),
(42, 'facebook', 'https://www.facebook.com/finvasoft', NULL, '2023-09-05 11:43:45'),
(43, 'whatsapp', '01925015919', NULL, '2024-03-05 01:28:50'),
(44, 'twitter', NULL, NULL, '2023-05-13 11:15:19'),
(45, 'linkedin', NULL, NULL, '2023-05-13 11:15:19'),
(46, 'instagram', NULL, NULL, '2023-05-13 11:15:19'),
(47, 'messanger', NULL, NULL, '2022-04-20 00:48:50'),
(48, 'youtube', NULL, NULL, '2023-09-05 11:43:45'),
(49, 'shipping_charge', '80', NULL, '2024-03-25 03:54:57'),
(50, 'shipping_charge_out_of_range', '130', NULL, '2023-08-22 22:35:33'),
(51, 'is_point', '0', NULL, '2023-08-22 22:35:33'),
(52, 'Default_Point', '10', NULL, '2023-04-14 10:10:15'),
(53, 'Point_rate', '.1', NULL, '2023-04-12 12:58:13'),
(54, 'fb_pixel', NULL, NULL, '2024-03-05 01:27:23'),
(59, 'mega_cat', '[\"4\",\"18\",\"19\",\"21\"]', NULL, '2023-09-11 07:31:41'),
(60, 'sub_cat', '[\"102\",\"103\"]', NULL, '2023-09-05 15:23:03'),
(61, 'mini_cat', '[\"193\"]', NULL, '2023-09-11 06:43:09'),
(62, 'extra_cat', '[\"51\"]', NULL, '2023-09-05 15:23:03'),
(64, 'meta_img', 'dd', NULL, NULL),
(65, 'g_bkash', 'true', '2023-02-28 11:00:52', '2023-02-28 11:00:52'),
(66, 'g_nagad', 'true', '2023-02-28 11:00:52', '2023-02-28 11:14:16'),
(67, 'g_rocket', 'true', '2023-02-28 11:00:52', '2024-03-25 03:54:57'),
(68, 'g_bank', 'true', '2023-02-28 11:00:52', '2023-02-28 11:00:52'),
(69, 'g_wallate', 'false', '2023-02-28 11:00:52', '2023-05-14 12:49:31'),
(70, 'g_cod', 'true', '2023-02-28 11:00:52', '2024-03-05 01:25:00'),
(71, 'g_aamar', 'false', '2023-02-28 11:00:52', '2023-02-28 11:14:16'),
(72, 'g_uddok', 'true', '2023-02-28 11:00:52', '2024-02-02 11:22:38'),
(73, 'uapi', '982d381360a69d419689740d9f2e26ce36fb7a50', '2023-02-28 11:09:19', '2023-06-22 13:55:23'),
(74, 'astore', 'aamarpaytest', '2023-02-28 11:09:19', '2023-02-28 11:11:09'),
(75, 'akey', 'dbb74894e82415a2f7ff0ec3a97e4183', '2023-02-28 11:09:19', '2023-02-28 11:11:09'),
(76, 'amode', '1', '2023-02-28 11:23:07', '2023-02-28 11:23:49'),
(77, 'umode', '1', '2023-02-28 11:23:07', '2024-03-05 01:25:04'),
(78, 'placeholder_one', 'Search by product name', NULL, '2023-03-10 04:38:56'),
(79, 'placeholder_two', 'Search by Vendor', NULL, '2023-03-10 04:38:56'),
(80, 'placeholder_three', 'Search by category', NULL, '2023-03-10 04:38:56'),
(81, 'placeholder_four', 'Search by product', NULL, '2023-03-10 04:38:56'),
(82, 'ubase', 'sandbox.uddoktapay.com', '2023-03-10 04:36:30', '2023-06-22 13:56:45'),
(83, 'min_rec', '50', NULL, '2023-04-13 07:53:07'),
(84, 'min_with', '100', NULL, '2023-04-13 07:53:07'),
(85, 'header_code', NULL, '2024-01-14 01:27:39', '2024-03-05 01:27:23'),
(92, 'mail_config', '0', '2024-01-21 00:49:58', '2024-01-21 00:49:58'),
(93, 'MAIL_DRIVER', 'smtp', '2024-01-21 00:49:58', '2024-01-21 00:49:58'),
(94, 'MAIL_HOST', NULL, '2024-01-21 00:49:58', '2024-04-04 22:08:01'),
(95, 'MAIL_PORT', NULL, '2024-01-21 00:49:58', '2024-04-04 22:08:01'),
(96, 'MAIL_USERNAME', NULL, '2024-01-21 00:49:58', '2024-04-04 22:08:01'),
(97, 'MAIL_PASSWORD', NULL, '2024-01-21 00:49:58', '2024-04-04 22:08:01'),
(98, 'MAIL_ENCRYPTION', 'ssl', '2024-01-21 00:49:58', '2024-01-21 01:31:25'),
(99, 'MAIL_FROM_ADDRESS', NULL, '2024-01-21 00:49:58', '2024-04-04 22:08:01'),
(100, 'MAIL_FROM_NAME', NULL, '2024-01-21 00:49:58', '2024-04-04 22:08:01'),
(101, 'SMS_API_URL', NULL, '2024-01-21 02:18:50', '2024-03-05 01:25:58'),
(102, 'SMS_API_KEY', NULL, '2024-01-21 02:18:50', '2024-03-05 01:25:58'),
(103, 'SMS_API_SENDER_ID', NULL, '2024-01-21 02:18:50', '2024-03-05 01:25:58'),
(104, 'regVerify', 'email', '2024-01-21 03:13:40', '2024-02-03 05:48:32'),
(105, 'recovrAC', 'email', '2024-01-21 03:13:40', '2024-04-04 22:08:14'),
(106, 'SITE_INFO_ADDRESS', 'Mirpur, Dhaka, Bangladesh', '2024-01-21 06:02:39', '2024-03-05 01:28:28'),
(107, 'SITE_INFO_PHONE', '+8801925015919', '2024-01-21 06:02:39', '2024-03-05 01:28:28'),
(108, 'SITE_INFO_SUPPORT_MAIL', 'info@finvasoft.com', '2024-01-21 06:02:39', '2024-03-05 01:28:28'),
(109, 'MAIN_MENU_STYLE', '1', '2024-01-23 23:56:30', '2024-02-05 22:30:00'),
(110, 'SLIDER_LAYOUT', '1', '2024-01-23 23:56:30', '2024-01-24 23:37:07'),
(111, 'SELLER_STATUS', '0', '2024-01-24 04:03:05', '2024-04-04 22:08:37'),
(112, 'TOP_CAT_STATUS', '1', '2024-01-24 04:11:40', '2024-01-24 23:37:07'),
(113, 'LATEST_PRODUCT_STATUS', '1', '2024-01-24 05:14:03', '2024-01-24 23:37:07'),
(114, 'FEATURE_PRODUCT_STATUS', '1', '2024-01-24 05:14:03', '2024-01-24 23:37:07'),
(115, 'HERO_SLIDER_1', '1', '2024-01-24 05:29:56', '2024-04-04 22:27:36'),
(116, 'HERO_SLIDER_2', '1', '2024-01-24 05:29:56', '2024-01-24 23:37:07'),
(117, 'SLIDER_LAYOUT_STATUS', '1', '2024-01-24 23:21:31', '2024-01-24 23:37:07'),
(118, 'CLASSIFIED_SELL_STATUS', '1', '2024-01-24 23:21:31', '2024-01-24 23:37:07'),
(119, 'SUB_CAT_PRODUCT_STATUS', '1', '2024-01-24 23:21:31', '2024-01-24 23:37:07'),
(120, 'MINI_CAT_PRODUCT_STATUS', '1', '2024-01-24 23:21:31', '2024-01-24 23:37:07'),
(121, 'EXTRA_CAT_PRODUCT_STATUS', '1', '2024-01-24 23:21:31', '2024-01-24 23:37:07'),
(122, 'BRAND_STATUS', '1', '2024-01-24 23:21:32', '2024-01-24 23:37:07'),
(123, 'CATEGORY_SMALL_SUMMERY', '1', '2024-01-24 23:21:32', '2024-01-24 23:37:07'),
(124, 'NEWS_LETTER_STATUS', '1', '2024-01-24 23:21:32', '2024-01-24 23:37:07'),
(125, 'MEGA_CAT_PRODUCT_STATUS', '1', '2024-01-24 23:32:47', '2024-01-24 23:37:07'),
(128, 'GUEST_CHECKOUT', '1', '2024-01-25 06:01:42', '2024-01-25 06:01:54'),
(129, 'NOTICE_STATUS', '0', '2024-01-30 00:15:52', '2024-01-30 00:23:48'),
(130, 'CUSTOM_NOTICE', 'Sell 200', '2024-01-30 00:15:52', '2024-01-30 00:21:47'),
(131, 'FLOAT_LIVE_CHAT', '0', '2024-02-04 00:56:51', '2024-02-04 01:18:18'),
(132, 'TOP_HEADER_STYLE', '2', '2024-02-05 09:53:51', '2024-04-04 00:43:32'),
(133, 'CHECKOUT_TYPE', '0', '2024-03-05 01:24:29', '2024-03-05 01:24:29'),
(134, 'shipping_free_above', '10000', '2024-03-05 01:24:29', '2024-03-05 01:24:29'),
(135, 'shipping_range_inside', 'Dhaka', '2024-03-05 01:24:29', '2024-03-05 01:24:29'),
(136, 'body_code', NULL, '2024-03-05 01:27:23', '2024-03-05 01:27:23'),
(137, 'FOOTER_COL_4_HTML', '<b>Payment Support: Bkash, Roacket, Nagad</b>', '2024-03-05 01:27:23', '2024-03-05 01:27:23'),
(138, 'COUNTRY_SERVE', 'Bangladesh', '2024-03-25 04:27:50', '2024-03-25 04:27:50'),
(139, 'CURRENCY_CODE', 'BDT', '2024-03-25 04:27:50', '2024-03-25 04:27:50'),
(140, 'CURRENCY_CODE_MIN', 'Tk', '2024-03-25 04:27:50', '2024-03-25 04:27:50'),
(141, 'CURRENCY_ICON', '৳', '2024-03-25 04:27:50', '2024-03-25 04:27:50'),
(142, 'phone_min_dgt', '11', '2024-03-25 04:27:50', '2024-03-25 04:35:05'),
(143, 'phone_max_dgt', '11', '2024-03-25 04:27:50', '2024-03-25 04:35:05'),
(144, 'STYLE_3_TOP_MENU', NULL, '2024-04-04 00:43:32', '2024-04-04 00:43:32'),
(145, 'STYLE_3_TOP_MENU_BG_COLOR', NULL, '2024-04-04 00:43:32', '2024-04-04 00:43:32'),
(146, 'STYLE_3_TOP_MENU_LINK_COLOR', NULL, '2024-04-04 00:43:32', '2024-04-04 00:43:32'),
(147, 'STYLE_3_TOP_MENU_LINK_HOVER_COLOR', NULL, '2024-04-04 00:43:32', '2024-04-04 00:43:32'),
(148, 'STYLE_3_HEADER_SEARCH_INPUT_BAR_WIDHT', NULL, '2024-04-04 00:43:32', '2024-04-04 00:43:32'),
(149, 'HERO_SLIDER_1_TEXT', NULL, '2024-04-04 00:43:32', '2024-04-04 00:43:32'),
(150, 'TOP_CAT', NULL, '2024-04-04 00:43:32', '2024-04-04 00:43:32');

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

--
-- Table structure for table `shop_infos`
--

CREATE TABLE `shop_infos` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `is_admin` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gmail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `selfi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `holder_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `routing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `commission` decimal(10,0) DEFAULT NULL,
  `nid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nidback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `trade` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nogod` int DEFAULT NULL,
  `rocket` int DEFAULT NULL,
  `bkash` int DEFAULT NULL,
  `mobile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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_infos`
--

INSERT INTO `shop_infos` (`id`, `user_id`, `is_admin`, `name`, `gmail`, `selfi`, `slug`, `address`, `url`, `bank_account`, `bank_name`, `holder_name`, `branch_name`, `routing`, `profile`, `cover_photo`, `description`, `commission`, `nid`, `nidback`, `trade`, `nogod`, `rocket`, `bkash`, `mobile`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 'Finva Soft', '', NULL, '192792713879207', 'Mirpur 6, Dhaka', 'http://finvasoft.com/', '0', 'Brac Bank', 'Finva Soft', 'Mirpur 6, Dhaka', '01548', '2023-09-05-64f771292c2e1.jpg', '2023-09-05-64f771292c37b.jpg', 'এখানে ডেসক্রিপশন আপডেট করতে হবে', NULL, NULL, NULL, NULL, 0, 0, 0, NULL, '2022-02-02 08:32:44', '2023-09-05 12:19:21'),
(20, 286, 0, 'Vendor shop', 'vendor@gmail.com', NULL, '331182978833678', 'Mirpur 6, Dhaka', 'facebook.com/vendor', 'Vendor', 'DBL', 'Vendor', 'Mirpur 6, Dhaka', '1245', '2023-09-11-64ff19a2486c7.png', '2023-09-11-64ff19a248796.jpg', 'Vendor', NULL, '2023-09-11-64ff19a24885e.jpg', NULL, '2023-09-11-64ff19a2487ff.jpg', NULL, NULL, NULL, NULL, '2023-09-11 07:44:02', '2023-09-11 07:44:02');

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

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

CREATE TABLE `sizes` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) 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 `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `is_feature` int NOT NULL DEFAULT '0',
  `is_pop` int NOT NULL DEFAULT '0',
  `is_sub` int 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`, `image`, `url`, `status`, `is_feature`, `is_pop`, `is_sub`, `created_at`, `updated_at`) VALUES
(10, '2023-05-13-645fc89eb6465.jpg', 'https://ecommerce.finvasoft.com', 1, 1, 0, 0, '2022-03-11 13:06:15', '2023-09-05 15:01:59'),
(11, '2023-05-13-645fc895c3f78.jpg', 'https://ecommerce.finvasoft.com', 1, 1, 0, 0, '2022-03-11 13:07:31', '2023-09-05 15:01:56'),
(12, '2023-05-13-645fc88a89bda.jpg', 'https://ecommerce.finvasoft.com', 1, 1, 0, 0, '2022-04-14 07:23:19', '2023-09-05 15:01:52'),
(14, '2023-03-27-64212fa727226.jpg', 'https://ecommerce.finvasoft.com', 0, 0, 0, 0, '2022-04-14 08:29:15', '2023-09-05 15:01:49'),
(16, '2023-03-27-64212e1710415.jpg', 'https://ecommerce.finvasoft.com', 0, 0, 0, 0, '2022-04-20 04:20:20', '2023-09-05 15:01:46'),
(20, '2023-03-27-6421303ae5c9b.jpg', 'https://ecommerce.finvasoft.com', 0, 0, 0, 0, '2023-02-24 14:15:43', '2023-09-05 15:01:42'),
(21, '2023-05-18-64668b854ed7b.jpg', 'https://ecommerce.finvasoft.com', 1, 0, 0, 1, '2023-03-15 01:58:16', '2023-09-05 15:01:39'),
(23, '2023-05-18-64668dc463aee.png', 'https://ecommerce.finvasoft.com', 1, 0, 0, 1, '2023-03-15 01:58:33', '2023-09-05 15:01:37'),
(24, '2023-06-22-6494aadd0939a.jpg', 'https://ecommerce.finvasoft.com', 1, 0, 0, 1, '2023-03-15 01:58:43', '2023-09-05 15:01:33'),
(25, '2023-05-18-64668a4cc1eac.jpg', 'https://ecommerce.finvasoft.com', 1, 0, 0, 1, '2023-03-15 01:58:53', '2023-09-05 15:01:30'),
(26, '2023-05-18-64668a470d64a.jpg', 'https://ecommerce.finvasoft.com', 1, 1, 0, 1, '2023-05-05 10:18:42', '2023-09-05 15:01:13'),
(33, '2023-05-13-645fc1d421e52.jpg', 'https://ecommerce.finvasoft.com', 1, 0, 0, 0, '2023-05-07 00:37:44', '2023-09-05 15:00:17'),
(34, '2023-05-13-645fc1c8c09c2.jpg', 'https://ecommerce.finvasoft.com', 1, 0, 0, 0, '2023-05-07 00:38:48', '2023-09-05 15:00:11'),
(35, '2023-05-13-645fc1ad01df8.jpg', 'https://ecommerce.finvasoft.com', 1, 0, 0, 0, '2023-05-07 00:39:12', '2023-09-05 15:00:06');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 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 `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `email`, `created_at`, `updated_at`) VALUES
(1, 'sohel@finvasoft.com', '2023-09-05 15:20:46', '2023-09-05 15:20:46');

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

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

CREATE TABLE `sub_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default.png',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `is_feature` int 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 `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `category_id`, `name`, `slug`, `cover_photo`, `status`, `is_feature`, `created_at`, `updated_at`) VALUES
(102, 4, 'Bluetooth Speaker', 'bluetooth-speaker', '2023-05-09-645a48125ed74.png', 1, 1, '2023-05-09 07:18:10', '2023-09-05 14:15:32'),
(103, 4, 'Microphone', 'microphone', '2023-05-09-645a950a90d2e.png', 1, 1, '2023-05-09 12:46:34', '2023-09-05 14:15:19'),
(104, 4, 'Chargers', 'chargers', '2023-05-10-645b7384e7ca0.png', 1, 0, '2023-05-10 04:35:48', '2023-09-05 14:13:02'),
(105, 4, 'Headphone', 'headphone', '2023-05-10-645b97902b399.png', 1, 1, '2023-05-10 07:09:36', '2023-09-05 14:15:12'),
(106, 4, 'Mobile/Tablet Stand', 'mobiletablet-stand', '2023-05-10-645bd451c76d5.png', 1, 0, '2023-05-10 11:28:49', '2023-09-05 14:13:02'),
(107, 6, 'Fan', 'fan', '2023-05-13-645f5ddf74fd9.png', 1, 0, '2023-05-13 01:57:44', '2023-05-13 03:52:31'),
(113, 19, 'Apple  Watch Clone', 'apple-watch-clone', '2023-08-23-64e59b5c47b10.png', 1, 1, '2023-08-22 23:38:36', '2023-09-05 14:15:55'),
(116, 4, 'Phone Back Cover', 'phone-back-cover', 'default.png', 1, 0, '2023-09-05 14:52:20', '2023-09-05 14:52:20'),
(117, 26, 'Common bag', 'common-bag', 'default.png', 1, 1, '2024-04-04 22:15:26', '2024-04-04 22:15:26');

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `tags`
--

INSERT INTO `tags` (`id`, `name`, `slug`, `status`, `description`, `created_at`, `updated_at`) VALUES
(3, 'Dettol', 'dettol', 1, 'null', '2022-04-17 12:28:08', '2022-04-17 12:28:08'),
(4, 'RFL', 'rfl', 1, 'null', '2022-04-18 03:24:08', '2022-04-18 03:24:08'),
(5, 'Pepsodent', 'pepsodent', 1, 'null', '2022-04-18 03:31:43', '2022-04-18 03:31:43'),
(6, 'Books', 'books', 1, 'null', '2022-04-18 03:55:45', '2022-04-18 03:55:45'),
(7, '19 April', '19-april', 1, 'null', '2022-04-18 13:47:39', '2022-04-18 13:49:09'),
(8, 'Best', 'best', 1, 's', '2022-05-07 12:35:01', '2022-05-07 12:35:01'),
(9, 'home', 'home', 1, 'null', '2023-04-05 06:08:44', '2023-04-05 06:08:44'),
(10, 'school bag', 'school-bag', 1, 'null', '2023-05-07 04:42:28', '2023-05-07 04:42:28'),
(11, 'Sharee', 'sharee', 1, 'null', '2023-05-07 06:47:34', '2023-05-07 06:47:34'),
(12, 'Panjabi', 'panjabi', 1, 'null', '2023-05-07 06:47:50', '2023-05-07 06:47:50'),
(13, 'Couple Dress', 'couple-dress', 1, 'null', '2023-05-07 11:58:43', '2023-05-07 11:58:43'),
(14, 'Women fashion', 'women-fashion', 1, 'null', '2023-05-07 12:27:17', '2023-05-07 12:27:17'),
(15, 'Kaftan', 'kaftan', 1, 'null', '2023-05-07 12:27:24', '2023-05-07 12:27:24'),
(16, 'Men\'s Fashion', 'mens-fashion', 1, 'null', '2023-05-08 05:40:13', '2023-05-08 05:40:13'),
(17, 'polo Shirt', 'polo-shirt', 1, 'null', '2023-05-08 05:40:27', '2023-05-08 05:40:27'),
(18, 'Bluetooth Speaker', 'bluetooth-speaker', 1, 'null', '2023-05-09 11:36:06', '2023-05-09 11:36:06'),
(19, 'Speaker', 'speaker', 1, 'null', '2023-05-09 11:36:18', '2023-05-09 11:36:18'),
(20, 'microphone', 'microphone', 1, 'null', '2023-05-09 12:13:20', '2023-05-09 12:13:20'),
(21, 'K8 Price in Bangladesh', 'k8-price-in-bangladesh', 1, 'null', '2023-05-09 12:13:43', '2023-05-09 12:13:43'),
(22, 'k8 wireless microphone', 'k8-wireless-microphone', 1, 'null', '2023-05-09 12:14:11', '2023-05-09 12:14:11'),
(23, 'wireless microphone price in bangladesh', 'wireless-microphone-price-in-bangladesh', 1, 'null', '2023-05-09 12:14:31', '2023-05-09 12:14:31'),
(24, 'oneplus charger price in bangladesh', 'oneplus-charger-price-in-bangladesh', 1, 'null', '2023-05-10 05:10:32', '2023-05-10 05:10:32'),
(25, 'mobile charger', 'mobile-charger', 1, 'null', '2023-05-10 05:11:04', '2023-05-10 05:11:04'),
(26, 'oneplus 65w charger price in bangladesh', 'oneplus-65w-charger-price-in-bangladesh', 1, 'null', '2023-05-10 05:11:33', '2023-05-10 05:11:33'),
(27, 'oneplus 30w charger price in bangladesh', 'oneplus-30w-charger-price-in-bangladesh', 1, 'null', '2023-05-10 05:11:56', '2023-05-10 05:11:56'),
(28, 'neckband', 'neckband', 1, 'null', '2023-05-10 07:18:22', '2023-05-10 07:18:22'),
(29, 'Neckband price in Bangladesh', 'neckband-price-in-bangladesh', 1, 'null', '2023-05-10 07:18:42', '2023-05-10 07:18:42'),
(30, 'Realme neckband price in Bangladesh', 'realme-neckband-price-in-bangladesh', 1, 'null', '2023-05-10 07:19:17', '2023-05-10 07:19:17'),
(31, 'Realme neckband price', 'realme-neckband-price', 1, 'null', '2023-05-10 07:19:20', '2023-05-10 07:19:20'),
(32, 'Oneplus neckband', 'oneplus-neckband', 1, 'null', '2023-05-10 07:30:29', '2023-05-10 07:30:29'),
(33, 'Oneplus neckband price', 'oneplus-neckband-price', 1, 'null', '2023-05-10 07:30:39', '2023-05-10 07:30:39'),
(34, 'Oneplus neckband price in bangladesh', 'oneplus-neckband-price-in-bangladesh', 1, 'null', '2023-05-10 07:30:52', '2023-05-10 07:30:52'),
(35, 'headphone', 'headphone', 1, 'null', '2023-05-10 09:25:59', '2023-05-10 09:25:59'),
(36, 'Bluetooth headphone', 'bluetooth-headphone', 1, 'null', '2023-05-10 09:26:11', '2023-05-10 09:26:11'),
(37, 'tws', 'tws', 1, 'null', '2023-05-10 09:26:17', '2023-05-10 09:26:17'),
(38, 'tws price in bangladesh', 'tws-price-in-bangladesh', 1, 'null', '2023-05-10 09:26:28', '2023-05-10 09:26:28'),
(39, 'm10 tws', 'm10-tws', 1, 'null', '2023-05-10 09:26:36', '2023-05-10 09:26:36'),
(40, 'remax 595 earphone price', 'remax-595-earphone-price', 1, 'null', '2023-05-10 10:17:16', '2023-05-10 10:17:16'),
(41, 'Remax earphone', 'remax-earphone', 1, 'null', '2023-05-10 10:17:27', '2023-05-10 10:17:27'),
(42, 'Remax earphone price in Bangladesh', 'remax-earphone-price-in-bangladesh', 1, 'null', '2023-05-10 10:17:42', '2023-05-10 10:17:42'),
(43, 'mobile stand', 'mobile-stand', 1, 'null', '2023-05-10 11:16:46', '2023-05-10 11:16:46'),
(44, 'mobile stand price in bangladesh', 'mobile-stand-price-in-bangladesh', 1, 'null', '2023-05-10 11:16:59', '2023-05-10 11:16:59'),
(45, 'tablet stand', 'tablet-stand', 1, 'null', '2023-05-10 11:17:08', '2023-05-10 11:17:08'),
(46, 'good mobile stand', 'good-mobile-stand', 1, 'null', '2023-05-10 11:17:34', '2023-05-10 11:17:34'),
(47, 'best tablet stand price', 'best-tablet-stand-price', 1, 'null', '2023-05-10 11:18:05', '2023-05-10 11:18:05'),
(48, 'portable cell phone stand', 'portable-cell-phone-stand', 1, 'null', '2023-05-10 12:43:09', '2023-05-10 12:43:09'),
(49, 'adjustable phone holder', 'adjustable-phone-holder', 1, 'null', '2023-05-10 12:43:33', '2023-05-10 12:43:33'),
(50, 'moblie stand price', 'moblie-stand-price', 1, 'null', '2023-05-10 12:45:01', '2023-05-10 12:45:01'),
(51, 'mobile phone stand price in bangladesh', 'mobile-phone-stand-price-in-bangladesh', 1, 'null', '2023-05-10 12:45:22', '2023-05-10 12:45:22'),
(52, 'Lenovo Neckband price', 'lenovo-neckband-price', 1, 'null', '2023-05-11 03:01:53', '2023-05-11 03:01:53'),
(53, 'Lenovo Neckband price  in bangladesh', 'lenovo-neckband-price-in-bangladesh', 1, 'null', '2023-05-11 03:02:02', '2023-05-11 03:02:02'),
(54, 'M20 TWS Wireless Earbuds', 'm20-tws-wireless-earbuds', 1, 'null', '2023-05-11 05:07:25', '2023-05-11 05:07:25'),
(55, 'M20 TWS Wireless Earbuds price in Bangladesh', 'm20-tws-wireless-earbuds-price-in-bangladesh', 1, 'null', '2023-05-11 05:07:44', '2023-05-11 05:07:44'),
(56, 'M27 tws price', 'm27-tws-price', 1, 'null', '2023-05-11 05:48:39', '2023-05-11 05:48:39'),
(57, 'm27 headphone price', 'm27-headphone-price', 1, 'null', '2023-05-11 05:48:50', '2023-05-11 05:48:50'),
(58, 'M27 tws price in bangladesh', 'm27-tws-price-in-bangladesh', 1, 'null', '2023-05-11 05:48:58', '2023-05-11 05:48:58'),
(59, 'M27 headphone price in bangladesh', 'm27-headphone-price-in-bangladesh', 1, 'null', '2023-05-11 05:49:15', '2023-05-11 05:49:15'),
(60, 'M32 Mini Bluetooth 5.1 Earphone TWS Wireless Headphones', 'm32-mini-bluetooth-51-earphone-tws-wireless-headphones', 1, 'null', '2023-05-11 07:34:35', '2023-05-11 07:34:35'),
(61, 'TWS Wireless Headphones', 'tws-wireless-headphones', 1, 'null', '2023-05-11 07:34:49', '2023-05-11 07:34:49'),
(62, 'M32 Mini Bluetooth price', 'm32-mini-bluetooth-price', 1, 'null', '2023-05-11 07:35:02', '2023-05-11 07:35:02'),
(63, 'M35 TWS Bluetooth', 'm35-tws-bluetooth', 1, 'null', '2023-05-11 08:13:05', '2023-05-11 08:13:05'),
(64, 'M35 TWS Bluetooth price in bangladesh', 'm35-tws-bluetooth-price-in-bangladesh', 1, 'null', '2023-05-11 08:13:15', '2023-05-11 08:13:15'),
(65, 'M19 TWS Wireless Bluetooth', 'm19-tws-wireless-bluetooth', 1, 'null', '2023-05-11 08:58:17', '2023-05-11 08:58:17'),
(66, 'M19 TWS Wireless Bluetooth price in bangladesh', 'm19-tws-wireless-bluetooth-price-in-bangladesh', 1, 'null', '2023-05-11 08:58:27', '2023-05-11 08:58:27'),
(67, 'JBL Bluetooth speaker', 'jbl-bluetooth-speaker', 1, 'null', '2023-05-11 10:25:02', '2023-05-11 10:25:02'),
(68, 'JBL M3 mini Bluetooth speaker', 'jbl-m3-mini-bluetooth-speaker', 1, 'null', '2023-05-11 10:25:14', '2023-05-11 10:25:14'),
(69, 'WS887BluetoothSpeaker', 'ws887bluetoothspeaker', 1, 'null', '2023-05-11 11:54:47', '2023-05-11 11:54:47'),
(70, 'PortableSpeaker', 'portablespeaker', 1, 'null', '2023-05-11 11:55:05', '2023-05-11 11:55:05'),
(71, 'WirelessSpeaker', 'wirelessspeaker', 1, 'null', '2023-05-11 11:55:18', '2023-05-11 11:55:18'),
(72, 'BluetoothEarphones', 'bluetoothearphones', 1, 'null', '2023-05-12 08:34:18', '2023-05-12 08:34:18'),
(73, 'JBLM10PRO', 'jblm10pro', 1, 'null', '2023-05-12 08:34:35', '2023-05-12 08:34:35'),
(74, 'TWSEarbuds', 'twsearbuds', 1, 'null', '2023-05-12 08:34:53', '2023-05-12 08:34:53'),
(75, 'Portable speaker', 'portable-speaker', 1, 'null', '2023-05-12 08:59:00', '2023-05-12 08:59:00'),
(76, 'Rechargeable speaker', 'rechargeable-speaker', 1, 'null', '2023-05-12 08:59:26', '2023-05-12 08:59:26'),
(77, 'Party speaker', 'party-speaker', 1, 'null', '2023-05-12 08:59:42', '2023-05-12 08:59:42'),
(78, 'Home speaker', 'home-speaker', 1, 'null', '2023-05-12 08:59:55', '2023-05-12 08:59:55'),
(79, 'Neck fan', 'neck-fan', 1, 'null', '2023-05-13 01:58:33', '2023-05-13 01:58:33'),
(80, 'Hands-free fan', 'hands-free-fan', 1, 'null', '2023-05-13 01:58:45', '2023-05-13 01:58:45'),
(81, 'Portable fan', 'portable-fan', 1, 'null', '2023-05-13 01:58:56', '2023-05-13 01:58:56'),
(82, 'USB fan', 'usb-fan', 1, 'null', '2023-05-13 01:59:07', '2023-05-13 01:59:07'),
(83, 'Rechargeable fan', 'rechargeable-fan', 1, 'null', '2023-05-13 01:59:17', '2023-05-13 01:59:17'),
(84, 'Mini fan', 'mini-fan', 1, 'null', '2023-05-13 01:59:27', '2023-05-13 01:59:27'),
(85, 'Personal fan', 'personal-fan', 1, 'null', '2023-05-13 01:59:37', '2023-05-13 01:59:37'),
(86, 'Wearable fan', 'wearable-fan', 1, 'null', '2023-05-13 01:59:51', '2023-05-13 01:59:51'),
(87, 'Battery fan', 'battery-fan', 1, 'null', '2023-05-13 02:00:08', '2023-05-13 02:00:08'),
(88, 'Office fan', 'office-fan', 1, 'null', '2023-05-13 02:00:21', '2023-05-13 02:00:21'),
(89, 'Kitchen fan', 'kitchen-fan', 1, 'null', '2023-05-13 02:01:37', '2023-05-13 02:01:37'),
(90, 'PortableFan', 'portablefan', 1, 'null', '2023-05-13 04:24:37', '2023-05-13 04:24:37'),
(91, 'RechargeableFan', 'rechargeablefan', 1, 'null', '2023-05-13 04:24:51', '2023-05-13 04:24:51'),
(92, 'USBFan', 'usbfan', 1, 'null', '2023-05-13 04:25:03', '2023-05-13 04:25:03'),
(93, 'HandheldFan', 'handheldfan', 1, 'null', '2023-05-13 04:25:14', '2023-05-13 04:25:14'),
(94, '#MiniFan', 'minifan', 1, 'null', '2023-05-13 04:25:25', '2023-05-13 04:25:25'),
(95, '#MakeupFan', 'makeupfan', 1, 'null', '2023-05-13 04:25:37', '2023-05-13 04:25:37'),
(96, '#BabyFan', 'babyfan', 1, 'null', '2023-05-13 04:25:51', '2023-05-13 04:25:51'),
(97, 'Bone conduction earphone', 'bone-conduction-earphone', 1, 'null', '2023-05-13 07:51:17', '2023-05-13 07:51:17'),
(98, 'Wireless Bluetooth headphones', 'wireless-bluetooth-headphones', 1, 'null', '2023-05-13 07:51:29', '2023-05-13 07:51:29'),
(99, 'Neckband earphone', 'neckband-earphone', 1, 'null', '2023-05-13 07:51:41', '2023-05-13 07:51:41'),
(100, 'Bluetooth V5.1', 'bluetooth-v51', 1, 'null', '2023-05-13 07:51:54', '2023-05-13 07:51:54'),
(101, 'Copper ring speaker', 'copper-ring-speaker', 1, 'null', '2023-05-13 07:52:13', '2023-05-13 07:52:13'),
(102, 'Portable earphone', 'portable-earphone', 1, 'null', '2023-05-13 07:52:56', '2023-05-13 07:52:56'),
(103, 'Bone conduction earphones', 'bone-conduction-earphones', 1, 'null', '2023-05-13 09:38:38', '2023-05-13 09:38:38');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `sub` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `reply` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `unproducts`
--

CREATE TABLE `unproducts` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `thumbnail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) 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 `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `refer` int NOT NULL DEFAULT '2',
  `username` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oauth_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oauth_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `cancel_attempt` int NOT NULL DEFAULT '0',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default.png',
  `point` int NOT NULL DEFAULT '0',
  `pen_point` int DEFAULT NULL,
  `joining_date` date NOT NULL,
  `joining_month` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `joining_year` year NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desig` int DEFAULT NULL,
  `wallate` int 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 `users`
--

INSERT INTO `users` (`id`, `role_id`, `name`, `refer`, `username`, `email`, `phone`, `password`, `oauth_id`, `oauth_type`, `is_approved`, `status`, `cancel_attempt`, `avatar`, `point`, `pen_point`, `joining_date`, `joining_month`, `joining_year`, `email_verified_at`, `remember_token`, `desig`, `wallate`, `created_at`, `updated_at`) VALUES
(1, 1, 'Finva Soft', 2, 'admin', 'asifulmamun@gmail.com', '01721600688', '$2y$10$zayBOfViYMB65kxVCJLGQuw9nBHkxyIVlVkHl1zjoWuMEWGHT2GOO', NULL, NULL, 1, 1, 0, '2023-09-05-64f771292bc07.jpg', 0, 0, '2021-04-30', 'April', 2021, '2021-04-30 05:44:48', 'XaRJAPppF2UYNGR9PvzOztkCuT2RY3IcS0r3XWtyuTbjcWRbyNiNeCdx25kp', 1, 0, '2021-04-30 05:44:48', '2024-01-18 07:31:08'),
(286, 2, 'Vendor', 2, 'vendor', 'vendor@gmail.com', '01710101010', '$2y$10$zayBOfViYMB65kxVCJLGQuw9nBHkxyIVlVkHl1zjoWuMEWGHT2GOO', NULL, NULL, 1, 1, 0, 'default.png', 0, NULL, '2023-09-11', 'September', 2023, NULL, NULL, NULL, 0, '2023-09-11 07:44:02', '2023-09-11 07:44:02'),
(287, 3, 'customer', 2, 'customer', 'customer@gmail.com', '01710101011', '$2y$10$zayBOfViYMB65kxVCJLGQuw9nBHkxyIVlVkHl1zjoWuMEWGHT2GOO', NULL, NULL, 1, 1, 0, '2024-01-23-65af4a2dcf1c3.JPG', 0, 0, '2023-09-11', 'September', 2023, NULL, NULL, NULL, 0, '2023-09-11 07:46:51', '2024-01-22 23:10:05'),
(291, 3, 'Finva', 2, 'finva4088', 'mamun.finvasoft@gmail.com', '01787841017', '$2y$10$DT72pvDDJanad4tjH.pOd.I6qid6pXU.G2r6WRM/vfgnJeS0OCk..', NULL, NULL, 1, 1, 0, 'default.png', 0, NULL, '2024-01-22', 'January', 2024, NULL, NULL, NULL, 0, '2024-01-22 03:31:50', '2024-01-22 04:11:51'),
(292, 3, 'xobaeer', 2, 'xobaeer1453', 'asmaakterkg@gmail.com', '01793658563', '$2y$10$Xbi7LhriOcLW81IURGUjHuTkocuHif/7Ayrf3OGA4Pn.PPOE4c/6u', NULL, NULL, 1, 1, 0, 'default.png', 0, NULL, '2024-02-03', 'February', 2024, NULL, NULL, NULL, 0, '2024-02-03 05:49:16', '2024-02-03 05:50:24');

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

--
-- Table structure for table `vendor_accounts`
--

CREATE TABLE `vendor_accounts` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` bigint UNSIGNED NOT NULL,
  `amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `pending_amount` decimal(20,2) 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 `vendor_accounts`
--

INSERT INTO `vendor_accounts` (`id`, `vendor_id`, `amount`, `pending_amount`, `created_at`, `updated_at`) VALUES
(1, 1, '0.00', '250.00', NULL, '2024-01-22 04:30:17'),
(20, 286, '0.00', NULL, '2023-09-11 07:44:02', '2023-09-11 07:44:02');

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

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wishlists`
--

INSERT INTO `wishlists` (`id`, `user_id`, `product_id`, `created_at`, `updated_at`) VALUES
(3, 227, 656, '2023-07-02 10:03:25', '2023-07-02 10:03:25'),
(4, 247, 683, '2023-08-23 04:31:22', '2023-08-23 04:31:22'),
(5, 247, 684, '2023-08-23 04:31:25', '2023-08-23 04:31:25'),
(6, 274, 683, '2023-08-27 04:56:38', '2023-08-27 04:56:38'),
(7, 274, 684, '2023-08-27 04:57:28', '2023-08-27 04:57:28'),
(11, 256, 693, '2023-08-27 05:35:06', '2023-08-27 05:35:06'),
(12, 275, 683, '2023-08-27 08:27:42', '2023-08-27 08:27:42');

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

--
-- Table structure for table `withdraws`
--

CREATE TABLE `withdraws` (
  `id` bigint UNSIGNED NOT NULL,
  `user_type` int DEFAULT NULL,
  `number` int DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attributes`
--
ALTER TABLE `attributes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`);

--
-- Indexes for table `attribute_product`
--
ALTER TABLE `attribute_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attribute_product_attribute_value_id_foreign` (`attribute_value_id`),
  ADD KEY `attribute_product_product_id_foreign` (`product_id`);

--
-- Indexes for table `attribute_values`
--
ALTER TABLE `attribute_values`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `attribute_values_slug_unique` (`slug`),
  ADD KEY `attribute_values_attributes_id_foreign` (`attributes_id`);

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

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

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_comments_blog_id_foreign` (`blog_id`);

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

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `brands_slug_unique` (`slug`);

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

--
-- Indexes for table `campaing_comments`
--
ALTER TABLE `campaing_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaing_comments_campaign_id_foreign` (`campaign_id`);

--
-- Indexes for table `campaing_products`
--
ALTER TABLE `campaing_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaing_products_campain_id_foreign` (`campaign_id`),
  ADD KEY `campaing_products_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_name_unique` (`name`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`);

--
-- Indexes for table `category_collection`
--
ALTER TABLE `category_collection`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_collection_category_id_foreign` (`category_id`),
  ADD KEY `category_collection_collection_id_foreign` (`collection_id`);

--
-- Indexes for table `category_product`
--
ALTER TABLE `category_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_product_category_id_foreign` (`category_id`),
  ADD KEY `category_product_product_id_foreign` (`product_id`);

--
-- Indexes for table `chats`
--
ALTER TABLE `chats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chats_user_id_foreign` (`user_id`);

--
-- Indexes for table `collections`
--
ALTER TABLE `collections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `collections_name_unique` (`name`),
  ADD UNIQUE KEY `collections_slug_unique` (`slug`);

--
-- Indexes for table `colors`
--
ALTER TABLE `colors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `colors_name_unique` (`name`),
  ADD UNIQUE KEY `colors_slug_unique` (`slug`),
  ADD UNIQUE KEY `colors_code_unique` (`code`);

--
-- Indexes for table `color_product`
--
ALTER TABLE `color_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `color_product_color_id_foreign` (`color_id`),
  ADD KEY `color_product_product_id_foreign` (`product_id`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comments_product_id_foreign` (`product_id`);

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

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

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

--
-- Indexes for table `coupon_user`
--
ALTER TABLE `coupon_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `coupon_user_user_id_foreign` (`user_id`),
  ADD KEY `coupon_user_coupon_id_foreign` (`coupon_id`);

--
-- Indexes for table `customer_infos`
--
ALTER TABLE `customer_infos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_infos_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `download_products`
--
ALTER TABLE `download_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `download_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `download_users`
--
ALTER TABLE `download_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `download_users_user_id_foreign` (`user_id`),
  ADD KEY `download_users_product_id_foreign` (`product_id`);

--
-- Indexes for table `download_user_products`
--
ALTER TABLE `download_user_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `download_user_products_user_id_foreign` (`user_id`),
  ADD KEY `download_user_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `extra_mini_categories`
--
ALTER TABLE `extra_mini_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `extra_mini_categories_name_unique` (`name`),
  ADD UNIQUE KEY `extra_mini_categories_slug_unique` (`slug`),
  ADD KEY `extra_mini_categories_mini_category_id_foreign` (`mini_category_id`);

--
-- Indexes for table `extra_mini_category_product`
--
ALTER TABLE `extra_mini_category_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `extra_mini_category_product_extra_mini_categories_id_foreign` (`extra_mini_category_id`),
  ADD KEY `extra_mini_category_product_product_id_foreign` (`product_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Indexes for table `mini_categories`
--
ALTER TABLE `mini_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mini_categories_name_unique` (`name`),
  ADD UNIQUE KEY `mini_categories_slug_unique` (`slug`),
  ADD KEY `mini_categories_category_id_foreign` (`category_id`);

--
-- Indexes for table `mini_category_product`
--
ALTER TABLE `mini_category_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mini_category_product_product_id_foreign` (`product_id`),
  ADD KEY `mini_category_product_mini_category_id_foreign` (`mini_category_id`);

--
-- Indexes for table `multi_order`
--
ALTER TABLE `multi_order`
  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`),
  ADD KEY `order_details_order_id_foreign` (`order_id`);

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_slug_unique` (`slug`);

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

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

--
-- Indexes for table `product_size`
--
ALTER TABLE `product_size`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_size_size_id_foreign` (`size_id`),
  ADD KEY `product_size_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_sub_category`
--
ALTER TABLE `product_sub_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_sub_category_sub_category_id_foreign` (`sub_category_id`),
  ADD KEY `product_sub_category_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_tag`
--
ALTER TABLE `product_tag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_tag_tag_id_foreign` (`tag_id`),
  ADD KEY `product_tag_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_user`
--
ALTER TABLE `product_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_user_user_id_foreign` (`user_id`),
  ADD KEY `product_user_product_id_foreign` (`product_id`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reviews_user_id_foreign` (`user_id`),
  ADD KEY `reviews_product_id_foreign` (`product_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

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

--
-- Indexes for table `shop_infos`
--
ALTER TABLE `shop_infos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_infos_user_id_foreign` (`user_id`);

--
-- Indexes for table `sizes`
--
ALTER TABLE `sizes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sizes_name_unique` (`name`),
  ADD UNIQUE KEY `sizes_slug_unique` (`slug`);

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

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

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sub_categories_name_unique` (`name`),
  ADD UNIQUE KEY `sub_categories_slug_unique` (`slug`),
  ADD KEY `sub_categories_category_id_foreign` (`category_id`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tags_name_unique` (`name`),
  ADD UNIQUE KEY `tags_slug_unique` (`slug`);

--
-- Indexes for table `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tickets_user_id_foreign` (`user_id`);

--
-- Indexes for table `unproducts`
--
ALTER TABLE `unproducts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `unproducts_user_id_foreign` (`user_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_username_unique` (`username`);

--
-- Indexes for table `vendor_accounts`
--
ALTER TABLE `vendor_accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `vendor_accounts_vendor_id_foreign` (`vendor_id`) USING BTREE;

--
-- Indexes for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wishlists_user_id_foreign` (`user_id`),
  ADD KEY `wishlists_product_id_foreign` (`product_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attributes`
--
ALTER TABLE `attributes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `attribute_product`
--
ALTER TABLE `attribute_product`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT for table `attribute_values`
--
ALTER TABLE `attribute_values`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `authors`
--
ALTER TABLE `authors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bloods`
--
ALTER TABLE `bloods`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=297;

--
-- AUTO_INCREMENT for table `campaigns`
--
ALTER TABLE `campaigns`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `campaing_comments`
--
ALTER TABLE `campaing_comments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `campaing_products`
--
ALTER TABLE `campaing_products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `cart_infos`
--
ALTER TABLE `cart_infos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `category_collection`
--
ALTER TABLE `category_collection`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `category_product`
--
ALTER TABLE `category_product`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=731;

--
-- AUTO_INCREMENT for table `chats`
--
ALTER TABLE `chats`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `collections`
--
ALTER TABLE `collections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `colors`
--
ALTER TABLE `colors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `color_product`
--
ALTER TABLE `color_product`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `commissions`
--
ALTER TABLE `commissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `coupon_user`
--
ALTER TABLE `coupon_user`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `customer_infos`
--
ALTER TABLE `customer_infos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=262;

--
-- AUTO_INCREMENT for table `device_ids`
--
ALTER TABLE `device_ids`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154;

--
-- AUTO_INCREMENT for table `download_products`
--
ALTER TABLE `download_products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `download_users`
--
ALTER TABLE `download_users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `download_user_products`
--
ALTER TABLE `download_user_products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `extra_mini_categories`
--
ALTER TABLE `extra_mini_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `extra_mini_category_product`
--
ALTER TABLE `extra_mini_category_product`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `mini_categories`
--
ALTER TABLE `mini_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=199;

--
-- AUTO_INCREMENT for table `mini_category_product`
--
ALTER TABLE `mini_category_product`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=347;

--
-- AUTO_INCREMENT for table `multi_order`
--
ALTER TABLE `multi_order`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `partial_payments`
--
ALTER TABLE `partial_payments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=714;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=377;

--
-- AUTO_INCREMENT for table `product_reviews`
--
ALTER TABLE `product_reviews`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_size`
--
ALTER TABLE `product_size`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_sub_category`
--
ALTER TABLE `product_sub_category`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=905;

--
-- AUTO_INCREMENT for table `product_tag`
--
ALTER TABLE `product_tag`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=209;

--
-- AUTO_INCREMENT for table `product_user`
--
ALTER TABLE `product_user`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT for table `shop_infos`
--
ALTER TABLE `shop_infos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `sizes`
--
ALTER TABLE `sizes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=118;

--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;

--
-- AUTO_INCREMENT for table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `unproducts`
--
ALTER TABLE `unproducts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=293;

--
-- AUTO_INCREMENT for table `vendor_accounts`
--
ALTER TABLE `vendor_accounts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `wishlists`
--
ALTER TABLE `wishlists`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `withdraws`
--
ALTER TABLE `withdraws`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `attribute_product`
--
ALTER TABLE `attribute_product`
  ADD CONSTRAINT `attribute_product_attribute_value_id_foreign` FOREIGN KEY (`attribute_value_id`) REFERENCES `attribute_values` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `attribute_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `attribute_values`
--
ALTER TABLE `attribute_values`
  ADD CONSTRAINT `attribute_values_attributes_id_foreign` FOREIGN KEY (`attributes_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD CONSTRAINT `blog_comments_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `campaing_comments`
--
ALTER TABLE `campaing_comments`
  ADD CONSTRAINT `campaing_comments_campaign_id_foreign` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `campaing_products`
--
ALTER TABLE `campaing_products`
  ADD CONSTRAINT `campaing_products_campain_id_foreign` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `campaing_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_collection`
--
ALTER TABLE `category_collection`
  ADD CONSTRAINT `category_collection_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_collection_collection_id_foreign` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_product`
--
ALTER TABLE `category_product`
  ADD CONSTRAINT `category_product_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `chats`
--
ALTER TABLE `chats`
  ADD CONSTRAINT `chats_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `color_product`
--
ALTER TABLE `color_product`
  ADD CONSTRAINT `color_product_color_id_foreign` FOREIGN KEY (`color_id`) REFERENCES `colors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `color_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `coupon_user`
--
ALTER TABLE `coupon_user`
  ADD CONSTRAINT `coupon_user_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `coupon_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_infos`
--
ALTER TABLE `customer_infos`
  ADD CONSTRAINT `customer_infos_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `download_products`
--
ALTER TABLE `download_products`
  ADD CONSTRAINT `download_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `download_users`
--
ALTER TABLE `download_users`
  ADD CONSTRAINT `download_users_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `download_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `download_user_products`
--
ALTER TABLE `download_user_products`
  ADD CONSTRAINT `download_user_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `download_user_products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `extra_mini_categories`
--
ALTER TABLE `extra_mini_categories`
  ADD CONSTRAINT `extra_mini_categories_mini_category_id_foreign` FOREIGN KEY (`mini_category_id`) REFERENCES `mini_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `extra_mini_category_product`
--
ALTER TABLE `extra_mini_category_product`
  ADD CONSTRAINT `extra_mini_category_product_extra_mini_categories_id_foreign` FOREIGN KEY (`extra_mini_category_id`) REFERENCES `extra_mini_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `extra_mini_category_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `mini_category_product`
--
ALTER TABLE `mini_category_product`
  ADD CONSTRAINT `mini_category_product_mini_category_id_foreign` FOREIGN KEY (`mini_category_id`) REFERENCES `mini_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `mini_category_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `unproducts`
--
ALTER TABLE `unproducts`
  ADD CONSTRAINT `unproducts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

