/[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.12 - (hide annotations)
Wed Apr 9 09:58:54 2025 UTC (11 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.11: +0 -67 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 `section_class` (
148 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
154 sysadm 1.4
155 sysadm 1.3 CREATE TABLE `section_class_master` (
156 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
165 sysadm 1.4
166 sysadm 1.3 CREATE TABLE `section_config` (
167 sysadm 1.4 `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 sysadm 1.8 `topic_retention` smallint NOT NULL DEFAULT '0',
173 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
186 sysadm 1.4
187 sysadm 1.3 CREATE TABLE `section_favorite` (
188 sysadm 1.4 `ID` int NOT NULL,
189     `UID` mediumint NOT NULL DEFAULT '0',
190     `SID` smallint NOT NULL DEFAULT '0'
191 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
192 sysadm 1.4
193 sysadm 1.3 CREATE TABLE `section_master` (
194 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
203 sysadm 1.4
204 sysadm 1.3 CREATE TABLE `section_user_priv` (
205 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
210 sysadm 1.4
211 sysadm 1.3 CREATE TABLE `send_pass_log` (
212 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
217 sysadm 1.4
218 sysadm 1.3 CREATE TABLE `upload_file` (
219 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
228 sysadm 1.4
229 sysadm 1.3 CREATE TABLE `user_err_login_log` (
230 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
236 sysadm 1.4
237 sysadm 1.3 CREATE TABLE `user_life_log` (
238 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
245 sysadm 1.4
246 sysadm 1.3 CREATE TABLE `user_list` (
247 sysadm 1.4 `UID` mediumint NOT NULL,
248     `username` varchar(20) NOT NULL DEFAULT '',
249     `password` varchar(64) NOT NULL DEFAULT '',
250 sysadm 1.10 `temp_password` varchar(20) NOT NULL DEFAULT '',
251 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
257 sysadm 1.4
258 sysadm 1.3 CREATE TABLE `user_login_log` (
259 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
264 sysadm 1.4
265 sysadm 1.3 CREATE TABLE `user_modify_email_verify` (
266 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
274 sysadm 1.4
275 sysadm 1.3 CREATE TABLE `user_modify_log` (
276 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
282 sysadm 1.4
283 sysadm 1.3 CREATE TABLE `user_nickname` (
284 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
292 sysadm 1.4
293 sysadm 1.3 CREATE TABLE `user_online` (
294 sysadm 1.4 `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 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
301 sysadm 1.4
302 sysadm 1.3 CREATE TABLE `user_pubinfo` (
303 sysadm 1.4 `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     `sub_permission` tinyint UNSIGNED NOT NULL DEFAULT '1',
321     `upload_limit` int NOT NULL DEFAULT '1048576',
322 sysadm 1.10 `login_notify_dt` datetime DEFAULT NULL
323     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
324 sysadm 1.4
325 sysadm 1.3 CREATE TABLE `user_reginfo` (
326 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
327     `name` varchar(10) DEFAULT NULL,
328     `birthday` datetime DEFAULT NULL,
329     `signup_dt` datetime DEFAULT NULL,
330     `signup_ip` varchar(20) DEFAULT NULL,
331     `memo` mediumtext
332 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
333 sysadm 1.3
334     CREATE TABLE `user_regverify` (
335 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
336     `verify_code` varchar(10) NOT NULL DEFAULT '',
337     `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
338     `set_dt` 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_score` (
342 sysadm 1.4 `UID` mediumint NOT NULL DEFAULT '0',
343     `score` mediumint NOT NULL DEFAULT '0',
344     `last_exp` mediumint NOT NULL DEFAULT '0',
345     `exp_left` mediumint NOT NULL DEFAULT '0'
346 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
347 sysadm 1.4
348 sysadm 1.3 CREATE TABLE `user_score_log` (
349 sysadm 1.4 `ID` mediumint NOT NULL,
350     `UID` mediumint NOT NULL DEFAULT '0',
351     `score_change` mediumint NOT NULL DEFAULT '0',
352     `reason` varchar(50) DEFAULT NULL,
353     `dt` datetime DEFAULT NULL
354 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
355 sysadm 1.4
356 sysadm 1.3 CREATE TABLE `view_article_log` (
357 sysadm 1.4 `AID` int NOT NULL DEFAULT '0',
358     `UID` mediumint NOT NULL DEFAULT '0',
359     `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
360 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
361 sysadm 1.4
362 sysadm 1.3 CREATE TABLE `visit_log` (
363 sysadm 1.4 `VID` int NOT NULL,
364     `dt` datetime DEFAULT NULL,
365     `ip` varchar(20) DEFAULT NULL
366 sysadm 1.10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
367 sysadm 1.4
368 sysadm 1.8
369 sysadm 1.4 ALTER TABLE `admin_config`
370     ADD PRIMARY KEY (`AID`),
371     ADD KEY `UID` (`UID`);
372    
373     ALTER TABLE `ban_user_list`
374     ADD PRIMARY KEY (`BID`),
375     ADD KEY `ban_UID` (`ban_UID`),
376     ADD KEY `SID` (`SID`),
377     ADD KEY `day` (`day`),
378     ADD KEY `UID` (`UID`);
379    
380     ALTER TABLE `bbs`
381     ADD PRIMARY KEY (`AID`),
382     ADD UNIQUE KEY `CID` (`CID`),
383     ADD KEY `UID` (`UID`),
384     ADD KEY `reply_count` (`reply_count`),
385     ADD KEY `last_reply_dt` (`last_reply_dt`),
386     ADD KEY `view_count` (`view_count`),
387     ADD KEY `sub_dt` (`sub_dt`),
388     ADD KEY `title` (`title`(10)),
389     ADD KEY `old_SID` (`old_SID`),
390     ADD KEY `SID` (`SID`),
391     ADD KEY `TID` (`TID`),
392     ADD KEY `last_reply_UID` (`last_reply_UID`);
393    
394     ALTER TABLE `bbs_article_op`
395     ADD PRIMARY KEY (`MID`),
396     ADD KEY `AID` (`AID`),
397     ADD KEY `UID` (`UID`),
398     ADD KEY `type` (`type`);
399    
400     ALTER TABLE `bbs_content`
401     ADD PRIMARY KEY (`CID`),
402     ADD KEY `AID` (`AID`);
403    
404     ALTER TABLE `bbs_ex_dl`
405     ADD PRIMARY KEY (`ID`),
406     ADD UNIQUE KEY `SID` (`SID`),
407     ADD KEY `dl_type` (`dl_type`);
408    
409     ALTER TABLE `bbs_msg`
410     ADD PRIMARY KEY (`MID`),
411     ADD KEY `fromUID` (`fromUID`),
412     ADD KEY `toUID` (`toUID`);
413    
414     ALTER TABLE `email`
415     ADD PRIMARY KEY (`ID`),
416     ADD KEY `complete` (`complete`);
417    
418     ALTER TABLE `ex_dir`
419     ADD PRIMARY KEY (`FID`),
420     ADD KEY `SID` (`SID`),
421     ADD KEY `dir` (`dir`(50));
422    
423     ALTER TABLE `ex_file`
424     ADD PRIMARY KEY (`AID`),
425     ADD KEY `FID` (`FID`);
426    
427     ALTER TABLE `friend_list`
428     ADD PRIMARY KEY (`ID`),
429     ADD KEY `fUID` (`fUID`),
430     ADD KEY `UID` (`UID`);
431    
432     ALTER TABLE `journal_data`
433     ADD PRIMARY KEY (`ID`),
434     ADD UNIQUE KEY `AID` (`AID`),
435     ADD KEY `JID` (`JID`);
436    
437     ALTER TABLE `journal_index`
438     ADD PRIMARY KEY (`JID`);
439    
440     ALTER TABLE `section_class`
441     ADD PRIMARY KEY (`CID`),
442     ADD KEY `sort_order` (`sort_order`);
443    
444     ALTER TABLE `section_class_master`
445     ADD PRIMARY KEY (`MID`),
446     ADD KEY `UID` (`UID`),
447     ADD KEY `CID` (`CID`);
448    
449     ALTER TABLE `section_config`
450     ADD PRIMARY KEY (`SID`),
451     ADD KEY `CID` (`CID`),
452     ADD KEY `write_user_level` (`write_user_level`),
453     ADD KEY `sort_order` (`sort_order`),
454     ADD KEY `read_user_level` (`read_user_level`),
455     ADD KEY `sname` (`sname`);
456    
457     ALTER TABLE `section_favorite`
458     ADD PRIMARY KEY (`ID`),
459     ADD KEY `UID` (`UID`);
460    
461     ALTER TABLE `section_master`
462     ADD PRIMARY KEY (`MID`),
463     ADD KEY `SID` (`SID`),
464     ADD KEY `UID` (`UID`);
465    
466     ALTER TABLE `section_user_priv`
467     ADD PRIMARY KEY (`SID`,`UID`),
468     ADD KEY `UID` (`UID`);
469    
470     ALTER TABLE `send_pass_log`
471     ADD PRIMARY KEY (`ID`),
472     ADD KEY `UID` (`UID`);
473    
474     ALTER TABLE `upload_file`
475     ADD PRIMARY KEY (`AID`),
476     ADD KEY `check` (`check`),
477     ADD KEY `UID` (`UID`),
478     ADD KEY `ref_AID` (`ref_AID`);
479    
480     ALTER TABLE `user_err_login_log`
481     ADD PRIMARY KEY (`ID`),
482     ADD KEY `login_dt` (`login_dt`,`login_ip`);
483    
484     ALTER TABLE `user_life_log`
485     ADD PRIMARY KEY (`ID`),
486     ADD KEY `set_UID` (`set_UID`),
487     ADD KEY `UID` (`UID`);
488    
489     ALTER TABLE `user_list`
490     ADD PRIMARY KEY (`UID`),
491     ADD UNIQUE KEY `username` (`username`),
492     ADD KEY `verified` (`verified`),
493     ADD KEY `enable` (`enable`);
494    
495     ALTER TABLE `user_login_log`
496     ADD PRIMARY KEY (`ID`),
497     ADD KEY `UID` (`UID`),
498     ADD KEY `login_dt` (`login_dt`);
499    
500     ALTER TABLE `user_modify_email_verify`
501     ADD PRIMARY KEY (`MID`),
502     ADD UNIQUE KEY `verify_code` (`verify_code`),
503     ADD KEY `UID` (`UID`),
504     ADD KEY `complete` (`complete`);
505    
506     ALTER TABLE `user_modify_log`
507     ADD PRIMARY KEY (`MID`),
508     ADD KEY `UID` (`UID`);
509    
510     ALTER TABLE `user_nickname`
511     ADD PRIMARY KEY (`NID`),
512     ADD KEY `UID` (`UID`),
513     ADD KEY `nickname` (`nickname`),
514     ADD KEY `begin_dt` (`begin_dt`),
515     ADD KEY `end_dt` (`end_dt`);
516    
517     ALTER TABLE `user_online`
518 sysadm 1.8 ADD PRIMARY KEY (`SID`) USING BTREE,
519 sysadm 1.4 ADD KEY `login_tm` (`login_tm`),
520     ADD KEY `UID` (`UID`),
521 sysadm 1.8 ADD KEY `last_tm` (`last_tm`);
522 sysadm 1.4
523     ALTER TABLE `user_pubinfo`
524     ADD PRIMARY KEY (`UID`),
525     ADD UNIQUE KEY `nickname` (`nickname`),
526     ADD KEY `life` (`life`),
527     ADD KEY `login_notify_dt` (`login_notify_dt`),
528     ADD KEY `exp` (`exp`),
529 sysadm 1.10 ADD KEY `last_login_dt` (`last_login_dt`);
530 sysadm 1.4
531     ALTER TABLE `user_reginfo`
532     ADD PRIMARY KEY (`UID`);
533    
534     ALTER TABLE `user_regverify`
535     ADD PRIMARY KEY (`UID`),
536     ADD UNIQUE KEY `verify_code` (`verify_code`);
537    
538     ALTER TABLE `user_score`
539     ADD PRIMARY KEY (`UID`),
540     ADD KEY `score` (`score`);
541    
542     ALTER TABLE `user_score_log`
543     ADD PRIMARY KEY (`ID`),
544     ADD KEY `UID` (`UID`);
545    
546     ALTER TABLE `view_article_log`
547     ADD PRIMARY KEY (`AID`,`UID`),
548     ADD KEY `dt` (`dt`);
549    
550     ALTER TABLE `visit_log`
551     ADD PRIMARY KEY (`VID`);
552    
553 sysadm 1.8
554 sysadm 1.4 ALTER TABLE `admin_config`
555     MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
556    
557     ALTER TABLE `ban_user_list`
558     MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
559    
560     ALTER TABLE `bbs`
561     MODIFY `AID` int NOT NULL AUTO_INCREMENT;
562    
563     ALTER TABLE `bbs_article_op`
564     MODIFY `MID` int NOT NULL AUTO_INCREMENT;
565    
566     ALTER TABLE `bbs_content`
567     MODIFY `CID` int NOT NULL AUTO_INCREMENT;
568    
569     ALTER TABLE `bbs_ex_dl`
570     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
571    
572     ALTER TABLE `bbs_msg`
573     MODIFY `MID` int NOT NULL AUTO_INCREMENT;
574    
575     ALTER TABLE `email`
576     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
577    
578     ALTER TABLE `ex_dir`
579     MODIFY `FID` mediumint NOT NULL AUTO_INCREMENT;
580    
581     ALTER TABLE `friend_list`
582     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
583    
584     ALTER TABLE `journal_data`
585     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
586    
587     ALTER TABLE `journal_index`
588     MODIFY `JID` smallint NOT NULL AUTO_INCREMENT;
589    
590     ALTER TABLE `section_class`
591     MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;
592    
593     ALTER TABLE `section_class_master`
594     MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
595    
596     ALTER TABLE `section_config`
597     MODIFY `SID` smallint NOT NULL AUTO_INCREMENT;
598    
599     ALTER TABLE `section_favorite`
600     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
601    
602     ALTER TABLE `section_master`
603     MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
604    
605     ALTER TABLE `send_pass_log`
606     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
607    
608     ALTER TABLE `upload_file`
609     MODIFY `AID` mediumint NOT NULL AUTO_INCREMENT;
610    
611     ALTER TABLE `user_err_login_log`
612     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
613    
614     ALTER TABLE `user_life_log`
615     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
616    
617     ALTER TABLE `user_list`
618     MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
619    
620     ALTER TABLE `user_login_log`
621     MODIFY `ID` int NOT NULL AUTO_INCREMENT;
622    
623     ALTER TABLE `user_modify_email_verify`
624     MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
625    
626     ALTER TABLE `user_modify_log`
627     MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
628    
629     ALTER TABLE `user_nickname`
630     MODIFY `NID` mediumint NOT NULL AUTO_INCREMENT;
631    
632     ALTER TABLE `user_score_log`
633     MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
634    
635     ALTER TABLE `visit_log`
636     MODIFY `VID` int NOT NULL AUTO_INCREMENT;
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1