
--
-- Table structure for table `wpfp_term_relationships`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_term_relationships`
--

INSERT INTO `wpfp_term_relationships` VALUES (1,1,0),(260,60,0),(11,57,0),(11,16,0),(11,17,0),(11,18,0),(11,19,0),(11,20,0),(11,21,0),(11,22,0),(11,23,0),(11,24,0),(11,25,0),(11,4,0),(185,44,0),(47,16,0),(47,26,0),(47,27,0),(47,20,0),(47,21,0),(47,22,0),(47,23,0),(47,24,0),(47,25,0),(47,4,0),(47,57,0),(185,43,0),(185,42,0),(185,17,0),(185,41,0),(185,16,0),(185,57,0),(303,56,0),(185,20,0),(83,57,0),(83,16,0),(83,28,0),(83,29,0),(83,30,0),(83,31,0),(83,20,0),(83,21,0),(83,22,0),(83,23,0),(83,24,0),(83,25,0),(83,4,0),(185,21,0),(122,32,0),(122,17,0),(122,33,0),(122,34,0),(122,35,0),(122,36,0),(122,20,0),(122,37,0),(122,21,0),(122,22,0),(122,23,0),(122,24,0),(122,25,0),(122,38,0),(122,39,0),(122,40,0),(122,4,0),(185,22,0),(185,23,0),(185,24,0),(185,25,0),(185,4,0),(302,56,0),(122,57,0),(228,57,0),(228,45,0),(228,46,0),(228,47,0),(228,37,0),(228,21,0),(228,22,0),(228,23,0),(228,24,0),(228,25,0),(228,4,0),(301,56,0),(250,48,0),(250,49,0),(250,50,0),(250,51,0),(250,4,0),(260,2,0),(250,58,0),(265,60,0),(265,16,0),(265,17,0),(265,52,0),(265,53,0),(265,54,0),(265,55,0),(265,4,0),(290,2,0),(290,59,0),(304,56,0),(305,56,0),(306,56,0);

--
-- Table structure for table `wpfp_term_taxonomy`
--

CREATE TABLE `wpfp_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=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_term_taxonomy`
--

INSERT INTO `wpfp_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'product_type','',0,2),(3,3,'product_type','',0,0),(4,4,'product_type','',0,8),(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,0),(10,10,'product_visibility','',0,0),(11,11,'product_visibility','',0,0),(12,12,'product_visibility','',0,0),(13,13,'product_visibility','',0,0),(14,14,'product_visibility','',0,0),(15,15,'product_cat','',0,0),(16,16,'pa_color','',0,5),(17,17,'pa_color','',0,4),(18,18,'pa_color','',0,1),(19,19,'pa_color','',0,1),(20,20,'pa_color','',0,5),(21,21,'pa_size','',0,6),(22,22,'pa_size','',0,6),(23,23,'pa_size','',0,6),(24,24,'pa_size','',0,6),(25,25,'pa_size','',0,6),(26,26,'pa_color','',0,1),(27,27,'pa_color','',0,1),(28,28,'pa_color','',0,1),(29,29,'pa_color','',0,1),(30,30,'pa_color','',0,1),(31,31,'pa_color','',0,1),(32,32,'pa_color','',0,1),(33,33,'pa_color','',0,1),(34,34,'pa_color','',0,1),(35,35,'pa_color','',0,1),(36,36,'pa_color','',0,1),(37,37,'pa_size','',0,2),(38,38,'pa_size','',0,1),(39,39,'pa_size','',0,1),(40,40,'pa_size','',0,1),(41,41,'pa_color','',0,1),(42,42,'pa_color','',0,1),(43,43,'pa_color','',0,1),(44,44,'pa_color','',0,1),(45,45,'pa_color','',0,1),(46,46,'pa_color','',0,1),(47,47,'pa_color','',0,1),(48,48,'pa_color','',0,1),(49,49,'pa_color','',0,1),(50,50,'pa_color','',0,1),(51,51,'pa_color','',0,1),(52,52,'pa_color','',0,1),(53,53,'pa_color','',0,1),(54,54,'pa_color','',0,1),(55,55,'pa_color','',0,1),(56,56,'nav_menu','',0,6),(57,57,'product_cat','',0,6),(58,58,'product_cat','',0,1),(59,59,'product_cat','',0,1),(60,60,'product_cat','',0,2),(61,61,'product_cat','',0,0),(62,62,'product_cat','',0,0);

--
-- Table structure for table `wpfp_termmeta`
--

CREATE TABLE `wpfp_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=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_termmeta`
--

