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

admin

  * 修改了所有的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. 
   
4. ALTER TABLE pre_common_credit_log
   
5.     MODIFY COLUMN logid INT(10) unsigned NOT NULL AUTO_INCREMENT;
   
6. 
   
7. ALTER TABLE pre_common_banned
   
8.     ADD COLUMN ip VARCHAR(49) NOT NULL DEFAULT '' AFTER id,
   
9.     ADD COLUMN upperip VARBINARY(16) NOT NULL DEFAULT 0x0 AFTER ip,
   
10.     ADD COLUMN lowerip VARBINARY(16) NOT NULL DEFAULT 0x0 AFTER ip,
    
11.     ADD INDEX iprange (lowerip, upperip);
    
12. 
    
13. ALTER TABLE pre_common_credit_log
    
14.     MODIFY COLUMN logid INT(8) unsigned NOT NULL AUTO_INCREMENT;
    
15. 
    
16. ALTER TABLE pre_common_failedip
    
17.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';
    
18. 
    
19. ALTER TABLE pre_common_failedlogin
    
20.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';
    
21. 
    
22. ALTER TABLE pre_common_invite
    
23.     MODIFY COLUMN inviteip VARCHAR(45) NOT NULL DEFAULT '';
    
24. 
    
25. ALTER TABLE pre_common_member_action_log
    
26.     MODIFY COLUMN id INT(10) unsigned NOT NULL AUTO_INCREMENT;
    
27. 
    
28. ALTER TABLE pre_common_member_status
    
29.     MODIFY COLUMN regip VARCHAR(45) NOT NULL DEFAULT '',
    
30.     MODIFY COLUMN lastip VARCHAR(45) NOT NULL DEFAULT '',
    
31.     ADD COLUMN regport SMALLINT(6) unsigned NOT NULL DEFAULT '0' AFTER lastip;
    
32. 
    
33. ALTER TABLE pre_common_regip
    
34.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';
    
35. 
    
36. ALTER TABLE pre_common_remote_port
    
37.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';
    
38. 
    
39. ALTER TABLE pre_common_searchindex
    
40.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';
    
41. 
    
42. ALTER TABLE pre_common_session
    
43.     ADD COLUMN ip VARCHAR(45) NOT NULL DEFAULT '' AFTER sid,
    
44.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
45. 
    
46. ALTER TABLE pre_common_task
    
47.     MODIFY COLUMN applicants INT(10) unsigned NOT NULL DEFAULT '0',
    
48.     MODIFY COLUMN achievers INT(10) unsigned NOT NULL DEFAULT '0';
    
49. 
    
50. ALTER TABLE pre_common_usergroup_field
    
51.     MODIFY COLUMN edittimelimit INT(10) unsigned NOT NULL DEFAULT '0';
    
52. 
    
53. ALTER TABLE pre_common_visit
    
54.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';
    
55. 
    
56. ALTER TABLE pre_connect_feedlog
    
57.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
58. 
    
59. ALTER TABLE pre_connect_tthreadlog
    
60.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
61. 
    
62. ALTER TABLE pre_forum_activity
    
63.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
64. 
    
65. ALTER TABLE pre_forum_activityapply
    
66.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
67. 
    
68. ALTER TABLE pre_forum_attachment
    
69.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
70. 
    
71. ALTER TABLE pre_forum_attachment_0
    
72.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
73. 
    
74. ALTER TABLE pre_forum_attachment_1
    
75.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
76. 
    
77. ALTER TABLE pre_forum_attachment_2
    
78.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
79. 
    
80. ALTER TABLE pre_forum_attachment_3
    
81.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
82. 
    
83. ALTER TABLE pre_forum_attachment_4
    
84.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
85. 
    
86. ALTER TABLE pre_forum_attachment_5
    
87.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
88. 
    
89. ALTER TABLE pre_forum_attachment_6
    
90.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
91. 
    
92. ALTER TABLE pre_forum_attachment_7
    
93.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
94. 
    
95. ALTER TABLE pre_forum_attachment_8
    
96.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
97. 
    
98. ALTER TABLE pre_forum_attachment_9
    
99.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
    
100. 
     
101. ALTER TABLE pre_forum_collectioncomment
     
102.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';
     
103. 
     
104. ALTER TABLE pre_forum_collectionteamworker
     
105.     MODIFY COLUMN lastvisit INT(10) unsigned NOT NULL DEFAULT '0';
     
106. 
     
107. ALTER TABLE pre_forum_collectionthread
     
108.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
109. 
     
110. ALTER TABLE pre_forum_debate
     
111.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
112. 
     
113. ALTER TABLE pre_forum_debatepost
     
114.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
115. 
     
116. ALTER TABLE pre_forum_filter_post
     
117.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
118. 
     
119. ALTER TABLE pre_forum_forumfield
     
120.     MODIFY COLUMN livetid INT(10) unsigned NOT NULL DEFAULT '0';
     
121. 
     
122. ALTER TABLE pre_forum_forumrecommend
     
123.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;
     
124. 
     
