/[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.20 - (hide annotations)
Tue Jun 24 09:15:26 2025 UTC (8 months, 3 weeks ago) by sysadm
Branch: MAIN
Changes since 1.19: +2 -0 lines
Content type: application/sql 
DB schema and configuration change to support gen_ex 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 sysadm 1.20 `ex_menu_tm` datetime DEFAULT NULL,
149     `ex_menu_update` tinyint NOT NULL DEFAULT '0',
150 sysadm 1.4 `read_user_level` smallint NOT NULL DEFAULT '0',
151     `write_user_level` smallint NOT NULL DEFAULT '0'
152 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
153 sysadm 1.4
154 sysadm 1.3 CREATE TABLE `section_favorite` (
155 sysadm 1.4 `ID` int NOT NULL,
156     `UID` mediumint NOT NULL DEFAULT '0',
157     `SID` smallint NOT NULL DEFAULT '0'
158 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
159 sysadm 1.4
160 sysadm 1.3 CREATE TABLE `section_master` (
161 sysadm 1.4 `MID` smallint NOT NULL,
162     `SID` smallint NOT NULL DEFAULT '0',
163     `UID` mediumint NOT NULL DEFAULT '0',
164     `begin_dt` datetime DEFAULT NULL,
165     `end_dt` datetime DEFAULT NULL,
166     `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
167     `major` tinyint UNSIGNED NOT NULL DEFAULT '0',
168     `memo` text
169 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
170 sysadm 1.4
171 sysadm 1.3 CREATE TABLE `send_pass_log` (
172 sysadm 1.4 `ID` mediumint NOT NULL,
173     `UID` mediumint NOT NULL DEFAULT '0',
174     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
175     `ip` varchar(20) NOT NULL DEFAULT ''
176 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
177 sysadm 1.4
178 sysadm 1.3 CREATE TABLE `upload_file` (
179 sysadm 1.4 `AID` mediumint NOT NULL,
180     `ref_AID` mediumint NOT NULL DEFAULT '0',
181     `UID` mediumint NOT NULL DEFAULT '0',
182     `size` mediumint NOT NULL DEFAULT '0',
183     `filename` varchar(255) NOT NULL DEFAULT '',
184     `check` tinyint UNSIGNED NOT NULL DEFAULT '0',
185     `deny` tinyint UNSIGNED NOT NULL DEFAULT '0',
186     `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
187 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
188 sysadm 1.4
189 sysadm 1.3 CREATE TABLE `user_err_login_log` (
190 sysadm 1.4 `ID` int NOT NULL,
191     `username` varchar(14) DEFAULT NULL,
192     `password` varchar(12) DEFAULT NULL,
193     `login_dt` datetime DEFAULT NULL,
194     `login_ip` varchar(20) DEFAULT NULL
195 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
196 sysadm 1.4
197 sysadm 1.3 CREATE TABLE `user_life_log` (
198 sysadm 1.4 `ID` mediumint NOT NULL,
199     `UID` mediumint NOT NULL DEFAULT '0',
200     `set_UID` mediumint NOT NULL DEFAULT '0',
201     `life` smallint NOT NULL DEFAULT '0',
202     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
203     `ip` varchar(20) NOT NULL DEFAULT ''
204 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
205 sysadm 1.4
206 sysadm 1.3 CREATE TABLE `user_list` (
207 sysadm 1.4 `UID` mediumint NOT NULL,
208     `username` varchar(20) NOT NULL DEFAULT '',
209     `password` varchar(64) NOT NULL DEFAULT '',
210 sysadm 1.10 `temp_password` varchar(20) NOT NULL DEFAULT '',
211 sysadm 1.4 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
212     `verified` tinyint UNSIGNED NOT NULL DEFAULT '0',
213     `p_login` tinyint UNSIGNED NOT NULL DEFAULT '1',
214     `p_post` tinyint UNSIGNED NOT NULL DEFAULT '1',
215     `p_msg` tinyint UNSIGNED NOT NULL DEFAULT '1'
216 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
217 sysadm 1.4
218 sysadm 1.3 CREATE TABLE `user_login_log` (
219 sysadm 1.4 `ID` int NOT NULL,
220     `UID` mediumint NOT NULL DEFAULT '0',
221     `login_dt` datetime DEFAULT NULL,
222     `login_ip` varchar(20) DEFAULT NULL
223 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
224 sysadm 1.4
225 sysadm 1.3 CREATE TABLE `user_modify_email_verify` (
226 sysadm 1.4 `MID` mediumint NOT NULL,
227     `UID` mediumint NOT NULL DEFAULT '0',
228     `email` varchar(30) DEFAULT NULL,
229     `verify_code` varchar(10) NOT NULL DEFAULT '',
230     `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
231     `dt` datetime DEFAULT NULL,
232     `ip` varchar(20) DEFAULT NULL
233 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
234 sysadm 1.4
235 sysadm 1.3 CREATE TABLE `user_modify_log` (
236 sysadm 1.4 `MID` mediumint NOT NULL,
237     `UID` mediumint NOT NULL DEFAULT '0',
238     `modify_dt` datetime DEFAULT NULL,
239     `modify_ip` varchar(20) DEFAULT NULL,
240     `complete` tinyint UNSIGNED NOT NULL DEFAULT '0'
241 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
242 sysadm 1.4
243 sysadm 1.3 CREATE TABLE `user_nickname` (
244 sysadm 1.4 `NID` mediumint NOT NULL,
245     `UID` mediumint NOT NULL DEFAULT '0',
246     `nickname` varchar(20) NOT NULL DEFAULT '',
247     `begin_dt` datetime DEFAULT NULL,
248     `begin_reason` char(1) DEFAULT NULL,
249     `end_dt` datetime DEFAULT NULL,
250     `end_reason` char(1) DEFAULT NULL
251 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
252 sysadm 1.4
253 sysadm 1.3 CREATE TABLE `user_online` (
254 sysadm 1.4 `SID` varchar(32) NOT NULL DEFAULT '',
255     `UID` mediumint NOT NULL DEFAULT '0',
256     `ip` varchar(20) NOT NULL DEFAULT '',
257     `current_action` varchar(20) NOT NULL DEFAULT '',
258     `login_tm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
259     `last_tm` datetime DEFAULT NULL
260 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
261 sysadm 1.4
262 sysadm 1.3 CREATE TABLE `user_pubinfo` (
263 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
264     `nickname` varchar(20) DEFAULT NULL,
265     `email` varchar(30) DEFAULT NULL,
266     `gender` char(1) NOT NULL DEFAULT 'M',
267     `qq` varchar(10) DEFAULT NULL,
268     `introduction` mediumtext,
269     `photo` smallint DEFAULT '0',
270     `photo_enable` tinyint(1) NOT NULL DEFAULT '0',
271     `photo_ext` varchar(5) NOT NULL DEFAULT '',
272     `life` smallint NOT NULL DEFAULT '15',
273     `exp` mediumint DEFAULT '0',
274     `visit_count` mediumint NOT NULL DEFAULT '0',
275     `gender_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
276     `last_login_dt` datetime DEFAULT NULL,
277     `sign_1` mediumtext,
278     `sign_2` mediumtext,
279     `sign_3` mediumtext,
280     `upload_limit` int NOT NULL DEFAULT '1048576',
281 sysadm 1.18 `login_notify_dt` datetime DEFAULT NULL,
282     `user_timezone` varchar(50) NOT NULL DEFAULT '',
283     `game_money` int NOT NULL DEFAULT '0'
284 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
285 sysadm 1.4
286 sysadm 1.3 CREATE TABLE `user_reginfo` (
287 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
288     `name` varchar(10) DEFAULT NULL,
289     `birthday` datetime DEFAULT NULL,
290     `signup_dt` datetime DEFAULT NULL,
291     `signup_ip` varchar(20) DEFAULT NULL,
292     `memo` mediumtext
293 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
294 sysadm 1.3
295     CREATE TABLE `user_score` (
296 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
297     `score` mediumint NOT NULL DEFAULT '0',
298     `last_exp` mediumint NOT NULL DEFAULT '0',
299     `exp_left` mediumint NOT NULL DEFAULT '0'
300 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
301 sysadm 1.4
302 sysadm 1.3 CREATE TABLE `user_score_log` (
303 sysadm 1.4 `ID` mediumint NOT NULL,
304     `UID` mediumint NOT NULL DEFAULT '0',
305     `score_change` mediumint NOT NULL DEFAULT '0',
306     `reason` varchar(50) DEFAULT NULL,
307     `dt` datetime DEFAULT NULL
308 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
309 sysadm 1.4
310 sysadm 1.3 CREATE TABLE `view_article_log` (
311 sysadm 1.4 `AID` int NOT NULL DEFAULT '0',
312     `UID` mediumint NOT NULL DEFAULT '0',
313     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
314 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
315 sysadm 1.4
316 sysadm 1.3 CREATE TABLE `visit_log` (
317 sysadm 1.4 `VID` int NOT NULL,
318     `dt` datetime DEFAULT NULL,
319     `ip` varchar(20) DEFAULT NULL
320 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
321 sysadm 1.4
322 sysadm 1.8
323 sysadm 1.4 ALTER TABLE `admin_config`
324     ADD PRIMARY KEY (`AID`),
325     ADD KEY `UID` (`UID`);
326    
327     ALTER TABLE `ban_user_list`
328     ADD PRIMARY KEY (`BID`),
329     ADD KEY `ban_UID` (`ban_UID`),
330     ADD KEY `SID` (`SID`),
331     ADD KEY `day` (`day`),
332     ADD KEY `UID` (`UID`);
333    
334     ALTER TABLE `bbs`
335     ADD PRIMARY KEY (`AID`),
336     ADD UNIQUE KEY `CID` (`CID`),
337     ADD KEY `UID` (`UID`),
338     ADD KEY `reply_count` (`reply_count`),
339     ADD KEY `last_reply_dt` (`last_reply_dt`),
340     ADD KEY `view_count` (`view_count`),
341     ADD KEY `sub_dt` (`sub_dt`),
342     ADD KEY `title` (`title`(10)),
343     ADD KEY `old_SID` (`old_SID`),
344     ADD KEY `SID` (`SID`),
345     ADD KEY `TID` (`TID`),
346     ADD KEY `last_reply_UID` (`last_reply_UID`);
347    
348     ALTER TABLE `bbs_article_op`
349     ADD PRIMARY KEY (`MID`),
350     ADD KEY `AID` (`AID`),
351     ADD KEY `UID` (`UID`),
352     ADD KEY `type` (`type`);
353    
354     ALTER TABLE `bbs_content`
355     ADD PRIMARY KEY (`CID`),
356     ADD KEY `AID` (`AID`);
357    
358     ALTER TABLE `bbs_msg`
359     ADD PRIMARY KEY (`MID`),
360     ADD KEY `fromUID` (`fromUID`),
361     ADD KEY `toUID` (`toUID`);
362    
363     ALTER TABLE `email`
364     ADD PRIMARY KEY (`ID`),
365     ADD KEY `complete` (`complete`);
366    
367     ALTER TABLE `ex_dir`
368     ADD PRIMARY KEY (`FID`),
369     ADD KEY `SID` (`SID`),
370     ADD KEY `dir` (`dir`(50));
371    
372     ALTER TABLE `ex_file`
373     ADD PRIMARY KEY (`AID`),
374     ADD KEY `FID` (`FID`);
375    
376     ALTER TABLE `friend_list`
377     ADD PRIMARY KEY (`ID`),
378     ADD KEY `fUID` (`fUID`),
379     ADD KEY `UID` (`UID`);
380    
381     ALTER TABLE `section_class`
382     ADD PRIMARY KEY (`CID`),
383     ADD KEY `sort_order` (`sort_order`);
384    
385     ALTER TABLE `section_config`
386     ADD PRIMARY KEY (`SID`),
387     ADD KEY `CID` (`CID`),
388     ADD KEY `write_user_level` (`write_user_level`),
389     ADD KEY `sort_order` (`sort_order`),
390     ADD KEY `read_user_level` (`read_user_level`),
391     ADD KEY `sname` (`sname`);
392    
393     ALTER TABLE `section_favorite`
394     ADD PRIMARY KEY (`ID`),
395     ADD KEY `UID` (`UID`);
396    
397     ALTER TABLE `section_master`
398     ADD PRIMARY KEY (`MID`),
399     ADD KEY `SID` (`SID`),
400     ADD KEY `UID` (`UID`);
401    
402     ALTER TABLE `send_pass_log`
403     ADD PRIMARY KEY (`ID`),
404     ADD KEY `UID` (`UID`);
405    
406     ALTER TABLE `upload_file`
407     ADD PRIMARY KEY (`AID`),
408     ADD KEY `check` (`check`),
409     ADD KEY `UID` (`UID`),
410     ADD KEY `ref_AID` (`ref_AID`);
411    
412     ALTER TABLE `user_err_login_log`
413     ADD PRIMARY KEY (`ID`),
414     ADD KEY `login_dt` (`login_dt`,`login_ip`);
415    
416     ALTER TABLE `user_life_log`
417     ADD PRIMARY KEY (`ID`),
418     ADD KEY `set_UID` (`set_UID`),
419     ADD KEY `UID` (`UID`);
420    
421     ALTER TABLE `user_list`
422     ADD PRIMARY KEY (`UID`),
423     ADD UNIQUE KEY `username` (`username`),
424     ADD KEY `verified` (`verified`),
425     ADD KEY `enable` (`enable`);
426    
427     ALTER TABLE `user_login_log`
428     ADD PRIMARY KEY (`ID`),
429     ADD KEY `UID` (`UID`),
430     ADD KEY `login_dt` (`login_dt`);
431    
432     ALTER TABLE `user_modify_email_verify`
433     ADD PRIMARY KEY (`MID`),
434     ADD UNIQUE KEY `verify_code` (`verify_code`),
435     ADD KEY `UID` (`UID`),
436     ADD KEY `complete` (`complete`);
437    
438     ALTER TABLE `user_modify_log`
439     ADD PRIMARY KEY (`MID`),
440     ADD KEY `UID` (`UID`);
441    
442     ALTER TABLE `user_nickname`
443     ADD PRIMARY KEY (`NID`),
444     ADD KEY `UID` (`UID`),
445     ADD KEY `nickname` (`nickname`),
446     ADD KEY `begin_dt` (`begin_dt`),
447     ADD KEY `end_dt` (`end_dt`);
448    
449     ALTER TABLE `user_online`
450 sysadm 1.8 ADD PRIMARY KEY (`SID`) USING BTREE,
451 sysadm 1.4 ADD KEY `login_tm` (`login_tm`),
452     ADD KEY `UID` (`UID`),
453 sysadm 1.8 ADD KEY `last_tm` (`last_tm`);
454 sysadm 1.4
455     ALTER TABLE `user_pubinfo`
456     ADD PRIMARY KEY (`UID`),
457     ADD UNIQUE KEY `nickname` (`nickname`),
458     ADD KEY `life` (`life`),
459     ADD KEY `login_notify_dt` (`login_notify_dt`),
460     ADD KEY `exp` (`exp`),
461 sysadm 1.10 ADD KEY `last_login_dt` (`last_login_dt`);
462 sysadm 1.4
463     ALTER TABLE `user_reginfo`
464     ADD PRIMARY KEY (`UID`);
465    
466     ALTER TABLE `user_score`
467     ADD PRIMARY KEY (`UID`),
468     ADD KEY `score` (`score`);
469    
470     ALTER TABLE `user_score_log`
471     ADD PRIMARY KEY (`ID`),
472     ADD KEY `UID` (`UID`);
473    
474     ALTER TABLE `view_article_log`
475     ADD PRIMARY KEY (`AID`,`UID`),
476 sysadm 1.19 ADD UNIQUE KEY `UID` (`UID`,`AID`),
477 sysadm 1.4 ADD KEY `dt` (`dt`);
478    
479     ALTER TABLE `visit_log`
480     ADD PRIMARY KEY (`VID`);
481    
482 sysadm 1.8
483 sysadm 1.4 ALTER TABLE `admin_config`
484     MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
485    
486     ALTER TABLE `ban_user_list`
487     MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
488    
489     ALTER TABLE `bbs`
490     MODIFY `AID` int NOT NULL AUTO_INCREMENT;
491    
492     ALTER TABLE `bbs_article_op`
493     MODIFY `MID` int NOT NULL AUTO_INCREMENT;
494    
495     ALTER TABLE `bbs_content`
496     MODIFY `CID` int NOT NULL AUTO_INCREMENT;
497    
498     ALTER TABLE `bbs_msg`
499     MODIFY `MID` int NOT NULL AUTO_INCREMENT;
500    
501     ALTER TABLE `email`
502     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
503    
504     ALTER TABLE `ex_dir`
505     MODIFY `FID` mediumint NOT NULL AUTO_INCREMENT;
506    
507     ALTER TABLE `friend_list`
508     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
509    
510     ALTER TABLE `section_class`
511     MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;
512    
513     ALTER TABLE `section_config`
514     MODIFY `SID` smallint NOT NULL AUTO_INCREMENT;
515    
516     ALTER TABLE `section_favorite`
517     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
518    
519     ALTER TABLE `section_master`
520     MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
521    
522     ALTER TABLE `send_pass_log`
523     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
524    
525     ALTER TABLE `upload_file`
526     MODIFY `AID` mediumint NOT NULL AUTO_INCREMENT;
527    
528     ALTER TABLE `user_err_login_log`
529     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
530    
531     ALTER TABLE `user_life_log`
532     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
533    
534     ALTER TABLE `user_list`
535     MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
536    
537     ALTER TABLE `user_login_log`
538     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
539    
540     ALTER TABLE `user_modify_email_verify`
541     MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
542    
543     ALTER TABLE `user_modify_log`
544     MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
545    
546     ALTER TABLE `user_nickname`
547     MODIFY `NID` mediumint NOT NULL AUTO_INCREMENT;
548    
549     ALTER TABLE `user_score_log`
550     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
551    
552     ALTER TABLE `visit_log`
553     MODIFY `VID` int NOT NULL AUTO_INCREMENT;
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1