-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 16, 2026 at 07:21 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `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 `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cache` -- INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel-cache-boost.roster.scan', 'a:2:{s:6:\"roster\";O:21:\"Laravel\\Roster\\Roster\":3:{s:13:\"\0*\0approaches\";O:29:\"Illuminate\\Support\\Collection\":2:{s:8:\"\0*\0items\";a:1:{i:0;O:23:\"Laravel\\Roster\\Approach\":1:{s:11:\"\0*\0approach\";E:38:\"Laravel\\Roster\\Enums\\Approaches:ACTION\";}}s:28:\"\0*\0escapeWhenCastingToString\";b:0;}s:11:\"\0*\0packages\";O:32:\"Laravel\\Roster\\PackageCollection\":2:{s:8:\"\0*\0items\";a:21:{i:0;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:4:\"^2.0\";s:10:\"\0*\0package\";E:37:\"Laravel\\Roster\\Enums\\Packages:INERTIA\";s:14:\"\0*\0packageName\";s:25:\"inertiajs/inertia-laravel\";s:10:\"\0*\0version\";s:6:\"2.0.16\";s:6:\"\0*\0dev\";b:0;}i:1;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:4:\"^2.0\";s:10:\"\0*\0package\";E:45:\"Laravel\\Roster\\Enums\\Packages:INERTIA_LARAVEL\";s:14:\"\0*\0packageName\";s:25:\"inertiajs/inertia-laravel\";s:10:\"\0*\0version\";s:6:\"2.0.16\";s:6:\"\0*\0dev\";b:0;}i:2;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:5:\"^1.30\";s:10:\"\0*\0package\";E:37:\"Laravel\\Roster\\Enums\\Packages:FORTIFY\";s:14:\"\0*\0packageName\";s:15:\"laravel/fortify\";s:10:\"\0*\0version\";s:6:\"1.33.0\";s:6:\"\0*\0dev\";b:0;}i:3;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:5:\"^12.0\";s:10:\"\0*\0package\";E:37:\"Laravel\\Roster\\Enums\\Packages:LARAVEL\";s:14:\"\0*\0packageName\";s:17:\"laravel/framework\";s:10:\"\0*\0version\";s:7:\"12.43.1\";s:6:\"\0*\0dev\";b:0;}i:4;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:6:\"v0.3.8\";s:10:\"\0*\0package\";E:37:\"Laravel\\Roster\\Enums\\Packages:PROMPTS\";s:14:\"\0*\0packageName\";s:15:\"laravel/prompts\";s:10:\"\0*\0version\";s:5:\"0.3.8\";s:6:\"\0*\0dev\";b:0;}i:5;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:4:\"^4.0\";s:10:\"\0*\0package\";E:37:\"Laravel\\Roster\\Enums\\Packages:SANCTUM\";s:14:\"\0*\0packageName\";s:15:\"laravel/sanctum\";s:10:\"\0*\0version\";s:5:\"4.2.1\";s:6:\"\0*\0dev\";b:0;}i:6;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:6:\"^0.1.9\";s:10:\"\0*\0package\";E:39:\"Laravel\\Roster\\Enums\\Packages:WAYFINDER\";s:14:\"\0*\0packageName\";s:17:\"laravel/wayfinder\";s:10:\"\0*\0version\";s:6:\"0.1.12\";s:6:\"\0*\0dev\";b:0;}i:7;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:6:\"^0.1.9\";s:10:\"\0*\0package\";E:47:\"Laravel\\Roster\\Enums\\Packages:WAYFINDER_LARAVEL\";s:14:\"\0*\0packageName\";s:17:\"laravel/wayfinder\";s:10:\"\0*\0version\";s:6:\"0.1.12\";s:6:\"\0*\0dev\";b:0;}i:8;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:6:\"v0.5.1\";s:10:\"\0*\0package\";E:33:\"Laravel\\Roster\\Enums\\Packages:MCP\";s:14:\"\0*\0packageName\";s:11:\"laravel/mcp\";s:10:\"\0*\0version\";s:5:\"0.5.1\";s:6:\"\0*\0dev\";b:1;}i:9;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:5:\"^1.24\";s:10:\"\0*\0package\";E:34:\"Laravel\\Roster\\Enums\\Packages:PINT\";s:14:\"\0*\0packageName\";s:12:\"laravel/pint\";s:10:\"\0*\0version\";s:6:\"1.26.0\";s:6:\"\0*\0dev\";b:1;}i:10;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:5:\"^1.41\";s:10:\"\0*\0package\";E:34:\"Laravel\\Roster\\Enums\\Packages:SAIL\";s:14:\"\0*\0packageName\";s:12:\"laravel/sail\";s:10:\"\0*\0version\";s:6:\"1.51.0\";s:6:\"\0*\0dev\";b:1;}i:11;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:1;s:13:\"\0*\0constraint\";s:4:\"^3.8\";s:10:\"\0*\0package\";E:34:\"Laravel\\Roster\\Enums\\Packages:PEST\";s:14:\"\0*\0packageName\";s:12:\"pestphp/pest\";s:10:\"\0*\0version\";s:5:\"3.8.4\";s:6:\"\0*\0dev\";b:1;}i:12;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:7:\"11.5.33\";s:10:\"\0*\0package\";E:37:\"Laravel\\Roster\\Enums\\Packages:PHPUNIT\";s:14:\"\0*\0packageName\";s:15:\"phpunit/phpunit\";s:10:\"\0*\0version\";s:7:\"11.5.33\";s:6:\"\0*\0dev\";b:1;}i:13;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";r:13;s:14:\"\0*\0packageName\";s:16:\"@inertiajs/react\";s:10:\"\0*\0version\";s:5:\"2.1.4\";s:6:\"\0*\0dev\";b:0;}i:14;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";E:43:\"Laravel\\Roster\\Enums\\Packages:INERTIA_REACT\";s:14:\"\0*\0packageName\";s:16:\"@inertiajs/react\";s:10:\"\0*\0version\";s:5:\"2.1.4\";s:6:\"\0*\0dev\";b:0;}i:15;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";E:35:\"Laravel\\Roster\\Enums\\Packages:REACT\";s:14:\"\0*\0packageName\";s:5:\"react\";s:10:\"\0*\0version\";s:6:\"19.2.0\";s:6:\"\0*\0dev\";b:0;}i:16;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";r:55;s:14:\"\0*\0packageName\";s:30:\"@laravel/vite-plugin-wayfinder\";s:10:\"\0*\0version\";s:5:\"0.1.3\";s:6:\"\0*\0dev\";b:1;}i:17;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";E:44:\"Laravel\\Roster\\Enums\\Packages:WAYFINDER_VITE\";s:14:\"\0*\0packageName\";s:30:\"@laravel/vite-plugin-wayfinder\";s:10:\"\0*\0version\";s:5:\"0.1.3\";s:6:\"\0*\0dev\";b:1;}i:18;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";E:36:\"Laravel\\Roster\\Enums\\Packages:ESLINT\";s:14:\"\0*\0packageName\";s:6:\"eslint\";s:10:\"\0*\0version\";s:6:\"9.33.0\";s:6:\"\0*\0dev\";b:1;}i:19;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";E:38:\"Laravel\\Roster\\Enums\\Packages:PRETTIER\";s:14:\"\0*\0packageName\";s:8:\"prettier\";s:10:\"\0*\0version\";s:5:\"3.6.2\";s:6:\"\0*\0dev\";b:1;}i:20;O:22:\"Laravel\\Roster\\Package\":6:{s:9:\"\0*\0direct\";b:0;s:13:\"\0*\0constraint\";s:0:\"\";s:10:\"\0*\0package\";E:41:\"Laravel\\Roster\\Enums\\Packages:TAILWINDCSS\";s:14:\"\0*\0packageName\";s:11:\"tailwindcss\";s:10:\"\0*\0version\";s:6:\"4.1.18\";s:6:\"\0*\0dev\";b:1;}}s:28:\"\0*\0escapeWhenCastingToString\";b:0;}s:21:\"\0*\0nodePackageManager\";E:43:\"Laravel\\Roster\\Enums\\NodePackageManager:NPM\";}s:9:\"timestamp\";i:1773085702;}', 1773172102); -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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 `email_configs` -- CREATE TABLE `email_configs` ( `id` bigint(20) UNSIGNED NOT NULL, `mail_mailer` varchar(255) DEFAULT NULL, `mail_host` varchar(255) DEFAULT NULL, `port` varchar(255) DEFAULT NULL, `mail_username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `mail_encryption` varchar(255) DEFAULT NULL, `email_name` varchar(255) DEFAULT NULL, `mail_name` varchar(255) DEFAULT NULL, `status` enum('active','inactive') 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 `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 `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_reset_tokens` -- INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES ('mohsinsikder.cse@gmail.com', '$2y$12$gaPJorPRIAa6izr/fMxD8ufqV39LUUhOhqerqd6Ncmk6IV4ItPBwm', '2026-03-06 06:36:48'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` text NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_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 `personal_access_tokens` -- INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES (23, 'App\\Models\\User', 3, 'auth_token', '6b4f2c54d987172bf8d2c3860496e6351b7a7d63a4e46121e227e4e7ce34ffcf', '[\"*\"]', '2026-03-12 19:16:04', NULL, '2026-03-12 18:31:05', '2026-03-12 19:16:04'); -- -------------------------------------------------------- -- -- 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, '

