/[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.2 - (hide annotations)
Tue Sep 27 15:08:12 2005 UTC (20 years, 5 months ago) by sysadm
Branch: MAIN
CVS Tags: fenglin_1-0-0-0_MIL
Changes since 1.1: +139 -224 lines
Content type: application/sql 
no message
1 sysadm 1.1 # Host: localhost
2     # Database: leafok
3     # Table: 'admin_config'
4     #
5     CREATE TABLE `admin_config` (
6     `AID` smallint(6) NOT NULL auto_increment,
7     `UID` mediumint(9) NOT NULL default '0',
8     `begin_dt` datetime default NULL,
9     `end_dt` datetime default NULL,
10     `enable` tinyint(1) unsigned NOT NULL default '1',
11     `major` tinyint(1) unsigned NOT NULL default '0',
12     PRIMARY KEY (`AID`),
13 sysadm 1.2 KEY `UID` (`UID`)
14     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
15 sysadm 1.1
16     # Host: localhost
17     # Database: leafok
18     # Table: 'ban_ip_list'
19     #
20     CREATE TABLE `ban_ip_list` (
21     `BID` smallint(6) NOT NULL auto_increment,
22     `begin_ip` varchar(20) default NULL,
23     `end_ip` varchar(20) default NULL,
24     `enable` tinyint(1) unsigned NOT NULL default '1',
25 sysadm 1.2 PRIMARY KEY (`BID`)
26     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
27 sysadm 1.1
28     # Host: localhost
29     # Database: leafok
30     # Table: 'ban_user_list'
31     #
32     CREATE TABLE `ban_user_list` (
33     `BID` smallint(6) NOT NULL auto_increment,
34     `SID` smallint(6) NOT NULL default '0',
35     `UID` mediumint(9) NOT NULL default '0',
36     `day` smallint(6) NOT NULL default '0',
37     `ban_UID` mediumint(9) NOT NULL default '0',
38     `ban_dt` datetime default NULL,
39     `ban_ip` varchar(20) default NULL,
40     `unban_UID` mediumint(9) NOT NULL default '0',
41     `unban_dt` datetime default NULL,
42     `unban_ip` varchar(20) default NULL,
43     `enable` tinyint(1) unsigned NOT NULL default '1',
44     `reason` text,
45     PRIMARY KEY (`BID`),
46 sysadm 1.2 KEY `ban_UID` (`ban_UID`),
47     KEY `SID` (`SID`),
48 sysadm 1.1 KEY `day` (`day`),
49 sysadm 1.2 KEY `UID` (`UID`)
50     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
51 sysadm 1.1
52     # Host: localhost
53     # Database: leafok
54     # Table: 'bbs'
55     #
56     CREATE TABLE `bbs` (
57     `AID` mediumint(9) NOT NULL auto_increment,
58     `SID` smallint(6) NOT NULL default '0',
59     `TID` mediumint(9) NOT NULL default '0',
60     `UID` mediumint(9) NOT NULL default '0',
61 sysadm 1.2 `username` varchar(20) default '',
62 sysadm 1.1 `nickname` varchar(20) default NULL,
63     `title` varchar(80) default NULL,
64     `CID` mediumint(9) NOT NULL default '0',
65     `sub_dt` datetime default NULL,
66     `sub_ip` varchar(20) default NULL,
67     `reply_note` tinyint(1) unsigned NOT NULL default '0',
68     `visible` tinyint(1) unsigned NOT NULL default '1',
69     `view_count` smallint(6) NOT NULL default '0',
70     `exp` mediumint(9) NOT NULL default '0',
71     `last_reply_dt` datetime default NULL,
72     `last_reply_UID` mediumint(9) NOT NULL default '0',
73 sysadm 1.2 `last_reply_username` varchar(20) default '',
74 sysadm 1.1 `last_reply_nickname` varchar(20) default NULL,
75     `transship` tinyint(1) unsigned NOT NULL default '0',
76     `lock` tinyint(1) unsigned NOT NULL default '0',
77     `reply_count` smallint(6) NOT NULL default '0',
78     `icon` smallint(6) default NULL,
79     `length` mediumint(9) NOT NULL default '0',
80     `excerption` tinyint(1) unsigned NOT NULL default '0',
81     `ontop` tinyint(1) unsigned NOT NULL default '0',
82     `static` tinyint(1) unsigned NOT NULL default '0',
83 sysadm 1.2 `cached` tinyint(3) unsigned NOT NULL default '0',
84 sysadm 1.1 `recommend` tinyint(1) unsigned NOT NULL default '0',
85 sysadm 1.2 `gen_ex` tinyint(1) unsigned NOT NULL default '0',
86     `m_del` tinyint(1) unsigned NOT NULL default '0',
87 sysadm 1.1 `old_SID` smallint(6) NOT NULL default '0',
88     `old_TID` mediumint(9) NOT NULL default '0',
89     PRIMARY KEY (`AID`),
90     UNIQUE KEY `CID` (`CID`),
91 sysadm 1.2 KEY `UID` (`UID`),
92     KEY `reply_count` (`reply_count`),
93 sysadm 1.1 KEY `last_reply_dt` (`last_reply_dt`),
94 sysadm 1.2 KEY `view_count` (`view_count`),
95 sysadm 1.1 KEY `sub_dt` (`sub_dt`),
96 sysadm 1.2 KEY `title` (`title`(10)),
97 sysadm 1.1 KEY `old_SID` (`old_SID`),
98 sysadm 1.2 KEY `SID` (`SID`),
99 sysadm 1.1 KEY `old_TID` (`old_TID`),
100 sysadm 1.2 KEY `TID` (`TID`),
101     KEY `last_reply_UID` (`last_reply_UID`)
102     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
103 sysadm 1.1
104     # Host: localhost
105     # Database: leafok
106     # Table: 'bbs_article_op'
107     #
108     CREATE TABLE `bbs_article_op` (
109     `MID` mediumint(9) NOT NULL auto_increment,
110     `AID` mediumint(9) NOT NULL default '0',
111     `UID` mediumint(9) NOT NULL default '0',
112     `type` char(1) NOT NULL default '',
113     `op_dt` datetime default NULL,
114     `op_ip` varchar(20) default NULL,
115 sysadm 1.2 `complete` tinyint(1) unsigned NOT NULL default '1',
116 sysadm 1.1 PRIMARY KEY (`MID`),
117 sysadm 1.2 KEY `AID` (`AID`),
118 sysadm 1.1 KEY `UID` (`UID`),
119 sysadm 1.2 KEY `type` (`type`)
120     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
121 sysadm 1.1
122     # Host: localhost
123     # Database: leafok
124     # Table: 'bbs_content'
125     #
126     CREATE TABLE `bbs_content` (
127     `CID` mediumint(9) NOT NULL auto_increment,
128     `AID` mediumint(9) NOT NULL default '0',
129     `content` longtext,
130     PRIMARY KEY (`CID`),
131     KEY `AID` (`AID`)
132 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
133 sysadm 1.1
134     # Host: localhost
135     # Database: leafok
136     # Table: 'bbs_ex_dl'
137     #
138     CREATE TABLE `bbs_ex_dl` (
139     `ID` mediumint(9) NOT NULL auto_increment,
140     `SID` smallint(6) NOT NULL default '0',
141     `url` varchar(255) default NULL,
142     `dl_count` mediumint(9) NOT NULL default '0',
143     `dl_type` char(1) NOT NULL default 'C',
144     `filename` varchar(50) default NULL,
145     `enable` tinyint(1) unsigned NOT NULL default '1',
146     PRIMARY KEY (`ID`),
147     UNIQUE KEY `SID` (`SID`),
148 sysadm 1.2 KEY `dl_type` (`dl_type`)
149     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
150 sysadm 1.1
151     # Host: localhost
152     # Database: leafok
153     # Table: 'bbs_msg'
154     #
155     CREATE TABLE `bbs_msg` (
156     `MID` mediumint(9) NOT NULL auto_increment,
157     `fromUID` mediumint(9) NOT NULL default '0',
158     `toUID` mediumint(9) NOT NULL default '0',
159     `content` text,
160     `send_dt` datetime NOT NULL default '0000-00-00 00:00:00',
161     `send_ip` varchar(20) NOT NULL default '',
162     `new` tinyint(1) unsigned NOT NULL default '1',
163     `deleted` tinyint(1) unsigned NOT NULL default '0',
164     `s_deleted` tinyint(1) unsigned NOT NULL default '0',
165     PRIMARY KEY (`MID`),
166     KEY `fromUID` (`fromUID`),
167 sysadm 1.2 KEY `toUID` (`toUID`)
168     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
169 sysadm 1.1
170     # Host: localhost
171     # Database: leafok
172     # Table: 'bbs_prize'
173     #
174     CREATE TABLE `bbs_prize` (
175     `PID` smallint(6) NOT NULL auto_increment,
176     `title` varchar(50) default NULL,
177     `description` varchar(50) default NULL,
178     `score` mediumint(9) NOT NULL default '0',
179     `enable` tinyint(1) unsigned NOT NULL default '1',
180     `count_left` mediumint(9) NOT NULL default '0',
181 sysadm 1.2 PRIMARY KEY (`PID`)
182     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
183 sysadm 1.1
184     # Host: localhost
185     # Database: leafok
186     # Table: 'bbs_recommend'
187     #
188     CREATE TABLE `bbs_recommend` (
189     `RID` mediumint(9) NOT NULL auto_increment,
190     `UID` mediumint(9) NOT NULL default '0',
191     `TID` mediumint(9) NOT NULL default '0',
192     `type` char(1) NOT NULL default 'D',
193     `dt` datetime default NULL,
194     `email` varchar(50) NOT NULL default '',
195     `ip` varchar(20) default NULL,
196     PRIMARY KEY (`RID`),
197     KEY `UID` (`UID`),
198     KEY `TID` (`TID`),
199     KEY `type` (`type`)
200 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
201 sysadm 1.1
202     # Host: localhost
203     # Database: leafok
204     # Table: 'bbs_top_list'
205     #
206     CREATE TABLE `bbs_top_list` (
207     `AID` mediumint(9) NOT NULL default '0',
208     `bbs_title` varchar(80) NOT NULL default '',
209     `section_title` varchar(20) NOT NULL default ''
210 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
211 sysadm 1.1
212     # Host: localhost
213     # Database: leafok
214     # Table: 'email'
215     #
216     CREATE TABLE `email` (
217     `ID` mediumint(9) NOT NULL auto_increment,
218     `fromemail` varchar(30) default NULL,
219     `fromname` varchar(30) default NULL,
220     `toemail` varchar(30) default NULL,
221     `toname` varchar(30) default NULL,
222     `subject` varchar(80) default NULL,
223     `body` text,
224     `set_dt` datetime default NULL,
225     `send_dt` datetime default NULL,
226     `complete` tinyint(1) unsigned NOT NULL default '0',
227     `error` tinyint(1) unsigned NOT NULL default '0',
228 sysadm 1.2 `error_msg` varchar(255) default NULL,
229 sysadm 1.1 PRIMARY KEY (`ID`),
230 sysadm 1.2 KEY `complete` (`complete`)
231     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
232 sysadm 1.1
233     # Host: localhost
234     # Database: leafok
235     # Table: 'ex_dir'
236     #
237     CREATE TABLE `ex_dir` (
238     `FID` mediumint(9) NOT NULL auto_increment,
239     `dir` varchar(255) default '',
240     `name` varchar(50) default '',
241     `SID` smallint(6) NOT NULL default '0',
242     `enable` tinyint(1) unsigned NOT NULL default '0',
243     `dt` datetime default '0000-00-00 00:00:00',
244     PRIMARY KEY (`FID`),
245     UNIQUE KEY `dir` (`dir`,`SID`),
246 sysadm 1.2 KEY `SID` (`SID`)
247     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
248 sysadm 1.1
249     # Host: localhost
250     # Database: leafok
251     # Table: 'ex_file'
252     #
253     CREATE TABLE `ex_file` (
254     `AID` mediumint(9) NOT NULL default '0',
255     `FID` smallint(6) NOT NULL default '0',
256     PRIMARY KEY (`AID`),
257     KEY `FID` (`FID`)
258 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
259 sysadm 1.1
260     # Host: localhost
261     # Database: leafok
262     # Table: 'exam_question_lib'
263     #
264     CREATE TABLE `exam_question_lib` (
265     `QID` mediumint(9) NOT NULL auto_increment,
266     `type` enum('S','M','B','C') NOT NULL default 'S',
267     `class` smallint(6) NOT NULL default '0',
268     `enable` tinyint(1) unsigned NOT NULL default '1',
269     `time_limit` smallint(6) NOT NULL default '120',
270     `score` smallint(6) NOT NULL default '1',
271     `A_count` smallint(6) NOT NULL default '0',
272     `Q` varchar(255) default '',
273     `A1` varchar(255) default '',
274     `E1` tinyint(1) unsigned NOT NULL default '0',
275     `A2` varchar(100) default '',
276     `E2` tinyint(1) unsigned NOT NULL default '0',
277     `A3` varchar(255) default '',
278     `E3` tinyint(3) unsigned NOT NULL default '0',
279     `A4` varchar(255) default '',
280     `E4` tinyint(1) unsigned NOT NULL default '0',
281     `A5` varchar(255) default '',
282     `E5` tinyint(1) unsigned NOT NULL default '0',
283     PRIMARY KEY (`QID`),
284     KEY `type` (`type`),
285     KEY `class` (`class`)
286 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
287 sysadm 1.1
288     # Host: localhost
289     # Database: leafok
290     # Table: 'exam_user_list'
291     #
292     CREATE TABLE `exam_user_list` (
293     `TID` mediumint(9) NOT NULL auto_increment,
294     `UID` mediumint(9) NOT NULL default '0',
295     `class` smallint(6) NOT NULL default '0',
296     `voucher` varchar(10) default '',
297     `enable` tinyint(1) unsigned NOT NULL default '0',
298     `done` enum('N','B','E') NOT NULL default 'N',
299     `tm_limit` smallint(6) NOT NULL default '120',
300     `begin_tm` datetime default '0000-00-00 00:00:00',
301     `end_tm` datetime default '0000-00-00 00:00:00',
302     `ip` varchar(20) default '',
303     `score` smallint(6) NOT NULL default '0',
304     `pass` enum('P','F','N') NOT NULL default 'N',
305     `Q_S` smallint(6) NOT NULL default '0',
306     `Q_M` smallint(6) NOT NULL default '0',
307     `Q_B` smallint(6) NOT NULL default '0',
308     `Q_C` smallint(6) NOT NULL default '0',
309     `user_comment` text,
310     PRIMARY KEY (`TID`),
311     UNIQUE KEY `voucher` (`voucher`),
312     KEY `class` (`class`),
313     KEY `UID` (`UID`),
314 sysadm 1.2 KEY `score` (`score`)
315     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
316 sysadm 1.1
317     # Host: localhost
318     # Database: leafok
319     # Table: 'exam_user_question'
320     #
321     CREATE TABLE `exam_user_question` (
322     `ID` int(11) NOT NULL auto_increment,
323     `TID` mediumint(9) NOT NULL default '0',
324     `QID` mediumint(9) NOT NULL default '0',
325     `answer_order` varchar(10) default '',
326     `user_answer` varchar(10) default '',
327     `done` enum('N','B','E') NOT NULL default 'N',
328     `begin_tm` datetime default '0000-00-00 00:00:00',
329     `end_tm` datetime default '0000-00-00 00:00:00',
330     `score` smallint(6) NOT NULL default '0',
331     `user_answer_text` text,
332     PRIMARY KEY (`ID`),
333     KEY `QID` (`QID`),
334 sysadm 1.2 KEY `TID` (`TID`)
335     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
336 sysadm 1.1
337     # Host: localhost
338     # Database: leafok
339     # Table: 'friend_list'
340     #
341     CREATE TABLE `friend_list` (
342     `ID` mediumint(9) NOT NULL auto_increment,
343     `UID` mediumint(9) NOT NULL default '0',
344     `fUID` mediumint(9) NOT NULL default '0',
345     PRIMARY KEY (`ID`),
346     KEY `fUID` (`fUID`),
347     KEY `UID` (`UID`)
348 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
349 sysadm 1.1
350     # Host: localhost
351     # Database: leafok
352     # Table: 'innd_access'
353     #
354     CREATE TABLE `innd_access` (
355     `ID` mediumint(9) NOT NULL auto_increment,
356     `server` varchar(50) NOT NULL default '',
357     `ip` varchar(20) NOT NULL default '',
358     `port` smallint(5) unsigned NOT NULL default '0',
359     `use_post` tinyint(1) unsigned NOT NULL default '0',
360     `use_ihave` tinyint(1) unsigned NOT NULL default '0',
361     `control` tinyint(1) NOT NULL default '0',
362     `get` tinyint(1) unsigned NOT NULL default '1',
363     `post` tinyint(1) unsigned NOT NULL default '0',
364     `ihave` tinyint(1) unsigned NOT NULL default '0',
365     `enable` tinyint(1) unsigned NOT NULL default '1',
366     PRIMARY KEY (`ID`),
367     KEY `server` (`server`),
368     KEY `ip` (`ip`)
369 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
370 sysadm 1.1
371     # Host: localhost
372     # Database: leafok
373     # Table: 'innd_conf'
374     #
375     CREATE TABLE `innd_conf` (
376     `ID` mediumint(9) NOT NULL auto_increment,
377     `group` varchar(255) NOT NULL default '',
378     `server` varchar(50) NOT NULL default '',
379     `SID` mediumint(9) NOT NULL default '0',
380     `in` tinyint(1) unsigned NOT NULL default '0',
381     `out` tinyint(1) unsigned NOT NULL default '0',
382     `last_in_art_id` mediumint(9) NOT NULL default '0',
383     `last_in_msg_id` varchar(255) NOT NULL default '',
384     `cancel` tinyint(1) unsigned NOT NULL default '0',
385     `passive_mode` tinyint(1) unsigned NOT NULL default '0',
386     PRIMARY KEY (`ID`),
387     KEY `SID` (`SID`),
388     KEY `group` (`group`),
389 sysadm 1.2 KEY `server` (`server`)
390     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
391 sysadm 1.1
392     # Host: localhost
393     # Database: leafok
394     # Table: 'innd_log'
395     #
396     CREATE TABLE `innd_log` (
397     `AID` mediumint(9) NOT NULL default '0',
398     `art_id` mediumint(9) NOT NULL default '0',
399     `msg_id` varchar(255) NOT NULL default '',
400     `op` enum('I','O') NOT NULL default 'I',
401     `cancel` tinyint(1) unsigned NOT NULL default '0',
402     PRIMARY KEY (`AID`),
403     KEY `op` (`op`),
404     KEY `msg_id` (`msg_id`)
405 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
406 sysadm 1.1
407     # Host: localhost
408     # Database: leafok
409     # Table: 'innd_todo'
410     #
411     CREATE TABLE `innd_todo` (
412     `ID` mediumint(9) NOT NULL auto_increment,
413     `AID` mediumint(9) NOT NULL default '0',
414     `SID` smallint(9) NOT NULL default '0',
415     `server` varchar(50) NOT NULL default '',
416     `op` enum('P','C') NOT NULL default 'P',
417     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
418     PRIMARY KEY (`ID`),
419     KEY `AID` (`AID`),
420     KEY `op` (`op`),
421     KEY `server` (`server`)
422 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
423 sysadm 1.1
424     # Host: localhost
425     # Database: leafok
426     # Table: 'ip_list'
427     #
428     CREATE TABLE `ip_list` (
429     `IPID` mediumint(9) NOT NULL auto_increment,
430     `begin_ip` varchar(15) NOT NULL default '',
431     `end_ip` varchar(15) NOT NULL default '',
432     `address` varchar(20) NOT NULL default '',
433     `area` varchar(20) NOT NULL default '',
434     PRIMARY KEY (`IPID`),
435     KEY `ip` (`begin_ip`,`end_ip`)
436 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
437 sysadm 1.1
438     # Host: localhost
439     # Database: leafok
440     # Table: 'jk_log'
441     #
442     CREATE TABLE `jk_log` (
443     `ID` int(11) NOT NULL auto_increment,
444     `UID` mediumint(9) NOT NULL default '0',
445     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
446     `ip` varchar(20) NOT NULL default '',
447     `process` tinyint(1) unsigned NOT NULL default '0',
448     `complete` tinyint(1) NOT NULL default '0',
449     `anonymous` tinyint(1) unsigned NOT NULL default '0',
450     `amount` mediumint(9) NOT NULL default '0',
451     `pay_type` enum('CASH','POST','BANK','PAYPAL','OTHER') NOT NULL default 'OTHER',
452     `comment` text NOT NULL,
453     `reward` enum('NONE','SCORE','MAIL','BOTH') NOT NULL default 'NONE',
454     PRIMARY KEY (`ID`),
455     KEY `UID` (`UID`),
456     KEY `amount` (`amount`),
457     KEY `process` (`process`)
458 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
459 sysadm 1.1
460     # Host: localhost
461     # Database: leafok
462     # Table: 'journal_data'
463     #
464     CREATE TABLE `journal_data` (
465     `ID` mediumint(9) NOT NULL auto_increment,
466     `JID` smallint(6) NOT NULL default '0',
467     `AID` mediumint(9) NOT NULL default '0',
468     `abstract` text NOT NULL,
469     PRIMARY KEY (`ID`),
470     UNIQUE KEY `AID` (`AID`),
471     KEY `JID` (`JID`)
472 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
473 sysadm 1.1
474     # Host: localhost
475     # Database: leafok
476     # Table: 'journal_index'
477     #
478     CREATE TABLE `journal_index` (
479     `JID` smallint(6) NOT NULL auto_increment,
480     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
481     `enable` tinyint(1) NOT NULL default '0',
482 sysadm 1.2 PRIMARY KEY (`JID`)
483     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
484 sysadm 1.1
485     # Host: localhost
486     # Database: leafok
487     # Table: 'mng_err_login_log'
488     #
489     CREATE TABLE `mng_err_login_log` (
490     `ID` mediumint(9) NOT NULL auto_increment,
491     `username` varchar(14) default NULL,
492     `password` varchar(12) default NULL,
493     `login_dt` datetime default NULL,
494     `login_ip` varchar(20) default NULL,
495     PRIMARY KEY (`ID`)
496 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
497 sysadm 1.1
498     # Host: localhost
499     # Database: leafok
500     # Table: 'mng_login_log'
501     #
502     CREATE TABLE `mng_login_log` (
503     `ID` mediumint(9) NOT NULL auto_increment,
504     `UID` mediumint(9) NOT NULL default '0',
505     `login_dt` datetime default NULL,
506     `login_ip` varchar(20) default NULL,
507     PRIMARY KEY (`ID`),
508     KEY `UID` (`UID`),
509     KEY `login_dt` (`login_dt`)
510 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
511 sysadm 1.1
512     # Host: localhost
513     # Database: leafok
514     # Table: 'mng_priv_list'
515     #
516     CREATE TABLE `mng_priv_list` (
517     `PID` mediumint(9) NOT NULL auto_increment,
518     `UID` mediumint(9) NOT NULL default '0',
519     `ch_passwd` tinyint(1) unsigned NOT NULL default '1',
520     `db_cleanup` tinyint(1) unsigned NOT NULL default '0',
521     `score_cacl` tinyint(1) unsigned NOT NULL default '0',
522     `auth_user_op` tinyint(1) unsigned NOT NULL default '0',
523     `section_op` tinyint(1) unsigned NOT NULL default '0',
524     `master_op` tinyint(2) unsigned NOT NULL default '0',
525     `photo_check` tinyint(1) unsigned NOT NULL default '0',
526     `prize_op` tinyint(1) unsigned NOT NULL default '0',
527     `db_op` tinyint(1) unsigned NOT NULL default '0',
528     `file_op` tinyint(1) unsigned NOT NULL default '0',
529     `article_audit` tinyint(1) unsigned NOT NULL default '0',
530     `gen_ex` tinyint(1) unsigned NOT NULL default '0',
531     `jk_op` tinyint(1) unsigned NOT NULL default '0',
532     `upload_check` tinyint(1) unsigned NOT NULL default '0',
533     `article_recommend` tinyint(1) unsigned NOT NULL default '0',
534     PRIMARY KEY (`PID`),
535     UNIQUE KEY `UID` (`UID`)
536 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
537 sysadm 1.1
538     # Host: localhost
539     # Database: leafok
540     # Table: 'mng_user_list'
541     #
542     CREATE TABLE `mng_user_list` (
543     `UID` mediumint(9) NOT NULL auto_increment,
544     `username` varchar(14) NOT NULL default '',
545     `password` varchar(32) NOT NULL default '',
546     `enable` tinyint(1) unsigned NOT NULL default '0',
547     PRIMARY KEY (`UID`),
548 sysadm 1.2 UNIQUE KEY `username` (`username`)
549     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
550 sysadm 1.1
551     # Host: localhost
552     # Database: leafok
553     # Table: 'page_log'
554     #
555     CREATE TABLE `page_log` (
556     `ID` int(11) NOT NULL auto_increment,
557     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
558     `ip` varchar(20) NOT NULL default '',
559     `UID` mediumint(9) NOT NULL default '0',
560     `tm` smallint(6) NOT NULL default '0',
561     `script` varchar(255) NOT NULL default '',
562     `query` varchar(255) default '',
563     PRIMARY KEY (`ID`)
564 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
565 sysadm 1.1
566     # Host: localhost
567     # Database: leafok
568     # Table: 'page_log_bak'
569     #
570     CREATE TABLE `page_log_bak` (
571     `ID` int(11) NOT NULL auto_increment,
572     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
573     `ip` varchar(20) NOT NULL default '',
574     `UID` mediumint(9) NOT NULL default '0',
575     `tm` smallint(6) NOT NULL default '0',
576     `script` varchar(255) NOT NULL default '',
577     `query` varchar(255) default '',
578     PRIMARY KEY (`ID`)
579 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
580 sysadm 1.1
581     # Host: localhost
582     # Database: leafok
583     # Table: 'page_log_stat'
584     #
585     CREATE TABLE `page_log_stat` (
586     `year` smallint(4) NOT NULL default '0',
587     `month` smallint(4) NOT NULL default '0',
588     `day` smallint(4) NOT NULL default '0',
589     `hour` smallint(4) NOT NULL default '0',
590     `c_page` smallint(6) NOT NULL default '0',
591     KEY `dt` (`year`,`month`,`day`,`hour`)
592 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
593 sysadm 1.1
594     # Host: localhost
595     # Database: leafok
596     # Table: 's_e'
597     #
598     CREATE TABLE `s_e` (
599     `ID` int(11) NOT NULL auto_increment,
600     `sitename` varchar(40) NOT NULL default '',
601     `url` varchar(255) NOT NULL default '',
602     `class` enum('WWW','FTP','TELNET','BC','MMS') NOT NULL default 'WWW',
603     `description` varchar(255) default '',
604     `location` enum('INTERNET','LAN') NOT NULL default 'INTERNET',
605     `enable` tinyint(1) NOT NULL default '0',
606     `process` tinyint(1) NOT NULL default '0',
607     `name` varchar(10) NOT NULL default '',
608     `email` varchar(30) NOT NULL default '',
609     `ip` varchar(20) NOT NULL default '',
610     PRIMARY KEY (`ID`),
611     KEY `location` (`location`),
612     KEY `class` (`class`)
613 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
614 sysadm 1.1
615     # Host: localhost
616     # Database: leafok
617     # Table: 'section_apply_log'
618     #
619     CREATE TABLE `section_apply_log` (
620     `AID` smallint(6) NOT NULL auto_increment,
621     `SID` smallint(6) NOT NULL default '0',
622     `UID` mediumint(9) NOT NULL default '0',
623     `process_dt` datetime default NULL,
624     `memo` tinytext,
625     PRIMARY KEY (`AID`)
626 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
627 sysadm 1.1
628     # Host: localhost
629     # Database: leafok
630     # Table: 'section_class'
631     #
632     CREATE TABLE `section_class` (
633     `CID` smallint(6) NOT NULL auto_increment,
634     `cname` varchar(20) default NULL,
635     `title` varchar(20) default NULL,
636     `enable` tinyint(1) unsigned NOT NULL default '1',
637     `sort_order` smallint(6) NOT NULL default '10',
638     PRIMARY KEY (`CID`),
639     KEY `sort_order` (`sort_order`)
640 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
641 sysadm 1.1
642     # Host: localhost
643     # Database: leafok
644     # Table: 'section_class_master'
645     #
646     CREATE TABLE `section_class_master` (
647     `MID` smallint(6) NOT NULL auto_increment,
648     `CID` smallint(6) NOT NULL default '0',
649     `UID` mediumint(9) NOT NULL default '0',
650     `begin_dt` datetime default NULL,
651     `end_dt` datetime default NULL,
652     `enable` tinyint(1) unsigned NOT NULL default '1',
653     `memo` tinytext,
654     `major` tinyint(1) unsigned NOT NULL default '0',
655     PRIMARY KEY (`MID`),
656     KEY `UID` (`UID`),
657     KEY `CID` (`CID`)
658 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
659 sysadm 1.1
660     # Host: localhost
661     # Database: leafok
662     # Table: 'section_config'
663     #
664     CREATE TABLE `section_config` (
665     `SID` smallint(6) NOT NULL auto_increment,
666     `sname` varchar(20) default NULL,
667     `CID` smallint(6) NOT NULL default '0',
668     `title` varchar(20) default NULL,
669     `comment` varchar(255) default NULL,
670     `topic_max_count` smallint(6) NOT NULL default '0',
671 sysadm 1.2 `announcement` text,
672 sysadm 1.1 `bgsound` smallint(6) NOT NULL default '0',
673     `enable` tinyint(1) unsigned NOT NULL default '1',
674     `exp_get` tinyint(1) unsigned NOT NULL default '0',
675     `recommend` tinyint(1) unsigned NOT NULL default '0',
676     `transship_ratio` float NOT NULL default '0.5',
677     `set_UID` mediumint(9) default '0',
678     `set_dt` datetime default NULL,
679     `set_ip` varchar(20) default NULL,
680     `sort_order` smallint(6) NOT NULL default '10',
681     `ex_gen_tm` datetime default '0000-00-00 00:00:00',
682     `ex_pack_tm` datetime default '0000-00-00 00:00:00',
683     `ex_update` tinyint(1) unsigned NOT NULL default '0',
684 sysadm 1.2 `read_user_level` smallint(6) NOT NULL default '0',
685     `write_user_level` smallint(6) NOT NULL default '0',
686 sysadm 1.1 PRIMARY KEY (`SID`),
687 sysadm 1.2 KEY `CID` (`CID`),
688     KEY `write_user_level` (`write_user_level`),
689 sysadm 1.1 KEY `sort_order` (`sort_order`),
690 sysadm 1.2 KEY `read_user_level` (`read_user_level`),
691     KEY `sname` (`sname`)
692     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
693 sysadm 1.1
694     # Host: localhost
695     # Database: leafok
696     # Table: 'section_favorite'
697     #
698     CREATE TABLE `section_favorite` (
699     `ID` int(11) NOT NULL auto_increment,
700     `UID` mediumint(9) NOT NULL default '0',
701     `SID` smallint(6) NOT NULL default '0',
702     PRIMARY KEY (`ID`),
703     KEY `UID` (`UID`)
704 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
705 sysadm 1.1
706     # Host: localhost
707     # Database: leafok
708     # Table: 'section_master'
709     #
710     CREATE TABLE `section_master` (
711     `MID` smallint(6) NOT NULL auto_increment,
712     `SID` smallint(6) NOT NULL default '0',
713     `UID` mediumint(9) NOT NULL default '0',
714     `begin_dt` datetime default NULL,
715     `end_dt` datetime default NULL,
716     `enable` tinyint(1) unsigned NOT NULL default '1',
717     `major` tinyint(1) unsigned NOT NULL default '0',
718     `formal` tinyint(1) unsigned NOT NULL default '0',
719     `memo` tinytext,
720     PRIMARY KEY (`MID`),
721     KEY `SID` (`SID`),
722 sysadm 1.2 KEY `UID` (`UID`)
723     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
724 sysadm 1.1
725     # Host: localhost
726     # Database: leafok
727     # Table: 'section_master_apply'
728     #
729     CREATE TABLE `section_master_apply` (
730     `AID` smallint(6) NOT NULL auto_increment,
731     `SID` smallint(6) NOT NULL default '0',
732     `UID` mediumint(9) NOT NULL default '0',
733     `apply_dt` datetime default NULL,
734     `process` tinyint(1) unsigned NOT NULL default '0',
735     `process_dt` datetime default NULL,
736     `permit` tinyint(1) unsigned NOT NULL default '0',
737     `major` tinyint(1) unsigned NOT NULL default '0',
738     `memo` tinytext,
739     PRIMARY KEY (`AID`)
740 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
741    
742     # Host: localhost
743     # Database: leafok
744     # Table: 'section_user_priv'
745     #
746     CREATE TABLE `section_user_priv` (
747     `SID` smallint(6) NOT NULL default '0',
748     `UID` mediumint(9) NOT NULL default '0',
749     `read` tinyint(1) unsigned NOT NULL default '0',
750     `write` tinyint(1) unsigned NOT NULL default '0',
751     PRIMARY KEY (`SID`,`UID`),
752     KEY `UID` (`UID`)
753     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
754 sysadm 1.1
755     # Host: localhost
756     # Database: leafok
757     # Table: 'send_pass_log'
758     #
759     CREATE TABLE `send_pass_log` (
760     `ID` mediumint(9) NOT NULL auto_increment,
761     `UID` mediumint(9) NOT NULL default '0',
762     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
763     `ip` varchar(20) NOT NULL default '',
764     PRIMARY KEY (`ID`),
765     KEY `UID` (`UID`)
766 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
767 sysadm 1.1
768     # Host: localhost
769     # Database: leafok
770     # Table: 'upload_file'
771     #
772     CREATE TABLE `upload_file` (
773     `AID` mediumint(9) NOT NULL auto_increment,
774     `ref_AID` mediumint(9) NOT NULL default '0',
775     `UID` mediumint(9) NOT NULL default '0',
776     `size` mediumint(9) NOT NULL default '0',
777     `filename` varchar(255) NOT NULL default '',
778     `check` tinyint(1) unsigned NOT NULL default '0',
779     `deny` tinyint(1) unsigned NOT NULL default '0',
780     `deleted` tinyint(1) unsigned NOT NULL default '0',
781     PRIMARY KEY (`AID`),
782     KEY `check` (`check`),
783     KEY `UID` (`UID`),
784     KEY `ref_AID` (`ref_AID`)
785 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
786 sysadm 1.1
787     # Host: localhost
788     # Database: leafok
789     # Table: 'user_auth'
790     #
791     CREATE TABLE `user_auth` (
792     `AUID` mediumint(9) NOT NULL auto_increment,
793     `UID` mediumint(9) NOT NULL default '0',
794     `pid` varchar(18) default NULL,
795     `name` varchar(10) default NULL,
796     `email` varchar(30) default NULL,
797     `expire_dt` datetime default NULL,
798     `photo_enable` tinyint(1) unsigned NOT NULL default '1',
799     `photo_ext` varchar(5) NOT NULL default '',
800     `enable` tinyint(1) unsigned NOT NULL default '0',
801     `process` tinyint(1) unsigned NOT NULL default '0',
802     `auth_type` enum('PID','EMAIL','TRUST','SCORE') NOT NULL default 'TRUST',
803     PRIMARY KEY (`AUID`),
804     KEY `UID` (`UID`),
805     KEY `expire_dt` (`expire_dt`),
806     KEY `auth_type` (`auth_type`)
807 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
808 sysadm 1.1
809     # Host: localhost
810     # Database: leafok
811     # Table: 'user_elect'
812     #
813     CREATE TABLE `user_elect` (
814     `ID` mediumint(9) NOT NULL auto_increment,
815     `UID` mediumint(9) NOT NULL default '0',
816     `attend` tinyint(1) unsigned NOT NULL default '0',
817     `invalid` tinyint(1) unsigned NOT NULL default '0',
818     `voted` tinyint(1) unsigned NOT NULL default '0',
819     PRIMARY KEY (`ID`),
820 sysadm 1.2 KEY `UID` (`UID`)
821     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
822 sysadm 1.1
823     # Host: localhost
824     # Database: leafok
825     # Table: 'user_elect_vote'
826     #
827     CREATE TABLE `user_elect_vote` (
828     `elect_UID` mediumint(9) NOT NULL default '0',
829     `vote_UID` mediumint(9) NOT NULL default '0',
830     KEY `elect_UID` (`elect_UID`),
831     KEY `vote_UID` (`vote_UID`)
832 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
833 sysadm 1.1
834     # Host: localhost
835     # Database: leafok
836     # Table: 'user_err_login_log'
837     #
838     CREATE TABLE `user_err_login_log` (
839     `ID` mediumint(9) NOT NULL auto_increment,
840     `username` varchar(14) default NULL,
841     `password` varchar(12) default NULL,
842     `login_dt` datetime default NULL,
843     `login_ip` varchar(20) default NULL,
844     PRIMARY KEY (`ID`)
845 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
846 sysadm 1.1
847     # Host: localhost
848     # Database: leafok
849     # Table: 'user_life_log'
850     #
851     CREATE TABLE `user_life_log` (
852     `ID` mediumint(9) NOT NULL auto_increment,
853     `UID` mediumint(9) NOT NULL default '0',
854     `set_UID` mediumint(9) NOT NULL default '0',
855     `life` smallint(6) NOT NULL default '0',
856     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
857     `ip` varchar(20) NOT NULL default '',
858     PRIMARY KEY (`ID`),
859     KEY `set_UID` (`set_UID`),
860     KEY `UID` (`UID`)
861 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
862 sysadm 1.1
863     # Host: localhost
864     # Database: leafok
865     # Table: 'user_list'
866     #
867     CREATE TABLE `user_list` (
868     `UID` mediumint(9) NOT NULL auto_increment,
869 sysadm 1.2 `username` varchar(20) NOT NULL default '',
870 sysadm 1.1 `password` varchar(32) NOT NULL default '',
871     `enable` tinyint(1) unsigned NOT NULL default '1',
872     `verified` tinyint(1) unsigned NOT NULL default '0',
873     `p_login` tinyint(1) unsigned NOT NULL default '1',
874     `p_post` tinyint(1) unsigned NOT NULL default '1',
875     `p_msg` tinyint(1) unsigned NOT NULL default '1',
876     `p_mail` tinyint(1) unsigned NOT NULL default '1',
877     PRIMARY KEY (`UID`),
878     UNIQUE KEY `username` (`username`),
879     KEY `verified` (`verified`),
880     KEY `enable` (`enable`)
881 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
882 sysadm 1.1
883     # Host: localhost
884     # Database: leafok
885     # Table: 'user_login_log'
886     #
887     CREATE TABLE `user_login_log` (
888     `ID` mediumint(9) NOT NULL auto_increment,
889     `UID` mediumint(9) NOT NULL default '0',
890     `login_dt` datetime default NULL,
891     `login_ip` varchar(20) default NULL,
892     PRIMARY KEY (`ID`),
893     KEY `UID` (`UID`),
894     KEY `login_dt` (`login_dt`)
895 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
896 sysadm 1.1
897     # Host: localhost
898     # Database: leafok
899     # Table: 'user_modify_email_verify'
900     #
901     CREATE TABLE `user_modify_email_verify` (
902     `MID` mediumint(9) NOT NULL auto_increment,
903     `UID` mediumint(9) NOT NULL default '0',
904     `email` varchar(30) default NULL,
905     `verify_code` varchar(10) NOT NULL default '',
906     `complete` tinyint(1) unsigned NOT NULL default '0',
907     `dt` datetime default NULL,
908     `ip` varchar(20) default NULL,
909     PRIMARY KEY (`MID`),
910     UNIQUE KEY `verify_code` (`verify_code`),
911     KEY `UID` (`UID`),
912     KEY `complete` (`complete`)
913 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
914 sysadm 1.1
915     # Host: localhost
916     # Database: leafok
917     # Table: 'user_modify_log'
918     #
919     CREATE TABLE `user_modify_log` (
920     `MID` mediumint(9) NOT NULL auto_increment,
921     `UID` mediumint(9) NOT NULL default '0',
922     `modify_dt` datetime default NULL,
923     `modify_ip` varchar(20) default NULL,
924     `complete` tinyint(1) unsigned NOT NULL default '0',
925     PRIMARY KEY (`MID`),
926     KEY `UID` (`UID`)
927 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
928 sysadm 1.1
929     # Host: localhost
930     # Database: leafok
931     # Table: 'user_nickname'
932     #
933     CREATE TABLE `user_nickname` (
934     `NID` mediumint(9) NOT NULL auto_increment,
935     `UID` mediumint(9) NOT NULL default '0',
936     `nickname` varchar(20) NOT NULL default '',
937     `begin_dt` datetime default NULL,
938     `begin_reason` char(1) default NULL,
939     `end_dt` datetime default NULL,
940     `end_reason` char(1) default NULL,
941     PRIMARY KEY (`NID`),
942     KEY `UID` (`UID`),
943     KEY `nickname` (`nickname`),
944     KEY `begin_dt` (`begin_dt`),
945     KEY `end_dt` (`end_dt`)
946 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
947 sysadm 1.1
948     # Host: localhost
949     # Database: leafok
950     # Table: 'user_online'
951     #
952     CREATE TABLE `user_online` (
953 sysadm 1.2 `ID` int(9) NOT NULL auto_increment,
954 sysadm 1.1 `SID` varchar(32) NOT NULL default '',
955     `UID` mediumint(9) NOT NULL default '0',
956     `ip` varchar(20) NOT NULL default '',
957     `current_SID` smallint(6) NOT NULL default '0',
958     `current_action` varchar(20) NOT NULL default '',
959     `login_tm` datetime NOT NULL default '0000-00-00 00:00:00',
960     `last_tm` datetime default NULL,
961     PRIMARY KEY (`ID`),
962     KEY `login_tm` (`login_tm`),
963     KEY `UID` (`UID`),
964     KEY `last_tm` (`last_tm`),
965     KEY `SID` (`SID`)
966 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
967 sysadm 1.1
968     # Host: localhost
969     # Database: leafok
970     # Table: 'user_prize'
971     #
972     CREATE TABLE `user_prize` (
973     `ID` mediumint(9) NOT NULL auto_increment,
974     `UID` mediumint(9) NOT NULL default '0',
975     `PID` smallint(6) NOT NULL default '0',
976     `dt` datetime default NULL,
977     `ip` varchar(20) default NULL,
978     `process` tinyint(1) unsigned NOT NULL default '0',
979     `complete` tinyint(1) unsigned NOT NULL default '0',
980     PRIMARY KEY (`ID`),
981     KEY `UID` (`UID`),
982     KEY `PID` (`PID`),
983 sysadm 1.2 KEY `process` (`process`)
984     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
985 sysadm 1.1
986     # Host: localhost
987     # Database: leafok
988     # Table: 'user_pubinfo'
989     #
990     CREATE TABLE `user_pubinfo` (
991     `UID` mediumint(9) NOT NULL default '0',
992     `nickname` varchar(20) default NULL,
993     `email` varchar(30) default NULL,
994     `gender` char(1) NOT NULL default 'M',
995     `oicq` varchar(10) default NULL,
996     `icq` varchar(10) default NULL,
997     `homepage` varchar(80) default NULL,
998     `introduction` text,
999     `photo` smallint(6) default '0',
1000     `life` smallint(6) NOT NULL default '15',
1001     `exp` mediumint(9) default '0',
1002     `visit_count` mediumint(9) NOT NULL default '0',
1003     `email_pub` tinyint(1) unsigned NOT NULL default '0',
1004     `oicq_pub` tinyint(1) unsigned NOT NULL default '0',
1005     `icq_pub` tinyint(1) unsigned NOT NULL default '0',
1006     `homepage_pub` tinyint(1) unsigned NOT NULL default '0',
1007     `gender_pub` tinyint(1) unsigned NOT NULL default '0',
1008     `last_login_dt` datetime default NULL,
1009     `sign_1` text,
1010     `sign_2` text,
1011     `sign_3` text,
1012     `sub_permission` tinyint(1) unsigned NOT NULL default '1',
1013     `upload_limit` int(11) NOT NULL default '1048576',
1014     `login_notify_dt` datetime default '0000-00-00 00:00:00',
1015     `subscribe_jid` smallint(6) NOT NULL default '-1',
1016     `bgsound` tinyint(1) NOT NULL default '1',
1017     PRIMARY KEY (`UID`),
1018     UNIQUE KEY `nickname` (`nickname`),
1019     KEY `life` (`life`),
1020     KEY `login_notify_dt` (`login_notify_dt`),
1021     KEY `exp` (`exp`),
1022     KEY `last_login_dt` (`last_login_dt`),
1023     KEY `subscribe_jid` (`subscribe_jid`)
1024 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1025 sysadm 1.1
1026     # Host: localhost
1027     # Database: leafok
1028     # Table: 'user_reginfo'
1029     #
1030     CREATE TABLE `user_reginfo` (
1031     `UID` mediumint(9) NOT NULL default '0',
1032     `name` varchar(10) default NULL,
1033 sysadm 1.2 `birthday` datetime default NULL,
1034 sysadm 1.1 `address` varchar(80) default NULL,
1035     `tel` varchar(20) default NULL,
1036     `postcode` varchar(6) default NULL,
1037     `pid` varchar(18) default NULL,
1038     `country` varchar(10) default NULL,
1039     `province` varchar(10) default NULL,
1040     `city` varchar(10) default NULL,
1041     `signup_dt` datetime default NULL,
1042     `signup_ip` varchar(20) default NULL,
1043     `memo` text,
1044     PRIMARY KEY (`UID`)
1045 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1046 sysadm 1.1
1047     # Host: localhost
1048     # Database: leafok
1049     # Table: 'user_reginfo_log'
1050     #
1051     CREATE TABLE `user_reginfo_log` (
1052     `ID` mediumint(9) NOT NULL auto_increment,
1053     `UID` mediumint(9) NOT NULL default '0',
1054     `name` varchar(10) default NULL,
1055     `birthday` date default NULL,
1056     `address` varchar(80) default NULL,
1057     `tel` varchar(20) default NULL,
1058     `postcode` varchar(6) default NULL,
1059     `pid` varchar(18) default NULL,
1060     `country` varchar(10) default NULL,
1061     `province` varchar(10) default NULL,
1062     `city` varchar(10) default NULL,
1063     PRIMARY KEY (`ID`),
1064     KEY `UID` (`UID`)
1065 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1066 sysadm 1.1
1067     # Host: localhost
1068     # Database: leafok
1069     # Table: 'user_regverify'
1070     #
1071     CREATE TABLE `user_regverify` (
1072     `UID` mediumint(9) NOT NULL default '0',
1073     `verify_code` varchar(10) NOT NULL default '',
1074     `complete` tinyint(1) unsigned NOT NULL default '0',
1075     `set_dt` datetime default NULL,
1076     PRIMARY KEY (`UID`),
1077 sysadm 1.2 UNIQUE KEY `verify_code` (`verify_code`)
1078     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1079 sysadm 1.1
1080     # Host: localhost
1081     # Database: leafok
1082     # Table: 'user_relation'
1083     #
1084     CREATE TABLE `user_relation` (
1085     `RID` mediumint(9) NOT NULL auto_increment,
1086     `pUID` mediumint(9) NOT NULL default '0',
1087     `cUID` mediumint(9) NOT NULL default '0',
1088     `enable` tinyint(1) unsigned NOT NULL default '0',
1089     `last_exp` mediumint(9) NOT NULL default '0',
1090     PRIMARY KEY (`RID`),
1091     UNIQUE KEY `cUID` (`cUID`),
1092 sysadm 1.2 KEY `pUID` (`pUID`)
1093     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1094 sysadm 1.1
1095     # Host: localhost
1096     # Database: leafok
1097     # Table: 'user_score'
1098     #
1099     CREATE TABLE `user_score` (
1100     `UID` mediumint(9) NOT NULL default '0',
1101     `score` mediumint(9) NOT NULL default '0',
1102     `last_exp` mediumint(9) NOT NULL default '0',
1103     `exp_left` mediumint(9) NOT NULL default '0',
1104     PRIMARY KEY (`UID`),
1105     KEY `score` (`score`)
1106 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1107 sysadm 1.1
1108     # Host: localhost
1109     # Database: leafok
1110     # Table: 'user_score_log'
1111     #
1112     CREATE TABLE `user_score_log` (
1113     `ID` mediumint(9) NOT NULL auto_increment,
1114     `UID` mediumint(9) NOT NULL default '0',
1115     `score_change` mediumint(9) NOT NULL default '0',
1116     `reason` varchar(50) default NULL,
1117     `dt` datetime default NULL,
1118     PRIMARY KEY (`ID`),
1119     KEY `UID` (`UID`)
1120 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1121 sysadm 1.1
1122     # Host: localhost
1123     # Database: leafok
1124     # Table: 'user_switch_list'
1125     #
1126     CREATE TABLE `user_switch_list` (
1127     `ID` mediumint(9) NOT NULL auto_increment,
1128     `UID` mediumint(9) NOT NULL default '0',
1129     `tUID` mediumint(9) NOT NULL default '0',
1130     PRIMARY KEY (`ID`),
1131     KEY `tUID` (`tUID`),
1132     KEY `UID` (`UID`)
1133 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1134 sysadm 1.1
1135     # Host: localhost
1136     # Database: leafok
1137     # Table: 'user_trust_log'
1138     #
1139     CREATE TABLE `user_trust_log` (
1140     `ID` mediumint(9) NOT NULL auto_increment,
1141     `UID` mediumint(9) NOT NULL default '0',
1142     `tUID` mediumint(9) NOT NULL default '0',
1143     PRIMARY KEY (`ID`),
1144     KEY `tUID` (`tUID`),
1145     KEY `UID` (`UID`)
1146 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1147    
1148     # Host: localhost
1149     # Database: leafok
1150     # Table: 'view_article_log'
1151     #
1152     CREATE TABLE `view_article_log` (
1153     `AID` mediumint(11) NOT NULL default '0',
1154     `UID` mediumint(9) NOT NULL default '0',
1155     `dt` datetime NOT NULL default '0000-00-00 00:00:00',
1156     PRIMARY KEY (`AID`,`UID`),
1157     KEY `dt` (`dt`)
1158     ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1159 sysadm 1.1
1160     # Host: localhost
1161     # Database: leafok
1162     # Table: 'visit_log'
1163     #
1164     CREATE TABLE `visit_log` (
1165     `VID` mediumint(9) NOT NULL auto_increment,
1166     `dt` datetime default NULL,
1167     `ip` varchar(20) default NULL,
1168     PRIMARY KEY (`VID`)
1169 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1170 sysadm 1.1
1171     # Host: localhost
1172     # Database: leafok
1173     # Table: 'vote_answer'
1174     #
1175     CREATE TABLE `vote_answer` (
1176     `AID` smallint(6) NOT NULL auto_increment,
1177     `VID` smallint(6) NOT NULL default '0',
1178     `answer` varchar(100) default NULL,
1179     `count` smallint(6) NOT NULL default '0',
1180     PRIMARY KEY (`AID`),
1181     KEY `VID` (`VID`)
1182 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1183 sysadm 1.1
1184     # Host: localhost
1185     # Database: leafok
1186     # Table: 'vote_config'
1187     #
1188     CREATE TABLE `vote_config` (
1189     `VID` smallint(6) NOT NULL auto_increment,
1190     `title` varchar(20) default NULL,
1191     `question` varchar(100) default NULL,
1192     `begin_dt` datetime default NULL,
1193     `end_dt` datetime default NULL,
1194     `enable` tinyint(1) unsigned NOT NULL default '1',
1195     PRIMARY KEY (`VID`),
1196     KEY `begin_dt` (`begin_dt`),
1197     KEY `end_dt` (`end_dt`)
1198 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1199 sysadm 1.1
1200     # Host: localhost
1201     # Database: leafok
1202     # Table: 'vote_log'
1203     #
1204     CREATE TABLE `vote_log` (
1205     `ID` mediumint(9) NOT NULL auto_increment,
1206     `UID` mediumint(9) NOT NULL default '0',
1207     `VID` smallint(6) NOT NULL default '0',
1208     `AID` smallint(6) NOT NULL default '0',
1209     `vote_dt` datetime default NULL,
1210     `vote_ip` varchar(20) default NULL,
1211     PRIMARY KEY (`ID`),
1212     KEY `UID` (`UID`),
1213     KEY `VID` (`VID`),
1214     KEY `AID` (`AID`)
1215 sysadm 1.2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1216 sysadm 1.1
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1