CREATE TABLE `club_point_wallets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wallet_point` double(20,4) 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 `club_point_wallets` VALUES (1,10.0000,'2021-05-05 03:42:40','2024-01-24 08:49:27');
CREATE TABLE `colors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_value_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `colors` VALUES (1,1,'Black','2024-01-23 11:19:53','2024-01-23 11:19:53'),(2,2,'Red','2024-01-23 11:19:53','2024-01-23 11:19:53'),(3,3,'White','2024-01-23 11:19:53','2024-01-23 11:19:53'),(4,4,'Yellow','2024-02-06 14:26:48','2024-02-06 14:26:48'),(5,5,'Blue','2024-02-06 14:29:53','2024-02-06 14:29:53'),(6,6,'Brown','2024-02-06 14:29:53','2024-02-06 14:29:53'),(7,7,'Green','2024-02-06 14:29:53','2024-02-06 14:29:53'),(8,8,'Orange','2024-02-06 14:29:53','2024-02-06 14:29:53'),(9,9,'Violet','2024-02-06 14:29:53','2024-02-06 14:29:53'),(10,10,'Pink','2024-02-06 14:29:53','2024-02-06 14:29:53'),(11,14,'Gold','2024-03-02 10:43:21','2024-03-02 10:43:21'),(12,15,'Gray','2024-03-03 13:31:20','2024-03-03 13:31:20');
CREATE TABLE `compares` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned NOT NULL,
  `product_sku_id` bigint(20) unsigned NOT NULL,
  `data_type` varchar(191) NOT NULL,
  `product_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `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 `compares` VALUES (1,5,47,'product',1,'2024-03-04 14:08:16','2024-03-04 14:08:16');
CREATE TABLE `contact_contents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `mainTitle` varchar(191) NOT NULL,
  `subTitle` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `description` longtext 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 `contact_contents` VALUES (1,NULL,'Contact Us','SEND US ANY QUERY THAT YOU ARE HAVING TROUBLE WITH','initail slug','info@emarketzone.com','<p>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.</p>','2024-01-23 11:19:52','2024-01-27 14:56:42');
