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

START TRANSACTION;



--
-- Database: `elitede1_ecom11`
--

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

--
-- Table structure for table `addon_settings`
--

CREATE TABLE `addon_settings` (
  `id` char(36) NOT NULL,
  `key_name` varchar(191) DEFAULT NULL,
  `live_values` longtext DEFAULT NULL,
  `test_values` longtext DEFAULT NULL,
  `settings_type` varchar(255) DEFAULT NULL,
  `mode` varchar(20) NOT NULL DEFAULT 'live',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addon_settings`
--

INSERT INTO `addon_settings` (`id`, `key_name`, `live_values`, `test_values`, `settings_type`, `mode`, `is_active`, `created_at`, `updated_at`, `additional_data`) VALUES
('070c6bbd-d777-11ed-96f4-0c7a158e4469', 'twilio', '{\"gateway\":\"twilio\",\"mode\":\"live\",\"status\":\"0\",\"sid\":\"data\",\"messaging_service_sid\":\"data\",\"token\":\"data\",\"from\":\"data\",\"otp_template\":\"data\"}', '{\"gateway\":\"twilio\",\"mode\":\"live\",\"status\":\"0\",\"sid\":\"data\",\"messaging_service_sid\":\"data\",\"token\":\"data\",\"from\":\"data\",\"otp_template\":\"data\"}', 'sms_config', 'live', 0, NULL, '2023-08-12 07:01:29', NULL),
('070c766c-d777-11ed-96f4-0c7a158e4469', '2factor', '{\"gateway\":\"2factor\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"data\"}', '{\"gateway\":\"2factor\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"data\"}', 'sms_config', 'live', 0, NULL, '2023-08-12 07:01:36', NULL),
('0d8a9308-d6a5-11ed-962c-0c7a158e4469', 'mercadopago', '{\"gateway\":\"mercadopago\",\"mode\":\"live\",\"status\":0,\"access_token\":\"\",\"public_key\":\"\"}', '{\"gateway\":\"mercadopago\",\"mode\":\"live\",\"status\":0,\"access_token\":\"\",\"public_key\":\"\"}', 'payment_config', 'test', 0, NULL, '2023-08-27 11:57:11', '{\"gateway_title\":\"Mercadopago\",\"gateway_image\":null}'),
('0d8a9e49-d6a5-11ed-962c-0c7a158e4469', 'liqpay', '{\"gateway\":\"liqpay\",\"mode\":\"live\",\"status\":0,\"private_key\":\"\",\"public_key\":\"\"}', '{\"gateway\":\"liqpay\",\"mode\":\"live\",\"status\":0,\"private_key\":\"\",\"public_key\":\"\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:32:31', '{\"gateway_title\":\"Liqpay\",\"gateway_image\":null}'),
('101befdf-d44b-11ed-8564-0c7a158e4469', 'paypal', '{\"gateway\":\"paypal\",\"mode\":\"live\",\"status\":\"0\",\"client_id\":\"\",\"client_secret\":\"\"}', '{\"gateway\":\"paypal\",\"mode\":\"live\",\"status\":\"0\",\"client_id\":\"\",\"client_secret\":\"\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 03:41:32', '{\"gateway_title\":\"Paypal\",\"gateway_image\":null}'),
('133d9647-cabb-11ed-8fec-0c7a158e4469', 'hyper_pay', '{\"gateway\":\"hyper_pay\",\"mode\":\"test\",\"status\":\"0\",\"entity_id\":\"data\",\"access_code\":\"data\"}', '{\"gateway\":\"hyper_pay\",\"mode\":\"test\",\"status\":\"0\",\"entity_id\":\"data\",\"access_code\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:32:42', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('1821029f-d776-11ed-96f4-0c7a158e4469', 'msg91', '{\"gateway\":\"msg91\",\"mode\":\"live\",\"status\":\"0\",\"template_id\":\"data\",\"auth_key\":\"data\"}', '{\"gateway\":\"msg91\",\"mode\":\"live\",\"status\":\"0\",\"template_id\":\"data\",\"auth_key\":\"data\"}', 'sms_config', 'live', 0, NULL, '2023-08-12 07:01:48', NULL),
('18210f2b-d776-11ed-96f4-0c7a158e4469', 'nexmo', '{\"gateway\":\"nexmo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"\",\"api_secret\":\"\",\"token\":\"\",\"from\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"nexmo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"\",\"api_secret\":\"\",\"token\":\"\",\"from\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, '2023-04-10 02:14:44', NULL),
('18fbb21f-d6ad-11ed-962c-0c7a158e4469', 'foloosi', '{\"gateway\":\"foloosi\",\"mode\":\"test\",\"status\":\"0\",\"merchant_key\":\"data\"}', '{\"gateway\":\"foloosi\",\"mode\":\"test\",\"status\":\"0\",\"merchant_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:34:33', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('2767d142-d6a1-11ed-962c-0c7a158e4469', 'paytm', '{\"gateway\":\"paytm\",\"mode\":\"live\",\"status\":0,\"merchant_key\":\"\",\"merchant_id\":\"\",\"merchant_website_link\":\"\"}', '{\"gateway\":\"paytm\",\"mode\":\"live\",\"status\":0,\"merchant_key\":\"\",\"merchant_id\":\"\",\"merchant_website_link\":\"\"}', 'payment_config', 'test', 0, NULL, '2023-08-22 06:30:55', '{\"gateway_title\":\"Paytm\",\"gateway_image\":null}'),
('3201d2e6-c937-11ed-a424-0c7a158e4469', 'amazon_pay', '{\"gateway\":\"amazon_pay\",\"mode\":\"test\",\"status\":\"0\",\"pass_phrase\":\"data\",\"access_code\":\"data\",\"merchant_identifier\":\"data\"}', '{\"gateway\":\"amazon_pay\",\"mode\":\"test\",\"status\":\"0\",\"pass_phrase\":\"data\",\"access_code\":\"data\",\"merchant_identifier\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:36:07', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('4593b25c-d6a1-11ed-962c-0c7a158e4469', 'paytabs', '{\"gateway\":\"paytabs\",\"mode\":\"live\",\"status\":0,\"profile_id\":\"\",\"server_key\":\"\",\"base_url\":\"https:\\/\\/secure-egypt.paytabs.com\\/\"}', '{\"gateway\":\"paytabs\",\"mode\":\"live\",\"status\":0,\"profile_id\":\"\",\"server_key\":\"\",\"base_url\":\"https:\\/\\/secure-egypt.paytabs.com\\/\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:34:51', '{\"gateway_title\":\"Paytabs\",\"gateway_image\":null}'),
('4e9b8dfb-e7d1-11ed-a559-0c7a158e4469', 'bkash', '{\"gateway\":\"bkash\",\"mode\":\"live\",\"status\":\"0\",\"app_key\":\"\",\"app_secret\":\"\",\"username\":\"\",\"password\":\"\"}', '{\"gateway\":\"bkash\",\"mode\":\"live\",\"status\":\"0\",\"app_key\":\"\",\"app_secret\":\"\",\"username\":\"\",\"password\":\"\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:39:42', '{\"gateway_title\":\"Bkash\",\"gateway_image\":null}'),
('544a24a4-c872-11ed-ac7a-0c7a158e4469', 'fatoorah', '{\"gateway\":\"fatoorah\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}', '{\"gateway\":\"fatoorah\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:36:24', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('58c1bc8a-d6ac-11ed-962c-0c7a158e4469', 'ccavenue', '{\"gateway\":\"ccavenue\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"working_key\":\"data\",\"access_code\":\"data\"}', '{\"gateway\":\"ccavenue\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"working_key\":\"data\",\"access_code\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 03:42:38', '{\"gateway_title\":null,\"gateway_image\":\"2023-04-13-643783f01d386.png\"}'),
('5e2d2ef9-d6ab-11ed-962c-0c7a158e4469', 'thawani', '{\"gateway\":\"thawani\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"private_key\":\"data\"}', '{\"gateway\":\"thawani\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"private_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:50:40', '{\"gateway_title\":null,\"gateway_image\":\"2023-04-13-64378f9856f29.png\"}'),
('60cc83cc-d5b9-11ed-b56f-0c7a158e4469', 'sixcash', '{\"gateway\":\"sixcash\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"secret_key\":\"data\",\"merchant_number\":\"data\",\"base_url\":\"data\"}', '{\"gateway\":\"sixcash\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"secret_key\":\"data\",\"merchant_number\":\"data\",\"base_url\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:16:17', '{\"gateway_title\":null,\"gateway_image\":\"2023-04-12-6436774e77ff9.png\"}'),
('68579846-d8e8-11ed-8249-0c7a158e4469', 'alphanet_sms', '{\"gateway\":\"alphanet_sms\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"alphanet_sms\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL),
('6857a2e8-d8e8-11ed-8249-0c7a158e4469', 'sms_to', '{\"gateway\":\"sms_to\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"sms_to\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL),
('74c30c00-d6a6-11ed-962c-0c7a158e4469', 'hubtel', '{\"gateway\":\"hubtel\",\"mode\":\"test\",\"status\":\"0\",\"account_number\":\"data\",\"api_id\":\"data\",\"api_key\":\"data\"}', '{\"gateway\":\"hubtel\",\"mode\":\"test\",\"status\":\"0\",\"account_number\":\"data\",\"api_id\":\"data\",\"api_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:37:43', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('74e46b0a-d6aa-11ed-962c-0c7a158e4469', 'tap', '{\"gateway\":\"tap\",\"mode\":\"test\",\"status\":\"0\",\"secret_key\":\"data\"}', '{\"gateway\":\"tap\",\"mode\":\"test\",\"status\":\"0\",\"secret_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:50:09', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('761ca96c-d1eb-11ed-87ca-0c7a158e4469', 'swish', '{\"gateway\":\"swish\",\"mode\":\"test\",\"status\":\"0\",\"number\":\"data\"}', '{\"gateway\":\"swish\",\"mode\":\"test\",\"status\":\"0\",\"number\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:17:02', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('7b1c3c5f-d2bd-11ed-b485-0c7a158e4469', 'payfast', '{\"gateway\":\"payfast\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"secured_key\":\"data\"}', '{\"gateway\":\"payfast\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"secured_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:18:13', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('8592417b-d1d1-11ed-a984-0c7a158e4469', 'esewa', '{\"gateway\":\"esewa\",\"mode\":\"test\",\"status\":\"0\",\"merchantCode\":\"data\"}', '{\"gateway\":\"esewa\",\"mode\":\"test\",\"status\":\"0\",\"merchantCode\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:17:38', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('9162a1dc-cdf1-11ed-affe-0c7a158e4469', 'viva_wallet', '{\"gateway\":\"viva_wallet\",\"mode\":\"test\",\"status\":\"0\",\"client_id\": \"\",\"client_secret\": \"\", \"source_code\":\"\"}\n', '{\"gateway\":\"viva_wallet\",\"mode\":\"test\",\"status\":\"0\",\"client_id\": \"\",\"client_secret\": \"\", \"source_code\":\"\"}\n', 'payment_config', 'test', 0, NULL, NULL, NULL),
('998ccc62-d6a0-11ed-962c-0c7a158e4469', 'stripe', '{\"gateway\":\"stripe\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null,\"published_key\":null}', '{\"gateway\":\"stripe\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null,\"published_key\":null}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:18:55', '{\"gateway_title\":\"Stripe\",\"gateway_image\":null}'),
('a3313755-c95d-11ed-b1db-0c7a158e4469', 'iyzi_pay', '{\"gateway\":\"iyzi_pay\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\",\"secret_key\":\"data\",\"base_url\":\"data\"}', '{\"gateway\":\"iyzi_pay\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\",\"secret_key\":\"data\",\"base_url\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:20:02', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('a76c8993-d299-11ed-b485-0c7a158e4469', 'momo', '{\"gateway\":\"momo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"data\",\"api_user\":\"data\",\"subscription_key\":\"data\"}', '{\"gateway\":\"momo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"data\",\"api_user\":\"data\",\"subscription_key\":\"data\"}', 'payment_config', 'live', 0, NULL, '2023-08-30 04:19:28', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('a8608119-cc76-11ed-9bca-0c7a158e4469', 'moncash', '{\"gateway\":\"moncash\",\"mode\":\"test\",\"status\":\"0\",\"client_id\":\"data\",\"secret_key\":\"data\"}', '{\"gateway\":\"moncash\",\"mode\":\"test\",\"status\":\"0\",\"client_id\":\"data\",\"secret_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:47:34', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('ad5af1c1-d6a2-11ed-962c-0c7a158e4469', 'razor_pay', '{\"gateway\":\"razor_pay\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null,\"api_secret\":null}', '{\"gateway\":\"razor_pay\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null,\"api_secret\":null}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:47:00', '{\"gateway_title\":\"Razor pay\",\"gateway_image\":null}'),
('ad5b02a0-d6a2-11ed-962c-0c7a158e4469', 'senang_pay', '{\"gateway\":\"senang_pay\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":null,\"secret_key\":null,\"merchant_id\":null}', '{\"gateway\":\"senang_pay\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":null,\"secret_key\":null,\"merchant_id\":null}', 'payment_config', 'test', 0, NULL, '2023-08-27 09:58:57', '{\"gateway_title\":\"Senang pay\",\"gateway_image\":null}'),
('b6c333f6-d8e9-11ed-8249-0c7a158e4469', 'akandit_sms', '{\"gateway\":\"akandit_sms\",\"mode\":\"live\",\"status\":0,\"username\":\"\",\"password\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"akandit_sms\",\"mode\":\"live\",\"status\":0,\"username\":\"\",\"password\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL),
('b6c33c87-d8e9-11ed-8249-0c7a158e4469', 'global_sms', '{\"gateway\":\"global_sms\",\"mode\":\"live\",\"status\":0,\"user_name\":\"\",\"password\":\"\",\"from\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"global_sms\",\"mode\":\"live\",\"status\":0,\"user_name\":\"\",\"password\":\"\",\"from\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL),
('b8992bd4-d6a0-11ed-962c-0c7a158e4469', 'paymob_accept', '{\"gateway\":\"paymob_accept\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":null,\"api_key\":\"\",\"iframe_id\":\"\",\"integration_id\":\"\",\"hmac\":\"\"}', '{\"gateway\":\"paymob_accept\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":null,\"api_key\":\"\",\"iframe_id\":\"\",\"integration_id\":\"\",\"hmac\":\"\"}', 'payment_config', 'test', 0, NULL, NULL, '{\"gateway_title\":\"Paymob accept\",\"gateway_image\":null}'),
('c41c0dcd-d119-11ed-9f67-0c7a158e4469', 'maxicash', '{\"gateway\":\"maxicash\",\"mode\":\"test\",\"status\":\"0\",\"merchantId\":\"data\",\"merchantPassword\":\"data\"}', '{\"gateway\":\"maxicash\",\"mode\":\"test\",\"status\":\"0\",\"merchantId\":\"data\",\"merchantPassword\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:49:15', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('c9249d17-cd60-11ed-b879-0c7a158e4469', 'pvit', '{\"gateway\":\"pvit\",\"mode\":\"test\",\"status\":\"0\",\"mc_tel_merchant\": \"\",\"access_token\": \"\", \"mc_merchant_code\": \"\"}', '{\"gateway\":\"pvit\",\"mode\":\"test\",\"status\":\"0\",\"mc_tel_merchant\": \"\",\"access_token\": \"\", \"mc_merchant_code\": \"\"}', 'payment_config', 'test', 0, NULL, NULL, NULL),
('cb0081ce-d775-11ed-96f4-0c7a158e4469', 'releans', '{\"gateway\":\"releans\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"from\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"releans\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"from\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, '2023-04-10 02:14:44', NULL),
('d4f3f5f1-d6a0-11ed-962c-0c7a158e4469', 'flutterwave', '{\"gateway\":\"flutterwave\",\"mode\":\"live\",\"status\":0,\"secret_key\":\"\",\"public_key\":\"\",\"hash\":\"\"}', '{\"gateway\":\"flutterwave\",\"mode\":\"live\",\"status\":0,\"secret_key\":\"\",\"public_key\":\"\",\"hash\":\"\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:41:03', '{\"gateway_title\":\"Flutterwave\",\"gateway_image\":null}'),
('d822f1a5-c864-11ed-ac7a-0c7a158e4469', 'paystack', '{\"gateway\":\"paystack\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":\"https:\\/\\/api.paystack.co\",\"public_key\":null,\"secret_key\":null,\"merchant_email\":null}', '{\"gateway\":\"paystack\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":\"https:\\/\\/api.paystack.co\",\"public_key\":null,\"secret_key\":null,\"merchant_email\":null}', 'payment_config', 'test', 0, NULL, '2023-08-30 04:20:45', '{\"gateway_title\":\"Paystack\",\"gateway_image\":null}'),
('daec8d59-c893-11ed-ac7a-0c7a158e4469', 'xendit', '{\"gateway\":\"xendit\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}', '{\"gateway\":\"xendit\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:35:46', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('dc0f5fc9-d6a5-11ed-962c-0c7a158e4469', 'worldpay', '{\"gateway\":\"worldpay\",\"mode\":\"test\",\"status\":\"0\",\"OrgUnitId\":\"data\",\"jwt_issuer\":\"data\",\"mac\":\"data\",\"merchantCode\":\"data\",\"xml_password\":\"data\"}', '{\"gateway\":\"worldpay\",\"mode\":\"test\",\"status\":\"0\",\"OrgUnitId\":\"data\",\"jwt_issuer\":\"data\",\"mac\":\"data\",\"merchantCode\":\"data\",\"xml_password\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:35:26', '{\"gateway_title\":null,\"gateway_image\":\"\"}'),
('e0450278-d8eb-11ed-8249-0c7a158e4469', 'signal_wire', '{\"gateway\":\"signal_wire\",\"mode\":\"live\",\"status\":0,\"project_id\":\"\",\"token\":\"\",\"space_url\":\"\",\"from\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"signal_wire\",\"mode\":\"live\",\"status\":0,\"project_id\":\"\",\"token\":\"\",\"space_url\":\"\",\"from\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL),
('e0450b40-d8eb-11ed-8249-0c7a158e4469', 'paradox', '{\"gateway\":\"paradox\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"\",\"sender_id\":\"\"}', '{\"gateway\":\"paradox\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"\",\"sender_id\":\"\"}', 'sms_config', 'live', 0, NULL, '2023-09-10 01:14:01', NULL),
('ea346efe-cdda-11ed-affe-0c7a158e4469', 'ssl_commerz', '{\"gateway\":\"ssl_commerz\",\"mode\":\"live\",\"status\":\"0\",\"store_id\":\"\",\"store_password\":\"\"}', '{\"gateway\":\"ssl_commerz\",\"mode\":\"live\",\"status\":\"0\",\"store_id\":\"\",\"store_password\":\"\"}', 'payment_config', 'test', 0, NULL, '2023-08-30 03:43:49', '{\"gateway_title\":\"Ssl commerz\",\"gateway_image\":null}'),
('eed88336-d8ec-11ed-8249-0c7a158e4469', 'hubtel', '{\"gateway\":\"hubtel\",\"mode\":\"live\",\"status\":0,\"sender_id\":\"\",\"client_id\":\"\",\"client_secret\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"hubtel\",\"mode\":\"live\",\"status\":0,\"sender_id\":\"\",\"client_id\":\"\",\"client_secret\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL),
('f149c546-d8ea-11ed-8249-0c7a158e4469', 'viatech', '{\"gateway\":\"viatech\",\"mode\":\"live\",\"status\":0,\"api_url\":\"\",\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"viatech\",\"mode\":\"live\",\"status\":0,\"api_url\":\"\",\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL),
('f149cd9c-d8ea-11ed-8249-0c7a158e4469', '019_sms', '{\"gateway\":\"019_sms\",\"mode\":\"live\",\"status\":0,\"password\":\"\",\"username\":\"\",\"username_for_token\":\"\",\"sender\":\"\",\"otp_template\":\"\"}', '{\"gateway\":\"019_sms\",\"mode\":\"live\",\"status\":0,\"password\":\"\",\"username\":\"\",\"username_for_token\":\"\",\"sender\":\"\",\"otp_template\":\"\"}', 'sms_config', 'live', 0, NULL, NULL, NULL);

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

--
-- Table structure for table `add_fund_bonus_categories`
--

CREATE TABLE `add_fund_bonus_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `bonus_type` varchar(50) NOT NULL,
  `bonus_amount` double(14,2) NOT NULL DEFAULT 0.00,
  `min_add_money_amount` double(14,2) NOT NULL DEFAULT 0.00,
  `max_bonus_amount` double(14,2) NOT NULL DEFAULT 0.00,
  `start_date_time` datetime DEFAULT NULL,
  `end_date_time` datetime DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `admin_roles`
--

CREATE TABLE `admin_roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `module_access` varchar(250) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_roles`
--

INSERT INTO `admin_roles` (`id`, `name`, `module_access`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Master Admin', NULL, 1, NULL, NULL);

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

--
-- Table structure for table `admin_wallets`
--

CREATE TABLE `admin_wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `inhouse_earning` double NOT NULL DEFAULT 0,
  `withdrawn` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `commission_earned` double(8,2) NOT NULL DEFAULT 0.00,
  `delivery_charge_earned` double(8,2) NOT NULL DEFAULT 0.00,
  `pending_amount` double(8,2) NOT NULL DEFAULT 0.00,
  `total_tax_collected` double(8,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_wallets`
--

INSERT INTO `admin_wallets` (`id`, `admin_id`, `inhouse_earning`, `withdrawn`, `created_at`, `updated_at`, `commission_earned`, `delivery_charge_earned`, `pending_amount`, `total_tax_collected`) VALUES
(1, 1, 0, 0, NULL, NULL, 0.00, 0.00, 0.00, 0.00),
(2, 1, 0, 0, '2024-03-07 09:42:43', '2024-03-07 09:42:43', 0.00, 0.00, 0.00, 0.00);

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

--
-- Table structure for table `admin_wallet_histories`
--

CREATE TABLE `admin_wallet_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `order_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `payment` varchar(191) NOT NULL DEFAULT 'received',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `attributes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `banner_type` varchar(255) NOT NULL,
  `theme` varchar(255) NOT NULL DEFAULT 'default',
  `published` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `resource_type` varchar(191) DEFAULT NULL,
  `resource_id` bigint(20) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `sub_title` varchar(191) DEFAULT NULL,
  `button_text` varchar(191) DEFAULT NULL,
  `background_color` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `banners` (`id`, `photo`, `banner_type`, `theme`, `published`, `created_at`, `updated_at`, `url`, `resource_type`, `resource_id`, `title`, `sub_title`, `button_text`, `background_color`) VALUES
(1, '2024-03-07-65e95219b7244.webp', 'Main Banner', 'default', 1, '2024-03-07 05:35:21', '2024-03-07 05:35:27', 'https://elitedesign.com.bd', 'product', NULL, NULL, NULL, NULL, NULL),
(2, '2024-03-07-65e9524f5cde3.webp', 'Main Banner', 'default', 1, '2024-03-07 05:36:15', '2024-03-07 05:36:46', 'https://elitedesign.com.bd', 'product', NULL, NULL, NULL, NULL, NULL),
(3, '2024-03-07-65e952795d38a.webp', 'Main Banner', 'default', 1, '2024-03-07 05:36:57', '2024-03-07 05:37:20', 'https://elitedesign.com.bd', 'product', NULL, NULL, NULL, NULL, NULL),
(5, '2024-03-08-65eab7c4eb973.webp', 'Main Banner', 'theme_fashion', 1, '2024-03-08 07:01:24', '2024-03-08 07:02:04', 'https://youngerlifestyle.net/', 'category', 14, 'Elevate Your Lifestyle', 'Explore, Experience, Enjoy – All at Your Fingertips', 'Shop Now', '#8d3cb9'),
(6, '2024-03-08-65eab83eefc71.webp', 'Main Banner', 'theme_fashion', 1, '2024-03-08 07:03:26', '2024-03-08 07:03:32', 'https://youngerlifestyle.net/', 'category', 14, 'Unleash Your Imagination', 'Limitless Choices Await You on Our E-Commerce Paradise', 'Shop Now', '#08b2b5'),
(7, '2024-03-08-65eab88a6fe09.webp', 'Main Banner', 'theme_fashion', 1, '2024-03-08 07:04:42', '2024-03-08 07:04:47', 'https://youngerlifestyle.net/', 'category', 16, 'Shop Smarter, Live Better', 'Discover Endless Possibilities at 6valley', 'Shop Now', '#fee440'),
(8, '2024-03-08-65eab8cfc2141.webp', 'Main Banner', 'theme_fashion', 1, '2024-03-08 07:05:51', '2024-03-08 07:05:59', 'https://youngerlifestyle.net/', 'category', 14, 'Your Dream Store Awaits', 'Browse, Click, and Transform Your World Today', 'Shop Now', '#c20044'),
(9, '2024-03-08-65eab92a8a732.webp', 'Main Banner', 'theme_fashion', 1, '2024-03-08 07:07:22', '2024-03-08 07:07:28', 'https://youngerlifestyle.net/', 'category', 14, 'Unleash Your Imagination', 'Limitless Choices Await You on Our E-Commerce Paradise', 'Shop Now', '#08b2b5'),
(10, '2024-03-08-65eab9e17579a.webp', 'Promo Banner Middle Bottom', 'theme_fashion', 1, '2024-03-08 07:10:25', '2024-03-08 07:10:33', 'https://youngerlifestyle.net/', 'category', 14, NULL, NULL, NULL, '#fee440'),
(11, '2024-03-08-65eab9f7a1164.webp', 'Promo Banner Middle Top', 'theme_fashion', 1, '2024-03-08 07:10:47', '2024-03-08 07:10:58', 'https://youngerlifestyle.net/', 'category', 14, NULL, NULL, NULL, '#fee440'),
(12, '2024-03-08-65eaba53034a7.webp', 'Promo Banner Right', 'theme_fashion', 1, '2024-03-08 07:12:19', '2024-03-08 07:12:27', 'https://youngerlifestyle.net/', 'category', 14, NULL, NULL, NULL, '#fee440'),
(13, '2024-03-08-65eabaa96adc2.webp', 'Promo Banner Left', 'theme_fashion', 1, '2024-03-08 07:13:45', '2024-03-08 07:13:54', 'https://youngerlifestyle.net/', 'category', 14, NULL, NULL, NULL, '#fee440');

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

--
-- Table structure for table `billing_addresses`
--

CREATE TABLE `billing_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `contact_person_name` varchar(191) DEFAULT NULL,
  `address_type` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `zip` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `image` varchar(50) NOT NULL DEFAULT 'def.png',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `brands` (`id`, `name`, `image`, `status`, `created_at`, `updated_at`) VALUES
(12, 'Easy', '2024-03-08-65eabc53f2a78.webp', 1, '2024-03-08 07:20:52', '2024-03-08 07:20:52');

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

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

CREATE TABLE `business_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(50) NOT NULL,
  `value` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `business_settings` (`id`, `type`, `value`, `created_at`, `updated_at`) VALUES
(1, 'system_default_currency', '2', '2020-10-11 07:43:44', '2024-03-08 10:26:17'),
(2, 'language', '[{\"id\":\"1\",\"name\":\"english\",\"direction\":\"ltr\",\"code\":\"en\",\"status\":1,\"default\":true}]', '2020-10-11 07:53:02', '2024-03-08 10:26:17'),
(3, 'mail_config', '{\"status\":0,\"name\":\"demo\",\"host\":\"mail.demo.com\",\"driver\":\"SMTP\",\"port\":\"587\",\"username\":\"info@demo.com\",\"email_id\":\"info@demo.com\",\"encryption\":\"TLS\",\"password\":\"demo\"}', '2020-10-12 10:29:18', '2021-07-06 12:32:01'),
(4, 'cash_on_delivery', '{\"status\":\"1\"}', NULL, '2024-03-07 04:03:01'),
(6, 'ssl_commerz_payment', '{\"status\":\"0\",\"environment\":\"sandbox\",\"store_id\":\"\",\"store_password\":\"\"}', '2020-11-09 08:36:51', '2023-01-10 05:51:56'),
(7, 'paypal', '{\"status\":\"0\",\"environment\":\"sandbox\",\"paypal_client_id\":\"\",\"paypal_secret\":\"\"}', '2020-11-09 08:51:39', '2023-01-10 05:51:56'),
(8, 'stripe', '{\"status\":\"0\",\"api_key\":null,\"published_key\":null}', '2020-11-09 09:01:47', '2021-07-06 12:30:05'),
(10, 'company_phone', '01775457008', NULL, '2024-03-08 10:26:17'),
(11, 'company_name', 'Younger Life Style', NULL, '2024-03-08 10:26:17'),
(12, 'company_web_logo', '2024-03-08-65eaaefaeacab.webp', NULL, '2024-03-08 06:23:54'),
(13, 'company_mobile_logo', '2024-03-08-65eaae6c105ca.webp', NULL, '2024-03-08 06:21:32'),
(14, 'terms_condition', '<p>terms and conditions</p>', NULL, '2021-06-11 01:51:36'),
(15, 'about_us', '<p>Welcome to [Your E-Commerce Website]. Your One-Stop Destination for All Things [Your Niche/Product Category]. We are more than just an online store; we are your trusted partner in finding quality products that enhance your life.</p><p><span style=\"font-weight: bolder;\">Our Story</span></p><p>Founded in [Year], [Your E-Commerce Website] was born out of a passion for [Your Niche/Product Category]. Our journey began with a simple mission: to provide a convenient, enjoyable, and reliable shopping experience to individuals who share our enthusiasm.</p><p><span style=\"font-weight: bolder;\">What Sets Us Apart?</span></p><ol><li><p><span style=\"font-weight: bolder;\">Quality Assurance</span>: We curate a carefully selected range of products, focusing on quality and innovation. Every item you find here is chosen with precision, ensuring you receive the best value for your money.</p></li><li><p><span style=\"font-weight: bolder;\">Customer-Centric Approach</span>: Your satisfaction is our top priority. We go the extra mile to offer personalized support, quick response times, and hassle-free returns.</p></li><li><p><span style=\"font-weight: bolder;\">Secure Shopping</span>: We understand the importance of security when shopping online. Your data is protected by industry-standard encryption and security measures.</p></li><li><p><span style=\"font-weight: bolder;\">Constant Improvement</span>: We continuously strive to improve our website, product selection, and customer service to meet your evolving needs.</p></li></ol><p><span style=\"font-weight: bolder;\">Our Commitment</span></p><p>At [Your E-Commerce Website], we are committed to not only meeting but exceeding your expectations. Whether you\'re looking for everyday essentials or unique items to express your style, we\'ve got you covered. Your trust in us is what fuels our passion.</p><p><span style=\"font-weight: bolder;\">Join Our Community</span></p><p>We invite you to explore our website, discover our product offerings, and become a part of our growing community. Subscribe to our newsletter and follow us on social media to stay updated with the latest trends, offers, and product launches.</p><p>Thank you for choosing [Your E-Commerce Website] as your go-to shopping destination. We look forward to serving you and providing an exceptional online shopping experience.</p><p>If you have any questions or feedback, please don\'t hesitate to reach out to us at [Contact Email/Phone]. Your voice matters, and we\'re here to listen.</p><p>[Your E-Commerce Website]. Where Quality Meets Convenience.</p>', NULL, '2024-03-08 07:36:22'),
(16, 'sms_nexmo', '{\"status\":\"0\",\"nexmo_key\":\"custo5cc042f7abf4c\",\"nexmo_secret\":\"custo5cc042f7abf4c@ssl\"}', NULL, NULL),
(17, 'company_email', 'info@youngerlifestyle.net', NULL, '2024-03-08 10:26:17'),
(18, 'colors', '{\"primary\":\"#2d2f93\",\"secondary\":\"#2d2f93\",\"primary_light\":\"#CFDFFB\"}', '2020-10-11 13:53:02', '2024-03-08 10:26:17'),
(19, 'company_footer_logo', '2024-03-08-65eabb6c1b6e0.webp', NULL, '2024-03-08 07:17:00'),
(20, 'company_copyright_text', 'All Rights Reserved By Younger Life Style', NULL, '2024-03-08 10:26:17'),
(21, 'download_app_apple_stroe', '{\"status\":\"1\",\"link\":\"https:\\/\\/youngerlifestyle.net\\/app.apk\"}', NULL, '2024-03-08 10:26:17'),
(22, 'download_app_google_stroe', '{\"status\":\"1\",\"link\":\"https:\\/\\/youngerlifestyle.net\\/app.apk\"}', NULL, '2024-03-08 10:26:17'),
(23, 'company_fav_icon', '2024-03-08-65eaae6c19736.webp', '2020-10-11 13:53:02', '2024-03-08 06:21:32'),
(24, 'fcm_topic', '', NULL, NULL),
(25, 'fcm_project_id', '', NULL, NULL),
(26, 'push_notification_key', 'Put your firebase server key here.', NULL, NULL),
(27, 'order_pending_message', '{\"status\":\"1\",\"message\":\"order pen message\"}', NULL, NULL),
(28, 'order_confirmation_msg', '{\"status\":\"1\",\"message\":\"Order con Message\"}', NULL, NULL),
(29, 'order_processing_message', '{\"status\":\"1\",\"message\":\"Order pro Message\"}', NULL, NULL),
(30, 'out_for_delivery_message', '{\"status\":\"1\",\"message\":\"Order ouut Message\"}', NULL, NULL),
(31, 'order_delivered_message', '{\"status\":\"1\",\"message\":\"Order del Message\"}', NULL, NULL),
(32, 'razor_pay', '{\"status\":\"0\",\"razor_key\":null,\"razor_secret\":null}', NULL, '2021-07-06 12:30:14'),
(33, 'sales_commission', '0', NULL, '2024-03-07 04:03:53'),
(34, 'seller_registration', '1', NULL, '2024-03-07 04:03:53'),
(35, 'pnc_language', '[\"en\"]', NULL, NULL),
(36, 'order_returned_message', '{\"status\":\"1\",\"message\":\"Order hh Message\"}', NULL, NULL),
(37, 'order_failed_message', '{\"status\":null,\"message\":\"Order fa Message\"}', NULL, NULL),
(40, 'delivery_boy_assign_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL),
(41, 'delivery_boy_start_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL),
(42, 'delivery_boy_delivered_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL),
(43, 'terms_and_conditions', '', NULL, NULL),
(44, 'minimum_order_value', '1', NULL, NULL),
(45, 'privacy_policy', '<p>my privacy policy</p>\r\n\r\n<p>&nbsp;</p>', NULL, '2021-07-06 11:09:07'),
(46, 'paystack', '{\"status\":\"0\",\"publicKey\":null,\"secretKey\":null,\"paymentUrl\":\"https:\\/\\/api.paystack.co\",\"merchantEmail\":null}', NULL, '2021-07-06 12:30:35'),
(47, 'senang_pay', '{\"status\":\"0\",\"secret_key\":null,\"merchant_id\":null}', NULL, '2021-07-06 12:30:23'),
(48, 'currency_model', 'single_currency', NULL, NULL),
(49, 'social_login', '[{\"login_medium\":\"google\",\"client_id\":\"jjjjj\",\"client_secret\":\"jjjjjjjjj\",\"status\":\"1\"},{\"login_medium\":\"facebook\",\"client_id\":\"jjjjj\",\"client_secret\":\"kkkkkkkk\",\"status\":\"1\"}]', NULL, '2024-03-08 07:37:40'),
(50, 'digital_payment', '{\"status\":0}', NULL, '2024-03-07 04:03:01'),
(51, 'phone_verification', '', NULL, '2024-03-08 10:26:17'),
(52, 'email_verification', '', NULL, '2024-03-08 10:26:17'),
(53, 'order_verification', '0', NULL, '2024-03-07 04:03:37'),
(54, 'country_code', 'BD', NULL, '2024-03-08 10:26:17'),
(55, 'pagination_limit', '10', NULL, '2024-03-08 10:26:17'),
(56, 'shipping_method', 'inhouse_shipping', NULL, NULL),
(57, 'paymob_accept', '{\"status\":\"0\",\"api_key\":\"\",\"iframe_id\":\"\",\"integration_id\":\"\",\"hmac\":\"\"}', NULL, NULL),
(58, 'bkash', '{\"status\":\"0\",\"environment\":\"sandbox\",\"api_key\":\"\",\"api_secret\":\"\",\"username\":\"\",\"password\":\"\"}', NULL, '2023-01-10 05:51:56'),
(59, 'forgot_password_verification', 'email', NULL, '2024-03-08 10:26:17'),
(60, 'paytabs', '{\"status\":0,\"profile_id\":\"\",\"server_key\":\"\",\"base_url\":\"https:\\/\\/secure-egypt.paytabs.com\\/\"}', NULL, '2021-11-21 03:01:40'),
(61, 'stock_limit', '10', NULL, NULL),
(62, 'flutterwave', '{\"status\":0,\"public_key\":\"\",\"secret_key\":\"\",\"hash\":\"\"}', NULL, NULL),
(63, 'mercadopago', '{\"status\":0,\"public_key\":\"\",\"access_token\":\"\"}', NULL, NULL),
(64, 'announcement', '{\"status\":null,\"color\":null,\"text_color\":null,\"announcement\":null}', NULL, NULL),
(65, 'fawry_pay', '{\"status\":0,\"merchant_code\":\"\",\"security_key\":\"\"}', NULL, '2022-01-18 09:46:30'),
(66, 'recaptcha', '{\"status\":0,\"site_key\":\"\",\"secret_key\":\"\"}', NULL, '2022-01-18 09:46:30'),
(67, 'seller_pos', '1', NULL, '2024-03-07 04:03:53'),
(68, 'liqpay', '{\"status\":0,\"public_key\":\"\",\"private_key\":\"\"}', NULL, NULL),
(69, 'paytm', '{\"status\":0,\"environment\":\"sandbox\",\"paytm_merchant_key\":\"\",\"paytm_merchant_mid\":\"\",\"paytm_merchant_website\":\"\",\"paytm_refund_url\":\"\"}', NULL, '2023-01-10 05:51:56'),
(70, 'refund_day_limit', '0', NULL, '2024-03-07 04:03:37'),
(71, 'business_mode', 'single', NULL, '2024-03-08 10:26:17'),
(72, 'mail_config_sendgrid', '{\"status\":0,\"name\":\"\",\"host\":\"\",\"driver\":\"\",\"port\":\"\",\"username\":\"\",\"email_id\":\"\",\"encryption\":\"\",\"password\":\"\"}', NULL, NULL),
(73, 'decimal_point_settings', '2', NULL, '2024-03-08 10:26:17'),
(74, 'shop_address', 'House: Munshi Bari, Beside Nayar Hat High School,Borobari', NULL, '2024-03-08 10:26:17'),
(75, 'billing_input_by_customer', '1', NULL, '2024-03-07 04:03:37'),
(76, 'wallet_status', '1', NULL, '2024-03-07 04:04:11'),
(77, 'loyalty_point_status', '1', NULL, '2024-03-07 04:04:11'),
(78, 'wallet_add_refund', '0', NULL, '2024-03-07 04:04:11'),
(79, 'loyalty_point_exchange_rate', '0', NULL, '2024-03-07 04:04:11'),
(80, 'loyalty_point_item_purchase_point', '0', NULL, '2024-03-07 04:04:11'),
(81, 'loyalty_point_minimum_point', '0', NULL, '2024-03-07 04:04:11'),
(82, 'minimum_order_limit', '1', NULL, NULL),
(83, 'product_brand', '1', NULL, NULL),
(84, 'digital_product', '1', NULL, NULL),
(85, 'delivery_boy_expected_delivery_date_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL),
(86, 'order_canceled', '{\"status\":0,\"message\":\"\"}', NULL, NULL),
(87, 'refund-policy', '{\"status\":1,\"content\":\"\"}', NULL, '2023-03-04 06:25:36'),
(88, 'return-policy', '{\"status\":1,\"content\":\"\"}', NULL, '2023-03-04 06:25:36'),
(89, 'cancellation-policy', '{\"status\":1,\"content\":\"\"}', NULL, '2023-03-04 06:25:36'),
(90, 'offline_payment', '{\"status\":\"1\"}', NULL, '2024-03-07 04:03:01'),
(91, 'temporary_close', '{\"status\":0}', NULL, '2023-03-04 06:25:36'),
(92, 'vacation_add', '{\"status\":0,\"vacation_start_date\":null,\"vacation_end_date\":null,\"vacation_note\":null}', NULL, '2023-03-04 06:25:36'),
(93, 'cookie_setting', '{\"status\":0,\"cookie_text\":null}', NULL, '2023-03-04 06:25:36'),
(94, 'maximum_otp_hit', '0', NULL, '2023-06-13 13:04:49'),
(95, 'otp_resend_time', '0', NULL, '2023-06-13 13:04:49'),
(96, 'temporary_block_time', '0', NULL, '2023-06-13 13:04:49'),
(97, 'maximum_login_hit', '0', NULL, '2023-06-13 13:04:49'),
(98, 'temporary_login_block_time', '0', NULL, '2023-06-13 13:04:49'),
(104, 'apple_login', '[{\"login_medium\":\"apple\",\"client_id\":\"\",\"client_secret\":\"\",\"status\":0,\"team_id\":\"\",\"key_id\":\"\",\"service_file\":\"\",\"redirect_url\":\"\"}]', NULL, '2023-10-13 05:34:53'),
(105, 'ref_earning_status', '1', NULL, '2024-03-07 04:04:11'),
(106, 'ref_earning_exchange_rate', '0', NULL, '2024-03-07 04:04:11'),
(107, 'guest_checkout', '1', NULL, '2024-03-07 04:03:37'),
(108, 'minimum_order_amount', '0', NULL, '2023-10-13 11:34:53'),
(109, 'minimum_order_amount_by_seller', '0', NULL, '2024-03-07 04:03:53'),
(110, 'minimum_order_amount_status', '0', NULL, '2024-03-07 04:03:37'),
(111, 'admin_login_url', 'admin', NULL, '2023-10-13 11:34:53'),
(112, 'employee_login_url', 'employee', NULL, '2023-10-13 11:34:53'),
(113, 'free_delivery_status', '0', NULL, '2024-03-07 04:03:37'),
(114, 'free_delivery_responsibility', 'admin', NULL, '2024-03-07 04:03:37'),
(115, 'free_delivery_over_amount', '0', NULL, '2023-10-13 11:34:53'),
(116, 'free_delivery_over_amount_seller', '0', NULL, '2024-03-07 04:03:37'),
(117, 'add_funds_to_wallet', '0', NULL, '2024-03-07 04:04:11'),
(118, 'minimum_add_fund_amount', '0', NULL, '2023-10-13 11:34:53'),
(119, 'maximum_add_fund_amount', '0', NULL, '2023-10-13 11:34:53'),
(120, 'user_app_version_control', '{\"for_android\":{\"status\":1,\"version\":\"14.1\",\"link\":\"\"},\"for_ios\":{\"status\":1,\"version\":\"14.1\",\"link\":\"\"}}', NULL, '2023-10-13 11:34:53'),
(121, 'seller_app_version_control', '{\"for_android\":{\"status\":1,\"version\":\"14.1\",\"link\":\"\"},\"for_ios\":{\"status\":1,\"version\":\"14.1\",\"link\":\"\"}}', NULL, '2023-10-13 11:34:53'),
(122, 'delivery_man_app_version_control', '{\"for_android\":{\"status\":1,\"version\":\"14.1\",\"link\":\"\"},\"for_ios\":{\"status\":1,\"version\":\"14.1\",\"link\":\"\"}}', NULL, '2023-10-13 11:34:53'),
(123, 'whatsapp', '{\"status\":\"1\",\"phone\":\"8801775457008\"}', NULL, '2024-03-08 07:37:13'),
(124, 'currency_symbol_position', 'left', NULL, '2024-03-08 10:26:17'),
(148, 'company_reliability', '[{\"item\":\"delivery_info\",\"title\":\"Fast Delivery all across the country\",\"image\":\"\",\"status\":1},{\"item\":\"safe_payment\",\"title\":\"Safe Payment\",\"image\":\"\",\"status\":1},{\"item\":\"return_policy\",\"title\":\"7 Days Return Policy\",\"image\":\"\",\"status\":1},{\"item\":\"authentic_product\",\"title\":\"100% Authentic Products\",\"image\":\"\",\"status\":1}]', NULL, NULL),
(149, 'react_setup', '{\"status\":0,\"react_license_code\":\"\",\"react_domain\":\"\",\"react_platform\":\"\"}', NULL, '2024-03-07 09:42:43'),
(150, 'app_activation', '{\"software_id\":\"\",\"is_active\":0}', NULL, '2024-03-07 09:42:43'),
(151, 'shop_banner', '2024-03-08-65eabd33f2554.webp', NULL, '2024-03-08 07:24:35'),
(152, 'timezone', 'UTC', NULL, '2024-03-08 10:26:17'),
(153, 'default_location', '{\"lat\":null,\"lng\":null}', NULL, '2024-03-08 10:26:17'),
(154, 'new_product_approval', '0', NULL, '2024-03-07 04:03:53'),
(155, 'product_wise_shipping_cost_approval', '0', NULL, '2024-03-07 04:03:53'),
(156, 'delivery_country_restriction', '1', NULL, '2024-03-07 04:06:49'),
(157, 'offer_banner', '2024-03-08-65eabd3406f48.webp', NULL, '2024-03-08 07:24:36'),
(158, 'features_section_top', '{\"title\":\"How We Work\",\"subtitle\":\"In the world of e-commerce, our approach is laser-focused on your success. We\'re not just a website; we\'re your dedicated partner. We work tirelessly to ensure your online store thrives, combining innovation, transparency, and a client-centric mindset. Discover how we redefine e-commerce success \\u2013 this is how we work for your online store.\"}', NULL, '2024-03-08 07:33:57'),
(159, 'features_section_middle', '[{\"title\":\"Picking up best product for you\",\"subtitle\":\"\\\"Selecting the Perfect Product: A Comprehensive Guide to Finding Your Ideal Choice\\\"\"},{\"title\":\"Packaging In thge best way for you\",\"subtitle\":\"\\\"Crafting the Ideal Packaging Solution: Tailored to Your Unique Needs and Brand\\\"\"},{\"title\":\"Safe Delivery Process for deliver to you\",\"subtitle\":\"\\\"Ensuring Secure Delivery: Our Proven Process for Safe and Timely Deliveries to Your Doorstep\\\"\"},{\"title\":\"We Deliver The Happiness to you\",\"subtitle\":\"\\\"Delivering Smiles: Our Commitment to Bringing Joy and Happiness Right to Your Doorstep\\\"\"}]', NULL, '2024-03-08 07:33:57'),
(160, 'features_section_bottom', '[{\"title\":\"Free Shipping\",\"subtitle\":\"For all orders over TK1000\",\"icon\":\"2024-03-08-65eabf21890f6.webp\"},{\"title\":\"Replacement Policy\",\"subtitle\":\"7 Days product replacement\",\"icon\":\"2024-03-08-65eabf2189429.webp\"},{\"title\":\"Ensure Quality\",\"subtitle\":\"Best quality product for you\",\"icon\":\"2024-03-08-65eabf2189781.webp\"},{\"title\":\"Discount\",\"subtitle\":\"Amazing coupons for all\",\"icon\":\"2024-03-08-65eabf2189adc.webp\"},{\"title\":\"100% Secure Payment\",\"subtitle\":\"For Cash on delivery, Online & Offline payment\",\"icon\":\"2024-03-08-65eabf2189d75.webp\"},{\"title\":\"Daily Offers\",\"subtitle\":\"Discount up to 60% OFF\",\"icon\":\"2024-03-08-65eabf218a0be.webp\"},{\"title\":\"Coupon\",\"subtitle\":\"Amazing coupons for al\",\"icon\":\"2024-03-08-65eabf218a4b7.webp\"},{\"title\":\"27\\/7 Dedicated Support\",\"subtitle\":\"Anywhere & Anytime\",\"icon\":\"2024-03-08-65eabf654523a.webp\"}]', NULL, '2024-03-08 07:33:57'),
(161, 'map_api_key', 'AIzaSyB6jd8P1T9uo327sCX9jNVwHoqYpPYNPZ8', NULL, '2024-03-08 07:39:47'),
(162, 'map_api_key_server', 'AIzaSyB6jd8P1T9uo327sCX9jNVwHoqYpPYNPZ8', NULL, '2024-03-08 07:39:47');

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

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

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `cart_group_id` varchar(191) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `product_type` varchar(20) NOT NULL DEFAULT 'physical',
  `digital_product_type` varchar(30) DEFAULT NULL,
  `color` varchar(191) DEFAULT NULL,
  `choices` text DEFAULT NULL,
  `variations` text DEFAULT NULL,
  `variant` text DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price` double NOT NULL DEFAULT 1,
  `tax` double NOT NULL DEFAULT 1,
  `discount` double NOT NULL DEFAULT 1,
  `tax_model` varchar(20) NOT NULL DEFAULT 'exclude',
  `slug` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `thumbnail` varchar(191) DEFAULT NULL,
  `seller_id` bigint(20) DEFAULT NULL,
  `seller_is` varchar(191) NOT NULL DEFAULT 'admin',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `shop_info` varchar(191) DEFAULT NULL,
  `shipping_cost` double(8,2) DEFAULT NULL,
  `shipping_type` varchar(191) DEFAULT NULL,
  `is_guest` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `carts` (`id`, `customer_id`, `cart_group_id`, `product_id`, `product_type`, `digital_product_type`, `color`, `choices`, `variations`, `variant`, `quantity`, `price`, `tax`, `discount`, `tax_model`, `slug`, `name`, `thumbnail`, `seller_id`, `seller_is`, `created_at`, `updated_at`, `shop_info`, `shipping_cost`, `shipping_type`, `is_guest`) VALUES
(1, 12, 'guest-Q1JkV-1709887586', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-03-08 08:46:26', '2024-03-08 08:46:26', 'Smart Accessorise Gallery', 0.00, 'order_wise', 1),
(2, 36, 'guest-uQTKl-1709887992', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-03-08 08:53:12', '2024-03-08 08:53:12', 'Younger Life Style', 0.00, 'order_wise', 1),
(3, 79, 'guest-4JAk6-1709888272', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-03-08 08:57:52', '2024-03-08 08:57:52', 'Younger Life Style', 0.00, 'order_wise', 1),
(4, 80, 'guest-V0Fn1-1709888726', 23, 'physical', NULL, NULL, '[]', '[]', '', 2, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-03-08 09:05:26', '2024-03-08 09:18:31', 'Younger Life Style', 0.00, 'order_wise', 1),
(5, 80, 'guest-V0Fn1-1709888726', 24, 'physical', NULL, NULL, '[]', '[]', '', 4, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-03-08 09:05:41', '2024-03-08 09:18:27', 'Younger Life Style', 0.00, 'order_wise', 1),
(6, 112, 'guest-t8JQx-1709894986', 17, 'physical', NULL, '#FFFF00', '[]', '{\"color\":\"Yellow\"}', 'Yellow', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-03-08 10:49:46', '2024-03-08 10:49:46', 'Younger Life Style', 0.00, 'order_wise', 1),
(7, 121, 'guest-AaGTR-1709898855', 17, 'physical', NULL, '#EE82EE', '[]', '{\"color\":\"Violet\"}', 'Violet', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-03-08 11:54:15', '2024-03-08 11:54:15', 'Younger Life Style', 0.00, 'order_wise', 1),
(8, 121, 'guest-AaGTR-1709898855', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-03-08 11:54:45', '2024-03-08 11:54:45', 'Younger Life Style', 0.00, 'order_wise', 1),
(9, 122, 'guest-WaGQW-1709899011', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-03-08 11:56:51', '2024-03-08 11:56:51', 'Younger Life Style', 0.00, 'order_wise', 1),
(10, 285, 'guest-G1f6K-1710353466', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-03-13 18:11:06', '2024-03-13 18:11:06', 'Younger Life Style', 0.00, 'order_wise', 1),
(11, 299, 'guest-BDfZZ-1710422301', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-03-14 13:18:21', '2024-03-14 13:18:21', 'Younger Life Style', 0.00, 'order_wise', 1),
(12, 374, 'guest-Lnd9o-1710750907', 25, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-hp8401-hair-straightener-eS3LWJ', 'Philips HP8401 Hair Straightener', '2024-03-08-65eac7877906a.png', 1, 'admin', '2024-03-18 08:35:07', '2024-03-18 08:35:07', 'Younger Life Style', 0.00, 'order_wise', 1),
(13, 380, 'guest-zJ1LC-1710780892', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-03-18 16:54:52', '2024-03-18 16:54:52', 'Younger Life Style', 0.00, 'order_wise', 1),
(14, 382, 'guest-Ya31X-1710826590', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-03-19 05:36:30', '2024-03-19 05:36:30', 'Younger Life Style', 0.00, 'order_wise', 1),
(15, 382, 'guest-Ya31X-1710826590', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-03-19 05:36:43', '2024-03-19 05:36:43', 'Younger Life Style', 0.00, 'order_wise', 1),
(16, 382, 'guest-Ya31X-1710826590', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-03-19 05:52:03', '2024-03-19 05:52:03', 'Younger Life Style', 0.00, 'order_wise', 1),
(17, 383, 'guest-gsLwT-1710829249', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-03-19 06:20:49', '2024-03-19 06:20:49', 'Younger Life Style', 0.00, 'order_wise', 1),
(18, 440, 'guest-rFt9M-1711371025', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-03-25 12:50:25', '2024-03-25 12:50:25', 'Younger Life Style', 0.00, 'order_wise', 1),
(19, 858, 'guest-KN9Iv-1713105476', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-04-14 14:37:56', '2024-04-14 14:37:56', 'Younger Life Style', 0.00, 'order_wise', 1),
(20, 860, 'guest-nbiYH-1713109778', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-04-14 15:49:38', '2024-04-14 15:49:38', 'Younger Life Style', 0.00, 'order_wise', 1),
(21, 870, 'guest-sdlNd-1713176603', 18, 'physical', NULL, NULL, '[]', '[]', '', 2, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-04-15 10:23:23', '2024-04-15 10:23:40', 'Younger Life Style', 0.00, 'order_wise', 1),
(22, 899, 'guest-PZAvF-1713641900', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-04-20 19:38:20', '2024-04-20 19:38:20', 'Younger Life Style', 0.00, 'order_wise', 1),
(23, 904, 'guest-68c1A-1713664741', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-04-21 01:59:01', '2024-04-21 01:59:01', 'Younger Life Style', 0.00, 'order_wise', 1),
(24, 937, 'guest-Z6YKo-1713771972', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-04-22 07:46:12', '2024-04-22 07:46:12', 'Younger Life Style', 0.00, 'order_wise', 1),
(25, 1016, 'guest-KieQ8-1714213629', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-04-27 10:27:09', '2024-04-27 10:27:09', 'Younger Life Style', 0.00, 'order_wise', 1),
(26, 2295, 'guest-BGqDn-1721137340', 19, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'easy-panjabi-pnI8J8', 'Easy Panjabi', '2024-03-08-65eac3bd726e2.png', 1, 'admin', '2024-07-16 13:42:20', '2024-07-16 13:42:20', 'Younger Life Style', 0.00, 'order_wise', 1),
(27, 2315, 'guest-ScSNg-1721145866', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-07-16 16:04:26', '2024-07-16 16:04:26', 'Younger Life Style', 0.00, 'order_wise', 1),
(30, 4317, 'guest-oS9rr-1722010168', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-07-26 16:09:28', '2024-07-26 16:09:28', 'Younger Life Style', 0.00, 'order_wise', 1),
(31, 4360, 'guest-haAr4-1722030156', 24, 'physical', NULL, NULL, '[]', '[]', '', 2, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-07-26 21:42:36', '2024-07-26 21:42:36', 'Younger Life Style', 0.00, 'order_wise', 1),
(32, 5689, 'guest-iIAHK-1722643808', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-08-03 00:10:08', '2024-08-03 00:10:08', 'Younger Life Style', 0.00, 'order_wise', 1),
(33, 5689, 'guest-iIAHK-1722643808', 17, 'physical', NULL, '#EE82EE', '[]', '{\"color\":\"Violet\"}', 'Violet', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-08-03 00:12:25', '2024-08-03 00:12:25', 'Younger Life Style', 0.00, 'order_wise', 1),
(34, 5772, 'guest-QZLYO-1722682566', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-08-03 10:56:06', '2024-08-03 10:56:06', 'Younger Life Style', 0.00, 'order_wise', 1),
(35, 6695, 'guest-PNBy3-1723155769', 19, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'easy-panjabi-pnI8J8', 'Easy Panjabi', '2024-03-08-65eac3bd726e2.png', 1, 'admin', '2024-08-08 22:22:49', '2024-08-08 22:22:49', 'Younger Life Style', 0.00, 'order_wise', 1),
(36, 6695, 'guest-PNBy3-1723155769', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-08-08 22:23:02', '2024-08-08 22:23:02', 'Younger Life Style', 0.00, 'order_wise', 1),
(37, 7504, 'guest-92Qiv-1723588415', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-08-13 22:33:35', '2024-08-13 22:33:35', 'Younger Life Style', 0.00, 'order_wise', 1),
(38, 7540, 'guest-DSABI-1724138521', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-08-20 07:22:01', '2024-08-20 07:22:01', 'Younger Life Style', 0.00, 'order_wise', 1),
(39, 7559, 'guest-Z7eIN-1724349997', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-08-22 18:06:37', '2024-08-22 18:06:37', 'Younger Life Style', 0.00, 'order_wise', 1),
(40, 7567, 'guest-s8vpl-1724597281', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-08-25 14:48:01', '2024-08-25 14:48:01', 'Younger Life Style', 0.00, 'order_wise', 1),
(41, 7580, 'guest-m6PDO-1724902891', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-08-29 03:41:31', '2024-08-29 03:41:31', 'Younger Life Style', 0.00, 'order_wise', 1),
(42, 7583, 'guest-S1Wnv-1724952282', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-08-29 17:24:42', '2024-08-29 17:24:42', 'Younger Life Style', 0.00, 'order_wise', 1),
(44, 7696, 'guest-QP6SN-1726466165', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-09-16 05:56:05', '2024-09-16 05:56:05', 'Younger Life Style', 0.00, 'order_wise', 1),
(45, 7759, 'guest-MKVQ6-1726691679', 17, 'physical', NULL, '#D2B48C', '[]', '{\"color\":\"Tan\"}', 'Tan', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-09-18 20:34:39', '2024-09-18 20:34:39', 'Younger Life Style', 0.00, 'order_wise', 1),
(46, 7797, 'guest-AcsDU-1727068386', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-09-23 05:13:06', '2024-09-23 05:13:06', 'Younger Life Style', 0.00, 'order_wise', 1),
(47, 7809, 'guest-QfwQU-1727327595', 17, 'physical', NULL, '#EE82EE', '[]', '{\"color\":\"Violet\"}', 'Violet', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-09-26 05:13:15', '2024-09-26 05:13:15', 'Younger Life Style', 0.00, 'order_wise', 1),
(48, 7820, 'guest-2JcHX-1727466150', 26, 'physical', NULL, NULL, '[]', '[]', '', 1, 1250, 0, 0, 'include', 'philips-bt312515-beard-trimmer-series-3000-for-men-GXCUMn', 'Philips BT3125/15 Beard Trimmer Series 3000 for Men', '2024-03-08-65eac7c63ea2b.png', 1, 'admin', '2024-09-27 19:42:30', '2024-09-27 19:42:30', 'Younger Life Style', 0.00, 'order_wise', 1),
(49, 7828, 'guest-Fz8lZ-1727562199', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-09-28 22:23:19', '2024-09-28 22:23:19', 'Younger Life Style', 0.00, 'order_wise', 1),
(50, 7880, 'guest-34GF6-1728519661', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-10-10 00:21:01', '2024-10-10 00:21:01', 'Younger Life Style', 0.00, 'order_wise', 1),
(51, 7890, 'guest-5LBLq-1728670294', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-10-11 18:11:34', '2024-10-11 18:11:34', 'Younger Life Style', 0.00, 'order_wise', 1),
(52, 7890, 'guest-5LBLq-1728670294', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-10-11 18:11:52', '2024-10-11 18:11:52', 'Younger Life Style', 0.00, 'order_wise', 1),
(53, 7894, 'guest-jKeZ6-1728671762', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-10-11 18:36:02', '2024-10-11 18:36:02', 'Younger Life Style', 0.00, 'order_wise', 1),
(54, 7898, 'guest-YrVkd-1728721259', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-10-12 08:20:59', '2024-10-12 08:20:59', 'Younger Life Style', 0.00, 'order_wise', 1),
(55, 7899, 'guest-kRHON-1728721504', 17, 'physical', NULL, '#EE82EE', '[]', '{\"color\":\"Violet\"}', 'Violet', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-10-12 08:25:04', '2024-10-12 08:25:04', 'Younger Life Style', 0.00, 'order_wise', 1),
(56, 7899, 'guest-kRHON-1728721504', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-10-12 08:27:18', '2024-10-12 08:27:18', 'Younger Life Style', 0.00, 'order_wise', 1),
(57, 7917, 'guest-OIbKH-1729098910', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-10-16 17:15:10', '2024-10-16 17:15:10', 'Younger Life Style', 0.00, 'order_wise', 1),
(58, 7946, 'guest-9Ag7U-1729868692', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-10-25 15:04:52', '2024-10-25 15:04:52', 'Younger Life Style', 0.00, 'order_wise', 1),
(59, 7949, 'guest-oZbBb-1729881936', 19, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'easy-panjabi-pnI8J8', 'Easy Panjabi', '2024-03-08-65eac3bd726e2.png', 1, 'admin', '2024-10-25 18:45:36', '2024-10-25 18:45:36', 'Younger Life Style', 0.00, 'order_wise', 1),
(60, 8101, 'guest-WqW5A-1731786648', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-11-16 19:50:48', '2024-11-16 19:50:48', 'Younger Life Style', 0.00, 'order_wise', 1),
(61, 8106, 'guest-E7Lpz-1731814151', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-11-17 03:29:11', '2024-11-17 03:29:11', 'Younger Life Style', 0.00, 'order_wise', 1),
(62, 8138, 'guest-cHr1G-1732167526', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-11-21 05:38:46', '2024-11-21 05:38:46', 'Younger Life Style', 0.00, 'order_wise', 1),
(63, 8203, 'guest-cOvbK-1732725118', 19, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'easy-panjabi-pnI8J8', 'Easy Panjabi', '2024-03-08-65eac3bd726e2.png', 1, 'admin', '2024-11-27 16:31:58', '2024-11-27 16:31:58', 'Younger Life Style', 0.00, 'order_wise', 1),
(64, 8203, 'guest-cOvbK-1732725118', 25, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-hp8401-hair-straightener-eS3LWJ', 'Philips HP8401 Hair Straightener', '2024-03-08-65eac7877906a.png', 1, 'admin', '2024-11-27 16:32:49', '2024-11-27 16:32:49', 'Younger Life Style', 0.00, 'order_wise', 1),
(65, 8210, 'guest-jql0U-1732730028', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-11-27 17:53:48', '2024-11-27 17:53:48', 'Younger Life Style', 0.00, 'order_wise', 1),
(66, 8213, 'guest-BKZJ2-1732738750', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-11-27 20:19:10', '2024-11-27 20:19:10', 'Younger Life Style', 0.00, 'order_wise', 1),
(67, 8218, 'guest-i4Ta9-1732770112', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-11-28 05:01:53', '2024-11-28 05:01:53', 'Younger Life Style', 0.00, 'order_wise', 1),
(68, 8226, 'guest-RKKFi-1732803073', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-11-28 14:11:13', '2024-11-28 14:11:13', 'Younger Life Style', 0.00, 'order_wise', 1),
(69, 8233, 'guest-PfK4N-1732817747', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-11-28 18:15:47', '2024-11-28 18:15:47', 'Younger Life Style', 0.00, 'order_wise', 1),
(70, 8240, 'guest-uQcXW-1732878367', 26, 'physical', NULL, NULL, '[]', '[]', '', 1, 1250, 0, 0, 'include', 'philips-bt312515-beard-trimmer-series-3000-for-men-GXCUMn', 'Philips BT3125/15 Beard Trimmer Series 3000 for Men', '2024-03-08-65eac7c63ea2b.png', 1, 'admin', '2024-11-29 11:06:07', '2024-11-29 11:06:07', 'Younger Life Style', 0.00, 'order_wise', 1),
(71, 8241, 'guest-XoP3R-1732878924', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-11-29 11:15:24', '2024-11-29 11:15:24', 'Younger Life Style', 0.00, 'order_wise', 1),
(72, 8281, 'guest-NYbWH-1733540393', 17, 'physical', NULL, '#FFFF00', '[]', '{\"color\":\"Yellow\"}', 'Yellow', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-06 20:59:53', '2024-12-06 20:59:53', 'Younger Life Style', 0.00, 'order_wise', 1),
(73, 8284, 'guest-PDxHI-1733551031', 25, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-hp8401-hair-straightener-eS3LWJ', 'Philips HP8401 Hair Straightener', '2024-03-08-65eac7877906a.png', 1, 'admin', '2024-12-06 23:57:11', '2024-12-06 23:57:11', 'Younger Life Style', 0.00, 'order_wise', 1),
(74, 8291, 'guest-iEFas-1733556374', 17, 'physical', NULL, '#EE82EE', '[]', '{\"color\":\"Violet\"}', 'Violet', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-07 01:26:14', '2024-12-07 01:26:14', 'Younger Life Style', 0.00, 'order_wise', 1),
(75, 8319, 'guest-OwbFI-1733591050', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-07 11:04:10', '2024-12-07 11:04:10', 'Younger Life Style', 0.00, 'order_wise', 1),
(76, 8323, 'guest-2yypE-1733595897', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-07 12:24:57', '2024-12-07 12:24:57', 'Younger Life Style', 0.00, 'order_wise', 1),
(77, 8370, 'guest-AmcUX-1733828503', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-10 05:01:43', '2024-12-10 05:01:43', 'Younger Life Style', 0.00, 'order_wise', 1),
(78, 8373, 'guest-6bjLm-1733842505', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-10 08:55:05', '2024-12-10 08:55:05', 'Younger Life Style', 0.00, 'order_wise', 1),
(79, 8375, 'guest-SHA42-1733843641', 26, 'physical', NULL, NULL, '[]', '[]', '', 1, 1250, 0, 0, 'include', 'philips-bt312515-beard-trimmer-series-3000-for-men-GXCUMn', 'Philips BT3125/15 Beard Trimmer Series 3000 for Men', '2024-03-08-65eac7c63ea2b.png', 1, 'admin', '2024-12-10 09:14:01', '2024-12-10 09:14:01', 'Younger Life Style', 0.00, 'order_wise', 1),
(81, 8378, 'guest-y1Bbn-1733850167', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-10 11:05:43', '2024-12-10 11:05:43', 'Younger Life Style', 0.00, 'order_wise', 1),
(82, 8434, 'guest-vZ0Ka-1733919581', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-11 06:19:41', '2024-12-11 06:19:41', 'Younger Life Style', 0.00, 'order_wise', 1),
(83, 8453, 'guest-3tuST-1733992198', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-12 02:29:58', '2024-12-12 02:29:58', 'Younger Life Style', 0.00, 'order_wise', 1),
(84, 8453, 'guest-3tuST-1733992198', 26, 'physical', NULL, NULL, '[]', '[]', '', 1, 1250, 0, 0, 'include', 'philips-bt312515-beard-trimmer-series-3000-for-men-GXCUMn', 'Philips BT3125/15 Beard Trimmer Series 3000 for Men', '2024-03-08-65eac7c63ea2b.png', 1, 'admin', '2024-12-12 02:30:06', '2024-12-12 02:30:06', 'Younger Life Style', 0.00, 'order_wise', 1),
(85, 8462, 'guest-Funpn-1734000028', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-12 04:40:28', '2024-12-12 04:40:28', 'Younger Life Style', 0.00, 'order_wise', 1),
(86, 8464, 'guest-Ugo0Q-1734007040', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-12 06:37:20', '2024-12-12 06:37:20', 'Younger Life Style', 0.00, 'order_wise', 1),
(87, 8464, 'guest-Ugo0Q-1734007040', 17, 'physical', NULL, '#D2B48C', '[]', '{\"color\":\"Tan\"}', 'Tan', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-12 06:41:39', '2024-12-12 06:41:39', 'Younger Life Style', 0.00, 'order_wise', 1),
(88, 3, '3-hFnFa-1734016970', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-12 09:22:50', '2024-12-12 09:25:13', 'Younger Life Style', 0.00, 'order_wise', 0),
(93, 8509, 'guest-gdu8S-1734058899', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-12 21:01:39', '2024-12-12 21:01:39', 'Younger Life Style', 0.00, 'order_wise', 1),
(94, 8529, 'guest-iwd9x-1734069128', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-12 23:52:08', '2024-12-12 23:52:08', 'Younger Life Style', 0.00, 'order_wise', 1),
(95, 8549, 'guest-VgYs4-1734080386', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-13 02:59:46', '2024-12-13 02:59:46', 'Younger Life Style', 0.00, 'order_wise', 1),
(96, 8552, 'guest-tOmFp-1734081682', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-13 03:21:22', '2024-12-13 03:21:22', 'Younger Life Style', 0.00, 'order_wise', 1),
(97, 8561, 'guest-oElYK-1734085215', 19, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'easy-panjabi-pnI8J8', 'Easy Panjabi', '2024-03-08-65eac3bd726e2.png', 1, 'admin', '2024-12-13 04:20:15', '2024-12-13 04:20:15', 'Younger Life Style', 0.00, 'order_wise', 1),
(98, 8563, 'guest-gii3w-1734085884', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-13 04:31:24', '2024-12-13 04:31:24', 'Younger Life Style', 0.00, 'order_wise', 1),
(99, 8581, 'guest-eSNr7-1734092819', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-13 06:26:59', '2024-12-13 06:26:59', 'Younger Life Style', 0.00, 'order_wise', 1),
(100, 8586, 'guest-qQVj4-1734097147', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-13 07:39:07', '2024-12-13 07:39:07', 'Younger Life Style', 0.00, 'order_wise', 1),
(101, 8598, 'guest-vBeYW-1734103855', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-13 09:30:55', '2024-12-13 09:30:55', 'Younger Life Style', 0.00, 'order_wise', 1),
(102, 8603, 'guest-wxasS-1734107489', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-13 10:31:29', '2024-12-13 10:31:29', 'Younger Life Style', 0.00, 'order_wise', 1),
(104, 8604, 'guest-FcNFJ-1734107856', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-13 10:37:36', '2024-12-13 10:37:36', 'Younger Life Style', 0.00, 'order_wise', 1),
(105, 8607, 'guest-biXz7-1734108941', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-13 10:55:41', '2024-12-13 10:55:41', 'Younger Life Style', 0.00, 'order_wise', 1),
(109, 8644, 'guest-a9YTd-1734147462', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-13 21:37:42', '2024-12-13 21:37:42', 'Younger Life Style', 0.00, 'order_wise', 1),
(110, 8652, 'guest-Ntedr-1734152674', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-13 23:04:34', '2024-12-13 23:04:34', 'Younger Life Style', 0.00, 'order_wise', 1),
(111, 8662, 'guest-KS8Bz-1734159018', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-14 00:50:18', '2024-12-14 00:50:18', 'Younger Life Style', 0.00, 'order_wise', 1),
(112, 8667, 'guest-ekjF4-1734159352', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-12-14 00:55:52', '2024-12-14 00:55:52', 'Younger Life Style', 0.00, 'order_wise', 1),
(113, 8672, 'guest-yOiGV-1734162804', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-14 01:53:24', '2024-12-14 01:53:24', 'Younger Life Style', 0.00, 'order_wise', 1),
(114, 8680, 'guest-l2uek-1734167196', 24, 'physical', NULL, NULL, '[]', '[]', '', 2, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-14 03:06:36', '2024-12-14 03:06:41', 'Younger Life Style', 0.00, 'order_wise', 1),
(115, 8685, 'guest-UxMMb-1734168002', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-14 03:20:02', '2024-12-14 03:20:02', 'Younger Life Style', 0.00, 'order_wise', 1),
(116, 8687, 'guest-9fOHL-1734170527', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-14 04:02:07', '2024-12-14 04:02:07', 'Younger Life Style', 0.00, 'order_wise', 1),
(117, 8690, 'guest-jcTHa-1734171557', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-14 04:19:17', '2024-12-14 04:19:17', 'Younger Life Style', 0.00, 'order_wise', 1),
(118, 8708, 'guest-ZqLSf-1734180446', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-14 06:47:26', '2024-12-14 06:47:26', 'Younger Life Style', 0.00, 'order_wise', 1),
(119, 8749, 'guest-gP3ZN-1734191416', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-14 09:50:16', '2024-12-14 09:50:16', 'Younger Life Style', 0.00, 'order_wise', 1),
(120, 8751, 'guest-YBcfb-1734193010', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-14 10:16:50', '2024-12-14 10:16:50', 'Younger Life Style', 0.00, 'order_wise', 1),
(122, 8795, 'guest-VQolI-1734227691', 17, 'physical', NULL, '#EE82EE', '[]', '{\"color\":\"Violet\"}', 'Violet', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-14 19:54:51', '2024-12-14 19:54:51', 'Younger Life Style', 0.00, 'order_wise', 1),
(123, 8831, 'guest-Es52B-1734257462', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-15 04:11:02', '2024-12-15 04:11:02', 'Younger Life Style', 0.00, 'order_wise', 1),
(124, 8832, 'guest-60Luq-1734258633', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-15 04:30:33', '2024-12-15 04:30:33', 'Younger Life Style', 0.00, 'order_wise', 1),
(125, 8852, 'guest-mDBNv-1734274511', 22, 'physical', NULL, NULL, '[]', '[]', '', 2, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-15 08:55:11', '2024-12-15 08:56:14', 'Younger Life Style', 0.00, 'order_wise', 1),
(126, 8852, 'guest-mDBNv-1734274511', 19, 'physical', NULL, NULL, '[]', '[]', '', 2, 1200, 0, 0, 'include', 'easy-panjabi-pnI8J8', 'Easy Panjabi', '2024-03-08-65eac3bd726e2.png', 1, 'admin', '2024-12-15 08:56:08', '2024-12-15 08:56:15', 'Younger Life Style', 0.00, 'order_wise', 1),
(128, 8868, 'guest-pMpAz-1734280891', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-12-15 10:41:31', '2024-12-15 10:41:31', 'Younger Life Style', 0.00, 'order_wise', 1),
(129, 8891, 'guest-dQuhz-1734291220', 26, 'physical', NULL, NULL, '[]', '[]', '', 1, 1250, 0, 0, 'include', 'philips-bt312515-beard-trimmer-series-3000-for-men-GXCUMn', 'Philips BT3125/15 Beard Trimmer Series 3000 for Men', '2024-03-08-65eac7c63ea2b.png', 1, 'admin', '2024-12-15 13:33:40', '2024-12-15 13:33:40', 'Younger Life Style', 0.00, 'order_wise', 1),
(130, 8907, 'guest-ixXFn-1734322630', 20, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-12-15 22:17:10', '2024-12-15 22:17:10', 'Younger Life Style', 0.00, 'order_wise', 1),
(131, 8941, 'guest-4leLM-1734355009', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-16 07:16:49', '2024-12-16 07:16:49', 'Younger Life Style', 0.00, 'order_wise', 1),
(132, 8944, 'guest-0KJSw-1734356143', 23, 'physical', NULL, NULL, '[]', '[]', '', 2, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-16 07:35:43', '2024-12-16 07:35:43', 'Younger Life Style', 0.00, 'order_wise', 1),
(133, 8947, 'guest-VkTCe-1734357550', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-16 07:59:10', '2024-12-16 07:59:10', 'Younger Life Style', 0.00, 'order_wise', 1),
(134, 8976, 'guest-JZOT1-1734368784', 23, 'physical', NULL, NULL, '[]', '[]', '', 2, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-16 11:06:24', '2024-12-16 11:06:37', 'Younger Life Style', 0.00, 'order_wise', 1),
(135, 9004, 'guest-lf3xN-1734404601', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-16 21:03:21', '2024-12-16 21:03:21', 'Younger Life Style', 0.00, 'order_wise', 1),
(136, 9004, 'guest-lf3xN-1734404601', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-16 21:03:36', '2024-12-16 21:03:36', 'Younger Life Style', 0.00, 'order_wise', 1),
(137, 9029, 'guest-N3z2i-1734420354', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-17 01:25:54', '2024-12-17 01:25:54', 'Younger Life Style', 0.00, 'order_wise', 1),
(138, 9029, 'guest-N3z2i-1734420354', 20, 'physical', NULL, NULL, '[]', '[]', '', 11, 1200, 0, 0, 'include', 'full-sleeve-classic-fit-shirt-TTAVaK', 'Full Sleeve Classic Fit Shirt', '2024-03-08-65eac451baf41.png', 1, 'admin', '2024-12-17 01:26:08', '2024-12-17 01:26:15', 'Younger Life Style', 0.00, 'order_wise', 1),
(139, 9039, 'guest-lgKjf-1734428163', 17, 'physical', NULL, '#9ACD32', '[]', '{\"color\":\"YellowGreen\"}', 'YellowGreen', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-17 03:36:03', '2024-12-17 03:36:03', 'Younger Life Style', 0.00, 'order_wise', 1),
(140, 9043, 'guest-Sne9M-1734429949', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-17 04:05:49', '2024-12-17 04:05:49', 'Younger Life Style', 0.00, 'order_wise', 1),
(141, 9046, 'guest-PCVc3-1734434118', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-17 05:15:18', '2024-12-17 05:15:18', 'Younger Life Style', 0.00, 'order_wise', 1),
(142, 9064, 'guest-oX7tX-1734445828', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-17 08:30:28', '2024-12-17 08:30:28', 'Younger Life Style', 0.00, 'order_wise', 1),
(143, 9068, 'guest-58O2P-1734450057', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-17 09:40:57', '2024-12-17 09:40:57', 'Younger Life Style', 0.00, 'order_wise', 1),
(144, 9088, 'guest-z6U31-1734462518', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-17 13:08:38', '2024-12-17 13:08:38', 'Younger Life Style', 0.00, 'order_wise', 1),
(145, 9101, 'guest-wAB9i-1734494271', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-17 21:57:51', '2024-12-17 21:57:51', 'Younger Life Style', 0.00, 'order_wise', 1),
(146, 9108, 'guest-Tk7St-1734500079', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-17 23:34:39', '2024-12-17 23:34:39', 'Younger Life Style', 0.00, 'order_wise', 1),
(147, 9108, 'guest-Tk7St-1734500079', 21, 'physical', NULL, NULL, '[]', '[]', '', 1, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-17 23:34:42', '2024-12-17 23:34:42', 'Younger Life Style', 0.00, 'order_wise', 1),
(148, 9109, 'guest-UJklu-1734500326', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-17 23:38:46', '2024-12-17 23:38:46', 'Younger Life Style', 0.00, 'order_wise', 1),
(149, 9124, 'guest-1mf30-1734508064', 24, 'physical', NULL, NULL, '[]', '[]', '', 4, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-18 01:47:44', '2024-12-18 01:48:34', 'Younger Life Style', 0.00, 'order_wise', 1),
(150, 9143, 'guest-JhJ54-1734527416', 26, 'physical', NULL, NULL, '[]', '[]', '', 1, 1250, 0, 0, 'include', 'philips-bt312515-beard-trimmer-series-3000-for-men-GXCUMn', 'Philips BT3125/15 Beard Trimmer Series 3000 for Men', '2024-03-08-65eac7c63ea2b.png', 1, 'admin', '2024-12-18 07:10:16', '2024-12-18 07:10:16', 'Younger Life Style', 0.00, 'order_wise', 1),
(151, 9163, 'guest-74K7t-1734547194', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-18 12:39:54', '2024-12-18 12:39:54', 'Younger Life Style', 0.00, 'order_wise', 1),
(152, 9169, 'guest-keJEO-1734553769', 24, 'physical', NULL, NULL, '[]', '[]', '', 1, 1200, 0, 0, 'include', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'PHILIPS BHH811 Hair Straightener/Hair Curler', '2024-03-08-65eac727d0e15.png', 1, 'admin', '2024-12-18 14:29:29', '2024-12-18 14:29:29', 'Younger Life Style', 0.00, 'order_wise', 1),
(153, 9189, 'guest-Hl9Nc-1734584523', 18, 'physical', NULL, NULL, '[]', '[]', '', 5, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-18 23:02:03', '2024-12-18 23:02:10', 'Younger Life Style', 0.00, 'order_wise', 1),
(154, 9205, 'guest-vRbgP-1734610559', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-19 06:15:59', '2024-12-19 06:15:59', 'Younger Life Style', 0.00, 'order_wise', 1),
(155, 9324, 'guest-zJwFL-1734709342', 23, 'physical', NULL, NULL, '[]', '[]', '', 1, 1000, 0, 0, 'include', 'womens-party-wear-DyGSz3', 'WOMENS PARTY WEAR', '2024-03-08-65eac67b03cdb.png', 1, 'admin', '2024-12-20 09:42:22', '2024-12-20 09:42:22', 'Younger Life Style', 0.00, 'order_wise', 1),
(157, 9455, 'guest-PP8kM-1734853332', 17, 'physical', NULL, '#EE82EE', '[]', '{\"color\":\"Violet\"}', 'Violet', 1, 550, 0, 20, 'include', 'polo-t-shirt-WoxkEf', 'Polo T-Shirt', '2024-03-08-65eac27817ed5.png', 1, 'admin', '2024-12-22 01:42:50', '2024-12-22 01:42:50', 'Younger Life Style', 0.00, 'order_wise', 1),
(158, 9538, 'guest-OvK6A-1734934268', 18, 'physical', NULL, NULL, '[]', '[]', '', 1, 550, 0, 0, 'include', 'boys-panjabi-chWohB', 'Boys Panjabi', '2024-03-08-65eac3381290e.png', 1, 'admin', '2024-12-23 00:11:08', '2024-12-23 00:11:08', 'Younger Life Style', 0.00, 'order_wise', 1),
(159, 9546, 'guest-2nXQj-1734941332', 22, 'physical', NULL, NULL, '[]', '[]', '', 1, 100, 0, 0, 'include', 'womens-ethnic-3pcs-uY6Osy', 'WOMENS ETHNIC 3PCS', '2024-03-08-65eac5ed3b4e4.png', 1, 'admin', '2024-12-23 02:08:52', '2024-12-23 02:08:52', 'Younger Life Style', 0.00, 'order_wise', 1),
(160, 9558, 'guest-hGa7Q-1734948804', 21, 'physical', NULL, NULL, '[]', '[]', '', 2, 1400, 0, 0, 'include', 'womens-fashion-tops-OZNuhZ', 'WOMENS FASHION TOPS', '2024-03-08-65eac53e84485.png', 1, 'admin', '2024-12-23 04:13:24', '2024-12-23 04:13:30', 'Younger Life Style', 0.00, 'order_wise', 1);

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

--
-- Table structure for table `cart_shippings`
--

CREATE TABLE `cart_shippings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cart_group_id` varchar(191) DEFAULT NULL,
  `shipping_method_id` bigint(20) DEFAULT NULL,
  `shipping_cost` double(8,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_shippings`
--

INSERT INTO `cart_shippings` (`id`, `cart_group_id`, `shipping_method_id`, `shipping_cost`, `created_at`, `updated_at`) VALUES
(1, 'guest-Q1JkV-1709887586', 2, 60.00, '2024-03-08 08:47:11', '2024-03-08 08:47:11'),
(2, 'guest-4JAk6-1709888272', 10, 60.00, '2024-03-08 08:58:18', '2024-03-08 08:58:18'),
(3, 'guest-V0Fn1-1709888726', 2, 60.00, '2024-03-08 09:17:26', '2024-03-08 09:17:26'),
(4, 'guest-WaGQW-1709899011', 2, 60.00, '2024-03-08 11:56:59', '2024-03-08 11:56:59'),
(5, 'guest-G1f6K-1710353466', 2, 60.00, '2024-03-13 18:12:48', '2024-03-13 18:12:48'),
(6, 'guest-BDfZZ-1710422301', 9, 60.00, '2024-03-14 13:18:44', '2024-03-14 13:18:44'),
(7, 'guest-Lnd9o-1710750907', 2, 60.00, '2024-03-18 08:35:43', '2024-03-18 08:35:48'),
(8, 'guest-zJ1LC-1710780892', 2, 60.00, '2024-03-18 16:55:13', '2024-03-18 16:55:13'),
(9, 'guest-Ya31X-1710826590', 2, 60.00, '2024-03-19 05:38:21', '2024-03-19 05:38:21'),
(10, 'guest-gsLwT-1710829249', 2, 60.00, '2024-03-19 06:21:34', '2024-03-19 06:21:34'),
(11, 'guest-KN9Iv-1713105476', 2, 60.00, '2024-04-14 14:38:06', '2024-04-14 14:38:06'),
(12, 'guest-nbiYH-1713109778', 9, 60.00, '2024-04-14 15:49:43', '2024-04-14 15:49:43'),
(13, 'guest-sdlNd-1713176603', 10, 60.00, '2024-04-15 10:24:33', '2024-04-15 10:24:33'),
(14, 'guest-68c1A-1713664741', 2, 60.00, '2024-04-21 01:59:29', '2024-04-21 01:59:29'),
(15, 'guest-KieQ8-1714213629', 2, 60.00, '2024-04-27 10:27:41', '2024-04-27 10:27:41'),
(16, 'guest-ScSNg-1721145866', 11, 150.00, '2024-07-16 16:04:45', '2024-07-16 16:04:45'),
(17, 'guest-Qakh2-1722009833', 9, 60.00, '2024-07-26 16:04:16', '2024-07-26 16:04:16'),
(18, 'guest-iIAHK-1722643808', 2, 60.00, '2024-08-03 00:12:45', '2024-08-03 00:12:45'),
(19, 'guest-PNBy3-1723155769', 9, 60.00, '2024-08-08 22:23:11', '2024-08-08 22:23:11'),
(20, 'guest-DSABI-1724138521', 10, 60.00, '2024-08-20 07:22:28', '2024-08-20 07:22:36'),
(21, 'guest-Z7eIN-1724349997', 2, 60.00, '2024-08-22 18:06:59', '2024-08-22 18:06:59'),
(22, 'guest-s8vpl-1724597281', 11, 150.00, '2024-08-25 14:48:18', '2024-08-25 14:48:18'),
(23, 'guest-m6PDO-1724902891', 2, 60.00, '2024-08-29 03:41:48', '2024-08-29 03:41:48'),
(24, 'guest-S1Wnv-1724952282', 9, 60.00, '2024-08-29 17:24:50', '2024-08-29 17:24:50'),
(25, 'guest-a26dP-1725254216', 2, 60.00, '2024-09-02 05:17:02', '2024-09-02 05:17:02'),
(26, 'guest-QfwQU-1727327595', 2, 60.00, '2024-09-26 05:13:30', '2024-09-26 05:13:30'),
(27, 'guest-2JcHX-1727466150', 2, 60.00, '2024-09-27 19:43:02', '2024-09-27 19:43:02'),
(28, 'guest-Fz8lZ-1727562199', 10, 60.00, '2024-09-28 22:23:31', '2024-09-28 22:23:31'),
(29, 'guest-34GF6-1728519661', 2, 60.00, '2024-10-10 00:21:37', '2024-10-10 00:21:37'),
(30, 'guest-5LBLq-1728670294', 12, 150.00, '2024-10-11 18:12:46', '2024-10-11 18:12:46'),
(31, 'guest-YrVkd-1728721259', 2, 60.00, '2024-10-12 08:21:12', '2024-10-12 08:21:12'),
(32, 'guest-OIbKH-1729098910', 2, 60.00, '2024-10-16 17:15:20', '2024-10-16 17:15:20'),
(33, 'guest-9Ag7U-1729868692', 2, 60.00, '2024-10-25 15:05:01', '2024-10-25 15:05:01'),
(34, 'guest-oZbBb-1729881936', 2, 60.00, '2024-10-25 18:46:02', '2024-10-25 18:46:02'),
(35, 'guest-WqW5A-1731786648', 2, 60.00, '2024-11-16 19:51:28', '2024-11-16 19:51:28'),
(36, 'guest-E7Lpz-1731814151', 10, 60.00, '2024-11-17 03:29:40', '2024-11-17 03:29:40'),
(37, 'guest-cHr1G-1732167526', 2, 60.00, '2024-11-21 05:38:56', '2024-11-21 05:38:56'),
(38, 'guest-cOvbK-1732725118', 10, 60.00, '2024-11-27 16:33:11', '2024-11-27 16:33:11'),
(39, 'guest-BKZJ2-1732738750', 12, 150.00, '2024-11-27 20:19:56', '2024-11-27 20:20:11'),
(40, 'guest-i4Ta9-1732770112', 2, 60.00, '2024-11-28 05:02:38', '2024-11-28 05:02:38'),
(41, 'guest-RKKFi-1732803073', 9, 60.00, '2024-11-28 14:12:05', '2024-11-28 14:12:05'),
(42, 'guest-PfK4N-1732817747', 11, 150.00, '2024-11-28 18:16:03', '2024-11-28 18:16:03'),
(43, 'guest-uQcXW-1732878367', 11, 150.00, '2024-11-29 11:06:40', '2024-11-29 11:06:40'),
(44, 'guest-NYbWH-1733540393', 9, 60.00, '2024-12-06 21:00:06', '2024-12-06 21:00:06'),
(45, 'guest-PDxHI-1733551031', 10, 60.00, '2024-12-06 23:57:25', '2024-12-06 23:57:25'),
(46, 'guest-iEFas-1733556374', 11, 150.00, '2024-12-07 01:26:28', '2024-12-07 01:26:28'),
(47, 'guest-AmcUX-1733828503', 9, 60.00, '2024-12-10 05:01:49', '2024-12-10 05:01:49'),
(48, 'guest-SHA42-1733843641', 11, 150.00, '2024-12-10 09:14:31', '2024-12-10 09:14:31'),
(49, 'guest-y1Bbn-1733850167', 13, 120.00, '2024-12-10 11:02:57', '2024-12-10 11:02:57'),
(50, 'guest-vZ0Ka-1733919581', 10, 60.00, '2024-12-11 06:19:46', '2024-12-11 06:19:46'),
(51, 'guest-Ugo0Q-1734007040', 2, 60.00, '2024-12-12 06:37:38', '2024-12-12 06:37:38'),
(52, 'guest-hFnFa-1734016970', 10, 60.00, '2024-12-12 09:23:05', '2024-12-12 09:23:05'),
(53, '3-hFnFa-1734016970', 2, 60.00, '2024-12-12 09:26:14', '2024-12-12 09:26:14'),
(54, 'guest-iwd9x-1734069128', 2, 60.00, '2024-12-12 23:52:18', '2024-12-12 23:52:18'),
(55, 'guest-VgYs4-1734080386', 2, 60.00, '2024-12-13 02:59:59', '2024-12-13 02:59:59'),
(56, 'guest-tOmFp-1734081682', 2, 60.00, '2024-12-13 03:21:33', '2024-12-13 03:21:33'),
(57, 'guest-eSNr7-1734092819', 10, 60.00, '2024-12-13 06:27:36', '2024-12-13 06:27:36'),
(58, 'guest-qQVj4-1734097147', 2, 60.00, '2024-12-13 07:39:11', '2024-12-13 07:39:11'),
(59, 'guest-vBeYW-1734103855', 2, 60.00, '2024-12-13 09:31:10', '2024-12-13 09:31:10'),
(60, 'guest-FcNFJ-1734107856', 9, 60.00, '2024-12-13 10:37:49', '2024-12-13 10:37:49'),
(61, 'guest-biXz7-1734108941', 13, 120.00, '2024-12-13 10:56:03', '2024-12-13 10:56:03'),
(62, 'guest-s07mm-1734109825', 2, 60.00, '2024-12-13 11:10:31', '2024-12-13 11:10:31'),
(63, 'guest-Ntedr-1734152674', 2, 60.00, '2024-12-13 23:04:39', '2024-12-13 23:04:39'),
(64, 'guest-KS8Bz-1734159018', 9, 60.00, '2024-12-14 00:50:24', '2024-12-14 00:50:24'),
(65, 'guest-yOiGV-1734162804', 2, 60.00, '2024-12-14 01:53:32', '2024-12-14 01:53:32'),
(66, 'guest-UxMMb-1734168002', 10, 60.00, '2024-12-14 03:20:16', '2024-12-14 03:20:16'),
(67, 'guest-9fOHL-1734170527', 2, 60.00, '2024-12-14 04:02:14', '2024-12-14 04:02:14'),
(68, 'guest-jcTHa-1734171557', 11, 150.00, '2024-12-14 04:19:26', '2024-12-14 04:19:29'),
(69, 'guest-gP3ZN-1734191416', 9, 60.00, '2024-12-14 09:50:24', '2024-12-14 09:50:24'),
(70, 'guest-YBcfb-1734193010', 9, 60.00, '2024-12-14 10:17:18', '2024-12-14 10:17:18'),
(71, 'guest-VXr5r-1734202475', 10, 60.00, '2024-12-14 12:55:43', '2024-12-14 12:55:52'),
(72, 'guest-Es52B-1734257462', 11, 150.00, '2024-12-15 04:11:22', '2024-12-15 04:11:22'),
(73, 'guest-60Luq-1734258633', 2, 60.00, '2024-12-15 04:30:37', '2024-12-15 04:30:37'),
(74, 'guest-mDBNv-1734274511', 9, 60.00, '2024-12-15 09:18:36', '2024-12-15 09:18:36'),
(75, 'guest-VkTCe-1734357550', 9, 60.00, '2024-12-16 07:59:37', '2024-12-16 07:59:37'),
(76, 'guest-JZOT1-1734368784', 9, 60.00, '2024-12-16 11:06:44', '2024-12-16 11:06:44'),
(77, 'guest-lgKjf-1734428163', 2, 60.00, '2024-12-17 03:36:07', '2024-12-17 03:36:07'),
(78, 'guest-Sne9M-1734429949', 9, 60.00, '2024-12-17 04:06:06', '2024-12-17 04:06:06'),
(79, 'guest-PCVc3-1734434118', 2, 60.00, '2024-12-17 05:15:26', '2024-12-17 05:15:26'),
(80, 'guest-oX7tX-1734445828', 9, 60.00, '2024-12-17 08:30:37', '2024-12-17 08:30:37'),
(81, 'guest-z6U31-1734462518', 2, 60.00, '2024-12-17 13:09:25', '2024-12-17 13:09:25'),
(82, 'guest-wAB9i-1734494271', 2, 60.00, '2024-12-17 21:57:55', '2024-12-17 21:57:55'),
(83, 'guest-UJklu-1734500326', 2, 60.00, '2024-12-17 23:38:51', '2024-12-17 23:38:51'),
(84, 'guest-1mf30-1734508064', 2, 60.00, '2024-12-18 01:48:40', '2024-12-18 01:48:40'),
(85, 'guest-JhJ54-1734527416', 13, 120.00, '2024-12-18 07:10:26', '2024-12-18 07:10:26'),
(86, 'guest-Hl9Nc-1734584523', 9, 60.00, '2024-12-18 23:02:21', '2024-12-18 23:02:21'),
(87, 'guest-vRbgP-1734610559', 12, 150.00, '2024-12-19 06:16:20', '2024-12-19 06:16:25'),
(88, 'guest-PP8kM-1734853332', 10, 60.00, '2024-12-22 01:42:34', '2024-12-22 01:42:34'),
(89, 'guest-OvK6A-1734934268', 2, 60.00, '2024-12-23 00:11:15', '2024-12-23 00:11:15'),
(90, 'guest-2nXQj-1734941332', 13, 120.00, '2024-12-23 02:09:06', '2024-12-23 02:09:06'),
(91, 'guest-hGa7Q-1734948804', 13, 120.00, '2024-12-23 04:13:33', '2024-12-23 04:13:37');

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `icon` varchar(250) DEFAULT NULL,
  `parent_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `home_status` tinyint(1) NOT NULL DEFAULT 0,
  `priority` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `slug`, `icon`, `parent_id`, `position`, `created_at`, `updated_at`, `home_status`, `priority`) VALUES
(14, 'Clothing & Fashion', 'clothing-fashion', '2024-03-08-65eaafafab4ea.webp', 0, 0, '2024-03-08 06:26:55', '2024-03-08 06:27:03', 1, 1),
(15, 'Footwear', 'footwear', '2024-03-08-65eab005bcc16.webp', 0, 0, '2024-03-08 06:28:21', '2024-03-08 06:28:30', 1, 2),
(16, 'Fashion Accessories', 'fashion-accessories', '2024-03-08-65eab073d5c7f.webp', 0, 0, '2024-03-08 06:30:11', '2024-03-08 06:30:20', 1, 3),
(17, 'Lifestyle Accessories', 'lifestyle-accessories', '2024-03-08-65eab0fc3bde4.webp', 0, 0, '2024-03-08 06:32:28', '2024-03-08 06:32:37', 1, 4),
(18, 'Personal Care', 'personal-care', '2024-03-08-65eab13916c2c.webp', 0, 0, '2024-03-08 06:33:29', '2024-03-08 06:33:36', 1, 5),
(19, 'Home Decor', 'home-decor', '2024-03-08-65eab1a464edb.webp', 0, 0, '2024-03-08 06:35:16', '2024-03-08 06:35:24', 1, 6),
(20, 'Handicrafts Appliance', 'handicrafts-appliance', '2024-03-08-65eab21fb5e01.webp', 0, 0, '2024-03-08 06:37:19', '2024-03-08 06:37:36', 1, 7),
(21, 'Gift Cards Appliance', 'gift-cards-appliance', '2024-03-08-65eab2c9d9e53.webp', 0, 0, '2024-03-08 06:40:09', '2024-03-08 06:40:16', 1, 8),
(22, 'Eid-Ul-Fitr \'24', 'eid-ul-fitr-24', '2024-03-08-65eab35702c95.webp', 0, 0, '2024-03-08 06:42:31', '2024-03-08 06:42:38', 1, 9),
(23, 'Mens Fashion', 'mens-fashion', 'def.png', 14, 1, '2024-03-08 06:44:09', '2024-03-08 06:44:09', 0, 1),
(24, 'Womens Fashion', 'womens-fashion', 'def.png', 14, 1, '2024-03-08 06:44:21', '2024-03-08 06:44:21', 0, 2),
(25, 'Kids Winter Collection', 'kids-winter-collection', 'def.png', 14, 1, '2024-03-08 06:44:34', '2024-03-08 06:44:34', 0, 3),
(26, 'Mens Top Wear', 'mens-top-wear', 'def.png', 23, 2, '2024-03-08 06:45:54', '2024-03-08 06:45:54', 0, 1),
(27, 'Mens Bottom Wear', 'mens-bottom-wear', 'def.png', 23, 2, '2024-03-08 06:46:15', '2024-03-08 06:46:15', 0, 2),
(28, 'Mens Sports Wear', 'mens-sports-wear', 'def.png', 23, 2, '2024-03-08 06:46:35', '2024-03-08 06:46:35', 0, 3),
(29, 'Mens Innerwear & Sleepwear', 'mens-innerwear-sleepwear', 'def.png', 23, 2, '2024-03-08 06:46:54', '2024-03-08 06:46:54', 0, 4),
(30, 'Womens Top Wear', 'womens-top-wear', 'def.png', 24, 2, '2024-03-08 06:47:40', '2024-03-08 06:47:40', 0, 1),
(31, 'Womens Bottom Wear', 'womens-bottom-wear', 'def.png', 24, 2, '2024-03-08 06:48:00', '2024-03-08 06:48:00', 0, 2),
(32, 'Womens Modest Wear', 'womens-modest-wear', 'def.png', 24, 2, '2024-03-08 06:48:27', '2024-03-08 06:48:27', 0, 3),
(33, 'Womens Western Set', 'womens-western-set', 'def.png', 24, 2, '2024-03-08 06:48:47', '2024-03-08 06:48:47', 0, 4),
(34, 'Womens Innerwear & Sleepwear', 'womens-innerwear-sleepwear', 'def.png', 24, 2, '2024-03-08 06:49:06', '2024-03-08 06:49:06', 0, 6),
(35, 'New Born 3 to 18 (Month)', 'new-born-3-to-18-month', 'def.png', 25, 2, '2024-03-08 06:51:04', '2024-03-08 06:51:04', 0, 1),
(36, 'Baby boys (2-7Y)', 'baby-boys-2-7y', 'def.png', 25, 2, '2024-03-08 06:51:22', '2024-03-08 06:51:22', 0, 2),
(37, 'Baby Girls (2-7Y)', 'baby-girls-2-7y', 'def.png', 25, 2, '2024-03-08 06:51:39', '2024-03-08 06:51:39', 0, 3),
(38, 'Boys (8-15Y) Girls (8-15Y)', 'boys-8-15y-girls-8-15y', 'def.png', 25, 2, '2024-03-08 06:51:55', '2024-03-08 06:51:55', 0, 5);

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

--
-- Table structure for table `category_shipping_costs`
--

CREATE TABLE `category_shipping_costs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED DEFAULT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `cost` double(8,2) DEFAULT NULL,
  `multiply_qty` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_shipping_costs`
--

INSERT INTO `category_shipping_costs` (`id`, `seller_id`, `category_id`, `cost`, `multiply_qty`, `created_at`, `updated_at`) VALUES
(1, 0, 14, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(2, 0, 15, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(3, 0, 16, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(4, 0, 17, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(5, 0, 18, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(6, 0, 19, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(7, 0, 20, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(8, 0, 21, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29'),
(9, 0, 22, 0.00, NULL, '2024-03-08 11:51:29', '2024-03-08 11:51:29');

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

--
-- Table structure for table `chattings`
--

CREATE TABLE `chattings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `seller_id` bigint(20) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `delivery_man_id` bigint(20) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `attachment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachment`)),
  `sent_by_customer` tinyint(1) NOT NULL DEFAULT 0,
  `sent_by_seller` tinyint(1) NOT NULL DEFAULT 0,
  `sent_by_admin` tinyint(1) DEFAULT NULL,
  `sent_by_delivery_man` tinyint(1) DEFAULT NULL,
  `seen_by_customer` tinyint(1) NOT NULL DEFAULT 1,
  `seen_by_seller` tinyint(1) NOT NULL DEFAULT 1,
  `seen_by_admin` tinyint(1) DEFAULT NULL,
  `seen_by_delivery_man` tinyint(1) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `shop_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `colors` (
  `id` int(11) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB 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'),
(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'),
(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'),
(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'),
(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 `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `mobile_number` varchar(191) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `message` text NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT 0,
  `feedback` varchar(191) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `reply` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `mobile_number`, `subject`, `message`, `seen`, `feedback`, `created_at`, `updated_at`, `reply`) VALUES
(1, 'Winston', 'redfordwinston54@gmail.com', 'redfordwinston54@gmail.com', 'We should probably talk', 'Winston here from Iowa. I\'m always watching to see what newer sites are going up and I just wanted to see if you would like an extra hand with getting some targeted traffic, create videos/images/adcopy, remove negative listings, the list goes on.  I\'ll even shoulder 90% of the costs, dedicating my time and tools that I\'ve created myself and bought over the years.  I\'ve been doing this for over 22 years, helped thousands of people and have loved every minute of it.\r\n\r\nThere\'s virtually no cost on my end to do any of this for you except for my time starting at 99 a month. I don\'t mean to impose; I was just curious if I could lend a hand.  \r\n\r\nBrief history, I\'ve been working from home for a couple decades now and I love helping others.  I\'m married, have three girls and if I can provide for them by helping you and giving back by using the tools and knowledge I\'ve built and learned over the years, I can\'t think of a better win-win.\r\n\r\nIt amazes me that no one else is helping others quite like I do and I\'d love to show you how I can help out.  So, if you need any extra help in any way, please let me know either way as I value your time and don\'t want to pester you.\r\n\r\nPS – If I didn’t mention something you might need help with just ask, I only mentioned a handful of things to keep this brief :-)\r\n\r\n\r\nAll the best,\r\n\r\nWinston\r\nCell - 1-319-435-1790‬\r\nMy Site (w/Live Chat) - https://cutt.ly/9wEWIZbQ', 0, '0', '2024-03-08 08:33:29', '2024-03-08 08:33:29', NULL);

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

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

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `symbol` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `exchange_rate` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `currencies` (`id`, `name`, `symbol`, `code`, `exchange_rate`, `status`, `created_at`, `updated_at`) VALUES
(1, 'USD', '$', 'USD', '1', 1, NULL, '2021-06-27 13:39:37'),
(2, 'BDT', '৳', 'BDT', '84', 1, NULL, '2021-07-06 11:52:58'),
(3, 'Indian Rupi', '₹', 'INR', '60', 1, '2020-10-15 17:23:04', '2021-06-04 18:26:38'),
(4, 'Euro', '€', 'EUR', '100', 1, '2021-05-25 21:00:23', '2021-06-04 18:25:29'),
(5, 'YEN', '¥', 'JPY', '110', 1, '2021-06-10 22:08:31', '2021-06-26 14:21:10'),
(6, 'Ringgit', 'RM', 'MYR', '4.16', 1, '2021-07-03 11:08:33', '2021-07-03 11:10:37'),
(7, 'Rand', 'R', 'ZAR', '14.26', 1, '2021-07-03 11:12:38', '2021-07-03 11:12:42');

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

--
-- Table structure for table `customer_wallets`
--

CREATE TABLE `customer_wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `balance` decimal(8,2) NOT NULL DEFAULT 0.00,
  `royality_points` decimal(8,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customer_wallet_histories`
--

CREATE TABLE `customer_wallet_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `transaction_amount` decimal(8,2) NOT NULL DEFAULT 0.00,
  `transaction_type` varchar(20) DEFAULT NULL,
  `transaction_method` varchar(30) DEFAULT NULL,
  `transaction_id` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deal_of_the_days`
--

CREATE TABLE `deal_of_the_days` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(150) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `discount` decimal(8,2) NOT NULL DEFAULT 0.00,
  `discount_type` varchar(12) NOT NULL DEFAULT 'amount',
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deal_of_the_days`
--

INSERT INTO `deal_of_the_days` (`id`, `title`, `product_id`, `discount`, `discount_type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Deals of The Day', 17, 20.00, 'flat', 0, '2024-03-08 08:13:02', '2024-03-08 08:13:35'),
(2, 'Deals of The Day', 18, 0.00, 'flat', 1, '2024-03-08 08:13:29', '2024-03-08 08:13:35');

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

--
-- Table structure for table `deliveryman_notifications`
--

CREATE TABLE `deliveryman_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `delivery_man_id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `description` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deliveryman_wallets`
--

CREATE TABLE `deliveryman_wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `delivery_man_id` bigint(20) NOT NULL,
  `current_balance` decimal(50,2) NOT NULL DEFAULT 0.00,
  `cash_in_hand` decimal(50,2) NOT NULL DEFAULT 0.00,
  `pending_withdraw` decimal(50,2) NOT NULL DEFAULT 0.00,
  `total_withdraw` decimal(50,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `delivery_country_codes`
--

CREATE TABLE `delivery_country_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_code` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_country_codes`
--

INSERT INTO `delivery_country_codes` (`id`, `country_code`, `created_at`, `updated_at`) VALUES
(1, 'BD', '2024-03-07 04:06:58', '2024-03-07 04:06:58');

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

--
-- Table structure for table `delivery_histories`
--

CREATE TABLE `delivery_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `deliveryman_id` bigint(20) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `delivery_man_transactions`
--

CREATE TABLE `delivery_man_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `delivery_man_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `user_type` varchar(20) NOT NULL,
  `transaction_id` char(36) NOT NULL,
  `debit` decimal(50,2) NOT NULL DEFAULT 0.00,
  `credit` decimal(50,2) NOT NULL DEFAULT 0.00,
  `transaction_type` varchar(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `delivery_zip_codes`
--

CREATE TABLE `delivery_zip_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `zipcode` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `emergency_contacts`
--

CREATE TABLE `emergency_contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `name` varchar(191) NOT NULL,
  `country_code` varchar(20) DEFAULT NULL,
  `phone` varchar(25) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Table structure for table `feature_deals`
--

CREATE TABLE `feature_deals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(191) DEFAULT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `flash_deals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(150) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `background_color` varchar(255) DEFAULT NULL,
  `text_color` varchar(255) DEFAULT NULL,
  `banner` varchar(100) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `deal_type` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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`, `product_id`, `deal_type`) VALUES
(1, 'Flash Deal', '2024-03-07', '2024-12-21', 1, 0, NULL, NULL, '2024-03-08-65eabb454b88b.webp', 'flash-deal', '2024-03-08 07:16:21', '2024-03-08 07:16:27', NULL, 'flash_deal'),
(2, 'Feature Deal', '2024-03-08', '2024-12-26', 1, 0, NULL, NULL, 'def.webp', 'feature-deal', '2024-03-08 08:15:22', '2024-03-08 08:16:34', NULL, 'feature_deal');

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

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

CREATE TABLE `flash_deal_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `flash_deal_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `discount` decimal(8,2) NOT NULL DEFAULT 0.00,
  `discount_type` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `flash_deal_products` (`id`, `flash_deal_id`, `product_id`, `discount`, `discount_type`, `created_at`, `updated_at`) VALUES
(1, 1, 17, 0.00, '0', '2024-03-08 08:11:30', '2024-03-08 08:11:30'),
(2, 1, 18, 0.00, '0', '2024-03-08 08:11:38', '2024-03-08 08:11:38'),
(3, 1, 21, 0.00, '0', '2024-03-08 08:11:49', '2024-03-08 08:11:49'),
(4, 1, 23, 0.00, '0', '2024-03-08 08:11:58', '2024-03-08 08:11:58'),
(5, 1, 24, 0.00, '0', '2024-03-08 08:12:06', '2024-03-08 08:12:06'),
(6, 2, 17, 0.00, '0', '2024-03-08 08:15:35', '2024-03-08 08:15:35'),
(7, 2, 18, 0.00, '0', '2024-03-08 08:15:43', '2024-03-08 08:15:43'),
(8, 2, 21, 0.00, '0', '2024-03-08 08:15:51', '2024-03-08 08:15:51'),
(9, 2, 22, 0.00, '0', '2024-03-08 08:16:12', '2024-03-08 08:16:12'),
(10, 2, 24, 0.00, '0', '2024-03-08 08:16:23', '2024-03-08 08:16:23');

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

--
-- Table structure for table `help_topics`
--

CREATE TABLE `help_topics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` text DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `ranking` int(11) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `help_topics`
--

INSERT INTO `help_topics` (`id`, `question`, `answer`, `ranking`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Can orders be placed using 6valley App?', 'Yes, Orders can be place with 6valley app.', 1, 1, '2024-03-08 07:34:56', '2024-03-08 07:34:56'),
(2, 'Is it important for me to educate the customer before placing order?', 'Yes, it is essential that you first educate your customer and tell them how to place the order, how to change the order, and how to return it as well. You have to guide them properly because the better you guide and convince them, the greater is the chance of them making a purchase from 6valley', 1, 1, '2024-03-08 07:35:14', '2024-03-08 07:35:14'),
(3, 'Why my id is blocked/blacklisted?', 'If you are already registered on any of 6valley\'s programs, you cannot make another ID using the same email address/phone number for D-Force\r\nIf you make fraudulent orders, your ID will be blocked automatically.', 1, 1, '2024-03-08 07:35:32', '2024-03-08 07:35:32'),
(4, 'Why my orders get canceled?', 'Orders get canceled because of following reasons:\r\n\r\nCancelation from customer side.\r\nProduct is out of stock.\r\nSystem recognizes it as a fraud order.', 1, 1, '2024-03-08 07:35:48', '2024-03-08 07:35:48');

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

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

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

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

--
-- Table structure for table `loyalty_point_transactions`
--

CREATE TABLE `loyalty_point_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transaction_id` char(36) NOT NULL,
  `credit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `debit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `balance` decimal(24,3) NOT NULL DEFAULT 0.000,
  `reference` varchar(191) DEFAULT NULL,
  `transaction_type` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2020_09_08_105159_create_admins_table', 1),
(5, '2020_09_08_111837_create_admin_roles_table', 1),
(6, '2020_09_16_142451_create_categories_table', 2),
(7, '2020_09_16_181753_create_categories_table', 3),
(8, '2020_09_17_134238_create_brands_table', 4),
(9, '2020_09_17_203054_create_attributes_table', 5),
(10, '2020_09_19_112509_create_coupons_table', 6),
(11, '2020_09_19_161802_create_curriencies_table', 7),
(12, '2020_09_20_114509_create_sellers_table', 8),
(13, '2020_09_23_113454_create_shops_table', 9),
(14, '2020_09_23_115615_create_shops_table', 10),
(15, '2020_09_23_153822_create_shops_table', 11),
(16, '2020_09_21_122817_create_products_table', 12),
(17, '2020_09_22_140800_create_colors_table', 12),
(18, '2020_09_28_175020_create_products_table', 13),
(19, '2020_09_28_180311_create_products_table', 14),
(20, '2020_10_04_105041_create_search_functions_table', 15),
(21, '2020_10_05_150730_create_customers_table', 15),
(22, '2020_10_08_133548_create_wishlists_table', 16),
(23, '2016_06_01_000001_create_oauth_auth_codes_table', 17),
(24, '2016_06_01_000002_create_oauth_access_tokens_table', 17),
(25, '2016_06_01_000003_create_oauth_refresh_tokens_table', 17),
(26, '2016_06_01_000004_create_oauth_clients_table', 17),
(27, '2016_06_01_000005_create_oauth_personal_access_clients_table', 17),
(28, '2020_10_06_133710_create_product_stocks_table', 17),
(29, '2020_10_06_134636_create_flash_deals_table', 17),
(30, '2020_10_06_134719_create_flash_deal_products_table', 17),
(31, '2020_10_08_115439_create_orders_table', 17),
(32, '2020_10_08_115453_create_order_details_table', 17),
(33, '2020_10_08_121135_create_shipping_addresses_table', 17),
(34, '2020_10_10_171722_create_business_settings_table', 17),
(35, '2020_09_19_161802_create_currencies_table', 18),
(36, '2020_10_12_152350_create_reviews_table', 18),
(37, '2020_10_12_161834_create_reviews_table', 19),
(38, '2020_10_12_180510_create_support_tickets_table', 20),
(39, '2020_10_14_140130_create_transactions_table', 21),
(40, '2020_10_14_143553_create_customer_wallets_table', 21),
(41, '2020_10_14_143607_create_customer_wallet_histories_table', 21),
(42, '2020_10_22_142212_create_support_ticket_convs_table', 21),
(43, '2020_10_24_234813_create_banners_table', 22),
(44, '2020_10_27_111557_create_shipping_methods_table', 23),
(45, '2020_10_27_114154_add_url_to_banners_table', 24),
(46, '2020_10_28_170308_add_shipping_id_to_order_details', 25),
(47, '2020_11_02_140528_add_discount_to_order_table', 26),
(48, '2020_11_03_162723_add_column_to_order_details', 27),
(49, '2020_11_08_202351_add_url_to_banners_table', 28),
(50, '2020_11_10_112713_create_help_topic', 29),
(51, '2020_11_10_141513_create_contacts_table', 29),
(52, '2020_11_15_180036_add_address_column_user_table', 30),
(53, '2020_11_18_170209_add_status_column_to_product_table', 31),
(54, '2020_11_19_115453_add_featured_status_product', 32),
(55, '2020_11_21_133302_create_deal_of_the_days_table', 33),
(56, '2020_11_20_172332_add_product_id_to_products', 34),
(57, '2020_11_27_234439_add__state_to_shipping_addresses', 34),
(58, '2020_11_28_091929_create_chattings_table', 35),
(59, '2020_12_02_011815_add_bank_info_to_sellers', 36),
(60, '2020_12_08_193234_create_social_medias_table', 37),
(61, '2020_12_13_122649_shop_id_to_chattings', 37),
(62, '2020_12_14_145116_create_seller_wallet_histories_table', 38),
(63, '2020_12_14_145127_create_seller_wallets_table', 38),
(64, '2020_12_15_174804_create_admin_wallets_table', 39),
(65, '2020_12_15_174821_create_admin_wallet_histories_table', 39),
(66, '2020_12_15_214312_create_feature_deals_table', 40),
(67, '2020_12_17_205712_create_withdraw_requests_table', 41),
(68, '2021_02_22_161510_create_notifications_table', 42),
(69, '2021_02_24_154706_add_deal_type_to_flash_deals', 43),
(70, '2021_03_03_204349_add_cm_firebase_token_to_users', 44),
(71, '2021_04_17_134848_add_column_to_order_details_stock', 45),
(72, '2021_05_12_155401_add_auth_token_seller', 46),
(73, '2021_06_03_104531_ex_rate_update', 47),
(74, '2021_06_03_222413_amount_withdraw_req', 48),
(75, '2021_06_04_154501_seller_wallet_withdraw_bal', 49),
(76, '2021_06_04_195853_product_dis_tax', 50),
(77, '2021_05_27_103505_create_product_translations_table', 51),
(78, '2021_06_17_054551_create_soft_credentials_table', 51),
(79, '2021_06_29_212549_add_active_col_user_table', 52),
(80, '2021_06_30_212619_add_col_to_contact', 53),
(81, '2021_07_01_160828_add_col_daily_needs_products', 54),
(82, '2021_07_04_182331_add_col_seller_sales_commission', 55),
(83, '2021_08_07_190655_add_seo_columns_to_products', 56),
(84, '2021_08_07_205913_add_col_to_category_table', 56),
(85, '2021_08_07_210808_add_col_to_shops_table', 56),
(86, '2021_08_14_205216_change_product_price_col_type', 56),
(87, '2021_08_16_201505_change_order_price_col', 56),
(88, '2021_08_16_201552_change_order_details_price_col', 56),
(89, '2019_09_29_154000_create_payment_cards_table', 57),
(90, '2021_08_17_213934_change_col_type_seller_earning_history', 57),
(91, '2021_08_17_214109_change_col_type_admin_earning_history', 57),
(92, '2021_08_17_214232_change_col_type_admin_wallet', 57),
(93, '2021_08_17_214405_change_col_type_seller_wallet', 57),
(94, '2021_08_22_184834_add_publish_to_products_table', 57),
(95, '2021_09_08_211832_add_social_column_to_users_table', 57),
(96, '2021_09_13_165535_add_col_to_user', 57),
(97, '2021_09_19_061647_add_limit_to_coupons_table', 57),
(98, '2021_09_20_020716_add_coupon_code_to_orders_table', 57),
(99, '2021_09_23_003059_add_gst_to_sellers_table', 57),
(100, '2021_09_28_025411_create_order_transactions_table', 57),
(101, '2021_10_02_185124_create_carts_table', 57),
(102, '2021_10_02_190207_create_cart_shippings_table', 57),
(103, '2021_10_03_194334_add_col_order_table', 57),
(104, '2021_10_03_200536_add_shipping_cost', 57),
(105, '2021_10_04_153201_add_col_to_order_table', 57),
(106, '2021_10_07_172701_add_col_cart_shop_info', 57),
(107, '2021_10_07_184442_create_phone_or_email_verifications_table', 57),
(108, '2021_10_07_185416_add_user_table_email_verified', 57),
(109, '2021_10_11_192739_add_transaction_amount_table', 57),
(110, '2021_10_11_200850_add_order_verification_code', 57),
(111, '2021_10_12_083241_add_col_to_order_transaction', 57),
(112, '2021_10_12_084440_add_seller_id_to_order', 57),
(113, '2021_10_12_102853_change_col_type', 57),
(114, '2021_10_12_110434_add_col_to_admin_wallet', 57),
(115, '2021_10_12_110829_add_col_to_seller_wallet', 57),
(116, '2021_10_13_091801_add_col_to_admin_wallets', 57),
(117, '2021_10_13_092000_add_col_to_seller_wallets_tax', 57),
(118, '2021_10_13_165947_rename_and_remove_col_seller_wallet', 57),
(119, '2021_10_13_170258_rename_and_remove_col_admin_wallet', 57),
(120, '2021_10_14_061603_column_update_order_transaction', 57),
(121, '2021_10_15_103339_remove_col_from_seller_wallet', 57),
(122, '2021_10_15_104419_add_id_col_order_tran', 57),
(123, '2021_10_15_213454_update_string_limit', 57),
(124, '2021_10_16_234037_change_col_type_translation', 57),
(125, '2021_10_16_234329_change_col_type_translation_1', 57),
(126, '2021_10_27_091250_add_shipping_address_in_order', 58),
(127, '2021_01_24_205114_create_paytabs_invoices_table', 59),
(128, '2021_11_20_043814_change_pass_reset_email_col', 59),
(129, '2021_11_25_043109_create_delivery_men_table', 60),
(130, '2021_11_25_062242_add_auth_token_delivery_man', 60),
(131, '2021_11_27_043405_add_deliveryman_in_order_table', 60),
(132, '2021_11_27_051432_create_delivery_histories_table', 60),
(133, '2021_11_27_051512_add_fcm_col_for_delivery_man', 60),
(134, '2021_12_15_123216_add_columns_to_banner', 60),
(135, '2022_01_04_100543_add_order_note_to_orders_table', 60),
(136, '2022_01_10_034952_add_lat_long_to_shipping_addresses_table', 60),
(137, '2022_01_10_045517_create_billing_addresses_table', 60),
(138, '2022_01_11_040755_add_is_billing_to_shipping_addresses_table', 60),
(139, '2022_01_11_053404_add_billing_to_orders_table', 60),
(140, '2022_01_11_234310_add_firebase_toke_to_sellers_table', 60),
(141, '2022_01_16_121801_change_colu_type', 60),
(142, '2022_01_22_101601_change_cart_col_type', 61),
(143, '2022_01_23_031359_add_column_to_orders_table', 61),
(144, '2022_01_28_235054_add_status_to_admins_table', 61),
(145, '2022_02_01_214654_add_pos_status_to_sellers_table', 61),
(146, '2019_12_14_000001_create_personal_access_tokens_table', 62),
(147, '2022_02_11_225355_add_checked_to_orders_table', 62),
(148, '2022_02_14_114359_create_refund_requests_table', 62),
(149, '2022_02_14_115757_add_refund_request_to_order_details_table', 62),
(150, '2022_02_15_092604_add_order_details_id_to_transactions_table', 62),
(151, '2022_02_15_121410_create_refund_transactions_table', 62),
(152, '2022_02_24_091236_add_multiple_column_to_refund_requests_table', 62),
(153, '2022_02_24_103827_create_refund_statuses_table', 62),
(154, '2022_03_01_121420_add_refund_id_to_refund_transactions_table', 62),
(155, '2022_03_10_091943_add_priority_to_categories_table', 63),
(156, '2022_03_13_111914_create_shipping_types_table', 63),
(157, '2022_03_13_121514_create_category_shipping_costs_table', 63),
(158, '2022_03_14_074413_add_four_column_to_products_table', 63),
(159, '2022_03_15_105838_add_shipping_to_carts_table', 63),
(160, '2022_03_16_070327_add_shipping_type_to_orders_table', 63),
(161, '2022_03_17_070200_add_delivery_info_to_orders_table', 63),
(162, '2022_03_18_143339_add_shipping_type_to_carts_table', 63),
(163, '2022_04_06_020313_create_subscriptions_table', 64),
(164, '2022_04_12_233704_change_column_to_products_table', 64),
(165, '2022_04_19_095926_create_jobs_table', 64),
(166, '2022_05_12_104247_create_wallet_transactions_table', 65),
(167, '2022_05_12_104511_add_two_column_to_users_table', 65),
(168, '2022_05_14_063309_create_loyalty_point_transactions_table', 65),
(169, '2022_05_26_044016_add_user_type_to_password_resets_table', 65),
(170, '2022_04_15_235820_add_provider', 66),
(171, '2022_07_21_101659_add_code_to_products_table', 66),
(172, '2022_07_26_103744_add_notification_count_to_notifications_table', 66),
(173, '2022_07_31_031541_add_minimum_order_qty_to_products_table', 66),
(174, '2022_08_11_172839_add_product_type_and_digital_product_type_and_digital_file_ready_to_products', 67),
(175, '2022_08_11_173941_add_product_type_and_digital_product_type_and_digital_file_to_order_details', 67),
(176, '2022_08_20_094225_add_product_type_and_digital_product_type_and_digital_file_ready_to_carts_table', 67),
(177, '2022_10_04_160234_add_banking_columns_to_delivery_men_table', 68),
(178, '2022_10_04_161339_create_deliveryman_wallets_table', 68),
(179, '2022_10_04_184506_add_deliverymanid_column_to_withdraw_requests_table', 68),
(180, '2022_10_11_103011_add_deliverymans_columns_to_chattings_table', 68),
(181, '2022_10_11_144902_add_deliverman_id_cloumn_to_reviews_table', 68),
(182, '2022_10_17_114744_create_order_status_histories_table', 68),
(183, '2022_10_17_120840_create_order_expected_delivery_histories_table', 68),
(184, '2022_10_18_084245_add_deliveryman_charge_and_expected_delivery_date', 68),
(185, '2022_10_18_130938_create_delivery_zip_codes_table', 68),
(186, '2022_10_18_130956_create_delivery_country_codes_table', 68),
(187, '2022_10_20_164712_create_delivery_man_transactions_table', 68),
(188, '2022_10_27_145604_create_emergency_contacts_table', 68),
(189, '2022_10_29_182930_add_is_pause_cause_to_orders_table', 68),
(190, '2022_10_31_150604_add_address_phone_country_code_column_to_delivery_men_table', 68),
(191, '2022_11_05_185726_add_order_id_to_reviews_table', 68),
(192, '2022_11_07_190749_create_deliveryman_notifications_table', 68),
(193, '2022_11_08_132745_change_transaction_note_type_to_withdraw_requests_table', 68),
(194, '2022_11_10_193747_chenge_order_amount_seller_amount_admin_commission_delivery_charge_tax_toorder_transactions_table', 68),
(195, '2022_12_17_035723_few_field_add_to_coupons_table', 69),
(196, '2022_12_26_231606_add_coupon_discount_bearer_and_admin_commission_to_orders', 69),
(197, '2023_01_04_003034_alter_billing_addresses_change_zip', 69),
(198, '2023_01_05_121600_change_id_to_transactions_table', 69),
(199, '2023_02_02_113330_create_product_tag_table', 70),
(200, '2023_02_02_114518_create_tags_table', 70),
(201, '2023_02_02_152248_add_tax_model_to_products_table', 70),
(202, '2023_02_02_152718_add_tax_model_to_order_details_table', 70),
(203, '2023_02_02_171034_add_tax_type_to_carts', 70),
(204, '2023_02_06_124447_add_color_image_column_to_products_table', 70),
(205, '2023_02_07_120136_create_withdrawal_methods_table', 70),
(206, '2023_02_07_175939_add_withdrawal_method_id_and_withdrawal_method_fields_to_withdraw_requests_table', 70),
(207, '2023_02_08_143314_add_vacation_start_and_vacation_end_and_vacation_not_column_to_shops_table', 70),
(208, '2023_02_09_104656_add_payment_by_and_payment_not_to_orders_table', 70),
(209, '2023_03_27_150723_add_expires_at_to_phone_or_email_verifications', 71),
(210, '2023_04_17_095721_create_shop_followers_table', 71),
(211, '2023_04_17_111249_add_bottom_banner_to_shops_table', 71),
(212, '2023_04_20_125423_create_product_compares_table', 71),
(213, '2023_04_30_165642_add_category_sub_category_and_sub_sub_category_add_in_product_table', 71),
(214, '2023_05_16_131006_add_expires_at_to_password_resets', 71),
(215, '2023_05_17_044243_add_visit_count_to_tags_table', 71),
(216, '2023_05_18_000403_add_title_and_subtitle_and_background_color_and_button_text_to_banners_table', 71),
(217, '2023_05_21_111300_add_login_hit_count_and_is_temp_blocked_and_temp_block_time_to_users_table', 71),
(218, '2023_05_21_111600_add_login_hit_count_and_is_temp_blocked_and_temp_block_time_to_phone_or_email_verifications_table', 71),
(219, '2023_05_21_112215_add_login_hit_count_and_is_temp_blocked_and_temp_block_time_to_password_resets_table', 71),
(220, '2023_06_04_210726_attachment_lenght_change_to_reviews_table', 71),
(221, '2023_06_05_115153_add_referral_code_and_referred_by_to_users_table', 72),
(222, '2023_06_21_002658_add_offer_banner_to_shops_table', 72),
(223, '2023_07_08_210747_create_most_demandeds_table', 72),
(224, '2023_07_31_111419_add_minimum_order_amount_to_sellers_table', 72),
(225, '2023_08_03_105256_create_offline_payment_methods_table', 72),
(226, '2023_08_07_131013_add_is_guest_column_to_carts_table', 72),
(227, '2023_08_07_170601_create_offline_payments_table', 72),
(228, '2023_08_12_102355_create_add_fund_bonus_categories_table', 72),
(229, '2023_08_12_215346_create_guest_users_table', 72),
(230, '2023_08_12_215659_add_is_guest_column_to_orders_table', 72),
(231, '2023_08_12_215933_add_is_guest_column_to_shipping_addresses_table', 72),
(232, '2023_08_15_000957_add_email_column_toshipping_address_table', 72),
(233, '2023_08_17_222330_add_identify_related_columns_to_admins_table', 72),
(234, '2023_08_20_230624_add_sent_by_and_send_to_in_notifications_table', 72),
(235, '2023_08_20_230911_create_notification_seens_table', 72),
(236, '2023_08_21_042331_add_theme_to_banners_table', 72),
(237, '2023_08_24_150009_add_free_delivery_over_amount_and_status_to_seller_table', 72),
(238, '2023_08_26_161214_add_is_shipping_free_to_orders_table', 72),
(239, '2023_08_26_173523_add_payment_method_column_to_wallet_transactions_table', 72),
(240, '2023_08_26_204653_add_verification_status_column_to_orders_table', 72),
(241, '2023_08_26_225113_create_order_delivery_verifications_table', 72),
(242, '2023_09_03_212200_add_free_delivery_responsibility_column_to_orders_table', 72),
(243, '2023_09_23_153314_add_shipping_responsibility_column_to_orders_table', 72),
(244, '2023_09_25_152733_create_digital_product_otp_verifications_table', 72),
(245, '2023_09_27_191638_add_attachment_column_to_support_ticket_convs_table', 73),
(246, '2023_10_01_205117_add_attachment_column_to_chattings_table', 73),
(247, '2023_10_07_182714_create_notification_messages_table', 73),
(248, '2023_10_21_113354_add_app_language_column_to_users_table', 73),
(249, '2023_10_21_123433_add_app_language_column_to_sellers_table', 73),
(250, '2023_10_21_124657_add_app_language_column_to_delivery_men_table', 73),
(251, '2023_10_22_130225_add_attachment_to_support_tickets_table', 73),
(252, '2023_10_25_113233_make_message_nullable_in_chattings_table', 73),
(253, '2023_10_30_152005_make_attachment_column_type_change_to_reviews_table', 73),
(254, '2024_01_14_192546_add_slug_to_shops_table', 74),
(255, '2024_01_25_175421_add_country_code_to_emergency_contacts_table', 75),
(256, '2024_02_01_200417_add_denied_count_and_approved_count_to_refund_requests_table', 75);

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

--
-- Table structure for table `most_demandeds`
--

CREATE TABLE `most_demandeds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `banner` varchar(255) NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sent_by` varchar(255) NOT NULL DEFAULT 'system',
  `sent_to` varchar(255) NOT NULL DEFAULT 'customer',
  `title` varchar(100) DEFAULT NULL,
  `description` varchar(191) DEFAULT NULL,
  `notification_count` int(11) NOT NULL DEFAULT 0,
  `image` varchar(50) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notifications` (`id`, `sent_by`, `sent_to`, `title`, `description`, `notification_count`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'seller', 'Theme Changed to Theme Aster', 'Theme Changed Description, time - 2024-03-08 05:13:47', 1, NULL, 1, '2024-03-08 05:13:47', '2024-03-08 05:13:47'),
(2, 'admin', 'seller', 'Theme Changed to Theme Fashion', 'Theme Changed Description, time - 2024-03-08 05:15:18', 1, NULL, 1, '2024-03-08 05:15:19', '2024-03-08 05:15:19'),
(3, 'admin', 'seller', 'Theme Changed to Theme Fashion', 'Theme Changed Description, time - 2024-03-08 05:18:10', 1, NULL, 1, '2024-03-08 05:18:10', '2024-03-08 05:18:10'),
(4, 'admin', 'seller', 'Theme Changed to Theme Aster', 'Theme Changed Description, time - 2024-03-08 05:18:33', 1, NULL, 1, '2024-03-08 05:18:33', '2024-03-08 05:18:33'),
(5, 'admin', 'seller', 'Theme Changed to Theme Fashion', 'Theme Changed Description, time - 2024-03-08 05:22:59', 1, NULL, 1, '2024-03-08 05:22:59', '2024-03-08 05:22:59');

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

--
-- Table structure for table `notification_seens`
--

CREATE TABLE `notification_seens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `notification_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2020-10-21 18:27:23', '2020-10-21 18:27:23');

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

--
-- Table structure for table `offline_payments`
--

CREATE TABLE `offline_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` int(11) NOT NULL,
  `payment_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_info`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `offline_payment_methods`
--

CREATE TABLE `offline_payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `method_name` varchar(255) NOT NULL,
  `method_fields` text NOT NULL,
  `method_informations` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_delivery_verifications`
--

CREATE TABLE `order_delivery_verifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `image` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `order_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `seller_id` bigint(20) DEFAULT NULL,
  `digital_file_after_sell` varchar(191) DEFAULT NULL,
  `product_details` text DEFAULT NULL,
  `qty` int(11) NOT NULL DEFAULT 0,
  `price` double NOT NULL DEFAULT 0,
  `tax` double NOT NULL DEFAULT 0,
  `discount` double NOT NULL DEFAULT 0,
  `tax_model` varchar(20) NOT NULL DEFAULT 'exclude',
  `delivery_status` varchar(15) NOT NULL DEFAULT 'pending',
  `payment_status` varchar(15) NOT NULL DEFAULT 'unpaid',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `shipping_method_id` bigint(20) DEFAULT NULL,
  `variant` varchar(255) DEFAULT NULL,
  `variation` varchar(255) DEFAULT NULL,
  `discount_type` varchar(30) DEFAULT NULL,
  `is_stock_decreased` tinyint(1) NOT NULL DEFAULT 1,
  `refund_request` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_expected_delivery_histories`
--

CREATE TABLE `order_expected_delivery_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `user_type` varchar(191) NOT NULL,
  `expected_delivery_date` date NOT NULL,
  `cause` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_status_histories`
--

CREATE TABLE `order_status_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `user_type` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `cause` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_transactions`
--

CREATE TABLE `order_transactions` (
  `seller_id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `order_amount` decimal(50,2) NOT NULL DEFAULT 0.00,
  `seller_amount` decimal(50,2) NOT NULL DEFAULT 0.00,
  `admin_commission` decimal(50,2) NOT NULL DEFAULT 0.00,
  `received_by` varchar(191) NOT NULL,
  `status` varchar(191) DEFAULT NULL,
  `delivery_charge` decimal(50,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(50,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `seller_is` varchar(191) DEFAULT NULL,
  `delivered_by` varchar(191) NOT NULL DEFAULT 'admin',
  `payment_method` varchar(191) DEFAULT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_requests`
--

CREATE TABLE `payment_requests` (
  `id` char(36) NOT NULL,
  `payer_id` varchar(64) DEFAULT NULL,
  `receiver_id` varchar(64) DEFAULT NULL,
  `payment_amount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `gateway_callback_url` varchar(191) DEFAULT NULL,
  `success_hook` varchar(100) DEFAULT NULL,
  `failure_hook` varchar(100) DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `currency_code` varchar(20) NOT NULL DEFAULT 'USD',
  `payment_method` varchar(50) DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `is_paid` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payer_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `external_redirect_link` varchar(255) DEFAULT NULL,
  `receiver_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `attribute_id` varchar(64) DEFAULT NULL,
  `attribute` varchar(255) DEFAULT NULL,
  `payment_platform` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `paytabs_invoices`
--

CREATE TABLE `paytabs_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `result` text NOT NULL,
  `response_code` int(10) UNSIGNED NOT NULL,
  `pt_invoice_id` int(10) UNSIGNED DEFAULT NULL,
  `amount` double(8,2) DEFAULT NULL,
  `currency` varchar(191) DEFAULT NULL,
  `transaction_id` int(10) UNSIGNED DEFAULT NULL,
  `card_brand` varchar(191) DEFAULT NULL,
  `card_first_six_digits` int(10) UNSIGNED DEFAULT NULL,
  `card_last_four_digits` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `added_by` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `slug` varchar(120) DEFAULT NULL,
  `product_type` varchar(20) NOT NULL DEFAULT 'physical',
  `category_ids` varchar(80) DEFAULT NULL,
  `category_id` varchar(191) DEFAULT NULL,
  `sub_category_id` varchar(191) DEFAULT NULL,
  `sub_sub_category_id` varchar(191) DEFAULT NULL,
  `brand_id` bigint(20) DEFAULT NULL,
  `unit` varchar(191) DEFAULT NULL,
  `min_qty` int(11) NOT NULL DEFAULT 1,
  `refundable` tinyint(1) NOT NULL DEFAULT 1,
  `digital_product_type` varchar(30) DEFAULT NULL,
  `digital_file_ready` varchar(191) DEFAULT NULL,
  `images` longtext DEFAULT NULL,
  `color_image` text NOT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `featured` varchar(255) DEFAULT NULL,
  `flash_deal` varchar(255) DEFAULT NULL,
  `video_provider` varchar(30) DEFAULT NULL,
  `video_url` varchar(150) DEFAULT NULL,
  `colors` varchar(150) DEFAULT NULL,
  `variant_product` tinyint(1) NOT NULL DEFAULT 0,
  `attributes` varchar(255) DEFAULT NULL,
  `choice_options` text DEFAULT NULL,
  `variation` text DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `unit_price` double NOT NULL DEFAULT 0,
  `purchase_price` double NOT NULL DEFAULT 0,
  `tax` varchar(191) NOT NULL DEFAULT '0.00',
  `tax_type` varchar(80) DEFAULT NULL,
  `tax_model` varchar(20) NOT NULL DEFAULT 'exclude',
  `discount` varchar(191) NOT NULL DEFAULT '0.00',
  `discount_type` varchar(80) DEFAULT NULL,
  `current_stock` int(11) DEFAULT NULL,
  `minimum_order_qty` int(11) NOT NULL DEFAULT 1,
  `details` text DEFAULT NULL,
  `free_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `attachment` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `featured_status` tinyint(1) NOT NULL DEFAULT 1,
  `meta_title` varchar(191) DEFAULT NULL,
  `meta_description` varchar(191) DEFAULT NULL,
  `meta_image` varchar(191) DEFAULT NULL,
  `request_status` tinyint(1) NOT NULL DEFAULT 0,
  `denied_note` varchar(191) DEFAULT NULL,
  `shipping_cost` double(8,2) DEFAULT NULL,
  `multiply_qty` tinyint(1) DEFAULT NULL,
  `temp_shipping_cost` double(8,2) DEFAULT NULL,
  `is_shipping_cost_updated` tinyint(1) DEFAULT NULL,
  `code` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `added_by`, `user_id`, `name`, `slug`, `product_type`, `category_ids`, `category_id`, `sub_category_id`, `sub_sub_category_id`, `brand_id`, `unit`, `min_qty`, `refundable`, `digital_product_type`, `digital_file_ready`, `images`, `color_image`, `thumbnail`, `featured`, `flash_deal`, `video_provider`, `video_url`, `colors`, `variant_product`, `attributes`, `choice_options`, `variation`, `published`, `unit_price`, `purchase_price`, `tax`, `tax_type`, `tax_model`, `discount`, `discount_type`, `current_stock`, `minimum_order_qty`, `details`, `free_shipping`, `attachment`, `created_at`, `updated_at`, `status`, `featured_status`, `meta_title`, `meta_description`, `meta_image`, `request_status`, `denied_note`, `shipping_cost`, `multiply_qty`, `temp_shipping_cost`, `is_shipping_cost_updated`, `code`) VALUES
(17, 'admin', 1, 'Polo T-Shirt', 'polo-t-shirt-WoxkEf', 'physical', '[{\"id\":\"14\",\"position\":1},{\"id\":\"23\",\"position\":2},{\"id\":\"26\",\"position\":3}]', '14', '23', '26', 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac2751556d.webp\",\"2024-03-08-65eac275832cc.webp\",\"2024-03-08-65eac275ef1b0.webp\",\"2024-03-08-65eac2766f21a.webp\"]', '[{\"color\":\"9ACD32\",\"image_name\":\"2024-03-08-65eac2751556d.webp\"},{\"color\":\"FFFF00\",\"image_name\":\"2024-03-08-65eac275832cc.webp\"},{\"color\":\"EE82EE\",\"image_name\":\"2024-03-08-65eac275ef1b0.webp\"},{\"color\":\"D2B48C\",\"image_name\":\"2024-03-08-65eac2766f21a.webp\"}]', '2024-03-08-65eac27817ed5.png', '1', NULL, 'youtube', NULL, '[\"#9ACD32\",\"#FFFF00\",\"#EE82EE\",\"#D2B48C\"]', 0, 'null', '[]', '[{\"type\":\"YellowGreen\",\"price\":550,\"sku\":\"PT-YELLOWGREEN\",\"qty\":1},{\"type\":\"Yellow\",\"price\":550,\"sku\":\"PT-YELLOW\",\"qty\":1},{\"type\":\"Violet\",\"price\":550,\"sku\":\"PT-VIOLET\",\"qty\":1},{\"type\":\"Tan\",\"price\":550,\"sku\":\"PT-TAN\",\"qty\":1}]', 0, 550, 0, '0', 'percent', 'include', '20', 'flat', 4, 1, '<p>Polo Shirt Measurement:</p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">M – Chest: 38inch, Sleeve: 7.5, Body Length: 27</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">L – Chest: 41inch, Sleeve: 7.5, Body Length: 27.5</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">XL – Chest: 42inch, Sleeve: 8, Body Length: 28</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">2XL – Chest: 44inch, Sleeve: 8 Body Length: 28.5</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">– Free Delivery Inside Dhaka City.</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">– Outside Dhaka City, 100 BDT will be charged as delivery Charge.</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">– Enjoy Free Delivery for shopping products worth 1000 BDT or more.</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">Super Fast Delivery Nationwide, Get your products in Dhaka within 48 hours or 2 Days.</span><br></p><p><span style=\"color: var(--text-color); font-family: var(--font); font-size: 0.875rem;\">For outside Dhaka, Delivery within 96 Hours or 4 Days.</span><br></p>', 0, NULL, '2024-03-08 07:47:04', '2024-03-08 07:47:12', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '130635'),
(18, 'admin', 1, 'Boys Panjabi', 'boys-panjabi-chWohB', 'physical', '[{\"id\":\"14\",\"position\":1},{\"id\":\"25\",\"position\":2},{\"id\":\"35\",\"position\":3}]', '14', '25', '35', 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac338046c7.webp\"]', '[]', '2024-03-08-65eac3381290e.png', '1', NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 550, 0, '0', 'percent', 'include', '0', 'flat', 1000, 1, '<p>Measurement:</p><p>4/5 Years Old</p><p>6/7 Years Old</p><p>8/9 Years Old</p><p>10/11 Years Old</p><p>12/13 Years Old</p><p>14/15 Years Old</p><p>Small Size</p><p><br></p><p>– Free Delivery Inside Dhaka City.</p><p>– Outside Dhaka City, 100 BDT will be charged as delivery Charge.</p><p>– Enjoy Free Delivery for shopping products worth 1000 BDT or more.</p><p><br></p><p>Super Fast Delivery Nationwide, Get your products in Dhaka within 48 hours or 2 Days.</p><p>For outside Dhaka, Delivery within 96 Hours or 4 Days.</p>', 0, NULL, '2024-03-08 07:50:16', '2024-03-08 07:50:28', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '124954'),
(19, 'admin', 1, 'Easy Panjabi', 'easy-panjabi-pnI8J8', 'physical', '[{\"id\":\"14\",\"position\":1},{\"id\":\"23\",\"position\":2},{\"id\":\"26\",\"position\":3}]', '14', '23', '26', 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac3bd6564f.webp\"]', '[]', '2024-03-08-65eac3bd726e2.png', '1', NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 1200, 0, '0', 'percent', 'include', '0', 'flat', 100, 1, '<p>Panjabi Measurement:</p><p><br></p><p>38” – Chest: 42inch, Body Length: 41.5 inch</p><p><br></p><p>40“ – Chest: 44inch, Body Length: 42 inch</p><p><br></p><p>42“ – Chest: 46inch, Body Length: 43 inch</p><p><br></p><p>44” – Chest: 48inch, Body Length: 43 inch</p><p><br></p><p>– Free Delivery Inside Dhaka City.</p><p><br></p><p>– Outside Dhaka City, 100 BDT will be charged as delivery Charge.</p><p><br></p><p>– Enjoy Free Delivery for shopping products worth 1000 BDT or more.</p><p><br></p><p>Super Fast Delivery Nationwide, Get your products in Dhaka within 48 hours or 2 Days.</p><p><br></p><p>For outside Dhaka, Delivery within 96 Hours or 4 Days.</p>', 0, NULL, '2024-03-08 07:52:29', '2024-03-08 07:52:35', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '178372'),
(20, 'admin', 1, 'Full Sleeve Classic Fit Shirt', 'full-sleeve-classic-fit-shirt-TTAVaK', 'physical', '[{\"id\":\"14\",\"position\":1},{\"id\":\"23\",\"position\":2},{\"id\":\"26\",\"position\":3}]', '14', '23', '26', 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac451b34ba.webp\"]', '[]', '2024-03-08-65eac451baf41.png', '1', NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 1200, 0, '0', 'percent', 'include', '0', 'flat', 1000, 1, '<p>Classic Shirt Measurement:</p><p><br></p><p>15 – Chest: 40inch, Sleeve: 24, Body Length: 27.5</p><p><br></p><p>15.5 – Chest: 42inch, Sleeve: 24.5, Body Length: 28.5</p><p><br></p><p>16 – Chest: 44inch, Sleeve: 25, Body Length: 29.5</p><p><br></p><p>16.5 – Chest: 46inch, Sleeve: 25.5, Body Length: 30.5</p><p><br></p><p>– Free Delivery Inside Dhaka City.</p><p><br></p><p>– Outside Dhaka City, 100 BDT will be charged as delivery Charge.</p><p><br></p><p>– Enjoy Free Delivery for shopping products worth 1000 BDT or more.</p><p><br></p><p>Super Fast Delivery Nationwide, Get your products in Dhaka within 48 hours or 2 Days.</p><p><br></p><p>For outside Dhaka, Delivery within 96 Hours or 4 Days.</p>', 0, NULL, '2024-03-08 07:54:57', '2024-03-08 07:55:46', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '171042'),
(21, 'admin', 1, 'WOMENS FASHION TOPS', 'womens-fashion-tops-OZNuhZ', 'physical', '[{\"id\":\"14\",\"position\":1},{\"id\":\"24\",\"position\":2},{\"id\":\"30\",\"position\":3}]', '14', '24', '30', 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac53e642d9.webp\"]', '[]', '2024-03-08-65eac53e84485.png', '1', NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 1400, 0, '0', 'percent', 'include', '0', 'flat', 100, 1, '<p>WOMENS FASHION TOPS</p><p>Brand: SaRa</p><p><br></p><p>Fabric: Viscose</p><p><br></p><p>Gender: Female</p><p><br></p><p>Color: Red Printed</p><p><br></p><p>Fit Type: Regular Fit</p><p><br></p><p>Length: Mid Length</p><p>Addition: Embroidery</p><p><br></p><p>Collar/ Neck: Round Collar</p><p>Sleeve: Full Sleeve</p><p>Note: The color is the same as the picture. However, it may slightly differ due to lighting.</p>', 0, NULL, '2024-03-08 07:58:54', '2024-03-08 07:59:00', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '115085'),
(22, 'admin', 1, 'WOMENS ETHNIC 3PCS', 'womens-ethnic-3pcs-uY6Osy', 'physical', '[{\"id\":\"14\",\"position\":1},{\"id\":\"24\",\"position\":2},{\"id\":\"30\",\"position\":3}]', '14', '24', '30', 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac5ed1ed73.webp\"]', '[]', '2024-03-08-65eac5ed3b4e4.png', '1', NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 100, 0, '0', 'percent', 'include', '0', 'flat', 100, 1, '<p>Brand: SaRa&nbsp;</p><p><br></p><p>Fabric: Viscose</p><p><br></p><p>Gender: Female</p><p><br></p><p>Color: Coffee</p><p><br></p><p>Fit Type: Regular Fit</p><p>Collar/ Neck: Round Collar</p><p>Length: Full Length</p><p><br></p><p>Addition: Auto Embroidery &amp; Screen Print</p><p><br></p><p>Sleeve: Quarter Sleeve</p><p>Set: 3 pcs</p>', 0, NULL, '2024-03-08 08:01:49', '2024-03-08 08:01:55', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '169669'),
(23, 'admin', 1, 'WOMENS PARTY WEAR', 'womens-party-wear-DyGSz3', 'physical', '[{\"id\":\"14\",\"position\":1},{\"id\":\"24\",\"position\":2},{\"id\":\"30\",\"position\":3}]', '14', '24', '30', 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac67aa1ab4.webp\"]', '[]', '2024-03-08-65eac67b03cdb.png', '1', NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 1000, 0, '0', 'percent', 'include', '0', 'flat', 1200, 1, '<p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\"><span style=\"font-weight: 600;\">Brand: DHEU By SaRa</span></p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\">Fabric: Synthetic</p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\">Gender: Female</p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\">Color: Printed&nbsp;</p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\">Fit Type: Slim fit</p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\">Length: Long&nbsp;</p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\">Collar/ Neck: Round&nbsp;</p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\">Sleeve: Half Sleeve</p><p style=\"font-family: &quot;Work Sans&quot;, sans-serif; line-height: 1.8em; color: rgb(102, 102, 102); margin-bottom: 0px !important;\"><span style=\"font-weight: 600;\">Note: The color is the same as the picture. However, it may slightly differ due to lighting.</span></p>', 0, NULL, '2024-03-08 08:04:11', '2024-03-08 08:04:16', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '137669'),
(24, 'admin', 1, 'PHILIPS BHH811 Hair Straightener/Hair Curler', 'philips-bhh811-hair-straightenerhair-curler-TSE55w', 'physical', '[{\"id\":\"15\",\"position\":1}]', '15', NULL, NULL, 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac727ac925.webp\"]', '[]', '2024-03-08-65eac727d0e15.png', '1', NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 1200, 0, '0', 'percent', 'include', '0', 'flat', 100, 1, '<p>PHILIPS BHH811 Hair Straightener/Hair Curler</p><p>Brand: Philips</p><p>Model: BHH811</p><p>Warranty: 1-year</p><p>Color: Black</p><p>Item type: Multi-Styler StyleCare</p><p>Attachments</p><p>Curler: Straightener</p><p>Style guide: with 10 easy to create styles</p><p>Elastic band: 2</p><p>Hair loop: Yes</p><p>Coating of heated parts: Ceramic</p><p>Barrel diameter: 25 mm</p><p>Straightener size: 30×80 mm</p><p>Cool tip: Yes</p><p>Swivel cord: Yes</p><p>Storage hook: Yes</p><p>OneClick release technology: Yes</p><p>Styling temperature: Up to 210°C</p><p>Heater type: PTC</p><p>Heating time: 60 sec</p><p>Cable length: 1.8 m</p><p>Plate size: Curler 90 mm</p><p>Power source: Electric</p><p>Voltage: 110-240V</p><p>Country of origin: China</p>', 0, NULL, '2024-03-08 08:07:03', '2024-03-08 08:07:09', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '147558'),
(25, 'admin', 1, 'Philips HP8401 Hair Straightener', 'philips-hp8401-hair-straightener-eS3LWJ', 'physical', '[{\"id\":\"15\",\"position\":1}]', '15', NULL, NULL, 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac78765ad4.webp\"]', '[]', '2024-03-08-65eac7877906a.png', NULL, NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 1200, 0, '0', 'percent', 'include', '0', 'flat', 1000, 1, '<p>PHILIPS BHH811 Hair Straightener/Hair Curler</p><p>Brand: Philips</p><p>Model: BHH811</p><p>Warranty: 1-year</p><p>Color: Black</p><p>Item type: Multi-Styler StyleCare</p><p>Attachments</p><p>Curler: Straightener</p><p>Style guide: with 10 easy to create styles</p><p>Elastic band: 2</p><p>Hair loop: Yes</p><p>Coating of heated parts: Ceramic</p><p>Barrel diameter: 25 mm</p><p>Straightener size: 30×80 mm</p><p>Cool tip: Yes</p><p>Swivel cord: Yes</p><p>Storage hook: Yes</p><p>OneClick release technology: Yes</p><p>Styling temperature: Up to 210°C</p><p>Heater type: PTC</p><p>Heating time: 60 sec</p><p>Cable length: 1.8 m</p><p>Plate size: Curler 90 mm</p><p>Power source: Electric</p><p>Voltage: 110-240V</p><p>Country of origin: China</p>', 0, NULL, '2024-03-08 08:08:39', '2024-03-08 08:08:39', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '165333'),
(26, 'admin', 1, 'Philips BT3125/15 Beard Trimmer Series 3000 for Men', 'philips-bt312515-beard-trimmer-series-3000-for-men-GXCUMn', 'physical', '[{\"id\":\"15\",\"position\":1}]', '15', NULL, NULL, 12, 'pc', 1, 1, NULL, '', '[\"2024-03-08-65eac7c62c467.webp\"]', '[]', '2024-03-08-65eac7c63ea2b.png', NULL, NULL, 'youtube', NULL, '[]', 0, 'null', '[]', '[]', 0, 1250, 0, '0', 'percent', 'include', '0', 'flat', 1250, 1, '<p>PHILIPS BHH811 Hair Straightener/Hair Curler</p><p>Brand: Philips</p><p>Model: BHH811</p><p>Warranty: 1-year</p><p>Color: Black</p><p>Item type: Multi-Styler StyleCare</p><p>Attachments</p><p>Curler: Straightener</p><p>Style guide: with 10 easy to create styles</p><p>Elastic band: 2</p><p>Hair loop: Yes</p><p>Coating of heated parts: Ceramic</p><p>Barrel diameter: 25 mm</p><p>Straightener size: 30×80 mm</p><p>Cool tip: Yes</p><p>Swivel cord: Yes</p><p>Storage hook: Yes</p><p>OneClick release technology: Yes</p><p>Styling temperature: Up to 210°C</p><p>Heater type: PTC</p><p>Heating time: 60 sec</p><p>Cable length: 1.8 m</p><p>Plate size: Curler 90 mm</p><p>Power source: Electric</p><p>Voltage: 110-240V</p><p>Country of origin: China</p>', 0, NULL, '2024-03-08 08:09:42', '2024-03-08 08:09:42', 1, 1, NULL, NULL, 'def.png', 1, NULL, 0.00, 0, NULL, NULL, '161940');

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

--
-- Table structure for table `product_compares`
--

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

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

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

CREATE TABLE `product_stocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `variant` varchar(255) DEFAULT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `qty` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `product_tag` (`id`, `product_id`, `tag_id`, `created_at`, `updated_at`) VALUES
(1, 17, 1, NULL, NULL),
(2, 17, 2, NULL, NULL),
(3, 17, 3, NULL, NULL),
(4, 18, 4, NULL, NULL),
(5, 19, 2, NULL, NULL),
(6, 20, 5, NULL, NULL),
(7, 21, 6, NULL, NULL);

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

--
-- Table structure for table `refund_requests`
--

CREATE TABLE `refund_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_details_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `status` varchar(191) NOT NULL,
  `approved_count` tinyint(4) NOT NULL DEFAULT 0,
  `denied_count` tinyint(4) NOT NULL DEFAULT 0,
  `amount` double(8,2) NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `refund_reason` longtext NOT NULL,
  `images` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `approved_note` longtext DEFAULT NULL,
  `rejected_note` longtext DEFAULT NULL,
  `payment_info` longtext DEFAULT NULL,
  `change_by` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `refund_statuses`
--

CREATE TABLE `refund_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `refund_request_id` bigint(20) UNSIGNED DEFAULT NULL,
  `change_by` varchar(191) DEFAULT NULL,
  `change_by_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `refund_transactions`
--

CREATE TABLE `refund_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_for` varchar(191) DEFAULT NULL,
  `payer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_receiver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `paid_by` varchar(191) DEFAULT NULL,
  `paid_to` varchar(191) DEFAULT NULL,
  `payment_method` varchar(191) DEFAULT NULL,
  `payment_status` varchar(191) DEFAULT NULL,
  `amount` double(8,2) DEFAULT NULL,
  `transaction_type` varchar(191) DEFAULT NULL,
  `order_details_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `refund_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `customer_id` bigint(20) NOT NULL,
  `delivery_man_id` bigint(20) DEFAULT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `comment` mediumtext DEFAULT NULL,
  `attachment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachment`)),
  `rating` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `is_saved` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_wallets`
--

CREATE TABLE `seller_wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) DEFAULT NULL,
  `total_earning` double NOT NULL DEFAULT 0,
  `withdrawn` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `commission_given` double(8,2) NOT NULL DEFAULT 0.00,
  `pending_withdraw` double(8,2) NOT NULL DEFAULT 0.00,
  `delivery_charge_earned` double(8,2) NOT NULL DEFAULT 0.00,
  `collected_cash` double(8,2) NOT NULL DEFAULT 0.00,
  `total_tax_collected` double(8,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_wallet_histories`
--

CREATE TABLE `seller_wallet_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `order_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `payment` varchar(191) NOT NULL DEFAULT 'received',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shipping_addresses`
--

CREATE TABLE `shipping_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` varchar(15) DEFAULT NULL,
  `is_guest` tinyint(4) NOT NULL DEFAULT 0,
  `contact_person_name` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address_type` varchar(20) NOT NULL DEFAULT 'home',
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `is_billing` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_addresses`
--

INSERT INTO `shipping_addresses` (`id`, `customer_id`, `is_guest`, `contact_person_name`, `email`, `address_type`, `address`, `city`, `zip`, `phone`, `created_at`, `updated_at`, `state`, `country`, `latitude`, `longitude`, `is_billing`) VALUES
(1, '79', 1, 'md rashed', 'mfn@gmail.com', 'home', 'savar ashulia', 'dhaka', '1341', '01670839055', NULL, NULL, NULL, 'Bangladesh', '85.05112877980659', '-180', 0),
(2, '382', 1, 'Burhan', 'burhanislam009@gmail.com', 'others', 'BD', 'Dhaka', '1206', '01710084184', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(3, '382', 1, 'Burhan', 'burhanislam009@gmail.com', 'others', 'BD', 'Dhaka', '1206', '01710084184', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(4, '382', 1, 'Burhan', 'burhanislam009@gmail.com', 'others', 'BD', 'Dhaka', '1206', '01710084184', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(5, '382', 1, 'Burhan', 'burhanislam009@gmail.com', 'others', 'BD', 'Dhaka', '1206', '01710084184', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(6, '382', 1, 'burhan', 'burhanislam009@gmail.com', 'others', 'BD', 'Dhaka', '1206', '01710084184', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(7, '858', 1, 'rtytt', 'tyt', 'permanent', 'tyrtyrtyrty', 'ytt', 'tyt', 'tytt', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(8, '858', 1, 'rtytt', 'tyt', 'permanent', 'tyrtyrtyrty', 'ytt', 'tyt', 'tytt', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(9, '860', 1, 'rtrr', 'ronybdxxx@gmail.com', 'permanent', 'dsfdsffr', 'sfsdf', 'sdfs', '01705517986', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(10, '860', 1, 'rtrr', 'ronybdxxx@gmail.com', 'permanent', 'dsfdsffr', 'sfsdf', 'sdfs', '01705517986', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(11, '904', 1, 'Nub', 'vh', 'permanent', 'Byg', 'Vuu', '123', '63', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(12, '904', 1, 'Nub', 'vh', 'permanent', 'Byg', 'Vuu', '123', '63', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(13, '904', 1, 'Byg', 'Gth', 'permanent', 'Hh', 'Hhy', 'Cbg', '336', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(14, '4317', 1, 'test', 'admin@admin.com', 'home', 'sdasdadasd', 'ddddd', '323233', '01710000000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(15, '4317', 1, 'test', 'admin@admin.com', 'home', 'sdasdadasd', 'ddddd', '323233', '01710000000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(16, '4317', 1, 'test', 'admin@admin.com', 'home', 'asdasdasd', 'asdasd', '12122', '01710000000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(17, '4317', 1, 'test', 'admin@admin.com', 'permanent', 'asasdadasdasdasd', 'eaweae', '322222', '01710000000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(18, '4317', 1, 'test', 'admin@admin.com', 'permanent', 'asasdadasdasdasd', 'eaweae', '322222', '01710000000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(19, '5689', 1, 'Oooooo', 'admin@admin.com', 'home', 'Hjiijh', 'Ggggg', 'Fgggg', '01710000000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(20, '6695', 1, 'Reed W', 'revenue29@gmail.com', 'home', '4278 W Jolly Rd', 'Lansing, MI', '48911', '5172728648', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(21, '6695', 1, 'Reed W', 'revenue29@gmail.com', 'home', '4278 W Jolly Rd', 'Lansing, MI', '48911', '5172728648', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(22, '6695', 1, 'Reed W', 'revenue29@gmail.com', 'home', '4278 W Jolly Rd', 'Lansing, MI', '48911', '5172728648', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(23, '7583', 1, 'vd', 'sharifulislamalauddin1@gmail.com', 'permanent', 'Shuvestu Najar Velly', 'Dhaka', '1212', '01320391581', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(24, '7583', 1, 'SALAH UDDIN', 'msisharife@gmail.com', 'permanent', 'Shuvestu Najar Velly', 'Dhaka', '1212', '01905057193', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(25, '7583', 1, 'hgjuyhgv', 'sharifulislamalauddin1@gmail.com', 'permanent', 'Shuvestu Najar Velly', 'Dhaka', '1212', '01320391581', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(26, '7880', 1, 'RAJU AHMAD', 'symul2000@gmail.com', 'permanent', 'Boro pool turning point', 'Dhaka', '7700', '01746636666', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(27, '7890', 1, 'Md. Shahidul Islam Jafor', 'shahidul.islam4750@gmail.com', 'permanent', 'Betagi', 'Barguna', '8730', '01722542773', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(28, '7890', 1, 'Md. Shahidul Islam Jafor', 'shahidul.islam4750@gmail.com', 'permanent', 'Betagi', 'Barguna', '8730', '01722542773', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(29, '7890', 1, 'Md. Shahidul Islam Jafor', 'shahidul.islam4750@gmail.com', 'permanent', 'Betagi', 'Barguna', '8730', '01722542773', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(30, '7946', 1, 'Lumen SoftTech Limited', 'princeabdulla006@gmail.com', 'permanent', 'GP CHA, 196/1 dhaka, dhaka', 'Gulshan, Dhaka', '1212', '01829317005', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(31, '7946', 1, 'Lumen SoftTech Limited', 'princeabdulla006@gmail.com', 'permanent', 'GP CHA, 196/1 dhaka, dhaka', 'Gulshan, Dhaka', '1212', '01829317005', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(32, '7946', 1, 'Lumen SoftTech Limited', 'princeabdulla006@gmail.com', 'permanent', 'GP CHA, 196/1 dhaka, dhaka', 'Gulshan, Dhaka', '1212', '01829317005', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(33, '7946', 1, 'Lumen SoftTech Limited', 'princeabdulla006@gmail.com', 'permanent', 'GP CHA, 196/1 dhaka, dhaka', 'Gulshan, Dhaka', '1212', '01829317005', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(34, '7949', 1, 'hhh', 'smakashhossain2@gmail.com', 'home', 'hhh', 'Dhaka', 'ygg', '01999999999', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(35, '8138', 1, 'dfgsdf', 'torboy696@gmail.com', 'home', 'dfgsdfgsdfgsdfg', 'sdfa', '544', 'dsfg', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(36, '8213', 1, 'khkq', 'info@elitedesin.com.bd', 'home', '240/d farmget', 'khulna', '1200', '01945898900', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(37, '8281', 1, 'Kukon Ali', 'regularmd@gmail.com', 'permanent', 'Dhaka', 'Dhaka', '1200', '01601280101', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(38, '8291', 1, 'Kukon', 'coderboss.mail@gmail.com', 'permanent', 'House12', 'Dhaka', '1230', '01601280101', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(39, '8291', 1, 'Kukon', 'coderboss.mail@gmail.com', 'permanent', 'House12', 'Dhaka', '1230', '01601280101', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(40, '8378', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(41, '8378', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(42, '8378', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(43, '8378', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(44, '3', 0, 'md shohidul', NULL, 'home', 'khulna', 'khulna', '9100', '01938282000', '2024-12-12 09:26:02', '2024-12-12 09:26:02', NULL, 'Bangladesh', NULL, NULL, 1),
(45, '0', 0, 'md shohidul', NULL, 'home', 'khulnakhulna', 'khulna', '9100', '01938282000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(46, '0', 0, 'md shohidul', NULL, 'home', 'khulna', 'khulna', '9100', '01938282000', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(47, '0', 0, 'md shohidul', NULL, 'home', 'khulnakhulna', 'khulna', '9100', '01938282000', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(48, '0', 0, 'md shohidul', NULL, 'home', 'khulna', 'khulna', '9100', '01938282000', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(49, '8604', 1, 'Firoz Ahmed Raju', 'info.firozraju@gmail.com', 'permanent', 'South Rasulpur, Kutubpur,', 'Narayanganj', '1421', '01791234505', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(50, '8604', 1, 'Firoz Ahmed Raju', 'info.firozraju@gmail.com', 'permanent', 'South Rasulpur, Kutubpur,', 'Narayanganj', '1421', '01791234505', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(51, '8604', 1, 'Firoz Ahmed Raju', 'info.firozraju@gmail.com', 'permanent', 'South Rasulpur, Kutubpur,', 'Narayanganj', '1421', '01791234505', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(52, '8604', 1, 'Firoz Ahmed Raju', 'info.firozraju@gmail.com', 'others', 'Narayanganj', 'Narayanganj', '1421', '01791234505', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(53, '8604', 1, 'Firoz Ahmed Raju', 'info.firozraju@gmail.com', 'permanent', 'South Rasulpur', 'Narayanganj', '1421', '01791234505', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(54, '8652', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(55, '8662', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(56, '8687', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(57, '8749', 1, 'mv', 'info@elitedesign.com.bd', 'home', 'ngfnhg et  ', 'Dhaka', '6500', '01716537329', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(58, '8749', 1, ' gr gs ', 'i', 'others', 'gfz sd  re r', ' fgef', '443', '01721885544', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(59, '8751', 1, 'Adnan Mahmud', 'redgreenit71@gmail.com', 'permanent', 'Mipur-2,Dhaka,Bangladesh', 'Dhaka', '1216', '01580392735', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(60, '8751', 1, 'Adnan Mahmud', 'redgreenit71@gmail.com', 'permanent', 'Mipur-2,Dhaka,Bangladesh', 'Dhaka', '1216', '01580392735', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(61, '8751', 1, 'Adnan Mahmud', 'redgreenit71@gmail.com', 'permanent', 'Dhaka, Bangladesh', 'Mirpur', '1216', '01580392735', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(62, '8751', 1, 'Red Green IT', 'redgreenit71@gmail.com', 'permanent', 'Mipur-2,Dhaka,Bangladesh', 'Dhaka', '1216', '01580392735', NULL, NULL, NULL, 'Bangladesh', '', '', 1),
(63, '8832', 1, 'Castor Wright', 'free512681@gmail.com', 'permanent', 'Aliqua Porro voluptatum soluta cupiditate aspernatur aspernatur dolores quod ipsam quis id aperiam incididunt consectetur qui quam eos', 'Aut autem mollitia i', 'WHITEHEAD ', '01744840059', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(64, '9039', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(65, '9101', 1, 'Mohammad Alamin', 'official.mohammadalamin.bd@gmail.com', 'permanent', 'Khulna , City', 'Khulna', '9200', '01400988766', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(66, '9124', 1, 'Rasel', 'admin.com', 'permanent', 'Ullapara', 'Sirajganj ', '6762', '01788041198', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(67, '9143', 1, 'ghh', 'jayedapu32@gmail.com', 'home', 'bbbjj', 'psss', '5000', '01741525852', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(68, '9189', 1, 'Michael Harrison', 'gigigigihg@gmail.com', 'permanent', 'ighfhv', 'Barisal', '8400', '09854920354', NULL, NULL, NULL, 'Bangladesh', '', '', 0),
(69, '9189', 1, 'Michael Harrison', 'gigigigihg@gmail.com', 'permanent', 'ighfhv', 'Barisal', '8400', '09854920354', NULL, NULL, NULL, 'Bangladesh', '', '', 0);

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

--
-- Table structure for table `shipping_methods`
--

CREATE TABLE `shipping_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `creator_id` bigint(20) DEFAULT NULL,
  `creator_type` varchar(191) NOT NULL DEFAULT 'admin',
  `title` varchar(100) DEFAULT NULL,
  `cost` decimal(8,2) NOT NULL DEFAULT 0.00,
  `duration` varchar(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_methods`
--

INSERT INTO `shipping_methods` (`id`, `creator_id`, `creator_type`, `title`, `cost`, `duration`, `status`, `created_at`, `updated_at`) VALUES
(2, 1, 'admin', 'Redex', 60.00, '2', 1, '2021-05-25 20:57:04', '2024-03-07 04:05:03'),
(9, 1, 'admin', 'Delivery Tiger', 60.00, '2', 1, '2024-03-07 04:05:22', '2024-03-07 04:05:22'),
(10, 1, 'admin', 'Pathao', 60.00, '2', 1, '2024-03-07 04:05:34', '2024-03-07 04:05:34'),
(11, 1, 'admin', 'SA Paribhan', 150.00, '7', 1, '2024-03-07 04:06:00', '2024-03-08 11:52:01'),
(12, 1, 'admin', 'Sundorban Courier Service', 150.00, '7', 1, '2024-03-07 04:06:20', '2024-03-08 11:51:51'),
(13, 1, 'admin', 'RedexBD', 120.00, '4 to 6 Days', 1, '2024-03-08 11:53:18', '2024-03-08 11:53:18');

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

--
-- Table structure for table `shipping_types`
--

CREATE TABLE `shipping_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED DEFAULT NULL,
  `shipping_type` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_types`
--

INSERT INTO `shipping_types` (`id`, `seller_id`, `shipping_type`, `created_at`, `updated_at`) VALUES
(1, 0, 'order_wise', '2024-03-07 09:42:43', '2024-03-07 09:42:43');

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

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

CREATE TABLE `shops` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(191) NOT NULL DEFAULT 'en',
  `address` varchar(255) NOT NULL,
  `contact` varchar(25) NOT NULL,
  `image` varchar(30) NOT NULL DEFAULT 'def.png',
  `bottom_banner` varchar(191) DEFAULT NULL,
  `offer_banner` varchar(255) DEFAULT NULL,
  `vacation_start_date` date DEFAULT NULL,
  `vacation_end_date` date DEFAULT NULL,
  `vacation_note` varchar(255) DEFAULT NULL,
  `vacation_status` tinyint(4) NOT NULL DEFAULT 0,
  `temporary_close` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `banner` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shop_followers`
--

CREATE TABLE `shop_followers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'Customer ID',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `social_medias`
--

CREATE TABLE `social_medias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `active_status` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_medias`
--

INSERT INTO `social_medias` (`id`, `name`, `link`, `icon`, `active_status`, `status`, `created_at`, `updated_at`) VALUES
(1, 'twitter', 'https://www.w3schools.com/howto/howto_css_table_responsive.asp', 'fa fa-twitter', 1, 1, '2020-12-31 21:18:03', '2020-12-31 21:18:25'),
(2, 'linkedin', 'https://dev.6amtech.com/', 'fa fa-linkedin', 1, 1, '2021-02-27 16:23:01', '2021-02-27 16:23:05'),
(3, 'google-plus', 'https://dev.6amtech.com/', 'fa fa-google-plus-square', 1, 1, '2021-02-27 16:23:30', '2021-02-27 16:23:33'),
(4, 'pinterest', 'https://dev.6amtech.com/', 'fa fa-pinterest', 1, 1, '2021-02-27 16:24:14', '2021-02-27 16:24:26'),
(5, 'instagram', 'https://dev.6amtech.com/', 'fa fa-instagram', 1, 1, '2021-02-27 16:24:36', '2021-02-27 16:24:41'),
(6, 'facebook', 'facebook.com', 'fa fa-facebook', 1, 1, '2021-02-27 19:19:42', '2021-06-11 17:41:59');

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

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

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `subject` varchar(150) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `priority` varchar(15) NOT NULL DEFAULT 'low',
  `description` varchar(255) DEFAULT NULL,
  `attachment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachment`)),
  `reply` varchar(255) DEFAULT NULL,
  `status` varchar(15) NOT NULL DEFAULT 'open',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_ticket_convs`
--

CREATE TABLE `support_ticket_convs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_ticket_id` bigint(20) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `customer_message` varchar(191) DEFAULT NULL,
  `attachment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachment`)),
  `admin_message` varchar(191) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tag` varchar(191) NOT NULL,
  `visit_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`id`, `tag`, `visit_count`, `created_at`, `updated_at`) VALUES
(1, 'Men\'s fashion', 51, '2024-03-08 07:47:04', '2024-12-22 13:32:05'),
(2, 'Punjabi', 83, '2024-03-08 07:47:04', '2024-12-22 20:59:59'),
(3, 'Men\'s Pant', 51, '2024-03-08 07:47:04', '2024-12-22 13:32:05'),
(4, 'Kid\'s Fashion', 61, '2024-03-08 07:50:16', '2024-12-23 00:11:02'),
(5, 'Shirts', 39, '2024-03-08 07:54:57', '2024-12-22 13:31:50'),
(6, 'Tops', 62, '2024-03-08 07:58:54', '2024-12-23 04:13:22');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `payment_for` varchar(100) DEFAULT NULL,
  `payer_id` bigint(20) DEFAULT NULL,
  `payment_receiver_id` bigint(20) DEFAULT NULL,
  `paid_by` varchar(15) DEFAULT NULL,
  `paid_to` varchar(15) DEFAULT NULL,
  `payment_method` varchar(15) DEFAULT NULL,
  `payment_status` varchar(10) NOT NULL DEFAULT 'success',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `amount` double(8,2) NOT NULL DEFAULT 0.00,
  `transaction_type` varchar(191) DEFAULT NULL,
  `order_details_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE `wallet_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transaction_id` char(36) NOT NULL,
  `credit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `debit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `admin_bonus` decimal(24,3) NOT NULL DEFAULT 0.000,
  `balance` decimal(24,3) NOT NULL DEFAULT 0.000,
  `transaction_type` varchar(191) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Table structure for table `withdrawal_methods`
--

CREATE TABLE `withdrawal_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `method_name` varchar(191) NOT NULL,
  `method_fields` text NOT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdraw_requests`
--

CREATE TABLE `withdraw_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) DEFAULT NULL,
  `delivery_man_id` bigint(20) DEFAULT NULL,
  `admin_id` bigint(20) DEFAULT NULL,
  `amount` varchar(191) NOT NULL DEFAULT '0.00',
  `withdrawal_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `withdrawal_method_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `transaction_note` text DEFAULT NULL,
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addon_settings`
--
ALTER TABLE `addon_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_settings_id_index` (`id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD UNIQUE KEY `transactions_id_unique` (`id`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `colors`
--
ALTER TABLE `colors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=144;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

