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]
