
--
-- Table structure for table `wp_social_users`
--

CREATE TABLE `wp_social_users` (
  `ID` int(11) NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `identifier` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `link_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY `ID` (`ID`,`type`),
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_social_users`
--


--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE `wp_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` VALUES (1,1,0),(19,1,0),(20,1,0),(21,1,0),(22,16,0),(22,17,0),(23,16,0),(23,18,0),(23,19,0),(23,20,0),(23,21,0),(24,16,0),(24,18,0),(24,19,0),(24,20,0),(24,21,0),(25,16,0),(26,16,0),(166,2,0),(166,24,0),(166,25,0),(166,26,0),(166,27,0),(166,81,0),(167,2,0),(167,9,0),(167,13,0),(167,29,0),(167,30,0),(167,31,0),(167,81,0),(168,2,0),(168,83,0),(169,2,0),(169,84,0),(170,2,0),(170,85,0),(171,2,0),(171,24,0),(171,37,0),(171,38,0),(171,39,0),(171,40,0),(171,41,0),(171,85,0),(172,2,0),(172,15,0),(172,25,0),(172,26,0),(172,42,0),(173,4,0),(173,25,0),(173,26,0),(173,43,0),(173,87,0),(174,2,0),(174,25,0),(174,26,0),(174,43,0),(174,87,0),(175,2,0),(175,25,0),(175,26,0),(175,43,0),(175,87,0),(176,2,0),(176,25,0),(176,26,0),(176,43,0),(176,83,0),(177,2,0),(177,25,0),(177,26,0),(177,43,0),(177,83,0),(178,2,0),(178,25,0),(178,26,0),(178,44,0),(178,87,0),(179,2,0),(179,24,0),(179,25,0),(179,26,0),(179,27,0),(179,87,0),(223,64,0),(224,65,0),(225,65,0),(226,65,0),(227,65,0),(228,65,0),(229,65,0),(230,64,0),(231,66,0),(254,66,0),(255,66,0),(256,66,0),(267,67,0),(268,66,0),(429,67,0),(438,67,0),(452,67,0),(468,67,0),(469,67,0),(470,67,0),(471,67,0),(472,67,0),(473,67,0),(489,2,0),(489,89,0),(494,2,0),(494,88,0),(498,2,0),(498,91,0),(501,2,0),(501,91,0),(504,2,0),(504,90,0),(508,2,0),(508,90,0),(511,2,0),(511,91,0),(514,2,0),(514,89,0),(518,2,0),(518,88,0),(547,67,0);

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,4),(2,2,'product_type','',0,22),(3,3,'product_type','',0,0),(4,4,'product_type','',0,1),(5,5,'product_type','',0,0),(6,6,'product_visibility','',0,0),(7,7,'product_visibility','',0,0),(8,8,'product_visibility','',0,0),(9,9,'product_visibility','',0,1),(10,10,'product_visibility','',0,0),(11,11,'product_visibility','',0,0),(12,12,'product_visibility','',0,0),(13,13,'product_visibility','',0,1),(14,14,'product_visibility','',0,0),(15,15,'product_cat','',0,1),(16,16,'category','',0,5),(17,17,'post_format','',0,1),(18,18,'post_tag','',0,2),(19,19,'post_tag','',0,2),(20,20,'post_tag','',0,2),(21,21,'post_tag','',0,2),(24,24,'product_tag','',0,3),(25,25,'product_tag','',0,9),(26,26,'product_tag','',0,9),(27,27,'product_tag','',0,2),(29,29,'product_tag','',0,1),(30,30,'product_tag','',0,1),(31,31,'product_tag','',0,1),(37,37,'product_tag','',0,1),(38,38,'product_tag','',0,1),(39,39,'product_tag','',0,1),(40,40,'product_tag','',0,1),(41,41,'product_tag','',0,1),(42,42,'product_tag','',0,1),(43,43,'product_tag','',0,5),(44,44,'product_tag','',0,1),(46,46,'product_tag','',0,0),(47,47,'product_tag','',0,0),(48,48,'product_tag','',0,0),(49,49,'product_tag','',0,0),(50,50,'product_tag','',0,0),(51,51,'product_tag','',0,0),(52,52,'product_tag','',0,0),(53,53,'product_tag','',0,0),(54,54,'product_tag','',0,0),(55,55,'product_tag','',0,0),(62,62,'product_tag','',0,0),(63,63,'product_tag','',0,0),(64,64,'featured_item_category','',0,2),(65,65,'featured_item_category','',0,6),(66,66,'nav_menu','',0,5),(67,67,'nav_menu','',0,11),(68,68,'wcmp_spmv','Used for minimum price products under all single product multi vendor concept.',0,0),(69,69,'wcmp_spmv','Used for maximum price products under all single product multi vendor concept.',0,0),(70,70,'wcmp_spmv','Used for top rated vendor products under all single product multi vendor concept.',0,0),(71,71,'wcmp_gtin','',0,0),(72,72,'wcmp_gtin','',0,0),(73,73,'wcmp_gtin','',0,0),(74,74,'wcmp_gtin','',0,0),(75,75,'wcmp_gtin','',0,0),(76,76,'wcmp_gtin','',0,0),(77,77,'wcmp_gtin','',0,0),(78,78,'wcmp_gtin','',0,0),(79,79,'product_shipping_class','',0,0),(80,80,'dc_vendor_shop','',0,0),(81,81,'product_cat','',0,2),(83,83,'product_cat','',0,3),(84,84,'product_cat','',0,1),(85,85,'product_cat','',0,2),(86,86,'product_cat','',0,0),(87,87,'product_cat','',0,5),(88,88,'product_cat','',0,2),(89,89,'product_cat','',0,2),(90,90,'product_cat','',0,2),(91,91,'product_cat','',0,3),(92,92,'product_cat','',0,0),(93,93,'product_cat','',0,0);

--
-- Table structure for table `wp_termmeta`
--

CREATE TABLE `wp_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_termmeta`
--

INSERT INTO `wp_termmeta` VALUES (5,24,'product_count_product_tag','3'),(6,25,'product_count_product_tag','9'),(7,26,'product_count_product_tag','9'),(8,27,'product_count_product_tag','2'),(11,29,'product_count_product_tag','1'),(12,30,'product_count_product_tag','1'),(13,31,'product_count_product_tag','1'),(24,37,'product_count_product_tag','1'),(25,38,'product_count_product_tag','1'),(26,39,'product_count_product_tag','1'),(27,40,'product_count_product_tag','1'),(28,41,'product_count_product_tag','1'),(29,42,'product_count_product_tag','1'),(30,43,'product_count_product_tag','5'),(31,44,'product_count_product_tag','1'),(34,46,'product_count_product_tag','0'),(35,47,'product_count_product_tag','0'),(36,48,'product_count_product_tag','0'),(37,49,'product_count_product_tag','0'),(38,50,'product_count_product_tag','0'),(39,51,'product_count_product_tag','0'),(40,52,'product_count_product_tag','0'),(41,53,'product_count_product_tag','0'),(42,54,'product_count_product_tag','0'),(43,55,'product_count_product_tag','0'),(56,62,'product_count_product_tag','0'),(57,63,'product_count_product_tag','0'),(58,79,'vendor_id','2'),(59,79,'vendor_shipping_origin','GB'),(60,80,'_vendor_user_id','2'),(61,81,'order','0'),(62,81,'product_count_product_cat','2'),(63,15,'product_count_product_cat','1'),(68,83,'order','0'),(69,83,'commision','0'),(70,83,'display_type',''),(71,83,'thumbnail_id','0'),(72,84,'order','0'),(73,84,'commision','0'),(74,84,'display_type',''),(75,84,'thumbnail_id','0'),(76,85,'order','0'),(77,85,'commision','0'),(78,85,'display_type',''),(79,85,'thumbnail_id','0'),(80,86,'order','0'),(81,86,'commision','0'),(82,86,'display_type',''),(83,86,'thumbnail_id','0'),(84,87,'order','0'),(85,87,'commision','0'),(86,87,'display_type',''),(87,87,'thumbnail_id','0'),(89,83,'product_count_product_cat','3'),(90,84,'product_count_product_cat','1'),(91,85,'product_count_product_cat','2'),(92,87,'product_count_product_cat','5'),(93,88,'order','0'),(94,89,'order','0'),(95,90,'order','0'),(96,91,'order','0'),(97,92,'order','0'),(98,93,'order','0'),(99,88,'product_count_product_cat','2'),(100,89,'product_count_product_cat','2'),(101,91,'product_count_product_cat','3'),(102,90,'product_count_product_cat','2');

