CREATE TABLE `tophorny_rank_math_analytics_keyword_manager` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `keyword` varchar(1000) NOT NULL,
  `collection` varchar(200) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_rank_math_analytics_objects`
--

CREATE TABLE `tophorny_rank_math_analytics_objects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `title` text NOT NULL,
  `page` varchar(500) NOT NULL,
  `object_type` varchar(100) NOT NULL,
  `object_subtype` varchar(100) NOT NULL,
  `object_id` bigint(20) UNSIGNED NOT NULL,
  `primary_key` varchar(255) NOT NULL,
  `seo_score` tinyint(4) NOT NULL DEFAULT 0,
  `page_score` tinyint(4) NOT NULL DEFAULT 0,
  `is_indexable` tinyint(1) NOT NULL DEFAULT 1,
  `schemas_in_use` varchar(500) DEFAULT NULL,
  `desktop_interactive` double DEFAULT 0,
  `desktop_pagescore` double DEFAULT 0,
  `mobile_interactive` double DEFAULT 0,
  `mobile_pagescore` double DEFAULT 0,
  `pagespeed_refreshed` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_rank_math_analytics_objects`
--

INSERT INTO `tophorny_rank_math_analytics_objects` (`id`, `created`, `title`, `page`, `object_type`, `object_subtype`, `object_id`, `primary_key`, `seo_score`, `page_score`, `is_indexable`, `schemas_in_use`, `desktop_interactive`, `desktop_pagescore`, `mobile_interactive`, `mobile_pagescore`, `pagespeed_refreshed`) VALUES
(1, '2025-02-13 16:31:41', '範例頁面', '/?page_id=2', 'post', 'page', 2, '', 0, 0, 1, 'Article', 0, 0, 0, 0, '0000-00-00 00:00:00'),
(2, '2025-02-13 16:31:41', '網站第一篇文章', '/?p=1', 'post', 'post', 1, '', 0, 0, 1, 'Article', 0, 0, 0, 0, '0000-00-00 00:00:00');

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

--
-- 資料表結構 `tophorny_rank_math_internal_links`
--

CREATE TABLE `tophorny_rank_math_internal_links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(255) NOT NULL,
  `post_id` bigint(20) UNSIGNED NOT NULL,
  `target_post_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_rank_math_internal_links`
--

