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

START TRANSACTION;



--
-- Database: `tasfon`
--

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`image`)),
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL 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 `banners`
--

INSERT INTO `banners` (`id`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '\"{\\\"original\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9b8c2f191771690424.webp\\\",\\\"small\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9b8c2f191771690424_400.webp\\\",\\\"medium\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9b8c2f191771690424_768.webp\\\",\\\"large\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9b8c2f191771690424_1200.webp\\\"}\"', 'active', NULL, '2026-02-21 16:13:48', '2026-02-21 16:13:48'),
(2, '\"{\\\"original\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9c5532961771690437.webp\\\",\\\"small\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9c5532961771690437_400.webp\\\",\\\"medium\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9c5532961771690437_768.webp\\\",\\\"large\\\":\\\"uploads\\\\\\/category\\\\\\/6999d9c5532961771690437_1200.webp\\\"}\"', 'active', NULL, '2026-02-21 16:13:57', '2026-02-21 16:13:57');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `slug` varchar(255) DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_description` varchar(255) DEFAULT NULL,
  `seo_image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `imageTitle` varchar(255) DEFAULT NULL,
  `totalViews` int(11) DEFAULT NULL,
  `readingTime` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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 `blog_tags`
--

CREATE TABLE `blog_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` int(11) DEFAULT NULL,
  `tag_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog_writers`
--

CREATE TABLE `blog_writers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` int(11) DEFAULT NULL,
  `writer_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`image`)),
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `name`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Topten', NULL, 'active', NULL, '2026-02-21 04:25:37', '2026-02-21 04:25:37');

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

--
-- Table structure for table `cart_settings`
--

CREATE TABLE `cart_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `minimum_order_amount` decimal(10,2) DEFAULT NULL,
  `minimum_order_amount_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `maximum_order_amount` decimal(10,2) DEFAULT NULL,
  `maximum_order_amount_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `pre_order_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `pre_order_type` enum('cart','product') NOT NULL DEFAULT 'cart',
  `pre_order_amount` decimal(10,2) DEFAULT NULL,
  `free_shipping_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `free_shipping_amount` decimal(10,2) DEFAULT NULL,
  `default_shipping_charge` decimal(10,2) DEFAULT NULL,
  `tax_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `tax_percentage` decimal(5,2) DEFAULT NULL,
  `coupon_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `cod_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `guest_checkout_enabled` 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;

--
-- Dumping data for table `cart_settings`
--

INSERT INTO `cart_settings` (`id`, `minimum_order_amount`, `minimum_order_amount_enabled`, `maximum_order_amount`, `maximum_order_amount_enabled`, `pre_order_enabled`, `pre_order_type`, `pre_order_amount`, `free_shipping_enabled`, `free_shipping_amount`, `default_shipping_charge`, `tax_enabled`, `tax_percentage`, `coupon_enabled`, `cod_enabled`, `guest_checkout_enabled`, `created_at`, `updated_at`) VALUES
(1, 675.00, 0, 35676.60, 0, 0, 'cart', 12.00, 1, NULL, 60.00, 0, 12.00, 0, 1, 1, '2026-02-21 08:36:23', '2026-03-13 04:03:46');

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`image`)),
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Mens', NULL, 'active', NULL, '2026-02-21 04:24:56', '2026-02-21 04:24:56'),
(2, 'লাইফস্টাইল', NULL, 'active', NULL, '2026-02-23 03:45:58', '2026-02-23 03:45:58');

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

--
-- Table structure for table `child_categories`
--

CREATE TABLE `child_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subcategory_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`image`)),
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL 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 `child_categories`
--

INSERT INTO `child_categories` (`id`, `subcategory_id`, `name`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'T-shirt', NULL, 'active', NULL, '2026-02-21 04:25:24', '2026-02-21 04:25:24');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `gallery_images`
--

