Discuz!X3.5修复 tinyint的相关修改在x3.5上导致部分数值无法正常存储需要升级的字段
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';
页:
[1]
