/[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.11 - (show annotations)
Wed Apr 9 06:15:33 2025 UTC (11 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.10: +0 -34 lines
Content type: application/sql 
Remove legacy tables
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 `mng_err_login_log` (
148 `ID` int NOT NULL,
149 `username` varchar(14) DEFAULT NULL,
150 `password` varchar(12) DEFAULT NULL,
151 `login_dt` datetime DEFAULT NULL,
152 `login_ip` varchar(20) DEFAULT NULL
153 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
154
155 CREATE TABLE `mng_login_log` (
156 `ID` int NOT NULL,
157 `UID` mediumint NOT NULL DEFAULT '0',
158 `login_dt` datetime DEFAULT NULL,
159 `login_ip` varchar(20) DEFAULT NULL
160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
161
162 CREATE TABLE `mng_priv_list` (
163 `PID` mediumint NOT NULL,
164 `UID` mediumint NOT NULL DEFAULT '0',
165 `ch_passwd` tinyint UNSIGNED NOT NULL DEFAULT '1',
166 `db_cleanup` tinyint UNSIGNED NOT NULL DEFAULT '0',
167 `score_cacl` tinyint UNSIGNED NOT NULL DEFAULT '0',
168 `auth_user_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
169 `section_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
170 `master_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
171 `photo_check` tinyint UNSIGNED NOT NULL DEFAULT '0',
172 `prize_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
173 `article_audit` tinyint UNSIGNED NOT NULL DEFAULT '0',
174 `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
175 `upload_check` tinyint UNSIGNED NOT NULL DEFAULT '0',
176 `article_recommend` tinyint UNSIGNED NOT NULL DEFAULT '0'
177 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
178
179 CREATE TABLE `mng_user_list` (
180 `UID` mediumint NOT NULL,
181 `username` varchar(14) NOT NULL DEFAULT '',
182 `password` varchar(64) NOT NULL DEFAULT '',
183 `enable` tinyint UNSIGNED NOT NULL DEFAULT '0'
184 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
185
186 CREATE TABLE `section_class` (
187 `CID` smallint NOT NULL,
188 `cname` varchar(20) DEFAULT NULL,
189 `title` varchar(20) DEFAULT NULL,
190 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
191 `sort_order` smallint NOT NULL DEFAULT '10'
192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
193
194 CREATE TABLE `section_class_master` (
195 `MID` smallint NOT NULL,
196 `CID` smallint NOT NULL DEFAULT '0',
197 `UID` mediumint NOT NULL DEFAULT '0',
198 `begin_dt` datetime DEFAULT NULL,
199 `end_dt` datetime DEFAULT NULL,
200 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
201 `memo` text,
202 `major` tinyint UNSIGNED NOT NULL DEFAULT '0'
203 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
204
205 CREATE TABLE `section_config` (
206 `SID` smallint NOT NULL,
207 `sname` varchar(20) DEFAULT NULL,
208 `CID` smallint NOT NULL DEFAULT '0',
209 `title` varchar(20) DEFAULT NULL,
210 `comment` varchar(255) DEFAULT NULL,
211 `topic_retention` smallint NOT NULL DEFAULT '0',
212 `announcement` longtext,
213 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
214 `exp_get` tinyint UNSIGNED NOT NULL DEFAULT '0',
215 `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
216 `set_UID` mediumint DEFAULT '0',
217 `set_dt` datetime DEFAULT NULL,
218 `set_ip` varchar(20) DEFAULT NULL,
219 `sort_order` smallint NOT NULL DEFAULT '10',
220 `ex_gen_tm` datetime DEFAULT NULL,
221 `ex_update` tinyint UNSIGNED NOT NULL DEFAULT '0',
222 `read_user_level` smallint NOT NULL DEFAULT '0',
223 `write_user_level` smallint NOT NULL DEFAULT '0'
224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
225
226 CREATE TABLE `section_favorite` (
227 `ID` int NOT NULL,
228 `UID` mediumint NOT NULL DEFAULT '0',
229 `SID` smallint NOT NULL DEFAULT '0'
230 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
231
232 CREATE TABLE `section_master` (
233 `MID` smallint NOT NULL,
234 `SID` smallint NOT NULL DEFAULT '0',
235 `UID` mediumint NOT NULL DEFAULT '0',
236 `begin_dt` datetime DEFAULT NULL,
237 `end_dt` datetime DEFAULT NULL,
238 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
239 `major` tinyint UNSIGNED NOT NULL DEFAULT '0',
240 `memo` text
241 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
242
243 CREATE TABLE `section_user_priv` (
244 `SID` smallint NOT NULL DEFAULT '0',
245 `UID` mediumint NOT NULL DEFAULT '0',
246 `read` tinyint UNSIGNED NOT NULL DEFAULT '0',
247 `write` tinyint UNSIGNED NOT NULL DEFAULT '0'
248 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
249
250 CREATE TABLE `send_pass_log` (
251 `ID` mediumint NOT NULL,
252 `UID` mediumint NOT NULL DEFAULT '0',
253 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
254 `ip` varchar(20) NOT NULL DEFAULT ''
255 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
256
257 CREATE TABLE `upload_file` (
258 `AID` mediumint NOT NULL,
259 `ref_AID` mediumint NOT NULL DEFAULT '0',
260 `UID` mediumint NOT NULL DEFAULT '0',
261 `size` mediumint NOT NULL DEFAULT '0',
262 `filename` varchar(255) NOT NULL DEFAULT '',
263 `check` tinyint UNSIGNED NOT NULL DEFAULT '0',
264 `deny` tinyint UNSIGNED NOT NULL DEFAULT '0',
265 `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
266 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
267
268 CREATE TABLE `user_err_login_log` (
269 `ID` int NOT NULL,
270 `username` varchar(14) DEFAULT NULL,
271 `password` varchar(12) DEFAULT NULL,
272 `login_dt` datetime DEFAULT NULL,
273 `login_ip` varchar(20) DEFAULT NULL
274 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
275
276 CREATE TABLE `user_life_log` (
277 `ID` mediumint NOT NULL,
278 `UID` mediumint NOT NULL DEFAULT '0',
279 `set_UID` mediumint NOT NULL DEFAULT '0',
280 `life` smallint NOT NULL DEFAULT '0',
281 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
282 `ip` varchar(20) NOT NULL DEFAULT ''
283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
284
285 CREATE TABLE `user_list` (
286 `UID` mediumint NOT NULL,
287 `username` varchar(20) NOT NULL DEFAULT '',
288 `password` varchar(64) NOT NULL DEFAULT '',
289 `temp_password` varchar(20) NOT NULL DEFAULT '',
290 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
291 `verified` tinyint UNSIGNED NOT NULL DEFAULT '0',
292 `p_login` tinyint UNSIGNED NOT NULL DEFAULT '1',
293 `p_post` tinyint UNSIGNED NOT NULL DEFAULT '1',
294 `p_msg` tinyint UNSIGNED NOT NULL DEFAULT '1'
295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
296
297 CREATE TABLE `user_login_log` (
298 `ID` int NOT NULL,
299 `UID` mediumint NOT NULL DEFAULT '0',
300 `login_dt` datetime DEFAULT NULL,
301 `login_ip` varchar(20) DEFAULT NULL
302 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
303
304 CREATE TABLE `user_modify_email_verify` (
305 `MID` mediumint NOT NULL,
306 `UID` mediumint NOT NULL DEFAULT '0',
307 `email` varchar(30) DEFAULT NULL,
308 `verify_code` varchar(10) NOT NULL DEFAULT '',
309 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
310 `dt` datetime DEFAULT NULL,
311 `ip` varchar(20) DEFAULT NULL
312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
313
314 CREATE TABLE `user_modify_log` (
315 `MID` mediumint NOT NULL,
316 `UID` mediumint NOT NULL DEFAULT '0',
317 `modify_dt` datetime DEFAULT NULL,
318 `modify_ip` varchar(20) DEFAULT NULL,
319 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0'
320 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
321
322 CREATE TABLE `user_nickname` (
323 `NID` mediumint NOT NULL,
324 `UID` mediumint NOT NULL DEFAULT '0',
325 `nickname` varchar(20) NOT NULL DEFAULT '',
326 `begin_dt` datetime DEFAULT NULL,
327 `begin_reason` char(1) DEFAULT NULL,
328 `end_dt` datetime DEFAULT NULL,
329 `end_reason` char(1) DEFAULT NULL
330 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
331
332 CREATE TABLE `user_online` (
333 `SID` varchar(32) NOT NULL DEFAULT '',
334 `UID` mediumint NOT NULL DEFAULT '0',
335 `ip` varchar(20) NOT NULL DEFAULT '',
336 `current_action` varchar(20) NOT NULL DEFAULT '',
337 `login_tm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
338 `last_tm` datetime DEFAULT NULL
339 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
340
341 CREATE TABLE `user_pubinfo` (
342 `UID` mediumint NOT NULL DEFAULT '0',
343 `nickname` varchar(20) DEFAULT NULL,
344 `email` varchar(30) DEFAULT NULL,
345 `gender` char(1) NOT NULL DEFAULT 'M',
346 `qq` varchar(10) DEFAULT NULL,
347 `introduction` mediumtext,
348 `photo` smallint DEFAULT '0',
349 `photo_enable` tinyint(1) NOT NULL DEFAULT '0',
350 `photo_ext` varchar(5) NOT NULL DEFAULT '',
351 `life` smallint NOT NULL DEFAULT '15',
352 `exp` mediumint DEFAULT '0',
353 `visit_count` mediumint NOT NULL DEFAULT '0',
354 `gender_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
355 `last_login_dt` datetime DEFAULT NULL,
356 `sign_1` mediumtext,
357 `sign_2` mediumtext,
358 `sign_3` mediumtext,
359 `sub_permission` tinyint UNSIGNED NOT NULL DEFAULT '1',
360 `upload_limit` int NOT NULL DEFAULT '1048576',
361 `login_notify_dt` datetime DEFAULT NULL
362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
363
364 CREATE TABLE `user_reginfo` (
365 `UID` mediumint NOT NULL DEFAULT '0',
366 `name` varchar(10) DEFAULT NULL,
367 `birthday` datetime DEFAULT NULL,
368 `signup_dt` datetime DEFAULT NULL,
369 `signup_ip` varchar(20) DEFAULT NULL,
370 `memo` mediumtext
371 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
372
373 CREATE TABLE `user_regverify` (
374 `UID` mediumint NOT NULL DEFAULT '0',
375 `verify_code` varchar(10) NOT NULL DEFAULT '',
376 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
377 `set_dt` datetime DEFAULT NULL
378 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
379
380 CREATE TABLE `user_score` (
381 `UID` mediumint NOT NULL DEFAULT '0',
382 `score` mediumint NOT NULL DEFAULT '0',
383 `last_exp` mediumint NOT NULL DEFAULT '0',
384 `exp_left` mediumint NOT NULL DEFAULT '0'
385 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
386
387 CREATE TABLE `user_score_log` (
388 `ID` mediumint NOT NULL,
389 `UID` mediumint NOT NULL DEFAULT '0',
390 `score_change` mediumint NOT NULL DEFAULT '0',
391 `reason` varchar(50) DEFAULT NULL,
392 `dt` datetime DEFAULT NULL
393 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
394
395 CREATE TABLE `view_article_log` (
396 `AID` int NOT NULL DEFAULT '0',
397 `UID` mediumint NOT NULL DEFAULT '0',
398 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
399 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
400
401 CREATE TABLE `visit_log` (
402 `VID` int NOT NULL,
403 `dt` datetime DEFAULT NULL,
404 `ip` varchar(20) DEFAULT NULL
405 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
406
407
408 ALTER TABLE `admin_config`
409 ADD PRIMARY KEY (`AID`),
410 ADD KEY `UID` (`UID`);
411
412 ALTER TABLE `ban_user_list`
413 ADD PRIMARY KEY (`BID`),
414 ADD KEY `ban_UID` (`ban_UID`),
415 ADD KEY `SID` (`SID`),
416 ADD KEY `day` (`day`),
417 ADD KEY `UID` (`UID`);
418
419 ALTER TABLE `bbs`
420 ADD PRIMARY KEY (`AID`),
421 ADD UNIQUE KEY `CID` (`CID`),
422 ADD KEY `UID` (`UID`),
423 ADD KEY `reply_count` (`reply_count`),
424 ADD KEY `last_reply_dt` (`last_reply_dt`),
425 ADD KEY `view_count` (`view_count`),
426 ADD KEY `sub_dt` (`sub_dt`),
427 ADD KEY `title` (`title`(10)),
428 ADD KEY `old_SID` (`old_SID`),
429 ADD KEY `SID` (`SID`),
430 ADD KEY `TID` (`TID`),
431 ADD KEY `last_reply_UID` (`last_reply_UID`);
432
433 ALTER TABLE `bbs_article_op`
434 ADD PRIMARY KEY (`MID`),
435 ADD KEY `AID` (`AID`),
436 ADD KEY `UID` (`UID`),
437 ADD KEY `type` (`type`);
438
439 ALTER TABLE `bbs_content`
440 ADD PRIMARY KEY (`CID`),
441 ADD KEY `AID` (`AID`);
442
443 ALTER TABLE `bbs_ex_dl`
444 ADD PRIMARY KEY (`ID`),
445 ADD UNIQUE KEY `SID` (`SID`),
446 ADD KEY `dl_type` (`dl_type`);
447
448 ALTER TABLE `bbs_msg`
449 ADD PRIMARY KEY (`MID`),
450 ADD KEY `fromUID` (`fromUID`),
451 ADD KEY `toUID` (`toUID`);
452
453 ALTER TABLE `email`
454 ADD PRIMARY KEY (`ID`),
455 ADD KEY `complete` (`complete`);
456
457 ALTER TABLE `ex_dir`
458 ADD PRIMARY KEY (`FID`),
459 ADD KEY `SID` (`SID`),
460 ADD KEY `dir` (`dir`(50));
461
462 ALTER TABLE `ex_file`
463 ADD PRIMARY KEY (`AID`),
464 ADD KEY `FID` (`FID`);
465
466 ALTER TABLE `friend_list`
467 ADD PRIMARY KEY (`ID`),
468 ADD KEY `fUID` (`fUID`),
469 ADD KEY `UID` (`UID`);
470
471 ALTER TABLE `journal_data`
472 ADD PRIMARY KEY (`ID`),
473 ADD UNIQUE KEY `AID` (`AID`),
474 ADD KEY `JID` (`JID`);
475
476 ALTER TABLE `journal_index`
477 ADD PRIMARY KEY (`JID`);
478
479 ALTER TABLE `mng_err_login_log`
480 ADD PRIMARY KEY (`ID`);
481
482 ALTER TABLE `mng_login_log`
483 ADD PRIMARY KEY (`ID`),
484 ADD KEY `UID` (`UID`),
485 ADD KEY `login_dt` (`login_dt`);
486
487 ALTER TABLE `mng_priv_list`
488 ADD PRIMARY KEY (`PID`),
489 ADD UNIQUE KEY `UID` (`UID`);
490
491 ALTER TABLE `mng_user_list`
492 ADD PRIMARY KEY (`UID`),
493 ADD UNIQUE KEY `username` (`username`);
494
495 ALTER TABLE `section_class`
496 ADD PRIMARY KEY (`CID`),
497 ADD KEY `sort_order` (`sort_order`);
498
499 ALTER TABLE `section_class_master`
500 ADD PRIMARY KEY (`MID`),
501 ADD KEY `UID` (`UID`),
502 ADD KEY `CID` (`CID`);
503
504 ALTER TABLE `section_config`
505 ADD PRIMARY KEY (`SID`),
506 ADD KEY `CID` (`CID`),
507 ADD KEY `write_user_level` (`write_user_level`),
508 ADD KEY `sort_order` (`sort_order`),
509 ADD KEY `read_user_level` (`read_user_level`),
510 ADD KEY `sname` (`sname`);
511
512 ALTER TABLE `section_favorite`
513 ADD PRIMARY KEY (`ID`),
514 ADD KEY `UID` (`UID`);
515
516 ALTER TABLE `section_master`
517 ADD PRIMARY KEY (`MID`),
518 ADD KEY `SID` (`SID`),
519 ADD KEY `UID` (`UID`);
520
521 ALTER TABLE `section_user_priv`
522 ADD PRIMARY KEY (`SID`,`UID`),
523 ADD KEY `UID` (`UID`);
524
525 ALTER TABLE `send_pass_log`
526 ADD PRIMARY KEY (`ID`),
527 ADD KEY `UID` (`UID`);
528
529 ALTER TABLE `upload_file`
530 ADD PRIMARY KEY (`AID`),
531 ADD KEY `check` (`check`),
532 ADD KEY `UID` (`UID`),
533 ADD KEY `ref_AID` (`ref_AID`);
534
535 ALTER TABLE `user_err_login_log`
536 ADD PRIMARY KEY (`ID`),
537 ADD KEY `login_dt` (`login_dt`,`login_ip`);
538
539 ALTER TABLE `user_life_log`
540 ADD PRIMARY KEY (`ID`),
541 ADD KEY `set_UID` (`set_UID`),
542 ADD KEY `UID` (`UID`);
543
544 ALTER TABLE `user_list`
545 ADD PRIMARY KEY (`UID`),
546 ADD UNIQUE KEY `username` (`username`),
547 ADD KEY `verified` (`verified`),
548 ADD KEY `enable` (`enable`);
549
550 ALTER TABLE `user_login_log`
551 ADD PRIMARY KEY (`ID`),
552 ADD KEY `UID` (`UID`),
553 ADD KEY `login_dt` (`login_dt`);
554
555 ALTER TABLE `user_modify_email_verify`
556 ADD PRIMARY KEY (`MID`),
557 ADD UNIQUE KEY `verify_code` (`verify_code`),
558 ADD KEY `UID` (`UID`),
559 ADD KEY `complete` (`complete`);
560
561 ALTER TABLE `user_modify_log`
562 ADD PRIMARY KEY (`MID`),
563 ADD KEY `UID` (`UID`);
564
565 ALTER TABLE `user_nickname`
566 ADD PRIMARY KEY (`NID`),
567 ADD KEY `UID` (`UID`),
568 ADD KEY `nickname` (`nickname`),
569 ADD KEY `begin_dt` (`begin_dt`),
570 ADD KEY `end_dt` (`end_dt`);
571
572 ALTER TABLE `user_online`
573 ADD PRIMARY KEY (`SID`) USING BTREE,
574 ADD KEY `login_tm` (`login_tm`),
575 ADD KEY `UID` (`UID`),
576 ADD KEY `last_tm` (`last_tm`);
577
578 ALTER TABLE `user_pubinfo`
579 ADD PRIMARY KEY (`UID`),
580 ADD UNIQUE KEY `nickname` (`nickname`),
581 ADD KEY `life` (`life`),
582 ADD KEY `login_notify_dt` (`login_notify_dt`),
583 ADD KEY `exp` (`exp`),
584 ADD KEY `last_login_dt` (`last_login_dt`);
585
586 ALTER TABLE `user_reginfo`
587 ADD PRIMARY KEY (`UID`);
588
589 ALTER TABLE `user_regverify`
590 ADD PRIMARY KEY (`UID`),
591 ADD UNIQUE KEY `verify_code` (`verify_code`);
592
593 ALTER TABLE `user_score`
594 ADD PRIMARY KEY (`UID`),
595 ADD KEY `score` (`score`);
596
597 ALTER TABLE `user_score_log`
598 ADD PRIMARY KEY (`ID`),
599 ADD KEY `UID` (`UID`);
600
601 ALTER TABLE `view_article_log`
602 ADD PRIMARY KEY (`AID`,`UID`),
603 ADD KEY `dt` (`dt`);
604
605 ALTER TABLE `visit_log`
606 ADD PRIMARY KEY (`VID`);
607
608
609 ALTER TABLE `admin_config`
610 MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
611
612 ALTER TABLE `ban_user_list`
613 MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
614
615 ALTER TABLE `bbs`
616 MODIFY `AID` int NOT NULL AUTO_INCREMENT;
617
618 ALTER TABLE `bbs_article_op`
619 MODIFY `MID` int NOT NULL AUTO_INCREMENT;
620
621 ALTER TABLE `bbs_content`
622 MODIFY `CID` int NOT NULL AUTO_INCREMENT;
623
624 ALTER TABLE `bbs_ex_dl`
625 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
626
627 ALTER TABLE `bbs_msg`
628 MODIFY `MID` int NOT NULL AUTO_INCREMENT;
629
630 ALTER TABLE `email`
631 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
632
633 ALTER TABLE `ex_dir`
634 MODIFY `FID` mediumint NOT NULL AUTO_INCREMENT;
635
636 ALTER TABLE `friend_list`
637 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
638
639 ALTER TABLE `journal_data`
640 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
641
642 ALTER TABLE `journal_index`
643 MODIFY `JID` smallint NOT NULL AUTO_INCREMENT;
644
645 ALTER TABLE `mng_err_login_log`
646 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
647
648 ALTER TABLE `mng_login_log`
649 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
650
651 ALTER TABLE `mng_priv_list`
652 MODIFY `PID` mediumint NOT NULL AUTO_INCREMENT;
653
654 ALTER TABLE `mng_user_list`
655 MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
656
657 ALTER TABLE `section_class`
658 MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;
659
660 ALTER TABLE `section_class_master`
661 MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
662
663 ALTER TABLE `section_config`
664 MODIFY `SID` smallint NOT NULL AUTO_INCREMENT;
665
666 ALTER TABLE `section_favorite`
667 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
668
669 ALTER TABLE `section_master`
670 MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
671
672 ALTER TABLE `send_pass_log`
673 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
674
675 ALTER TABLE `upload_file`
676 MODIFY `AID` mediumint NOT NULL AUTO_INCREMENT;
677
678 ALTER TABLE `user_err_login_log`
679 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
680
681 ALTER TABLE `user_life_log`
682 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
683
684 ALTER TABLE `user_list`
685 MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
686
687 ALTER TABLE `user_login_log`
688 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
689
690 ALTER TABLE `user_modify_email_verify`
691 MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
692
693 ALTER TABLE `user_modify_log`
694 MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
695
696 ALTER TABLE `user_nickname`
697 MODIFY `NID` mediumint NOT NULL AUTO_INCREMENT;
698
699 ALTER TABLE `user_score_log`
700 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
701
702 ALTER TABLE `visit_log`
703 MODIFY `VID` int NOT NULL AUTO_INCREMENT;
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1