-- Table structure for table `wpln_term_relationships`
--

CREATE TABLE `wpln_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_ci;

--
-- Dumping data for table `wpln_term_relationships`
--

INSERT INTO `wpln_term_relationships` VALUES (145,15,0),(145,2,0),(146,15,0),(146,2,0),(147,15,0),(147,2,0),(148,15,0),(148,2,0),(149,15,0),(149,2,0),(150,15,0),(150,2,0),(151,15,0),(151,2,0),(152,15,0),(152,2,0),(153,15,0),(153,2,0),(154,15,0),(154,2,0),(155,15,0),(155,2,0),(156,15,0),(156,2,0),(157,15,0),(157,2,0),(158,15,0),(158,2,0),(159,15,0),(159,2,0),(160,15,0),(160,2,0),(161,15,0),(161,2,0),(162,15,0),(162,2,0),(163,15,0),(163,2,0),(164,15,0),(164,2,0),(165,15,0),(165,2,0),(166,15,0),(166,2,0),(167,15,0),(167,2,0),(168,15,0),(168,2,0),(169,15,0),(169,2,0),(314,2,0),(313,2,0),(547,25,0),(312,2,0),(547,2,0),(547,9,0),(311,2,0),(402,2,0),(402,9,0),(493,2,0),(314,26,0),(402,24,0),(313,27,0),(311,28,0),(493,30,0),(312,29,0),(548,25,0),(548,2,0),(586,32,0);

--
-- Table structure for table `wpln_term_taxonomy`
--

CREATE TABLE `wpln_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_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_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=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_term_taxonomy`
--

INSERT INTO `wpln_term_taxonomy` VALUES (1,1,'category','',0,0),(2,2,'product_type','',0,8),(3,3,'product_type','',0,0),(4,4,'product_type','',0,0),(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,2),(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,'product_cat','',0,0),(17,17,'product_cat','',16,0),(18,18,'product_cat','',16,0),(19,19,'product_cat','',16,0),(20,20,'product_cat','',0,0),(21,21,'product_cat','',0,0),(22,22,'nav_menu','',0,0),(23,23,'product_cat','',0,0),(24,24,'product_cat','',0,1),(26,26,'product_cat','',0,1),(25,25,'product_cat','',0,2),(27,27,'product_cat','',0,1),(28,28,'product_cat','',0,1),(29,29,'product_cat','',0,1),(30,30,'product_cat','',0,1),(31,31,'product_cat','',0,0),(32,32,'wp_theme','',0,1);

--
-- Table structure for table `wpln_termmeta`
--

CREATE TABLE `wpln_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_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_termmeta`
--

INSERT INTO `wpln_termmeta` VALUES (1,15,'product_count_product_cat','0'),(2,23,'order','0'),(3,23,'product_count_product_cat','0'),(4,24,'order','0'),(5,24,'product_count_product_cat','1'),(6,19,'product_count_product_cat','0'),(7,16,'product_count_product_cat','0'),(8,25,'order','0'),(9,25,'product_count_product_cat','2'),(10,26,'order','0'),(11,26,'product_count_product_cat','1'),(12,27,'order','0'),(13,27,'product_count_product_cat','1'),(14,28,'order','0'),(15,28,'product_count_product_cat','1'),(16,29,'order','0'),(17,29,'product_count_product_cat','1'),(18,30,'order','0'),(19,30,'product_count_product_cat','1'),(20,31,'order','0'),(21,31,'product_count_product_cat','0');

--
-- Table structure for table `wpln_terms`
--

CREATE TABLE `wpln_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_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=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_terms`
--

INSERT INTO `wpln_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,'Clothing','clothing',0),(17,'Tshirts','tshirts',0),(18,'Hoodies','hoodies',0),(19,'Accessories','accessories',0),(20,'Music','music',0),(21,'Decor','decor',0),(22,'Baby Love Bugs Swing Cover Store','baby-love-bugs-swing-cover-store',0),(23,'MamaRoo style covers','mamaroo-style-covers',0),(24,'Bright Starts (TM) Style','bright-starts-tm-style',0),(25,'MamaRoo (TM) style cover','mamaroo-tm-style-cover',0),(26,'BLB1','blb1',0),(27,'BLB4','blb4',0),(28,'BLB2','blb2',0),(29,'BLB3','blb3',0),(30,'VSR1','vsr1',0),(31,'MRC 2','mrc-2',0),(32,'storefront','storefront',0);

--
-- Table structure for table `wpln_usermeta`
--

CREATE TABLE `wpln_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_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_usermeta`
--

