-- Table structure for table `iamc_wc_admin_note_actions`
--

CREATE TABLE `iamc_wc_admin_note_actions` (
  `action_id` bigint UNSIGNED NOT NULL,
  `note_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `query` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `actioned_text` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `nonce_action` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `nonce_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `iamc_wc_admin_note_actions`
--

INSERT INTO `iamc_wc_admin_note_actions` (`action_id`, `note_id`, `name`, `label`, `query`, `status`, `is_primary`, `actioned_text`, `nonce_action`, `nonce_name`) VALUES
(1, 1, 'yes-please', 'Yes please!', 'https://woocommerce.us8.list-manage.com/subscribe/post?u=2c1434dc56f9506bf3c3ecd21&amp;id=13860df971&amp;SIGNUPPAGE=plugin', 'actioned', 0, '', NULL, NULL),
(2, 2, 'open-marketing-hub', 'Open marketing hub', 'https://www.iamctv.com/wp-admin/admin.php?page=wc-admin&path=/marketing', 'actioned', 0, '', NULL, NULL),
(3, 3, 'connect', 'Connect', '?page=wc-addons&section=helper', 'unactioned', 0, '', NULL, NULL),
(10272, 53, 'get-woo-commerce-payments', 'Get WooCommerce Payments', 'admin.php?page=wc-admin&action=setup-woocommerce-payments', 'actioned', 1, '', NULL, NULL),
(1592, 22, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(6, 5, 'install-jp-and-wcs-plugins', 'Install plugins', '', 'actioned', 1, '', NULL, NULL),
(7, 6, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/', 'actioned', 0, '', NULL, NULL),
(12, 9, 'share-feedback', 'Share feedback', 'https://automattic.survey.fm/new-onboarding-survey', 'actioned', 0, '', NULL, NULL),
(9, 7, 'tracking-opt-in', 'Activate usage tracking', '', 'actioned', 1, '', 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),
(13, 10, 'need-some-inspiration', 'See success stories', 'https://woocommerce.com/success-stories/?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(14, 11, 'first-product-watch-tutorial', 'Watch tutorial', 'https://www.youtube.com/watch?v=sFtXa00Jf_o&list=PLHdG8zvZd0E575Ia8Mu3w1h750YLXNfsC&index=24', 'actioned', 0, '', NULL, NULL),
(10254, 16, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox', 'unactioned', 1, '', NULL, NULL),
(120, 13, 'affirm-insight-first-sale', 'Yes', '', 'actioned', 0, 'Thanks for your feedback', NULL, NULL),
(121, 13, 'deny-insight-first-sale', 'No', '', 'actioned', 0, 'Thanks for your feedback', NULL, NULL),
(122, 14, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(10273, 54, 'get-woocommerce-payments', 'Get WooCommerce Payments', 'admin.php?page=wc-admin&action=setup-woocommerce-payments', 'actioned', 1, '', NULL, NULL),
(10253, 15, 'set-up-concierge', 'Schedule free session', 'https://wordpress.com/me/concierge', 'actioned', 1, '', NULL, NULL),
(10255, 17, 'learn-more-ecomm-unique-shopping-experience', 'Learn more', 'https://docs.woocommerce.com/document/product-add-ons/?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(2813, 37, 'visit-the-theme-marketplace', 'Visit the theme marketplace', 'https://woocommerce.com/product-category/themes/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(2762, 35, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/home-screen/?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(1266, 19, 'confirm-tax-settings_edit-tax-settings', 'Edit tax settings', 'https://www.iamctv.com/wp-admin/admin.php?page=wc-settings&tab=tax', 'unactioned', 1, '', NULL, NULL),
(2701, 21, 'install-now', 'Install now', 'admin.php?page=wc-admin&action=setup-woocommerce-payments', 'actioned', 1, '', NULL, NULL),
(10257, 25, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/ecommerce-shipping-solutions-guide/?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(2703, 24, 'install-now', 'Install now', 'admin.php?page=wc-admin&action=setup-woocommerce-payments', 'actioned', 1, '', NULL, NULL),
(10256, 26, 'watch-the-webinar', 'Watch the webinar', 'https://youtu.be/V_2XtCOyZ7o', 'actioned', 1, '', NULL, NULL),
(10251, 27, 'upgrade_now_facebook_pixel_api', 'Upgrade now', 'plugin-install.php?tab=plugin-information&plugin=&section=changelog', 'actioned', 1, '', NULL, NULL),
(10252, 28, 'learn_more_facebook_ec', 'Learn more', 'https://woocommerce.com/products/facebook/', 'unactioned', 1, '', NULL, NULL),
(10258, 29, 'boost-sales-marketing-guide', 'See marketing guide', 'https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=square-boost-sales', 'actioned', 1, '', NULL, NULL),
(10259, 30, 'grow-your-business-marketing-guide', 'See marketing guide', 'https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=square-grow-your-business', 'actioned', 1, '', NULL, NULL),
(10264, 31, 'optimizing-the-checkout-flow', 'Learn more', 'https://woocommerce.com/posts/optimizing-woocommerce-checkout?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(10265, 32, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/first-things-customize-woocommerce/?utm_source=inbox', 'unactioned', 1, '', NULL, NULL),
(10269, 50, 'get-started', 'Get started', 'https://woocommerce.com/products/google-listings-and-ads', 'actioned', 1, '', NULL, NULL),
(2723, 34, 'marketing-guide', 'See marketing guide', 'https://developer.apple.com/apple-pay/marketing/', 'actioned', 0, '', NULL, NULL),
(10262, 42, 'boost-sales-marketing-guide', 'See marketing guide', 'https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=wcpay-boost-sales', 'actioned', 1, '', NULL, NULL),
(2812, 36, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/how-to-make-your-online-store-stand-out/?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(2814, 38, 'affirm-insight-first-product-and-payment', 'Yes', '', 'actioned', 0, 'Thanks for your feedback', NULL, NULL),
(2815, 39, 'add-first-product', 'Add a product', 'https://www.iamctv.com/wp-admin/admin.php?page=wc-admin&task=products', 'actioned', 0, '', NULL, NULL),
(2816, 40, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/managing-products/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(2878, 41, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(10284, 67, 'learn-more', 'Learn more', 'https://woocommerce.com/products/bbpos-chipper2xbt-card-reader?utm_source=inbox&utm_medium=product&utm_campaign=bbpos-chipper-launch', 'unactioned', 1, '', NULL, NULL),
(5622, 58, 'jetpack-backup-woocommerce', 'Get backups', 'https://jetpack.com/upgrade/backup-woocommerce/?utm_source=inbox&#038;utm_medium=automattic_referred&#038;utm_campaign=jp_backup_to_woo', 'actioned', 0, '', NULL, NULL),
(10263, 43, 'grow-your-business-marketing-guide', 'See marketing guide', 'https://developer.apple.com/apple-pay/marketing/?utm_source=inbox&utm_campaign=wcpay-grow-your-business', 'actioned', 1, '', NULL, NULL),
(10261, 44, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/payments/apple-pay/?utm_source=inbox&utm_medium=product&utm_campaign=wcpay_applepay', 'actioned', 1, '', NULL, NULL),
(10250, 45, 'open_wc_paypal_payments_product_page', 'Learn more', 'https://woocommerce.com/products/woocommerce-paypal-payments/', 'actioned', 1, '', NULL, NULL),
(10260, 44, 'add-apple-pay', 'Add Apple Pay', '/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments', 'actioned', 1, '', NULL, NULL),
(10266, 46, 'qualitative-feedback-from-new-users', 'Share feedback', 'https://automattic.survey.fm/wc-pay-new', 'actioned', 1, '', NULL, NULL),
(10267, 47, 'share-feedback', 'Share feedback', 'http://automattic.survey.fm/paypal-feedback', 'unactioned', 1, '', NULL, NULL),
(10268, 48, 'learn-more', 'Learn about Instant Deposits eligibility', 'https://docs.woocommerce.com/document/payments/instant-deposits/?utm_source=inbox&utm_medium=product&utm_campaign=wcpay_instant_deposits', 'actioned', 1, '', NULL, NULL),
(10270, 49, 'update-wc-subscriptions-3-0-15', 'View latest version', 'https://www.iamctv.com/wp-admin/admin.php?page=wc-admin&page=wc-addons&section=helper', 'actioned', 1, '', NULL, NULL),
(4566, 51, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(10271, 52, 'update-wc-core-5-4-0', 'How to update WooCommerce', 'https://docs.woocommerce.com/document/how-to-update-woocommerce/', 'actioned', 1, '', NULL, NULL),
(10274, 55, '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),
(10275, 56, '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),
(10249, 57, 'eu_vat_changes_2021', 'Learn more about the EU tax regulations', 'https://woocommerce.com/posts/new-eu-vat-regulations', 'actioned', 1, '', NULL, NULL),
(6860, 64, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/pre-launch-checklist-the-essentials/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(10248, 59, 'wayflyer_q3_2021', 'Get funded', 'https://woocommerce.com/products/wayflyer/', 'actioned', 1, '', NULL, NULL),
(10277, 60, 'dismiss', 'Dismiss', '', 'actioned', 0, '', NULL, NULL),
(10279, 61, 'dismiss', 'Dismiss', '', 'actioned', 0, '', NULL, NULL),
(10281, 62, 'dismiss', 'Dismiss', '', 'actioned', 0, '', NULL, NULL),
(10283, 63, 'dismiss', 'Dismiss', '', 'actioned', 0, '', NULL, NULL),
(10276, 60, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms', 'unactioned', 1, '', NULL, NULL),
(10278, 61, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms', 'unactioned', 1, '', NULL, NULL),
(10280, 62, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms', 'unactioned', 1, '', NULL, NULL),
(10282, 63, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=vulnerability_comms', 'unactioned', 1, '', NULL, NULL),
(8058, 66, 'mercadopago_q3_2021_EN', 'Free download', 'https://woocommerce.com/products/mercado-pago-checkout/?utm_source=inbox&utm_medium=product&utm_campaign=mercadopago_q3_2021_EN', 'actioned', 1, '', NULL, NULL),
(7068, 65, 'notify-refund-returns-page', 'Edit page', 'https://www.iamctv.com/wp-admin/post.php?post=5036&action=edit', 'actioned', 0, '', NULL, NULL),
(10285, 68, 'share-feedback', 'Share feedback', 'https://automattic.survey.fm/store-management', 'unactioned', 1, '', NULL, NULL),
(10246, 69, 'browse_extensions', 'Browse extensions', 'https://www.iamctv.com/wp-admin/admin.php?page=wc-admin&page=wc-addons', 'unactioned', 1, '', NULL, NULL),
(10247, 70, 'browse_extensions', 'Browse extensions', 'https://www.iamctv.com/wp-admin/admin.php?page=wc-admin&page=wc-addons', 'unactioned', 1, '', NULL, NULL),
(10293, 12, 'update-db_done', 'Thanks!', 'https://www.iamctv.com/wp-admin/admin.php?page=stats&noheader&chart=flot-stats-data&wc-hide-notice=update', 'actioned', 1, 'woocommerce_hide_notices_nonce', 'woocommerce_hide_notices_nonce', '_wc_notice_nonce');

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

--
-- Table structure for table `iamc_wc_category_lookup`
--

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

--
-- Dumping data for table `iamc_wc_category_lookup`
--

INSERT INTO `iamc_wc_category_lookup` (`category_tree_id`, `category_id`) VALUES
(15, 15);

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

--
-- Table structure for table `iamc_wc_customer_lookup`
--

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

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

--
-- Table structure for table `iamc_wc_download_log`
--

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

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

--
-- Table structure for table `iamc_wc_order_coupon_lookup`
--

CREATE TABLE `iamc_wc_order_coupon_lookup` (
  `order_id` bigint UNSIGNED NOT NULL,
  `coupon_id` bigint NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `discount_amount` double NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `iamc_wc_order_product_lookup`
--

CREATE TABLE `iamc_wc_order_product_lookup` (
  `order_item_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `variation_id` bigint UNSIGNED NOT NULL,
  `customer_id` bigint UNSIGNED DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_qty` int 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `iamc_wc_order_stats`
--

CREATE TABLE `iamc_wc_order_stats` (
  `order_id` bigint UNSIGNED NOT NULL,
  `parent_id` bigint 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 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `customer_id` bigint UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `iamc_wc_order_tax_lookup`
--

CREATE TABLE `iamc_wc_order_tax_lookup` (
  `order_id` bigint UNSIGNED NOT NULL,
  `tax_rate_id` bigint 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `iamc_wc_product_meta_lookup`
--

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

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

--
-- Table structure for table `iamc_wc_reserved_stock`
--

CREATE TABLE `iamc_wc_reserved_stock` (
  `order_id` bigint NOT NULL,
  `product_id` bigint 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `iamc_wc_tax_rate_classes`
--

CREATE TABLE `iamc_wc_tax_rate_classes` (
  `tax_rate_class_id` bigint UNSIGNED NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `iamc_wc_tax_rate_classes`
--

INSERT INTO `iamc_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 `iamc_wc_webhooks`
--

CREATE TABLE `iamc_wc_webhooks` (
  `webhook_id` bigint UNSIGNED NOT NULL,
  `status` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `delivery_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `secret` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `topic` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `api_version` smallint NOT NULL,
  `failure_count` smallint NOT NULL DEFAULT '0',
  `pending_delivery` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `iamc_wfblockediplog`
--

CREATE TABLE `iamc_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 UNSIGNED NOT NULL DEFAULT '0',
  `unixday` int UNSIGNED NOT NULL,
  `blockType` varchar(50) NOT NULL DEFAULT 'generic'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `iamc_wfblockediplog`
--

INSERT INTO `iamc_wfblockediplog` (`IP`, `countryCode`, `blockCount`, `unixday`, `blockType`) VALUES
(0x00000000000000000000ffff3359ffd4, 'GB', 2, 19361, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 2, 19361, 'waf'),
(0x00000000000000000000ffff141903b3, 'US', 9, 19362, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19362, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19362, 'waf'),
(0x00000000000000000000ffff1460b0b7, 'US', 13, 19362, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 2, 19363, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19358, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19358, 'waf'),
(0x00000000000000000000ffffa7ebcc07, 'DE', 28, 19358, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19359, 'waf'),
(0x00000000000000000000ffff4f7c0803, 'NL', 2, 19363, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19365, 'waf'),
(0x00000000000000000000ffff1419a204, 'US', 7, 19365, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19363, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 2, 19364, 'waf'),
(0x00000000000000000000ffff287c36e2, 'US', 7, 19363, 'waf'),
(0x00000000000000000000ffffade69d7c, 'US', 2, 19363, 'waf'),
(0x00000000000000000000ffff2d213ac0, 'US', 2, 19362, 'waf'),
(0x00000000000000000000ffffc3c97be0, 'DE', 6, 19363, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19363, 'waf'),
(0x00000000000000000000ffffaa409e6d, 'AU', 1, 19366, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19366, 'waf'),
(0x00000000000000000000ffffc18e928a, 'DE', 2, 19377, 'waf'),
(0x00000000000000000000ffff2b829ab9, 'SG', 2, 19376, 'waf'),
(0x00000000000000000000ffffc21ac0f5, 'NL', 2, 19375, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 3, 19375, 'waf'),
(0x00000000000000000000ffffb9fd2a17, 'UA', 1, 19372, 'waf'),
(0x00000000000000000000ffff146bc4d3, 'IE', 2, 19372, 'waf'),
(0x00000000000000000000ffffacae6a59, 'US', 9, 19374, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 8, 19361, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19353, 'waf'),
(0x00000000000000000000ffff9f41520a, 'GB', 69, 19354, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19354, 'waf'),
(0x00000000000000000000ffffc26e7349, 'BE', 1, 19361, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19361, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 2, 19360, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19360, 'waf'),
(0x00000000000000000000ffff4f7c0803, 'NL', 2, 19362, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 2, 19358, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19359, 'waf'),
(0x00000000000000000000ffff263670f6, 'MY', 2, 19370, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19365, 'waf'),
(0x00000000000000000000ffffc21ac0e0, 'NL', 2, 19364, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19369, 'waf'),
(0x00000000000000000000ffff263659eb, 'JP', 4, 19369, 'waf'),
(0x00000000000000000000ffff2e038b83, 'LV', 1, 19369, 'waf'),
(0x00000000000000000000ffff29d8bc5c, 'DE', 4, 19369, 'waf'),
(0x00000000000000000000ffff263659eb, 'JP', 4, 19368, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19368, 'waf'),
(0x00000000000000000000ffff054bbae4, 'DE', 62, 19372, 'waf'),
(0x00000000000000000000ffff3378f2cd, 'NO', 4, 19373, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19373, 'waf'),
(0x00000000000000000000ffffc21ac0e0, 'NL', 2, 19373, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19377, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 3, 19381, 'waf'),
(0x00000000000000000000ffff39808127, 'FR', 2, 19380, 'waf'),
(0x00000000000000000000ffff65807f0a, 'ID', 2, 19379, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19371, 'waf'),
(0x00000000000000000000ffff58630c6f, 'DE', 28, 19372, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 2, 19372, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19374, 'waf'),
(0x00000000000000000000ffff55d768fd, 'DE', 1, 19374, 'waf'),
(0x00000000000000000000ffff2d5c014d, 'BR', 9, 19371, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 3, 19375, 'waf'),
(0x00000000000000000000ffffa51633ab, 'SG', 2, 19374, 'waf'),
(0x00000000000000000000ffffa877eb1e, 'SA', 33, 19375, 'waf'),
(0x00000000000000000000ffff054bcce3, 'DE', 34, 19376, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 4, 19376, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 3, 19378, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 3, 19378, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19380, 'waf'),
(0x00000000000000000000ffffc2a9af27, 'SC', 3, 19381, 'waf'),
(0x00000000000000000000ffffb9f6dd2a, 'BG', 2, 19381, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19382, 'waf'),
(0x00000000000000000000ffffc22614a1, 'UA', 1, 19351, 'waf'),
(0x00000000000000000000ffff1476a20d, 'US', 2, 19352, 'waf'),
(0x00000000000000000000ffffab161c0b, 'US', 4, 19351, 'waf'),
(0x00000000000000000000ffff1419b44a, 'US', 4, 19351, 'waf'),
(0x00000000000000000000ffff93b69a9a, 'CA', 69, 19352, 'waf'),
(0x00000000000000000000ffff142ef84c, 'US', 3, 19351, 'waf'),
(0x00000000000000000000ffffacaed1f3, 'US', 2, 19353, 'waf'),
(0x00000000000000000000ffff416cfdfc, 'FI', 28, 19355, 'waf'),
(0x00000000000000000000ffff0d5a1f3c, 'US', 2, 19354, 'waf'),
(0x00000000000000000000ffff1476802c, 'US', 2, 19362, 'waf'),
(0x00000000000000000000ffffade69d7c, 'US', 2, 19360, 'waf'),
(0x00000000000000000000ffff2de3fe16, 'PA', 78, 19366, 'waf');

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

--
-- Table structure for table `iamc_wfblocks7`
--

CREATE TABLE `iamc_wfblocks7` (
  `id` bigint UNSIGNED NOT NULL,
  `type` int 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 NOT NULL,
  `reason` varchar(255) NOT NULL,
  `lastAttempt` int UNSIGNED DEFAULT '0',
  `blockedHits` int UNSIGNED DEFAULT '0',
  `expiration` bigint UNSIGNED NOT NULL DEFAULT '0',
  `parameters` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `iamc_wfconfig`
--

CREATE TABLE `iamc_wfconfig` (
  `name` varchar(100) NOT NULL,
  `val` longblob,
  `autoload` enum('no','yes') NOT NULL DEFAULT 'yes'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `iamc_wfconfig`
--

INSERT INTO `iamc_wfconfig` (`name`, `val`, `autoload`) VALUES
('alertOn_update', 0x30, 'yes'),
('alertOn_scanIssues', 0x31, 'yes'),
('alertOn_throttle', 0x30, 'yes'),
('alertOn_block', 0x31, 'yes'),
('alertOn_loginLockout', 0x31, 'yes'),
('alertOn_breachLogin', 0x31, 'yes'),
('alertOn_lostPasswdForm', 0x31, 'yes'),
('alertOn_adminLogin', 0x31, 'yes'),
('alertOn_firstAdminLoginOnly', 0x30, 'yes'),
('alertOn_nonAdminLogin', 0x30, 'yes'),
('alertOn_firstNonAdminLoginOnly', 0x30, 'yes'),
('alertOn_wordfenceDeactivated', 0x31, 'yes'),
('alertOn_wafDeactivated', 0x31, 'yes'),
('liveTrafficEnabled', 0x30, 'yes'),
('advancedCommentScanning', 0x31, 'yes'),
('checkSpamIP', 0x31, 'yes'),
('spamvertizeCheck', 0x31, 'yes'),
('liveTraf_ignorePublishers', 0x31, 'yes'),
('liveTraf_displayExpandedRecords', 0x30, 'no'),
('scheduledScansEnabled', 0x31, 'yes'),
('lowResourceScansEnabled', 0x30, 'yes'),
('scansEnabled_checkGSB', 0x31, 'yes'),
('scansEnabled_checkHowGetIPs', 0x31, 'yes'),
('scansEnabled_core', 0x31, 'yes'),
('scansEnabled_themes', 0x30, 'yes'),
('scansEnabled_plugins', 0x30, 'yes'),
('scansEnabled_coreUnknown', 0x31, 'yes'),
('scansEnabled_malware', 0x31, 'yes'),
('scansEnabled_fileContents', 0x31, 'yes'),
('scansEnabled_fileContentsGSB', 0x31, 'yes'),
('scansEnabled_checkReadableConfig', 0x31, 'yes'),
('scansEnabled_suspectedFiles', 0x31, 'yes'),
('scansEnabled_posts', 0x31, 'yes'),
('scansEnabled_comments', 0x31, 'yes'),
('scansEnabled_suspiciousOptions', 0x31, 'yes'),
('scansEnabled_passwds', 0x31, 'yes'),
('scansEnabled_diskSpace', 0x31, 'yes'),
('scansEnabled_wafStatus', 0x31, 'yes'),
('scansEnabled_options', 0x31, 'yes'),
('scansEnabled_wpscan_fullPathDisclosure', 0x31, 'yes'),
('scansEnabled_wpscan_directoryListingEnabled', 0x31, 'yes'),
('scansEnabled_scanImages', 0x30, 'yes'),
('scansEnabled_highSense', 0x30, 'yes'),
('scansEnabled_oldVersions', 0x31, 'yes'),
('scansEnabled_suspiciousAdminUsers', 0x31, 'yes'),
('liveActivityPauseEnabled', 0x31, 'yes'),
('firewallEnabled', 0x31, 'yes'),
('autoBlockScanners', 0x31, 'yes'),
('loginSecurityEnabled', 0x31, 'yes'),
('loginSec_strongPasswds_enabled', 0x31, 'yes'),
('loginSec_breachPasswds_enabled', 0x31, 'yes'),
('loginSec_lockInvalidUsers', 0x31, 'yes'),
('loginSec_maskLoginErrors', 0x31, 'yes'),
('loginSec_blockAdminReg', 0x31, 'yes'),
('loginSec_disableAuthorScan', 0x31, 'yes'),
('loginSec_disableOEmbedAuthor', 0x30, 'yes'),
('loginSec_requireAdminTwoFactor', 0x30, 'yes'),
('notification_updatesNeeded', 0x31, 'yes'),
('notification_securityAlerts', 0x31, 'yes'),
('notification_promotions', 0x31, 'yes'),
('notification_blogHighlights', 0x31, 'yes'),
('notification_productUpdates', 0x31, 'yes'),
('notification_scanStatus', 0x31, 'yes'),
('other_hideWPVersion', 0x30, 'yes'),
('other_blockBadPOST', 0x31, 'yes'),
('other_scanComments', 0x31, 'yes'),
('other_pwStrengthOnUpdate', 0x31, 'yes'),
('other_WFNet', 0x31, 'yes'),
('other_scanOutside', 0x30, 'yes'),
('other_bypassLitespeedNoabort', 0x30, 'yes'),
('deleteTablesOnDeact', 0x30, 'yes'),
('autoUpdate', 0x31, 'yes'),
('startScansRemotely', 0x30, 'yes'),
('disableConfigCaching', 0x30, 'yes'),
('addCacheComment', 0x30, 'yes'),
('disableCodeExecutionUploads', 0x30, 'yes'),
('allowHTTPSCaching', 0x30, 'yes'),
('debugOn', 0x30, 'yes'),
('email_summary_enabled', 0x31, 'yes'),
('email_summary_dashboard_widget_enabled', 0x31, 'yes'),
('ssl_verify', 0x31, 'yes'),
('ajaxWatcherDisabled_front', 0x30, 'yes'),
('ajaxWatcherDisabled_admin', 0x30, 'yes'),
('wafAlertOnAttacks', 0x31, 'yes'),
('disableWAFIPBlocking', 0x30, 'yes'),
('showAdminBarMenu', 0x31, 'yes'),
('displayTopLevelOptions', 0x31, 'yes'),
('displayTopLevelBlocking', 0x30, 'yes'),
('displayTopLevelLiveTraffic', 0x30, 'yes'),
('displayAutomaticBlocks', 0x31, 'yes'),
('allowLegacy2FA', 0x30, 'yes'),
('scan_include_extra', '', 'yes'),
('alertEmails', 0x737570706f72744069616d6374762e636f6d, 'yes'),
('liveTraf_ignoreUsers', '', 'yes'),
('liveTraf_ignoreIPs', '', 'yes'),
('liveTraf_ignoreUA', '', 'yes'),
('maxMem', 0x323536, 'yes'),
('scan_exclude', 0x77702d636f6e74656e742f706c7567696e732f776f726470726573732d73656f2f7372632f6275696c646572732f696e64657861626c652d686f6d652d706167652d6275696c6465722e706870, 'yes'),
('scan_maxIssues', 0x31303030, 'yes'),
('scan_maxDuration', '', 'yes'),
('whitelisted', '', 'yes'),
('whitelistedServices', 0x7b7d, 'yes'),
('bannedURLs', '', 'yes'),
('maxExecutionTime', 0x30, 'yes'),
('howGetIPs', '', 'yes'),
('actUpdateInterval', 0x32, 'yes'),
('alert_maxHourly', 0x30, 'yes'),
('loginSec_userBlacklist', 0x61646d696e0a69616d6374760a69616d63747661646d696e0a696e7465726e6174696f6e616c6166726963616e6d6f7669656368616e6e656c, 'yes'),
('liveTraf_maxRows', 0x32303030, 'yes'),
('liveTraf_maxAge', 0x3330, 'yes'),
('neverBlockBG', 0x6e65766572426c6f636b5665726966696564, 'yes'),
('loginSec_countFailMins', 0x3630, 'yes'),
('loginSec_lockoutMins', 0x3836343030, 'yes'),
('loginSec_strongPasswds', 0x70756273, 'yes'),
('loginSec_breachPasswds', 0x61646d696e73, 'yes'),
('loginSec_maxFailures', 0x33, 'yes'),
('loginSec_maxForgotPasswd', 0x33, 'yes'),
('maxGlobalRequests', 0x44495341424c4544, 'yes'),
('maxGlobalRequests_action', 0x7468726f74746c65, 'yes'),
('maxRequestsCrawlers', 0x44495341424c4544, 'yes'),
('maxRequestsCrawlers_action', 0x7468726f74746c65, 'yes'),
('maxRequestsHumans', 0x44495341424c4544, 'yes'),
('maxRequestsHumans_action', 0x7468726f74746c65, 'yes'),
('max404Crawlers', 0x44495341424c4544, 'yes'),
('max404Crawlers_action', 0x7468726f74746c65, 'yes'),
('max404Humans', 0x44495341424c4544, 'yes'),
('max404Humans_action', 0x7468726f74746c65, 'yes'),
('blockedTime', 0x333030, 'yes'),
('email_summary_interval', 0x7765656b6c79, 'yes'),
('email_summary_excluded_directories', 0x77702d636f6e74656e742f63616368652c77702d636f6e74656e742f77666c6f6773, 'yes'),
('allowed404s', 0x2f66617669636f6e2e69636f0a2f6170706c652d746f7563682d69636f6e2a2e706e670a2f2a4032782e706e670a2f62726f77736572636f6e6669672e786d6c, 'yes'),
('wafAlertWhitelist', '', 'yes'),
('wafAlertInterval', 0x363030, 'yes'),
('wafAlertThreshold', 0x313030, 'yes'),
('howGetIPs_trusted_proxies', '', 'yes'),
('scanType', 0x7374616e64617264, 'yes'),
('manualScanType', 0x6f6e63654461696c79, 'yes'),
('schedStartHour', 0x3138, 'yes'),
('schedMode', 0x6175746f, 'yes'),
('cbl_loggedInBlocked', '', 'yes'),
('cbl_action', 0x626c6f636b, 'yes'),
('cbl_redirURL', '', 'yes'),
('cbl_bypassRedirURL', '', 'yes'),
('cbl_bypassRedirDest', '', 'yes'),
('cbl_bypassViewURL', '', 'yes'),
('loginSec_enableSeparateTwoFactor', '', 'yes'),
('blockCustomText', '', 'yes'),
('alertOn_severityLevel', 0x3235, 'yes'),
('apiKey', 0x3632306538663965643863313265656436356430636336343731656431303962393835666266346464393034333265616130623965383264663137633065656130653636363236383739323633313764653231373932616262653538653561623864616564616534613835343434313761346538376330633333663563313434, 'yes'),
('keyType', 0x66726565, 'yes'),
('isPaid', '', 'yes'),
('betaThreatDefenseFeed', 0x30, 'yes'),
('timeoffset_wf_updated', 0x31363538363331363933, 'yes'),
('cacheType', 0x64697361626c6564, 'yes'),
('detectProxyRecommendation', 0x52454d4f54455f41444452, 'no'),
('dismissAutoPrependNotice', 0x30, 'yes'),
('onboardingAttempt1', 0x6c6963656e7365, 'yes'),
('onboardingAttempt2', '', 'no'),
('onboardingAttempt3', '', 'no'),
('onboardingAttempt3Initial', 0x30, 'yes'),
('needsNewTour_dashboard', 0x31, 'yes'),
('needsNewTour_firewall', 0x31, 'yes'),
('needsNewTour_scan', 0x31, 'yes'),
('needsNewTour_blocking', 0x31, 'yes'),
('needsNewTour_livetraffic', 0x31, 'yes'),
('needsNewTour_loginsecurity', 0x31, 'yes'),
('needsUpgradeTour_dashboard', 0x30, 'yes'),
('needsUpgradeTour_firewall', 0x30, 'yes'),
('needsUpgradeTour_scan', 0x30, 'yes'),
('needsUpgradeTour_blocking', 0x30, 'yes'),
('needsUpgradeTour_livetraffic', 0x30, 'yes'),
('needsUpgradeTour_loginsecurity', 0x30, 'yes'),
('supportContent', 0x[encoded data, 21086 characters], 'yes'),
('supportHash', 0x62396135653332373063373637613164313739303762393930383265633039333237646333383232393634353730656163616538303333643834363434366434, 'yes');
INSERT INTO `iamc_wfconfig` (`name`, `val`, `autoload`) VALUES
('whitelistPresets', 0x[encoded data, 22158 characters], 'yes'),
('whitelistHash', 0x62663364373664633035636166383632336362336665303163316663396533303865326632656133376238323639333764383530666465333631636465666434, 'yes'),
('touppPromptNeeded', '', 'yes'),
('touppBypassNextCheck', 0x30, 'yes'),
('autoUpdateAttempts', 0x30, 'yes'),
('wfPeakMemory', 0x38333838363038, 'no'),
('previousWflogsFileList', 0x5b2261747461636b2d646174612e706870222c22636f6e6669672d6c6976657761662e706870222c2272756c65732e706870222c226970732e706870222c22636f6e6669672d73796e6365642e706870222c22636f6e6669672d7472616e7369656e742e706870222c2274656d706c6174652e706870222c22636f6e6669672e706870222c2247656f4c697465322d436f756e7472792e6d6d6462222c222e6874616363657373225d, 'yes'),
('diagnosticsWflogsRemovalHistory', 0x5b5b313631393739353837332c5b22636f6e6669672e746d702e314466726c6b225d5d2c5b313539353334363630352c5b222e6e6673303030303030303031346230343530313030303065616137225d5d5d, 'yes'),
('encKey', 0x39666438613639366234373030613537, 'yes'),
('longEncKey', 0x65346536393238663966383865373961616138356137636333333030373039346335306638623939333830373431393862393039626433613266653438656135, 'yes'),
('cbl_restOfSiteBlocked', 0x31, 'yes'),
('timeoffset_wf', 0x30, 'yes'),
('lastBlockAggregation', 0x31363734353931313539, 'yes'),
('allowed404s6116Migration', 0x31, 'yes'),
('migration636_email_summary_excluded_directories', 0x31, 'no'),
('fileContentsGSB6315Migration', 0x31, 'yes'),
('config701Migration', 0x31, 'yes'),
('blocks702Migration', 0x31, 'yes'),
('geoIPVersionHash', 0x61313231346163616331623331303961653531656165363334396662303435636566346235333334366565363538343065646266383466613066616439363737, 'yes'),
('scansEnabled_geoipSupport', 0x31, 'yes'),
('config720Migration', 0x31, 'yes'),
('waf_status', 0x656e61626c6564, 'yes'),
('detectProxyNextCheck', 0x31363731353637303933, 'no'),
('detectProxyNonce', '', 'no'),
('serverIP', 0x313635383234373035333b3136322e3231302e39372e313136, 'yes'),
('allScansScheduled', 0x613a303a7b7d, 'yes'),
('activatingIP', 0x32342e39392e3134322e3132, 'yes'),
('cbl_cookieVal', 0x35656466616536396264636538, 'yes'),
('serverDNS', 0x313637343635383530373b313532373b3139382e32332e35312e323234, 'yes'),
('adminNoticeQueue', 0x613a303a7b7d, 'yes'),
('wp_home_url', 0x68747470733a2f2f7777772e69616d6374762e636f6d, 'yes'),
('wp_site_url', 0x68747470733a2f2f7777772e69616d6374762e636f6d, 'yes'),
('dbVersion', 0x382e302e3232, 'yes'),
('lastDashboardCheck', 0x31363538363331363933, 'yes'),
('dashboardData', 0x[encoded data, 7682 characters], 'yes');
INSERT INTO `iamc_wfconfig` (`name`, `val`, `autoload`) VALUES
('tldlist', 0x[encoded data, 19826 characters], 'yes'),
('tldlistHash', 0x35353635363466306134633334633663376361326635363164613134633736363736623664363061633138633336656134666663333766633536323132666631, 'yes'),
('noc1ScanSchedule', 0x613a333a7b693a303b693a313635383736353430303b693a313b693a313635393032343630303b693a323b693a313635393238333830303b7d, 'yes'),
('showWfCentralUI', 0x31, 'yes'),
('allowMySQLi', 0x31, 'yes'),
('dbTest', 0x613a313a7b733a353a226e6f6e6365223b733a36343a2235653637636661623937326437663837633836643234323961636263643064363339353234643437356162663432613763613636306535353061613233646539223b7d, 'no'),
('vulnerabilities_plugin', 0x[encoded data, 4310 characters], 'yes'),
('scan_force_ipv4_start', 0x30, 'yes'),
('vulnerabilities_theme', 0x613a333a7b693a303b613a343a7b733a343a22736c7567223b733a393a226e6577737068657265223b733a393a22746f56657273696f6e223b733a353a22332e312e30223b733a31313a2266726f6d56657273696f6e223b733a353a22322e302e34223b733a31303a2276756c6e657261626c65223b623a303b7d693a313b613a343a7b733a343a22736c7567223b733a31353a227477656e74797477656e74796f6e65223b733a393a22746f56657273696f6e223b733a333a22312e37223b733a31313a2266726f6d56657273696f6e223b733a333a22312e36223b733a31303a2276756c6e657261626c65223b623a303b7d693a323b613a343a7b733a343a22736c7567223b733a31353a227477656e74797477656e747974776f223b733a393a22746f56657273696f6e223b733a333a22312e33223b733a31313a2266726f6d56657273696f6e223b733a333a22312e32223b733a31303a2276756c6e657261626c65223b623a303b7d7d, 'yes'),
('lastNotificationID', 0x33363639, 'no'),
('totalScansRun', 0x31303037, 'yes'),
('wfKillRequested', 0x30, 'no'),
('currentCronKey', '', 'yes'),
('wf_scanLastStatusTime', 0x30, 'yes'),
('wf_scanRunning', '', 'yes'),
('wfScanStartVersion', 0x362e302e31, 'yes'),
('lowResourceScanWaitStep', '', 'yes'),
('wfStatusStartMsgs', 0x613a303a7b7d, 'yes'),
('wf_summaryItems', 0x613a383a7b733a31323a227363616e6e6564506f737473223b693a303b733a31353a227363616e6e6564436f6d6d656e7473223b693a303b733a31323a227363616e6e656446696c6573223b693a303b733a31343a227363616e6e6564506c7567696e73223b693a303b733a31333a227363616e6e65645468656d6573223b693a303b733a31323a227363616e6e65645573657273223b693a303b733a31313a227363616e6e656455524c73223b693a303b733a31303a226c617374557064617465223b693a313635393238343130373b7d, 'yes'),
('scanStageStatuses', 0x613a31313a7b733a31333a227370616d766572746973696e67223b613a343a7b733a363a22737461747573223b733a373a227072656d69756d223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a303b7d733a343a227370616d223b613a343a7b733a363a22737461747573223b733a373a227072656d69756d223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a303b7d733a393a22626c61636b6c697374223b613a343a7b733a363a22737461747573223b733a373a227072656d69756d223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a303b7d733a363a22736572766572223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a353b7d733a373a226368616e676573223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a323b7d733a363a227075626c6963223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a323b7d733a373a226d616c77617265223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a323b7d733a373a22636f6e74656e74223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a333b7d733a383a2270617373776f7264223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a313b7d733a31333a2276756c6e65726162696c697479223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a313b7d733a373a226f7074696f6e73223b613a343a7b733a363a22737461747573223b733a373a2270656e64696e67223b733a373a2273746172746564223b693a303b733a383a2266696e6973686564223b693a303b733a383a226578706563746564223b693a323b7d7d, 'no'),
('lastScanCompleted', 0x54686572652077617320616e206572726f7220636f6e6e656374696e6720746f2074686520576f726466656e6365207363616e6e696e6720736572766572733a206355524c206572726f7220373a20, 'yes'),
('lastScanFailureType', 0x6170696661696c6564, 'yes'),
('scanTime', 0x313635393139333838392e35333535, 'yes'),
('emailedIssuesList', 0x[encoded data, 14036 characters], 'yes'),
('autoUpdateChoice', 0x31, 'yes'),
('wafStatusCallbackNonce', '', 'yes'),
('disclosureStates', 0x613a323a7b733a32303a227761662d6f7074696f6e732d616476616e636564223b623a313b733a32323a227761662d6f7074696f6e732d6272757465666f726365223b623a313b7d, 'yes'),
('totalLoginHits', 0x343533, 'yes'),
('totalLogins', 0x313437, 'yes'),
('lastAdminLogin', 0x613a363a7b733a363a22757365724944223b693a313b733a383a22757365726e616d65223b733a31343a2269616d636d616e6167656d656e74223b733a393a2266697273744e616d65223b733a343a2249414d43223b733a383a226c6173744e616d65223b733a323a225456223b733a343a2274696d65223b733a32393a225765642031317468204a616e7561727920402030333a32323a3532504d223b733a323a224950223b733a31343a2237332e3138342e3134392e313436223b7d, 'yes'),
('totalAlertsSent', 0x313437, 'yes'),
('lastEmailHash', 0x313637333436383537333a3865616164613939313362333334383436633534323763343263626563653862, 'yes'),
('originalScheduledScanStart', 0x31363539323833383030, 'yes'),
('lastScheduledScanStart', 0x31363539323834313031, 'yes');
INSERT INTO `iamc_wfconfig` (`name`, `val`, `autoload`) VALUES
('malwarePrefixes', 0x[encoded data, 391370 characters]