--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'simple','simple',0),(3,'grouped','grouped',0),(4,'variable','variable',0),(5,'external','external',0),(6,'exclude-from-search','exclude-from-search',0),(7,'exclude-from-catalog','exclude-from-catalog',0),(8,'featured','featured',0),(9,'outofstock','outofstock',0),(10,'rated-1','rated-1',0),(11,'rated-2','rated-2',0),(12,'rated-3','rated-3',0),(13,'rated-4','rated-4',0),(14,'rated-5','rated-5',0),(15,'Uncategorized','uncategorized',0),(16,'Style','style',0),(17,'Video','post-format-video',0),(18,'brooklyn','brooklyn',0),(19,'fashion','fashion',0),(20,'style','style-2',0),(21,'women','women-3',0),(24,'jeans','jeans-2',0),(25,'man','man',0),(26,'t-shirt','t-shirt',0),(27,'white','white',0),(29,'Diesel','diesel',0),(30,'shoe','shoe',0),(31,'stars','stars',0),(37,'fit','fit',0),(38,'levis','levis',0),(39,'party','party',0),(40,'washed-out','washed-out',0),(41,'women','women-2',0),(42,'River Island','river-island',0),(43,'Jack and Jones','jack-and-jones',0),(44,'Lee','lee',0),(46,'bag','bag',0),(47,'classic','classic',0),(48,'leather','leather',0),(49,'sweden','sweden',0),(50,'green','green',0),(51,'nypd','nypd',0),(52,'Converse','converse',0),(53,'rock chick','rock-chick',0),(54,'vans','vans',0),(55,'run','run',0),(62,'Jumper','jumper',0),(63,'Pink','pink',0),(64,'Lookbook','lookbook',0),(65,'Design','design',0),(66,'Secondary','secondary',0),(67,'Main','main',0),(68,'Min Price','min-price',0),(69,'Max Price','max-price',0),(70,'Top rated vendor','top-rated-vendor',0),(71,'UPC','upc',0),(72,'EAN','ean',0),(73,'ISBN','isbn',0),(74,'ISSN','issn',0),(75,'ISMN','ismn',0),(76,'JAN','jan',0),(77,'ITF-14','itf-14',0),(78,'MPUIN','mpuin',0),(79,'sonuvalakam-2','sonuvalakam-2',0),(80,'sonuvalakam','sonuvalakam',0),(81,'Kancheepuram Sarees','kancheepuram-sarees',0),(83,'Fancy Sarees','fancy-sarees',0),(84,'party gown','party-gown',0),(85,'Lachas','lachas',0),(86,'Lehengas','lehengas',0),(87,'Gowns','gowns',0),(88,'Ladies Wear','ladies-wear',0),(89,'Designer Wear','designer-wear',0),(90,'Leggings','leggings',0),(91,'Kurtis | Top | Saries','kurtis-top-saries',0),(92,'Churidar Materials','churidar-materials',0),(93,'Bottoms etc..','bottoms-etc',0);

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','Marlins'),(2,1,'first_name','sonu'),(3,1,'last_name','s'),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'syntax_highlighting','true'),(7,1,'comment_shortcuts','false'),(8,1,'admin_color','fresh'),(9,1,'use_ssl','0'),(10,1,'show_admin_bar_front','true'),(11,1,'locale',''),(12,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wp_user_level','10'),(14,1,'dismissed_wp_pointers',''),(15,1,'show_welcome_panel','1'),(17,1,'wp_dashboard_quick_press_last_post_id','562'),(18,1,'community-events-location','a:1:{s:2:\"ip\";s:19:\"2409:4073:95:f4f5::\";}'),(19,1,'_woocommerce_tracks_anon_id','woo:0PtcsQ9r+AFN/avoNb3safjS'),(20,1,'wc_last_active','1629676800'),(24,1,'nav_menu_recently_edited','67'),(25,1,'managenav-menuscolumnshidden','a:5:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";i:4;s:15:\"title-attribute\";}'),(26,1,'metaboxhidden_nav-menus','a:8:{i:0;s:20:\"add-post-type-blocks\";i:1;s:21:\"add-post-type-product\";i:2;s:27:\"add-post-type-featured_item\";i:3;s:12:\"add-post_tag\";i:4;s:15:\"add-post_format\";i:5;s:15:\"add-product_tag\";i:6;s:26:\"add-featured_item_category\";i:7;s:21:\"add-featured_item_tag\";}'),(27,1,'wp_user-settings','libraryContent=browse'),(28,1,'wp_user-settings-time','1607589716'),(42,2,'nickname','sonuvalakam'),(43,2,'first_name',''),(44,2,'last_name',''),(45,2,'description',''),(46,2,'rich_editing','true'),(47,2,'syntax_highlighting','true'),(48,2,'comment_shortcuts','false'),(49,2,'admin_color','fresh'),(50,2,'use_ssl','0'),(51,2,'show_admin_bar_front','true'),(52,2,'locale',''),(53,2,'wp_capabilities','a:1:{s:9:\"dc_vendor\";b:1;}'),(54,2,'wp_user_level','0'),(55,2,'wcmp_vendor_fields','a:2:{i:1;a:3:{s:5:\"value\";s:18:\"wrtryu7i8o90poiuyt\";s:5:\"label\";s:19:\"Company Description\";s:4:\"type\";s:8:\"textarea\";}i:2;a:3:{s:5:\"value\";s:2:\"on\";s:5:\"label\";s:19:\"Quality Certificate\";s:4:\"type\";s:8:\"checkbox\";}}'),(56,2,'session_tokens','a:1:{s:64:\"f88b954b6119139023e862ad819321533df128be3ae569b0c81bf391d69f6e0d\";a:4:{s:10:\"expiration\";i:1606475450;s:2:\"ip\";s:12:\"157.44.203.7\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.193 Safari/537.36\";s:5:\"login\";i:1605265850;}}'),(57,2,'wc_last_active','1605225600'),(58,2,'shipping_class_id','79'),(59,2,'_vendor_term_id','80'),(60,2,'_vendor_page_title','sonuvalakam'),(61,2,'_vendor_added_product','1'),(63,1,'last_update','1607658343'),(64,1,'billing_first_name','sonu'),(65,1,'billing_last_name','s'),(66,1,'billing_company','ghjkl'),(67,1,'billing_address_1','dfgfhj'),(68,1,'billing_address_2','ftygu'),(69,1,'billing_city','kochi'),(70,1,'billing_state','KL'),(71,1,'billing_postcode','68316'),(72,1,'billing_country','IN'),(73,1,'billing_email','sonuvalakam@gmail.com'),(74,1,'billing_phone','09447727591'),(75,1,'shipping_method',''),(77,1,'paying_customer','1'),(79,1,'_order_count','2'),(84,1,'closedpostboxes_page','a:1:{i:0;s:22:\"flatsome_page_options2\";}'),(85,1,'metaboxhidden_page','a:0:{}'),(88,1,'woocommerce_admin_activity_panel_inbox_last_read','1607658342128'),(92,1,'meta-box-order_page','a:3:{s:4:\"side\";s:47:\"flatsome_page_options2,ht_ctc_settings_meta_box\";s:6:\"normal\";s:0:\"\";s:8:\"advanced\";s:0:\"\";}'),(94,1,'closedpostboxes_nav-menus','a:0:{}'),(96,1,'session_tokens','a:2:{s:64:\"614140a912228aee01017cd5dec0a3b77b029ee8a8cae92086d05a7c9dc64fc2\";a:4:{s:10:\"expiration\";i:1629872885;s:2:\"ip\";s:37:\"2409:4073:95:f4f5:adf2:9f2c:8934:2550\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Safari/537.36\";s:5:\"login\";i:1629700085;}s:64:\"b87936d2de1e303fcfc3aab3e6fe7b7d12b4221ef699281ea0e117f801c86001\";a:4:{s:10:\"expiration\";i:1629872896;s:2:\"ip\";s:37:\"2409:4073:95:f4f5:adf2:9f2c:8934:2550\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Safari/537.36\";s:5:\"login\";i:1629700096;}}'),(97,3,'nickname','krystyna.eichel94'),(98,3,'first_name',''),(99,3,'last_name',''),(100,3,'description',''),(101,3,'rich_editing','true'),(102,3,'syntax_highlighting','true'),(103,3,'comment_shortcuts','false'),(104,3,'admin_color','fresh'),(105,3,'use_ssl','0'),(106,3,'show_admin_bar_front','true'),(107,3,'locale',''),(108,3,'wp_capabilities','a:1:{s:8:\"customer\";b:1;}'),(109,3,'wp_user_level','0'),(110,3,'session_tokens','a:1:{s:64:\"97bef6878560c568b8c3bee5b8a6a6bb8f12ce6b40c1009f282a5530236e8c8e\";a:4:{s:10:\"expiration\";i:1629004634;s:2:\"ip\";s:15:\"195.140.212.162\";s:2:\"ua\";s:77:\"Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101 Firefox/4FD9\";s:5:\"login\";i:1627795034;}}'),(111,3,'wc_last_active','1627776000');

--
-- Table structure for table `wp_users`
--

CREATE TABLE `wp_users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_pass` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_nicename` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_url` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT '0',
  `display_name` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`),
  KEY `user_email` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_users`
--

INSERT INTO `wp_users` VALUES (1,'Marlins','$P$B1et57QYzWd4TJdbKyBTpUCWMwZ9481','marlins','joaijo93@gmail.com','http://demoweblinks.in/marlins','2020-11-09 14:43:33','',0,'Marlins'),(2,'sonuvalakam','$P$B5AKE.mz6KBaxMdqi7TKQKCMu2m30k/','sonuvalakam','sonuvalakam@gmail.com','','2020-11-13 11:10:49','',0,'sonuvalakam'),(3,'krystyna.eichel94','$P$Bfc7e/Zth54B5Hl3x87VTWpuHFPhmI1','krystyna-eichel94','krystyna.eichel94@hounslowminicoaches.co.uk','','2021-08-01 05:17:13','',0,'krystyna.eichel94');

--
-- Table structure for table `wp_wc_admin_note_actions`
--

