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

Contents of /fenglin/TODO/sql/db_stru.sql

Parent Directory Parent Directory | Revision Log Revision Log

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