CREATE TABLE `gallery_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `product_variant_color_id` int(11) DEFAULT NULL,
  `original` varchar(255) DEFAULT NULL,
  `small` varchar(255) DEFAULT NULL,
  `medium` varchar(255) DEFAULT NULL,
  `large` varchar(255) DEFAULT NULL,
  `type` varchar(255) 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 `gallery_images`
--

INSERT INTO `gallery_images` (`id`, `product_id`, `product_variant_color_id`, `original`, `small`, `medium`, `large`, `type`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 'uploads/products/JP278sJqQrHQaro5xZME.jpeg', 'uploads/products/JP278sJqQrHQaro5xZME_400.jpeg', 'uploads/products/JP278sJqQrHQaro5xZME_768.jpeg', 'uploads/products/JP278sJqQrHQaro5xZME_1200.jpeg', 'main', '2026-02-21 04:53:15', '2026-02-21 04:53:15'),
(2, 1, NULL, 'uploads/products/Z2lILWf8y2vLSMlqRfCr.jpeg', 'uploads/products/Z2lILWf8y2vLSMlqRfCr_400.jpeg', 'uploads/products/Z2lILWf8y2vLSMlqRfCr_768.jpeg', 'uploads/products/Z2lILWf8y2vLSMlqRfCr_1200.jpeg', 'hover', '2026-02-21 04:53:16', '2026-02-21 04:53:16'),
(3, 1, 1, 'uploads/variants/2pGXO4yM9XZmty7XJFa6.jpeg', 'uploads/variants/2pGXO4yM9XZmty7XJFa6_400.jpeg', 'uploads/variants/2pGXO4yM9XZmty7XJFa6_768.jpeg', 'uploads/variants/2pGXO4yM9XZmty7XJFa6_1200.jpeg', 'variant', '2026-02-21 04:53:17', '2026-02-21 04:53:17'),
(4, 1, 2, 'uploads/variants/9vM1dfjkslhuN9znEwJe.jpeg', 'uploads/variants/9vM1dfjkslhuN9znEwJe_400.jpeg', 'uploads/variants/9vM1dfjkslhuN9znEwJe_768.jpeg', 'uploads/variants/9vM1dfjkslhuN9znEwJe_1200.jpeg', 'variant', '2026-02-21 04:53:18', '2026-02-21 04:53:18'),
(5, 2, NULL, 'uploads/products/sarjtbxcSwEZ3y6c13vW.png', 'uploads/products/sarjtbxcSwEZ3y6c13vW_400.png', 'uploads/products/sarjtbxcSwEZ3y6c13vW_768.png', 'uploads/products/sarjtbxcSwEZ3y6c13vW_1200.png', 'main', '2026-02-21 06:38:17', '2026-02-21 06:38:17'),
(6, 2, NULL, 'uploads/products/bWNXSRgoVGacwtt0WsBP.png', 'uploads/products/bWNXSRgoVGacwtt0WsBP_400.png', 'uploads/products/bWNXSRgoVGacwtt0WsBP_768.png', 'uploads/products/bWNXSRgoVGacwtt0WsBP_1200.png', 'hover', '2026-02-21 06:38:19', '2026-02-21 06:38:19'),
(7, 2, 3, 'uploads/variants/lnBPx869j4Vw2V2GawcK.png', 'uploads/variants/lnBPx869j4Vw2V2GawcK_400.png', 'uploads/variants/lnBPx869j4Vw2V2GawcK_768.png', 'uploads/variants/lnBPx869j4Vw2V2GawcK_1200.png', 'variant', '2026-02-21 06:38:23', '2026-02-21 06:38:23'),
(8, 2, 3, 'uploads/variants/JAgk2ggmydIbJ5Y8YWGj.png', 'uploads/variants/JAgk2ggmydIbJ5Y8YWGj_400.png', 'uploads/variants/JAgk2ggmydIbJ5Y8YWGj_768.png', 'uploads/variants/JAgk2ggmydIbJ5Y8YWGj_1200.png', 'variant', '2026-02-21 06:38:23', '2026-02-21 06:38:23'),
(9, 2, 4, 'uploads/variants/tSmQcCt0QmYicEK1nPDt.jpeg', 'uploads/variants/tSmQcCt0QmYicEK1nPDt_400.jpeg', 'uploads/variants/tSmQcCt0QmYicEK1nPDt_768.jpeg', 'uploads/variants/tSmQcCt0QmYicEK1nPDt_1200.jpeg', 'variant', '2026-02-21 07:04:16', '2026-02-21 07:04:16'),
(10, 2, 4, 'uploads/variants/z31oRcsGEKxe8hgUeHGZ.jpeg', 'uploads/variants/z31oRcsGEKxe8hgUeHGZ_400.jpeg', 'uploads/variants/z31oRcsGEKxe8hgUeHGZ_768.jpeg', 'uploads/variants/z31oRcsGEKxe8hgUeHGZ_1200.jpeg', 'variant', '2026-02-21 07:04:16', '2026-02-21 07:04:16'),
(11, 3, NULL, 'uploads/products/I4DDnOxEsBMnmr35U3Bo.jpeg', 'uploads/products/I4DDnOxEsBMnmr35U3Bo_400.jpeg', 'uploads/products/I4DDnOxEsBMnmr35U3Bo_768.jpeg', 'uploads/products/I4DDnOxEsBMnmr35U3Bo_1200.jpeg', 'main', '2026-02-23 03:38:50', '2026-02-23 03:38:50'),
(12, 3, NULL, 'uploads/products/ihPnnzBZ8qiv3IxByuN3.jpeg', 'uploads/products/ihPnnzBZ8qiv3IxByuN3_400.jpeg', 'uploads/products/ihPnnzBZ8qiv3IxByuN3_768.jpeg', 'uploads/products/ihPnnzBZ8qiv3IxByuN3_1200.jpeg', 'hover', '2026-02-23 03:38:50', '2026-02-23 03:38:50'),
(13, 3, 5, 'uploads/variants/Wr37QknqrVtuLTsprziM.jpeg', 'uploads/variants/Wr37QknqrVtuLTsprziM_400.jpeg', 'uploads/variants/Wr37QknqrVtuLTsprziM_768.jpeg', 'uploads/variants/Wr37QknqrVtuLTsprziM_1200.jpeg', 'variant', '2026-02-23 03:38:52', '2026-02-23 03:38:52'),
(14, 3, 5, 'uploads/variants/jYmsfJrcmOQxMvTOgPtK.jpeg', 'uploads/variants/jYmsfJrcmOQxMvTOgPtK_400.jpeg', 'uploads/variants/jYmsfJrcmOQxMvTOgPtK_768.jpeg', 'uploads/variants/jYmsfJrcmOQxMvTOgPtK_1200.jpeg', 'variant', '2026-02-23 03:38:52', '2026-02-23 03:38:52'),
(15, 4, NULL, 'uploads/products/bPyVZLWmYWSd2TP17C8J.jpeg', 'uploads/products/bPyVZLWmYWSd2TP17C8J_400.jpeg', 'uploads/products/bPyVZLWmYWSd2TP17C8J_768.jpeg', 'uploads/products/bPyVZLWmYWSd2TP17C8J_1200.jpeg', 'main', '2026-03-06 20:03:22', '2026-03-06 20:03:22'),
(16, 4, NULL, 'uploads/products/pyHGoEKUPaj59pM5ryLF.jpeg', 'uploads/products/pyHGoEKUPaj59pM5ryLF_400.jpeg', 'uploads/products/pyHGoEKUPaj59pM5ryLF_768.jpeg', 'uploads/products/pyHGoEKUPaj59pM5ryLF_1200.jpeg', 'hover', '2026-03-06 20:03:23', '2026-03-06 20:03:23'),
(17, 5, NULL, 'uploads/products/A3RSol6CTMGXaesC7498.jpeg', 'uploads/products/A3RSol6CTMGXaesC7498_400.jpeg', 'uploads/products/A3RSol6CTMGXaesC7498_768.jpeg', 'uploads/products/A3RSol6CTMGXaesC7498_1200.jpeg', 'main', '2026-03-06 20:06:39', '2026-03-06 20:06:39'),
(18, 5, NULL, 'uploads/products/07PrnF8RCq85b4J25eLl.jpeg', 'uploads/products/07PrnF8RCq85b4J25eLl_400.jpeg', 'uploads/products/07PrnF8RCq85b4J25eLl_768.jpeg', 'uploads/products/07PrnF8RCq85b4J25eLl_1200.jpeg', 'hover', '2026-03-06 20:06:39', '2026-03-06 20:06:39'),
(19, 6, NULL, 'uploads/products/WrH6kFDlJoj3EAUAbB3f.jpeg', 'uploads/products/WrH6kFDlJoj3EAUAbB3f_400.jpeg', 'uploads/products/WrH6kFDlJoj3EAUAbB3f_768.jpeg', 'uploads/products/WrH6kFDlJoj3EAUAbB3f_1200.jpeg', 'main', '2026-03-06 20:14:30', '2026-03-06 20:14:30'),
(20, 6, NULL, 'uploads/products/XNqsiUWAGT27ef0B2Ycv.jpeg', 'uploads/products/XNqsiUWAGT27ef0B2Ycv_400.jpeg', 'uploads/products/XNqsiUWAGT27ef0B2Ycv_768.jpeg', 'uploads/products/XNqsiUWAGT27ef0B2Ycv_1200.jpeg', 'hover', '2026-03-06 20:14:31', '2026-03-06 20:14:31'),
(21, 6, 6, 'uploads/variants/UmGadnroXkkBPEOU1bIN.png', 'uploads/variants/UmGadnroXkkBPEOU1bIN_400.png', 'uploads/variants/UmGadnroXkkBPEOU1bIN_768.png', 'uploads/variants/UmGadnroXkkBPEOU1bIN_1200.png', 'variant', '2026-03-06 20:14:36', '2026-03-06 20:14:36'),
(22, 6, 6, 'uploads/variants/oZKLpr0EyML4wcriS5tI.png', 'uploads/variants/oZKLpr0EyML4wcriS5tI_400.png', 'uploads/variants/oZKLpr0EyML4wcriS5tI_768.png', 'uploads/variants/oZKLpr0EyML4wcriS5tI_1200.png', 'variant', '2026-03-06 20:14:36', '2026-03-06 20:14:36'),
(23, 6, 6, 'uploads/variants/eeigkPzAraO2sjlSbJ2u.jpeg', 'uploads/variants/eeigkPzAraO2sjlSbJ2u_400.jpeg', 'uploads/variants/eeigkPzAraO2sjlSbJ2u_768.jpeg', 'uploads/variants/eeigkPzAraO2sjlSbJ2u_1200.jpeg', 'variant', '2026-03-06 20:14:36', '2026-03-06 20:14:36'),
(24, 6, 6, 'uploads/variants/VDEmBiMWbfY4HWgLvkQN.jpeg', 'uploads/variants/VDEmBiMWbfY4HWgLvkQN_400.jpeg', 'uploads/variants/VDEmBiMWbfY4HWgLvkQN_768.jpeg', 'uploads/variants/VDEmBiMWbfY4HWgLvkQN_1200.jpeg', 'variant', '2026-03-06 20:14:36', '2026-03-06 20:14:36'),
(25, 6, 7, 'uploads/variants/jIcmSirttK7dOKznNWEQ.png', 'uploads/variants/jIcmSirttK7dOKznNWEQ_400.png', 'uploads/variants/jIcmSirttK7dOKznNWEQ_768.png', 'uploads/variants/jIcmSirttK7dOKznNWEQ_1200.png', 'variant', '2026-03-06 20:14:41', '2026-03-06 20:14:41'),
(26, 6, 7, 'uploads/variants/Qytf2YFA7ypOXk5PRAAq.png', 'uploads/variants/Qytf2YFA7ypOXk5PRAAq_400.png', 'uploads/variants/Qytf2YFA7ypOXk5PRAAq_768.png', 'uploads/variants/Qytf2YFA7ypOXk5PRAAq_1200.png', 'variant', '2026-03-06 20:14:41', '2026-03-06 20:14:41'),
(27, 6, 7, 'uploads/variants/Zk2kGaG6GMYUkUluQ0nO.jpeg', 'uploads/variants/Zk2kGaG6GMYUkUluQ0nO_400.jpeg', 'uploads/variants/Zk2kGaG6GMYUkUluQ0nO_768.jpeg', 'uploads/variants/Zk2kGaG6GMYUkUluQ0nO_1200.jpeg', 'variant', '2026-03-06 20:14:41', '2026-03-06 20:14:41'),
(28, 6, 7, 'uploads/variants/Pq7bWcl1dF3Swd287AL3.jpeg', 'uploads/variants/Pq7bWcl1dF3Swd287AL3_400.jpeg', 'uploads/variants/Pq7bWcl1dF3Swd287AL3_768.jpeg', 'uploads/variants/Pq7bWcl1dF3Swd287AL3_1200.jpeg', 'variant', '2026-03-06 20:14:41', '2026-03-06 20:14:41'),
(29, 6, 6, 'uploads/variants/SpgarbEmj1WkXkhJtRpS.png', 'uploads/variants/SpgarbEmj1WkXkhJtRpS_400.png', 'uploads/variants/SpgarbEmj1WkXkhJtRpS_768.png', 'uploads/variants/SpgarbEmj1WkXkhJtRpS_1200.png', 'variant', '2026-03-06 20:15:41', '2026-03-06 20:15:41'),
(30, 6, 6, 'uploads/variants/XvLMvT98Vx14MKCFmWIn.png', 'uploads/variants/XvLMvT98Vx14MKCFmWIn_400.png', 'uploads/variants/XvLMvT98Vx14MKCFmWIn_768.png', 'uploads/variants/XvLMvT98Vx14MKCFmWIn_1200.png', 'variant', '2026-03-06 20:15:41', '2026-03-06 20:15:41'),
(31, 6, 6, 'uploads/variants/Pg370Wb2AX5Tb7HHMJQq.jpeg', 'uploads/variants/Pg370Wb2AX5Tb7HHMJQq_400.jpeg', 'uploads/variants/Pg370Wb2AX5Tb7HHMJQq_768.jpeg', 'uploads/variants/Pg370Wb2AX5Tb7HHMJQq_1200.jpeg', 'variant', '2026-03-06 20:15:41', '2026-03-06 20:15:41'),
(32, 6, 6, 'uploads/variants/Q31kwvH4s7d2Kj3xdOK8.jpeg', 'uploads/variants/Q31kwvH4s7d2Kj3xdOK8_400.jpeg', 'uploads/variants/Q31kwvH4s7d2Kj3xdOK8_768.jpeg', 'uploads/variants/Q31kwvH4s7d2Kj3xdOK8_1200.jpeg', 'variant', '2026-03-06 20:15:41', '2026-03-06 20:15:41'),
(33, 6, 7, 'uploads/variants/MVnvII13Jh9UbQNgJEmJ.png', 'uploads/variants/MVnvII13Jh9UbQNgJEmJ_400.png', 'uploads/variants/MVnvII13Jh9UbQNgJEmJ_768.png', 'uploads/variants/MVnvII13Jh9UbQNgJEmJ_1200.png', 'variant', '2026-03-06 20:15:46', '2026-03-06 20:15:46'),
(34, 6, 7, 'uploads/variants/EuQxTSoa82StIARu2m6i.png', 'uploads/variants/EuQxTSoa82StIARu2m6i_400.png', 'uploads/variants/EuQxTSoa82StIARu2m6i_768.png', 'uploads/variants/EuQxTSoa82StIARu2m6i_1200.png', 'variant', '2026-03-06 20:15:46', '2026-03-06 20:15:46'),
(35, 6, 7, 'uploads/variants/HVaNqyOxfzbht9jpJMT7.jpeg', 'uploads/variants/HVaNqyOxfzbht9jpJMT7_400.jpeg', 'uploads/variants/HVaNqyOxfzbht9jpJMT7_768.jpeg', 'uploads/variants/HVaNqyOxfzbht9jpJMT7_1200.jpeg', 'variant', '2026-03-06 20:15:46', '2026-03-06 20:15:46'),
(36, 6, 7, 'uploads/variants/omnbEMN3hlDCHRQIpPtl.jpeg', 'uploads/variants/omnbEMN3hlDCHRQIpPtl_400.jpeg', 'uploads/variants/omnbEMN3hlDCHRQIpPtl_768.jpeg', 'uploads/variants/omnbEMN3hlDCHRQIpPtl_1200.jpeg', 'variant', '2026-03-06 20:15:46', '2026-03-06 20:15:46');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_08_26_100418_add_two_factor_columns_to_users_table', 1),
(6, '2025_10_10_182132_create_email_configs_table', 1),
(7, '2025_12_18_092032_create_brands_table', 1),
(8, '2025_12_18_093412_create_categories_table', 1),
(9, '2025_12_18_093427_create_subcategories_table', 1),
(10, '2025_12_18_093438_create_child_categories_table', 1),
(11, '2025_12_19_224349_create_sliders_table', 1),
(12, '2025_12_19_234150_create_banners_table', 1),
(13, '2025_12_20_001152_create_personal_access_tokens_table', 1),
(14, '2026_01_03_18000_create_variant_types_table', 1),
(15, '2026_01_03_19000_create_variants_table', 1),
(16, '2026_01_03_210000_create_gallery_images_table', 1),
(17, '2026_01_03_215448_create_products_table', 1),
(18, '2026_02_21_095643_create_product_variant_colors_table', 1),
(19, '2026_02_21_095758_create_product_variant_sizes_table', 1),
(20, '2026_02_21_230615_create_stocks_table', 1),
(21, '2026_02_21_141311_create_cart_settings_table', 2),
(22, '2025_09_24_184227_create_settings_table', 3),
(23, '2026_02_21_210333_create_orders_table', 3),
(24, '2026_02_21_210349_create_order_details_table', 3),
(25, '2025_06_30_160801_create_blogs_table', 4),
(26, '2025_12_09_105935_create_blog_categories_table', 4),
(27, '2025_12_09_110057_create_blog_writers_table', 4),
(28, '2025_12_09_110411_add_colum_blog_writer_id_category_id', 4),
(29, '2025_12_09_110652_create_tags_table', 4),
(30, '2025_12_09_110746_create_blog_tags_table', 4),
(31, '2025_12_09_110226_create_writers_table', 5),
(32, '2026_03_05_200522_create_units_table', 6),
(33, '2026_03_06_173128_create_wishlists_table', 7),
(34, '2026_03_10_004033_create_order_statuses_table', 8);

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

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`address`)),
  `invoice_number` varchar(191) DEFAULT NULL,
  `tracking_number` varchar(255) DEFAULT NULL,
  `sub_total_amount` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT NULL,
  `discount_amount` decimal(15,2) DEFAULT NULL,
  `tax` decimal(15,2) DEFAULT NULL,
  `shipping_type` int(11) DEFAULT NULL,
  `shipping_cost` decimal(15,2) DEFAULT NULL,
  `discount_shipping` decimal(10,2) DEFAULT NULL,
  `coupon_code` varchar(20) DEFAULT NULL,
  `coupon_amount` decimal(10,2) DEFAULT NULL,
  `pre_order_amount` decimal(15,2) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `payment_status` varchar(255) DEFAULT NULL,
  `payment_status_code` varchar(255) DEFAULT NULL,
  `payment_status_message` varchar(255) DEFAULT NULL,
  `payment_status_date` timestamp NULL DEFAULT NULL,
  `status` varchar(255) 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 `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `address`, `invoice_number`, `tracking_number`, `sub_total_amount`, `total_amount`, `discount_amount`, `tax`, `shipping_type`, `shipping_cost`, `discount_shipping`, `coupon_code`, `coupon_amount`, `pre_order_amount`, `payment_method`, `payment_status`, `payment_status_code`, `payment_status_message`, `payment_status_date`, `status`, `created_at`, `updated_at`) VALUES