CREATE TABLE `wp_wc_admin_note_actions` (
  `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `note_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `query` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `actioned_text` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`action_id`),
  KEY `note_id` (`note_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14789 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_admin_note_actions`
--

INSERT INTO `wp_wc_admin_note_actions` VALUES (1,1,'yes-please','Yes please!','https://woocommerce.us8.list-manage.com/subscribe/post?u=2c1434dc56f9506bf3c3ecd21&amp;id=13860df971&amp;SIGNUPPAGE=plugin','actioned',0,''),(2,2,'open-marketing-hub','Open marketing hub','http://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&path=/marketing','actioned',0,''),(6,6,'connect','Connect','?page=wc-addons&section=helper','unactioned',0,''),(7,7,'continue-profiler','Continue Store Setup','http://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&path=/setup-wizard','unactioned',1,''),(8,7,'skip-profiler','Skip Setup','http://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&reset_profiler=0','actioned',0,''),(186,8,'learn-more','Learn more','https://woocommerce.com/mobile/','actioned',0,''),(208,9,'learn-more','Learn more','https://docs.woocommerce.com/document/managing-orders/?utm_source=inbox','actioned',0,''),(218,10,'tracking-opt-in','Activate usage tracking','','actioned',1,''),(222,11,'share-feedback','Share feedback','https://automattic.survey.fm/new-onboarding-survey','actioned',0,''),(223,12,'affirm-insight-first-sale','Yes','','actioned',0,'Thanks for your feedback'),(224,12,'deny-insight-first-sale','No','','actioned',0,'Thanks for your feedback'),(245,15,'home-screen-feedback-share-feedback','Share feedback','https://automattic.survey.fm/home-screen-survey','actioned',0,''),(1232,20,'learn-more','Learn more','https://woocommerce.com/mobile/?utm_source=inbox','actioned',0,''),(1474,14,'install-now','Install now','admin.php?page=wc-admin&action=setup-woocommerce-payments','actioned',1,''),(1476,17,'install-now','Install now','admin.php?page=wc-admin&action=setup-woocommerce-payments','actioned',1,''),(1639,27,'install-mollie','Install Mollie','https://wordpress.org/plugins/mollie-payments-for-woocommerce/','actioned',1,''),(4757,48,'learn-more','Learn more','https://woocommerce.com/mobile/?utm_source=inbox','actioned',0,''),(6142,49,'mercadopago_q3_2021_EN','Free download','https://woocommerce.com/products/mercado-pago-checkout/?utm_source=inbox&utm_medium=product&utm_campaign=mercadopago_q3_2021_EN','actioned',1,''),(8118,54,'learn-more','Learn more','https://woocommerce.com/mobile/?utm_source=inbox','actioned',0,''),(8161,43,'wayflyer_q3_2021','Get funded','https://woocommerce.com/products/wayflyer/','actioned',1,''),(8162,42,'eu_vat_changes_2021','Learn more about the EU tax regulations','https://woocommerce.com/posts/new-eu-vat-regulations','actioned',1,''),(8163,31,'open_wc_paypal_payments_product_page','Learn more','https://woocommerce.com/products/woocommerce-paypal-payments/','actioned',1,''),(8164,21,'upgrade_now_facebook_pixel_api','Upgrade now','plugin-install.php?tab=plugin-information&plugin=&section=changelog','actioned',1,''),(8165,22,'learn_more_facebook_ec','Learn more','https://woocommerce.com/products/facebook/','unactioned',1,''),(8181,34,'learn-more','Learn about Instant Deposits eligibility','https://docs.woocommerce.com/document/payments/instant-deposits/?utm_source=inbox&utm_medium=product&utm_campaign=wcpay_instant_deposits','actioned',1,''),(8197,50,'learn-more','Learn more','https://woocommerce.com/products/bbpos-chipper2xbt-card-reader?utm_source=inbox&utm_medium=product&utm_campaign=bbpos-chipper-launch','unactioned',1,''),(8368,23,'boost-sales-marketing-guide','See marketing guide','https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=square-boost-sales','actioned',1,''),(8369,24,'grow-your-business-marketing-guide','See marketing guide','https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=square-grow-your-business','actioned',1,''),(8370,30,'add-apple-pay','Add Apple Pay','/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments','actioned',1,''),(8371,30,'learn-more','Learn more','https://docs.woocommerce.com/document/payments/apple-pay/?utm_source=inbox&utm_medium=product&utm_campaign=wcpay_applepay','actioned',1,''),(8372,28,'boost-sales-marketing-guide','See marketing guide','https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=wcpay-boost-sales','actioned',1,''),(8373,29,'grow-your-business-marketing-guide','See marketing guide','https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=wcpay-grow-your-business','actioned',1,''),(8628,52,'browse_extensions','Browse extensions','https://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&page=wc-addons','unactioned',1,''),(8629,53,'browse_extensions','Browse extensions','https://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&page=wc-addons','unactioned',1,''),(11358,38,'get-woo-commerce-payments','Get WooCommerce Payments','admin.php?page=wc-admin&action=setup-woocommerce-payments','actioned',1,''),(11359,39,'get-woocommerce-payments','Get WooCommerce Payments','admin.php?page=wc-admin&action=setup-woocommerce-payments','actioned',1,''),(11873,63,'wc_simple_payments_m2_reader_launch_q1_2022','Learn more','https://woocommerce.com/in-person-payments/','actioned',0,''),(11948,55,'stripe_applepay_holiday2021','Accept Apple Pay','https://woocommerce.com/apple-pay/','actioned',1,''),(11949,56,'square_applepay_holiday2021','Accept Apple Pay','https://woocommerce.com/apple-pay/','actioned',1,''),(11950,57,'wcpay_applepay_holiday2021','Accept Apple Pay','https://woocommerce.com/apple-pay/','actioned',1,''),(13065,64,'wcpay_applepay_q1_2022','Let your customers know about Apple Pay','https://developer.apple.com/apple-pay/marketing/','actioned',0,''),(13066,65,'stripe_applepay_q1_2022','Add Apple Pay','http://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&page=wc-settings&tab=checkout&section=stripe','actioned',0,''),(13067,66,'square_applepay_q1_2022','Add Apple Pay','http://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&page=wc-settings&tab=square','actioned',0,''),(14068,67,'lead_gen_existing_customers_1','Yes, please','https://woocommerce.com/take-your-business-to-the-next-level/?utm_source=inbox_note&utm_medium=product&utm_campaign=lead_gen_existing_customers_1','actioned',0,''),(14370,71,'pinterest_gtm_q2_2021','Get started for free','https://woocommerce.com/products/pinterest-for-woocommerce/?utm_source=inbox_note&utm_medium=product&utm_campaign=pinterest_gtm_q2_2021','unactioned',1,''),(14444,73,'woocommerce_payments_subscriptions_nopayments_q2_2022','Start selling subscriptions','https://woocommerce.com/products/woocommerce-payments/?utm_source=inbox_note&utm_medium=product&utm_campaign=woocommerce_payments_subscriptions_nopayments_q2_2022','actioned',0,''),(14445,74,'woocommerce_payments_subscriptions_yespayments_q2_2022','Get started','https://woocommerce.com/document/payments/subscriptions/?utm_source=inbox_note&utm_medium=product&utm_campaign=woocommerce_payments_subscriptions_yespayments_q2_2022#section-2','actioned',0,''),(14750,61,'browse_extensions','Browse extensions','https://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&page=wc-addons','unactioned',1,''),(14751,58,'wayflyer_bnpl_q4_2021','Level up with funding','https://woocommerce.com/products/wayflyer/?utm_source=inbox_note&utm_medium=product&utm_campaign=wayflyer_bnpl_q4_2021','actioned',1,''),(14752,59,'wc_shipping_mobile_app_usps_q4_2021','Get WooCommerce Shipping','https://woocommerce.com/woocommerce-shipping/?utm_source=inbox_note&utm_medium=product&utm_campaign=wc_shipping_mobile_app_usps_q4_2021','actioned',1,''),(14753,60,'wc_shipping_mobile_app_q4_2021','Get the WooCommerce Mobile App','https://woocommerce.com/mobile/?utm_source=inbox_note&utm_medium=product&utm_campaign=wc_shipping_mobile_app_q4_2021','actioned',1,''),(14754,3,'set-up-concierge','Schedule free session','https://wordpress.com/me/concierge','actioned',1,''),(14755,4,'learn-more','Learn more','https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox','unactioned',1,''),(14756,5,'learn-more-ecomm-unique-shopping-experience','Learn more','https://docs.woocommerce.com/document/product-add-ons/?utm_source=inbox','actioned',1,''),(14757,19,'watch-the-webinar','Watch the webinar','https://youtu.be/V_2XtCOyZ7o','actioned',1,''),(14758,18,'learn-more','Learn more','https://woocommerce.com/posts/ecommerce-shipping-solutions-guide/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','actioned',1,''),(14759,25,'optimizing-the-checkout-flow','Learn more','https://woocommerce.com/posts/optimizing-woocommerce-checkout?utm_source=inbox_note&utm_medium=product&utm_campaign=optimizing-the-checkout-flow','actioned',1,''),(14760,26,'learn-more','Learn more','https://woocommerce.com/posts/first-things-customize-woocommerce/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned',1,''),(14761,32,'qualitative-feedback-from-new-users','Share feedback','https://automattic.survey.fm/wc-pay-new','actioned',1,''),(14762,33,'share-feedback','Share feedback','http://automattic.survey.fm/paypal-feedback','unactioned',1,''),(14763,36,'get-started','Get started','https://woocommerce.com/products/google-listings-and-ads?utm_source=inbox_note&utm_medium=product&utm_campaign=get-started','actioned',1,''),(14764,35,'update-wc-subscriptions-3-0-15','View latest version','https://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-admin&page=wc-addons&section=helper','actioned',1,''),(14765,37,'update-wc-core-5-4-0','How to update WooCommerce','https://docs.woocommerce.com/document/how-to-update-woocommerce/','actioned',1,''),(14766,40,'ppxo-pps-install-paypal-payments-1','View upgrade guide','https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/','actioned',1,''),(14767,41,'ppxo-pps-install-paypal-payments-2','View upgrade guide','https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/','actioned',1,''),(14768,44,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned',1,''),(14769,44,'dismiss','Dismiss','','actioned',0,''),(14770,45,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned',1,''),(14771,45,'dismiss','Dismiss','','actioned',0,''),(14772,46,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned',1,''),(14773,46,'dismiss','Dismiss','','actioned',0,''),(14774,47,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned',1,''),(14775,47,'dismiss','Dismiss','','actioned',0,''),(14776,51,'share-feedback','Share feedback','https://automattic.survey.fm/store-management','unactioned',1,''),(14777,62,'share-navigation-survey-feedback','Share feedback','https://automattic.survey.fm/feedback-on-woocommerce-navigation','actioned',1,''),(14778,68,'learn-more','Learn more','https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/','unactioned',1,''),(14779,68,'woocommerce-core-paypal-march-2022-dismiss','Dismiss','','actioned',0,''),(14780,69,'learn-more','Learn more','https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/','unactioned',1,''),(14781,69,'dismiss','Dismiss','','actioned',0,''),(14782,70,'pinterest_03_2022_update','Update Instructions','https://woocommerce.com/document/pinterest-for-woocommerce/?utm_source=inbox_note&utm_medium=product&utm_campaign=pinterest_03_2022_update#section-3','actioned',0,''),(14783,72,'setup_task_initiative_survey_q2_2022_share_your_input','Share your input','https://t.maze.co/87390007','actioned',0,''),(14784,77,'affirm_q2_2022','Get started for free','https://woocommerce.com/products/woocommerce-gateway-affirm/?utm_source=inbox_note&utm_medium=product&utm_campaign=affirm_q2_2022','unactioned',1,''),(14785,75,'setup_task_second_survey_q2_2022_share_your_input','Share your input','https://t.maze.co/87390007','actioned',0,''),(14786,76,'store_setup_survey_survey_q2_2022_share_your_thoughts','Tell us how it’s going','https://automattic.survey.fm/store-setup-survey-2022','actioned',0,''),(14787,78,'wc-admin-EU-consumer-protection','Learn more about these changes','https://ec.europa.eu/info/law/law-topic/consumer-protection-law/review-eu-consumer-law_en#guidance','actioned',1,''),(14788,79,'googlelistings_multicountrygtm_q22022','Get Google Listings & Ads – free','https://woocommerce.com/products/google-listings-and-ads/?utm_source=inbox_note&utm_medium=product&utm_campaign=googlelistings_multicountrygtm_q22022','actioned',1,'');

--
-- Table structure for table `wp_wc_admin_notes`
--

CREATE TABLE `wp_wc_admin_notes` (
  `note_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `locale` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `title` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `content_data` longtext COLLATE utf8mb4_unicode_520_ci,
  `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_reminder` datetime DEFAULT NULL,
  `is_snoozable` tinyint(1) NOT NULL DEFAULT '0',
  `layout` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `image` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `icon` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'info',
  PRIMARY KEY (`note_id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_admin_notes`
--

INSERT INTO `wp_wc_admin_notes` VALUES (1,'wc-admin-onboarding-email-marketing','info','en_US','Tips, product updates, and inspiration','We\'re here for you - get tips, product updates and inspiration straight to your email box','{}','unactioned','woocommerce-admin','2020-11-09 14:48:34',NULL,0,'plain','',0,'info'),(2,'wc-admin-marketing-intro','info','en_US','Connect with your audience','Grow your customer base and increase your sales with marketing tools built for WooCommerce.','{}','unactioned','woocommerce-admin','2020-11-09 14:48:34',NULL,0,'plain','',0,'info'),(3,'ecomm-need-help-setting-up-your-store','info','en_US','Need help setting up your Store?','Schedule a free 30-min <a href=\"https://wordpress.com/support/concierge-support/\">quick start session</a> and get help from our specialists. We’re happy to walk through setup steps, show you around the WordPress.com dashboard, troubleshoot any issues you may have, and help you the find the features you need to accomplish your goals for your site.','{}','pending','woocommerce.com','2020-11-09 14:48:34',NULL,0,'plain','',0,'info'),(4,'woocommerce-services','info','en_US','WooCommerce Shipping & Tax','WooCommerce Shipping &amp; Tax helps get your store \"ready to sell\" as quickly as possible. You create your products. We take care of tax calculation, payment processing, and shipping label printing! Learn more about the extension that you just installed.','{}','pending','woocommerce.com','2020-11-09 14:48:34',NULL,0,'plain','',0,'info'),(5,'ecomm-unique-shopping-experience','info','en_US','For a shopping experience as unique as your customers','Product Add-Ons allow your customers to personalize products while they\'re shopping on your online store. No more follow-up email requests—customers get what they want, before they\'re done checking out. Learn more about this extension that comes included in your plan.','{}','pending','woocommerce.com','2020-11-09 14:48:34',NULL,0,'plain','',0,'info'),(6,'wc-admin-wc-helper-connection','info','en_US','Connect to WooCommerce.com','Connect to get important product notifications and updates.','{}','unactioned','woocommerce-admin','2020-11-09 14:48:34',NULL,0,'plain','',0,'info'),(7,'wc-admin-onboarding-profiler-reminder','update','en_US','Welcome to WooCommerce! Set up your store and start selling','We\'re here to help you going through the most important steps to get your store up and running.','{}','unactioned','woocommerce-admin','2020-11-09 14:48:34',NULL,0,'plain','',0,'info'),(8,'wc-admin-mobile-app','info','en_US','Install Woo mobile app','Install the WooCommerce mobile app to manage orders, receive sales notifications, and view key metrics — wherever you are.','{}','unactioned','woocommerce-admin','2020-11-11 17:08:19',NULL,0,'plain','',0,'info'),(9,'wc-admin-orders-milestone','info','en_US','First order received','Congratulations on getting your first order! Now is a great time to learn how to manage your orders.','{}','unactioned','woocommerce-admin','2020-11-13 11:48:37',NULL,0,'plain','',0,'info'),(10,'wc-admin-usage-tracking-opt-in','info','en_US','Help WooCommerce improve with usage tracking','Gathering usage data allows us to improve WooCommerce. Your store will be considered as we evaluate new features, judge the quality of an update, or determine if an improvement makes sense. You can always visit the <a href=\"http://demoweblinks.in/marlins/wp-admin/admin.php?page=wc-settings&#038;tab=advanced&#038;section=woocommerce_com\" target=\"_blank\">Settings</a> and choose to stop sharing data. <a href=\"https://woocommerce.com/usage-tracking\" target=\"_blank\">Read more</a> about what data we collect.','{}','unactioned','woocommerce-admin','2020-11-16 19:15:03',NULL,0,'plain','',0,'info'),(11,'wc-admin-store-notice-giving-feedback-2','info','en_US','Give feedback','Now that you’ve chosen us as a partner, our goal is to make sure we\'re providing the right tools to meet your needs. We\'re looking forward to having your feedback on the store setup experience so we can improve it in the future.','{}','unactioned','woocommerce-admin','2020-11-17 16:22:35',NULL,0,'plain','',0,'info'),(12,'wc-admin-insight-first-sale','survey','en_US','Did you know?','A WooCommerce powered store needs on average 31 days to get the first sale. You\'re on the right track! Do you find this type of insight useful?','{}','unactioned','woocommerce-admin','2020-11-17 16:22:35',NULL,0,'plain','',0,'info'),(13,'wcpay-promo-2020-11','marketing','en_US','wcpay-promo-2020-11','wcpay-promo-2020-11','{}','pending','woocommerce.com','2020-11-20 23:43:41',NULL,0,'plain','',0,'info'),(14,'wcpay-subscriptions-2020-11','marketing','en_US','Manage subscriber payments from your store\'s dashboard','Securely accept cards and manage transactions right from your dashboard with <a href=\"https://woocommerce.com/payments/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay_ctrl20\" target=\"_blank\">WooCommerce Payments</a>  – now supporting <a href=\"https://woocommerce.com/products/woocommerce-subscriptions/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay_ctrl20\" target=\"_blank\">WooCommerce Subscriptions</a>! <br /><br /><em>By clicking \"Install now,\" you agree to our <a href=\"https://wordpress.com/tos/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay_ctrl20\" target=\"_blank\">Terms of Service</a>.</em>','{}','pending','woocommerce.com','2020-11-20 23:43:41',NULL,0,'plain','',0,'info'),(15,'wc-admin-home-screen-feedback','info','en_US','Help us improve the WooCommerce Home screen','We\'d love your input to shape the future of the WooCommerce Home screen together. Feel free to share any feedback, ideas or suggestions that you have.','{}','unactioned','woocommerce-admin','2020-11-23 03:45:09',NULL,0,'plain','',0,'info'),(16,'wcpay-promo-2020-12','marketing','en_US','wcpay-promo-2020-12','wcpay-promo-2020-12','{}','pending','woocommerce.com','2020-12-10 19:13:46',NULL,0,'plain','',0,'info'),(17,'wcpay-subscriptions-2020-12','marketing','en_US','Manage payments from your store\'s dashboard','Securely accept cards and manage transactions right from your dashboard with <a href=\"https://woocommerce.com/payments/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay_ctrl20\" target=\"_blank\">WooCommerce Payments</a>! Zero setup fees or monthly fees. Just pay-as-you-go, starting at just 2.9% + $0.30 per transaction for U.S.-issued cards. <br /><br /><em>By clicking \"Install now,\" you agree to our <a href=\"https://wordpress.com/tos/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay_ctrl20\" target=\"_blank\">Terms of Service</a>.</em>','{}','pending','woocommerce.com','2020-12-10 19:13:46',NULL,0,'plain','',0,'info'),(18,'your-first-product','info','en_US','Your first product','That’s huge! You’re well on your way to building a successful online store — now it’s time to think about how you’ll fulfill your orders.<br /><br />Read our shipping guide to learn best practices and options for putting together your shipping strategy. And for WooCommerce stores in the United States, you can print discounted shipping labels via USPS with <a href=\"https://href.li/?https://woocommerce.com/shipping\" target=\"_blank\">WooCommerce Shipping</a>.','{}','pending','woocommerce.com','2021-01-21 21:09:18',NULL,0,'plain','',0,'info'),(19,'wc-admin-getting-started-in-ecommerce','info','en_US','Getting Started in eCommerce - webinar','We want to make eCommerce and this process of getting started as easy as possible for you. Watch this webinar to get tips on how to have our store up and running in a breeze.','{}','pending','woocommerce.com','2021-01-27 22:27:07',NULL,0,'plain','',0,'info'),(20,'wc-admin-real-time-order-alerts','info','en_US','Get real-time order alerts anywhere','Get notifications about store activity, including new orders and product reviews directly on your mobile devices with the Woo app.','{}','unactioned','woocommerce-admin','2021-02-07 15:37:49',NULL,0,'plain','',0,'info'),(21,'facebook_pixel_api_2021','marketing','en_US','Improve the performance of your Facebook ads','Enable Facebook Pixel and Conversions API through the latest version of Facebook for WooCommerce for improved measurement and ad targeting capabilities.','{}','pending','woocommerce.com','2021-02-12 18:01:01',NULL,0,'plain','',0,'info'),(22,'facebook_ec_2021','marketing','en_US','Sync your product catalog with Facebook to help boost sales','A single click adds all products to your Facebook Business Page shop. Product changes are automatically synced, with the flexibility to control which products are listed.','{}','pending','woocommerce.com','2021-02-12 18:01:01',NULL,0,'plain','',0,'info'),(23,'wc-square-apple-pay-boost-sales','marketing','en_US','Boost sales with Apple Pay','Now that you accept Apple Pay® with Square you can increase conversion rates by letting your customers know that Apple Pay® is available. Here’s a marketing guide to help you get started.','{}','pending','woocommerce.com','2021-02-12 18:01:01',NULL,0,'plain','',0,'info'),(24,'wc-square-apple-pay-grow-your-business','marketing','en_US','Grow your business with Square and Apple Pay ','Now more than ever, shoppers want a fast, simple, and secure online checkout experience. Increase conversion rates by letting your customers know that you now accept Apple Pay®.','{}','pending','woocommerce.com','2021-02-12 18:01:01',NULL,0,'plain','',0,'info'),(25,'wc-admin-optimizing-the-checkout-flow','info','en_US','Optimizing the checkout flow','It’s crucial to get your store’s checkout as smooth as possible to avoid losing sales. Let’s take a look at how you can optimize the checkout experience for your shoppers.','{}','pending','woocommerce.com','2021-02-17 14:57:44',NULL,0,'plain','',0,'info'),(26,'wc-admin-first-five-things-to-customize','info','en_US','The first 5 things to customize in your store','Deciding what to start with first is tricky. To help you properly prioritize, we’ve put together this short list of the first few things you should customize in WooCommerce.','{}','pending','woocommerce.com','2021-02-17 14:57:44',NULL,0,'plain','',0,'info'),(27,'wc-admin-effortless-payments-by-mollie','info','en_US','Effortless payments by Mollie','Offer global and local payment methods, get onboarded in minutes and supported in your language – try it now!','{}','pending','woocommerce.com','2021-02-20 14:48:39',NULL,0,'plain','',0,'info'),(28,'wcpay-apple-pay-boost-sales','marketing','en_US','Boost sales with Apple Pay','Now that you accept Apple Pay® with WooCommerce Payments you can increase conversion rates by letting your customers know that Apple Pay® is available. Here’s a marketing guide to help you get started.','{}','pending','woocommerce.com','2021-03-20 16:47:56',NULL,0,'plain','',0,'info'),(29,'wcpay-apple-pay-grow-your-business','marketing','en_US','Grow your business with WooCommerce Payments and Apple Pay','Now more than ever, shoppers want a fast, simple, and secure online checkout experience. Increase conversion rates by letting your customers know that you now accept Apple Pay®.','{}','pending','woocommerce.com','2021-03-20 16:47:56',NULL,0,'plain','',0,'info'),(30,'wcpay-apple-pay-is-now-available','marketing','en_US','Apple Pay is now available with WooCommerce Payments!','Increase your conversion rate by offering a fast and secure checkout with <a href=\"https://woocommerce.com/apple-pay/?utm_source=inbox&amp;utm_medium=product&amp;utm_campaign=wcpay_applepay\" target=\"_blank\">Apple Pay</a>®. It’s free to get started with <a href=\"https://woocommerce.com/payments/?utm_source=inbox&amp;utm_medium=product&amp;utm_campaign=wcpay_applepay\" target=\"_blank\">WooCommerce Payments</a>.','{}','pending','woocommerce.com','2021-03-30 19:14:05',NULL,0,'plain','',0,'info'),(31,'paypal_ppcp_gtm_2021','marketing','en_US','Offer more options with the new PayPal','Get the latest PayPal extension for a full suite of payment methods with extensive currency and country coverage.','{}','pending','woocommerce.com','2021-04-01 15:59:03',NULL,0,'plain','',0,'info'),(32,'wc-payments-qualitative-feedback','info','en_US','WooCommerce Payments setup - let us know what you think','Congrats on enabling WooCommerce Payments for your store. Please share your feedback in this 2 minute survey to help us improve the setup process.','{}','pending','woocommerce.com','2021-04-16 17:53:07',NULL,0,'plain','',0,'info'),(33,'share-your-feedback-on-paypal','info','en_US','Share your feedback on PayPal','Share your feedback in this 2 minute survey about how we can make the process of accepting payments more useful for your store.','{}','pending','woocommerce.com','2021-05-14 15:49:14',NULL,0,'plain','',0,'info'),(34,'wcpay_instant_deposits_gtm_2021','marketing','en_US','Get paid within minutes – Instant Deposits for WooCommerce Payments','Stay flexible with immediate access to your funds when you need them – including nights, weekends, and holidays. With <a href=\"https://woocommerce.com/products/woocommerce-payments/?utm_source=inbox&amp;utm_medium=product&amp;utm_campaign=wcpay_instant_deposits\">WooCommerce Payments\'</a> new Instant Deposits feature, you’re able to transfer your earnings to a debit card within minutes.','{}','pending','woocommerce.com','2021-05-14 15:49:14',NULL,0,'plain','',0,'info'),(35,'wc-subscriptions-security-update-3-0-15','info','en_US','WooCommerce Subscriptions security update!','We recently released an important security update to WooCommerce Subscriptions. To ensure your site’s data is protected, please upgrade <strong>WooCommerce Subscriptions to version 3.0.15</strong> or later.<br /><br />Click the button below to view and update to the latest Subscriptions version, or log in to <a href=\"https://woocommerce.com/my-dashboard\">WooCommerce.com Dashboard</a> and navigate to your <strong>Downloads</strong> page.<br /><br />We recommend always using the latest version of WooCommerce Subscriptions, and other software running on your site, to ensure maximum security.<br /><br />If you have any questions we are here to help — just <a href=\"https://woocommerce.com/my-account/create-a-ticket/\">open a ticket</a>.','{}','pending','woocommerce.com','2021-05-31 19:27:56',NULL,0,'plain','',0,'info'),(36,'google_listings_and_ads_install','marketing','en_US','Drive traffic and sales with Google','Reach online shoppers to drive traffic and sales for your store by showcasing products across Google, for free or with ads.','{}','pending','woocommerce.com','2021-06-07 18:45:46',NULL,0,'plain','',0,'info'),(37,'woocommerce-core-update-5-4-0','info','en_US','Update to WooCommerce 5.4.1 now','WooCommerce 5.4.1 addresses a checkout issue discovered in WooCommerce 5.4. We recommend upgrading to WooCommerce 5.4.1 as soon as possible.','{}','pending','woocommerce.com','2021-06-10 17:48:14',NULL,0,'plain','',0,'info'),(38,'wcpay-promo-2021-6-incentive-1','marketing','en_US','Simplify the payments process for you and your customers with WooCommerce Payments','With <a href=\"https://woocommerce.com/payments/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay601\">WooCommerce Payments</a>, you can securely accept all major cards, Apple Pay®, and recurring revenue in over 100 currencies.\n				Built into your store’s WooCommerce dashboard, track cash flow and manage all of your transactions in one place – with no setup costs or monthly fees.\n				<br /><br />\n				By clicking \"Get WooCommerce Payments,\" you agree to the <a href=\"https://wordpress.com/tos/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay601\">Terms of Service</a>\n				and acknowledge you have read the <a href=\"https://automattic.com/privacy/\">Privacy Policy</a>.\n				','{}','pending','woocommerce.com','2021-06-13 14:51:45',NULL,0,'plain','',0,'info'),(39,'wcpay-promo-2021-6-incentive-2','marketing','en_US','Simplify the payments process for you and your customers with WooCommerce Payments','With <a href=\"https://woocommerce.com/payments/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay601\">WooCommerce Payments</a>, you can securely accept all major cards, Apple Pay®, and recurring revenue in over 100 currencies.\n				Built into your store’s WooCommerce dashboard, track cash flow and manage all of your transactions in one place – with no setup costs or monthly fees.\n				<br /><br />\n				By clicking \"Get WooCommerce Payments,\" you agree to the <a href=\"https://wordpress.com/tos/?utm_medium=notification&amp;utm_source=product&amp;utm_campaign=wcpay601\">Terms of Service</a>\n				and acknowledge you have read the <a href=\"https://automattic.com/privacy/\">Privacy Policy</a>.\n				','{}','pending','woocommerce.com','2021-06-13 14:51:45',NULL,0,'plain','',0,'info'),(40,'ppxo-pps-upgrade-paypal-payments-1','info','en_US','Get the latest PayPal extension for WooCommerce','Heads up! There’s a new PayPal on the block!<br /><br />Now is a great time to upgrade to our latest <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">PayPal extension</a> to continue to receive support and updates with PayPal.<br /><br />Get access to a full suite of PayPal payment methods, extensive currency and country coverage, and pay later options with the all-new PayPal extension for WooCommerce.','{}','pending','woocommerce.com','2021-06-22 16:34:29',NULL,0,'plain','',0,'info'),(41,'ppxo-pps-upgrade-paypal-payments-2','info','en_US','Upgrade your PayPal experience!','Get access to a full suite of PayPal payment methods, extensive currency and country coverage, offer subscription and recurring payments, and the new PayPal pay later options.<br /><br />Start using our <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">latest PayPal today</a> to continue to receive support and updates.','{}','pending','woocommerce.com','2021-06-22 16:34:29',NULL,0,'plain','',0,'info'),(42,'eu_vat_changes_2021','marketing','en_US','Get your business ready for the new EU tax regulations','On July 1, 2021, new taxation rules will come into play when the <a href=\"https://ec.europa.eu/taxation_customs/business/vat/modernising-vat-cross-border-ecommerce_en\">European Union (EU) Value-Added Tax (VAT) eCommerce package</a> takes effect.<br /><br />The new regulations will impact virtually every B2C business involved in cross-border eCommerce trade with the EU.<br /><br />We therefore recommend <a href=\"https://woocommerce.com/posts/new-eu-vat-regulations\">familiarizing yourself with the new updates</a>, and consult with a tax professional to ensure your business is following regulations and best practice.','{}','pending','woocommerce.com','2021-06-23 16:44:41',NULL,0,'plain','',0,'info'),(43,'wayflyer_q3_2021','marketing','en_US','Grow your revenue with Wayflyer financing and analytics','Flexible financing tailored to your needs by <a href=\"https://woocommerce.com/products/wayflyer/\">Wayflyer</a> – one fee, no interest rates, penalties, equity, or personal guarantees. Based on your store\'s performance, Wayflyer can provide the financing you need to grow and the analytical insights to help you spend it.','{}','pending','woocommerce.com','2021-07-16 11:12:22',NULL,0,'plain','',0,'info'),(44,'woocommerce-core-sqli-july-2021-need-to-update','update','en_US','Action required: Critical vulnerabilities in WooCommerce','In response to a critical vulnerability identified on July 13, 2021, we are working with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br />Our investigation into this vulnerability is ongoing, but <strong>we wanted to let you know now about the importance of updating immediately</strong>.<br /><br />For more information on which actions you should take, as well as answers to FAQs, please urgently review our blog post detailing this issue.','{}','pending','woocommerce.com','2021-07-16 11:12:22',NULL,0,'plain','',0,'info'),(45,'woocommerce-blocks-sqli-july-2021-need-to-update','update','en_US','Action required: Critical vulnerabilities in WooCommerce Blocks','In response to a critical vulnerability identified on July 13, 2021, we are working with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br />Our investigation into this vulnerability is ongoing, but <strong>we wanted to let you know now about the importance of updating immediately</strong>.<br /><br />For more information on which actions you should take, as well as answers to FAQs, please urgently review our blog post detailing this issue.','{}','pending','woocommerce.com','2021-07-16 11:12:22',NULL,0,'plain','',0,'info'),(46,'woocommerce-core-sqli-july-2021-store-patched','update','en_US','Solved: Critical vulnerabilities patched in WooCommerce','In response to a critical vulnerability identified on July 13, 2021, we worked with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br /><strong>Your store has been updated to the latest secure version(s)</strong>. For more information and answers to FAQs, please review our blog post detailing this issue.','{}','unactioned','woocommerce.com','2021-07-16 11:12:22',NULL,0,'plain','',0,'info'),(47,'woocommerce-blocks-sqli-july-2021-store-patched','update','en_US','Solved: Critical vulnerabilities patched in WooCommerce Blocks','In response to a critical vulnerability identified on July 13, 2021, we worked with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br /><strong>Your store has been updated to the latest secure version(s)</strong>. For more information and answers to FAQs, please review our blog post detailing this issue.','{}','pending','woocommerce.com','2021-07-16 11:12:22',NULL,0,'plain','',0,'info'),(48,'wc-admin-performance-on-mobile','info','en_US','Track your store performance on mobile','Monitor your sales and high performing products with the Woo app.','{}','unactioned','woocommerce-admin','2021-08-06 20:36:53',NULL,0,'plain','',0,'info'),(49,'mercadopago_q3_2021_EN','marketing','en_US','Get paid with Mercado Pago Checkout','Latin America\'s leading payment processor is now available for WooCommerce stores. Securely accept debit and credit cards, cash, bank transfers, and installment payments – backed by exclusive fraud prevention tools.','{}','pending','woocommerce.com','2021-08-31 15:28:10',NULL,0,'plain','',0,'info'),(50,'bbpos-chipper-launch','marketing','en_US','Ready to grow your business beyond online?','Collect payment in person for orders placed online using WooCommerce In-Person Payments. The BBPOS Chipper card reader can process payments securely, and keep everything synced in your WooCommerce Payments dashboard – no matter where you are.','{}','pending','woocommerce.com','2021-10-15 18:44:11',NULL,0,'plain','',0,'info'),(51,'habit-moment-survey','marketing','en_US','We’re all ears! Share your experience so far with WooCommerce','We’d love your input to shape the future of WooCommerce together. Feel free to share any feedback, ideas or suggestions that you have.','{}','pending','woocommerce.com','2021-11-05 01:27:02',NULL,0,'plain','',0,'info'),(52,'new_in_app_marketplace_2021_1','info','en_US','Grow your business with extensions','Check out our NEW Extensions tab to see our favorite extensions for growing your business, and discover the most popular extensions in the WooCommerce Marketplace.','{}','pending','woocommerce.com','2021-11-08 22:58:53',NULL,0,'plain','',0,'info'),(53,'new_in_app_marketplace_2021_2','info','en_US','Customize your store with extensions','Check out our NEW Extensions tab to see our favorite extensions for customizing your store, and discover the most popular extensions in the WooCommerce Marketplace.','{}','pending','woocommerce.com','2021-11-08 22:58:53',NULL,0,'plain','',0,'info'),(54,'wc-admin-edit-products-on-the-move','info','en_US','Edit products on the move','Edit and create new products from your mobile devices with the Woo app','{}','unactioned','woocommerce-admin','2021-11-09 21:06:20',NULL,0,'plain','',0,'info'),(55,'stripe_applepay_holiday2021','marketing','en_US','Boost sales this holiday season with Apple Pay!','Increase your conversion rate by letting your customers know that you accept Apple Pay. It’s seamless to <a href=\"https://docs.woocommerce.com/document/stripe/?_ga=2.90941597.642705274.1635776464-1391993999.1621950839#apple-pay\">enable Apple Pay with Stripe</a> and easy to communicate it with this <a href=\"https://developer.apple.com/apple-pay/marketing/\">marketing guide</a>.','{}','pending','woocommerce.com','2021-11-12 00:10:17',NULL,0,'plain','',0,'info'),(56,'square_applepay_holiday2021','marketing','en_US','Boost sales this holiday season with Apple Pay!','Increase your conversion rate by letting your customers know that you accept Apple Pay. It’s seamless to <a href=\"https://docs.woocommerce.com/document/woocommerce-square/?_ga=2.90941597.642705274.1635776464-1391993999.1621950839#section-14\">enable Apple Pay with Square</a> and easy to communicate it with this <a href=\"https://developer.apple.com/apple-pay/marketing/\">marketing guide</a>.','{}','pending','woocommerce.com','2021-11-12 00:10:17',NULL,0,'plain','',0,'info'),(57,'wcpay_applepay_holiday2021','marketing','en_US','Boost sales this holiday season with Apple Pay!','Increase your conversion rate by letting your customers know that you accept Apple Pay. It’s seamless to <a href=\"https://docs.woocommerce.com/document/payments/apple-pay/\">enable Apple Pay with WooCommerce Payments</a> and easy to communicate it with this <a href=\"https://developer.apple.com/apple-pay/marketing/\">marketing guide</a>.','{}','pending','woocommerce.com','2021-11-12 00:10:17',NULL,0,'plain','',0,'info'),(58,'wayflyer_bnpl_q4_2021','marketing','en_US','Grow your business with funding through Wayflyer','Fast, flexible financing to boost cash flow and help your business grow – one fee, no interest rates, penalties, equity, or personal guarantees. Based on your store’s performance, Wayflyer provides funding and analytical insights to invest in your business.','{}','pending','woocommerce.com','2021-11-12 00:10:17',NULL,0,'plain','',0,'info'),(59,'wc_shipping_mobile_app_usps_q4_2021','marketing','en_US','Print and manage your shipping labels with WooCommerce Shipping and the WooCommerce Mobile App','Save time by printing, purchasing, refunding, and tracking shipping labels generated by <a href=\"https://woocommerce.com/woocommerce-shipping/\">WooCommerce Shipping</a> – all directly from your mobile device!','{}','pending','woocommerce.com','2021-11-12 00:10:17',NULL,0,'plain','',0,'info'),(60,'wc_shipping_mobile_app_q4_2021','marketing','en_US','Print and manage your shipping labels with the WooCommerce Mobile App','Save time by printing, purchasing, refunding, and tracking shipping labels generated by <a href=\"https://woocommerce.com/woocommerce-shipping/\">WooCommerce Shipping</a> – all directly from your mobile device!','{}','pending','woocommerce.com','2021-11-12 00:10:17',NULL,0,'plain','',0,'info'),(61,'new_in_app_marketplace_2021','info','en_US','Customize your store with extensions','Check out our NEW Extensions tab to see our favorite extensions for customizing your store, and discover the most popular extensions in the WooCommerce Marketplace.','{}','pending','woocommerce.com','2021-11-23 16:50:16',NULL,0,'plain','',0,'info'),(62,'ecomm-wc-navigation-survey','info','en_US','We’d like your feedback on the WooCommerce navigation','We’re making improvements to the WooCommerce navigation and would love your feedback. Share your experience in this 2 minute survey.','{}','pending','woocommerce.com','2022-01-05 18:18:04',NULL,0,'plain','',0,'info'),(63,'wc_simple_payments_m2_reader_launch_q1_2022','marketing','en_US','Take quick and easy in-person payments','WooCommerce is continuing to power up your business with our new Simple Payments feature, built exclusively for WooCommerce In-Person Payments. Capture quick and simple payments anywhere else your customers are – or offer a local pickup option with payment taken in-person for orders placed online.','{}','pending','woocommerce.com','2022-02-05 07:59:49',NULL,0,'plain','',0,'info'),(64,'wcpay_applepay_q1_2022','marketing','en_US','Increase conversions with Apple Pay – just like Diane does','See how Diane from <a href=\"https://woocommerce.com/posts/lady-dye-yarns-from-crafts-to-activism-with-woocommerce/?utm_source=product&amp;utm_medium=inboxnotification&amp;utm_campaign=apple-pay\" target=\"_blank\">Lady Dye Yarns</a> uses Apple Pay to provide customers with the fast, secure checkout experience they love. You can, too – Apple Pay is included in WooCommerce Payments. Here\'s how you can increase conversions by encouraging shoppers to pay with a single tap.','{}','pending','woocommerce.com','2022-02-07 18:52:32',NULL,0,'plain','',0,'info'),(65,'stripe_applepay_q1_2022','marketing','en_US','Increase conversions with Apple Pay – just like Thomas does','Read the inspirational story of <a href=\"https://woocommerce.com/posts/incredible-story-of-thomas-trendy-socks-down-syndrome-entrepreneur/?utm_source=product&amp;utm_medium=inboxnotification&amp;utm_campaign=apple-pay\" target=\"_blank\">Thomas\'s Trendy Socks</a> and see how he’s using Apple Pay to provide customers with the fast, secure checkout experience they love. You can, too – ready to turn more visitors into buyers? Accept Apple Pay by selecting Enable express checkouts in Settings &gt; Payments &gt; Stripe.','{}','pending','woocommerce.com','2022-02-07 18:52:32',NULL,0,'plain','',0,'info'),(66,'square_applepay_q1_2022','marketing','en_US','Increase conversions with a faster checkout experience','By enabling Apple Pay in Square, your customers can complete purchases quickly and securely with a single touch or a glance – no lengthy checkout forms necessary. Accept Apple Pay by enabling Digital Wallets within Settings &gt; Payments &gt; Square.','{}','pending','woocommerce.com','2022-02-07 18:52:32',NULL,0,'plain','',0,'info'),(67,'lead_gen_existing_customers_1','marketing','en_US','Talk to a consultant','As your business grows, you want to optimize costs, streamline operations, and sell more. We can help. Talk to us about how you can get the most out of WooCommerce.','{}','pending','woocommerce.com','2022-02-11 17:42:07',NULL,0,'plain','',0,'info'),(68,'woocommerce-core-paypal-march-2022-updated','update','en_US','Security auto-update of WooCommerce','<strong>Your store has been updated to the latest secure version of WooCommerce</strong>. We worked with WordPress to deploy PayPal Standard security updates for stores running WooCommerce (version 3.5 to 6.3). It’s recommended to disable PayPal Standard, and use <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">PayPal Payments</a> to accept PayPal.','{}','unactioned','woocommerce.com','2022-03-10 19:00:58',NULL,0,'plain','',0,'info'),(69,'woocommerce-core-paypal-march-2022-updated-nopp','update','en_US','Security auto-update of WooCommerce','<strong>Your store has been updated to the latest secure version of WooCommerce</strong>. We worked with WordPress to deploy security updates related to PayPal Standard payment gateway for stores running WooCommerce (version 3.5 to 6.3).','{}','pending','woocommerce.com','2022-03-10 19:00:58',NULL,0,'plain','',0,'info'),(70,'pinterest_03_2022_update','marketing','en_US','Your Pinterest for WooCommerce plugin is out of date!','Update to the latest version of Pinterest for WooCommerce to continue using this plugin and keep your store connected with Pinterest. To update, visit <strong>Plugins &gt; Installed Plugins</strong>, and click on “update now” under Pinterest for WooCommerce.','{}','pending','woocommerce.com','2022-03-23 21:45:53',NULL,0,'plain','',0,'info'),(71,'pinterest_gtm_q2_2021','marketing','en_US','Get your products in front of a large, engaged audience','Did you know that shoppers on Pinterest spend twice as much as people on other social platforms? With the new, official Pinterest for WooCommerce, you can turn your product catalog into shoppable Pins and showcase them to 400+ million monthly users looking to buy.','{}','unactioned','woocommerce.com','2022-04-24 20:10:36',NULL,0,'plain','',0,'info'),(72,'setup_task_initiative_survey_q2_2022','survey','en_US','We want to know what matters most to you','Take 2 minutes to give us your input on what is important for you while setting up your store and help shape the future of WooCommerce together.','{}','pending','woocommerce.com','2022-04-26 18:44:24',NULL,0,'plain','',0,'info'),(73,'woocommerce_payments_subscriptions_nopayments_q2_2022','marketing','en_US','Sell subscriptions online – without a paid extension','Say hello to WooCommerce Payments – now with built-in subscriptions functionality. Get free access to the features you need to start earning recurring revenue online. Pay as you go, with no setup costs or monthly fees.','{}','pending','woocommerce.com','2022-04-26 18:44:24',NULL,0,'plain','',0,'info'),(74,'woocommerce_payments_subscriptions_yespayments_q2_2022','marketing','en_US','Sell subscriptions online – no extra extension required','It\'s here! WooCommerce Payments now features built-in subscriptions functionality. No need to install an extra, paid extension – we\'ve made it simpler than ever to start earning recurring revenue. Ready to grow your business?','{}','pending','woocommerce.com','2022-04-26 18:44:24',NULL,0,'plain','',0,'info'),(75,'setup_task_second_survey_q2_2022','survey','en_US','We want to know what matters most to you','Take 2 minutes to give us your input on what is important for you while setting up your store and help shape the future of WooCommerce together.','{}','pending','woocommerce.com','2022-05-10 12:35:12',NULL,0,'plain','',0,'info'),(76,'store_setup_survey_survey_q2_2022','survey','en_US','How is your store setup going?','Our goal is to make sure you have all the right tools to start setting up your store in the smoothest way possible.\r\nWe’d love to know if we hit our mark and how we can improve. To collect your thoughts, we made a 2-minute survey.','{}','pending','woocommerce.com','2022-05-10 12:35:12',NULL,0,'plain','',0,'info'),(77,'affirm_q2_2022','marketing','en_US','Boost your business with flexible payments','Expand your customer base with smarter payment options for more shoppers. With Affirm,  you can offer the most relevant payment options at every price point – from four interest-free payments every two weeks to longer installments up to 36 months. Fast-track your revenue goals today!','{}','pending','woocommerce.com','2022-05-15 02:04:51',NULL,0,'plain','',0,'info'),(78,'wc-admin-EU-consumer-protection','marketing','en_US','Important changes to EU consumer protection laws','New regulations to help modernize and strengthen consumer protection laws in the European Union (EU) take effect on May 28, 2022. These rules impact all merchants selling to the EU, regardless of where their business is located. Further detailed information is available on the European Commission\'s official website.','{}','unactioned','woocommerce.com','2022-05-15 02:04:51',NULL,0,'plain','',0,'info'),(79,'googlelistings_multicountrygtm_q22022','marketing','en_US','Expand your audience with Multi-Country Advertising','It\'s time to expand your audience with Multi-Country Advertising, an exciting new feature in Google Listings &amp; Ads. Reach more potential customers in as many regions as you like within a single campaign, all from the convenience of your WooCommerce dashboard.','{}','unactioned','woocommerce.com','2022-05-16 15:41:20',NULL,0,'plain','',0,'info');

--
-- Table structure for table `wp_wc_category_lookup`
--

CREATE TABLE `wp_wc_category_lookup` (
  `category_tree_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`category_tree_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_category_lookup`
--

INSERT INTO `wp_wc_category_lookup` VALUES (15,15),(81,81),(83,83),(84,84),(85,85),(86,86),(87,87),(88,88),(89,89),(90,90),(91,91),(92,92),(93,93);

--
-- Table structure for table `wp_wc_customer_lookup`
--

CREATE TABLE `wp_wc_customer_lookup` (
  `customer_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `username` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `first_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `date_last_active` timestamp NULL DEFAULT NULL,
  `date_registered` timestamp NULL DEFAULT NULL,
  `country` char(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `postcode` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `city` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `state` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`customer_id`),
  UNIQUE KEY `user_id` (`user_id`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_customer_lookup`
--

INSERT INTO `wp_wc_customer_lookup` VALUES (1,1,'Marlins','sonu','s','joaijo93@gmail.com','2021-08-23 00:00:00','2020-11-09 14:43:33','IN','68316','kochi','KL');

--
-- Table structure for table `wp_wc_download_log`
--

CREATE TABLE `wp_wc_download_log` (
  `download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  PRIMARY KEY (`download_log_id`),
  KEY `permission_id` (`permission_id`),
  KEY `timestamp` (`timestamp`),
  CONSTRAINT `fk_wp_wc_download_log_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `wp_woocommerce_downloadable_product_permissions` (`permission_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_download_log`
--


--
-- Table structure for table `wp_wc_order_coupon_lookup`
--

CREATE TABLE `wp_wc_order_coupon_lookup` (
  `order_id` bigint(20) unsigned NOT NULL,
  `coupon_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `discount_amount` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`order_id`,`coupon_id`),
  KEY `coupon_id` (`coupon_id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_coupon_lookup`
--


--
-- Table structure for table `wp_wc_order_product_lookup`
--

CREATE TABLE `wp_wc_order_product_lookup` (
  `order_item_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `variation_id` bigint(20) unsigned NOT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_qty` int(11) NOT NULL,
  `product_net_revenue` double NOT NULL DEFAULT '0',
  `product_gross_revenue` double NOT NULL DEFAULT '0',
  `coupon_amount` double NOT NULL DEFAULT '0',
  `tax_amount` double NOT NULL DEFAULT '0',
  `shipping_amount` double NOT NULL DEFAULT '0',
  `shipping_tax_amount` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`),
  KEY `product_id` (`product_id`),
  KEY `customer_id` (`customer_id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_product_lookup`
--

INSERT INTO `wp_wc_order_product_lookup` VALUES (1,286,284,0,1,'2020-11-13 11:17:51',1,1999,1999,0,0,0,0),(2,287,284,0,1,'2020-11-13 11:17:51',1,1999,1999,0,0,0,0);

--
-- Table structure for table `wp_wc_order_stats`
--

CREATE TABLE `wp_wc_order_stats` (
  `order_id` bigint(20) unsigned NOT NULL,
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `num_items_sold` int(11) NOT NULL DEFAULT '0',
  `total_sales` double NOT NULL DEFAULT '0',
  `tax_total` double NOT NULL DEFAULT '0',
  `shipping_total` double NOT NULL DEFAULT '0',
  `net_total` double NOT NULL DEFAULT '0',
  `returning_customer` tinyint(1) DEFAULT NULL,
  `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `customer_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`order_id`),
  KEY `date_created` (`date_created`),
  KEY `customer_id` (`customer_id`),
  KEY `status` (`status`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_stats`
--

INSERT INTO `wp_wc_order_stats` VALUES (286,0,'2020-11-13 11:17:51','2020-11-13 11:17:51',1,1999,0,0,1999,0,'wc-processing',1);

--
-- Table structure for table `wp_wc_order_tax_lookup`
--

CREATE TABLE `wp_wc_order_tax_lookup` (
  `order_id` bigint(20) unsigned NOT NULL,
  `tax_rate_id` bigint(20) unsigned NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `shipping_tax` double NOT NULL DEFAULT '0',
  `order_tax` double NOT NULL DEFAULT '0',
  `total_tax` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`order_id`,`tax_rate_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_tax_lookup`
--


--
-- Table structure for table `wp_wc_product_meta_lookup`
--

CREATE TABLE `wp_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  `virtual` tinyint(1) DEFAULT '0',
  `downloadable` tinyint(1) DEFAULT '0',
  `min_price` decimal(19,4) DEFAULT NULL,
  `max_price` decimal(19,4) DEFAULT NULL,
  `onsale` tinyint(1) DEFAULT '0',
  `stock_quantity` double DEFAULT NULL,
  `stock_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'instock',
  `rating_count` bigint(20) DEFAULT '0',
  `average_rating` decimal(3,2) DEFAULT '0.00',
  `total_sales` bigint(20) DEFAULT '0',
  `tax_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'taxable',
  `tax_class` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  PRIMARY KEY (`product_id`),
  KEY `virtual` (`virtual`),
  KEY `downloadable` (`downloadable`),
  KEY `stock_status` (`stock_status`),
  KEY `stock_quantity` (`stock_quantity`),
  KEY `onsale` (`onsale`),
  KEY `min_max_price` (`min_price`,`max_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_product_meta_lookup`
--

INSERT INTO `wp_wc_product_meta_lookup` VALUES (166,'',0,0,1599.0000,1599.0000,1,NULL,'instock',4,4.00,156,'',''),(167,'',0,0,17500.0000,17500.0000,0,NULL,'outofstock',3,4.33,402337,'',''),(168,'',0,0,1200.0000,1200.0000,1,NULL,'instock',0,0.00,127,'',''),(169,'',0,0,1500.0000,1500.0000,1,NULL,'instock',2,3.50,125,'',''),(170,'',0,0,29.0000,29.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(171,'',0,0,3100.0000,3100.0000,1,NULL,'instock',2,3.00,75,'',''),(172,'',0,0,2999.0000,2999.0000,0,NULL,'instock',3,3.67,32,'taxable',''),(173,'',0,0,29.0000,29.0000,0,0,'outofstock',2,4.00,266,'',''),(174,'',0,0,46800.0000,46800.0000,1,NULL,'instock',2,3.50,2928,'',''),(175,'00012',0,0,26500.0000,26500.0000,1,NULL,'instock',3,4.00,1312,'',''),(176,'',0,0,2876.0000,2876.0000,1,NULL,'instock',2,4.50,100,'',''),(177,'',0,0,1233.0000,1233.0000,1,NULL,'instock',0,0.00,54,'',''),(178,'',0,0,32500.0000,32500.0000,1,NULL,'instock',0,0.00,35634,'',''),(179,'',0,0,39999.0000,39999.0000,1,NULL,'instock',1,5.00,63,'',''),(284,'',0,0,1999.0000,1999.0000,1,NULL,'instock',0,0.00,2,'taxable',''),(486,'',0,0,2100.0000,2100.0000,1,NULL,'instock',0,0.00,0,'taxable',''),(489,'',0,0,8000.0000,8000.0000,1,NULL,'instock',0,0.00,0,'taxable',''),(494,'',0,0,29500.0000,29500.0000,1,NULL,'instock',0,0.00,0,'taxable',''),(498,'',0,0,2500.0000,2500.0000,1,NULL,'instock',0,0.00,0,'taxable',''),(501,'',0,0,3200.0000,3200.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(504,'',0,0,1900.0000,1900.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(508,'',0,0,1300.0000,1300.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(511,'',0,0,5500.0000,5500.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(514,'',0,0,5650.0000,5650.0000,1,NULL,'instock',0,0.00,0,'taxable',''),(518,'',0,0,4600.0000,4600.0000,0,NULL,'instock',0,0.00,0,'taxable','');

--
-- Table structure for table `wp_wc_reserved_stock`
--

CREATE TABLE `wp_wc_reserved_stock` (
  `order_id` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `stock_quantity` double NOT NULL DEFAULT '0',
  `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_reserved_stock`
--


--
-- Table structure for table `wp_wc_tax_rate_classes`
--

CREATE TABLE `wp_wc_tax_rate_classes` (
  `tax_rate_class_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_class_id`),
  UNIQUE KEY `slug` (`slug`(191))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_tax_rate_classes`
--

INSERT INTO `wp_wc_tax_rate_classes` VALUES (1,'Reduced rate','reduced-rate'),(2,'Zero rate','zero-rate');

--
-- Table structure for table `wp_wc_webhooks`
--

CREATE TABLE `wp_wc_webhooks` (
  `webhook_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `delivery_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `secret` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `topic` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `api_version` smallint(4) NOT NULL,
  `failure_count` smallint(10) NOT NULL DEFAULT '0',
  `pending_delivery` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`webhook_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_webhooks`
--


--
-- Table structure for table `wp_wcmp_cust_answers`
--

CREATE TABLE `wp_wcmp_cust_answers` (
  `ans_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `ques_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `ans_details` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `ans_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `ans_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ans_vote` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`ans_ID`),
  UNIQUE KEY `ques_id` (`ques_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_cust_answers`
--


--
-- Table structure for table `wp_wcmp_cust_questions`
--

CREATE TABLE `wp_wcmp_cust_questions` (
  `ques_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `ques_details` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `ques_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `ques_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ques_vote` longtext COLLATE utf8mb4_unicode_520_ci,
  `status` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`ques_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_cust_questions`
--


--
-- Table structure for table `wp_wcmp_products_map`
--

CREATE TABLE `wp_wcmp_products_map` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_map_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `product_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_products_map`
--


--
-- Table structure for table `wp_wcmp_shipping_zone_locations`
--

CREATE TABLE `wp_wcmp_shipping_zone_locations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) DEFAULT NULL,
  `zone_id` int(11) DEFAULT NULL,
  `location_code` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `location_type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_shipping_zone_locations`
--


--
-- Table structure for table `wp_wcmp_shipping_zone_methods`
--

CREATE TABLE `wp_wcmp_shipping_zone_methods` (
  `instance_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `method_id` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `zone_id` int(11) unsigned NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `settings` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_shipping_zone_methods`
--


--
-- Table structure for table `wp_wcmp_vendor_ledger`
--

CREATE TABLE `wp_wcmp_vendor_ledger` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `ref_id` bigint(20) NOT NULL,
  `ref_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `ref_info` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `ref_status` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `ref_updated` timestamp NULL DEFAULT NULL,
  `credit` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `debit` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `balance` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_vendor_ledger`
--

INSERT INTO `wp_wcmp_vendor_ledger` VALUES (1,2,287,288,'commission','Commission generated for Order &ndash; <a href=\"http://demoweblinks.in/marlins/dashboard/vendor-orders/287\" target=\"_blank\">#287</a>','unpaid','2020-11-13 11:17:51','0','','0','2020-11-13 11:17:51');

--
-- Table structure for table `wp_wcmp_vendor_orders`
--

CREATE TABLE `wp_wcmp_vendor_orders` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL,
  `commission_id` bigint(20) NOT NULL,
  `commission_status` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'unpaid',
  `commission_paid_date` timestamp NULL DEFAULT NULL,
  `vendor_id` bigint(20) NOT NULL,
  `shipping_status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `order_item_id` bigint(20) NOT NULL,
  `line_item_type` longtext COLLATE utf8mb4_unicode_520_ci,
  `product_id` bigint(20) NOT NULL,
  `variation_id` bigint(20) NOT NULL DEFAULT '0',
  `quantity` bigint(20) NOT NULL DEFAULT '1',
  `commission_amount` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `shipping` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `tax` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `shipping_tax_amount` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',
  `is_trashed` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `vendor_orders` (`order_id`,`vendor_id`,`commission_id`,`order_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_vendor_orders`
--


--
-- Table structure for table `wp_wcmp_visitors_stats`
--

CREATE TABLE `wp_wcmp_visitors_stats` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `vendor_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_cookie` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `session_id` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `ip` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `lat` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `lon` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `city` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `zip` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `regionCode` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `region` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `countryCode` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `country` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `isp` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `timezone` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `visitor` (`vendor_id`,`session_id`),
  KEY `vendor_id` (`vendor_id`),
  KEY `user_id` (`user_id`),
  KEY `user_cookie` (`user_cookie`(191)),
  KEY `session_id` (`session_id`),
  KEY `ip` (`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wcmp_visitors_stats`
--

INSERT INTO `wp_wcmp_visitors_stats` VALUES (1,2,1,'wcmp_cookie5fae6b028c4a0','','157.44.203.7','9.9671','76.2904','Ernakulam','682036','KL','Kerala','IN','India','Reliance Jio Infocomm Limited','Asia/Kolkata','2020-11-13 11:16:24');

--
-- Table structure for table `wp_woocommerce_api_keys`
--

CREATE TABLE `wp_woocommerce_api_keys` (
  `key_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `description` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `permissions` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `consumer_key` char(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `consumer_secret` char(43) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `nonces` longtext COLLATE utf8mb4_unicode_520_ci,
  `truncated_key` char(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `last_access` datetime DEFAULT NULL,
  PRIMARY KEY (`key_id`),
  KEY `consumer_key` (`consumer_key`),
  KEY `consumer_secret` (`consumer_secret`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_api_keys`
--


--
-- Table structure for table `wp_woocommerce_attribute_taxonomies`
--

CREATE TABLE `wp_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_label` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `attribute_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_orderby` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_public` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`attribute_id`),
  KEY `attribute_name` (`attribute_name`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_attribute_taxonomies`
--


--
-- Table structure for table `wp_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `wp_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `download_id` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `order_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_email` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`permission_id`),
  KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
  KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
  KEY `order_id` (`order_id`),
  KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_downloadable_product_permissions`
--


--
-- Table structure for table `wp_woocommerce_log`
--

CREATE TABLE `wp_woocommerce_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `level` smallint(4) NOT NULL,
  `source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `context` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`log_id`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_log`
--


--
-- Table structure for table `wp_woocommerce_order_itemmeta`
--

CREATE TABLE `wp_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `order_item_id` (`order_item_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_order_itemmeta`
--

INSERT INTO `wp_woocommerce_order_itemmeta` VALUES (1,1,'_product_id','284'),(2,1,'_variation_id','0'),(3,1,'_qty','1'),(4,1,'_tax_class',''),(5,1,'_line_subtotal','1999'),(6,1,'_line_subtotal_tax','0'),(7,1,'_line_total','1999'),(8,1,'_line_tax','0'),(9,1,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(10,2,'_product_id','284'),(11,2,'_variation_id','0'),(12,2,'_qty','1'),(13,2,'_tax_class',''),(14,2,'_line_subtotal','1999'),(15,2,'_line_subtotal_tax','0'),(16,2,'_line_total','1999'),(17,2,'_line_tax','0'),(18,2,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(19,2,'_vendor_order_item_id','1'),(20,2,'_vendor_item_commission','0'),(21,2,'commission','0'),(22,2,'commission_rate','a:4:{s:4:\"mode\";s:6:\"vendor\";s:4:\"type\";s:7:\"percent\";s:14:\"commission_val\";d:0;s:16:\"commission_fixed\";i:0;}'),(23,1,'_vendor_id','2'),(24,1,'Sold By','sonuvalakam');

--
-- Table structure for table `wp_woocommerce_order_items`
--

CREATE TABLE `wp_woocommerce_order_items` (
  `order_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `order_item_type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `order_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_order_items`
--

INSERT INTO `wp_woocommerce_order_items` VALUES (1,'INFORMAL Bag','line_item',286),(2,'INFORMAL Bag','line_item',287);

--
-- Table structure for table `wp_woocommerce_payment_tokenmeta`
--

CREATE TABLE `wp_woocommerce_payment_tokenmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_token_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `payment_token_id` (`payment_token_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_payment_tokenmeta`
--


--
-- Table structure for table `wp_woocommerce_payment_tokens`
--

CREATE TABLE `wp_woocommerce_payment_tokens` (
  `token_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gateway_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `token` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`token_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_payment_tokens`
--


--
-- Table structure for table `wp_woocommerce_sessions`
--

CREATE TABLE `wp_woocommerce_sessions` (
  `session_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `session_key` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `session_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `session_expiry` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`session_id`),
  UNIQUE KEY `session_key` (`session_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_sessions`
--


--
-- Table structure for table `wp_woocommerce_shipping_zone_locations`
--

CREATE TABLE `wp_woocommerce_shipping_zone_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_id` bigint(20) unsigned NOT NULL,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `location_id` (`location_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zone_locations`
--


--
-- Table structure for table `wp_woocommerce_shipping_zone_methods`
--

CREATE TABLE `wp_woocommerce_shipping_zone_methods` (
  `zone_id` bigint(20) unsigned NOT NULL,
  `instance_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `method_order` bigint(20) unsigned NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zone_methods`
--


--
-- Table structure for table `wp_woocommerce_shipping_zones`
--

CREATE TABLE `wp_woocommerce_shipping_zones` (
  `zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `zone_order` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zones`
--


--
-- Table structure for table `wp_woocommerce_tax_rate_locations`
--

CREATE TABLE `wp_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `tax_rate_id` bigint(20) unsigned NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_tax_rate_locations`
--


--
-- Table structure for table `wp_woocommerce_tax_rates`
--

CREATE TABLE `wp_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_rate_country` varchar(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_priority` bigint(20) unsigned NOT NULL,
  `tax_rate_compound` int(1) NOT NULL DEFAULT '0',
  `tax_rate_shipping` int(1) NOT NULL DEFAULT '1',
  `tax_rate_order` bigint(20) unsigned NOT NULL,
  `tax_rate_class` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_id`),
  KEY `tax_rate_country` (`tax_rate_country`),
  KEY `tax_rate_state` (`tax_rate_state`(2)),
  KEY `tax_rate_class` (`tax_rate_class`(10)),
  KEY `tax_rate_priority` (`tax_rate_priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_tax_rates`
--

/*!50112 PREPARE s FROM @disable_bulk_load */;
/*!50112 EXECUTE s */;
/*!50112 DEALLOCATE PREPARE s */;