INSERT INTO `wpfp_termmeta` VALUES (1,16,'order_pa_color',NULL),(2,17,'order_pa_color',NULL),(3,18,'order_pa_color',NULL),(4,19,'order_pa_color',NULL),(5,20,'order_pa_color',NULL),(6,21,'order_pa_size',NULL),(7,22,'order_pa_size',NULL),(8,23,'order_pa_size',NULL),(9,24,'order_pa_size',NULL),(10,25,'order_pa_size',NULL),(11,15,'product_count_product_cat','0'),(12,26,'order_pa_color',NULL),(13,27,'order_pa_color',NULL),(14,28,'order_pa_color',NULL),(15,29,'order_pa_color',NULL),(16,30,'order_pa_color',NULL),(17,31,'order_pa_color',NULL),(18,32,'order_pa_color',NULL),(19,33,'order_pa_color',NULL),(20,34,'order_pa_color',NULL),(21,35,'order_pa_color',NULL),(22,36,'order_pa_color',NULL),(23,37,'order_pa_size',NULL),(24,38,'order_pa_size',NULL),(25,39,'order_pa_size',NULL),(26,40,'order_pa_size',NULL),(27,41,'order_pa_color',NULL),(28,42,'order_pa_color',NULL),(29,43,'order_pa_color',NULL),(30,44,'order_pa_color',NULL),(31,45,'order_pa_color',NULL),(32,46,'order_pa_color',NULL),(33,47,'order_pa_color',NULL),(34,48,'order_pa_color',NULL),(35,49,'order_pa_color',NULL),(36,50,'order_pa_color',NULL),(37,51,'order_pa_color',NULL),(38,52,'order_pa_color',NULL),(39,53,'order_pa_color',NULL),(40,54,'order_pa_color',NULL),(41,55,'order_pa_color',NULL),(61,60,'product_count_product_cat','2'),(42,57,'order','0'),(43,57,'display_type',''),(44,57,'thumbnail_id','0'),(45,58,'order','0'),(46,58,'display_type',''),(47,58,'thumbnail_id','0'),(48,59,'order','0'),(49,59,'display_type',''),(50,59,'thumbnail_id','0'),(51,60,'order','0'),(52,60,'display_type',''),(53,60,'thumbnail_id','0'),(54,61,'order','0'),(55,61,'display_type',''),(56,61,'thumbnail_id','0'),(57,62,'order','0'),(58,62,'display_type',''),(59,62,'thumbnail_id','0'),(60,59,'product_count_product_cat','1'),(62,58,'product_count_product_cat','1'),(63,57,'product_count_product_cat','6');

--
-- Table structure for table `wpfp_terms`
--

CREATE TABLE `wpfp_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=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_terms`
--

INSERT INTO `wpfp_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,'Black','black',0),(17,'Red','red',0),(18,'Royal','royal',0),(19,'Sport Grey','sport-grey',0),(20,'White','white',0),(21,'S','s',0),(22,'M','m',0),(23,'L','l',0),(24,'XL','xl',0),(25,'2XL','2xl',0),(26,'Heather Grey','heather-grey',0),(27,'Cool Heather','cool-heather',0),(28,'Navy Blazer','navy-blazer',0),(29,'Maroon','maroon',0),(30,'Charcoal Heather','charcoal-heather',0),(31,'Carbon Grey','carbon-grey',0),(32,'Black Heather','black-heather',0),(33,'True Royal','true-royal',0),(34,'Kelly','kelly',0),(35,'Ocean Blue','ocean-blue',0),(36,'Silver','silver',0),(37,'XS','xs',0),(38,'3XL','3xl',0),(39,'4XL','4xl',0),(40,'5XL','5xl',0),(41,'Smoke','smoke',0),(42,'Royal Blue','royal-blue',0),(43,'Storm Grey','storm-grey',0),(44,'Heather Green','heather-green',0),(45,'Charcoal black Triblend','charcoal-black-triblend',0),(46,'Solid Black Triblend','solid-black-triblend',0),(47,'Grey Triblend','grey-triblend',0),(48,'Dark Navy','dark-navy',0),(49,'Black/ Red','black-red',0),(50,'Black/ Teal','black-teal',0),(51,'Black/ Silver','black-silver',0),(52,'Orange','orange',0),(53,'Blue','blue',0),(54,'Pink','pink',0),(55,'Yellow','yellow',0),(56,'Main Menu','main-menu',0),(57,'Apparel','apparel',0),(58,'Hats','hats',0),(59,'Accessories','accessories',0),(60,'Home &amp; Living','home-living',0),(61,'Office','office',0),(62,'Tech','tech',0);

--
-- Table structure for table `wpfp_usermeta`
--

CREATE TABLE `wpfp_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=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_usermeta`
--

INSERT INTO `wpfp_usermeta` VALUES (1,1,'nickname','admin'),(2,1,'first_name',''),(3,1,'last_name',''),(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,'wpfp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wpfp_user_level','10'),(14,1,'dismissed_wp_pointers','theme_editor_notice'),(15,1,'show_welcome_panel','1'),(16,1,'session_tokens','a:3:{s:64:\"8b4e2551acde7fbeacb55f68c640f9a700789aee9996ff2434454ce261264bd4\";a:4:{s:10:\"expiration\";i:1629482023;s:2:\"ip\";s:11:\"72.255.7.82\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36\";s:5:\"login\";i:1628272423;}s:64:\"fa2ac182573534c2f6f12d8206faea74ee88b4b6d51ff06d23a229d221f19d26\";a:4:{s:10:\"expiration\";i:1628697372;s:2:\"ip\";s:12:\"66.146.75.82\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36\";s:5:\"login\";i:1628524572;}s:64:\"2924624e4a0a4f65f0a849ca95335a5e4855e8d2a6e6d91f04cce135dc493580\";a:4:{s:10:\"expiration\";i:1628709323;s:2:\"ip\";s:13:\"47.145.164.29\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36\";s:5:\"login\";i:1628536523;}}'),(17,1,'wpfp_dashboard_quick_press_last_post_id','4'),(18,1,'community-events-location','a:1:{s:2:\"ip\";s:12:\"47.145.164.0\";}'),(19,1,'_woocommerce_tracks_anon_id','woo:Ecn10PDGtZceH5BUw9rfCKo1'),(20,1,'last_update','1628539474'),(21,1,'woocommerce_admin_activity_panel_inbox_last_read','1628539472331'),(22,1,'wc_last_active','1628467200'),(23,1,'_order_count','0'),(24,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\";}'),(25,1,'metaboxhidden_nav-menus','a:5:{i:0;s:28:\"add-post-type-e-landing-page\";i:1;s:21:\"add-post-type-product\";i:2;s:12:\"add-post_tag\";i:3;s:15:\"add-product_cat\";i:4;s:15:\"add-product_tag\";}'),(26,1,'nav_menu_recently_edited','56'),(27,1,'wpfp_user-settings','libraryContent=browse'),(28,1,'wpfp_user-settings-time','1628208809'),(30,1,'_woocommerce_persistent_cart_1','a:1:{s:4:\"cart\";a:0:{}}');

--
-- Table structure for table `wpfp_wc_admin_note_actions`
--

CREATE TABLE `wpfp_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,
  `nonce_action` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `nonce_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`action_id`),
  KEY `note_id` (`note_id`)
) ENGINE=MyISAM AUTO_INCREMENT=806 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_admin_note_actions`
--

