-- Table structure for table `wpep_wc_admin_note_actions`
--

CREATE TABLE `wpep_wc_admin_note_actions` (
  `action_id` bigint(20) UNSIGNED NOT NULL,
  `note_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `query` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `actioned_text` varchar(255) NOT NULL,
  `nonce_action` varchar(255) DEFAULT NULL,
  `nonce_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpep_wc_admin_note_actions`
--

INSERT INTO `wpep_wc_admin_note_actions` (`action_id`, `note_id`, `name`, `label`, `query`, `status`, `actioned_text`, `nonce_action`, `nonce_name`) VALUES
(1, 1, 'notify-refund-returns-page', 'Edit page', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/post.php?post=11&action=edit', 'actioned', '', NULL, NULL),
(78, 54, 'setup-instructions', 'Setup Instructions', 'https://woocommerce.com/document/woocommerce-paypal-payments/fraud-and-disputes/?utm_source=inbox_note&utm_medium=product&utm_campaign=setup-instructions#section-4', 'unactioned', '', NULL, NULL),
(79, 54, 'activate-now', 'Activate Now', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=integration&section=ppcp-recaptcha', 'unactioned', '', NULL, NULL),
(160, 56, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_medium=product', 'actioned', '', NULL, NULL),
(239, 57, 'view-payment-gateways', 'Learn more', 'https://woocommerce.com/product-category/woocommerce-extensions/payment-gateways/?utm_medium=product', 'actioned', '', NULL, NULL),
(397, 59, 'tracking-opt-in', 'Activate usage tracking', '', 'actioned', 'Usage tracking activated', NULL, NULL),
(1032, 61, 'Googleupdate_q1_2026', 'Get started with Google', 'https://woocommerce.com/products/google-listings-and-ads/?utm_source=inbox_note&utm_medium=product&utm_campaign=Googleupdate_q1_2026', 'unactioned', '', NULL, NULL),
(1577, 55, 'setup-instructions', 'Setup Instructions', 'https://woocommerce.com/document/woocommerce-paypal-payments/fraud-and-disputes/?utm_source=inbox_note&utm_medium=product&utm_campaign=setup-instructions#section-4', 'unactioned', '', NULL, NULL),
(1578, 55, 'activate-now', 'Activate Now', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=integration&section=ppcp-recaptcha', 'unactioned', '', NULL, NULL),
(1808, 63, 'RIN-WC-Security-Update-admin-update-March-2026', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/update-core.php?', 'unactioned', '', NULL, NULL),
(2424, 64, 'USPS_Scan_Form_Mar2026_button', 'Learn More', 'https://woocommerce.com/document/woocommerce-shipping/?utm_source=inbox_note&utm_medium=product&utm_campaign=USPS_Scan_Form_Mar2026_button#USPS-scan-forms', 'unactioned', '', NULL, NULL),
(2425, 65, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/pre-launch-checklist-the-essentials/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(3502, 58, 'reddit_q1_2026', 'Get started with Reddit for WooCommerce', 'https://woocommerce.com/products/reddit/?utm_source=inbox_note&utm_medium=product&utm_campaign=reddit_q1_2026', 'actioned', '', NULL, NULL),
(4041, 66, 'usps-surcharge-apr2026-cta', 'Learn More', 'https://about.usps.com/newsroom/national-releases/2026/0325-usps-announces-transportation-related-time-limited-price-change.htm', 'unactioned', '', NULL, NULL),
(4042, 67, 'view-report', 'View report', '?page=wc-admin&path=/analytics/revenue&period=custom&compare=previous_year&after=2026-04-23&before=2026-04-23', 'actioned', '', NULL, NULL),
(4121, 69, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(4676, 68, 'stripe-woo-gateway-update-april2026', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(4677, 68, 'stripe-woo-gateway-update-april2026', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5069, 62, 'scheduled-updates-enable', 'Enable', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-admin', 'actioned', 'Scheduled updates enabled', NULL, NULL),
(5070, 60, 'learn-more', 'Learn more', 'https://woocommerce.com/payments/?utm_medium=product', 'unactioned', '', NULL, NULL),
(5071, 60, 'get-started', 'Get started', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-admin&action=setup-woocommerce-payments', 'actioned', '', 'setup-woocommerce-payments', ''),
(5290, 70, 'klaviyo_q2_2026', 'Get started', 'https://www.klaviyo.com/login?next=/customer-hub/get-started', 'unactioned', '', NULL, NULL),
(5457, 2, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/ecommerce-shipping-solutions-guide/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more', 'actioned', '', NULL, NULL),
(5458, 3, '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', '', NULL, NULL),
(5459, 4, 'qualitative-feedback-from-new-users', 'Share feedback', 'https://automattic.survey.fm/woopayments-new-user-feedback', 'actioned', '', NULL, NULL),
(5460, 5, 'share-feedback', 'Share feedback', 'http://automattic.survey.fm/paypal-feedback', 'unactioned', '', NULL, NULL),
(5461, 6, 'get-started', 'Get started', 'https://woocommerce.com/products/google-listings-and-ads?utm_source=inbox_note&utm_medium=product&utm_campaign=get-started', 'actioned', '', NULL, NULL),
(5462, 7, 'update-wc-subscriptions-3-0-15', 'View latest version', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/&page=wc-addons&section=helper', 'actioned', '', NULL, NULL),
(5463, 8, 'update-wc-core-5-4-0', 'How to update WooCommerce', 'https://docs.woocommerce.com/document/how-to-update-woocommerce/', 'actioned', '', NULL, NULL),
(5464, 11, 'ppxo-pps-install-paypal-payments-1', 'View upgrade guide', 'https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/', 'actioned', '', NULL, NULL),
(5465, 12, 'ppxo-pps-install-paypal-payments-2', 'View upgrade guide', 'https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/', 'actioned', '', NULL, NULL),
(5466, 13, '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', '', NULL, NULL),
(5467, 13, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(5468, 14, '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', '', NULL, NULL),
(5469, 14, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(5470, 15, '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', '', NULL, NULL),
(5471, 15, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(5472, 16, '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', '', NULL, NULL),
(5473, 16, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(5474, 17, 'share-feedback', 'Share feedback', 'https://automattic.survey.fm/store-management', 'unactioned', '', NULL, NULL),
(5475, 18, 'learn-more', 'Learn more', 'https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/', 'unactioned', '', NULL, NULL),
(5476, 18, 'woocommerce-core-paypal-march-2022-dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(5477, 19, 'learn-more', 'Learn more', 'https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/', 'unactioned', '', NULL, NULL),
(5478, 19, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(5479, 20, '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', '', NULL, NULL),
(5480, 21, 'store_setup_survey_survey_q2_2022_share_your_thoughts', 'Tell us how it’s going', 'https://automattic.survey.fm/store-setup-survey-2022', 'actioned', '', NULL, NULL),
(5481, 22, 'needs-update-eway-payment-gateway-rin-action-button-2022-12-20', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(5482, 22, 'needs-update-eway-payment-gateway-rin-dismiss-button-2022-12-20', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5483, 23, 'updated-eway-payment-gateway-rin-action-button-2022-12-20', 'See all updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(5484, 23, 'updated-eway-payment-gateway-rin-dismiss-button-2022-12-20', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5485, 24, 'share-navigation-survey-feedback', 'Share feedback', 'https://automattic.survey.fm/new-ecommerce-plan-navigation', 'actioned', '', NULL, NULL),
(5486, 25, 'woopay-beta-merchantrecruitment-activate-04MAY23', 'Activate WooPay', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(5487, 25, 'woopay-beta-merchantrecruitment-activate-learnmore-04MAY23', 'Learn More', 'https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-activate-learnmore-04MAY23', 'unactioned', '', NULL, NULL),
(5488, 26, 'woocommerce-wcpay-march-2023-update-needed-button', 'See Blog Post', 'https://developer.woocommerce.com/2023/03/23/critical-vulnerability-detected-in-woocommerce-payments-what-you-need-to-know', 'unactioned', '', NULL, NULL),
(5489, 26, 'woocommerce-wcpay-march-2023-update-needed-dismiss-button', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5490, 27, 'tap_to_pay_iphone_q2_2023_no_wcpay', 'Simplify my payments', 'https://woocommerce.com/products/woocommerce-payments/?utm_source=inbox_note&utm_medium=product&utm_campaign=tap_to_pay_iphone_q2_2023_no_wcpay', 'actioned', '', NULL, NULL),
(5491, 28, 'extension-settings', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(5492, 28, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5493, 29, 'woopay-beta-merchantrecruitment-update-WCPay-04MAY23', 'Update WooCommerce Payments', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(5494, 29, 'woopay-beta-merchantrecruitment-update-activate-04MAY23', 'Activate WooPay', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(5495, 30, 'woopay-beta-existingmerchants-noaction-documentation-27APR23', 'Documentation', 'https://woocommerce.com/document/woopay-merchant-documentation/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-existingmerchants-noaction-documentation-27APR23', 'actioned', '', NULL, NULL),
(5496, 31, 'woopay-beta-existingmerchants-update-WCPay-27APR23', 'Update WooCommerce Payments', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'actioned', '', NULL, NULL),
(5497, 32, 'woopay-beta-merchantrecruitment-short-activate-04MAY23', 'Activate WooPay', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(5498, 32, 'woopay-beta-merchantrecruitment-short-activate-learnmore-04MAY23', 'Learn More', 'https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-04MAY23', 'actioned', '', NULL, NULL),
(5499, 33, 'woopay-beta-merchantrecruitment-short-update-WCPay-04MAY23', 'Update WooCommerce Payments', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(5500, 33, 'woopay-beta-merchantrecruitment-short-update-activate-04MAY23', 'Activate WooPay', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(5501, 34, 'woopay-beta-merchantrecruitment-short-activate-button-09MAY23', 'Activate WooPay', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(5502, 34, 'woopay-beta-merchantrecruitment-short-activate-learnmore-button2-09MAY23', 'Learn More', 'https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-button2-09MAY23', 'unactioned', '', NULL, NULL),
(5503, 35, 'woopay-beta-merchantrecruitment-short-update-WCPay-09MAY23', 'Update WooCommerce Payments', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(5504, 35, 'woopay-beta-merchantrecruitment-short-update-activate-09MAY23', 'Activate WooPay', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(5505, 36, 'woocommerce-WCSubscriptions-June-2023-updated-needed-Plugin-Settings', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(5506, 36, 'woocommerce-WCSubscriptions-June-2023-updated-needed-dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5507, 37, 'woocommerce-WCReturnsWarranty-June-2023-updated-needed', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(5508, 37, 'woocommerce-WCReturnsWarranty-June-2023-updated-needed', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5509, 38, 'woocommerce-WCOPC-June-2023-updated-needed', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'actioned', '', NULL, NULL),
(5510, 38, 'woocommerce-WCOPC-June-2023-updated-needed', 'Dismiss', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/#', 'actioned', '', NULL, NULL),
(5511, 39, 'woocommerce-WCGC-July-2023-update-needed', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(5512, 39, 'woocommerce-WCGC-July-2023-update-needed', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5513, 40, 'learn-more', 'Learn more', 'https://woocommerce.com/document/fedex/?utm_medium=product&utm_source=inbox_note&utm_campaign=learn-more#july-2023-api-outage', 'unactioned', '', NULL, NULL),
(5514, 41, 'plugin-list', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(5515, 41, 'dismiss', 'Dismiss', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/admin.php?page=wc-admin', 'actioned', '', NULL, NULL),
(5516, 42, 'woocommerce-WCStripe-Aug-2023-update-needed', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/update-core.php?', 'unactioned', '', NULL, NULL),
(5517, 42, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5518, 43, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5519, 44, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5520, 45, 'avalara_q3-2023_noAvaTax', 'Automate my sales tax', 'https://woocommerce.com/products/woocommerce-avatax/?utm_source=inbox_note&utm_medium=product&utm_campaign=avalara_q3-2023_noAvaTax', 'unactioned', '', NULL, NULL),
(5521, 46, 'woocommerce-usermeta-Sept2023-productvendors', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/plugins.php', 'unactioned', '', NULL, NULL),
(5522, 46, 'dismiss', 'Dismiss', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/#', 'actioned', '', NULL, NULL),
(5523, 47, 'woocommerce-STRIPE-Oct-2023-update-needed', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(5524, 47, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5525, 48, 'amazon-mcf-review-button-2023-12-07', 'Leave a review', 'https://woocommerce.com/products/woocommerce-amazon-fulfillment/?review&utm_source=inbox_note&utm_medium=product&utm_campaign=amazon-mcf-review-button-2023-12-07', 'actioned', '', NULL, NULL),
(5526, 48, 'amazon-mcf-support-button-2023-12-07', 'Request support', 'https://woocommerce.com/my-account/contact-support/?utm_source=inbox_note&utm_medium=product&utm_campaign=amazon-mcf-support-button-2023-12-07', 'actioned', '', NULL, NULL),
(5527, 49, 'view_docs', 'Learn about Deposit schedules', 'https://woocommerce.com/document/woopayments/deposits/deposit-schedule/?utm_source=inbox_note&utm_medium=product&utm_campaign=view_docs#available-funds', 'unactioned', '', NULL, NULL),
(5528, 50, 'sirt-woo-2024-11-xss-admin', 'See available updates', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/update-core.php?', 'unactioned', '', NULL, NULL),
(5529, 50, 'sirt-woo-2024-11-xss-admin', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(5530, 51, 'paypal-braintree-sdk-depreciation-2025-02-20-button', 'Upgrade now', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/wp-admin/plugins.php', 'actioned', '', NULL, NULL),
(5531, 52, 'uk-vat-notice-button-2025-04-30', 'Learn more about this extension', 'https://wordpress.org/plugins/eu-vat-for-woocommerce/', 'actioned', '', NULL, NULL),
(5532, 53, 'paypal-braintree-sdk-depreciation-2025-05-30-button', 'Update now', 'https://kwilliams3479.mccweb.net/add175project/wp-admin/wp-admin/plugins.php', 'unactioned', '', NULL, NULL),
(5533, 71, 'existing_square_discountcodes_gtm_q2_2026_click', 'See how it works', 'https://woocommerce.com/product-update/square-for-woocommerce-apply-your-square-discount-codes-at-checkout/?utm_source=inbox_note&utm_medium=product&utm_campaign=existing_square_discountcodes_gtm_q2_2026_click', 'actioned', '', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_category_lookup`
--

CREATE TABLE `wpep_wc_category_lookup` (
  `category_tree_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpep_wc_category_lookup`
--

INSERT INTO `wpep_wc_category_lookup` (`category_tree_id`, `category_id`) VALUES
(15, 15),
(19, 19),
(20, 20);

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_customer_lookup`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_download_log`
--

CREATE TABLE `wpep_wc_download_log` (
  `download_log_id` bigint(20) UNSIGNED NOT NULL,
  `timestamp` datetime NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_ip_address` varchar(100) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_orders`
--

CREATE TABLE `wpep_wc_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status` varchar(20) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `tax_amount` decimal(26,8) DEFAULT NULL,
  `total_amount` decimal(26,8) DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `billing_email` varchar(320) DEFAULT NULL,
  `date_created_gmt` datetime DEFAULT NULL,
  `date_updated_gmt` datetime DEFAULT NULL,
  `parent_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `payment_method_title` text DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `ip_address` varchar(100) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `customer_note` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_orders_meta`
--

CREATE TABLE `wpep_wc_orders_meta` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_order_addresses`
--

CREATE TABLE `wpep_wc_order_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `address_type` varchar(20) DEFAULT NULL,
  `first_name` text DEFAULT NULL,
  `last_name` text DEFAULT NULL,
  `company` text DEFAULT NULL,
  `address_1` text DEFAULT NULL,
  `address_2` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `state` text DEFAULT NULL,
  `postcode` text DEFAULT NULL,
  `country` text DEFAULT NULL,
  `email` varchar(320) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_order_coupon_lookup`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_order_operational_data`
--

CREATE TABLE `wpep_wc_order_operational_data` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_via` varchar(100) DEFAULT NULL,
  `woocommerce_version` varchar(20) DEFAULT NULL,
  `prices_include_tax` tinyint(1) DEFAULT NULL,
  `coupon_usages_are_counted` tinyint(1) DEFAULT NULL,
  `download_permission_granted` tinyint(1) DEFAULT NULL,
  `cart_hash` varchar(100) DEFAULT NULL,
  `new_order_email_sent` tinyint(1) DEFAULT NULL,
  `order_key` varchar(100) DEFAULT NULL,
  `order_stock_reduced` tinyint(1) DEFAULT NULL,
  `date_paid_gmt` datetime DEFAULT NULL,
  `date_completed_gmt` datetime DEFAULT NULL,
  `shipping_tax_amount` decimal(26,8) DEFAULT NULL,
  `shipping_total_amount` decimal(26,8) DEFAULT NULL,
  `discount_tax_amount` decimal(26,8) DEFAULT NULL,
  `discount_total_amount` decimal(26,8) DEFAULT NULL,
  `recorded_sales` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_order_product_lookup`
--

CREATE TABLE `wpep_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 current_timestamp(),
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_order_stats`
--

CREATE TABLE `wpep_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',
  `date_paid` datetime DEFAULT '0000-00-00 00:00:00',
  `date_completed` datetime 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(20) NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_order_tax_lookup`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_product_attributes_lookup`
--

CREATE TABLE `wpep_wc_product_attributes_lookup` (
  `product_id` bigint(20) NOT NULL,
  `product_or_parent_id` bigint(20) NOT NULL,
  `taxonomy` varchar(32) NOT NULL,
  `term_id` bigint(20) NOT NULL,
  `is_variation_attribute` tinyint(1) NOT NULL,
  `in_stock` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_product_download_directories`
--

CREATE TABLE `wpep_wc_product_download_directories` (
  `url_id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(256) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpep_wc_product_download_directories`
--

INSERT INTO `wpep_wc_product_download_directories` (`url_id`, `url`, `enabled`) VALUES
(1, 'file:///home/kwilliams3479/public_html/add175project/wp-content/uploads/woocommerce_uploads/', 1),
(2, 'https://kwilliams3479.mccweb.net/add175project/wp-content/uploads/woocommerce_uploads/', 1);

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_product_meta_lookup`
--

CREATE TABLE `wpep_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) DEFAULT '',
  `global_unique_id` varchar(100) 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) 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) DEFAULT 'taxable',
  `tax_class` varchar(100) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpep_wc_product_meta_lookup`
--

INSERT INTO `wpep_wc_product_meta_lookup` (`product_id`, `sku`, `global_unique_id`, `virtual`, `downloadable`, `min_price`, `max_price`, `onsale`, `stock_quantity`, `stock_status`, `rating_count`, `average_rating`, `total_sales`, `tax_status`, `tax_class`) VALUES
(205, '', '', 0, 0, 9.9900, 19.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(208, '', '', 0, 0, 24.9900, 24.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(233, '', '', 0, 0, 9.9900, 9.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', 'parent'),
(234, '', '', 0, 0, 19.9900, 19.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', 'parent'),
(235, '', '', 0, 0, 9.9900, 9.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', 'parent'),
(236, '', '', 0, 0, 24.9900, 24.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(245, '', '', 0, 0, 9.9900, 9.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(246, '', '', 0, 0, 9.9900, 9.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(249, '', '', 0, 0, 4.9900, 4.9900, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', '');

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_rate_limits`
--

CREATE TABLE `wpep_wc_rate_limits` (
  `rate_limit_id` bigint(20) UNSIGNED NOT NULL,
  `rate_limit_key` varchar(200) NOT NULL,
  `rate_limit_expiry` bigint(20) UNSIGNED NOT NULL,
  `rate_limit_remaining` smallint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_reserved_stock`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wc_tax_rate_classes`
--

CREATE TABLE `wpep_wc_tax_rate_classes` (
  `tax_rate_class_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpep_wc_tax_rate_classes`
--

INSERT INTO `wpep_wc_tax_rate_classes` (`tax_rate_class_id`, `name`, `slug`) VALUES
(1, 'Reduced rate', 'reduced-rate'),
(2, 'Zero rate', 'zero-rate');

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wfauditevents`
--

CREATE TABLE `wpep_wfauditevents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT '',
  `data` text NOT NULL,
  `event_time` double(14,4) NOT NULL,
  `request_id` bigint(20) UNSIGNED NOT NULL,
  `state` enum('new','sending','sent') NOT NULL DEFAULT 'new',
  `state_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wfblockediplog`
--

CREATE TABLE `wpep_wfblockediplog` (
  `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `countryCode` varchar(2) NOT NULL,
  `blockCount` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `unixday` int(10) UNSIGNED NOT NULL,
  `blockType` varchar(50) NOT NULL DEFAULT 'generic'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wfblocks7`
--

CREATE TABLE `wpep_wfblocks7` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `blockedTime` bigint(20) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `lastAttempt` int(10) UNSIGNED DEFAULT 0,
  `blockedHits` int(10) UNSIGNED DEFAULT 0,
  `expiration` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `parameters` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wpep_wfconfig`
--

CREATE TABLE `wpep_wfconfig` (
  `name` varchar(100) NOT NULL,
  `val` longblob DEFAULT NULL,
  `autoload` enum('no','yes') NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `wpep_wfconfig`
--

INSERT INTO `wpep_wfconfig` (`name`, `val`, `autoload`) VALUES
('activatingIP', 0x37332e35312e3139352e3339, 'yes'),
('actUpdateInterval', 0x32, 'yes'),
('addCacheComment', 0x30, 'yes'),
('adminUserList', 0x613a313a7b693a313b693a313b7d, 'yes'),
('advancedCommentScanning', 0x31, 'yes'),
('ajaxWatcherDisabled_admin', 0x30, 'yes'),
('ajaxWatcherDisabled_front', 0x30, 'yes'),
('alertEmails', 0x6b77696c6c69616d73333437394073747564656e74732e6d6368656e72792e656475, 'yes'),
('alertFreqTrack', 0x613a303a7b7d, 'yes'),
('alertOn_adminLogin', 0x31, 'yes'),
('alertOn_block', 0x31, 'yes'),
('alertOn_breachLogin', 0x31, 'yes'),
('alertOn_firstAdminLoginOnly', 0x30, 'yes'),
('alertOn_firstNonAdminLoginOnly', 0x30, 'yes'),
('alertOn_loginLockout', 0x31, 'yes'),
('alertOn_lostPasswdForm', 0x31, 'yes'),
('alertOn_nonAdminLogin', 0x30, 'yes'),
('alertOn_scanIssues', 0x31, 'yes'),
('alertOn_severityLevel', 0x3235, 'yes'),
('alertOn_throttle', 0x30, 'yes'),
('alertOn_update', 0x30, 'yes'),
('alertOn_wafDeactivated', 0x31, 'yes'),
('alertOn_wordfenceDeactivated', 0x31, 'yes'),
('alert_maxHourly', 0x35, 'yes'),
('allowed404s', 0x2f66617669636f6e2e69636f0a2f6170706c652d746f7563682d69636f6e2a2e706e670a2f2a4032782e706e670a2f62726f77736572636f6e6669672e786d6c, 'yes'),
('allowed404s6116Migration', 0x31, 'yes'),
('allowHTTPSCaching', 0x30, 'yes'),
('allowLegacy2FA', 0x30, 'yes'),
('allowMySQLi', 0x31, 'yes'),
('allScansScheduled', 0x613a333a7b693a303b613a323a7b733a393a2274696d657374616d70223b693a313737393134303836373b733a343a2261726773223b613a313a7b693a303b693a313737393134303836373b7d7d693a313b613a323a7b733a393a2274696d657374616d70223b693a313737393430303036373b733a343a2261726773223b613a313a7b693a303b693a313737393430303036373b7d7d693a323b613a323a7b733a393a2274696d657374616d70223b693a313737393635393236373b733a343a2261726773223b613a313a7b693a303b693a313737393635393236373b7d7d7d, 'yes'),
('apiKey', 0x33323266616633363236393430613232396634353933353932396137336638363465663633383231376461623035396461326531616636353433646165393565643465333663353038623233353330373730663335626132623737666134613536373365376661383663303463376363363935363664386130363131616335323564613466333638326531656262643865333662613539666435333066383462, 'yes'),
('auditLogMode', 0x64656661756c74, 'yes'),
('autoBlockScanners', 0x31, 'yes'),
('autoUpdate', 0x31, 'yes'),
('autoUpdateAttempts', 0x30, 'yes'),
('autoUpdateChoice', 0x31, 'yes'),
('bannedURLs', '', 'yes'),
('blockCustomText', '', 'yes'),
('blockedTime', 0x333030, 'yes'),
('blocks702Migration', 0x31, 'yes'),
('cacheType', 0x64697361626c6564, 'yes'),
('cbl_action', 0x626c6f636b, 'yes'),
('cbl_bypassRedirDest', '', 'yes'),
('cbl_bypassRedirURL', '', 'yes'),
('cbl_bypassViewURL', '', 'yes'),
('cbl_cookieVal', 0x36393866386665636432326464, 'yes'),
('cbl_loggedInBlocked', '', 'yes'),
('cbl_redirURL', '', 'yes'),
('cbl_restOfSiteBlocked', 0x31, 'yes'),
('checkSpamIP', 0x31, 'yes'),
('config701Migration', 0x31, 'yes'),
('config720Migration', 0x31, 'yes');
INSERT INTO `wpep_wfconfig` (`name`, `val`, `autoload`) VALUES
('coreHashes', 0x[encoded data, 405710 characters], 'no');
