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

START TRANSACTION;



--
-- Database: `ecom`
--

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

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

CREATE TABLE `brands` (
  `id` bigint UNSIGNED NOT NULL,
  `brandName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `brandImg` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `brands` (`id`, `brandName`, `brandImg`, `created_at`, `updated_at`) VALUES
(1, 'ACI', 'https://via.placeholder.com/150?text=ACI', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(2, 'Square', 'https://via.placeholder.com/150?text=Square', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(3, 'Pran', 'https://via.placeholder.com/150?text=Pran', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(4, 'Beximco', 'https://via.placeholder.com/150?text=Beximco', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(5, 'Arong', 'https://via.placeholder.com/150?text=Arong', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(6, 'Bashundhara', 'https://via.placeholder.com/150?text=Bashundhara', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(7, 'Fresh', 'https://via.placeholder.com/150?text=Fresh', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(8, 'Teer', 'https://via.placeholder.com/150?text=Teer', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(9, 'Walton', 'https://via.placeholder.com/150?text=Walton', '2025-07-31 13:16:40', '2025-07-31 13:16:40'),
(10, 'Radhuni', 'https://via.placeholder.com/150?text=Radhuni', '2025-07-31 13:16:40', '2025-07-31 13:16:40');

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

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

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `categoryName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categoryImg` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `categoryName`, `categoryImg`, `created_at`, `updated_at`) VALUES
(1, 'Fashion', 'https://via.placeholder.com/150?text=Fashion', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(2, 'Electronics', 'https://via.placeholder.com/150?text=Electronics', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(3, 'Home Appliances', 'https://via.placeholder.com/150?text=Home+Appliances', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(4, 'Mobile & Tablet', 'https://via.placeholder.com/150?text=Mobile+%26+Tablet', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(5, 'Computer', 'https://via.placeholder.com/150?text=Computer', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(6, 'Sports', 'https://via.placeholder.com/150?text=Sports', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(7, 'Books', 'https://via.placeholder.com/150?text=Books', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(8, 'Beauty & Health', 'https://via.placeholder.com/150?text=Beauty+%26+Health', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(9, 'Office Supplies', 'https://via.placeholder.com/150?text=Office+Supplies', '2025-07-31 13:37:56', '2025-07-31 13:37:56'),
(10, 'Food & Drinks', 'https://via.placeholder.com/150?text=Food+%26+Drinks', '2025-07-31 13:37:56', '2025-07-31 13:37:56');

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

--
-- Table structure for table `customer_profiles`
--

CREATE TABLE `customer_profiles` (
  `id` bigint UNSIGNED NOT NULL,
  `cus_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_add` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_city` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_state` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_postcode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_country` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_phone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_fax` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_add` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_state` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_postcode` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_country` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_phone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_profiles`
--

INSERT INTO `customer_profiles` (`id`, `cus_name`, `cus_add`, `cus_city`, `cus_state`, `cus_postcode`, `cus_country`, `cus_phone`, `cus_fax`, `ship_name`, `ship_add`, `ship_city`, `ship_state`, `ship_postcode`, `ship_country`, `ship_phone`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Rahim Uddin Khan Udpate', 'House 12, Road 8, Dhanmondi', 'Dhaka', 'Dhaka', '1209', 'Bangladesh', '01712345678', '880-2-123456', 'Rahim Uddin', 'House 12, Road 8, Dhanmondi', 'Dhaka', 'Dhaka', '1209', 'Bangladesh', '01712345678', 1, '2025-07-31 14:04:10', '2025-08-01 08:38:33'),
(2, 'Fatema Khatun', 'Flat 5A, Block B, Mirpur', 'Dhaka', 'Dhaka', '1216', 'Bangladesh', '01898765432', '880-2-654321', 'Fatema Khatun', 'Flat 5A, Block B, Mirpur', 'Dhaka', 'Dhaka', '1216', 'Bangladesh', '01898765432', 2, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(3, 'Jahid Hasan', 'House 45, Road 7, Gulshan', 'Dhaka', 'Dhaka', '1212', 'Bangladesh', '01912349876', '880-2-789456', 'Jahid Hasan', 'House 45, Road 7, Gulshan', 'Dhaka', 'Dhaka', '1212', 'Bangladesh', '01912349876', 3, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(4, 'Anika Rahman', 'Flat 10, Block C, Banani', 'Dhaka', 'Dhaka', '1213', 'Bangladesh', '01711223344', '880-2-112233', 'Anika Rahman', 'Flat 10, Block C, Banani', 'Dhaka', 'Dhaka', '1213', 'Bangladesh', '01711223344', 4, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(5, 'Shuvo Sarker', 'House 23, Road 4, Motijheel', 'Dhaka', 'Dhaka', '1000', 'Bangladesh', '01844556677', '880-2-445566', 'Shuvo Sarker', 'House 23, Road 4, Motijheel', 'Dhaka', 'Dhaka', '1000', 'Bangladesh', '01844556677', 5, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(6, 'Nusrat Jahan', 'Road 2, Uttara', 'Dhaka', 'Dhaka', '1230', 'Bangladesh', '01988776655', '880-2-998877', 'Nusrat Jahan', 'Road 2, Uttara', 'Dhaka', 'Dhaka', '1230', 'Bangladesh', '01988776655', 6, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(7, 'Rifat Hossain', 'House 99, DIT Road, Mirpur', 'Dhaka', 'Dhaka', '1216', 'Bangladesh', '01766554433', '880-2-776655', 'Rifat Hossain', 'House 99, DIT Road, Mirpur', 'Dhaka', 'Dhaka', '1216', 'Bangladesh', '01766554433', 7, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(8, 'Maya Sultana', 'Flat 3B, Elephant Road', 'Dhaka', 'Dhaka', '1205', 'Bangladesh', '01899887766', '880-2-554433', 'Maya Sultana', 'Flat 3B, Elephant Road', 'Dhaka', 'Dhaka', '1205', 'Bangladesh', '01899887766', 8, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(9, 'Arif Chowdhury', 'House 5, West Panthapath', 'Dhaka', 'Dhaka', '1207', 'Bangladesh', '01733445566', '880-2-443322', 'Arif Chowdhury', 'House 5, West Panthapath', 'Dhaka', 'Dhaka', '1207', 'Bangladesh', '01733445566', 9, '2025-07-31 14:04:10', '2025-07-31 14:04:10'),
(10, 'Rahim', 'House 12, Road 8, Dhanmondi', 'Dhaka', 'Dhaka', '1209', 'Bangladesh', '01712345678', '880-2-123456', 'Rahim Uddin', 'House 12, Road 8, Dhanmondi', 'Dhaka', 'Dhaka', '1209', 'Bangladesh', '01712345678', 11, '2025-08-01 09:14:16', '2025-08-01 09:14:16');

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

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

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

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint UNSIGNED NOT NULL,
  `total` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vat` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payable` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cus_details` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_details` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tran_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `val_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `delivery_status` enum('Pending','Processing','Completed') COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`id`, `total`, `vat`, `payable`, `cus_details`, `ship_details`, `tran_id`, `val_id`, `delivery_status`, `payment_status`, `user_id`, `created_at`, `updated_at`) VALUES
(23, '9530', '285.9', '9815.9', 'Name:Rahim Uddin Khan Udpate,Address:House 12, Road 8, Dhanmondi,City:Dhaka,Phone: 01712345678', 'Name:Rahim Uddin,Address:House 12, Road 8, Dhanmondi ,City:Dhaka ,Phone: 01712345678', '688de264e9b32', '0', 'Pending', 'Success', 1, '2025-08-02 04:03:16', '2025-08-02 04:04:29'),
(24, '9530', '285.9', '9815.9', 'Name:Rahim Uddin Khan Udpate,Address:House 12, Road 8, Dhanmondi,City:Dhaka,Phone: 01712345678', 'Name:Rahim Uddin,Address:House 12, Road 8, Dhanmondi ,City:Dhaka ,Phone: 01712345678', '688de2e2d4eaa', '0', 'Pending', 'Fail', 1, '2025-08-02 04:05:22', '2025-08-02 04:05:44');

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

--
-- Table structure for table `invoice_products`
--

CREATE TABLE `invoice_products` (
  `id` bigint UNSIGNED NOT NULL,
  `invoice_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `qty` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sale_price` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_products`
--

INSERT INTO `invoice_products` (`id`, `invoice_id`, `product_id`, `user_id`, `qty`, `sale_price`, `created_at`, `updated_at`) VALUES
(13, 23, 2, 1, '5', '9530', '2025-08-02 04:03:16', '2025-08-02 04:03:16'),
(14, 24, 2, 1, '5', '9530', '2025-08-02 04:05:22', '2025-08-02 04:05:22');

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

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

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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_07_31_134330_create_customer_profiles_table', 1),
(5, '2025_07_31_134331_create_categories_table', 1),
(6, '2025_07_31_134332_create_brands_table', 1),
(7, '2025_07_31_134332_create_products_table', 1),
(8, '2025_07_31_134333_create_product_reviews_table', 1),
(9, '2025_07_31_134334_create_product_details_table', 1),
(10, '2025_07_31_134334_create_product_sliders_table', 1),
(11, '2025_07_31_134335_create_product_wishes_table', 1),
(12, '2025_07_31_134336_create_product_carts_table', 1),
(13, '2025_07_31_134337_create_sslcommerz_accounts_table', 1),
(14, '2025_07_31_134338_create_invoices_table', 1),
(15, '2025_07_31_134339_create_invoice_products_table', 1),
(17, '2025_07_31_134343_create_policies_table', 2),
(18, '2025_08_02_091306_create_personal_access_tokens_table', 3);

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

--
-- Table structure for table `policies`
--

CREATE TABLE `policies` (
  `id` bigint UNSIGNED NOT NULL,
  `type` enum('about','refund','terms','how to buy','contact','complain') COLLATE utf8mb4_unicode_ci NOT NULL,
  `des` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `policies`
--

INSERT INTO `policies` (`id`, `type`, `des`, `created_at`, `updated_at`) VALUES
(1, 'about', 'আমাদের প্রতিষ্ঠান বাংলাদেশের একটি শীর্ষস্থানীয় ই-কমার্স প্ল্যাটফর্ম। আমরা মানসম্মত পণ্য সরবরাহে অঙ্গীকারবদ্ধ।', '2025-07-31 13:30:19', '2025-07-31 13:30:19'),
(2, 'refund', 'যেকোনো ত্রুটিপূর্ণ পণ্যের জন্য ৭ কার্যদিবসের মধ্যে ফেরত নীতিমালা প্রযোজ্য। টাকা ফেরত পেতে পণ্যের আসল রসিদ প্রয়োজন হবে।', '2025-07-31 13:30:19', '2025-07-31 13:30:19'),
(3, 'terms', 'এই ওয়েবসাইট ব্যবহারে আপনি আমাদের শর্তাবলী মেনে নিচ্ছেন। অনুগ্রহ করে নিয়মিত শর্তাবলী পর্যালোচনা করুন।', '2025-07-31 13:30:19', '2025-07-31 13:30:19'),
(4, 'how to buy', 'পণ্য অর্ডার করতে আপনার একটি অ্যাকাউন্ট প্রয়োজন। পছন্দের পণ্য কার্টে যোগ করে অর্ডার সম্পন্ন করুন। ক্যাশ অন ডেলিভারি এবং মোবাইল ব্যাংকিং সুবিধা রয়েছে।', '2025-07-31 13:30:19', '2025-07-31 13:30:19'),
(5, 'contact', 'যোগাযোগ করুন: হটলাইন: ০১২৩৪-৫৬৭৮৯০, ইমেইল: support@example.com, ঠিকানা: ঢাকা, বাংলাদেশ।', '2025-07-31 13:30:19', '2025-07-31 13:30:19'),
(6, 'complain', 'আপনার অভিযোগ জানাতে আমাদের হটলাইন বা ইমেইলে যোগাযোগ করুন। প্রতিটি অভিযোগ গুরুত্বের সঙ্গে বিবেচনা করা হয়।', '2025-07-31 13:30:19', '2025-07-31 13:30:19');

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

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

CREATE TABLE `products` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_des` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount` tinyint(1) NOT NULL,
  `discount_price` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stock` tinyint(1) NOT NULL,
  `star` double NOT NULL,
  `remark` enum('popular','new','top','special','trending','regular') COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `brand_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `title`, `short_des`, `price`, `discount`, `discount_price`, `image`, `stock`, `star`, `remark`, `category_id`, `brand_id`, `created_at`, `updated_at`) VALUES
(1, 'Cane Chair', 'This is a high-quality Bangladeshi product.', '1828', 1, '1722', 'https://via.placeholder.com/200?text=Product+1', 1, 3.6, 'trending', 1, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(2, 'Muslin Cloth', 'This is a high-quality Bangladeshi product.', '1906', 0, '0', 'https://via.placeholder.com/200?text=Product+2', 0, 3.5, 'regular', 4, 1, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(3, 'Copperware', 'This is a high-quality Bangladeshi product.', '1870', 1, '1735', 'https://via.placeholder.com/200?text=Product+3', 1, 3.9, 'new', 4, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(4, 'Fish Sauce', 'This is a high-quality Bangladeshi product.', '619', 1, '523', 'https://via.placeholder.com/200?text=Product+4', 1, 4.5, 'top', 10, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(5, 'Pottery Bowl', 'This is a high-quality Bangladeshi product.', '4101', 1, '3846', 'https://via.placeholder.com/200?text=Product+5', 0, 4.9, 'regular', 8, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(6, 'Herbal Tea', 'This is a high-quality Bangladeshi product.', '874', 1, '824', 'https://via.placeholder.com/200?text=Product+6', 1, 3.3, 'trending', 4, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(7, 'Khadi Cotton Shirt', 'This is a high-quality Bangladeshi product.', '2097', 1, '1907', 'https://via.placeholder.com/200?text=Product+7', 1, 4, 'regular', 4, 1, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(8, 'Silver Jewelry', 'This is a high-quality Bangladeshi product.', '674', 1, '623', 'https://via.placeholder.com/200?text=Product+8', 1, 4.9, 'top', 5, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(9, 'Cinnamon Stick', 'This is a high-quality Bangladeshi product.', '1507', 1, '1356', 'https://via.placeholder.com/200?text=Product+9', 1, 4.5, 'new', 3, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(10, 'Organic Rice', 'This is a high-quality Bangladeshi product.', '1154', 1, '999', 'https://via.placeholder.com/200?text=Product+10', 0, 4.2, 'trending', 5, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(11, 'Gold Earrings', 'This is a high-quality Bangladeshi product.', '4616', 0, '0', 'https://via.placeholder.com/200?text=Product+11', 0, 3, 'top', 7, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(12, 'Salted Fish', 'This is a high-quality Bangladeshi product.', '1514', 0, '0', 'https://via.placeholder.com/200?text=Product+12', 0, 4.2, 'top', 7, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(13, 'Dhakai Topi', 'This is a high-quality Bangladeshi product.', '2580', 1, '2387', 'https://via.placeholder.com/200?text=Product+13', 1, 3.9, 'special', 8, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(14, 'Traditional Clay Oven', 'This is a high-quality Bangladeshi product.', '1530', 1, '1448', 'https://via.placeholder.com/200?text=Product+14', 1, 4.5, 'popular', 1, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(15, 'Traditional Clay Oven', 'This is a high-quality Bangladeshi product.', '1748', 0, '0', 'https://via.placeholder.com/200?text=Product+15', 1, 4.1, 'special', 9, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(16, 'Sandalwood Perfume', 'This is a high-quality Bangladeshi product.', '1865', 1, '1589', 'https://via.placeholder.com/200?text=Product+16', 1, 4.4, 'new', 10, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(17, 'Spiced Tea', 'This is a high-quality Bangladeshi product.', '3997', 1, '3706', 'https://via.placeholder.com/200?text=Product+17', 0, 4.1, 'new', 8, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(18, 'Silk Fabric', 'This is a high-quality Bangladeshi product.', '3893', 1, '3785', 'https://via.placeholder.com/200?text=Product+18', 1, 4.9, 'special', 3, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(19, 'Traditional Mask', 'This is a high-quality Bangladeshi product.', '4086', 0, '0', 'https://via.placeholder.com/200?text=Product+19', 1, 4.3, 'special', 3, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(20, 'Mango Jam', 'This is a high-quality Bangladeshi product.', '4756', 1, '4532', 'https://via.placeholder.com/200?text=Product+20', 1, 3.6, 'special', 1, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(21, 'Handwoven Carpet', 'This is a high-quality Bangladeshi product.', '550', 0, '0', 'https://via.placeholder.com/200?text=Product+21', 0, 4, 'top', 9, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(22, 'Bamboo Pen Stand', 'This is a high-quality Bangladeshi product.', '1596', 0, '0', 'https://via.placeholder.com/200?text=Product+22', 0, 3.1, 'regular', 3, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(23, 'Silver Necklace', 'This is a high-quality Bangladeshi product.', '1573', 0, '0', 'https://via.placeholder.com/200?text=Product+23', 0, 4.4, 'popular', 10, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(24, 'Dhakai Topi', 'This is a high-quality Bangladeshi product.', '839', 1, '673', 'https://via.placeholder.com/200?text=Product+24', 1, 3.7, 'trending', 10, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(25, 'Palm Sugar', 'This is a high-quality Bangladeshi product.', '1499', 0, '0', 'https://via.placeholder.com/200?text=Product+25', 1, 3.8, 'regular', 5, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(26, 'Clove', 'This is a high-quality Bangladeshi product.', '3509', 1, '3398', 'https://via.placeholder.com/200?text=Product+26', 1, 4.3, 'regular', 1, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(27, 'Clay Pottery', 'This is a high-quality Bangladeshi product.', '1614', 1, '1485', 'https://via.placeholder.com/200?text=Product+27', 0, 4.5, 'new', 9, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(28, 'Cinnamon Stick', 'This is a high-quality Bangladeshi product.', '2391', 1, '2238', 'https://via.placeholder.com/200?text=Product+28', 0, 3.6, 'new', 7, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(29, 'Handmade Soap Bar', 'This is a high-quality Bangladeshi product.', '4768', 0, '0', 'https://via.placeholder.com/200?text=Product+29', 1, 3.9, 'regular', 6, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(30, 'Traditional Drum', 'This is a high-quality Bangladeshi product.', '3661', 1, '3595', 'https://via.placeholder.com/200?text=Product+30', 1, 3.5, 'special', 10, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(31, 'Sandalwood Beads', 'This is a high-quality Bangladeshi product.', '4339', 1, '4076', 'https://via.placeholder.com/200?text=Product+31', 1, 3.3, 'trending', 7, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(32, 'Cotton Towels', 'This is a high-quality Bangladeshi product.', '4794', 1, '4687', 'https://via.placeholder.com/200?text=Product+32', 1, 3, 'popular', 4, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(33, 'Mango Juice', 'This is a high-quality Bangladeshi product.', '4029', 1, '3800', 'https://via.placeholder.com/200?text=Product+33', 1, 4.5, 'popular', 9, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(34, 'Betel Leaf', 'This is a high-quality Bangladeshi product.', '3441', 0, '0', 'https://via.placeholder.com/200?text=Product+34', 0, 4.8, 'top', 3, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(35, 'Banana Chips', 'This is a high-quality Bangladeshi product.', '978', 1, '925', 'https://via.placeholder.com/200?text=Product+35', 1, 4.9, 'regular', 2, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(36, 'Cotton Towels', 'This is a high-quality Bangladeshi product.', '4741', 0, '0', 'https://via.placeholder.com/200?text=Product+36', 1, 4.8, 'special', 2, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(37, 'Fish Oil', 'This is a high-quality Bangladeshi product.', '2625', 0, '0', 'https://via.placeholder.com/200?text=Product+37', 0, 4.6, 'top', 4, 1, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(38, 'Mango Juice', 'This is a high-quality Bangladeshi product.', '3303', 0, '0', 'https://via.placeholder.com/200?text=Product+38', 1, 3.8, 'new', 8, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(39, 'Betel Leaf', 'This is a high-quality Bangladeshi product.', '751', 1, '614', 'https://via.placeholder.com/200?text=Product+39', 0, 4.6, 'new', 4, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(40, 'Pottery Bowl', 'This is a high-quality Bangladeshi product.', '1215', 1, '1035', 'https://via.placeholder.com/200?text=Product+40', 0, 4, 'new', 4, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(41, 'Mustard Seeds', 'This is a high-quality Bangladeshi product.', '2108', 0, '0', 'https://via.placeholder.com/200?text=Product+41', 1, 4.9, 'trending', 8, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(42, 'Handmade Soap Bar', 'This is a high-quality Bangladeshi product.', '3721', 0, '0', 'https://via.placeholder.com/200?text=Product+42', 1, 4.4, 'new', 3, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(43, 'Sesame Seeds', 'This is a high-quality Bangladeshi product.', '1150', 1, '939', 'https://via.placeholder.com/200?text=Product+43', 0, 4.3, 'new', 1, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(44, 'Handmade Diary', 'This is a high-quality Bangladeshi product.', '1150', 1, '956', 'https://via.placeholder.com/200?text=Product+44', 1, 3.8, 'popular', 8, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(45, 'Fish Oil', 'This is a high-quality Bangladeshi product.', '4001', 0, '0', 'https://via.placeholder.com/200?text=Product+45', 0, 4.5, 'regular', 2, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(46, 'Muslin Cloth', 'This is a high-quality Bangladeshi product.', '3233', 0, '0', 'https://via.placeholder.com/200?text=Product+46', 1, 4.1, 'top', 2, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(47, 'Pottery Bowl', 'This is a high-quality Bangladeshi product.', '2710', 0, '0', 'https://via.placeholder.com/200?text=Product+47', 1, 3.7, 'trending', 4, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(48, 'Sandalwood Perfume', 'This is a high-quality Bangladeshi product.', '754', 1, '693', 'https://via.placeholder.com/200?text=Product+48', 1, 5, 'special', 7, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(49, 'Traditional Clay Oven', 'This is a high-quality Bangladeshi product.', '4351', 0, '0', 'https://via.placeholder.com/200?text=Product+49', 1, 4.8, 'special', 9, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(50, 'Clay Lamp', 'This is a high-quality Bangladeshi product.', '1822', 0, '0', 'https://via.placeholder.com/200?text=Product+50', 1, 4.6, 'special', 8, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(51, 'Traditional Music Instrument', 'This is a high-quality Bangladeshi product.', '2411', 0, '0', 'https://via.placeholder.com/200?text=Product+51', 0, 3.8, 'popular', 7, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(52, 'Coconut Shell Bowl', 'This is a high-quality Bangladeshi product.', '4460', 1, '4404', 'https://via.placeholder.com/200?text=Product+52', 0, 4.2, 'new', 6, 1, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(53, 'Terracotta Items', 'This is a high-quality Bangladeshi product.', '3805', 1, '3643', 'https://via.placeholder.com/200?text=Product+53', 0, 4.3, 'popular', 2, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(54, 'Clay Lamp', 'This is a high-quality Bangladeshi product.', '3183', 1, '3079', 'https://via.placeholder.com/200?text=Product+54', 1, 4.8, 'special', 7, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(55, 'Mango Pickle', 'This is a high-quality Bangladeshi product.', '4299', 0, '0', 'https://via.placeholder.com/200?text=Product+55', 1, 3, 'new', 3, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(56, 'Handmade Soap', 'This is a high-quality Bangladeshi product.', '1160', 1, '1009', 'https://via.placeholder.com/200?text=Product+56', 0, 3.2, 'top', 10, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(57, 'Spices Mix', 'This is a high-quality Bangladeshi product.', '3513', 1, '3375', 'https://via.placeholder.com/200?text=Product+57', 0, 4.3, 'special', 8, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(58, 'Coconut Oil', 'This is a high-quality Bangladeshi product.', '3830', 1, '3690', 'https://via.placeholder.com/200?text=Product+58', 1, 4.1, 'trending', 5, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(59, 'Khadi Cotton Shirt', 'This is a high-quality Bangladeshi product.', '2855', 0, '0', 'https://via.placeholder.com/200?text=Product+59', 0, 4.4, 'new', 10, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(60, 'Salted Fish', 'This is a high-quality Bangladeshi product.', '4866', 0, '0', 'https://via.placeholder.com/200?text=Product+60', 1, 3.4, 'new', 7, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(61, 'Organic Rice', 'This is a high-quality Bangladeshi product.', '4941', 1, '4868', 'https://via.placeholder.com/200?text=Product+61', 1, 3.6, 'regular', 5, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(62, 'Organic Tea Leaves', 'This is a high-quality Bangladeshi product.', '3439', 1, '3226', 'https://via.placeholder.com/200?text=Product+62', 0, 3.8, 'new', 6, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(63, 'Handwoven Mat', 'This is a high-quality Bangladeshi product.', '4212', 1, '3941', 'https://via.placeholder.com/200?text=Product+63', 1, 3.2, 'top', 7, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(64, 'Rice Flour', 'This is a high-quality Bangladeshi product.', '1669', 0, '0', 'https://via.placeholder.com/200?text=Product+64', 1, 4.4, 'trending', 5, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(65, 'Spiced Tea', 'This is a high-quality Bangladeshi product.', '1138', 0, '0', 'https://via.placeholder.com/200?text=Product+65', 1, 4, 'new', 1, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(66, 'Pottery Bowl', 'This is a high-quality Bangladeshi product.', '1485', 0, '0', 'https://via.placeholder.com/200?text=Product+66', 0, 3.6, 'regular', 7, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(67, 'Henna Powder', 'This is a high-quality Bangladeshi product.', '3961', 1, '3716', 'https://via.placeholder.com/200?text=Product+67', 1, 5, 'regular', 5, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(68, 'Cane Chair', 'This is a high-quality Bangladeshi product.', '2007', 1, '1715', 'https://via.placeholder.com/200?text=Product+68', 0, 4.7, 'new', 3, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(69, 'Mango Pickle', 'This is a high-quality Bangladeshi product.', '1379', 1, '1166', 'https://via.placeholder.com/200?text=Product+69', 1, 4.5, 'trending', 5, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(70, 'Chili Powder', 'This is a high-quality Bangladeshi product.', '1322', 0, '0', 'https://via.placeholder.com/200?text=Product+70', 1, 3.2, 'special', 7, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(71, 'Jute Rug', 'This is a high-quality Bangladeshi product.', '1483', 1, '1338', 'https://via.placeholder.com/200?text=Product+71', 0, 4.8, 'trending', 6, 1, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(72, 'Spices Mix', 'This is a high-quality Bangladeshi product.', '2845', 0, '0', 'https://via.placeholder.com/200?text=Product+72', 1, 3, 'special', 4, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(73, 'Traditional Mask', 'This is a high-quality Bangladeshi product.', '556', 1, '382', 'https://via.placeholder.com/200?text=Product+73', 0, 5, 'popular', 6, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(74, 'Handmade Soap', 'This is a high-quality Bangladeshi product.', '4668', 1, '4444', 'https://via.placeholder.com/200?text=Product+74', 1, 5, 'popular', 2, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(75, 'Jamdani Saree', 'This is a high-quality Bangladeshi product.', '4637', 0, '0', 'https://via.placeholder.com/200?text=Product+75', 0, 4.9, 'trending', 2, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(76, 'Mango Pickle', 'This is a high-quality Bangladeshi product.', '4193', 0, '0', 'https://via.placeholder.com/200?text=Product+76', 0, 4.6, 'new', 5, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(77, 'Silver Bracelet', 'This is a high-quality Bangladeshi product.', '3894', 1, '3656', 'https://via.placeholder.com/200?text=Product+77', 1, 3.2, 'trending', 4, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(78, 'Mango Pickle', 'This is a high-quality Bangladeshi product.', '1550', 0, '0', 'https://via.placeholder.com/200?text=Product+78', 0, 3.3, 'top', 1, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(79, 'Organic Tea Leaves', 'This is a high-quality Bangladeshi product.', '3954', 1, '3836', 'https://via.placeholder.com/200?text=Product+79', 1, 3.8, 'new', 9, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(80, 'Organic Honey', 'This is a high-quality Bangladeshi product.', '2882', 0, '0', 'https://via.placeholder.com/200?text=Product+80', 1, 4.8, 'trending', 6, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(81, 'Mango Pickle', 'This is a high-quality Bangladeshi product.', '2859', 1, '2627', 'https://via.placeholder.com/200?text=Product+81', 1, 4.1, 'trending', 10, 1, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(82, 'Spiced Tea', 'This is a high-quality Bangladeshi product.', '2967', 1, '2915', 'https://via.placeholder.com/200?text=Product+82', 1, 4.9, 'special', 10, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(83, 'Traditional Sweets', 'This is a high-quality Bangladeshi product.', '3684', 0, '0', 'https://via.placeholder.com/200?text=Product+83', 1, 3.6, 'top', 8, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(84, 'Sesame Seeds', 'This is a high-quality Bangladeshi product.', '4010', 1, '3919', 'https://via.placeholder.com/200?text=Product+84', 1, 4.9, 'top', 5, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(85, 'Black Tea', 'This is a high-quality Bangladeshi product.', '1015', 1, '853', 'https://via.placeholder.com/200?text=Product+85', 0, 4.5, 'popular', 9, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(86, 'Gold Earrings', 'This is a high-quality Bangladeshi product.', '2396', 1, '2255', 'https://via.placeholder.com/200?text=Product+86', 1, 4.8, 'top', 8, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(87, 'Pottery Bowl', 'This is a high-quality Bangladeshi product.', '4526', 1, '4260', 'https://via.placeholder.com/200?text=Product+87', 0, 3.4, 'new', 1, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(88, 'Rose Water', 'This is a high-quality Bangladeshi product.', '1199', 0, '0', 'https://via.placeholder.com/200?text=Product+88', 0, 3.3, 'regular', 5, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(89, 'Jackfruit Chips', 'This is a high-quality Bangladeshi product.', '4486', 1, '4217', 'https://via.placeholder.com/200?text=Product+89', 0, 3.5, 'top', 6, 2, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(90, 'Mango Pickle', 'This is a high-quality Bangladeshi product.', '4035', 1, '3833', 'https://via.placeholder.com/200?text=Product+90', 1, 4.2, 'special', 1, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(91, 'Curry Leaves', 'This is a high-quality Bangladeshi product.', '4855', 1, '4561', 'https://via.placeholder.com/200?text=Product+91', 1, 3.3, 'trending', 9, 6, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(92, 'Curry Leaves', 'This is a high-quality Bangladeshi product.', '4612', 0, '0', 'https://via.placeholder.com/200?text=Product+92', 1, 3.9, 'new', 9, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(93, 'Palm Leaf Plate', 'This is a high-quality Bangladeshi product.', '1532', 0, '0', 'https://via.placeholder.com/200?text=Product+93', 0, 3, 'popular', 5, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(94, 'Jamdani Saree', 'This is a high-quality Bangladeshi product.', '2753', 1, '2482', 'https://via.placeholder.com/200?text=Product+94', 1, 3.4, 'special', 9, 5, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(95, 'Betel Leaf', 'This is a high-quality Bangladeshi product.', '2160', 1, '1986', 'https://via.placeholder.com/200?text=Product+95', 0, 4.5, 'new', 3, 4, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(96, 'Spiced Tea', 'This is a high-quality Bangladeshi product.', '3349', 1, '3100', 'https://via.placeholder.com/200?text=Product+96', 1, 3.4, 'popular', 10, 7, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(97, 'Salted Fish', 'This is a high-quality Bangladeshi product.', '609', 0, '0', 'https://via.placeholder.com/200?text=Product+97', 1, 3.1, 'regular', 4, 3, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(98, 'Spices Mix', 'This is a high-quality Bangladeshi product.', '3728', 1, '3677', 'https://via.placeholder.com/200?text=Product+98', 1, 4.3, 'trending', 1, 10, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(99, 'Rice Noodles', 'This is a high-quality Bangladeshi product.', '834', 1, '706', 'https://via.placeholder.com/200?text=Product+99', 0, 3.7, 'regular', 10, 9, '2025-08-01 04:17:58', '2025-08-01 04:17:58'),
(100, 'Mango Juice', 'This is a high-quality Bangladeshi product.', '3041', 1, '2775', 'https://via.placeholder.com/200?text=Product+100', 0, 5, 'popular', 9, 8, '2025-08-01 04:17:58', '2025-08-01 04:17:58');

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

--
-- Table structure for table `product_carts`
--

CREATE TABLE `product_carts` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `color` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `qty` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_carts`
--

INSERT INTO `product_carts` (`id`, `user_id`, `product_id`, `color`, `size`, `qty`, `price`, `created_at`, `updated_at`) VALUES
(2, 1, 2, 'Red', 'X', '5', '9530', '2025-08-01 12:04:52', '2025-08-01 12:04:52');

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

--
-- Table structure for table `product_details`
--

CREATE TABLE `product_details` (
  `id` bigint UNSIGNED NOT NULL,
  `img1` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img2` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img3` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img4` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `des` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_details`
--

INSERT INTO `product_details` (`id`, `img1`, `img2`, `img3`, `img4`, `des`, `color`, `size`, `product_id`, `created_at`, `updated_at`) VALUES
(2, 'https://picsum.photos/seed/img1_1/400/400', 'https://picsum.photos/seed/img2_1/400/400', 'https://picsum.photos/seed/img3_1/400/400', 'https://picsum.photos/seed/img4_1/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Green', 'XXL', 1, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(3, 'https://picsum.photos/seed/img1_2/400/400', 'https://picsum.photos/seed/img2_2/400/400', 'https://picsum.photos/seed/img3_2/400/400', 'https://picsum.photos/seed/img4_2/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'L', 2, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(4, 'https://picsum.photos/seed/img1_3/400/400', 'https://picsum.photos/seed/img2_3/400/400', 'https://picsum.photos/seed/img3_3/400/400', 'https://picsum.photos/seed/img4_3/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'White', 'XL', 3, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(5, 'https://picsum.photos/seed/img1_4/400/400', 'https://picsum.photos/seed/img2_4/400/400', 'https://picsum.photos/seed/img3_4/400/400', 'https://picsum.photos/seed/img4_4/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'XXL', 4, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(6, 'https://picsum.photos/seed/img1_5/400/400', 'https://picsum.photos/seed/img2_5/400/400', 'https://picsum.photos/seed/img3_5/400/400', 'https://picsum.photos/seed/img4_5/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'White', 'S', 5, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(7, 'https://picsum.photos/seed/img1_6/400/400', 'https://picsum.photos/seed/img2_6/400/400', 'https://picsum.photos/seed/img3_6/400/400', 'https://picsum.photos/seed/img4_6/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'L', 6, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(8, 'https://picsum.photos/seed/img1_7/400/400', 'https://picsum.photos/seed/img2_7/400/400', 'https://picsum.photos/seed/img3_7/400/400', 'https://picsum.photos/seed/img4_7/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Red', 'M', 7, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(9, 'https://picsum.photos/seed/img1_8/400/400', 'https://picsum.photos/seed/img2_8/400/400', 'https://picsum.photos/seed/img3_8/400/400', 'https://picsum.photos/seed/img4_8/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Blue', 'S', 8, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(10, 'https://picsum.photos/seed/img1_9/400/400', 'https://picsum.photos/seed/img2_9/400/400', 'https://picsum.photos/seed/img3_9/400/400', 'https://picsum.photos/seed/img4_9/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'S', 9, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(11, 'https://picsum.photos/seed/img1_10/400/400', 'https://picsum.photos/seed/img2_10/400/400', 'https://picsum.photos/seed/img3_10/400/400', 'https://picsum.photos/seed/img4_10/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'L', 10, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(12, 'https://picsum.photos/seed/img1_11/400/400', 'https://picsum.photos/seed/img2_11/400/400', 'https://picsum.photos/seed/img3_11/400/400', 'https://picsum.photos/seed/img4_11/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Blue', 'XL', 11, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(13, 'https://picsum.photos/seed/img1_12/400/400', 'https://picsum.photos/seed/img2_12/400/400', 'https://picsum.photos/seed/img3_12/400/400', 'https://picsum.photos/seed/img4_12/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'XXL', 12, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(14, 'https://picsum.photos/seed/img1_13/400/400', 'https://picsum.photos/seed/img2_13/400/400', 'https://picsum.photos/seed/img3_13/400/400', 'https://picsum.photos/seed/img4_13/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Black', 'L', 13, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(15, 'https://picsum.photos/seed/img1_14/400/400', 'https://picsum.photos/seed/img2_14/400/400', 'https://picsum.photos/seed/img3_14/400/400', 'https://picsum.photos/seed/img4_14/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'S', 14, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(16, 'https://picsum.photos/seed/img1_15/400/400', 'https://picsum.photos/seed/img2_15/400/400', 'https://picsum.photos/seed/img3_15/400/400', 'https://picsum.photos/seed/img4_15/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Red', 'M', 15, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(17, 'https://picsum.photos/seed/img1_16/400/400', 'https://picsum.photos/seed/img2_16/400/400', 'https://picsum.photos/seed/img3_16/400/400', 'https://picsum.photos/seed/img4_16/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'S', 16, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(18, 'https://picsum.photos/seed/img1_17/400/400', 'https://picsum.photos/seed/img2_17/400/400', 'https://picsum.photos/seed/img3_17/400/400', 'https://picsum.photos/seed/img4_17/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'XL', 17, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(19, 'https://picsum.photos/seed/img1_18/400/400', 'https://picsum.photos/seed/img2_18/400/400', 'https://picsum.photos/seed/img3_18/400/400', 'https://picsum.photos/seed/img4_18/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Black', 'S', 18, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(20, 'https://picsum.photos/seed/img1_19/400/400', 'https://picsum.photos/seed/img2_19/400/400', 'https://picsum.photos/seed/img3_19/400/400', 'https://picsum.photos/seed/img4_19/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'White', 'M', 19, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(21, 'https://picsum.photos/seed/img1_20/400/400', 'https://picsum.photos/seed/img2_20/400/400', 'https://picsum.photos/seed/img3_20/400/400', 'https://picsum.photos/seed/img4_20/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'S', 20, '2025-08-01 10:17:58', '2025-08-01 10:17:58'),
(22, 'https://picsum.photos/seed/img1_21/400/400', 'https://picsum.photos/seed/img2_21/400/400', 'https://picsum.photos/seed/img3_21/400/400', 'https://picsum.photos/seed/img4_21/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'XL', 21, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(23, 'https://picsum.photos/seed/img1_22/400/400', 'https://picsum.photos/seed/img2_22/400/400', 'https://picsum.photos/seed/img3_22/400/400', 'https://picsum.photos/seed/img4_22/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'M', 22, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(24, 'https://picsum.photos/seed/img1_23/400/400', 'https://picsum.photos/seed/img2_23/400/400', 'https://picsum.photos/seed/img3_23/400/400', 'https://picsum.photos/seed/img4_23/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Red', 'S', 23, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(25, 'https://picsum.photos/seed/img1_24/400/400', 'https://picsum.photos/seed/img2_24/400/400', 'https://picsum.photos/seed/img3_24/400/400', 'https://picsum.photos/seed/img4_24/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'S', 24, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(26, 'https://picsum.photos/seed/img1_25/400/400', 'https://picsum.photos/seed/img2_25/400/400', 'https://picsum.photos/seed/img3_25/400/400', 'https://picsum.photos/seed/img4_25/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'XL', 25, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(27, 'https://picsum.photos/seed/img1_26/400/400', 'https://picsum.photos/seed/img2_26/400/400', 'https://picsum.photos/seed/img3_26/400/400', 'https://picsum.photos/seed/img4_26/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'M', 26, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(28, 'https://picsum.photos/seed/img1_27/400/400', 'https://picsum.photos/seed/img2_27/400/400', 'https://picsum.photos/seed/img3_27/400/400', 'https://picsum.photos/seed/img4_27/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Green', 'S', 27, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(29, 'https://picsum.photos/seed/img1_28/400/400', 'https://picsum.photos/seed/img2_28/400/400', 'https://picsum.photos/seed/img3_28/400/400', 'https://picsum.photos/seed/img4_28/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Black', 'XL', 28, '2025-08-01 10:17:59', '2025-08-01 10:17:59'),
(30, 'https://picsum.photos/seed/img1_29/400/400', 'https://picsum.photos/seed/img2_29/400/400', 'https://picsum.photos/seed/img3_29/400/400', 'https://picsum.photos/seed/img4_29/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'White', 'S', 29, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(31, 'https://picsum.photos/seed/img1_30/400/400', 'https://picsum.photos/seed/img2_30/400/400', 'https://picsum.photos/seed/img3_30/400/400', 'https://picsum.photos/seed/img4_30/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'XL', 30, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(32, 'https://picsum.photos/seed/img1_31/400/400', 'https://picsum.photos/seed/img2_31/400/400', 'https://picsum.photos/seed/img3_31/400/400', 'https://picsum.photos/seed/img4_31/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'S', 31, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(33, 'https://picsum.photos/seed/img1_32/400/400', 'https://picsum.photos/seed/img2_32/400/400', 'https://picsum.photos/seed/img3_32/400/400', 'https://picsum.photos/seed/img4_32/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'L', 32, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(34, 'https://picsum.photos/seed/img1_33/400/400', 'https://picsum.photos/seed/img2_33/400/400', 'https://picsum.photos/seed/img3_33/400/400', 'https://picsum.photos/seed/img4_33/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'S', 33, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(35, 'https://picsum.photos/seed/img1_34/400/400', 'https://picsum.photos/seed/img2_34/400/400', 'https://picsum.photos/seed/img3_34/400/400', 'https://picsum.photos/seed/img4_34/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Green', 'XXL', 34, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(36, 'https://picsum.photos/seed/img1_35/400/400', 'https://picsum.photos/seed/img2_35/400/400', 'https://picsum.photos/seed/img3_35/400/400', 'https://picsum.photos/seed/img4_35/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Black', 'XL', 35, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(37, 'https://picsum.photos/seed/img1_36/400/400', 'https://picsum.photos/seed/img2_36/400/400', 'https://picsum.photos/seed/img3_36/400/400', 'https://picsum.photos/seed/img4_36/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'XXL', 36, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(38, 'https://picsum.photos/seed/img1_37/400/400', 'https://picsum.photos/seed/img2_37/400/400', 'https://picsum.photos/seed/img3_37/400/400', 'https://picsum.photos/seed/img4_37/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Red', 'L', 37, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(39, 'https://picsum.photos/seed/img1_38/400/400', 'https://picsum.photos/seed/img2_38/400/400', 'https://picsum.photos/seed/img3_38/400/400', 'https://picsum.photos/seed/img4_38/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Green', 'S', 38, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(40, 'https://picsum.photos/seed/img1_39/400/400', 'https://picsum.photos/seed/img2_39/400/400', 'https://picsum.photos/seed/img3_39/400/400', 'https://picsum.photos/seed/img4_39/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Black', 'S', 39, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(41, 'https://picsum.photos/seed/img1_40/400/400', 'https://picsum.photos/seed/img2_40/400/400', 'https://picsum.photos/seed/img3_40/400/400', 'https://picsum.photos/seed/img4_40/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'S', 40, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(42, 'https://picsum.photos/seed/img1_41/400/400', 'https://picsum.photos/seed/img2_41/400/400', 'https://picsum.photos/seed/img3_41/400/400', 'https://picsum.photos/seed/img4_41/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'White', 'XXL', 41, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(43, 'https://picsum.photos/seed/img1_42/400/400', 'https://picsum.photos/seed/img2_42/400/400', 'https://picsum.photos/seed/img3_42/400/400', 'https://picsum.photos/seed/img4_42/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Red', 'L', 42, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(44, 'https://picsum.photos/seed/img1_43/400/400', 'https://picsum.photos/seed/img2_43/400/400', 'https://picsum.photos/seed/img3_43/400/400', 'https://picsum.photos/seed/img4_43/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Yellow', 'S', 43, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(45, 'https://picsum.photos/seed/img1_44/400/400', 'https://picsum.photos/seed/img2_44/400/400', 'https://picsum.photos/seed/img3_44/400/400', 'https://picsum.photos/seed/img4_44/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Orange', 'S', 44, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(46, 'https://picsum.photos/seed/img1_45/400/400', 'https://picsum.photos/seed/img2_45/400/400', 'https://picsum.photos/seed/img3_45/400/400', 'https://picsum.photos/seed/img4_45/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Green', 'L', 45, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(47, 'https://picsum.photos/seed/img1_46/400/400', 'https://picsum.photos/seed/img2_46/400/400', 'https://picsum.photos/seed/img3_46/400/400', 'https://picsum.photos/seed/img4_46/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Black', 'XXL', 46, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(48, 'https://picsum.photos/seed/img1_47/400/400', 'https://picsum.photos/seed/img2_47/400/400', 'https://picsum.photos/seed/img3_47/400/400', 'https://picsum.photos/seed/img4_47/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Blue', 'S', 47, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(49, 'https://picsum.photos/seed/img1_48/400/400', 'https://picsum.photos/seed/img2_48/400/400', 'https://picsum.photos/seed/img3_48/400/400', 'https://picsum.photos/seed/img4_48/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Green', 'XL', 48, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(50, 'https://picsum.photos/seed/img1_49/400/400', 'https://picsum.photos/seed/img2_49/400/400', 'https://picsum.photos/seed/img3_49/400/400', 'https://picsum.photos/seed/img4_49/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Black', 'M', 49, '2025-08-01 10:18:00', '2025-08-01 10:18:00'),
(51, 'https://picsum.photos/seed/img1_50/400/400', 'https://picsum.photos/seed/img2_50/400/400', 'https://picsum.photos/seed/img3_50/400/400', 'https://picsum.photos/seed/img4_50/400/400', 'This is a high-quality product made in Bangladesh. It is affordable and durable, offering long-lasting performance for everyday use.', 'Blue', 'S', 50, '2025-08-01 10:18:00', '2025-08-01 10:18:00');

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

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

CREATE TABLE `product_reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `description` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_reviews`
--

INSERT INTO `product_reviews` (`id`, `description`, `rating`, `customer_id`, `product_id`, `created_at`, `updated_at`) VALUES
(1, 'Hello Great quality saree, very comfortable and looks elegant. Highly recommended!', '4.5', 1, 1, '2025-08-01 10:35:35', '2025-08-01 09:09:57'),
(2, 'The Jamdani design is beautiful. Delivery was fast and packaging was good.', '5.0', 2, 2, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(3, 'Rice is aromatic and cooks perfectly. Will buy again.', '4.0', 3, 3, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(4, 'Salt is fine and dissolves easily. Good for daily use.', '4.2', 4, 4, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(5, 'Wallet is made of genuine leather. Very stylish and compact.', '4.7', 5, 5, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(6, 'Excellent picture quality and sound. Perfect for a small room.', '4.8', 6, 6, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(7, 'Refreshing mango taste. Perfect drink for summer.', '4.3', 7, 7, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(8, 'Chair is strong and durable. Suitable for both indoor and outdoor use.', '4.0', 8, 8, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(9, 'Fan is powerful and runs silently. Very energy efficient.', '4.6', 9, 9, '2025-08-01 10:35:35', '2025-08-01 10:35:35'),
(11, 'Highly recommended!', '4.5', 10, 1, '2025-08-01 09:14:25', '2025-08-01 09:14:51');

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

--
-- Table structure for table `product_sliders`
--

CREATE TABLE `product_sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_des` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_sliders`
--

INSERT INTO `product_sliders` (`id`, `title`, `short_des`, `price`, `image`, `product_id`, `created_at`, `updated_at`) VALUES
(1, 'Bangladeshi Cotton Saree', 'Traditional handloom cotton saree, comfortable for daily wear.', '1200 BDT', 'https://picsum.photos/seed/saree/400/400', 1, '2025-08-01 10:27:45', '2025-08-01 10:27:45'),
(2, 'Jamdani Saree', 'Authentic Jamdani saree from Narayanganj, perfect for festivals.', '3500 BDT', 'https://picsum.photos/seed/jamdani/400/400', 2, '2025-08-01 10:27:45', '2025-08-01 10:27:45'),
(3, 'Panjeri Basmati Rice (5kg)', 'Premium quality aromatic basmati rice, ideal for biryani.', '750 BDT', 'https://picsum.photos/seed/rice/400/400', 3, '2025-08-01 10:27:45', '2025-08-01 10:27:45'),
(4, 'ACI Pure Salt (1kg)', 'Iodized salt from ACI, essential for daily cooking.', '35 BDT', 'https://picsum.photos/seed/salt/400/400', 4, '2025-08-01 10:27:46', '2025-08-01 10:27:46'),
(5, 'Bengal Leather Wallet', 'Genuine leather wallet made in Bangladesh, sleek and durable.', '500 BDT', 'https://picsum.photos/seed/wallet/400/400', 5, '2025-08-01 10:27:46', '2025-08-01 10:27:46'),
(6, 'Walton Smart TV 32\"', '32-inch HD Smart TV by Walton with Wi-Fi and YouTube support.', '18000 BDT', 'https://picsum.photos/seed/tv/400/400', 6, '2025-08-01 10:27:46', '2025-08-01 10:27:46'),
(7, 'Pran Mango Juice (1L)', 'Refreshing mango drink from Pran, no added preservatives.', '90 BDT', 'https://picsum.photos/seed/juice/400/400', 7, '2025-08-01 10:27:46', '2025-08-01 10:27:46'),
(8, 'RFL Plastic Chair', 'Durable and lightweight plastic chair for home or office use.', '850 BDT', 'https://picsum.photos/seed/chair/400/400', 8, '2025-08-01 10:27:46', '2025-08-01 10:27:46'),
(9, 'Nitol Fan 16\"', 'High-speed ceiling fan with energy-saving technology.', '2500 BDT', 'https://picsum.photos/seed/fan/400/400', 9, '2025-08-01 10:27:46', '2025-08-01 10:27:46'),
(10, 'Teer Soybean Oil (1L)', 'Refined soybean oil ideal for healthy cooking.', '160 BDT', 'https://picsum.photos/seed/oil/400/400', 10, '2025-08-01 10:27:46', '2025-08-01 10:27:46');

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

--
-- Table structure for table `product_wishes`
--

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

--
-- Dumping data for table `product_wishes`
--

INSERT INTO `product_wishes` (`id`, `product_id`, `user_id`, `created_at`, `updated_at`) VALUES
(2, 2, 1, '2025-08-01 17:41:55', '2025-08-01 17:44:42'),
(3, 3, 1, '2025-08-01 17:41:55', '2025-08-01 17:44:52'),
(4, 4, 4, '2025-08-01 17:41:55', '2025-08-01 17:41:55'),
(5, 5, 5, '2025-08-01 17:41:55', '2025-08-01 17:41:55'),
(6, 6, 6, '2025-08-01 17:41:55', '2025-08-01 17:41:55'),
(7, 7, 7, '2025-08-01 17:41:55', '2025-08-01 17:41:55'),
(8, 8, 8, '2025-08-01 17:41:55', '2025-08-01 17:41:55'),
(9, 9, 9, '2025-08-01 17:41:55', '2025-08-01 17:41:55'),
(10, 10, 10, '2025-08-01 17:41:55', '2025-08-01 17:41:55');

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int 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
('6DfwJHpzICxjQmVv6ZxUqx4Trhn1eoHRkgzUj1lX', NULL, '127.0.0.1', 'PostmanRuntime/7.45.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSFZqVUdjM090am1ydGpkSlZiZ3h5N0Z3cktxcnRJUjdWblAwY1ZRSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9DYXJ0TGlzdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1754074286),
('FcLblSdI1SGtJqTYxnZa7eaj2TYyYMRRbwZ9CJMv', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiSHlvS211VTNpckVEZG9DUmNDWUR5VktaaEpoeEplbHZTSVN1QXp0ZSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1754129144),
('fpsP1efW10kg7ixl0aSRpbvJLLiaPi4rgIQXp2jD', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiWjR5aXlXOGR5Y2Y3WXpzZ3ptdHJ4TnJROUtwMVlTMnRIOGRmUWVKaCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1754129069),
('GI1j7ot6TRoHsjKJGi8xvjFZixRxWCMzojTIFuHF', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiVlI1ZlhCcENMcHVrQ0ZwazhBcHplMUt6bXdDRnRsVzFIVHFXQlhSRiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1754128850),
('pHJBb050qZJx3RwSZgsHJbmeZIzZOX5z3U8rVnsA', NULL, '127.0.0.1', 'PostmanRuntime/7.45.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT3V0TUdkb1JSdHM1WkVqQ0x5eml0aWdxTm1xMW52eGFYWHdBdzRHQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9JbnZvaWNlQ3JlYXRlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1754129123),
('qyFwUglwhAy3Jh23YyAXh0FDI76YiXxRXDBSI5km', NULL, '127.0.0.1', 'PostmanRuntime/7.45.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRDcwUkZNcDY1N1lKamUzN29CYWw3NkdwdkN6eUxBY2JlbHdLTDYyViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9WZXJpZnlMb2dpbi9kdW1teUBnbWFpbC5jb20vOTU4NjM3Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1754061291),
('vl41Zp5i3D0bqOypDVJmaWjHh61LicLBUGEe3HrB', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNHJxVUdyUDU1WkxpSmdLREpWbmxNUlZ0TldBSWhnQWk5SVRiRlJsMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1754117417),
('y32gaCOhPHKSI0EfDXT6ERbLEKHb1qdMr07eUR9F', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSUZDQmM5Z1VmbGV6bWhCaDFESTFJNnBJODMyakV0anlQU0g0UWFETiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC8/dHJhbl9pZD02ODhkZTAyNzA3OTAzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1754128539);

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `customer_profiles`
--
ALTER TABLE `customer_profiles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customer_profiles_user_id_unique` (`user_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 `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoices_user_id_foreign` (`user_id`);

--
-- Indexes for table `invoice_products`
--
ALTER TABLE `invoice_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice_products_invoice_id_foreign` (`invoice_id`),
  ADD KEY `invoice_products_product_id_foreign` (`product_id`),
  ADD KEY `invoice_products_user_id_foreign` (`user_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 `policies`
--
ALTER TABLE `policies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_brand_id_foreign` (`brand_id`);

--
-- Indexes for table `product_carts`
--
ALTER TABLE `product_carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_carts_product_id_foreign` (`product_id`),
  ADD KEY `product_carts_user_id_foreign` (`user_id`);

--
-- Indexes for table `product_details`
--
ALTER TABLE `product_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_details_product_id_unique` (`product_id`);

--
-- Indexes for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_reviews_customer_id_foreign` (`customer_id`),
  ADD KEY `product_reviews_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_sliders`
--
ALTER TABLE `product_sliders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_sliders_product_id_unique` (`product_id`);

--
-- Indexes for table `product_wishes`
--
ALTER TABLE `product_wishes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_wishes_product_id_foreign` (`product_id`),
  ADD KEY `product_wishes_user_id_foreign` (`user_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`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `customer_profiles`
--
ALTER TABLE `customer_profiles`
  ADD CONSTRAINT `customer_profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Constraints for table `invoice_products`
--
ALTER TABLE `invoice_products`
  ADD CONSTRAINT `invoice_products_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  ADD CONSTRAINT `invoice_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  ADD CONSTRAINT `invoice_products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Constraints for table `product_carts`
--
ALTER TABLE `product_carts`
  ADD CONSTRAINT `product_carts_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD CONSTRAINT `product_carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Constraints for table `product_details`
--
ALTER TABLE `product_details`
  ADD CONSTRAINT `product_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD CONSTRAINT `product_reviews_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customer_profiles` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD CONSTRAINT `product_reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `product_sliders`
--
ALTER TABLE `product_sliders`
  ADD CONSTRAINT `product_sliders_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `product_wishes`
--
ALTER TABLE `product_wishes`
  ADD CONSTRAINT `product_wishes_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD CONSTRAINT `product_wishes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
COMMIT;

