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