没想到 WordPress 已经可以支持 Mysql 8.4.2 的 caching_sha2_password 密码插件。
凌晨在研究 LANMP 环境时特意将 10.11.6-MariaDB 换成了 mysql 8.4.2 数据库，然后就特意验证一下能直接部署 WordPress 程序，毕竟之前迁移出现了错误。
没想到在默认配置的情况下竟然就直接安装成功了，然后查看表结构看到其默认值也是 0000-00-00 00:00:00，所以不免觉得奇怪！为什么迁移时就会报错呢？难道是安装时就执行暂时修改了 sql_mode 了吧。
最让我兴起的是竟然支持 caching_sha2_password 的密码插件，这样下次正式使用 Mysql 8.4.x 时就不需要特意改回旧的密码插件了。
旧表结构：
/* Navicat Premium Dump SQL Source Server : 47.97.219.152 Source Server Type : MariaDB Source Server Version : 100434 (10.4.34-MariaDB) Source Host : localhost:3306 Source Schema : wordpress Target Server Type : MariaDB Target Server Version : 100434 (10.4.34-MariaDB) File Encoding : 65001 Date: 05/10/2024 05:40:34 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for wp_commentmeta -- ---------------------------- DROP TABLE IF EXISTS `wp_commentmeta`; CREATE TABLE `wp_commentmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`meta_id`) USING BTREE, INDEX `comment_id`(`comment_id`) USING BTREE, INDEX `meta_key`(`meta_key`(191)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4529 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_comments -- ---------------------------- DROP TABLE IF EXISTS `wp_comments`; CREATE TABLE `wp_comments` ( `comment_ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `comment_post_ID` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `comment_author` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `comment_author_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_author_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_author_IP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `comment_karma` int(11) NOT NULL DEFAULT 0, `comment_approved` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `comment_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'comment', `comment_parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`comment_ID`) USING BTREE, INDEX `comment_post_ID`(`comment_post_ID`) USING BTREE, INDEX `comment_approved_date_gmt`(`comment_approved`, `comment_date_gmt`) USING BTREE, INDEX `comment_date_gmt`(`comment_date_gmt`) USING BTREE, INDEX `comment_parent`(`comment_parent`) USING BTREE, INDEX `comment_author_email`(`comment_author_email`(10)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2226 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_links -- ---------------------------- DROP TABLE IF EXISTS `wp_links`; CREATE TABLE `wp_links` ( `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `link_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_target` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_visible` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y', `link_owner` bigint(20) UNSIGNED NOT NULL DEFAULT 1, `link_rating` int(11) NOT NULL DEFAULT 0, `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `link_rel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `link_rss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`link_id`) USING BTREE, INDEX `link_visible`(`link_visible`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_options -- ---------------------------- DROP TABLE IF EXISTS `wp_options`; CREATE TABLE `wp_options` ( `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes', PRIMARY KEY (`option_id`) USING BTREE, UNIQUE INDEX `option_name`(`option_name`) USING BTREE, INDEX `autoload`(`autoload`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 41486 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_postmeta -- ---------------------------- DROP TABLE IF EXISTS `wp_postmeta`; CREATE TABLE `wp_postmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`meta_id`) USING BTREE, INDEX `post_id`(`post_id`) USING BTREE, INDEX `meta_key`(`meta_key`(191)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1610 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_posts -- ---------------------------- DROP TABLE IF EXISTS `wp_posts`; CREATE TABLE `wp_posts` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `post_author` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `post_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `post_excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `post_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish', `comment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open', `ping_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open', `post_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `post_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `to_ping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pinged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_content_filtered` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `post_parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `guid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_order` int(11) NOT NULL DEFAULT 0, `post_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'post', `post_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_count` bigint(20) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) USING BTREE, INDEX `post_name`(`post_name`(191)) USING BTREE, INDEX `type_status_date`(`post_type`, `post_status`, `post_date`, `ID`) USING BTREE, INDEX `post_parent`(`post_parent`) USING BTREE, INDEX `post_author`(`post_author`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2113 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_term_relationships -- ---------------------------- DROP TABLE IF EXISTS `wp_term_relationships`; CREATE TABLE `wp_term_relationships` ( `object_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `term_order` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`object_id`, `term_taxonomy_id`) USING BTREE, INDEX `term_taxonomy_id`(`term_taxonomy_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_term_taxonomy -- ---------------------------- DROP TABLE IF EXISTS `wp_term_taxonomy`; CREATE TABLE `wp_term_taxonomy` ( `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `taxonomy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `count` bigint(20) NOT NULL DEFAULT 0, PRIMARY KEY (`term_taxonomy_id`) USING BTREE, UNIQUE INDEX `term_id_taxonomy`(`term_id`, `taxonomy`) USING BTREE, INDEX `taxonomy`(`taxonomy`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_termmeta -- ---------------------------- DROP TABLE IF EXISTS `wp_termmeta`; CREATE TABLE `wp_termmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`meta_id`) USING BTREE, INDEX `term_id`(`term_id`) USING BTREE, INDEX `meta_key`(`meta_key`(191)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_terms -- ---------------------------- DROP TABLE IF EXISTS `wp_terms`; CREATE TABLE `wp_terms` ( `term_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `slug` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `term_group` bigint(10) NOT NULL DEFAULT 0, PRIMARY KEY (`term_id`) USING BTREE, INDEX `slug`(`slug`(191)) USING BTREE, INDEX `name`(`name`(191)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_usermeta -- ---------------------------- DROP TABLE IF EXISTS `wp_usermeta`; CREATE TABLE `wp_usermeta` ( `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`umeta_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `meta_key`(`meta_key`(191)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 589 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_users -- ---------------------------- DROP TABLE IF EXISTS `wp_users`; CREATE TABLE `wp_users` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_nicename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `user_activation_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_status` int(11) NOT NULL DEFAULT 0, `display_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`ID`) USING BTREE, INDEX `user_login_key`(`user_login`) USING BTREE, INDEX `user_nicename`(`user_nicename`) USING BTREE, INDEX `user_email`(`user_email`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_wp_optimisation_sizes_info -- ---------------------------- DROP TABLE IF EXISTS `wp_wp_optimisation_sizes_info`; CREATE TABLE `wp_wp_optimisation_sizes_info` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `size` bigint(20) NOT NULL DEFAULT 0, `optimised_size` bigint(20) NOT NULL DEFAULT 0, `date` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;
现表结构：
/* Navicat Premium Dump SQL Source Server : 47.97.219.152 Source Server Type : MySQL Source Server Version : 80402 (8.4.2) Source Host : localhost:3306 Source Schema : wordpress Target Server Type : MySQL Target Server Version : 80402 (8.4.2) File Encoding : 65001 Date: 09/10/2024 05:25:06 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for wp_commentmeta -- ---------------------------- DROP TABLE IF EXISTS `wp_commentmeta`; CREATE TABLE `wp_commentmeta` ( `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `comment_id` bigint UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL, PRIMARY KEY (`meta_id`) USING BTREE, INDEX `comment_id`(`comment_id` ASC) USING BTREE, INDEX `meta_key`(`meta_key`(191) ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_comments -- ---------------------------- DROP TABLE IF EXISTS `wp_comments`; CREATE TABLE `wp_comments` ( `comment_ID` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `comment_post_ID` bigint UNSIGNED NOT NULL DEFAULT 0, `comment_author` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `comment_author_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_author_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_author_IP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `comment_karma` int NOT NULL DEFAULT 0, `comment_approved` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1', `comment_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'comment', `comment_parent` bigint UNSIGNED NOT NULL DEFAULT 0, `user_id` bigint UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`comment_ID`) USING BTREE, INDEX `comment_post_ID`(`comment_post_ID` ASC) USING BTREE, INDEX `comment_approved_date_gmt`(`comment_approved` ASC, `comment_date_gmt` ASC) USING BTREE, INDEX `comment_date_gmt`(`comment_date_gmt` ASC) USING BTREE, INDEX `comment_parent`(`comment_parent` ASC) USING BTREE, INDEX `comment_author_email`(`comment_author_email`(10) ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_links -- ---------------------------- DROP TABLE IF EXISTS `wp_links`; CREATE TABLE `wp_links` ( `link_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `link_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_target` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_visible` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y', `link_owner` bigint UNSIGNED NOT NULL DEFAULT 1, `link_rating` int NOT NULL DEFAULT 0, `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `link_rel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `link_rss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', PRIMARY KEY (`link_id`) USING BTREE, INDEX `link_visible`(`link_visible` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_options -- ---------------------------- DROP TABLE IF EXISTS `wp_options`; CREATE TABLE `wp_options` ( `option_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes', PRIMARY KEY (`option_id`) USING BTREE, UNIQUE INDEX `option_name`(`option_name` ASC) USING BTREE, INDEX `autoload`(`autoload` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 160 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_postmeta -- ---------------------------- DROP TABLE IF EXISTS `wp_postmeta`; CREATE TABLE `wp_postmeta` ( `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `post_id` bigint UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL, PRIMARY KEY (`meta_id`) USING BTREE, INDEX `post_id`(`post_id` ASC) USING BTREE, INDEX `meta_key`(`meta_key`(191) ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_posts -- ---------------------------- DROP TABLE IF EXISTS `wp_posts`; CREATE TABLE `wp_posts` ( `ID` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `post_author` bigint UNSIGNED NOT NULL DEFAULT 0, `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish', `comment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open', `ping_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open', `post_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `post_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `to_ping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `pinged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_content_filtered` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_parent` bigint UNSIGNED NOT NULL DEFAULT 0, `guid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `menu_order` int NOT NULL DEFAULT 0, `post_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post', `post_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_count` bigint NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) USING BTREE, INDEX `post_name`(`post_name`(191) ASC) USING BTREE, INDEX `type_status_date`(`post_type` ASC, `post_status` ASC, `post_date` ASC, `ID` ASC) USING BTREE, INDEX `post_parent`(`post_parent` ASC) USING BTREE, INDEX `post_author`(`post_author` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_term_relationships -- ---------------------------- DROP TABLE IF EXISTS `wp_term_relationships`; CREATE TABLE `wp_term_relationships` ( `object_id` bigint UNSIGNED NOT NULL DEFAULT 0, `term_taxonomy_id` bigint UNSIGNED NOT NULL DEFAULT 0, `term_order` int NOT NULL DEFAULT 0, PRIMARY KEY (`object_id`, `term_taxonomy_id`) USING BTREE, INDEX `term_taxonomy_id`(`term_taxonomy_id` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_term_taxonomy -- ---------------------------- DROP TABLE IF EXISTS `wp_term_taxonomy`; CREATE TABLE `wp_term_taxonomy` ( `term_taxonomy_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `term_id` bigint UNSIGNED NOT NULL DEFAULT 0, `taxonomy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, `parent` bigint UNSIGNED NOT NULL DEFAULT 0, `count` bigint NOT NULL DEFAULT 0, PRIMARY KEY (`term_taxonomy_id`) USING BTREE, UNIQUE INDEX `term_id_taxonomy`(`term_id` ASC, `taxonomy` ASC) USING BTREE, INDEX `taxonomy`(`taxonomy` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_termmeta -- ---------------------------- DROP TABLE IF EXISTS `wp_termmeta`; CREATE TABLE `wp_termmeta` ( `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `term_id` bigint UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL, PRIMARY KEY (`meta_id`) USING BTREE, INDEX `term_id`(`term_id` ASC) USING BTREE, INDEX `meta_key`(`meta_key`(191) ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_terms -- ---------------------------- DROP TABLE IF EXISTS `wp_terms`; CREATE TABLE `wp_terms` ( `term_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `slug` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `term_group` bigint NOT NULL DEFAULT 0, PRIMARY KEY (`term_id`) USING BTREE, INDEX `slug`(`slug`(191) ASC) USING BTREE, INDEX `name`(`name`(191) ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_usermeta -- ---------------------------- DROP TABLE IF EXISTS `wp_usermeta`; CREATE TABLE `wp_usermeta` ( `umeta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint UNSIGNED NOT NULL DEFAULT 0, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL, PRIMARY KEY (`umeta_id`) USING BTREE, INDEX `user_id`(`user_id` ASC) USING BTREE, INDEX `meta_key`(`meta_key`(191) ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for wp_users -- ---------------------------- DROP TABLE IF EXISTS `wp_users`; CREATE TABLE `wp_users` ( `ID` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_nicename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `user_activation_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_status` int NOT NULL DEFAULT 0, `display_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', PRIMARY KEY (`ID`) USING BTREE, INDEX `user_login_key`(`user_login` ASC) USING BTREE, INDEX `user_nicename`(`user_nicename` ASC) USING BTREE, INDEX `user_email`(`user_email` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;
眼拙没看到什么区别，`comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 与 `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 不都是一样的？
看来还是临时修改了 sql_mode 吧？
ChiuYut
2024年10月09日