INSERT INTO `wpln_usermeta` VALUES (1,1,'nickname','Baby Love Bugs'),(2,1,'first_name','KATHERINE'),(3,1,'last_name','DEWEES'),(4,1,'description','We are a small woman owned business located in Rio Rancho, NM.\r\nOur goal is to provide a disinfect-able product to help in keeping \r\nbabies in a medical setting, safe from cross-contamination.'),(5,1,'rich_editing','true'),(6,1,'syntax_highlighting','true'),(7,1,'comment_shortcuts','false'),(8,1,'admin_color','blue'),(9,1,'use_ssl','0'),(10,1,'show_admin_bar_front','true'),(11,1,'locale',''),(12,1,'wpln_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wpln_user_level','10'),(14,1,'dismissed_wp_pointers','text_widget_custom_html,wc_services_labels_metabox,wc_services_new_carrier_dhl_express'),(15,1,'show_welcome_panel','1'),(78,1,'meta-box-order_product','a:3:{s:4:\"side\";s:29:\"submitdiv,tagsdiv-product_tag\";s:6:\"normal\";s:98:\"postimagediv,woocommerce-product-images,product_catdiv,woocommerce-product-data,postcustom,slugdiv\";s:8:\"advanced\";s:11:\"postexcerpt\";}'),(17,1,'bglibDashboardOrder','1'),(18,1,'wpln_user-settings','libraryContent=browse&editor=html&advImgDetails=hide&editor_plain_text_paste_warning=1&posts_list_mode=excerpt&uploader=1&urlbutton=post&hidetb=1'),(19,1,'wpln_user-settings-time','1627679308'),(29,1,'jetpack_tracks_wpcom_id','137240839'),(21,1,'wpln_dashboard_quick_press_last_post_id','585'),(22,1,'community-events-location','a:1:{s:2:\"ip\";s:10:\"72.24.55.0\";}'),(23,1,'boldgrid_dismissed_admin_notices','a:2:{s:2:\"id\";s:13:\"bg-key-prompt\";s:9:\"timestamp\";i:1584592732;}'),(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:1:{i:0;s:12:\"add-post_tag\";}'),(58,1,'meta-box-order_dashboard','a:4:{s:6:\"normal\";s:172:\"boldgrid-notifications,dashboard_right_now,jetpack_summary_widget,dashboard_activity,woocommerce_dashboard_recent_reviews,woocommerce_dashboard_status,dashboard_site_health\";s:4:\"side\";s:60:\"boldgrid_news_widget,dashboard_quick_press,dashboard_primary\";s:7:\"column3\";s:0:\"\";s:7:\"column4\";s:0:\"\";}'),(27,1,'_woocommerce_tracks_anon_id','woo:Z8nT8JMmkcP4K+f5hddNzdH+'),(28,1,'wc_last_active','1652054400'),(30,1,'jetpack_tracks_anon_id','jetpack:55TxLMsj1v0g7f7xJpOLApns'),(31,1,'boldgrid_dismissed_admin_notices','a:2:{s:2:\"id\";s:23:\"boldgrid_backup_renamed\";s:9:\"timestamp\";i:1584747168;}'),(32,1,'_order_count','0'),(33,1,'nav_menu_recently_edited','22'),(34,1,'last_update','1619746887'),(38,1,'billing_first_name','KATHERINE'),(39,1,'billing_last_name','DEWEES'),(40,1,'billing_company','Baby Love Bugs LLC'),(41,1,'billing_address_1','6446 Roadrunner Lp NE'),(42,1,'billing_address_2',''),(43,1,'billing_city','Rio Rancho'),(44,1,'billing_postcode','87144'),(45,1,'billing_country','US'),(46,1,'billing_state','NM'),(47,1,'billing_phone','5055099184'),(48,1,'billing_email','babylovebugsllc@gmail.com'),(36,1,'closedpostboxes_product','a:0:{}'),(37,1,'metaboxhidden_product','a:2:{i:0;s:10:\"postcustom\";i:1;s:7:\"slugdiv\";}'),(49,1,'shipping_first_name','KATHERINE'),(50,1,'shipping_last_name','DEWEES'),(51,1,'shipping_company','Baby Love Bugs LLC'),(52,1,'shipping_address_1','6446 Roadrunner Lp NE'),(53,1,'shipping_address_2',''),(54,1,'shipping_city','Rio Rancho'),(55,1,'shipping_postcode','87144'),(56,1,'shipping_country','US'),(57,1,'shipping_state','NM'),(59,1,'_woocommerce_persistent_cart_1','a:1:{s:4:\"cart\";a:0:{}}'),(73,1,'closedpostboxes_shop_order','a:2:{i:0;s:23:\"woocommerce-order-label\";i:1;s:10:\"postcustom\";}'),(74,1,'metaboxhidden_shop_order','a:0:{}'),(60,1,'closedpostboxes_dashboard','a:6:{i:0;s:22:\"boldgrid-notifications\";i:1;s:19:\"dashboard_right_now\";i:2;s:28:\"woocommerce_dashboard_status\";i:3;s:20:\"boldgrid_news_widget\";i:4;s:21:\"dashboard_quick_press\";i:5;s:17:\"dashboard_primary\";}'),(61,1,'metaboxhidden_dashboard','a:0:{}'),(62,1,'manageedit-pagecolumnshidden','a:4:{i:0;s:6:\"author\";i:1;s:5:\"stats\";i:2;s:8:\"comments\";i:3;s:4:\"date\";}'),(63,1,'edit_page_per_page','1'),(79,1,'screen_layout_product','2'),(96,1,'woocommerce_admin_revenue_report_columns','[\"coupons\",\"taxes\",\"shipping\"]'),(97,1,'meta-box-order_shop_order','a:3:{s:4:\"side\";s:85:\"woocommerce-order-shipment-tracking,woocommerce-order-actions,woocommerce-order-notes\";s:6:\"normal\";s:109:\"woocommerce-order-label,woocommerce-order-items,woocommerce-order-data,postcustom,woocommerce-order-downloads\";s:8:\"advanced\";s:0:\"\";}'),(98,1,'screen_layout_shop_order','2'),(147,1,'session_tokens','a:3:{s:64:\"8da033aa27d3a595660e47ec5cc640f5635435669539b73d7d3410975c19acdd\";a:4:{s:10:\"expiration\";i:1652287571;s:2:\"ip\";s:11:\"72.24.55.85\";s:2:\"ua\";s:137:\"Mozilla/5.0 (iPhone; CPU iPhone OS 15_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Mobile/15E148 Safari/604.1\";s:5:\"login\";i:1652114771;}s:64:\"5b8ad716145c88437572c9412db899ba0ed5614b9ee44114ef74f6c8a8f167d4\";a:4:{s:10:\"expiration\";i:1652291283;s:2:\"ip\";s:12:\"98.60.38.123\";s:2:\"ua\";s:121:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36\";s:5:\"login\";i:1652118483;}s:64:\"288afb21a06aa7d1f7172ee109af066c6aa5538818c07ba2dfe1ed57246d831d\";a:4:{s:10:\"expiration\";i:1652292344;s:2:\"ip\";s:11:\"72.24.55.85\";s:2:\"ua\";s:119:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.1.2 Safari/605.1.15\";s:5:\"login\";i:1652119544;}}'),(130,1,'_wc_plugin_framework_facebook_for_woocommerce_dismissed_messages','a:2:{s:56:\"facebook-for-woocommerce-deprecated-wc-version-as-of-5-3\";b:1;s:56:\"facebook-for-woocommerce-deprecated-wc-version-as-of-6-1\";b:1;}');

--
-- Table structure for table `wpln_wc_admin_note_actions`
--

CREATE TABLE `wpln_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_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `query` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `actioned_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nonce_action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nonce_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`action_id`),
  KEY `note_id` (`note_id`)
) ENGINE=MyISAM AUTO_INCREMENT=468 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_admin_note_actions`
--

INSERT INTO `wpln_wc_admin_note_actions` VALUES (1,1,'connect','Connect','?page=wc-addons&section=helper','actioned',0,'',NULL,NULL),(6,5,'learn-more','Learn more','https://woocommerce.com/mobile/','actioned',0,'',NULL,NULL),(429,17,'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,'',NULL,NULL),(8,6,'tracking-opt-in','Activate usage tracking','','actioned',1,'',NULL,NULL),(9,7,'yes-please','Yes please!','https://woocommerce.us8.list-manage.com/subscribe/post?u=2c1434dc56f9506bf3c3ecd21&amp;id=13860df971&amp;SIGNUPPAGE=plugin','actioned',0,'',NULL,NULL),(10,8,'learn-more','Learn more','https://woocommerce.com/payments/','unactioned',0,'',NULL,NULL),(11,8,'install-now','Install now','','actioned',1,'',NULL,NULL),(428,16,'browse_extensions','Browse extensions','https://babylovebugs.com/wp-admin/admin.php?page=wc-admin&page=wc-addons','unactioned',1,'',NULL,NULL),(16,13,'browse','Browse','https://woocommerce.com/success-stories/','actioned',0,'',NULL,NULL),(17,14,'view-report','View report','?page=wc-admin&path=/analytics/revenue&period=custom&compare=previous_year&after=2021-09-09&before=2021-09-09','actioned',0,'',NULL,NULL),(466,15,'update-db_run','Update WooCommerce Database','https://babylovebugs.com/wp-admin/plugins.php?plugin_status=all&paged=1&s&do_update_woocommerce=true','unactioned',1,'wc_db_update','wc_db_update','wc_db_update_nonce'),(467,15,'update-db_learn-more','Learn more about updates','https://docs.woocommerce.com/document/how-to-update-woocommerce/','unactioned',0,'',NULL,NULL),(430,18,'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,'',NULL,NULL),(431,19,'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,'',NULL,NULL),(432,20,'set-up-concierge','Schedule free session','https://wordpress.com/me/concierge','actioned',1,'',NULL,NULL),(433,21,'learn-more','Learn more','https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox','unactioned',1,'',NULL,NULL),(434,22,'learn-more-ecomm-unique-shopping-experience','Learn more','https://docs.woocommerce.com/document/product-add-ons/?utm_source=inbox','actioned',1,'',NULL,NULL),(435,23,'watch-the-webinar','Watch the webinar','https://youtu.be/V_2XtCOyZ7o','actioned',1,'',NULL,NULL),(436,24,'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,'',NULL,NULL),(437,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,'',NULL,NULL),(438,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,'',NULL,NULL),(439,27,'qualitative-feedback-from-new-users','Share feedback','https://automattic.survey.fm/wc-pay-new','actioned',1,'',NULL,NULL),(440,28,'share-feedback','Share feedback','http://automattic.survey.fm/paypal-feedback','unactioned',1,'',NULL,NULL),(441,29,'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,'',NULL,NULL),(442,30,'update-wc-subscriptions-3-0-15','View latest version','https://babylovebugs.com/wp-admin/admin.php?page=wc-admin&page=wc-addons&section=helper','actioned',1,'',NULL,NULL),(443,31,'update-wc-core-5-4-0','How to update WooCommerce','https://docs.woocommerce.com/document/how-to-update-woocommerce/','actioned',1,'',NULL,NULL),(444,34,'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),(445,35,'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),(446,36,'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,'',NULL,NULL),(447,36,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(448,37,'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,'',NULL,NULL),(449,37,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(450,38,'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,'',NULL,NULL),(451,38,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(452,39,'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,'',NULL,NULL),(453,39,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(454,40,'share-feedback','Share feedback','https://automattic.survey.fm/store-management','unactioned',1,'',NULL,NULL),(455,41,'share-navigation-survey-feedback','Share feedback','https://automattic.survey.fm/feedback-on-woocommerce-navigation','actioned',1,'',NULL,NULL),(457,42,'woocommerce-core-paypal-march-2022-dismiss','Dismiss','','actioned',0,'',NULL,NULL),(456,42,'learn-more','Learn more','https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/','unactioned',1,'',NULL,NULL),(458,43,'learn-more','Learn more','https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/','unactioned',1,'',NULL,NULL),(459,43,'dismiss','Dismiss','','actioned',0,'',NULL,NULL),(460,44,'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,'',NULL,NULL),(461,45,'setup_task_initiative_survey_q2_2022_share_your_input','Share your input','https://t.maze.co/87390007','actioned',0,'',NULL,NULL),(462,46,'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,'',NULL,NULL),(463,47,'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,'',NULL,NULL);

--
-- Table structure for table `wpln_wc_admin_notes`
--

CREATE TABLE `wpln_wc_admin_notes` (
  `note_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'info',
  `content_data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source` varchar(200) COLLATE utf8mb4_unicode_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_ci NOT NULL DEFAULT '',
  `image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`note_id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_admin_notes`
--

INSERT INTO `wpln_wc_admin_notes` VALUES (1,'wc-admin-wc-helper-connection','info','en_US','Connect to WooCommerce.com','Connect to get important product notifications and updates.','info','{}','unactioned','woocommerce-admin','2020-03-20 20:40:32',NULL,0,'',NULL,0,1),(6,'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=\"https://babylovebugs.com/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.','info','{}','unactioned','woocommerce-admin','2020-06-26 17:27:59',NULL,0,'',NULL,0,1),(5,'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.','phone','{}','unactioned','woocommerce-admin','2020-06-26 17:27:59',NULL,0,'',NULL,0,1),(17,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(7,'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','mail','{}','unactioned','woocommerce-admin','2020-06-26 17:27:59',NULL,0,'',NULL,0,1),(8,'wc-admin-woocommerce-payments','info','en_US','Try the new way to get paid','Securely accept credit and debit cards on your site. Manage transactions without leaving your WordPress dashboard. Only with WooCommerce Payments.','credit-card','{}','unactioned','woocommerce-admin','2020-06-26 17:27:59',NULL,0,'',NULL,0,1),(16,'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.','info','{}','unactioned','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(13,'wc-admin-orders-milestone','info','en_US','Congratulations on processing 10 orders!','You\'ve hit the 10 orders milestone! Look at you go. Browse some WooCommerce success stories for inspiration.','trophy','{}','actioned','woocommerce-admin','2021-08-23 17:35:45',NULL,0,'',NULL,0,0),(14,'wc-admin-new-sales-record','info','en_US','New sales record!','Woohoo, September 9th was your record day for sales! Net Sales was $1,700.00 beating the previous record of $1,190.00 set on November 25th.','trophy','{\"old_record_date\":\"2020-11-25\",\"old_record_amt\":1190,\"new_record_date\":\"2021-09-09\",\"new_record_amt\":1700}','actioned','woocommerce-admin','2021-09-10 18:07:25',NULL,0,'',NULL,0,0),(15,'wc-update-db-reminder','update','en_US','WooCommerce database update required','WooCommerce has been updated! To keep things running smoothly, we have to update your database to the newest version. The database update process runs in the background and may take a little while, so please be patient. Advanced users can alternatively update via <a href=\"https://github.com/woocommerce/woocommerce/wiki/Upgrading-the-database-using-WP-CLI\">WP CLI</a>.','info','{}','unactioned','woocommerce-core','2022-03-18 21:46:42',NULL,0,'plain',NULL,0,0),(18,'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!','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(19,'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!','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(20,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(21,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(22,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(23,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(24,'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>.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(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.','info','{}','unactioned','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(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.','info','{}','unactioned','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(27,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(28,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(29,'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.','info','{}','unactioned','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(30,'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>.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(31,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(32,'wcpay-promo-2020-11','marketing','en_US','wcpay-promo-2020-11','wcpay-promo-2020-11','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(33,'wcpay-promo-2020-12','marketing','en_US','wcpay-promo-2020-12','wcpay-promo-2020-12','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(34,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(35,'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.','info','{}','unactioned','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(36,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(37,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(38,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(39,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(40,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(41,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(42,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(43,'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).','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(44,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(45,'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.','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(46,'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.','info','{}','unactioned','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0),(47,'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?','info','{}','pending','woocommerce.com','2022-05-09 17:56:06',NULL,0,'plain','',0,0);

--
-- Table structure for table `wpln_wc_category_lookup`
--

CREATE TABLE `wpln_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_ci;

