|
Discuz! X3.5 开发版每日构建升级教程
Discuz! X 3.5 每日构建下载:https://www.discuz.net/daily/
在Gitee有提交的第二天早上,可以下载到简体GBK、简体UTF8、繁体BIG5、繁体UTF8的打包版本。
本文仅记录 Discuz! X 3.5 构建版本自2021年09月18日至最新构建版本的mysql数据库的升级记录,若中间版本没有升级记录的即仅为程序文件的更新,下载 Discuz! X 3.5 的最新构建版本直接覆盖论坛程序文件即可。
目前已经升级到 最新的 Discuz! X 3.5-2022-01-01(Discuz! X3.5 Alpha-20211231)的构建版本,特别提醒,升级前务必记得备份站点程序文件和mysql数据库。升级明细如下:
2021-09-18 —— 2021-12-04 to 2021-12-06
说明:Discuz! X 3.5 构建版本自 2021-09-18 至 2021-12-04 升级为 2021-12-06 构建版本的SQL语句。
ALTER TABLE `pre_common_card` CHANGE status status tinyint(3) unsigned NOT NULL DEFAULT '1';
ALTER TABLE `pre_common_district` CHANGE usetype usetype tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_failedip` CHANGE count count tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_failedlogin` CHANGE count count tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_magiclog` CHANGE credit credit tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_member_field_forum` CHANGE customshow customshow tinyint(3) unsigned NOT NULL DEFAULT '26';
ALTER TABLE `pre_common_plugin` CHANGE adminid adminid tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_secquestion` CHANGE type type tinyint(3) unsigned NOT NULL;
ALTER TABLE `pre_common_session` CHANGE action action tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE allowmagics allowmagics tinyint(3) unsigned NOT NULL;
ALTER TABLE `pre_common_usergroup_field` CHANGE tradestick tradestick tinyint(3) unsigned NOT NULL;
ALTER TABLE `pre_common_usergroup_field` CHANGE exempt exempt tinyint(3) unsigned NOT NULL;
ALTER TABLE `pre_common_usergroup_field` CHANGE allowrecommend allowrecommend tinyint(3) unsigned NOT NULL DEFAULT '1';
ALTER TABLE `pre_common_usergroup_field` CHANGE allowbuildgroup allowbuildgroup tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE allowgroupdirectpost allowgroupdirectpost tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE allowgroupposturl allowgroupposturl tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE allowfollowcollection allowfollowcollection tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE forcelogin forcelogin tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_payment_transfer` CHANGE status status tinyint(3) unsigned NOT NULL;
ALTER TABLE `pre_forum_attachment` CHANGE tableid tableid tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_forum_bbcode` CHANGE params params tinyint(3) unsigned NOT NULL DEFAULT '1';
ALTER TABLE `pre_forum_medal` CHANGE credit credit tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_forum_ratelog` CHANGE extcredits extcredits tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_forum_trade` CHANGE quality quality tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_forum_tradelog` CHANGE paytype paytype tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_forum_tradelog` CHANGE quality quality tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_home_doing` CHANGE status status tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_home_pic` CHANGE status status tinyint(3) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `pre_ucenter_failedlogins` CHANGE count count tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_protectedmembers` CHANGE appid appid tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_lists` CHANGE pmtype pmtype tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_0` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_1` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_2` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_3` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_4` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_5` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_6` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_7` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_8` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `pre_ucenter_pm_messages_9` CHANGE delstatus delstatus tinyint(3) unsigned NOT NULL default '0';
2021-12-06 —— 2021-12-11 to 2021-12-12
说明:新增 允许用户拒绝被收听、加好友 的功能,下载Discuz! X 3.5-2021-12-12构建版本的文件直接覆盖即可,数据库升级SQL语句如下:
ALTER TABLE `pre_common_member_field_home` ADD `allowasfriend` TINYINT(1) NOT NULL DEFAULT '1' AFTER `addfriend`;
ALTER TABLE `pre_common_member_field_home` ADD `allowasfollow` TINYINT(1) NOT NULL DEFAULT '1' AFTER `allowasfriend`;
2021-12-12 to 2021-12-19
说明:用户历史资料下载功能相关表pre_common_member_profile_history以及设置参数的增加,数据库升级SQL语句如下:
CREATE TABLE pre_common_member_profile_history (
hid int(10) unsigned NOT NULL AUTO_INCREMENT,
uid mediumint(8) unsigned NOT NULL,
realname varchar(255) NOT NULL DEFAULT '',
gender tinyint(1) NOT NULL DEFAULT '0',
birthyear smallint(6) unsigned NOT NULL DEFAULT '0',
birthmonth tinyint(3) unsigned NOT NULL DEFAULT '0',
birthday tinyint(3) unsigned NOT NULL DEFAULT '0',
constellation varchar(255) NOT NULL DEFAULT '',
zodiac varchar(255) NOT NULL DEFAULT '',
telephone varchar(255) NOT NULL DEFAULT '',
mobile varchar(255) NOT NULL DEFAULT '',
idcardtype varchar(255) NOT NULL DEFAULT '',
idcard varchar(255) NOT NULL DEFAULT '',
address varchar(255) NOT NULL DEFAULT '',
zipcode varchar(255) NOT NULL DEFAULT '',
nationality varchar(255) NOT NULL DEFAULT '',
birthprovince varchar(255) NOT NULL DEFAULT '',
birthcity varchar(255) NOT NULL DEFAULT '',
birthdist varchar(20) NOT NULL DEFAULT '',
birthcommunity varchar(255) NOT NULL DEFAULT '',
resideprovince varchar(255) NOT NULL DEFAULT '',
residecity varchar(255) NOT NULL DEFAULT '',
residedist varchar(20) NOT NULL DEFAULT '',
residecommunity varchar(255) NOT NULL DEFAULT '',
residesuite varchar(255) NOT NULL DEFAULT '',
graduateschool varchar(255) NOT NULL DEFAULT '',
company varchar(255) NOT NULL DEFAULT '',
education varchar(255) NOT NULL DEFAULT '',
occupation varchar(255) NOT NULL DEFAULT '',
position varchar(255) NOT NULL DEFAULT '',
revenue varchar(255) NOT NULL DEFAULT '',
affectivestatus varchar(255) NOT NULL DEFAULT '',
lookingfor varchar(255) NOT NULL DEFAULT '',
bloodtype varchar(255) NOT NULL DEFAULT '',
height varchar(255) NOT NULL DEFAULT '',
weight varchar(255) NOT NULL DEFAULT '',
alipay varchar(255) NOT NULL DEFAULT '',
icq varchar(255) NOT NULL DEFAULT '',
qq varchar(255) NOT NULL DEFAULT '',
yahoo varchar(255) NOT NULL DEFAULT '',
msn varchar(255) NOT NULL DEFAULT '',
taobao varchar(255) NOT NULL DEFAULT '',
site varchar(255) NOT NULL DEFAULT '',
bio text NOT NULL,
interest text NOT NULL,
field1 text NOT NULL,
field2 text NOT NULL,
field3 text NOT NULL,
field4 text NOT NULL,
field5 text NOT NULL,
field6 text NOT NULL,
field7 text NOT NULL,
field8 text NOT NULL,
dateline int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (hid)
) ENGINE=InnoDB;
INSERT INTO pre_common_setting VALUES ('profilehistory','1');
2021-12-19 to 2021-12-21
说明:优化 修改容易被刷分积分策略,清理漫游相关积分策略 的功能修改,数据库升级SQL语句如下:
UPDATE pre_common_credit_rule SET extcredits2 = replace (extcredits2,'1','0') WHERE rid = 8;
UPDATE pre_common_credit_rule SET extcredits2 = replace (extcredits2,'2','0') WHERE rid = 16;
UPDATE pre_common_credit_rule SET extcredits2 = replace (extcredits2,'1','0') WHERE rid = 17;
UPDATE pre_common_setting SET svalue = replace (svalue,'0','1') WHERE skey = 'allowwidthauto';
DELETE FROM `pre_common_credit_rule` WHERE action IN ('installapp', 'useapp');
备注:删除的这条看自己需要,可删可不删,后台默认未开启该两条记录的积分规则。另外,本次升级的一个重大变化是 默认模板宽度从960px改为1200px,只需上传论坛程序文件覆盖升级即可实现。
2021-12-21——2021-12-24 to 2021-12-30
UPDATE `pre_common_setting` SET `svalue` = '0' WHERE `skey` = 'allowwidthauto';
ALTER TABLE `pre_common_admincp_perm` MODIFY COLUMN `perm` VARCHAR(100);
ALTER TABLE `pre_common_admincp_perm` DROP INDEX `cpgroupperm`, ADD UNIQUE KEY `cpgroupperm` (`cpgroupid`, `perm`);
ALTER TABLE `pre_common_cache` MODIFY COLUMN `cachekey` VARCHAR(190);
ALTER TABLE `pre_common_cache` DROP PRIMARY KEY, ADD PRIMARY KEY (`cachekey`);
ALTER TABLE `pre_common_card` MODIFY COLUMN `id` VARCHAR(190);
ALTER TABLE `pre_common_card` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`);
ALTER TABLE `pre_common_member` DROP INDEX `email`, ADD INDEX `email` (`email`(40));
ALTER TABLE `pre_common_member_profile_setting` MODIFY COLUMN `fieldid` VARCHAR(190);
ALTER TABLE `pre_common_member_profile_setting` DROP PRIMARY KEY, ADD PRIMARY KEY (`fieldid`);
ALTER TABLE `pre_common_setting` MODIFY COLUMN `skey` VARCHAR(190);
ALTER TABLE `pre_common_setting` DROP PRIMARY KEY, ADD PRIMARY KEY (`skey`);
ALTER TABLE `pre_forum_groupfield` MODIFY COLUMN `type` VARCHAR(100);
ALTER TABLE `pre_forum_groupfield` DROP INDEX `types`, ADD UNIQUE `types` (`fid`, `type`);
ALTER TABLE `pre_forum_groupfield` DROP INDEX `type`, ADD INDEX `type` (`type`);
ALTER TABLE `pre_mobile_setting` MODIFY COLUMN `skey` VARCHAR(190);
ALTER TABLE `pre_mobile_setting` DROP PRIMARY KEY, ADD PRIMARY KEY (`skey`);
ALTER TABLE `pre_ucenter_members` DROP INDEX `email`, ADD INDEX `email` (`email`(40));
ALTER TABLE `pre_ucenter_badwords` DROP INDEX `find`;
2021-12-30——2021-12-31 to 2022-01-01(Discuz! X3.5 Alpha-20211231)
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` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `lastupdate`;
ALTER TABLE `pre_forum_post` ADD `premsg` text NOT NULL AFTER `updateuid`;
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;
ALTER TABLE `pre_common_smslog` DROP `type`;
ALTER TABLE `pre_common_smslog` ADD `smstype` int(10) NOT NULL DEFAULT '0' AFTER `uid`;
ALTER TABLE `pre_common_smslog` ADD `svctype` int(10) NOT NULL DEFAULT '0' AFTER `smstype`;
ALTER TABLE `pre_common_smslog` ADD `ip` varchar(45) NOT NULL DEFAULT '' AFTER `secmobile`;
ALTER TABLE `pre_common_smslog` ADD `port` smallint(6) unsigned NOT NULL DEFAULT '0' AFTER `ip`;
ALTER TABLE `pre_common_smslog` ADD `dateline` int(10) unsigned NOT NULL DEFAULT '0' AFTER `content`;
ALTER TABLE `pre_common_smslog` ADD INDEX dateline (`secmobicc`, `secmobile`, `dateline`);
ALTER TABLE `pre_common_smslog` ADD INDEX uid (`uid`);
CREATE TABLE pre_common_smslog_archive (
`smslogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`smstype` int(10) NOT NULL DEFAULT '0',
`svctype` int(10) NOT NULL DEFAULT '0',
`smsgw` int(10) NOT NULL DEFAULT '0',
`status` int(10) NOT NULL DEFAULT '0',
`verify` int(10) NOT NULL DEFAULT '0',
`secmobicc` varchar(3) NOT NULL DEFAULT '',
`secmobile` varchar(12) NOT NULL DEFAULT '',
`ip` varchar(45) NOT NULL DEFAULT '',
`port` smallint(6) unsigned NOT NULL DEFAULT '0',
`content` text NOT NULL,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`smslogid`)
) ENGINE=InnoDB;
ALTER TABLE `pre_common_member` ADD INDEX secmobile (`secmobile`, `secmobicc`);
INSERT INTO pre_common_cron VALUES ('21','1','system','每周短信日志归档','cron_smslog_daily.php','1269746639','1269792000','-1','-1','03','0');
INSERT INTO pre_common_setting VALUES ('smsdefaultlength','4');
ALTER TABLE `pre_ucenter_members` ADD INDEX secmobile (`secmobile`, `secmobicc`);
说明:Discuz! X3.5 Alpha 的 config/config_ucenter.php 文件中加了 UC_STANDALONE、UC_AVTURL、UC_AVTPATH 三个常量,参考下面的内容把相关代码补上即可:
define('UC_CONNECT', 'mysql');
define('UC_STANDALONE', 0);
define('UC_DBHOST', '127.0.0.1:3306');
define('UC_DBUSER', 'root');
define('UC_DBPW', '12345678');
define('UC_DBNAME', 'dx35');
define('UC_DBCHARSET', 'utf8mb4');
define('UC_DBTABLEPRE', '`dx35`.pre_ucenter_');
define('UC_DBCONNECT', 0);
define('UC_AVTURL', '');
define('UC_AVTPATH', '');
define('UC_CHARSET', 'utf-8');
define('UC_KEY', 's9BcufK2S5v5P3T9saL593c5b0Ldy2G1p5939ab8vaS8C8R37aNbmd58L667ldj5');
define('UC_API', 'http://www.test.com/uc_server');
define('UC_APPID', '1');
define('UC_IP', '');
define('UC_PPP', 20);
|
|