CREATE TABLE `contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `query_type` varchar(191) NOT NULL,
  `message` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `others` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phonecode` varchar(255) DEFAULT NULL,
  `flag` varchar(255) DEFAULT 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=247 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `countries` VALUES (1,'AF','Afghanistan','93','/flags/flag-of-Afghanistan.jpg',1,NULL,NULL),(2,'AL','Albania','355','/flags/flag-of-Albania.jpg',1,NULL,NULL),(3,'DZ','Algeria','213','/flags/flag-of-Algeria.jpg',1,NULL,NULL),(4,'AS','American Samoa','1684',NULL,1,NULL,NULL),(5,'AD','Andorra','376','/flags/flag-of-Andorra.jpg',1,NULL,NULL),(6,'AO','Angola','244','/flags/flag-of-Angola.jpg',1,NULL,NULL),(7,'AI','Anguilla','1264',NULL,1,NULL,NULL),(8,'AQ','Antarctica','0',NULL,1,NULL,NULL),(9,'AG','Antigua And Barbuda','1268','/flags/flag-of-Antigua.jpg',1,NULL,NULL),(10,'AR','Argentina','54','/flags/flag-of-Argentina.jpg',1,NULL,NULL),(11,'AM','Armenia','374','/flags/flag-of-Armenia.jpg',1,NULL,NULL),(12,'AW','Aruba','297',NULL,1,NULL,NULL),(13,'AU','Australia','61','/flags/flag-of-Australia.jpg',1,NULL,NULL),(14,'AT','Austria','43','/flags/flag-of-Austria.jpg',1,NULL,NULL),(15,'AZ','Azerbaijan','994','/flags/flag-of-Azerbaijan.jpg',1,NULL,NULL),(16,'BS','Bahamas The','1242','/flags/flag-of-Bahamas.jpg',1,NULL,NULL),(17,'BH','Bahrain','973','/flags/flag-of-Bahrain.jpg',1,NULL,NULL),(18,'BD','Bangladesh','880','/flags/flag-of-Bangladesh.jpg',1,NULL,NULL),(19,'BB','Barbados','1246','/flags/flag-of-Barbados.jpg',1,NULL,NULL),(20,'BY','Belarus','375','/flags/flag-of-Belarus.jpg',1,NULL,NULL),(21,'BE','Belgium','32','/flags/flag-of-Belgium.jpg',1,NULL,NULL),(22,'BZ','Belize','501','/flags/flag-of-Belize.jpg',1,NULL,NULL),(23,'BJ','Benin','229','/flags/flag-of-Benin.jpg',1,NULL,NULL),(24,'BM','Bermuda','1441',NULL,1,NULL,NULL),(25,'BT','Bhutan','975','/flags/flag-of-Bhutan.jpg',1,NULL,NULL),(26,'BO','Bolivia','591','/flags/flag-of-Bolivia.jpg',1,NULL,NULL),(27,'BA','Bosnia and Herzegovina','387','/flags/flag-of-Bosnia-Herzegovina.jpg',1,NULL,NULL),(28,'BW','Botswana','267','/flags/flag-of-Botswana.jpg',1,NULL,NULL),(29,'BV','Bouvet Island','0',NULL,1,NULL,NULL),(30,'BR','Brazil','55','/flags/flag-of-Brazil.jpg',1,NULL,NULL),(31,'IO','British Indian Ocean Territory','246',NULL,1,NULL,NULL),(32,'BN','Brunei','673','/flags/flag-of-Brunei.jpg',1,NULL,NULL),(33,'BG','Bulgaria','359','/flags/flag-of-Bulgaria.jpg',1,NULL,NULL),(34,'BF','Burkina Faso','226','/flags/flag-of-Burkina-Faso.jpg',1,NULL,NULL),(35,'BI','Burundi','257','/flags/flag-of-Burundi.jpg',1,NULL,NULL),(36,'KH','Cambodia','855','/flags/flag-of-Cambodia.jpg',1,NULL,NULL),(37,'CM','Cameroon','237','/flags/flag-of-Cameroon.jpg',1,NULL,NULL),(38,'CA','Canada','1','/flags/flag-of-Canada.jpg',1,NULL,NULL),(39,'CV','Cape Verde','238','/flags/flag-of-Cabo-Verde.jpg',1,NULL,NULL),(40,'KY','Cayman Islands','1345',NULL,1,NULL,NULL),(41,'CF','Central African Republic','236','/flags/flag-of-Central-African-Republic.jpg',1,NULL,NULL),(42,'TD','Chad','235','/flags/flag-of-Chad.jpg',1,NULL,NULL),(43,'CL','Chile','56','/flags/flag-of-Chile.jpg',1,NULL,NULL),(44,'CN','China','86','/flags/flag-of-China.jpg',1,NULL,NULL),(45,'CX','Christmas Island','61',NULL,1,NULL,NULL),(46,'CC','Cocos (Keeling) Islands','672',NULL,1,NULL,NULL),(47,'CO','Colombia','57','/flags/flag-of-Colombia.jpg',1,NULL,NULL),(48,'KM','Comoros','269','/flags/flag-of-Comoros.jpg',1,NULL,NULL),(49,'CG','Republic Of The Congo','242','/flags/flag-of-Congo.jpg',1,NULL,NULL),(50,'CD','Democratic Republic Of The Congo','242','/flags/flag-of-Congo-Democratic-Republic-of.jpg',1,NULL,NULL),(51,'CK','Cook Islands','682',NULL,1,NULL,NULL),(52,'CR','Costa Rica','506','/flags/flag-of-Costa-Rica.jpg',1,NULL,NULL),(53,'CI','Cote D\'Ivoire (Ivory Coast)','225','/flags/flag-of-Cote-d-Ivoire.jpg',1,NULL,NULL),(54,'HR','Croatia (Hrvatska)','385','/flags/flag-of-Croatia.jpg',1,NULL,NULL),(55,'CU','Cuba','53','/flags/flag-of-Cuba.jpg',1,NULL,NULL),(56,'CY','Cyprus','357','/flags/flag-of-Cyprus.jpg',1,NULL,NULL),(57,'CZ','Czech Republic','420','/flags/flag-of-Czech-Republic.jpg',1,NULL,NULL),(58,'DK','Denmark','45','/flags/flag-of-Denmark.jpg',1,NULL,NULL),(59,'DJ','Djibouti','253','/flags/flag-of-Djibouti.jpg',1,NULL,NULL),(60,'DM','Dominica','1767','/flags/flag-of-Dominica.jpg',1,NULL,NULL),(61,'DO','Dominican Republic','1809','/flags/flag-of-Dominican-Republic.jpg',1,NULL,NULL),(62,'TP','East Timor','670',NULL,1,NULL,NULL),(63,'EC','Ecuador','593','/flags/flag-of-Ecuador.jpg',1,NULL,NULL),(64,'EG','Egypt','20','/flags/flag-of-Egypt.jpg',1,NULL,NULL),(65,'SV','El Salvador','503','/flags/flag-of-El-Salvador.jpg',1,NULL,NULL),(66,'GQ','Equatorial Guinea','240','/flags/flag-of-Equatorial-Guinea.jpg',1,NULL,NULL),(67,'ER','Eritrea','291','/flags/flag-of-Eritrea.jpg',1,NULL,NULL),(68,'EE','Estonia','372','/flags/flag-of-Estonia.jpg',1,NULL,NULL),(69,'ET','Ethiopia','251','/flags/flag-of-Ethiopia.jpg',1,NULL,NULL),(70,'XA','External Territories of Australia','61',NULL,1,NULL,NULL),(71,'FK','Falkland Islands','500',NULL,1,NULL,NULL),(72,'FO','Faroe Islands','298',NULL,1,NULL,NULL),(73,'FJ','Fiji Islands','679','/flags/flag-of-Fiji.jpg',1,NULL,NULL),(74,'FI','Finland','358','/flags/flag-of-Finland.jpg',1,NULL,NULL),(75,'FR','France','33','/flags/flag-of-France.jpg',1,NULL,NULL),(76,'GF','French Guiana','594',NULL,1,NULL,NULL),(77,'PF','French Polynesia','689',NULL,1,NULL,NULL),(78,'TF','French Southern Territories','0',NULL,1,NULL,NULL),(79,'GA','Gabon','241','/flags/flag-of-Gabon.jpg',1,NULL,NULL),(80,'GM','Gambia The','220','/flags/flag-of-Gambia.jpg',1,NULL,NULL),(81,'GE','Georgia','995','/flags/flag-of-Georgia.jpg',1,NULL,NULL),(82,'DE','Germany','49','/flags/flag-of-Germany.jpg',1,NULL,NULL),(83,'GH','Ghana','233','/flags/flag-of-Ghana.jpg',1,NULL,NULL),(84,'GI','Gibraltar','350',NULL,1,NULL,NULL),(85,'GR','Greece','30','/flags/flag-of-Greece.jpg',1,NULL,NULL),(86,'GL','Greenland','299',NULL,1,NULL,NULL),(87,'GD','Grenada','1473','/flags/flag-of-Grenada.jpg',1,NULL,NULL),(88,'GP','Guadeloupe','590',NULL,1,NULL,NULL),(89,'GU','Guam','1671',NULL,1,NULL,NULL),(90,'GT','Guatemala','502','/flags/flag-of-Guatemala.jpg',1,NULL,NULL),(91,'XU','Guernsey and Alderney','44',NULL,1,NULL,NULL),(92,'GN','Guinea','224','/flags/flag-of-Guinea.jpg',1,NULL,NULL),(93,'GW','Guinea-Bissau','245','/flags/flag-of-Guinea-Bissau.jpg',1,NULL,NULL),(94,'GY','Guyana','592','/flags/flag-of-Guyana.jpg',1,NULL,NULL),(95,'HT','Haiti','509','/flags/flag-of-Haiti.jpg',1,NULL,NULL),(96,'HM','Heard and McDonald Islands','0',NULL,1,NULL,NULL),(97,'HN','Honduras','504','/flags/flag-of-Honduras.jpg',1,NULL,NULL),(98,'HK','Hong Kong S.A.R.','852',NULL,1,NULL,NULL),(99,'HU','Hungary','36','/flags/flag-of-Hungary.jpg',1,NULL,NULL),(100,'IS','Iceland','354','/flags/flag-of-Iceland.jpg',1,NULL,NULL),(101,'IN','India','91','/flags/flag-of-India.jpg',1,NULL,NULL),(102,'ID','Indonesia','62','/flags/flag-of-Indonesia.jpg',1,NULL,NULL),(103,'IR','Iran','98','/flags/flag-of-Iran.jpg',1,NULL,NULL),(104,'IQ','Iraq','964','/flags/flag-of-Iraq.jpg',1,NULL,NULL),(105,'IE','Ireland','353','/flags/flag-of-Ireland.jpg',1,NULL,NULL),(106,'IL','Israel','972','/flags/flag-of-Israel.jpg',1,NULL,NULL),(107,'IT','Italy','39','/flags/flag-of-Italy.jpg',1,NULL,NULL),(108,'JM','Jamaica','1876','/flags/flag-of-Jamaica.jpg',1,NULL,NULL),(109,'JP','Japan','81','/flags/flag-of-Japan.jpg',1,NULL,NULL),(110,'XJ','Jersey','44',NULL,1,NULL,NULL),(111,'JO','Jordan','962','/flags/flag-of-Jordan.jpg',1,NULL,NULL),(112,'KZ','Kazakhstan','7','/flags/flag-of-Kazakhstan.jpg',1,NULL,NULL),(113,'KE','Kenya','254','/flags/flag-of-Kenya.jpg',1,NULL,NULL),(114,'KI','Kiribati','686','/flags/flag-of-Kiribati.jpg',1,NULL,NULL),(115,'KP','Korea North','850','/flags/flag-of-Korea-North.jpg',1,NULL,NULL),(116,'KR','Korea South','82','/flags/flag-of-Korea-South.jpg',1,NULL,NULL),(117,'KW','Kuwait','965','/flags/flag-of-Kuwait.jpg',1,NULL,NULL),(118,'KG','Kyrgyzstan','996','/flags/flag-of-Kyrgyzstan.jpg',1,NULL,NULL),(119,'LA','Laos','856','/flags/flag-of-Laos.jpg',1,NULL,NULL),(120,'LV','Latvia','371','/flags/flag-of-Latvia.jpg',1,NULL,NULL),(121,'LB','Lebanon','961','/flags/flag-of-Lebanon.jpg',1,NULL,NULL),(122,'LS','Lesotho','266','/flags/flag-of-Lesotho.jpg',1,NULL,NULL),(123,'LR','Liberia','231','/flags/flag-of-Liberia.jpg',1,NULL,NULL),(124,'LY','Libya','218','/flags/flag-of-Libya.jpg',1,NULL,NULL),(125,'LI','Liechtenstein','423','/flags/flag-of-Liechtenstein.jpg',1,NULL,NULL),(126,'LT','Lithuania','370','/flags/flag-of-Lithuania.jpg',1,NULL,NULL),(127,'LU','Luxembourg','352','/flags/flag-of-Luxembourg.jpg',1,NULL,NULL),(128,'MO','Macau S.A.R.','853',NULL,1,NULL,NULL),(129,'MK','Macedonia','389','/flags/flag-of-Macedonia.jpg',1,NULL,NULL),(130,'MG','Madagascar','261','/flags/flag-of-Madagascar.jpg',1,NULL,NULL),(131,'MW','Malawi','265','/flags/flag-of-Malawi.jpg',1,NULL,NULL),(132,'MY','Malaysia','60','/flags/flag-of-Malaysia.jpg',1,NULL,NULL),(133,'MV','Maldives','960','/flags/flag-of-Maldives.jpg',1,NULL,NULL),(134,'ML','Mali','223','/flags/flag-of-Mali.jpg',1,NULL,NULL),(135,'MT','Malta','356','/flags/flag-of-Malta.jpg',1,NULL,NULL),(136,'XM','Man (Isle of)','44',NULL,1,NULL,NULL),(137,'MH','Marshall Islands','692','/flags/flag-of-Marshall-Islands.jpg',1,NULL,NULL),(138,'MQ','Martinique','596',NULL,1,NULL,NULL),(139,'MR','Mauritania','222','/flags/flag-of-Mauritania.jpg',1,NULL,NULL),(140,'MU','Mauritius','230','/flags/flag-of-Mauritius.jpg',1,NULL,NULL),(141,'YT','Mayotte','269',NULL,1,NULL,NULL),(142,'MX','Mexico','52','/flags/flag-of-Mexico.jpg',1,NULL,NULL),(143,'FM','Micronesia','691','/flags/flag-of-Micronesia.jpg',1,NULL,NULL),(144,'MD','Moldova','373','/flags/flag-of-Moldova.jpg',1,NULL,NULL),(145,'MC','Monaco','377','/flags/flag-of-Monaco.jpg',1,NULL,NULL),(146,'MN','Mongolia','976','/flags/flag-of-Mongolia.jpg',1,NULL,NULL),(147,'MS','Montserrat','1664',NULL,1,NULL,NULL),(148,'MA','Morocco','212','/flags/flag-of-Morocco.jpg',1,NULL,NULL),(149,'MZ','Mozambique','258','/flags/flag-of-Mozambique.jpg',1,NULL,NULL),(150,'MM','Myanmar','95','/flags/flag-of-Myanmar.jpg',1,NULL,NULL),(151,'NA','Namibia','264','/flags/flag-of-Namibia.jpg',1,NULL,NULL),(152,'NR','Nauru','674','/flags/flag-of-Nauru.jpg',1,NULL,NULL),(153,'NP','Nepal','977','/flags/flag-of-Nepal.jpg',1,NULL,NULL),(154,'AN','Netherlands Antilles','599','/flags/flag-of-Netherlands.jpg',1,NULL,NULL),(155,'NL','Netherlands The','31','/flags/flag-of-Netherlands.jpg',1,NULL,NULL),(156,'NC','New Caledonia','687',NULL,1,NULL,NULL),(157,'NZ','New Zealand','64','/flags/flag-of-New-Zealand.jpg',1,NULL,NULL),(158,'NI','Nicaragua','505','/flags/flag-of-Nicaragua.jpg',1,NULL,NULL),(159,'NE','Niger','227','/flags/flag-of-Niger.jpg',1,NULL,NULL),(160,'NG','Nigeria','234','/flags/flag-of-Nigeria.jpg',1,NULL,NULL),(161,'NU','Niue','683',NULL,1,NULL,NULL),(162,'NF','Norfolk Island','672',NULL,1,NULL,NULL),(163,'MP','Northern Mariana Islands','1670',NULL,1,NULL,NULL),(164,'NO','Norway','47','/flags/flag-of-Norway.jpg',1,NULL,NULL),(165,'OM','Oman','968','/flags/flag-of-Oman.jpg',1,NULL,NULL),(166,'PK','Pakistan','92','/flags/flag-of-Pakistan.jpg',1,NULL,NULL),(167,'PW','Palau','680','/flags/flag-of-Palau.jpg',1,NULL,NULL),(168,'PS','Palestinian Territory Occupied','970','/flags/flag-of-Palestine.jpg',1,NULL,NULL),(169,'PA','Panama','507','/flags/flag-of-Panama.jpg',1,NULL,NULL),(170,'PG','Papua new Guinea','675','/flags/flag-of-Papua-New-Guinea.jpg',1,NULL,NULL),(171,'PY','Paraguay','595','/flags/flag-of-Paraguay.jpg',1,NULL,NULL),(172,'PE','Peru','51','/flags/flag-of-Peru.jpg',1,NULL,NULL),(173,'PH','Philippines','63','/flags/flag-of-Philippines.jpg',1,NULL,NULL),(174,'PN','Pitcairn Island','0',NULL,1,NULL,NULL),(175,'PL','Poland','48','/flags/flag-of-Poland.jpg',1,NULL,NULL),(176,'PT','Portugal','351','/flags/flag-of-Portugal.jpg',1,NULL,NULL),(177,'PR','Puerto Rico','1787',NULL,1,NULL,NULL),(178,'QA','Qatar','974','/flags/flag-of-Qatar.jpg',1,NULL,NULL),(179,'RE','Reunion','262',NULL,1,NULL,NULL),(180,'RO','Romania','40','/flags/flag-of-Romania.jpg',1,NULL,NULL),(181,'RU','Russia','70','/flags/flag-of-Russia.jpg',1,NULL,NULL),(182,'RW','Rwanda','250','/flags/flag-of-Rwanda.jpg',1,NULL,NULL),(183,'SH','Saint Helena','290',NULL,1,NULL,NULL),(184,'KN','Saint Kitts And Nevis','1869',NULL,1,NULL,NULL),(185,'LC','Saint Lucia','1758',NULL,1,NULL,NULL),(186,'PM','Saint Pierre and Miquelon','508',NULL,1,NULL,NULL),(187,'VC','Saint Vincent And The Grenadines','1784',NULL,1,NULL,NULL),(188,'WS','Samoa','684','/flags/flag-of-Samoa.jpg',1,NULL,NULL),(189,'SM','San Marino','378','/flags/flag-of-San-Marino.jpg',1,NULL,NULL),(190,'ST','Sao Tome and Principe','239','/flags/flag-of-Sao-Tome-and-Principe.jpg',1,NULL,NULL),(191,'SA','Saudi Arabia','966','/flags/flag-of-Saudi-Arabia.jpg',1,NULL,NULL),(192,'SN','Senegal','221','/flags/flag-of-Senegal.jpg',1,NULL,NULL),(193,'RS','Serbia','381','/flags/flag-of-Serbia.jpg',1,NULL,NULL),(194,'SC','Seychelles','248','/flags/flag-of-Seychelles.jpg',1,NULL,NULL),(195,'SL','Sierra Leone','232','/flags/flag-of-Sierra-Leone.jpg',1,NULL,NULL),(196,'SG','Singapore','65','/flags/flag-of-Singapore.jpg',1,NULL,NULL),(197,'SK','Slovakia','421','/flags/flag-of-Slovakia.jpg',1,NULL,NULL),(198,'SI','Slovenia','386','/flags/flag-of-Slovenia.jpg',1,NULL,NULL),(199,'XG','Smaller Territories of the UK','44',NULL,1,NULL,NULL),(200,'SB','Solomon Islands','677','/flags/flag-of-Solomon-Islands.jpg',1,NULL,NULL),(201,'SO','Somalia','252','/flags/flag-of-Somalia.jpg',1,NULL,NULL),(202,'ZA','South Africa','27','/flags/flag-of-South-Africa.jpg',1,NULL,NULL),(203,'GS','South Georgia','0',NULL,1,NULL,NULL),(204,'SS','South Sudan','211','/flags/flag-of-South-Sudan.jpg',1,NULL,NULL),(205,'ES','Spain','34','/flags/flag-of-Spain.jpg',1,NULL,NULL),(206,'LK','Sri Lanka','94','/flags/flag-of-Sri-Lanka.jpg',1,NULL,NULL),(207,'SD','Sudan','249','/flags/flag-of-Sudan.jpg',1,NULL,NULL),(208,'SR','Suriname','597','/flags/flag-of-Suriname.jpg',1,NULL,NULL),(209,'SJ','Svalbard And Jan Mayen Islands','47',NULL,1,NULL,NULL),(210,'SZ','Swaziland','268','/flags/flag-of-Swaziland.jpg',1,NULL,NULL),(211,'SE','Sweden','46','/flags/flag-of-Sweden.jpg',1,NULL,NULL),(212,'CH','Switzerland','41','/flags/flag-of-Switzerland.jpg',1,NULL,NULL),(213,'SY','Syria','963','/flags/flag-of-Syria.jpg',1,NULL,NULL),(214,'TW','Taiwan','886','/flags/flag-of-Taiwan.jpg',1,NULL,NULL),(215,'TJ','Tajikistan','992','/flags/flag-of-Tajikistan.jpg',1,NULL,NULL),(216,'TZ','Tanzania','255','/flags/flag-of-Tanzania.jpg',1,NULL,NULL),(217,'TH','Thailand','66','/flags/flag-of-Thailand.jpg',1,NULL,NULL),(218,'TG','Togo','228','/flags/flag-of-Togo.jpg',1,NULL,NULL),(219,'TK','Tokelau','690',NULL,1,NULL,NULL),(220,'TO','Tonga','676','/flags/flag-of-Tonga.jpg',1,NULL,NULL),(221,'TT','Trinidad And Tobago','1868','/flags/flag-of-Trinidad-and-Tobago.jpg',1,NULL,NULL),(222,'TN','Tunisia','216','/flags/flag-of-Tunisia.jpg',1,NULL,NULL),(223,'TR','Turkey','90','/flags/flag-of-Turkey.jpg',1,NULL,NULL),(224,'TM','Turkmenistan','7370','/flags/flag-of-Turkmenistan.jpg',1,NULL,NULL),(225,'TC','Turks And Caicos Islands','1649',NULL,1,NULL,NULL),(226,'TV','Tuvalu','688','/flags/flag-of-Tuvalu.jpg',1,NULL,NULL),(227,'UG','Uganda','256','/flags/flag-of-Uganda.jpg',1,NULL,NULL),(228,'UA','Ukraine','380','/flags/flag-of-Ukraine.jpg',1,NULL,NULL),(229,'AE','United Arab Emirates','971','/flags/flag-of-United-Arab-Emirates.jpg',1,NULL,NULL),(230,'GB','United Kingdom','44','/flags/flag-of-United-Kingdom.jpg',1,NULL,NULL),(231,'US','United States','1','/flags/flag-of-United-States-of-America.jpg',1,NULL,NULL),(232,'UM','United States Minor Outlying Islands','1',NULL,1,NULL,NULL),(233,'UY','Uruguay','598','/flags/flag-of-Uruguay.jpg',1,NULL,NULL),(234,'UZ','Uzbekistan','998','/flags/flag-of-Uzbekistan.jpg',1,NULL,NULL),(235,'VU','Vanuatu','678','/flags/flag-of-Vanuatu.jpg',1,NULL,NULL),(236,'VA','Vatican City State (Holy See)','39','/flags/flag-of-Vatican-City.jpg',1,NULL,NULL),(237,'VE','Venezuela','58','/flags/flag-of-Venezuela.jpg',1,NULL,NULL),(238,'VN','Vietnam','84','/flags/flag-of-Vietnam.jpg',1,NULL,NULL),(239,'VG','Virgin Islands (British)','1284',NULL,1,NULL,NULL),(240,'VI','Virgin Islands (US)','1340',NULL,1,NULL,NULL),(241,'WF','Wallis And Futuna Islands','681',NULL,1,NULL,NULL),(242,'EH','Western Sahara','212',NULL,1,NULL,NULL),(243,'YE','Yemen','967','/flags/flag-of-Yemen.jpg',1,NULL,NULL),(244,'YU','Yugoslavia','38',NULL,1,NULL,NULL),(245,'ZM','Zambia','260','/flags/flag-of-Zambia.jpg',1,NULL,NULL),(246,'ZW','Zimbabwe','263','/flags/flag-of-Zimbabwe.jpg',1,NULL,NULL);