(5, NULL, '{\"street\":\"plashbari bazar\",\"city\":\"htyh\",\"state\":\"tyhjyuthjyuhjy\",\"zip\":\"8100\",\"country\":\"Bangladesh\"}', NULL, 'TRK-I4X-20260306-6227', NULL, 0.00, 0.00, 0.00, NULL, 120.00, NULL, NULL, 0.00, NULL, 'sslcommerz', 'pending', NULL, NULL, NULL, 'pending', '2026-03-06 04:31:38', '2026-03-06 04:31:38'),
(6, NULL, '{\"street\":\"urfi charpara,Manikhar ,Gopalgonj\",\"city\":\"dsfcdsfc\",\"state\":\"dsfcdsfdsf\",\"zip\":\"4322\",\"country\":\"Bangladesh\"}', NULL, 'TRK-SE8-20260306-1868', NULL, 0.00, 0.00, 0.00, NULL, 120.00, NULL, NULL, 0.00, NULL, 'card', 'pending', NULL, NULL, NULL, 'pending', '2026-03-06 04:33:35', '2026-03-06 04:33:35'),
(8, NULL, '{\"street\":\"urfi charpara,Manikhar ,Gopalgonj\",\"city\":\"defrefg\",\"state\":\"regvrdeg\",\"zip\":\"4311\",\"country\":\"Bangladesh\"}', NULL, 'TRK-EXX-20260306-6207', NULL, 0.00, 0.00, 0.00, NULL, 120.00, NULL, NULL, 0.00, NULL, 'cod', 'pending', 'COD_PENDING', 'Cash on Delivery order confirmed. Agent will collect ৳120.00 on arrival.', '2026-03-05 18:00:00', 'pending', '2026-03-06 04:51:02', '2026-03-06 04:51:02'),
(9, NULL, '{\"street\":\"kollyanpur\",\"city\":\"erfetfre\",\"state\":\"tgrrg\",\"zip\":\"123\",\"country\":\"Bangladesh\"}', NULL, 'TRK-RMF-20260306-1658', NULL, 0.00, 0.00, 0.00, NULL, 120.00, NULL, NULL, 0.00, NULL, 'cod', 'pending', 'COD_PENDING', 'Cash on Delivery order confirmed. Agent will collect ৳120.00 on arrival.', '2026-03-05 18:00:00', 'pending', '2026-03-06 15:17:18', '2026-03-06 15:17:19'),
(10, NULL, '{\"street\":\"tgrtfhrtgfhy\",\"city\":\"hhjy\",\"state\":\"tyhjytyhj\",\"zip\":\"3454\",\"country\":\"Bangladesh\"}', NULL, 'TRK-RDH-20260313-9934', NULL, NULL, NULL, 0.00, NULL, 120.00, NULL, NULL, 0.00, NULL, 'cod', 'pending', 'COD_PENDING', 'Cash on Delivery order confirmed. Agent will collect ৳ on arrival.', '2026-03-12 18:00:00', 'pending', '2026-03-13 04:04:23', '2026-03-13 04:04:23'),
(11, NULL, '\"{\\\"street\\\":\\\"12\\\",\\\"city\\\":\\\"fgdrgdrtfg\\\",\\\"state\\\":\\\"ftgftghrfgh\\\",\\\"zip\\\":\\\"12\\\",\\\"country\\\":\\\"Bangladesh\\\"}\"', NULL, 'TRK-XUC-20260313-7251', 2445.00, 2640.60, 0.00, 195.60, NULL, 0.00, NULL, NULL, 0.00, NULL, 'cod', 'pending', 'COD_PENDING', 'Cash on Delivery order confirmed. Agent will collect ৳ on arrival.', '2026-03-13 06:38:50', 'pending', '2026-03-13 06:38:50', '2026-03-13 06:38:50'),
(12, NULL, '\"{\\\"contact\\\":{\\\"first_name\\\":\\\"dfgdrg\\\",\\\"last_name\\\":\\\"rftgdfgdf\\\",\\\"email\\\":\\\"hospital@example.com\\\",\\\"phone\\\":\\\"01715486265\\\"},\\\"address\\\":{\\\"street\\\":\\\"12ere\\\",\\\"city\\\":\\\"drfefre\\\",\\\"state\\\":\\\"fergftregf\\\",\\\"zip\\\":\\\"12\\\",\\\"country\\\":\\\"Bangladesh\\\"}}\"', 'INV-20260313-3400', 'TRK-FJ0-20260313-4481', 12000.00, 12960.00, 0.00, 960.00, NULL, 0.00, NULL, NULL, 0.00, NULL, 'cod', 'pending', 'COD_PENDING', 'Cash on Delivery order confirmed. Agent will collect ৳ on arrival.', '2026-03-13 06:58:04', 'pending', '2026-03-13 06:58:04', '2026-03-13 06:58:04'),
(13, NULL, '\"{\\\"contact\\\":{\\\"first_name\\\":\\\"ghfghg\\\",\\\"last_name\\\":\\\"mhjbjb\\\",\\\"email\\\":\\\"mohsinsikder.cse@gmail.com\\\",\\\"phone\\\":\\\"01715486265\\\"},\\\"address\\\":{\\\"street\\\":\\\"jyhguyjg\\\",\\\"city\\\":\\\"jhgjhbghj\\\",\\\"state\\\":\\\"jhghj\\\",\\\"zip\\\":\\\"1223\\\",\\\"country\\\":\\\"Bangladesh\\\"}}\"', 'INV-20260313-5498', 'TRK-L2B-20260313-4558', 12000.00, 12960.00, 0.00, 960.00, NULL, 0.00, NULL, NULL, 0.00, NULL, 'cod', 'pending', 'COD_PENDING', 'Cash on Delivery order confirmed. Agent will collect ৳ on arrival.', '2026-03-13 09:36:16', 'pending', '2026-03-13 09:36:16', '2026-03-13 09:36:16');

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

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

