admin 发表于 2022-1-1 15:23:42

Discuz!X3.5新增 回帖数据结构化所需的表结构需要升级的数据库语句

Discuz!X3.5新增 回帖数据结构化所需的表结构需要升级的数据库语句:

ALTER TABLE `pre_forum_post` ADD `repid` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tid`;

ALTER TABLE `pre_forum_post` ADD `lastupdate` int(10) unsigned NOT NULL DEFAULT '0' AFTER `dateline`;

ALTER TABLE `pre_forum_post` ADD `updateuid` int(10) unsigned NOT NULL DEFAULT '0' AFTER `lastupdate`;

ALTER TABLE `pre_forum_post` ADD `premsg` text NOT NULL AFTER `updateuid`;


DROP TABLE IF EXISTS pre_forum_post_history;
CREATE TABLE pre_forum_post_history (
id int(10) unsigned NOT NULL,
pid int(10) unsigned NOT NULL,
dateline int(10) unsigned NOT NULL,
`subject` varchar(255) NOT NULL DEFAULT '',
message mediumtext NOT NULL,
PRIMARY KEY (id),
KEY pid (pid,dateline)
) ENGINE=InnoDB;

页: [1]
查看完整版本: Discuz!X3.5新增 回帖数据结构化所需的表结构需要升级的数据库语句

创宇盾启航版免费网站防御网站加速服务