/[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.11 - (hide 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 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_class` (
187 sysadm 1.4 `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 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_master` (
195 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
204 sysadm 1.4
205 sysadm 1.3 CREATE TABLE `section_config` (
206 sysadm 1.4 `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 sysadm 1.8 `topic_retention` smallint NOT NULL DEFAULT '0',
212 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
225 sysadm 1.4
226 sysadm 1.3 CREATE TABLE `section_favorite` (
227 sysadm 1.4 `ID` int NOT NULL,
228     `UID` mediumint NOT NULL DEFAULT '0',
229     `SID` smallint NOT NULL DEFAULT '0'
230 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
231 sysadm 1.4
232 sysadm 1.3 CREATE TABLE `section_master` (
233 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
242 sysadm 1.4
243 sysadm 1.3 CREATE TABLE `section_user_priv` (
244 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
249 sysadm 1.4
250 sysadm 1.3 CREATE TABLE `send_pass_log` (
251 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
256 sysadm 1.4
257 sysadm 1.3 CREATE TABLE `upload_file` (
258 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
267 sysadm 1.4
268 sysadm 1.3 CREATE TABLE `user_err_login_log` (
269 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
275 sysadm 1.4
276 sysadm 1.3 CREATE TABLE `user_life_log` (
277 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
284 sysadm 1.4
285 sysadm 1.3 CREATE TABLE `user_list` (
286 sysadm 1.4 `UID` mediumint NOT NULL,
287     `username` varchar(20) NOT NULL DEFAULT '',
288     `password` varchar(64) NOT NULL DEFAULT '',
289 sysadm 1.10 `temp_password` varchar(20) NOT NULL DEFAULT '',
290 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
296 sysadm 1.4
297 sysadm 1.3 CREATE TABLE `user_login_log` (
298 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
303 sysadm 1.4
304 sysadm 1.3 CREATE TABLE `user_modify_email_verify` (
305 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
313 sysadm 1.4
314 sysadm 1.3 CREATE TABLE `user_modify_log` (
315 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
321 sysadm 1.4
322 sysadm 1.3 CREATE TABLE `user_nickname` (
323 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
331 sysadm 1.4
332 sysadm 1.3 CREATE TABLE `user_online` (
333 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
340 sysadm 1.4
341 sysadm 1.3 CREATE TABLE `user_pubinfo` (
342 sysadm 1.4 `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 sysadm 1.10 `login_notify_dt` datetime DEFAULT NULL
362     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
363 sysadm 1.4
364 sysadm 1.3 CREATE TABLE `user_reginfo` (
365 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
372 sysadm 1.3
373     CREATE TABLE `user_regverify` (
374 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
379 sysadm 1.4
380 sysadm 1.3 CREATE TABLE `user_score` (
381 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
386 sysadm 1.4
387 sysadm 1.3 CREATE TABLE `user_score_log` (
388 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
394 sysadm 1.4
395 sysadm 1.3 CREATE TABLE `view_article_log` (
396 sysadm 1.4 `AID` int NOT NULL DEFAULT '0',
397     `UID` mediumint NOT NULL DEFAULT '0',
398     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
399 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
400 sysadm 1.4
401 sysadm 1.3 CREATE TABLE `visit_log` (
402 sysadm 1.4 `VID` int NOT NULL,
403     `dt` datetime DEFAULT NULL,
404     `ip` varchar(20) DEFAULT NULL
405 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
406 sysadm 1.4
407 sysadm 1.8
408 sysadm 1.4 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 sysadm 1.8 ADD PRIMARY KEY (`SID`) USING BTREE,
574 sysadm 1.4 ADD KEY `login_tm` (`login_tm`),
575     ADD KEY `UID` (`UID`),
576 sysadm 1.8 ADD KEY `last_tm` (`last_tm`);
577 sysadm 1.4
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 sysadm 1.10 ADD KEY `last_login_dt` (`last_login_dt`);
585 sysadm 1.4
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 sysadm 1.8
609 sysadm 1.4 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