/[LeafOK_CVS]/fenglin/TODO/sql/db_stru.sql
ViewVC logotype

Annotation of /fenglin/TODO/sql/db_stru.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.19 - (hide annotations)
Sat Jun 7 12:06:12 2025 UTC (9 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.18: +1 -0 lines
Content type: application/sql 
Add index to support article_view_log feature in Telnet version
1 sysadm 1.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2     SET time_zone = "+00:00";
3    
4 sysadm 1.3 CREATE TABLE `admin_config` (
5 sysadm 1.4 `AID` smallint NOT NULL,
6     `UID` mediumint NOT NULL DEFAULT '0',
7     `begin_dt` datetime DEFAULT NULL,
8     `end_dt` datetime DEFAULT NULL,
9     `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
10     `major` tinyint UNSIGNED NOT NULL DEFAULT '0'
11 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
12 sysadm 1.4
13 sysadm 1.3 CREATE TABLE `ban_user_list` (
14 sysadm 1.4 `BID` smallint NOT NULL,
15     `SID` smallint NOT NULL DEFAULT '0',
16     `UID` mediumint NOT NULL DEFAULT '0',
17     `day` smallint NOT NULL DEFAULT '0',
18     `ban_UID` mediumint NOT NULL DEFAULT '0',
19     `ban_dt` datetime DEFAULT NULL,
20     `ban_ip` varchar(20) DEFAULT NULL,
21     `unban_UID` mediumint NOT NULL DEFAULT '0',
22     `unban_dt` datetime DEFAULT NULL,
23     `unban_ip` varchar(20) DEFAULT NULL,
24     `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
25     `reason` mediumtext
26 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
27 sysadm 1.4
28 sysadm 1.3 CREATE TABLE `bbs` (
29 sysadm 1.4 `AID` int NOT NULL,
30     `SID` smallint NOT NULL DEFAULT '0',
31     `TID` mediumint NOT NULL DEFAULT '0',
32     `UID` mediumint NOT NULL DEFAULT '0',
33     `username` varchar(20) DEFAULT NULL,
34     `nickname` varchar(20) DEFAULT NULL,
35     `title` varchar(80) DEFAULT NULL,
36     `CID` mediumint NOT NULL DEFAULT '0',
37     `sub_dt` datetime DEFAULT NULL,
38     `sub_ip` varchar(20) DEFAULT NULL,
39     `reply_note` tinyint UNSIGNED NOT NULL DEFAULT '0',
40     `visible` tinyint UNSIGNED NOT NULL DEFAULT '1',
41     `view_count` smallint NOT NULL DEFAULT '0',
42     `exp` mediumint NOT NULL DEFAULT '0',
43     `last_reply_dt` datetime DEFAULT NULL,
44     `last_reply_UID` mediumint NOT NULL DEFAULT '0',
45     `last_reply_username` varchar(20) DEFAULT NULL,
46     `last_reply_nickname` varchar(20) DEFAULT NULL,
47     `transship` tinyint UNSIGNED NOT NULL DEFAULT '0',
48     `lock` tinyint UNSIGNED NOT NULL DEFAULT '0',
49     `reply_count` smallint NOT NULL DEFAULT '0',
50     `icon` smallint DEFAULT NULL,
51     `length` mediumint NOT NULL DEFAULT '0',
52     `excerption` tinyint UNSIGNED NOT NULL DEFAULT '0',
53     `ontop` tinyint UNSIGNED NOT NULL DEFAULT '0',
54     `static` tinyint UNSIGNED NOT NULL DEFAULT '0',
55     `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
56     `m_del` tinyint UNSIGNED NOT NULL DEFAULT '0',
57 sysadm 1.8 `old_SID` smallint NOT NULL DEFAULT '0'
58 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
59 sysadm 1.4
60 sysadm 1.3 CREATE TABLE `bbs_article_op` (
61 sysadm 1.4 `MID` int NOT NULL,
62     `AID` int NOT NULL DEFAULT '0',
63     `UID` mediumint NOT NULL DEFAULT '0',
64     `type` char(1) NOT NULL DEFAULT '',
65     `op_dt` datetime DEFAULT NULL,
66     `op_ip` varchar(20) DEFAULT NULL,
67     `complete` tinyint UNSIGNED NOT NULL DEFAULT '1'
68 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
69 sysadm 1.4
70 sysadm 1.3 CREATE TABLE `bbs_content` (
71 sysadm 1.4 `CID` int NOT NULL,
72     `AID` int NOT NULL DEFAULT '0',
73     `content` longtext
74 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
75 sysadm 1.4
76 sysadm 1.3 CREATE TABLE `bbs_msg` (
77 sysadm 1.4 `MID` int NOT NULL,
78     `fromUID` mediumint NOT NULL DEFAULT '0',
79     `toUID` mediumint NOT NULL DEFAULT '0',
80     `content` longtext,
81     `send_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
82     `send_ip` varchar(20) NOT NULL DEFAULT '',
83     `new` tinyint UNSIGNED NOT NULL DEFAULT '1',
84     `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0',
85     `s_deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
86 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
87 sysadm 1.4
88 sysadm 1.3 CREATE TABLE `email` (
89 sysadm 1.4 `ID` int NOT NULL,
90     `fromemail` varchar(30) DEFAULT NULL,
91     `fromname` varchar(30) DEFAULT NULL,
92     `toemail` varchar(30) DEFAULT NULL,
93     `toname` varchar(30) DEFAULT NULL,
94     `subject` varchar(80) DEFAULT NULL,
95     `body` longtext,
96     `set_dt` datetime DEFAULT NULL,
97     `send_dt` datetime DEFAULT NULL,
98     `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
99     `error` tinyint UNSIGNED NOT NULL DEFAULT '0',
100     `error_msg` varchar(255) DEFAULT NULL
101 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
102 sysadm 1.4
103 sysadm 1.3 CREATE TABLE `ex_dir` (
104 sysadm 1.4 `FID` mediumint NOT NULL,
105     `dir` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
106     `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
107     `SID` smallint NOT NULL DEFAULT '0',
108     `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
109     `dt` datetime DEFAULT NULL
110 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
111 sysadm 1.4
112 sysadm 1.3 CREATE TABLE `ex_file` (
113 sysadm 1.4 `AID` int NOT NULL DEFAULT '0',
114     `FID` smallint NOT NULL DEFAULT '0'
115 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
116 sysadm 1.4
117 sysadm 1.3 CREATE TABLE `friend_list` (
118 sysadm 1.4 `ID` mediumint NOT NULL,
119     `UID` mediumint NOT NULL DEFAULT '0',
120     `fUID` mediumint NOT NULL DEFAULT '0'
121 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
122 sysadm 1.4
123 sysadm 1.3 CREATE TABLE `section_class` (
124 sysadm 1.4 `CID` smallint NOT NULL,
125     `cname` varchar(20) DEFAULT NULL,
126     `title` varchar(20) DEFAULT NULL,
127     `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
128     `sort_order` smallint NOT NULL DEFAULT '10'
129 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
130 sysadm 1.4
131 sysadm 1.3 CREATE TABLE `section_config` (
132 sysadm 1.4 `SID` smallint NOT NULL,
133     `sname` varchar(20) DEFAULT NULL,
134     `CID` smallint NOT NULL DEFAULT '0',
135     `title` varchar(20) DEFAULT NULL,
136     `comment` varchar(255) DEFAULT NULL,
137 sysadm 1.8 `topic_retention` smallint NOT NULL DEFAULT '0',
138 sysadm 1.4 `announcement` longtext,
139     `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
140     `exp_get` tinyint UNSIGNED NOT NULL DEFAULT '0',
141     `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
142     `set_UID` mediumint DEFAULT '0',
143     `set_dt` datetime DEFAULT NULL,
144     `set_ip` varchar(20) DEFAULT NULL,
145     `sort_order` smallint NOT NULL DEFAULT '10',
146     `ex_gen_tm` datetime DEFAULT NULL,
147     `ex_update` tinyint UNSIGNED NOT NULL DEFAULT '0',
148     `read_user_level` smallint NOT NULL DEFAULT '0',
149     `write_user_level` smallint NOT NULL DEFAULT '0'
150 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
151 sysadm 1.4
152 sysadm 1.3 CREATE TABLE `section_favorite` (
153 sysadm 1.4 `ID` int NOT NULL,
154     `UID` mediumint NOT NULL DEFAULT '0',
155     `SID` smallint NOT NULL DEFAULT '0'
156 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
157 sysadm 1.4
158 sysadm 1.3 CREATE TABLE `section_master` (
159 sysadm 1.4 `MID` smallint NOT NULL,
160     `SID` smallint NOT NULL DEFAULT '0',
161     `UID` mediumint NOT NULL DEFAULT '0',
162     `begin_dt` datetime DEFAULT NULL,
163     `end_dt` datetime DEFAULT NULL,
164     `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
165     `major` tinyint UNSIGNED NOT NULL DEFAULT '0',
166     `memo` text
167 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
168 sysadm 1.4
169 sysadm 1.3 CREATE TABLE `send_pass_log` (
170 sysadm 1.4 `ID` mediumint NOT NULL,
171     `UID` mediumint NOT NULL DEFAULT '0',
172     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
173     `ip` varchar(20) NOT NULL DEFAULT ''
174 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
175 sysadm 1.4
176 sysadm 1.3 CREATE TABLE `upload_file` (
177 sysadm 1.4 `AID` mediumint NOT NULL,
178     `ref_AID` mediumint NOT NULL DEFAULT '0',
179     `UID` mediumint NOT NULL DEFAULT '0',
180     `size` mediumint NOT NULL DEFAULT '0',
181     `filename` varchar(255) NOT NULL DEFAULT '',
182     `check` tinyint UNSIGNED NOT NULL DEFAULT '0',
183     `deny` tinyint UNSIGNED NOT NULL DEFAULT '0',
184     `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
185 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
186 sysadm 1.4
187 sysadm 1.3 CREATE TABLE `user_err_login_log` (
188 sysadm 1.4 `ID` int NOT NULL,
189     `username` varchar(14) DEFAULT NULL,
190     `password` varchar(12) DEFAULT NULL,
191     `login_dt` datetime DEFAULT NULL,
192     `login_ip` varchar(20) DEFAULT NULL
193 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
194 sysadm 1.4
195 sysadm 1.3 CREATE TABLE `user_life_log` (
196 sysadm 1.4 `ID` mediumint NOT NULL,
197     `UID` mediumint NOT NULL DEFAULT '0',
198     `set_UID` mediumint NOT NULL DEFAULT '0',
199     `life` smallint NOT NULL DEFAULT '0',
200     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
201     `ip` varchar(20) NOT NULL DEFAULT ''
202 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
203 sysadm 1.4
204 sysadm 1.3 CREATE TABLE `user_list` (
205 sysadm 1.4 `UID` mediumint NOT NULL,
206     `username` varchar(20) NOT NULL DEFAULT '',
207     `password` varchar(64) NOT NULL DEFAULT '',
208 sysadm 1.10 `temp_password` varchar(20) NOT NULL DEFAULT '',
209 sysadm 1.4 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
210     `verified` tinyint UNSIGNED NOT NULL DEFAULT '0',
211     `p_login` tinyint UNSIGNED NOT NULL DEFAULT '1',
212     `p_post` tinyint UNSIGNED NOT NULL DEFAULT '1',
213     `p_msg` tinyint UNSIGNED NOT NULL DEFAULT '1'
214 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
215 sysadm 1.4
216 sysadm 1.3 CREATE TABLE `user_login_log` (
217 sysadm 1.4 `ID` int NOT NULL,
218     `UID` mediumint NOT NULL DEFAULT '0',
219     `login_dt` datetime DEFAULT NULL,
220     `login_ip` varchar(20) DEFAULT NULL
221 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
222 sysadm 1.4
223 sysadm 1.3 CREATE TABLE `user_modify_email_verify` (
224 sysadm 1.4 `MID` mediumint NOT NULL,
225     `UID` mediumint NOT NULL DEFAULT '0',
226     `email` varchar(30) DEFAULT NULL,
227     `verify_code` varchar(10) NOT NULL DEFAULT '',
228     `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
229     `dt` datetime DEFAULT NULL,
230     `ip` varchar(20) DEFAULT NULL
231 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
232 sysadm 1.4
233 sysadm 1.3 CREATE TABLE `user_modify_log` (
234 sysadm 1.4 `MID` mediumint NOT NULL,
235     `UID` mediumint NOT NULL DEFAULT '0',
236     `modify_dt` datetime DEFAULT NULL,
237     `modify_ip` varchar(20) DEFAULT NULL,
238     `complete` tinyint UNSIGNED NOT NULL DEFAULT '0'
239 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
240 sysadm 1.4
241 sysadm 1.3 CREATE TABLE `user_nickname` (
242 sysadm 1.4 `NID` mediumint NOT NULL,
243     `UID` mediumint NOT NULL DEFAULT '0',
244     `nickname` varchar(20) NOT NULL DEFAULT '',
245     `begin_dt` datetime DEFAULT NULL,
246     `begin_reason` char(1) DEFAULT NULL,
247     `end_dt` datetime DEFAULT NULL,
248     `end_reason` char(1) DEFAULT NULL
249 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
250 sysadm 1.4
251 sysadm 1.3 CREATE TABLE `user_online` (
252 sysadm 1.4 `SID` varchar(32) NOT NULL DEFAULT '',
253     `UID` mediumint NOT NULL DEFAULT '0',
254     `ip` varchar(20) NOT NULL DEFAULT '',
255     `current_action` varchar(20) NOT NULL DEFAULT '',
256     `login_tm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
257     `last_tm` datetime DEFAULT NULL
258 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
259 sysadm 1.4
260 sysadm 1.3 CREATE TABLE `user_pubinfo` (
261 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
262     `nickname` varchar(20) DEFAULT NULL,
263     `email` varchar(30) DEFAULT NULL,
264     `gender` char(1) NOT NULL DEFAULT 'M',
265     `qq` varchar(10) DEFAULT NULL,
266     `introduction` mediumtext,
267     `photo` smallint DEFAULT '0',
268     `photo_enable` tinyint(1) NOT NULL DEFAULT '0',
269     `photo_ext` varchar(5) NOT NULL DEFAULT '',
270     `life` smallint NOT NULL DEFAULT '15',
271     `exp` mediumint DEFAULT '0',
272     `visit_count` mediumint NOT NULL DEFAULT '0',
273     `gender_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
274     `last_login_dt` datetime DEFAULT NULL,
275     `sign_1` mediumtext,
276     `sign_2` mediumtext,
277     `sign_3` mediumtext,
278     `upload_limit` int NOT NULL DEFAULT '1048576',
279 sysadm 1.18 `login_notify_dt` datetime DEFAULT NULL,
280     `user_timezone` varchar(50) NOT NULL DEFAULT '',
281     `game_money` int NOT NULL DEFAULT '0'
282 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
283 sysadm 1.4
284 sysadm 1.3 CREATE TABLE `user_reginfo` (
285 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
286     `name` varchar(10) DEFAULT NULL,
287     `birthday` datetime DEFAULT NULL,
288     `signup_dt` datetime DEFAULT NULL,
289     `signup_ip` varchar(20) DEFAULT NULL,
290     `memo` mediumtext
291 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
292 sysadm 1.3
293     CREATE TABLE `user_score` (
294 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
295     `score` mediumint NOT NULL DEFAULT '0',
296     `last_exp` mediumint NOT NULL DEFAULT '0',
297     `exp_left` mediumint NOT NULL DEFAULT '0'
298 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
299 sysadm 1.4
300 sysadm 1.3 CREATE TABLE `user_score_log` (
301 sysadm 1.4 `ID` mediumint NOT NULL,
302     `UID` mediumint NOT NULL DEFAULT '0',
303     `score_change` mediumint NOT NULL DEFAULT '0',
304     `reason` varchar(50) DEFAULT NULL,
305     `dt` datetime DEFAULT NULL
306 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
307 sysadm 1.4
308 sysadm 1.3 CREATE TABLE `view_article_log` (
309 sysadm 1.4 `AID` int NOT NULL DEFAULT '0',
310     `UID` mediumint NOT NULL DEFAULT '0',
311     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
312 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
313 sysadm 1.4
314 sysadm 1.3 CREATE TABLE `visit_log` (
315 sysadm 1.4 `VID` int NOT NULL,
316     `dt` datetime DEFAULT NULL,
317     `ip` varchar(20) DEFAULT NULL
318 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
319 sysadm 1.4
320 sysadm 1.8
321 sysadm 1.4 ALTER TABLE `admin_config`
322     ADD PRIMARY KEY (`AID`),
323     ADD KEY `UID` (`UID`);
324    
325     ALTER TABLE `ban_user_list`
326     ADD PRIMARY KEY (`BID`),
327     ADD KEY `ban_UID` (`ban_UID`),
328     ADD KEY `SID` (`SID`),
329     ADD KEY `day` (`day`),
330     ADD KEY `UID` (`UID`);
331    
332     ALTER TABLE `bbs`
333     ADD PRIMARY KEY (`AID`),
334     ADD UNIQUE KEY `CID` (`CID`),
335     ADD KEY `UID` (`UID`),
336     ADD KEY `reply_count` (`reply_count`),
337     ADD KEY `last_reply_dt` (`last_reply_dt`),
338     ADD KEY `view_count` (`view_count`),
339     ADD KEY `sub_dt` (`sub_dt`),
340     ADD KEY `title` (`title`(10)),
341     ADD KEY `old_SID` (`old_SID`),
342     ADD KEY `SID` (`SID`),
343     ADD KEY `TID` (`TID`),
344     ADD KEY `last_reply_UID` (`last_reply_UID`);
345    
346     ALTER TABLE `bbs_article_op`
347     ADD PRIMARY KEY (`MID`),
348     ADD KEY `AID` (`AID`),
349     ADD KEY `UID` (`UID`),
350     ADD KEY `type` (`type`);
351    
352     ALTER TABLE `bbs_content`
353     ADD PRIMARY KEY (`CID`),
354     ADD KEY `AID` (`AID`);
355    
356     ALTER TABLE `bbs_msg`
357     ADD PRIMARY KEY (`MID`),
358     ADD KEY `fromUID` (`fromUID`),
359     ADD KEY `toUID` (`toUID`);
360    
361     ALTER TABLE `email`
362     ADD PRIMARY KEY (`ID`),
363     ADD KEY `complete` (`complete`);
364    
365     ALTER TABLE `ex_dir`
366     ADD PRIMARY KEY (`FID`),
367     ADD KEY `SID` (`SID`),
368     ADD KEY `dir` (`dir`(50));
369    
370     ALTER TABLE `ex_file`
371     ADD PRIMARY KEY (`AID`),
372     ADD KEY `FID` (`FID`);
373    
374     ALTER TABLE `friend_list`
375     ADD PRIMARY KEY (`ID`),
376     ADD KEY `fUID` (`fUID`),
377     ADD KEY `UID` (`UID`);
378    
379     ALTER TABLE `section_class`
380     ADD PRIMARY KEY (`CID`),
381     ADD KEY `sort_order` (`sort_order`);
382    
383     ALTER TABLE `section_config`
384     ADD PRIMARY KEY (`SID`),
385     ADD KEY `CID` (`CID`),
386     ADD KEY `write_user_level` (`write_user_level`),
387     ADD KEY `sort_order` (`sort_order`),
388     ADD KEY `read_user_level` (`read_user_level`),
389     ADD KEY `sname` (`sname`);
390    
391     ALTER TABLE `section_favorite`
392     ADD PRIMARY KEY (`ID`),
393     ADD KEY `UID` (`UID`);
394    
395     ALTER TABLE `section_master`
396     ADD PRIMARY KEY (`MID`),
397     ADD KEY `SID` (`SID`),
398     ADD KEY `UID` (`UID`);
399    
400     ALTER TABLE `send_pass_log`
401     ADD PRIMARY KEY (`ID`),
402     ADD KEY `UID` (`UID`);
403    
404     ALTER TABLE `upload_file`
405     ADD PRIMARY KEY (`AID`),
406     ADD KEY `check` (`check`),
407     ADD KEY `UID` (`UID`),
408     ADD KEY `ref_AID` (`ref_AID`);
409    
410     ALTER TABLE `user_err_login_log`
411     ADD PRIMARY KEY (`ID`),
412     ADD KEY `login_dt` (`login_dt`,`login_ip`);
413    
414     ALTER TABLE `user_life_log`
415     ADD PRIMARY KEY (`ID`),
416     ADD KEY `set_UID` (`set_UID`),
417     ADD KEY `UID` (`UID`);
418    
419     ALTER TABLE `user_list`
420     ADD PRIMARY KEY (`UID`),
421     ADD UNIQUE KEY `username` (`username`),
422     ADD KEY `verified` (`verified`),
423     ADD KEY `enable` (`enable`);
424    
425     ALTER TABLE `user_login_log`
426     ADD PRIMARY KEY (`ID`),
427     ADD KEY `UID` (`UID`),
428     ADD KEY `login_dt` (`login_dt`);
429    
430     ALTER TABLE `user_modify_email_verify`
431     ADD PRIMARY KEY (`MID`),
432     ADD UNIQUE KEY `verify_code` (`verify_code`),
433     ADD KEY `UID` (`UID`),
434     ADD KEY `complete` (`complete`);
435    
436     ALTER TABLE `user_modify_log`
437     ADD PRIMARY KEY (`MID`),
438     ADD KEY `UID` (`UID`);
439    
440     ALTER TABLE `user_nickname`
441     ADD PRIMARY KEY (`NID`),
442     ADD KEY `UID` (`UID`),
443     ADD KEY `nickname` (`nickname`),
444     ADD KEY `begin_dt` (`begin_dt`),
445     ADD KEY `end_dt` (`end_dt`);
446    
447     ALTER TABLE `user_online`
448 sysadm 1.8 ADD PRIMARY KEY (`SID`) USING BTREE,
449 sysadm 1.4 ADD KEY `login_tm` (`login_tm`),
450     ADD KEY `UID` (`UID`),
451 sysadm 1.8 ADD KEY `last_tm` (`last_tm`);
452 sysadm 1.4
453     ALTER TABLE `user_pubinfo`
454     ADD PRIMARY KEY (`UID`),
455     ADD UNIQUE KEY `nickname` (`nickname`),
456     ADD KEY `life` (`life`),
457     ADD KEY `login_notify_dt` (`login_notify_dt`),
458     ADD KEY `exp` (`exp`),
459 sysadm 1.10 ADD KEY `last_login_dt` (`last_login_dt`);
460 sysadm 1.4
461     ALTER TABLE `user_reginfo`
462     ADD PRIMARY KEY (`UID`);
463    
464     ALTER TABLE `user_score`
465     ADD PRIMARY KEY (`UID`),
466     ADD KEY `score` (`score`);
467    
468     ALTER TABLE `user_score_log`
469     ADD PRIMARY KEY (`ID`),
470     ADD KEY `UID` (`UID`);
471    
472     ALTER TABLE `view_article_log`
473     ADD PRIMARY KEY (`AID`,`UID`),
474 sysadm 1.19 ADD UNIQUE KEY `UID` (`UID`,`AID`),
475 sysadm 1.4 ADD KEY `dt` (`dt`);
476    
477     ALTER TABLE `visit_log`
478     ADD PRIMARY KEY (`VID`);
479    
480 sysadm 1.8
481 sysadm 1.4 ALTER TABLE `admin_config`
482     MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
483    
484     ALTER TABLE `ban_user_list`
485     MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
486    
487     ALTER TABLE `bbs`
488     MODIFY `AID` int NOT NULL AUTO_INCREMENT;
489    
490     ALTER TABLE `bbs_article_op`
491     MODIFY `MID` int NOT NULL AUTO_INCREMENT;
492    
493     ALTER TABLE `bbs_content`
494     MODIFY `CID` int NOT NULL AUTO_INCREMENT;
495    
496     ALTER TABLE `bbs_msg`
497     MODIFY `MID` int NOT NULL AUTO_INCREMENT;
498    
499     ALTER TABLE `email`
500     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
501    
502     ALTER TABLE `ex_dir`
503     MODIFY `FID` mediumint NOT NULL AUTO_INCREMENT;
504    
505     ALTER TABLE `friend_list`
506     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
507    
508     ALTER TABLE `section_class`
509     MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;
510    
511     ALTER TABLE `section_config`
512     MODIFY `SID` smallint NOT NULL AUTO_INCREMENT;
513    
514     ALTER TABLE `section_favorite`
515     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
516    
517     ALTER TABLE `section_master`
518     MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
519    
520     ALTER TABLE `send_pass_log`
521     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
522    
523     ALTER TABLE `upload_file`
524     MODIFY `AID` mediumint NOT NULL AUTO_INCREMENT;
525    
526     ALTER TABLE `user_err_login_log`
527     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
528    
529     ALTER TABLE `user_life_log`
530     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
531    
532     ALTER TABLE `user_list`
533     MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
534    
535     ALTER TABLE `user_login_log`
536     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
537    
538     ALTER TABLE `user_modify_email_verify`
539     MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
540    
541     ALTER TABLE `user_modify_log`
542     MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
543    
544     ALTER TABLE `user_nickname`
545     MODIFY `NID` mediumint NOT NULL AUTO_INCREMENT;
546    
547     ALTER TABLE `user_score_log`
548     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
549    
550     ALTER TABLE `visit_log`
551     MODIFY `VID` int NOT NULL AUTO_INCREMENT;
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1