dfdgdfgtgfhghtgf

', 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, '

dfddfdrdrfdrrf

', 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, '

dfvdgvgvfgg

', 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, '

rfrefref

', 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, '

rewerfewfte4tf

', 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, '

asxdadsfc

', 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', '\r\n\r\n', '\r\n\r\n', '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 `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `lName` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `roleType` enum('admin','user') NOT NULL DEFAULT 'user', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `avatar` varchar(191) DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `two_factor_secret` text DEFAULT NULL, `two_factor_recovery_codes` text DEFAULT NULL, `two_factor_confirmed_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `lName`, `email`, `phone`, `roleType`, `status`, `avatar`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Test User', NULL, 'test@example.com', NULL, 'user', 'active', NULL, '2026-02-21 04:25:00', '$2y$12$FfCCLBcAYxx6/ws9oozR4uEPW20EXd/N817mujM3TjQGHnpJZH53G', NULL, NULL, NULL, NULL, '2026-02-21 04:25:00', '2026-02-21 04:25:00'), (3, 'dgfvdgdfg', NULL, 'mohsinsikder.cse@gmail.com', '01715486265', 'user', 'active', 'avatars/Ob19YbcCQtshMbc3njmeNVUzZxASAmuMLhpFgLf2.jpg', NULL, '$2y$12$hmOVBnfAMcWE5V8i6Vj/5uUhtFh4bRHgKJR/CqHobguAxS0Z0ghcK', NULL, NULL, NULL, NULL, '2026-03-06 06:22:32', '2026-03-06 06:25:23'); -- -------------------------------------------------------- -- -- 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 `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- 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 `email_configs` -- ALTER TABLE `email_configs` ADD PRIMARY KEY (`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 `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`), ADD KEY `personal_access_tokens_expires_at_index` (`expires_at`); -- -- 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 `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- 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 `email_configs` -- ALTER TABLE `email_configs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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 `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;