CREATE TABLE `email_template_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) DEFAULT NULL,
  `module` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `email_template_types` VALUES (1,'order_invoice_template',NULL,NULL,'2021-01-20 11:40:47'),(2,'order_pending_template',NULL,NULL,'2021-01-20 11:40:47'),(3,'order_confirmed_template',NULL,NULL,'2021-01-20 11:40:47'),(4,'order_declined_template',NULL,NULL,'2021-01-20 11:40:47'),(5,'paid_payment_template',NULL,NULL,'2021-01-20 11:40:47'),(6,'order_completed_template',NULL,NULL,'2021-01-20 11:40:47'),(7,'delivery_process_template',NULL,NULL,'2021-01-20 11:40:47'),(8,'refund_pending_template',NULL,NULL,'2021-01-20 11:40:47'),(9,'refund_confirmed_template',NULL,NULL,'2021-01-20 11:40:47'),(10,'refund_declined_template',NULL,NULL,'2021-01-20 11:40:47'),(11,'refund_money_paid_template',NULL,NULL,'2021-01-20 11:40:47'),(12,'refund_money_pending_template',NULL,NULL,'2021-01-20 11:40:47'),(13,'refund_completed_template',NULL,NULL,'2021-01-20 11:40:47'),(14,'refund_process_template',NULL,NULL,'2021-01-20 11:40:47'),(15,'gift_card_template',NULL,NULL,'2021-01-20 11:40:47'),(16,'review_email_template',NULL,NULL,'2021-01-20 11:40:47'),(17,'newsletter_email_template',NULL,NULL,'2021-01-20 11:40:47'),(18,'wallet_email_template',NULL,NULL,'2021-01-20 11:40:47'),(19,'order_email_template',NULL,NULL,'2021-01-20 11:40:47'),(20,'register_email_template',NULL,NULL,'2021-01-20 11:40:47'),(21,'notification_email_template',NULL,NULL,'2021-01-20 11:40:47'),(22,'support_ticket_email_template',NULL,NULL,'2021-01-20 11:40:47'),(23,'verification_email_template',NULL,NULL,'2021-01-20 11:40:47'),(24,'product_review_email_template',NULL,NULL,'2021-01-20 11:40:47'),(25,'subscription_payment_email_template','MultiVendor',NULL,'2021-01-20 11:40:47'),(26,'seller_approve_email_template','MultiVendor',NULL,'2021-01-20 11:40:47'),(27,'seller_suspended_email_template','MultiVendor',NULL,'2021-01-20 11:40:47'),(28,'product_disable_email_template',NULL,NULL,'2021-01-20 11:40:47'),(29,'product_approve_email_template','MultiVendor',NULL,'2021-01-20 11:40:47'),(30,'product_review_approve_email_template',NULL,NULL,'2021-01-20 11:40:47'),(31,'product_update_email_template',NULL,NULL,'2021-01-20 11:40:47'),(32,'withdraw_request_email_template',NULL,NULL,'2021-01-20 11:40:47'),(39,'seller_create_email_template','MultiVendor',NULL,'2021-01-20 11:40:47'),(40,'sub_seller_create_email_template','MultiVendor',NULL,'2021-01-20 11:40:47'),(41,'Password Reset',NULL,NULL,'2021-01-20 11:40:47'),(42,'Subscription email verify',NULL,NULL,'2021-01-20 11:40:47'),(43,'Send digital file',NULL,NULL,'2021-01-20 11:40:47'),(44,'new_user_registration_template',NULL,NULL,NULL),(45,'auction_bidder_template',NULL,NULL,'2023-03-24 11:40:47'),(46,'auction_seller_template',NULL,NULL,'2023-03-24 11:40:47'),(47,'auction_order_cancel_template',NULL,NULL,'2023-03-24 11:40:47');
CREATE TABLE `email_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type_id` varchar(191) DEFAULT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `relatable_type` varchar(191) DEFAULT NULL,
  `relatable_id` bigint(20) unsigned DEFAULT NULL,
  `reciepnt_type` varchar(191) DEFAULT NULL,
  `module` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `short_codes` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `email_templates` VALUES (1,'1','Order Invoice','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 16:59:42','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(2,'2','Order Pending','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 17:03:03','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(3,'3','Order Confirmation','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:17:18','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(4,'4','Order Declined','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:15:55','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(5,'5','Paid Payment','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:20:29','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(6,'6','Order Complete','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:18:21','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(7,'8','Refund Pending','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:18:07','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(8,'9','Refund Confirmation','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:17:52','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(9,'10','Refund Declined','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 17:00:32','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(10,'11','Refund Payment Paid','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 17:00:52','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(11,'12','Refund Payment Pending','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 17:01:15','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(12,'13','Refund Completed','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(152, 62, 81); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(152, 62, 81); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-23 11:19:59','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(13,'17','News Letter','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 17:02:21','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(14,'18','Wallet','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 17:02:38','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(15,'19','Order','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-24 16:59:14','{USER_FIRST_NAME},{ORDER_TRACKING_NUMBER},{EMAIL_SIGNATURE}'),(16,'20','Register','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:12:13','{USER_FIRST_NAME},{EMAIL_SIGNATURE}, {CUSTOM_MESSAGE}'),(17,'21','Notification','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:11:58','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(18,'22','Support Ticket','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:11:07','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(19,'23','Verify Email','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:10:50','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(20,'24','Product Review','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:10:34','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(24,'28','Product disable','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:08:46','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(26,'30','Product Review Approve','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:17:03','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(27,'31','Product Update','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:16:49','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(28,'32','Withdraw Request','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:16:34','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(29,'25','Subscription Payment','<div>Template</div><div><p style=\"color:rgb(85,85,85);\">Hello {USER_FIRST_NAME}<br><br>Subscription Payment Done.</p><p style=\"color:rgb(85,85,85);\"><br></p><p style=\"color:rgb(85,85,85);\">{EMAIL_SIGNATURE}</p><p style=\"color:rgb(85,85,85);\"><br></p></div><div>Template</div>',1,NULL,NULL,'[\"customer\"]','MultiVendor','2024-01-23 11:19:56','2024-01-26 04:10:17','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(30,'26','Seller Approve','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>Account has been approved.</p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]','MultiVendor','2024-01-23 11:19:56','2024-01-26 04:09:55','{USER_FIRST_NAME},{RESET_LINK},{EMAIL_SIGNATURE}'),(31,'27','Seller Suspended','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>Account has been suspoended.</p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\\\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]','MultiVendor','2024-01-23 11:19:56','2024-01-26 04:09:35','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(32,'29','Product Approve','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>Product Approved.</p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]','MultiVendor','2024-01-23 11:19:56','2024-01-26 04:08:29','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(33,'39','Seller Create','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>Seller Created .</p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]','MultiVendor','2024-01-23 11:19:56','2024-01-26 04:16:18','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(34,'40','Sub Seller Create','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>Sub Seller Created .</p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]','MultiVendor','2024-01-23 11:19:56','2024-01-26 04:15:38','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(35,'15','Gift card template','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px;border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>Here is the secret code of gift card.</p><p style=\"color: rgb(85, 85, 85);\">Please use the gift card to redeem the amount.</p><p style=\"\"><span style=\"color: rgb(85, 85, 85);\">product name: {GIFT_CARD_NAME}</span></p><p style=\"color: rgb(85, 85, 85);\">secret code : {SECRET_CODE}</p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,'2024-01-23 11:19:57','2024-01-24 17:02:03','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(36,'41','Password Reset','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello,<br><br>You are receiving this email because we received a password reset request for your account.</p><p style=\"color: rgb(85, 85, 85);\">Your reset link is :</p><p style=\"color: rgb(85, 85, 85);\">{RESET_LINK}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\",\"admin\",\"seller\"]',NULL,'2024-01-23 11:19:58','2024-01-26 04:14:54','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(37,'42','Subscription email verify','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello,<br><br>You are receiving this email because we received a Newsletter subscribe request.</p><p style=\"color: rgb(85, 85, 85);\">Your verify link is :</p><p style=\"color: rgb(85, 85, 85);\">{VERIFICATION_LINK}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\",\"admin\",\"seller\"]',NULL,'2024-01-23 11:19:58','2024-01-26 04:21:57','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(38,'43','Send digital file','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello,<br><br>You are receiving this email because of get access digital link.</p><p style=\"color: rgb(85, 85, 85);\">File access link is :</p><p style=\"color: rgb(85, 85, 85);\">{DIGITAL_FILE_LINK}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"customer\"]',NULL,'2024-01-23 11:19:58','2024-01-26 04:21:36','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(39,'44','New user has been Registred','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\"><br><img src=\"https://shop.school.edu.sl/public/uploads/editor-image/1680716990.PNG\" style=\"width: 25%;\"></h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello Admin<br>New customer has been Registered. Name: {CUSTOMER_NAME}. Email: {CUSTOMER_EMAIL}.</p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n                    <div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\"><br></h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"admin\"]',NULL,NULL,'2024-01-26 04:21:14','{USER_FIRST_NAME},{EMAIL_SIGNATURE}'),(40,'40','Winner of Auction','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>Auction has ended. You have been selected as Winner.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following link to confirm your order:</p><p style=\"color: rgb(85, 85, 85);\">{VERIFICATION_LINK}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>',1,NULL,NULL,'[\"customer\"]',NULL,NULL,'2024-01-26 04:15:13',NULL),(41,'41','Auction has Ended','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>The Auction has ended. Please check and select top bidder to award or increase auction end time.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following link to see the auction:</p><p style=\"color: rgb(85, 85, 85);\">{VERIFICATION_LINK}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"admin\",\"seller\"]',NULL,NULL,'2024-01-26 04:14:34',NULL),(42,'46','Awarded Bidder Cancelled the Order','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>The awarded bidder has cancelled the order.</p><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">Bidder name: {CUSTOMER_NAME}</p><p style=\"color: rgb(85, 85, 85);\">Bidding amount: {BIDDING_AMOUNT}</p><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to check auction list:</p><p style=\"color: rgb(85, 85, 85);\">{VERIFICATION_LINK}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div><div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>',1,NULL,NULL,'[\"admin\",\"seller\"]',NULL,NULL,'2024-01-26 04:20:50',NULL);
CREATE TABLE `events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `for_whom` varchar(191) NOT NULL,
  `location` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `facebook_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `code` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `facebook_messages` VALUES (1,0,NULL,'2024-01-23 11:19:57','2024-01-23 11:19:57');
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) 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(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `faqs` VALUES (1,NULL,'How does the site work? ','You can browse the site or use our search engine to find your desired products. You can then add them to your shopping bag and click on place order. You let us know your address, select a delivery time – and voila, you are done.',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(2,NULL,'How do I know when my order is here? ','A representative will call you as soon as they are at your house to let you know about your delivery.',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(3,NULL,' I can’t find the product I am looking for. What do I do? ','We are always open to new suggestions and will add an item to our inventory just for you. There is a \"Product Request\" feature that you can use to inform us of your requirement.',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(4,NULL,'What if the item is out of stock? ','We hold our own inventory in our warehouses, so we rarely run out of stock. However, we will try our best to source what you need. If we cannot find it, we will SMS/call you and let you know what substitutes are available.',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(5,NULL,' Why should we buy from you when I have a store nearby?','Well, that is up to you but you can also be a couch potato like our founders and have your items delivered to your house for free. Our prices are sometimes lower than that of major superstores in the city. We also carry a larger variety than the average corner store. So, there is really no reason to not buy from us. ',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(6,NULL,'What about the prices? ','Our prices are our own but we try our best to offer them to you at or below market prices. Our prices are the same as the local market and we are working hard to get them even lower! If you feel that any product is priced unfairly, please let us know. ',1,'2024-01-23 11:19:52','2024-01-23 11:19:52');
CREATE TABLE `features` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `icon` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `features_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `features` VALUES (1,'Great Value','Great Value','ti-cup',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(2,'Secured Shopping','Secured Shopping','ti-shield',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(3,'Worldwide Delivery','Worldwide Delivery','ti-truck',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(4,'24/7 Support','24/7 Support','ti-headphone-alt',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(5,'Easy Payment','Easy Payment','ti-server',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(6,'Portable Shopping','Portable Shopping','ti-shopping-cart-full',1,'2024-01-23 11:19:52','2024-01-23 11:19:52');
CREATE TABLE `flash_deal_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `flash_deal_id` bigint(20) unsigned NOT NULL,
  `seller_product_id` bigint(20) unsigned NOT NULL,
  `discount` double NOT NULL,
  `discount_type` tinyint(3) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `flash_deal_products_flash_deal_id_foreign` (`flash_deal_id`),
  KEY `flash_deal_products_seller_product_id_foreign` (`seller_product_id`),
  CONSTRAINT `flash_deal_products_flash_deal_id_foreign` FOREIGN KEY (`flash_deal_id`) REFERENCES `flash_deals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `flash_deal_products_seller_product_id_foreign` FOREIGN KEY (`seller_product_id`) REFERENCES `seller_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `flash_deal_products` VALUES (1,1,1,10,0,1,'2024-01-28 16:06:06','2024-01-28 16:06:06');
CREATE TABLE `flash_deals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `background_color` varchar(191) NOT NULL,
  `text_color` varchar(191) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `slug` varchar(191) NOT NULL,
  `banner_image` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `flash_deals_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `flash_deals` VALUES (1,'Flash Sale','white','#5b5b5b','2024-01-28','2024-02-29','flash-sale-1ahan','uploads/images/28-01-2024/65b6897e08866.jpeg',1,0,1,1,'2024-01-28 16:06:06','2024-01-28 16:06:21');
CREATE TABLE `follow_seller` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned NOT NULL,
  `seller_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `footer_contents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `about_title` text DEFAULT NULL,
  `about_description` text DEFAULT NULL,
  `copy_right` text DEFAULT NULL,
  `section_one_title` varchar(255) DEFAULT NULL,
  `section_two_title` varchar(255) DEFAULT NULL,
  `section_three_title` varchar(255) DEFAULT NULL,
  `play_store` varchar(300) DEFAULT '#',
  `app_store` varchar(300) DEFAULT '#',
  `payment_image` varchar(300) DEFAULT NULL,
  `show_play_store` tinyint(1) NOT NULL DEFAULT 0,
  `show_app_store` tinyint(1) NOT NULL DEFAULT 0,
  `show_payment_image` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `footer_contents` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'#','#','uploads/images/03-02-2024/65be054b4f180.png',1,1,1,'2024-01-23 11:19:58','2024-02-04 13:13:46');
CREATE TABLE `footer_widgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `category` varchar(191) NOT NULL,
  `page` varchar(191) NOT NULL,
  `section` varchar(191) NOT NULL,
  `is_static` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `footer_widgets` VALUES (1,NULL,'About Us','about-us','1','1','1',0,1,'2024-01-23 11:19:53','2024-01-23 11:19:53'),(2,NULL,'Blog','blog','1','3','1',0,1,'2024-01-23 11:19:53','2024-01-23 11:19:53'),(3,NULL,'Dashboard','profile/dashboard','2','17','2',0,1,'2024-01-23 11:19:53','2024-01-23 11:19:53'),(4,NULL,'My Profile','profile','2','5','2',0,1,'2024-01-23 11:19:53','2024-01-23 11:19:53'),(5,NULL,'My Order','my-purchase-orders','2','6','2',0,1,'2024-01-23 11:19:53','2024-01-23 11:19:53'),(6,NULL,'Help & Contact','contact-us','3','13','3',0,1,'2024-01-23 11:19:53','2024-01-23 11:19:53'),(7,NULL,'Become A Merchant','merchant','3','4','3',0,1,'2024-01-23 11:19:53','2024-02-04 13:22:58'),(8,NULL,'Return & Exchange','return-exchange','3','21','3',0,1,'2024-01-23 11:19:53','2024-01-23 11:19:53'),(9,1,'Return Policy','return-exchange','1','21','1',0,1,'2024-02-01 17:55:02','2024-02-03 13:45:39'),(11,1,'Terms & Conditions','terms-&-conditions','1','23','1',0,1,'2024-02-02 04:29:55','2024-02-02 04:29:55'),(12,1,'Privacy Policy','privacy-policy','1','25','1',0,1,'2024-02-03 08:18:25','2024-02-04 13:10:50'),(13,1,'Affiliates','affiliate','1','22','1',0,1,'2024-02-04 13:10:21','2024-02-04 13:11:26'),(14,1,'My wish list','my-wishlist','2','8','2',0,1,'2024-02-04 13:18:20','2024-02-04 13:18:20'),(15,1,'My coupons','profile/coupons','2','10','2',0,1,'2024-02-04 13:18:51','2024-02-04 13:18:51'),(16,1,'Support Tickets','support-ticket','2','15','2',0,1,'2024-02-04 13:19:43','2024-02-04 13:19:43'),(17,1,'Track Orders','track-order','2','14','2',0,1,'2024-02-04 13:22:17','2024-02-04 13:22:17');
CREATE TABLE `g_s_t_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `same_state_gst` text DEFAULT NULL,
  `outsite_state_gst` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `g_s_t_groups` VALUES (1,'London','{\"4\":20}','{\"4\":20}','2024-02-03 11:36:40','2024-02-03 11:36:40');
CREATE TABLE `general_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_title` varchar(191) DEFAULT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `country_id` bigint(20) unsigned DEFAULT 18,
  `state_id` bigint(20) unsigned DEFAULT 348,
  `city_id` bigint(20) unsigned DEFAULT 7291,
  `verify_on_newsletter` tinyint(1) NOT NULL DEFAULT 0,
  `seller_wise_payment` tinyint(1) NOT NULL DEFAULT 0,
  `country_name` varchar(191) DEFAULT NULL,
  `company_info` longtext DEFAULT NULL,
  `file_supported` text DEFAULT NULL,
  `zip_code` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `vat_number` varchar(191) DEFAULT NULL,
  `gst_number` varchar(191) DEFAULT NULL,
  `price_with_vat` varchar(191) NOT NULL DEFAULT '0',
  `address` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `currency` varchar(191) DEFAULT 'USD',
  `currency_symbol` varchar(191) DEFAULT '$',
  `promotionSetting` int(11) DEFAULT 0,
  `logo` varchar(191) NOT NULL DEFAULT '/uploads/settings/logo.png',
  `favicon` varchar(191) NOT NULL DEFAULT '/uploads/settings/favicon.png',
  `shop_link_banner` varchar(191) NOT NULL DEFAULT 'frontend/default/img/breadcrumb_bg.png',
  `system_version` varchar(191) DEFAULT '1.0',
  `active_status` int(11) DEFAULT 1,
  `currency_code` varchar(191) DEFAULT 'USD',
  `language_name` varchar(191) DEFAULT 'en',
  `system_purchase_code` varchar(191) DEFAULT NULL,
  `system_activated_date` date DEFAULT NULL,
  `envato_user` varchar(191) DEFAULT NULL,
  `envato_item_id` varchar(191) DEFAULT NULL,
  `system_domain` varchar(191) DEFAULT NULL,
  `copyright_text` varchar(191) DEFAULT NULL,
  `website_btn` int(11) NOT NULL DEFAULT 1,
  `dashboard_btn` int(11) NOT NULL DEFAULT 1,
  `report_btn` int(11) NOT NULL DEFAULT 1,
  `style_btn` int(11) NOT NULL DEFAULT 1,
  `ltl_rtl_btn` int(11) NOT NULL DEFAULT 1,
  `lang_btn` int(11) NOT NULL DEFAULT 1,
  `website_url` varchar(191) DEFAULT NULL,
  `ttl_rtl` int(11) NOT NULL DEFAULT 2,
  `phone_number_privacy` int(11) NOT NULL DEFAULT 1 COMMENT '1 = enable, 0 = disable',
  `time_zone` varchar(100) DEFAULT 'Asia/Dhaka',
  `language_code` varchar(100) DEFAULT 'en',
  `date_format_id` varchar(100) DEFAULT '1',
  `software_version` varchar(100) DEFAULT NULL,
  `mail_signature` varchar(191) DEFAULT NULL,
  `mail_header` varchar(191) DEFAULT NULL,
  `mail_footer` varchar(191) DEFAULT NULL,
  `mail_protocol` varchar(100) DEFAULT 'sendmail',
  `preloader` varchar(100) DEFAULT 'infix',
  `email_template` longtext DEFAULT NULL,
  `up_sale_product_display_title` varchar(150) DEFAULT 'Up Sale Products',
  `cross_sale_product_display_title` varchar(150) DEFAULT 'Cross Sale Products',
  `footer_about_title` varchar(191) NOT NULL DEFAULT 'About',
  `footer_about_description` text DEFAULT NULL,
  `footer_copy_right` text DEFAULT NULL,
  `footer_section_one_title` varchar(191) NOT NULL DEFAULT 'Company',
  `footer_section_two_title` varchar(191) NOT NULL DEFAULT 'My Account',
  `footer_section_three_title` varchar(191) NOT NULL DEFAULT 'Services',
  `maintenance_title` varchar(191) DEFAULT NULL,
  `maintenance_subtitle` varchar(191) DEFAULT NULL,
  `maintenance_banner` varchar(191) DEFAULT NULL,
  `maintenance_status` tinyint(1) NOT NULL DEFAULT 0,
  `auto_approve_wallet_status` tinyint(1) NOT NULL DEFAULT 0,
  `auto_approve_seller` tinyint(1) NOT NULL DEFAULT 1,
  `auto_approve_product_review` tinyint(1) NOT NULL DEFAULT 0,
  `auto_approve_seller_review` tinyint(1) NOT NULL DEFAULT 0,
  `track_order_by_secret_id` tinyint(1) NOT NULL DEFAULT 0,
  `track_order_by_phone` tinyint(1) NOT NULL DEFAULT 1,
  `facebook_client_id` varchar(191) DEFAULT NULL,
  `facebook_client_secret` varchar(191) DEFAULT NULL,
  `facebook_status` tinyint(1) NOT NULL DEFAULT 1,
  `google_client_id` varchar(191) DEFAULT NULL,
  `google_client_secret` varchar(191) DEFAULT NULL,
  `google_status` tinyint(1) NOT NULL DEFAULT 1,
  `twitter_client_id` varchar(191) DEFAULT NULL,
  `twitter_client_secret` varchar(191) DEFAULT NULL,
  `twitter_status` tinyint(1) NOT NULL DEFAULT 0,
  `linkedin_client_id` varchar(191) DEFAULT NULL,
  `linkedin_client_secret` varchar(191) DEFAULT NULL,
  `linkedin_status` tinyint(1) NOT NULL DEFAULT 0,
  `facebook` varchar(191) DEFAULT NULL,
  `twitter` varchar(191) DEFAULT NULL,
  `linkedin` varchar(191) DEFAULT NULL,
  `instagram` varchar(191) DEFAULT NULL,
  `multi_category` tinyint(1) NOT NULL DEFAULT 1,
  `commission_by` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `currency_symbol_position` varchar(191) NOT NULL DEFAULT 'left_with_space',
  `decimal_limit` int(10) unsigned NOT NULL DEFAULT 2,
  `default_country` bigint(20) unsigned DEFAULT 18,
  `default_state` bigint(20) unsigned DEFAULT 348,
  `guest_checkout` tinyint(1) NOT NULL DEFAULT 1,
  `category_show_in_frontend` varchar(10) NOT NULL DEFAULT 'all',
  `meta_site_title` varchar(191) DEFAULT NULL,
  `meta_tags` longtext DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `preloader_type` tinyint(3) unsigned DEFAULT 1,
  `preloader_status` tinyint(1) NOT NULL DEFAULT 1,
  `preloader_style` int(10) unsigned NOT NULL DEFAULT 0,
  `preloader_image` varchar(255) DEFAULT NULL,
  `product_subtitle_show` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `disable_seller_plan` int(11) NOT NULL DEFAULT 0,
  `user_login_checkout` int(11) NOT NULL DEFAULT 0,
  `user_manual_activation` int(11) NOT NULL DEFAULT 1,
  `registration_success_url` text DEFAULT NULL,
  `WholeSale` int(11) DEFAULT 1,
  `Affiliate` int(11) DEFAULT 1,
  `ClubPoint` int(11) DEFAULT 1,
  `AuctionProducts` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `general_settings` VALUES (1,'eMarket Zone','GB Group 3D Decor LTD',230,3866,42219,1,1,'BD',NULL,'pdf,txt,csv','NW4 4QR',NULL,NULL,'GB 457 0133 11','GB 457 0133 11','0','11 J Sunningfields Road, London, United Kingdom NW4 4QR','+447496805021','office@emarketzone.com','2','$',0,'uploads/settings/65b64e1daadf0.png','uploads/settings/65b6504cbfe37.png','frontend/default/img/breadcrumb_bg.png','3.9.1',1,'USD','en',NULL,'2024-01-23',NULL,NULL,'https://www.emarketzone.com','Copyright © 2019. All rights reserved',1,1,1,1,1,1,NULL,2,1,'Europe/London','en','8','3.9.1','eMarket Zone','Mail Header','Mail footer','smtp','AmazCart','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(152, 62, 81); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"><p style=\"color: rgb(85, 85, 85);\">Hello {USER_FIRST_NAME}<br><br>An account has been created for you.</p><p style=\"color: rgb(85, 85, 85);\">Please use the following info to login your dashboard:</p><p style=\"color: rgb(85, 85, 85);\">{ORDER_TRACKING_NUMBER}<br></p><hr style=\"box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85);\"><br></p><p style=\"color: rgb(85, 85, 85);\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85);\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(152, 62, 81); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>','Up Sale Products','Cross Sale Products','About','Welcome to Emarket Zone. We are a dynamic trading company dedicated to providing a comprehensive platform for traders worldwide to connect, engage, and prosper in the global marketplace. At Emarket Zone, we understand the complexities of modern trading and the importance of access to diverse markets and products. That\'s why we offer a range of innovative solutions tailored to meet the needs of traders of all levels, from seasoned professionals to aspiring enthusiasts. Our platform serves as a gateway to a world of trading possibilities, offering an intuitive interface, robust trading tools, and unparalleled market insights. In addition to our own trading services, we also empower fellow traders to showcase their products and services on our platform. Through our collaborative marketplace, traders can expand their reach, connect with new customers, and grow their businesses with ease. We are committed to fostering a vibrant trading community built on trust, transparency, and mutual success. Join us today and experience the next evolution in trading excellence.','<font color=\"#424242\">Copyright © 2024. eMarket Zone</font>','Company','My Account','Services',NULL,NULL,NULL,0,1,0,0,0,1,1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,1,1,'left_with_space',2,230,3866,1,'all','eMarket Zone','Emarket, market, multivendor, multivendor market, multivendor emarket,shop for rent,online shop, online shopping,worldwide shipping,special offer','Welcome to Emarket Zone. We are a dynamic trading company dedicated to providing a comprehensive platform for traders worldwide to connect, engage, and prosper in the global marketplace. At Emarket Zone, we understand the complexities of modern trading and the importance of access to diverse markets and products. That\'s why we offer a range of innovative solutions tailored to meet the needs of traders of all levels, from seasoned professionals to aspiring enthusiasts. Our platform serves as a gateway to a world of trading possibilities, offering an intuitive interface, robust trading tools, and unparalleled market insights. In addition to our own trading services, we also empower fellow traders to showcase their products and services on our platform. Through our collaborative marketplace, traders can expand their reach, connect with new customers, and grow their businesses with ease. We are committed to fostering a vibrant trading community built on trust, transparency, and mutual success. Join us today and experience the next evolution in trading excellence.',2,1,0,'uploads/settings/65aff08a824b0.gif',0,NULL,'2024-03-04 13:28:44',0,0,0,'https://www.emarketzone.com/new-user-zone/new-user-gifts-jck47',1,1,1,1);
CREATE TABLE `gift_card_galary_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gift_card_id` bigint(20) unsigned NOT NULL,
  `image_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `gift_card_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gift_card_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,
  PRIMARY KEY (`id`),
  KEY `gift_card_tag_gift_card_id_foreign` (`gift_card_id`),
  KEY `gift_card_tag_tag_id_foreign` (`tag_id`),
  CONSTRAINT `gift_card_tag_gift_card_id_foreign` FOREIGN KEY (`gift_card_id`) REFERENCES `gift_cards` (`id`) ON DELETE CASCADE,
  CONSTRAINT `gift_card_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `gift_card_uses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gift_card_id` bigint(20) unsigned NOT NULL,
  `qty` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT 0,
  `secret_code` varchar(191) DEFAULT NULL,
  `mail_sent_date` date DEFAULT NULL,
  `is_mail_sent` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `gift_cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `sku` varchar(191) NOT NULL,
  `selling_price` double NOT NULL,
  `thumbnail_image` varchar(191) DEFAULT NULL,
  `discount` double DEFAULT 0,
  `discount_type` tinyint(3) unsigned DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0,
  `avg_rating` double NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `shipping_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `gift_coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gift_selling_coupon` varchar(191) DEFAULT NULL,
  `add_gift_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gift_coupons_add_gift_id_foreign` (`add_gift_id`),
  CONSTRAINT `gift_coupons_add_gift_id_foreign` FOREIGN KEY (`add_gift_id`) REFERENCES `add_gift_cards` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `parent_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `sort_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `groups_parent_id_foreign` (`parent_id`),
  CONSTRAINT `groups_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `gst_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `tax_percentage` double(8,2) NOT NULL DEFAULT 0.00,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gst_taxes_created_by_foreign` (`created_by`),
  KEY `gst_taxes_updated_by_foreign` (`updated_by`),
  CONSTRAINT `gst_taxes_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `gst_taxes_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `gst_taxes` VALUES (1,'CGST',0.00,0,NULL,1,'2021-05-05 03:34:36','2024-02-03 11:35:39'),(2,'SGST',0.00,0,NULL,1,'2021-05-05 03:42:18','2024-02-03 11:35:34'),(3,'IGST',0.00,0,NULL,1,'2021-05-05 03:42:40','2024-02-03 11:35:27'),(4,'VAT',20.00,1,1,1,'2024-01-31 04:34:14','2024-01-31 04:34:14');
CREATE TABLE `guest_order_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `guest_id` varchar(255) DEFAULT NULL,
  `billing_name` varchar(255) DEFAULT NULL,
  `billing_email` varchar(255) DEFAULT NULL,
  `billing_phone` varchar(255) DEFAULT NULL,
  `billing_address` varchar(255) DEFAULT NULL,
  `billing_city_id` bigint(20) unsigned DEFAULT NULL,
  `billing_state_id` bigint(20) unsigned DEFAULT NULL,
  `billing_country_id` bigint(20) unsigned DEFAULT NULL,
  `billing_post_code` bigint(20) unsigned DEFAULT NULL,
  `shipping_name` varchar(255) DEFAULT NULL,
  `shipping_email` varchar(255) DEFAULT NULL,
  `shipping_phone` varchar(255) DEFAULT NULL,
  `shipping_address` varchar(255) DEFAULT NULL,
  `shipping_city_id` bigint(20) unsigned DEFAULT NULL,
  `shipping_state_id` bigint(20) unsigned DEFAULT NULL,
  `shipping_country_id` bigint(20) unsigned DEFAULT NULL,
  `shipping_post_code` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `header_category_panels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_newtab` tinyint(1) NOT NULL,
  `position` bigint(20) unsigned NOT NULL DEFAULT 986754,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `header_new_user_zone_panels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `navigation_label` varchar(191) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `pricing` varchar(191) DEFAULT NULL,
  `new_user_zone_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `header_new_user_zone_panels` VALUES (1,'New User Zone','Get your coupon','usd 5',1,'2024-01-23 11:19:54','2024-01-23 11:19:54');
CREATE TABLE `header_product_panels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_newtab` tinyint(1) NOT NULL,
  `position` bigint(20) unsigned NOT NULL DEFAULT 986754,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `header_slider_panels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `url` text DEFAULT NULL,
  `data_type` varchar(191) DEFAULT NULL,
  `data_id` bigint(20) unsigned DEFAULT NULL,
  `slider_image` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_newtab` tinyint(1) NOT NULL DEFAULT 1,
  `position` int(10) unsigned NOT NULL DEFAULT 598776,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `header_slider_panels` VALUES (1,'Banner1',NULL,'product',1,'uploads/images/28-01-2024/65b66dc5439d5.jpeg',1,0,598776,'2024-01-28 14:07:49','2024-01-28 14:07:49'),(2,'Banner2',NULL,'product',1,'uploads/images/28-01-2024/65b66ddc530a0.jpeg',1,0,598776,'2024-01-28 14:08:12','2024-01-28 14:08:12'),(3,'Banner3',NULL,'product',1,'uploads/images/28-01-2024/65b66e0760f76.jpeg',1,0,598776,'2024-01-28 14:08:55','2024-01-28 14:08:55');
CREATE TABLE `headers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `column_size` varchar(191) NOT NULL,
  `is_enable` tinyint(1) NOT NULL DEFAULT 1,
  `is_full_row` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `headers` VALUES (1,'Slider Section','slider','8 column',1,0,'2024-01-23 11:19:54','2024-01-28 14:57:59'),(2,'Category Section','category','4 column',1,0,'2024-01-23 11:19:54','2024-01-23 11:19:54'),(3,'Product Section','product','8 column',1,0,'2024-01-23 11:19:54','2024-01-23 11:19:54'),(4,'New User Zone Section','new_user_zone','4 column',1,0,'2024-01-23 11:19:54','2024-01-23 11:19:54');
CREATE TABLE `holidays` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `year` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 =>single 1 => multiple',
  `date` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `home_page_custom_sections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint(20) unsigned NOT NULL,
  `field_1` varchar(191) DEFAULT NULL,
  `field_2` varchar(191) DEFAULT NULL,
  `field_3` varchar(191) DEFAULT NULL,
  `field_4` varchar(500) DEFAULT NULL,
  `field_5` varchar(500) DEFAULT NULL,
  `field_6` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `home_page_custom_sections` VALUES (1,7,'2','uploads/images/03-03-2024/65e44d1570873.jpeg',NULL,NULL,NULL,NULL,'2024-01-23 11:19:58','2024-03-03 09:13:28'),(2,10,NULL,NULL,NULL,NULL,NULL,NULL,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(3,11,NULL,NULL,NULL,NULL,NULL,NULL,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(4,12,NULL,NULL,NULL,NULL,NULL,NULL,'2024-01-23 11:19:58','2024-01-23 11:19:58');
CREATE TABLE `home_page_sections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `section_name` varchar(191) NOT NULL,
  `title` varchar(191) NOT NULL,
  `section_for` int(10) unsigned NOT NULL,
  `column_size` varchar(191) NOT NULL,
  `type` int(10) unsigned DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `theme` varchar(191) NOT NULL DEFAULT 'default',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `home_page_sections` VALUES (1,'best_deals','Best Deals',1,'col-lg-12',4,1,'default, amazy','2024-01-23 11:19:53','2024-01-23 11:19:59'),(2,'top_brands','Top Brands',3,'col-lg-6',2,1,'default, amazy','2024-01-23 11:19:53','2024-01-23 11:19:59'),(3,'top_picks','Top Picks',1,'col-lg-6',2,1,'default, amazy','2024-01-23 11:19:53','2024-03-03 09:08:50'),(4,'feature_categories','Feature Categories',2,'col-lg-12',6,1,'default, amazy','2024-01-23 11:19:53','2024-02-21 03:27:38'),(5,'more_products','MORE PRODUCTS THAT YOU MAY LOVE',1,'col-lg-12',3,1,'default, amazy','2024-01-23 11:19:53','2024-01-23 11:19:59'),(6,'top_bar','Top Bar',1,'col-lg-12',3,1,'default, amazy','2024-01-23 11:19:53','2024-01-23 11:19:59'),(7,'filter_category_1','House Appliances',4,'col-lg-12',1,1,'amazy','2024-01-23 11:19:58','2024-01-23 11:19:58'),(8,'top_rating','Top Rating',1,'col-lg-12',5,1,'amazy','2024-01-23 11:19:58','2024-01-23 11:19:58'),(9,'people_choices','People Choices',1,'col-lg-12',3,1,'amazy','2024-01-23 11:19:58','2024-01-23 11:19:58'),(10,'discount_banner','Discount Banner',4,'col-lg-12',1,1,'amazy','2024-01-23 11:19:58','2024-01-23 11:19:58'),(11,'filter_category_2','Electronics',4,'col-lg-12',1,1,'amazy','2024-01-23 11:19:58','2024-01-23 11:19:58'),(12,'filter_category_3','Fashion',4,'col-lg-12',1,1,'amazy','2024-01-23 11:19:58','2024-01-23 11:19:58'),(13,'popular_search','Popular Searches',5,'col-lg-12',3,1,'amazy','2024-01-23 11:19:59','2024-01-23 11:19:59'),(14,'about_section','About',5,'col-lg-12',3,1,'amazy','2024-01-23 11:19:59','2024-01-27 14:54:46');
CREATE TABLE `homepage_custom_brands` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint(20) unsigned NOT NULL,
  `brand_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `homepage_custom_brands_section_id_foreign` (`section_id`),
  KEY `homepage_custom_brands_brand_id_foreign` (`brand_id`),
  CONSTRAINT `homepage_custom_brands_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE,
  CONSTRAINT `homepage_custom_brands_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `home_page_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `homepage_custom_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `homepage_custom_categories_section_id_foreign` (`section_id`),
  KEY `homepage_custom_categories_category_id_foreign` (`category_id`),
  CONSTRAINT `homepage_custom_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `homepage_custom_categories_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `home_page_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `homepage_custom_categories` VALUES (3,4,1,'2024-03-03 09:09:17','2024-03-03 09:09:17'),(4,4,3,'2024-03-03 09:09:17','2024-03-03 09:09:17'),(5,4,12,'2024-03-03 09:09:17','2024-03-03 09:09:17');
CREATE TABLE `homepage_custom_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint(20) unsigned NOT NULL,
  `seller_product_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `homepage_custom_products_section_id_foreign` (`section_id`),
  KEY `homepage_custom_products_seller_product_id_foreign` (`seller_product_id`),
  CONSTRAINT `homepage_custom_products_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `home_page_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `homepage_custom_products_seller_product_id_foreign` FOREIGN KEY (`seller_product_id`) REFERENCES `seller_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `ignore_ip` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `image_refund_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `refund_request_id` bigint(20) unsigned NOT NULL,
  `image` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `in_queries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `in_queries` VALUES (1,NULL,'Order',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(2,NULL,'Payment',1,'2024-01-23 11:19:52','2024-01-23 11:19:52'),(3,NULL,'Product',1,'2024-01-23 11:19:52','2024-01-23 11:19:52');
CREATE TABLE `infix_module_managers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `version` varchar(200) DEFAULT NULL,
  `update_url` text DEFAULT NULL,
  `purchase_code` text DEFAULT NULL,
  `installed_domain` text DEFAULT NULL,
  `checksum` text DEFAULT NULL,
  `activated_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `infix_module_managers` VALUES (1,'MultiVendor','support@spondonit.com','This is Multi Vendor Module for Amazcart. After install this module, system will converted to multi vendor ecommerce. Amazcart version required 3.7.5','v1.9.5','https://spondonit.com/contact','476a8546-c631-42d2-a243-398a1547a5e9','https://www.emarketzone.com','712c41ff-65a6-4c8e-93f7-eac6498ac643','2024-01-23','2024-01-23 11:19:51','2024-01-23 11:19:59'),(2,'WholeSale','nedkox@gmail.com','This is WholeSale module for Amazcart. Thanks for using. Amazcrt version required 3.8','1.4','https://spondonit.com/contact','a2c8c673-daaf-4be2-b2a9-1ada83d7b8f9','https://www.emarketzone.com','eyJpdiI6InNpV2loS0tPT2I2OW9ncFlRajl2Rmc9PSIsInZhbHVlIjoiS2lwNlZTdEFZZFc4d2dpT3ltaDhHTVZQS28wdGN5MklLZmxwRDV6aVczOWQrbTdldDIydmxiTjdBMW9ueGRvaCIsIm1hYyI6IjZmMjJiMDE0NGNhMmJiMjkzODQ4NGU3ZmVmMTJhMTljZGM4N2RjNjEwZTk5NmNjOGIzNWI5OGJhOTQ3MTRiODEiLCJ0YWciOiIifQ==','2024-01-23','2024-01-23 15:53:42','2024-01-23 15:53:42'),(3,'Affiliate','nedkox@gmail.com','This is Affiliate module for Amazcart. Thanks for using. Amazcrt version required 3.8','2.0','https://spondonit.com/contact','8f842a9a-52ad-40fd-8b1b-e32be4f68da2','https://www.emarketzone.com','eyJpdiI6Im9QN2V6a1MxVXRNZ3lVTDMyTGEwZHc9PSIsInZhbHVlIjoiS3pPaVVhRmlwWlhyODQ1UkNEM2N0dTBqSzFiUjZJMUZaWXJBdFhFaVduMWk3bThKajkwam5hRklNaElqUzhobiIsIm1hYyI6ImE3MmJjN2JkNmI1Yzc1Mjc2ZTI4OWY2NjkzNmNmYjJlZjdjN2I0YzlhN2YxYTJlYmJlZWQ4ZjFjZTFkYWRmOWEiLCJ0YWciOiIifQ==','2024-01-23','2024-01-23 15:55:19','2024-01-23 15:55:19'),(4,'ClubPoint','nedkox@gmail.com','This is ClubPoint module for Amazcart. Thanks for using. Amazcrt version required 3.8','1.3','https://spondonit.com/contact','c2d0c827-ebed-4a5c-9c41-a7a6100e9b1b','https://www.emarketzone.com','eyJpdiI6ImUrRUV6YW9DMzI0SWsrNWVXMTE5eGc9PSIsInZhbHVlIjoiYlpiWDA1eFJKRTc3SXlJNGovVFhYeU52ZzRvZkdqaXpLQ1NVOFpZYlg1SXhFWHRoODF2VXVEOWtrS3hHWDA2eks3MXlwdlhQNG1Ib1BrNGtWTWttZURmVzhuQnVXcEw0cUxQNWdKZElaMEQ1Ky8zRWxWZ3hmT0tDQmhqMEFtMUFMRzluU3d4Ykd2OTJIL3AzajFocHBRPT0iLCJtYWMiOiIwMGNmYzE5NjVhNGM4YjIxNjhlZTllYWQxZTgxYmE0Y2ZkZDRhOTg2MGI3MGJhMjcyMWQ4YjQ5MTk3NDY1MDExIiwidGFnIjoiIn0=','2024-01-23','2024-01-23 15:56:20','2024-01-23 15:56:20'),(5,'AuctionProducts','nedkox@gmail.com','This is Auction module for Amazcart. Thanks for using. Amazcrt version required 3.9','1.0','https://spondonit.com/contact','16ad7fc0-d626-4823-b4dd-e28d6fb21bce','https://www.emarketzone.com','eyJpdiI6InVqR1paZi9FcXFqa2dMZEVUVHBleEE9PSIsInZhbHVlIjoiTG9WbjkrM1JtelRxQkVtS3dKZU5yVUVoNmV1TFZiMHVjdDRTMDE5UGlNUUs0YUpGOXUreW9mbTJ1b1Q5VXliWWpBL3ZIUGNiQWlOOVpmdmozTE0valNHL1RhekxVaHhza3o0aGZaTHRibk8xaGkzZVkrRWl3blU1aWZqcXZpN1BVUlFwNmU4MzB0cUZXaFpPd1M5RlVnPT0iLCJtYWMiOiJkYzY3MmEyNDJiZGQxMWI5YjE3YmRjNGY4OTQ1MDU2NWM5YjdhOTI3MjcyY2I3MzkyMjI3ZGQzZjg3YjdmMmYwIiwidGFnIjoiIn0=','2024-01-23','2024-01-23 15:57:33','2024-01-23 15:57:33');
CREATE TABLE `inhouse_order_carts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `seller_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `qty` int(10) unsigned NOT NULL DEFAULT 1,
  `price` double NOT NULL DEFAULT 0,
  `total_price` double NOT NULL DEFAULT 0,
  `sku` varchar(191) DEFAULT NULL,
  `is_select` tinyint(1) NOT NULL DEFAULT 1,
  `shipping_method_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `inhouse_order_carts_seller_id_foreign` (`seller_id`),
  KEY `inhouse_order_carts_product_id_foreign` (`product_id`),
  CONSTRAINT `inhouse_order_carts_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `seller_product_s_k_us` (`id`) ON DELETE CASCADE,
  CONSTRAINT `inhouse_order_carts_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `intro_prefix` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `prefix` varchar(191) NOT NULL,
  `title` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `label_configs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `condition` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `native` varchar(191) NOT NULL,
  `rtl` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `json_exist` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `languages` VALUES (1,'af','Afrikaans','Afrikaans',0,0,0,NULL,NULL),(2,'am','Amharic','አማርኛ',0,0,0,NULL,NULL),(3,'ar','Arabic','العربية',1,0,0,NULL,'2024-01-25 10:11:51'),(4,'ay','Aymara','Aymar',0,0,0,NULL,NULL),(5,'az','Azerbaijani','Azərbaycanca / آذربايجان',0,0,0,NULL,NULL),(6,'be','Belarusian','Беларуская',0,0,0,NULL,NULL),(7,'bg','Bulgarian','Български',0,0,0,NULL,NULL),(8,'bi','Bislama','Bislama',0,0,0,NULL,NULL),(9,'bn','Bengali','বাংলা',0,0,0,NULL,'2024-01-25 10:11:57'),(10,'bs','Bosnian','Bosanski',0,0,0,NULL,NULL),(11,'ca','Catalan','Català',0,0,0,NULL,NULL),(12,'ch','Chamorro','Chamoru',0,0,0,NULL,NULL),(13,'cs','Czech','Česky',0,0,0,NULL,NULL),(14,'da','Danish','Dansk',0,0,0,NULL,NULL),(15,'de','German','Deutsch',0,0,0,NULL,NULL),(16,'dv','Divehi','ދިވެހިބަސް',1,0,0,NULL,NULL),(17,'dz','Dzongkha','ཇོང་ཁ',0,0,0,NULL,NULL),(18,'el','Greek','Ελληνικά',0,0,0,NULL,NULL),(19,'en','English','English',0,1,0,NULL,NULL),(20,'es','Spanish','Español',0,0,0,NULL,NULL),(21,'et','Estonian','Eesti',0,0,0,NULL,NULL),(22,'eu','Basque','Euskara',0,0,0,NULL,NULL),(23,'fa','Persian','فارسی',1,0,0,NULL,NULL),(24,'ff','Peul','Fulfulde',0,0,0,NULL,NULL),(25,'fi','Finnish','Suomi',0,0,0,NULL,NULL),(26,'fj','Fijian','Na Vosa Vakaviti',0,0,0,NULL,NULL),(27,'fo','Faroese','Føroyskt',0,0,0,NULL,NULL),(28,'fr','French','Français',0,0,0,NULL,NULL),(29,'ga','Irish','Gaeilge',0,0,0,NULL,NULL),(30,'gl','Galician','Galego',0,0,0,NULL,NULL),(31,'gn','Guarani','Avañe\'ẽ',0,0,0,NULL,NULL),(32,'gv','Manx','Gaelg',0,0,0,NULL,NULL),(33,'he','Hebrew','עברית',1,0,0,NULL,NULL),(34,'hi','Hindi','हिन्दी',0,0,0,NULL,NULL),(35,'hr','Croatian','Hrvatski',0,0,0,NULL,NULL),(36,'ht','Haitian','Krèyol ayisyen',0,0,0,NULL,NULL),(37,'hu','Hungarian','Magyar',0,0,0,NULL,NULL),(38,'hy','Armenian','Հայերեն',0,0,0,NULL,NULL),(39,'indo','Indonesian','Bahasa Indonesia',0,0,0,NULL,NULL),(40,'is','Icelandic','Íslenska',0,0,0,NULL,NULL),(41,'it','Italian','Italiano',0,0,0,NULL,NULL),(42,'ja','Japanese','日本語',0,0,0,NULL,NULL),(43,'ka','Georgian','ქართული',0,0,0,NULL,NULL),(44,'kg','Kongo','KiKongo',0,0,0,NULL,NULL),(45,'kk','Kazakh','Қазақша',0,0,0,NULL,NULL),(46,'kl','Greenlandic','Kalaallisut',0,0,0,NULL,NULL),(47,'km','Cambodian','ភាសាខ្មែរ',0,0,0,NULL,NULL),(48,'ko','Korean','한국어',0,0,0,NULL,NULL),(49,'ku','Kurdish','Kurdî / كوردی',1,0,0,NULL,NULL),(50,'ky','Kirghiz','Kırgızca / Кыргызча',0,0,0,NULL,NULL),(51,'la','Latin','Latina',0,0,0,NULL,NULL),(52,'lb','Luxembourgish','Lëtzebuergesch',0,0,0,NULL,NULL),(53,'ln','Lingala','Lingála',0,0,0,NULL,NULL),(54,'lo','Laotian','ລາວ / Pha xa lao',0,0,0,NULL,NULL),(55,'lt','Lithuanian','Lietuvių',0,0,0,NULL,NULL),(56,'lu','','',0,0,0,NULL,NULL),(57,'lv','Latvian','Latviešu',0,0,0,NULL,NULL),(58,'mg','Malagasy','Malagasy',0,0,0,NULL,NULL),(59,'mh','Marshallese','Kajin Majel / Ebon',0,0,0,NULL,NULL),(60,'mi','Maori','Māori',0,0,0,NULL,NULL),(61,'mk','Macedonian','Македонски',0,0,0,NULL,NULL),(62,'mn','Mongolian','Монгол',0,0,0,NULL,NULL),(63,'ms','Malay','Bahasa Melayu',0,0,0,NULL,NULL),(64,'mt','Maltese','bil-Malti',0,0,0,NULL,NULL),(65,'my','Burmese','မြန်မာစာ',0,0,0,NULL,NULL),(66,'na','Nauruan','Dorerin Naoero',0,0,0,NULL,NULL),(67,'nb','','',0,0,0,NULL,NULL),(68,'nd','North Ndebele','Sindebele',0,0,0,NULL,NULL),(69,'ne','Nepali','नेपाली',0,0,0,NULL,NULL),(70,'nl','Dutch','Nederlands',0,0,0,NULL,NULL),(71,'nn','Norwegian Nynorsk','Norsk (nynorsk)',0,0,0,NULL,NULL),(72,'no','Norwegian','Norsk (bokmål / riksmål)',0,0,0,NULL,NULL),(73,'nr','South Ndebele','isiNdebele',0,0,0,NULL,NULL),(74,'ny','Chichewa','Chi-Chewa',0,0,0,NULL,NULL),(75,'oc','Occitan','Occitan',0,0,0,NULL,NULL),(76,'pa','Panjabi / Punjabi','ਪੰਜਾਬੀ / पंजाबी / پنجابي',0,0,0,NULL,NULL),(77,'pl','Polish','Polski',0,0,0,NULL,NULL),(78,'ps','Pashto','پښتو',1,0,0,NULL,NULL),(79,'pt','Portuguese','Português',0,0,0,NULL,NULL),(80,'qu','Quechua','Runa Simi',0,0,0,NULL,NULL),(81,'rn','Kirundi','Kirundi',0,0,0,NULL,NULL),(82,'ro','Romanian','Română',0,0,0,NULL,NULL),(83,'ru','Russian','Русский',0,0,0,NULL,NULL),(84,'rw','Rwandi','Kinyarwandi',0,0,0,NULL,NULL),(85,'sg','Sango','Sängö',0,0,0,NULL,NULL),(86,'si','Sinhalese','සිංහල',0,0,0,NULL,NULL),(87,'sk','Slovak','Slovenčina',0,0,0,NULL,NULL),(88,'sl','Slovenian','Slovenščina',0,0,0,NULL,NULL),(89,'sm','Samoan','Gagana Samoa',0,0,0,NULL,NULL),(90,'sn','Shona','chiShona',0,0,0,NULL,NULL),(91,'so','Somalia','Soomaaliga',0,0,0,NULL,NULL),(92,'sq','Albanian','Shqip',0,0,0,NULL,NULL),(93,'sr','Serbian','Српски',0,0,0,NULL,NULL),(94,'ss','Swati','SiSwati',0,0,0,NULL,NULL),(95,'st','Southern Sotho','Sesotho',0,0,0,NULL,NULL),(96,'sv','Swedish','Svenska',0,0,0,NULL,NULL),(97,'sw','Swahili','Kiswahili',0,0,0,NULL,NULL),(98,'ta','Tamil','தமிழ்',0,0,0,NULL,NULL),(99,'tg','Tajik','Тоҷикӣ',0,0,0,NULL,NULL),(100,'th','Thai','ไทย / Phasa Thai',0,0,0,NULL,NULL),(101,'ti','Tigrinya','ትግርኛ',0,0,0,NULL,NULL),(102,'tk','Turkmen','Туркмен /تركمن ',0,0,0,NULL,NULL),(103,'tn','Tswana','Setswana',0,0,0,NULL,NULL),(104,'to','Tonga','Lea Faka-Tonga',0,0,0,NULL,NULL),(105,'tr','Turkish','Türkçe',0,0,0,NULL,NULL),(106,'ts','Tsonga','Xitsonga',0,0,0,NULL,NULL),(107,'uk','Ukrainian','Українська',0,0,0,NULL,NULL),(108,'ur','Urdu','اردو',1,0,0,NULL,NULL),(109,'uz','Uzbek','Ўзбек',0,0,0,NULL,NULL),(110,'ve','Venda','Tshivenḓa',0,0,0,NULL,NULL),(111,'vi','Vietnamese','Tiếng Việt',0,0,0,NULL,NULL),(112,'xh','Xhosa','isiXhosa',0,0,0,NULL,NULL),(113,'zh','Chinese','中文',0,0,0,NULL,NULL),(114,'zu','Zulu','isiZulu',0,0,0,NULL,NULL);
CREATE TABLE `lb_blocks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `raw_title` varchar(191) DEFAULT NULL,
  `raw_content` text DEFAULT NULL,
  `rendered_content` text DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL DEFAULT 'wp_block',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `lb_contents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `raw_content` text DEFAULT NULL,
  `rendered_content` text DEFAULT NULL,
  `contentable_type` varchar(191) NOT NULL,
  `contentable_id` bigint(20) unsigned NOT NULL,
  `type` varchar(191) NOT NULL DEFAULT 'page',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lb_contents_contentable_type_contentable_id_index` (`contentable_type`,`contentable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `log_activity` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject` longtext NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 1,
  `url` longtext DEFAULT NULL,
  `method` varchar(191) DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `login` tinyint(1) NOT NULL DEFAULT 0,
  `login_time` datetime DEFAULT NULL,
  `logout_time` datetime DEFAULT NULL,
  `agent` varchar(191) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=601 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `log_activity` VALUES (348,'Super - logged in at : 2024-02-06 07:27:47',1,'https://www.emarketzone.com/admin/login','POST','212.39.89.60',1,'2024-02-06 07:27:47',NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 06:27:47','2024-02-06 06:27:47'),(349,'customer update active status',1,'https://www.emarketzone.com/customer/is-active/update','POST','212.39.89.60',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 06:29:15','2024-02-06 06:29:15'),(350,'Updated Successfully',1,'https://www.emarketzone.com/generalsetting/general-settings/update','POST','212.39.89.60',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 06:30:55','2024-02-06 06:30:55'),(351,'Nedko - logged in at : 2024-02-06 07:31:23',3,'https://www.emarketzone.com/login','POST','212.39.89.60',1,'2024-02-06 07:31:23',NULL,'Chrome Mobile-121-Blink-Android 10-',3,'2024-02-06 06:31:23','2024-02-06 06:31:23'),(352,'address added',1,'https://www.emarketzone.com/customer/address/store','POST','212.39.89.60',0,NULL,NULL,'Chrome Mobile-121-Blink-Android 10-',3,'2024-02-06 06:44:54','2024-02-06 06:44:54'),(353,'update info',1,'https://www.emarketzone.com/customer/info/update','POST','212.39.89.60',0,NULL,NULL,'Chrome Mobile-121-Blink-Android 10-',3,'2024-02-06 06:46:13','2024-02-06 06:46:13'),(354,'Super - logged in at : 2024-02-06 11:24:31',1,'https://www.emarketzone.com/admin/login','POST','212.39.89.36',1,'2024-02-06 11:24:31',NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 10:24:31','2024-02-06 10:24:31'),(355,'Social link store successful.',1,'https://www.emarketzone.com/admin/setting/social-link/store','POST','212.39.89.12',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 10:27:25','2024-02-06 10:27:25'),(356,'Super - logged in at : 2024-02-06 15:16:58',1,'https://www.emarketzone.com/admin/login','POST','212.39.89.108',1,'2024-02-06 15:16:58',NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:16:58','2024-02-06 14:16:58'),(357,'Updated Successfully',1,'https://www.emarketzone.com/generalsetting/general-settings/update','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:20:34','2024-02-06 14:20:34'),(358,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:22:36','2024-02-06 14:22:36'),(359,'Units added.',1,'https://www.emarketzone.com/products/unit-store','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:23:09','2024-02-06 14:23:09'),(360,'Units added.',1,'https://www.emarketzone.com/products/unit-store','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:23:23','2024-02-06 14:23:23'),(361,'Attribute Updated.',1,'https://www.emarketzone.com/products/attribute-list/1/update','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:26:48','2024-02-06 14:26:48'),(362,'Attribute Updated.',1,'https://www.emarketzone.com/products/attribute-list/1/update','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:29:53','2024-02-06 14:29:53'),(363,'Attribute Added.',1,'https://www.emarketzone.com/products/attribute-store','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:32:13','2024-02-06 14:32:13'),(364,'Units added.',1,'https://www.emarketzone.com/products/unit-store','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:33:53','2024-02-06 14:33:53'),(365,'Units updated.',1,'https://www.emarketzone.com/products/unit-update/3','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:34:18','2024-02-06 14:34:18'),(366,'Units updated.',1,'https://www.emarketzone.com/products/unit-update/2','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:34:34','2024-02-06 14:34:34'),(367,'footer Content updated.',1,'https://www.emarketzone.com/footer/footer-setting','POST','212.39.89.108',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:35:14','2024-02-06 14:35:14'),(368,'Subscribe Content updated.',1,'https://www.emarketzone.com/frontendcms/promotion-bar/update','POST','212.39.89.12',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:38:41','2024-02-06 14:38:41'),(369,'Subscribe Content updated.',1,'https://www.emarketzone.com/frontendcms/promotion-bar/update','POST','212.39.89.36',0,NULL,NULL,'Chrome Webview-112.0.5615-Blink-Android 12-Mi 11',1,'2024-02-06 14:40:25','2024-02-06 14:40:25'),(370,'Subscribe Content updated.',1,'https://www.emarketzone.com/frontendcms/subscribe-content/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 15:34:18','2024-02-10 15:34:18'),(371,'Subscribe Content updated.',1,'https://www.emarketzone.com/frontendcms/subscribe-content/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 15:34:59','2024-02-10 15:34:59'),(372,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 15:48:21','2024-02-10 15:48:21'),(373,'Utility Operation Done.',1,'https://www.emarketzone.com/utilities?utilities=optimize_clear','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 15:58:52','2024-02-10 15:58:52'),(374,'Utility Operation Done.',1,'https://www.emarketzone.com/utilities?utilities=clear_log','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 15:58:56','2024-02-10 15:58:56'),(375,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:11:53','2024-02-10 16:11:53'),(376,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:18:11','2024-02-10 16:18:11'),(377,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:48:47','2024-02-10 16:48:47'),(378,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:50:43','2024-02-10 16:50:43'),(379,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:52:19','2024-02-10 16:52:19'),(380,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:53:47','2024-02-10 16:53:47'),(381,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:54:02','2024-02-10 16:54:02'),(382,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:54:53','2024-02-10 16:54:53'),(383,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 16:55:06','2024-02-10 16:55:06'),(384,'seller updated.',1,'https://www.emarketzone.com/admin/update-status/4','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-10 17:03:40','2024-02-10 17:03:40'),(385,'Book Mall - logged in at : 2024-02-11 07:11:38',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-11 07:11:38',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:11:38','2024-02-11 06:11:38'),(386,'update info',1,'https://www.emarketzone.com/customer/info/update','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:14:43','2024-02-11 06:14:43'),(387,'update info',1,'https://www.emarketzone.com/customer/info/update','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:19:56','2024-02-11 06:19:56'),(388,'Business information update successful.',1,'https://www.emarketzone.com/seller/profile/business-information/update/4','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:22:29','2024-02-11 06:22:29'),(389,'Logo update successful.',1,'https://www.emarketzone.com/seller/setting/logo/update/4','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:27:16','2024-02-11 06:27:16'),(390,'Bank account update successful.',1,'https://www.emarketzone.com/seller/profile/bank-account/update/4','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:28:50','2024-02-11 06:28:50'),(391,'Warehouse address update successful.',1,'https://www.emarketzone.com/seller/profile/warehouse-address/update/4','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:30:09','2024-02-11 06:30:09'),(392,'Trusted Status has been changed.',1,'https://www.emarketzone.com/admin/change-trusted-status/1','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 06:30:47','2024-02-11 06:30:47'),(393,'Units added.',1,'https://www.emarketzone.com/products/unit-store','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 06:44:31','2024-02-11 06:44:31'),(394,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:54:37','2024-02-11 06:54:37'),(395,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 06:56:35','2024-02-11 06:56:35'),(396,'Update stock manage status successful.',1,'https://www.emarketzone.com/seller/product-stock-status','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:58:02','2024-02-11 06:58:02'),(397,'Update stock manage status successful.',1,'https://www.emarketzone.com/seller/product-stock-status','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 06:58:14','2024-02-11 06:58:14'),(398,'Product updated.',1,'https://www.emarketzone.com/products/update/12','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:00:22','2024-02-11 07:00:22'),(399,'Menu added.',1,'https://www.emarketzone.com/menu/store','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:14:11','2024-02-11 07:14:11'),(400,'column created successful.',1,'https://www.emarketzone.com/menu/setup/add-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:17:43','2024-02-11 07:17:43'),(401,'column updated.',1,'https://www.emarketzone.com/menu/setup/column-update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:17:57','2024-02-11 07:17:57'),(402,'column created successful.',1,'https://www.emarketzone.com/menu/setup/add-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:19:22','2024-02-11 07:19:22'),(403,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:21:02','2024-02-11 07:21:02'),(404,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:21:10','2024-02-11 07:21:10'),(405,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:21:10','2024-02-11 07:21:10'),(406,'Menu added.',1,'https://www.emarketzone.com/menu/setup/add-menu','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:21:53','2024-02-11 07:21:53'),(407,'update menu for multi menu',1,'https://www.emarketzone.com/menu/setup/menu-update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:22:26','2024-02-11 07:22:26'),(408,'Product updated.',1,'https://www.emarketzone.com/products/update/12','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 07:24:37','2024-02-11 07:24:37'),(409,'Milin - logged in at : 2024-02-11 13:16:07',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-11 13:16:07',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 12:16:07','2024-02-11 12:16:07'),(410,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 12:18:53','2024-02-11 12:18:53'),(411,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-11 12:32:25','2024-02-11 12:32:25'),(412,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-11 12:33:34','2024-02-11 12:33:34'),(413,'Milin - logged in at : 2024-02-12 05:24:11',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-12 05:24:11',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-12 04:24:11','2024-02-12 04:24:11'),(414,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-12 04:40:47','2024-02-12 04:40:47'),(415,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-12 04:41:18','2024-02-12 04:41:18'),(416,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-12 04:46:06','2024-02-12 04:46:06'),(417,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-12 04:46:12','2024-02-12 04:46:12'),(418,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-12 04:46:12','2024-02-12 04:46:12'),(419,'Milin - logged in at : 2024-02-13 17:31:36',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-13 17:31:36',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-13 16:31:36','2024-02-13 16:31:36'),(420,'Milin - logged in at : 2024-02-14 05:48:45',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-14 05:48:45',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-14 04:48:45','2024-02-14 04:48:45'),(421,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-14 05:02:13','2024-02-14 05:02:13'),(422,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-14 05:05:26','2024-02-14 05:05:26'),(423,'Milin - logged in at : 2024-02-15 16:55:25',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-15 16:55:25',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-15 15:55:25','2024-02-15 15:55:25'),(424,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-15 16:02:50','2024-02-15 16:02:50'),(425,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-15 16:09:32','2024-02-15 16:09:32'),(426,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-15 16:12:09','2024-02-15 16:12:09'),(427,'Georgi - logged out at : 2024-02-16 19:26:56',2,'https://www.emarketzone.com/admin/login','POST','82.132.215.41',1,'2024-02-16 19:08:15','2024-02-16 19:26:56','Chrome-121-Blink-Windows 10-',2,'2024-02-16 18:08:15','2024-02-16 18:26:56'),(428,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','82.132.215.41',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',2,'2024-02-16 18:14:55','2024-02-16 18:14:55'),(429,'Product updated.',1,'https://www.emarketzone.com/products/update/10','POST','82.132.215.41',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',2,'2024-02-16 18:22:50','2024-02-16 18:22:50'),(430,'Product updated.',1,'https://www.emarketzone.com/products/update/10','POST','82.132.215.41',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',2,'2024-02-16 18:23:57','2024-02-16 18:23:57'),(431,'Product updated.',1,'https://www.emarketzone.com/products/update/10','POST','82.132.215.41',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',2,'2024-02-16 18:26:07','2024-02-16 18:26:07'),(432,'Product updated.',1,'https://www.emarketzone.com/products/update/10','POST','82.132.215.41',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',2,'2024-02-16 18:26:08','2024-02-16 18:26:08'),(433,'Product deleted.',1,'https://www.emarketzone.com/products/destroy','POST','82.132.215.41',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',2,'2024-02-16 18:26:46','2024-02-16 18:26:46'),(434,'Milin - logged in at : 2024-02-17 16:04:08',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-17 16:04:08',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-17 15:04:08','2024-02-17 15:04:08'),(435,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-17 15:10:11','2024-02-17 15:10:11'),(436,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:12:35','2024-02-17 15:12:35'),(437,'Commision Updated Successfully',1,'https://www.emarketzone.com/admin/seller-commisions/1/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:15:51','2024-02-17 15:15:51'),(438,'Commision Updated Successfully',1,'https://www.emarketzone.com/admin/seller-commisions/2/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:22:18','2024-02-17 15:22:18'),(439,'Commision Updated Successfully',1,'https://www.emarketzone.com/admin/seller-commisions/3/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:22:27','2024-02-17 15:22:27'),(440,'Commision Updated Successfully',1,'https://www.emarketzone.com/admin/seller-commisions/2/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:23:10','2024-02-17 15:23:10'),(441,'Commision Updated Successfully',1,'https://www.emarketzone.com/admin/seller-commisions/3/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:23:17','2024-02-17 15:23:17'),(442,'Pricing updated.',1,'https://www.emarketzone.com/admin/pricing/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:26:18','2024-02-17 15:26:18'),(443,'Pricing updated.',1,'https://www.emarketzone.com/admin/pricing/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:28:33','2024-02-17 15:28:33'),(444,'Pricing updated.',1,'https://www.emarketzone.com/admin/pricing/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:30:56','2024-02-17 15:30:56'),(445,'Commision has been Updated to 10 %',1,'https://www.emarketzone.com/admin/commission-update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:34:45','2024-02-17 15:34:45'),(446,'seller updated.',1,'https://www.emarketzone.com/admin/update-status/5','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-17 15:42:39','2024-02-17 15:42:39'),(447,'Alispress - logged in at : 2024-02-17 16:43:03',5,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-17 16:43:03',NULL,'Chrome-114-Blink-Windows 10-',5,'2024-02-17 15:43:03','2024-02-17 15:43:03'),(448,'Business information update successful.',1,'https://www.emarketzone.com/seller/profile/business-information/update/5','POST','151.251.174.75',0,NULL,NULL,'Chrome-114-Blink-Windows 10-',5,'2024-02-17 15:45:41','2024-02-17 15:45:41'),(449,'Bank account update successful.',1,'https://www.emarketzone.com/seller/profile/bank-account/update/5','POST','151.251.174.75',0,NULL,NULL,'Chrome-114-Blink-Windows 10-',5,'2024-02-17 15:46:30','2024-02-17 15:46:30'),(450,'Warehouse address update successful.',1,'https://www.emarketzone.com/seller/profile/warehouse-address/update/5','POST','151.251.174.75',0,NULL,NULL,'Chrome-114-Blink-Windows 10-',5,'2024-02-17 15:47:22','2024-02-17 15:47:22'),(451,'cart store successful.',1,'https://www.emarketzone.com/cart/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-114-Blink-Windows 10-',5,'2024-02-17 15:49:18','2024-02-17 15:49:18'),(452,'delete cart successful.',1,'https://www.emarketzone.com/cart/delete','POST','151.251.174.75',0,NULL,NULL,'Chrome-114-Blink-Windows 10-',5,'2024-02-17 15:49:57','2024-02-17 15:49:57'),(453,'seller updated.',1,'https://www.emarketzone.com/admin/update-status/6','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 08:34:47','2024-02-18 08:34:47'),(454,'Amazshop - logged in at : 2024-02-18 09:35:32',6,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-18 09:35:32',NULL,'Chrome-121-Blink-Windows 10-',6,'2024-02-18 08:35:32','2024-02-18 08:35:32'),(455,'Business information update successful.',1,'https://www.emarketzone.com/seller/profile/business-information/update/6','POST','151.251.174.75',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',6,'2024-02-18 08:39:57','2024-02-18 08:39:57'),(456,'Bank account update successful.',1,'https://www.emarketzone.com/seller/profile/bank-account/update/6','POST','151.251.174.75',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',6,'2024-02-18 08:40:27','2024-02-18 08:40:27'),(457,'Warehouse address update successful.',1,'https://www.emarketzone.com/seller/profile/warehouse-address/update/6','POST','151.251.174.75',0,NULL,NULL,'Chrome-121-Blink-Windows 10-',6,'2024-02-18 08:40:52','2024-02-18 08:40:52'),(458,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:31:01','2024-02-18 09:31:01'),(459,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:31:22','2024-02-18 09:31:22'),(460,'Element deleted',1,'https://www.emarketzone.com/menu/setup/element-delete','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:36:51','2024-02-18 09:36:51'),(461,'Element deleted',1,'https://www.emarketzone.com/menu/setup/element-delete','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:36:57','2024-02-18 09:36:57'),(462,'Element deleted',1,'https://www.emarketzone.com/menu/setup/element-delete','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:37:22','2024-02-18 09:37:22'),(463,'Element deleted',1,'https://www.emarketzone.com/menu/setup/element-delete','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:37:26','2024-02-18 09:37:26'),(464,'Element deleted',1,'https://www.emarketzone.com/menu/setup/element-delete','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:37:31','2024-02-18 09:37:31'),(465,'Element deleted',1,'https://www.emarketzone.com/menu/setup/element-delete','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:37:40','2024-02-18 09:37:40'),(466,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:38:19','2024-02-18 09:38:19'),(467,'Milin - logged in at : 2024-02-18 10:41:19',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-18 10:41:19',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-18 09:41:19','2024-02-18 09:41:19'),(468,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:45:27','2024-02-18 09:45:27'),(469,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:46:48','2024-02-18 09:46:48'),(470,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:46:55','2024-02-18 09:46:55'),(471,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 09:46:55','2024-02-18 09:46:55'),(472,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-18 11:31:45','2024-02-18 11:31:45'),(473,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-18 11:55:32','2024-02-18 11:55:32'),(474,'widget update successful.',1,'https://www.emarketzone.com/frontendcms/homepage/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-21 03:27:38','2024-02-21 03:27:38'),(475,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-21 03:31:42','2024-02-21 03:31:42'),(476,'Milin - logged in at : 2024-02-21 04:41:04',4,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-02-21 04:41:04',NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-21 03:41:04','2024-02-21 03:41:04'),(477,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-21 03:48:05','2024-02-21 03:48:05'),(478,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-21 03:48:45','2024-02-21 03:48:45'),(479,'cart store successful.',1,'https://www.emarketzone.com/cart/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-122-Gecko-Windows 10-',4,'2024-02-21 04:12:17','2024-02-21 04:12:17'),(480,'Product updated.',1,'https://www.emarketzone.com/products/update/12','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-21 04:19:05','2024-02-21 04:19:05'),(481,'delete cart successful.',1,'https://www.emarketzone.com/cart/delete','POST','151.251.174.75',0,NULL,NULL,'Firefox-123-Gecko-Windows 10-',4,'2024-02-23 04:14:05','2024-02-23 04:14:05'),(482,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-23 04:16:12','2024-02-23 04:16:12'),(483,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-23 04:17:01','2024-02-23 04:17:01'),(484,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-23 04:17:07','2024-02-23 04:17:07'),(485,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-23 04:17:07','2024-02-23 04:17:07'),(486,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-123-Gecko-Windows 10-',4,'2024-02-23 04:24:00','2024-02-23 04:24:00'),(487,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-121-Blink-Windows 10-',1,'2024-02-23 04:24:37','2024-02-23 04:24:37'),(488,'Undefined array key \"wholesale_min_qty_0\"',0,'https://www.emarketzone.com/seller/product/update/21','POST','151.251.174.75',0,NULL,NULL,'Firefox-123-Gecko-Windows 10-',4,'2024-02-27 03:50:16','2024-02-27 03:50:16'),(489,'product updated.',1,'https://www.emarketzone.com/seller/product/update/21','POST','151.251.174.75',0,NULL,NULL,'Firefox-123-Gecko-Windows 10-',4,'2024-02-27 03:50:31','2024-02-27 03:50:31'),(490,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-123-Gecko-Windows 10-',4,'2024-02-27 03:56:19','2024-02-27 03:56:19'),(491,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-02-27 04:01:48','2024-02-27 04:01:48'),(492,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-02-28 04:01:45','2024-02-28 04:01:45'),(493,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-02-28 04:02:21','2024-02-28 04:02:21'),(494,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-02-28 04:02:32','2024-02-28 04:02:32'),(495,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-02-28 04:02:32','2024-02-28 04:02:32'),(496,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Firefox-123-Gecko-Windows 10-',4,'2024-02-28 04:06:35','2024-02-28 04:06:35'),(497,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-02-28 04:26:39','2024-02-28 04:26:39'),(498,'Seller account update successful.',1,'https://www.emarketzone.com/seller/profile/seller-account/update/5','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:19:21','2024-03-02 10:19:21'),(499,'Seller account update successful.',1,'https://www.emarketzone.com/seller/profile/seller-account/update/5','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:19:21','2024-03-02 10:19:21'),(500,'Super - logged in at : 2024-03-02 11:23:15',1,'https://www.emarketzone.com/admin/login','POST','151.251.174.75',1,'2024-03-02 11:23:15',NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:23:15','2024-03-02 10:23:15'),(501,'Trusted Status has been changed.',1,'https://www.emarketzone.com/admin/change-trusted-status/2','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:26:20','2024-03-02 10:26:20'),(502,'Brand Added.',1,'https://www.emarketzone.com/products/brands-store','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:29:02','2024-03-02 10:29:02'),(503,'Attribute Updated.',1,'https://www.emarketzone.com/products/attribute-list/1/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:43:21','2024-03-02 10:43:21'),(504,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:46:44','2024-03-02 10:46:44'),(505,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:47:47','2024-03-02 10:47:47'),(506,'Menu added.',1,'https://www.emarketzone.com/menu/store','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:48:40','2024-03-02 10:48:40'),(507,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:49:30','2024-03-02 10:49:30'),(508,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:49:35','2024-03-02 10:49:35'),(509,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 10:49:35','2024-03-02 10:49:35'),(510,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 12:03:10','2024-03-02 12:03:10'),(511,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:51:31','2024-03-02 13:51:31'),(512,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:51:51','2024-03-02 13:51:51'),(513,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:52:38','2024-03-02 13:52:38'),(514,'column updated.',1,'https://www.emarketzone.com/menu/setup/column-update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:53:44','2024-03-02 13:53:44'),(515,'element updated',1,'https://www.emarketzone.com/menu/setup/element-update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:54:26','2024-03-02 13:54:26'),(516,'Category Updated.',1,'https://www.emarketzone.com/products/category/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:54:57','2024-03-02 13:54:57'),(517,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:55:40','2024-03-02 13:55:40'),(518,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 13:55:40','2024-03-02 13:55:40'),(519,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 14:20:57','2024-03-02 14:20:57'),(520,'Attempt to read property \"id\" on null',0,'https://www.emarketzone.com/products/25/edit','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 14:21:29','2024-03-02 14:21:29'),(521,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 14:21:41','2024-03-02 14:21:41'),(522,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 14:21:45','2024-03-02 14:21:45'),(523,'Product updated.',1,'https://www.emarketzone.com/products/update/25','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 14:24:58','2024-03-02 14:24:58'),(524,'Menu added.',1,'https://www.emarketzone.com/menu/setup/add-menu','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 15:06:13','2024-03-02 15:06:13'),(525,'Sort menu for multi menu successful.',1,'https://www.emarketzone.com/menu/setup/sort-menu','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 15:06:21','2024-03-02 15:06:21'),(526,'Super - logged in at : 2024-03-02 18:18:59',1,'https://www.emarketzone.com/admin/login','POST','151.251.174.75',1,'2024-03-02 18:18:59',NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 17:18:59','2024-03-02 17:18:59'),(527,'Product updated.',1,'https://www.emarketzone.com/products/update/25','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 18:42:12','2024-03-02 18:42:12'),(528,'Product updated.',1,'https://www.emarketzone.com/products/update/25','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 18:43:08','2024-03-02 18:43:08'),(529,'Product updated.',1,'https://www.emarketzone.com/products/update/25','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-02 18:44:26','2024-03-02 18:44:26'),(530,'Business information update successful.',1,'https://www.emarketzone.com/seller/profile/business-information/update/5','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:45:19','2024-03-02 18:45:19'),(531,'Business information update successful.',1,'https://www.emarketzone.com/seller/profile/business-information/update/5','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:45:19','2024-03-02 18:45:19'),(532,'Warehouse address update successful.',1,'https://www.emarketzone.com/seller/profile/warehouse-address/update/5','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:46:03','2024-03-02 18:46:03'),(533,'Business information update successful.',1,'https://www.emarketzone.com/seller/profile/business-information/update/5','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:46:32','2024-03-02 18:46:32'),(534,'Seller account update successful.',1,'https://www.emarketzone.com/seller/profile/seller-account/update/5','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:46:44','2024-03-02 18:46:44'),(535,'product status updated.',1,'https://www.emarketzone.com/seller/product/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:55:57','2024-03-02 18:55:57'),(536,'product status updated.',1,'https://www.emarketzone.com/seller/product/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:55:57','2024-03-02 18:55:57'),(537,'product status updated.',1,'https://www.emarketzone.com/seller/product/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:55:58','2024-03-02 18:55:58'),(538,'product status updated.',1,'https://www.emarketzone.com/seller/product/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',5,'2024-03-02 18:56:06','2024-03-02 18:56:06'),(539,'Super - logged in at : 2024-03-03 07:56:41',1,'https://www.emarketzone.com/admin/login','POST','151.251.174.75',1,'2024-03-03 07:56:41',NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 06:56:41','2024-03-03 06:56:41'),(540,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 06:59:10','2024-03-03 06:59:10'),(541,'product status update successful.',1,'https://www.emarketzone.com/products/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 06:59:41','2024-03-03 06:59:41'),(542,'Product updated.',1,'https://www.emarketzone.com/products/update/25','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:01:15','2024-03-03 07:01:15'),(543,'Product updated.',1,'https://www.emarketzone.com/products/update/26','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:02:53','2024-03-03 07:02:53'),(544,'Product updated.',1,'https://www.emarketzone.com/products/update/26','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:04:56','2024-03-03 07:04:56'),(545,'Product updated.',1,'https://www.emarketzone.com/products/update/26','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:08:04','2024-03-03 07:08:04'),(546,'Product updated.',1,'https://www.emarketzone.com/products/update/26','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:09:29','2024-03-03 07:09:29'),(547,'product status update successful.',1,'https://www.emarketzone.com/products/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:10:03','2024-03-03 07:10:03'),(548,'product status update successful.',1,'https://www.emarketzone.com/products/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:10:11','2024-03-03 07:10:11'),(549,'Product updated.',1,'https://www.emarketzone.com/products/update/26','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:13:03','2024-03-03 07:13:03'),(550,'Mi Store - logged in at : 2024-03-03 08:16:13',5,'https://www.emarketzone.com/seller/login','POST','151.251.174.75',1,'2024-03-03 08:16:13',NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-03 07:16:13','2024-03-03 07:16:13'),(551,'product status updated.',1,'https://www.emarketzone.com/seller/product/update-status','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-03 07:16:51','2024-03-03 07:16:51'),(552,'product delete successful.',1,'https://www.emarketzone.com/seller/product/delete','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-03 07:16:59','2024-03-03 07:16:59'),(553,'Product updated.',1,'https://www.emarketzone.com/products/update/26','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:25:17','2024-03-03 07:25:17'),(554,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-03 07:26:13','2024-03-03 07:26:13'),(555,'product status update successful.',1,'https://www.emarketzone.com/products/update-status','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:26:26','2024-03-03 07:26:26'),(556,'Product deleted.',1,'https://www.emarketzone.com/products/destroy','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:26:33','2024-03-03 07:26:33'),(557,'Product deleted.',1,'https://www.emarketzone.com/products/destroy','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:26:43','2024-03-03 07:26:43'),(558,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 07:26:53','2024-03-03 07:26:53'),(559,'widget update successful.',1,'https://www.emarketzone.com/frontendcms/homepage/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:08:50','2024-03-03 09:08:50'),(560,'widget update successful.',1,'https://www.emarketzone.com/frontendcms/homepage/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:09:17','2024-03-03 09:09:17'),(561,'widget update successful.',1,'https://www.emarketzone.com/frontendcms/homepage/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:11:56','2024-03-03 09:11:56'),(562,'widget update successful.',1,'https://www.emarketzone.com/frontendcms/homepage/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:12:37','2024-03-03 09:12:37'),(563,'widget update successful.',1,'https://www.emarketzone.com/frontendcms/homepage/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:13:28','2024-03-03 09:13:28'),(564,'Category Added.',1,'https://www.emarketzone.com/products/category','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:39:17','2024-03-03 09:39:17'),(565,'element added successful.',1,'https://www.emarketzone.com/menu/setup/add-element','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:39:53','2024-03-03 09:39:53'),(566,'column created successful.',1,'https://www.emarketzone.com/menu/setup/add-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:40:29','2024-03-03 09:40:29'),(567,'Element sorted successful.',1,'https://www.emarketzone.com/menu/setup/element/sort','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:40:35','2024-03-03 09:40:35'),(568,'add to column successful.',1,'https://www.emarketzone.com/menu/setup/add-to-column','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:40:35','2024-03-03 09:40:35'),(569,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-03 09:50:05','2024-03-03 09:50:05'),(570,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:50:25','2024-03-03 09:50:25'),(571,'Product updated.',1,'https://www.emarketzone.com/products/update/28','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 09:58:54','2024-03-03 09:58:54'),(572,'Attribute Updated.',1,'https://www.emarketzone.com/products/attribute-list/1/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 13:31:20','2024-03-03 13:31:20'),(573,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-03 14:00:59','2024-03-03 14:00:59'),(574,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:01:28','2024-03-03 14:01:28'),(575,'Product updated.',1,'https://www.emarketzone.com/products/update/29','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:02:55','2024-03-03 14:02:55'),(576,'Product updated.',1,'https://www.emarketzone.com/products/update/29','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:03:22','2024-03-03 14:03:22'),(577,'Product updated.',1,'https://www.emarketzone.com/products/update/29','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:04:27','2024-03-03 14:04:27'),(578,'Attribute Updated.',1,'https://www.emarketzone.com/products/attribute-list/1/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:13:11','2024-03-03 14:13:11'),(579,'Product updated.',1,'https://www.emarketzone.com/products/update/29','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:16:09','2024-03-03 14:16:09'),(580,'Product updated.',1,'https://www.emarketzone.com/products/update/29','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:17:17','2024-03-03 14:17:17'),(581,'Product updated.',1,'https://www.emarketzone.com/products/update/24','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:21:54','2024-03-03 14:21:54'),(582,'Product updated.',1,'https://www.emarketzone.com/products/update/29','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-03 14:22:15','2024-03-03 14:22:15'),(583,'product upload successful.',1,'https://www.emarketzone.com/products/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:01:23','2024-03-04 13:01:23'),(584,'product approve  successful.',1,'https://www.emarketzone.com/products/request-product/approved','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:02:02','2024-03-04 13:02:02'),(585,'cart store successful.',1,'https://www.emarketzone.com/cart/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:03:09','2024-03-04 13:03:09'),(586,'delete cart successful.',1,'https://www.emarketzone.com/cart/delete','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:03:51','2024-03-04 13:03:51'),(587,'cart store successful.',1,'https://www.emarketzone.com/cart/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:04:23','2024-03-04 13:04:23'),(588,'delete cart successful.',1,'https://www.emarketzone.com/cart/delete','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:04:38','2024-03-04 13:04:38'),(589,'Product updated.',1,'https://www.emarketzone.com/products/update/30','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:06:24','2024-03-04 13:06:24'),(590,'cart store successful.',1,'https://www.emarketzone.com/cart/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:07:03','2024-03-04 13:07:03'),(591,'delete cart successful.',1,'https://www.emarketzone.com/cart/delete','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:07:32','2024-03-04 13:07:32'),(592,'cart store successful.',1,'https://www.emarketzone.com/cart/store','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:08:08','2024-03-04 13:08:08'),(593,'delete cart successful.',1,'https://www.emarketzone.com/cart/delete','POST','151.251.174.75',0,NULL,NULL,'Chrome-122-Blink-Windows 10-',5,'2024-03-04 13:08:19','2024-03-04 13:08:19'),(594,'Utility Operation Done.',1,'https://www.emarketzone.com/utilities?utilities=optimize_clear','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:16:33','2024-03-04 13:16:33'),(595,'Utility Operation Done.',1,'https://www.emarketzone.com/utilities?utilities=clear_log','GET','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:16:39','2024-03-04 13:16:39'),(596,'Updated Successfully',1,'https://www.emarketzone.com/generalsetting/general-settings/update','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:28:44','2024-03-04 13:28:44'),(597,'Product updated.',1,'https://www.emarketzone.com/products/update/30','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:30:52','2024-03-04 13:30:52'),(598,'Product updated.',1,'https://www.emarketzone.com/products/update/30','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:37:18','2024-03-04 13:37:18'),(599,'Product updated.',1,'https://www.emarketzone.com/products/update/30','POST','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:43:14','2024-03-04 13:43:14'),(600,'Currency updated Successfully',1,'https://www.emarketzone.com/setup/currencies/11','PUT','151.251.174.75',0,NULL,NULL,'Microsoft Edge-122-Blink-Windows 10-',1,'2024-03-04 13:54:17','2024-03-04 13:54:17');
CREATE TABLE `login_pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(500) DEFAULT NULL,
  `sub_title` varchar(500) DEFAULT NULL,
  `cover_img` varchar(250) DEFAULT NULL,
  `login_slug` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `login_pages` VALUES (1,'Turn your ideas into reality.','Consistent quality and experience across all platforms and devices.','frontend/amazy/img/banner/admin_login_img.png','admin-login',NULL,NULL),(2,'Turn your ideas into reality.','Consistent quality and experience across all platforms and devices.','frontend/amazy/img/banner/login_img.png','login',NULL,NULL),(3,'Turn your ideas into reality.','Consistent quality and experience across all platforms and devices.','frontend/amazy/img/banner/seller_login_img.png','seller-login',NULL,NULL),(4,'Turn your ideas into reality.','Consistent quality and experience across all platforms and devices.','frontend/amazy/img/banner/password_reset_login_img.png','password-reset',NULL,NULL);
CREATE TABLE `media_managers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `file_name` varchar(191) NOT NULL,
  `orginal_name` varchar(191) NOT NULL,
  `extension` varchar(191) NOT NULL,
  `type` varchar(191) DEFAULT NULL,
  `size` bigint(20) unsigned NOT NULL,
  `external_link` varchar(191) DEFAULT NULL,
  `storage` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `media_managers` VALUES (1,1,'uploads/all/65b6537f9ccd6.png','seller-registration.png','png','image',29,NULL,'local',NULL,NULL),(2,1,'uploads/all/65b65449039bf.jpeg','photo_2024-01-28_15-18-22.jpg','jpeg','image',61,NULL,'local',NULL,NULL),(3,1,'uploads/all/65b66da9937b6.jpeg','63b43e3b21095.jpeg','jpeg','image',126,NULL,'local',NULL,NULL),(4,1,'uploads/all/65b66db618415.jpeg','63b6990a4cd4d.jpeg','jpeg','image',176,NULL,'local',NULL,NULL),(5,1,'uploads/all/65b66db7386cc.jpeg','63b69317ca215.jpeg','jpeg','image',193,NULL,'local',NULL,NULL),(6,1,'uploads/all/65b66db73c337.jpeg','63b508b5b7c35.jpeg','jpeg','image',170,NULL,'local',NULL,NULL),(7,1,'uploads/all/65bd5cb901d9f.jpeg','102683271_824538444620821_6983688925270197040_n.jpg','jpeg','image',51,NULL,'local',NULL,NULL),(8,1,'uploads/all/65bd5cd5b4ed0.jpeg','102683271_824538444620821_6983688925270197040_n.jpg','jpeg','image',51,NULL,'local',NULL,NULL),(9,1,'uploads/all/65bd5cdff1689.jpeg','5924636_105877054_big.jpg','jpeg','image',136,NULL,'local',NULL,NULL),(10,1,'uploads/all/65bd5ce667ebf.jpeg','5924636_109100163_big.jpg','jpeg','image',99,NULL,'local',NULL,NULL),(11,1,'uploads/all/65bd5cee6651b.jpeg','102581136_293389685166121_3927059642669719118_n.jpg','jpeg','image',33,NULL,'local',NULL,NULL),(12,1,'uploads/all/65bd5d00626e4.jpeg','102906766_1133847610325729_6484152816141855985_n.jpg','jpeg','image',34,NULL,'local',NULL,NULL),(13,1,'uploads/all/65bd5d123db88.jpeg','268031608_1572499336437842_4425822088654516513_n.jpg','jpeg','image',184,NULL,'local',NULL,NULL),(14,1,'uploads/all/65bd5d1f8bd6e.jpeg','268045314_1572499389771170_6287956805450848876_n.jpg','jpeg','image',171,NULL,'local',NULL,NULL),(15,1,'uploads/all/65bd5d27e4bd4.jpeg','268250340_1572499269771182_1949393027481140505_n.jpg','jpeg','image',132,NULL,'local',NULL,NULL),(16,1,'uploads/all/65bd5d37015e1.png','102702643_264940851517584_3343768080723354221_n_800x800.png','png','image',258,NULL,'local',NULL,NULL),(17,1,'uploads/all/65bd5d6df344a.jpeg','102683271_824538444620821_6983688925270197040_n.jpg','jpeg','image',51,NULL,'local',NULL,NULL),(18,1,'uploads/all/65bd63deefbe5.jpeg','800x800.jpg','jpeg','image',63,NULL,'local',NULL,NULL),(19,1,'uploads/all/65bd63f4bb85f.jpeg','2.jpg','jpeg','image',122,NULL,'local',NULL,NULL),(20,1,'uploads/all/65bd63f8d4f2b.jpeg','3.jpg','jpeg','image',91,NULL,'local',NULL,NULL),(21,1,'uploads/all/65bd640495560.jpeg','1.jpg','jpeg','image',100,NULL,'local',NULL,NULL),(22,1,'uploads/all/65bd640875e93.jpeg','4.jpg','jpeg','image',103,NULL,'local',NULL,NULL),(23,1,'uploads/all/65bd688d9261d.jpeg','800x800.jpg','jpeg','image',81,NULL,'local',NULL,NULL),(24,1,'uploads/all/65bd68963a3a2.jpeg','5.jpg','jpeg','image',39,NULL,'local',NULL,NULL),(25,1,'uploads/all/65bd689be8dcf.jpeg','2.jpg','jpeg','image',44,NULL,'local',NULL,NULL),(26,1,'uploads/all/65bd68a8db948.jpeg','3.jpg','jpeg','image',47,NULL,'local',NULL,NULL),(27,1,'uploads/all/65bd68b2f3d7d.jpeg','4.jpg','jpeg','image',18,NULL,'local',NULL,NULL),(28,1,'uploads/all/65bd68bda7cd7.jpeg','6.jpg','jpeg','image',32,NULL,'local',NULL,NULL),(29,1,'uploads/all/65bd6b9850125.jpeg','1.jpg','jpeg','image',270,NULL,'local',NULL,NULL),(30,1,'uploads/all/65bd6ba09e8b7.jpeg','2.jpg','jpeg','image',54,NULL,'local',NULL,NULL),(31,1,'uploads/all/65bd6ba4b62dd.jpeg','3.jpg','jpeg','image',176,NULL,'local',NULL,NULL),(32,1,'uploads/all/65bd6bafe0b53.jpeg','4.jpg','jpeg','image',227,NULL,'local',NULL,NULL),(33,1,'uploads/all/65bd6bba949cc.jpeg','5.jpg','jpeg','image',83,NULL,'local',NULL,NULL),(34,1,'uploads/all/65bd6bcf482f2.jpeg','6.jpg','jpeg','image',138,NULL,'local',NULL,NULL),(35,1,'uploads/all/65bd6bd61ec76.png','7.png','png','image',596,NULL,'local',NULL,NULL),(36,1,'uploads/all/65bdfbf75a78e.png','63b54f0429ac0.png','png','image',196,NULL,'local',NULL,NULL),(37,1,'uploads/all/65bfe59d96553.png','103106649_261855385032870_5768047731798121046_n_800x800.png','png','image',151,NULL,'local',NULL,NULL),(38,1,'uploads/all/65bfe5a4d7001.jpeg','2.jpg','jpeg','image',62,NULL,'local',NULL,NULL),(39,1,'uploads/all/65bfe5a9901a3.jpeg','1.jpg','jpeg','image',55,NULL,'local',NULL,NULL),(40,1,'uploads/all/65bfe5afd21a3.jpeg','4.jpg','jpeg','image',28,NULL,'local',NULL,NULL),(41,1,'uploads/all/65bfe5b53d6e6.jpeg','3.jpg','jpeg','image',140,NULL,'local',NULL,NULL),(42,1,'uploads/all/65bfe960878e3.jpeg','model-slats-3d-wall-panel.jpg','jpeg','image',49,NULL,'local',NULL,NULL),(43,1,'uploads/all/65c7ae4b41d24.jpeg','71tMqUkxOKL._AC_UF350,350_QL50_.jpg','jpeg','image',17,NULL,'local',NULL,NULL),(44,4,'uploads/all/65c87d0cb6b92.jpeg','91SCDXZKv8L._SY466_.jpg','jpeg','image',38,NULL,'local',NULL,NULL),(45,1,'uploads/all/65c87e844dd4d.jpeg','91SCDXZKv8L._SL1500_.jpg','jpeg','image',235,NULL,'local',NULL,NULL),(46,4,'uploads/all/65c8cc31ccfe7.jpeg','71+R9qD5WjL._SL1500_.jpg','jpeg','image',100,NULL,'local',NULL,NULL),(47,4,'uploads/all/65c9aed473f78.jpeg','61avVT4Vk8L._SL1254_.jpg','jpeg','image',96,NULL,'local',NULL,NULL),(48,4,'uploads/all/65cc55fb63cb7.jpeg','61Ef9ckg0wL.jpg','jpeg','image',93,NULL,'local',NULL,NULL),(49,4,'uploads/all/65ce45275814c.jpeg','71D1qLHNX4L._SL1500_.jpg','jpeg','image',122,NULL,'local',NULL,NULL),(50,4,'uploads/all/65d0da4c4e811.jpeg','71pAiMKMB2L._SL1500_.jpg','jpeg','image',98,NULL,'local',NULL,NULL),(51,4,'uploads/all/65d1f894b2dc4.jpeg','81560LciY3L._SL1500_.jpg','jpeg','image',144,NULL,'local',NULL,NULL),(52,1,'uploads/all/65d57ca583521.jpeg','1.jpg','jpeg','image',19,NULL,'local',NULL,NULL),(53,4,'uploads/all/65d5806ad861a.jpeg','71Kw9wE5UIL._SL1500_.jpg','jpeg','image',88,NULL,'local',NULL,NULL),(54,4,'uploads/all/65d82bcea0f26.jpeg','61H08Kk3AfL._SL1246_.jpg','jpeg','image',90,NULL,'local',NULL,NULL),(55,4,'uploads/all/65dd6adf1e2be.jpeg','71AYkf1QfyL._SL1500_.jpg','jpeg','image',80,NULL,'local',NULL,NULL),(56,4,'uploads/all/65debf47a66e9.jpeg','61SzUIBoTfL._SL1246_.jpg','jpeg','image',107,NULL,'local',NULL,NULL),(57,1,'uploads/all/65e30d70d5f44.png','Xiaomi_logo.svg.png','png','image',1,NULL,'local',NULL,NULL),(58,1,'uploads/all/65e3118fb501e.jpeg','GfvkqPSI1572417622.jpg','jpeg','image',82,NULL,'local',NULL,NULL),(59,5,'uploads/all/65e313b8747dc.jpeg','m-avif-to-jpg-converter.jpg','jpeg','image',78,NULL,'local',NULL,NULL),(60,5,'uploads/all/65e315d496963.jpeg','ebp-to-jpg-converter.jpg','jpeg','image',71,NULL,'local',NULL,NULL),(61,5,'uploads/all/65e322d9b49f8.webp','S10c9c3d071d340cbb82c2902ab6c22cao.webp','webp','image',54,NULL,'local',NULL,NULL),(62,5,'uploads/all/65e341abd96eb.jpeg','S85744c2afe6149cbb4ab32f52d154cddN-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',83,NULL,'local',NULL,NULL),(63,5,'uploads/all/65e341be76926.jpeg','Xiaomi-ANC-TOUR-PRO-2-Bluetooth-5-3-Earphones-Active-Noise-Reduction-Wireless-Earphones-TWS-Small.jpg_640x640.jpg_-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',66,NULL,'local',NULL,NULL),(64,1,'uploads/all/65e3444c71611.jpeg','S5a4ded778f844eed83b8c942fb3c8786C-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',124,NULL,'local',NULL,NULL),(65,1,'uploads/all/65e3444c76731.jpeg','S6fb65452d1d74dde8497311fcc64083eL-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',230,NULL,'local',NULL,NULL),(66,1,'uploads/all/65e3444dbba6c.jpeg','S863a83be9b774314b255d73ea19670ca1-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',216,NULL,'local',NULL,NULL),(67,1,'uploads/all/65e3444dc7799.jpeg','Sa63e13a720674ede9379844a51a05895u-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',188,NULL,'local',NULL,NULL),(68,1,'uploads/all/65e3448de62a9.jpeg','Xiaomi-ANC-TOUR-PRO-2-Bluetooth-5-3-Earphones-Active-Noise-Reduction-Wireless-Earphones-TWS-Small.jpg_640x640.jpg_-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',66,NULL,'local',NULL,NULL),(69,5,'uploads/all/65e433bb729ca.jpeg','65e3444dbba6c.jpeg','jpeg','image',195,NULL,'local',NULL,NULL),(70,5,'uploads/all/65e433bb7395b.jpeg','65e3444c71611.jpeg','jpeg','image',113,NULL,'local',NULL,NULL),(71,5,'uploads/all/65e433bcaa59e.jpeg','65e3444c76731.jpeg','jpeg','image',212,NULL,'local',NULL,NULL),(72,5,'uploads/all/65e455c84914c.jpeg','S5868909df7ff48a0a2699d8def86e19b4-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',100,NULL,'local',NULL,NULL),(73,5,'uploads/all/65e455c84f73c.jpeg','S52e1e2273aa64865a27625a21d815cd62-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',119,NULL,'local',NULL,NULL),(74,5,'uploads/all/65e455c9729a0.jpeg','S1c454b59b1284394a9e3406d5b0747efF-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',151,NULL,'local',NULL,NULL),(75,5,'uploads/all/65e48d2304307.jpeg','World-Premiere-Xiaomi-Redmi-Watch-3-Active1-83-LCD-Display-Blood-Oxygen-Heart-Rate-Bluetooth.jpg_640x640.jpg_-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',46,NULL,'local',NULL,NULL),(76,5,'uploads/all/65e48e0adc536.jpeg','World-Premiere-Xiaomi-Redmi-Watch-3-Active1-83-LCD-Display-Blood-Oxygen-Heart-Rate-Bluetooth.jpg_640x640.jpg_-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',57,NULL,'local',NULL,NULL),(77,5,'uploads/all/65e48e1a7b619.jpeg','World-Premiere-Xiaomi-Redmi-Watch-3-Active1-83-LCD-Display-Blood-Oxygen-Heart-Rate-Bluetooth-with-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',52,NULL,'local',NULL,NULL),(78,5,'uploads/all/65e48f611e282.jpeg','S735f197bd3394ab4804b5e04d1768f4fS-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',51,NULL,'local',NULL,NULL),(79,5,'uploads/all/65e48f611c1e9.jpeg','S3ebb734440454f8590d3c0cfe44ba74bH-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',68,NULL,'local',NULL,NULL),(80,5,'uploads/all/65e48f611f257.jpeg','Sdd1121a0de10439890120dea127b78e08-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',51,NULL,'local',NULL,NULL),(81,5,'uploads/all/65e48f611ca92.webp','S442b061b8b0745c9ae4bae1b5b928877n.webp','webp','image',32,NULL,'local',NULL,NULL),(82,1,'uploads/all/65e4910190fd7.jpeg','World-Premiere-Xiaomi-Redmi-Watch-3-Active1-83-LCD-Display-Blood-Oxygen-Heart-Rate-Bluetooth.jpg_640x640.jpg_-ezgif.com-webp-to-jpg-converter.jpg','jpeg','image',57,NULL,'local',NULL,NULL),(83,5,'uploads/all/65e5d2d232257.webp','Xiaomi-REDMI-Wireless-Earphone-Noise-Reducting-Bluetooth-Earbuds-HiFi-Stereo-In-Ear-Headset-Subwoofer-Headphones-Handsfree.jpg_640x640.22jpg_.webp','webp','image',28,NULL,'local',NULL,NULL),(84,5,'uploads/all/65e5d2fd7be3c.webp','Xiaomi-REDMI-Wireless-Earphone-Noise-Reducting-Bluetooth-Earbuds-HiFi-Stereo-In-Ear-Headset-Subwoofer-Headphones-Handsfree.jpg_640x151515640.jpg_.webp','webp','image',25,NULL,'local',NULL,NULL),(85,5,'uploads/all/65e5d3116c10f.webp','Xiaomi-REDMI-Wireless-Earphone-Noise-Reducting-Bluetooth-Earbuds-HiFi-Stereo-In-Ear-Headset-Subwoofer-Headphones-Handsfree.jpg_.webp','webp','image',40,NULL,'local',NULL,NULL),(86,5,'uploads/all/65e5d312b3515.webp','Xiaomi-REDMI-Wireless-Earphone-Noise-Reducting-Bluetooth-Earbuds-HiFi-Stereo-In-Ear-Headset-Subwoofer-Headphones-Handsfree.jpg_640x640.jpg_.webp','webp','image',27,NULL,'local',NULL,NULL),(87,5,'uploads/all/65e5d407512e2.webp','S950fcb1a3f5a4f16845d80b1eef81d94h.webp','webp','image',47,NULL,'local',NULL,NULL),(88,5,'uploads/all/65e5d4074c5ef.webp','S01ea41f5c03a44118ba1653c1f954323p.webp','webp','image',34,NULL,'local',NULL,NULL),(89,5,'uploads/all/65e5d409356fb.webp','S8c079e621c60438f98a23a3464160b49n.webp','webp','image',57,NULL,'local',NULL,NULL),(90,1,'uploads/all/65e5dde87da69.webp','Xiaomi-REDMI-Wireless-Earphone-Noise-Reducting-Bluetooth-Earbuds-HiFi-Stereo-In-Ear-Headset-Subwoofer-Headphones-Handsfree.jpg_640x640.22jpg_.webp','webp','image',28,NULL,'local',NULL,NULL);
CREATE TABLE `mega_menu_ads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `link` varchar(500) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `mega_menu_bottom_panels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `menu_id` bigint(20) unsigned NOT NULL,
  `brand_id` bigint(20) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT 978437,
  `is_newtab` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `mega_menu_right_panels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `menu_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT 978437,
  `is_newtab` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `menu_columns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint(20) unsigned NOT NULL,
  `column` varchar(191) NOT NULL,
  `size` varchar(191) NOT NULL,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_columns_menu_id_foreign` (`menu_id`),
  CONSTRAINT `menu_columns_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `menu_columns` VALUES (1,5,'Interior decoration','1/3',NULL,0,'2024-01-28 13:59:46','2024-01-28 14:03:35'),(2,6,'eBooks','1/3',NULL,0,'2024-02-11 07:14:11','2024-02-11 07:17:57'),(3,6,'Kindle','1/3',NULL,987678,'2024-02-11 07:17:43','2024-02-11 07:17:43'),(4,6,'Paperback','1/3',NULL,987678,'2024-02-11 07:19:22','2024-02-11 07:19:22'),(5,7,'Smart electronics','1/3',NULL,0,'2024-03-02 10:48:40','2024-03-02 13:53:44'),(6,7,'Home Electronics','1/3',NULL,987678,'2024-03-03 09:40:29','2024-03-03 09:40:29');
CREATE TABLE `menu_elements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint(20) unsigned NOT NULL,
  `column_id` bigint(20) unsigned DEFAULT NULL,
  `type` varchar(191) NOT NULL,
  `element_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `link` varchar(191) DEFAULT NULL,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT 0,
  `show` tinyint(1) NOT NULL DEFAULT 0,
  `is_newtab` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `menu_elements` VALUES (2,1,NULL,'link',NULL,'Appstore',NULL,'#',NULL,2,0,0,NULL,NULL),(3,2,NULL,'page',14,'Track Orders',NULL,NULL,NULL,1,0,0,NULL,NULL),(4,2,NULL,'page',16,'Compare',NULL,NULL,NULL,2,0,0,NULL,NULL),(5,2,NULL,'page',8,'My Wish List',NULL,NULL,NULL,3,0,0,NULL,NULL),(6,2,NULL,'page',13,'Help & Contact Us',NULL,NULL,NULL,4,0,0,NULL,NULL),(7,2,NULL,'function',1,'Lang & Currency',NULL,NULL,NULL,5,0,0,NULL,NULL),(8,2,NULL,'page',7,'My Cart',NULL,NULL,NULL,6,0,0,NULL,NULL),(9,1,NULL,'link',NULL,'Playstore',NULL,'#',NULL,1,0,0,NULL,NULL),(10,3,NULL,'link',NULL,'Home',NULL,'https://www.emarketzone.com/',NULL,1,0,0,'2024-01-28 13:43:41','2024-01-28 15:04:36'),(11,3,NULL,'page',3,'Blog',NULL,NULL,NULL,3,0,0,'2024-01-28 13:44:22','2024-02-18 09:31:40'),(12,3,NULL,'link',NULL,'Contact Us',NULL,'/contact-us',NULL,4,0,0,'2024-01-28 13:46:17','2024-02-18 09:31:40'),(13,3,NULL,'page',1,'About Us',NULL,NULL,NULL,5,0,0,'2024-01-28 13:46:41','2024-02-18 09:31:40'),(14,5,1,'category',1,'3D Wall Panels',NULL,NULL,NULL,1,0,0,'2024-01-28 14:03:43','2024-01-28 14:03:47'),(15,3,NULL,'link',NULL,'Pages',NULL,'#',NULL,6,0,0,'2024-02-03 07:57:04','2024-02-18 09:31:40'),(16,3,NULL,'page',4,'Become A Merchant',NULL,NULL,15,3,0,0,'2024-02-03 07:57:49','2024-02-10 15:47:03'),(17,3,NULL,'page',12,'Referral',NULL,NULL,15,1,0,0,'2024-02-03 07:58:25','2024-02-10 15:47:03'),(19,3,NULL,'page',22,'Affiliate',NULL,NULL,15,2,0,0,'2024-02-03 08:06:24','2024-02-10 15:47:03'),(20,3,NULL,'link',NULL,'Seller Login',NULL,'https://www.emarketzone.com/seller/login',15,4,0,0,'2024-02-10 15:48:21','2024-02-10 15:48:26'),(21,6,3,'category',6,'Computers & Technology',NULL,NULL,NULL,1,0,0,'2024-02-11 07:21:02','2024-02-11 07:21:10'),(22,6,2,'category',7,'Computers Technology',NULL,NULL,NULL,1,0,0,'2024-02-12 04:46:06','2024-02-12 04:46:12'),(25,3,NULL,'category',2,'Books',NULL,NULL,30,2,0,0,'2024-02-18 09:31:01','2024-02-18 09:38:34'),(30,3,NULL,'link',NULL,'Category',NULL,'#',NULL,2,0,0,'2024-02-18 09:31:22','2024-02-18 09:31:34'),(31,3,NULL,'category',1,'3D Wall Panels',NULL,NULL,30,1,0,0,'2024-02-18 09:38:19','2024-02-18 09:38:34'),(32,6,3,'category',9,'Programming',NULL,NULL,NULL,2,0,0,'2024-02-18 09:46:48','2024-02-18 09:46:55'),(33,6,2,'category',10,'Engineering',NULL,NULL,NULL,2,0,0,'2024-02-23 04:17:01','2024-02-23 04:17:07'),(34,6,2,'category',11,'Business & Money',NULL,NULL,NULL,3,0,0,'2024-02-28 04:02:21','2024-02-28 04:02:32'),(35,7,5,'category',13,'Smart Watches',NULL,NULL,NULL,1,0,0,'2024-03-02 10:49:30','2024-03-02 13:54:26'),(36,7,5,'category',14,'Earphones & Headphones',NULL,NULL,NULL,2,0,0,'2024-03-02 13:52:38','2024-03-02 13:55:40'),(37,7,6,'category',15,'Home Electronics',NULL,NULL,NULL,1,0,0,'2024-03-03 09:39:53','2024-03-03 09:40:35');
CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `menu_type` varchar(191) NOT NULL,
  `menu_position` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `has_parent` int(10) unsigned DEFAULT NULL,
  `order_by` int(10) unsigned NOT NULL DEFAULT 865435,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `menus` VALUES (1,'Top Navbar left menu','top-navbar-left-menu',NULL,'normal_menu','top_navbar',1,NULL,1,NULL,NULL,'2024-01-23 11:19:54','2024-01-23 11:19:54'),(2,'Top Navbar right menu','top-navbar-right-menu',NULL,'normal_menu','top_navbar',1,NULL,2,NULL,NULL,'2024-01-23 11:19:54','2024-01-23 11:19:54'),(3,'Middle Menu','middle-menu',NULL,'normal_menu','main_menu',1,NULL,865435,1,NULL,'2024-01-28 13:42:07','2024-01-28 13:42:07'),(4,'All Categories','all-categories',NULL,'multi_mega_menu','main_menu',1,NULL,865435,1,NULL,'2024-01-28 13:48:29','2024-01-28 13:48:29'),(5,'Home & Garden','home-&-garden',NULL,'mega_menu','main_menu',1,1,865435,1,1,'2024-01-28 13:59:46','2024-01-28 14:01:19'),(6,'Books','books',NULL,'mega_menu','main_menu',1,1,865435,1,1,'2024-02-11 07:14:11','2024-02-11 07:21:53'),(7,'Consumer Electronics','consumer-electronics',NULL,'mega_menu','main_menu',1,1,865435,1,1,'2024-03-02 10:48:40','2024-03-02 15:06:13');
CREATE TABLE `merchant_contents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `pricing_id` varchar(191) DEFAULT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `mainTitle` varchar(191) DEFAULT NULL,
  `subTitle` varchar(191) DEFAULT NULL,
  `Maindescription` text DEFAULT NULL,
  `pricing` varchar(191) DEFAULT NULL,
  `benifitTitle` varchar(191) DEFAULT NULL,
  `benifitDescription` text DEFAULT NULL,
  `howitworkTitle` varchar(191) DEFAULT NULL,
  `howitworkDescription` text DEFAULT NULL,
  `pricingTitle` varchar(191) DEFAULT NULL,
  `pricingDescription` text DEFAULT NULL,
  `sellerRegistrationTitle` varchar(191) DEFAULT NULL,
  `sellerRegistrationDescription` text DEFAULT NULL,
  `queryTitle` varchar(191) DEFAULT NULL,
  `queryDescription` text DEFAULT NULL,
  `faqTitle` varchar(191) DEFAULT NULL,
  `faqDescription` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `merchant_contents` VALUES (1,NULL,NULL,'ALL YOU JUST NEED IS START SELLING','Become A Merchant','ALL YOU JUST NEED IS START SELLING','<p>Formal educational training is not required to become this type of merchant. However, having a degree in a related field, such as business or communications.</p>','Starting @ $7.00/month','Benefits','<p>One of the most important benefits a merchant account can bring is the ability to accept credit and debit cards. Credit cards and debit cards continue grow in preference among customers, gaining ground as the new norm.</p>','How it works','<p>Feed your mind with fascinating facts about the world around us.','Merchant Pricing','<p>Pricing is the process whereby a business sets the price at which it will sell its products and services, and may be part of the business marketing plan</p>','Register','<p>A seller registration form is a registration form used by businesses or organizations who sell items or services at a location.</p>','Send us your query','<p>A query is a question or a request for information expressed in a formal manner.</p>','Frequently Asked Questions','<p>A list of questions and answers relating to a particular subject, especially one giving basic information for users of a website.</p>','2024-01-23 11:19:52','2024-01-23 11:19:52');
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=393 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` VALUES (1,'2014_07_12_000546_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_02_08_105647_create_blocks_contents_tables',1),(4,'2019_08_19_000000_create_failed_jobs_table',1),(5,'2019_12_14_000001_create_personal_access_tokens_table',1),(6,'2020_04_23_090029_create_modules_table',1),(7,'2020_07_11_063308_create_intro_prefix_table',1),(8,'2020_07_11_161843_crate_table_currencie_table',1),(9,'2020_07_11_162112_create_language_table',1),(10,'2020_07_12_044721_create_date_formats_table',1),(11,'2020_07_13_061051_create_timezone_table',1),(12,'2020_07_20_095501_create_permissions_tables',1),(13,'2020_07_20_095817_create_role_permission_tables',1),(14,'2020_07_25_101854_create_support_ticket_category_table',1),(15,'2020_07_25_102024_create_support_ticket_piority_table',1),(16,'2020_07_25_135453_create_support_tickets_table',1),(17,'2020_07_26_093838_create_ticket_message_files_table',1),(18,'2020_08_07_124026_create_support_ticket_files_table',1),(19,'2020_08_09_044229_create_ticket_messages_table',1),(20,'2020_08_09_092856_create_ticket_statuses_table',1),(21,'2020_09_02_043711_create_unit_types_table',1),(22,'2020_09_02_052045_create_brands_table',1),(23,'2020_09_02_054852_create_business_settings_table',1),(24,'2020_09_02_084215_create_general_settings_table',1),(25,'2020_09_07_093017_create_products_table',1),(26,'2020_09_07_093446_create_product_variations_table',1),(27,'2020_09_09_120113_create_log_activity_table',1),(28,'2020_09_10_075009_create_roles_table',1),(29,'2020_09_23_092712_create_attendances_table',1),(30,'2020_09_24_130332_create_infix_module_managers_table',1),(31,'2020_10_02_034421_create_product_sku_table',1),(32,'2020_10_28_130927_create_payment_methods_table',1),(33,'2020_11_26_042410_create_features_table',1),(34,'2020_11_26_174602_create_holidays_table',1),(35,'2020_11_27_061245_create_policies_table',1),(36,'2020_11_29_050753_create_about_us_table',1),(37,'2020_11_29_101117_create_terms_conditions_table',1),(38,'2020_11_30_060928_create_contact_contents_table',1),(39,'2020_11_30_084330_create_careers_table',1),(40,'2020_11_30_112735_create_merchant_contents_table',1),(41,'2020_12_01_040841_create_benifits_table',1),(42,'2020_12_01_103212_create_categories_table',1),(43,'2020_12_02_070049_create_subscribe_contents_table',1),(44,'2020_12_03_063135_create_faqs_table',1),(45,'2020_12_03_095639_create_working_processes_table',1),(46,'2020_12_04_043310_create_pricings_table',1),(47,'2020_12_07_102001_create_return_exchanges_table',1),(48,'2020_12_07_103420_create_events_table',1),(49,'2020_12_07_131939_create_dynamic_pages_table',1),(50,'2020_12_07_135925_create_to_dos_table',1),(51,'2020_12_09_121552_create_groups_table',1),(52,'2020_12_10_102035_create_themes_table',1),(53,'2020_12_13_113438_create_category_images_table',1),(54,'2020_12_14_122951_create_social_providers_table',1),(55,'2020_12_14_123034_create_profiles_table',1),(56,'2020_12_15_122112_create_brand_category_table',1),(57,'2020_12_17_051339_create_countries_table',1),(58,'2020_12_17_104946_create_attributes_table',1),(59,'2020_12_17_105259_create_attribute_values_table',1),(60,'2020_12_18_082213_create_tags_table',1),(61,'2020_12_21_120908_create_subscriptions_table',1),(62,'2020_12_22_064826_add_sort_id_groups_table',1),(63,'2020_12_22_132712_create_contacts_table',1),(64,'2020_12_22_141042_create_in_queries_table',1),(65,'2020_12_23_084911_create_staff_table',1),(66,'2020_12_23_092946_create_staff_documents_table',1),(67,'2020_12_23_113630_create_departments_table',1),(68,'2020_12_23_115353_create_product_galary_images_table',1),(69,'2020_12_23_115414_create_product_tags_table',1),(70,'2020_12_25_051437_create_footer_widgets_table',1),(71,'2020_12_25_113053_add_user_type_to_users_table_after_column_email',1),(72,'2020_12_28_043226_create_colors_table',1),(73,'2020_12_31_052152_create_seller_accounts_table',1),(74,'2020_12_31_053135_create_seller_business_information_table',1),(75,'2020_12_31_053153_create_seller_bank_accounts_table',1),(76,'2020_12_31_053245_create_seller_warehouse_addresses_table',1),(77,'2020_12_31_053300_create_seller_return_addresses_table',1),(78,'2020_12_31_055257_create_blog_categories_table',1),(79,'2020_12_31_081926_create_blog_posts_table',1),(80,'2021_01_03_061303_create_seller_social_links_table',1),(81,'2021_01_03_071324_create_blog_category_post_table',1),(82,'2021_01_03_071403_create_blog_post_tag_table',1),(83,'2021_01_03_120216_create_seller_products_table',1),(84,'2021_01_05_105821_create_blog_comments_table',1),(85,'2021_01_05_110423_create_blog_comment_replays_table',1),(86,'2021_01_06_060708_create_suppliers_table',1),(87,'2021_01_09_164635_create_seller_product_s_k_us_table',1),(88,'2021_01_09_180037_create_notifications_table',1),(89,'2021_01_10_140156_create_carts_table',1),(90,'2021_01_10_163151_create_blog_post_likes_table',1),(91,'2021_01_21_140241_create_customer_addresses_table',1),(92,'2021_01_24_131808_create_orders_table',1),(93,'2021_01_24_173216_create_order_package_details_table',1),(94,'2021_01_24_173329_create_order_product_details_table',1),(95,'2021_01_27_114823_create_digital_files_table',1),(96,'2021_01_27_174448_create_wishlists_table',1),(97,'2021_01_28_185049_create_wallet_balances_table',1),(98,'2021_01_31_113723_create_home_page_sections_table',1),(99,'2021_02_01_122047_create_homepage_custom_products_table',1),(100,'2021_02_01_122152_create_homepage_custom_categories_table',1),(101,'2021_02_01_122214_create_homepage_custom_brands_table',1),(102,'2021_02_01_142114_create_bank_details_table',1),(103,'2021_02_02_155129_create_order_payments_table',1),(104,'2021_02_03_142230_create_flash_deals_table',1),(105,'2021_02_03_143135_create_flash_deal_products_table',1),(106,'2021_02_04_141339_create_order_delivery_states_table',1),(107,'2021_02_07_105737_create_news_letters_table',1),(108,'2021_02_07_173109_create_bulk_s_m_s_table',1),(109,'2021_02_08_111855_create_email_templates_table',1),(110,'2021_02_08_142747_create_refund_reasons_table',1),(111,'2021_02_08_193641_create_coupons_table',1),(112,'2021_02_09_104911_create_shipping_methods_table',1),(113,'2021_02_09_130341_create_coupon_products_table',1),(114,'2021_02_09_150432_create_refund_requests_table',1),(115,'2021_02_09_152335_create_refund_request_details_table',1),(116,'2021_02_09_153503_create_refund_states_table',1),(117,'2021_02_09_155555_create_refund_products_table',1),(118,'2021_02_10_163156_create_refund_processes_table',1),(119,'2021_02_10_182354_create_referral_codes_table',1),(120,'2021_02_10_184539_create_delivery_processes_table',1),(121,'2021_02_11_123312_create_referral_code_setups_table',1),(122,'2021_02_13_125057_create_referral_uses_table',1),(123,'2021_02_14_170640_create_coupon_uses_table',1),(124,'2021_02_15_115409_create_customer_coupon_stores_table',1),(125,'2021_02_17_123320_create_product_reviews_table',1),(126,'2021_02_17_123429_create_seller_reviews_table',1),(127,'2021_02_17_123443_create_review_images_table',1),(128,'2021_02_17_123503_create_review_replies_table',1),(129,'2021_02_18_134139_create_product_up_sales_table',1),(130,'2021_02_18_134359_create_product_cross_sales_table',1),(131,'2021_02_18_134426_create_product_related_sales_table',1),(132,'2021_02_23_185648_create_menus_table',1),(133,'2021_02_23_194810_create_version_histories_table',1),(134,'2021_02_24_135826_create_menu_columns_table',1),(135,'2021_02_24_180335_create_menu_elements_table',1),(136,'2021_02_28_183320_create_multi_mega_menus_table',1),(137,'2021_03_02_130852_create_mega_menu_right_panels_table',1),(138,'2021_03_02_130927_create_mega_menu_bottom_panels_table',1),(139,'2021_03_03_175737_create_product_shippings_table',1),(140,'2021_03_08_110444_create_headers_table',1),(141,'2021_03_08_110507_create_header_category_panels_table',1),(142,'2021_03_08_110528_create_header_slider_panels_table',1),(143,'2021_03_08_110545_create_header_product_panels_table',1),(144,'2021_03_08_183219_create_new_user_zones_table',1),(145,'2021_03_08_183234_create_new_user_zone_products_table',1),(146,'2021_03_09_132336_create_header_new_user_zone_panels_table',1),(147,'2021_03_14_144759_create_new_user_zone_categories_table',1),(148,'2021_03_14_144834_create_new_user_zone_coupons_table',1),(149,'2021_03_17_192827_create_new_user_zone_coupon_categories_table',1),(150,'2021_03_18_173018_create_analytics_tools_table',1),(151,'2021_03_25_105021_create_states_table',1),(152,'2021_03_25_105054_create_cities_table',1),(153,'2021_03_31_144111_create_seller_commissions_table',1),(154,'2021_04_11_171145_create_sub_sellers_table',1),(155,'2021_04_12_173028_create_sub_seller_accesses_table',1),(156,'2021_04_18_111843_create_chart_of_accounts_table',1),(157,'2021_04_18_150157_create_payu_transactions_table',1),(158,'2021_04_20_134831_create_backendmenus_table',1),(159,'2021_04_20_134911_create_backendmenu_users_table',1),(160,'2021_04_21_104120_create_sidebars_table',1),(161,'2021_04_24_095314_create_bank_accounts_table',1),(162,'2021_04_25_165206_create_transactions_table',1),(163,'2021_05_04_155633_create_gst_taxes_table',1),(164,'2021_05_06_124337_create_order_package_gst_table',1),(165,'2021_05_17_122458_create_gift_cards_table',1),(166,'2021_05_17_125912_create_email_template_types_table',1),(167,'2021_05_17_171227_create_gift_card_uses_table',1),(168,'2021_05_17_194735_create_gift_card_galary_images_table',1),(169,'2021_05_19_160431_create_guest_order_details_table',1),(170,'2021_05_26_184426_create_inhouse_order_carts_table',1),(171,'2021_06_01_173615_create_recent_view_products_table',1),(172,'2021_06_12_173154_create_cancel_reasons_table',1),(173,'2021_06_15_112727_create_compares_table',1),(174,'2021_06_15_133043_create_visitor_histories_table',1),(175,'2021_06_15_133555_create_ignore_ip_table',1),(176,'2021_06_16_132331_create_dashboard_setup_table',1),(177,'2021_06_20_125028_create_search_terms_table',1),(178,'2021_06_24_122317_create_digital_file_downloads_table',1),(179,'2021_06_26_145008_create_seller_subcriptions_table',1),(180,'2021_06_26_181400_create_subscription_payment_info_table',1),(181,'2021_08_21_171154_create_customer_notifications_table',1),(182,'2021_08_24_111855_create_notification_settings_table',1),(183,'2021_08_25_111855_create_user_notification_settings_table',1),(184,'2021_10_17_164810_create_category_product_table',1),(185,'2021_10_21_114022_create_sms_templates_table',1),(186,'2021_10_21_115410_create_sms_template_types_table',1),(187,'2021_10_25_155921_GiftCardTag',1),(188,'2021_10_30_154040_email_template_for_multivendor',1),(189,'2021_10_30_183422_permission_for_multivendor',1),(190,'2021_10_30_191728_role_for_multivendor',1),(191,'2021_11_01_103053_sms_template_type_for_multivendor',1),(192,'2021_11_01_103347_sms_template_for_multivendor',1),(193,'2021_11_02_112411_email_template_type_for_multivendor',1),(194,'2021_11_28_124959_add_currency_format_column_to_general_settings',1),(195,'2021_11_30_163218_product_id_foreign_remove_to_carts_table',1),(196,'2021_12_05_171133_create_facebook_messages_table',1),(197,'2021_12_08_102035_create_admin_colors_table',1),(198,'2021_12_08_102035_create_theme_colors_table',1),(199,'2021_12_11_170536_add_row_customer_crud_permission_to_permissions_table',1),(200,'2021_12_13_110634_create_page_builder_permission_table',1),(201,'2021_12_13_140220_remove_reset_db_form_permission_table',1),(202,'2021_12_13_180444_add_session_id_to_carts_table',1),(203,'2021_12_15_112951_create_sms_gateway_settings_table',1),(204,'2021_12_19_104116_add_affiliate_module',1),(205,'2021_12_19_115013_add_otp_row_to_modules_table',1),(206,'2021_12_23_081812_add_page_builder_module',1),(207,'2021_12_26_125438_add_sms_gateway_bussiness_seeting_row_table',1),(208,'2021_12_27_130537_create_form_builder_permission_table',1),(209,'2021_12_27_131929_create_custom_forms_table',1),(210,'2021_12_28_151539_add_others_column_to_users_table',1),(211,'2021_12_29_131650_add_bkash_module_table',1),(212,'2022_01_02_112510_add_note_column_to_orders_table',1),(213,'2022_01_02_114714_add_others_field_to_contacts_table',1),(214,'2022_01_04_131457_change_description_column_to_dynamic_pages_table',1),(215,'2022_01_10_104731_add_ssl_commerz_module',1),(216,'2022_01_12_125313_modify_superadmin_role_to_roles_table',1),(217,'2022_01_12_172422_create_carriers_table',1),(218,'2022_01_12_202221_remove_multivendor_permission_issue_from_role_permission',1),(219,'2022_01_12_203914_add_role_permission_to_multivendor_module',1),(220,'2022_01_13_095627_modify_shipping_method_table',1),(221,'2022_01_13_122553_create_shipping_configurations_table',1),(222,'2022_01_13_122658_add_default_role_permission_for_admin_role',1),(223,'2022_01_14_092734_add_lead_module_table',1),(224,'2022_01_17_175615_add_carrier_order_id_field_to_order_package_details_table',1),(225,'2022_01_18_130411_change_currency_rate_field',1),(226,'2022_01_18_152854_add_weight_field_to_product_sku_table',1),(227,'2022_01_20_125652_add_mercado_pago_module',1),(228,'2022_01_21_101328_add_permission_sidebar_for_configuration_marketing_module',1),(229,'2022_01_24_171847_add_admin_msg_field_to_notification_settings',1),(230,'2022_01_24_183901_add_shiprocket_module',1),(231,'2022_01_25_143449_create_pickup_locations_table',1),(232,'2022_02_01_160034_add_permission_sidebar_for_shipping_module',1),(233,'2022_02_02_094454_add_default_position_field_to_sidebars_table',1),(234,'2022_02_04_095633_add_height_weight_info_to_order_package_details_table',1),(235,'2022_02_05_105348_shipping_method_user_assign_table',1),(236,'2022_02_05_171836_add_column_to_refund_request_details_table',1),(237,'2022_02_05_193256_add_notification_setting_for_multivendor',1),(238,'2022_02_07_103238_set_pickup_point_value_in_order_package_details_column',1),(239,'2022_02_07_142059_create_label_configs_table',1),(240,'2022_02_07_163154_add_new_permission_to_shipping_module',1),(241,'2022_02_08_175019_add_multivendor_to_modules',1),(242,'2022_02_11_082245_add_created_by_field_to_carriers_table',1),(243,'2022_02_11_090246_create_seller_wise_carrier_configs_table',1),(244,'2022_02_14_110834_modify_shipping_configurations_table',1),(245,'2022_02_14_124826_seller_default_shipping_config',1),(246,'2022_02_14_175028_seller_default_carrier_table',1),(247,'2022_02_14_175730_seller_default_shipping_rates_table',1),(248,'2022_02_15_161758_packing_permision_add_to_shipping_orders',1),(249,'2022_02_16_131625_add_customer_address_permission_table',1),(250,'2022_02_16_174330_create_package_wise_seller_commisions_table',1),(251,'2022_02_16_183448_add_seller_commision_chart_of_account',1),(252,'2022_02_17_153347_add_is_paid_column_to_order_package_details',1),(253,'2022_02_21_174115_add_giftcard_default_template',1),(254,'2022_02_22_094455_create_g_s_t_groups_table',1),(255,'2022_02_22_180442_add_gst_group_to_products',1),(256,'2022_02_24_174922_previous_order_amount_fix',1),(257,'2022_02_24_184058_rename_subseller_name_from_subsellar',1),(258,'2022_02_25_171629_create_default_pickup_for_exsisting_seller',1),(259,'2022_02_28_094234_alter_customer_addresses_table',1),(260,'2022_03_03_104504_create_xml_sitemaps_table',1),(261,'2022_03_03_180118_add_homepage_seo_meta_to_general_settings_table',1),(262,'2022_03_04_154236_add_preloader_info_to_general_settings',1),(263,'2022_03_07_195511_minimum_shopping_amount_add_to_shipping_methods_table',1),(264,'2022_03_10_112409_create_order_address_details_table',1),(265,'2022_03_11_151758_create_media_managers_table',1),(266,'2022_03_14_201529_file_storage_permission_sidebar_to_root',1),(267,'2022_03_15_152222_add_previus_img_to_media_managers',1),(268,'2022_03_16_185315_create_used_media_table',1),(269,'2022_03_21_192609_add_password_reset_email_template',1),(270,'2022_03_25_182815_index_column_id_for_tables',1),(271,'2022_03_28_105150_change_color_scheme_permision_route_name',1),(272,'2022_04_06_095709_change_default_dashboard_border_color',1),(273,'2022_04_06_151218_additional_field_to_products_table',1),(274,'2022_04_18_144137_add_pickup_delivery_info_to_orders_table',1),(275,'2022_04_19_114438_add_goldPrice_module_to_module_manager',1),(276,'2022_04_22_123127_add_is_updated_to_carts_add_category_show_to_general_settings',1),(277,'2022_05_12_141838_add_two_fields_to_general_settings_table',1),(278,'2022_05_12_153301_add_social_links_to_general_settings_table',1),(279,'2022_05_17_151800_inhouse_order_permission_change',1),(280,'2022_05_18_115653_inhouse_orders_payment_create',1),(281,'2022_05_28_124453_add_subscription_type_field_to_seller_payment_info',1),(282,'2022_06_09_171902_tax_add_on_order_product_details',1),(283,'2022_06_20_125007_blog_permision_issue_fixed',1),(284,'2022_07_04_122335_add_is_buy_now_to_cart_table',1),(285,'2022_07_06_123724_homepage_data_section_add',1),(286,'2022_07_06_181409_create_home_page_custom_sections_table',1),(287,'2022_07_07_121157_create_mega_menu_ads_table',1),(288,'2022_07_08_124743_promotion_ads_bar_to_table',1),(289,'2022_07_14_191002_create_login_pages_table',1),(290,'2022_07_15_173807_AddColumnInThemeTable',1),(291,'2022_07_18_193728_add_wholesale_module_to_modules',1),(292,'2022_07_20_160741_add_show_title_to_new_user_zone',1),(293,'2022_07_22_111046_create_footer_contents_table',1),(294,'2022_08_01_190504_add_googlemerchantcenter_to_modules',1),(295,'2022_08_16_133115_min_max_sale_pice_update_to_seller_products_table',1),(296,'2022_08_24_164715_create_device_tokens_table',1),(297,'2022_08_25_120510_create_push_notifications_table',1),(298,'2022_08_29_125311_create_cache_table',1),(299,'2022_08_29_125651_create_sessions_table',1),(300,'2022_08_31_132235_backend_menu_multivendor',1),(301,'2022_09_15_173450_add_permission_menu_for_bulk_product_upload',1),(302,'2022_09_19_102954_add_custom_asset_to_menu_and_permission_table',1),(303,'2022_09_19_192543_create_jobs_table',1),(304,'2022_09_21_171230_add_msegat_sms_gateway',1),(305,'2022_09_30_114309_add_backendmenus_customers_bulkupload_table',1),(306,'2022_10_03_191831_add_storage_cdn_module_into_modules',1),(307,'2022_10_04_190224_remove_visitor_permission_table',1),(308,'2022_10_07_185811_add_shipping_amount_multiply_with_qty_to_shipping_configurations_table',1),(309,'2022_10_11_151616_create_seller_wise_payment_gateways_table',1),(310,'2022_10_12_182627_add_send_digital_file_template_to_email_template_table',1),(311,'2022_10_18_102123_add_permission_for_social_link',1),(312,'2022_10_18_180910_follow_seller_table',1),(313,'2022_10_24_171609__add_permission_for_followers',1),(314,'2022_11_11_122429_add_frontendmultilanguage_module_to_modules',1),(315,'2022_11_11_122503_add_intshipping_module_to_modules',1),(316,'2022_12_02_142831_menu_icon_setup_table',1),(317,'2022_12_07_192021_header_name_change_to_slider_permission_table',1),(318,'2022_12_08_105530_footer_background_and_footer_text_color_migration_table',1),(319,'2022_12_08_200243_seller_review_review_change_nullable_table',1),(320,'2022_12_19_132006_add_clubpoint_module_to_modules',1),(321,'2022_12_21_104157_add_social_link_translate_name_change_table',1),(322,'2022_12_29_121511_homepage_custome_section_category_add_part_two_increment_table',1),(323,'2023_01_11_162827_add_seller-commisions_slug_collunm_table',1),(324,'2023_01_18_123451_sidbarmanager_translate_name_change_table',1),(325,'2023_01_18_134453_add_customer_panel_translate_name_change_table',1),(326,'2023_01_20_173911_create_digital_gift_cards_table',1),(327,'2023_01_23_223450_create_add_gift_cards_table',1),(328,'2023_01_25_172821_add_coupon_limit_table',1),(329,'2023_01_26_124606_create_gift_coupons_table',1),(330,'2023_02_09_144253_create_image_refund_requests_table',1),(331,'2023_02_10_190957_shipping_amount_back_refund_complete',1),(332,'2023_02_13_124819_create_follower_send_notification_table',1),(333,'2023_02_15_114332_add_pos_module_to_modules',1),(334,'2023_03_15_173712_notification_settings_slug_generate',1),(335,'2023_03_21_121249_add_gst_or_vat_number_column',1),(336,'2023_03_23_095847_create_gift_card_xtra_column',1),(337,'2023_03_23_164338_homepage_custome_section_popular_search_and_about_section_add',1),(338,'2023_03_24_103254_general_settings_module_manager_name_update',1),(339,'2023_04_05_132459_add_is_received_column_in_order_table',1),(340,'2023_04_06_141538_create_checkout_field_visibility_table',1),(341,'2023_04_06_142908_alter_column_of_customer_addresses_table',1),(342,'2023_04_07_092553_create_permission_for_checkout_field_visibility_setup_table',1),(343,'2023_04_11_172848_add_auction_products_module_to_modules',1),(344,'2023_04_12_112555_create_one_clickorder_receive_statuses_table',1),(345,'2023_04_13_121616_variant_sku_prefix_column_add_products_table',1),(346,'2023_04_14_110829_homepage_section_theme_two_update',1),(347,'2023_04_26_091707_price_with_vat_column_add',1),(348,'2023_05_01_153026_add_column_disable_seller_plan_at_general_settings_table',1),(349,'2023_05_01_173819_add_tax_id_column_table',1),(350,'2023_05_02_101256_add_new_row_in_seller_commissions_table',1),(351,'2023_05_03_160833_add_category_limit_column_in_pricing_table',1),(352,'2023_05_08_115504_add_checkpincode_module_to_modules',1),(353,'2023_05_13_114815_add_notification_settings_and_order_sms_templete_items_table',1),(354,'2023_05_25_103413_add_tabby_payment_gateway_module_to_modules',1),(355,'2023_05_25_180548_payment_methods_slug_column_add',1),(356,'2023_07_11_164721_change_datatype_of_meta_tags_column_on_general_setting_table',1),(357,'2023_08_01_153152_make_multivendor_module_as_free',1),(358,'2023_08_06_120129_add_users_login_checkout_column_on_general_settings_table',1),(359,'2023_08_23_103825_add_user_manual_activation_field_on_general_settings_table',1),(360,'2023_08_25_103732_add_registration_success_url_column_on_general_settings_table',1),(361,'2023_09_04_193747_add_user_registration_email_template_manual_activation',1),(362,'2023_09_18_122630_update_role_permission_on_permissions_table',1),(363,'2023_10_28_153259_create_slug_column_on_payment_methods_table',1),(364,'2023_11_16_180709_add_short_codes_column_on_email_templates_table',1),(365,'2023_11_16_181000_update_short_codes_on_email_templates_table',1),(366,'2022_07_05_151639_create_wholesale_prices_table',2),(367,'2021_12_05_131251_create_affiliate_module_permission_table',3),(368,'2021_12_05_141246_create_affiliate_links_table',4),(369,'2021_12_06_102647_create_affiliate_link_visit_track_users_table',5),(370,'2021_12_19_121253_create_affiliate_referral_users_table',6),(371,'2021_12_06_130347_create_affiliate_configurations_table',7),(372,'2021_12_06_173303_create_affiliate_referral_payments_table',8),(373,'2021_12_07_100911_create_affiliate_user_wallets_table',9),(374,'2021_12_07_152509_create_affiliate_withdraws_table',10),(375,'2021_12_19_172520_add_affiliate_module_user_info_table',11),(376,'2021_12_20_123308_create_affiliate_category_commissions_table',12),(377,'2022_01_04_164053_add_affiliate_page_to_dynamic_page_table',13),(378,'2022_06_03_101649_convert_affiliate_role_customer',14),(379,'2022_06_03_170630_relation_build_affiliate_to_order',15),(380,'2022_06_08_190913_add_new_permissions_for_user_details_block_user',16),(381,'2022_09_01_172539_backend_menu_affiliate',17),(382,'2022_11_16_153129_create_point_table',18),(383,'2022_11_23_132624_create_club_point_wallets_table',19),(384,'2022_11_25_181214_create_club_point_permission',20),(385,'2024_01_19_171533_add_AuctionProduct_column_on_general_settings_table',21),(386,'2023_03_16_104846_create_auctions_table',22),(387,'2023_03_17_101430_create_auction_bids_table',23),(388,'2023_03_24_123728_insert_auction_template_type_in_email_template_types_table',24),(389,'2023_03_24_125444_insert_auction_template_in_email_templates_table',25),(390,'2023_03_27_141804_insert_auction_order_cancel_in_email_template_types_table',26),(391,'2023_03_27_142118_insert_auction_order_cancel_in_email_templates_table',27),(392,'2023_04_03_105026_create_auction_products_permission',28);
CREATE TABLE `modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `modules` VALUES (1,'AmazonS3',1,0,'2024-01-23 11:19:50','2024-01-23 11:19:50'),(4,'Affiliate',1,3,'2024-01-23 11:19:57','2024-01-23 15:55:23'),(5,'Otp',1,3,'2024-01-23 11:19:57','2024-01-23 11:19:57'),(6,'Bkash',0,5,'2024-01-23 11:19:57','2024-01-23 11:19:57'),(7,'SslCommerz',0,5,'2024-01-23 11:19:57','2024-01-23 11:19:57'),(8,'Lead',0,6,'2024-01-23 11:19:57','2024-01-23 11:19:57'),(9,'MercadoPago',0,7,'2024-01-23 11:19:57','2024-01-23 11:19:57'),(10,'ShipRocket',0,8,'2024-01-23 11:19:57','2024-01-23 11:19:57'),(11,'GoldPrice',1,9,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(12,'WholeSale',1,10,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(13,'GoogleMerchantCenter',1,11,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(14,'StorageCDN',1,12,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(15,'FrontendMultiLang',1,13,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(16,'INTShipping',1,14,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(17,'ClubPoint',1,15,'2024-01-23 11:19:58','2024-01-23 11:19:58'),(18,'POS',1,17,'2024-01-23 11:19:59','2024-01-23 11:19:59'),(19,'AuctionProducts',1,18,'2024-01-23 11:19:59','2024-01-23 11:19:59'),(20,'CheckPincode',1,18,'2024-01-23 11:19:59','2024-01-23 11:19:59'),(21,'Tabby',1,19,'2024-01-23 11:19:59','2024-01-23 11:19:59');
CREATE TABLE `multi_mega_menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `multi_mega_menu_id` bigint(20) unsigned NOT NULL,
  `menu_id` bigint(20) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT 768989,
  `is_newtab` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `multi_mega_menus` VALUES (1,'Home & Garden',4,5,2,0,'2024-01-28 13:59:58','2024-03-02 15:06:21'),(2,'Books',4,6,3,0,'2024-02-11 07:21:53','2024-03-02 15:06:21'),(3,'Consumer Electronics',4,7,1,0,'2024-03-02 15:06:13','2024-03-02 15:06:21');
CREATE TABLE `new_user_zone_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `new_user_zone_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `new_user_zone_categories` VALUES (1,1,1,1,'2024-01-28 16:10:40','2024-01-28 16:10:40');
CREATE TABLE `new_user_zone_coupon_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `new_user_zone_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `position` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `new_user_zone_coupon_categories` VALUES (1,1,1,1,'2024-01-28 16:10:40','2024-01-28 16:10:40');
CREATE TABLE `new_user_zone_coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `new_user_zone_id` bigint(20) unsigned NOT NULL,
  `coupon_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `new_user_zone_coupons` VALUES (1,1,1,'2024-01-28 16:12:26','2024-01-28 16:50:33');
CREATE TABLE `new_user_zone_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `new_user_zone_id` bigint(20) unsigned NOT NULL,
  `seller_product_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `new_user_zone_products_new_user_zone_id_foreign` (`new_user_zone_id`),
  KEY `new_user_zone_products_seller_product_id_foreign` (`seller_product_id`),
  CONSTRAINT `new_user_zone_products_new_user_zone_id_foreign` FOREIGN KEY (`new_user_zone_id`) REFERENCES `new_user_zones` (`id`) ON DELETE CASCADE,
  CONSTRAINT `new_user_zone_products_seller_product_id_foreign` FOREIGN KEY (`seller_product_id`) REFERENCES `seller_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `new_user_zone_products` VALUES (1,1,1,1,'2024-01-28 16:10:40','2024-01-28 16:10:40');
CREATE TABLE `new_user_zones` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `sub_title` varchar(191) DEFAULT NULL,
  `background_color` varchar(191) DEFAULT NULL,
  `text_color` varchar(191) DEFAULT NULL,
  `slug` varchar(191) NOT NULL,
  `banner_image` varchar(191) DEFAULT NULL,
  `product_navigation_label` varchar(191) NOT NULL,
  `category_navigation_label` varchar(191) NOT NULL,
  `coupon_navigation_label` varchar(191) NOT NULL,
  `product_slogan` varchar(191) DEFAULT NULL,
  `category_slogan` varchar(191) DEFAULT NULL,
  `coupon_slogan` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `title_show` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `new_user_zones_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `new_user_zones` VALUES (1,'New User Gifts','Hi, welcome to eMarket Zone','#f3f6f4',NULL,'new-user-gifts-jck47','uploads/images/28-01-2024/65b68a906b4ac.jpeg','$us 0.1','Exclusive price','Coupon',NULL,NULL,NULL,1,0,1,1,1,'2024-01-28 16:10:40','2024-01-28 16:50:33');
CREATE TABLE `news_letters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `message` longtext NOT NULL,
  `publish_date` date NOT NULL,
  `send_type` int(10) unsigned NOT NULL,
  `send_user_ids` text NOT NULL,
  `multiple_role_id` varchar(191) DEFAULT NULL,
  `single_role_id` tinyint(3) unsigned DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `is_send` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `news_letters` VALUES (1,'Welcome','<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"padding: 20px;\"><p style=\"color: rgb(85, 85, 85); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;\">Hello {USER_FIRST_NAME}<br></p><p style=\"\"><font color=\"#555555\">Thank you for subscribing to our newsletter so you will learn about new opportunities.</font></p><p style=\"\"><font color=\"#555555\">Here is the promised code:&nbsp;&nbsp;</font><span style=\"color: var(--text-color);\">5465445515</span></p><p style=\"\"><font color=\"#858585\">use at purchase.</font><br></p><hr style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; box-sizing: content-box; margin-top: 20px; margin-bottom: 20px; border-top-color: rgb(238, 238, 238);\"><p style=\"color: rgb(85, 85, 85); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;\"><br></p><p style=\"color: rgb(85, 85, 85); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;\">{EMAIL_SIGNATURE}</p><p style=\"color: rgb(85, 85, 85); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;\"><br></p></div>\r\n<div style=\"font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); text-align: center; background-color: rgb(64, 132, 214); padding: 30px; border-top-left-radius: 3px; border-top-right-radius: 3px; margin: 0px;\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.1; color: inherit;\">Template</h1></div><div style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; padding: 20px;\"></div>','2024-02-04',4,'[\"5\",\"3\",\"2\"]',NULL,NULL,1,NULL,1,'2024-02-04 14:00:49','2024-02-04 16:00:05');
CREATE TABLE `notification_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event` varchar(191) DEFAULT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `delivery_process_id` bigint(20) unsigned DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `message` varchar(191) DEFAULT NULL,
  `admin_msg` longtext DEFAULT NULL,
  `user_access_status` tinyint(1) NOT NULL DEFAULT 1,
  `seller_access_status` tinyint(1) NOT NULL DEFAULT 0,
  `admin_access_status` tinyint(1) NOT NULL DEFAULT 0,
  `staff_access_status` tinyint(1) NOT NULL DEFAULT 0,
  `module` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_settings_delivery_process_id_foreign` (`delivery_process_id`),
  CONSTRAINT `notification_settings_delivery_process_id_foreign` FOREIGN KEY (`delivery_process_id`) REFERENCES `delivery_processes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `notification_settings` VALUES (1,'Register','register',NULL,'system','Welcome to the system.','A customer has been registered.',0,0,1,1,NULL,'2024-01-23 11:19:56','2024-01-23 11:19:59'),(2,'Offline recharge','offline-recharge',NULL,'email,mobile,system,','Offline recharge successful','Offline recharge done to user.',1,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-26 04:33:25'),(3,'Withdraw request declined','withdraw-request-declined',NULL,'email,mobile,system,','Your withdraw request declined','A withdraw request has been declined.',0,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-26 04:33:42'),(4,'Withdraw request approve','withdraw-request-approve',NULL,'system','Withdraw request approve','A withdraw request has been approved.',0,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-23 11:19:59'),(5,'Order confirmation','order-confirmation',NULL,'email,mobile,system,','Order Confirmed','An order has been approved.',1,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-24 17:20:12'),(6,'Order Pending','order-pending',1,'email,mobile,system,','Order Pending','An order process change to Pending',1,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-26 04:34:22'),(7,'Order Processing','order-processing',2,'email,mobile,system,','Order Processing','An order process change to Processing',1,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-26 04:34:31'),(8,'Order Shipped','order-shipped',3,'email,mobile,system,','Order Shipped','An order process change to Shipped',1,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-26 04:34:38'),(9,'Order Recieved','order-recieved',4,'email,mobile,system,','Order Recieved','An order process change to Recieved',1,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-26 04:34:47'),(10,'Order Delivered','order-delivered',5,'email,mobile,system,','Order Delivered','An order process change to Delivered',1,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-26 04:34:56'),(11,'Product review','product-review',NULL,'system','Product review.','A product reviewed by customer.',0,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-23 11:19:59'),(12,'Product disable','product-disable',NULL,'system','Product disable.','A product has been disabled.',0,1,1,1,NULL,'2024-01-23 11:19:56','2024-01-23 11:19:59'),(13,'Seller product approval','seller-product-approval',NULL,'system','Product approved.','A seller product approved.',0,1,1,1,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(14,'Seller product create','seller-product-create',NULL,'system','Product created.','A seller created product.',0,1,1,1,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(15,'Seller product update','seller-product-update',NULL,'system','Product updated.','A seller updated product.',0,1,1,1,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(16,'Seller payout','seller-payout',NULL,'system','Payout successfull.','A seller request to payout.',0,1,1,1,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(17,'Seller suspended','seller-suspended',NULL,'system','You are Suspended.','A seller has been suspended.',0,1,1,1,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(18,'Seller approved','seller-approved',NULL,'system','You are approved.','A seller has been approved.',0,1,1,1,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(19,'Seller Created','seller-created',NULL,'system','Welcome as a seller.','A seller has been created.',0,1,1,1,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(20,'Sub Seller Created','sub-seller-created',NULL,'system','Welcome as a sub seller.','A sub seller has been created.',0,1,0,0,'MultiVendor','2024-01-23 11:19:57','2024-01-23 11:19:59'),(21,'New Order','new-order',NULL,'system','Order Is placed.','New Order placed',1,1,1,1,NULL,'2024-01-23 11:19:58','2024-01-23 11:19:59'),(22,'Seller Add New Product','seller-add-new-product',NULL,'system','Seller Add New Product',NULL,1,1,1,1,NULL,'2024-01-23 11:19:59','2024-01-23 11:19:59'),(23,'Order Declined','order-declined',NULL,'system','Order Declined',NULL,1,1,1,1,NULL,'2024-01-23 11:19:59','2024-01-23 11:19:59');
