去评论
dz插件网

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

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

  1. ALTER TABLE `pre_common_card` CHANGE `status` `status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  3. ALTER TABLE `pre_common_district` CHANGE `usetype` `usetype` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  5. ALTER TABLE `pre_common_failedip` CHANGE `count` `count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  7. ALTER TABLE `pre_common_failedlogin` CHANGE `count` `count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  9. ALTER TABLE `pre_common_magiclog` CHANGE `credit` `credit` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  11. ALTER TABLE `pre_common_member_field_forum` CHANGE `customshow` `customshow` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  13. ALTER TABLE `pre_common_plugin` CHANGE `adminid` `adminid` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  15. ALTER TABLE `pre_common_secquestion` CHANGE `type` `type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  17. ALTER TABLE `pre_common_session` CHANGE `action` `action` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  19. ALTER TABLE `pre_common_usergroup_field` CHANGE `allowmagics` `allowmagics` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  20. ALTER TABLE `pre_common_usergroup_field` CHANGE `tradestick` `tradestick` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  21. ALTER TABLE `pre_common_usergroup_field` CHANGE `exempt` `exempt` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  22. ALTER TABLE `pre_common_usergroup_field` CHANGE `allowrecommend` `allowrecommend` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  23. ALTER TABLE `pre_common_usergroup_field` CHANGE `allowbuildgroup` `allowbuildgroup` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  24. ALTER TABLE `pre_common_usergroup_field` CHANGE `allowgroupdirectpost` `allowgroupdirectpost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  25. ALTER TABLE `pre_common_usergroup_field` CHANGE `allowgroupposturl` `allowgroupposturl` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  26. ALTER TABLE `pre_common_usergroup_field` CHANGE `allowfollowcollection` `allowfollowcollection` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  27. ALTER TABLE `pre_common_usergroup_field` CHANGE `forcelogin` `forcelogin` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  29. ALTER TABLE `pre_common_payment_transfer` CHANGE `status` `status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  31. ALTER TABLE `pre_forum_attachment` CHANGE `tableid` `tableid` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  33. ALTER TABLE `pre_forum_bbcode` CHANGE `params` `params` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  35. ALTER TABLE `pre_forum_medal` CHANGE `credit` `credit` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  37. ALTER TABLE `pre_forum_ratelog` CHANGE `extcredits` `extcredits` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  39. ALTER TABLE `pre_forum_trade` CHANGE `quality` `quality` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  41. ALTER TABLE `pre_forum_tradelog` CHANGE `paytype` `paytype` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  43. ALTER TABLE `pre_forum_tradelog` CHANGE `quality` `quality` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  45. ALTER TABLE `pre_home_doing` CHANGE `status` `status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  47. ALTER TABLE `pre_home_pic` CHANGE `status` `status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';


UC数据库部分：【以下是独立的数据库前缀，如果是论坛一体的，请在前面加pre_，例如：pre_uc_】
  1. ALTER TABLE `uc_failedlogins` CHANGE `count` `count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  3. ALTER TABLE `uc_protectedmembers` CHANGE `appid` `appid` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  5. ALTER TABLE `uc_pm_lists` CHANGE `pmtype` `pmtype` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

  7. ALTER TABLE `uc_pm_messages_0` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  8. ALTER TABLE `uc_pm_messages_1` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  9. ALTER TABLE `uc_pm_messages_2` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  10. ALTER TABLE `uc_pm_messages_3` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  11. ALTER TABLE `uc_pm_messages_4` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  12. ALTER TABLE `uc_pm_messages_5` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  13. ALTER TABLE `uc_pm_messages_6` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  14. ALTER TABLE `uc_pm_messages_7` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  15. ALTER TABLE `uc_pm_messages_8` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
  16. ALTER TABLE `uc_pm_messages_9` CHANGE `delstatus` `delstatus` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';



进入原文参与互动