CREATE TABLE `order_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `color_id` int(11) DEFAULT NULL,
  `size_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `total_price` decimal(10,2) DEFAULT NULL,
  `discount_price` decimal(10,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 `order_details`
--

INSERT INTO `order_details` (`id`, `order_id`, `product_id`, `color_id`, `size_id`, `quantity`, `price`, `total_price`, `discount_price`, `created_at`, `updated_at`) VALUES
(7, 5, 2, NULL, NULL, 1, NULL, 0.00, 0.00, '2026-03-06 04:31:38', '2026-03-06 04:31:38'),
(8, 5, 1, NULL, NULL, 1, NULL, 0.00, 0.00, '2026-03-06 04:31:38', '2026-03-06 04:31:38'),
(9, 6, 2, NULL, NULL, 1, NULL, 0.00, 0.00, '2026-03-06 04:33:35', '2026-03-06 04:33:35'),
(11, 8, 2, NULL, NULL, 1, NULL, 0.00, 0.00, '2026-03-06 04:51:02', '2026-03-06 04:51:02'),
(12, 9, 2, NULL, NULL, 4, NULL, 0.00, 0.00, '2026-03-06 15:17:18', '2026-03-06 15:17:18'),
(13, 9, 1, NULL, NULL, 3, NULL, 0.00, 0.00, '2026-03-06 15:17:18', '2026-03-06 15:17:18'),
(14, 10, 2, NULL, NULL, 1, NULL, 0.00, 0.00, '2026-03-13 04:04:23', '2026-03-13 04:04:23'),
(15, 11, 6, 6, 8, 1, 2323.00, 2323.00, 0.00, '2026-03-13 06:38:50', '2026-03-13 06:38:50'),
(16, 11, 6, 7, 9, 1, 122.00, 122.00, 0.00, '2026-03-13 06:38:50', '2026-03-13 06:38:50'),
(17, 12, 3, 5, 7, 1, 12000.00, 12000.00, 0.00, '2026-03-13 06:58:04', '2026-03-13 06:58:04'),
(18, 13, 3, 5, 7, 1, 12000.00, 12000.00, 0.00, '2026-03-13 09:36:16', '2026-03-13 09:36:16');

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

--
-- Table structure for table `order_statuses`
--

CREATE TABLE `order_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `isDefault` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sorting_number` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_statuses`
--

INSERT INTO `order_statuses` (`id`, `name`, `isDefault`, `status`, `sorting_number`, `created_at`, `updated_at`) VALUES
(1, 'In Courir', NULL, 'active', NULL, '2026-03-09 18:49:37', '2026-03-09 18:49:37');

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subcategory_id` bigint(20) UNSIGNED DEFAULT NULL,
  `child_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `meta_keyword` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_image` varchar(255) DEFAULT NULL,
  `discount_type` varchar(255) DEFAULT NULL,
  `product_video` varchar(255) DEFAULT NULL,
  `size_chart` varchar(255) DEFAULT NULL,
  `discount_amount` decimal(8,2) DEFAULT NULL,
  `discount_start_date` datetime DEFAULT NULL,
  `discount_end_date` datetime DEFAULT NULL,
  `has_discount` enum('yes','no') NOT NULL DEFAULT 'no',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `main_image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hover_image_id` bigint(20) UNSIGNED 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 `products`
--

INSERT INTO `products` (`id`, `category_id`, `subcategory_id`, `child_category_id`, `brand_id`, `name`, `slug`, `sku`, `stock`, `short_description`, `description`, `meta_description`, `meta_keyword`, `meta_title`, `meta_image`, `discount_type`, `product_video`, `size_chart`, `discount_amount`, `discount_start_date`, `discount_end_date`, `has_discount`, `status`, `main_image_id`, `hover_image_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, 'sdsdfdfsdgvdgv', 'sdsdfdfsdgvdgv-EEZtAS', NULL, NULL, NULL, '<p>dfdgdfgtgfhghtgf</p>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'active', 1, 2, '2026-02-21 04:53:12', '2026-02-21 05:38:20'),
(2, 1, 1, 1, 1, 'Cotton Polo Sweater S/S', 'cotton-polo-sweater-ss-bnye01', NULL, NULL, NULL, '<p>dfddfdrdrfdrrf</p>', NULL, NULL, NULL, NULL, 'percent', NULL, NULL, 10.00, '2026-02-02 00:00:00', '2026-03-11 00:00:00', 'yes', 'active', 5, 6, '2026-02-21 06:38:15', '2026-03-06 20:00:09'),
(3, 1, 1, 1, 1, 'Flannel Overshirt Jacket (A)', 'flannel-overshirt-jacket-a-vytn8A', NULL, NULL, NULL, '<p>dfvdgvgvfgg</p>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'active', 11, 12, '2026-02-23 03:38:46', '2026-03-06 12:00:13'),
(4, 2, NULL, NULL, 1, 'cdfdsfvdrgdrfghtfh', 'cdfdsfvdrgdrfghtfh-kgdiHN', NULL, NULL, NULL, '<p>rfrefref</p>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'active', 15, 16, '2026-03-06 20:03:19', '2026-03-06 20:03:23'),
(5, 2, NULL, NULL, 1, 'sdcsfdgbdfhbgfhn', 'sdcsfdgbdfhbgfhn-JScluH', NULL, NULL, NULL, '<p>rewerfewfte4tf</p>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'active', 17, 18, '2026-03-06 20:06:38', '2026-03-06 20:06:39'),
(6, 2, NULL, NULL, NULL, 'fedrgfvdreghynjyuj', 'fedrgfvdreghynjyuj-GvLmLt', NULL, NULL, NULL, '<p>asxdadsfc</p>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'active', 19, 20, '2026-03-06 20:14:30', '2026-03-06 20:15:36');

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

--
-- Table structure for table `product_variant_colors`
--

CREATE TABLE `product_variant_colors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `color_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_variant_colors`
--

INSERT INTO `product_variant_colors` (`id`, `product_id`, `color_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2026-02-21 04:53:16', '2026-02-21 04:53:16'),
(2, 1, 2, '2026-02-21 04:53:17', '2026-02-21 04:53:17'),
(3, 2, 1, '2026-02-21 06:38:20', '2026-02-21 06:38:20'),
(4, 2, 2, '2026-02-21 07:04:15', '2026-02-21 07:04:15'),
(5, 3, 2, '2026-02-23 03:38:50', '2026-02-23 03:38:50'),
(6, 6, 1, '2026-03-06 20:14:31', '2026-03-06 20:14:31'),
(7, 6, 2, '2026-03-06 20:14:36', '2026-03-06 20:14:36');

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

--
-- Table structure for table `product_variant_sizes`
--

CREATE TABLE `product_variant_sizes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_variant_color_id` bigint(20) UNSIGNED DEFAULT NULL,
  `size_id` int(11) DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `purchase_price` decimal(8,2) DEFAULT NULL,
  `sale_price` decimal(8,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 `product_variant_sizes`
--

INSERT INTO `product_variant_sizes` (`id`, `product_variant_color_id`, `size_id`, `stock`, `sku`, `purchase_price`, `sale_price`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 2, 'dsfdgfsvdrg', 122.00, 122.00, '2026-02-21 04:53:16', '2026-02-21 05:38:20'),
(2, 2, 3, 2, 'dfvgdgv', 122.00, 122.00, '2026-02-21 04:53:17', '2026-02-21 05:38:20'),
(4, 3, 3, 2, 'dfdfdrfr', 1290.00, 1490.00, '2026-02-21 06:38:20', '2026-02-21 07:04:15'),
(5, 3, 4, NULL, 'rfrgtryhth', 20000.00, 200000.00, '2026-02-21 07:03:11', '2026-02-21 07:04:15'),
(6, 4, 3, 2, 'erewretf', 1333.00, 122.00, '2026-02-21 07:04:15', '2026-02-21 07:04:15'),
(7, 5, 3, 4, 'defefrefre', 12200.00, 12000.00, '2026-02-23 03:38:50', '2026-02-23 03:38:50'),
(8, 6, 3, 2, '2drfegdregrtfh', 133.00, 2323.00, '2026-03-06 20:14:31', '2026-03-06 20:15:36'),
(9, 7, 3, 2, 'erfefgreg', 1221.00, 122.00, '2026-03-06 20:14:36', '2026-03-06 20:15:41');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('auR67gUS3gkEoWybG6lcDHBk4wuBqeQTtwnvP6ci', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVkdkbzFNMmlobXU0dDE4RlVZTU1jUUJOZjQ3Y1RlM3I4NTdhc1EwaiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9vcmRlci9pbnZvaWNlLzgiO3M6NToicm91dGUiO3M6MTk6ImFkbWluLm9yZGVyLmludm9pY2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjU6ImFsZXJ0IjthOjA6e319', 1773088065),
('Dwd6sKQV2swuczA6Us5ZnuBxOplSZEcUAzuGDoXy', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRnl6eFJZVTJVY2pPY3dyODFTcU5MZ05tWUxQZHA0WkptMUFEcTlONSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9jYXJ0LXNldHRpbmciO3M6NToicm91dGUiO3M6MjQ6ImFkbWluLmNhcnQtc2V0dGluZy5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NToiYWxlcnQiO2E6MDp7fX0=', 1773374627),
('fJERkeO0qHcaud3yKCFcCOX9y0VPtZ1nz3rYfYrR', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYkZkWjB1NzVaSTJDSUVFWFp6am5QSFNoajBTY3NCdkRiVXBtRzNkMiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9vcmRlci9kZXRhaWxzLzEyIjtzOjU6InJvdXRlIjtzOjE5OiJhZG1pbi5vcmRlci5kZXRhaWxzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773391914),
('vmymY3EXD5HM9UxrFO8CTcF4CQoHZBR3hxAUofro', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicWdRVUJldlhuUmxNSWZIbnJ2dUJXSDA5V256b1hQdTd5SllGN2JOZCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9nZW5lcmFsU2V0dGluZyI7czo1OiJyb3V0ZSI7czoyNjoiYWRtaW4uZ2VuZXJhbFNldHRpbmcuaW5kZXgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773596195);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `site_name` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `videoUrl` varchar(255) DEFAULT NULL,
  `favicon` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `whitebglogo` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `iosUrl` varchar(255) DEFAULT NULL,
  `androidUrl` varchar(255) DEFAULT NULL,
  `webUrl` varchar(255) DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_description` varchar(255) DEFAULT NULL,
  `google_pixle` longtext DEFAULT NULL,
  `facebook_pixle` longtext DEFAULT NULL,
  `fb` varchar(255) DEFAULT NULL,
  `wp` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `linkdi` varchar(255) DEFAULT NULL,
  `term_condition` longtext DEFAULT NULL,
  `privacy_policy` longtext DEFAULT NULL,
  `return_policy` longtext DEFAULT NULL,
  `about_us` longtext DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `footer_content` longtext 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 `settings`
--

INSERT INTO `settings` (`id`, `site_name`, `logo`, `videoUrl`, `favicon`, `email`, `whitebglogo`, `phone`, `currency`, `position`, `url`, `iosUrl`, `androidUrl`, `webUrl`, `seo_title`, `seo_description`, `google_pixle`, `facebook_pixle`, `fb`, `wp`, `twitter`, `youtube`, `linkdi`, `term_condition`, `privacy_policy`, `return_policy`, `about_us`, `address`, `footer_content`, `created_at`, `updated_at`) VALUES
(1, 'Micol', 'uploads/images/projects/1771691560_logo.png', 'https://www.youtube.com/watch?v=xR6zAFleN1c', 'uploads/images/projects/1771691560_favicon.png', 'mohsinsikder.cse@gmail.com', 'uploads/images/projects/1771691560_whitebglogo.png', '01706125400', 'DBT', 'right', 'https://www.youtube.com/watch?v=4dNjkHLzTNY', 'https://apps.apple.com/us/app/ojus-one/id6756559512', 'https://play.google.com/store/apps/details?id=com.ojus_one.client&pcampaignid=web_share', 'https://login.ojusone.com/Home/Login', 'sdxcsadc', 'sacscfsfcs', '<!-- Google tag (gtag.js) -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=AW-1234567890\"></script>\r\n<script>\r\nwindow.dataLayer = window.dataLayer || [];\r\nfunction gtag(){dataLayer.push(arguments);}\r\ngtag(\'js\', new Date());\r\n\r\ngtag(\'config\', \'AW-1234567890\');\r\n</script>', '<!-- Facebook Pixel Code -->\r\n<script>\r\n!function(f,b,e,v,n,t,s)\r\n{if(f.fbq)return;n=f.fbq=function(){n.callMethod?\r\nn.callMethod.apply(n,arguments):n.queue.push(arguments)};\r\nif(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version=\'2.0\';\r\nn.queue=[];t=b.createElement(e);t.async=!0;\r\nt.src=v;s=b.getElementsByTagName(e)[0];\r\ns.parentNode.insertBefore(t,s)}\r\n(window, document,\'script\',\r\n\'https://connect.facebook.net/en_US/fbevents.js\');\r\n\r\nfbq(\'init\', \'123456789012345\'); \r\nfbq(\'track\', \'PageView\');\r\n</script>\r\n<!-- End Facebook Pixel Code -->', 'http://127.0.0.1:8000/admin/generalSetting', 'http://127.0.0.1:8000/admin/generalSetting', 'http://127.0.0.1:8000/admin/generalSetting', 'http://127.0.0.1:8000/admin/generalSetting', 'http://127.0.0.1:8000/admin/generalSetting', NULL, NULL, NULL, NULL, 'urfi charpara,Manikhar ,Gopalgonj', NULL, '2026-02-21 16:32:40', '2026-03-06 10:31:27');

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`image`)),
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL 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 `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '\"{\\\"original\\\":\\\"uploads\\\\\\/category\\\\\\/699951757eaa51771655541.webp\\\",\\\"small\\\":\\\"uploads\\\\\\/category\\\\\\/699951757eaa51771655541_400.webp\\\",\\\"medium\\\":\\\"uploads\\\\\\/category\\\\\\/699951757eaa51771655541_768.webp\\\",\\\"large\\\":\\\"uploads\\\\\\/category\\\\\\/699951757eaa51771655541_1200.webp\\\"}\"', 'active', NULL, '2026-02-21 06:32:23', '2026-02-21 06:32:23');

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

--
-- Table structure for table `stocks`
--

CREATE TABLE `stocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_variant_size_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `stockType` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `subcategories`
--

CREATE TABLE `subcategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`image`)),
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL 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 `subcategories`
--

INSERT INTO `subcategories` (`id`, `category_id`, `name`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Mens shirt', NULL, 'active', NULL, '2026-02-21 04:25:09', '2026-02-21 04:25:09');

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

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

CREATE TABLE `tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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 `units`
--

CREATE TABLE `units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `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 `units`
--

INSERT INTO `units` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'mohsin', 'active', '2026-03-05 14:15:37', '2026-03-05 14:16:33');

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

