在wp_posts创建字段post_category

update wp_posts, wp_term_relationships set wp_posts.post_category = wp_term_relationships.term_taxonomy_id where wp_posts.id=wp_term_relationships.object_id and wp_term_relationships.term_taxonomy_id in (select term_taxonomy_id from wp_term_taxonomy where taxonomy ='category')

这个语句将目录ID保存到了wp_posts表中，这样以后转换会方便一些。

ALTER TABLE `df_post` CHANGE `ID` `log_ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `df_post` CHANGE `post_category` `log_CateID` INT(11) NOT NULL;

ALTER TABLE `df_post` CHANGE `log_CateID` `log_CateID` INT(11) NOT NULL DEFAULT '0';

ALTER TABLE `df_post` ADD `log_AuthorID` INT(11) NOT NULL DEFAULT '1' AFTER `log_CateID`;

ALTER TABLE `df_post` CHANGE `log_AuthorID` `log_AuthorID` INT(11) NOT NULL DEFAULT '0';

ALTER TABLE `df_post` ADD `log_Tag` VARCHAR(250) NOT NULL AFTER `log_AuthorID`;

ALTER TABLE `df_post` ADD `log_Status` TINYINT(4) NOT NULL DEFAULT '0' AFTER `log_Tag`;

ALTER TABLE `df_post` ADD `log_Type` INT(11) NOT NULL DEFAULT '0' AFTER `log_Status`;

ALTER TABLE `df_post` ADD `log_Alias` VARCHAR(250) NOT NULL AFTER `log_Type`;

ALTER TABLE `df_post` ADD `log_IsTop` TINYINT(4) NOT NULL DEFAULT '0' AFTER `log_Alias`;

ALTER TABLE `df_post` ADD `log_IsLock` TINYINT(4) NOT NULL DEFAULT '0' AFTER `log_IsTop`;

ALTER TABLE `df_post` ADD `log_Title` VARCHAR(300) NOT NULL AFTER `log_IsLock`;

update df_post set  log_Title=post_title

ALTER TABLE `df_post` CHANGE `post_excerpt` `log_Intro` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL AFTER `log_Title`;

ALTER TABLE `df_post` CHANGE `post_content` `log_Content` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL AFTER `log_Intro`;

ALTER TABLE `df_post` ADD `log_CreateTime` INT(11) NOT NULL DEFAULT '0' AFTER `log_Content`;

ALTER TABLE `df_post` ADD `log_PostTime` INT(11) NOT NULL DEFAULT '0' AFTER `log_CreateTime`;

ALTER TABLE `df_post` ADD `log_UpdateTime` INT(11) NOT NULL DEFAULT '0' AFTER `log_PostTime`;

ALTER TABLE `df_post` ADD `log_CommNums` INT(11) NOT NULL DEFAULT '0' AFTER `log_UpdateTime`;

ALTER TABLE `df_post` ADD `log_ViewNums` INT(11) NOT NULL DEFAULT '0' AFTER `log_CommNums`;

ALTER TABLE `df_post` ADD `log_Template` VARCHAR(250) NOT NULL AFTER `log_ViewNums`;

ALTER TABLE `df_post` ADD `log_Meta` LONGTEXT NOT NULL AFTER `log_Template`;

将时间转换为时间戳

UPDATE df_post set log_CreateTime=UNIX_TIMESTAMP(post_date);

UPDATE df_post set log_PostTime=UNIX_TIMESTAMP(post_date);

UPDATE df_post set log_UpdateTime=UNIX_TIMESTAMP(post_date);

zblog 分站

insert into wlzs_post select * from df_post where log_CateID=1

delete from df_post where log_CateID=1

myqsl命令删除zblog文章少于2条的tag标签

delete from zbp_tag where tag_Count<2

UPDATE df_post SET log_CreateTime=REPLACE(log_CreateTime,'0','1677204912');

UPDATE df_post SET log_PostTime=REPLACE(log_PostTime,'0','1677204912');

UPDATE df_post SET log_UpdateTime=REPLACE(log_UpdateTime,'0','1677204912');

UPDATE df_post SET log_CreateTime=REPLACE(log_CreateTime,'214','170');

UPDATE df_post SET log_PostTime=REPLACE(log_PostTime,'214','170');

UPDATE df_post SET log_UpdateTime=REPLACE(log_UpdateTime,'214','170');

ALTER TABLE `df_category` CHANGE `term_id` `cate_ID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `df_category` CHANGE `name` `cate_Name` VARCHAR(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '';

ALTER TABLE `df_category` ADD `cate_Order` INT(11) NOT NULL DEFAULT '0' AFTER `cate_Name`;

ALTER TABLE `df_category` ADD `cate_Type` INT(11) NOT NULL DEFAULT '0' AFTER `cate_Order`;

ALTER TABLE `df_category` ADD `cate_Count` INT(11) NOT NULL DEFAULT '0' AFTER `cate_Type`;

ALTER TABLE `df_category` CHANGE `slug` `cate_Alias` VARCHAR(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '';

ALTER TABLE `df_category` ADD `cate_Group` VARCHAR(250) NOT NULL AFTER `cate_Alias`;

ALTER TABLE `df_category` ADD `cate_Intro` TEXT NOT NULL AFTER `cate_Group`;

ALTER TABLE `df_category` ADD `cate_RootID` INT(11) NOT NULL DEFAULT '0' AFTER `cate_Intro`;

ALTER TABLE `df_category` ADD `cate_ParentID` INT(11) NOT NULL DEFAULT '0' AFTER `cate_RootID`;

ALTER TABLE `df_category` ADD `cate_Template` VARCHAR(250) NOT NULL AFTER `cate_ParentID`;

ALTER TABLE `df_category` ADD `cate_LogTemplate` VARCHAR(250) NOT NULL AFTER `cate_Template`;

免责声明：本文内容来自用户上传并发布，站点仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。请核实广告和内容真实性，谨慎使用。