INSERT INTO `wpfp_wc_admin_note_actions` VALUES (770,1,'wayflyer_q3_2021','Get funded','https://woocommerce.com/products/wayflyer/','actioned',1,'',NULL,NULL),(771,2,'eu_vat_changes_2021','Learn more about the EU tax regulations','https://woocommerce.com/posts/new-eu-vat-regulations','actioned',1,'',NULL,NULL),(772,3,'open_wc_paypal_payments_product_page','Learn more','https://woocommerce.com/products/woocommerce-paypal-payments/','actioned',1,'',NULL,NULL),(773,4,'upgrade_now_facebook_pixel_api','Upgrade now','plugin-install.php?tab=plugin-information&plugin=&section=changelog','actioned',1,'',NULL,NULL),(774,5,'learn_more_facebook_ec','Learn more','https://woocommerce.com/products/facebook/','unactioned',1,'',NULL,NULL),(775,6,'set-up-concierge','Schedule free session','https://wordpress.com/me/concierge','actioned',1,'',NULL,NULL),(776,7,'learn-more','Learn more','https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox','unactioned',1,'',NULL,NULL),(777,8,'learn-more-ecomm-unique-shopping-experience','Learn more','https://docs.woocommerce.com/document/product-add-ons/?utm_source=inbox','actioned',1,'',NULL,NULL),(778,9,'watch-the-webinar','Watch the webinar','https://youtu.be/V_2XtCOyZ7o','actioned',1,'',NULL,NULL),(779,10,'learn-more','Learn more','https://woocommerce.com/posts/ecommerce-shipping-solutions-guide/?utm_source=inbox','actioned',1,'',NULL,NULL),(780,11,'boost-sales-marketing-guide','See marketing guide','https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=square-boost-sales','actioned',1,'',NULL,NULL),(781,12,'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,'',NULL,NULL),(782,13,'add-apple-pay','Add Apple Pay','/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments','actioned',1,'',NULL,NULL),(783,13,'learn-more','Learn more','https://docs.woocommerce.com/document/payments/apple-pay/?utm_source=inbox&utm_medium=product&utm_campaign=wcpay_applepay','actioned',1,'',NULL,NULL),(784,14,'boost-sales-marketing-guide','See marketing guide','https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=wcpay-boost-sales','actioned',1,'',NULL,NULL),(785,15,'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,'',NULL,NULL),(786,16,'optimizing-the-checkout-flow','Learn more','https://woocommerce.com/posts/optimizing-woocommerce-checkout?utm_source=inbox','actioned',1,'',NULL,NULL),(787,17,'learn-more','Learn more','https://woocommerce.com/posts/first-things-customize-woocommerce/?utm_source=inbox','unactioned',1,'',NULL,NULL),(788,18,'qualitative-feedback-from-new-users','Share feedback','https://automattic.survey.fm/wc-pay-new','actioned',1,'',NULL,NULL),(789,19,'share-feedback','Share feedback','http://automattic.survey.fm/paypal-feedback','unactioned',1,'',NULL,NULL),(790,20,'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,'',NULL,NULL),(791,21,'get-started','Get started','https://woocommerce.com/products/google-listings-and-ads','actioned',1,'',NULL,NULL),(792,22,'update-wc-subscriptions-3-0-15','View latest version','https://demo.updogshops.net/wp-admin/admin.php?page=wc-admin&page=wc-addons&section=helper','actioned',1,'',NULL,NULL),(793,23,'update-wc-core-5-4-0','How to update WooCommerce','https://docs.woocommerce.com/document/how-to-update-woocommerce/','actioned',1,'',NULL,NULL),(794,26,'get-woo-commerce-payments','Get WooCommerce Payments','admin.php?page=wc-admin&action=setup-woocommerce-payments','actioned',1,'',NULL,NULL),(795,27,'get-woocommerce-payments','Get WooCommerce Payments','admin.php?page=wc-admin&action=setup-woocommerce-payments','actioned',1,'',NULL,NULL),(796,28,'ppxo-pps-install-paypal-payments-1','View upgrade guide','https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/','actioned',1,'',NULL,NULL),(797,29,'ppxo-pps-install-paypal-payments-2','View upgrade guide','https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/','actioned',1,'',NULL,NULL),(798,30,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms','unactioned',1,'',NULL,NULL),(799,30,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(800,31,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms','unactioned',1,'',NULL,NULL),(801,31,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(802,32,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms','unactioned',1,'',NULL,NULL),(803,32,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(804,33,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms','unactioned',1,'',NULL,NULL),(805,33,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(37,34,'yes-please','Yes please!','https://woocommerce.us8.list-manage.com/subscribe/post?u=2c1434dc56f9506bf3c3ecd21&amp;id=13860df971&amp;SIGNUPPAGE=plugin','actioned',0,'',NULL,NULL),(74,35,'connect','Connect','?page=wc-addons&section=helper','unactioned',0,'',NULL,NULL),(147,36,'customize-store-with-storefront','Let\'s go!','https://demo.updogshops.net/wp-admin/themes.php?page=storefront-welcome','actioned',1,'',NULL,NULL),(184,37,'learn-more','Learn more','https://docs.woocommerce.com/document/variable-product/?utm_source=inbox','actioned',0,'',NULL,NULL),(660,44,'learn-more','Learn more','https://woocommerce.com/posts/how-to-make-your-online-store-stand-out/?utm_source=inbox','actioned',1,'',NULL,NULL),(581,38,'learn-more','Learn more','https://docs.woocommerce.com/document/woocommerce-analytics/#variations-report','actioned',0,'',NULL,NULL),(582,39,'visit-the-theme-marketplace','Visit the theme marketplace','https://woocommerce.com/product-category/themes/?utm_source=inbox','actioned',0,'',NULL,NULL),(583,40,'affirm-insight-first-product-and-payment','Yes','','actioned',0,'Thanks for your feedback',NULL,NULL),(584,40,'affirm-insight-first-product-and-payment','No','','actioned',0,'Thanks for your feedback',NULL,NULL),(621,41,'learn-more','Learn more','https://woocommerce.com/mobile/','actioned',0,'',NULL,NULL),(622,42,'online-clothing-store','Learn more','https://woocommerce.com/posts/starting-an-online-clothing-store/?utm_source=inbox','actioned',1,'',NULL,NULL),(623,43,'day-after-first-product','Learn more','https://docs.woocommerce.com/document/woocommerce-customizer/?utm_source=inbox','actioned',0,'',NULL,NULL),(697,45,'need-some-inspiration','See success stories','https://woocommerce.com/success-stories/?utm_source=inbox','actioned',1,'',NULL,NULL);

--
-- Table structure for table `wpfp_wc_admin_notes`
--

CREATE TABLE `wpfp_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=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_admin_notes`
--

INSERT INTO `wpfp_wc_admin_notes` VALUES (1,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(2,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(3,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(4,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(5,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(6,'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','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(7,'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','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(8,'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','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(9,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(10,'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>.','{}','unactioned','woocommerce.com','2021-08-05 23:17:56',NULL,0,'plain','',0,'info'),(11,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(12,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(13,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(14,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(15,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(16,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(17,'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.','{}','unactioned','woocommerce.com','2021-08-06 23:55:03',NULL,0,'plain','',0,'info'),(18,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(19,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(20,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(21,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(22,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(23,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(24,'wcpay-promo-2020-11','marketing','en_US','wcpay-promo-2020-11','wcpay-promo-2020-11','{}','pending','woocommerce.com','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(25,'wcpay-promo-2020-12','marketing','en_US','wcpay-promo-2020-12','wcpay-promo-2020-12','{}','pending','woocommerce.com','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(26,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(27,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(28,'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.','{}','unactioned','woocommerce.com','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(29,'ppxo-pps-upgrade-paypal-payments-2','info','en_US','Upgrade your PayPal experience!','We\'ve developed a whole new <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">PayPal extension for WooCommerce</a> that combines the best features of our many PayPal extensions into just one extension.<br /><br />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 latest PayPal today to continue to receive support and updates.','{}','pending','woocommerce.com','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(30,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(31,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(32,'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.','{}','pending','woocommerce.com','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(33,'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-08-04 23:54:55',NULL,0,'plain','',0,'info'),(34,'wc-admin-onboarding-email-marketing','info','en_US','Sign up for tips, product updates, and inspiration','We\'re here for you - get tips, product updates and inspiration straight to your email box','{}','unactioned','woocommerce-admin','2021-08-04 23:54:55',NULL,0,'plain','',0,'info'),(35,'wc-admin-wc-helper-connection','info','en_US','Connect to WooCommerce.com','Connect to get important product notifications and updates.','{}','unactioned','woocommerce-admin','2021-08-04 23:54:56',NULL,0,'plain','',0,'info'),(36,'storefront-customize','info','en_US','Design your store with Storefront ?','Visit the Storefront settings page to start setup and customization of your shop.','{}','unactioned','storefront','2021-08-04 23:56:47',NULL,0,'plain','',0,'info'),(37,'wc-admin-learn-more-about-variable-products','info','en_US','Learn more about variable products','Variable products are a powerful product type that lets you offer a set of variations on a product, with control over prices, stock, image and more for each variation. They can be used for a product like a shirt, where you can offer a large, medium and small and in different colors.','{}','unactioned','woocommerce-admin','2021-08-05 22:17:50',NULL,0,'plain','',0,'info'),(38,'wc-admin-filter-by-product-variations-in-reports','info','en_US','New - filter by product variations in orders and products reports','One of the most awaited features has just arrived! You can now have insights into each product variation in the orders and products reports.','{}','unactioned','woocommerce-admin','2021-08-06 00:07:11',NULL,0,'banner','https://demo.updogshops.net/wp-content/plugins/woocommerce/packages/woocommerce-admin/images/admin_notes/filter-by-product-variations-note.svg',0,'info'),(39,'wc-admin-choosing-a-theme','marketing','en_US','Choosing a theme?','Check out the themes that are compatible with WooCommerce and choose one aligned with your brand and business needs.','{}','unactioned','woocommerce-admin','2021-08-06 00:07:11',NULL,0,'plain','',0,'info'),(40,'wc-admin-insight-first-product-and-payment','survey','en_US','Insight','More than 80% of new merchants add the first product and have at least one payment method set up during the first week.<br><br>Do you find this type of insight useful?','{}','unactioned','woocommerce-admin','2021-08-06 00:07:11',NULL,0,'plain','',0,'info'),(41,'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','2021-08-06 23:55:03',NULL,0,'plain','',0,'info'),(42,'wc-admin-online-clothing-store','info','en_US','Start your online clothing store','Starting a fashion website is exciting but it may seem overwhelming as well. In this article, we\'ll walk you through the setup process, teach you to create successful product listings, and show you how to market to your ideal audience.','{}','unactioned','woocommerce-admin','2021-08-06 23:55:03',NULL,0,'plain','',0,'info'),(43,'wc-admin-customizing-product-catalog','info','en_US','How to customize your product catalog','You want your product catalog and images to look great and align with your brand. This guide will give you all the tips you need to get your products looking great in your store.','{}','unactioned','woocommerce-admin','2021-08-06 23:55:03',NULL,0,'plain','',0,'info'),(44,'wc-admin-draw-attention','info','en_US','Get noticed: how to draw attention to your online store','To get you started, here are seven ways to boost your sales and avoid getting drowned out by similar, mass-produced products competing for the same buyers.','{}','unactioned','woocommerce-admin','2021-08-08 00:05:51',NULL,0,'plain','',0,'info'),(45,'wc-admin-need-some-inspiration','info','en_US','Browse our success stories','Learn more about how other entrepreneurs used WooCommerce to build successful businesses.','{}','unactioned','woocommerce-admin','2021-08-09 02:56:10',NULL,0,'plain','',0,'info');

--
-- Table structure for table `wpfp_wc_category_lookup`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_category_lookup`
--

INSERT INTO `wpfp_wc_category_lookup` VALUES (15,15);

--
-- Table structure for table `wpfp_wc_customer_lookup`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_customer_lookup`
--


--
-- Table structure for table `wpfp_wc_download_log`
--

CREATE TABLE `wpfp_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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_download_log`
--


--
-- Table structure for table `wpfp_wc_order_coupon_lookup`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_order_coupon_lookup`
--


--
-- Table structure for table `wpfp_wc_order_product_lookup`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_order_product_lookup`
--


--
-- Table structure for table `wpfp_wc_order_stats`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_order_stats`
--


--
-- Table structure for table `wpfp_wc_order_tax_lookup`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_order_tax_lookup`
--


--
-- Table structure for table `wpfp_wc_product_meta_lookup`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_product_meta_lookup`
--

INSERT INTO `wpfp_wc_product_meta_lookup` VALUES (11,'',0,0,21.5000,34.9500,0,NULL,'instock',0,0.00,0,'taxable',''),(12,'610B3C7EC3DD3_Black-S',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(13,'610B3C7EC3DD3_Black-M',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(14,'610B3C7EC3DD3_Black-L',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(15,'610B3C7EC3DD3_Black-XL',0,0,21.5000,21.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(16,'610B3C7EC3DD3_Black-2XL',0,0,24.0000,24.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(17,'610B3C7EC3DD3_Red-S',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(18,'610B3C7EC3DD3_Red-M',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(19,'610B3C7EC3DD3_Red-L',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(20,'610B3C7EC3DD3_Red-XL',0,0,21.5000,21.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(21,'610B3C7EC3DD3_Red-2XL',0,0,24.0000,24.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(22,'610B3C7EC3DD3_Royal-S',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(23,'610B3C7EC3DD3_Royal-M',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(24,'610B3C7EC3DD3_Royal-L',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(25,'610B3C7EC3DD3_Royal-XL',0,0,21.5000,21.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(26,'610B3C7EC3DD3_Royal-2XL',0,0,24.0000,24.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(27,'610B3C7EC3DD3_Sport-Grey-S',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(28,'610B3C7EC3DD3_Sport-Grey-M',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(29,'610B3C7EC3DD3_Sport-Grey-L',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(30,'610B3C7EC3DD3_Sport-Grey-XL',0,0,21.5000,21.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(31,'610B3C7EC3DD3_Sport-Grey-2XL',0,0,24.0000,24.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(32,'610B3C7EC3DD3_White-S',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(33,'610B3C7EC3DD3_White-M',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(34,'610B3C7EC3DD3_White-L',0,0,34.9500,34.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(35,'610B3C7EC3DD3_White-XL',0,0,21.5000,21.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(36,'610B3C7EC3DD3_White-2XL',0,0,24.0000,24.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(47,'',0,0,39.0000,41.9500,0,NULL,'instock',0,0.00,0,'taxable',''),(48,'610B3CF52F5E8_Black-S',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(49,'610B3CF52F5E8_Black-M',0,0,39.0000,39.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(50,'610B3CF52F5E8_Black-L',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(51,'610B3CF52F5E8_Black-XL',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(52,'610B3CF52F5E8_Black-2XL',0,0,41.9500,41.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(53,'610B3CF52F5E8_Heather-Grey-S',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(54,'610B3CF52F5E8_Heather-Grey-M',0,0,39.0000,39.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(55,'610B3CF52F5E8_Heather-Grey-L',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(56,'610B3CF52F5E8_Heather-Grey-XL',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(57,'610B3CF52F5E8_Heather-Grey-2XL',0,0,41.9500,41.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(58,'610B3CF52F5E8_Cool-Heather-S',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(59,'610B3CF52F5E8_Cool-Heather-M',0,0,39.0000,39.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(60,'610B3CF52F5E8_Cool-Heather-L',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(61,'610B3CF52F5E8_Cool-Heather-XL',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(62,'610B3CF52F5E8_Cool-Heather-2XL',0,0,41.9500,41.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(63,'610B3CF52F5E8_White-S',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(64,'610B3CF52F5E8_White-M',0,0,39.0000,39.0000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(65,'610B3CF52F5E8_White-L',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(66,'610B3CF52F5E8_White-XL',0,0,39.9500,39.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(67,'610B3CF52F5E8_White-2XL',0,0,41.9500,41.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(185,'',0,0,24.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable',''),(186,'610C6207E932C_Black-S',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(187,'610C6207E932C_Black-M',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(188,'610C6207E932C_Black-L',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(191,'610C6207E932C_Smoke-S',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(190,'610C6207E932C_Black-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(189,'610C6207E932C_Black-XL',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(83,'',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable',''),(86,'610B3FBD565A6_Black-S',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(87,'610B3FBD565A6_Black-M',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(88,'610B3FBD565A6_Black-L',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(89,'610B3FBD565A6_Black-XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(90,'610B3FBD565A6_Black-2XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(91,'610B3FBD565A6_Navy-Blazer-S',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(92,'610B3FBD565A6_Navy-Blazer-M',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(93,'610B3FBD565A6_Navy-Blazer-L',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(94,'610B3FBD565A6_Navy-Blazer-XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(95,'610B3FBD565A6_Navy-Blazer-2XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(96,'610B3FBD565A6_Maroon-S',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(97,'610B3FBD565A6_Maroon-M',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(98,'610B3FBD565A6_Maroon-L',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(99,'610B3FBD565A6_Maroon-XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(100,'610B3FBD565A6_Maroon-2XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(101,'610B3FBD565A6_Charcoal-Heather-S',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(102,'610B3FBD565A6_Charcoal-Heather-M',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(103,'610B3FBD565A6_Charcoal-Heather-L',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(104,'610B3FBD565A6_Charcoal-Heather-XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(105,'610B3FBD565A6_Charcoal-Heather-2XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(106,'610B3FBD565A6_Carbon-Grey-S',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(107,'610B3FBD565A6_Carbon-Grey-M',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(108,'610B3FBD565A6_Carbon-Grey-L',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(109,'610B3FBD565A6_Carbon-Grey-XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(110,'610B3FBD565A6_Carbon-Grey-2XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(111,'610B3FBD565A6_White-S',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(112,'610B3FBD565A6_White-M',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(113,'610B3FBD565A6_White-L',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(114,'610B3FBD565A6_White-XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(115,'610B3FBD565A6_White-2XL',0,0,49.9500,49.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(122,'',0,0,19.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable',''),(125,'610B40F174DC1_Black-Heather-XS',0,0,19.9500,19.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(126,'610B40F174DC1_Black-Heather-S',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(127,'610B40F174DC1_Black-Heather-M',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(128,'610B40F174DC1_Black-Heather-L',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(129,'610B40F174DC1_Black-Heather-XL',0,0,23.9500,23.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(130,'610B40F174DC1_Black-Heather-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(131,'610B40F174DC1_Black-Heather-3XL',0,0,28.9500,28.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(132,'610B40F174DC1_Black-Heather-4XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(133,'610B40F174DC1_Black-Heather-5XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(134,'610B40F174DC1_Red-S',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(135,'610B40F174DC1_Red-M',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(136,'610B40F174DC1_Red-L',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(137,'610B40F174DC1_Red-XL',0,0,23.9500,23.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(138,'610B40F174DC1_Red-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(139,'610B40F174DC1_Red-3XL',0,0,28.9500,28.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(140,'610B40F174DC1_Red-4XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(141,'610B40F174DC1_Red-5XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(142,'610B40F174DC1_True-Royal-S',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(143,'610B40F174DC1_True-Royal-M',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(144,'610B40F174DC1_True-Royal-L',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(145,'610B40F174DC1_True-Royal-XL',0,0,23.9500,23.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(146,'610B40F174DC1_True-Royal-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(147,'610B40F174DC1_True-Royal-3XL',0,0,28.9500,28.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(148,'610B40F174DC1_True-Royal-4XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(149,'610B40F174DC1_Kelly-XS',0,0,19.9500,19.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(150,'610B40F174DC1_Kelly-S',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(151,'610B40F174DC1_Kelly-M',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(152,'610B40F174DC1_Kelly-L',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(153,'610B40F174DC1_Kelly-XL',0,0,23.9500,23.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(154,'610B40F174DC1_Kelly-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(155,'610B40F174DC1_Kelly-3XL',0,0,28.9500,28.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(156,'610B40F174DC1_Kelly-4XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(157,'610B40F174DC1_Ocean-Blue-S',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(158,'610B40F174DC1_Ocean-Blue-M',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(159,'610B40F174DC1_Ocean-Blue-L',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(160,'610B40F174DC1_Ocean-Blue-XL',0,0,23.9500,23.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(161,'610B40F174DC1_Ocean-Blue-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(162,'610B40F174DC1_Ocean-Blue-3XL',0,0,28.9500,28.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(163,'610B40F174DC1_Ocean-Blue-4XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(164,'610B40F174DC1_Silver-S',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(165,'610B40F174DC1_Silver-M',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(166,'610B40F174DC1_Silver-L',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(167,'610B40F174DC1_Silver-XL',0,0,23.9500,23.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(168,'610B40F174DC1_Silver-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(169,'610B40F174DC1_White-XS',0,0,19.9500,19.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(170,'610B40F174DC1_White-S',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(171,'610B40F174DC1_White-M',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(172,'610B40F174DC1_White-L',0,0,21.9500,21.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(173,'610B40F174DC1_White-XL',0,0,23.9500,23.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(174,'610B40F174DC1_White-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(175,'610B40F174DC1_White-3XL',0,0,28.9500,28.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(176,'610B40F174DC1_White-4XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(177,'610B40F174DC1_White-5XL',0,0,29.9500,29.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(192,'610C6207E932C_Smoke-M',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(193,'610C6207E932C_Smoke-L',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(194,'610C6207E932C_Smoke-XL',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(195,'610C6207E932C_Smoke-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(196,'610C6207E932C_Red-S',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(197,'610C6207E932C_Red-M',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(198,'610C6207E932C_Red-L',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(199,'610C6207E932C_Red-XL',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(200,'610C6207E932C_Red-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(201,'610C6207E932C_Royal-Blue-S',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(202,'610C6207E932C_Royal-Blue-M',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(203,'610C6207E932C_Royal-Blue-L',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(204,'610C6207E932C_Royal-Blue-XL',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(205,'610C6207E932C_Royal-Blue-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(206,'610C6207E932C_Storm-Grey-S',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(207,'610C6207E932C_Storm-Grey-M',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(208,'610C6207E932C_Storm-Grey-L',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(209,'610C6207E932C_Storm-Grey-XL',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(210,'610C6207E932C_Storm-Grey-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(211,'610C6207E932C_Heather-Green-S',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(212,'610C6207E932C_Heather-Green-M',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(213,'610C6207E932C_Heather-Green-L',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(214,'610C6207E932C_Heather-Green-XL',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(215,'610C6207E932C_Heather-Green-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(216,'610C6207E932C_White-S',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(217,'610C6207E932C_White-M',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(218,'610C6207E932C_White-L',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(219,'610C6207E932C_White-XL',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(220,'610C6207E932C_White-2XL',0,0,25.9500,25.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(228,'',0,0,35.9500,38.5000,0,NULL,'instock',0,0.00,0,'taxable',''),(229,'610C62CAD3CC0_Charcoal-black-Triblend-XS',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(230,'610C62CAD3CC0_Charcoal-black-Triblend-S',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(231,'610C62CAD3CC0_Charcoal-black-Triblend-M',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(232,'610C62CAD3CC0_Charcoal-black-Triblend-L',0,0,36.5000,36.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(233,'610C62CAD3CC0_Charcoal-black-Triblend-XL',0,0,36.5000,36.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(234,'610C62CAD3CC0_Charcoal-black-Triblend-2XL',0,0,38.5000,38.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(235,'610C62CAD3CC0_Solid-Black-Triblend-XS',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(236,'610C62CAD3CC0_Solid-Black-Triblend-S',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(237,'610C62CAD3CC0_Solid-Black-Triblend-M',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(238,'610C62CAD3CC0_Solid-Black-Triblend-L',0,0,36.5000,36.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(239,'610C62CAD3CC0_Solid-Black-Triblend-XL',0,0,36.5000,36.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(240,'610C62CAD3CC0_Solid-Black-Triblend-2XL',0,0,38.5000,38.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(241,'610C62CAD3CC0_Grey-Triblend-XS',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(242,'610C62CAD3CC0_Grey-Triblend-S',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(243,'610C62CAD3CC0_Grey-Triblend-M',0,0,35.9500,35.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(244,'610C62CAD3CC0_Grey-Triblend-L',0,0,36.5000,36.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(245,'610C62CAD3CC0_Grey-Triblend-XL',0,0,36.5000,36.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(246,'610C62CAD3CC0_Grey-Triblend-2XL',0,0,38.5000,38.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(250,'',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable',''),(252,'610C632061DD3_Dark-Navy',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(253,'610C632061DD3_Black--Red',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(254,'610C632061DD3_Black--Teal',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(255,'610C632061DD3_Black--Silver',0,0,24.9500,24.9500,0,NULL,'instock',0,0.00,0,'taxable','parent'),(260,'610C638964E59',0,0,28.0000,28.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(265,'',0,0,12.5000,12.5000,0,NULL,'instock',0,0.00,0,'taxable',''),(266,'610C63F8B12CC_Black',0,0,12.5000,12.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(267,'610C63F8B12CC_Red',0,0,12.5000,12.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(268,'610C63F8B12CC_Orange',0,0,12.5000,12.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(269,'610C63F8B12CC_Blue',0,0,12.5000,12.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(270,'610C63F8B12CC_Pink',0,0,12.5000,12.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(271,'610C63F8B12CC_Yellow',0,0,12.5000,12.5000,0,NULL,'instock',0,0.00,0,'taxable','parent'),(290,'610C649E3EEDF',0,0,77.0000,77.0000,0,NULL,'instock',0,0.00,0,'taxable','');

--
-- Table structure for table `wpfp_wc_reserved_stock`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_reserved_stock`
--


--
-- Table structure for table `wpfp_wc_tax_rate_classes`
--

CREATE TABLE `wpfp_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=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_wc_tax_rate_classes`
--

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

--
-- Table structure for table `wpfp_woocommerce_attribute_taxonomies`
--

CREATE TABLE `wpfp_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=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_attribute_taxonomies`
--

INSERT INTO `wpfp_woocommerce_attribute_taxonomies` VALUES (1,'color','Color','select','menu_order',0),(2,'size','Size','select','menu_order',0);

--
-- Table structure for table `wpfp_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_downloadable_product_permissions`
--


--
-- Table structure for table `wpfp_woocommerce_log`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_log`
--


--
-- Table structure for table `wpfp_woocommerce_order_itemmeta`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_order_itemmeta`
--


--
-- Table structure for table `wpfp_woocommerce_order_items`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_order_items`
--


--
-- Table structure for table `wpfp_woocommerce_payment_tokenmeta`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_payment_tokenmeta`
--


--
-- Table structure for table `wpfp_woocommerce_payment_tokens`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_payment_tokens`
--


--
-- Table structure for table `wpfp_woocommerce_shipping_zone_locations`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_shipping_zone_locations`
--


--
-- Table structure for table `wpfp_woocommerce_shipping_zone_methods`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_shipping_zone_methods`
--


--
-- Table structure for table `wpfp_woocommerce_shipping_zones`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_shipping_zones`
--


--
-- Table structure for table `wpfp_woocommerce_tax_rate_locations`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_tax_rate_locations`
--


--
-- Table structure for table `wpfp_woocommerce_tax_rates`
--

CREATE TABLE `wpfp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpfp_woocommerce_tax_rates`
--