--
-- Table structure for table `variants`
--

CREATE TABLE `variants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `variant_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL 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 `variants`
--

INSERT INTO `variants` (`id`, `variant_type_id`, `name`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'red', 'active', NULL, '2026-02-21 04:26:02', '2026-02-21 04:26:02'),
(2, 1, 'blue', 'active', NULL, '2026-02-21 04:26:14', '2026-02-21 04:26:14'),
(3, 2, 'xl', 'active', NULL, '2026-02-21 04:26:24', '2026-02-21 04:26:24'),
(4, 2, 'sm', 'active', NULL, '2026-02-21 04:26:37', '2026-02-21 04:26:37');

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

--
-- Table structure for table `variant_types`
--

CREATE TABLE `variant_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive','delete') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL 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 `variant_types`
--

INSERT INTO `variant_types` (`id`, `name`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Color', 'active', NULL, '2026-02-21 04:25:48', '2026-02-21 04:25:48'),
(2, 'Size', 'active', NULL, '2026-02-21 04:25:53', '2026-02-21 04:25:53');

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

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

CREATE TABLE `wishlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) 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 `writers`
--

CREATE TABLE `writers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `fb` varchar(255) DEFAULT NULL,
  `wp` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `linkdi` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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 `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

--
-- Indexes for table `child_categories`
--
ALTER TABLE `child_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `child_categories_subcategory_id_foreign` (`subcategory_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 `gallery_images`
--
ALTER TABLE `gallery_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoice_number` (`invoice_number`,`tracking_number`),
  ADD KEY `orders_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_slug_unique` (`slug`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_subcategory_id_foreign` (`subcategory_id`),
  ADD KEY `products_child_category_id_foreign` (`child_category_id`),
  ADD KEY `products_brand_id_foreign` (`brand_id`),
  ADD KEY `products_main_image_id_foreign` (`main_image_id`),
  ADD KEY `products_hover_image_id_foreign` (`hover_image_id`);

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

--
-- Indexes for table `product_variant_sizes`
--
ALTER TABLE `product_variant_sizes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_variant_sizes_product_variant_color_id_foreign` (`product_variant_color_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

--
-- Indexes for table `stocks`
--
ALTER TABLE `stocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stocks_product_id_foreign` (`product_id`),
  ADD KEY `stocks_product_variant_size_id_foreign` (`product_variant_size_id`);

--
-- Indexes for table `subcategories`
--
ALTER TABLE `subcategories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subcategories_category_id_foreign` (`category_id`);

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

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

--
-- Indexes for table `variants`
--
ALTER TABLE `variants`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variants_variant_type_id_foreign` (`variant_type_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `child_categories`
--
ALTER TABLE `child_categories`
  ADD CONSTRAINT `child_categories_subcategory_id_foreign` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_child_category_id_foreign` FOREIGN KEY (`child_category_id`) REFERENCES `child_categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_hover_image_id_foreign` FOREIGN KEY (`hover_image_id`) REFERENCES `gallery_images` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_main_image_id_foreign` FOREIGN KEY (`main_image_id`) REFERENCES `gallery_images` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_subcategory_id_foreign` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategories` (`id`) ON DELETE SET NULL;

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

--
-- Constraints for table `product_variant_sizes`
--
ALTER TABLE `product_variant_sizes`
  ADD CONSTRAINT `product_variant_sizes_product_variant_color_id_foreign` FOREIGN KEY (`product_variant_color_id`) REFERENCES `product_variant_colors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `stocks`
--
ALTER TABLE `stocks`
  ADD CONSTRAINT `stocks_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `stocks_product_variant_size_id_foreign` FOREIGN KEY (`product_variant_size_id`) REFERENCES `product_variant_sizes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subcategories`
--
ALTER TABLE `subcategories`
  ADD CONSTRAINT `subcategories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `variants`
--
ALTER TABLE `variants`
  ADD CONSTRAINT `variants_variant_type_id_foreign` FOREIGN KEY (`variant_type_id`) REFERENCES `variant_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD CONSTRAINT `wishlists_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