--
-- Dumping data for table `wpln_wc_category_lookup`
--

INSERT INTO `wpln_wc_category_lookup` VALUES (15,15),(16,16),(16,17),(16,18),(16,19),(17,17),(18,18),(19,19),(20,20),(21,21),(23,23),(24,24),(25,25),(26,26),(27,27),(28,28),(29,29),(30,30),(31,31);

--
-- Table structure for table `wpln_wc_customer_lookup`
--

CREATE TABLE `wpln_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_ci NOT NULL DEFAULT '',
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_last_active` timestamp NULL DEFAULT NULL,
  `date_registered` timestamp NULL DEFAULT NULL,
  `country` char(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `postcode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `state` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`customer_id`),
  UNIQUE KEY `user_id` (`user_id`),
  KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_customer_lookup`
--

INSERT INTO `wpln_wc_customer_lookup` VALUES (1,NULL,'','Natasha','Bogner','natashab@sagebrush.church','2020-06-26 19:04:48',NULL,'US','87120','Albuquerque','NM'),(2,NULL,'','Katherine','DeWees','kathyedewees@gmail.com','2020-06-27 08:49:44',NULL,'US','87144','Rio Rancho','NM'),(3,NULL,'','Heather Roberts-Child Life','Heather Roberts-Child Life','thomas.simolaris@tmcaz.com','2020-08-12 22:12:40',NULL,'US','85712','Tucson','AZ'),(4,NULL,'','Jessica','Hagerman','jessica.hagerman@baystatehealth.org','2020-10-27 00:58:40',NULL,'US','01199','Springfield','MA'),(5,NULL,'','Lanette','Gammage','GammageLR@archildrens.org','2020-10-27 23:13:06',NULL,'US','72202','Little Rock','AR'),(6,NULL,'','BCH','Purchasing','gianna.costello@childrens.harvard.edu','2021-03-16 23:04:56',NULL,'US','02115','Boston','MA'),(7,NULL,'','Kristen','Johnson','kristenromig@att.net','2021-04-20 01:07:06',NULL,'US','75071','McKinney','TX'),(8,NULL,'','Evan','O\'Neill','evan.oneill@childrens.harvard.edu','2021-08-23 21:02:57',NULL,'US','02115','Boston','MA'),(9,NULL,'','Steve','Gosselin','sgosselin@phoenixchildrens.com','2021-09-03 20:28:57',NULL,'US','85016','Phoenix','AZ'),(10,NULL,'','Terri','Nivens','terri.nivens@atriumhealth.org','2021-09-09 20:26:54',NULL,'US','28207','Charlotte','NC'),(11,NULL,'','Heather','Silva','heather.silva@atriumhealth.org','2021-11-01 15:54:42',NULL,'US','28203','Charlotte','NC'),(12,NULL,'','Ashley','Ochs','Ashley.Ochs@integrisok.com','2022-05-09 20:01:40',NULL,'US','73160','Moore','OK');

--
-- Table structure for table `wpln_wc_download_log`
--

CREATE TABLE `wpln_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_ci DEFAULT '',
  PRIMARY KEY (`download_log_id`),
  KEY `permission_id` (`permission_id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_download_log`
--


--
-- Table structure for table `wpln_wc_order_coupon_lookup`
--

CREATE TABLE `wpln_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_ci;

--
-- Dumping data for table `wpln_wc_order_coupon_lookup`
--


--
-- Table structure for table `wpln_wc_order_product_lookup`
--

CREATE TABLE `wpln_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_ci;

--
-- Dumping data for table `wpln_wc_order_product_lookup`
--

INSERT INTO `wpln_wc_order_product_lookup` VALUES (12,435,312,0,3,'2020-08-12 18:12:40',1,170,170,0,0,0,0),(5,430,311,0,2,'2020-06-27 04:49:44',1,170,170,0,0,0,0),(7,431,314,0,1,'2020-06-29 17:19:28',1,170,170,0,0,0,0),(9,432,313,0,1,'2020-06-30 17:46:50',1,170,170,0,0,0,0),(10,432,311,0,1,'2020-06-30 17:46:50',1,170,170,0,0,0,0),(16,438,314,0,4,'2020-10-26 20:58:40',1,170,170,0,0,0,0),(18,440,313,0,5,'2020-10-27 19:13:06',1,170,170,0,0,0,0),(20,443,312,0,5,'2020-11-25 16:16:44',7,1190,1190,0,0,0,0),(22,450,314,0,6,'2021-03-16 19:04:56',1,170,170,0,0,0,0),(24,455,313,0,7,'2021-04-19 21:07:06',1,170,170,0,0,0,0),(26,570,313,0,8,'2021-08-23 17:02:57',1,170,170,0,0,0,0),(28,572,311,0,9,'2021-09-03 16:28:57',1,170,170,0,0,0,0),(30,574,314,0,10,'2021-09-09 16:26:54',5,850,850,0,0,0,0),(31,574,313,0,10,'2021-09-09 16:26:54',5,850,850,0,0,0,0),(33,578,547,0,11,'2021-11-01 11:54:42',3,540,540,0,0,0,0),(35,584,547,0,12,'2022-05-09 16:01:40',1,180,180,0,0,0,0);

--
-- Table structure for table `wpln_wc_order_stats`
--

CREATE TABLE `wpln_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_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_ci;

--
-- Dumping data for table `wpln_wc_order_stats`
--

INSERT INTO `wpln_wc_order_stats` VALUES (435,0,'2020-08-12 18:12:40','2020-08-12 18:12:40',1,170,0,0,170,0,'wc-completed',3),(430,0,'2020-06-27 04:49:44','2020-06-27 04:49:44',1,170,0,0,170,0,'wc-completed',2),(431,0,'2020-06-29 17:19:28','2020-06-29 17:19:28',1,170,0,0,170,0,'wc-completed',1),(432,0,'2020-06-30 17:46:50','2020-06-30 17:46:50',2,340,0,0,340,1,'wc-completed',1),(438,0,'2020-10-26 20:58:40','2020-10-26 20:58:40',1,170,0,0,170,0,'wc-completed',4),(440,0,'2020-10-27 19:13:06','2020-10-27 19:13:06',1,170,0,0,170,0,'wc-completed',5),(443,0,'2020-11-25 16:16:44','2020-11-25 16:16:44',7,1190,0,0,1190,1,'wc-completed',5),(450,0,'2021-03-16 19:04:56','2021-03-16 19:04:56',1,170,0,0,170,0,'wc-completed',6),(455,0,'2021-04-19 21:07:06','2021-04-19 21:07:06',1,170,0,0,170,0,'wc-completed',7),(570,0,'2021-08-23 17:02:57','2021-08-23 17:02:57',1,170,0,0,170,0,'wc-completed',8),(572,0,'2021-09-03 16:28:57','2021-09-03 16:28:57',1,170,0,0,170,0,'wc-completed',9),(574,0,'2021-09-09 16:26:54','2021-09-09 16:26:54',10,1700,0,0,1700,0,'wc-completed',10),(578,0,'2021-11-01 11:54:42','2021-11-01 11:54:42',3,540,0,0,540,0,'wc-completed',11),(584,0,'2022-05-09 16:01:40','2022-05-09 16:01:40',1,180,0,0,180,0,'wc-on-hold',12);

--
-- Table structure for table `wpln_wc_order_tax_lookup`
--

CREATE TABLE `wpln_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_ci;

--
-- Dumping data for table `wpln_wc_order_tax_lookup`
--


--
-- Table structure for table `wpln_wc_product_attributes_lookup`
--

CREATE TABLE `wpln_wc_product_attributes_lookup` (
  `product_id` bigint(20) NOT NULL,
  `product_or_parent_id` bigint(20) NOT NULL,
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `term_id` bigint(20) NOT NULL,
  `is_variation_attribute` tinyint(1) NOT NULL,
  `in_stock` tinyint(1) NOT NULL,
  PRIMARY KEY (`product_or_parent_id`,`term_id`,`product_id`,`taxonomy`),
  KEY `is_variation_attribute_term_id` (`is_variation_attribute`,`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_product_attributes_lookup`
--


--
-- Table structure for table `wpln_wc_product_download_directories`
--

CREATE TABLE `wpln_wc_product_download_directories` (
  `url_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`url_id`),
  KEY `url` (`url`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_product_download_directories`
--


--
-- Table structure for table `wpln_wc_product_meta_lookup`
--

CREATE TABLE `wpln_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) COLLATE utf8mb4_unicode_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_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_ci DEFAULT 'taxable',
  `tax_class` varchar(100) COLLATE utf8mb4_unicode_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_ci;

