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

START TRANSACTION;



--
-- Database: `onlineshop`
--

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

--
-- Table structure for table `addons`
--

CREATE TABLE IF NOT EXISTS `addons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `unique_identifier` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `version` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `activated` int NOT NULL DEFAULT '1',
  `image` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `addons`
--

INSERT INTO `addons` (`id`, `name`, `unique_identifier`, `version`, `activated`, `image`, `created_at`, `updated_at`) VALUES
(1, 'club_point', 'club_point', '1.6', 1, 'club_points.png', '2025-11-18 16:33:15', '2025-11-18 16:36:17'),
(2, 'Offline Payment', 'offline_payment', '1.5', 1, 'offline_banner.jpg', '2025-11-19 10:04:15', '2025-11-19 10:04:15');

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

--
-- Table structure for table `addresses`
--

CREATE TABLE IF NOT EXISTS `addresses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `postal_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set_default` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `addresses`
--

INSERT INTO `addresses` (`id`, `user_id`, `address`, `country`, `city`, `longitude`, `latitude`, `postal_code`, `phone`, `set_default`, `created_at`, `updated_at`) VALUES
(1, 10, 'Muradpur School Road', 'Bangladesh', 'Dhaka', NULL, NULL, '1204', '+8801998126567', 0, '2023-11-23 22:31:21', '2023-11-23 22:31:21'),
(2, 11, 'dhaka', 'Bangladesh', 'Dhaka', NULL, NULL, '1212', '01727632825', 0, '2023-11-24 01:24:43', '2023-11-24 01:24:43'),
(3, 17, 'Dhaka', 'Bangladesh', 'Dhaka', NULL, NULL, '1212', '01727532825', 0, '2025-11-04 02:45:20', '2025-11-04 02:45:20'),
(4, 18, 'hfh', 'Bangladesh', 'Dhaka', NULL, NULL, '1212', '01727532825', 0, '2025-11-10 03:01:03', '2025-11-10 03:01:03');

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

--
-- Table structure for table `app_settings`
--

