查看: 79|回复: 0
收起左侧

将discuz在所有记录IP地址的地方,增加端口号的记录

[复制链接]
发表于 2020-3-15 18:41:50 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让您轻松玩转资讯

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
  * 修改了所有的IP地址,改为varchar(45)类型;
  * 在所有记录IP地址的地方,增加了端口号的记录;
  * 在pre_common_banned表中,增加了upperip和lowerip两个VARBINARY(16)类型的字段,用于记录IP地址的封禁范围最大值和最小
  * 将部分字段改”大“,比如INT改为BIGINT, TEXT改为MEDIUMTEXT等
  1. ALTER TABLE pre_common_admincp_session
  2.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';

  3. ALTER TABLE pre_common_credit_log
  4.     MODIFY COLUMN logid INT(10) unsigned NOT NULL AUTO_INCREMENT;

  5. ALTER TABLE pre_common_banned
  6.     ADD COLUMN ip VARCHAR(49) NOT NULL DEFAULT '' AFTER id,
  7.     ADD COLUMN upperip VARBINARY(16) NOT NULL DEFAULT 0x0 AFTER ip,
  8.     ADD COLUMN lowerip VARBINARY(16) NOT NULL DEFAULT 0x0 AFTER ip,
  9.     ADD INDEX iprange (lowerip, upperip);

  10. ALTER TABLE pre_common_credit_log
  11.     MODIFY COLUMN logid INT(8) unsigned NOT NULL AUTO_INCREMENT;

  12. ALTER TABLE pre_common_failedip
  13.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';

  14. ALTER TABLE pre_common_failedlogin
  15.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';

  16. ALTER TABLE pre_common_invite
  17.     MODIFY COLUMN inviteip VARCHAR(45) NOT NULL DEFAULT '';

  18. ALTER TABLE pre_common_member_action_log
  19.     MODIFY COLUMN id INT(10) unsigned NOT NULL AUTO_INCREMENT;

  20. ALTER TABLE pre_common_member_status
  21.     MODIFY COLUMN regip VARCHAR(45) NOT NULL DEFAULT '',
  22.     MODIFY COLUMN lastip VARCHAR(45) NOT NULL DEFAULT '',
  23.     ADD COLUMN regport SMALLINT(6) unsigned NOT NULL DEFAULT '0' AFTER lastip;

  24. ALTER TABLE pre_common_regip
  25.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';

  26. ALTER TABLE pre_common_remote_port
  27.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';

  28. ALTER TABLE pre_common_searchindex
  29.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';

  30. ALTER TABLE pre_common_session
  31.     ADD COLUMN ip VARCHAR(45) NOT NULL DEFAULT '' AFTER sid,
  32.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  33. ALTER TABLE pre_common_task
  34.     MODIFY COLUMN applicants INT(10) unsigned NOT NULL DEFAULT '0',
  35.     MODIFY COLUMN achievers INT(10) unsigned NOT NULL DEFAULT '0';

  36. ALTER TABLE pre_common_usergroup_field
  37.     MODIFY COLUMN edittimelimit INT(10) unsigned NOT NULL DEFAULT '0';

  38. ALTER TABLE pre_common_visit
  39.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';

  40. ALTER TABLE pre_connect_feedlog
  41.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  42. ALTER TABLE pre_connect_tthreadlog
  43.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  44. ALTER TABLE pre_forum_activity
  45.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  46. ALTER TABLE pre_forum_activityapply
  47.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  48. ALTER TABLE pre_forum_attachment
  49.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  50. ALTER TABLE pre_forum_attachment_0
  51.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  52. ALTER TABLE pre_forum_attachment_1
  53.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  54. ALTER TABLE pre_forum_attachment_2
  55.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  56. ALTER TABLE pre_forum_attachment_3
  57.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  58. ALTER TABLE pre_forum_attachment_4
  59.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  60. ALTER TABLE pre_forum_attachment_5
  61.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  62. ALTER TABLE pre_forum_attachment_6
  63.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  64. ALTER TABLE pre_forum_attachment_7
  65.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  66. ALTER TABLE pre_forum_attachment_8
  67.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  68. ALTER TABLE pre_forum_attachment_9
  69.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  70. ALTER TABLE pre_forum_collectioncomment
  71.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';

  72. ALTER TABLE pre_forum_collectionteamworker
  73.     MODIFY COLUMN lastvisit INT(10) unsigned NOT NULL DEFAULT '0';

  74. ALTER TABLE pre_forum_collectionthread
  75.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  76. ALTER TABLE pre_forum_debate
  77.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  78. ALTER TABLE pre_forum_debatepost
  79.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  80. ALTER TABLE pre_forum_filter_post
  81.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  82. ALTER TABLE pre_forum_forumfield
  83.     MODIFY COLUMN livetid INT(10) unsigned NOT NULL DEFAULT '0';

  84. ALTER TABLE pre_forum_forumrecommend
  85.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;

  86. ALTER TABLE pre_forum_groupcreditslog
  87.     MODIFY COLUMN logdate INT(10) unsigned NOT NULL DEFAULT '0';

  88. ALTER TABLE pre_forum_hotreply_member
  89.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  90. ALTER TABLE pre_forum_hotreply_number
  91.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  92. ALTER TABLE pre_forum_memberrecommend
  93.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;

  94. ALTER TABLE pre_forum_newthread
  95.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  96. ALTER TABLE pre_forum_order
  97.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '',
  98.     ADD COLUMN `port` SMALLINT(6) unsigned NOT NULL DEFAULT '0' AFTER ip;

  99. ALTER TABLE pre_forum_poll
  100.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  101. ALTER TABLE pre_forum_polloption
  102.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  103. ALTER TABLE pre_forum_polloption_image
  104.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  105. ALTER TABLE pre_forum_pollvoter
  106.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  107. ALTER TABLE pre_forum_post
  108.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0',
  109.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '',
  110.     MODIFY COLUMN position INT(10) unsigned NOT NULL;

  111. ALTER TABLE pre_forum_post_location
  112.     MODIFY COLUMN tid INT(10) unsigned DEFAULT '0';

  113. ALTER TABLE pre_forum_postcache
  114.     MODIFY COLUMN `comment` MEDIUMTEXT NOT NULL,
  115.     MODIFY COLUMN rate MEDIUMTEXT NOT NULL;

  116. ALTER TABLE pre_forum_postcomment
  117.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0',
  118.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';

  119. ALTER TABLE pre_forum_postlog
  120.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  121. ALTER TABLE pre_forum_poststick
  122.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;

  123. ALTER TABLE pre_forum_promotion
  124.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '',
  125.     ADD COLUMN `port` SMALLINT(6) unsigned NOT NULL DEFAULT '0';

  126. ALTER TABLE pre_forum_relatedthread
  127.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  128. ALTER TABLE pre_forum_replycredit
  129.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;

  130. ALTER TABLE pre_forum_rsscache
  131.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  132. ALTER TABLE pre_forum_sofa
  133.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  134. ALTER TABLE pre_forum_thread
  135.     MODIFY COLUMN tid INT(10) unsigned NOT NULL AUTO_INCREMENT,
  136.     MODIFY COLUMN maxposition INT(10) unsigned NOT NULL DEFAULT '0';

  137. ALTER TABLE pre_forum_threadaddviews
  138.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  139. ALTER TABLE pre_forum_threadclosed
  140.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  141. ALTER TABLE pre_forum_threaddisablepos
  142.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  143. ALTER TABLE pre_forum_threadhidelog
  144.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  145. ALTER TABLE pre_forum_threadhot
  146.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  147. ALTER TABLE pre_forum_threadimage
  148.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  149. ALTER TABLE pre_forum_threadlog
  150.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  151. ALTER TABLE pre_forum_threadmod
  152.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  153. ALTER TABLE pre_forum_threadpartake
  154.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  155. ALTER TABLE pre_forum_threadpreview
  156.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  157. ALTER TABLE pre_forum_threadrush
  158.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  159. ALTER TABLE pre_forum_trade
  160.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;

  161. ALTER TABLE pre_forum_tradelog
  162.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;

  163. ALTER TABLE pre_forum_typeoptionvar
  164.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  165. ALTER TABLE pre_home_comment
  166.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';

  167. ALTER TABLE pre_home_docomment
  168.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '',
  169.     ADD COLUMN `port` SMALLINT(6) unsigned NOT NULL DEFAULT '0';

  170. ALTER TABLE pre_home_doing
  171.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';

  172. ALTER TABLE pre_home_follow_feed
  173.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  174. ALTER TABLE pre_home_follow_feed_archiver
  175.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';

  176. ALTER TABLE pre_home_notification
  177.     MODIFY COLUMN id BIGINT(20) unsigned NOT NULL AUTO_INCREMENT;

  178. ALTER TABLE pre_security_evilpost
  179.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
复制代码



增加端口号的记录.zip

1.13 KB, 下载次数:

感谢大家一直以来对飞吧资源网的支持!https://www.fb93.com
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ:2076338| 小黑屋|无图浏览|手机版|飞吧地图| 飞吧资源网

本帖部分内容转载自其它媒体,但并不代表本站赞同其观点和对其真实性负责
如本帖侵犯到任何版权问题,请立即告知本站,本站将及时予与删除并致以最深的歉意

Copyright © 2011-2020 飞吧资源网 Fb93 (https://www.fb93.com) All Rights Reserved.

网站备案信息:( 粤ICP备13002650号-1 )

快速回复 返回顶部 返回列表