INSERT INTO `tophorny_rank_math_internal_links` (`id`, `url`, `post_id`, `target_post_id`, `type`) VALUES
(1, 'https://automattic.com/privacy/', 3, 0, 'external'),
(2, 'https://tophorny.com/?filter=latest', 163, 0, 'internal'),
(3, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-5-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 131, 'internal'),
(4, 'https://tophorny.com/zh/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-5-%e9%a0%90%e8%a6%bd%e5%bd%b1%e7%89%87/', 163, 129, 'internal'),
(5, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-4-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 127, 'internal'),
(6, 'https://tophorny.com/zh/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-4-%e9%a0%90%e8%a6%bd%e5%bd%b1%e7%89%87/', 163, 125, 'internal'),
(7, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-3-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 123, 'internal'),
(8, 'https://tophorny.com/?filter=random', 163, 0, 'internal'),
(9, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-2-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 119, 'internal'),
(10, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-3-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 123, 'internal'),
(11, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-5-preview-video/', 163, 81, 'internal'),
(12, 'https://tophorny.com/killuas-secret-cave-life-5-preview-video/', 163, 86, 'internal'),
(13, 'https://tophorny.com/zh/%e8%82%89%e7%a9%b4%e8%a3%a1%e7%9a%84%e6%98%87%e9%be%8d%e6%8b%b3-3-%e9%a0%90%e8%a6%bd%e5%bd%b1%e7%89%87/', 163, 98, 'internal'),
(14, 'https://tophorny.com/?filter=popular', 163, 0, 'internal'),
(15, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-1-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 114, 'internal'),
(16, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-2-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 119, 'internal'),
(17, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-3-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 123, 'internal'),
(18, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-4-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 127, 'internal'),
(19, 'https://tophorny.com/zh-cn/%e5%a5%87%e7%8a%bd%e7%9a%84%e7%a7%98%e7%a9%b4%e7%94%9f%e6%b4%bb-5-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87/', 163, 131, 'internal');

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

--
-- 資料表結構 `tophorny_rank_math_internal_meta`
--

CREATE TABLE `tophorny_rank_math_internal_meta` (
  `object_id` bigint(20) UNSIGNED NOT NULL,
  `internal_link_count` int(10) UNSIGNED DEFAULT 0,
  `external_link_count` int(10) UNSIGNED DEFAULT 0,
  `incoming_link_count` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_rank_math_internal_meta`
--

INSERT INTO `tophorny_rank_math_internal_meta` (`object_id`, `internal_link_count`, `external_link_count`, `incoming_link_count`) VALUES
(3, 0, 1, 0),
(11, 0, 0, 0),
(12, 0, 0, 0),
(13, 0, 0, 0),
(14, 0, 0, 0),
(15, 0, 0, 0),
(74, 0, 0, 0),
(75, 0, 0, 0),
(76, 0, 0, 0),
(77, 0, 0, 0),
(78, 0, 0, 0),
(79, 0, 0, 0),
(80, 0, 0, 0),
(81, 0, 0, 1),
(82, 0, 0, 0),
(83, 0, 0, 0),
(84, 0, 0, 0),
(85, 0, 0, 0),
(86, 0, 0, 1),
(88, 0, 0, 0),
(91, 0, 0, 0),
(94, 0, 0, 0),
(96, 0, 0, 0),
(98, 0, 0, 1),
(100, 0, 0, 0),
(103, 0, 0, 0),
(105, 0, 0, 0),
(107, 0, 0, 0),
(109, 0, 0, 0),
(111, 0, 0, 0),
(114, 0, 0, 1),
(117, 0, 0, 0),
(119, 0, 0, 2),
(121, 0, 0, 0),
(123, 0, 0, 3),
(125, 0, 0, 1),
(127, 0, 0, 2),
(129, 0, 0, 1),
(131, 0, 0, 2),
(150, 0, 0, 0),
(153, 0, 0, 0),
(155, 0, 0, 0),
(157, 0, 0, 0),
(158, 0, 0, 0),
(160, 0, 0, 0),
(162, 0, 0, 0),
(163, 18, 0, 0),
(166, 0, 0, 0),
(168, 0, 0, 0);

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

--
-- 資料表結構 `tophorny_snippets`
--

CREATE TABLE `tophorny_snippets` (
  `id` bigint(20) NOT NULL,
  `name` tinytext NOT NULL,
  `description` text NOT NULL,
  `code` longtext NOT NULL,
  `tags` longtext NOT NULL,
  `scope` varchar(15) NOT NULL DEFAULT 'global',
  `priority` smallint(6) NOT NULL DEFAULT 10,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `revision` bigint(20) NOT NULL DEFAULT 1,
  `cloud_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_snippets`
--

INSERT INTO `tophorny_snippets` (`id`, `name`, `description`, `code`, `tags`, `scope`, `priority`, `active`, `modified`, `revision`, `cloud_id`) VALUES
(5, '媒體 - 隨機命名上傳的檔案', '', 'add_filter( \'sanitize_file_name\', \'wnt_media_upload_random\' );\nfunction wnt_media_upload_random($filename) {\n	$info = pathinfo($filename);\n	$ext  = empty($info[\'extension\']) ? \'\' : \'.\' . $info[\'extension\'];\n	$name = basename($filename, $ext);\n	return substr(md5($name), 0, 20) . $ext;\n}', '', 'admin', 10, 1, '2025-02-14 08:31:27', 2, NULL),
(6, '媒體 - 啟用 ICO 檔案格式', '', 'add_filter( \'mime_types\', \'wnt_media_upload_ico\' );\nfunction wnt_media_upload_ico($existing_mimes) {\n	$existing_mimes[\'ico\'] = \'image/vnd.microsoft.icon\';\n	return $existing_mimes;\n}', '', 'admin', 10, 1, '2025-02-14 08:31:32', 2, NULL),
(7, '媒體 - 啟用 SVG 檔案格式', '', 'add_filter( \'mime_types\', \'wnt_media_upload_svg\' );\nfunction wnt_media_upload_svg($existing_mimes) {\n	$existing_mimes[\'svg\'] = \'image/svg+xml\';\n	return $existing_mimes;\n}', '', 'admin', 10, 1, '2025-02-14 08:31:38', 2, NULL),
(8, '後台 - 停用忘記密碼的連結', '', 'add_filter( \'gettext\', \'wnt_login_pwd_lost\' );\nfunction wnt_login_pwd_lost( $text ) {\n	if( $text == \'Lost your password?\' || $text == \'忘記密碼？\' ) { $text = \'\'; }\n	return $text;\n}', '', 'front-end', 10, 1, '2025-02-14 08:31:44', 2, NULL),
(9, '後台 - 停用登入錯誤的訊息', '', 'add_filter( \'login_errors\', \'wnt_login_message\' );\nfunction wnt_login_message( $errors ) {\n	echo \'<style>#login_error { display:none !important; }</style>\';\n}', '', 'front-end', 10, 1, '2025-02-14 08:31:50', 2, NULL),
(10, '前台 - 自動將圖片新增 alt 和 title 屬性', '', 'function add_image_alt_title_tags($content) {\n    global $post;\n    $post_title = $post->post_title;\n    $pattern = \'/<img(.*?)\\/>/i\';\n    preg_match_all($pattern, $content, $matches);\n    foreach ($matches[0] as $index => $img_tag) {\n        if (strpos($img_tag, \' alt=\') === false || preg_match(\'/ alt=[\"\\\']\\s*[\"\\\']/\', $img_tag)) {\n            $replacement = preg_replace(\'/<img/\', \'<img alt=\"\' . $post_title . \' \' . ($index + 1) . \'\" title=\"\' . $post_title . \' \' . ($index + 1) . \'\"\', $img_tag);\n            $content = str_replace($img_tag, $replacement, $content);\n        }\n    }\n    return $content;\n}\nadd_filter(\'the_content\', \'add_image_alt_title_tags\');', '', 'front-end', 10, 1, '2025-02-14 08:31:55', 2, NULL);

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

--
-- 資料表結構 `tophorny_termmeta`
--

CREATE TABLE `tophorny_termmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_termmeta`
--

INSERT INTO `tophorny_termmeta` (`meta_id`, `term_id`, `meta_key`, `meta_value`) VALUES
(1, 15, 'product_count_product_cat', '3'),
(2, 43, 'order', '0'),
(3, 46, 'order', '0'),
(4, 43, 'product_count_product_cat', '3'),
(5, 46, 'product_count_product_cat', '3'),
(6, 1, 'category-image-id', ''),
(7, 21, 'category-image-id', ''),
(8, 25, 'category-image-id', ''),
(9, 15, 'thumbnail_id', '0'),
(10, 43, 'thumbnail_id', '0'),
(11, 46, 'thumbnail_id', '0'),
(12, 15, 'display_type', ''),
(13, 43, 'display_type', ''),
(14, 46, 'display_type', ''),
(15, 43, 'rank_math_title', ''),
(16, 43, 'rank_math_description', ''),
(17, 43, 'rank_math_robots', 'a:1:{i:0;s:5:\"index\";}'),
(18, 43, 'rank_math_focus_keyword', ''),
(19, 43, 'rank_math_canonical_url', ''),
(20, 46, 'rank_math_title', ''),
(21, 46, 'rank_math_description', ''),
(22, 46, 'rank_math_robots', 'a:1:{i:0;s:5:\"index\";}'),
(23, 46, 'rank_math_focus_keyword', ''),
(24, 46, 'rank_math_canonical_url', ''),
(25, 16, '_pll_strings_translations', 'a:2:{i:0;a:2:{i:0;s:19:\"Top Horny 成人網\";i:1;s:19:\"Top Horny 成人網\";}i:1;a:2:{i:0;s:9:\"Top Horny\";i:1;s:9:\"Top Horny\";}}'),
(26, 19, '_pll_strings_translations', 'a:2:{i:0;a:2:{i:0;s:19:\"Top Horny 成人網\";i:1;s:19:\"Top Horny 成人網\";}i:1;a:2:{i:0;s:9:\"Top Horny\";i:1;s:9:\"Top Horny\";}}'),
(27, 23, '_pll_strings_translations', 'a:2:{i:0;a:2:{i:0;s:19:\"Top Horny 成人網\";i:1;s:19:\"Top Horny 成人網\";}i:1;a:2:{i:0;s:9:\"Top Horny\";i:1;s:9:\"Top Horny\";}}');

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

--
-- 資料表結構 `tophorny_terms`
--

CREATE TABLE `tophorny_terms` (
  `term_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) NOT NULL DEFAULT '',
  `term_group` bigint(20) NOT NULL DEFAULT 0,
  `term_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_terms`
--

INSERT INTO `tophorny_terms` (`term_id`, `name`, `slug`, `term_group`, `term_order`) VALUES
(1, 'Adult Videos', 'adult-videos', 0, 0),
(2, 'simple', 'simple', 0, 0),
(3, 'grouped', 'grouped', 0, 0),
(4, 'variable', 'variable', 0, 0),
(5, 'external', 'external', 0, 0),
(6, 'exclude-from-search', 'exclude-from-search', 0, 0),
(7, 'exclude-from-catalog', 'exclude-from-catalog', 0, 0),
(8, 'featured', 'featured', 0, 0),
(9, 'outofstock', 'outofstock', 0, 0),
(10, 'rated-1', 'rated-1', 0, 0),
(11, 'rated-2', 'rated-2', 0, 0),
(12, 'rated-3', 'rated-3', 0, 0),
(13, 'rated-4', 'rated-4', 0, 0),
(14, 'rated-5', 'rated-5', 0, 0),
(15, 'Plan', 'plan', 0, 0),
(16, 'English', 'en', 1, 0),
(17, 'English', 'pll_en', 0, 0),
(18, 'pll_67af017dcb12a', 'pll_67af017dcb12a', 0, 0),
(19, '中文 (繁體)', 'zh', 2, 0),
(20, '中文 (繁體)', 'pll_zh', 0, 0),
(21, '成人影片', 'adult-videos', 0, 0),
(23, '中文 (简体)', 'zh-cn', 3, 0),
(24, '中文 (简体)', 'pll_zh-cn', 0, 0),
(25, '成人视频', 'adult-videos', 0, 0),
(27, '主選單(英文)', '%e4%b8%bb%e9%81%b8%e5%96%ae%e8%8b%b1%e6%96%87', 0, 0),
(28, '主選單(繁體中文)', '%e4%b8%bb%e9%81%b8%e5%96%ae%e7%b9%81%e9%ab%94%e4%b8%ad%e6%96%87', 0, 0),
(29, '主選單(簡體中文)', '%e4%b8%bb%e9%81%b8%e5%96%ae%e7%b0%a1%e9%ab%94%e4%b8%ad%e6%96%87', 0, 0),
(30, 'pll_67af090d081cc', 'pll_67af090d081cc', 0, 0),
(31, 'pll_67af092822e04', 'pll_67af092822e04', 0, 0),
(32, 'pll_67af09776e21b', 'pll_67af09776e21b', 0, 0),
(33, 'pll_67af09af824ce', 'pll_67af09af824ce', 0, 0),
(34, 'pll_67af0a3ee8c47', 'pll_67af0a3ee8c47', 0, 0),
(35, 'pll_67af0a74bedff', 'pll_67af0a74bedff', 0, 0),
(36, 'pll_67af0ac195fb9', 'pll_67af0ac195fb9', 0, 0),
(37, 'pll_67af0ad4942c5', 'pll_67af0ad4942c5', 0, 0),
(38, 'pll_67af0b0531f48', 'pll_67af0b0531f48', 0, 0),
(39, 'pll_67af0b2e423cb', 'pll_67af0b2e423cb', 0, 0),
(40, 'pll_67af0b5b4c699', 'pll_67af0b5b4c699', 0, 0),
(41, 'pll_67af0b8c24d43', 'pll_67af0b8c24d43', 0, 0),
(42, 'pll_67c44c9cb1146', 'pll_67c44c9cb1146', 0, 0),
(43, '方案', 'plan', 0, 0),
(44, 'pll_67c44c9cb93c0', 'pll_67c44c9cb93c0', 0, 0),
(46, '方案', 'plan', 0, 0),
(47, 'pll_67c44c9cd0bfa', 'pll_67c44c9cd0bfa', 0, 0),
(50, 'pll_67c44ed109be4', 'pll_67c44ed109be4', 0, 0),
(51, 'pll_67c450fbc7483', 'pll_67c450fbc7483', 0, 0),
(52, 'pll_67c453a98f70a', 'pll_67c453a98f70a', 0, 0),
(53, 'pll_67c45405204d6', 'pll_67c45405204d6', 0, 0),
(54, 'pll_67c45460a14d5', 'pll_67c45460a14d5', 0, 0),
(55, 'pll_67c454c16873d', 'pll_67c454c16873d', 0, 0),
(57, 'pll_67c4561cdd80a', 'pll_67c4561cdd80a', 0, 0),
(58, 'pll_67c456b828709', 'pll_67c456b828709', 0, 0),
(59, 'pll_67c45760bfb5a', 'pll_67c45760bfb5a', 0, 0),
(60, 'pll_67c457c682965', 'pll_67c457c682965', 0, 0),
(61, 'pll_67c4586a017e3', 'pll_67c4586a017e3', 0, 0),
(62, '頁尾選單 2 (英文)', '%e9%a0%81%e5%b0%be%e9%81%b8%e5%96%ae-2-%e8%8b%b1%e6%96%87', 0, 0),
(63, '頁尾選單 2 (繁體中文)', '%e9%a0%81%e5%b0%be%e9%81%b8%e5%96%ae-2-%e7%b9%81%e9%ab%94%e4%b8%ad%e6%96%87', 0, 0),
(64, '頁尾選單 2 (簡體中文)', '%e9%a0%81%e5%b0%be%e9%81%b8%e5%96%ae-2-%e7%b0%a1%e9%ab%94%e4%b8%ad%e6%96%87', 0, 0),
(65, '頁尾選單 1 (英文)', '%e9%a0%81%e5%b0%be%e9%81%b8%e5%96%ae-1-%e8%8b%b1%e6%96%87', 0, 0),
(66, '頁尾選單 1 (繁體中文)', '%e9%a0%81%e5%b0%be%e9%81%b8%e5%96%ae-1-%e7%b9%81%e9%ab%94%e4%b8%ad%e6%96%87', 0, 0),
(67, '頁尾選單 1 (簡體中文)', '%e9%a0%81%e5%b0%be%e9%81%b8%e5%96%ae-1-%e7%b0%a1%e9%ab%94%e4%b8%ad%e6%96%87', 0, 0),
(68, 'pll_67c46557be3b6', 'pll_67c46557be3b6', 0, 0),
(69, 'pll_67c4656fa42e5', 'pll_67c4656fa42e5', 0, 0),
(70, '手機版語系選單', '%e6%89%8b%e6%a9%9f%e7%89%88%e8%aa%9e%e7%b3%bb%e9%81%b8%e5%96%ae', 0, 0),
(71, '手機版主選單(英文)', '%e6%89%8b%e6%a9%9f%e7%89%88%e4%b8%bb%e9%81%b8%e5%96%ae%e8%8b%b1%e6%96%87', 0, 0),
(72, '手機版主選單(繁體)', '%e6%89%8b%e6%a9%9f%e7%89%88%e4%b8%bb%e9%81%b8%e5%96%ae%e7%b9%81%e9%ab%94', 0, 0),
(73, '手機版主選單(簡體)', '%e6%89%8b%e6%a9%9f%e7%89%88%e4%b8%bb%e9%81%b8%e5%96%ae%e7%b0%a1%e9%ab%94', 0, 0),
(74, '性玩具', '%e6%80%a7%e7%8e%a9%e5%85%b7', 0, 0),
(75, 'pll_67c6c814d872a', 'pll_67c6c814d872a', 0, 0),
(76, '白淨', '%e7%99%bd%e6%b7%a8', 0, 0),
(77, 'pll_67c6c814ddcb1', 'pll_67c6c814ddcb1', 0, 0),
(78, '白净', '%e7%99%bd%e5%87%80', 0, 0),
(79, 'pll_67c6c83a61ed7', 'pll_67c6c83a61ed7', 0, 0),
(80, '性玩具', '%e6%80%a7%e7%8e%a9%e5%85%b7', 0, 0),
(82, 'Sex toys', 'sex-toys', 0, 0),
(83, 'pll_67c6c8d3b5d82', 'pll_67c6c8d3b5d82', 0, 0),
(84, 'white', 'white', 0, 0),
(85, 'pll_67c6c8d3bbaf1', 'pll_67c6c8d3bbaf1', 0, 0),
(86, 'pll_67c6d2d6bebbc', 'pll_67c6d2d6bebbc', 0, 0),
(87, 'pll_67c6d330d9a5a', 'pll_67c6d330d9a5a', 0, 0);

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

--
-- 資料表結構 `tophorny_term_relationships`
--

CREATE TABLE `tophorny_term_relationships` (
  `object_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `term_order` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_term_relationships`
--

INSERT INTO `tophorny_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES
(1, 17, 0),
(1, 18, 0),
(3, 16, 0),
(3, 52, 0),
(9, 16, 0),
(10, 16, 0),
(10, 68, 0),
(11, 16, 0),
(11, 57, 0),
(12, 16, 0),
(12, 59, 0),
(13, 16, 0),
(13, 60, 0),
(14, 16, 0),
(14, 58, 0),
(15, 16, 0),
(15, 17, 0),
(15, 42, 0),
(15, 61, 0),
(21, 18, 0),
(21, 20, 0),
(25, 18, 0),
(25, 24, 0),
(43, 20, 0),
(43, 42, 0),
(46, 24, 0),
(46, 42, 0),
(66, 16, 0),
(69, 16, 0),
(70, 16, 0),
(70, 30, 0),
(71, 16, 0),
(72, 16, 0),
(72, 36, 0),
(73, 16, 0),
(74, 20, 0),
(74, 75, 0),
(76, 20, 0),
(76, 77, 0),
(77, 1, 0),
(77, 16, 0),
(77, 31, 0),
(77, 82, 0),
(77, 84, 0),
(78, 1, 0),
(78, 16, 0),
(78, 24, 0),
(78, 32, 0),
(78, 79, 0),
(78, 82, 0),
(78, 84, 0),
(79, 1, 0),
(79, 16, 0),
(79, 33, 0),
(79, 82, 0),
(79, 84, 0),
(80, 1, 0),
(80, 16, 0),
(80, 24, 0),
(80, 34, 0),
(80, 75, 0),
(80, 82, 0),
(80, 84, 0),
(81, 1, 0),
(81, 16, 0),
(81, 35, 0),
(81, 82, 0),
(81, 84, 0),
(82, 1, 0),
(82, 16, 0),
(82, 17, 0),
(82, 37, 0),
(82, 82, 0),
(82, 83, 0),
(82, 84, 0),
(83, 1, 0),
(83, 16, 0),
(83, 38, 0),
(83, 82, 0),
(83, 84, 0),
(84, 1, 0),
(84, 16, 0),
(84, 17, 0),
(84, 39, 0),
(84, 82, 0),
(84, 84, 0),
(84, 85, 0),
(85, 1, 0),
(85, 16, 0),
(85, 40, 0),
(85, 82, 0),
(85, 84, 0),
(86, 1, 0),
(86, 16, 0),
(86, 41, 0),
(86, 82, 0),
(86, 84, 0),
(88, 19, 0),
(88, 21, 0),
(88, 31, 0),
(88, 74, 0),
(88, 76, 0),
(89, 19, 0),
(89, 30, 0),
(91, 23, 0),
(91, 25, 0),
(91, 31, 0),
(91, 78, 0),
(91, 80, 0),
(92, 23, 0),
(92, 30, 0),
(94, 19, 0),
(94, 21, 0),
(94, 32, 0),
(94, 74, 0),
(94, 76, 0),
(96, 23, 0),
(96, 25, 0),
(96, 32, 0),
(96, 78, 0),
(96, 80, 0),
(98, 19, 0),
(98, 21, 0),
(98, 33, 0),
(98, 74, 0),
(98, 76, 0),
(100, 23, 0),
(100, 25, 0),
(100, 33, 0),
(100, 78, 0),
(100, 80, 0),
(103, 19, 0),
(103, 21, 0),
(103, 34, 0),
(103, 74, 0),
(103, 76, 0),
(105, 23, 0),
(105, 25, 0),
(105, 34, 0),
(105, 78, 0),
(105, 80, 0),
(107, 19, 0),
(107, 21, 0),
(107, 35, 0),
(107, 74, 0),
(107, 76, 0),
(109, 23, 0),
(109, 25, 0),
(109, 35, 0),
(109, 78, 0),
(109, 80, 0),
(111, 19, 0),
(111, 21, 0),
(111, 37, 0),
(111, 74, 0),
(111, 76, 0),
(112, 19, 0),
(112, 36, 0),
(114, 23, 0),
(114, 25, 0),
(114, 37, 0),
(114, 78, 0),
(114, 80, 0),
(115, 23, 0),
(115, 36, 0),
(117, 19, 0),
(117, 21, 0),
(117, 38, 0),
(117, 74, 0),
(117, 76, 0),
(119, 23, 0),
(119, 25, 0),
(119, 38, 0),
(119, 78, 0),
(119, 80, 0),
(121, 19, 0),
(121, 21, 0),
(121, 39, 0),
(121, 74, 0),
(121, 76, 0),
(123, 23, 0),
(123, 25, 0),
(123, 39, 0),
(123, 78, 0),
(123, 80, 0),
(125, 19, 0),
(125, 21, 0),
(125, 40, 0),
(125, 74, 0),
(125, 76, 0),
(127, 23, 0),
(127, 25, 0),
(127, 40, 0),
(127, 78, 0),
(127, 80, 0),
(129, 19, 0),
(129, 21, 0),
(129, 41, 0),
(129, 74, 0),
(129, 76, 0),
(131, 23, 0),
(131, 25, 0),
(131, 41, 0),
(131, 78, 0),
(131, 80, 0),
(152, 16, 0),
(154, 19, 0),
(156, 23, 0),
(158, 16, 0),
(158, 50, 0),
(159, 19, 0),
(160, 19, 0),
(160, 50, 0),
(161, 23, 0),
(162, 23, 0),
(162, 50, 0),
(163, 16, 0),
(163, 51, 0),
(165, 19, 0),
(166, 19, 0),
(166, 51, 0),
(167, 23, 0),
(168, 23, 0),
(168, 51, 0),
(169, 19, 0),
(170, 19, 0),
(170, 52, 0),
(171, 23, 0),
(172, 23, 0),
(172, 52, 0),
(173, 16, 0),
(173, 53, 0),
(174, 19, 0),
(174, 53, 0),
(175, 23, 0),
(175, 53, 0),
(176, 16, 0),
(176, 54, 0),
(177, 19, 0),
(177, 54, 0),
(178, 23, 0),
(178, 54, 0),
(179, 16, 0),
(179, 55, 0),
(180, 19, 0),
(180, 55, 0),
(181, 23, 0),
(181, 55, 0),
(183, 19, 0),
(187, 19, 0),
(188, 19, 0),
(188, 57, 0),
(189, 23, 0),
(190, 23, 0),
(190, 57, 0),
(191, 19, 0),
(192, 19, 0),
(192, 58, 0),
(193, 23, 0),
(194, 23, 0),
(194, 58, 0),
(196, 19, 0),
(199, 19, 0),
(200, 19, 0),
(200, 59, 0),
(201, 23, 0),
(202, 23, 0),
(202, 59, 0),
(204, 19, 0),
(205, 19, 0),
(205, 60, 0),
(206, 23, 0),
(207, 23, 0),
(207, 60, 0),
(208, 19, 0),
(209, 19, 0),
(209, 61, 0),
(210, 23, 0),
(210, 61, 0),
(212, 62, 0),
(213, 62, 0),
(214, 62, 0),
(215, 62, 0),
(216, 62, 0),
(217, 63, 0),
(218, 63, 0),
(219, 63, 0),
(220, 63, 0),
(221, 63, 0),
(222, 64, 0),
(223, 64, 0),
(224, 64, 0),
(225, 64, 0),
(226, 64, 0),
(227, 65, 0),
(228, 65, 0),
(229, 65, 0),
(230, 65, 0),
(231, 66, 0),
(232, 66, 0),
(233, 66, 0),
(234, 66, 0),
(235, 67, 0),
(236, 67, 0),
(237, 67, 0),
(238, 67, 0),
(239, 27, 0),
(240, 27, 0),
(241, 27, 0),
(242, 27, 0),
(243, 28, 0),
(244, 28, 0),
(245, 28, 0),
(246, 28, 0),
(247, 29, 0),
(248, 29, 0),
(249, 29, 0),
(250, 29, 0),
(252, 2, 0),
(252, 15, 0),
(252, 16, 0),
(252, 69, 0),
(253, 2, 0),
(253, 19, 0),
(253, 43, 0),
(254, 19, 0),
(254, 68, 0),
(255, 2, 0),
(255, 19, 0),
(255, 43, 0),
(255, 69, 0),
(256, 2, 0),
(256, 23, 0),
(256, 46, 0),
(257, 23, 0),
(257, 68, 0),
(258, 2, 0),
(258, 23, 0),
(258, 46, 0),
(258, 69, 0),
(261, 19, 0),
(304, 19, 0),
(307, 70, 0),
(308, 71, 0),
(309, 71, 0),
(310, 71, 0),
(311, 71, 0),
(313, 72, 0),
(314, 72, 0),
(315, 72, 0),
(316, 72, 0),
(318, 73, 0),
(319, 73, 0),
(320, 73, 0),
(321, 73, 0),
(323, 27, 0),
(324, 28, 0),
(325, 29, 0),
(339, 19, 0),
(340, 23, 0),
(342, 27, 0),
(343, 28, 0),
(344, 29, 0),
(345, 27, 0),
(346, 28, 0),
(347, 29, 0),
(348, 16, 0),
(364, 16, 0),
(365, 16, 0),
(366, 16, 0),
(367, 16, 0),
(369, 2, 0),
(369, 15, 0),
(369, 16, 0),
(369, 86, 0),
(370, 2, 0),
(370, 19, 0),
(370, 43, 0),
(370, 86, 0),
(371, 2, 0),
(371, 23, 0),
(371, 46, 0),
(371, 86, 0),
(372, 2, 0),
(372, 15, 0),
(372, 16, 0),
(372, 87, 0),
(373, 2, 0),
(373, 19, 0),
(373, 43, 0),
(373, 87, 0),
(374, 2, 0),
(374, 23, 0),
(374, 46, 0),
(374, 87, 0),
(378, 71, 0),
(379, 72, 0),
(380, 73, 0),
(381, 71, 0),
(382, 72, 0),
(383, 73, 0),
(385, 16, 0),
(386, 16, 0),
(387, 16, 0),
(388, 16, 0),
(389, 16, 0),
(400, 65, 0),
(401, 66, 0),
(402, 67, 0);

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

--
-- 資料表結構 `tophorny_term_taxonomy`
--

CREATE TABLE `tophorny_term_taxonomy` (
  `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL,
  `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `taxonomy` varchar(32) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `count` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_term_taxonomy`
--

INSERT INTO `tophorny_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES
(1, 1, 'category', '', 0, 10),
(2, 2, 'product_type', '', 0, 9),
(3, 3, 'product_type', '', 0, 0),
(4, 4, 'product_type', '', 0, 0),
(5, 5, 'product_type', '', 0, 0),
(6, 6, 'product_visibility', '', 0, 0),
(7, 7, 'product_visibility', '', 0, 0),
(8, 8, 'product_visibility', '', 0, 0),
(9, 9, 'product_visibility', '', 0, 0),
(10, 10, 'product_visibility', '', 0, 0),
(11, 11, 'product_visibility', '', 0, 0),
(12, 12, 'product_visibility', '', 0, 0),
(13, 13, 'product_visibility', '', 0, 0),
(14, 14, 'product_visibility', '', 0, 0),
(15, 15, 'product_cat', '', 0, 3),
(16, 16, 'language', 'a:4:{s:9:\"fallbacks\";a:0:{}s:6:\"locale\";s:5:\"en_US\";s:3:\"rtl\";i:0;s:9:\"flag_code\";s:2:\"us\";}', 0, 27),
(17, 17, 'term_language', '', 0, 4),
(18, 18, 'term_translations', 'a:3:{s:2:\"en\";i:1;s:2:\"zh\";i:21;s:5:\"zh-cn\";i:25;}', 0, 3),
(19, 19, 'language', 'a:4:{s:9:\"fallbacks\";a:0:{}s:6:\"locale\";s:5:\"zh_TW\";s:3:\"rtl\";i:0;s:9:\"flag_code\";s:2:\"tw\";}', 0, 26),
(20, 20, 'term_language', '', 0, 4),
(21, 21, 'category', '', 0, 10),
(23, 23, 'language', 'a:4:{s:9:\"fallbacks\";a:0:{}s:6:\"locale\";s:5:\"zh_CN\";s:3:\"rtl\";i:0;s:9:\"flag_code\";s:2:\"cn\";}', 0, 26),
(24, 24, 'term_language', '', 0, 4),
(25, 25, 'category', '', 0, 10),
(27, 27, 'nav_menu', '', 0, 7),
(28, 28, 'nav_menu', '', 0, 7),
(29, 29, 'nav_menu', '', 0, 7),
(30, 30, 'post_translations', 'a:3:{s:2:\"zh\";i:89;s:2:\"en\";i:70;s:5:\"zh-cn\";i:92;}', 0, 3),
(31, 31, 'post_translations', 'a:3:{s:2:\"zh\";i:88;s:2:\"en\";i:77;s:5:\"zh-cn\";i:91;}', 0, 3),
(32, 32, 'post_translations', 'a:3:{s:2:\"zh\";i:94;s:2:\"en\";i:78;s:5:\"zh-cn\";i:96;}', 0, 3),
(33, 33, 'post_translations', 'a:3:{s:2:\"zh\";i:98;s:2:\"en\";i:79;s:5:\"zh-cn\";i:100;}', 0, 3),
(34, 34, 'post_translations', 'a:3:{s:2:\"zh\";i:103;s:2:\"en\";i:80;s:5:\"zh-cn\";i:105;}', 0, 3),
(35, 35, 'post_translations', 'a:3:{s:2:\"zh\";i:107;s:2:\"en\";i:81;s:5:\"zh-cn\";i:109;}', 0, 3),
(36, 36, 'post_translations', 'a:3:{s:2:\"zh\";i:112;s:2:\"en\";i:72;s:5:\"zh-cn\";i:115;}', 0, 3),
(37, 37, 'post_translations', 'a:3:{s:2:\"zh\";i:111;s:2:\"en\";i:82;s:5:\"zh-cn\";i:114;}', 0, 3),
(38, 38, 'post_translations', 'a:3:{s:2:\"zh\";i:117;s:2:\"en\";i:83;s:5:\"zh-cn\";i:119;}', 0, 3),
(39, 39, 'post_translations', 'a:3:{s:2:\"zh\";i:121;s:2:\"en\";i:84;s:5:\"zh-cn\";i:123;}', 0, 3),
(40, 40, 'post_translations', 'a:3:{s:2:\"zh\";i:125;s:2:\"en\";i:85;s:5:\"zh-cn\";i:127;}', 0, 3),
(41, 41, 'post_translations', 'a:3:{s:2:\"zh\";i:129;s:2:\"en\";i:86;s:5:\"zh-cn\";i:131;}', 0, 3),
(42, 42, 'term_translations', 'a:3:{s:2:\"en\";i:15;s:2:\"zh\";i:43;s:5:\"zh-cn\";i:46;}', 0, 3),
(43, 43, 'product_cat', '', 0, 3),
(44, 44, 'term_translations', 'a:1:{s:2:\"en\";i:43;}', 0, 0),
(46, 46, 'product_cat', '', 0, 3),
(47, 47, 'term_translations', 'a:1:{s:2:\"en\";i:46;}', 0, 0),
(50, 50, 'post_translations', 'a:3:{s:2:\"zh\";i:160;s:2:\"en\";i:158;s:5:\"zh-cn\";i:162;}', 0, 3),
(51, 51, 'post_translations', 'a:3:{s:2:\"zh\";i:166;s:2:\"en\";i:163;s:5:\"zh-cn\";i:168;}', 0, 3),
(52, 52, 'post_translations', 'a:3:{s:2:\"zh\";i:170;s:2:\"en\";i:3;s:5:\"zh-cn\";i:172;}', 0, 3),
(53, 53, 'post_translations', 'a:3:{s:2:\"zh\";i:174;s:2:\"en\";i:173;s:5:\"zh-cn\";i:175;}', 0, 3),
(54, 54, 'post_translations', 'a:3:{s:2:\"zh\";i:177;s:2:\"en\";i:176;s:5:\"zh-cn\";i:178;}', 0, 3),
(55, 55, 'post_translations', 'a:3:{s:2:\"zh\";i:180;s:2:\"en\";i:179;s:5:\"zh-cn\";i:181;}', 0, 3),
(57, 57, 'post_translations', 'a:3:{s:2:\"zh\";i:188;s:2:\"en\";i:11;s:5:\"zh-cn\";i:190;}', 0, 3),
(58, 58, 'post_translations', 'a:3:{s:2:\"zh\";i:192;s:2:\"en\";i:14;s:5:\"zh-cn\";i:194;}', 0, 3),
(59, 59, 'post_translations', 'a:3:{s:2:\"zh\";i:200;s:2:\"en\";i:12;s:5:\"zh-cn\";i:202;}', 0, 3),
(60, 60, 'post_translations', 'a:3:{s:2:\"zh\";i:205;s:2:\"en\";i:13;s:5:\"zh-cn\";i:207;}', 0, 3),
(61, 61, 'post_translations', 'a:3:{s:2:\"zh\";i:209;s:2:\"en\";i:15;s:5:\"zh-cn\";i:210;}', 0, 3),
(62, 62, 'nav_menu', '', 0, 5),
(63, 63, 'nav_menu', '', 0, 5),
(64, 64, 'nav_menu', '', 0, 5),
(65, 65, 'nav_menu', '', 0, 5),
(66, 66, 'nav_menu', '', 0, 5),
(67, 67, 'nav_menu', '', 0, 5),
(68, 68, 'post_translations', 'a:3:{s:2:\"zh\";i:254;s:2:\"en\";i:10;s:5:\"zh-cn\";i:257;}', 0, 3),
(69, 69, 'post_translations', 'a:3:{s:2:\"zh\";i:255;s:2:\"en\";i:252;s:5:\"zh-cn\";i:258;}', 0, 3),
(70, 70, 'nav_menu', '', 0, 1),
(71, 71, 'nav_menu', '', 0, 6),
(72, 72, 'nav_menu', '', 0, 6),
(73, 73, 'nav_menu', '', 0, 6),
(74, 74, 'post_tag', '', 0, 10),
(75, 75, 'term_translations', 'a:2:{s:2:\"zh\";i:74;s:5:\"zh-cn\";i:80;}', 0, 2),
(76, 76, 'post_tag', '', 0, 10),
(77, 77, 'term_translations', 'a:1:{s:2:\"zh\";i:76;}', 0, 1),
(78, 78, 'post_tag', '', 0, 10),
(79, 79, 'term_translations', 'a:1:{s:5:\"zh-cn\";i:78;}', 0, 1),
(80, 80, 'post_tag', '', 0, 10),
(82, 82, 'post_tag', '', 0, 10),
(83, 83, 'term_translations', 'a:1:{s:2:\"en\";i:82;}', 0, 1),
(84, 84, 'post_tag', '', 0, 10),
(85, 85, 'term_translations', 'a:1:{s:2:\"en\";i:84;}', 0, 1),
(86, 86, 'post_translations', 'a:3:{s:2:\"en\";i:369;s:2:\"zh\";i:370;s:5:\"zh-cn\";i:371;}', 0, 3),
(87, 87, 'post_translations', 'a:3:{s:2:\"en\";i:372;s:2:\"zh\";i:373;s:5:\"zh-cn\";i:374;}', 0, 3);

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

--
-- 資料表結構 `tophorny_usermeta`
--

CREATE TABLE `tophorny_usermeta` (
  `umeta_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_usermeta`
--

INSERT INTO `tophorny_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(1, 1, 'nickname', 'wpstudio'),
(2, 1, 'first_name', ''),
(3, 1, 'last_name', ''),
(4, 1, 'description', ''),
(5, 1, 'rich_editing', 'true'),
(6, 1, 'syntax_highlighting', 'true'),
(7, 1, 'comment_shortcuts', 'false'),
(8, 1, 'admin_color', 'fresh'),
(9, 1, 'use_ssl', '0'),
(10, 1, 'show_admin_bar_front', 'false'),
(11, 1, 'locale', ''),
(12, 1, 'tophorny_capabilities', 'a:1:{s:13:\"administrator\";b:1;}'),
(13, 1, 'tophorny_user_level', '10'),
(14, 1, 'dismissed_wp_pointers', ''),
(15, 1, 'show_welcome_panel', '0'),
(17, 1, 'tophorny_dashboard_quick_press_last_post_id', '152'),
(18, 1, 'community-events-location', 'a:1:{s:2:\"ip\";s:12:\"123.205.15.0\";}'),
(19, 1, 'elementor_introduction', 'a:3:{s:27:\"ai-get-started-announcement\";b:1;s:30:\"e-ai-product-image-unification\";b:1;s:20:\"globals_introduction\";b:1;}'),
(20, 1, '_imagify_ignore_notices', 'a:1:{i:0;s:13:\"welcome-steps\";}'),
(21, 1, 'manageedit-postcolumnshidden', 'a:6:{i:0;s:6:\"author\";i:1;s:4:\"tags\";i:2;s:15:\"taxonomy-actors\";i:3;s:4:\"date\";i:4;s:15:\"rank_math_title\";i:5;s:21:\"rank_math_description\";}'),
(22, 1, 'manageedit-postcolumnshidden_default', '1'),
(23, 1, 'manageedit-pagecolumnshidden', 'a:4:{i:0;s:6:\"author\";i:1;s:8:\"comments\";i:2;s:4:\"date\";i:3;s:8:\"age_gate\";}'),
(24, 1, 'manageedit-pagecolumnshidden_default', '1'),
(25, 1, 'manageedit-e-floating-buttonscolumnshidden', 'a:3:{i:0;s:0:\"\";i:1;s:15:\"rank_math_title\";i:2;s:21:\"rank_math_description\";}'),
(26, 1, 'manageedit-e-floating-buttonscolumnshidden_default', '1'),
(27, 1, 'manageedit-bdt-template-buildercolumnshidden', 'a:3:{i:0;s:0:\"\";i:1;s:15:\"rank_math_title\";i:2;s:21:\"rank_math_description\";}'),
(28, 1, 'manageedit-bdt-template-buildercolumnshidden_default', '1'),
(29, 1, 'manageedit-blogcolumnshidden', 'a:3:{i:0;s:0:\"\";i:1;s:15:\"rank_math_title\";i:2;s:21:\"rank_math_description\";}'),
(30, 1, 'manageedit-blogcolumnshidden_default', '1'),
(31, 1, 'manageedit-photoscolumnshidden', 'a:3:{i:0;s:0:\"\";i:1;s:15:\"rank_math_title\";i:2;s:21:\"rank_math_description\";}'),
(32, 1, 'manageedit-photoscolumnshidden_default', '1'),
(33, 1, 'last_update', '1741109602'),
(34, 1, 'manageedit-productcolumnshidden', 'a:3:{i:0;s:0:\"\";i:1;s:15:\"rank_math_title\";i:2;s:21:\"rank_math_description\";}'),
(35, 1, 'manageedit-productcolumnshidden_default', '1'),
(36, 1, '_woocommerce_tracks_anon_id', 'woo:b7Eo3K1d2onmRfPAI3vtIote'),
(37, 1, 'ignore_code_snippets_survey_message', 'backtonormal'),
(38, 1, 'wc_last_active', '1741046400'),
(39, 1, '_sig_line_notify_setting', ''),
(40, 1, 'tophorny_elementor_enable_ai', '1'),
(41, 1, 'tophorny_elementor_pro_enable_notes_notifications', '1'),
(42, 1, 'description_zh', ''),
(43, 1, 'description_zh-cn', ''),
(44, 1, 'billing_first_name', 'vincen'),
(45, 1, 'billing_last_name', 'chen'),
(46, 1, 'billing_company', ''),
(47, 1, 'billing_address_1', 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,'),
(48, 1, 'billing_address_2', ''),
(49, 1, 'billing_city', 'Taichung City'),
(50, 1, 'billing_postcode', '435'),
(51, 1, 'billing_country', 'TW'),
(52, 1, 'billing_state', 'Taichung City'),
(53, 1, 'billing_phone', '+886938891255'),
(54, 1, 'billing_email', 'service@wpstudio.com.tw'),
(55, 1, 'shipping_first_name', 'vincen'),
(56, 1, 'shipping_last_name', 'chen'),
(57, 1, 'shipping_company', ''),
(58, 1, 'shipping_address_1', 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,'),
(59, 1, 'shipping_address_2', ''),
(60, 1, 'shipping_city', 'Taichung City'),
(61, 1, 'shipping_postcode', '435'),
(62, 1, 'shipping_country', 'TW'),
(63, 1, 'shipping_state', 'Taichung City'),
(64, 1, 'shipping_phone', '+886938891255'),
(65, 1, 'twitter', ''),
(66, 1, 'facebook', ''),
(67, 1, 'additional_profile_urls', ''),
(68, 1, 'managenav-menuscolumnshidden', 'a:3:{i:0;s:11:\"css-classes\";i:1;s:3:\"xfn\";i:2;s:11:\"description\";}'),
(69, 1, 'metaboxhidden_nav-menus', 'a:13:{i:0;s:21:\"add-post-type-product\";i:1;s:18:\"add-post-type-blog\";i:2;s:20:\"add-post-type-photos\";i:3;s:12:\"add-post_tag\";i:4;s:15:\"add-post_format\";i:5;s:17:\"add-blog_category\";i:6;s:12:\"add-blog_tag\";i:7;s:19:\"add-photos_category\";i:8;s:14:\"add-photos_tag\";i:9;s:10:\"add-actors\";i:10;s:17:\"add-product_brand\";i:11;s:15:\"add-product_cat\";i:12;s:15:\"add-product_tag\";}'),
(70, 1, 'wpcf7_hide_welcome_panel_on', 'a:1:{i:0;s:3:\"6.0\";}'),
(71, 1, 'meta-box-order_page', 'a:2:{i:0;b:0;s:4:\"side\";s:38:\"submitdiv,rank_math_metabox_content_ai\";}'),
(72, 1, 'edit_page_per_page', '50'),
(73, 1, 'tophorny_user-settings', 'posts_list_mode=list&libraryContent=browse&editor=html&advImgDetails=show'),
(74, 1, 'tophorny_user-settings-time', '1741095140'),
(75, 1, 'fbv_folder_startup', '1'),
(76, 1, 'meta-box-order_post', 'a:2:{i:0;b:0;s:4:\"side\";s:38:\"submitdiv,rank_math_metabox_content_ai\";}'),
(77, 1, 'edit_post_per_page', '50'),
(78, 1, 'meta-box-order_product', 'a:3:{s:4:\"side\";s:84:\"submitdiv,postimagediv,woocommerce-product-images,product_catdiv,tagsdiv-product_tag\";s:6:\"normal\";s:55:\"woocommerce-product-data,postcustom,slugdiv,postexcerpt\";s:8:\"advanced\";s:0:\"\";}'),
(79, 1, 'closedpostboxes_post', 'a:6:{i:0;s:8:\"age_gate\";i:1;s:28:\"rank_math_metabox_content_ai\";i:2;s:14:\"tagsdiv-actors\";i:3;s:13:\"pageparentdiv\";i:4;s:34:\"rank_math_metabox_link_suggestions\";i:5;s:17:\"rank_math_metabox\";}'),
(80, 1, 'metaboxhidden_post', 'a:6:{i:0;s:11:\"postexcerpt\";i:1;s:13:\"trackbacksdiv\";i:2;s:10:\"postcustom\";i:3;s:16:\"commentstatusdiv\";i:4;s:7:\"slugdiv\";i:5;s:9:\"authordiv\";}'),
(81, 1, 'closedpostboxes_page', 'a:1:{i:0;s:11:\"commentsdiv\";}'),
(82, 1, 'metaboxhidden_page', 'a:4:{i:0;s:10:\"postcustom\";i:1;s:16:\"commentstatusdiv\";i:2;s:7:\"slugdiv\";i:3;s:9:\"authordiv\";}'),
(83, 1, 'nav_menu_recently_edited', '27'),
(84, 1, 'closedpostboxes_nav-menus', 'a:0:{}'),
(85, 1, 'closedpostboxes_product', 'a:5:{i:0;s:8:\"age_gate\";i:1;s:26:\"woocommerce-product-images\";i:2;s:14:\"product_catdiv\";i:3;s:19:\"tagsdiv-product_tag\";i:4;s:16:\"product_branddiv\";}'),
(86, 1, 'metaboxhidden_product', 'a:2:{i:0;s:10:\"postcustom\";i:1;s:7:\"slugdiv\";}'),
(88, 1, 'tophorny__stripe_customer_id', 'cus_RnfrLNY1Jlle7W'),
(89, 1, 'paying_customer', '1'),
(92, 1, 'woocommerce_admin_variable_product_tour_shown', 'yes'),
(93, 1, 'wp_mail_smtp_pro_banner_dismissed', '1'),
(94, 1, 'session_tokens', 'a:5:{s:64:\"aceecfde0ee038e5dcc727c946415d79e7ad0919eb219e2d3c46ce1f0d95bb01\";a:4:{s:10:\"expiration\";i:1742275229;s:2:\"ip\";s:13:\"123.205.15.40\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36\";s:5:\"login\";i:1741065629;}s:64:\"718f2b056a6550e6a14e097d0b39b3ee461da3b5863282c7c5071e33bdf406ef\";a:4:{s:10:\"expiration\";i:1742275243;s:2:\"ip\";s:13:\"123.205.15.40\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36\";s:5:\"login\";i:1741065643;}s:64:\"ea451b37fabe8533637a5100d941edaa2fa20cabb1e233fb8e1587cf4ebd8e48\";a:4:{s:10:\"expiration\";i:1742275259;s:2:\"ip\";s:13:\"123.205.15.40\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36\";s:5:\"login\";i:1741065659;}s:64:\"31214046b571248a2b278f5ccf025ecb24e91cafc8303651b87713d09f9e8678\";a:4:{s:10:\"expiration\";i:1741271880;s:2:\"ip\";s:13:\"123.205.15.40\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36\";s:5:\"login\";i:1741099080;}s:64:\"9fd43ac197878d3d743ae4e66f83efd339453a89fe03867a7c9b96d55bf6a5ed\";a:4:{s:10:\"expiration\";i:1741271981;s:2:\"ip\";s:13:\"123.205.15.40\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36\";s:5:\"login\";i:1741099181;}}'),
(96, 1, '_woocommerce_persistent_cart_1', 'a:1:{s:4:\"cart\";a:0:{}}'),
(99, 1, 'rocket_boxes', 'a:2:{i:0;s:24:\"rocket_activation_notice\";i:1;s:34:\"rocket_warning_plugin_modification\";}'),
(100, 1, 'ignore_code_snippets_survey_message', 'survey'),
(102, 1, 'advanced-ads-hide-wizard', 'true'),
(103, 1, 'closedpostboxes_advanced_ads', 'a:0:{}'),
(104, 1, 'metaboxhidden_advanced_ads', 'a:1:{i:0;s:7:\"slugdiv\";}'),
(105, 1, 'manageedit-advanced_adscolumnshidden', 'a:6:{i:0;s:14:\"ad_description\";i:1;s:7:\"ad_size\";i:2;s:9:\"ad_timing\";i:3;s:7:\"ad_date\";i:4;s:6:\"author\";i:5;s:28:\"taxonomy-advanced_ads_groups\";}'),
(106, 1, 'advanced-ads-ad-list-screen-options', 'a:1:{s:12:\"show-filters\";b:0;}'),
(107, 1, 'edit_advanced_ads_per_page', '20');

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

--
-- 資料表結構 `tophorny_users`
--

CREATE TABLE `tophorny_users` (
  `ID` bigint(20) UNSIGNED NOT NULL,
  `user_login` varchar(60) NOT NULL DEFAULT '',
  `user_pass` varchar(255) NOT NULL DEFAULT '',
  `user_nicename` varchar(50) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_url` varchar(100) NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT 0,
  `display_name` varchar(250) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_users`
--

INSERT INTO `tophorny_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
(1, 'wpstudio', '$P$B2Qxf7j7fdl3k6ax5Ds8IrBz9QIe/w1', 'wpstudio', 'service@wpstudio.com.tw', 'https://tophorny.com', '2025-02-13 16:31:41', '', 0, 'wpstudio');

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

--
-- 資料表結構 `tophorny_user_verification_stats`
--

CREATE TABLE `tophorny_user_verification_stats` (
  `id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_wc_admin_notes`
--

CREATE TABLE `tophorny_wc_admin_notes` (
  `note_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL,
  `locale` varchar(20) NOT NULL,
  `title` longtext NOT NULL,
  `content` longtext NOT NULL,
  `content_data` longtext DEFAULT NULL,
  `status` varchar(200) NOT NULL,
  `source` varchar(200) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_reminder` datetime DEFAULT NULL,
  `is_snoozable` tinyint(1) NOT NULL DEFAULT 0,
  `layout` varchar(20) NOT NULL DEFAULT '',
  `image` varchar(200) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `icon` varchar(200) NOT NULL DEFAULT 'info'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wc_admin_notes`
--

INSERT INTO `tophorny_wc_admin_notes` (`note_id`, `name`, `type`, `locale`, `title`, `content`, `content_data`, `status`, `source`, `date_created`, `date_reminder`, `is_snoozable`, `layout`, `image`, `is_deleted`, `is_read`, `icon`) VALUES
(1, 'wc-refund-returns-page', 'info', 'en_US', '設定退款和退貨政策頁面，提高商店可信度。', '我們已為你建立退款和退貨政策的範例草稿頁面。 請查看該頁面並視貴店需求加以更新。', '{}', 'unactioned', 'woocommerce-core', '2025-02-14 01:32:04', NULL, 0, 'plain', '', 0, 1, 'info'),
(2, 'wayflyer_bnpl_q4_2021', 'marketing', 'en_US', 'Grow your business with funding through Wayflyer', 'Fast, flexible financing to boost cash flow and help your business grow – one fee, no interest rates, penalties, equity, or personal guarantees. Based on your store’s performance, Wayflyer provides funding and analytical insights to invest in your business.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(3, 'wc_shipping_mobile_app_usps_q4_2021', 'marketing', 'en_US', 'Print and manage your shipping labels with WooCommerce Shipping and the WooCommerce Mobile App', 'Save time by printing, purchasing, refunding, and tracking shipping labels generated by <a href=\"https://woocommerce.com/woocommerce-shipping/\">WooCommerce Shipping</a> – all directly from your mobile device!', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(4, 'your-first-product', 'info', 'en_US', 'Your first product', 'That’s huge! You’re well on your way to building a successful online store — now it’s time to think about how you’ll fulfill your orders.<br /><br />Read our shipping guide to learn best practices and options for putting together your shipping strategy. And for WooCommerce stores in the United States, you can print discounted shipping labels via USPS with <a href=\"https://href.li/?https://woocommerce.com/shipping\" target=\"_blank\">WooCommerce Shipping</a>.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(5, 'wc-admin-optimizing-the-checkout-flow', 'info', 'en_US', 'Optimizing the checkout flow', 'It’s crucial to get your store’s checkout as smooth as possible to avoid losing sales. Let’s take a look at how you can optimize the checkout experience for your shoppers.', '{}', 'unactioned', 'woocommerce.com', '2025-02-20 03:32:48', NULL, 0, 'plain', '', 0, 1, 'info'),
(6, 'wc-payments-qualitative-feedback', 'info', 'en_US', 'WooPayments setup - let us know what you think', 'Congrats on enabling WooPayments for your store. Please share your feedback in this 2 minute survey to help us improve the setup process.', '{}', 'unactioned', 'woocommerce.com', '2025-02-20 03:32:48', NULL, 0, 'plain', '', 0, 1, 'info'),
(7, 'share-your-feedback-on-paypal', 'info', 'en_US', 'Share your feedback on PayPal', 'Share your feedback in this 2 minute survey about how we can make the process of accepting payments more useful for your store.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(8, 'google_listings_and_ads_install', 'marketing', 'en_US', 'Drive traffic and sales with Google', 'Reach online shoppers to drive traffic and sales for your store by showcasing products across Google, for free or with ads.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(9, 'wc-subscriptions-security-update-3-0-15', 'info', 'en_US', 'WooCommerce Subscriptions security update!', 'We recently released an important security update to WooCommerce Subscriptions. To ensure your site’s data is protected, please upgrade <strong>WooCommerce Subscriptions to version 3.0.15</strong> or later.<br /><br />Click the button below to view and update to the latest Subscriptions version, or log in to <a href=\"https://woocommerce.com/my-dashboard\">WooCommerce.com Dashboard</a> and navigate to your <strong>Downloads</strong> page.<br /><br />We recommend always using the latest version of WooCommerce Subscriptions, and other software running on your site, to ensure maximum security.<br /><br />If you have any questions we are here to help — just <a href=\"https://woocommerce.com/my-account/create-a-ticket/\">open a ticket</a>.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(10, 'woocommerce-core-update-5-4-0', 'info', 'en_US', 'Update to WooCommerce 5.4.1 now', 'WooCommerce 5.4.1 addresses a checkout issue discovered in WooCommerce 5.4. We recommend upgrading to WooCommerce 5.4.1 as soon as possible.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(11, 'wcpay-promo-2020-11', 'marketing', 'en_US', 'wcpay-promo-2020-11', 'wcpay-promo-2020-11', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(12, 'wcpay-promo-2020-12', 'marketing', 'en_US', 'wcpay-promo-2020-12', 'wcpay-promo-2020-12', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(13, 'ppxo-pps-upgrade-paypal-payments-1', 'info', 'en_US', 'Get the latest PayPal extension for WooCommerce', 'Heads up! There’s a new PayPal on the block!<br /><br />Now is a great time to upgrade to our latest <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">PayPal extension</a> to continue to receive support and updates with PayPal.<br /><br />Get access to a full suite of PayPal payment methods, extensive currency and country coverage, and pay later options with the all-new PayPal extension for WooCommerce.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(14, 'ppxo-pps-upgrade-paypal-payments-2', 'info', 'en_US', 'Upgrade your PayPal experience!', 'Get access to a full suite of PayPal payment methods, extensive currency and country coverage, offer subscription and recurring payments, and the new PayPal pay later options.<br /><br />Start using our <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">latest PayPal today</a> to continue to receive support and updates.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(15, 'woocommerce-core-sqli-july-2021-need-to-update', 'update', 'en_US', 'Action required: Critical vulnerabilities in WooCommerce', 'In response to a critical vulnerability identified on July 13, 2021, we are working with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br />Our investigation into this vulnerability is ongoing, but <strong>we wanted to let you know now about the importance of updating immediately</strong>.<br /><br />For more information on which actions you should take, as well as answers to FAQs, please urgently review our blog post detailing this issue.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(16, 'woocommerce-blocks-sqli-july-2021-need-to-update', 'update', 'en_US', 'Action required: Critical vulnerabilities in WooCommerce Blocks', 'In response to a critical vulnerability identified on July 13, 2021, we are working with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br />Our investigation into this vulnerability is ongoing, but <strong>we wanted to let you know now about the importance of updating immediately</strong>.<br /><br />For more information on which actions you should take, as well as answers to FAQs, please urgently review our blog post detailing this issue.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(17, 'woocommerce-core-sqli-july-2021-store-patched', 'update', 'en_US', 'Solved: Critical vulnerabilities patched in WooCommerce', 'In response to a critical vulnerability identified on July 13, 2021, we worked with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br /><strong>Your store has been updated to the latest secure version(s)</strong>. For more information and answers to FAQs, please review our blog post detailing this issue.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(18, 'woocommerce-blocks-sqli-july-2021-store-patched', 'update', 'en_US', 'Solved: Critical vulnerabilities patched in WooCommerce Blocks', 'In response to a critical vulnerability identified on July 13, 2021, we worked with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br /><strong>Your store has been updated to the latest secure version(s)</strong>. For more information and answers to FAQs, please review our blog post detailing this issue.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(19, 'habit-moment-survey', 'marketing', 'en_US', 'We’re all ears! Share your experience so far with WooCommerce', 'We’d love your input to shape the future of WooCommerce together. Feel free to share any feedback, ideas or suggestions that you have.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(20, 'woocommerce-core-paypal-march-2022-updated', 'update', 'en_US', 'Security auto-update of WooCommerce', '<strong>Your store has been updated to the latest secure version of WooCommerce</strong>. We worked with WordPress to deploy PayPal Standard security updates for stores running WooCommerce (version 3.5 to 6.3). It’s recommended to disable PayPal Standard, and use <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">PayPal Payments</a> to accept PayPal.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(21, 'woocommerce-core-paypal-march-2022-updated-nopp', 'update', 'en_US', 'Security auto-update of WooCommerce', '<strong>Your store has been updated to the latest secure version of WooCommerce</strong>. We worked with WordPress to deploy security updates related to PayPal Standard payment gateway for stores running WooCommerce (version 3.5 to 6.3).', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(22, 'pinterest_03_2022_update', 'marketing', 'en_US', 'Your Pinterest for WooCommerce plugin is out of date!', 'Update to the latest version of Pinterest for WooCommerce to continue using this plugin and keep your store connected with Pinterest. To update, visit <strong>Plugins &gt; Installed Plugins</strong>, and click on “update now” under Pinterest for WooCommerce.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(23, 'store_setup_survey_survey_q2_2022', 'survey', 'en_US', 'How is your store setup going?', 'Our goal is to make sure you have all the right tools to start setting up your store in the smoothest way possible.\r\nWe’d love to know if we hit our mark and how we can improve. To collect your thoughts, we made a 2-minute survey.', '{}', 'unactioned', 'woocommerce.com', '2025-02-21 02:31:01', NULL, 0, 'plain', '', 0, 1, 'info'),
(24, 'needs-update-eway-payment-gateway-rin-2022-12-20', 'update', 'en_US', 'Security vulnerability patched in WooCommerce Eway Gateway', 'In response to a potential vulnerability identified in WooCommerce Eway Gateway versions 3.1.0 to 3.5.0, we’ve worked to deploy security fixes and have released an updated version.\r\nNo external exploits have been detected, but we recommend you update to your latest supported version 3.1.26, 3.2.3, 3.3.1, 3.4.6, or 3.5.1', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(25, 'updated-eway-payment-gateway-rin-2022-12-20', 'update', 'en_US', 'WooCommerce Eway Gateway has been automatically updated', 'Your store is now running the latest secure version of WooCommerce Eway Gateway. We worked with the WordPress Plugins team to deploy a software update to stores running WooCommerce Eway Gateway (versions 3.1.0 to 3.5.0) in response to a security vulnerability that was discovered.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(26, 'ecomm-wc-navigation-survey-2023', 'info', 'en_US', 'Navigating WooCommerce on WordPress.com', 'We are improving the WooCommerce navigation on WordPress.com and would love your help to make it better! Please share your experience with us in this 2-minute survey.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(27, 'woopay-beta-merchantrecruitment-04MAY23', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'WooPay, a new express checkout feature built into WooCommerce Payments, is now available —and we’re inviting you to be one of the first to try it. \r\n<br><br>\r\nBoost conversions by offering your customers a simple, secure way to pay with a single click.\r\n<br><br>\r\nGet started in seconds.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(28, 'woocommerce-wcpay-march-2023-update-needed', 'update', 'en_US', 'Action required: Security update for WooCommerce Payments', '<strong>Your store requires a security update for WooCommerce Payments</strong>. Please update to the latest version of WooCommerce Payments immediately to address a potential vulnerability discovered on March 22. For more information on how to update, visit this WooCommerce Developer Blog Post.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(29, 'tap_to_pay_iphone_q2_2023_no_wcpay', 'marketing', 'en_US', 'Accept in-person contactless payments on your iPhone', 'Tap to Pay on iPhone and WooCommerce Payments is quick, secure, and simple to set up — no extra terminals or card readers are needed. Accept contactless debit and credit cards, Apple Pay, and other NFC digital wallets in person.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(30, 'woocommerce-WCPreOrders-april-2023-update-needed', 'update', 'en_US', 'Action required: Security update of WooCommerce Pre-Orders extension', '<strong>Your store requires a security update for the WooCommerce Pre-Orders extension</strong>. Please update the WooCommerce Pre-Orders extension immediately to address a potential vulnerability discovered on April 11.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(31, 'woopay-beta-merchantrecruitment-update-04MAY23', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'WooPay, a new express checkout feature built into WooCommerce Payments, is now available — and you’re invited to try it. \r\n<br /><br />\r\nBoost conversions by offering your customers a simple, secure way to pay with a single click.\r\n<br /><br />\r\nUpdate WooCommerce Payments to get started.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(32, 'woopay-beta-existingmerchants-noaction-27APR23', 'info', 'en_US', 'WooPay is back!', 'Thanks for previously trying WooPay, the express checkout feature built into WooCommerce Payments. We’re excited to announce that WooPay availability has resumed. No action is required on your part.\r\n<br /><br />\r\nYou can now continue boosting conversions by offering your customers a simple, secure way to pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(33, 'woopay-beta-existingmerchants-update-27APR23', 'info', 'en_US', 'WooPay is back!', 'Thanks for previously trying WooPay, the express checkout feature built into WooCommerce Payments. We’re excited to announce that WooPay availability has resumed.\r\n<br /><br />\r\n\r\nUpdate to the latest WooCommerce Payments version to continue boosting conversions by offering your customers a simple, secure way to pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(34, 'woopay-beta-merchantrecruitment-short-04MAY23', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(35, 'woopay-beta-merchantrecruitment-short-update-04MAY23', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, our new express checkout feature. <br>Boost conversions by letting customers pay with a single click. <br><br>Update to the latest version of WooCommerce Payments to get started.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(36, 'woopay-beta-merchantrecruitment-short-06MAY23-TESTA', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(37, 'woopay-beta-merchantrecruitment-short-06MAY23-TESTB', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(38, 'woopay-beta-merchantrecruitment-short-06MAY23-TESTC', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(39, 'woopay-beta-merchantrecruitment-short-06MAY23-TESTD', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(40, 'woopay-beta-merchantrecruitment-short-09MAY23', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(41, 'woopay-beta-merchantrecruitment-short-update-09MAY23', 'info', 'en_US', 'Increase conversions with WooPay — our fastest checkout yet', 'Be one of the first to try WooPay, our new express checkout feature. <br>Boost conversions by letting customers pay with a single click. <br><br>Update to the latest version of WooCommerce Payments to get started.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(42, 'woocommerce-WCSubscriptions-June-2023-updated-needed', 'marketing', 'en_US', 'Action required: Security update of WooCommerce Subscriptions', '<strong>Your store requires a security update for the WooCommerce Subscriptions plugin</strong>. Please update the WooCommerce Subscriptions plugin immediately to address a potential vulnerability.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(43, 'woocommerce-WCReturnsWarranty-June-2023-updated-needed', 'update', 'en_US', 'Action required: Security update of WooCommerce Returns and Warranty Requests extension', '<strong>Your store requires a security update for the Returns and Warranty Requests extension</strong>.  Please update to the latest version of the WooCommerce Returns and Warranty Requests extension immediately to address a potential vulnerability discovered on May 31.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(44, 'woocommerce-WCOPC-June-2023-updated-needed', 'update', 'en_US', 'Action required: Security update of WooCommerce One Page Checkout', '<strong>Your shop requires a security update to address a vulnerability in the WooCommerce One Page Checkout extension</strong>. The fix for this vulnerability was released for this extension on June 13th. Please update immediately.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(45, 'woocommerce-WCGC-July-2023-update-needed', 'update', 'en_US', 'Action required: Security update of WooCommerce GoCardless Extension', '<strong>Your shop requires a security update to address a vulnerability in the WooCommerce GoCardless extension</strong>. The fix for this vulnerability was released on July 4th. Please update immediately.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(46, 'woocommerce-shipping-fedex-api-outage-2023-07-16', 'warning', 'en_US', 'Scheduled FedEx API outage — July 2023', 'On July 16 there will be a full outage of the FedEx API from 04:00 to 08:00 AM UTC. Due to planned maintenance by FedEx, you\'ll be unable to provide FedEx shipping rates during this time. Follow the link below for more information and recommendations on how to minimize impact.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(47, 'wcship-2023-07-hazmat-update-needed', 'update', 'en_US', 'Action required: USPS HAZMAT compliance update for WooCommerce Shipping & Tax extension', '<strong>Your store requires an update for the WooCommerce Shipping extension</strong>. Please update to the latest version of the WooCommerce Shipping &amp; Tax extension immediately to ensure compliance with new USPS HAZMAT rules currently in effect.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(48, 'woocommerce-WCStripe-Aug-2023-update-needed', 'update', 'en_US', 'Action required: Security update for WooCommerce Stripe plugin', '<strong>Your shop requires an important security update for the  WooCommerce Stripe plugin</strong>. The fix for this vulnerability was released on July 31. Please update immediately.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(49, 'woocommerce-WCStripe-Aug-2023-security-updated', 'update', 'en_US', 'Security update of WooCommerce Stripe plugin', '<strong>Your store has been updated to the latest secure version of the WooCommerce Stripe plugin</strong>. This update was released on July 31.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(50, 'woocommerce-WooPayments-Aug-2023-security-updated', 'update', 'en_US', 'Security update of WooPayments (WooCommerce Payments) plugin', '<strong>Your store has been updated to the more secure version of WooPayments (WooCommerce Payments)</strong>. This update was released on July 31.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(51, 'avalara_q3-2023_noAvaTax', 'marketing', 'en_US', 'Automatically calculate VAT in real time', 'Take the effort out of determining tax rates and sell confidently across borders with automated tax management from Avalara AvaTax— including built-in VAT calculation when you sell into or across the EU and UK. Save time and stay compliant when you let Avalara do the heavy lifting.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(52, 'woocommerce-usermeta-Sept2023-productvendors', 'update', 'en_US', 'Your store requires a security update', '<strong>Your shop needs an update to address a vulnerability in WooCommerce.</strong> The fix was released on Sept 15. Please update WooCommerce to the latest version immediately. <a href=\"https://developer.woocommerce.com/2023/09/16/woocommerce-vulnerability-reintroduced-from-7-0-1/\" />Read our developer update</a> for more information.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(53, 'woocommerce-STRIPE-Oct-2023-update-needed', 'update', 'en_US', 'Action required: Security update for WooCommerce Stripe Gateway', '<strong>Your shop requires a security update to address a vulnerability in the WooCommerce Stripe Gateway</strong>. The fix for this vulnerability was released on October 17. Please update immediately.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(54, 'amazon-mcf-reviews-2023-12-07', 'marketing', 'en_US', 'Enjoying Amazon MCF for WooCommerce?', 'We\'re Never Settle, the developers behind Amazon MCF for WooCommerce, and would be deeply honored to have your review. Reviews help immensely as other users can learn how MCF can solve their needs too! Not happy or need help? Please reach out for support and we’d love to make things right!', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(55, 'remove_estimated_deposits_2024', 'marketing', 'en_US', 'Estimated deposits are going away', 'To provide more accurate deposit information and support the expansion of instant deposits, estimated deposit details will no longer be available in WooPayments. We recommend upgrading to the latest version of WooPayments for more detailed balance status information.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(56, 'sirt-woo-2024-11-xss-admin', 'update', 'en_US', 'An important update is required for WooCommerce', 'This update addresses a security vulnerability that could allow unauthorized access to administrative privileges on your site. <a href=\"https://developer.woocommerce.com/2024/12/03/woocommerce-9-4-3-and-woocommerce-9-3-4-available-now/\">Learn more</a>.\r\n<br><br>\r\n<strong>Please ensure your site is updated to the latest version to stay secure.</strong>', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(57, 'woocommerce-analytics-order-attribution-promotions-december-2024', 'marketing', 'en_US', 'Discover what drives your sales', 'Use our powerful <strong>Order Attribution</strong> extension to understand what truly drives your revenue. Track your sales journey, identify your most effective marketing channels, and optimize your sales strategy.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(58, 'paypal_bnpl_au_promo_Q1_2025', 'marketing', 'en_US', 'Australian shoppers can Pay in 4 with PayPal', 'Enable Pay in 4 messaging to let Australian customers know that they can pay over time while you get paid up front and in full. Pay in 4 is included in PayPal Payments at no additional cost. Eligible buyers can pay in four interest-free payments for purchases of $30 to $2,000 AUD. Terms apply.', '{}', 'pending', 'woocommerce.com', '2025-02-14 01:32:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(59, 'wc-admin-choosing-a-theme', 'marketing', 'en_US', '想要選擇佈景主題嗎？', '瀏覽與 WooCommerce 相容的佈景主題，然後挑選符合品牌及商業需求的樣式。', '{}', 'unactioned', 'woocommerce-admin', '2025-02-15 09:15:35', NULL, 0, 'plain', '', 0, 0, 'info'),
(60, 'wc-admin-add-first-product-note', 'email', 'en_US', '新增第一個產品', '{greetings}<br /><br />Nice one;你已建立了 WooCommerce 商店！ 現在該新增第一項產品，開始銷售。<br /><br />新增產品的方法有三種：你可以<strong>手動建立產品、以 CSV 檔案一次匯入</strong>，或<strong>從其他服務移轉過來</strong>。<br /><br /><a href=\"https://woocommerce.com/document/managing-products/?utm_source=help_panel&amp;utm_medium=product\">探索我們的文件</a>以瞭解更多資訊，或直接開始使用！', '{\"role\":\"administrator\"}', 'unactioned', 'woocommerce-admin', '2025-02-16 05:10:49', NULL, 0, 'plain', 'http://tophorny.com/wp-content/plugins/woocommerce/images/admin_notes/dashboard-widget-setup.png', 0, 0, 'info'),
(61, 'wc-admin-mobile-app', 'info', 'en_US', '安裝 Woo 行動應用程式', '只要安裝 WooCommerce　行動應用程式，不論身在何處皆可管理訂單、接收銷售通知及檢視關鍵指標。', '{}', 'unactioned', 'woocommerce-admin', '2025-02-16 05:10:49', NULL, 0, 'plain', '', 0, 0, 'info'),
(62, 'wc-admin-onboarding-payments-reminder', 'info', 'en_US', '開始在商店上接受付款！', '透過適合你的供應商收取付款 — WooCommerce 有超過 100 種付款途徑可供選擇。', '{}', 'unactioned', 'woocommerce-admin', '2025-02-19 02:54:54', NULL, 0, 'plain', '', 0, 0, 'info'),
(63, 'wc-admin-orders-milestone', 'info', 'en_US', '收到第一筆訂單', '恭喜你收到第一筆訂單！ 現在正是學習如何管理訂單的好時機。', '{\"current_milestone\":1}', 'unactioned', 'woocommerce-admin', '2025-02-19 06:48:05', NULL, 0, 'plain', '', 0, 0, 'info'),
(64, 'wc-admin-launch-checklist', 'info', 'en_US', '準備好推出你的商店了嗎？', '為確保你永遠不用經歷「我到底忘了什麼」的沈重感受，我們製作了重要的推出前檢查清單。', '{}', 'unactioned', 'woocommerce-admin', '2025-02-20 03:32:46', NULL, 0, 'plain', '', 0, 0, 'info'),
(65, 'stripe_stripetax_q1_2025', 'marketing', 'en_US', 'Say goodbye to your tax woes', 'Stripe Tax automatically applies the correct sales tax, VAT, or GST, saving time while keeping you compliant. And with simple automatic filing, you can stop stressing at tax time and focus on growing instead.', '{}', 'pending', 'woocommerce.com', '2025-02-20 03:32:48', NULL, 0, 'plain', '', 0, 0, 'info'),
(66, 'wc-admin-customizing-product-catalog', 'info', 'en_US', '如何自訂產品目錄', '你會希望產品目錄和圖片精美動人，並且符合品牌精神。 本指南將提供你所需的一切秘訣，讓商店產品看起來光彩奪目。', '{}', 'unactioned', 'woocommerce-admin', '2025-02-21 02:30:58', NULL, 0, 'plain', '', 0, 1, 'info'),
(67, 'printful_promo_q1_2025', 'marketing', 'en_US', 'New: sell print-on-demand products, risk-free', 'Expand your product line with Printful, now available in the WooCommerce Marketplace. Sell custom products with no upfront costs or inventory. This trusted supplier prints, packages, and ships for you, so you can focus on growing your store — and your next big idea.', '{}', 'pending', 'woocommerce.com', '2025-03-02 11:51:43', NULL, 0, 'plain', '', 0, 0, 'info'),
(68, 'wc-admin-new-sales-record', 'info', 'en_US', '創下新的銷售記錄！', '喔耶，你在 2025 年 3 月 2 日 創下銷售記錄了！ 淨銷售額達到 $1.99，打破之前在 2025 年 2 月 19 日 創下的記錄 $1.00。', '{\"old_record_date\":\"2025-02-19\",\"old_record_amt\":1,\"new_record_date\":\"2025-03-02\",\"new_record_amt\":1.99}', 'unactioned', 'woocommerce-admin', '2025-03-03 08:34:10', NULL, 0, 'plain', '', 0, 1, 'info'),
(69, 'paypal-braintree-sdk-depreciation-2025-02-20', 'update', 'en_US', 'Update required for your PayPal Braintree extension', 'To continue securely accepting payments, you must update your PayPal Braintree extension to version 3.2.4 or newer before June 30, 2025. Your current extension version will not support payment processing after this date due to an SSL certificate update.', '{}', 'pending', 'woocommerce.com', '2025-03-04 01:33:45', NULL, 0, 'plain', '', 0, 0, 'info');

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

--
-- 資料表結構 `tophorny_wc_admin_note_actions`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_admin_note_actions`
--

INSERT INTO `tophorny_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', '編輯頁面', 'https://tophorny.com/wp-admin/post.php?post=15&action=edit', 'actioned', '', NULL, NULL),
(87, 59, 'visit-the-theme-marketplace', '造訪佈景主題市集', 'https://woocommerce.com/product-category/themes/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(172, 58, 'paypal_bnpl_au_promo_Q1_2025_button', 'Enable “Pay in 4” now', 'https://woocommerce.com/document/woocommerce-paypal-payments/?utm_source=inbox_note&utm_medium=product&utm_campaign=paypal_bnpl_au_promo_Q1_2025_button#pay-later-tab', 'unactioned', '', NULL, NULL),
(173, 60, 'add-first-product', '新增產品', 'https://tophorny.com/wp-admin/admin.php?page=wc-admin&task=products', 'actioned', '', NULL, NULL),
(174, 61, 'learn-more', '進一步了解', 'https://woocommerce.com/mobile/?utm_medium=product', 'actioned', '', NULL, NULL),
(427, 62, 'view-payment-gateways', '進一步了解', 'https://woocommerce.com/product-category/woocommerce-extensions/payment-gateways/?utm_medium=product', 'actioned', '', NULL, NULL),
(596, 63, 'learn-more', '進一步了解', 'https://woocommerce.com/document/managing-orders/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(597, 64, 'learn-more', '進一步了解', 'https://woocommerce.com/posts/pre-launch-checklist-the-essentials/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(683, 66, 'day-after-first-product', '進一步了解', 'https://woocommerce.com/document/woocommerce-customizer/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(768, 65, 'stripe_stripetax_q1_2025_click', 'Automate my taxes with Stripe', 'https://woocommerce.com/products/stripe-tax/?utm_source=inbox_note&utm_medium=product&utm_campaign=stripe_stripetax_q1_2025_click', 'unactioned', '', NULL, NULL),
(1364, 68, 'view-report', '查看報表', '?page=wc-admin&path=/analytics/revenue&period=custom&compare=previous_year&after=2025-03-02&before=2025-03-02', 'actioned', '', NULL, NULL),
(2568, 2, 'wayflyer_bnpl_q4_2021', 'Level up with funding', 'https://woocommerce.com/products/wayflyer/?utm_source=inbox_note&utm_medium=product&utm_campaign=wayflyer_bnpl_q4_2021', 'actioned', '', NULL, NULL),
(2569, 3, 'wc_shipping_mobile_app_usps_q4_2021', 'Get WooCommerce Shipping', 'https://woocommerce.com/woocommerce-shipping/?utm_source=inbox_note&utm_medium=product&utm_campaign=wc_shipping_mobile_app_usps_q4_2021', 'actioned', '', NULL, NULL),
(2570, 4, '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),
(2571, 5, '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),
(2572, 6, 'qualitative-feedback-from-new-users', 'Share feedback', 'https://automattic.survey.fm/woopayments-new-user-feedback', 'actioned', '', NULL, NULL),
(2573, 7, 'share-feedback', 'Share feedback', 'http://automattic.survey.fm/paypal-feedback', 'unactioned', '', NULL, NULL),
(2574, 8, '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),
(2575, 9, 'update-wc-subscriptions-3-0-15', 'View latest version', 'https://tophorny.com/wp-admin/&page=wc-addons&section=helper', 'actioned', '', NULL, NULL),
(2576, 10, 'update-wc-core-5-4-0', 'How to update WooCommerce', 'https://docs.woocommerce.com/document/how-to-update-woocommerce/', 'actioned', '', NULL, NULL),
(2577, 13, 'ppxo-pps-install-paypal-payments-1', 'View upgrade guide', 'https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/', 'actioned', '', NULL, NULL),
(2578, 14, 'ppxo-pps-install-paypal-payments-2', 'View upgrade guide', 'https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/', 'actioned', '', NULL, NULL),
(2579, 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),
(2580, 15, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(2581, 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),
(2582, 16, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(2583, 17, '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),
(2584, 17, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(2585, 18, '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),
(2586, 18, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(2587, 19, 'share-feedback', 'Share feedback', 'https://automattic.survey.fm/store-management', 'unactioned', '', NULL, NULL),
(2588, 20, 'learn-more', 'Learn more', 'https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/', 'unactioned', '', NULL, NULL),
(2589, 20, 'woocommerce-core-paypal-march-2022-dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(2590, 21, 'learn-more', 'Learn more', 'https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/', 'unactioned', '', NULL, NULL),
(2591, 21, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(2592, 22, '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),
(2593, 23, '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),
(2594, 24, 'needs-update-eway-payment-gateway-rin-action-button-2022-12-20', 'See available updates', 'https://tophorny.com/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(2595, 24, 'needs-update-eway-payment-gateway-rin-dismiss-button-2022-12-20', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2596, 25, 'updated-eway-payment-gateway-rin-action-button-2022-12-20', 'See all updates', 'https://tophorny.com/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(2597, 25, 'updated-eway-payment-gateway-rin-dismiss-button-2022-12-20', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2598, 26, 'share-navigation-survey-feedback', 'Share feedback', 'https://automattic.survey.fm/new-ecommerce-plan-navigation', 'actioned', '', NULL, NULL),
(2599, 27, 'woopay-beta-merchantrecruitment-activate-04MAY23', 'Activate WooPay', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(2600, 27, '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),
(2601, 28, '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),
(2602, 28, 'woocommerce-wcpay-march-2023-update-needed-dismiss-button', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2603, 29, '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),
(2604, 30, 'extension-settings', 'See available updates', 'https://tophorny.com/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(2605, 30, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2606, 31, 'woopay-beta-merchantrecruitment-update-WCPay-04MAY23', 'Update WooCommerce Payments', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(2607, 31, 'woopay-beta-merchantrecruitment-update-activate-04MAY23', 'Activate WooPay', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(2608, 32, '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),
(2609, 33, 'woopay-beta-existingmerchants-update-WCPay-27APR23', 'Update WooCommerce Payments', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'actioned', '', NULL, NULL),
(2610, 34, 'woopay-beta-merchantrecruitment-short-activate-04MAY23', 'Activate WooPay', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(2611, 34, '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),
(2612, 35, 'woopay-beta-merchantrecruitment-short-update-WCPay-04MAY23', 'Update WooCommerce Payments', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(2613, 35, 'woopay-beta-merchantrecruitment-short-update-activate-04MAY23', 'Activate WooPay', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'actioned', '', NULL, NULL),
(2614, 36, 'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTA', 'Activate WooPay Test A', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(2615, 36, 'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA', 'Learn More', 'https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA', 'unactioned', '', NULL, NULL),
(2616, 37, 'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTB', 'Activate WooPay Test B', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(2617, 37, 'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA', 'Learn More', 'https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA', 'unactioned', '', NULL, NULL),
(2618, 38, 'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTC', 'Activate WooPay Test C', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(2619, 38, 'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTC', 'Learn More', 'https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTC', 'unactioned', '', NULL, NULL),
(2620, 39, 'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTD', 'Activate WooPay Test D', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(2621, 39, 'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTD', 'Learn More', 'https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTD', 'unactioned', '', NULL, NULL),
(2622, 40, 'woopay-beta-merchantrecruitment-short-activate-button-09MAY23', 'Activate WooPay', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(2623, 40, '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),
(2624, 41, 'woopay-beta-merchantrecruitment-short-update-WCPay-09MAY23', 'Update WooCommerce Payments', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(2625, 41, 'woopay-beta-merchantrecruitment-short-update-activate-09MAY23', 'Activate WooPay', 'https://tophorny.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout', 'unactioned', '', NULL, NULL),
(2626, 42, 'woocommerce-WCSubscriptions-June-2023-updated-needed-Plugin-Settings', 'See available updates', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(2627, 42, 'woocommerce-WCSubscriptions-June-2023-updated-needed-dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2628, 43, 'woocommerce-WCReturnsWarranty-June-2023-updated-needed', 'See available updates', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(2629, 43, 'woocommerce-WCReturnsWarranty-June-2023-updated-needed', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2630, 44, 'woocommerce-WCOPC-June-2023-updated-needed', 'See available updates', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'actioned', '', NULL, NULL),
(2631, 44, 'woocommerce-WCOPC-June-2023-updated-needed', 'Dismiss', 'https://tophorny.com/wp-admin/#', 'actioned', '', NULL, NULL),
(2632, 45, 'woocommerce-WCGC-July-2023-update-needed', 'See available updates', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(2633, 45, 'woocommerce-WCGC-July-2023-update-needed', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2634, 46, '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),
(2635, 47, 'plugin-list', 'See available updates', 'https://tophorny.com/wp-admin/plugins.php?plugin_status=all', 'unactioned', '', NULL, NULL),
(2636, 47, 'dismiss', 'Dismiss', 'https://tophorny.com/wp-admin/admin.php?page=wc-admin', 'actioned', '', NULL, NULL),
(2637, 48, 'woocommerce-WCStripe-Aug-2023-update-needed', 'See available updates', 'https://tophorny.com/wp-admin/update-core.php?', 'unactioned', '', NULL, NULL),
(2638, 48, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2639, 49, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2640, 50, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2641, 51, '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),
(2642, 52, 'woocommerce-usermeta-Sept2023-productvendors', 'See available updates', 'https://tophorny.com/wp-admin/plugins.php', 'unactioned', '', NULL, NULL),
(2643, 52, 'dismiss', 'Dismiss', 'https://tophorny.com/wp-admin/#', 'actioned', '', NULL, NULL),
(2644, 53, 'woocommerce-STRIPE-Oct-2023-update-needed', 'See available updates', 'https://tophorny.com/wp-admin/update-core.php', 'unactioned', '', NULL, NULL),
(2645, 53, 'dismiss', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2646, 54, '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),
(2647, 54, '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),
(2648, 55, '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),
(2649, 56, 'sirt-woo-2024-11-xss-admin', 'See available updates', 'https://tophorny.com/wp-admin/update-core.php?', 'unactioned', '', NULL, NULL),
(2650, 56, 'sirt-woo-2024-11-xss-admin', 'Dismiss', '#', 'actioned', '', NULL, NULL),
(2651, 57, 'woocommerce-analytics-order-attribution-promotions-december-2024-find-out-more', 'Find out more', 'https://wordpress.org/plugins/woocommerce-analytics', 'actioned', '', NULL, NULL),
(2652, 67, 'printful_promo_q1_2025', 'Get started for free', 'https://woocommerce.com/products/printful/?utm_source=inbox_note&utm_medium=product&utm_campaign=printful_promo_q1_2025', 'unactioned', '', NULL, NULL),
(2653, 69, 'paypal-braintree-sdk-depreciation-2025-02-20-button', 'Upgrade now', 'https://tophorny.com/wp-admin/wp-admin/plugins.php', 'actioned', '', NULL, NULL);

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

--
-- 資料表結構 `tophorny_wc_category_lookup`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_category_lookup`
--

INSERT INTO `tophorny_wc_category_lookup` (`category_tree_id`, `category_id`) VALUES
(15, 15),
(43, 43),
(46, 46);

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

--
-- 資料表結構 `tophorny_wc_customer_lookup`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_customer_lookup`
--

INSERT INTO `tophorny_wc_customer_lookup` (`customer_id`, `user_id`, `username`, `first_name`, `last_name`, `email`, `date_last_active`, `date_registered`, `country`, `postcode`, `city`, `state`) VALUES
(1, 1, 'wpstudio', '', '', 'service@wpstudio.com.tw', '2025-03-04 01:01:55', '2025-02-13 08:31:41', 'TW', '435', 'Taichung City', 'Taichung City'),
(2, NULL, '', '', '', '', '2025-03-03 18:17:30', NULL, 'TW', '', '', '');

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

--
-- 資料表結構 `tophorny_wc_download_log`
--

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

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

--
-- 資料表結構 `tophorny_wc_orders`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_orders`
--

INSERT INTO `tophorny_wc_orders` (`id`, `status`, `currency`, `type`, `tax_amount`, `total_amount`, `customer_id`, `billing_email`, `date_created_gmt`, `date_updated_gmt`, `parent_order_id`, `payment_method`, `payment_method_title`, `transaction_id`, `ip_address`, `user_agent`, `customer_note`) VALUES
(151, 'wc-processing', 'USD', 'shop_order', 0.00000000, 1.00000000, 1, 'service@wpstudio.com.tw', '2025-02-19 04:02:12', '2025-02-19 04:04:51', 0, 'stripe', 'Credit / Debit Card', 'ch_3Qu4VfIdNIY6WtW32SIgkEID', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', ''),
(261, 'wc-processing', 'USD', 'shop_order', 0.00000000, 1.99000000, 1, 'service@wpstudio.com.tw', '2025-03-02 14:08:56', '2025-03-02 14:10:54', 0, 'stripe', 'Credit / Debit Card', 'ch_3QyDE8IdNIY6WtW31ssptm79', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', ''),
(304, 'wc-checkout-draft', 'USD', 'shop_order', 0.00000000, 0.00000000, 0, NULL, '2025-03-04 02:17:30', '2025-03-04 05:07:35', 0, '', '', '', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', ''),
(339, 'wc-checkout-draft', 'USD', 'shop_order', 0.00000000, 0.00000000, 1, 'service@wpstudio.com.tw', '2025-03-04 07:04:02', '2025-03-04 07:04:31', 0, '', '', '', '123.205.15.40', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', ''),
(340, 'wc-checkout-draft', 'USD', 'shop_order', 0.00000000, 1.99000000, 1, 'service@wpstudio.com.tw', '2025-03-04 07:04:52', '2025-03-04 07:04:53', 0, '', '', '', '123.205.15.40', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', ''),
(348, 'wc-checkout-draft', 'USD', 'shop_order', 0.00000000, 0.00000000, 1, 'service@wpstudio.com.tw', '2025-03-04 09:01:55', '2025-03-04 09:01:58', 0, '', '', '', '123.205.15.40', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '');

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

--
-- 資料表結構 `tophorny_wc_orders_meta`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_orders_meta`
--

INSERT INTO `tophorny_wc_orders_meta` (`id`, `order_id`, `meta_key`, `meta_value`) VALUES
(1, 151, '_shipping_hash', '9d4568c009d203ab10e33ea9953a0264'),
(2, 151, '_coupons_hash', 'd751713988987e9331980363e24189ce'),
(3, 151, '_fees_hash', 'd751713988987e9331980363e24189ce'),
(4, 151, '_taxes_hash', 'd751713988987e9331980363e24189ce'),
(5, 151, 'is_vat_exempt', 'no'),
(6, 151, '_billing_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW service@wpstudio.com.tw +886938891255'),
(7, 151, '_shipping_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW +886938891255'),
(8, 151, '_wc_order_attribution_source_type', 'typein'),
(9, 151, '_wc_order_attribution_utm_source', '(direct)'),
(10, 151, '_wc_order_attribution_session_entry', 'https://tophorny.com/'),
(11, 151, '_wc_order_attribution_session_start_time', '2025-02-14 09:26:15'),
(12, 151, '_wc_order_attribution_session_pages', '6'),
(13, 151, '_wc_order_attribution_session_count', '3'),
(14, 151, '_wc_order_attribution_user_agent', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(15, 151, '_wc_order_attribution_device_type', 'Desktop'),
(16, 151, '_stripe_source_id', 'pm_1Qu4WWIdNIY6WtW34ESsLg26'),
(17, 151, '_stripe_customer_id', 'cus_RnfrLNY1Jlle7W'),
(18, 151, '_stripe_upe_payment_type', 'card'),
(20, 151, '_stripe_intent_id', 'pi_3Qu4VfIdNIY6WtW32PYF58mc'),
(21, 151, '_wc_order_attribution_source_type', 'typein'),
(22, 151, '_wc_order_attribution_utm_source', '(direct)'),
(23, 151, '_wc_order_attribution_session_entry', 'https://tophorny.com/'),
(24, 151, '_wc_order_attribution_session_start_time', '2025-02-14 09:26:15'),
(25, 151, '_wc_order_attribution_session_pages', '6'),
(26, 151, '_wc_order_attribution_session_count', '3'),
(27, 151, '_wc_order_attribution_user_agent', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(28, 151, '_wc_order_attribution_device_type', 'Desktop'),
(29, 151, '_stripe_charge_captured', 'yes'),
(30, 151, '_stripe_fee', '0.34'),
(31, 151, '_stripe_net', '0.66'),
(32, 151, '_stripe_currency', 'USD'),
(33, 261, '_shipping_hash', '9d4568c009d203ab10e33ea9953a0264'),
(34, 261, '_coupons_hash', 'd751713988987e9331980363e24189ce'),
(35, 261, '_fees_hash', 'd751713988987e9331980363e24189ce'),
(36, 261, '_taxes_hash', 'd751713988987e9331980363e24189ce'),
(37, 261, 'is_vat_exempt', 'no'),
(38, 261, '_billing_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW service@wpstudio.com.tw +886938891255'),
(39, 261, '_shipping_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW +886938891255'),
(40, 261, '_wc_order_attribution_source_type', 'typein'),
(41, 261, '_wc_order_attribution_utm_source', '(direct)'),
(42, 261, '_wc_order_attribution_session_entry', 'https://tophorny.com/'),
(43, 261, '_wc_order_attribution_session_start_time', '2025-02-14 09:26:15'),
(44, 261, '_wc_order_attribution_session_pages', '28'),
(45, 261, '_wc_order_attribution_session_count', '6'),
(46, 261, '_wc_order_attribution_user_agent', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(47, 261, '_wc_order_attribution_device_type', 'Desktop'),
(48, 261, '_stripe_source_id', 'pm_1QyDE5IdNIY6WtW3NvwQ9xMT'),
(49, 261, '_stripe_customer_id', 'cus_RnfrLNY1Jlle7W'),
(50, 261, '_stripe_upe_payment_type', 'card'),
(52, 261, '_stripe_intent_id', 'pi_3QyDE8IdNIY6WtW316hxf8ap'),
(53, 261, '_stripe_charge_captured', 'yes'),
(54, 261, '_stripe_fee', '0.39'),
(55, 261, '_stripe_net', '1.6'),
(56, 261, '_stripe_currency', 'USD'),
(57, 304, '_shipping_hash', '9d4568c009d203ab10e33ea9953a0264'),
(58, 304, '_coupons_hash', 'd751713988987e9331980363e24189ce'),
(59, 304, '_fees_hash', 'd751713988987e9331980363e24189ce'),
(60, 304, '_taxes_hash', 'd751713988987e9331980363e24189ce'),
(61, 304, 'is_vat_exempt', 'no'),
(62, 304, '_billing_address_index', '        TW  '),
(63, 304, '_shipping_address_index', '        TW '),
(64, 339, '_shipping_hash', '9d4568c009d203ab10e33ea9953a0264'),
(65, 339, '_coupons_hash', 'd751713988987e9331980363e24189ce'),
(66, 339, '_fees_hash', 'd751713988987e9331980363e24189ce'),
(67, 339, '_taxes_hash', 'd751713988987e9331980363e24189ce'),
(68, 339, 'is_vat_exempt', 'no'),
(69, 339, '_billing_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW service@wpstudio.com.tw +886938891255'),
(70, 339, '_shipping_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW +886938891255'),
(71, 340, '_shipping_hash', '9d4568c009d203ab10e33ea9953a0264'),
(72, 340, '_coupons_hash', 'd751713988987e9331980363e24189ce'),
(73, 340, '_fees_hash', 'd751713988987e9331980363e24189ce'),
(74, 340, '_taxes_hash', 'd751713988987e9331980363e24189ce'),
(75, 340, 'is_vat_exempt', 'no'),
(76, 340, '_billing_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW service@wpstudio.com.tw +886938891255'),
(77, 340, '_shipping_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW +886938891255'),
(78, 348, '_shipping_hash', '9d4568c009d203ab10e33ea9953a0264'),
(79, 348, '_coupons_hash', 'd751713988987e9331980363e24189ce'),
(80, 348, '_fees_hash', 'd751713988987e9331980363e24189ce'),
(81, 348, '_taxes_hash', 'd751713988987e9331980363e24189ce'),
(82, 348, 'is_vat_exempt', 'no'),
(83, 348, '_billing_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW service@wpstudio.com.tw +886938891255'),
(84, 348, '_shipping_address_index', 'vincen chen  Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,  Taichung City Taichung City 435 TW +886938891255');

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

--
-- 資料表結構 `tophorny_wc_order_addresses`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_order_addresses`
--

INSERT INTO `tophorny_wc_order_addresses` (`id`, `order_id`, `address_type`, `first_name`, `last_name`, `company`, `address_1`, `address_2`, `city`, `state`, `postcode`, `country`, `email`, `phone`) VALUES
(1, 151, 'billing', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', 'service@wpstudio.com.tw', '+886938891255'),
(2, 151, 'shipping', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', NULL, '+886938891255'),
(3, 261, 'billing', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', 'service@wpstudio.com.tw', '+886938891255'),
(4, 261, 'shipping', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', NULL, '+886938891255'),
(5, 304, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'TW', NULL, NULL),
(6, 304, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'TW', NULL, NULL),
(7, 339, 'billing', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', 'service@wpstudio.com.tw', '+886938891255'),
(8, 339, 'shipping', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', NULL, '+886938891255'),
(9, 340, 'billing', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', 'service@wpstudio.com.tw', '+886938891255'),
(10, 340, 'shipping', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', NULL, '+886938891255'),
(11, 348, 'billing', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', 'service@wpstudio.com.tw', '+886938891255'),
(12, 348, 'shipping', 'vincen', 'chen', NULL, 'Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,', NULL, 'Taichung City', 'Taichung City', '435', 'TW', NULL, '+886938891255');

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

--
-- 資料表結構 `tophorny_wc_order_coupon_lookup`
--

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

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

--
-- 資料表結構 `tophorny_wc_order_operational_data`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_order_operational_data`
--

INSERT INTO `tophorny_wc_order_operational_data` (`id`, `order_id`, `created_via`, `woocommerce_version`, `prices_include_tax`, `coupon_usages_are_counted`, `download_permission_granted`, `cart_hash`, `new_order_email_sent`, `order_key`, `order_stock_reduced`, `date_paid_gmt`, `date_completed_gmt`, `shipping_tax_amount`, `shipping_total_amount`, `discount_tax_amount`, `discount_total_amount`, `recorded_sales`) VALUES
(1, 151, 'store-api', '9.6.2', 0, 1, 1, '76a1607cb020bb676dc5d3e804ed94b9', 0, 'wc_order_8qv00Kno0TWet', 1, '2025-02-19 04:04:47', NULL, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 1),
(10, 261, 'store-api', '9.6.2', 0, 1, 1, '9b0e81cb55cedaef4bde065c3daba296', 0, 'wc_order_LmU2PUYllKtp8', 1, '2025-03-02 14:10:48', NULL, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 1),
(17, 304, 'store-api', '9.6.2', 0, 0, 0, '', 0, 'wc_order_EKUOF8AAa4F1j', 0, NULL, NULL, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 0),
(22, 339, 'store-api', '9.6.2', 0, 0, 0, '', 0, 'wc_order_DrHvdYTRJhHOr', 0, NULL, NULL, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 0),
(25, 340, 'store-api', '9.6.2', 0, 0, 0, '9b0e81cb55cedaef4bde065c3daba296', 0, 'wc_order_oVdVGAq0fneQy', 0, NULL, NULL, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 0),
(27, 348, 'store-api', '9.6.2', 0, 0, 0, '', 0, 'wc_order_jhbpG40iGmOPd', 0, NULL, NULL, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 0);

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

--
-- 資料表結構 `tophorny_wc_order_product_lookup`
--

CREATE TABLE `tophorny_wc_order_product_lookup` (
  `order_item_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `variation_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_qty` int(11) NOT NULL,
  `product_net_revenue` double NOT NULL DEFAULT 0,
  `product_gross_revenue` double NOT NULL DEFAULT 0,
  `coupon_amount` double NOT NULL DEFAULT 0,
  `tax_amount` double NOT NULL DEFAULT 0,
  `shipping_amount` double NOT NULL DEFAULT 0,
  `shipping_tax_amount` double NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wc_order_product_lookup`
--

INSERT INTO `tophorny_wc_order_product_lookup` (`order_item_id`, `order_id`, `product_id`, `variation_id`, `customer_id`, `date_created`, `product_qty`, `product_net_revenue`, `product_gross_revenue`, `coupon_amount`, `tax_amount`, `shipping_amount`, `shipping_tax_amount`) VALUES
(1, 151, 150, 0, 1, '2025-02-19 12:02:12', 1, 1, 1, 0, 0, 0, 0),
(2, 261, 255, 0, 1, '2025-03-02 22:08:56', 1, 1.99, 1.99, 0, 0, 0, 0),
(6, 340, 258, 0, 1, '2025-03-04 15:04:52', 1, 1.99, 1.99, 0, 0, 0, 0);

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

--
-- 資料表結構 `tophorny_wc_order_stats`
--

CREATE TABLE `tophorny_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(200) NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wc_order_stats`
--

INSERT INTO `tophorny_wc_order_stats` (`order_id`, `parent_id`, `date_created`, `date_created_gmt`, `date_paid`, `date_completed`, `num_items_sold`, `total_sales`, `tax_total`, `shipping_total`, `net_total`, `returning_customer`, `status`, `customer_id`) VALUES
(151, 0, '2025-02-19 12:02:12', '2025-02-19 04:02:12', '2025-02-19 12:04:47', NULL, 1, 1, 0, 0, 1, 0, 'wc-processing', 1),
(261, 0, '2025-03-02 22:08:56', '2025-03-02 14:08:56', '2025-03-02 22:10:48', NULL, 1, 1.99, 0, 0, 1.99, 1, 'wc-processing', 1),
(304, 0, '2025-03-04 10:17:30', '2025-03-04 02:17:30', NULL, NULL, 0, 0, 0, 0, 0, 0, 'wc-checkout-draft', 2),
(339, 0, '2025-03-04 15:04:02', '2025-03-04 07:04:02', NULL, NULL, 0, 0, 0, 0, 0, 1, 'wc-checkout-draft', 1),
(340, 0, '2025-03-04 15:04:52', '2025-03-04 07:04:52', NULL, NULL, 1, 1.99, 0, 0, 1.99, 1, 'wc-checkout-draft', 1),
(348, 0, '2025-03-04 17:01:55', '2025-03-04 09:01:55', NULL, NULL, 0, 0, 0, 0, 0, 1, 'wc-checkout-draft', 1);

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

--
-- 資料表結構 `tophorny_wc_order_tax_lookup`
--

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

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

--
-- 資料表結構 `tophorny_wc_product_attributes_lookup`
--

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

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

--
-- 資料表結構 `tophorny_wc_product_download_directories`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_product_download_directories`
--

INSERT INTO `tophorny_wc_product_download_directories` (`url_id`, `url`, `enabled`) VALUES
(1, 'file://D:/www/tophorny/wp-content/uploads/woocommerce_uploads/', 1),
(2, 'https://tophorny.com/wp-content/uploads/woocommerce_uploads/', 1);

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

--
-- 資料表結構 `tophorny_wc_product_meta_lookup`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_product_meta_lookup`
--

INSERT INTO `tophorny_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
(252, '', '', 1, 0, 1.9900, 1.9900, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(255, '', '', 1, 0, 1.9900, 1.9900, 1, NULL, 'instock', 0, 0.00, 1, 'taxable', ''),
(258, '', '', 1, 0, 1.9900, 1.9900, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(369, '', '', 1, 0, 11.9400, 11.9400, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(370, '', '', 1, 0, 11.9400, 11.9400, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(371, '', '', 1, 0, 11.9400, 11.9400, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(372, '', '', 1, 0, 23.8800, 23.8800, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(373, '', '', 1, 0, 23.8800, 23.8800, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(374, '', '', 1, 0, 23.8800, 23.8800, 1, NULL, 'instock', 0, 0.00, 0, 'taxable', '');

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

--
-- 資料表結構 `tophorny_wc_rate_limits`
--

CREATE TABLE `tophorny_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(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_wc_reserved_stock`
--

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

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

--
-- 資料表結構 `tophorny_wc_tax_rate_classes`
--

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

--
-- 傾印資料表的資料 `tophorny_wc_tax_rate_classes`
--

INSERT INTO `tophorny_wc_tax_rate_classes` (`tax_rate_class_id`, `name`, `slug`) VALUES
(1, '優惠稅率', '%e5%84%aa%e6%83%a0%e7%a8%85%e7%8e%87'),
(2, '零稅率', '%e9%9b%b6%e7%a8%85%e7%8e%87');

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

--
-- 資料表結構 `tophorny_wc_webhooks`
--

CREATE TABLE `tophorny_wc_webhooks` (
  `webhook_id` bigint(20) UNSIGNED NOT NULL,
  `status` varchar(200) NOT NULL,
  `name` text NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `delivery_url` text NOT NULL,
  `secret` text NOT NULL,
  `topic` varchar(200) 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(6) NOT NULL,
  `failure_count` smallint(6) NOT NULL DEFAULT 0,
  `pending_delivery` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_api_keys`
--

CREATE TABLE `tophorny_woocommerce_api_keys` (
  `key_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `permissions` varchar(10) NOT NULL,
  `consumer_key` char(64) NOT NULL,
  `consumer_secret` char(43) NOT NULL,
  `nonces` longtext DEFAULT NULL,
  `truncated_key` char(7) NOT NULL,
  `last_access` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_attribute_taxonomies`
--

CREATE TABLE `tophorny_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) UNSIGNED NOT NULL,
  `attribute_name` varchar(200) NOT NULL,
  `attribute_label` varchar(200) DEFAULT NULL,
  `attribute_type` varchar(20) NOT NULL,
  `attribute_orderby` varchar(20) NOT NULL,
  `attribute_public` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `tophorny_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `download_id` varchar(36) NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `order_key` varchar(200) NOT NULL,
  `user_email` varchar(200) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `downloads_remaining` varchar(9) DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_log`
--

CREATE TABLE `tophorny_woocommerce_log` (
  `log_id` bigint(20) UNSIGNED NOT NULL,
  `timestamp` datetime NOT NULL,
  `level` smallint(6) NOT NULL,
  `source` varchar(200) NOT NULL,
  `message` longtext NOT NULL,
  `context` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_order_itemmeta`
--

CREATE TABLE `tophorny_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `order_item_id` bigint(20) UNSIGNED NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_woocommerce_order_itemmeta`
--

INSERT INTO `tophorny_woocommerce_order_itemmeta` (`meta_id`, `order_item_id`, `meta_key`, `meta_value`) VALUES
(1, 1, '_product_id', '150'),
(2, 1, '_variation_id', '0'),
(3, 1, '_qty', '1'),
(4, 1, '_tax_class', ''),
(5, 1, '_line_subtotal', '1'),
(6, 1, '_line_subtotal_tax', '0'),
(7, 1, '_line_total', '1'),
(8, 1, '_line_tax', '0'),
(9, 1, '_line_tax_data', 'a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),
(10, 2, '_product_id', '255'),
(11, 2, '_variation_id', '0'),
(12, 2, '_qty', '1'),
(13, 2, '_tax_class', ''),
(14, 2, '_line_subtotal', '1.99'),
(15, 2, '_line_subtotal_tax', '0'),
(16, 2, '_line_total', '1.99'),
(17, 2, '_line_tax', '0'),
(18, 2, '_line_tax_data', 'a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),
(46, 6, '_product_id', '258'),
(47, 6, '_variation_id', '0'),
(48, 6, '_qty', '1'),
(49, 6, '_tax_class', ''),
(50, 6, '_line_subtotal', '1.99'),
(51, 6, '_line_subtotal_tax', '0'),
(52, 6, '_line_total', '1.99'),
(53, 6, '_line_tax', '0'),
(54, 6, '_line_tax_data', 'a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}');

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

--
-- 資料表結構 `tophorny_woocommerce_order_items`
--

CREATE TABLE `tophorny_woocommerce_order_items` (
  `order_item_id` bigint(20) UNSIGNED NOT NULL,
  `order_item_name` text NOT NULL,
  `order_item_type` varchar(200) NOT NULL DEFAULT '',
  `order_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_woocommerce_order_items`
--

INSERT INTO `tophorny_woocommerce_order_items` (`order_item_id`, `order_item_name`, `order_item_type`, `order_id`) VALUES
(1, '刷卡測試', 'line_item', 151),
(2, '月繳方案', 'line_item', 261),
(6, '月缴方案', 'line_item', 340);

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

--
-- 資料表結構 `tophorny_woocommerce_payment_tokenmeta`
--

CREATE TABLE `tophorny_woocommerce_payment_tokenmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `payment_token_id` bigint(20) UNSIGNED NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_payment_tokens`
--

CREATE TABLE `tophorny_woocommerce_payment_tokens` (
  `token_id` bigint(20) UNSIGNED NOT NULL,
  `gateway_id` varchar(200) NOT NULL,
  `token` text NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `type` varchar(200) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_sessions`
--

CREATE TABLE `tophorny_woocommerce_sessions` (
  `session_id` bigint(20) UNSIGNED NOT NULL,
  `session_key` char(32) NOT NULL,
  `session_value` longtext NOT NULL,
  `session_expiry` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_woocommerce_sessions`
--

INSERT INTO `tophorny_woocommerce_sessions` (`session_id`, `session_key`, `session_value`, `session_expiry`) VALUES
(346, 't_bdc9b2f2101b740bc26b7183c77538', 'a:1:{s:8:\"customer\";s:1066:\"a:28:{s:2:\"id\";s:1:\"1\";s:13:\"date_modified\";s:25:\"2025-03-02T22:10:44+08:00\";s:10:\"first_name\";s:6:\"vincen\";s:9:\"last_name\";s:4:\"chen\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:13:\"+886938891255\";s:5:\"email\";s:23:\"service@wpstudio.com.tw\";s:7:\"address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:13:\"Taichung City\";s:5:\"state\";s:13:\"Taichung City\";s:8:\"postcode\";s:3:\"435\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:6:\"vincen\";s:18:\"shipping_last_name\";s:4:\"chen\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:13:\"+886938891255\";s:16:\"shipping_address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:13:\"Taichung City\";s:14:\"shipping_state\";s:13:\"Taichung City\";s:17:\"shipping_postcode\";s:3:\"435\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741097333),
(348, 't_31c0eea9a632e6a46a56cca1d1e6df', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741243251),
(366, 't_329c993e6641abf5e0c092977d1d29', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741248560),
(367, 't_882ce3d85b5d7b583a27c01855d6c7', 'a:8:{s:4:\"cart\";s:415:\"a:1:{s:32:\"03c6b06952c750899bb03d998e631860\";a:11:{s:3:\"key\";s:32:\"03c6b06952c750899bb03d998e631860\";s:10:\"product_id\";i:252;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:1.99;s:17:\"line_subtotal_tax\";d:0;s:10:\"line_total\";d:1.99;s:8:\"line_tax\";d:0;}}\";s:11:\"cart_totals\";s:396:\"a:15:{s:8:\"subtotal\";s:4:\"1.99\";s:12:\"subtotal_tax\";d:0;s:14:\"shipping_total\";s:1:\"0\";s:12:\"shipping_tax\";d:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";d:0;s:12:\"discount_tax\";d:0;s:19:\"cart_contents_total\";s:4:\"1.99\";s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";s:1:\"0\";s:7:\"fee_tax\";d:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";s:4:\"1.99\";s:9:\"total_tax\";d:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:10:\"wc_notices\";s:223:\"a:1:{s:7:\"success\";a:1:{i:0;a:2:{s:6:\"notice\";s:148:\"&ldquo;Monthly Payment Plan&rdquo; has been added to your cart. <a href=\"https://tophorny.com/shop/\" class=\"button wc-forward\">Continue shopping</a>\";s:4:\"data\";a:0:{}}}}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741248564),
(368, 't_9967ac89c71d27c0b42d4d3080b26d', 'a:8:{s:4:\"cart\";s:415:\"a:1:{s:32:\"502e4a16930e414107ee22b6198c578f\";a:11:{s:3:\"key\";s:32:\"502e4a16930e414107ee22b6198c578f\";s:10:\"product_id\";i:258;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:1.99;s:17:\"line_subtotal_tax\";d:0;s:10:\"line_total\";d:1.99;s:8:\"line_tax\";d:0;}}\";s:11:\"cart_totals\";s:396:\"a:15:{s:8:\"subtotal\";s:4:\"1.99\";s:12:\"subtotal_tax\";d:0;s:14:\"shipping_total\";s:1:\"0\";s:12:\"shipping_tax\";d:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";d:0;s:12:\"discount_tax\";d:0;s:19:\"cart_contents_total\";s:4:\"1.99\";s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";s:1:\"0\";s:7:\"fee_tax\";d:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";s:4:\"1.99\";s:9:\"total_tax\";d:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:10:\"wc_notices\";s:221:\"a:1:{s:7:\"success\";a:1:{i:0;a:2:{s:6:\"notice\";s:146:\"&ldquo;月缴方案&rdquo; has been added to your cart. <a href=\"https://tophorny.com/zh-cn/shop/\" class=\"button wc-forward\">Continue shopping</a>\";s:4:\"data\";a:0:{}}}}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741248573),
(369, 't_cb890067800d420bd1164a61b3f0b3', 'a:8:{s:4:\"cart\";s:415:\"a:1:{s:32:\"fe131d7f5a6b38b23cc967316c13dae2\";a:11:{s:3:\"key\";s:32:\"fe131d7f5a6b38b23cc967316c13dae2\";s:10:\"product_id\";i:255;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:1.99;s:17:\"line_subtotal_tax\";d:0;s:10:\"line_total\";d:1.99;s:8:\"line_tax\";d:0;}}\";s:11:\"cart_totals\";s:396:\"a:15:{s:8:\"subtotal\";s:4:\"1.99\";s:12:\"subtotal_tax\";d:0;s:14:\"shipping_total\";s:1:\"0\";s:12:\"shipping_tax\";d:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";d:0;s:12:\"discount_tax\";d:0;s:19:\"cart_contents_total\";s:4:\"1.99\";s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";s:1:\"0\";s:7:\"fee_tax\";d:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";s:4:\"1.99\";s:9:\"total_tax\";d:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:10:\"wc_notices\";s:209:\"a:1:{s:7:\"success\";a:1:{i:0;a:2:{s:6:\"notice\";s:134:\"&ldquo;月繳方案&rdquo; 已加入您的購物車 <a href=\"https://tophorny.com/zh/shop/\" class=\"button wc-forward\">繼續選購</a>\";s:4:\"data\";a:0:{}}}}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741248584),
(401, 't_ba2a94b7c645a995a7cf064bcc225d', 'a:1:{s:8:\"customer\";s:1066:\"a:28:{s:2:\"id\";s:1:\"1\";s:13:\"date_modified\";s:25:\"2025-03-05T01:00:25+08:00\";s:10:\"first_name\";s:6:\"vincen\";s:9:\"last_name\";s:4:\"chen\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:13:\"+886938891255\";s:5:\"email\";s:23:\"service@wpstudio.com.tw\";s:7:\"address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:13:\"Taichung City\";s:5:\"state\";s:13:\"Taichung City\";s:8:\"postcode\";s:3:\"435\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:6:\"vincen\";s:18:\"shipping_last_name\";s:4:\"chen\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:13:\"+886938891255\";s:16:\"shipping_address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:13:\"Taichung City\";s:14:\"shipping_state\";s:13:\"Taichung City\";s:17:\"shipping_postcode\";s:3:\"435\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741244619),
(532, 't_aa6f2cb24cf81653f6aaa128ed66ef', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741256355),
(554, 't_9be23a9544bd582ccf289636b7b2a6', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741256471),
(567, 't_5906e866817163459d71f56f849cab', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741256534),
(576, 't_a312143c743c39aff82d39fe35743e', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741256597),
(674, 't_c5f2621cdc5533f39c21e4423b5a26', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741261537),
(903, 't_6e08f10c079dee9a8a5a4d746ea79e', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741270782),
(918, 't_0a08b272b4537497ece26bbde7a8d1', 'a:1:{s:8:\"customer\";s:1066:\"a:28:{s:2:\"id\";s:1:\"1\";s:13:\"date_modified\";s:25:\"2025-03-05T01:33:22+08:00\";s:10:\"first_name\";s:6:\"vincen\";s:9:\"last_name\";s:4:\"chen\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:13:\"+886938891255\";s:5:\"email\";s:23:\"service@wpstudio.com.tw\";s:7:\"address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:13:\"Taichung City\";s:5:\"state\";s:13:\"Taichung City\";s:8:\"postcode\";s:3:\"435\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:6:\"vincen\";s:18:\"shipping_last_name\";s:4:\"chen\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:13:\"+886938891255\";s:16:\"shipping_address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:13:\"Taichung City\";s:14:\"shipping_state\";s:13:\"Taichung City\";s:17:\"shipping_postcode\";s:3:\"435\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741222994),
(919, '1', 'a:8:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:1066:\"a:28:{s:2:\"id\";s:1:\"1\";s:13:\"date_modified\";s:25:\"2025-03-05T01:33:22+08:00\";s:10:\"first_name\";s:6:\"vincen\";s:9:\"last_name\";s:4:\"chen\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:13:\"+886938891255\";s:5:\"email\";s:23:\"service@wpstudio.com.tw\";s:7:\"address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:13:\"Taichung City\";s:5:\"state\";s:13:\"Taichung City\";s:8:\"postcode\";s:3:\"435\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:6:\"vincen\";s:18:\"shipping_last_name\";s:4:\"chen\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:13:\"+886938891255\";s:16:\"shipping_address\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_1\";s:41:\"Aly. 25, Ln. 194, Wenhua St., Wuqi Dist.,\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:13:\"Taichung City\";s:14:\"shipping_state\";s:13:\"Taichung City\";s:17:\"shipping_postcode\";s:3:\"435\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";s:10:\"wc_notices\";s:6:\"a:0:{}\";}', 1741272027),
(922, 't_bb0ff297e223622725e3e51cda6400', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741306359),
(923, 't_f0c0520314fa91891ccda7fd22872e', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741306770),
(924, 't_9af60e436f88b3dd29ddbfdae552df', 'a:7:{s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:8:\"customer\";s:738:\"a:28:{s:2:\"id\";s:1:\"0\";s:13:\"date_modified\";s:0:\"\";s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:4:\"city\";s:0:\"\";s:5:\"state\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:7:\"country\";s:2:\"TW\";s:19:\"shipping_first_name\";s:0:\"\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:17:\"shipping_postcode\";s:0:\"\";s:16:\"shipping_country\";s:2:\"TW\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:9:\"meta_data\";a:0:{}}\";}', 1741312170);

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

--
-- 資料表結構 `tophorny_woocommerce_shipping_zones`
--

CREATE TABLE `tophorny_woocommerce_shipping_zones` (
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `zone_name` varchar(200) NOT NULL,
  `zone_order` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_shipping_zone_locations`
--

CREATE TABLE `tophorny_woocommerce_shipping_zone_locations` (
  `location_id` bigint(20) UNSIGNED NOT NULL,
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `location_code` varchar(200) NOT NULL,
  `location_type` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_shipping_zone_methods`
--

CREATE TABLE `tophorny_woocommerce_shipping_zone_methods` (
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `instance_id` bigint(20) UNSIGNED NOT NULL,
  `method_id` varchar(200) NOT NULL,
  `method_order` bigint(20) UNSIGNED NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_tax_rates`
--

CREATE TABLE `tophorny_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_country` varchar(2) NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) NOT NULL DEFAULT '',
  `tax_rate` varchar(8) NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) NOT NULL DEFAULT '',
  `tax_rate_priority` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_compound` int(11) NOT NULL DEFAULT 0,
  `tax_rate_shipping` int(11) NOT NULL DEFAULT 1,
  `tax_rate_order` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_class` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_woocommerce_tax_rate_locations`
--

CREATE TABLE `tophorny_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) UNSIGNED NOT NULL,
  `location_code` varchar(200) NOT NULL,
  `tax_rate_id` bigint(20) UNSIGNED NOT NULL,
  `location_type` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- 資料表結構 `tophorny_wpmailsmtp_debug_events`
--

CREATE TABLE `tophorny_wpmailsmtp_debug_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `content` text DEFAULT NULL,
  `initiator` text DEFAULT NULL,
  `event_type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wpmailsmtp_debug_events`
--

INSERT INTO `tophorny_wpmailsmtp_debug_events` (`id`, `content`, `initiator`, `event_type`, `created_at`) VALUES
(1, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Reports\\\\Emails\\\\Summary.php\",\"line\":112}', 0, '2025-02-17 10:15:28'),
(2, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\woocommerce\\\\includes\\\\class-wc-payment-gateways.php\",\"line\":255}', 0, '2025-02-18 19:56:38'),
(3, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\woocommerce\\\\includes\\\\emails\\\\class-wc-email.php\",\"line\":769}', 0, '2025-02-18 20:03:50'),
(4, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\woocommerce\\\\includes\\\\emails\\\\class-wc-email.php\",\"line\":769}', 0, '2025-02-18 20:03:52'),
(5, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\woocommerce\\\\includes\\\\emails\\\\class-wc-email.php\",\"line\":769}', 0, '2025-02-18 20:04:49'),
(6, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\woocommerce\\\\includes\\\\emails\\\\class-wc-email.php\",\"line\":769}', 0, '2025-02-18 20:04:51'),
(7, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\wp-mail-smtp\\\\src\\\\Reports\\\\Emails\\\\Summary.php\",\"line\":112}', 0, '2025-03-02 03:51:22'),
(8, 'Mailer: 不使用其他服務 (預設)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\woocommerce\\\\includes\\\\emails\\\\class-wc-email.php\",\"line\":769}', 0, '2025-03-02 06:10:52'),
(9, 'Mailer: Default (none)\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.', '{\"file\":\"D:\\\\www\\\\tophorny\\\\wp-content\\\\plugins\\\\woocommerce\\\\includes\\\\emails\\\\class-wc-email.php\",\"line\":769}', 0, '2025-03-02 06:10:54');

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

--
-- 資料表結構 `tophorny_wpmailsmtp_tasks_meta`
--

CREATE TABLE `tophorny_wpmailsmtp_tasks_meta` (
  `id` bigint(20) NOT NULL,
  `action` varchar(255) NOT NULL,
  `data` longtext NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wpmailsmtp_tasks_meta`
--

INSERT INTO `tophorny_wpmailsmtp_tasks_meta` (`id`, `action`, `data`, `date`) VALUES
(1, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2025-02-14 01:12:54');

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

--
-- 資料表結構 `tophorny_wpmm_subscribers`
--

CREATE TABLE `tophorny_wpmm_subscribers` (
  `id_subscriber` bigint(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `insert_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- 資料表結構 `tophorny_wpr_above_the_fold`
--

CREATE TABLE `tophorny_wpr_above_the_fold` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(2000) NOT NULL DEFAULT '',
  `is_mobile` tinyint(1) NOT NULL DEFAULT 0,
  `lcp` longtext DEFAULT NULL,
  `viewport` longtext DEFAULT NULL,
  `error_message` longtext DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT '',
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_accessed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wpr_above_the_fold`
--

INSERT INTO `tophorny_wpr_above_the_fold` (`id`, `url`, `is_mobile`, `lcp`, `viewport`, `error_message`, `status`, `modified`, `last_accessed`) VALUES
(1, 'https://tophorny.com', 0, '{\"type\":\"img\",\"src\":\"https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/03\\/8c4912db3c2f84b15091.png\"}', '[{\"type\":\"img-srcset\",\"src\":\"https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/03\\/8ea5c8b9968d342ae636.png\",\"srcset\":\"https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/03\\/8ea5c8b9968d342ae636.png 728w, https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/03\\/8ea5c8b9968d342ae636-300x37.png 300w, https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/03\\/8ea5c8b9968d342ae636-600x74.png 600w\",\"sizes\":\"(max-width: 728px) 100vw, 728px\"},{\"type\":\"img\",\"src\":\"https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/02\\/24e15ab1846f4df3f9e5-320x180.jpg\"},{\"type\":\"img\",\"src\":\"https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/02\\/cc52582e7fbfef66b167-320x180.jpg\"},{\"type\":\"picture\",\"src\":\"https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/03\\/8981868955ad1dbfc3c6.png\",\"sources\":[{\"media\":\"\",\"sizes\":\"\",\"srcset\":\"https:\\/\\/tophorny.com\\/wp-content\\/uploads\\/2025\\/03\\/8981868955ad1dbfc3c6.png.webp\",\"type\":\"image\\/webp\"}]}]', '', 'completed', '2025-03-04 06:37:46', '2025-03-04 06:37:46');

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

--
-- 資料表結構 `tophorny_wpr_lazy_render_content`
--

CREATE TABLE `tophorny_wpr_lazy_render_content` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(2000) NOT NULL DEFAULT '',
  `is_mobile` tinyint(1) NOT NULL DEFAULT 0,
  `below_the_fold` longtext DEFAULT NULL,
  `error_message` longtext DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT '',
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_accessed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wpr_lazy_render_content`
--

INSERT INTO `tophorny_wpr_lazy_render_content` (`id`, `url`, `is_mobile`, `below_the_fold`, `error_message`, `status`, `modified`, `last_accessed`, `created_at`) VALUES
(1, 'https://tophorny.com', 0, '[]', '', 'completed', '2025-03-04 06:37:46', '2025-03-04 06:37:46', '2025-03-04 06:37:46');

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

--
-- 資料表結構 `tophorny_wpr_rocket_cache`
--

CREATE TABLE `tophorny_wpr_rocket_cache` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(2000) NOT NULL DEFAULT '',
  `status` varchar(255) NOT NULL DEFAULT '',
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_accessed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_locked` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wpr_rocket_cache`
--

INSERT INTO `tophorny_wpr_rocket_cache` (`id`, `url`, `status`, `modified`, `last_accessed`, `is_locked`) VALUES
(2, 'https://tophorny.com/author/wpstudio', 'completed', '2025-03-04 06:27:42', '2025-03-04 06:27:42', 0),
(3, 'https://tophorny.com/refund-and-return-policy', 'completed', '2025-03-04 06:27:44', '2025-03-04 06:27:44', 0),
(5, 'https://tophorny.com/category/adult-videos', 'completed', '2025-03-04 06:27:46', '2025-03-04 06:27:46', 0),
(6, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-1-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:27:47', '2025-03-04 06:27:47', 0),
(7, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-1-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:27:49', '2025-03-04 06:27:49', 0),
(8, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-2-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:27:51', '2025-03-04 06:27:51', 0),
(9, 'https://tophorny.com/zh-cn/%e8%82%89%e7%a9%b4%e9%87%8c%e7%9a%84%e5%8d%87%e9%be%99%e6%8b%b3-5-%e9%a2%84%e8%a7%88%e5%bd%b1%e7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 01:31:05', 1),
(10, 'https://tophorny.com/zh/%e8%82%89%e7%a9%b4%e8%a3%a1%e7%9a%84%e6%98%87%e9%be%8d%e6%8b%b3-5-%e9%a0%90%e8%a6%bd%e5%bd%b1%e7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 01:31:07', 1),
(11, 'https://tophorny.com/zh/tag/%E6%80%A7%E7%8E%A9%E5%85%B7', 'completed', '2025-03-04 06:27:52', '2025-03-04 06:27:52', 0),
(12, 'https://tophorny.com/zh/tag/%E7%99%BD%E6%B7%A8', 'completed', '2025-03-04 06:27:54', '2025-03-04 06:27:54', 0),
(13, 'https://tophorny.com/zh/home', 'pending', '2025-03-04 06:27:28', '2025-03-04 05:17:36', 1),
(14, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-2-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:27:55', '2025-03-04 06:27:55', 0),
(15, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-3-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:27:57', '2025-03-04 06:27:57', 0),
(16, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-3-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:27:58', '2025-03-04 06:27:58', 0),
(17, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-4-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:28:00', '2025-03-04 06:28:00', 0),
(18, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-4-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:28:01', '2025-03-04 06:28:01', 0),
(19, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-5-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:28:03', '2025-03-04 06:28:03', 0),
(20, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-5-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'completed', '2025-03-04 06:28:04', '2025-03-04 06:28:04', 0),
(21, 'https://tophorny.com/zh-cn/tag/%E7%99%BD%E5%87%80', 'completed', '2025-03-04 06:28:06', '2025-03-04 06:28:06', 0),
(22, 'https://tophorny.com/zh-cn/home', 'pending', '2025-03-04 06:27:28', '2025-03-04 05:17:39', 1),
(24, 'https://tophorny.com/killuas-secret-cave-life-5-preview-video', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:35', 0),
(25, 'https://tophorny.com/zh/%e8%82%89%e7%a9%b4%e8%a3%a1%e7%9a%84%e6%98%87%e9%be%8d%e6%8b%b3-1-%e9%a0%90%e8%a6%bd%e5%bd%b1%e7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 01:34:15', 1),
(26, 'https://tophorny.com/killuas-secret-cave-life-4-preview-video', 'completed', '2025-03-04 06:43:32', '2025-03-04 06:43:32', 0),
(27, 'https://tophorny.com/tag/sex-toys', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:38', 0),
(28, 'https://tophorny.com/tag/white', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:39', 0),
(29, 'https://tophorny.com/killuas-secret-cave-life-3-preview-video', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:41', 0),
(30, 'https://tophorny.com/killuas-secret-cave-life-2-preview-video', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:42', 0),
(31, 'https://tophorny.com/killuas-secret-cave-life-1-preview-video', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:44', 0),
(32, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-5-preview-video', 'completed', '2025-03-04 06:43:07', '2025-03-04 06:43:07', 1),
(33, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-4-preview-video', 'completed', '2025-03-04 06:43:33', '2025-03-04 06:43:33', 0),
(34, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-3-preview-video', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:47', 0),
(35, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-2-preview-video', 'completed', '2025-03-04 06:43:24', '2025-03-04 06:43:24', 0),
(36, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-1-preview-video', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:50', 0),
(37, 'https://tophorny.com/zh-cn/%E8%82%89%E7%A9%B4%E9%87%8C%E7%9A%84%E5%8D%87%E9%BE%99%E6%8B%B3-4-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:53', 0),
(38, 'https://tophorny.com/zh/%E8%82%89%E7%A9%B4%E8%A3%A1%E7%9A%84%E6%98%87%E9%BE%8D%E6%8B%B3-4-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:54', 0),
(39, 'https://tophorny.com/zh-cn/%E8%82%89%E7%A9%B4%E9%87%8C%E7%9A%84%E5%8D%87%E9%BE%99%E6%8B%B3-3-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:56', 0),
(40, 'https://tophorny.com/zh/%E8%82%89%E7%A9%B4%E8%A3%A1%E7%9A%84%E6%98%87%E9%BE%8D%E6%8B%B3-3-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:25:58', 0),
(41, 'https://tophorny.com/zh-cn/%E8%82%89%E7%A9%B4%E9%87%8C%E7%9A%84%E5%8D%87%E9%BE%99%E6%8B%B3-2-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:05', 0),
(42, 'https://tophorny.com/zh/%E8%82%89%E7%A9%B4%E8%A3%A1%E7%9A%84%E6%98%87%E9%BE%8D%E6%8B%B3-2-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:07', 0),
(43, 'https://tophorny.com/zh-cn/%E8%82%89%E7%A9%B4%E9%87%8C%E7%9A%84%E5%8D%87%E9%BE%99%E6%8B%B3-1-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:08', 0),
(44, 'https://tophorny.com/product/half-year-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 02:18:15', 1),
(45, 'https://tophorny.com/zh-cn/product/monthly-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 02:18:19', 1),
(46, 'https://tophorny.com/product-category/plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:10', 0),
(49, 'https://tophorny.com/zh/product/half-year-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 02:18:22', 1),
(50, 'https://tophorny.com/product/annual-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 02:21:16', 1),
(51, 'https://tophorny.com/zh-cn/product/annual-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 02:21:12', 1),
(53, 'https://tophorny.com/zh/product/annual-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 02:21:14', 1),
(54, 'https://tophorny.com/zh-cn/product/half-year-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:12', 0),
(55, 'https://tophorny.com/zh/product/monthly-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:13', 0),
(56, 'https://tophorny.com/product/monthly-payment-plan', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:15', 0),
(57, 'https://tophorny.com', 'completed', '2025-03-04 06:27:55', '2025-03-04 06:27:55', 1),
(58, 'https://tophorny.com/zh-cn/my-favorite', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:26:31', 0),
(59, 'https://tophorny.com/zh/privacy-notes-and-terms', 'pending', '2025-03-04 06:27:28', '2025-03-04 05:17:39', 0),
(61, 'https://tophorny.com/subscription', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:19:50', 1),
(62, 'https://tophorny.com/privacy-notes-and-terms', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:19:52', 1),
(64, 'https://tophorny.com/zh/subscription', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:20:45', 1),
(66, 'https://tophorny.com/zh-cn/2257-statement', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:20:42', 1),
(67, 'https://tophorny.com/zh-cn/subscription', 'pending', '2025-03-04 06:27:28', '2025-03-04 06:20:49', 1);

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

--
-- 資料表結構 `tophorny_wpr_rucss_used_css`
--

CREATE TABLE `tophorny_wpr_rucss_used_css` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(2000) NOT NULL DEFAULT '',
  `css` longtext DEFAULT NULL,
  `hash` varchar(32) DEFAULT '',
  `error_code` varchar(32) DEFAULT NULL,
  `error_message` longtext DEFAULT NULL,
  `unprocessedcss` longtext DEFAULT NULL,
  `retries` tinyint(1) NOT NULL DEFAULT 1,
  `is_mobile` tinyint(1) NOT NULL DEFAULT 0,
  `job_id` varchar(255) NOT NULL DEFAULT '',
  `queue_name` varchar(255) NOT NULL DEFAULT '',
  `status` varchar(255) NOT NULL DEFAULT '',
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_accessed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `submitted_at` timestamp NULL DEFAULT NULL,
  `next_retry_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 傾印資料表的資料 `tophorny_wpr_rucss_used_css`
--

INSERT INTO `tophorny_wpr_rucss_used_css` (`id`, `url`, `css`, `hash`, `error_code`, `error_message`, `unprocessedcss`, `retries`, `is_mobile`, `job_id`, `queue_name`, `status`, `modified`, `last_accessed`, `submitted_at`, `next_retry_time`) VALUES
(60, 'https://tophorny.com', '', '', '', ' - 2025-03-04 14:13:36 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:14:45 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:17:38 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:23:37 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support.', NULL, 4, 0, 'WORKER16_EU_OVH--01HDRGQPXVXNW2NYNRDV5YD8M1', 'EU', 'pending', '2025-03-04 06:12:31', '2025-03-04 06:12:31', '2025-03-04 06:12:36', '2025-03-04 06:33:37'),
(61, 'https://tophorny.com/subscription', '', '', '', ' - 2025-03-04 14:22:31 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:23:40 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:26:55 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support.', NULL, 3, 0, 'WORKER16_EU_OVH--01HDRGQPXVXNW2NYNRDV5YD8M1', 'EU', 'pending', '2025-03-04 06:19:50', '2025-03-04 06:19:50', '2025-03-04 06:20:35', '2025-03-04 06:31:55'),
(62, 'https://tophorny.com/privacy-notes-and-terms', '', '', '', ' - 2025-03-04 14:22:32 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:23:40 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:26:55 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support.', NULL, 3, 0, 'WORKER16_EU_OVH--01HDRGQPXVXNW2NYNRDV5YD8M1', 'EU', 'pending', '2025-03-04 06:19:52', '2025-03-04 06:19:52', '2025-03-04 06:20:36', '2025-03-04 06:31:55'),
(63, 'https://tophorny.com/zh-cn/2257-statement', '', '', '', ' - 2025-03-04 14:22:36 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:24:36 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:26:56 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support.', NULL, 3, 0, 'WORKER16_EU_OVH--01HDRGQPXVXNW2NYNRDV5YD8M1', 'EU', 'pending', '2025-03-04 06:20:42', '2025-03-04 06:20:42', '2025-03-04 06:22:29', '2025-03-04 06:31:56'),
(64, 'https://tophorny.com/zh/subscription', '', '', '', ' - 2025-03-04 14:22:37 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:24:36 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:26:57 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support.', NULL, 3, 0, 'WORKER16_EU_OVH--01HDRGQPXVXNW2NYNRDV5YD8M1', 'EU', 'pending', '2025-03-04 06:20:45', '2025-03-04 06:20:45', '2025-03-04 06:22:29', '2025-03-04 06:31:57'),
(65, 'https://tophorny.com/zh-cn/subscription', '', '', '', ' - 2025-03-04 14:22:37 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:24:37 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support. - 2025-03-04 14:26:58 400: We could not authenticate your request. Please make sure your license is active and this website is registered on your wp-rocket.me account. If the issue persists, contact our support.', NULL, 3, 0, 'WORKER16_EU_OVH--01HDRGQPXVXNW2NYNRDV5YD8M1', 'EU', 'pending', '2025-03-04 06:20:49', '2025-03-04 06:20:49', '2025-03-04 06:22:30', '2025-03-04 06:31:58'),
(66, 'https://tophorny.com/author/wpstudio', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:42', '2025-03-04 06:27:42', '2025-03-04 06:27:42', '0000-00-00 00:00:00'),
(67, 'https://tophorny.com/refund-and-return-policy', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:44', '2025-03-04 06:27:44', '2025-03-04 06:27:44', '0000-00-00 00:00:00'),
(68, 'https://tophorny.com/category/adult-videos', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:46', '2025-03-04 06:27:46', '2025-03-04 06:27:46', '0000-00-00 00:00:00'),
(69, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-1-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:47', '2025-03-04 06:27:47', '2025-03-04 06:27:47', '0000-00-00 00:00:00'),
(70, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-1-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:49', '2025-03-04 06:27:49', '2025-03-04 06:27:49', '0000-00-00 00:00:00'),
(71, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-2-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:51', '2025-03-04 06:27:51', '2025-03-04 06:27:51', '0000-00-00 00:00:00'),
(72, 'https://tophorny.com/zh/tag/%E6%80%A7%E7%8E%A9%E5%85%B7', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:52', '2025-03-04 06:27:52', '2025-03-04 06:27:52', '0000-00-00 00:00:00'),
(73, 'https://tophorny.com/zh/tag/%E7%99%BD%E6%B7%A8', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:54', '2025-03-04 06:27:54', '2025-03-04 06:27:54', '0000-00-00 00:00:00'),
(74, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-2-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:55', '2025-03-04 06:27:55', '2025-03-04 06:27:55', '0000-00-00 00:00:00'),
(75, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-3-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:57', '2025-03-04 06:27:57', '2025-03-04 06:27:57', '0000-00-00 00:00:00'),
(76, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-3-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:27:58', '2025-03-04 06:27:58', '2025-03-04 06:27:58', '0000-00-00 00:00:00'),
(77, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-4-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:28:00', '2025-03-04 06:28:00', '2025-03-04 06:28:00', '0000-00-00 00:00:00'),
(78, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-4-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:28:01', '2025-03-04 06:28:01', '2025-03-04 06:28:01', '0000-00-00 00:00:00'),
(79, 'https://tophorny.com/zh/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-5-%E9%A0%90%E8%A6%BD%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:28:03', '2025-03-04 06:28:03', '2025-03-04 06:28:03', '0000-00-00 00:00:00'),
(80, 'https://tophorny.com/zh-cn/%E5%A5%87%E7%8A%BD%E7%9A%84%E7%A7%98%E7%A9%B4%E7%94%9F%E6%B4%BB-5-%E9%A2%84%E8%A7%88%E5%BD%B1%E7%89%87', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:28:04', '2025-03-04 06:28:04', '2025-03-04 06:28:04', '0000-00-00 00:00:00'),
(81, 'https://tophorny.com/zh-cn/tag/%E7%99%BD%E5%87%80', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:28:06', '2025-03-04 06:28:06', '2025-03-04 06:28:06', '0000-00-00 00:00:00'),
(82, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-2-preview-video', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:37:48', '2025-03-04 06:37:48', '2025-03-04 06:37:48', '0000-00-00 00:00:00'),
(83, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-5-preview-video', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:43:07', '2025-03-04 06:43:07', '2025-03-04 06:43:07', '0000-00-00 00:00:00'),
(84, 'https://tophorny.com/killuas-secret-cave-life-4-preview-video', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:43:32', '2025-03-04 06:43:32', '2025-03-04 06:43:32', '0000-00-00 00:00:00'),
(85, 'https://tophorny.com/rising-dragon-fist-in-the-meat-hole-4-preview-video', '', '', '', '', NULL, 0, 0, '', '', 'to-submit', '2025-03-04 06:43:33', '2025-03-04 06:43:33', '2025-03-04 06:43:33', '0000-00-00 00:00:00');

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

--
-- 資料表結構 `tophorny_wps_custom_menu`
--

CREATE TABLE `tophorny_wps_custom_menu` (
  `id` int(11) NOT NULL,
  `blog_id` int(11) NOT NULL,
  `menu_title` varchar(250) NOT NULL,
  `menu_data` longtext DEFAULT NULL,
  `user_type` varchar(20) DEFAULT NULL,
  `menu_role_id` varchar(100) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `other_data` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- 已傾印資料表的索引
--

--
-- 資料表索引 `tophorny_actionscheduler_actions`
--
ALTER TABLE `tophorny_actionscheduler_actions`
  ADD PRIMARY KEY (`action_id`),
  ADD KEY `hook_status_scheduled_date_gmt` (`hook`(163),`status`,`scheduled_date_gmt`),
  ADD KEY `status_scheduled_date_gmt` (`status`,`scheduled_date_gmt`),
  ADD KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
  ADD KEY `args` (`args`),
  ADD KEY `group_id` (`group_id`),
  ADD KEY `last_attempt_gmt` (`last_attempt_gmt`),
  ADD KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`);

--
-- 資料表索引 `tophorny_actionscheduler_claims`
--
ALTER TABLE `tophorny_actionscheduler_claims`
  ADD PRIMARY KEY (`claim_id`),
  ADD KEY `date_created_gmt` (`date_created_gmt`);

--
-- 資料表索引 `tophorny_actionscheduler_groups`
--
ALTER TABLE `tophorny_actionscheduler_groups`
  ADD PRIMARY KEY (`group_id`),
  ADD KEY `slug` (`slug`(191));

--
-- 資料表索引 `tophorny_actionscheduler_logs`
--
ALTER TABLE `tophorny_actionscheduler_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `action_id` (`action_id`),
  ADD KEY `log_date_gmt` (`log_date_gmt`);

--
-- 資料表索引 `tophorny_advads_clicks`
--
ALTER TABLE `tophorny_advads_clicks`
  ADD PRIMARY KEY (`timestamp`,`ad_id`);

--
-- 資料表索引 `tophorny_advads_impressions`
--
ALTER TABLE `tophorny_advads_impressions`
  ADD PRIMARY KEY (`timestamp`,`ad_id`);

--
-- 資料表索引 `tophorny_commentmeta`
--
ALTER TABLE `tophorny_commentmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `comment_id` (`comment_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- 資料表索引 `tophorny_comments`
--
ALTER TABLE `tophorny_comments`
  ADD PRIMARY KEY (`comment_ID`),
  ADD KEY `comment_post_ID` (`comment_post_ID`),
  ADD KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  ADD KEY `comment_date_gmt` (`comment_date_gmt`),
  ADD KEY `comment_parent` (`comment_parent`),
  ADD KEY `comment_author_email` (`comment_author_email`(10)),
  ADD KEY `woo_idx_comment_type` (`comment_type`);

--
-- 資料表索引 `tophorny_db7_forms`
--
ALTER TABLE `tophorny_db7_forms`
  ADD PRIMARY KEY (`form_id`);

--
-- 資料表索引 `tophorny_e_events`
--
ALTER TABLE `tophorny_e_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `created_at_index` (`created_at`);

--
-- 資料表索引 `tophorny_e_notes`
--
ALTER TABLE `tophorny_e_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `route_url_index` (`route_url`(191)),
  ADD KEY `post_id_index` (`post_id`),
  ADD KEY `element_id_index` (`element_id`),
  ADD KEY `parent_id_index` (`parent_id`),
  ADD KEY `author_id_index` (`author_id`),
  ADD KEY `status_index` (`status`),
  ADD KEY `is_resolved_index` (`is_resolved`),
  ADD KEY `is_public_index` (`is_public`),
  ADD KEY `created_at_index` (`created_at`),
  ADD KEY `updated_at_index` (`updated_at`),
  ADD KEY `last_activity_at_index` (`last_activity_at`);

--
-- 資料表索引 `tophorny_e_notes_users_relations`
--
ALTER TABLE `tophorny_e_notes_users_relations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type_index` (`type`),
  ADD KEY `note_id_index` (`note_id`),
  ADD KEY `user_id_index` (`user_id`);

--
-- 資料表索引 `tophorny_e_submissions`
--
ALTER TABLE `tophorny_e_submissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `hash_id_unique_index` (`hash_id`),
  ADD KEY `main_meta_id_index` (`main_meta_id`),
  ADD KEY `hash_id_index` (`hash_id`),
  ADD KEY `type_index` (`type`),
  ADD KEY `post_id_index` (`post_id`),
  ADD KEY `element_id_index` (`element_id`),
  ADD KEY `campaign_id_index` (`campaign_id`),
  ADD KEY `user_id_index` (`user_id`),
  ADD KEY `user_ip_index` (`user_ip`),
  ADD KEY `status_index` (`status`),
  ADD KEY `is_read_index` (`is_read`),
  ADD KEY `created_at_gmt_index` (`created_at_gmt`),
  ADD KEY `updated_at_gmt_index` (`updated_at_gmt`),
  ADD KEY `created_at_index` (`created_at`),
  ADD KEY `updated_at_index` (`updated_at`),
  ADD KEY `referer_index` (`referer`(191)),
  ADD KEY `referer_title_index` (`referer_title`(191));

--
-- 資料表索引 `tophorny_e_submissions_actions_log`
--
ALTER TABLE `tophorny_e_submissions_actions_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `submission_id_index` (`submission_id`),
  ADD KEY `action_name_index` (`action_name`),
  ADD KEY `status_index` (`status`),
  ADD KEY `created_at_gmt_index` (`created_at_gmt`),
  ADD KEY `updated_at_gmt_index` (`updated_at_gmt`),
  ADD KEY `created_at_index` (`created_at`),
  ADD KEY `updated_at_index` (`updated_at`);

--
-- 資料表索引 `tophorny_e_submissions_values`
--
ALTER TABLE `tophorny_e_submissions_values`
  ADD PRIMARY KEY (`id`),
  ADD KEY `submission_id_index` (`submission_id`),
  ADD KEY `key_index` (`key`);

--
-- 資料表索引 `tophorny_fbv`
--
ALTER TABLE `tophorny_fbv`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- 資料表索引 `tophorny_fbv_attachment_folder`
--
ALTER TABLE `tophorny_fbv_attachment_folder`
  ADD PRIMARY KEY (`folder_id`,`attachment_id`);

--
-- 資料表索引 `tophorny_hfcm_scripts`
--
ALTER TABLE `tophorny_hfcm_scripts`
  ADD PRIMARY KEY (`script_id`);

--
-- 資料表索引 `tophorny_imagify_files`
--
ALTER TABLE `tophorny_imagify_files`
  ADD PRIMARY KEY (`file_id`),
  ADD UNIQUE KEY `path` (`path`),
  ADD KEY `folder_id` (`folder_id`),
  ADD KEY `optimization_level` (`optimization_level`),
  ADD KEY `status` (`status`),
  ADD KEY `modified` (`modified`);

--
-- 資料表索引 `tophorny_imagify_folders`
--
ALTER TABLE `tophorny_imagify_folders`
  ADD PRIMARY KEY (`folder_id`),
  ADD UNIQUE KEY `path` (`path`),
  ADD KEY `active` (`active`);

--
-- 資料表索引 `tophorny_links`
--
ALTER TABLE `tophorny_links`
  ADD PRIMARY KEY (`link_id`),
  ADD KEY `link_visible` (`link_visible`);

--
-- 資料表索引 `tophorny_options`
--
ALTER TABLE `tophorny_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`),
  ADD KEY `autoload` (`autoload`);

--
-- 資料表索引 `tophorny_postmeta`
--
ALTER TABLE `tophorny_postmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- 資料表索引 `tophorny_posts`
--
ALTER TABLE `tophorny_posts`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `post_name` (`post_name`(191)),
  ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  ADD KEY `post_parent` (`post_parent`),
  ADD KEY `post_author` (`post_author`);

--
-- 資料表索引 `tophorny_rank_math_analytics_keyword_manager`
--
ALTER TABLE `tophorny_rank_math_analytics_keyword_manager`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `tophorny_rank_math_analytics_objects`
--
ALTER TABLE `tophorny_rank_math_analytics_objects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analytics_object_page` (`page`(190));

--
-- 資料表索引 `tophorny_rank_math_internal_links`
--
ALTER TABLE `tophorny_rank_math_internal_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `link_direction` (`post_id`,`type`),
  ADD KEY `target_post_id` (`target_post_id`);

--
-- 資料表索引 `tophorny_rank_math_internal_meta`
--
ALTER TABLE `tophorny_rank_math_internal_meta`
  ADD PRIMARY KEY (`object_id`);

--
-- 資料表索引 `tophorny_snippets`
--
ALTER TABLE `tophorny_snippets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `scope` (`scope`),
  ADD KEY `active` (`active`);

--
-- 資料表索引 `tophorny_termmeta`
--
ALTER TABLE `tophorny_termmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `term_id` (`term_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- 資料表索引 `tophorny_terms`
--
ALTER TABLE `tophorny_terms`
  ADD PRIMARY KEY (`term_id`),
  ADD KEY `slug` (`slug`(191)),
  ADD KEY `name` (`name`(191));

--
-- 資料表索引 `tophorny_term_relationships`
--
ALTER TABLE `tophorny_term_relationships`
  ADD PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  ADD KEY `term_taxonomy_id` (`term_taxonomy_id`);

--
-- 資料表索引 `tophorny_term_taxonomy`
--
ALTER TABLE `tophorny_term_taxonomy`
  ADD PRIMARY KEY (`term_taxonomy_id`),
  ADD UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  ADD KEY `taxonomy` (`taxonomy`);

--
-- 資料表索引 `tophorny_usermeta`
--
ALTER TABLE `tophorny_usermeta`
  ADD PRIMARY KEY (`umeta_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- 資料表索引 `tophorny_users`
--
ALTER TABLE `tophorny_users`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `user_login_key` (`user_login`),
  ADD KEY `user_nicename` (`user_nicename`),
  ADD KEY `user_email` (`user_email`);

--
-- 資料表索引 `tophorny_user_verification_stats`
--
ALTER TABLE `tophorny_user_verification_stats`
  ADD UNIQUE KEY `id` (`id`);

--
-- 資料表索引 `tophorny_wc_admin_notes`
--
ALTER TABLE `tophorny_wc_admin_notes`
  ADD PRIMARY KEY (`note_id`);

--
-- 資料表索引 `tophorny_wc_admin_note_actions`
--
ALTER TABLE `tophorny_wc_admin_note_actions`
  ADD PRIMARY KEY (`action_id`),
  ADD KEY `note_id` (`note_id`);

--
-- 資料表索引 `tophorny_wc_category_lookup`
--
ALTER TABLE `tophorny_wc_category_lookup`
  ADD PRIMARY KEY (`category_tree_id`,`category_id`);

--
-- 資料表索引 `tophorny_wc_customer_lookup`
--
ALTER TABLE `tophorny_wc_customer_lookup`
  ADD PRIMARY KEY (`customer_id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD KEY `email` (`email`);

--
-- 資料表索引 `tophorny_wc_download_log`
--
ALTER TABLE `tophorny_wc_download_log`
  ADD PRIMARY KEY (`download_log_id`),
  ADD KEY `permission_id` (`permission_id`),
  ADD KEY `timestamp` (`timestamp`);

--
-- 資料表索引 `tophorny_wc_orders`
--
ALTER TABLE `tophorny_wc_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `date_created` (`date_created_gmt`),
  ADD KEY `customer_id_billing_email` (`customer_id`,`billing_email`(171)),
  ADD KEY `billing_email` (`billing_email`(191)),
  ADD KEY `type_status_date` (`type`,`status`,`date_created_gmt`),
  ADD KEY `parent_order_id` (`parent_order_id`),
  ADD KEY `date_updated` (`date_updated_gmt`);

--
-- 資料表索引 `tophorny_wc_orders_meta`
--
ALTER TABLE `tophorny_wc_orders_meta`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meta_key_value` (`meta_key`(100),`meta_value`(82)),
  ADD KEY `order_id_meta_key_meta_value` (`order_id`,`meta_key`(100),`meta_value`(82));

--
-- 資料表索引 `tophorny_wc_order_addresses`
--
ALTER TABLE `tophorny_wc_order_addresses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `address_type_order_id` (`address_type`,`order_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `email` (`email`(191)),
  ADD KEY `phone` (`phone`);

--
-- 資料表索引 `tophorny_wc_order_coupon_lookup`
--
ALTER TABLE `tophorny_wc_order_coupon_lookup`
  ADD PRIMARY KEY (`order_id`,`coupon_id`),
  ADD KEY `coupon_id` (`coupon_id`),
  ADD KEY `date_created` (`date_created`);

--
-- 資料表索引 `tophorny_wc_order_operational_data`
--
ALTER TABLE `tophorny_wc_order_operational_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_id` (`order_id`),
  ADD KEY `order_key` (`order_key`);

--
-- 資料表索引 `tophorny_wc_order_product_lookup`
--
ALTER TABLE `tophorny_wc_order_product_lookup`
  ADD PRIMARY KEY (`order_item_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `date_created` (`date_created`);

--
-- 資料表索引 `tophorny_wc_order_stats`
--
ALTER TABLE `tophorny_wc_order_stats`
  ADD PRIMARY KEY (`order_id`),
  ADD KEY `date_created` (`date_created`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `status` (`status`(191));

--
-- 資料表索引 `tophorny_wc_order_tax_lookup`
--
ALTER TABLE `tophorny_wc_order_tax_lookup`
  ADD PRIMARY KEY (`order_id`,`tax_rate_id`),
  ADD KEY `tax_rate_id` (`tax_rate_id`),
  ADD KEY `date_created` (`date_created`);

--
-- 資料表索引 `tophorny_wc_product_attributes_lookup`
--
ALTER TABLE `tophorny_wc_product_attributes_lookup`
  ADD PRIMARY KEY (`product_or_parent_id`,`term_id`,`product_id`,`taxonomy`),
  ADD KEY `is_variation_attribute_term_id` (`is_variation_attribute`,`term_id`);

--
-- 資料表索引 `tophorny_wc_product_download_directories`
--
ALTER TABLE `tophorny_wc_product_download_directories`
  ADD PRIMARY KEY (`url_id`),
  ADD KEY `url` (`url`(191));

--
-- 資料表索引 `tophorny_wc_product_meta_lookup`
--
ALTER TABLE `tophorny_wc_product_meta_lookup`
  ADD PRIMARY KEY (`product_id`),
  ADD KEY `virtual` (`virtual`),
  ADD KEY `downloadable` (`downloadable`),
  ADD KEY `stock_status` (`stock_status`),
  ADD KEY `stock_quantity` (`stock_quantity`),
  ADD KEY `onsale` (`onsale`),
  ADD KEY `min_max_price` (`min_price`,`max_price`),
  ADD KEY `sku` (`sku`(50));

--
-- 資料表索引 `tophorny_wc_rate_limits`
--
ALTER TABLE `tophorny_wc_rate_limits`
  ADD PRIMARY KEY (`rate_limit_id`),
  ADD UNIQUE KEY `rate_limit_key` (`rate_limit_key`(191));

--
-- 資料表索引 `tophorny_wc_reserved_stock`
--
ALTER TABLE `tophorny_wc_reserved_stock`
  ADD PRIMARY KEY (`order_id`,`product_id`);

--
-- 資料表索引 `tophorny_wc_tax_rate_classes`
--
ALTER TABLE `tophorny_wc_tax_rate_classes`
  ADD PRIMARY KEY (`tax_rate_class_id`),
  ADD UNIQUE KEY `slug` (`slug`(191));

--
-- 資料表索引 `tophorny_wc_webhooks`
--
ALTER TABLE `tophorny_wc_webhooks`
  ADD PRIMARY KEY (`webhook_id`),
  ADD KEY `user_id` (`user_id`);

--
-- 資料表索引 `tophorny_woocommerce_api_keys`
--
ALTER TABLE `tophorny_woocommerce_api_keys`
  ADD PRIMARY KEY (`key_id`),
  ADD KEY `consumer_key` (`consumer_key`),
  ADD KEY `consumer_secret` (`consumer_secret`);

--
-- 資料表索引 `tophorny_woocommerce_attribute_taxonomies`
--
ALTER TABLE `tophorny_woocommerce_attribute_taxonomies`
  ADD PRIMARY KEY (`attribute_id`),
  ADD KEY `attribute_name` (`attribute_name`(20));

--
-- 資料表索引 `tophorny_woocommerce_downloadable_product_permissions`
--
ALTER TABLE `tophorny_woocommerce_downloadable_product_permissions`
  ADD PRIMARY KEY (`permission_id`),
  ADD KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
  ADD KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`);

--
-- 資料表索引 `tophorny_woocommerce_log`
--
ALTER TABLE `tophorny_woocommerce_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `level` (`level`);

--
-- 資料表索引 `tophorny_woocommerce_order_itemmeta`
--
ALTER TABLE `tophorny_woocommerce_order_itemmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `order_item_id` (`order_item_id`),
  ADD KEY `meta_key` (`meta_key`(32));

--
-- 資料表索引 `tophorny_woocommerce_order_items`
--
ALTER TABLE `tophorny_woocommerce_order_items`
  ADD PRIMARY KEY (`order_item_id`),
  ADD KEY `order_id` (`order_id`);

--
-- 資料表索引 `tophorny_woocommerce_payment_tokenmeta`
--
ALTER TABLE `tophorny_woocommerce_payment_tokenmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `payment_token_id` (`payment_token_id`),
  ADD KEY `meta_key` (`meta_key`(32));

--
-- 資料表索引 `tophorny_woocommerce_payment_tokens`
--
ALTER TABLE `tophorny_woocommerce_payment_tokens`
  ADD PRIMARY KEY (`token_id`),
  ADD KEY `user_id` (`user_id`);

--
-- 資料表索引 `tophorny_woocommerce_sessions`
--
ALTER TABLE `tophorny_woocommerce_sessions`
  ADD PRIMARY KEY (`session_id`),
  ADD UNIQUE KEY `session_key` (`session_key`);

--
-- 資料表索引 `tophorny_woocommerce_shipping_zones`
--
ALTER TABLE `tophorny_woocommerce_shipping_zones`
  ADD PRIMARY KEY (`zone_id`);

--
-- 資料表索引 `tophorny_woocommerce_shipping_zone_locations`
--
ALTER TABLE `tophorny_woocommerce_shipping_zone_locations`
  ADD PRIMARY KEY (`location_id`),
  ADD KEY `zone_id` (`zone_id`),
  ADD KEY `location_type_code` (`location_type`(10),`location_code`(20));

--
-- 資料表索引 `tophorny_woocommerce_shipping_zone_methods`
--
ALTER TABLE `tophorny_woocommerce_shipping_zone_methods`
  ADD PRIMARY KEY (`instance_id`);

--
-- 資料表索引 `tophorny_woocommerce_tax_rates`
--
ALTER TABLE `tophorny_woocommerce_tax_rates`
  ADD PRIMARY KEY (`tax_rate_id`),
  ADD KEY `tax_rate_country` (`tax_rate_country`),
  ADD KEY `tax_rate_state` (`tax_rate_state`(2)),
  ADD KEY `tax_rate_class` (`tax_rate_class`(10)),
  ADD KEY `tax_rate_priority` (`tax_rate_priority`);

--
-- 資料表索引 `tophorny_woocommerce_tax_rate_locations`
--
ALTER TABLE `tophorny_woocommerce_tax_rate_locations`
  ADD PRIMARY KEY (`location_id`),
  ADD KEY `tax_rate_id` (`tax_rate_id`),
  ADD KEY `location_type_code` (`location_type`(10),`location_code`(20));

--
-- 資料表索引 `tophorny_wpmailsmtp_debug_events`
--
ALTER TABLE `tophorny_wpmailsmtp_debug_events`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `tophorny_wpmailsmtp_tasks_meta`
--
ALTER TABLE `tophorny_wpmailsmtp_tasks_meta`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `tophorny_wpmm_subscribers`
--
ALTER TABLE `tophorny_wpmm_subscribers`
  ADD PRIMARY KEY (`id_subscriber`);

--
-- 資料表索引 `tophorny_wpr_above_the_fold`
--
ALTER TABLE `tophorny_wpr_above_the_fold`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`url`(150),`is_mobile`),
  ADD KEY `modified` (`modified`),
  ADD KEY `last_accessed` (`last_accessed`),
  ADD KEY `status_index` (`status`(191));

--
-- 資料表索引 `tophorny_wpr_lazy_render_content`
--
ALTER TABLE `tophorny_wpr_lazy_render_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`url`(150),`is_mobile`),
  ADD KEY `modified` (`modified`),
  ADD KEY `last_accessed` (`last_accessed`),
  ADD KEY `status_index` (`status`(191));

--
-- 資料表索引 `tophorny_wpr_rocket_cache`
--
ALTER TABLE `tophorny_wpr_rocket_cache`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`url`(191)),
  ADD KEY `modified` (`modified`),
  ADD KEY `last_accessed` (`last_accessed`);

--
-- 資料表索引 `tophorny_wpr_rucss_used_css`
--
ALTER TABLE `tophorny_wpr_rucss_used_css`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`url`(150),`is_mobile`),
  ADD KEY `modified` (`modified`),
  ADD KEY `last_accessed` (`last_accessed`),
  ADD KEY `status_index` (`status`(191)),
  ADD KEY `error_code_index` (`error_code`),
  ADD KEY `hash` (`hash`);

--
-- 資料表索引 `tophorny_wps_custom_menu`
--
ALTER TABLE `tophorny_wps_custom_menu`
  ADD PRIMARY KEY (`id`);

--
-- 在傾印的資料表使用自動遞增(AUTO_INCREMENT)
--

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_actionscheduler_actions`
--
ALTER TABLE `tophorny_actionscheduler_actions`
  MODIFY `action_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1381;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_actionscheduler_claims`
--
ALTER TABLE `tophorny_actionscheduler_claims`
  MODIFY `claim_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1849;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_actionscheduler_groups`
--
ALTER TABLE `tophorny_actionscheduler_groups`
  MODIFY `group_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_actionscheduler_logs`
--
ALTER TABLE `tophorny_actionscheduler_logs`
  MODIFY `log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4048;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_commentmeta`
--
ALTER TABLE `tophorny_commentmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_comments`
--
ALTER TABLE `tophorny_comments`
  MODIFY `comment_ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_db7_forms`
--
ALTER TABLE `tophorny_db7_forms`
  MODIFY `form_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_e_events`
--
ALTER TABLE `tophorny_e_events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_e_notes`
--
ALTER TABLE `tophorny_e_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_e_notes_users_relations`
--
ALTER TABLE `tophorny_e_notes_users_relations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_e_submissions`
--
ALTER TABLE `tophorny_e_submissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_e_submissions_actions_log`
--
ALTER TABLE `tophorny_e_submissions_actions_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_e_submissions_values`
--
ALTER TABLE `tophorny_e_submissions_values`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_fbv`
--
ALTER TABLE `tophorny_fbv`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_hfcm_scripts`
--
ALTER TABLE `tophorny_hfcm_scripts`
  MODIFY `script_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_imagify_files`
--
ALTER TABLE `tophorny_imagify_files`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_imagify_folders`
--
ALTER TABLE `tophorny_imagify_folders`
  MODIFY `folder_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_links`
--
ALTER TABLE `tophorny_links`
  MODIFY `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_options`
--
ALTER TABLE `tophorny_options`
  MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6050;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_postmeta`
--
ALTER TABLE `tophorny_postmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2690;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_posts`
--
ALTER TABLE `tophorny_posts`
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=403;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_rank_math_analytics_keyword_manager`
--
ALTER TABLE `tophorny_rank_math_analytics_keyword_manager`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_rank_math_analytics_objects`
--
ALTER TABLE `tophorny_rank_math_analytics_objects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_rank_math_internal_links`
--
ALTER TABLE `tophorny_rank_math_internal_links`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_snippets`
--
ALTER TABLE `tophorny_snippets`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_termmeta`
--
ALTER TABLE `tophorny_termmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_terms`
--
ALTER TABLE `tophorny_terms`
  MODIFY `term_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_term_taxonomy`
--
ALTER TABLE `tophorny_term_taxonomy`
  MODIFY `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_usermeta`
--
ALTER TABLE `tophorny_usermeta`
  MODIFY `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_users`
--
ALTER TABLE `tophorny_users`
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_user_verification_stats`
--
ALTER TABLE `tophorny_user_verification_stats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_admin_notes`
--
ALTER TABLE `tophorny_wc_admin_notes`
  MODIFY `note_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_admin_note_actions`
--
ALTER TABLE `tophorny_wc_admin_note_actions`
  MODIFY `action_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2654;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_customer_lookup`
--
ALTER TABLE `tophorny_wc_customer_lookup`
  MODIFY `customer_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_download_log`
--
ALTER TABLE `tophorny_wc_download_log`
  MODIFY `download_log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_orders_meta`
--
ALTER TABLE `tophorny_wc_orders_meta`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_order_addresses`
--
ALTER TABLE `tophorny_wc_order_addresses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_order_operational_data`
--
ALTER TABLE `tophorny_wc_order_operational_data`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_product_download_directories`
--
ALTER TABLE `tophorny_wc_product_download_directories`
  MODIFY `url_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_rate_limits`
--
ALTER TABLE `tophorny_wc_rate_limits`
  MODIFY `rate_limit_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_tax_rate_classes`
--
ALTER TABLE `tophorny_wc_tax_rate_classes`
  MODIFY `tax_rate_class_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wc_webhooks`
--
ALTER TABLE `tophorny_wc_webhooks`
  MODIFY `webhook_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_api_keys`
--
ALTER TABLE `tophorny_woocommerce_api_keys`
  MODIFY `key_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_attribute_taxonomies`
--
ALTER TABLE `tophorny_woocommerce_attribute_taxonomies`
  MODIFY `attribute_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_downloadable_product_permissions`
--
ALTER TABLE `tophorny_woocommerce_downloadable_product_permissions`
  MODIFY `permission_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_log`
--
ALTER TABLE `tophorny_woocommerce_log`
  MODIFY `log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_order_itemmeta`
--
ALTER TABLE `tophorny_woocommerce_order_itemmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_order_items`
--
ALTER TABLE `tophorny_woocommerce_order_items`
  MODIFY `order_item_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_payment_tokenmeta`
--
ALTER TABLE `tophorny_woocommerce_payment_tokenmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_payment_tokens`
--
ALTER TABLE `tophorny_woocommerce_payment_tokens`
  MODIFY `token_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_sessions`
--
ALTER TABLE `tophorny_woocommerce_sessions`
  MODIFY `session_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=925;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_shipping_zones`
--
ALTER TABLE `tophorny_woocommerce_shipping_zones`
  MODIFY `zone_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_shipping_zone_locations`
--
ALTER TABLE `tophorny_woocommerce_shipping_zone_locations`
  MODIFY `location_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_shipping_zone_methods`
--
ALTER TABLE `tophorny_woocommerce_shipping_zone_methods`
  MODIFY `instance_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_tax_rates`
--
ALTER TABLE `tophorny_woocommerce_tax_rates`
  MODIFY `tax_rate_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_woocommerce_tax_rate_locations`
--
ALTER TABLE `tophorny_woocommerce_tax_rate_locations`
  MODIFY `location_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wpmailsmtp_debug_events`
--
ALTER TABLE `tophorny_wpmailsmtp_debug_events`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wpmailsmtp_tasks_meta`
--
ALTER TABLE `tophorny_wpmailsmtp_tasks_meta`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wpmm_subscribers`
--
ALTER TABLE `tophorny_wpmm_subscribers`
  MODIFY `id_subscriber` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wpr_above_the_fold`
--
ALTER TABLE `tophorny_wpr_above_the_fold`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wpr_lazy_render_content`
--
ALTER TABLE `tophorny_wpr_lazy_render_content`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wpr_rocket_cache`
--
ALTER TABLE `tophorny_wpr_rocket_cache`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wpr_rucss_used_css`
--
ALTER TABLE `tophorny_wpr_rucss_used_css`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `tophorny_wps_custom_menu`
--
ALTER TABLE `tophorny_wps_custom_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

