/[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.4 - (show annotations)
Mon Mar 3 06:43:40 2025 UTC (12 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.3: +897 -1029 lines
Content type: application/sql 
Update SQL statements for creating 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
12
13 CREATE TABLE `ban_ip_list` (
14 `BID` smallint NOT NULL,
15 `begin_ip` varchar(20) DEFAULT NULL,
16 `end_ip` varchar(20) DEFAULT NULL,
17 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
19
20 CREATE TABLE `ban_user_list` (
21 `BID` smallint NOT NULL,
22 `SID` smallint NOT NULL DEFAULT '0',
23 `UID` mediumint NOT NULL DEFAULT '0',
24 `day` smallint NOT NULL DEFAULT '0',
25 `ban_UID` mediumint NOT NULL DEFAULT '0',
26 `ban_dt` datetime DEFAULT NULL,
27 `ban_ip` varchar(20) DEFAULT NULL,
28 `unban_UID` mediumint NOT NULL DEFAULT '0',
29 `unban_dt` datetime DEFAULT NULL,
30 `unban_ip` varchar(20) DEFAULT NULL,
31 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
32 `reason` mediumtext
33 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
34
35 CREATE TABLE `bbs` (
36 `AID` int NOT NULL,
37 `SID` smallint NOT NULL DEFAULT '0',
38 `TID` mediumint NOT NULL DEFAULT '0',
39 `UID` mediumint NOT NULL DEFAULT '0',
40 `username` varchar(20) DEFAULT NULL,
41 `nickname` varchar(20) DEFAULT NULL,
42 `title` varchar(80) DEFAULT NULL,
43 `CID` mediumint NOT NULL DEFAULT '0',
44 `sub_dt` datetime DEFAULT NULL,
45 `sub_ip` varchar(20) DEFAULT NULL,
46 `reply_note` tinyint UNSIGNED NOT NULL DEFAULT '0',
47 `visible` tinyint UNSIGNED NOT NULL DEFAULT '1',
48 `view_count` smallint NOT NULL DEFAULT '0',
49 `exp` mediumint NOT NULL DEFAULT '0',
50 `last_reply_dt` datetime DEFAULT NULL,
51 `last_reply_UID` mediumint NOT NULL DEFAULT '0',
52 `last_reply_username` varchar(20) DEFAULT NULL,
53 `last_reply_nickname` varchar(20) DEFAULT NULL,
54 `transship` tinyint UNSIGNED NOT NULL DEFAULT '0',
55 `lock` tinyint UNSIGNED NOT NULL DEFAULT '0',
56 `reply_count` smallint NOT NULL DEFAULT '0',
57 `icon` smallint DEFAULT NULL,
58 `length` mediumint NOT NULL DEFAULT '0',
59 `excerption` tinyint UNSIGNED NOT NULL DEFAULT '0',
60 `ontop` tinyint UNSIGNED NOT NULL DEFAULT '0',
61 `static` tinyint UNSIGNED NOT NULL DEFAULT '0',
62 `cached` tinyint UNSIGNED NOT NULL DEFAULT '0',
63 `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
64 `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
65 `m_del` tinyint UNSIGNED NOT NULL DEFAULT '0',
66 `old_SID` smallint NOT NULL DEFAULT '0',
67 `old_TID` mediumint NOT NULL DEFAULT '0'
68 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
69
70 CREATE TABLE `bbs_article_op` (
71 `MID` int NOT NULL,
72 `AID` int NOT NULL DEFAULT '0',
73 `UID` mediumint NOT NULL DEFAULT '0',
74 `type` char(1) NOT NULL DEFAULT '',
75 `op_dt` datetime DEFAULT NULL,
76 `op_ip` varchar(20) DEFAULT NULL,
77 `complete` tinyint UNSIGNED NOT NULL DEFAULT '1'
78 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
79
80 CREATE TABLE `bbs_content` (
81 `CID` int NOT NULL,
82 `AID` int NOT NULL DEFAULT '0',
83 `content` longtext
84 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
85
86 CREATE TABLE `bbs_ex_dl` (
87 `ID` mediumint NOT NULL,
88 `SID` smallint NOT NULL DEFAULT '0',
89 `url` varchar(255) DEFAULT NULL,
90 `dl_count` mediumint NOT NULL DEFAULT '0',
91 `dl_type` char(1) NOT NULL DEFAULT 'C',
92 `filename` varchar(50) DEFAULT NULL,
93 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
95
96 CREATE TABLE `bbs_msg` (
97 `MID` int NOT NULL,
98 `fromUID` mediumint NOT NULL DEFAULT '0',
99 `toUID` mediumint NOT NULL DEFAULT '0',
100 `content` longtext,
101 `send_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
102 `send_ip` varchar(20) NOT NULL DEFAULT '',
103 `new` tinyint UNSIGNED NOT NULL DEFAULT '1',
104 `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0',
105 `s_deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
106 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
107
108 CREATE TABLE `bbs_prize` (
109 `PID` smallint NOT NULL,
110 `title` varchar(50) DEFAULT NULL,
111 `description` varchar(50) DEFAULT NULL,
112 `score` mediumint NOT NULL DEFAULT '0',
113 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
114 `count_left` mediumint NOT NULL DEFAULT '0'
115 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
116
117 CREATE TABLE `bbs_top_list` (
118 `AID` int NOT NULL DEFAULT '0',
119 `bbs_title` varchar(80) NOT NULL DEFAULT '',
120 `section_title` varchar(20) NOT NULL DEFAULT ''
121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
122
123 CREATE TABLE `email` (
124 `ID` int NOT NULL,
125 `fromemail` varchar(30) DEFAULT NULL,
126 `fromname` varchar(30) DEFAULT NULL,
127 `toemail` varchar(30) DEFAULT NULL,
128 `toname` varchar(30) DEFAULT NULL,
129 `subject` varchar(80) DEFAULT NULL,
130 `body` longtext,
131 `set_dt` datetime DEFAULT NULL,
132 `send_dt` datetime DEFAULT NULL,
133 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
134 `error` tinyint UNSIGNED NOT NULL DEFAULT '0',
135 `error_msg` varchar(255) DEFAULT NULL
136 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
137
138 CREATE TABLE `ex_dir` (
139 `FID` mediumint NOT NULL,
140 `dir` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
141 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
142 `SID` smallint NOT NULL DEFAULT '0',
143 `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
144 `dt` datetime DEFAULT NULL
145 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
146
147 CREATE TABLE `ex_file` (
148 `AID` int NOT NULL DEFAULT '0',
149 `FID` smallint NOT NULL DEFAULT '0'
150 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
151
152 CREATE TABLE `friend_list` (
153 `ID` mediumint NOT NULL,
154 `UID` mediumint NOT NULL DEFAULT '0',
155 `fUID` mediumint NOT NULL DEFAULT '0'
156 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
157
158 CREATE TABLE `journal_data` (
159 `ID` mediumint NOT NULL,
160 `JID` smallint NOT NULL DEFAULT '0',
161 `AID` mediumint NOT NULL DEFAULT '0',
162 `abstract` longtext NOT NULL
163 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
164
165 CREATE TABLE `journal_index` (
166 `JID` smallint NOT NULL,
167 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
168 `enable` tinyint(1) NOT NULL DEFAULT '0'
169 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
170
171 CREATE TABLE `mng_err_login_log` (
172 `ID` int NOT NULL,
173 `username` varchar(14) DEFAULT NULL,
174 `password` varchar(12) DEFAULT NULL,
175 `login_dt` datetime DEFAULT NULL,
176 `login_ip` varchar(20) DEFAULT NULL
177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
178
179 CREATE TABLE `mng_login_log` (
180 `ID` int NOT NULL,
181 `UID` mediumint NOT NULL DEFAULT '0',
182 `login_dt` datetime DEFAULT NULL,
183 `login_ip` varchar(20) DEFAULT NULL
184 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
185
186 CREATE TABLE `mng_priv_list` (
187 `PID` mediumint NOT NULL,
188 `UID` mediumint NOT NULL DEFAULT '0',
189 `ch_passwd` tinyint UNSIGNED NOT NULL DEFAULT '1',
190 `db_cleanup` tinyint UNSIGNED NOT NULL DEFAULT '0',
191 `score_cacl` tinyint UNSIGNED NOT NULL DEFAULT '0',
192 `auth_user_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
193 `section_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
194 `master_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
195 `photo_check` tinyint UNSIGNED NOT NULL DEFAULT '0',
196 `prize_op` tinyint UNSIGNED NOT NULL DEFAULT '0',
197 `article_audit` tinyint UNSIGNED NOT NULL DEFAULT '0',
198 `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
199 `upload_check` tinyint UNSIGNED NOT NULL DEFAULT '0',
200 `article_recommend` tinyint UNSIGNED NOT NULL DEFAULT '0'
201 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
202
203 CREATE TABLE `mng_user_list` (
204 `UID` mediumint NOT NULL,
205 `username` varchar(14) NOT NULL DEFAULT '',
206 `password` varchar(64) NOT NULL DEFAULT '',
207 `enable` tinyint UNSIGNED NOT NULL DEFAULT '0'
208 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
209
210 CREATE TABLE `section_apply_log` (
211 `AID` smallint NOT NULL,
212 `SID` smallint NOT NULL DEFAULT '0',
213 `UID` mediumint NOT NULL DEFAULT '0',
214 `process_dt` datetime DEFAULT NULL,
215 `memo` text
216 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
217
218 CREATE TABLE `section_class` (
219 `CID` smallint NOT NULL,
220 `cname` varchar(20) DEFAULT NULL,
221 `title` varchar(20) DEFAULT NULL,
222 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
223 `sort_order` smallint NOT NULL DEFAULT '10'
224 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
225
226 CREATE TABLE `section_class_master` (
227 `MID` smallint NOT NULL,
228 `CID` smallint NOT NULL DEFAULT '0',
229 `UID` mediumint NOT NULL DEFAULT '0',
230 `begin_dt` datetime DEFAULT NULL,
231 `end_dt` datetime DEFAULT NULL,
232 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
233 `memo` text,
234 `major` tinyint UNSIGNED NOT NULL DEFAULT '0'
235 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
236
237 CREATE TABLE `section_config` (
238 `SID` smallint NOT NULL,
239 `sname` varchar(20) DEFAULT NULL,
240 `CID` smallint NOT NULL DEFAULT '0',
241 `title` varchar(20) DEFAULT NULL,
242 `comment` varchar(255) DEFAULT NULL,
243 `topic_max_count` smallint NOT NULL DEFAULT '0',
244 `announcement` longtext,
245 `bgsound` smallint NOT NULL DEFAULT '0',
246 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
247 `exp_get` tinyint UNSIGNED NOT NULL DEFAULT '0',
248 `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
249 `transship_ratio` float NOT NULL DEFAULT '0.5',
250 `set_UID` mediumint DEFAULT '0',
251 `set_dt` datetime DEFAULT NULL,
252 `set_ip` varchar(20) DEFAULT NULL,
253 `sort_order` smallint NOT NULL DEFAULT '10',
254 `ex_gen_tm` datetime DEFAULT NULL,
255 `ex_pack_tm` datetime DEFAULT NULL,
256 `ex_update` tinyint UNSIGNED NOT NULL DEFAULT '0',
257 `read_user_level` smallint NOT NULL DEFAULT '0',
258 `write_user_level` smallint NOT NULL DEFAULT '0'
259 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
260
261 CREATE TABLE `section_favorite` (
262 `ID` int NOT NULL,
263 `UID` mediumint NOT NULL DEFAULT '0',
264 `SID` smallint NOT NULL DEFAULT '0'
265 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
266
267 CREATE TABLE `section_master` (
268 `MID` smallint NOT NULL,
269 `SID` smallint NOT NULL DEFAULT '0',
270 `UID` mediumint NOT NULL DEFAULT '0',
271 `begin_dt` datetime DEFAULT NULL,
272 `end_dt` datetime DEFAULT NULL,
273 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
274 `major` tinyint UNSIGNED NOT NULL DEFAULT '0',
275 `formal` tinyint UNSIGNED NOT NULL DEFAULT '0',
276 `memo` text
277 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
278
279 CREATE TABLE `section_master_apply` (
280 `AID` smallint NOT NULL,
281 `SID` smallint NOT NULL DEFAULT '0',
282 `UID` mediumint NOT NULL DEFAULT '0',
283 `apply_dt` datetime DEFAULT NULL,
284 `process` tinyint UNSIGNED NOT NULL DEFAULT '0',
285 `process_dt` datetime DEFAULT NULL,
286 `permit` tinyint UNSIGNED NOT NULL DEFAULT '0',
287 `major` tinyint UNSIGNED NOT NULL DEFAULT '0',
288 `memo` text
289 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
290
291 CREATE TABLE `section_user_priv` (
292 `SID` smallint NOT NULL DEFAULT '0',
293 `UID` mediumint NOT NULL DEFAULT '0',
294 `read` tinyint UNSIGNED NOT NULL DEFAULT '0',
295 `write` tinyint UNSIGNED NOT NULL DEFAULT '0'
296 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
297
298 CREATE TABLE `send_pass_log` (
299 `ID` mediumint NOT NULL,
300 `UID` mediumint NOT NULL DEFAULT '0',
301 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
302 `ip` varchar(20) NOT NULL DEFAULT ''
303 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
304
305 CREATE TABLE `upload_file` (
306 `AID` mediumint NOT NULL,
307 `ref_AID` mediumint NOT NULL DEFAULT '0',
308 `UID` mediumint NOT NULL DEFAULT '0',
309 `size` mediumint NOT NULL DEFAULT '0',
310 `filename` varchar(255) NOT NULL DEFAULT '',
311 `check` tinyint UNSIGNED NOT NULL DEFAULT '0',
312 `deny` tinyint UNSIGNED NOT NULL DEFAULT '0',
313 `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
314 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
315
316 CREATE TABLE `user_auth` (
317 `AUID` mediumint NOT NULL,
318 `UID` mediumint NOT NULL DEFAULT '0',
319 `pid` varchar(18) DEFAULT NULL,
320 `name` varchar(10) DEFAULT NULL,
321 `email` varchar(30) DEFAULT NULL,
322 `expire_dt` datetime DEFAULT NULL,
323 `photo_enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
324 `photo_ext` varchar(5) NOT NULL DEFAULT '',
325 `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
326 `process` tinyint UNSIGNED NOT NULL DEFAULT '0',
327 `auth_type` enum('PID','EMAIL','TRUST','SCORE') NOT NULL DEFAULT 'TRUST'
328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
329
330 CREATE TABLE `user_err_login_log` (
331 `ID` int NOT NULL,
332 `username` varchar(14) DEFAULT NULL,
333 `password` varchar(12) DEFAULT NULL,
334 `login_dt` datetime DEFAULT NULL,
335 `login_ip` varchar(20) DEFAULT NULL
336 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
337
338 CREATE TABLE `user_life_log` (
339 `ID` mediumint NOT NULL,
340 `UID` mediumint NOT NULL DEFAULT '0',
341 `set_UID` mediumint NOT NULL DEFAULT '0',
342 `life` smallint NOT NULL DEFAULT '0',
343 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
344 `ip` varchar(20) NOT NULL DEFAULT ''
345 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
346
347 CREATE TABLE `user_list` (
348 `UID` mediumint NOT NULL,
349 `username` varchar(20) NOT NULL DEFAULT '',
350 `password` varchar(64) NOT NULL DEFAULT '',
351 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
352 `verified` tinyint UNSIGNED NOT NULL DEFAULT '0',
353 `p_login` tinyint UNSIGNED NOT NULL DEFAULT '1',
354 `p_post` tinyint UNSIGNED NOT NULL DEFAULT '1',
355 `p_msg` tinyint UNSIGNED NOT NULL DEFAULT '1'
356 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
357
358 CREATE TABLE `user_login_log` (
359 `ID` int NOT NULL,
360 `UID` mediumint NOT NULL DEFAULT '0',
361 `login_dt` datetime DEFAULT NULL,
362 `login_ip` varchar(20) DEFAULT NULL
363 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
364
365 CREATE TABLE `user_modify_email_verify` (
366 `MID` mediumint NOT NULL,
367 `UID` mediumint NOT NULL DEFAULT '0',
368 `email` varchar(30) DEFAULT NULL,
369 `verify_code` varchar(10) NOT NULL DEFAULT '',
370 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
371 `dt` datetime DEFAULT NULL,
372 `ip` varchar(20) DEFAULT NULL
373 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
374
375 CREATE TABLE `user_modify_log` (
376 `MID` mediumint NOT NULL,
377 `UID` mediumint NOT NULL DEFAULT '0',
378 `modify_dt` datetime DEFAULT NULL,
379 `modify_ip` varchar(20) DEFAULT NULL,
380 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0'
381 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
382
383 CREATE TABLE `user_nickname` (
384 `NID` mediumint NOT NULL,
385 `UID` mediumint NOT NULL DEFAULT '0',
386 `nickname` varchar(20) NOT NULL DEFAULT '',
387 `begin_dt` datetime DEFAULT NULL,
388 `begin_reason` char(1) DEFAULT NULL,
389 `end_dt` datetime DEFAULT NULL,
390 `end_reason` char(1) DEFAULT NULL
391 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
392
393 CREATE TABLE `user_online` (
394 `ID` int NOT NULL,
395 `SID` varchar(32) NOT NULL DEFAULT '',
396 `UID` mediumint NOT NULL DEFAULT '0',
397 `ip` varchar(20) NOT NULL DEFAULT '',
398 `current_SID` smallint NOT NULL DEFAULT '0',
399 `current_action` varchar(20) NOT NULL DEFAULT '',
400 `login_tm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
401 `last_tm` datetime DEFAULT NULL
402 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
403
404 CREATE TABLE `user_prize` (
405 `ID` mediumint NOT NULL,
406 `UID` mediumint NOT NULL DEFAULT '0',
407 `PID` smallint NOT NULL DEFAULT '0',
408 `dt` datetime DEFAULT NULL,
409 `ip` varchar(20) DEFAULT NULL,
410 `process` tinyint UNSIGNED NOT NULL DEFAULT '0',
411 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0'
412 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
413
414 CREATE TABLE `user_pubinfo` (
415 `UID` mediumint NOT NULL DEFAULT '0',
416 `nickname` varchar(20) DEFAULT NULL,
417 `email` varchar(30) DEFAULT NULL,
418 `gender` char(1) NOT NULL DEFAULT 'M',
419 `qq` varchar(10) DEFAULT NULL,
420 `msn` varchar(30) DEFAULT NULL,
421 `homepage` varchar(80) DEFAULT NULL,
422 `introduction` mediumtext,
423 `photo` smallint DEFAULT '0',
424 `photo_enable` tinyint(1) NOT NULL DEFAULT '0',
425 `photo_ext` varchar(5) NOT NULL DEFAULT '',
426 `life` smallint NOT NULL DEFAULT '15',
427 `exp` mediumint DEFAULT '0',
428 `visit_count` mediumint NOT NULL DEFAULT '0',
429 `email_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
430 `qq_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
431 `msn_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
432 `homepage_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
433 `gender_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
434 `last_login_dt` datetime DEFAULT NULL,
435 `sign_1` mediumtext,
436 `sign_2` mediumtext,
437 `sign_3` mediumtext,
438 `sub_permission` tinyint UNSIGNED NOT NULL DEFAULT '1',
439 `upload_limit` int NOT NULL DEFAULT '1048576',
440 `login_notify_dt` datetime DEFAULT NULL,
441 `subscribe_jid` smallint NOT NULL DEFAULT '-1',
442 `bgsound` tinyint(1) NOT NULL DEFAULT '1'
443 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
444
445 CREATE TABLE `user_reginfo` (
446 `UID` mediumint NOT NULL DEFAULT '0',
447 `name` varchar(10) DEFAULT NULL,
448 `birthday` datetime DEFAULT NULL,
449 `address` varchar(80) DEFAULT NULL,
450 `tel` varchar(20) DEFAULT NULL,
451 `postcode` varchar(6) DEFAULT NULL,
452 `pid` varchar(18) DEFAULT NULL,
453 `country` varchar(10) DEFAULT NULL,
454 `province` varchar(10) DEFAULT NULL,
455 `city` varchar(10) DEFAULT NULL,
456 `signup_dt` datetime DEFAULT NULL,
457 `signup_ip` varchar(20) DEFAULT NULL,
458 `memo` mediumtext
459 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
460
461 CREATE TABLE `user_reginfo_log` (
462 `ID` mediumint NOT NULL,
463 `UID` mediumint NOT NULL DEFAULT '0',
464 `name` varchar(10) DEFAULT NULL,
465 `birthday` date DEFAULT NULL,
466 `address` varchar(80) DEFAULT NULL,
467 `tel` varchar(20) DEFAULT NULL,
468 `postcode` varchar(6) DEFAULT NULL,
469 `pid` varchar(18) DEFAULT NULL,
470 `country` varchar(10) DEFAULT NULL,
471 `province` varchar(10) DEFAULT NULL,
472 `city` varchar(10) DEFAULT NULL
473 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
474
475 CREATE TABLE `user_regverify` (
476 `UID` mediumint NOT NULL DEFAULT '0',
477 `verify_code` varchar(10) NOT NULL DEFAULT '',
478 `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
479 `set_dt` datetime DEFAULT NULL
480 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
481
482 CREATE TABLE `user_relation` (
483 `RID` mediumint NOT NULL,
484 `pUID` mediumint NOT NULL DEFAULT '0',
485 `cUID` mediumint NOT NULL DEFAULT '0',
486 `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
487 `last_exp` mediumint NOT NULL DEFAULT '0'
488 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
489
490 CREATE TABLE `user_score` (
491 `UID` mediumint NOT NULL DEFAULT '0',
492 `score` mediumint NOT NULL DEFAULT '0',
493 `last_exp` mediumint NOT NULL DEFAULT '0',
494 `exp_left` mediumint NOT NULL DEFAULT '0'
495 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
496
497 CREATE TABLE `user_score_log` (
498 `ID` mediumint NOT NULL,
499 `UID` mediumint NOT NULL DEFAULT '0',
500 `score_change` mediumint NOT NULL DEFAULT '0',
501 `reason` varchar(50) DEFAULT NULL,
502 `dt` datetime DEFAULT NULL
503 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
504
505 CREATE TABLE `user_switch_list` (
506 `ID` mediumint NOT NULL,
507 `UID` mediumint NOT NULL DEFAULT '0',
508 `tUID` mediumint NOT NULL DEFAULT '0'
509 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
510
511 CREATE TABLE `user_trust_log` (
512 `ID` mediumint NOT NULL,
513 `UID` mediumint NOT NULL DEFAULT '0',
514 `tUID` mediumint NOT NULL DEFAULT '0'
515 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
516
517 CREATE TABLE `view_article_log` (
518 `AID` int NOT NULL DEFAULT '0',
519 `UID` mediumint NOT NULL DEFAULT '0',
520 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
521 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
522
523 CREATE TABLE `visit_log` (
524 `VID` int NOT NULL,
525 `dt` datetime DEFAULT NULL,
526 `ip` varchar(20) DEFAULT NULL
527 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
528
529 CREATE TABLE `vote_answer` (
530 `AID` smallint NOT NULL,
531 `VID` smallint NOT NULL DEFAULT '0',
532 `answer` varchar(100) DEFAULT NULL,
533 `count` smallint NOT NULL DEFAULT '0'
534 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
535
536 CREATE TABLE `vote_config` (
537 `VID` smallint NOT NULL,
538 `title` varchar(20) DEFAULT NULL,
539 `question` varchar(100) DEFAULT NULL,
540 `begin_dt` datetime DEFAULT NULL,
541 `end_dt` datetime DEFAULT NULL,
542 `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
543 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
544
545 CREATE TABLE `vote_log` (
546 `ID` mediumint NOT NULL,
547 `UID` mediumint NOT NULL DEFAULT '0',
548 `VID` smallint NOT NULL DEFAULT '0',
549 `AID` smallint NOT NULL DEFAULT '0',
550 `vote_dt` datetime DEFAULT NULL,
551 `vote_ip` varchar(20) DEFAULT NULL
552 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
553
554
555 ALTER TABLE `admin_config`
556 ADD PRIMARY KEY (`AID`),
557 ADD KEY `UID` (`UID`);
558
559 ALTER TABLE `ban_ip_list`
560 ADD PRIMARY KEY (`BID`);
561
562 ALTER TABLE `ban_user_list`
563 ADD PRIMARY KEY (`BID`),
564 ADD KEY `ban_UID` (`ban_UID`),
565 ADD KEY `SID` (`SID`),
566 ADD KEY `day` (`day`),
567 ADD KEY `UID` (`UID`);
568
569 ALTER TABLE `bbs`
570 ADD PRIMARY KEY (`AID`),
571 ADD UNIQUE KEY `CID` (`CID`),
572 ADD KEY `UID` (`UID`),
573 ADD KEY `reply_count` (`reply_count`),
574 ADD KEY `last_reply_dt` (`last_reply_dt`),
575 ADD KEY `view_count` (`view_count`),
576 ADD KEY `sub_dt` (`sub_dt`),
577 ADD KEY `title` (`title`(10)),
578 ADD KEY `old_SID` (`old_SID`),
579 ADD KEY `SID` (`SID`),
580 ADD KEY `old_TID` (`old_TID`),
581 ADD KEY `TID` (`TID`),
582 ADD KEY `last_reply_UID` (`last_reply_UID`);
583
584 ALTER TABLE `bbs_article_op`
585 ADD PRIMARY KEY (`MID`),
586 ADD KEY `AID` (`AID`),
587 ADD KEY `UID` (`UID`),
588 ADD KEY `type` (`type`);
589
590 ALTER TABLE `bbs_content`
591 ADD PRIMARY KEY (`CID`),
592 ADD KEY `AID` (`AID`);
593
594 ALTER TABLE `bbs_ex_dl`
595 ADD PRIMARY KEY (`ID`),
596 ADD UNIQUE KEY `SID` (`SID`),
597 ADD KEY `dl_type` (`dl_type`);
598
599 ALTER TABLE `bbs_msg`
600 ADD PRIMARY KEY (`MID`),
601 ADD KEY `fromUID` (`fromUID`),
602 ADD KEY `toUID` (`toUID`);
603
604 ALTER TABLE `bbs_prize`
605 ADD PRIMARY KEY (`PID`);
606
607 ALTER TABLE `email`
608 ADD PRIMARY KEY (`ID`),
609 ADD KEY `complete` (`complete`);
610
611 ALTER TABLE `ex_dir`
612 ADD PRIMARY KEY (`FID`),
613 ADD KEY `SID` (`SID`),
614 ADD KEY `dir` (`dir`(50));
615
616 ALTER TABLE `ex_file`
617 ADD PRIMARY KEY (`AID`),
618 ADD KEY `FID` (`FID`);
619
620 ALTER TABLE `friend_list`
621 ADD PRIMARY KEY (`ID`),
622 ADD KEY `fUID` (`fUID`),
623 ADD KEY `UID` (`UID`);
624
625 ALTER TABLE `journal_data`
626 ADD PRIMARY KEY (`ID`),
627 ADD UNIQUE KEY `AID` (`AID`),
628 ADD KEY `JID` (`JID`);
629
630 ALTER TABLE `journal_index`
631 ADD PRIMARY KEY (`JID`);
632
633 ALTER TABLE `mng_err_login_log`
634 ADD PRIMARY KEY (`ID`);
635
636 ALTER TABLE `mng_login_log`
637 ADD PRIMARY KEY (`ID`),
638 ADD KEY `UID` (`UID`),
639 ADD KEY `login_dt` (`login_dt`);
640
641 ALTER TABLE `mng_priv_list`
642 ADD PRIMARY KEY (`PID`),
643 ADD UNIQUE KEY `UID` (`UID`);
644
645 ALTER TABLE `mng_user_list`
646 ADD PRIMARY KEY (`UID`),
647 ADD UNIQUE KEY `username` (`username`);
648
649 ALTER TABLE `section_apply_log`
650 ADD PRIMARY KEY (`AID`);
651
652 ALTER TABLE `section_class`
653 ADD PRIMARY KEY (`CID`),
654 ADD KEY `sort_order` (`sort_order`);
655
656 ALTER TABLE `section_class_master`
657 ADD PRIMARY KEY (`MID`),
658 ADD KEY `UID` (`UID`),
659 ADD KEY `CID` (`CID`);
660
661 ALTER TABLE `section_config`
662 ADD PRIMARY KEY (`SID`),
663 ADD KEY `CID` (`CID`),
664 ADD KEY `write_user_level` (`write_user_level`),
665 ADD KEY `sort_order` (`sort_order`),
666 ADD KEY `read_user_level` (`read_user_level`),
667 ADD KEY `sname` (`sname`);
668
669 ALTER TABLE `section_favorite`
670 ADD PRIMARY KEY (`ID`),
671 ADD KEY `UID` (`UID`);
672
673 ALTER TABLE `section_master`
674 ADD PRIMARY KEY (`MID`),
675 ADD KEY `SID` (`SID`),
676 ADD KEY `UID` (`UID`);
677
678 ALTER TABLE `section_master_apply`
679 ADD PRIMARY KEY (`AID`);
680
681 ALTER TABLE `section_user_priv`
682 ADD PRIMARY KEY (`SID`,`UID`),
683 ADD KEY `UID` (`UID`);
684
685 ALTER TABLE `send_pass_log`
686 ADD PRIMARY KEY (`ID`),
687 ADD KEY `UID` (`UID`);
688
689 ALTER TABLE `upload_file`
690 ADD PRIMARY KEY (`AID`),
691 ADD KEY `check` (`check`),
692 ADD KEY `UID` (`UID`),
693 ADD KEY `ref_AID` (`ref_AID`);
694
695 ALTER TABLE `user_auth`
696 ADD PRIMARY KEY (`AUID`),
697 ADD KEY `UID` (`UID`),
698 ADD KEY `expire_dt` (`expire_dt`),
699 ADD KEY `auth_type` (`auth_type`);
700
701 ALTER TABLE `user_err_login_log`
702 ADD PRIMARY KEY (`ID`),
703 ADD KEY `login_dt` (`login_dt`,`login_ip`);
704
705 ALTER TABLE `user_life_log`
706 ADD PRIMARY KEY (`ID`),
707 ADD KEY `set_UID` (`set_UID`),
708 ADD KEY `UID` (`UID`);
709
710 ALTER TABLE `user_list`
711 ADD PRIMARY KEY (`UID`),
712 ADD UNIQUE KEY `username` (`username`),
713 ADD KEY `verified` (`verified`),
714 ADD KEY `enable` (`enable`);
715
716 ALTER TABLE `user_login_log`
717 ADD PRIMARY KEY (`ID`),
718 ADD KEY `UID` (`UID`),
719 ADD KEY `login_dt` (`login_dt`);
720
721 ALTER TABLE `user_modify_email_verify`
722 ADD PRIMARY KEY (`MID`),
723 ADD UNIQUE KEY `verify_code` (`verify_code`),
724 ADD KEY `UID` (`UID`),
725 ADD KEY `complete` (`complete`);
726
727 ALTER TABLE `user_modify_log`
728 ADD PRIMARY KEY (`MID`),
729 ADD KEY `UID` (`UID`);
730
731 ALTER TABLE `user_nickname`
732 ADD PRIMARY KEY (`NID`),
733 ADD KEY `UID` (`UID`),
734 ADD KEY `nickname` (`nickname`),
735 ADD KEY `begin_dt` (`begin_dt`),
736 ADD KEY `end_dt` (`end_dt`);
737
738 ALTER TABLE `user_online`
739 ADD PRIMARY KEY (`ID`),
740 ADD KEY `login_tm` (`login_tm`),
741 ADD KEY `UID` (`UID`),
742 ADD KEY `last_tm` (`last_tm`),
743 ADD KEY `SID` (`SID`);
744
745 ALTER TABLE `user_prize`
746 ADD PRIMARY KEY (`ID`),
747 ADD KEY `UID` (`UID`),
748 ADD KEY `PID` (`PID`),
749 ADD KEY `process` (`process`);
750
751 ALTER TABLE `user_pubinfo`
752 ADD PRIMARY KEY (`UID`),
753 ADD UNIQUE KEY `nickname` (`nickname`),
754 ADD KEY `life` (`life`),
755 ADD KEY `login_notify_dt` (`login_notify_dt`),
756 ADD KEY `exp` (`exp`),
757 ADD KEY `last_login_dt` (`last_login_dt`),
758 ADD KEY `subscribe_jid` (`subscribe_jid`);
759
760 ALTER TABLE `user_reginfo`
761 ADD PRIMARY KEY (`UID`);
762
763 ALTER TABLE `user_reginfo_log`
764 ADD PRIMARY KEY (`ID`),
765 ADD KEY `UID` (`UID`);
766
767 ALTER TABLE `user_regverify`
768 ADD PRIMARY KEY (`UID`),
769 ADD UNIQUE KEY `verify_code` (`verify_code`);
770
771 ALTER TABLE `user_relation`
772 ADD PRIMARY KEY (`RID`),
773 ADD UNIQUE KEY `cUID` (`cUID`),
774 ADD KEY `pUID` (`pUID`);
775
776 ALTER TABLE `user_score`
777 ADD PRIMARY KEY (`UID`),
778 ADD KEY `score` (`score`);
779
780 ALTER TABLE `user_score_log`
781 ADD PRIMARY KEY (`ID`),
782 ADD KEY `UID` (`UID`);
783
784 ALTER TABLE `user_switch_list`
785 ADD PRIMARY KEY (`ID`),
786 ADD KEY `tUID` (`tUID`),
787 ADD KEY `UID` (`UID`);
788
789 ALTER TABLE `user_trust_log`
790 ADD PRIMARY KEY (`ID`),
791 ADD KEY `tUID` (`tUID`),
792 ADD KEY `UID` (`UID`);
793
794 ALTER TABLE `view_article_log`
795 ADD PRIMARY KEY (`AID`,`UID`),
796 ADD KEY `dt` (`dt`);
797
798 ALTER TABLE `visit_log`
799 ADD PRIMARY KEY (`VID`);
800
801 ALTER TABLE `vote_answer`
802 ADD PRIMARY KEY (`AID`),
803 ADD KEY `VID` (`VID`);
804
805 ALTER TABLE `vote_config`
806 ADD PRIMARY KEY (`VID`),
807 ADD KEY `begin_dt` (`begin_dt`),
808 ADD KEY `end_dt` (`end_dt`);
809
810 ALTER TABLE `vote_log`
811 ADD PRIMARY KEY (`ID`),
812 ADD KEY `UID` (`UID`),
813 ADD KEY `VID` (`VID`),
814 ADD KEY `AID` (`AID`);
815
816
817 ALTER TABLE `admin_config`
818 MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
819
820 ALTER TABLE `ban_ip_list`
821 MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
822
823 ALTER TABLE `ban_user_list`
824 MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
825
826 ALTER TABLE `bbs`
827 MODIFY `AID` int NOT NULL AUTO_INCREMENT;
828
829 ALTER TABLE `bbs_article_op`
830 MODIFY `MID` int NOT NULL AUTO_INCREMENT;
831
832 ALTER TABLE `bbs_content`
833 MODIFY `CID` int NOT NULL AUTO_INCREMENT;
834
835 ALTER TABLE `bbs_ex_dl`
836 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
837
838 ALTER TABLE `bbs_msg`
839 MODIFY `MID` int NOT NULL AUTO_INCREMENT;
840
841 ALTER TABLE `bbs_prize`
842 MODIFY `PID` smallint NOT NULL AUTO_INCREMENT;
843
844 ALTER TABLE `email`
845 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
846
847 ALTER TABLE `ex_dir`
848 MODIFY `FID` mediumint NOT NULL AUTO_INCREMENT;
849
850 ALTER TABLE `friend_list`
851 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
852
853 ALTER TABLE `journal_data`
854 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
855
856 ALTER TABLE `journal_index`
857 MODIFY `JID` smallint NOT NULL AUTO_INCREMENT;
858
859 ALTER TABLE `mng_err_login_log`
860 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
861
862 ALTER TABLE `mng_login_log`
863 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
864
865 ALTER TABLE `mng_priv_list`
866 MODIFY `PID` mediumint NOT NULL AUTO_INCREMENT;
867
868 ALTER TABLE `mng_user_list`
869 MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
870
871 ALTER TABLE `section_apply_log`
872 MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
873
874 ALTER TABLE `section_class`
875 MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;
876
877 ALTER TABLE `section_class_master`
878 MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
879
880 ALTER TABLE `section_config`
881 MODIFY `SID` smallint NOT NULL AUTO_INCREMENT;
882
883 ALTER TABLE `section_favorite`
884 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
885
886 ALTER TABLE `section_master`
887 MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
888
889 ALTER TABLE `section_master_apply`
890 MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
891
892 ALTER TABLE `send_pass_log`
893 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
894
895 ALTER TABLE `upload_file`
896 MODIFY `AID` mediumint NOT NULL AUTO_INCREMENT;
897
898 ALTER TABLE `user_auth`
899 MODIFY `AUID` mediumint NOT NULL AUTO_INCREMENT;
900
901 ALTER TABLE `user_err_login_log`
902 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
903
904 ALTER TABLE `user_life_log`
905 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
906
907 ALTER TABLE `user_list`
908 MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
909
910 ALTER TABLE `user_login_log`
911 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
912
913 ALTER TABLE `user_modify_email_verify`
914 MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
915
916 ALTER TABLE `user_modify_log`
917 MODIFY `MID` mediumint NOT NULL AUTO_INCREMENT;
918
919 ALTER TABLE `user_nickname`
920 MODIFY `NID` mediumint NOT NULL AUTO_INCREMENT;
921
922 ALTER TABLE `user_online`
923 MODIFY `ID` int NOT NULL AUTO_INCREMENT;
924
925 ALTER TABLE `user_prize`
926 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
927
928 ALTER TABLE `user_reginfo_log`
929 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
930
931 ALTER TABLE `user_relation`
932 MODIFY `RID` mediumint NOT NULL AUTO_INCREMENT;
933
934 ALTER TABLE `user_score_log`
935 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
936
937 ALTER TABLE `user_switch_list`
938 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
939
940 ALTER TABLE `user_trust_log`
941 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
942
943 ALTER TABLE `visit_log`
944 MODIFY `VID` int NOT NULL AUTO_INCREMENT;
945
946 ALTER TABLE `vote_answer`
947 MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
948
949 ALTER TABLE `vote_config`
950 MODIFY `VID` smallint NOT NULL AUTO_INCREMENT;
951
952 ALTER TABLE `vote_log`
953 MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1