Discuz!X3.5修复 tinyint的相关修改在x3.5上导致部分数值无法正常存储需要升级的字段

admin · 发表于 2021-12-10 13:17:50

马上注册，免费下载更多dz插件网资源。

您需要登录才可以下载或查看，没有账号？立即注册

×

Discuz!X3.5修复 tinyint的相关修改在x3.5上导致部分数值无法正常存储需要升级的数据库语句：

ALTER TABLE `pre_common_card` CHANGE `status` `status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
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 '0';
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 DEFAULT '0';
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 DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE `tradestick` `tradestick` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE `exempt` `exempt` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `pre_common_usergroup_field` CHANGE `allowrecommend` `allowrecommend` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
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 DEFAULT '0';
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 '0';
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';

复制代码

UC数据库部分：【以下是独立的数据库前缀，如果是论坛一体的，请在前面加pre_，例如：pre_uc_】

ALTER TABLE `uc_failedlogins` CHANGE `count` `count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_protectedmembers` CHANGE `appid` `appid` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_lists` CHANGE `pmtype` `pmtype` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_0` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_1` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_2` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_3` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_4` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_5` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_6` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_7` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_8` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `uc_pm_messages_9` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

复制代码

©DZ插件网所发布的一切资源仅限用于学习和研究目的；不得将上述内容用于商业或者非法用途，否则，一切后果请用户自负。
网站部分内容来源于网络，版权争议与本站无关。您必须在下载后的24个小时之内，从您的电脑中彻底删除上述内容。如果您喜欢该程序，请支持正版软件，得到更好的正版服务。
您在本站任何的赞助购买、下载、查阅、回复等行为等均表示接受并同意签订《DZ插件网免责声明协议》。
如有侵权请邮件与我们联系处理: discuzaddons@vip.qq.com 并出示相关证明以便删除。敬请谅解！

[已处理] Discuz!X3.5修复 tinyint的相关修改在x3.5上导致部分数值无法正常存储需要升级的字段

马上注册，免费下载更多dz插件网资源。

相关帖子

回复

More猜你喜欢

关于我们

服务支持

discuzaddons@vip.qq.com