CREATE TABLE `coupon_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` bigint(20) unsigned NOT NULL,
  `coupon_code` varchar(191) NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `coupon_products_product_id_foreign` (`product_id`),
  KEY `coupon_products_coupon_id_foreign` (`coupon_id`),
  CONSTRAINT `coupon_products_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `coupon_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `seller_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `coupon_uses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `coupon_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `discount_amount` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `coupon_uses_user_id_foreign` (`user_id`),
  KEY `coupon_uses_coupon_id_foreign` (`coupon_id`),
  CONSTRAINT `coupon_uses_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `coupon_uses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `coupon_code` varchar(191) NOT NULL,
  `coupon_type` tinyint(3) unsigned NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `discount` double DEFAULT NULL,
  `discount_type` tinyint(3) unsigned DEFAULT NULL,
  `minimum_shopping` double DEFAULT NULL,
  `maximum_discount` double DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `is_expire` tinyint(1) NOT NULL DEFAULT 0,
  `is_multiple_buy` tinyint(1) NOT NULL DEFAULT 0,
  `multiple_buy_limit` varchar(191) 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 `coupons` VALUES (1,'Coupon','5465445515',2,'2024-01-28','2024-02-29',10,1,1,NULL,1,1,0,0,NULL,'2024-01-28 16:12:07','2024-02-04 13:38:33');
CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `code` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `convert_rate` double NOT NULL DEFAULT 0,
  `symbol` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `currencies` VALUES (1,'Leke','ALL',0,0,'Lek','2024-01-23 11:19:50','2024-01-23 11:19:50'),(2,'Dollars','USD',1,1,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(3,'Afghanis','AFN',0,0,'؋','2024-01-23 11:19:50','2024-01-23 11:19:50'),(4,'Pesos','ARS',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(5,'Guilders','AWG',0,0,'ƒ','2024-01-23 11:19:50','2024-01-23 11:19:50'),(6,'Dollars','AUD',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(7,'New Manats','AZN',0,0,'ман','2024-01-23 11:19:50','2024-01-23 11:19:50'),(8,'Dollars','BSD',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(9,'Dollars','BBD',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(10,'Rubles','BYR',0,0,'p.','2024-01-23 11:19:50','2024-01-23 11:19:50'),(11,'Euro','EUR',1,0.92,'€','2024-01-23 11:19:50','2024-03-04 13:54:17'),(12,'Dollars','BZD',0,0,'BZ$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(13,'Dollars','BMD',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(14,'Bolivianos','BOB',0,0,'$b','2024-01-23 11:19:50','2024-01-23 11:19:50'),(15,'Convertible Marka','BAM',0,0,'KM','2024-01-23 11:19:50','2024-01-23 11:19:50'),(16,'Pula','BWP',0,0,'P','2024-01-23 11:19:50','2024-01-23 11:19:50'),(17,'Leva','BGN',0,0,'лв','2024-01-23 11:19:50','2024-01-23 11:19:50'),(18,'Reais','BRL',0,0,'R$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(19,'Pounds','GBP',0,0,'£','2024-01-23 11:19:50','2024-01-23 11:19:50'),(20,'Dollars','BND',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(21,'Riels','KHR',0,0,'៛','2024-01-23 11:19:50','2024-01-23 11:19:50'),(22,'Dollars','CAD',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(23,'Dollars','KYD',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(24,'Pesos','CLP',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(25,'Yuan Renminbi','CNY',0,0,'¥','2024-01-23 11:19:50','2024-01-23 11:19:50'),(26,'Pesos','COP',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(27,'Colón','CRC',0,0,'₡','2024-01-23 11:19:50','2024-01-23 11:19:50'),(28,'Kuna','HRK',0,0,'kn','2024-01-23 11:19:50','2024-01-23 11:19:50'),(29,'Pesos','CUP',0,0,'₱','2024-01-23 11:19:50','2024-01-23 11:19:50'),(30,'Koruny','CZK',0,0,'Kč','2024-01-23 11:19:50','2024-01-23 11:19:50'),(31,'Kroner','DKK',0,0,'kr','2024-01-23 11:19:50','2024-01-23 11:19:50'),(32,'Pesos','DOP ',0,0,'RD$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(33,'Dollars','XCD',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(34,'Pounds','EGP',0,0,'£','2024-01-23 11:19:50','2024-01-23 11:19:50'),(35,'Colones','SVC',0,0,'$','2024-01-23 11:19:50','2024-01-23 11:19:50'),(36,'Pounds','FKP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(37,'Dollars','FJD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(38,'Cedis','GHC',0,0,'¢','2024-01-23 11:19:51','2024-01-23 11:19:51'),(39,'Pounds','GIP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(40,'Quetzales','GTQ',0,0,'Q','2024-01-23 11:19:51','2024-01-23 11:19:51'),(41,'Pounds','GGP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(42,'Dollars','GYD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(43,'Lempiras','HNL',0,0,'L','2024-01-23 11:19:51','2024-01-23 11:19:51'),(44,'Dollars','HKD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(45,'Forint','HUF',0,0,'Ft','2024-01-23 11:19:51','2024-01-23 11:19:51'),(46,'Kronur','ISK',0,0,'kr','2024-01-23 11:19:51','2024-01-23 11:19:51'),(47,'Rupees','INR',0,0,'₹','2024-01-23 11:19:51','2024-01-23 11:19:51'),(48,'Rupiahs','IDR',0,0,'Rp','2024-01-23 11:19:51','2024-01-23 11:19:51'),(49,'Rials','IRR',0,0,'﷼','2024-01-23 11:19:51','2024-01-23 11:19:51'),(50,'Pounds','IMP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(51,'New Shekels','ILS',0,0,'₪','2024-01-23 11:19:51','2024-01-23 11:19:51'),(52,'Dollars','JMD',0,0,'J$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(53,'Yen','JPY',0,0,'¥','2024-01-23 11:19:51','2024-01-23 11:19:51'),(54,'Pounds','JEP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(55,'Tenge','KZT',0,0,'лв','2024-01-23 11:19:51','2024-01-23 11:19:51'),(56,'Won','KPW',0,0,'₩','2024-01-23 11:19:51','2024-01-23 11:19:51'),(57,'Won','KRW',0,0,'₩','2024-01-23 11:19:51','2024-01-23 11:19:51'),(58,'Soms','KGS',0,0,'лв','2024-01-23 11:19:51','2024-01-23 11:19:51'),(59,'Kips','LAK',0,0,'₭','2024-01-23 11:19:51','2024-01-23 11:19:51'),(60,'Lati','LVL',0,0,'Ls','2024-01-23 11:19:51','2024-01-23 11:19:51'),(61,'Pounds','LBP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(62,'Dollars','LRD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(63,'Switzerland Francs','CHF',0,0,'CHF','2024-01-23 11:19:51','2024-01-23 11:19:51'),(64,'Litai','LTL',0,0,'Lt','2024-01-23 11:19:51','2024-01-23 11:19:51'),(65,'Denars','MKD',0,0,'ден','2024-01-23 11:19:51','2024-01-23 11:19:51'),(66,'Ringgits','MYR',0,0,'RM','2024-01-23 11:19:51','2024-01-23 11:19:51'),(67,'Rupees','MUR',0,0,'₨','2024-01-23 11:19:51','2024-01-23 11:19:51'),(68,'Pesos','MXN',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(69,'Tugriks','MNT',0,0,'₮','2024-01-23 11:19:51','2024-01-23 11:19:51'),(70,'Meticais','MZN',0,0,'MT','2024-01-23 11:19:51','2024-01-23 11:19:51'),(71,'Dollars','NAD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(72,'Rupees','NPR',0,0,'₨','2024-01-23 11:19:51','2024-01-23 11:19:51'),(73,'Guilders','ANG',0,0,'ƒ','2024-01-23 11:19:51','2024-01-23 11:19:51'),(74,'Dollars','NZD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(75,'Cordobas','NIO',0,0,'C$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(76,'Nairas','NGN',0,0,'₦','2024-01-23 11:19:51','2024-01-23 11:19:51'),(77,'Krone','NOK',0,0,'kr','2024-01-23 11:19:51','2024-01-23 11:19:51'),(78,'Rials','OMR',0,0,'﷼','2024-01-23 11:19:51','2024-01-23 11:19:51'),(79,'Rupees','PKR',0,0,'₨','2024-01-23 11:19:51','2024-01-23 11:19:51'),(80,'Balboa','PAB',0,0,'B/.','2024-01-23 11:19:51','2024-01-23 11:19:51'),(81,'Guarani','PYG',0,0,'Gs','2024-01-23 11:19:51','2024-01-23 11:19:51'),(82,'Nuevos Soles','PEN',0,0,'S/.','2024-01-23 11:19:51','2024-01-23 11:19:51'),(83,'Pesos','PHP',0,0,'Php','2024-01-23 11:19:51','2024-01-23 11:19:51'),(84,'Zlotych','PLN',0,0,'zł','2024-01-23 11:19:51','2024-01-23 11:19:51'),(85,'Rials','QAR',0,0,'﷼','2024-01-23 11:19:51','2024-01-23 11:19:51'),(86,'New Lei','RON',0,0,'lei','2024-01-23 11:19:51','2024-01-23 11:19:51'),(87,'Rubles','RUB',0,0,'руб','2024-01-23 11:19:51','2024-01-23 11:19:51'),(88,'Pounds','SHP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(89,'Riyals','SAR',0,0,'﷼','2024-01-23 11:19:51','2024-01-23 11:19:51'),(90,'Dinars','RSD',0,0,'Дин.','2024-01-23 11:19:51','2024-01-23 11:19:51'),(91,'Rupees','SCR',0,0,'₨','2024-01-23 11:19:51','2024-01-23 11:19:51'),(92,'Dollars','SGD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(93,'Dollars','SBD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(94,'Shillings','SOS',0,0,'S','2024-01-23 11:19:51','2024-01-23 11:19:51'),(95,'Rand','ZAR',0,0,'R','2024-01-23 11:19:51','2024-01-23 11:19:51'),(96,'Rupees','LKR',0,0,'₨','2024-01-23 11:19:51','2024-01-23 11:19:51'),(97,'Kronor','SEK',0,0,'kr','2024-01-23 11:19:51','2024-01-23 11:19:51'),(98,'Dollars','SRD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(99,'Pounds','SYP',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(100,'New Dollars','TWD',0,0,'NT$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(101,'Baht','THB',0,0,'฿','2024-01-23 11:19:51','2024-01-23 11:19:51'),(102,'Dollars','TTD',0,0,'TT$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(103,'Lira','TRY',0,0,'TL','2024-01-23 11:19:51','2024-01-23 11:19:51'),(104,'Liras','TRL',0,0,'£','2024-01-23 11:19:51','2024-01-23 11:19:51'),(105,'Dollars','TVD',0,0,'$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(106,'Hryvnia','UAH',0,0,'₴','2024-01-23 11:19:51','2024-01-23 11:19:51'),(107,'Pesos','UYU',0,0,'$U','2024-01-23 11:19:51','2024-01-23 11:19:51'),(108,'Sums','UZS',0,0,'лв','2024-01-23 11:19:51','2024-01-23 11:19:51'),(109,'Bolivares Fuertes','VEF',0,0,'Bs','2024-01-23 11:19:51','2024-01-23 11:19:51'),(110,'Dong','VND',0,0,'₫','2024-01-23 11:19:51','2024-01-23 11:19:51'),(111,'Rials','YER',0,0,'﷼','2024-01-23 11:19:51','2024-01-23 11:19:51'),(112,'Taka','BDT',0,0,'৳','2024-01-23 11:19:51','2024-01-23 11:19:51'),(113,'Zimbabwe Dollars','ZWD',0,0,'Z$','2024-01-23 11:19:51','2024-01-23 11:19:51'),(114,'Kenya','KES',0,0,'KSh','2024-01-23 11:19:51','2024-01-23 11:19:51'),(115,'Nigeria','naira',0,0,'₦','2024-01-23 11:19:51','2024-01-23 11:19:51'),(116,'Ghana','GHS',0,0,'GH₵','2024-01-23 11:19:51','2024-01-23 11:19:51'),(117,'Ethiopian','ETB',0,0,'Br','2024-01-23 11:19:51','2024-01-23 11:19:51'),(118,'Tanzania','TZS',0,0,'TSh','2024-01-23 11:19:51','2024-01-23 11:19:51'),(119,'Uganda','UGX',0,0,'USh','2024-01-23 11:19:51','2024-01-23 11:19:51'),(120,'Rwandan','FRW',0,0,'FRw','2024-01-23 11:19:51','2024-01-23 11:19:51');
CREATE TABLE `custom_forms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `form_data` text DEFAULT 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `custom_forms` VALUES (1,'Affiliate User Registration',NULL,1,NULL,NULL),(2,'Customer Registration',NULL,1,NULL,NULL),(3,'Seller Registration','[{\"type\":\"select\",\"required\":true,\"label\":\"Account Type\",\"className\":\"form-control default-field\",\"name\":\"account_type\",\"values\":[{\"label\":\"Option 1\",\"value\":\"option-1\",\"selected\":true},{\"label\":\"Option 2\",\"value\":\"option-2\"},{\"label\":\"Option 3\",\"value\":\"option-3\"}]},{\"type\":\"text\",\"required\":true,\"label\":\"Shop Name\",\"placeholder\":\"Shop Name\",\"className\":\"form-control default-field\",\"name\":\"name\",\"subtype\":\"text\"},{\"type\":\"text\",\"required\":true,\"label\":\"Email Address\",\"placeholder\":\"Email Address\",\"className\":\"form-control default-field\",\"name\":\"email\",\"subtype\":\"text\"},{\"type\":\"text\",\"required\":true,\"label\":\"Phone Number\",\"placeholder\":\"Phone Number\",\"className\":\"form-control default-field\",\"name\":\"phone\",\"subtype\":\"text\"},{\"type\":\"text\",\"subtype\":\"password\",\"required\":true,\"label\":\"Password\",\"placeholder\":\"Password\",\"className\":\"form-control default-field\",\"name\":\"password\"},{\"type\":\"text\",\"subtype\":\"password\",\"required\":true,\"label\":\"Confirm password\",\"placeholder\":\"Confirm password\",\"className\":\"form-control default-field\",\"name\":\"password_confirmation\"},{\"type\":\"checkbox\",\"label\":\"By signing up, you agree to <a href=\\\"https://www.emarketzone.com/terms-&amp;-conditions\\\" class=\\\"term_link_set\\\">Terms of Service </a> and <a href=\\\"https://www.emarketzone.com/privacy-policy\\\" class=\\\"policy_link_set\\\">Privacy Policy</a>\",\"inline\":true,\"className\":\"form-control default-field\",\"name\":\"accept\",\"values\":[{\"label\":\"Option 1\",\"value\":\"option-1\",\"selected\":true}]}]',1,NULL,'2024-02-17 15:38:43'),(4,'Contact',NULL,1,NULL,NULL);
CREATE TABLE `customer_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `is_shipping_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_billing_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_updated` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `customer_addresses` VALUES (1,3,'Home','nedkox@abv.bg','+359888666222','Pliska 12','9758','546','33','8000',1,1,'2024-02-06 06:44:54','2024-02-06 06:44:54',0),(2,4,'Milin','risetools.com@gmail.com','+359888777555','Pliska 21','42207','3866','230',NULL,1,1,'2024-02-21 04:13:28','2024-02-21 04:13:28',0);
CREATE TABLE `customer_coupon_stores` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_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`),
  KEY `customer_coupon_stores_customer_id_foreign` (`customer_id`),
  KEY `customer_coupon_stores_coupon_id_foreign` (`coupon_id`),
  CONSTRAINT `customer_coupon_stores_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `customer_coupon_stores_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `customer_notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `seller_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `url` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `read_status` tinyint(1) NOT NULL DEFAULT 0,
  `super_admin_read_status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_notifications_customer_id_foreign` (`customer_id`),
  KEY `customer_notifications_seller_id_foreign` (`seller_id`),
  KEY `customer_notifications_order_id_foreign` (`order_id`),
  CONSTRAINT `customer_notifications_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `users` (`id`),
  CONSTRAINT `customer_notifications_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  CONSTRAINT `customer_notifications_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `customer_notifications` VALUES (1,NULL,3,NULL,'Welcome to the system.','#',NULL,0,0,'2024-02-06 06:21:41','2024-02-06 06:21:41'),(2,NULL,1,NULL,'A customer has been registered.','/customer/active-customer-list',NULL,1,1,'2024-02-06 06:21:41','2024-02-06 06:32:57'),(3,NULL,4,NULL,'Welcome as a seller.','#',NULL,1,1,'2024-02-10 16:58:24','2024-02-11 06:12:26'),(4,NULL,1,NULL,'A seller has been created.','/admin/merchants',NULL,1,1,'2024-02-10 16:58:24','2024-02-11 07:13:14'),(5,NULL,2,NULL,'A seller has been created.','/admin/merchants',NULL,1,1,'2024-02-10 16:58:24','2024-03-10 02:45:12'),(6,NULL,4,NULL,'You are approved.','#',NULL,1,1,'2024-02-10 17:03:40','2024-02-11 06:12:26'),(7,NULL,1,NULL,'A seller has been approved.','/admin/merchants',NULL,1,1,'2024-02-10 17:03:40','2024-02-11 07:13:14'),(8,NULL,2,NULL,'A seller has been approved.','/admin/merchants',NULL,1,1,'2024-02-10 17:03:40','2024-03-10 02:45:12'),(9,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-11 06:54:37','2024-02-11 06:54:56'),(10,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-11 06:54:37','2024-02-11 07:13:14'),(11,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-11 06:54:37','2024-03-10 02:45:12'),(12,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-11 06:56:35','2024-02-11 12:40:32'),(13,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-11 06:56:35','2024-02-11 07:13:14'),(14,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-11 06:56:35','2024-03-10 02:45:12'),(15,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-11 12:32:25','2024-02-11 12:40:32'),(16,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-11 12:32:25','2024-02-12 04:46:28'),(17,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-11 12:32:25','2024-03-10 02:45:12'),(18,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-11 12:33:34','2024-02-11 12:40:32'),(19,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-11 12:33:34','2024-02-12 04:46:28'),(20,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-11 12:33:34','2024-03-10 02:45:12'),(21,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-12 04:40:47','2024-02-13 16:32:23'),(22,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-12 04:40:47','2024-02-12 04:46:28'),(23,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-12 04:40:47','2024-03-10 02:45:12'),(24,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-12 04:41:18','2024-02-13 16:32:23'),(25,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-12 04:41:18','2024-02-12 04:46:28'),(26,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-12 04:41:18','2024-03-10 02:45:12'),(27,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-14 05:02:13','2024-02-14 05:07:24'),(28,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-14 05:02:13','2024-02-15 16:12:21'),(29,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-14 05:02:13','2024-03-10 02:45:12'),(30,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-14 05:05:26','2024-02-14 05:07:24'),(31,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-14 05:05:26','2024-02-15 16:12:21'),(32,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-14 05:05:26','2024-03-10 02:45:12'),(33,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-15 16:09:32','2024-02-17 15:04:22'),(34,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-15 16:09:32','2024-02-15 16:12:21'),(35,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-15 16:09:32','2024-03-10 02:45:12'),(36,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-15 16:12:09','2024-02-17 15:04:22'),(37,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-15 16:12:09','2024-02-15 16:12:21'),(38,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-15 16:12:09','2024-03-10 02:45:12'),(39,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-17 15:10:11','2024-02-17 15:12:18'),(40,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-17 15:10:11','2024-02-18 08:33:28'),(41,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-17 15:10:11','2024-03-10 02:45:12'),(42,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-17 15:12:35','2024-02-18 09:41:55'),(43,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-17 15:12:35','2024-02-18 08:33:28'),(44,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-17 15:12:35','2024-03-10 02:45:12'),(45,NULL,5,NULL,'Welcome as a seller.','#',NULL,1,1,'2024-02-17 15:32:45','2024-02-17 15:44:10'),(46,NULL,1,NULL,'A seller has been created.','/admin/merchants',NULL,1,1,'2024-02-17 15:32:45','2024-02-18 08:33:28'),(47,NULL,2,NULL,'A seller has been created.','/admin/merchants',NULL,1,1,'2024-02-17 15:32:45','2024-03-10 02:45:12'),(48,NULL,5,NULL,'You are approved.','#',NULL,1,1,'2024-02-17 15:42:39','2024-02-17 15:44:10'),(49,NULL,1,NULL,'A seller has been approved.','/admin/merchants',NULL,1,1,'2024-02-17 15:42:39','2024-02-18 08:33:28'),(50,NULL,2,NULL,'A seller has been approved.','/admin/merchants',NULL,1,1,'2024-02-17 15:42:39','2024-03-10 02:45:12'),(51,NULL,6,NULL,'Welcome as a seller.','#',NULL,1,1,'2024-02-17 15:54:36','2024-02-18 08:36:30'),(52,NULL,1,NULL,'A seller has been created.','/admin/merchants',NULL,1,1,'2024-02-17 15:54:36','2024-02-18 08:33:28'),(53,NULL,2,NULL,'A seller has been created.','/admin/merchants',NULL,1,1,'2024-02-17 15:54:36','2024-03-10 02:45:12'),(54,NULL,6,NULL,'You are approved.','#',NULL,1,1,'2024-02-18 08:34:47','2024-02-18 08:36:30'),(55,NULL,1,NULL,'A seller has been approved.','/admin/merchants',NULL,1,1,'2024-02-18 08:34:47','2024-02-27 04:02:15'),(56,NULL,2,NULL,'A seller has been approved.','/admin/merchants',NULL,1,1,'2024-02-18 08:34:47','2024-03-10 02:45:12'),(57,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-18 11:31:45','2024-02-18 11:59:11'),(58,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-18 11:31:45','2024-02-27 04:02:15'),(59,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-18 11:31:45','2024-03-10 02:45:12'),(60,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-18 11:55:32','2024-02-18 11:59:11'),(61,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-18 11:55:32','2024-02-27 04:02:15'),(62,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-18 11:55:32','2024-03-10 02:45:12'),(63,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-21 03:48:05','2024-02-21 03:54:59'),(64,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-21 03:48:05','2024-02-27 04:02:15'),(65,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-21 03:48:05','2024-03-10 02:45:12'),(66,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-21 03:48:45','2024-02-21 03:54:59'),(67,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-21 03:48:45','2024-02-27 04:02:15'),(68,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-21 03:48:45','2024-03-10 02:45:12'),(69,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-23 04:24:00','2024-02-27 04:02:32'),(70,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-23 04:24:00','2024-02-27 04:02:15'),(71,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-23 04:24:00','2024-03-10 02:45:12'),(72,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-23 04:24:37','2024-02-27 04:02:32'),(73,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-23 04:24:37','2024-02-27 04:02:15'),(74,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-23 04:24:37','2024-03-10 02:45:12'),(75,NULL,1,NULL,'A seller updated product.','#',NULL,1,1,'2024-02-27 03:50:31','2024-02-27 04:02:15'),(76,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-27 03:56:19','2024-02-27 04:02:32'),(77,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-27 03:56:19','2024-02-27 04:02:15'),(78,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-27 03:56:19','2024-03-10 02:45:12'),(79,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-27 04:01:47','2024-02-27 04:02:32'),(80,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-27 04:01:48','2024-02-27 04:02:15'),(81,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-27 04:01:48','2024-03-10 02:45:12'),(82,NULL,4,NULL,'Product created.','/seller/product',NULL,1,1,'2024-02-28 04:06:35','2024-02-29 17:07:34'),(83,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-28 04:06:35','2024-03-02 10:49:45'),(84,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-02-28 04:06:35','2024-03-10 02:45:12'),(85,NULL,4,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-02-28 04:26:39','2024-02-29 17:07:34'),(86,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-28 04:26:39','2024-03-02 10:49:45'),(87,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-02-28 04:26:39','2024-03-10 02:45:12'),(88,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-02 12:03:10','2024-03-03 09:03:24'),(89,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-02 12:03:10','2024-03-02 15:06:37'),(90,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-02 12:03:10','2024-03-10 02:45:12'),(91,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-02 14:20:57','2024-03-03 09:03:24'),(92,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-02 14:20:57','2024-03-02 15:06:37'),(93,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-02 14:20:57','2024-03-10 02:45:12'),(94,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-02 14:21:41','2024-03-03 09:03:24'),(95,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-02 14:21:41','2024-03-02 15:06:37'),(96,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-02 14:21:41','2024-03-10 02:45:12'),(97,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-02 14:21:45','2024-03-03 09:03:24'),(98,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-02 14:21:45','2024-03-02 15:06:37'),(99,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-02 14:21:45','2024-03-10 02:45:12'),(100,NULL,5,NULL,'Product disable.','/seller/product',NULL,1,1,'2024-03-03 06:59:41','2024-03-03 09:03:24'),(101,NULL,1,NULL,'A product has been disabled.','/products',NULL,1,1,'2024-03-03 06:59:41','2024-03-04 12:51:05'),(102,NULL,2,NULL,'A product has been disabled.','/products',NULL,1,1,'2024-03-03 06:59:41','2024-03-10 02:45:12'),(103,NULL,1,NULL,'A product has been disabled.','/products',NULL,1,1,'2024-03-03 07:10:03','2024-03-04 12:51:05'),(104,NULL,2,NULL,'A product has been disabled.','/products',NULL,1,1,'2024-03-03 07:10:03','2024-03-10 02:45:12'),(105,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-03 07:26:13','2024-03-03 09:03:24'),(106,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-03 07:26:13','2024-03-04 12:51:05'),(107,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-03 07:26:13','2024-03-10 02:45:12'),(108,NULL,1,NULL,'A product has been disabled.','/products',NULL,1,1,'2024-03-03 07:26:26','2024-03-04 12:51:05'),(109,NULL,2,NULL,'A product has been disabled.','/products',NULL,1,1,'2024-03-03 07:26:26','2024-03-10 02:45:12'),(110,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-03 07:26:53','2024-03-03 09:03:24'),(111,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-03 07:26:53','2024-03-04 12:51:05'),(112,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-03 07:26:53','2024-03-10 02:45:12'),(113,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-03 09:50:05','2024-03-03 16:13:03'),(114,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-03 09:50:05','2024-03-04 12:51:05'),(115,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-03 09:50:05','2024-03-10 02:45:12'),(116,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-03 09:50:25','2024-03-03 16:13:03'),(117,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-03 09:50:25','2024-03-04 12:51:05'),(118,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-03 09:50:25','2024-03-10 02:45:12'),(119,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-03 14:00:59','2024-03-03 16:13:03'),(120,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-03 14:00:59','2024-03-04 12:51:05'),(121,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-03 14:00:59','2024-03-10 02:45:12'),(122,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-03 14:01:28','2024-03-03 16:13:03'),(123,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-03 14:01:28','2024-03-04 12:51:05'),(124,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-03 14:01:28','2024-03-10 02:45:12'),(125,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-04 13:01:22','2024-03-11 16:18:07'),(126,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-04 13:01:22','2024-03-04 13:56:36'),(127,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-04 13:01:22','2024-03-10 02:45:12'),(128,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-04 13:02:02','2024-03-11 16:18:07'),(129,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-04 13:02:02','2024-03-04 13:56:36'),(130,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-04 13:02:02','2024-03-10 02:45:12'),(131,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-05 04:40:17','2024-03-11 16:18:07'),(132,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-05 04:40:17','2024-03-05 05:10:41'),(133,NULL,2,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-05 04:40:17','2024-03-10 02:45:12'),(134,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-05 04:40:37','2024-03-11 16:18:07'),(135,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-05 04:40:37','2024-03-05 05:10:41'),(136,NULL,2,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-05 04:40:37','2024-03-10 02:45:12'),(137,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-11 16:27:04','2024-03-23 15:47:28'),(138,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-11 16:27:04','2024-03-11 16:34:51'),(139,NULL,2,NULL,'A seller created product.','/products',NULL,0,0,'2024-03-11 16:27:04','2024-03-11 16:27:04'),(140,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-11 16:27:41','2024-03-23 15:47:28'),(141,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-11 16:27:41','2024-03-11 16:34:51'),(142,NULL,2,NULL,'A seller product approved.','/products',NULL,0,0,'2024-03-11 16:27:41','2024-03-11 16:27:41'),(143,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-15 03:17:08','2024-03-23 15:47:28'),(144,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-15 03:17:08','2024-03-23 16:10:51'),(145,NULL,2,NULL,'A seller created product.','/products',NULL,0,0,'2024-03-15 03:17:08','2024-03-15 03:17:08'),(146,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-15 03:17:48','2024-03-23 15:47:28'),(147,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-15 03:17:48','2024-03-23 16:10:51'),(148,NULL,2,NULL,'A seller product approved.','/products',NULL,0,0,'2024-03-15 03:17:48','2024-03-15 03:17:48'),(149,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-03-23 15:43:03','2024-03-23 15:47:28'),(150,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-03-23 15:43:03','2024-03-23 16:10:51'),(151,NULL,2,NULL,'A seller created product.','/products',NULL,0,0,'2024-03-23 15:43:03','2024-03-23 15:43:03'),(152,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-03-23 15:43:30','2024-03-23 15:47:28'),(153,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-03-23 15:43:30','2024-03-23 16:10:51'),(154,NULL,2,NULL,'A seller product approved.','/products',NULL,0,0,'2024-03-23 15:43:30','2024-03-23 15:43:30'),(155,NULL,5,NULL,'Product created.','/seller/product',NULL,1,1,'2024-04-02 02:04:51','2024-05-29 15:48:45'),(156,NULL,1,NULL,'A seller created product.','/products',NULL,1,1,'2024-04-02 02:04:51','2024-04-26 02:21:39'),(157,NULL,2,NULL,'A seller created product.','/products',NULL,0,0,'2024-04-02 02:04:51','2024-04-02 02:04:51'),(158,NULL,5,NULL,'Product approved.','/seller/product',NULL,1,1,'2024-04-02 02:57:53','2024-05-29 15:48:45'),(159,NULL,1,NULL,'A seller product approved.','/products',NULL,1,1,'2024-04-02 02:57:53','2024-04-26 02:21:39'),(160,NULL,2,NULL,'A seller product approved.','/products',NULL,0,0,'2024-04-02 02:57:53','2024-04-02 02:57:53'),(161,NULL,1,NULL,'A seller updated product.','#',NULL,1,1,'2024-08-25 09:56:26','2024-09-15 12:56:06'),(162,NULL,7,NULL,'Welcome to the system.','#',NULL,0,0,'2024-09-08 23:03:44','2024-09-08 23:03:44'),(163,NULL,1,NULL,'A customer has been registered.','/customer/active-customer-list',NULL,1,1,'2024-09-08 23:03:44','2024-09-15 12:56:06'),(164,NULL,8,NULL,'Welcome to the system.','#',NULL,0,0,'2024-09-14 08:30:42','2024-09-14 08:30:42'),(165,NULL,1,NULL,'A customer has been registered.','/customer/active-customer-list',NULL,1,1,'2024-09-14 08:30:42','2024-09-15 12:56:06');
CREATE TABLE `dashboard_setup` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) DEFAULT NULL,
  `is_active` 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=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `dashboard_setup` VALUES (1,'total_products',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(2,'total_sellers',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(3,'total_customer',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(4,'todays_visitor',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(5,'total_sale',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(6,'total_order',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(7,'pending_order',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(8,'completed_order',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(9,'total_review',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(10,'total_revenue',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(11,'active_customer',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(12,'total_subcriber',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(13,'total_product_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(14,'total_seller_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(15,'total_customer_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(16,'visitor_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(17,'total_order_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(18,'total_pending_order_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(19,'total_completed_order_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(20,'total_sale_amount_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(21,'total_review_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(22,'total_revenue_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(23,'total_active_customer_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(24,'total_subscriber_card',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(25,'product_graph',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(26,'order_summary_graph',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(27,'seller_graph',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(28,'guest_vs_registered_order_graph',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(29,'today_order_summary_graph',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(30,'top_ten_product',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(31,'top_ten_seller',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(32,'category_wise_product_qty',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(33,'category_wise_sale',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(34,'coupon_wise_sale',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(35,'new_customers',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(36,'recently_added_products',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(37,'top_refferer',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(38,'latest_order',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(39,'latest_search_keyword',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(40,'appealed_dispute',1,'2024-01-23 11:19:56','2024-01-23 11:19:56'),(41,'reviews',1,'2024-01-23 11:19:56','2024-01-23 11:19:56');
CREATE TABLE `date_formats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `format` varchar(191) DEFAULT NULL,
  `normal_view` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(10) unsigned DEFAULT 1,
  `updated_by` int(10) unsigned DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `date_formats` VALUES (1,'jS M, Y','17th May, 2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(2,'Y-m-d','2019-05-17',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(3,'Y-d-m','2019-17-05',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(4,'d-m-Y','17-05-2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(5,'m-d-Y','05-17-2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(6,'Y/m/d','2019/05/17',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(7,'Y/d/m','2019/17/05',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(8,'d/m/Y','17/05/2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(9,'m/d/Y','05/17/2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(10,'l jS \\of F Y','Monday 17th of May 2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(11,'jS \\of F Y','17th of May 2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(12,'g:ia \\o\\n l jS F Y','12:00am on Monday 17th May 2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(13,'F j, Y, g:i a','May 7, 2019, 6:20 pm',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(14,'F j, Y','May 17, 2019',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51'),(15,'\\i\\t \\i\\s \\t\\h\\e jS \\d\\a\\y','it is the 17th day',1,1,1,'2024-01-23 11:19:51','2024-01-23 11:19:51');
CREATE TABLE `delivery_processes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `description` longtext 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 `delivery_processes` VALUES (1,'Pending','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College.','2021-02-11 03:33:37','2021-02-11 03:33:37'),(2,'Processing','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College.','2021-02-11 03:33:55','2021-02-11 03:33:55'),(3,'Shipped','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College.','2021-02-11 03:34:08','2021-02-11 03:34:08'),(4,'Recieved','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text ever since the 1500s,','2021-02-11 03:34:30','2021-02-11 03:34:30'),(5,'Delivered','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text ever since the 1500s,','2021-02-11 03:34:43','2021-02-11 03:35:02');
CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `details` varchar(191) DEFAULT 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `departments` VALUES (1,'Sales','Sales Department',1,NULL,NULL),(2,'Marketing','Marketing Department',1,NULL,NULL),(3,'HR','HR Department',1,NULL,NULL),(4,'Boss','Boss',1,'2024-02-05 04:24:30','2024-02-05 04:24:30');
CREATE TABLE `device_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `device_token` text 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 `digital_file_downloads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `seller_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `order_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `package_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `seller_product_sku_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `product_sku_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `download_limit` bigint(20) unsigned NOT NULL DEFAULT 0,
  `downloaded_count` bigint(20) unsigned 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 `digital_files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_sku_id` bigint(20) unsigned NOT NULL,
  `file_source` varchar(255) 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 `digital_gift_cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gift_name` varchar(191) NOT NULL,
  `descriptionOne` text DEFAULT NULL,
  `thumbnail_image_one` varchar(191) DEFAULT NULL,
  `thumbnail_image_two` 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 `dynamic_pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `is_static` tinyint(1) NOT NULL DEFAULT 0,
  `is_page_builder` 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`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `dynamic_pages` VALUES (1,NULL,'About Us','about-us','<div class=\"row\">\n            <div class=\"col-sm-12 ui-resizable\" data-type=\"container-content\"><div class=\"row\">\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"></div>\n        <div class=\"col-sm-6 ui-resizable\" data-type=\"container-content\"><div data-type=\"component-photo\">\n                <div class=\"photo-panel\">\n        <img src=\"data:image/jpeg;base64,[encoded data, 222356 characters]\" width=\"100%\" height=\"\" style=\"display: inline-block;\">\n    </div>\n            </div></div>\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"></div>\n    </div></div>\n        </div><div class=\"row\">\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"></div>\n        <div class=\"col-sm-6 ui-resizable\" data-type=\"container-content\"><div data-type=\"component-text\">\n<p style=\"text-align: center;\"><strong>About eMarket Zone</strong></p>\n\n<p>&nbsp;</p>\n\n<p>We are providing an inspirational shopping experience and unrivalled product range authority, coupled with exceptional convenience. Giving you the best possible shopping experience throughout each stage from browsing and ordering, to receiving your goods, is our key aim and we want to make the whole process as safe and easy as possible. Our priority is giving you the best service. The key to success is the outstanding range of products and associated products at prices to suit all pockets coupled with excellent and knowledgeable customer service.</p>\n\n<p>&nbsp;</p>\n\n<p style=\"text-align: center;\"><strong>OUR PRODUCTS</strong><br>\nWe at eMarket Zone are all about making our customers\' lives comfortable and smarter. We have a massive selection of products and offer unbeatable prices. If you are looking for the latest and the greatest product, eMarket Zone is where you should be! Shop for your favorite brands and products today!</p>\n\n<p>&nbsp;</p>\n\n<p style=\"text-align: center;\"><strong>Safe &amp; Easy Shopping</strong><br>\nOur product categories can be sorted based on how you want to shop. You can simply search for products according to the price, brand, or specifications. Once you have found out a product you love, just add to your “Wishlist” to keep it, or you can add it to your cart and continue to check out. The checkout process is made to be simple and secure. We accept all major Credit and Debit Cards such as: VISA, MASTER CARD, AMERICAN EXPRESS, DISCOVER, JCB, DINERS CLUB, ELO &amp; HIPERCARD. We have also partnered with PayPal.</p>\n\n<p>&nbsp;</p>\n\n<p style=\"text-align: center;\"><strong>Free Fast Shipping</strong><br>\nWe at eMarket Zone work tirelessly to ensure your orders are delivered to your doorstep as fast as possible. We ship our products to hundreds of countries and have warehouses located around the world. You, the customer are kept in mind every aspect of the shipping process, so we only use trusted carriers to ship our goods. If you have any inquiry throughout the shipping process, our customer service will be there to help.</p>\n\n<p>&nbsp;</p>\n\n<p style=\"text-align: center;\"><strong>Download Our APP</strong></p>\n\n<p>Download our app for an even more convenient shopping experience. Enjoy lower prices, exclusive discounts, and extra coupons by using the Geekbuying app today!</p>\n\n<p>&nbsp;</p>\n\n<p>&nbsp;</p>\n</div>\n</div>\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"></div>\n    </div><div class=\"row\">\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"></div>\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"><div data-type=\"component-photo\">\n                <div class=\"photo-panel\" style=\"text-align: right;\">\n        <img src=\"data:image/png;base64,[encoded data, 13456 characters]\" width=\"100%\" height=\"\" style=\"display: inline-block; width: 200px; height: 58px;\" class=\"img-responsive\">\n    </div>\n            </div></div>\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"><div data-type=\"component-photo\">\n                <div class=\"photo-panel\">\n        <img src=\"data:image/png;base64,[encoded data, 12496 characters]\" width=\"100%\" height=\"\" style=\"display: inline-block; width: 200px; height: 58px;\" class=\"img-responsive\">\n    </div>\n            </div></div>\n        <div class=\"col-sm-3 ui-resizable\" data-type=\"container-content\"></div>\n    </div>',1,0,1,NULL,'2024-01-23 06:19:52','2024-02-04 09:07:20'),(3,NULL,'Blog','blog','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(4,NULL,'Become A Merchant','merchant','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(5,NULL,'My Account','profile','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(6,NULL,'My Orders','my-purchase-orders','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(7,NULL,'My Cart','cart','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(8,NULL,'My Wish List','my-wishlist','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(9,NULL,'Refunds & Disputes','refund/my-refund-list','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(10,NULL,'My Coupons','profile/coupons','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(11,NULL,'My Wallet','wallet/customer/my-wallet-index','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(12,NULL,'Referral','profile/referral','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(13,NULL,'Help & Contact Us','contact-us','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(14,NULL,'Track Orders','track-order','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(15,NULL,'Support Tickets','support-ticket','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(16,NULL,'Compare','compare','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(17,NULL,'Dashboard','profile/dashboard','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(18,NULL,'Shopping Recent Viewed','shopping-recent-viewed','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(19,NULL,'My Giftcarts','purchased-gift-cards','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(20,NULL,'My Digital Products','digital-products','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(21,NULL,'Return & Exchange','return-exchange','initial description',1,1,0,NULL,'2024-01-23 06:19:52','2024-01-23 06:19:52'),(22,NULL,'Affiliate','affiliate','<div class=\"row\">\n        <div class=\"col-sm-12 ui-resizable\" data-type=\"container-content\"><div data-type=\"component-text\">\n<div class=\"affiliate_bradcam_area\">\n<div class=\"container\">\n<div class=\"row\">\n<div class=\"col-lg-10 offset-lg-1\">\n<div class=\"breadcam_text text-center\"><span>Join Our Affiliate Program</span>\n<h3>Become a Part of Our Success Earn Up-to 10% On Affiliate</h3>\n\n<p>We offer attractive referral commissions for each successful</p>\n<a class=\"theme_btn\" href=\"https://www.emarketzone.com/affiliate/registration\">Join Our Affiliate Family</a></div>\n</div>\n</div>\n</div>\n</div>\n</div>\n<div data-type=\"component-text\">\n<div class=\"lms_section\">\n<div class=\"container\">\n<div class=\"row justify-content-center\">\n<div class=\"col-xl-10\">\n<div class=\"commision_box\">\n<div alt=\"\" class=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/round.svg\">&nbsp;</div>\n\n<div class=\"comissiion_left\">\n<h4>Commission Rate</h4>\n\n<p class=\"rate_text\">Help Shape the Future of Commerce</p>\n\n<h3>20%</h3>\n\n<p class=\"Sale_text\">For the First Sale</p>\n<a class=\"theme_btn small_btn2\" href=\"#\"><span style=\"color:#e74c3c;\">Create Affiliate Link</span></a>\n\n<p class=\"abc\">Offers 20% commission for first referral sale If your visitor purchases our product for $100&nbsp;you will get a $20&nbsp;commission.</p>\n</div>\n\n<div class=\"comissiion_right flex-fill\">\n<div class=\"commision_payment_lists\">\n<div class=\"commision_payment_list\">\n<div class=\"thumb\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/wallet_1.svg\"></div>\n\n<div class=\"comission_payment_text\">\n<h4>Minimum Payout</h4>\n\n<p>Our affiliates always on 30th of the month for sales referred in last month.</p>\n</div>\n</div>\n\n<div class=\"commision_payment_list\">\n<div class=\"thumb\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/wallet_2.svg\"></div>\n\n<div class=\"comission_payment_text\">\n<h4>Global Payments</h4>\n\n<p>Our affiliates always on 30th of the month for sales referred in last month.</p>\n</div>\n</div>\n\n<div class=\"commision_payment_list\">\n<div class=\"thumb\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/wallet_3.svg\"></div>\n\n<div class=\"comission_payment_text\">\n<h4>Dedicated Support</h4>\n\n<p>Our affiliates always on 30th of the month for sales referred in last month.</p>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n<div class=\"lms_section section_padding2\" data-type=\"component-text\">\n<div class=\"container\">\n<div class=\"row justify-content-center\">\n<div class=\"col-xl-10\">\n<div class=\"work_title_area\">\n<div class=\"section__title4 \"><span class=\"subheading_text\">How Does It Works?</span>\n<h3>We’ve Streamlined Affiliate Process</h3>\n</div>\n\n<div class=\"work_title_desc\">\n<p>Felix is the ultimate product to create unique and powerful experiences online. Easily edit pages and sections to create professional-looking.</p>\n\n<p>We are humans helping other humans succeed and we believe transparency is the key to forging lasting relationships, as we continue to grow.</p>\n</div>\n</div>\n\n<div class=\"row justify-content-center\">\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"process_widget_box text-center mb_30\">\n<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/process_icon_1.svg\"></div>\n\n<h4>Register As Affiliate</h4>\n\n<p>FREE and easy to join! Click join now</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"process_widget_box text-center mb_30\">\n<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/process_icon_2.svg\"></div>\n\n<h4>Advertise</h4>\n\n<p>Choose a product, create a affiliate&nbsp;link and share it on social networks, Youtube, blogs, telegram and your page.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"process_widget_box text-center mb_30\">\n<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/process_icon_3.svg\"></div>\n\n<h4>Earn</h4>\n\n<p>Get Up to 10% commission on every sale made from your link.</p>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n<div data-type=\"component-text\">\n<div class=\"lms_section section_padding2 affiliate_bg\">\n<div class=\"container\">\n<div class=\"row justify-content-center\">\n<div class=\"col-xl-6 col-lg-8 col-md-8\">\n<div class=\"section__title4 text-center margin_52\"><span class=\"subheading_text\">Rules and Requirements</span>\n<h3>Do’s &amp; Don’ts for an eMarket Zone&nbsp;Affiliate</h3>\n</div>\n</div>\n</div>\n\n<div class=\"row justify-content-center\">\n<div class=\"col-xl-10\">\n<div class=\"Requirements_boxs mb_80\">\n<div class=\"single_Requirements_box\">\n<div class=\"Requirements_box_head\">\n<h3>What to Do</h3>\n</div>\n\n<div class=\"Requirements_box_body\">\n<ul>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/green_check.svg\"></div>\n\n	<p>Engage with the WordPress community and suggest our solutions on relevant threads.</p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/green_check.svg\"></div>\n\n	<p>Write reviews and Blog posts about our products and solutions.</p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/green_check.svg\"></div>\n\n	<p>Spread positive awareness about our products and its features through social channels.</p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/green_check.svg\"></div>\n\n	<p>Publish product comparisons, white papers, infographics, images and case studies.</p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/green_check.svg\"></div>\n\n	<p>Create demo videos and video blogs on our products on your own channels.</p>\n	</li>\n</ul>\n</div>\n</div>\n\n<div class=\"single_Requirements_box\">\n<div class=\"Requirements_box_head style2\">\n<h3>What Not to Do</h3>\n</div>\n\n<div class=\"Requirements_box_body\">\n<ul>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/red_cross.svg\"></div>\n\n	<p>Spam with links without having a meaningful conversation and in irrelevant threads.</p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/red_cross.svg\"></div>\n\n	<p>Use Blackhat approach and unethical means to manipulate search engines.</p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/red_cross.svg\"></div>\n\n	<p>Expect commissions on purchases made by you, friends, or family<strong>.</strong></p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/red_cross.svg\"></div>\n\n	<p>Share your affiliate links elsewhere pdf, SMS, MMS, and other&nbsp;and other misleading ways.</p>\n	</li>\n	<li>\n	<div class=\"icon\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/red_cross.svg\"></div>\n\n	<p>you post a link that contains the name of our system in the title but leads to other content.</p>\n	</li>\n</ul>\n</div>\n</div>\n</div>\n\n<div class=\"apply_btn text-center mb_30\"><a class=\"theme_btn min_windth_200 text-center\" href=\"#\">Apply Today</a></div>\n</div>\n</div>\n</div>\n</div>\n</div>\n<div data-type=\"component-text\">\n<div class=\"lms_section section_padding2\">\n<div class=\"container\">\n<div class=\"row justify-content-center\">\n<div class=\"col-xl-6 col-lg-8 col-md-8\">\n<div class=\"section__title4 text-center margin_50\"><span class=\"subheading_text\">eMarket Zone Affiliate Benefits</span>\n<h3 class=\"m-0\">We Follow Industry Standard Practices in Our Affiliate</h3>\n</div>\n</div>\n</div>\n\n<div class=\"row justify-content-center \">\n<div class=\"col-xl-10\">\n<div class=\"Affiliate_benefit_boxs position-relative \">\n<div class=\"row\">\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"Affiliate_benefit_box mb_30\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/benifit_icon_1.png\">\n<h4>Lowest payout commission</h4>\n\n<p>After reaching a minimum WITHDRAW&nbsp;of $50 you can request a payout.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"Affiliate_benefit_box mb_30\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/benifit_icon_2.png\">\n<h4>Amounts of Creative</h4>\n\n<p>Capib vivamus element senisie aene vulp uta eleifend tellus aenean ligulaene barai element senisie aene.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"Affiliate_benefit_box mb_30\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/benifit_icon_3.png\">\n<h4>Dedicated Mentorship</h4>\n\n<p>Capib vivamus element senisie aene vulp uta eleifend tellus aenean ligulaene barai element senisie aene.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"Affiliate_benefit_box mb_30\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/benifit_icon_1.png\">\n<h4>Weekly Follow-Up</h4>\n\n<p>Capib vivamus element senisie aene vulp uta eleifend tellus aenean ligulaene barai element senisie aene.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"Affiliate_benefit_box mb_30\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/benifit_icon_2.png\">\n<h4>Offers and Promotions</h4>\n\n<p>Capib vivamus element senisie aene vulp uta eleifend tellus aenean ligulaene barai element senisie aene.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"Affiliate_benefit_box mb_30\"><img alt=\"\" src=\"https://www.emarketzone.com/Modules/PageBuilder/Resources/assets/img/affiliate/benifit_icon_3.png\">\n<h4>Real-time Reporting</h4>\n\n<p>Capib vivamus element senisie aene vulp uta eleifend tellus aenean ligulaene barai element senisie aene.</p>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n<div data-type=\"component-text\">\n<div class=\"affliate_faq-section\">\n<div class=\"container\">\n<div class=\"row justify-content-center\">\n<div class=\"col-xl-6 col-lg-8 col-md-8\">\n<div class=\"section__title4 text-center margin_52\"><span class=\"subheading_text\">Frequently Asked Questions</span>\n<h3>Never Hesitate to Reach Out Regarding Any Queries</h3>\n</div>\n</div>\n</div>\n\n<div class=\"row\">\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"affiliate_faq_box mb_25\">\n<h4>Do you support banking loan?</h4>\n\n<p>Consectetur adipiscing elit maecenas loboes alesuada am pellentesque sitproin mauris quam congue orciodio laoreet quis nisi lacinia gravida onec.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"affiliate_faq_box mb_25\">\n<h4>How do I open an account?</h4>\n\n<p>Consectetur adipiscing elit maecenas loboes alesuada am pellentesque sitproin mauris quam congue orciodio laoreet quis nisi lacinia gravida onec.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"affiliate_faq_box mb_25\">\n<h4>How do I open an account?</h4>\n\n<p>Consectetur adipiscing elit maecenas loboes alesuada am pellentesque sitproin mauris quam congue orciodio laoreet quis nisi lacinia gravida onec.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"affiliate_faq_box mb_25\">\n<h4>How do I open an account?</h4>\n\n<p>Consectetur adipiscing elit maecenas loboes alesuada am pellentesque sitproin mauris quam congue orciodio laoreet quis nisi lacinia gravida onec.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"affiliate_faq_box mb_25\">\n<h4>How do I open an account?</h4>\n\n<p>Consectetur adipiscing elit maecenas loboes alesuada am pellentesque sitproin mauris quam congue orciodio laoreet quis nisi lacinia gravida onec.</p>\n</div>\n</div>\n\n<div class=\"col-xl-4 col-lg-4 col-md-6\">\n<div class=\"affiliate_faq_box mb_25\">\n<h4>How do I open an account?</h4>\n\n<p>Consectetur adipiscing elit maecenas loboes alesuada am pellentesque sitproin mauris quam congue orciodio laoreet quis nisi lacinia gravida onec.</p>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n    </div>',1,0,1,'Affiliate','2024-01-23 15:55:24','2024-02-04 12:26:02'),(23,NULL,'Terms & conditions','terms-&-conditions','<div>\n            <div>Please read this agreement carefully before proceeding\n\n<p>Welcome to www.emarketzone.com! These Terms of Use describe the terms and conditions applicable to your access and use of the website at www.emarketzone.com. This statement is a legally binding agreement between you as the user(s) of the Site (referred to as \"you\", \"Member\", \"Customer\" or \"User\" hereinafter) and www.emarketzone.com (referred to as \"we\", \"our\", \"us\" or \"eMarket Zone\", \"site\" hereinafter), Please read these terms and conditions carefully before ordering any Products from our site.</p>\n\nUser Agreement\n\n<p>By accessing, browsing or use this website, you are agreeing to be bound by these website\'s terms &amp; conditions of use, all applicable laws &amp; regulations, while agreeing that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this website. The materials contained in this website are protected by applicable copyright and trademark laws.</p>\n\n<p>Our products and services are mainly targeted at adults. If you are a minor, please warrant that you are visiting the Site under the supervision of a parent or legal guardian.</p>\n\n<p> </p>\n\n1. Agreement Condition\n\n<p>1.1 As a condition of your access to and use of the Site or Services, you agree that you will comply with all applicable laws and regulations when using the Site or Services.</p>\n\n<p>1.2 You agree to use the Site or Services solely for your own private and internal purposes. You agree that (a) you will not copy, reproduce, download, re-publish, sell, distribute or resell any Services or any information, text, images, graphics, video clips, sound, directories, files, databases or listings, etc available on or through the Site (the \"Site Content\"), and (b) you will not copy, reproduce, download, compile or otherwise use any Site Content for the purposes of operating a business that competes with eMarket Zone, or otherwise commercially exploiting the Site Content. Systematic retrieval of Site Content from the Site to create or compile, directly or indirectly, a collection, compilation, database or directory (whether through robots, spiders, automatic devices or manual processes) without written permission from eMarket Zone is prohibited. Use of any content or materials on the Site for any purpose not expressly permitted in the Terms is prohibited.</p>\n\n<p>1.3 You must read eMarket Zone\'s Privacy Policy which governs the protection and use of personal information about Users in the possession of eMarket Zone and our affiliates. You agree to the use of the personal information about you in accordance with the Privacy Policy.</p>\n\n<p>1.4 eMarket Zone may allow Users to access to content, products or services offered by third parties through hyperlinks (in the form of word link, banners, channels or otherwise), API or otherwise to such third parties\' web site. You are cautioned to read such web site\' terms and conditions and/or privacy policies before using the Site. You acknowledge that eMarket Zone has no control over such third parties\' web site, does not monitor such web site, and shall not be responsible or liable to anyone for such web site, or any content, products or services made available on such web site.</p>\n\n<p>1.5 You agree not to undertake any action to undermine the integrity of the computer systems or networks of eMarket Zone and/or any other User nor to gain unauthorized access to such computer systems or networks.</p>\n\n<p>1.6 You agree not to undertake any action which may undermine the integrity of eMarket Zone\'s feedback system, such as leaving positive feedback for yourself using secondary Member IDs or through third parties or by leaving unsubstantiated negative feedback for another User.</p>\n\n<p> </p>\n\n2. User\'s Responsibilities\n\n<p>2.1 User must be registered on the Site to use some Services. Except with eMarket Zone\'s approval, one User may only register one user account on the Site. eMarket Zone may cancel or terminate a User\'s account if eMarket Zone has reasons to suspect that the User has concurrently registered or controlled two or more user accounts. Further, eMarket Zone may reject User\'s application for registration for any reason.</p>\n\n<p>2.2 Upon registration on the Site, eMarket Zone shall assign an account and issue a user ID and password (the latter shall be chosen by a registered User during registration) to each registered User. An account may have a web-based email account with limited storage space for the user to send or receive emails. Upon becoming a eMarket Zone User, you consent to authorize eMarket Zone to store and use your information in accordance with the Privacy Policy.</p>\n\n<p>2.3 A set of User ID and password is unique to a single account. Each user shall be solely responsible for maintaining the confidentiality and security of your user ID and password and for all activities that occur under your account. No user may share, assign, or permit the use of your User account, ID or password by another person outside of the User\'s own business entity. User agrees to notify eMarket Zone immediately if you become aware of any unauthorized use of your password or your account or any other breach of security of your account.</p>\n\n<p>2.4 User agrees that all activities that occur under your account (including without limitation, posting any company or product information, clicking to accept any Additional Agreements or rules, subscribing to or making any payment for any services, sending emails using the email account) will be deemed to have been authorized by the User.</p>\n\n<p>2.5 User acknowledges that sharing of your account with other persons, or allowing multiple users to use your account (collectively, \"multiple use\"), may cause irreparable harm to eMarket Zone or other Users of the Site. User shall indemnify eMarket Zone, our affiliates, directors, employees, agents and representatives against any loss or damages (including but not limited to loss of profits) suffered as a result of the multiple use of your account. User also agrees that in case of the multiple use of your account or User\'s failure to maintain the security of your account, eMarket Zone shall not be liable for any loss or damages arising from such a breach and shall have the right to suspend or terminate User\'s account without liability to User.</p>\n\n<p>2.6 User warrants that information you have provided when registering your eMarket Zone account is accurate, truthful, legal, and valid and belongs solely to you. Users are solely responsible for the accuracy of data that they provide to eMarket Zone, and eMarket Zone will not held responsible and will not offer any compensation for any cases by incorrect information.</p>\n\n<p>2.7 User shall have the option to cancel the order only when prior to shipping by contacting our support center. And eMarket Zone reserves the right to cancel the order for operation strategy with a prior notice to User account. However, once the order has been dispatched, the order cannot be canceled, changed, or refunded. Upon receipt of the package, our Return policy comes into effect.</p>\n\n<p>2.8 User shall be respected to have the option to subscribe or cancel newsletter subscription upon registration.</p>\n\n<p>2.9 User understands and agrees that eMarket Zone shall have the right to temporarily or permanently terminate all or part of the services at any time in accordance with its own business needs(including but not limited to the cases like violate the terms and condition of eMarket Zone, unacceptable and unreasonable comments or behaviors towards eMarket Zone\'s brand image ).</p>\n\n<p>2.10 If you have any concerns or complaints regarding our service, please email us directly at Contact Us. You also have the right to make a complaint to official authotities. We would, however, appreciate the chance to deal with your concerns before you approach the third parties, so please do contact us in the first instance.</p>\n\n<p> </p>\n\n3. Acceptance Of Order Terms\n\n<p>3.1 Please note that there may be certain orders that we are unable to accept and must cancel. eMarket Zone reserves the right, at sole discretion, to refuse or cancel any order for any reason. Some situations that may result in your order being canceled include limitations on quantities available for purchase, inaccuracies or errors in product or pricing information, or problems identified by our credit and fraud avoidance department. We may also require additional verifications or information before accepting any order. We will contact you if all or any portion of your order is canceled or if additional information is required to accept your order.<br>\nGiven the popularity and/or supply constraints of some of our products, eMarket Zone may have to limit the number of products available for purchase. eMarket Zone reserves the right to change quantities available for purchase at any time, even after you place an order.</p>\n\n<p>3.2 When you make a purchase, you agree that the risk of loss transfers from eMarket Zone to you from the moment we deliver your order to the carrier.<br>\nYou will bear all related liabilities and risks during the third-party transportation of your order.</p>\n\n<p>3.3 For order payment, shipping and delivery, users should agree with the terms stated on Freight and Pay.</p>\n\n<p>3.4 For warranty and return, users should agree with the terms on Return policy.</p>\n\n<p> </p>\n\n4. Conditions Of Use\n\n<p>4.1 License Use<br>\nPermission is granted to temporarily download one copy of the materials (information or software) from emarketzone.com website for personal &amp; non-commercial transitory viewing only. This is the grant of license, not a transfer of title and under this license you cannot modify or copy the materials, use the materials for any commercial purpose, or for any public display (commercial or non-commercial) attempt to decompile or reverse engineer any software contained on emarketzone.com website, remove any copyright or other proprietary notations from the materials, or transfer the materials to another person or \"mirror\" the materials on any other server. This license shall automatically terminate if you violate any of these restrictions and may be terminated by emarketzone.com at any time. Upon terminating your viewing of these materials or upon the termination of this license, you must destroy any downloaded materials in your possession whether in electronic or printed format.</p>\n\n<p> </p>\n\n<p>4.2 Disclaimer<br>\nThe materials on emarketzone.com website are provided \"as is\". emarketzone.com makes no warranties, expressed or implied, and hereby disclaims and negates all other warranties, including without limitation, implied warranties or conditions of merchantability, fitness for a particular purpose, or non-infringement of intellectual property or other violation of rights. Further, emarketzone.com does not warrant or make any representations concerning the accuracy, likely results, or reliability of the use of the materials on its Internet website or otherwise relating to such materials or on any other website linked to this website.</p>\n\n<p>4.3 Limitations<br>\nIn no event shall emarketzone.com or its suppliers be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption,) arising out of the use or inability to use the materials on emarketzone.com, even if emarketzone.com or a emarketzone.com authorized representative has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you.</p>\n\n<p>4.4 Revisions &amp; Errata<br>\nThe materials appearing on emarketzone.com website could include technical, typographical, or photographic errors. And, emarketzone.com does not warrant that any of the materials on its website are accurate, complete, or current. Also, emarketzone.com may make changes to the materials contained on its website at any time without notice. Furthermore, emarketzone.com does not make any commitment to update the materials.</p>\n\n<p>4.5 Links<br>\nThe website emarketzone.com has not reviewed all of the websites linked to its Internet website and is not responsible for the contents of any such linked website. The inclusion of any such links does not imply endorsement by emarketzone.com of the website. Use of any such linked website is at the user\'s own risk.</p>\n\n<p>4.6 Website Terms of Use Modifications<br>\nThe website emarketzone.com may revise these terms of use for its website at any time without any prior notice. By using this website you are agreeing to be bound by the then current version of these terms &amp; conditions of use.</p>\n</div>\n        </div>',1,0,1,NULL,'2024-02-02 04:17:59','2024-02-02 04:28:56'),(24,NULL,'Career','career','<section class=\"policy_part return_part padding_top bg-white\">\r\n            <div class=\"container\">\r\n                <div class=\"row justify-content-center mb_60 mt_60\">\r\n                    <div class=\"col-lg-10\">\r\n                        <div class=\"policy_part_iner\">\r\n                            <h3 style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased; clear: both; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-size: 2.8rem; line-height: 3.2rem; color: rgb(51, 62, 73); font-family: proxima-nova, helvetica, arial, sans-serif;\">When you want… to be unique</h3><p style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased; margin-right: 0px; margin-bottom: 32px; margin-left: 0px; color: rgb(51, 62, 73); font-family: proxima-nova, helvetica, arial, sans-serif; font-size: 19px;\">Now,\r\n here’s an exercise for you: what is it that you want to tell job \r\nseekers through your careers page? What makes your company a desirable \r\nplace to work? What makes your company special and unlike any other out \r\nthere?</p><p style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased; margin-right: 0px; margin-bottom: 32px; margin-left: 0px; color: rgb(51, 62, 73); font-family: proxima-nova, helvetica, arial, sans-serif; font-size: 19px;\">You don’t have to answer these questions immediately. Check with your colleagues first. Ask them questions such as:</p><ul style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased; margin-bottom: 32px; padding-left: 24px; list-style-position: initial; list-style-image: initial; color: rgb(51, 62, 73); font-family: proxima-nova, helvetica, arial, sans-serif; font-size: 19px;\"><li style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased;\">What do you wish you had known about the company beforehand?</li><li style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased;\">What do you like the most about your job?</li><li style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased;\">What makes you happiest at work?</li><li style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased;\">What keeps you productive?</li><li style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased;\">How have you developed your skills through your time here?</li><li style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased;\">How would you describe your work life to a friend?</li></ul><p style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased; margin-right: 0px; margin-bottom: 32px; margin-left: 0px; color: rgb(51, 62, 73); font-family: proxima-nova, helvetica, arial, sans-serif; font-size: 19px;\">Make\r\n sure to talk with employees from all departments to get different \r\nperspectives. Then, it’s time to set up your site. You can use the \r\naforementioned career page examples as an inspiration but don’t forget \r\nto add your unique touch. That’s the only way to attract candidates who \r\nwant to work&nbsp;<em style=\"box-sizing: inherit; -webkit-font-smoothing: antialiased;\">specifically</em>&nbsp;with you.</p>                        </div>\r\n                    </div>\r\n                </div>\r\n            </div></section>',1,0,0,NULL,'2024-02-03 08:57:51','2024-02-03 08:57:51'),(25,NULL,'Privacy Policy','privacy-policy','<div class=\"row\">\n        <div class=\"col-sm-4 ui-resizable\" data-type=\"container-content\"><div data-type=\"component-photo\">\n                <div class=\"photo-panel\" style=\"text-align: center;\">\n        <img src=\"data:image/png;base64,[encoded data, 118272 characters]\" width=\"100%\" height=\"\" style=\"display: inline-block; width: 160px; height: 600px;\">\n    </div>\n            </div></div>\n        <div class=\"col-sm-8 ui-resizable\" data-type=\"container-content\"><div data-type=\"component-text\">\n<p>&nbsp;</p>\n\n<p style=\"text-align: center;\"><span style=\"font-size:20px;\"><strong>Privacy Policy</strong></span></p>\n\n<p>&nbsp;</p>\n\n<p>Here at www.emarketzone.com (hereinafter referred to as \"we\", \"us\" or \"eMarket Zone\", \"Site\"), we are committed to protecting and respecting the privacy of your personal data. This privacy policy explains how your data is collected, used, transferred and disclosed by eMarket Zone. It applies to data collected when you use our websites when you interact with us through social media, email, or phone, or when you participate in our competitions or events.</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"One\">1. Our commitment to you</h4>\n\n<p>We take the protection of your personal data seriously and will process your personal data fairly, lawfully and transparently. This privacy policy describes the personal data we are collecting about you and how it is used.</p>\n\n<p>We will only collect and use your personal data for the following purposes, to:<br>\n1.1 complete your order(s)<br>\n1.2 offer you a better shopping experience<br>\n1.3 improve our services<br>\n1.4 meet our legal responsibilities</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"Two\">2. How we secure your data</h4>\n\n<p>We have appropriate organizational safeguards and security measures in place to protect your data from being accidentally lost, used or accessed in an unauthorized way, altered or disclosed.</p>\n\n<p>The communication between your browser and our website uses a secure encrypted connection wherever your personal data is involved. We encrypt your data and store it on secure servers hidden behind a firewall.</p>\n\n<p>We require any third party who is contracted to process your personal data on our behalf to have security measures in place to protect your data and to treat such data in accordance with the law.</p>\n\n<p>In the unfortunate event of a personal data breach, we will notify you and any applicable regulator when we are legally required to do so.</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"Three\">3. The personal data we collect</h4>\n\n<p>By visiting our website, to complete registration, ordering and notification, we collect and store information for legal use, included but not limited to:<br>\n3.1 email address, including email address provided via approved third parties associated.<br>\n3.2 shipping and billing address ( es ), including name, address line, phone number.<br>\n3.3 specific information for payment verification and Customs issues.<br>\n3.4 technical data, including IP address, date and time, browser and operating system, the URL you requested, etc.</p>\n\n<p>We also protect all personal information that is collected from you offline, such as through phone calls. If we contact you by telephone regarding an order or payment, we will ask only for the personal information needed to place your order or resolve your issue. When we need to store information related to an order, we enter it into our database through SSL encryption.</p>\n\n<p>While our website is designed for a general audience, we will not knowingly collect any data from children or sell products to children, who are not permitted to use or submit the data to the website.</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"Four\">4. How we collect your data</h4>\n\n<p>We may collect personal data about you in the following ways:<br>\n4.1 Direct interactions – you may give us your Identity, Contact, Financial, Transaction, Profile, and Marketing and Communications data by filling in forms, entering information online or by corresponding with us by post, phone, email, telephone or otherwise. This includes personal data you provide, for example, when you:<br>\n4.1.1 Create an account or purchase products on our website;<br>\n4.1.2 Subscribe to our newsletter, discussion boards, social media sites or create wish lists;<br>\n4.1.3 Complete a voluntary market research survey;<br>\n4.1.4 Contact us with an enquiry or to report a problem (by phone, email, social media, or messaging service);<br>\n4.1.5 When you log in to our website via social media.<br>\n4.2 Indirect interactions – as you interact with our website, we may automatically collect the technical data by using cookies, server logs and other similar technologies. Please see <a href=\"#\">About Cookies</a> for further details.<br>\n4.3 Third parties – we may receive personal data about you from various third parties, including:<br>\n4.3.1 assoiated third parties, including analytics providers such as Google;<br>\n4.3.2 affiliate networks through whom you have accessed our website;<br>\n4.3.3 social media platforms when you log in to our website using such social media platforms;</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"Five\">5. How we use your data</h4>\n\n<p>We will only collect and process your personal data where we have a legal basis to do so. As a data controller, the legal basis for our collection and use of your personal data varies depending on the manner and purpose for which we collected it.</p>\n\n<p>5.1 we have your consent to do so, or<br>\n5.2 we need your personal data to perform a contract with you. For example, to process a payment from you, fulfill your order or provide customer support connected with an order, or<br>\n5.3 the processing is in our legitimate interests and not overridden by your rights, or<br>\n5.4 we have a legal obligation to collect or disclose personal data from you.</p>\n\n<p>Your personal data is used by eMarket Zone&nbsp;to support a range of different activities. These are listed in the table below together with the types of data used and the legal bases we rely on when processing them, including where appropriate, our legitimate interests. Please be aware that we may process your personal data using more than one lawful basis, depending on the specific activity involved. Please contact us if you need details about the specific legal ground we are relying on to process your personal data where more than one ground has been set out in the table below.</p>\n\n<p>5.5 To create an account and register you as a new customer (either directly or via social media).<br>\n5.6 To process and deliver your order including: recording your order details; keeping you informed about the order status; process payments and refunds, collect money owed to us; and assist fraud prevention and detection.<br>\n5.7 To manage our relationship with you, including: providing you with any information, products and services that you request from us; notifying you about changes to our services, terms and conditions or privacy policy; asking you to leave a review or take a survey.<br>\n5.8 To enable you to take part in a competition, event, survey, or receive a reward for shopping with us.<br>\n5.9 To administer, protect and improve our business and our website/app, including: troubleshooting, data analysis, testing, system maintenance, support, data analysis, reporting and hosting of data; setting default options for you, such as language and currency.<br>\n5.10 To deliver relevant website content, online advertisements and information for you; and measure the effectiveness of the advertising provided.<br>\n5.11 To use data analytics to: improve our website, products, services, marketing, customer relationships and experiences; and for market research, statistical and survey purposes.<br>\n5.12 To recommend products, services discounts, promotions, reward campaigns, as well as offers that may be of interest to you, including sending you such information by email, post or SMS,&nbsp;subscribing to our newsletter, responding to a survey or access to occasional website news and updates.<br>\n5.13 To inform or remind you by email of any task carried out via our website which remains uncompleted, such as incomplete orders or abandoned baskets.</p>\n\n<p>We will only use your personal data for the purposes for which we collected it, unless we reasonably consider that we need to use it for another reason and that reason is compatible with the original purpose. If we wish to use your personal data for an unrelated purpose, we will notify you and we will explain the legal basis which allows us to do so. We may process personal data without your consent, in compliance with the above rules, where this is required or permitted by law.</p>\n\n<p>We will keep your personal data for no longer than is necessary for the purpose(s) it was provided for and to meet our legal obligations. Further details of the periods for which we retain data are available on request.</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"AboutCookies\">6. About Cookies</h4>\n\n<p>We use \"cookies\" to store specific information about you and track your visits to the Site, either through a compute or via a mobile device. It is not uncommon for websites to use cookies to enhance identification of their visitors.</p>\n\n<p>A \"cookie\" is a small amount of data that is sent to your browser and stored on your computer\'s or mobile device\'s hard drive. If you do not de-activate or erase the cookie, each time you use the same browser or mobile device to access the Site, our web servers will be notified of your visit to the Site and in turn we may have knowledge of your visit and the pattern of your usage. The cookies will enable us to remember your information so you do not have to re-enter it every time you use the Site.</p>\n\n<p>In addition, we use cookies to manage the security of our Site, to gather information about usage by users; to research visiting patterns and conduct interest-based advertising; to assist our partners to track user visits to the Site and process orders; and to track progress and participation in promotions.</p>\n\n<p>For these additional purposes identified above, you can determine if and how a cookie will be accepted by configuring the privacy setting of the browser you are using to access the Site or the privacy setting of your mobile device. If you adjust the privacy setting in the browser, your mobile device will continue collecting data unless you adjust the privacy setting of the device, and vice versa.</p>\n\n<p>Certain features of the Site depend on cookies. Please be aware that if you choose to block cookies, you may not be able to sign in or use those features, and preferences that are dependent on cookies may be lost.</p>\n\n<p>We use a range of analytics and targeted advertising tools to display relevant website content on our website and online advertisements on other websites and apps (as described above) to you, deliver relevant content to you in marketing communications (where applicable), and to measure the effectiveness of the advertising provided. For example, we use tools such as Google Analytics to analyze Google\'s interest-based advertising data and/or third-party audience data (such as age, marital status, life event, gender and interests) to target and improve our marketing campaigns, marketing strategies and website content. We may also use tools provided by other third parties, such as Facebook,</p>\n\n<p>Our website may include links to and from the websites of our partner networks, advertisers and affiliates, or to social media platforms. If you follow a link to any of these websites, please note that these websites have their own privacy policies and that we do not accept any responsibility or liability for these policies. Please check these policies before you submit any personal data to their websites.</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"Seven\">7. How we share your data</h4>\n\n<p>We do not sell, rent, trade, license, or otherwise disclose or share your personal or financial information to anyone, except in the following specific situations:<br>\n7.1 Third-party service providers: Like most online merchants, we sometimes use third-party service providers to perform specific functions on our behalf. Any information disclosed to them is solely to help in their provision of service. For example, we provide your name, shipping address and phone number to partners such as DHL in order to guarantee delivery of your orders, and we may use relevant customer information in order to monitor the quality of the third party\'s service.<br>\n7.2 Legal requirement to disclose information: We may be required to disclose information if subpoenaed, served with a court order or requested by law-enforcement officials conducting investigations, or if we are otherwise required by law to disclose such information. We will also release personal information when necessary to protect our legal rights or enforce our Terms of Use and other agreements. For example, we may share information to reduce the risk of fraud, or to prevent fraud by users who attempt fraud or other illegal activity on our Site.<br>\n7.3 Merger and/or sale of assets: We do not normally sell, trade or rent personal information to other companies in the course of our business. However, it is possible that we might acquire, merge with or be acquired by another company, or that we might dispose of some or all of our assets, in which case your personal information could be disclosed to another company, subject to the Privacy Policy in effect.<br>\n7.4 Non-personally identifiable information: We may share information that does not identify you or any user, such as the number of daily visitors to a particular page, or the size of an order placed on a certain date, with third parties such as advertising partners.</p>\n\n<p>&nbsp;</p>\n\n<h4 id=\"Eight\">8. Your Rights on your personal data</h4>\n\n<p>You have several rights under the data privacy legislation. This includes, under certain circumstances, the right to:<br>\n&nbsp;&nbsp;8.1 request access to your personal data<br>\n&nbsp;&nbsp;8.2 request correction of your personal data<br>\n&nbsp;&nbsp;8.3 request erasure of your personal data<br>\n&nbsp;&nbsp;8.4 request restriction of processing of your personal data<br>\n&nbsp;&nbsp;8.5 request the transfer of your personal data<br>\n&nbsp;&nbsp;8.6 object to processing of your personal data<br>\n&nbsp;&nbsp;8.7 object to automated decision making<br>\n&nbsp;&nbsp;This Terms of Use shall be governed by and construed in accordance with the laws of Lithuania<br>\n&nbsp;&nbsp;If you wish to exercise any of these rights,or have any questions,comments or requests for more information,please email us at <a href=\"mailto:office@emarketzone.com\">office@emarketzone.com</a>.</p>\n\n<h4 id=\"Nine\">9. Changes to this Privacy Policy</h4>\n\n<p>From time to time we may change this privacy policy. If there are any significant changes we will post updates on our website, applications or let you know by email.</p>\n</div>\n</div>\n    </div>',1,0,1,NULL,'2024-02-04 12:27:29','2024-02-07 05:07:00');
