wordpress怎么转换成zblog-wordpress转zblog的方法
在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`;