-- Table structure for table `wpgn_wc_tax_rate_classes`
--

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

--
-- Dumping data for table `wpgn_wc_tax_rate_classes`
--

INSERT INTO `wpgn_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 `wpgn_wc_webhooks`
--

CREATE TABLE `wpgn_wc_webhooks` (
  `webhook_id` bigint(20) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `wpgn_wfblockediplog`
--

CREATE TABLE `wpgn_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=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpgn_wfblockediplog`
--

INSERT INTO `wpgn_wfblockediplog` (`IP`, `countryCode`, `blockCount`, `unixday`, `blockType`) VALUES
(0x00000000000000000000ffff05bcd212, 'RU', 8, 18299, 'blacklist'),
(0x00000000000000000000ffffb2a364dd, 'RU', 4, 18299, 'blacklist'),
(0x00000000000000000000ffff5013c1a1, 'IT', 1, 18308, 'blacklist'),
(0x00000000000000000000ffff722034b8, 'TW', 2, 18289, 'blacklist'),
(0x00000000000000000000ffff592e4530, 'IT', 4, 18289, 'blacklist'),
(0x00000000000000000000ffff2dee7996, 'BR', 1, 18308, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18305, 'blacklist'),
(0x00000000000000000000ffffb2eee3ad, 'DE', 1, 18289, 'blacklist'),
(0x00000000000000000000ffff76188070, 'CN', 21, 18299, 'blacklist'),
(0x00000000000000000000ffff0350be80, 'US', 3, 18296, 'brute'),
(0x00000000000000000000ffffc7f9e657, 'US', 1, 18296, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 8, 18296, 'blacklist'),
(0x00000000000000000000ffffb22ddb6c, 'RU', 4, 18296, 'blacklist'),
(0x00000000000000000000ffff8b3b5728, 'IN', 1, 18298, 'blacklist'),
(0x00000000000000000000ffffa5161847, 'DE', 1, 18298, 'blacklist'),
(0x00000000000000000000ffffc16a1e63, 'UA', 20, 18296, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 16, 18320, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 28, 18299, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 22, 18298, 'blacklist'),
(0x00000000000000000000ffffd5a647f4, 'NL', 4, 18300, 'blacklist'),
(0x00000000000000000000ffffde57c626, 'CN', 1, 18299, 'blacklist'),
(0x00000000000000000000ffff334d34d8, 'PL', 4, 18298, 'blacklist'),
(0x00000000000000000000ffff58939849, 'RU', 4, 18300, 'blacklist'),
(0x00000000000000000000ffff0d34b4e8, 'US', 3, 18301, 'brute'),
(0x00000000000000000000ffff3adac922, 'CN', 40, 18301, 'blacklist'),
(0x00000000000000000000ffffc66232c9, 'US', 4, 18305, 'blacklist'),
(0x00000000000000000000ffffb280387d, 'SG', 7, 18305, 'blacklist'),
(0x00000000000000000000ffff3ed2bbdf, 'FR', 1, 18303, 'blacklist'),
(0x00000000000000000000ffff4df31a29, 'RS', 4, 18303, 'blacklist'),
(0x00000000000000000000ffff5d56fe32, 'RS', 4, 18304, 'blacklist'),
(0x00000000000000000000ffff510a03ba, 'EG', 1, 18308, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18307, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 24, 18308, 'blacklist'),
(0x00000000000000000000ffff2dee79e5, 'BR', 1, 18307, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 28, 18307, 'blacklist'),
(0x00000000000000000000ffffb0245835, 'UA', 4, 18306, 'blacklist'),
(0x00000000000000000000ffff5d5f6633, 'RU', 11, 18295, 'blacklist'),
(0x00000000000000000000ffffb280a127, 'GB', 11, 18295, 'blacklist'),
(0x00000000000000000000ffff538cdd0a, 'DE', 11, 18295, 'blacklist'),
(0x00000000000000000000ffffa061541a, 'IT', 11, 18295, 'blacklist'),
(0x00000000000000000000ffffb2eeeee9, 'DE', 11, 18294, 'blacklist'),
(0x00000000000000000000ffffbb49214c, 'BR', 1, 18294, 'blacklist'),
(0x00000000000000000000ffffa014bb8a, 'BR', 1, 18308, 'blacklist'),
(0x00000000000000000000ffffc06324b1, 'CA', 2, 18291, 'blacklist'),
(0x00000000000000000000ffff178140d3, 'US', 1, 18291, 'blacklist'),
(0x00000000000000000000ffff330f7532, 'NL', 3, 18291, 'blacklist'),
(0x00000000000000000000ffff6706c766, 'MY', 1, 18291, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 26, 18311, 'blacklist'),
(0x00000000000000000000ffff77a0806c, 'BN', 1, 18311, 'blacklist'),
(0x00000000000000000000ffff239a7fcd, 'IN', 1, 18310, 'brute'),
(0x00000000000000000000ffffca899ba0, 'LA', 1, 18309, 'blacklist'),
(0x00000000000000000000ffffd9aacd6b, 'NO', 1, 18290, 'blacklist'),
(0x00000000000000000000ffff90a8a322, 'CA', 4, 18290, 'blacklist'),
(0x00000000000000000000ffff334d34a0, 'PL', 1, 18290, 'blacklist'),
(0x00000000000000000000ffff40cab993, 'US', 2, 18290, 'blacklist'),
(0x00000000000000000000ffffb23e56d6, 'GB', 2, 18290, 'blacklist'),
(0x00000000000000000000ffff674a7b06, 'VN', 1, 18290, 'blacklist'),
(0x00000000000000000000ffff2ebc620a, 'RU', 16, 18290, 'blacklist'),
(0x00000000000000000000ffff59914a5b, 'GB', 2, 18290, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 14, 18290, 'blacklist'),
(0x00000000000000000000ffff0385f499, 'US', 4, 18290, 'blacklist'),
(0x00000000000000000000ffff33ff403a, 'FR', 2, 18289, 'blacklist'),
(0x00000000000000000000ffffa63e296c, 'US', 2, 18289, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18289, 'blacklist'),
(0x00000000000000000000ffff036a0328, 'AU', 2, 18289, 'blacklist'),
(0x00000000000000000000ffff712a7c32, 'JP', 2, 18289, 'blacklist'),
(0x00000000000000000000ffffaaf72998, 'BR', 1, 18312, 'blacklist'),
(0x00000000000000000000ffffca899ad5, 'LA', 1, 18312, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 30, 18312, 'blacklist'),
(0x00000000000000000000ffffc16a1e63, 'UA', 20, 18310, 'blacklist'),
(0x00000000000000000000ffff2f64c588, 'CN', 2, 18289, 'blacklist'),
(0x00000000000000000000ffff4d786684, 'UA', 4, 18289, 'blacklist'),
(0x00000000000000000000ffff4e6bc389, 'RU', 4, 18314, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 32, 18314, 'blacklist'),
(0x00000000000000000000ffff2ebc620a, 'RU', 4, 18312, 'blacklist'),
(0x00000000000000000000ffff334d34a0, 'PL', 1, 18312, 'waf'),
(0x00000000000000000000ffffb22dd4e3, 'RU', 4, 18312, 'blacklist'),
(0x00000000000000000000ffffadf5efe4, 'US', 4, 18311, 'blacklist'),
(0x00000000000000000000ffffc5320fbd, 'EG', 1, 18311, 'blacklist'),
(0x00000000000000000000ffff334d34a0, 'PL', 1, 18312, 'blacklist'),
(0x00000000000000000000ffff2ef3dc67, 'RU', 4, 18314, 'blacklist'),
(0x00000000000000000000ffffca899a01, 'LA', 1, 18314, 'blacklist'),
(0x00000000000000000000ffffb10a6473, 'BR', 1, 18314, 'blacklist'),
(0x00000000000000000000ffff55718107, 'RU', 4, 18313, 'blacklist'),
(0x00000000000000000000ffff59d87cfd, 'RS', 2, 18289, 'blacklist'),
(0x00000000000000000000ffff2246953e, 'US', 2, 18289, 'blacklist'),
(0x00000000000000000000ffffcebd9db7, 'SG', 2, 18289, 'blacklist'),
(0x00000000000000000000ffff44b7eef6, 'SG', 2, 18289, 'blacklist'),
(0x00000000000000000000ffffc6329ad6, 'US', 2, 18289, 'blacklist'),
(0x00000000000000000000ffffbca5e8ca, 'FR', 4, 18289, 'blacklist'),
(0x00000000000000000000ffff71ba4232, 'VN', 4, 18316, 'blacklist'),
(0x00000000000000000000ffff7cbfc877, 'AU', 1, 18316, 'blacklist'),
(0x00000000000000000000ffff5ef23616, 'RU', 4, 18316, 'blacklist'),
(0x00000000000000000000ffffc61b507b, 'CA', 2, 18288, 'blacklist'),
(0x00000000000000000000ffff5ef23616, 'RU', 4, 18317, 'blacklist'),
(0x00000000000000000000ffff2dee7981, 'BR', 1, 18316, 'blacklist'),
(0x00000000000000000000ffffc4db60a8, 'EG', 1, 18316, 'blacklist'),
(0x00000000000000000000ffffb9f427b1, 'NL', 113, 18316, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18316, 'blacklist'),
(0x00000000000000000000ffffca899a01, 'LA', 1, 18316, 'blacklist'),
(0x00000000000000000000ffffbb482a5c, 'BR', 2, 18316, 'blacklist'),
(0x00000000000000000000ffffb956a46a, 'TR', 1, 18316, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 28, 18316, 'blacklist'),
(0x00000000000000000000ffffca899a9e, 'LA', 1, 18316, 'blacklist'),
(0x00000000000000000000ffffc4db4fd0, 'EG', 1, 18315, 'blacklist'),
(0x00000000000000000000ffff2573ccd7, 'UA', 4, 18320, 'blacklist'),
(0x00000000000000000000ffffb9ced648, 'NL', 4, 18320, 'blacklist'),
(0x00000000000000000000ffffca899bcb, 'LA', 1, 18318, 'blacklist'),
(0x00000000000000000000ffff2dee7bdc, 'BR', 1, 18318, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 32, 18318, 'blacklist'),
(0x00000000000000000000ffffc16a1e63, 'UA', 20, 18317, 'blacklist'),
(0x00000000000000000000ffff735463b3, 'LA', 1, 18319, 'blacklist'),
(0x00000000000000000000ffffca899ad5, 'LA', 1, 18319, 'blacklist'),
(0x00000000000000000000ffff8a61428e, 'BR', 1, 18319, 'blacklist'),
(0x00000000000000000000ffff2dee79a5, 'BR', 1, 18319, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 30, 18319, 'blacklist'),
(0x00000000000000000000ffffb12bfb99, 'BR', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffb4b7f6ad, 'TH', 1, 18317, 'blacklist'),
(0x00000000000000000000ffff586f47b1, 'GB', 1, 18319, 'waf'),
(0x00000000000000000000ffffb2e92cc6, 'TR', 4, 18319, 'blacklist'),
(0x00000000000000000000ffff71177585, 'VN', 4, 18319, 'blacklist'),
(0x00000000000000000000ffffd07199d3, 'US', 1, 18318, 'blacklist'),
(0x00000000000000000000ffffbca5e8ca, 'FR', 4, 18288, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 16, 18288, 'blacklist'),
(0x00000000000000000000ffff5893ad0f, 'RU', 4, 18289, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 20, 18289, 'blacklist'),
(0x00000000000000000000ffffc16a1e63, 'UA', 20, 18289, 'blacklist'),
(0x00000000000000000000ffff8d62fee1, 'DK', 4, 18291, 'blacklist'),
(0x00000000000000000000ffff5c3fc5a0, 'RU', 1, 18291, 'blacklist'),
(0x00000000000000000000ffffb9dc6515, 'DE', 3, 18291, 'blacklist'),
(0x00000000000000000000ffffc7f9e652, '', 2, 18290, 'blacklist'),
(0x00000000000000000000ffffc7f9e650, 'US', 4, 18290, 'blacklist'),
(0x00000000000000000000ffff84e873d4, 'CN', 21, 18290, 'blacklist'),
(0x00000000000000000000ffff05357263, 'UA', 4, 18290, 'blacklist'),
(0x00000000000000000000ffff671c793a, 'BD', 1, 18294, 'blacklist'),
(0x00000000000000000000ffff22ec12c5, 'US', 3, 18293, 'blacklist'),
(0x00000000000000000000ffff7ba2c7ab, 'CN', 1, 18293, 'blacklist'),
(0x00000000000000000000ffff9446fc0f, 'CN', 21, 18292, 'blacklist'),
(0x00000000000000000000ffffd53dd736, 'DE', 1, 18292, 'blacklist'),
(0x00000000000000000000ffff4de8999b, 'RU', 4, 18292, 'blacklist'),
(0x00000000000000000000ffff7ba2c7ab, 'CN', 1, 18291, 'blacklist'),
(0x00000000000000000000ffffb9aed0ae, 'AL', 2, 18293, 'blacklist'),
(0x00000000000000000000ffffb9ced648, 'NL', 4, 18293, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18293, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18292, 'blacklist'),
(0x00000000000000000000ffff68c7b33e, '', 1, 18292, 'blacklist'),
(0x00000000000000000000ffffbca5e8ca, 'FR', 4, 18293, 'blacklist'),
(0x00000000000000000000ffff4d6d930a, 'CH', 311, 18293, 'blacklist'),
(0x00000000000000000000ffff8494f56a, 'US', 284, 18293, 'blacklist'),
(0x00000000000000000000ffff334d34d8, 'PL', 4, 18293, 'blacklist'),
(0x00000000000000000000ffffb2802c63, 'GB', 11, 18295, 'blacklist'),
(0x00000000000000000000ffff59167141, 'DE', 11, 18294, 'blacklist'),
(0x00000000000000000000ffff12d1facf, 'US', 11, 18294, 'blacklist'),
(0x00000000000000000000ffff330f0fa4, 'NL', 4, 18295, 'blacklist'),
(0x00000000000000000000ffffa5161847, 'DE', 1, 18296, 'blacklist'),
(0x00000000000000000000ffffb952d861, 'BG', 1, 18298, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 6, 18297, 'blacklist'),
(0x00000000000000000000ffff3adac922, 'CN', 4, 18305, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 24, 18300, 'blacklist'),
(0x00000000000000000000ffff767b06d8, 'CN', 3, 18300, 'blacklist'),
(0x00000000000000000000ffffbca5e8ca, 'FR', 4, 18299, 'blacklist'),
(0x00000000000000000000ffff767b06d8, 'CN', 3, 18301, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 26, 18301, 'blacklist'),
(0x00000000000000000000ffffddebb850, 'CN', 21, 18300, 'blacklist'),
(0x00000000000000000000ffff2f6abb07, 'CN', 2, 18301, 'blacklist'),
(0x00000000000000000000ffffc69a7053, 'US', 43, 18301, 'blacklist'),
(0x00000000000000000000ffff3adac922, 'CN', 64, 18303, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 26, 18303, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 24, 18304, 'blacklist'),
(0x00000000000000000000ffff1212f811, 'US', 4, 18304, 'blacklist'),
(0x00000000000000000000ffff3adac922, 'CN', 55, 18304, 'blacklist'),
(0x00000000000000000000ffffbc44e1b7, 'PL', 1, 18304, 'blacklist'),
(0x00000000000000000000ffffc16a1e63, 'UA', 20, 18303, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 28, 18305, 'blacklist'),
(0x00000000000000000000ffffbca5e8ca, 'FR', 4, 18304, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18304, 'blacklist'),
(0x00000000000000000000ffff05c4ee86, 'FR', 7, 18304, 'blacklist'),
(0x00000000000000000000ffffb168fe40, 'BR', 1, 18308, 'blacklist'),
(0x00000000000000000000ffffca898df3, 'LA', 1, 18308, 'blacklist'),
(0x00000000000000000000ffff2ebc620a, 'RU', 4, 18306, 'blacklist'),
(0x00000000000000000000ffff9446fc0f, 'CN', 21, 18306, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 22, 18306, 'blacklist'),
(0x00000000000000000000ffffcebd6976, 'NL', 4, 18306, 'blacklist'),
(0x00000000000000000000ffff2dee7aa0, 'BR', 1, 18307, 'blacklist'),
(0x00000000000000000000ffff31ecd64b, 'NP', 1, 18307, 'blacklist'),
(0x00000000000000000000ffff73545c7b, 'LA', 1, 18307, 'blacklist'),
(0x00000000000000000000ffff12c3fae5, 'DE', 11, 18295, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18295, 'blacklist'),
(0x00000000000000000000ffff4e6bc389, 'RU', 4, 18295, 'blacklist'),
(0x00000000000000000000ffff9e45ce4b, 'CA', 11, 18295, 'blacklist'),
(0x00000000000000000000ffffd443d61b, 'GB', 11, 18295, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 12, 18295, 'blacklist'),
(0x00000000000000000000ffffd9aefdb1, 'GB', 9, 18295, 'blacklist'),
(0x00000000000000000000ffffc1460f1b, 'FR', 11, 18295, 'blacklist'),
(0x00000000000000000000ffff86d59628, 'GB', 11, 18295, 'blacklist'),
(0x00000000000000000000ffff4d786684, 'UA', 4, 18295, 'blacklist'),
(0x00000000000000000000ffff589398b1, 'RU', 4, 18296, 'blacklist'),
(0x00000000000000000000ffffb8a81ba6, 'US', 1, 18301, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18301, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 24, 18302, 'blacklist'),
(0x00000000000000000000ffffc7f9e656, 'US', 4, 18302, 'blacklist'),
(0x00000000000000000000ffff3adac922, 'CN', 28, 18302, 'blacklist'),
(0x00000000000000000000ffff767b06d8, 'CN', 4, 18302, 'blacklist'),
(0x00000000000000000000ffff5b868cc8, 'FR', 7, 18305, 'blacklist'),
(0x00000000000000000000ffff3ed2bbdf, 'FR', 4, 18305, 'blacklist'),
(0x00000000000000000000ffff4f7e5055, 'RU', 4, 18305, 'blacklist'),
(0x00000000000000000000ffff767b06d8, 'CN', 1, 18305, 'blacklist'),
(0x00000000000000000000ffffca899a5e, 'LA', 1, 18308, 'blacklist'),
(0x00000000000000000000ffffb758e93d, 'TH', 1, 18308, 'blacklist'),
(0x00000000000000000000ffffca899b2f, 'LA', 1, 18308, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 26, 18309, 'blacklist'),
(0x00000000000000000000ffff771ba958, 'CN', 21, 18309, 'blacklist'),
(0x00000000000000000000ffffca899ad5, 'LA', 1, 18309, 'blacklist'),
(0x00000000000000000000ffff73545ccc, 'LA', 1, 18309, 'blacklist'),
(0x00000000000000000000ffff323eb1b8, 'US', 1, 18309, 'blacklist'),
(0x00000000000000000000ffffb4b7f409, 'TH', 1, 18309, 'blacklist'),
(0x00000000000000000000ffffa8e4f406, 'BR', 1, 18309, 'blacklist'),
(0x00000000000000000000ffffb758da91, 'TH', 1, 18309, 'blacklist'),
(0x00000000000000000000ffffbca5e8ca, 'FR', 4, 18309, 'blacklist'),
(0x00000000000000000000ffff73545c43, 'LA', 1, 18309, 'blacklist'),
(0x00000000000000000000ffff2dee79e1, 'BR', 1, 18309, 'blacklist'),
(0x00000000000000000000ffff73546329, 'LA', 1, 18309, 'blacklist'),
(0x00000000000000000000ffff2dee79aa, 'BR', 1, 18309, 'blacklist'),
(0x00000000000000000000ffff1fcf210a, 'FR', 3, 18309, 'blacklist'),
(0x00000000000000000000ffff44b74c9d, 'DE', 2, 18309, 'waf'),
(0x00000000000000000000ffff94460923, 'CN', 21, 18310, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 28, 18310, 'blacklist'),
(0x00000000000000000000ffffb168fe40, 'BR', 1, 18310, 'blacklist'),
(0x00000000000000000000ffffa83f13d8, 'NL', 3, 18310, 'blacklist'),
(0x00000000000000000000ffff44b74c9d, 'DE', 3, 18310, 'blacklist'),
(0x00000000000000000000ffffa32ccf36, 'VN', 3, 18310, 'blacklist'),
(0x00000000000000000000ffffc53248df, 'EG', 1, 18310, 'blacklist'),
(0x00000000000000000000ffff6dea263d, 'NL', 4, 18310, 'blacklist'),
(0x00000000000000000000ffffb946b850, 'NL', 4, 18310, 'blacklist'),
(0x00000000000000000000ffffb168fe47, 'BR', 1, 18310, 'blacklist'),
(0x00000000000000000000ffff67015d6b, 'NP', 1, 18310, 'blacklist'),
(0x00000000000000000000ffff73545c3d, 'LA', 1, 18310, 'blacklist'),
(0x00000000000000000000ffff334b902b, 'DE', 2, 18310, 'blacklist'),
(0x00000000000000000000ffffaf8e18a6, 'MY', 1, 18311, 'blacklist'),
(0x00000000000000000000ffff7c29d918, 'NP', 1, 18311, 'blacklist'),
(0x00000000000000000000ffff2dee7aad, 'BR', 1, 18311, 'blacklist'),
(0x00000000000000000000ffff9f41a2ba, 'US', 1, 18311, 'waf'),
(0x00000000000000000000ffff33fec70c, 'FR', 1, 18311, 'waf'),
(0x00000000000000000000ffff43c92105, 'US', 2, 18311, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 8, 18311, 'blacklist'),
(0x00000000000000000000ffff3ed26f7f, 'FR', 4, 18311, 'blacklist'),
(0x00000000000000000000ffff73545c89, 'LA', 1, 18312, 'blacklist'),
(0x00000000000000000000ffff03515641, 'US', 3, 18312, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 28, 18313, 'blacklist'),
(0x00000000000000000000ffffca899be4, 'LA', 1, 18313, 'blacklist'),
(0x00000000000000000000ffffa85a8555, 'BR', 1, 18313, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18313, 'blacklist'),
(0x00000000000000000000ffff589399be, 'RU', 4, 18313, 'blacklist'),
(0x00000000000000000000ffff5ef23616, 'RU', 4, 18314, 'blacklist'),
(0x00000000000000000000ffffbcf3b2d7, 'RU', 4, 18314, 'blacklist'),
(0x00000000000000000000ffff2d594281, 'RU', 1, 18314, 'waf'),
(0x00000000000000000000ffffc2b8628d, 'IT', 1, 18314, 'blacklist'),
(0x00000000000000000000ffffb4b7f57a, 'TH', 1, 18314, 'blacklist'),
(0x00000000000000000000ffff5275c2e5, 'RS', 2, 18314, 'blacklist'),
(0x00000000000000000000ffff669d8b14, 'TN', 1, 18314, 'blacklist'),
(0x00000000000000000000ffffc257626b, 'RU', 1, 18314, 'blacklist'),
(0x00000000000000000000ffff330f0fa4, 'NL', 4, 18315, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 26, 18315, 'blacklist'),
(0x00000000000000000000ffffcb99274d, 'IN', 1, 18315, 'blacklist'),
(0x00000000000000000000ffff2ebc620a, 'RU', 4, 18315, 'blacklist'),
(0x00000000000000000000ffff05bcd212, 'RU', 4, 18315, 'blacklist'),
(0x00000000000000000000ffffbca5e8ca, 'FR', 4, 18315, 'blacklist'),
(0x00000000000000000000ffffb168fe40, 'BR', 1, 18315, 'blacklist'),
(0x00000000000000000000ffff944899d3, 'US', 1, 18315, 'blacklist'),
(0x00000000000000000000ffffb168fe41, 'BR', 1, 18315, 'blacklist'),
(0x00000000000000000000ffffb5efb88d, 'AR', 8, 18316, 'blacklist'),
(0x00000000000000000000ffffc39ab659, 'FR', 26, 18317, 'blacklist'),
(0x00000000000000000000ffffc3514066, 'GB', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffca89865f, 'LA', 1, 18317, 'blacklist'),
(0x00000000000000000000ffff31ecd64b, 'NP', 1, 18317, 'blacklist'),
(0x00000000000000000000ffff811c3d42, 'CN', 21, 18317, 'blacklist'),
(0x00000000000000000000ffff25737c03, 'UA', 4, 18317, 'blacklist'),
(0x00000000000000000000ffff589399be, 'RU', 4, 18317, 'blacklist'),
(0x00000000000000000000ffffbbbdb236, 'MX', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffca899beb, 'LA', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffcf945788, 'AU', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffd9a5ccae, 'AE', 1, 18317, 'blacklist'),
(0x00000000000000000000ffff73545c02, 'LA', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffca899a9a, 'LA', 1, 18317, 'blacklist'),
(0x00000000000000000000ffff55718107, 'RU', 4, 18317, 'blacklist'),
(0x00000000000000000000ffff2ebc620a, 'RU', 4, 18317, 'blacklist'),
(0x00000000000000000000ffff735463b3, 'LA', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffcb99274b, 'IN', 1, 18317, 'blacklist'),
(0x00000000000000000000ffffb9cf8b02, 'UA', 4, 18317, 'blacklist'),
(0x00000000000000000000ffff7c29d918, 'NP', 1, 18318, 'blacklist'),
(0x00000000000000000000ffffca899a98, 'LA', 1, 18318, 'blacklist'),
(0x00000000000000000000ffff510a0313, 'EG', 1, 18318, 'blacklist'),
(0x00000000000000000000ffff4e0517ee, 'IT', 1, 18319, 'blacklist');

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

--
-- Table structure for table `wpgn_wfblocks7`
--

CREATE TABLE `wpgn_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=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `wpgn_wfconfig`
--

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