125. ALTER TABLE pre_forum_groupcreditslog
     
126.     MODIFY COLUMN logdate INT(10) unsigned NOT NULL DEFAULT '0';
     
127. 
     
128. ALTER TABLE pre_forum_hotreply_member
     
129.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
130. 
     
131. ALTER TABLE pre_forum_hotreply_number
     
132.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
133. 
     
134. ALTER TABLE pre_forum_memberrecommend
     
135.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;
     
136. 
     
137. ALTER TABLE pre_forum_newthread
     
138.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
139. 
     
140. ALTER TABLE pre_forum_order
     
141.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '',
     
142.     ADD COLUMN `port` SMALLINT(6) unsigned NOT NULL DEFAULT '0' AFTER ip;
     
143. 
     
144. ALTER TABLE pre_forum_poll
     
145.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
146. 
     
147. ALTER TABLE pre_forum_polloption
     
148.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
149. 
     
150. ALTER TABLE pre_forum_polloption_image
     
151.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
152. 
     
153. ALTER TABLE pre_forum_pollvoter
     
154.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
155. 
     
156. ALTER TABLE pre_forum_post
     
157.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0',
     
158.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '',
     
159.     MODIFY COLUMN position INT(10) unsigned NOT NULL;
     
160. 
     
161. ALTER TABLE pre_forum_post_location
     
162.     MODIFY COLUMN tid INT(10) unsigned DEFAULT '0';
     
163. 
     
164. ALTER TABLE pre_forum_postcache
     
165.     MODIFY COLUMN `comment` MEDIUMTEXT NOT NULL,
     
166.     MODIFY COLUMN rate MEDIUMTEXT NOT NULL;
     
167. 
     
168. ALTER TABLE pre_forum_postcomment
     
169.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0',
     
170.     MODIFY COLUMN useip VARCHAR(45) NOT NULL DEFAULT '';
     
171. 
     
172. ALTER TABLE pre_forum_postlog
     
173.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
174. 
     
175. ALTER TABLE pre_forum_poststick
     
176.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;
     
177. 
     
178. ALTER TABLE pre_forum_promotion
     
179.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '',
     
180.     ADD COLUMN `port` SMALLINT(6) unsigned NOT NULL DEFAULT '0';
     
181. 
     
182. ALTER TABLE pre_forum_relatedthread
     
183.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
184. 
     
185. ALTER TABLE pre_forum_replycredit
     
186.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;
     
187. 
     
188. ALTER TABLE pre_forum_rsscache
     
189.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
190. 
     
191. ALTER TABLE pre_forum_sofa
     
192.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
193. 
     
194. ALTER TABLE pre_forum_thread
     
195.     MODIFY COLUMN tid INT(10) unsigned NOT NULL AUTO_INCREMENT,
     
196.     MODIFY COLUMN maxposition INT(10) unsigned NOT NULL DEFAULT '0';
     
197. 
     
198. ALTER TABLE pre_forum_threadaddviews
     
199.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
200. 
     
201. ALTER TABLE pre_forum_threadclosed
     
202.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
203. 
     
204. ALTER TABLE pre_forum_threaddisablepos
     
205.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
206. 
     
207. ALTER TABLE pre_forum_threadhidelog
     
208.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
209. 
     
210. ALTER TABLE pre_forum_threadhot
     
211.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
212. 
     
213. ALTER TABLE pre_forum_threadimage
     
214.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
215. 
     
216. ALTER TABLE pre_forum_threadlog
     
217.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
218. 
     
219. ALTER TABLE pre_forum_threadmod
     
220.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
221. 
     
222. ALTER TABLE pre_forum_threadpartake
     
223.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
224. 
     
225. ALTER TABLE pre_forum_threadpreview
     
226.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
227. 
     
228. ALTER TABLE pre_forum_threadrush
     
229.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
230. 
     
231. ALTER TABLE pre_forum_trade
     
232.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;
     
233. 
     
234. ALTER TABLE pre_forum_tradelog
     
235.     MODIFY COLUMN tid INT(10) unsigned NOT NULL;
     
236. 
     
237. ALTER TABLE pre_forum_typeoptionvar
     
238.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
239. 
     
240. ALTER TABLE pre_home_comment
     
241.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';
     
242. 
     
243. ALTER TABLE pre_home_docomment
     
244.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '',
     
245.     ADD COLUMN `port` SMALLINT(6) unsigned NOT NULL DEFAULT '0';
     
246. 
     
247. ALTER TABLE pre_home_doing
     
248.     MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '';
     
249. 
     
250. ALTER TABLE pre_home_follow_feed
     
251.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
252. 
     
253. ALTER TABLE pre_home_follow_feed_archiver
     
254.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     
255. 
     
256. ALTER TABLE pre_home_notification
     
257.     MODIFY COLUMN id BIGINT(20) unsigned NOT NULL AUTO_INCREMENT;
     
258. 
     
259. ALTER TABLE pre_security_evilpost
     
260.     MODIFY COLUMN tid INT(10) unsigned NOT NULL DEFAULT '0';
     

复制代码