CREATE TABLE IF NOT EXISTS `app_settings` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `currency_id` int DEFAULT NULL,
  `currency_format` char(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `google_plus` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `app_settings`
--

INSERT INTO `app_settings` (`id`, `name`, `logo`, `currency_id`, `currency_format`, `facebook`, `twitter`, `instagram`, `youtube`, `google_plus`, `created_at`, `updated_at`) VALUES
(1, 'Active eCommerce', 'uploads/logo/matggar.png', 1, 'symbol', 'https://facebook.com', 'https://twitter.com', 'https://instagram.com', 'https://youtube.com', 'https://google.com', '2019-08-04 16:39:15', '2019-08-04 16:39:18');

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

--
-- Table structure for table `attributes`
--

CREATE TABLE IF NOT EXISTS `attributes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `attributes`
--

INSERT INTO `attributes` (`id`, `name`, `created_at`, `updated_at`) VALUES
(3, 'Size', '2025-11-26 11:12:30', '2025-11-26 11:12:30');

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

--
-- Table structure for table `attribute_translations`
--

CREATE TABLE IF NOT EXISTS `attribute_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `attribute_id` bigint NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `attribute_translations`
--

INSERT INTO `attribute_translations` (`id`, `attribute_id`, `name`, `lang`, `created_at`, `updated_at`) VALUES
(2, 3, 'Size', 'en', '2025-11-26 11:12:30', '2025-11-26 11:12:30');

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

--
-- Table structure for table `attribute_values`
--

CREATE TABLE IF NOT EXISTS `attribute_values` (
  `id` int NOT NULL AUTO_INCREMENT,
  `attribute_id` int NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `color_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `attribute_values`
--

INSERT INTO `attribute_values` (`id`, `attribute_id`, `value`, `color_code`, `created_at`, `updated_at`) VALUES
(7, 3, 'S', NULL, '2025-11-26 11:12:56', '2025-11-26 11:12:56'),
(8, 3, 'M', NULL, '2025-11-26 11:18:37', '2025-11-26 11:18:37'),
(9, 3, 'L', NULL, '2025-11-26 11:18:43', '2025-11-26 11:18:43'),
(10, 3, 'XL', NULL, '2025-11-26 11:18:52', '2025-11-26 11:18:52'),
(11, 3, 'XXL', NULL, '2025-11-26 11:18:59', '2025-11-26 11:18:59');

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

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

CREATE TABLE IF NOT EXISTS `banners` (
  `id` int NOT NULL AUTO_INCREMENT,
  `photo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `url` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `position` int NOT NULL DEFAULT '1',
  `published` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `photo`, `url`, `position`, `published`, `created_at`, `updated_at`) VALUES
(4, 'uploads/banners/banner.jpg', '#', 1, 1, '2019-03-12 05:58:23', '2019-06-11 04:56:50'),
(5, 'uploads/banners/banner.jpg', '#', 1, 1, '2019-03-12 05:58:41', '2019-03-12 05:58:57'),
(6, 'uploads/banners/banner.jpg', '#', 2, 1, '2019-03-12 05:58:52', '2019-03-12 05:58:57'),
(7, 'uploads/banners/banner.jpg', '#', 2, 1, '2019-05-26 05:16:38', '2019-05-26 05:17:34'),
(8, 'uploads/banners/banner.jpg', '#', 2, 1, '2019-06-11 05:00:06', '2019-06-11 05:00:27'),
(9, 'uploads/banners/banner.jpg', '#', 1, 1, '2019-06-11 05:00:15', '2019-06-11 05:00:29'),
(10, 'uploads/banners/banner.jpg', '#', 1, 0, '2019-06-11 05:00:24', '2019-06-11 05:01:56');

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

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

CREATE TABLE IF NOT EXISTS `blogs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `banner` int DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_img` int DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `meta_keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `blog_categories` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `category_name`, `slug`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Easy', 'Easy', '2023-11-23 13:58:22', '2023-11-23 13:58:22', NULL),
(2, 'Arong', 'Arong', '2023-11-23 13:58:36', '2023-11-23 13:58:36', NULL),
(3, 'Richman', 'Richman', '2023-11-23 13:59:25', '2023-11-23 13:59:25', NULL),
(4, 'Le Reve', 'Le-Reve', '2023-11-23 13:59:45', '2023-11-23 13:59:45', NULL);

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

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

CREATE TABLE IF NOT EXISTS `brands` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `logo` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `top` int NOT NULL DEFAULT '0',
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `brands` (`id`, `name`, `logo`, `top`, `slug`, `meta_title`, `meta_description`, `created_at`, `updated_at`) VALUES
(3, 'Arong', '5', 0, 'Arong-ArQP8', 'Arong', 'Arong shop', '2023-11-23 14:04:28', '2023-11-23 14:04:28'),
(4, 'Easy', '6', 0, 'Easy-79gPT', 'Easy', NULL, '2023-11-23 14:04:49', '2023-11-23 14:04:49'),
(5, 'Le Reve', '7', 0, 'Le-Reve-fJdZ8', 'Le reve', NULL, '2023-11-23 14:05:09', '2023-11-23 14:05:09'),
(6, 'Richman', '8', 0, 'Richman-MYLgA', 'Richman', NULL, '2023-11-23 14:05:41', '2023-11-23 14:05:41'),
(7, 'Naviforce', '11', 0, 'Naviforce-NyBd2', 'watch', NULL, '2023-11-23 15:19:21', '2023-11-23 15:19:21');

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

--
-- Table structure for table `brand_translations`
--

CREATE TABLE IF NOT EXISTS `brand_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `brand_id` bigint NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `brand_translations`
--

INSERT INTO `brand_translations` (`id`, `brand_id`, `name`, `lang`, `created_at`, `updated_at`) VALUES
(1, 3, 'Arong', 'en', '2023-11-23 14:04:28', '2023-11-23 14:04:28'),
(2, 4, 'Easy', 'en', '2023-11-23 14:04:49', '2023-11-23 14:04:49'),
(3, 5, 'Le Reve', 'en', '2023-11-23 14:05:09', '2023-11-23 14:05:09'),
(4, 6, 'Richman', 'en', '2023-11-23 14:05:41', '2023-11-23 14:05:41'),
(5, 7, 'Naviforce', 'en', '2023-11-23 15:19:21', '2023-11-23 15:19:21');

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

--
-- Table structure for table `business_settings`
--

CREATE TABLE IF NOT EXISTS `business_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `lang` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `business_settings`
--

INSERT INTO `business_settings` (`id`, `type`, `value`, `lang`, `created_at`, `updated_at`) VALUES
(1, 'home_default_currency', '27', NULL, '2018-10-16 01:35:52', '2023-11-22 12:22:47'),
(2, 'system_default_currency', '27', NULL, '2018-10-16 01:36:58', '2023-11-22 12:22:47'),
(3, 'currency_format', '1', NULL, '2018-10-17 03:01:59', '2018-10-17 03:01:59'),
(4, 'symbol_format', '1', NULL, '2018-10-17 03:01:59', '2019-01-20 02:10:55'),
(5, 'no_of_decimals', '2', NULL, '2018-10-17 03:01:59', '2020-03-04 00:57:16'),
(6, 'product_activation', '1', NULL, '2018-10-28 01:38:37', '2019-02-04 01:11:41'),
(7, 'vendor_system_activation', '1', NULL, '2018-10-28 07:44:16', '2019-02-04 01:11:38'),
(8, 'show_vendors', '1', NULL, '2018-10-28 07:44:47', '2019-02-04 01:11:13'),
(9, 'paypal_payment', '0', NULL, '2018-10-28 07:45:16', '2019-01-31 05:09:10'),
(10, 'stripe_payment', '0', NULL, '2018-10-28 07:45:47', '2018-11-14 01:51:51'),
(11, 'cash_payment', '1', NULL, '2018-10-28 07:46:05', '2019-01-24 03:40:18'),
(12, 'payumoney_payment', '0', NULL, '2018-10-28 07:46:27', '2019-03-05 05:41:36'),
(13, 'best_selling', '1', NULL, '2018-12-24 08:13:44', '2019-02-14 05:29:13'),
(14, 'paypal_sandbox', '0', NULL, '2019-01-16 12:44:18', '2019-01-16 12:44:18'),
(15, 'sslcommerz_sandbox', '1', NULL, '2019-01-16 12:44:18', '2019-03-14 00:07:26'),
(16, 'sslcommerz_payment', '0', NULL, '2019-01-24 09:39:07', '2019-01-29 06:13:46'),
(17, 'vendor_commission', '20', NULL, '2019-01-31 06:18:04', '2019-04-13 06:49:26'),
(18, 'verification_form', '[{\"type\":\"text\",\"label\":\"Your name\"},{\"type\":\"text\",\"label\":\"Shop name\"},{\"type\":\"text\",\"label\":\"Email\"},{\"type\":\"text\",\"label\":\"License No\"},{\"type\":\"text\",\"label\":\"Full Address\"},{\"type\":\"text\",\"label\":\"Phone Number\"},{\"type\":\"file\",\"label\":\"Tax Papers\"}]', NULL, '2019-02-03 11:36:58', '2019-02-16 06:14:42'),
(19, 'google_analytics', '0', NULL, '2019-02-06 12:22:35', '2019-02-06 12:22:35'),
(20, 'facebook_login', '0', NULL, '2019-02-07 12:51:59', '2019-02-08 19:41:15'),
(21, 'google_login', '0', NULL, '2019-02-07 12:52:10', '2019-02-08 19:41:14'),
(22, 'twitter_login', '0', NULL, '2019-02-07 12:52:20', '2019-02-08 02:32:56'),
(23, 'payumoney_payment', '1', NULL, '2019-03-05 11:38:17', '2019-03-05 11:38:17'),
(24, 'payumoney_sandbox', '1', NULL, '2019-03-05 11:38:17', '2019-03-05 05:39:18'),
(36, 'facebook_chat', '0', NULL, '2019-04-15 11:45:04', '2019-04-15 11:45:04'),
(37, 'email_verification', '0', NULL, '2019-04-30 07:30:07', '2019-04-30 07:30:07'),
(38, 'wallet_system', '1', NULL, '2019-05-19 08:05:44', '2025-11-19 06:09:31'),
(39, 'coupon_system', '1', NULL, '2019-06-11 09:46:18', '2023-12-11 03:43:27'),
(40, 'current_version', '5.0', NULL, '2019-06-11 09:46:18', '2019-06-11 09:46:18'),
(41, 'instamojo_payment', '0', NULL, '2019-07-06 09:58:03', '2019-07-06 09:58:03'),
(42, 'instamojo_sandbox', '1', NULL, '2019-07-06 09:58:43', '2019-07-06 09:58:43'),
(43, 'razorpay', '0', NULL, '2019-07-06 09:58:43', '2019-07-06 09:58:43'),
(44, 'paystack', '0', NULL, '2019-07-21 13:00:38', '2019-07-21 13:00:38'),
(45, 'pickup_point', '0', NULL, '2019-10-17 11:50:39', '2019-10-17 11:50:39'),
(46, 'maintenance_mode', '0', NULL, '2019-10-17 11:51:04', '2019-10-17 11:51:04'),
(47, 'voguepay', '0', NULL, '2019-10-17 11:51:24', '2019-10-17 11:51:24'),
(48, 'voguepay_sandbox', '0', NULL, '2019-10-17 11:51:38', '2019-10-17 11:51:38'),
(50, 'category_wise_commission', '0', NULL, '2020-01-21 07:22:47', '2020-01-21 07:22:47'),
(51, 'conversation_system', '1', NULL, '2020-01-21 07:23:21', '2020-01-21 07:23:21'),
(52, 'guest_checkout_active', '1', NULL, '2020-01-22 07:36:38', '2020-01-22 07:36:38'),
(53, 'facebook_pixel', '0', NULL, '2020-01-22 11:43:58', '2020-01-22 11:43:58'),
(55, 'classified_product', '0', NULL, '2020-05-13 13:01:05', '2020-05-13 13:01:05'),
(56, 'pos_activation_for_seller', '1', NULL, '2020-06-11 09:45:02', '2020-06-11 09:45:02'),
(57, 'shipping_type', 'product_wise_shipping', NULL, '2020-07-01 13:49:56', '2020-07-01 13:49:56'),
(58, 'flat_rate_shipping_cost', '0', NULL, '2020-07-01 13:49:56', '2020-07-01 13:49:56'),
(59, 'shipping_cost_admin', '0', NULL, '2020-07-01 13:49:56', '2020-07-01 13:49:56'),
(60, 'payhere_sandbox', '0', NULL, '2020-07-30 18:23:53', '2020-07-30 18:23:53'),
(61, 'payhere', '0', NULL, '2020-07-30 18:23:53', '2020-07-30 18:23:53'),
(62, 'google_recaptcha', '0', NULL, '2020-08-17 07:13:37', '2020-08-17 07:13:37'),
(63, 'ngenius', '0', NULL, '2020-09-22 10:58:21', '2020-09-22 10:58:21'),
(64, 'header_logo', '29', NULL, '2020-11-16 07:26:36', '2025-11-04 02:39:17'),
(65, 'show_language_switcher', 'on', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(66, 'show_currency_switcher', 'on', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(67, 'header_stikcy', 'on', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(68, 'footer_logo', '29', NULL, '2020-11-16 07:26:36', '2025-11-04 02:39:37'),
(69, 'about_us_description', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(70, 'contact_address', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(71, 'contact_phone', '+61451673553', NULL, '2020-11-16 07:26:36', '2023-11-23 22:01:07'),
(72, 'contact_email', 'asifhossainsyedofficial@gmail.com', NULL, '2020-11-16 07:26:36', '2023-11-23 22:01:07'),
(73, 'widget_one_labels', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(74, 'widget_one_links', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(75, 'widget_one', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(76, 'frontend_copyright_text', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(77, 'show_social_links', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(78, 'facebook_link', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(79, 'twitter_link', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(80, 'instagram_link', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(81, 'youtube_link', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(82, 'linkedin_link', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(83, 'payment_method_images', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(84, 'home_slider_images', '[\"28\",\"24\",\"26\"]', NULL, '2020-11-16 07:26:36', '2023-11-23 22:16:55'),
(85, 'home_slider_links', '[null,null,null]', NULL, '2020-11-16 07:26:36', '2023-11-23 22:16:55'),
(86, 'home_banner1_images', '[\"27\"]', NULL, '2020-11-16 07:26:36', '2023-11-23 22:18:42'),
(87, 'home_banner1_links', '[null]', NULL, '2020-11-16 07:26:36', '2023-11-23 22:18:42'),
(88, 'home_banner2_images', '[]', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(89, 'home_banner2_links', '[]', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(90, 'home_categories', '[]', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(91, 'top10_categories', '[]', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(92, 'top10_brands', '[]', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(93, 'website_name', 'Online Shop', NULL, '2020-11-16 07:26:36', '2023-11-23 21:54:49'),
(94, 'site_motto', 'Asif Syed', NULL, '2020-11-16 07:26:36', '2023-11-23 22:24:14'),
(95, 'site_icon', '23', NULL, '2020-11-16 07:26:36', '2023-11-23 21:54:49'),
(96, 'base_color', '#e62e04', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(97, 'base_hov_color', '#e62e04', NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(98, 'meta_title', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(99, 'meta_description', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(100, 'meta_keywords', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(101, 'meta_image', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(102, 'site_name', 'Asif Syed', NULL, '2020-11-16 07:26:36', '2023-11-23 22:07:24'),
(103, 'system_logo_white', '29', NULL, '2020-11-16 07:26:36', '2025-11-04 02:24:29'),
(104, 'system_logo_black', '29', NULL, '2020-11-16 07:26:36', '2025-11-04 02:24:29'),
(105, 'timezone', NULL, NULL, '2020-11-16 07:26:36', '2020-11-16 07:26:36'),
(106, 'admin_login_background', '29', NULL, '2020-11-16 07:26:36', '2025-11-04 02:24:29'),
(107, 'iyzico_sandbox', '1', NULL, '2020-12-30 16:45:56', '2020-12-30 16:45:56'),
(108, 'iyzico', '1', NULL, '2020-12-30 16:45:56', '2020-12-30 16:45:56'),
(109, 'decimal_separator', '1', NULL, '2020-12-30 16:45:56', '2020-12-30 16:45:56'),
(110, 'nagad', '0', NULL, '2021-01-22 10:30:03', '2021-01-22 10:30:03'),
(111, 'bkash', '0', NULL, '2021-01-22 10:30:03', '2021-01-22 10:30:03'),
(112, 'bkash_sandbox', '1', NULL, '2021-01-22 10:30:03', '2021-01-22 10:30:03'),
(113, 'header_menu_labels', '[\"Home\",\"All Stores\",\"Blogs\",\"All Brands\",\"All Categories\",\"Flash Sale\"]', NULL, '2021-02-16 02:43:11', '2025-11-30 04:57:09'),
(114, 'header_menu_links', '[\"http:\\/\\/localhost\\/onlineshop\\/\",\"http:\\/\\/localhost\\/onlineshop\\/stores\",\"http:\\/\\/localhost\\/onlineshop\\/blog\",\"http:\\/\\/localhost\\/onlineshop\\/brands\",\"http:\\/\\/localhost\\/onlineshop\\/categories\",\"http:\\/\\/localhost\\/onlineshop\\/flash-deals\"]', NULL, '2021-02-16 02:43:11', '2025-11-30 04:57:09'),
(115, 'proxypay', '1', NULL, '2021-06-20 11:25:42', '2021-06-20 11:25:42'),
(116, 'proxypay_sandbox', '1', NULL, '2021-06-20 11:25:42', '2021-06-20 11:25:42'),
(117, 'google_map', '0', NULL, '2021-07-27 15:49:39', '2021-07-27 15:49:39'),
(118, 'google_firebase', '0', NULL, '2021-07-27 15:49:39', '2021-07-27 15:49:39'),
(119, 'topbar_banner', NULL, NULL, '2023-11-23 00:02:24', '2023-11-23 00:08:59'),
(120, 'topbar_banner_link', NULL, NULL, '2023-11-23 00:02:24', '2023-11-23 00:02:24'),
(121, 'contact_address', 'Australia', 'en', '2023-11-23 15:34:14', '2023-11-23 22:01:07'),
(122, 'about_us_description', NULL, 'en', '2023-11-23 15:34:33', '2023-11-23 15:34:33'),
(123, 'play_store_link', NULL, NULL, '2023-11-23 15:34:33', '2023-11-23 15:34:33'),
(124, 'app_store_link', NULL, NULL, '2023-11-23 15:34:33', '2023-11-23 15:34:33'),
(125, 'club_point_convert_rate', '100', NULL, '2019-03-12 05:58:23', '2025-11-18 17:26:52');

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

--
-- Table structure for table `carts`
--

CREATE TABLE IF NOT EXISTS `carts` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `owner_id` int DEFAULT NULL,
  `store_id` bigint DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `temp_user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address_id` int NOT NULL DEFAULT '0',
  `product_id` int DEFAULT NULL,
  `variation` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `price` double(8,2) DEFAULT '0.00',
  `tax` double(8,2) DEFAULT '0.00',
  `shipping_cost` double(8,2) DEFAULT '0.00',
  `shipping_type` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `pickup_point` int DEFAULT NULL,
  `discount` double(10,2) NOT NULL DEFAULT '0.00',
  `product_referral_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `coupon_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `coupon_applied` tinyint NOT NULL DEFAULT '0',
  `quantity` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `carts`
--

INSERT INTO `carts` (`id`, `owner_id`, `store_id`, `user_id`, `temp_user_id`, `address_id`, `product_id`, `variation`, `price`, `tax`, `shipping_cost`, `shipping_type`, `pickup_point`, `discount`, `product_referral_code`, `coupon_code`, `coupon_applied`, `quantity`, `created_at`, `updated_at`) VALUES
(8, 9, NULL, NULL, '2cd9071eac91c2a1d826', 0, 6, 'Aqua-', 1000.00, 0.00, 0.00, '', NULL, 0.00, NULL, '', 0, 1, '2023-11-24 14:35:39', '2023-11-24 14:35:39'),
(13, 9, NULL, NULL, '93619f0bcb4bc733256c', 0, 8, 'Aqua-', 1000.00, 0.00, 0.00, '', NULL, 0.00, NULL, '', 0, 4, '2025-11-04 12:31:08', '2025-11-04 12:32:39');

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

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

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int DEFAULT '0',
  `level` int NOT NULL DEFAULT '0',
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `order_level` int NOT NULL DEFAULT '0',
  `commision_rate` double(8,2) NOT NULL DEFAULT '0.00',
  `banner` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `featured` int NOT NULL DEFAULT '0',
  `top` int NOT NULL DEFAULT '0',
  `digital` int NOT NULL DEFAULT '0',
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `categories` (`id`, `parent_id`, `level`, `name`, `order_level`, `commision_rate`, `banner`, `icon`, `featured`, `top`, `digital`, `slug`, `meta_title`, `meta_description`, `created_at`, `updated_at`) VALUES
(4, 0, 0, 'Women Collection', 1, 0.00, '9', '9', 1, 0, 0, 'women-collection', 'Women', NULL, '2023-11-23 10:10:24', '2023-11-23 15:10:24'),
(5, 0, 0, 'Men Collection', 2, 0.00, '14', '14', 1, 0, 0, 'men-collection-gvag9', 'Men Collection', 'Men Collection', '2023-11-23 10:10:06', '2023-11-23 15:10:06'),
(6, 0, 0, 'Kids Collection', 3, 0.00, '15', '15', 1, 0, 0, 'Kids-Collection-NM5wO', 'Kids Collection', 'Kids Collection', '2023-11-23 09:24:30', '2023-11-23 14:24:30'),
(7, 5, 1, 'Man Shirt', 4, 0.00, '14', '14', 1, 0, 0, 'Man-Shirt-M0qFt', 'Man Shirt', 'Man Shirt', '2023-11-23 09:24:26', '2023-11-23 14:24:26'),
(8, 5, 1, 'Man Watch', 5, 0.00, '11', '11', 1, 0, 0, 'Man-Watch-XtgBC', 'Man Watch', 'Man Watch', '2023-11-23 09:24:23', '2023-11-23 14:24:23'),
(9, 4, 1, 'Women Watch', 10, 0.00, '11', '11', 1, 0, 0, 'women-watch-886ll', 'Women Watch', 'Women Watch', '2023-11-23 09:25:59', '2023-11-23 14:25:59');

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

--
-- Table structure for table `category_translations`
--

CREATE TABLE IF NOT EXISTS `category_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `category_id` bigint NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `category_translations`
--

INSERT INTO `category_translations` (`id`, `category_id`, `name`, `lang`, `created_at`, `updated_at`) VALUES
(1, 4, 'Women Collection', 'en', '2023-11-23 14:14:52', '2023-11-23 14:16:07'),
(2, 5, 'Men Collection', 'en', '2023-11-23 14:17:59', '2023-11-23 14:17:59'),
(3, 6, 'Kids Collection', 'en', '2023-11-23 14:18:55', '2023-11-23 14:18:55'),
(4, 7, 'Man Shirt', 'en', '2023-11-23 14:19:59', '2023-11-23 14:19:59'),
(5, 8, 'Man Watch', 'en', '2023-11-23 14:21:02', '2023-11-23 14:21:02'),
(6, 9, 'Women Watch', 'en', '2023-11-23 14:22:01', '2023-11-23 14:22:01');

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

--
-- Table structure for table `cities`
--

CREATE TABLE IF NOT EXISTS `cities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `country_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cost` double(20,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `country_id`, `name`, `cost`, `created_at`, `updated_at`) VALUES
(1, 18, 'Dhaka', 65.00, '2023-11-23 22:30:25', '2023-11-23 22:30:25');

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

--
-- Table structure for table `city_translations`
--

CREATE TABLE IF NOT EXISTS `city_translations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `city_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `club_points`
--

CREATE TABLE IF NOT EXISTS `club_points` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `points` double(18,2) NOT NULL,
  `order_id` int NOT NULL,
  `convert_status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `club_points`
--

INSERT INTO `club_points` (`id`, `user_id`, `points`, `order_id`, `convert_status`, `created_at`, `updated_at`) VALUES
(1, 18, 200.00, 27, 0, '2025-11-24 09:55:07', '2025-11-24 09:55:07'),
(2, 18, 500.00, 28, 0, '2025-11-24 10:10:35', '2025-11-24 10:10:35'),
(3, 18, 500.00, 29, 1, '2025-11-25 10:44:29', '2025-11-25 10:54:10');

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

--
-- Table structure for table `club_point_details`
--

CREATE TABLE IF NOT EXISTS `club_point_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `club_point_id` int NOT NULL,
  `product_id` int NOT NULL,
  `product_qty` int NOT NULL,
  `point` double(8,2) NOT NULL,
  `converted_amount` double(8,2) DEFAULT '0.00',
  `refunded` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `club_point_details`
--

INSERT INTO `club_point_details` (`id`, `club_point_id`, `product_id`, `product_qty`, `point`, `converted_amount`, `refunded`, `created_at`, `updated_at`) VALUES
(1, 1, 4, 0, 200.00, 0.00, 0, '2025-11-24 09:55:07', '2025-11-24 09:55:07'),
(2, 2, 4, 0, 500.00, 0.00, 0, '2025-11-24 10:10:35', '2025-11-24 10:10:35'),
(3, 3, 4, 0, 500.00, 5.00, 0, '2025-11-25 10:44:29', '2025-11-25 10:54:10');

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

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

CREATE TABLE IF NOT EXISTS `colors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `colors`
--

INSERT INTO `colors` (`id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(1, 'IndianRed', '#CD5C5C', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(2, 'LightCoral', '#F08080', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(3, 'Salmon', '#FA8072', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(4, 'DarkSalmon', '#E9967A', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(5, 'LightSalmon', '#FFA07A', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(6, 'Crimson', '#DC143C', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(7, 'Red', '#FF0000', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(8, 'FireBrick', '#B22222', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(9, 'DarkRed', '#8B0000', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(10, 'Pink', '#FFC0CB', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(11, 'LightPink', '#FFB6C1', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(12, 'HotPink', '#FF69B4', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(13, 'DeepPink', '#FF1493', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(14, 'MediumVioletRed', '#C71585', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(15, 'PaleVioletRed', '#DB7093', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(16, 'LightSalmon', '#FFA07A', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(17, 'Coral', '#FF7F50', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(18, 'Tomato', '#FF6347', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(19, 'OrangeRed', '#FF4500', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(20, 'DarkOrange', '#FF8C00', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(21, 'Orange', '#FFA500', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(22, 'Gold', '#FFD700', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(23, 'Yellow', '#FFFF00', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(24, 'LightYellow', '#FFFFE0', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(25, 'LemonChiffon', '#FFFACD', '2018-11-05 02:12:26', '2018-11-05 02:12:26'),
(26, 'LightGoldenrodYellow', '#FAFAD2', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(27, 'PapayaWhip', '#FFEFD5', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(28, 'Moccasin', '#FFE4B5', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(29, 'PeachPuff', '#FFDAB9', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(30, 'PaleGoldenrod', '#EEE8AA', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(31, 'Khaki', '#F0E68C', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(32, 'DarkKhaki', '#BDB76B', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(33, 'Lavender', '#E6E6FA', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(34, 'Thistle', '#D8BFD8', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(35, 'Plum', '#DDA0DD', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(36, 'Violet', '#EE82EE', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(37, 'Orchid', '#DA70D6', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(38, 'Fuchsia', '#FF00FF', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(39, 'Magenta', '#FF00FF', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(40, 'MediumOrchid', '#BA55D3', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(41, 'MediumPurple', '#9370DB', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(42, 'Amethyst', '#9966CC', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(43, 'BlueViolet', '#8A2BE2', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(44, 'DarkViolet', '#9400D3', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(45, 'DarkOrchid', '#9932CC', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(46, 'DarkMagenta', '#8B008B', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(47, 'Purple', '#800080', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(48, 'Indigo', '#4B0082', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(49, 'SlateBlue', '#6A5ACD', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(50, 'DarkSlateBlue', '#483D8B', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(51, 'MediumSlateBlue', '#7B68EE', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(52, 'GreenYellow', '#ADFF2F', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(53, 'Chartreuse', '#7FFF00', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(54, 'LawnGreen', '#7CFC00', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(55, 'Lime', '#00FF00', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(56, 'LimeGreen', '#32CD32', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(57, 'PaleGreen', '#98FB98', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(58, 'LightGreen', '#90EE90', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(59, 'MediumSpringGreen', '#00FA9A', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(60, 'SpringGreen', '#00FF7F', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(61, 'MediumSeaGreen', '#3CB371', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(62, 'SeaGreen', '#2E8B57', '2018-11-05 02:12:27', '2018-11-05 02:12:27'),
(63, 'ForestGreen', '#228B22', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(64, 'Green', '#008000', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(65, 'DarkGreen', '#006400', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(66, 'YellowGreen', '#9ACD32', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(67, 'OliveDrab', '#6B8E23', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(68, 'Olive', '#808000', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(69, 'DarkOliveGreen', '#556B2F', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(70, 'MediumAquamarine', '#66CDAA', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(71, 'DarkSeaGreen', '#8FBC8F', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(72, 'LightSeaGreen', '#20B2AA', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(73, 'DarkCyan', '#008B8B', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(74, 'Teal', '#008080', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(75, 'Aqua', '#00FFFF', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(76, 'Cyan', '#00FFFF', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(77, 'LightCyan', '#E0FFFF', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(78, 'PaleTurquoise', '#AFEEEE', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(79, 'Aquamarine', '#7FFFD4', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(80, 'Turquoise', '#40E0D0', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(81, 'MediumTurquoise', '#48D1CC', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(82, 'DarkTurquoise', '#00CED1', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(83, 'CadetBlue', '#5F9EA0', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(84, 'SteelBlue', '#4682B4', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(85, 'LightSteelBlue', '#B0C4DE', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(86, 'PowderBlue', '#B0E0E6', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(87, 'LightBlue', '#ADD8E6', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(88, 'SkyBlue', '#87CEEB', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(89, 'LightSkyBlue', '#87CEFA', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(90, 'DeepSkyBlue', '#00BFFF', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(91, 'DodgerBlue', '#1E90FF', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(92, 'CornflowerBlue', '#6495ED', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(93, 'MediumSlateBlue', '#7B68EE', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(94, 'RoyalBlue', '#4169E1', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(95, 'Blue', '#0000FF', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(96, 'MediumBlue', '#0000CD', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(97, 'DarkBlue', '#00008B', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(98, 'Navy', '#000080', '2018-11-05 02:12:28', '2018-11-05 02:12:28'),
(99, 'MidnightBlue', '#191970', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(100, 'Cornsilk', '#FFF8DC', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(101, 'BlanchedAlmond', '#FFEBCD', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(102, 'Bisque', '#FFE4C4', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(103, 'NavajoWhite', '#FFDEAD', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(104, 'Wheat', '#F5DEB3', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(105, 'BurlyWood', '#DEB887', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(106, 'Tan', '#D2B48C', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(107, 'RosyBrown', '#BC8F8F', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(108, 'SandyBrown', '#F4A460', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(109, 'Goldenrod', '#DAA520', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(110, 'DarkGoldenrod', '#B8860B', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(111, 'Peru', '#CD853F', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(112, 'Chocolate', '#D2691E', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(113, 'SaddleBrown', '#8B4513', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(114, 'Sienna', '#A0522D', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(115, 'Brown', '#A52A2A', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(116, 'Maroon', '#800000', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(117, 'White', '#FFFFFF', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(118, 'Snow', '#FFFAFA', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(119, 'Honeydew', '#F0FFF0', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(120, 'MintCream', '#F5FFFA', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(121, 'Azure', '#F0FFFF', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(122, 'AliceBlue', '#F0F8FF', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(123, 'GhostWhite', '#F8F8FF', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(124, 'WhiteSmoke', '#F5F5F5', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(125, 'Seashell', '#FFF5EE', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(126, 'Beige', '#F5F5DC', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(127, 'OldLace', '#FDF5E6', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(128, 'FloralWhite', '#FFFAF0', '2018-11-05 02:12:29', '2018-11-05 02:12:29'),
(129, 'Ivory', '#FFFFF0', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(130, 'AntiqueWhite', '#FAEBD7', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(131, 'Linen', '#FAF0E6', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(132, 'LavenderBlush', '#FFF0F5', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(133, 'MistyRose', '#FFE4E1', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(134, 'Gainsboro', '#DCDCDC', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(135, 'LightGrey', '#D3D3D3', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(136, 'Silver', '#C0C0C0', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(137, 'DarkGray', '#A9A9A9', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(138, 'Gray', '#808080', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(139, 'DimGray', '#696969', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(140, 'LightSlateGray', '#778899', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(141, 'SlateGray', '#708090', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(142, 'DarkSlateGray', '#2F4F4F', '2018-11-05 02:12:30', '2018-11-05 02:12:30'),
(143, 'Black', '#000000', '2018-11-05 02:12:30', '2018-11-05 02:12:30');

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

--
-- Table structure for table `commission_histories`
--

CREATE TABLE IF NOT EXISTS `commission_histories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `order_detail_id` int NOT NULL,
  `seller_id` int NOT NULL,
  `admin_commission` double(25,2) NOT NULL,
  `seller_earning` double(25,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `conversations`
--

CREATE TABLE IF NOT EXISTS `conversations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int NOT NULL,
  `receiver_id` int NOT NULL,
  `title` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sender_viewed` int NOT NULL DEFAULT '1',
  `receiver_viewed` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `conversations`
--

INSERT INTO `conversations` (`id`, `sender_id`, `receiver_id`, `title`, `sender_viewed`, `receiver_viewed`, `created_at`, `updated_at`) VALUES
(1, 9, 9, 'Mens Shirt', 1, 0, '2023-11-23 22:20:58', '2023-11-23 22:20:58');

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

--
-- Table structure for table `countries`
--

CREATE TABLE IF NOT EXISTS `countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=297 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `code`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'AF', 'Afghanistan', 1, NULL, NULL),
(2, 'AL', 'Albania', 1, NULL, NULL),
(3, 'DZ', 'Algeria', 1, NULL, NULL),
(4, 'DS', 'American Samoa', 1, NULL, NULL),
(5, 'AD', 'Andorra', 1, NULL, NULL),
(6, 'AO', 'Angola', 1, NULL, NULL),
(7, 'AI', 'Anguilla', 1, NULL, NULL),
(8, 'AQ', 'Antarctica', 1, NULL, NULL),
(9, 'AG', 'Antigua and Barbuda', 1, NULL, NULL),
(10, 'AR', 'Argentina', 1, NULL, NULL),
(11, 'AM', 'Armenia', 1, NULL, NULL),
(12, 'AW', 'Aruba', 1, NULL, NULL),
(13, 'AU', 'Australia', 1, NULL, NULL),
(14, 'AT', 'Austria', 1, NULL, NULL),
(15, 'AZ', 'Azerbaijan', 1, NULL, NULL),
(16, 'BS', 'Bahamas', 1, NULL, NULL),
(17, 'BH', 'Bahrain', 1, NULL, NULL),
(18, 'BD', 'Bangladesh', 1, NULL, NULL),
(19, 'BB', 'Barbados', 1, NULL, NULL),
(20, 'BY', 'Belarus', 1, NULL, NULL),
(21, 'BE', 'Belgium', 1, NULL, NULL),
(22, 'BZ', 'Belize', 1, NULL, NULL),
(23, 'BJ', 'Benin', 1, NULL, NULL),
(24, 'BM', 'Bermuda', 1, NULL, NULL),
(25, 'BT', 'Bhutan', 1, NULL, NULL),
(26, 'BO', 'Bolivia', 1, NULL, NULL),
(27, 'BA', 'Bosnia and Herzegovina', 1, NULL, NULL),
(28, 'BW', 'Botswana', 1, NULL, NULL),
(29, 'BV', 'Bouvet Island', 1, NULL, NULL),
(30, 'BR', 'Brazil', 1, NULL, NULL),
(31, 'IO', 'British Indian Ocean Territory', 1, NULL, NULL),
(32, 'BN', 'Brunei Darussalam', 1, NULL, NULL),
(33, 'BG', 'Bulgaria', 1, NULL, NULL),
(34, 'BF', 'Burkina Faso', 1, NULL, NULL),
(35, 'BI', 'Burundi', 1, NULL, NULL),
(36, 'KH', 'Cambodia', 1, NULL, NULL),
(37, 'CM', 'Cameroon', 1, NULL, NULL),
(38, 'CA', 'Canada', 1, NULL, NULL),
(39, 'CV', 'Cape Verde', 1, NULL, NULL),
(40, 'KY', 'Cayman Islands', 1, NULL, NULL),
(41, 'CF', 'Central African Republic', 1, NULL, NULL),
(42, 'TD', 'Chad', 1, NULL, NULL),
(43, 'CL', 'Chile', 1, NULL, NULL),
(44, 'CN', 'China', 1, NULL, NULL),
(45, 'CX', 'Christmas Island', 1, NULL, NULL),
(46, 'CC', 'Cocos (Keeling) Islands', 1, NULL, NULL),
(47, 'CO', 'Colombia', 1, NULL, NULL),
(48, 'KM', 'Comoros', 1, NULL, NULL),
(49, 'CG', 'Congo', 1, NULL, NULL),
(50, 'CK', 'Cook Islands', 1, NULL, NULL),
(51, 'CR', 'Costa Rica', 1, NULL, NULL),
(52, 'HR', 'Croatia (Hrvatska)', 1, NULL, NULL),
(53, 'CU', 'Cuba', 1, NULL, NULL),
(54, 'CY', 'Cyprus', 1, NULL, NULL),
(55, 'CZ', 'Czech Republic', 1, NULL, NULL),
(56, 'DK', 'Denmark', 1, NULL, NULL),
(57, 'DJ', 'Djibouti', 1, NULL, NULL),
(58, 'DM', 'Dominica', 1, NULL, NULL),
(59, 'DO', 'Dominican Republic', 1, NULL, NULL),
(60, 'TP', 'East Timor', 1, NULL, NULL),
(61, 'EC', 'Ecuador', 1, NULL, NULL),
(62, 'EG', 'Egypt', 1, NULL, NULL),
(63, 'SV', 'El Salvador', 1, NULL, NULL),
(64, 'GQ', 'Equatorial Guinea', 1, NULL, NULL),
(65, 'ER', 'Eritrea', 1, NULL, NULL),
(66, 'EE', 'Estonia', 1, NULL, NULL),
(67, 'ET', 'Ethiopia', 1, NULL, NULL),
(68, 'FK', 'Falkland Islands (Malvinas)', 1, NULL, NULL),
(69, 'FO', 'Faroe Islands', 1, NULL, NULL),
(70, 'FJ', 'Fiji', 1, NULL, NULL),
(71, 'FI', 'Finland', 1, NULL, NULL),
(72, 'FR', 'France', 1, NULL, NULL),
(73, 'FX', 'France, Metropolitan', 1, NULL, NULL),
(74, 'GF', 'French Guiana', 1, NULL, NULL),
(75, 'PF', 'French Polynesia', 1, NULL, NULL),
(76, 'TF', 'French Southern Territories', 1, NULL, NULL),
(77, 'GA', 'Gabon', 1, NULL, NULL),
(78, 'GM', 'Gambia', 1, NULL, NULL),
(79, 'GE', 'Georgia', 1, NULL, NULL),
(80, 'DE', 'Germany', 1, NULL, NULL),
(81, 'GH', 'Ghana', 1, NULL, NULL),
(82, 'GI', 'Gibraltar', 1, NULL, NULL),
(83, 'GK', 'Guernsey', 1, NULL, NULL),
(84, 'GR', 'Greece', 1, NULL, NULL),
(85, 'GL', 'Greenland', 1, NULL, NULL),
(86, 'GD', 'Grenada', 1, NULL, NULL),
(87, 'GP', 'Guadeloupe', 1, NULL, NULL),
(88, 'GU', 'Guam', 1, NULL, NULL),
(89, 'GT', 'Guatemala', 1, NULL, NULL),
(90, 'GN', 'Guinea', 1, NULL, NULL),
(91, 'GW', 'Guinea-Bissau', 1, NULL, NULL),
(92, 'GY', 'Guyana', 1, NULL, NULL),
(93, 'HT', 'Haiti', 1, NULL, NULL),
(94, 'HM', 'Heard and Mc Donald Islands', 1, NULL, NULL),
(95, 'HN', 'Honduras', 1, NULL, NULL),
(96, 'HK', 'Hong Kong', 1, NULL, NULL),
(97, 'HU', 'Hungary', 1, NULL, NULL),
(98, 'IS', 'Iceland', 1, NULL, NULL),
(99, 'IN', 'India', 1, NULL, NULL),
(100, 'IM', 'Isle of Man', 1, NULL, NULL),
(101, 'ID', 'Indonesia', 1, NULL, NULL),
(102, 'IR', 'Iran (Islamic Republic of)', 1, NULL, NULL),
(103, 'IQ', 'Iraq', 1, NULL, NULL),
(104, 'IE', 'Ireland', 1, NULL, NULL),
(105, 'IL', 'Israel', 1, NULL, NULL),
(106, 'IT', 'Italy', 1, NULL, NULL),
(107, 'CI', 'Ivory Coast', 1, NULL, NULL),
(108, 'JE', 'Jersey', 1, NULL, NULL),
(109, 'JM', 'Jamaica', 1, NULL, NULL),
(110, 'JP', 'Japan', 1, NULL, NULL),
(111, 'JO', 'Jordan', 1, NULL, NULL),
(112, 'KZ', 'Kazakhstan', 1, NULL, NULL),
(113, 'KE', 'Kenya', 1, NULL, NULL),
(114, 'KI', 'Kiribati', 1, NULL, NULL),
(115, 'KP', 'Korea, Democratic People\'s Republic of', 1, NULL, NULL),
(116, 'KR', 'Korea, Republic of', 1, NULL, NULL),
(117, 'XK', 'Kosovo', 1, NULL, NULL),
(118, 'KW', 'Kuwait', 1, NULL, NULL),
(119, 'KG', 'Kyrgyzstan', 1, NULL, NULL),
(120, 'LA', 'Lao People\'s Democratic Republic', 1, NULL, NULL),
(121, 'LV', 'Latvia', 1, NULL, NULL),
(122, 'LB', 'Lebanon', 1, NULL, NULL),
(123, 'LS', 'Lesotho', 1, NULL, NULL),
(124, 'LR', 'Liberia', 1, NULL, NULL),
(125, 'LY', 'Libyan Arab Jamahiriya', 1, NULL, NULL),
(126, 'LI', 'Liechtenstein', 1, NULL, NULL),
(127, 'LT', 'Lithuania', 1, NULL, NULL),
(128, 'LU', 'Luxembourg', 1, NULL, NULL),
(129, 'MO', 'Macau', 1, NULL, NULL),
(130, 'MK', 'Macedonia', 1, NULL, NULL),
(131, 'MG', 'Madagascar', 1, NULL, NULL),
(132, 'MW', 'Malawi', 1, NULL, NULL),
(133, 'MY', 'Malaysia', 1, NULL, NULL),
(134, 'MV', 'Maldives', 1, NULL, NULL),
(135, 'ML', 'Mali', 1, NULL, NULL),
(136, 'MT', 'Malta', 1, NULL, NULL),
(137, 'MH', 'Marshall Islands', 1, NULL, NULL),
(138, 'MQ', 'Martinique', 1, NULL, NULL),
(139, 'MR', 'Mauritania', 1, NULL, NULL),
(140, 'MU', 'Mauritius', 1, NULL, NULL),
(141, 'TY', 'Mayotte', 1, NULL, NULL),
(142, 'MX', 'Mexico', 1, NULL, NULL),
(143, 'FM', 'Micronesia, Federated States of', 1, NULL, NULL),
(144, 'MD', 'Moldova, Republic of', 1, NULL, NULL),
(145, 'MC', 'Monaco', 1, NULL, NULL),
(146, 'MN', 'Mongolia', 1, NULL, NULL),
(147, 'ME', 'Montenegro', 1, NULL, NULL),
(148, 'MS', 'Montserrat', 1, NULL, NULL),
(149, 'MA', 'Morocco', 1, NULL, NULL),
(150, 'MZ', 'Mozambique', 1, NULL, NULL),
(151, 'MM', 'Myanmar', 1, NULL, NULL),
(152, 'NA', 'Namibia', 1, NULL, NULL),
(153, 'NR', 'Nauru', 1, NULL, NULL),
(154, 'NP', 'Nepal', 1, NULL, NULL),
(155, 'NL', 'Netherlands', 1, NULL, NULL),
(156, 'AN', 'Netherlands Antilles', 1, NULL, NULL),
(157, 'NC', 'New Caledonia', 1, NULL, NULL),
(158, 'NZ', 'New Zealand', 1, NULL, NULL),
(159, 'NI', 'Nicaragua', 1, NULL, NULL),
(160, 'NE', 'Niger', 1, NULL, NULL),
(161, 'NG', 'Nigeria', 1, NULL, NULL),
(162, 'NU', 'Niue', 1, NULL, NULL),
(163, 'NF', 'Norfolk Island', 1, NULL, NULL),
(164, 'MP', 'Northern Mariana Islands', 1, NULL, NULL),
(165, 'NO', 'Norway', 1, NULL, NULL),
(166, 'OM', 'Oman', 1, NULL, NULL),
(167, 'PK', 'Pakistan', 1, NULL, NULL),
(168, 'PW', 'Palau', 1, NULL, NULL),
(169, 'PS', 'Palestine', 1, NULL, NULL),
(170, 'PA', 'Panama', 1, NULL, NULL),
(171, 'PG', 'Papua New Guinea', 1, NULL, NULL),
(172, 'PY', 'Paraguay', 1, NULL, NULL),
(173, 'PE', 'Peru', 1, NULL, NULL),
(174, 'PH', 'Philippines', 1, NULL, NULL),
(175, 'PN', 'Pitcairn', 1, NULL, NULL),
(176, 'PL', 'Poland', 1, NULL, NULL),
(177, 'PT', 'Portugal', 1, NULL, NULL),
(178, 'PR', 'Puerto Rico', 1, NULL, NULL),
(179, 'QA', 'Qatar', 1, NULL, NULL),
(180, 'RE', 'Reunion', 1, NULL, NULL),
(181, 'RO', 'Romania', 1, NULL, NULL),
(182, 'RU', 'Russian Federation', 1, NULL, NULL),
(183, 'RW', 'Rwanda', 1, NULL, NULL),
(184, 'KN', 'Saint Kitts and Nevis', 1, NULL, NULL),
(185, 'LC', 'Saint Lucia', 1, NULL, NULL),
(186, 'VC', 'Saint Vincent and the Grenadines', 1, NULL, NULL),
(187, 'WS', 'Samoa', 1, NULL, NULL),
(188, 'SM', 'San Marino', 1, NULL, NULL),
(189, 'ST', 'Sao Tome and Principe', 1, NULL, NULL),
(190, 'SA', 'Saudi Arabia', 1, NULL, NULL),
(191, 'SN', 'Senegal', 1, NULL, NULL),
(192, 'RS', 'Serbia', 1, NULL, NULL),
(193, 'SC', 'Seychelles', 1, NULL, NULL),
(194, 'SL', 'Sierra Leone', 1, NULL, NULL),
(195, 'SG', 'Singapore', 1, NULL, NULL),
(196, 'SK', 'Slovakia', 1, NULL, NULL),
(197, 'SI', 'Slovenia', 1, NULL, NULL),
(198, 'SB', 'Solomon Islands', 1, NULL, NULL),
(199, 'SO', 'Somalia', 1, NULL, NULL),
(200, 'ZA', 'South Africa', 1, NULL, NULL),
(201, 'GS', 'South Georgia South Sandwich Islands', 1, NULL, NULL),
(202, 'SS', 'South Sudan', 1, NULL, NULL),
(203, 'ES', 'Spain', 1, NULL, NULL),
(204, 'LK', 'Sri Lanka', 1, NULL, NULL),
(205, 'SH', 'St. Helena', 1, NULL, NULL),
(206, 'PM', 'St. Pierre and Miquelon', 1, NULL, NULL),
(207, 'SD', 'Sudan', 1, NULL, NULL),
(208, 'SR', 'Suriname', 1, NULL, NULL),
(209, 'SJ', 'Svalbard and Jan Mayen Islands', 1, NULL, NULL),
(210, 'SZ', 'Swaziland', 1, NULL, NULL),
(211, 'SE', 'Sweden', 1, NULL, NULL),
(212, 'CH', 'Switzerland', 1, NULL, NULL),
(213, 'SY', 'Syrian Arab Republic', 1, NULL, NULL),
(214, 'TW', 'Taiwan', 1, NULL, NULL),
(215, 'TJ', 'Tajikistan', 1, NULL, NULL),
(216, 'TZ', 'Tanzania, United Republic of', 1, NULL, NULL),
(217, 'TH', 'Thailand', 1, NULL, NULL),
(218, 'TG', 'Togo', 1, NULL, NULL),
(219, 'TK', 'Tokelau', 1, NULL, NULL),
(220, 'TO', 'Tonga', 1, NULL, NULL),
(221, 'TT', 'Trinidad and Tobago', 1, NULL, NULL),
(222, 'TN', 'Tunisia', 1, NULL, NULL),
(223, 'TR', 'Turkey', 1, NULL, NULL),
(224, 'TM', 'Turkmenistan', 1, NULL, NULL),
(225, 'TC', 'Turks and Caicos Islands', 1, NULL, NULL),
(226, 'TV', 'Tuvalu', 1, NULL, NULL),
(227, 'UG', 'Uganda', 1, NULL, NULL),
(228, 'UA', 'Ukraine', 1, NULL, NULL),
(229, 'AE', 'United Arab Emirates', 1, NULL, NULL),
(230, 'GB', 'United Kingdom', 1, NULL, NULL),
(231, 'US', 'United States', 1, NULL, NULL),
(232, 'UM', 'United States minor outlying islands', 1, NULL, NULL),
(233, 'UY', 'Uruguay', 1, NULL, NULL),
(234, 'UZ', 'Uzbekistan', 1, NULL, NULL),
(235, 'VU', 'Vanuatu', 1, NULL, NULL),
(236, 'VA', 'Vatican City State', 1, NULL, NULL),
(237, 'VE', 'Venezuela', 1, NULL, NULL),
(238, 'VN', 'Vietnam', 1, NULL, NULL),
(239, 'VG', 'Virgin Islands (British)', 1, NULL, NULL),
(240, 'VI', 'Virgin Islands (U.S.)', 1, NULL, NULL),
(241, 'WF', 'Wallis and Futuna Islands', 1, NULL, NULL),
(242, 'EH', 'Western Sahara', 1, NULL, NULL),
(243, 'YE', 'Yemen', 1, NULL, NULL),
(244, 'ZR', 'Zaire', 1, NULL, NULL),
(245, 'ZM', 'Zambia', 1, NULL, NULL),
(246, 'ZW', 'Zimbabwe', 1, NULL, NULL);

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

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

CREATE TABLE IF NOT EXISTS `coupons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `details` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `discount` double(20,2) NOT NULL,
  `discount_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `start_date` int NOT NULL,
  `end_date` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `type`, `code`, `details`, `discount`, `discount_type`, `start_date`, `end_date`, `created_at`, `updated_at`) VALUES
(1, 'product_base', '1212', '[{\"product_id\":\"8\"},{\"product_id\":\"7\"},{\"product_id\":\"6\"}]', 100.00, 'amount', 1788112800, 1788112800, '2023-11-24 01:28:21', '2025-11-24 09:18:27');

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

--
-- Table structure for table `coupon_usages`
--

CREATE TABLE IF NOT EXISTS `coupon_usages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `coupon_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `currencies`
--

CREATE TABLE IF NOT EXISTS `currencies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `symbol` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `exchange_rate` double(10,5) NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `symbol`, `exchange_rate`, `status`, `code`, `created_at`, `updated_at`) VALUES
(1, 'U.S. Dollar', '$', 1.00000, 1, 'USD', '2018-10-09 11:35:08', '2018-10-17 05:50:52'),
(2, 'Australian Dollar', '$', 1.28000, 1, 'AUD', '2018-10-09 11:35:08', '2019-02-04 05:51:55'),
(5, 'Brazilian Real', 'R$', 3.25000, 1, 'BRL', '2018-10-09 11:35:08', '2018-10-17 05:51:00'),
(6, 'Canadian Dollar', '$', 1.27000, 1, 'CAD', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(7, 'Czech Koruna', 'Kč', 20.65000, 1, 'CZK', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(8, 'Danish Krone', 'kr', 6.05000, 1, 'DKK', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(9, 'Euro', '€', 0.85000, 1, 'EUR', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(10, 'Hong Kong Dollar', '$', 7.83000, 1, 'HKD', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(11, 'Hungarian Forint', 'Ft', 255.24000, 1, 'HUF', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(12, 'Israeli New Sheqel', '₪', 3.48000, 1, 'ILS', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(13, 'Japanese Yen', '¥', 107.12000, 1, 'JPY', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(14, 'Malaysian Ringgit', 'RM', 3.91000, 1, 'MYR', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(15, 'Mexican Peso', '$', 18.72000, 1, 'MXN', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(16, 'Norwegian Krone', 'kr', 7.83000, 1, 'NOK', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(17, 'New Zealand Dollar', '$', 1.38000, 1, 'NZD', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(18, 'Philippine Peso', '₱', 52.26000, 1, 'PHP', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(19, 'Polish Zloty', 'zł', 3.39000, 1, 'PLN', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(20, 'Pound Sterling', '£', 0.72000, 1, 'GBP', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(21, 'Russian Ruble', 'руб', 55.93000, 1, 'RUB', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(22, 'Singapore Dollar', '$', 1.32000, 1, 'SGD', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(23, 'Swedish Krona', 'kr', 8.19000, 1, 'SEK', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(24, 'Swiss Franc', 'CHF', 0.94000, 1, 'CHF', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(26, 'Thai Baht', '฿', 31.39000, 1, 'THB', '2018-10-09 11:35:08', '2018-10-09 11:35:08'),
(27, 'Taka', '৳', 84.00000, 1, 'BDT', '2018-10-09 11:35:08', '2018-12-02 05:16:13'),
(28, 'Indian Rupee', 'Rs', 68.45000, 1, 'Rupee', '2019-07-07 10:33:46', '2019-07-07 10:33:46');

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

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

CREATE TABLE IF NOT EXISTS `customers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `user_id`, `created_at`, `updated_at`) VALUES
(4, 8, '2019-08-01 10:35:09', '2019-08-01 10:35:09'),
(5, 10, '2023-11-23 15:27:08', '2023-11-23 15:27:08'),
(6, 11, '2023-11-24 01:23:11', '2023-11-24 01:23:11'),
(7, 12, '2023-12-03 21:31:54', '2023-12-03 21:31:54'),
(8, 13, '2024-04-23 10:25:25', '2024-04-23 10:25:25'),
(9, 14, '2024-04-23 10:47:49', '2024-04-23 10:47:49'),
(10, 15, '2024-04-24 09:04:24', '2024-04-24 09:04:24'),
(11, 16, '2025-09-04 14:25:45', '2025-09-04 14:25:45'),
(12, 17, '2025-11-04 02:44:03', '2025-11-04 02:44:03'),
(13, 18, '2025-11-10 02:51:41', '2025-11-10 02:51:41');

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

--
-- Table structure for table `customer_packages`
--

CREATE TABLE IF NOT EXISTS `customer_packages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double(20,2) DEFAULT NULL,
  `product_upload` int DEFAULT NULL,
  `logo` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `customer_package_payments`
--

CREATE TABLE IF NOT EXISTS `customer_package_payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `customer_package_id` int NOT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `payment_details` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `approval` int NOT NULL,
  `offline_payment` int NOT NULL COMMENT '1=offline payment\r\n2=online paymnet',
  `reciept` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `customer_package_translations`
--

CREATE TABLE IF NOT EXISTS `customer_package_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `customer_package_id` bigint NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `customer_products`
--

CREATE TABLE IF NOT EXISTS `customer_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `published` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `added_by` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `subcategory_id` int DEFAULT NULL,
  `subsubcategory_id` int DEFAULT NULL,
  `brand_id` int DEFAULT NULL,
  `photos` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `thumbnail_img` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `conditon` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `location` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `video_provider` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `video_link` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `unit` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tags` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `unit_price` double(20,2) DEFAULT '0.00',
  `meta_title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_description` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_img` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pdf` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `customer_product_translations`
--

CREATE TABLE IF NOT EXISTS `customer_product_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `customer_product_id` bigint NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `unit` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `firebase_notifications`
--

CREATE TABLE IF NOT EXISTS `firebase_notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `text` text,
  `item_type` varchar(255) NOT NULL,
  `item_type_id` int NOT NULL,
  `receiver_id` int NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `flash_deals`
--

CREATE TABLE IF NOT EXISTS `flash_deals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `start_date` int DEFAULT NULL,
  `end_date` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `featured` int NOT NULL DEFAULT '0',
  `background_color` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `text_color` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `flash_deals`
--

INSERT INTO `flash_deals` (`id`, `title`, `start_date`, `end_date`, `status`, `featured`, `background_color`, `text_color`, `banner`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Friday Deal', 1700697600, 1700956740, 0, 0, '#FFFFFF', 'dark', '20', 'friday-deal-ctona', '2023-11-23 15:24:12', '2023-11-23 15:24:12');

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

--
-- Table structure for table `flash_deal_products`
--

CREATE TABLE IF NOT EXISTS `flash_deal_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `flash_deal_id` int NOT NULL,
  `product_id` int NOT NULL,
  `discount` double(20,2) DEFAULT '0.00',
  `discount_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `flash_deal_products`
--

INSERT INTO `flash_deal_products` (`id`, `flash_deal_id`, `product_id`, `discount`, `discount_type`, `created_at`, `updated_at`) VALUES
(5, 1, 7, 0.00, NULL, '2023-11-23 15:25:42', '2023-11-23 15:25:42'),
(6, 1, 8, 0.00, NULL, '2023-11-23 15:25:42', '2023-11-23 15:25:42');

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

--
-- Table structure for table `flash_deal_translations`
--

CREATE TABLE IF NOT EXISTS `flash_deal_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `flash_deal_id` bigint NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `flash_deal_translations`
--

INSERT INTO `flash_deal_translations` (`id`, `flash_deal_id`, `title`, `lang`, `created_at`, `updated_at`) VALUES
(1, 1, 'Friday Deal', 'en', '2023-11-23 15:24:12', '2023-11-23 15:24:12');

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE IF NOT EXISTS `general_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `frontend_color` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'default',
  `logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `footer_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `admin_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `admin_login_background` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `admin_login_sidebar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `favicon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `site_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `phone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `facebook` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `instagram` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `twitter` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `youtube` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `google_plus` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`id`, `frontend_color`, `logo`, `footer_logo`, `admin_logo`, `admin_login_background`, `admin_login_sidebar`, `favicon`, `site_name`, `address`, `description`, `phone`, `email`, `facebook`, `instagram`, `twitter`, `youtube`, `google_plus`, `created_at`, `updated_at`) VALUES
(1, 'default', 'uploads/logo/pfdIuiMeXGkDAIpPEUrvUCbQrOHu484nbGfz77zB.png', NULL, 'uploads/admin_logo/wCgHrz0Q5QoL1yu4vdrNnQIr4uGuNL48CXfcxOuS.png', NULL, NULL, 'uploads/favicon/uHdGidSaRVzvPgDj6JFtntMqzJkwDk9659233jrb.png', 'Active Ecommerce CMS', 'Demo Address', 'Active eCommerce CMS is a Multi vendor system is such a platform to build a border less marketplace.', '1234567890', 'admin@example.com', 'https://www.facebook.com', 'https://www.instagram.com', 'https://www.twitter.com', 'https://www.youtube.com', 'https://www.googleplus.com', '2019-03-13 08:01:06', '2019-03-13 02:01:06');

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

--
-- Table structure for table `home_categories`
--

CREATE TABLE IF NOT EXISTS `home_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL,
  `subsubcategories` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `home_categories`
--

INSERT INTO `home_categories` (`id`, `category_id`, `subsubcategories`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '[\"1\"]', 1, '2019-03-12 06:38:23', '2019-03-12 06:38:23'),
(2, 2, '[\"10\"]', 1, '2019-03-12 06:44:54', '2019-03-12 06:44:54');

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

--
-- Table structure for table `languages`
--

CREATE TABLE IF NOT EXISTS `languages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rtl` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `name`, `code`, `rtl`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 0, '2019-01-20 12:13:20', '2019-01-20 12:13:20'),
(3, 'Bangla', 'bd', 0, '2019-02-17 06:35:37', '2019-02-18 06:49:51'),
(4, 'Arabic', 'sa', 1, '2019-04-28 18:34:12', '2019-04-28 18:34:12'),
(5, 'Japan', 'jp', 0, '2025-11-04 02:34:25', '2025-11-04 02:34:25');

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

--
-- Table structure for table `links`
--

CREATE TABLE IF NOT EXISTS `links` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `manual_payment_methods`
--

CREATE TABLE IF NOT EXISTS `manual_payment_methods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `heading` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `bank_info` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `photo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `manual_payment_methods`
--

INSERT INTO `manual_payment_methods` (`id`, `type`, `heading`, `description`, `bank_info`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'bank_payment', 'Bank Transfer', '<p>Bank Transfer<br>Bank Transfer</p>', '[{\"bank_name\":\"UCB\",\"account_name\":\"Halal Shop\",\"account_number\":\"24346567000976\",\"routing_number\":\"234567\"}]', '31', '2025-11-22 18:08:36', '2025-11-23 05:53:06'),
(2, 'check_payment', 'Check Payment', '<p><br></p>', NULL, '32', '2025-11-23 05:53:44', '2025-11-23 06:00:33');

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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `conversation_id` int NOT NULL,
  `user_id` int NOT NULL,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `conversation_id`, `user_id`, `message`, `created_at`, `updated_at`) VALUES
(1, 1, 9, 'https://onlineshop.asifsyed.com/product/mens-shirt-lwtdl', '2023-11-23 22:20:58', '2023-11-23 22:20:58');

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

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

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2025_11_26_000001_create_stores_table', 2),
(4, '2025_11_27_000001_add_logo_to_stores_table', 3),
(5, '2025_11_27_000002_create_store_translations_table', 4);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE IF NOT EXISTS `notifications` (
  `id` char(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `notifiable_type` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `notifiable_id` bigint UNSIGNED NOT NULL,
  `data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('088a2582-3bd2-4628-a77e-49f27438ceba', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":23,\"order_code\":\"20251123-13581861\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:58:19', '2025-11-23 07:58:19'),
('0daf9020-20fa-4cd1-a58b-1a2936ab3b51', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":9,\"order_code\":\"20251123-12321069\",\"user_id\":18,\"seller_id\":9,\"status\":\"delivered\"}', NULL, '2025-11-23 07:35:23', '2025-11-23 07:35:23'),
('15d6de2c-b241-4c93-bd66-470569e53d0d', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":18,\"order_code\":\"20251123-13384267\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:38:42', '2025-11-23 07:38:42'),
('1852bb96-6ca3-4c35-b0e8-ae986aaa80dc', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":6,\"order_code\":\"20251119-15144199\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 09:14:41', '2025-11-19 09:14:41'),
('1f60b6d9-a8b0-4f12-b40a-a88b42ff1aec', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":14,\"order_code\":\"20251123-13304638\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:30:46', '2025-11-23 07:30:46'),
('2087719d-75d5-40cb-8238-fd10c190606f', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":27,\"order_code\":\"20251124-15550731\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-24 09:55:07', '2025-11-24 09:55:07'),
('21f5b69a-5adb-44e8-8c95-5f2225b849d5', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":11,\"order_code\":\"20251123-13293086\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:29:30', '2025-11-23 07:29:30'),
('25c5d818-c205-44d4-9a9d-e0712dab4b65', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":29,\"order_code\":\"20251125-16442944\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-25 10:44:29', '2025-11-25 10:44:29'),
('29099d20-3512-4ee7-a8a6-94836a9906a2', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":3,\"order_code\":\"20251119-11442455\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', '2025-11-19 06:10:43', '2025-11-19 05:44:24', '2025-11-19 06:10:43'),
('2985ddbc-7a66-47c3-99ea-47fcc6ccbd95', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":16,\"order_code\":\"20251123-13312478\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:31:24', '2025-11-23 07:31:24'),
('2b2d0f5e-a5ed-4ebc-98dc-8f9deee3881c', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":14,\"order_code\":\"20251123-13304638\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:30:46', '2025-11-23 07:30:46'),
('2b3b76dc-3d81-4482-b24e-24c79672ed4e', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":13,\"order_code\":\"20251123-13302057\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:30:20', '2025-11-23 07:30:20'),
('309ab188-587d-4e9e-9d29-33c593759637', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":8,\"order_code\":\"20251123-11393740\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 05:39:38', '2025-11-23 05:39:38'),
('352abc14-8a05-448e-9866-c1ce9e849ec1', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":6,\"order_code\":\"20251119-15144199\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 09:14:41', '2025-11-19 09:14:41'),
('37d0ab30-da7d-4ef1-bffd-8da3e3746ce5', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":5,\"order_code\":\"20251119-15050363\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 09:05:03', '2025-11-19 09:05:03'),
('3fcc5acb-fd03-4a81-9777-d64747eb91c0', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":28,\"order_code\":\"20251124-16103420\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-24 10:10:35', '2025-11-24 10:10:35'),
('4580a588-95c5-47b6-8c6c-516403257734', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":9,\"order_code\":\"20251123-12321069\",\"user_id\":18,\"seller_id\":9,\"status\":\"delivered\"}', NULL, '2025-11-23 07:35:23', '2025-11-23 07:35:23'),
('49e2c548-09b3-47b9-b4b8-a52be65204b6', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":20,\"order_code\":\"20251123-13465183\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:46:51', '2025-11-23 07:46:51'),
('4a614ef1-ad85-4723-b699-c7b9620f5d51', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":5,\"order_code\":\"20251119-15050363\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 09:05:03', '2025-11-19 09:05:03'),
('4b15f3e4-bfe6-4345-b36a-3b3d1d0c70ad', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":19,\"order_code\":\"20251123-13390271\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:39:02', '2025-11-23 07:39:02'),
('4c7b8459-14d7-40e9-a0f5-76114652cb55', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":11,\"order_code\":\"20251123-13293086\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:29:30', '2025-11-23 07:29:30'),
('53897967-5830-43ae-bd30-ac1da68e6ab7', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":8,\"order_code\":\"20251123-11393740\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 05:39:38', '2025-11-23 05:39:38'),
('5398636e-ccff-4859-a667-ae2c37a52baa', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":32,\"order_code\":\"20251127-14160235\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-27 08:16:02', '2025-11-27 08:16:02'),
('616dc36b-f830-4194-86a9-3bc963e91ad1', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":30,\"order_code\":\"20251126-16305166\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-26 10:30:51', '2025-11-26 10:30:51'),
('6254dbc2-0f15-405f-8bd7-f24d5ebd31da', 'App\\Notifications\\OrderNotification', 'App\\User', 17, '{\"order_id\":2,\"order_code\":\"20251103-21480566\",\"user_id\":17,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-04 02:48:05', '2025-11-04 02:48:05'),
('632e932a-4254-447d-bedb-f3ca7d9d4413', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":26,\"order_code\":\"20251123-16481290\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 10:48:12', '2025-11-23 10:48:12'),
('66b23cdb-cf9e-4f8e-b1c2-683ef7717b5b', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":1,\"order_code\":\"20231123-17322210\",\"user_id\":10,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2023-11-23 22:32:23', '2023-11-23 22:32:23'),
('6ccea099-de81-451a-98c3-9d690ae01383', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":24,\"order_code\":\"20251123-13585580\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:58:55', '2025-11-23 07:58:55'),
('71247f14-7021-4717-91ad-0af21bfae0d6', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":15,\"order_code\":\"20251123-13311683\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:31:17', '2025-11-23 07:31:17'),
('7277df71-97df-4af9-8082-387d5e51038c', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":26,\"order_code\":\"20251123-16481290\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 10:48:12', '2025-11-23 10:48:12'),
('72fc0924-484e-4b91-8ecb-7cf9def7dfd8', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":24,\"order_code\":\"20251123-13585580\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:58:55', '2025-11-23 07:58:55'),
('763174cf-8790-470a-b805-9909cc5024c1', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":20,\"order_code\":\"20251123-13465183\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:46:51', '2025-11-23 07:46:51'),
('7cb5fed0-6c96-40ad-9b71-dca3e58c239d', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":25,\"order_code\":\"20251123-14035415\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 08:03:54', '2025-11-23 08:03:54'),
('85a0cd17-3353-4000-ab8e-7089a2c75c14', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":4,\"order_code\":\"20251119-14375093\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 08:37:50', '2025-11-19 08:37:50'),
('86153a22-ff95-42bc-9ac4-e1aa9830cf3c', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":25,\"order_code\":\"20251123-14035415\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 08:03:54', '2025-11-23 08:03:54'),
('87e379b3-237d-4dc1-8d2c-00f795471df0', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":9,\"order_code\":\"20251123-12321069\",\"user_id\":18,\"seller_id\":9,\"status\":\"confirmed\"}', NULL, '2025-11-23 07:35:16', '2025-11-23 07:35:16'),
('95823f88-ea9e-49b7-9bcd-cc040fd27ccc', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":3,\"order_code\":\"20251119-11442455\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 05:44:24', '2025-11-19 05:44:24'),
('95f96f70-4e7a-464d-b560-8b098f36066d', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":7,\"order_code\":\"20251119-15175163\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 09:17:51', '2025-11-19 09:17:51'),
('966b2606-3055-4320-849e-fa3394449d84', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":9,\"order_code\":\"20251123-12321069\",\"user_id\":18,\"seller_id\":9,\"status\":\"confirmed\"}', NULL, '2025-11-23 07:35:16', '2025-11-23 07:35:16'),
('acc643ed-c86c-423b-8855-d8945fd71cc9', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":17,\"order_code\":\"20251123-13331022\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:33:10', '2025-11-23 07:33:10'),
('af505799-4225-4e5d-a8a9-ad8124f349a9', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":10,\"order_code\":\"20251123-12324025\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 06:32:41', '2025-11-23 06:32:41'),
('b0b73414-29c7-4444-b513-acca93f3a87d', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":2,\"order_code\":\"20251103-21480566\",\"user_id\":17,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-04 02:48:05', '2025-11-04 02:48:05'),
('b1c5a581-822b-412d-95bd-6bcd16cb2a23', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":10,\"order_code\":\"20251123-12324025\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 06:32:41', '2025-11-23 06:32:41'),
('b34386f0-2d04-45d2-971b-c7efb6a25f77', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":19,\"order_code\":\"20251123-13390271\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:39:02', '2025-11-23 07:39:02'),
('b478b79c-3535-4bb5-9a6f-953910b7fc22', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":16,\"order_code\":\"20251123-13312478\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:31:24', '2025-11-23 07:31:24'),
('bd9598e7-c90a-476d-8864-9ac7e6c98aef', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":18,\"order_code\":\"20251123-13384267\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:38:43', '2025-11-23 07:38:43'),
('be53b525-b670-46e5-a9e9-14646a52f7a5', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":12,\"order_code\":\"20251123-13294989\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:29:49', '2025-11-23 07:29:49'),
('c12ce135-6f38-46cf-ad0f-a562759c7c9d', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":4,\"order_code\":\"20251119-14375093\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 08:37:50', '2025-11-19 08:37:50'),
('c5daa23e-a1f6-4500-b21f-f834e4debe16', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":31,\"order_code\":\"20251126-16551197\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-26 10:55:11', '2025-11-26 10:55:11'),
('c90ac4f9-c35c-496d-9d63-d2b6507e3e39', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":12,\"order_code\":\"20251123-13294989\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:29:49', '2025-11-23 07:29:49'),
('cf983413-12a5-4855-84a1-9c925514fc24', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":9,\"order_code\":\"20251123-12321069\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 06:32:10', '2025-11-23 06:32:10'),
('d2efce26-2c95-49f5-a246-ef88044a0f7d', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":9,\"order_code\":\"20251123-12321069\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 06:32:10', '2025-11-23 06:32:10'),
('d34d19e1-2db6-434c-9fdf-6674b7c3208f', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":28,\"order_code\":\"20251124-16103420\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-24 10:10:35', '2025-11-24 10:10:35'),
('d4a0bc55-8021-4beb-a426-c07e3a9c622c', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":30,\"order_code\":\"20251126-16305166\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-26 10:30:51', '2025-11-26 10:30:51'),
('dc63a2e3-bc10-446f-8ef0-f2d01015ee79', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":27,\"order_code\":\"20251124-15550731\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-24 09:55:07', '2025-11-24 09:55:07'),
('e1ef476e-fb05-4914-839c-bd37889fe717', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":7,\"order_code\":\"20251119-15175163\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-19 09:17:51', '2025-11-19 09:17:51'),
('e27fcb00-5440-4fff-b6fe-71f9bed4869c', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":31,\"order_code\":\"20251126-16551197\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-26 10:55:11', '2025-11-26 10:55:11'),
('e564b079-d880-4963-9474-29c12afec6c7', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":32,\"order_code\":\"20251127-14160235\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-27 08:16:02', '2025-11-27 08:16:02'),
('e7352c47-fad6-4b80-8666-93363b33434e', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":13,\"order_code\":\"20251123-13302057\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:30:20', '2025-11-23 07:30:20'),
('ea9b7228-57fd-4e8c-b417-ad0b149cc9ef', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":17,\"order_code\":\"20251123-13331022\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:33:10', '2025-11-23 07:33:10'),
('f2edea24-8abb-4186-9c3b-19b379adf763', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":15,\"order_code\":\"20251123-13311683\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:31:17', '2025-11-23 07:31:17'),
('f6913d2e-09de-4dd9-ba02-a2d7d83c4a5d', 'App\\Notifications\\OrderNotification', 'App\\User', 10, '{\"order_id\":1,\"order_code\":\"20231123-17322210\",\"user_id\":10,\"seller_id\":\"9\",\"status\":\"placed\"}', '2023-11-23 23:03:52', '2023-11-23 22:32:23', '2023-11-23 23:03:52'),
('f848988e-efa9-45bc-af38-8570a6ae67fe', 'App\\Notifications\\OrderNotification', 'App\\User', 9, '{\"order_id\":29,\"order_code\":\"20251125-16442944\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-25 10:44:29', '2025-11-25 10:44:29'),
('fe44b47d-7fad-4e05-9e69-ab7ff7cd8449', 'App\\Notifications\\OrderNotification', 'App\\User', 18, '{\"order_id\":23,\"order_code\":\"20251123-13581861\",\"user_id\":18,\"seller_id\":\"9\",\"status\":\"placed\"}', NULL, '2025-11-23 07:58:19', '2025-11-23 07:58:19');

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

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE IF NOT EXISTS `oauth_access_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `client_id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('04d38a4e4ca793677acc10cca00b2f81203278c48505113d983cf03cf9c3a9e5c8112b69b7fce099', 16, 1, 'Personal Access Token', '[]', 0, '2025-09-05 16:21:28', '2025-09-05 16:21:28', '2027-08-06 12:21:28'),
('125ce8289850f80d9fea100325bf892fbd0deba1f87dbfc2ab81fb43d57377ec24ed65f7dc560e46', 1, 1, 'Personal Access Token', '[]', 0, '2019-07-30 04:51:13', '2019-07-30 04:51:13', '2020-07-30 10:51:13'),
('293d2bb534220c070c4e90d25b5509965d23d3ddbc05b1e29fb4899ae09420ff112dbccab1c6f504', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 06:00:04', '2019-08-04 06:00:04', '2020-08-04 12:00:04'),
('5363e91c7892acdd6417aa9c7d4987d83568e229befbd75be64282dbe8a88147c6c705e06c1fb2bf', 1, 1, 'Personal Access Token', '[]', 0, '2019-07-13 06:44:28', '2019-07-13 06:44:28', '2020-07-13 12:44:28'),
('681b4a4099fac5e12517307b4027b54df94cbaf0cbf6b4bf496534c94f0ccd8a79dd6af9742d076b', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 07:23:06', '2019-08-04 07:23:06', '2020-08-04 13:23:06'),
('6d229e3559e568df086c706a1056f760abc1370abe74033c773490581a042442154afa1260c4b6f0', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 07:32:12', '2019-08-04 07:32:12', '2020-08-04 13:32:12'),
('6efc0f1fc3843027ea1ea7cd35acf9c74282f0271c31d45a164e7b27025a315d31022efe7bb94aaa', 1, 1, 'Personal Access Token', '[]', 0, '2019-08-08 02:35:26', '2019-08-08 02:35:26', '2020-08-08 08:35:26'),
('7745b763da15a06eaded371330072361b0524c41651cf48bf76fc1b521a475ece78703646e06d3b0', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 07:29:44', '2019-08-04 07:29:44', '2020-08-04 13:29:44'),
('815b625e239934be293cd34479b0f766bbc1da7cc10d464a2944ddce3a0142e943ae48be018ccbd0', 1, 1, 'Personal Access Token', '[]', 1, '2019-07-22 02:07:47', '2019-07-22 02:07:47', '2020-07-22 08:07:47'),
('8921a4c96a6d674ac002e216f98855c69de2568003f9b4136f6e66f4cb9545442fb3e37e91a27cad', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 06:05:05', '2019-08-04 06:05:05', '2020-08-04 12:05:05'),
('8d8b85720304e2f161a66564cec0ecd50d70e611cc0efbf04e409330086e6009f72a39ce2191f33a', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 06:44:35', '2019-08-04 06:44:35', '2020-08-04 12:44:35'),
('bcaaebdead4c0ef15f3ea6d196fd80749d309e6db8603b235e818cb626a5cea034ff2a55b66e3e1a', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 07:14:32', '2019-08-04 07:14:32', '2020-08-04 13:14:32'),
('c25417a5c728073ca8ba57058ded43d496a9d2619b434d2a004dd490a64478c08bc3e06ffc1be65d', 1, 1, 'Personal Access Token', '[]', 1, '2019-07-30 01:45:31', '2019-07-30 01:45:31', '2020-07-30 07:45:31'),
('c7423d85b2b5bdc5027cb283be57fa22f5943cae43f60b0ed27e6dd198e46f25e3501b3081ed0777', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-05 05:02:59', '2019-08-05 05:02:59', '2020-08-05 11:02:59'),
('cb2ae18bb87c3ca9b4bed3464cf39257176cc8ee6e638b6084cf2fc84959f8eb5b2f655f7793cd5f', 16, 1, 'Personal Access Token', '[]', 0, '2025-09-05 16:19:53', '2025-09-05 16:19:53', '2027-08-06 12:19:53'),
('e76f19dbd5c2c4060719fb1006ac56116fd86f7838b4bf74e2c0a0ac9696e724df1e517dbdb357f4', 1, 1, 'Personal Access Token', '[]', 1, '2019-07-15 02:53:40', '2019-07-15 02:53:40', '2020-07-15 08:53:40'),
('ed7c269dd6f9a97750a982f62e0de54749be6950e323cdfef892a1ec93f8ddbacf9fe26e6a42180e', 1, 1, 'Personal Access Token', '[]', 1, '2019-07-13 06:36:45', '2019-07-13 06:36:45', '2020-07-13 12:36:45'),
('efd54a9ead017bf197768806573702986a040c18ae56429fae6ad6c71c2c3358123b1ff391792f90', 16, 1, 'Personal Access Token', '[]', 0, '2025-09-04 14:38:43', '2025-09-04 14:38:43', '2027-08-05 10:38:43'),
('f6d1475bc17a27e389000d3df4da5c5004ce7610158b0dd414226700c0f6db48914637b4c76e1948', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 07:22:01', '2019-08-04 07:22:01', '2020-08-04 13:22:01'),
('f85e4e444fc954430170c41779a4238f84cd6fed905f682795cd4d7b6a291ec5204a10ac0480eb30', 1, 1, 'Personal Access Token', '[]', 1, '2019-07-30 06:38:49', '2019-07-30 06:38:49', '2020-07-30 12:38:49'),
('f8bf983a42c543b99128296e4bc7c2d17a52b5b9ef69670c629b93a653c6a4af27be452e0c331f79', 1, 1, 'Personal Access Token', '[]', 1, '2019-08-04 07:28:55', '2019-08-04 07:28:55', '2020-08-04 13:28:55');

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE IF NOT EXISTS `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `client_id` int UNSIGNED NOT NULL,
  `scopes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE IF NOT EXISTS `oauth_clients` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `redirect` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'eR2y7WUuem28ugHKppFpmss7jPyOHZsMkQwBo1Jj', 'http://localhost', 1, 0, 0, '2019-07-13 06:17:34', '2019-07-13 06:17:34'),
(2, NULL, 'Laravel Password Grant Client', 'WLW2Ol0GozbaXEnx1NtXoweYPuKEbjWdviaUgw77', 'http://localhost', 0, 1, 0, '2019-07-13 06:17:34', '2019-07-13 06:17:34');

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE IF NOT EXISTS `oauth_personal_access_clients` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2019-07-13 06:17:34', '2019-07-13 06:17:34');

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE IF NOT EXISTS `oauth_refresh_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `access_token_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `store_id` bigint DEFAULT NULL,
  `guest_id` int DEFAULT NULL,
  `seller_id` int DEFAULT NULL,
  `shipping_address` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `delivery_status` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'pending',
  `payment_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `manual_payment` int NOT NULL DEFAULT '0',
  `manual_payment_data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `payment_status` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'unpaid',
  `payment_details` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `grand_total` double(20,2) DEFAULT NULL,
  `coupon_discount` double(20,2) NOT NULL DEFAULT '0.00',
  `club_point_discount` double(20,2) NOT NULL DEFAULT '0.00',
  `code` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `date` int NOT NULL,
  `viewed` int NOT NULL DEFAULT '0',
  `delivery_viewed` int NOT NULL DEFAULT '1',
  `payment_status_viewed` int DEFAULT '1',
  `commission_calculated` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `store_id`, `guest_id`, `seller_id`, `shipping_address`, `delivery_status`, `payment_type`, `manual_payment`, `manual_payment_data`, `payment_status`, `payment_details`, `grand_total`, `coupon_discount`, `club_point_discount`, `code`, `date`, `viewed`, `delivery_viewed`, `payment_status_viewed`, `commission_calculated`, `created_at`, `updated_at`) VALUES
(1, 10, NULL, NULL, 9, '{\"id\":1,\"user_id\":\"10\",\"address\":\"Muradpur School Road\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1204\",\"phone\":\"+8801998126567\",\"set_default\":\"0\",\"created_at\":\"2023-11-23 17:31:21\",\"updated_at\":\"2023-11-23 17:31:21\",\"name\":\"SYED MD. ASIF HOSSAIN\",\"email\":\"asif48708698@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 500.00, 0.00, 0.00, '20231123-17322210', 1700739142, 0, 1, 1, 0, '2023-11-23 22:32:22', '2023-11-23 22:34:21'),
(2, 17, NULL, NULL, 9, '{\"id\":3,\"user_id\":\"17\",\"address\":\"Dhaka\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":\"0\",\"created_at\":\"2025-11-03 21:45:20\",\"updated_at\":\"2025-11-03 21:45:20\",\"name\":\"NIloy\",\"email\":\"niloy@gmail.com\"}', 'pending', 'proxypay', 0, NULL, 'unpaid', NULL, 400.00, 0.00, 0.00, '20251103-21480566', 1762184885, 0, 0, 0, 0, '2025-11-04 02:48:05', '2025-11-04 02:48:05'),
(3, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 400.00, 0.00, 0.00, '20251119-11442455', 1763531064, 0, 1, 1, 0, '2025-11-19 05:44:24', '2025-11-19 05:45:08'),
(4, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 400.00, 0.00, 0.00, '20251119-14375093', 1763541470, 0, 1, 1, 0, '2025-11-19 08:37:50', '2025-11-19 08:47:50'),
(5, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 400.00, 0.00, 0.00, '20251119-15050363', 1763543103, 0, 0, 0, 0, '2025-11-19 09:05:03', '2025-11-19 09:05:03'),
(6, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'proxypay', 0, NULL, 'unpaid', NULL, 400.00, 0.00, 0.00, '20251119-15144199', 1763543681, 0, 0, 0, 0, '2025-11-19 09:14:41', '2025-11-19 09:14:41'),
(7, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 400.00, 0.00, 0.00, '20251119-15175163', 1763543871, 0, 0, 0, 0, '2025-11-19 09:17:51', '2025-11-19 09:17:51'),
(8, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 1000.00, 0.00, 0.00, '20251123-11393740', 1763876377, 0, 0, 0, 0, '2025-11-23 05:39:37', '2025-11-23 05:39:38'),
(9, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'delivered', 'wallet', 0, NULL, 'paid', NULL, 400.00, 0.00, 0.00, '20251123-12321069', 1763879530, 0, 0, 1, 0, '2025-11-23 06:32:10', '2025-11-23 07:35:23'),
(23, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'wallet', 0, NULL, 'paid', NULL, 1000.00, 0.00, 0.00, '20251123-13581861', 1763884698, 0, 0, 0, 0, '2025-11-23 07:58:18', '2025-11-23 07:58:19'),
(24, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'wallet', 0, NULL, 'paid', NULL, 1000.00, 0.00, 0.00, '20251123-13585580', 1763884735, 0, 0, 0, 1, '2025-11-23 07:58:55', '2025-11-23 07:58:55'),
(25, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'wallet', 0, NULL, 'paid', NULL, 400.00, 0.00, 0.00, '20251123-14035415', 1763885034, 0, 0, 0, 1, '2025-11-23 08:03:54', '2025-11-23 08:03:54'),
(26, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'wallet', 0, NULL, 'paid', NULL, 400.00, 0.00, 0.00, '20251123-16481290', 1763894892, 0, 1, 1, 1, '2025-11-23 10:48:12', '2025-11-23 10:49:23'),
(27, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'wallet', 0, NULL, 'paid', NULL, 400.00, 0.00, 0.00, '20251124-15550731', 1763978107, 0, 1, 1, 1, '2025-11-24 09:55:07', '2025-11-24 09:56:27'),
(28, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'wallet', 0, NULL, 'paid', NULL, 400.00, 0.00, 0.00, '20251124-16103420', 1763979034, 0, 0, 0, 1, '2025-11-24 10:10:34', '2025-11-24 10:10:35'),
(29, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'wallet', 0, NULL, 'paid', NULL, 300.00, 0.00, 100.00, '20251125-16442944', 1764067469, 1, 0, 0, 1, '2025-11-25 10:44:29', '2025-11-25 10:50:39'),
(30, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 5000.00, 0.00, 0.00, '20251126-16305166', 1764153051, 0, 0, 0, 0, '2025-11-26 10:30:51', '2025-11-27 07:16:10'),
(31, 18, NULL, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 5000.00, 0.00, 0.00, '20251126-16551197', 1764154511, 0, 0, 0, 0, '2025-11-26 10:55:11', '2025-11-27 07:16:10'),
(32, 18, 2, NULL, 9, '{\"id\":4,\"user_id\":18,\"address\":\"hfh\",\"country\":\"Bangladesh\",\"city\":\"Dhaka\",\"longitude\":null,\"latitude\":null,\"postal_code\":\"1212\",\"phone\":\"01727532825\",\"set_default\":0,\"created_at\":\"2025-11-10 09:01:03\",\"updated_at\":\"2025-11-10 09:01:03\",\"name\":\"test\",\"email\":\"test@gmail.com\"}', 'pending', 'cash_on_delivery', 0, NULL, 'unpaid', NULL, 5000.00, 0.00, 0.00, '20251127-14160235', 1764231362, 0, 0, 0, 0, '2025-11-27 08:16:02', '2025-11-27 08:16:02');

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

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

CREATE TABLE IF NOT EXISTS `order_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `seller_id` int DEFAULT NULL,
  `product_id` int NOT NULL,
  `variation` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `price` double(20,2) DEFAULT NULL,
  `tax` double(20,2) NOT NULL DEFAULT '0.00',
  `shipping_cost` double(20,2) NOT NULL DEFAULT '0.00',
  `quantity` int DEFAULT NULL,
  `payment_status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'unpaid',
  `delivery_status` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'pending',
  `shipping_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pickup_point_id` int DEFAULT NULL,
  `product_referral_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `earn_point` double(25,3) NOT NULL DEFAULT '0.000',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `order_details`
--

INSERT INTO `order_details` (`id`, `order_id`, `seller_id`, `product_id`, `variation`, `price`, `tax`, `shipping_cost`, `quantity`, `payment_status`, `delivery_status`, `shipping_type`, `pickup_point_id`, `product_referral_code`, `earn_point`, `created_at`, `updated_at`) VALUES
(1, 1, 9, 8, 'Aqua-', 500.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2023-11-23 22:32:22', '2023-11-23 22:32:22'),
(2, 2, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-04 02:48:05', '2025-11-04 02:48:05'),
(3, 3, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-19 05:44:24', '2025-11-19 05:44:24'),
(4, 4, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-19 08:37:50', '2025-11-19 08:37:50'),
(5, 5, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-19 09:05:03', '2025-11-19 09:05:03'),
(6, 6, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-19 09:14:41', '2025-11-19 09:14:41'),
(7, 7, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-19 09:17:51', '2025-11-19 09:17:51'),
(8, 8, 9, 8, 'Aqua-', 1000.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 05:39:38', '2025-11-23 05:39:38'),
(9, 9, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'delivered', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 06:32:10', '2025-11-23 07:35:23'),
(18, 18, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 07:38:42', '2025-11-23 07:38:42'),
(19, 19, 9, 7, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 07:39:02', '2025-11-23 07:39:02'),
(21, 23, 9, 6, 'Aqua-', 1000.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 07:58:18', '2025-11-23 07:58:18'),
(22, 24, 9, 6, 'Aqua-', 1000.00, 0.00, 0.00, 1, 'paid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 07:58:55', '2025-11-23 07:58:55'),
(23, 25, 9, 4, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'paid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 08:03:54', '2025-11-23 08:03:54'),
(24, 26, 9, 4, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'paid', 'pending', 'home_delivery', NULL, NULL, 0.000, '2025-11-23 10:48:12', '2025-11-23 10:48:12'),
(25, 27, 9, 4, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'paid', 'pending', 'home_delivery', NULL, NULL, 200.000, '2025-11-24 09:55:07', '2025-11-24 09:55:07'),
(26, 28, 9, 4, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'paid', 'pending', 'home_delivery', NULL, NULL, 500.000, '2025-11-24 10:10:34', '2025-11-24 10:10:35'),
(27, 29, 9, 4, 'Amethyst-', 400.00, 0.00, 0.00, 1, 'paid', 'pending', 'home_delivery', NULL, NULL, 500.000, '2025-11-25 10:44:29', '2025-11-25 10:44:29'),
(28, 30, 9, 9, 'Amethyst-', 5000.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 400.000, '2025-11-26 10:30:51', '2025-11-26 10:30:51'),
(29, 31, 9, 9, 'Amethyst-', 5000.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 400.000, '2025-11-26 10:55:11', '2025-11-26 10:55:11'),
(30, 32, 9, 9, 'Amethyst-M', 5000.00, 0.00, 0.00, 1, 'unpaid', 'pending', 'home_delivery', NULL, NULL, 400.000, '2025-11-27 08:16:02', '2025-11-27 08:16:02');

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

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

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `meta_title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `meta_description` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `keywords` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_image` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `type`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `keywords`, `meta_image`, `created_at`, `updated_at`) VALUES
(1, 'home_page', 'Home Page', 'home', NULL, NULL, NULL, NULL, NULL, '2020-11-04 10:13:20', '2020-11-04 10:13:20'),
(2, 'seller_policy_page', 'Seller Policy Pages', 'sellerpolicy', NULL, NULL, NULL, NULL, NULL, '2020-11-04 10:14:41', '2020-11-04 12:19:30'),
(3, 'return_policy_page', 'Return Policy Page', 'returnpolicy', NULL, NULL, NULL, NULL, NULL, '2020-11-04 10:14:41', '2020-11-04 10:14:41'),
(4, 'support_policy_page', 'Support Policy Page', 'supportpolicy', NULL, NULL, NULL, NULL, NULL, '2020-11-04 10:14:59', '2020-11-04 10:14:59'),
(5, 'terms_conditions_page', 'Term Conditions Page', 'terms', NULL, NULL, NULL, NULL, NULL, '2020-11-04 10:15:29', '2020-11-04 10:15:29'),
(6, 'privacy_policy_page', 'Privacy Policy Page', 'privacypolicy', NULL, NULL, NULL, NULL, NULL, '2020-11-04 10:15:55', '2020-11-04 10:15:55');

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

--
-- Table structure for table `page_translations`
--

CREATE TABLE IF NOT EXISTS `page_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `page_id` bigint NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `token` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE IF NOT EXISTS `payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `seller_id` int NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT '0.00',
  `payment_details` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `payment_method` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `txn_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `pickup_points`
--

CREATE TABLE IF NOT EXISTS `pickup_points` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `address` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pick_up_status` int DEFAULT NULL,
  `cash_on_pickup_status` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `pickup_point_translations`
--

CREATE TABLE IF NOT EXISTS `pickup_point_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `pickup_point_id` bigint NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `policies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(35) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `policies` (`id`, `name`, `content`, `created_at`, `updated_at`) VALUES
(1, 'support_policy', NULL, '2019-10-29 12:54:45', '2019-01-22 05:13:15'),
(2, 'return_policy', NULL, '2019-10-29 12:54:47', '2019-01-24 05:40:11'),
(4, 'seller_policy', NULL, '2019-10-29 12:54:49', '2019-02-04 17:50:15'),
(5, 'terms', NULL, '2019-10-29 12:54:51', '2019-10-28 18:00:00'),
(6, 'privacy_policy', NULL, '2019-10-29 12:54:54', '2019-10-28 18:00:00');

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

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

CREATE TABLE IF NOT EXISTS `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `added_by` varchar(6) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'admin',
  `user_id` int NOT NULL,
  `store_id` bigint UNSIGNED DEFAULT NULL,
  `category_id` int NOT NULL,
  `brand_id` int DEFAULT NULL,
  `photos` varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `thumbnail_img` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `video_provider` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `video_link` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tags` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `unit_price` double(20,2) NOT NULL,
  `purchase_price` double(20,2) DEFAULT NULL,
  `variant_product` int NOT NULL DEFAULT '0',
  `attributes` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '[]',
  `choice_options` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `colors` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `variations` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `todays_deal` int NOT NULL DEFAULT '0',
  `published` int NOT NULL DEFAULT '1',
  `approved` tinyint(1) NOT NULL DEFAULT '1',
  `stock_visibility_state` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'quantity',
  `cash_on_delivery` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 = On, 0 = Off',
  `featured` int NOT NULL DEFAULT '0',
  `seller_featured` int NOT NULL DEFAULT '0',
  `current_stock` int NOT NULL DEFAULT '0',
  `unit` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `min_qty` int NOT NULL DEFAULT '1',
  `low_stock_quantity` int DEFAULT NULL,
  `discount` double(20,2) DEFAULT NULL,
  `discount_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `discount_start_date` int DEFAULT NULL,
  `discount_end_date` int DEFAULT NULL,
  `tax` double(20,2) DEFAULT NULL,
  `tax_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shipping_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'flat_rate',
  `shipping_cost` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `is_quantity_multiplied` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = Mutiplied with shipping cost',
  `est_shipping_days` int DEFAULT NULL,
  `num_of_sale` int NOT NULL DEFAULT '0',
  `meta_title` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `meta_description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `meta_img` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pdf` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `earn_point` double(8,2) NOT NULL DEFAULT '0.00',
  `rating` double(8,2) NOT NULL DEFAULT '0.00',
  `barcode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `digital` int NOT NULL DEFAULT '0',
  `file_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `tags` (`tags`(255))
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `products` (`id`, `name`, `added_by`, `user_id`, `store_id`, `category_id`, `brand_id`, `photos`, `thumbnail_img`, `video_provider`, `video_link`, `tags`, `description`, `unit_price`, `purchase_price`, `variant_product`, `attributes`, `choice_options`, `colors`, `variations`, `todays_deal`, `published`, `approved`, `stock_visibility_state`, `cash_on_delivery`, `featured`, `seller_featured`, `current_stock`, `unit`, `min_qty`, `low_stock_quantity`, `discount`, `discount_type`, `discount_start_date`, `discount_end_date`, `tax`, `tax_type`, `shipping_type`, `shipping_cost`, `is_quantity_multiplied`, `est_shipping_days`, `num_of_sale`, `meta_title`, `meta_description`, `meta_img`, `pdf`, `slug`, `earn_point`, `rating`, `barcode`, `digital`, `file_name`, `file_path`, `created_at`, `updated_at`) VALUES
(4, 'Kids shirt', 'admin', 9, 4, 6, 4, '15', '15', 'youtube', NULL, 'kid-shirt', '<p>Sample Product&nbsp;</p>', 400.00, NULL, 1, '[\"3\"]', '[{\"attribute_id\":\"3\",\"values\":[]}]', '[\"#9966CC\",\"#FAEBD7\",\"#7FFFD4\",\"#F0FFFF\"]', NULL, 1, 1, 1, 'quantity', 1, 1, 0, 0, 'pc', 1, 1, 0.00, 'amount', 1700697600, 1701388740, NULL, NULL, 'free', '0', 1, 7, 5, 'shirt', 'Sample Product&nbsp;', '15', NULL, 'kids-shirt-ege7r', 500.00, 0.00, NULL, 0, NULL, NULL, '2023-11-23 15:04:30', '2025-11-30 06:20:03'),
(6, 'Formal Mens Shirt', 'admin', 9, 4, 7, 4, '37', '37', 'youtube', NULL, 'men,men\'s shirt,shirt', '<p>★ColourQ Hi-Quality Premium Formal Shirt\r\n</p><p>★Msterials:International Burberry By London</p><p>★ সুপার প্রিমিয়াম অক্সফোর্ড কটন ফেব্রিক\r\n</p><p>★ সুপার সফট\r\n</p><p>★ অ্যানজাইম ওয়াশ\r\n</p><p>★ ছবিতে যেমন রঙ (মোবাইল আপ্লোড)\r\n</p><p>★Size_Measurement:-\r\n</p><p>★ এস-15-দৈর্ঘ্য-28, চেস্ট-38\r\n</p><p>★ এম-15.5-দৈর্ঘ্য-29, বুক-40\r\n</p><p>★ এল-16-লম্বা-30, বুক-42\r\n</p><p>★ XL-16.5-দৈর্ঘ্য-31, বুক-44\r\n</p><p>★ XXL-17-দৈর্ঘ্য-31, বুক-46\r\n</p><p>★ XXXL-17.5-দৈর্ঘ্য-31.5, বুক-48\"</p>', 1000.00, NULL, 1, '[\"3\"]', '[{\"attribute_id\":\"3\",\"values\":[\"M\"]}]', '[\"#00FFFF\",\"#7FFFD4\",\"#00FFFF\"]', NULL, 0, 1, 1, 'quantity', 1, 0, 0, 0, 'pc', 1, 1, 500.00, 'amount', 1700611200, 1700697540, NULL, NULL, 'free', '0', 0, NULL, 2, 'shirt', '★ColourQ Hi-Quality Premium Formal Shirt\r\n★Msterials:International Burberry By London★ সুপার প্রিমিয়াম অক্সফোর্ড কটন ফেব্রিক\r\n★ সুপার সফট\r\n★ অ্যানজাইম ওয়াশ\r\n★ ছবিতে যেমন রঙ (মোবাইল আপ্লোড)\r\n★Size_Measurement:-\r\n★ এস-15-দৈর্ঘ্য-28, চেস্ট-38\r\n★ এম-15.5-দৈর্ঘ্য-29, বুক-40\r\n★ এল-16-লম্বা-30, বুক-42\r\n★ XL-16.5-দৈর্ঘ্য-31, বুক-44\r\n★ XXL-17-দৈর্ঘ্য-31, বুক-46\r\n★ XXXL-17.5-দৈর্ঘ্য-31.5, বুক-48\"', '18', NULL, 'mens-shirt-jd76g', 100.00, 0.00, NULL, 0, NULL, NULL, '2023-11-23 15:16:53', '2025-11-30 05:55:59'),
(7, 'Adults shirt', 'admin', 9, NULL, 6, 4, '15', '15', 'youtube', NULL, 'kid-shirt', '<p>Sample Product&nbsp;</p>', 400.00, NULL, 1, '[\"3\"]', '[{\"attribute_id\":\"3\",\"values\":[null,null,null,null,null]}]', '[\"#9966CC\",\"#FAEBD7\",\"#7FFFD4\",\"#F0FFFF\"]', NULL, 1, 1, 1, 'quantity', 1, 1, 0, 0, 'pc', 1, 1, 0.00, 'amount', 1700697600, 1700956740, NULL, NULL, 'free', '0', 1, 7, 10, 'shirt', 'Sample Product&nbsp;', '15', NULL, 'kids-shirt-7vjjf', 5.00, 0.00, NULL, 0, NULL, NULL, '2023-11-23 15:17:05', '2025-11-23 07:39:02'),
(8, 'Mens Shirt', 'admin', 9, 2, 7, 4, '18', '18', 'youtube', NULL, 'men,men\'s shirt,shirt', '<p>★ColourQ Hi-Quality Premium Formal Shirt\r\n</p><p>★Msterials:International Burberry By London</p><p>★ সুপার প্রিমিয়াম অক্সফোর্ড কটন ফেব্রিক\r\n</p><p>★ সুপার সফট\r\n</p><p>★ অ্যানজাইম ওয়াশ\r\n</p><p>★ ছবিতে যেমন রঙ (মোবাইল আপ্লোড)\r\n</p><p>★Size_Measurement:-\r\n</p><p>★ এস-15-দৈর্ঘ্য-28, চেস্ট-38\r\n</p><p>★ এম-15.5-দৈর্ঘ্য-29, বুক-40\r\n</p><p>★ এল-16-লম্বা-30, বুক-42\r\n</p><p>★ XL-16.5-দৈর্ঘ্য-31, বুক-44\r\n</p><p>★ XXL-17-দৈর্ঘ্য-31, বুক-46\r\n</p><p>★ XXXL-17.5-দৈর্ঘ্য-31.5, বুক-48\"</p>', 1000.00, NULL, 1, '[\"3\"]', '[{\"attribute_id\":\"3\",\"values\":[\"L\",\"XL\"]}]', '[\"#00FFFF\",\"#7FFFD4\",\"#00FFFF\"]', NULL, 0, 1, 1, 'quantity', 1, 1, 0, 0, 'pc', 1, 1, 500.00, 'amount', 1700697600, 1700956740, NULL, NULL, 'free', '0', 0, NULL, 10, 'shirt', '★ColourQ Hi-Quality Premium Formal Shirt\r\n★Msterials:International Burberry By London★ সুপার প্রিমিয়াম অক্সফোর্ড কটন ফেব্রিক\r\n★ সুপার সফট\r\n★ অ্যানজাইম ওয়াশ\r\n★ ছবিতে যেমন রঙ (মোবাইল আপ্লোড)\r\n★Size_Measurement:-\r\n★ এস-15-দৈর্ঘ্য-28, চেস্ট-38\r\n★ এম-15.5-দৈর্ঘ্য-29, বুক-40\r\n★ এল-16-লম্বা-30, বুক-42\r\n★ XL-16.5-দৈর্ঘ্য-31, বুক-44\r\n★ XXL-17-দৈর্ঘ্য-31, বুক-46\r\n★ XXXL-17.5-দৈর্ঘ্য-31.5, বুক-48\"', '18', NULL, 'mens-shirt-lwtdl', 10.00, 0.00, NULL, 0, NULL, NULL, '2023-11-23 15:17:12', '2025-11-26 11:36:05'),
(9, 'Mens Jacket', 'admin', 9, 2, 5, 5, '33', '34', 'youtube', NULL, 'jackect', '<p>Exclusive Winter Jacket for Men in Bangladesh\r\n</p><p>Keep yourself warm and maintain a fashion statement miss this unique men\'s winter jacket which is a twofold concept as well as a comfort and protection enhancing design for the cold season extended.\r\n</p><p>Exclusive Winter Jacket for Men Details\r\n</p><p>·         Exclusive Men\'s Winter Jacket (Double Layer)\r\n</p><p>·         Outer Layer - China Macro Fabric\r\n</p><p>·         Inner Lining - China Serfa\r\n</p><p>·         Perfect for Cold Winter Weather\r\n</p><p>·         Premium Quality\r\n</p><p>·         Available Sizes: M, L, XL</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p>', 5000.00, NULL, 1, '[\"3\"]', '[{\"attribute_id\":\"3\",\"values\":[\"M\",\"L\",\"XL\"]}]', '[\"#9966CC\",\"#000000\"]', NULL, 0, 1, 1, 'quantity', 1, 0, 0, 0, 'pc', 1, 1, 0.00, 'amount', 0, 0, NULL, NULL, 'free', '0', 0, NULL, 3, 'Jackect', 'Exclusive Winter Jacket for Men in Bangladesh\r\nKeep yourself warm and maintain a fashion statement miss this unique men\'s winter jacket which is a twofold concept as well as a comfort and protection enhancing design for the cold season extended.\r\nExclusive Winter Jacket for Men Details\r\n·         Exclusive Men\'s Winter Jacket (Double Layer)\r\n·         Outer Layer - China Macro Fabric\r\n·         Inner Lining - China Serfa\r\n·         Perfect for Cold Winter Weather\r\n·         Premium Quality\r\n·         Available Sizes: M, L, XL', '34', NULL, 'mens-jacket-ngrkf', 400.00, 0.00, NULL, 0, NULL, NULL, '2025-11-26 10:23:38', '2025-11-27 08:16:02');

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

--
-- Table structure for table `product_stocks`
--

CREATE TABLE IF NOT EXISTS `product_stocks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `variant` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `sku` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `price` double(20,2) NOT NULL DEFAULT '0.00',
  `qty` int NOT NULL DEFAULT '0',
  `image` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_stocks`
--

INSERT INTO `product_stocks` (`id`, `product_id`, `variant`, `sku`, `price`, `qty`, `image`, `created_at`, `updated_at`) VALUES
(29, 7, 'Amethyst-', NULL, 400.00, 0, NULL, '2024-04-16 04:34:27', '2025-11-23 07:39:02'),
(30, 7, 'AntiqueWhite-', NULL, 400.00, 10, NULL, '2024-04-16 04:34:27', '2024-04-16 04:34:27'),
(31, 7, 'Aquamarine-', NULL, 400.00, 10, NULL, '2024-04-16 04:34:27', '2024-04-16 04:34:27'),
(32, 7, 'Azure-', NULL, 400.00, 10, NULL, '2024-04-16 04:34:27', '2024-04-16 04:34:27'),
(41, 9, 'Amethyst-M', 'Amethyst-M', 5000.00, 9, NULL, '2025-11-26 11:35:06', '2025-11-27 08:16:02'),
(42, 9, 'Amethyst-L', 'Amethyst-L', 5000.00, 10, NULL, '2025-11-26 11:35:06', '2025-11-26 11:35:06'),
(43, 9, 'Amethyst-XL', 'Amethyst-XL', 5000.00, 10, NULL, '2025-11-26 11:35:06', '2025-11-26 11:35:06'),
(44, 9, 'Black-M', 'Black-M', 5000.00, 10, NULL, '2025-11-26 11:35:06', '2025-11-26 11:35:06'),
(45, 9, 'Black-L', 'Black-L', 5000.00, 10, NULL, '2025-11-26 11:35:06', '2025-11-26 11:35:06'),
(46, 9, 'Black-XL', 'Black-XL', 5000.00, 10, NULL, '2025-11-26 11:35:06', '2025-11-26 11:35:06'),
(47, 8, 'Aqua-L', 'Aqua-L', 1000.00, 10, NULL, '2025-11-26 11:36:05', '2025-11-26 11:36:05'),
(48, 8, 'Aqua-XL', 'Aqua-XL', 1000.00, 10, NULL, '2025-11-26 11:36:05', '2025-11-26 11:36:05'),
(49, 8, 'Aquamarine-L', 'Aquamarine-L', 1000.00, 10, NULL, '2025-11-26 11:36:05', '2025-11-26 11:36:05'),
(50, 8, 'Aquamarine-XL', 'Aquamarine-XL', 1000.00, 10, NULL, '2025-11-26 11:36:05', '2025-11-26 11:36:05'),
(53, 6, 'Aqua-M', 'Aqua-M', 1000.00, 10, NULL, '2025-11-30 05:55:59', '2025-11-30 05:55:59'),
(54, 6, 'Aquamarine-M', 'Aquamarine-M', 1000.00, 10, NULL, '2025-11-30 05:55:59', '2025-11-30 05:55:59');

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

--
-- Table structure for table `product_taxes`
--

CREATE TABLE IF NOT EXISTS `product_taxes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `tax_id` int NOT NULL,
  `tax` double(20,2) NOT NULL,
  `tax_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_taxes`
--

INSERT INTO `product_taxes` (`id`, `product_id`, `tax_id`, `tax`, `tax_type`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 0.00, 'percent', '2023-11-23 15:03:16', '2023-11-23 15:03:16'),
(2, 5, 3, 0.00, 'amount', '2023-11-23 15:16:01', '2023-11-23 15:16:01'),
(4, 7, 3, 0.00, 'amount', '2024-04-16 04:34:27', '2024-04-16 04:34:27'),
(9, 9, 3, 0.00, 'amount', '2025-11-26 11:35:06', '2025-11-26 11:35:06'),
(10, 8, 3, 0.00, 'amount', '2025-11-26 11:36:05', '2025-11-26 11:36:05'),
(12, 6, 3, 0.00, 'amount', '2025-11-30 05:55:59', '2025-11-30 05:55:59'),
(14, 4, 3, 0.00, 'amount', '2025-11-30 06:20:03', '2025-11-30 06:20:03');

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

--
-- Table structure for table `product_translations`
--

CREATE TABLE IF NOT EXISTS `product_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `product_id` bigint NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `unit` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `product_translations`
--

INSERT INTO `product_translations` (`id`, `product_id`, `name`, `unit`, `description`, `lang`, `created_at`, `updated_at`) VALUES
(3, 8, 'Mens Shirt', 'pc', '<p>★ColourQ Hi-Quality Premium Formal Shirt\r\n</p><p>★Msterials:International Burberry By London</p><p>★ সুপার প্রিমিয়াম অক্সফোর্ড কটন ফেব্রিক\r\n</p><p>★ সুপার সফট\r\n</p><p>★ অ্যানজাইম ওয়াশ\r\n</p><p>★ ছবিতে যেমন রঙ (মোবাইল আপ্লোড)\r\n</p><p>★Size_Measurement:-\r\n</p><p>★ এস-15-দৈর্ঘ্য-28, চেস্ট-38\r\n</p><p>★ এম-15.5-দৈর্ঘ্য-29, বুক-40\r\n</p><p>★ এল-16-লম্বা-30, বুক-42\r\n</p><p>★ XL-16.5-দৈর্ঘ্য-31, বুক-44\r\n</p><p>★ XXL-17-দৈর্ঘ্য-31, বুক-46\r\n</p><p>★ XXXL-17.5-দৈর্ঘ্য-31.5, বুক-48\"</p>', 'en', '2023-11-23 15:26:53', '2023-11-23 15:26:53'),
(4, 7, 'Adults shirt', 'pc', '<p>Sample Product&nbsp;</p>', 'en', '2024-04-16 04:34:27', '2024-04-16 04:34:27'),
(5, 9, 'Mens Jacket', 'pc', '<p>Exclusive Winter Jacket for Men in Bangladesh\r\n</p><p>Keep yourself warm and maintain a fashion statement miss this unique men\'s winter jacket which is a twofold concept as well as a comfort and protection enhancing design for the cold season extended.\r\n</p><p>Exclusive Winter Jacket for Men Details\r\n</p><p>·         Exclusive Men\'s Winter Jacket (Double Layer)\r\n</p><p>·         Outer Layer - China Macro Fabric\r\n</p><p>·         Inner Lining - China Serfa\r\n</p><p>·         Perfect for Cold Winter Weather\r\n</p><p>·         Premium Quality\r\n</p><p>·         Available Sizes: M, L, XL</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p>', 'en', '2025-11-26 10:23:38', '2025-11-26 10:23:38'),
(6, 6, 'Formal Mens Shirt', 'pc', '<p>★ColourQ Hi-Quality Premium Formal Shirt\r\n</p><p>★Msterials:International Burberry By London</p><p>★ সুপার প্রিমিয়াম অক্সফোর্ড কটন ফেব্রিক\r\n</p><p>★ সুপার সফট\r\n</p><p>★ অ্যানজাইম ওয়াশ\r\n</p><p>★ ছবিতে যেমন রঙ (মোবাইল আপ্লোড)\r\n</p><p>★Size_Measurement:-\r\n</p><p>★ এস-15-দৈর্ঘ্য-28, চেস্ট-38\r\n</p><p>★ এম-15.5-দৈর্ঘ্য-29, বুক-40\r\n</p><p>★ এল-16-লম্বা-30, বুক-42\r\n</p><p>★ XL-16.5-দৈর্ঘ্য-31, বুক-44\r\n</p><p>★ XXL-17-দৈর্ঘ্য-31, বুক-46\r\n</p><p>★ XXXL-17.5-দৈর্ঘ্য-31.5, বুক-48\"</p>', 'en', '2025-11-30 05:54:51', '2025-11-30 05:54:51'),
(7, 4, 'Kids shirt', 'pc', '<p>Sample Product&nbsp;</p>', 'en', '2025-11-30 06:14:06', '2025-11-30 06:14:06');

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

--
-- Table structure for table `proxypay_payments`
--

CREATE TABLE IF NOT EXISTS `proxypay_payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `reference_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `order_id` int DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  `amount` double(25,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `proxypay_payments`
--

INSERT INTO `proxypay_payments` (`id`, `payment_type`, `reference_id`, `order_id`, `package_id`, `user_id`, `amount`, `created_at`, `updated_at`) VALUES
(1, 'cart_payment', '887240000', 2, 0, 17, 0.00, '2025-11-04 02:48:07', '2025-11-04 02:48:07');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE IF NOT EXISTS `reviews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `user_id` int NOT NULL,
  `rating` int NOT NULL DEFAULT '0',
  `comment` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `viewed` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `permissions` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES
(1, 'Manager', '[\"2\",\"4\",\"18\"]', '2018-10-10 04:39:47', '2025-11-18 17:00:39'),
(2, 'Accountant', '[\"2\",\"3\",\"18\"]', '2018-10-10 04:52:09', '2025-11-18 17:00:50'),
(3, 'Super Admin', '[\"2\",\"3\",\"4\",\"5\",\"6\",\"8\",\"9\",\"10\",\"11\",\"12\",\"13\",\"14\",\"16\",\"18\",\"20\",\"21\",\"22\",\"23\",\"24\"]', '2025-11-18 17:05:29', '2025-11-19 10:21:12');

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

--
-- Table structure for table `role_translations`
--

CREATE TABLE IF NOT EXISTS `role_translations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` bigint NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `role_translations`
--

INSERT INTO `role_translations` (`id`, `role_id`, `name`, `lang`, `created_at`, `updated_at`) VALUES
(1, 1, 'Manager', 'en', '2025-11-18 17:00:39', '2025-11-18 17:00:39'),
(2, 2, 'Accountant', 'en', '2025-11-18 17:00:50', '2025-11-18 17:00:50'),
(3, 3, 'Super Admin', 'en', '2025-11-18 17:05:29', '2025-11-18 17:05:29');

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

--
-- Table structure for table `searches`
--

CREATE TABLE IF NOT EXISTS `searches` (
  `id` int NOT NULL AUTO_INCREMENT,
  `query` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `count` int NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `searches`
--

INSERT INTO `searches` (`id`, `query`, `count`, `created_at`, `updated_at`) VALUES
(2, 'dcs', 1, '2020-03-08 00:29:09', '2020-03-08 00:29:09'),
(3, 'das', 3, '2020-03-08 00:29:15', '2020-03-08 00:29:50');

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

--
-- Table structure for table `sellers`
--

CREATE TABLE IF NOT EXISTS `sellers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `verification_status` int NOT NULL DEFAULT '0',
  `verification_info` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `cash_on_delivery_status` int NOT NULL DEFAULT '0',
  `admin_to_pay` double(20,2) NOT NULL DEFAULT '0.00',
  `bank_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_acc_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_acc_no` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_routing_no` int DEFAULT NULL,
  `bank_payment_status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sellers`
--

INSERT INTO `sellers` (`id`, `user_id`, `verification_status`, `verification_info`, `cash_on_delivery_status`, `admin_to_pay`, `bank_name`, `bank_acc_name`, `bank_acc_no`, `bank_routing_no`, `bank_payment_status`, `created_at`, `updated_at`) VALUES
(1, 3, 1, '[{\"type\":\"text\",\"label\":\"Name\",\"value\":\"Mr. Seller\"},{\"type\":\"select\",\"label\":\"Marital Status\",\"value\":\"Married\"},{\"type\":\"multi_select\",\"label\":\"Company\",\"value\":\"[\\\"Company\\\"]\"},{\"type\":\"select\",\"label\":\"Gender\",\"value\":\"Male\"},{\"type\":\"file\",\"label\":\"Image\",\"value\":\"uploads\\/verification_form\\/CRWqFifcbKqibNzllBhEyUSkV6m1viknGXMEhtiW.png\"}]', 1, 78.40, NULL, NULL, NULL, NULL, 0, '2018-10-07 04:42:57', '2020-01-26 04:21:11');

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

--
-- Table structure for table `seller_withdraw_requests`
--

CREATE TABLE IF NOT EXISTS `seller_withdraw_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `amount` double(20,2) DEFAULT NULL,
  `message` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `status` int DEFAULT NULL,
  `viewed` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `seo_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `keyword` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `author` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `revisit` int NOT NULL,
  `sitemap_link` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `seo_settings`
--

INSERT INTO `seo_settings` (`id`, `keyword`, `author`, `revisit`, `sitemap_link`, `description`, `created_at`, `updated_at`) VALUES
(1, 'bootstrap,responsive,template,developer', 'Active IT Zone', 11, 'https://www.activeitzone.com', 'Active E-commerce CMS Multi vendor system is such a platform to build a border less marketplace both for physical and digital goods.', '2019-08-08 08:56:11', '2019-08-08 02:56:11');

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

--
-- Table structure for table `shops`
--

CREATE TABLE IF NOT EXISTS `shops` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sliders` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `google` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `pick_up_point_id` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `shipping_cost` double(20,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `shops`
--

INSERT INTO `shops` (`id`, `user_id`, `name`, `logo`, `sliders`, `phone`, `address`, `facebook`, `google`, `twitter`, `youtube`, `slug`, `meta_title`, `meta_description`, `pick_up_point_id`, `shipping_cost`, `created_at`, `updated_at`) VALUES
(1, 3, 'Demo Seller Shop', NULL, NULL, NULL, 'House : Demo, Road : Demo, Section : Demo', 'www.facebook.com', 'www.google.com', 'www.twitter.com', 'www.youtube.com', 'Demo-Seller-Shop-1', 'Demo Seller Shop Title', 'Demo description', NULL, 0.00, '2018-11-27 10:23:13', '2019-08-06 06:43:16');

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

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

CREATE TABLE IF NOT EXISTS `sliders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `photo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `published` int NOT NULL DEFAULT '1',
  `link` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `photo`, `published`, `link`, `created_at`, `updated_at`) VALUES
(7, 'uploads/sliders/slider-image.jpg', 1, NULL, '2019-03-12 05:58:05', '2019-03-12 05:58:05'),
(8, 'uploads/sliders/slider-image.jpg', 1, NULL, '2019-03-12 05:58:12', '2019-03-12 05:58:12');

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

--
-- Table structure for table `staff`
--

CREATE TABLE IF NOT EXISTS `staff` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `role_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `user_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 19, 3, '2025-11-18 17:06:26', '2025-11-18 17:06:26');

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

--
-- Table structure for table `stores`
--

CREATE TABLE IF NOT EXISTS `stores` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stores`
--

INSERT INTO `stores` (`id`, `name`, `code`, `address`, `phone`, `logo`, `slug`, `meta_title`, `meta_description`, `created_at`, `updated_at`) VALUES
(2, 'Super Store', '223345', 'Baridhara, Block-J, Dhaka, Bangladesh', '01727532732', '35', 'Super-Store-rvU45', 'Super Store', 'It\'s a Super Store', '2025-11-27 07:17:22', '2025-11-27 07:17:37'),
(4, 'Online Shop', '223348', 'Gulshan Block-H', '01727532732', '36', 'Online-Shop-XYGFu', 'Super Store', NULL, '2025-11-27 07:36:45', '2025-11-27 07:36:45');

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

--
-- Table structure for table `store_translations`
--

CREATE TABLE IF NOT EXISTS `store_translations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `store_id` int UNSIGNED DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_translations_store_id_foreign` (`store_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_translations`
--

INSERT INTO `store_translations` (`id`, `store_id`, `name`, `lang`, `created_at`, `updated_at`) VALUES
(2, 2, 'Super Store', 'en', '2025-11-27 07:17:22', '2025-11-27 07:17:22'),
(3, 4, 'Online Shop', 'en', '2025-11-27 07:36:45', '2025-11-27 07:36:45');

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

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

CREATE TABLE IF NOT EXISTS `subscribers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `taxes`
--

CREATE TABLE IF NOT EXISTS `taxes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tax_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 = Inactive, 1 = Active',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` (`id`, `name`, `tax_status`, `created_at`, `updated_at`) VALUES
(3, 'Tax', 1, '2021-03-07 11:45:33', '2021-03-07 11:45:33');

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

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

CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` int NOT NULL,
  `user_id` int NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `details` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `files` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'pending',
  `viewed` int NOT NULL DEFAULT '0',
  `client_viewed` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `ticket_replies`
--

CREATE TABLE IF NOT EXISTS `ticket_replies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticket_id` int NOT NULL,
  `user_id` int NOT NULL,
  `reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `files` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `translations`
--

CREATE TABLE IF NOT EXISTS `translations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lang` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `lang_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `lang_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26957 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
























































INSERT INTO `translations` (`id`, `lang`, `lang_key`, `lang_value`, `created_at`, `updated_at`) VALUES
(26852, 'en', 'REDIS_HOST', 'REDIS_HOST', '2025-11-04 02:29:01', '2025-11-04 02:29:01'),
(26853, 'en', 'REDIS_PASSWORD', 'REDIS_PASSWORD', '2025-11-04 02:29:01', '2025-11-04 02:29:01'),
(26854, 'en', 'REDIS_PORT', 'REDIS_PORT', '2025-11-04 02:29:01', '2025-11-04 02:29:01'),
(26855, 'jp', 'Nothing selected', 'Nothing selected', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26856, 'jp', 'File selected', 'File selected', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26857, 'jp', 'Files selected', 'Files selected', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26858, 'jp', 'Add more files', 'Add more files', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26859, 'jp', 'Adding more files', 'Adding more files', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26860, 'jp', 'Drop files here, paste or', 'Drop files here, paste or', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26861, 'jp', 'Upload complete', 'Upload complete', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26862, 'jp', 'Upload paused', 'Upload paused', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26863, 'jp', 'Resume upload', 'Resume upload', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26864, 'jp', 'Pause upload', 'Pause upload', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26865, 'jp', 'Retry upload', 'Retry upload', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26866, 'jp', 'Cancel upload', 'Cancel upload', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26867, 'jp', 'Uploading', 'Uploading', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26868, 'jp', 'Processing', 'Processing', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26869, 'jp', 'Complete', 'Complete', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26870, 'jp', 'Files', 'Files', '2025-11-04 02:35:21', '2025-11-04 02:35:21'),
(26871, 'jp', 'Commission History', 'Commission History', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26872, 'jp', 'Wallet Recharge History', 'Wallet Recharge History', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26873, 'jp', 'Blog System', 'Blog System', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26874, 'jp', 'All Posts', 'All Posts', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26875, 'jp', 'Vat & TAX', 'Vat & TAX', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26876, 'jp', 'File System & Cache Configuration', 'File System & Cache Configuration', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26877, 'jp', 'Facebook Comment', 'Facebook Comment', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26878, 'jp', 'Google Map', 'Google Map', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26879, 'jp', 'Google Firebase', 'Google Firebase', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26880, 'jp', 'has been Placed', 'has been Placed', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26881, 'jp', 'View All Notifications', 'View All Notifications', '2025-11-04 02:35:22', '2025-11-04 02:35:22'),
(26882, 'jp', 'Blogs', 'Blogs', '2025-11-04 02:35:31', '2025-11-04 02:35:31'),
(26883, 'jp', 'Account', 'Account', '2025-11-04 02:35:32', '2025-11-04 02:35:32'),
(26884, 'jp', 'Item has been removed from cart', 'Item has been removed from cart', '2025-11-04 02:35:32', '2025-11-04 02:35:32'),
(26885, 'jp', 'Please choose all the options', 'Please choose all the options', '2025-11-04 02:35:32', '2025-11-04 02:35:32'),
(26886, 'jp', 'View All Sellers', 'View All Sellers', '2025-11-04 02:35:32', '2025-11-04 02:35:32'),
(26887, 'en', 'System Default Currency', 'System Default Currency', '2025-11-04 02:36:37', '2025-11-04 02:36:37'),
(26888, 'en', 'Set Currency Formats', 'Set Currency Formats', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26889, 'en', 'Symbol Format', 'Symbol Format', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26890, 'en', 'Decimal Separator', 'Decimal Separator', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26891, 'en', 'No of decimals', 'No of decimals', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26892, 'en', 'All Currencies', 'All Currencies', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26893, 'en', 'Add New Currency', 'Add New Currency', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26894, 'en', 'Currency name', 'Currency name', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26895, 'en', 'Currency symbol', 'Currency symbol', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26896, 'en', 'Currency code', 'Currency code', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26897, 'en', 'Currency Status updated successfully', 'Currency Status updated successfully', '2025-11-04 02:36:38', '2025-11-04 02:36:38'),
(26898, 'en', 'Proxypay Reference', 'Proxypay Reference', '2025-11-04 02:48:07', '2025-11-04 02:48:07'),
(26899, 'en', 'Coupon expired!', 'Coupon expired!', '2025-11-10 03:08:43', '2025-11-10 03:08:43'),
(26900, 'en', 'Seller', 'Seller', '2025-11-16 17:21:16', '2025-11-16 17:21:16'),
(26901, 'en', 'Role has been inserted successfully', 'Role has been inserted successfully', '2025-11-18 17:05:29', '2025-11-18 17:05:29'),
(26902, 'en', 'Account Name', 'Account Name', '2025-11-22 18:00:21', '2025-11-22 18:00:21'),
(26903, 'en', 'Account Number', 'Account Number', '2025-11-22 18:00:21', '2025-11-22 18:00:21'),
(26904, 'en', 'Routing Number', 'Routing Number', '2025-11-22 18:00:21', '2025-11-22 18:00:21'),
(26905, 'en', 'Method has been updated successfully', 'Method has been updated successfully', '2025-11-23 05:53:06', '2025-11-23 05:53:06'),
(26906, 'en', 'has been Delivered', 'has been Delivered', '2025-11-23 07:35:36', '2025-11-23 07:35:36'),
(26907, 'en', 'has been Confirmed', 'has been Confirmed', '2025-11-23 07:35:36', '2025-11-23 07:35:36'),
(26908, 'en', 'Redeem point', 'Redeem point', '2025-11-23 10:47:08', '2025-11-23 10:47:08'),
(26909, 'en', 'Remove Redeem Point', 'Remove Redeem Point', '2025-11-23 10:47:08', '2025-11-23 10:47:08'),
(26910, 'en', 'Your club point is', 'Your club point is', '2025-11-24 06:08:16', '2025-11-24 06:08:16'),
(26911, 'en', 'Enter club point here', 'Enter club point here', '2025-11-24 06:08:16', '2025-11-24 06:08:16'),
(26912, 'en', 'Redeem', 'Redeem', '2025-11-24 06:08:16', '2025-11-24 06:08:16'),
(26913, 'en', 'Point has been redeemed', 'Point has been redeemed', '2025-11-24 06:09:50', '2025-11-24 06:09:50'),
(26914, 'en', 'Could not apply point', 'Could not apply point', '2025-11-24 06:34:28', '2025-11-24 06:34:28'),
(26915, 'en', 'Point has been removed', 'Point has been removed', '2025-11-24 09:46:42', '2025-11-24 09:46:42'),
(26916, 'en', 'Club Point Discount', 'Club Point Discount', '2025-11-25 10:44:30', '2025-11-25 10:44:30'),
(26917, 'en', 'Wallet', 'Wallet', '2025-11-25 10:50:29', '2025-11-25 10:50:29'),
(26918, 'en', 'Stores', 'Stores', '2025-11-26 09:44:19', '2025-11-26 09:44:19'),
(26919, 'en', 'All Stores', 'All Stores', '2025-11-26 09:44:31', '2025-11-26 09:44:31'),
(26920, 'en', 'Add New Store', 'Add New Store', '2025-11-26 09:44:31', '2025-11-26 09:44:31'),
(26921, 'en', 'Search by name, code or phone', 'Search by name, code or phone', '2025-11-26 09:44:31', '2025-11-26 09:44:31'),
(26922, 'en', 'Store Name', 'Store Name', '2025-11-26 09:44:38', '2025-11-26 09:44:38'),
(26923, 'en', 'Store Code', 'Store Code', '2025-11-26 09:44:38', '2025-11-26 09:44:38'),
(26924, 'en', 'e.g., STORE-001', 'e.g., STORE-001', '2025-11-26 09:44:38', '2025-11-26 09:44:38'),
(26925, 'en', 'Phone Number', 'Phone Number', '2025-11-26 09:44:38', '2025-11-26 09:44:38'),
(26926, 'en', 'Store Address', 'Store Address', '2025-11-26 09:44:38', '2025-11-26 09:44:38'),
(26927, 'en', 'Save Store', 'Save Store', '2025-11-26 09:44:38', '2025-11-26 09:44:38'),
(26928, 'en', 'Store has been created successfully', 'Store has been created successfully', '2025-11-26 09:45:32', '2025-11-26 09:45:32'),
(26929, 'en', 'Store Details', 'Store Details', '2025-11-26 09:45:58', '2025-11-26 09:45:58'),
(26930, 'en', 'Back', 'Back', '2025-11-26 09:45:58', '2025-11-26 09:45:58'),
(26931, 'en', 'Created At', 'Created At', '2025-11-26 09:45:58', '2025-11-26 09:45:58'),
(26932, 'en', 'Edit Store', 'Edit Store', '2025-11-26 09:46:18', '2025-11-26 09:46:18'),
(26933, 'en', 'Update Store', 'Update Store', '2025-11-26 09:46:18', '2025-11-26 09:46:18'),
(26934, 'en', 'Store', 'Store', '2025-11-26 10:16:39', '2025-11-26 10:16:39'),
(26935, 'en', 'Select Store (optional)', 'Select Store (optional)', '2025-11-26 10:16:39', '2025-11-26 10:16:39'),
(26936, 'en', 'Filter by Store', 'Filter by Store', '2025-11-26 10:31:58', '2025-11-26 10:31:58'),
(26937, 'en', 'Store Based Sales Report', 'Store Based Sales Report', '2025-11-26 10:38:59', '2025-11-26 10:38:59'),
(26938, 'en', 'Date Range', 'Date Range', '2025-11-26 10:39:08', '2025-11-26 10:39:08'),
(26939, 'en', 'Number of Orders', 'Number of Orders', '2025-11-26 10:39:08', '2025-11-26 10:39:08'),
(26940, 'en', 'Total Sales', 'Total Sales', '2025-11-26 10:39:09', '2025-11-26 10:39:09'),
(26941, 'en', 'Commission History report', 'Commission History report', '2025-11-26 10:44:58', '2025-11-26 10:44:58'),
(26942, 'en', 'Choose Seller', 'Choose Seller', '2025-11-26 10:44:58', '2025-11-26 10:44:58'),
(26943, 'en', 'Daterange', 'Daterange', '2025-11-26 10:44:58', '2025-11-26 10:44:58'),
(26944, 'en', 'Admin Commission', 'Admin Commission', '2025-11-26 10:44:58', '2025-11-26 10:44:58'),
(26945, 'en', 'Seller Earning', 'Seller Earning', '2025-11-26 10:44:58', '2025-11-26 10:44:58'),
(26946, 'en', 'Wallet Transaction Report', 'Wallet Transaction Report', '2025-11-26 10:45:09', '2025-11-26 10:45:09'),
(26947, 'en', 'Wallet Transaction', 'Wallet Transaction', '2025-11-26 10:45:09', '2025-11-26 10:45:09'),
(26948, 'en', 'Choose User', 'Choose User', '2025-11-26 10:45:09', '2025-11-26 10:45:09'),
(26949, 'en', 'Attribute Value Information', 'Attribute Value Information', '2025-11-26 11:13:01', '2025-11-26 11:13:01'),
(26950, 'en', 'Attribute value has been updated successfully', 'Attribute value has been updated successfully', '2025-11-26 11:18:09', '2025-11-26 11:18:09'),
(26951, 'en', 'Store Logo', 'Store Logo', '2025-11-27 05:50:52', '2025-11-27 05:50:52'),
(26952, 'en', 'Store has been updated successfully', 'Store has been updated successfully', '2025-11-27 07:00:41', '2025-11-27 07:00:41'),
(26953, 'en', 'Store Information', 'Store Information', '2025-11-27 07:11:52', '2025-11-27 07:11:52'),
(26954, 'en', 'Store has been deleted successfully', 'Store has been deleted successfully', '2025-11-27 07:16:10', '2025-11-27 07:16:10'),
(26955, 'en', 'View All Stores', 'View All Stores', '2025-11-27 10:49:23', '2025-11-27 10:49:23'),
(26956, 'en', 'Store changed to ', 'Store changed to ', '2025-11-30 05:33:44', '2025-11-30 05:33:44');

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

--
-- Table structure for table `uploads`
--

CREATE TABLE IF NOT EXISTS `uploads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_original_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `file_size` int DEFAULT NULL,
  `extension` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `uploads`
--

INSERT INTO `uploads` (`id`, `file_original_name`, `file_name`, `user_id`, `file_size`, `extension`, `type`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'schoolma', 'uploads/all/KOJHQQXcd7TATLCJwKr0O3tIDhY6uH5z4GoBtD16.png', 9, 164352, 'png', 'image', '2023-11-22 23:58:34', '2023-11-22 23:58:34', NULL),
(2, 'whatsapp-image-2023-11-17-at-213945-8ab25e06', 'uploads/all/aBSo6UyjGp1baP1JfycL3tHpIEwAnbyPWDwCsKlg.jpg', 9, 63850, 'jpg', 'image', '2023-11-23 00:11:12', '2023-11-23 00:11:12', NULL),
(3, 'sY9upW7zlKDDx3CTxnE3h1uv89fbPU9JBGbbnjF2', 'uploads/all/qsJZdrLkKkmg45bmpUVt2ppm4p6OWzUqZxFYpJTg.webp', 9, 19150, 'webp', 'image', '2023-11-23 00:40:58', '2023-11-23 00:40:58', NULL),
(4, 'K11jEaa22um8nGJD5niqHNNTHYZtV0iGLng26x2Y', 'uploads/all/AuZpvegt1D77HxE7yCpZ1SAG1tAGHttIaDcSBlCn.webp', 9, 23114, 'webp', 'image', '2023-11-23 00:43:02', '2023-11-23 00:43:02', NULL),
(5, 'arong', 'uploads/all/R9bkyOnrIFcbKkZHHtIoED1aTXELQGc5OSeFzJLK.png', 9, 18007, 'png', 'image', '2023-11-23 14:03:22', '2023-11-23 14:03:22', NULL),
(6, 'easy', 'uploads/all/5F4rV0FVHvx4fmcasfB0SrDEEUoXlqMbzYseiZFG.png', 9, 7418, 'png', 'image', '2023-11-23 14:03:36', '2023-11-23 14:03:36', NULL),
(7, 'leve', 'uploads/all/B8JzlUOQ6e4dgCiR9im39qe5yL2XPXTAwIMZaQZJ.png', 9, 1852, 'png', 'image', '2023-11-23 14:03:43', '2023-11-23 14:03:43', NULL),
(8, 'richman', 'uploads/all/HOM8QNQXfx7NY2iYJi77JASUgop9Rpk2EFX9jhd1.png', 9, 8653, 'png', 'image', '2023-11-23 14:03:52', '2023-11-23 14:03:52', NULL),
(9, '49595533066270', 'uploads/all/YOagT60rvs5BjEl6m4jljBYZTvRqnU4d3w75c39l.jpg', 9, 8187, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(10, '49595533459486', 'uploads/all/O5DTCEN5VuUHvjKZ4WkQ8nA5KPi17cOsvKoTeqjM.jpg', 9, 6739, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(11, '49595534311454', 'uploads/all/WsSdvUpbIXWqeUoiMxP3AB29MIlFOdBYlL1LFVrn.jpg', 9, 7029, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(12, '49595533131806', 'uploads/all/Pka1hppOdDKTjyzyfYpp8ixOmIAsQqvQxLssNn1e.jpg', 9, 9172, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(13, '49595534508062', 'uploads/all/YArCKY1ynhVbqUcliBSNt3oEgiYROeTiRZMw9SMn.jpg', 9, 6449, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(14, '49595533197342', 'uploads/all/i2FsvXt5FdpHt0t0YYfOouJ47XMntdTNZoKN4Ba3.jpg', 9, 7430, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(15, '49595534442526', 'uploads/all/vwpyn9aZytSjNFMQg5hYJFWRfMisuvWdN2UwHo8G.jpg', 9, 11242, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(16, '49595534573598', 'uploads/all/9NfF96zNk2QaOvobcATGzmh462OjV1txRBQZ0FD0.jpg', 9, 6820, 'jpg', 'image', '2023-11-23 14:13:53', '2023-11-23 14:13:53', NULL),
(17, '49595534704670', 'uploads/all/iEWVu7dVodBgucomqf0rryyNmPygYsoTZRhDhYkT.jpg', 9, 5780, 'jpg', 'image', '2023-11-23 14:14:18', '2023-11-23 14:14:18', NULL),
(18, '45def485-f8a4-400b-8dee-ff84b68eef8a', 'uploads/all/FFhVLDbQv30QbQEFIqsRzc5jH8w1ymIU7zZ2ca51.png', 9, 1069633, 'png', 'image', '2023-11-23 15:13:52', '2023-11-23 15:13:52', NULL),
(19, 'SBLkJ5dmu4KPNsQY7Sug0VEwiLVikfgUCrFZ1WKh', 'uploads/all/qcJo2te7JAC1Y2PZQ3ex7I7A1utRFZMQ7As1Oahs.jpg', 9, 69292, 'jpg', 'image', '2023-11-23 15:20:25', '2023-11-23 15:20:25', NULL),
(20, '4e3e0ac3-3b9b-4912-be08-03a3b6783d9e', 'uploads/all/uy8sBGsRyaVyEB9pdth23mcFy1WdvxlBJcgxDoDQ.png', 9, 741460, 'png', 'image', '2023-11-23 15:23:11', '2023-11-23 15:23:11', NULL),
(21, 'resize_image', 'uploads/all/sjQjbd8xIIrkadgo0QGQtDKadIlOEGRtYEw9g9CB.png', 9, 116019, 'png', 'image', '2023-11-23 15:29:34', '2023-11-23 15:29:34', NULL),
(22, '49595533197342', 'uploads/all/o51BwlxfMDPyuQFuBzCBuXlhwZlynkqXwWXFDZ7P.jpg', 9, 7430, 'jpg', 'image', '2023-11-23 15:30:16', '2023-11-23 15:30:16', NULL),
(23, 'asifsyed2 (1)', 'uploads/all/TN5IWYBjs6bJBNifL7GwWxuwse7Xk8koUNGSio8B.png', 9, 52505, 'png', 'image', '2023-11-23 15:37:32', '2023-11-23 15:37:32', NULL),
(24, 'f0479034-8a86-49db-8f62-2604a0cfcb0e', 'uploads/all/MhoSh3RUOekHNbDn7kcZSMQmdv9hsjDb07FT1zXQ.jpg', 9, 76723, 'jpeg', 'image', '2023-11-23 22:16:07', '2023-11-23 22:16:07', NULL),
(25, '11b70b56-8509-4c22-b8d2-f6efb869354a', 'uploads/all/ZCHhm1PYpOE901gsu2pUwf1WDd3guuowtLV5Xcup.jpg', 9, 56899, 'jpeg', 'image', '2023-11-23 22:16:07', '2023-11-23 22:16:07', NULL),
(26, '06617aeb-f3ea-4d40-b48f-afdf83bbc367', 'uploads/all/e5d6AGxC1AuDcgGJyRgnj1Gehhkkq22yCDkl9PrV.jpg', 9, 93762, 'jpeg', 'image', '2023-11-23 22:16:07', '2023-11-23 22:16:07', NULL),
(27, '211cbf22-9b68-4d00-b94e-af98b3f141cc', 'uploads/all/KfqLHlnk17UTL6NjlhOgw2zeyJuZDthQ9yfBxh0n.jpg', 9, 64269, 'jpeg', 'image', '2023-11-23 22:16:07', '2023-11-23 22:16:07', NULL),
(28, 'e8213020-a695-41f7-9913-a81841ee3aee', 'uploads/all/ETmcixhW2ZjtjwK2MbCBH8i2qqbwl7FHf2uvsTg8.jpg', 9, 97262, 'jpeg', 'image', '2023-11-23 22:16:07', '2023-11-23 22:16:07', NULL),
(29, '367490970_790887649711748_4092296897689134099_n', 'uploads/all/PAENsA9BnNnhBsKaZBjuddcUfntG29wkwlwRvY3C.jpg', 9, 32482, 'jpg', 'image', '2025-11-04 02:24:04', '2025-11-04 02:24:04', NULL),
(30, 'images', 'uploads/all/veDtdCriTd4LULA3PpnOXejQtQoxMZdDcB5nsy2q.png', 19, 9758, 'png', 'image', '2025-11-22 18:06:51', '2025-11-22 18:06:51', NULL),
(31, 'images (1)', 'uploads/all/AI3YlDn9Oe6w3wLEHHgz3zBUZ1rz4XFnCzxHU55O.png', 19, 9758, 'png', 'image', '2025-11-23 05:52:29', '2025-11-23 05:52:29', NULL),
(32, 'images', 'uploads/all/OeizemeIhOEZDfT919VeUUHOTXdIliwzB5CfZxKa.jpg', 19, 14176, 'jpg', 'image', '2025-11-23 05:52:38', '2025-11-23 05:52:38', NULL),
(33, 'Jacket-34a', 'uploads/all/9DJcjM2RsE6mm4AgLTdldLNj6YxHPw0jaU2Gldq1.jpg', 9, 187217, 'jpg', 'image', '2025-11-26 10:18:54', '2025-11-26 10:18:54', NULL),
(34, 'YfcEvSldioYLnE1udfNreJcQkg1U5FXBLxYolgOT', 'uploads/all/vHQRLc0dleieSM2YJcRZIOzlT4KFrvI17tsYhTAr.jpg', 9, 97826, 'jpg', 'image', '2025-11-26 10:19:52', '2025-11-26 10:19:52', NULL),
(35, 'store-logo-design-template-3ac57f780d1cae2a6d3a049f82c62437_screen', 'uploads/all/rUGhjn25hWyHsiAoMczqz1tF3LzL6hCcnJl4iNzl.jpg', 19, 40972, 'jpg', 'image', '2025-11-27 05:59:46', '2025-11-27 05:59:46', NULL),
(36, 'pngtree-shopping-logo-design-for-online-store-website-png-image_6239056', 'uploads/all/4i2xTmq9zHlplp7dDsFG2j6DwAvRuUDP9ouyErVX.png', 19, 13405, 'png', 'image', '2025-11-27 07:35:40', '2025-11-27 07:35:40', NULL),
(37, 'a16e29300c401b8d17fbab7f0d4f9d3d.jpg_720x720q80', 'uploads/all/Zqx8QzVyQUtWCoRnVSljfS9qyJTMQyCjuZP4SyqA.jpg', 9, 49170, 'jpg', 'image', '2025-11-30 05:53:02', '2025-11-30 05:53:02', NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `referred_by` int DEFAULT NULL,
  `provider_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'customer',
  `name` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `verification_code` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `new_email_verificiation_code` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `password` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `device_token` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `avatar` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `avatar_original` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `country` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `postal_code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `balance` double(20,2) NOT NULL DEFAULT '0.00',
  `banned` tinyint NOT NULL DEFAULT '0',
  `referral_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `customer_package_id` int DEFAULT NULL,
  `remaining_uploads` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `referred_by`, `provider_id`, `user_type`, `name`, `email`, `email_verified_at`, `verification_code`, `new_email_verificiation_code`, `password`, `remember_token`, `device_token`, `avatar`, `avatar_original`, `address`, `country`, `city`, `postal_code`, `phone`, `balance`, `banned`, `referral_code`, `customer_package_id`, `remaining_uploads`, `created_at`, `updated_at`) VALUES
(3, NULL, NULL, 'seller', 'Mr. Seller', 'seller@example.com', '2018-12-11 18:00:00', NULL, NULL, '$2y$10$FVnUft962d4.EyoxhyLBleqg1OowCnS/Ap17EmHU5eX1gJqXrtC0e', '1zoU4eQxnOC5yxRWLsTzMNBPpJuOvTk4g3GMUVYIrbGijiXHOfIlFq0wHrIn', NULL, 'https://lh3.googleusercontent.com/-7OnRtLyua5Q/AAAAAAAAAAI/AAAAAAAADRk/VqWKMl4f8CI/photo.jpg?sz=50', NULL, 'Demo address', 'US', 'Demo city', '1234', NULL, 0.00, 0, '3dLUoHsR1l', NULL, NULL, '2018-10-07 04:42:57', '2020-03-05 01:33:22'),
(8, NULL, NULL, 'customer', 'Mr. Customer', 'customer@example.com', '2018-12-11 18:00:00', NULL, NULL, '$2y$10$eUKRlkmm2TAug75cfGQ4i.WoUbcJ2uVPqUlVkox.cv4CCyGEIMQEm', '9ndcz5o7xgnuxctJIbvUQcP41QKmgnWCc7JDSnWdHOvipOP2AijpamCNafEe', NULL, 'https://lh3.googleusercontent.com/-7OnRtLyua5Q/AAAAAAAAAAI/AAAAAAAADRk/VqWKMl4f8CI/photo.jpg?sz=50', NULL, 'Demo address', 'US', 'Demo city', '1234', NULL, 0.00, 0, '8zJTyXTlTT', NULL, NULL, '2018-10-07 04:42:57', '2020-03-03 04:26:11'),
(9, NULL, NULL, 'admin', 'admin', 'admin@gmail.com', '2023-11-22 12:11:47', NULL, NULL, '$2y$10$FVnUft962d4.EyoxhyLBleqg1OowCnS/Ap17EmHU5eX1gJqXrtC0e', 'DaSlYXufJsxuQ8Do9bVKrKoveC7vBZ5J5p6IAE9YRdKMJ1oNl6hLNypui5Yt', NULL, NULL, '29', NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2023-11-22 12:22:47', '2025-11-04 02:37:21'),
(10, NULL, NULL, 'customer', 'SYED MD. ASIF HOSSAIN', 'asif48708698@gmail.com', '2023-11-23 15:11:08', NULL, NULL, '$2y$10$PtbtMi8oZ331FaEeoHi8/ua7YtVwc1obNHWDoP0efegyRZX8aj8/a', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2023-11-23 15:27:08', '2023-11-23 15:27:08'),
(11, NULL, NULL, 'customer', 'asif', 'asif@gmail.com', '2023-11-24 01:11:11', NULL, NULL, '$2y$10$PCNw/p2mTQmrIZXHiTlvYO9WzxqSUzKVbiPmP.o0UYhvzUiL1J55q', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2023-11-24 01:23:11', '2023-11-24 01:23:11'),
(12, NULL, NULL, 'customer', 'Rubel', 'rubel.mia2091996@gmail.com', '2023-12-03 21:12:54', NULL, NULL, '$2y$10$roOdIhrjkCS9l/YzQf8n1OIu/zdQSypl8rim.9c7j86jx/ADK7dLa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2023-12-03 21:31:54', '2023-12-03 21:31:54'),
(13, NULL, NULL, 'customer', 'tom104', 'tom104@gmail.com', '2024-04-23 10:04:25', NULL, NULL, '$2y$10$LUOKlJDFzLxzckyrY7OZcug7JVkboCV3XZcAz4pNY5Bwo5zmNc2dm', 'jHdrTioiw3Lrnxe0jjboV8X2tTTyuDPyvb6awohKQslabSsIOCi8ofaDCalh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2024-04-23 10:25:25', '2024-04-23 10:25:25'),
(14, NULL, NULL, 'customer', 'tom607', 'tom607@gmail.com', '2024-04-23 10:04:49', NULL, NULL, '$2y$10$FkhdWJbRulpa4TCUDJ//X.yB0wUPMx/sA8VYAXqQwC0BIA9eV9VmS', 'cvAlISeQJODOS7Cla5w1hcMmBkx5wpAiRa1sj5Yqijaf7wK8lDCDibFgd0D6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2024-04-23 10:47:49', '2024-04-23 10:47:49'),
(15, NULL, NULL, 'customer', 'tom488', 'tom488@gmail.com', '2024-04-24 09:04:24', NULL, NULL, '$2y$10$kTJ/iIFsGl5JOO/1//AtLOO/k0eZ2zlrKM8FPqDFODcb7DdNNIO2K', 'tNB9sF19OHqbKCguUeFyt3d8DPYhDFLc5nQGlo1lcR4STob16FmIc9120Xu7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2024-04-24 09:04:24', '2024-04-24 09:04:24'),
(16, NULL, NULL, 'customer', 'tonyi123', '175952596312@qq.com', '2025-09-04 14:09:45', '223685', NULL, '$2y$10$Z9XpDCaraRz9FOlYTfgglejYs83cy6aTZRY9LrV3mFHrxN8K0wwPm', 'NEkx25vRJdMFwOYY7s3U7wYawYuA7ueym8o0Mz4clR0SHgWbAJtFySbIBlHw', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2025-09-04 14:25:45', '2025-09-04 14:25:45'),
(17, NULL, NULL, 'customer', 'NIloy', 'niloy@gmail.com', '2025-11-04 02:11:03', NULL, NULL, '$2y$10$j6CCKjTCgTuuJGYz4ZM8leo7/eIBg2VlebYqT8jnMnELca96L/0SK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0, '2025-11-04 02:44:03', '2025-11-04 02:44:03'),
(18, NULL, NULL, 'customer', 'test', 'test@gmail.com', '2025-11-10 02:11:41', NULL, NULL, '$2y$10$aAWccPTPWpeC5GYpqjcU1u2uyutWIrE9U7lztBt/PSYY0m42Q5dX.', 'Tq4tmU4z6u3Ki5CNjFfyctfRQdIMMTq7DtbkOF8qDMpNeZhQJM6lqGd8hrxE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 105.00, 0, NULL, NULL, 0, '2025-11-10 02:51:41', '2025-11-25 10:54:10'),
(19, NULL, NULL, 'admin', 'Super Admin', 'superadmin@gmail.com', NULL, NULL, NULL, '$2y$10$GpaWGIKavdPm2TTrQKp0r.tYZuisLXdCdoHl302UZTKrZzoCr8lWe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '01723635223', 0.00, 0, NULL, NULL, 0, '2025-11-18 17:06:26', '2025-11-18 17:06:26');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE IF NOT EXISTS `wallets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `amount` double(20,2) NOT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `payment_details` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `approval` int NOT NULL DEFAULT '0',
  `offline_payment` int NOT NULL DEFAULT '0',
  `reciept` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `amount`, `payment_method`, `payment_details`, `approval`, `offline_payment`, `reciept`, `created_at`, `updated_at`) VALUES
(1, 18, 100.00, 'Bank Transfer', '234567843', 1, 1, NULL, '2025-11-23 06:03:34', '2025-11-23 06:24:09'),
(2, 18, 1000.00, 'Check Payment', '322425252', 1, 1, NULL, '2025-11-23 06:31:16', '2025-11-23 06:31:30'),
(3, 18, 1000.00, 'Check Payment', '234252524124134', 1, 1, NULL, '2025-11-23 07:24:08', '2025-11-23 07:28:44'),
(4, 18, 5000.00, 'Bank Transfer', '234252556524124134', 1, 1, NULL, '2025-11-23 07:45:28', '2025-11-23 07:45:49'),
(5, 18, 5.00, 'Club Point Convert', 'Club Point Convert', 0, 0, NULL, '2025-11-25 10:54:10', '2025-11-25 10:54:10');

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

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

CREATE TABLE IF NOT EXISTS `wishlists` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `product_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
COMMIT;