--
-- Dumping data for table `wpgn_wfconfig`
--

INSERT INTO `wpgn_wfconfig` (`name`, `val`, `autoload`) VALUES
('activatingIP', 0x37392e36392e3137322e323338, 'yes'),
('actUpdateInterval', 0x32, 'yes'),
('addCacheComment', 0x30, 'yes'),
('adminNoticeQueue', 0x613a303a7b7d, 'yes'),
('adminUserList', 0x613a323a7b693a323b693a313b693a3335343b693a313b7d, 'yes'),
('advancedCommentScanning', 0x31, 'yes'),
('ajaxWatcherDisabled_admin', 0x30, 'yes'),
('ajaxWatcherDisabled_front', 0x30, 'yes'),
('alertEmails', 0x6d61726b2e666d6540676d61696c2e636f6d, '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', 0x30, 'yes'),
('allowed404s', 0x2f66617669636f6e2e69636f0a2f6170706c652d746f7563682d69636f6e2a2e706e670a2f2a4032782e706e670a2f62726f77736572636f6e6669672e786d6c, 'yes'),
('allowed404s6116Migration', 0x31, 'yes'),
('allowHTTPSCaching', 0x30, 'yes'),
('allowLegacy2FA', 0x30, 'yes'),
('allowMySQLi', 0x31, 'yes'),
('allScansScheduled', 0x613a313a7b693a303b613a323a7b733a393a2274696d657374616d70223b693a313538323935323430303b733a343a2261726773223b613a313a7b693a303b693a313538323935323430303b7d7d7d, 'yes'),
('wordfenceCentralSiteID', 0x66386138383431352d313830392d343266372d623363302d386131353461376232396461, 'yes'),
('apiKey', 0x36663935636461353930373235333532303462313261376662393662383532363966366234393235613039643736373266353235626533656462356231313630, 'yes'),
('keyAutoRenew10Sent', '', 'yes'),
('autoBlockScanners', 0x31, 'yes'),
('autoUpdate', 0x31, 'yes'),
('autoUpdateAttempts', 0x30, 'yes'),
('autoUpdateChoice', 0x31, 'yes'),
('bannedURLs', '', 'yes'),
('betaThreatDefenseFeed', 0x30, 'yes'),
('blockCustomText', '', 'yes'),
('blockedTime', 0x333030, 'yes'),
('blockFakeBots', 0x30, 'yes'),
('blocks702Migration', 0x31, 'yes'),
('cacheType', 0x64697361626c6564, 'yes'),
('cbl_action', 0x626c6f636b, 'yes'),
('cbl_bypassRedirDest', '', 'yes'),
('cbl_bypassRedirURL', '', 'yes'),
('cbl_bypassViewURL', '', 'yes'),
('cbl_cookieVal', 0x35643031373033343237343331, 'yes'),
('cbl_loggedInBlocked', '', 'yes'),
('cbl_redirURL', '', 'yes'),
('cbl_restOfSiteBlocked', 0x31, 'yes'),
('checkSpamIP', 0x31, 'yes'),
('config701Migration', 0x31, 'yes'),
('config720Migration', 0x31, 'yes');
INSERT INTO `wpgn_wfconfig` (`name`, `val`, `autoload`) VALUES
('coreHashes', 0x[encoded data, 252784 characters], 'no');
INSERT INTO `wpgn_wfconfig` (`name`, `val`, `autoload`) VALUES
('currentCronKey', '', 'yes'),
('dashboardData', 0x[encoded data, 7610 characters], 'yes'),
('dbTest', 0x613a313a7b733a353a226e6f6e6365223b733a36343a2230663932646663313964343765616637323736376431336639616632663438393363643537396137663635396632363164346434306636396532653961623236223b7d, 'no'),
('dbVersion', 0x31302e322e33312d4d6172696144422d636c6c2d6c7665, 'yes'),
('debugOn', 0x30, 'yes'),
('deleteTablesOnDeact', 0x30, 'yes'),
('detectProxyNextCheck', 0x31353833313235323730, 'no'),
('detectProxyNonce', '', 'no'),
('detectProxyRecommendation', 0x52454d4f54455f41444452, 'no'),
('diagnosticsWflogsRemovalHistory', 0x5b5d, 'no'),
('disableCodeExecutionUploads', 0x30, 'yes'),
('disableConfigCaching', 0x30, 'yes'),
('disableWAFIPBlocking', 0x30, 'yes'),
('disclosureStates', 0x613a353a7b733a32303a2277662d7363616e2d61637469766974792d6c6f67223b623a313b733a32303a227761662d6f7074696f6e732d616476616e636564223b623a313b733a32373a2277662d7363616e6e65722d6f7074696f6e732d7363686564756c65223b623a313b733a32363a2277662d7363616e6e65722d6f7074696f6e732d67656e6572616c223b623a313b733a32323a22676c6f62616c2d6f7074696f6e732d67656e6572616c223b623a313b7d, 'yes'),
('dismissAutoPrependNotice', 0x30, 'yes'),
('displayAutomaticBlocks', 0x31, 'yes'),
('displayTopLevelBlocking', 0x30, 'yes'),
('displayTopLevelLiveTraffic', 0x30, 'yes'),
('displayTopLevelOptions', 0x31, 'yes'),
('emailedIssuesList', 0x[encoded data, 4992 characters], 'yes'),
('email_summary_dashboard_widget_enabled', 0x31, 'yes'),
('email_summary_enabled', 0x31, 'yes'),
('email_summary_excluded_directories', 0x77702d636f6e74656e742f63616368652c77702d636f6e74656e742f77666c6f6773, 'yes'),
('email_summary_interval', 0x7765656b6c79, 'yes'),
('encKey', 0x32666566636337383738333665313862, 'yes'),
('fileContentsGSB6315Migration', 0x31, 'yes'),
('firewallEnabled', 0x31, 'yes'),
('geoIPVersionHash', 0x36373337396139653732303361303763343365303937393936663133333065386562346131653631343463343862353432626433633566356534616363333663, 'yes'),
('howGetIPs', '', 'yes'),
('howGetIPs_trusted_proxies', '', 'yes'),
('isPaid', 0x31, 'yes'),
('keyType', 0x706169642d63757272656e74, 'yes'),
('lastAdminLogin', 0x613a363a7b733a363a22757365724944223b693a323b733a383a22757365726e616d65223b733a343a226d61726b223b733a393a2266697273744e616d65223b733a313a224d223b733a383a226c6173744e616d65223b733a383a225020496e6772616d223b733a343a2274696d65223b733a33303a22546875203237746820466562727561727920402030333a32353a3536504d223b733a323a224950223b733a31333a2238382e3131312e37312e313737223b7d, 'yes'),
('lastAttackDataSendTime', 0x313538323838383735392e363237363837, 'yes'),
('lastBlockAggregation', 0x31353832383435363535, 'yes'),
('lastBruteForceDataSendTime', 0x313538313238333235382e303731323030, 'yes'),
('lastDashboardCheck', 0x31353832383234303239, 'yes'),
('lastEmailHash', 0x313538323831373135373a3233363064663233636462346539653561663761326136663534306131316537, 'yes'),
('lastFalsePositiveSendTime', 0x31353832383431393232, 'yes'),
('lastNotificationID', 0x323330, 'no'),
('lastScanCompleted', 0x6f6b, 'yes'),
('lastScanFailureType', '', 'yes'),
('lastScheduledScanStart', 0x31353832383636303138, 'yes'),
('liveActivityPauseEnabled', 0x31, 'yes'),
('liveTrafficEnabled', 0x30, 'yes'),
('liveTraf_displayExpandedRecords', 0x30, 'no'),
('liveTraf_ignoreIPs', '', 'yes'),
('liveTraf_ignorePublishers', 0x31, 'yes'),
('liveTraf_ignoreUA', '', 'yes'),
('liveTraf_ignoreUsers', '', 'yes'),
('liveTraf_maxAge', 0x3330, 'yes'),
('liveTraf_maxRows', 0x32303030, 'yes'),
('loginSecurityEnabled', 0x31, 'yes'),
('loginSec_blockAdminReg', 0x31, 'yes'),
('loginSec_breachPasswds', 0x61646d696e73, 'yes'),
('loginSec_breachPasswds_enabled', 0x31, 'yes'),
('loginSec_countFailMins', 0x323430, 'yes'),
('loginSec_disableAuthorScan', 0x31, 'yes'),
('loginSec_disableOEmbedAuthor', 0x30, 'yes'),
('loginSec_enableSeparateTwoFactor', '', 'yes'),
('loginSec_lockInvalidUsers', 0x30, 'yes'),
('loginSec_lockoutMins', 0x323430, 'yes'),
('loginSec_maskLoginErrors', 0x31, 'yes'),
('loginSec_maxFailures', 0x3230, 'yes'),
('loginSec_maxForgotPasswd', 0x3230, 'yes'),
('loginSec_requireAdminTwoFactor', 0x30, 'yes'),
('loginSec_strongPasswds', 0x70756273, 'yes'),
('loginSec_strongPasswds_enabled', 0x31, 'yes'),
('loginSec_userBlacklist', '', 'yes'),
('longEncKey', 0x66393433623165306263343435386236383433336161333037653835396239383730356664326262323162326561333233326561393163336165336661356266, 'yes'),
('lowResourceScansEnabled', 0x30, 'yes'),
('lowResourceScanWaitStep', '', 'yes');
INSERT INTO `wpgn_wfconfig` (`name`, `val`, `autoload`) VALUES
('malwarePrefixes', 0x[encoded data, 228795 characters]