去评论
dz插件网

DZ X3.5优化 回帖奖励以及附件表字段扩容

admin
2020/12/31 11:47:06
优化 回帖奖励以及附件表字段扩容

* 优化 附件表字段长度延长* 优化 回帖奖励字段延长
  1. ALTER TABLE `pre_forum_activity` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL DEFAULT '0';
  2. ALTER TABLE `pre_forum_attachment` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  3. ALTER TABLE `pre_forum_attachment_0` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  4. ALTER TABLE `pre_forum_attachment_1` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  5. ALTER TABLE `pre_forum_attachment_2` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  6. ALTER TABLE `pre_forum_attachment_3` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  7. ALTER TABLE `pre_forum_attachment_4` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  8. ALTER TABLE `pre_forum_attachment_5` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  9. ALTER TABLE `pre_forum_attachment_6` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  10. ALTER TABLE `pre_forum_attachment_7` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  11. ALTER TABLE `pre_forum_attachment_8` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  12. ALTER TABLE `pre_forum_attachment_9` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  13. ALTER TABLE `pre_forum_attachment_exif` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL;
  14. ALTER TABLE `pre_forum_attachment_unused` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL;
  15. ALTER TABLE `pre_forum_forumrecommend` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL DEFAULT '0';
  16. ALTER TABLE `pre_forum_replycredit` CHANGE `extcredits` `extcredits` INT(10) UNSIGNED NOT NULL DEFAULT '0';
  17. ALTER TABLE `pre_forum_replycredit` CHANGE `times` `times` INT(10) UNSIGNED NOT NULL DEFAULT '0';
  18. ALTER TABLE `pre_forum_replycredit` CHANGE `membertimes` `membertimes` INT(10) UNSIGNED NOT NULL DEFAULT '0';
  19. ALTER TABLE `pre_forum_thread` CHANGE `replycredit` `replycredit` INT(10) NOT NULL DEFAULT '0';
  20. ALTER TABLE `pre_forum_trade` CHANGE `aid` `aid` INT(10) UNSIGNED NOT NULL;