--
-- Dumping data for table `wpln_wc_product_meta_lookup`
--

INSERT INTO `wpln_wc_product_meta_lookup` VALUES (145,'woo-vneck-tee',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(146,'woo-hoodie',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(147,'woo-hoodie-with-logo',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(148,'woo-tshirt',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(149,'woo-beanie',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(150,'woo-belt',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(151,'woo-cap',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(152,'woo-sunglasses',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(153,'woo-hoodie-with-pocket',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(154,'woo-hoodie-with-zipper',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(155,'woo-long-sleeve-tee',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(156,'woo-polo',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(157,'woo-album',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(158,'woo-single',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(159,'woo-vneck-tee-red',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(160,'woo-vneck-tee-green',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(161,'woo-vneck-tee-blue',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(162,'woo-hoodie-red',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(163,'woo-hoodie-green',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(164,'woo-hoodie-blue',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(165,'Woo-tshirt-logo',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(166,'Woo-beanie-logo',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(167,'logo-collection',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(168,'wp-pennant',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(169,'woo-hoodie-blue-logo',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(314,'BLB-01',0,0,170.0000,170.0000,0,10,'instock',0,0.00,8,'taxable',''),(313,'BLB-04',0,0,170.0000,170.0000,0,8,'instock',0,0.00,9,'taxable',''),(312,'BLB-03',0,0,170.0000,170.0000,0,4,'instock',0,0.00,8,'taxable',''),(290,'001',0,0,200.0000,200.0000,0,0,'outofstock',0,0.00,0,'taxable',''),(291,'002',0,0,200.0000,200.0000,0,0,'outofstock',0,0.00,0,'taxable',''),(292,'',0,0,200.0000,200.0000,0,0,'outofstock',0,0.00,0,'taxable',''),(311,'BLB-02',0,0,170.0000,170.0000,0,7,'instock',0,0.00,3,'taxable',''),(398,'',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(363,'',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(387,'',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(401,'',0,0,0.0000,0.0000,0,NULL,'instock',0,0.00,0,'taxable',''),(402,'BLB',0,0,0.0000,0.0000,0,NULL,'outofstock',0,0.00,0,'taxable',''),(466,'MRC-01',0,0,180.0000,180.0000,0,4,'instock',0,0.00,0,'taxable',''),(493,'VSR1',0,0,15.0000,15.0000,0,10,'instock',0,0.00,0,'taxable',''),(542,'MRC-1',0,0,180.0000,180.0000,0,4,'instock',0,0.00,0,'taxable',''),(543,'MRC-02',0,0,0.0000,0.0000,0,3,'instock',0,0.00,0,'taxable',''),(547,'MRC-01',0,0,180.0000,180.0000,0,0,'outofstock',0,0.00,4,'taxable',''),(548,'MRC-02',0,0,180.0000,180.0000,0,3,'instock',0,0.00,0,'taxable','');

--
-- Table structure for table `wpln_wc_rate_limits`
--

CREATE TABLE `wpln_wc_rate_limits` (
  `rate_limit_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rate_limit_key` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate_limit_expiry` bigint(20) unsigned NOT NULL,
  `rate_limit_remaining` smallint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`rate_limit_id`),
  UNIQUE KEY `rate_limit_key` (`rate_limit_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_rate_limits`
--


--
-- Table structure for table `wpln_wc_reserved_stock`
--

CREATE TABLE `wpln_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_ci;

--
-- Dumping data for table `wpln_wc_reserved_stock`
--


--
-- Table structure for table `wpln_wc_tax_rate_classes`
--

CREATE TABLE `wpln_wc_tax_rate_classes` (
  `tax_rate_class_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_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_ci;

--
-- Dumping data for table `wpln_wc_tax_rate_classes`
--

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

--
-- Table structure for table `wpln_wc_webhooks`
--

CREATE TABLE `wpln_wc_webhooks` (
  `webhook_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `delivery_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `topic` varchar(200) COLLATE utf8mb4_unicode_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_wc_webhooks`
--


--
-- Table structure for table `wpln_woocommerce_api_keys`
--

CREATE TABLE `wpln_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_ci DEFAULT NULL,
  `permissions` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `consumer_key` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `consumer_secret` char(43) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nonces` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `truncated_key` char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_access` datetime DEFAULT NULL,
  PRIMARY KEY (`key_id`),
  KEY `consumer_key` (`consumer_key`),
  KEY `consumer_secret` (`consumer_secret`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_woocommerce_api_keys`
--


--
-- Table structure for table `wpln_woocommerce_attribute_taxonomies`
--

CREATE TABLE `wpln_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_label` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attribute_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_orderby` varchar(20) COLLATE utf8mb4_unicode_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_ci;

--
-- Dumping data for table `wpln_woocommerce_attribute_taxonomies`
--

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

--
-- Table structure for table `wpln_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `wpln_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `download_id` varchar(36) COLLATE utf8mb4_unicode_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_ci NOT NULL,
  `user_email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_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_ci;

--
-- Dumping data for table `wpln_woocommerce_downloadable_product_permissions`
--


--
-- Table structure for table `wpln_woocommerce_log`
--

CREATE TABLE `wpln_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_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `context` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`log_id`),
  KEY `level` (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_woocommerce_log`
--


--
-- Table structure for table `wpln_woocommerce_order_itemmeta`
--

CREATE TABLE `wpln_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_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `order_item_id` (`order_item_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=MyISAM AUTO_INCREMENT=292 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_woocommerce_order_itemmeta`
--

INSERT INTO `wpln_woocommerce_order_itemmeta` VALUES (103,13,'Items','Blue Baby Swing Cover &times; 1'),(101,13,'total_tax','0'),(102,13,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(100,13,'cost','0.00'),(99,13,'instance_id','1'),(98,13,'method_id','free_shipping'),(97,12,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(96,12,'_line_tax','0'),(95,12,'_line_total','170'),(94,12,'_line_subtotal_tax','0'),(93,12,'_line_subtotal','170'),(92,12,'_tax_class',''),(91,12,'_qty','1'),(90,12,'_variation_id','0'),(89,12,'_product_id','312'),(31,5,'_product_id','311'),(32,5,'_variation_id','0'),(33,5,'_qty','1'),(34,5,'_tax_class',''),(35,5,'_line_subtotal','170'),(36,5,'_line_subtotal_tax','0'),(37,5,'_line_total','170'),(38,5,'_line_tax','0'),(39,5,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(40,6,'method_id','free_shipping'),(41,6,'instance_id','1'),(42,6,'cost','0.00'),(43,6,'total_tax','0'),(44,6,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(45,6,'Items','Red Baby Swing Cover &times; 1'),(46,5,'_reduced_stock','1'),(47,7,'_product_id','314'),(48,7,'_variation_id','0'),(49,7,'_qty','1'),(50,7,'_tax_class',''),(51,7,'_line_subtotal','170'),(52,7,'_line_subtotal_tax','0'),(53,7,'_line_total','170'),(54,7,'_line_tax','0'),(55,7,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(56,8,'method_id','free_shipping'),(57,8,'instance_id','1'),(58,8,'cost','0.00'),(59,8,'total_tax','0'),(60,8,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(61,8,'Items','Lilac Baby Swing Cover &times; 1'),(62,7,'_reduced_stock','1'),(63,9,'_product_id','313'),(64,9,'_variation_id','0'),(65,9,'_qty','1'),(66,9,'_tax_class',''),(67,9,'_line_subtotal','170'),(68,9,'_line_subtotal_tax','0'),(69,9,'_line_total','170'),(70,9,'_line_tax','0'),(71,9,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(72,10,'_product_id','311'),(73,10,'_variation_id','0'),(74,10,'_qty','1'),(75,10,'_tax_class',''),(76,10,'_line_subtotal','170'),(77,10,'_line_subtotal_tax','0'),(78,10,'_line_total','170'),(79,10,'_line_tax','0'),(80,10,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(81,11,'method_id','free_shipping'),(82,11,'instance_id','1'),(83,11,'cost','0.00'),(84,11,'total_tax','0'),(85,11,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(86,11,'Items','Turquoise Baby Swing Cover &times; 1, Red Baby Swing Cover &times; 1'),(87,9,'_reduced_stock','1'),(88,10,'_reduced_stock','1'),(104,12,'_reduced_stock','1'),(129,17,'method_id','free_shipping'),(128,16,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(127,16,'_line_tax','0'),(126,16,'_line_total','170'),(125,16,'_line_subtotal_tax','0'),(124,16,'_line_subtotal','170'),(123,16,'_tax_class',''),(122,16,'_qty','1'),(121,16,'_variation_id','0'),(120,16,'_product_id','314'),(130,17,'instance_id','1'),(131,17,'cost','0.00'),(132,17,'total_tax','0'),(133,17,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(134,17,'Items','Lilac Baby Swing Cover &times; 1'),(135,16,'_reduced_stock','1'),(136,18,'_product_id','313'),(137,18,'_variation_id','0'),(138,18,'_qty','1'),(139,18,'_tax_class',''),(140,18,'_line_subtotal','170'),(141,18,'_line_subtotal_tax','0'),(142,18,'_line_total','170'),(143,18,'_line_tax','0'),(144,18,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(145,19,'method_id','free_shipping'),(146,19,'instance_id','1'),(147,19,'cost','0.00'),(148,19,'total_tax','0'),(149,19,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(150,19,'Items','Turquoise Baby Swing Cover &times; 1'),(151,18,'_reduced_stock','1'),(152,20,'_product_id','312'),(153,20,'_variation_id','0'),(154,20,'_qty','7'),(155,20,'_tax_class',''),(156,20,'_line_subtotal','1190'),(157,20,'_line_subtotal_tax','0'),(158,20,'_line_total','1190'),(159,20,'_line_tax','0'),(160,20,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(161,21,'method_id','free_shipping'),(162,21,'instance_id','1'),(163,21,'cost','0.00'),(164,21,'total_tax','0'),(165,21,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(166,21,'Items','Blue Baby Swing Cover &times; 7'),(167,20,'_reduced_stock','7'),(168,22,'_product_id','314'),(169,22,'_variation_id','0'),(170,22,'_qty','1'),(171,22,'_tax_class',''),(172,22,'_line_subtotal','170'),(173,22,'_line_subtotal_tax','0'),(174,22,'_line_total','170'),(175,22,'_line_tax','0'),(176,22,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(177,23,'method_id','free_shipping'),(178,23,'instance_id','1'),(179,23,'cost','0.00'),(180,23,'total_tax','0'),(181,23,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(182,23,'Items','Lilac Baby Swing Cover &times; 1'),(183,22,'_reduced_stock','1'),(184,24,'_product_id','313'),(185,24,'_variation_id','0'),(186,24,'_qty','1'),(187,24,'_tax_class',''),(188,24,'_line_subtotal','170'),(189,24,'_line_subtotal_tax','0'),(190,24,'_line_total','170'),(191,24,'_line_tax','0'),(192,24,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(193,25,'method_id','free_shipping'),(194,25,'instance_id','1'),(195,25,'cost','0.00'),(196,25,'total_tax','0'),(197,25,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(198,25,'Items','Turquoise Baby Swing Cover &times; 1'),(199,24,'_reduced_stock','1'),(200,26,'_product_id','313'),(201,26,'_variation_id','0'),(202,26,'_qty','1'),(203,26,'_tax_class',''),(204,26,'_line_subtotal','170'),(205,26,'_line_subtotal_tax','0'),(206,26,'_line_total','170'),(207,26,'_line_tax','0'),(208,26,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(209,27,'method_id','free_shipping'),(210,27,'instance_id','1'),(211,27,'cost','0.00'),(212,27,'total_tax','0'),(213,27,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(214,27,'Items','BLB4 Turquoise Swing Cover &times; 1'),(215,26,'_reduced_stock','1'),(216,28,'_product_id','311'),(217,28,'_variation_id','0'),(218,28,'_qty','1'),(219,28,'_tax_class',''),(220,28,'_line_subtotal','170'),(221,28,'_line_subtotal_tax','0'),(222,28,'_line_total','170'),(223,28,'_line_tax','0'),(224,28,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(225,29,'method_id','free_shipping'),(226,29,'instance_id','1'),(227,29,'cost','0.00'),(228,29,'total_tax','0'),(229,29,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(230,29,'Items','BLB2 Red Swing Cover &times; 1'),(231,28,'_reduced_stock','1'),(232,30,'_product_id','314'),(233,30,'_variation_id','0'),(234,30,'_qty','5'),(235,30,'_tax_class',''),(236,30,'_line_subtotal','850'),(237,30,'_line_subtotal_tax','0'),(238,30,'_line_total','850'),(239,30,'_line_tax','0'),(240,30,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(241,30,'Backordered','5'),(242,31,'_product_id','313'),(243,31,'_variation_id','0'),(244,31,'_qty','5'),(245,31,'_tax_class',''),(246,31,'_line_subtotal','850'),(247,31,'_line_subtotal_tax','0'),(248,31,'_line_total','850'),(249,31,'_line_tax','0'),(250,31,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(251,31,'Backordered','5'),(252,32,'method_id','free_shipping'),(253,32,'instance_id','1'),(254,32,'cost','0.00'),(255,32,'total_tax','0'),(256,32,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(257,32,'Items','BLB1 Lilac Swing Cover &times; 5, BLB4 Turquoise Swing Cover &times; 5'),(258,30,'_reduced_stock','5'),(259,31,'_reduced_stock','5'),(260,33,'_product_id','547'),(261,33,'_variation_id','0'),(262,33,'_qty','3'),(263,33,'_tax_class',''),(264,33,'_line_subtotal','540'),(265,33,'_line_subtotal_tax','0'),(266,33,'_line_total','540'),(267,33,'_line_tax','0'),(268,33,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(269,34,'method_id','free_shipping'),(270,34,'instance_id','1'),(271,34,'cost','0.00'),(272,34,'total_tax','0'),(273,34,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(274,34,'Items','MRC Cornflower &times; 3'),(275,33,'_reduced_stock','3'),(276,35,'_product_id','547'),(277,35,'_variation_id','0'),(278,35,'_qty','1'),(279,35,'_tax_class',''),(280,35,'_line_subtotal','180'),(281,35,'_line_subtotal_tax','0'),(282,35,'_line_total','180'),(283,35,'_line_tax','0'),(284,35,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(285,36,'method_id','free_shipping'),(286,36,'instance_id','1'),(287,36,'cost','0.00'),(288,36,'total_tax','0'),(289,36,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(290,36,'Items','MRC Cornflower &times; 1'),(291,35,'_reduced_stock','1');

--
-- Table structure for table `wpln_woocommerce_order_items`
--

CREATE TABLE `wpln_woocommerce_order_items` (
  `order_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_item_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `order_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_woocommerce_order_items`
--

INSERT INTO `wpln_woocommerce_order_items` VALUES (13,'Free shipping','shipping',435),(12,'Blue Baby Swing Cover','line_item',435),(5,'Red Baby Swing Cover','line_item',430),(6,'Free shipping','shipping',430),(7,'Lilac Baby Swing Cover','line_item',431),(8,'Free shipping','shipping',431),(9,'Turquoise Baby Swing Cover','line_item',432),(10,'Red Baby Swing Cover','line_item',432),(11,'Free shipping','shipping',432),(16,'Lilac Baby Swing Cover','line_item',438),(17,'Free shipping','shipping',438),(18,'Turquoise Baby Swing Cover','line_item',440),(19,'Free shipping','shipping',440),(20,'Blue Baby Swing Cover','line_item',443),(21,'Free shipping','shipping',443),(22,'Lilac Baby Swing Cover','line_item',450),(23,'Free shipping','shipping',450),(24,'Turquoise Baby Swing Cover','line_item',455),(25,'Free shipping','shipping',455),(26,'BLB4 Turquoise Swing Cover','line_item',570),(27,'Free shipping','shipping',570),(28,'BLB2 Red Swing Cover','line_item',572),(29,'Free shipping','shipping',572),(30,'BLB1 Lilac Swing Cover','line_item',574),(31,'BLB4 Turquoise Swing Cover','line_item',574),(32,'Free shipping','shipping',574),(33,'MRC Cornflower','line_item',578),(34,'Free shipping','shipping',578),(35,'MRC Cornflower','line_item',584),(36,'Free shipping','shipping',584);

--
-- Table structure for table `wpln_woocommerce_payment_tokenmeta`
--

CREATE TABLE `wpln_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_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  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_ci;

--
-- Dumping data for table `wpln_woocommerce_payment_tokenmeta`
--


--
-- Table structure for table `wpln_woocommerce_payment_tokens`
--

CREATE TABLE `wpln_woocommerce_payment_tokens` (
  `token_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gateway_id` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `type` varchar(200) COLLATE utf8mb4_unicode_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_ci;

--
-- Dumping data for table `wpln_woocommerce_payment_tokens`
--


--
-- Table structure for table `wpln_woocommerce_shipping_zone_locations`
--

CREATE TABLE `wpln_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_ci NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `location_id` (`location_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_woocommerce_shipping_zone_locations`
--

INSERT INTO `wpln_woocommerce_shipping_zone_locations` VALUES (1,1,'US','country');

--
-- Table structure for table `wpln_woocommerce_shipping_zone_methods`
--

CREATE TABLE `wpln_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_ci NOT NULL,
  `method_order` bigint(20) unsigned NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`instance_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_woocommerce_shipping_zone_methods`
--

INSERT INTO `wpln_woocommerce_shipping_zone_methods` VALUES (1,1,'free_shipping',1,1);

--
-- Table structure for table `wpln_woocommerce_shipping_zones`
--

CREATE TABLE `wpln_woocommerce_shipping_zones` (
  `zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zone_order` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpln_woocommerce_shipping_zones`
--

INSERT INTO `wpln_woocommerce_shipping_zones` VALUES (1,'US',0);

--
-- Table structure for table `wpln_woocommerce_tax_rate_locations`
--

CREATE TABLE `wpln_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_rate_id` bigint(20) unsigned NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_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_ci;

--
-- Dumping data for table `wpln_woocommerce_tax_rate_locations`
--


--
-- Table structure for table `wpln_woocommerce_tax_rates`
--

CREATE TABLE `wpln_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_rate_country` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_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_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_ci;

--
-- Dumping data for table `wpln_woocommerce_tax_rates`
--


--
-- Table structure for table `wpln_wpforms_lite`
--

CREATE TABLE `wpln_wpforms_lite` (
  `rid` int(10) NOT NULL AUTO_INCREMENT,
  `start` bigint(20) NOT NULL,
  `end` bigint(20) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT 1,
  `date` int(10) NOT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpln_wpforms_lite`
--



