/[LeafOK_CVS]/fenglin/TODO/sql/db_stru.sql
ViewVC logotype

Diff of /fenglin/TODO/sql/db_stru.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.1 by sysadm, Sun Jun 20 06:59:41 2004 UTC Revision 1.2 by sysadm, Tue Sep 27 15:08:12 2005 UTC
# Line 10  CREATE TABLE `admin_config` ( Line 10  CREATE TABLE `admin_config` (
10    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
11    `major` tinyint(1) unsigned NOT NULL default '0',    `major` tinyint(1) unsigned NOT NULL default '0',
12    PRIMARY KEY  (`AID`),    PRIMARY KEY  (`AID`),
13    KEY `UID` (`UID`),    KEY `UID` (`UID`)
14    KEY `enable` (`enable`),  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   KEY `major` (`major`)  
 ) TYPE=MyISAM;  
15    
16  # Host: localhost  # Host: localhost
17  # Database: leafok  # Database: leafok
# Line 24  CREATE TABLE `ban_ip_list` ( Line 22  CREATE TABLE `ban_ip_list` (
22    `begin_ip` varchar(20) default NULL,    `begin_ip` varchar(20) default NULL,
23    `end_ip` varchar(20) default NULL,    `end_ip` varchar(20) default NULL,
24    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
25    PRIMARY KEY  (`BID`),    PRIMARY KEY  (`BID`)
26    KEY `enable` (`enable`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
27    
28  # Host: localhost  # Host: localhost
29  # Database: leafok  # Database: leafok
# Line 46  CREATE TABLE `ban_user_list` ( Line 43  CREATE TABLE `ban_user_list` (
43    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
44    `reason` text,    `reason` text,
45    PRIMARY KEY  (`BID`),    PRIMARY KEY  (`BID`),
46    KEY `enable` (`enable`),    KEY `ban_UID` (`ban_UID`),
47    KEY `UID` (`UID`),    KEY `SID` (`SID`),
48    KEY `day` (`day`),    KEY `day` (`day`),
49    KEY `SID` (`SID`)    KEY `UID` (`UID`)
50  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
51    
52  # Host: localhost  # Host: localhost
53  # Database: leafok  # Database: leafok
# Line 61  CREATE TABLE `bbs` ( Line 58  CREATE TABLE `bbs` (
58    `SID` smallint(6) NOT NULL default '0',    `SID` smallint(6) NOT NULL default '0',
59    `TID` mediumint(9) NOT NULL default '0',    `TID` mediumint(9) NOT NULL default '0',
60    `UID` mediumint(9) NOT NULL default '0',    `UID` mediumint(9) NOT NULL default '0',
61      `username` varchar(20) default '',
62    `nickname` varchar(20) default NULL,    `nickname` varchar(20) default NULL,
63    `title` varchar(80) default NULL,    `title` varchar(80) default NULL,
64    `CID` mediumint(9) NOT NULL default '0',    `CID` mediumint(9) NOT NULL default '0',
# Line 72  CREATE TABLE `bbs` ( Line 70  CREATE TABLE `bbs` (
70    `exp` mediumint(9) NOT NULL default '0',    `exp` mediumint(9) NOT NULL default '0',
71    `last_reply_dt` datetime default NULL,    `last_reply_dt` datetime default NULL,
72    `last_reply_UID` mediumint(9) NOT NULL default '0',    `last_reply_UID` mediumint(9) NOT NULL default '0',
73      `last_reply_username` varchar(20) default '',
74    `last_reply_nickname` varchar(20) default NULL,    `last_reply_nickname` varchar(20) default NULL,
75    `transship` tinyint(1) unsigned NOT NULL default '0',    `transship` tinyint(1) unsigned NOT NULL default '0',
76    `lock` tinyint(1) unsigned NOT NULL default '0',    `lock` tinyint(1) unsigned NOT NULL default '0',
# Line 81  CREATE TABLE `bbs` ( Line 80  CREATE TABLE `bbs` (
80    `excerption` tinyint(1) unsigned NOT NULL default '0',    `excerption` tinyint(1) unsigned NOT NULL default '0',
81    `ontop` tinyint(1) unsigned NOT NULL default '0',    `ontop` tinyint(1) unsigned NOT NULL default '0',
82    `static` tinyint(1) unsigned NOT NULL default '0',    `static` tinyint(1) unsigned NOT NULL default '0',
83      `cached` tinyint(3) unsigned NOT NULL default '0',
84    `recommend` tinyint(1) unsigned NOT NULL default '0',    `recommend` tinyint(1) unsigned NOT NULL default '0',
85      `gen_ex` tinyint(1) unsigned NOT NULL default '0',
86      `m_del` tinyint(1) unsigned NOT NULL default '0',
87    `old_SID` smallint(6) NOT NULL default '0',    `old_SID` smallint(6) NOT NULL default '0',
88    `old_TID` mediumint(9) NOT NULL default '0',    `old_TID` mediumint(9) NOT NULL default '0',
89    PRIMARY KEY  (`AID`),    PRIMARY KEY  (`AID`),
90    UNIQUE KEY `CID` (`CID`),    UNIQUE KEY `CID` (`CID`),
91    KEY `last_reply_UID` (`last_reply_UID`),    KEY `UID` (`UID`),
   KEY `recommend` (`recommend`),  
   KEY `SID` (`SID`),  
   KEY `visible` (`visible`),  
   KEY `TID` (`TID`),  
   KEY `last_reply_dt` (`last_reply_dt`),  
   KEY `ontop` (`ontop`),  
   KEY `sub_dt` (`sub_dt`),  
92    KEY `reply_count` (`reply_count`),    KEY `reply_count` (`reply_count`),
93      KEY `last_reply_dt` (`last_reply_dt`),
94    KEY `view_count` (`view_count`),    KEY `view_count` (`view_count`),
95    KEY `UID` (`UID`),    KEY `sub_dt` (`sub_dt`),
96      KEY `title` (`title`(10)),
97    KEY `old_SID` (`old_SID`),    KEY `old_SID` (`old_SID`),
98    KEY `transship` (`transship`),    KEY `SID` (`SID`),
99    KEY `old_TID` (`old_TID`),    KEY `old_TID` (`old_TID`),
100    KEY `excerption` (`excerption`),    KEY `TID` (`TID`),
101    KEY `title` (`title`(10))    KEY `last_reply_UID` (`last_reply_UID`)
102  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
103    
104  # Host: localhost  # Host: localhost
105  # Database: leafok  # Database: leafok
# Line 115  CREATE TABLE `bbs_article_op` ( Line 112  CREATE TABLE `bbs_article_op` (
112    `type` char(1) NOT NULL default '',    `type` char(1) NOT NULL default '',
113    `op_dt` datetime default NULL,    `op_dt` datetime default NULL,
114    `op_ip` varchar(20) default NULL,    `op_ip` varchar(20) default NULL,
115    `complete` tinyint(1) unsigned NOT NULL default '0',    `complete` tinyint(1) unsigned NOT NULL default '1',
116    PRIMARY KEY  (`MID`),    PRIMARY KEY  (`MID`),
117      KEY `AID` (`AID`),
118    KEY `UID` (`UID`),    KEY `UID` (`UID`),
119    KEY `type` (`type`),    KEY `type` (`type`)
120    KEY `AID` (`AID`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
121    
122  # Host: localhost  # Host: localhost
123  # Database: leafok  # Database: leafok
# Line 132  CREATE TABLE `bbs_content` ( Line 129  CREATE TABLE `bbs_content` (
129    `content` longtext,    `content` longtext,
130    PRIMARY KEY  (`CID`),    PRIMARY KEY  (`CID`),
131    KEY `AID` (`AID`)    KEY `AID` (`AID`)
132  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
133    
134  # Host: localhost  # Host: localhost
135  # Database: leafok  # Database: leafok
# Line 148  CREATE TABLE `bbs_ex_dl` ( Line 145  CREATE TABLE `bbs_ex_dl` (
145    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
146    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
147    UNIQUE KEY `SID` (`SID`),    UNIQUE KEY `SID` (`SID`),
148    KEY `dl_type` (`dl_type`),    KEY `dl_type` (`dl_type`)
149    KEY `enable` (`enable`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
150    
151  # Host: localhost  # Host: localhost
152  # Database: leafok  # Database: leafok
# Line 168  CREATE TABLE `bbs_msg` ( Line 164  CREATE TABLE `bbs_msg` (
164    `s_deleted` tinyint(1) unsigned NOT NULL default '0',    `s_deleted` tinyint(1) unsigned NOT NULL default '0',
165    PRIMARY KEY  (`MID`),    PRIMARY KEY  (`MID`),
166    KEY `fromUID` (`fromUID`),    KEY `fromUID` (`fromUID`),
167    KEY `toUID` (`toUID`),    KEY `toUID` (`toUID`)
168    KEY `new` (`new`),  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   KEY `deleted` (`deleted`),  
   KEY `s_deleted` (`s_deleted`)  
 ) TYPE=MyISAM;  
169    
170  # Host: localhost  # Host: localhost
171  # Database: leafok  # Database: leafok
# Line 185  CREATE TABLE `bbs_prize` ( Line 178  CREATE TABLE `bbs_prize` (
178    `score` mediumint(9) NOT NULL default '0',    `score` mediumint(9) NOT NULL default '0',
179    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
180    `count_left` mediumint(9) NOT NULL default '0',    `count_left` mediumint(9) NOT NULL default '0',
181    PRIMARY KEY  (`PID`),    PRIMARY KEY  (`PID`)
182    KEY `score` (`score`),  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   KEY `enable` (`enable`)  
 ) TYPE=MyISAM;  
183    
184  # Host: localhost  # Host: localhost
185  # Database: leafok  # Database: leafok
# Line 206  CREATE TABLE `bbs_recommend` ( Line 197  CREATE TABLE `bbs_recommend` (
197    KEY `UID` (`UID`),    KEY `UID` (`UID`),
198    KEY `TID` (`TID`),    KEY `TID` (`TID`),
199    KEY `type` (`type`)    KEY `type` (`type`)
200  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
201    
202  # Host: localhost  # Host: localhost
203  # Database: leafok  # Database: leafok
# Line 216  CREATE TABLE `bbs_top_list` ( Line 207  CREATE TABLE `bbs_top_list` (
207    `AID` mediumint(9) NOT NULL default '0',    `AID` mediumint(9) NOT NULL default '0',
208    `bbs_title` varchar(80) NOT NULL default '',    `bbs_title` varchar(80) NOT NULL default '',
209    `section_title` varchar(20) NOT NULL default ''    `section_title` varchar(20) NOT NULL default ''
210  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
211    
212  # Host: localhost  # Host: localhost
213  # Database: leafok  # Database: leafok
# Line 234  CREATE TABLE `email` ( Line 225  CREATE TABLE `email` (
225    `send_dt` datetime default NULL,    `send_dt` datetime default NULL,
226    `complete` tinyint(1) unsigned NOT NULL default '0',    `complete` tinyint(1) unsigned NOT NULL default '0',
227    `error` tinyint(1) unsigned NOT NULL default '0',    `error` tinyint(1) unsigned NOT NULL default '0',
228      `error_msg` varchar(255) default NULL,
229    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
230    KEY `complete` (`complete`),    KEY `complete` (`complete`)
231    KEY `error` (`error`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
232    
233  # Host: localhost  # Host: localhost
234  # Database: leafok  # Database: leafok
# Line 252  CREATE TABLE `ex_dir` ( Line 243  CREATE TABLE `ex_dir` (
243    `dt` datetime default '0000-00-00 00:00:00',    `dt` datetime default '0000-00-00 00:00:00',
244    PRIMARY KEY  (`FID`),    PRIMARY KEY  (`FID`),
245    UNIQUE KEY `dir` (`dir`,`SID`),    UNIQUE KEY `dir` (`dir`,`SID`),
246    KEY `SID` (`SID`),    KEY `SID` (`SID`)
247    KEY `enable` (`enable`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
248    
249  # Host: localhost  # Host: localhost
250  # Database: leafok  # Database: leafok
# Line 265  CREATE TABLE `ex_file` ( Line 255  CREATE TABLE `ex_file` (
255    `FID` smallint(6) NOT NULL default '0',    `FID` smallint(6) NOT NULL default '0',
256    PRIMARY KEY  (`AID`),    PRIMARY KEY  (`AID`),
257    KEY `FID` (`FID`)    KEY `FID` (`FID`)
258  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
259    
260  # Host: localhost  # Host: localhost
261  # Database: leafok  # Database: leafok
# Line 292  CREATE TABLE `exam_question_lib` ( Line 282  CREATE TABLE `exam_question_lib` (
282    `E5` tinyint(1) unsigned NOT NULL default '0',    `E5` tinyint(1) unsigned NOT NULL default '0',
283    PRIMARY KEY  (`QID`),    PRIMARY KEY  (`QID`),
284    KEY `type` (`type`),    KEY `type` (`type`),
   KEY `enable` (`enable`),  
285    KEY `class` (`class`)    KEY `class` (`class`)
286  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
287    
288  # Host: localhost  # Host: localhost
289  # Database: leafok  # Database: leafok
# Line 320  CREATE TABLE `exam_user_list` ( Line 309  CREATE TABLE `exam_user_list` (
309    `user_comment` text,    `user_comment` text,
310    PRIMARY KEY  (`TID`),    PRIMARY KEY  (`TID`),
311    UNIQUE KEY `voucher` (`voucher`),    UNIQUE KEY `voucher` (`voucher`),
   KEY `pass` (`pass`),  
312    KEY `class` (`class`),    KEY `class` (`class`),
313    KEY `UID` (`UID`),    KEY `UID` (`UID`),
314    KEY `score` (`score`),    KEY `score` (`score`)
315    KEY `done` (`done`),  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   KEY `enable` (`enable`)  
 ) TYPE=MyISAM;  
316    
317  # Host: localhost  # Host: localhost
318  # Database: leafok  # Database: leafok
# Line 345  CREATE TABLE `exam_user_question` ( Line 331  CREATE TABLE `exam_user_question` (
331    `user_answer_text` text,    `user_answer_text` text,
332    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
333    KEY `QID` (`QID`),    KEY `QID` (`QID`),
334    KEY `TID` (`TID`),    KEY `TID` (`TID`)
335    KEY `done` (`done`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
336    
337  # Host: localhost  # Host: localhost
338  # Database: leafok  # Database: leafok
# Line 360  CREATE TABLE `friend_list` ( Line 345  CREATE TABLE `friend_list` (
345    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
346    KEY `fUID` (`fUID`),    KEY `fUID` (`fUID`),
347    KEY `UID` (`UID`)    KEY `UID` (`UID`)
348  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
349    
350  # Host: localhost  # Host: localhost
351  # Database: leafok  # Database: leafok
# Line 380  CREATE TABLE `innd_access` ( Line 365  CREATE TABLE `innd_access` (
365    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
366    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
367    KEY `server` (`server`),    KEY `server` (`server`),
   KEY `use_post` (`use_post`),  
   KEY `enable` (`enable`),  
   KEY `use_ihave` (`use_ihave`),  
368    KEY `ip` (`ip`)    KEY `ip` (`ip`)
369  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
370    
371  # Host: localhost  # Host: localhost
372  # Database: leafok  # Database: leafok
# Line 402  CREATE TABLE `innd_conf` ( Line 384  CREATE TABLE `innd_conf` (
384    `cancel` tinyint(1) unsigned NOT NULL default '0',    `cancel` tinyint(1) unsigned NOT NULL default '0',
385    `passive_mode` tinyint(1) unsigned NOT NULL default '0',    `passive_mode` tinyint(1) unsigned NOT NULL default '0',
386    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
   KEY `in` (`in`),  
   KEY `out` (`out`),  
   KEY `cancel` (`cancel`),  
387    KEY `SID` (`SID`),    KEY `SID` (`SID`),
388    KEY `group` (`group`),    KEY `group` (`group`),
389    KEY `server` (`server`),    KEY `server` (`server`)
390    KEY `passive_mode` (`passive_mode`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
391    
392  # Host: localhost  # Host: localhost
393  # Database: leafok  # Database: leafok
# Line 422  CREATE TABLE `innd_log` ( Line 400  CREATE TABLE `innd_log` (
400    `op` enum('I','O') NOT NULL default 'I',    `op` enum('I','O') NOT NULL default 'I',
401    `cancel` tinyint(1) unsigned NOT NULL default '0',    `cancel` tinyint(1) unsigned NOT NULL default '0',
402    PRIMARY KEY  (`AID`),    PRIMARY KEY  (`AID`),
   KEY `cancel` (`cancel`),  
403    KEY `op` (`op`),    KEY `op` (`op`),
404    KEY `msg_id` (`msg_id`)    KEY `msg_id` (`msg_id`)
405  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
406    
407  # Host: localhost  # Host: localhost
408  # Database: leafok  # Database: leafok
# Line 442  CREATE TABLE `innd_todo` ( Line 419  CREATE TABLE `innd_todo` (
419    KEY `AID` (`AID`),    KEY `AID` (`AID`),
420    KEY `op` (`op`),    KEY `op` (`op`),
421    KEY `server` (`server`)    KEY `server` (`server`)
422  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   
 # Host: localhost  
 # Database: leafok  
 # Table: 'innocentive'  
 #  
 CREATE TABLE `innocentive` (  
   `ID` mediumint(9) NOT NULL auto_increment,  
   `UID` mediumint(9) NOT NULL default '0',  
   `username` varchar(20) NOT NULL default '',  
   `password` varchar(20) NOT NULL default '',  
   `firstname` varchar(10) NOT NULL default '',  
   `lastname` varchar(10) NOT NULL default '',  
   `email` varchar(50) NOT NULL default '',  
   `address` varchar(100) NOT NULL default '',  
   `city` varchar(15) NOT NULL default '',  
   `province` varchar(15) NOT NULL default '',  
   `country` varchar(15) NOT NULL default '',  
   `postcode` varchar(10) NOT NULL default '',  
   `company` varchar(100) NOT NULL default '',  
   `biochemistry` tinyint(1) NOT NULL default '0',  
   `bioengineering` tinyint(1) NOT NULL default '0',  
   `bioinfomatics` tinyint(1) NOT NULL default '0',  
   `biophysics` tinyint(1) NOT NULL default '0',  
   `cellular` tinyint(1) NOT NULL default '0',  
   `genetics` tinyint(1) NOT NULL default '0',  
   `genomics` tinyint(1) NOT NULL default '0',  
   `histopathology` tinyint(1) NOT NULL default '0',  
   `immunology` tinyint(1) NOT NULL default '0',  
   `microbiology` tinyint(1) NOT NULL default '0',  
   `pharmacology` tinyint(1) NOT NULL default '0',  
   `physiology` tinyint(1) NOT NULL default '0',  
   `proteomics` tinyint(1) NOT NULL default '0',  
   `structural` tinyint(1) NOT NULL default '0',  
   `toxicology` tinyint(1) NOT NULL default '0',  
   `environmental` tinyint(1) NOT NULL default '0',  
   `kinase` tinyint(1) NOT NULL default '0',  
   `virology` tinyint(1) NOT NULL default '0',  
   `metabolic` tinyint(1) NOT NULL default '0',  
   `molecular` tinyint(1) NOT NULL default '0',  
   `protein` tinyint(1) NOT NULL default '0',  
   `receive_email` tinyint(1) NOT NULL default '0',  
   `html_email` tinyint(1) NOT NULL default '0',  
   `verified` tinyint(1) NOT NULL default '0',  
   `gift_given` tinyint(1) NOT NULL default '0',  
   PRIMARY KEY  (`ID`),  
   UNIQUE KEY `UID` (`UID`),  
   KEY `verified` (`verified`),  
   KEY `gift_given` (`gift_given`)  
 ) TYPE=MyISAM;  
423    
424  # Host: localhost  # Host: localhost
425  # Database: leafok  # Database: leafok
# Line 505  CREATE TABLE `ip_list` ( Line 433  CREATE TABLE `ip_list` (
433    `area` varchar(20) NOT NULL default '',    `area` varchar(20) NOT NULL default '',
434    PRIMARY KEY  (`IPID`),    PRIMARY KEY  (`IPID`),
435    KEY `ip` (`begin_ip`,`end_ip`)    KEY `ip` (`begin_ip`,`end_ip`)
436  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
437    
438  # Host: localhost  # Host: localhost
439  # Database: leafok  # Database: leafok
# Line 527  CREATE TABLE `jk_log` ( Line 455  CREATE TABLE `jk_log` (
455    KEY `UID` (`UID`),    KEY `UID` (`UID`),
456    KEY `amount` (`amount`),    KEY `amount` (`amount`),
457    KEY `process` (`process`)    KEY `process` (`process`)
458  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
459    
460  # Host: localhost  # Host: localhost
461  # Database: leafok  # Database: leafok
# Line 541  CREATE TABLE `journal_data` ( Line 469  CREATE TABLE `journal_data` (
469    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
470    UNIQUE KEY `AID` (`AID`),    UNIQUE KEY `AID` (`AID`),
471    KEY `JID` (`JID`)    KEY `JID` (`JID`)
472  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
473    
474  # Host: localhost  # Host: localhost
475  # Database: leafok  # Database: leafok
# Line 551  CREATE TABLE `journal_index` ( Line 479  CREATE TABLE `journal_index` (
479    `JID` smallint(6) NOT NULL auto_increment,    `JID` smallint(6) NOT NULL auto_increment,
480    `dt` datetime NOT NULL default '0000-00-00 00:00:00',    `dt` datetime NOT NULL default '0000-00-00 00:00:00',
481    `enable` tinyint(1) NOT NULL default '0',    `enable` tinyint(1) NOT NULL default '0',
482    PRIMARY KEY  (`JID`),    PRIMARY KEY  (`JID`)
483    KEY `enable` (`enable`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
484    
485  # Host: localhost  # Host: localhost
486  # Database: leafok  # Database: leafok
# Line 566  CREATE TABLE `mng_err_login_log` ( Line 493  CREATE TABLE `mng_err_login_log` (
493    `login_dt` datetime default NULL,    `login_dt` datetime default NULL,
494    `login_ip` varchar(20) default NULL,    `login_ip` varchar(20) default NULL,
495    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
496  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
497    
498  # Host: localhost  # Host: localhost
499  # Database: leafok  # Database: leafok
# Line 580  CREATE TABLE `mng_login_log` ( Line 507  CREATE TABLE `mng_login_log` (
507    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
508    KEY `UID` (`UID`),    KEY `UID` (`UID`),
509    KEY `login_dt` (`login_dt`)    KEY `login_dt` (`login_dt`)
510  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
511    
512  # Host: localhost  # Host: localhost
513  # Database: leafok  # Database: leafok
# Line 606  CREATE TABLE `mng_priv_list` ( Line 533  CREATE TABLE `mng_priv_list` (
533    `article_recommend` tinyint(1) unsigned NOT NULL default '0',    `article_recommend` tinyint(1) unsigned NOT NULL default '0',
534    PRIMARY KEY  (`PID`),    PRIMARY KEY  (`PID`),
535    UNIQUE KEY `UID` (`UID`)    UNIQUE KEY `UID` (`UID`)
536  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
537    
538  # Host: localhost  # Host: localhost
539  # Database: leafok  # Database: leafok
# Line 618  CREATE TABLE `mng_user_list` ( Line 545  CREATE TABLE `mng_user_list` (
545    `password` varchar(32) NOT NULL default '',    `password` varchar(32) NOT NULL default '',
546    `enable` tinyint(1) unsigned NOT NULL default '0',    `enable` tinyint(1) unsigned NOT NULL default '0',
547    PRIMARY KEY  (`UID`),    PRIMARY KEY  (`UID`),
548    UNIQUE KEY `username` (`username`),    UNIQUE KEY `username` (`username`)
549    KEY `enable` (`enable`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
550    
551  # Host: localhost  # Host: localhost
552  # Database: leafok  # Database: leafok
# Line 635  CREATE TABLE `page_log` ( Line 561  CREATE TABLE `page_log` (
561    `script` varchar(255) NOT NULL default '',    `script` varchar(255) NOT NULL default '',
562    `query` varchar(255) default '',    `query` varchar(255) default '',
563    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
564  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
565    
566  # Host: localhost  # Host: localhost
567  # Database: leafok  # Database: leafok
# Line 650  CREATE TABLE `page_log_bak` ( Line 576  CREATE TABLE `page_log_bak` (
576    `script` varchar(255) NOT NULL default '',    `script` varchar(255) NOT NULL default '',
577    `query` varchar(255) default '',    `query` varchar(255) default '',
578    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
579  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
580    
581  # Host: localhost  # Host: localhost
582  # Database: leafok  # Database: leafok
# Line 663  CREATE TABLE `page_log_stat` ( Line 589  CREATE TABLE `page_log_stat` (
589    `hour` smallint(4) NOT NULL default '0',    `hour` smallint(4) NOT NULL default '0',
590    `c_page` smallint(6) NOT NULL default '0',    `c_page` smallint(6) NOT NULL default '0',
591    KEY `dt` (`year`,`month`,`day`,`hour`)    KEY `dt` (`year`,`month`,`day`,`hour`)
592  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
593    
594  # Host: localhost  # Host: localhost
595  # Database: leafok  # Database: leafok
# Line 682  CREATE TABLE `s_e` ( Line 608  CREATE TABLE `s_e` (
608    `email` varchar(30) NOT NULL default '',    `email` varchar(30) NOT NULL default '',
609    `ip` varchar(20) NOT NULL default '',    `ip` varchar(20) NOT NULL default '',
610    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
   KEY `enable` (`enable`),  
611    KEY `location` (`location`),    KEY `location` (`location`),
612    KEY `class` (`class`)    KEY `class` (`class`)
613  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
614    
615  # Host: localhost  # Host: localhost
616  # Database: leafok  # Database: leafok
# Line 698  CREATE TABLE `section_apply_log` ( Line 623  CREATE TABLE `section_apply_log` (
623    `process_dt` datetime default NULL,    `process_dt` datetime default NULL,
624    `memo` tinytext,    `memo` tinytext,
625    PRIMARY KEY  (`AID`)    PRIMARY KEY  (`AID`)
626  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
627    
628  # Host: localhost  # Host: localhost
629  # Database: leafok  # Database: leafok
# Line 711  CREATE TABLE `section_class` ( Line 636  CREATE TABLE `section_class` (
636    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
637    `sort_order` smallint(6) NOT NULL default '10',    `sort_order` smallint(6) NOT NULL default '10',
638    PRIMARY KEY  (`CID`),    PRIMARY KEY  (`CID`),
   KEY `enable` (`enable`),  
639    KEY `sort_order` (`sort_order`)    KEY `sort_order` (`sort_order`)
640  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
641    
642  # Host: localhost  # Host: localhost
643  # Database: leafok  # Database: leafok
# Line 729  CREATE TABLE `section_class_master` ( Line 653  CREATE TABLE `section_class_master` (
653    `memo` tinytext,    `memo` tinytext,
654    `major` tinyint(1) unsigned NOT NULL default '0',    `major` tinyint(1) unsigned NOT NULL default '0',
655    PRIMARY KEY  (`MID`),    PRIMARY KEY  (`MID`),
   KEY `enable` (`enable`),  
656    KEY `UID` (`UID`),    KEY `UID` (`UID`),
   KEY `major` (`major`),  
657    KEY `CID` (`CID`)    KEY `CID` (`CID`)
658  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
659    
660  # Host: localhost  # Host: localhost
661  # Database: leafok  # Database: leafok
# Line 746  CREATE TABLE `section_config` ( Line 668  CREATE TABLE `section_config` (
668    `title` varchar(20) default NULL,    `title` varchar(20) default NULL,
669    `comment` varchar(255) default NULL,    `comment` varchar(255) default NULL,
670    `topic_max_count` smallint(6) NOT NULL default '0',    `topic_max_count` smallint(6) NOT NULL default '0',
671    `announcement` varchar(255) default NULL,    `announcement` text,
672    `bgsound` smallint(6) NOT NULL default '0',    `bgsound` smallint(6) NOT NULL default '0',
673    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
   `public` tinyint(1) unsigned NOT NULL default '1',  
674    `exp_get` tinyint(1) unsigned NOT NULL default '0',    `exp_get` tinyint(1) unsigned NOT NULL default '0',
675    `recommend` tinyint(1) unsigned NOT NULL default '0',    `recommend` tinyint(1) unsigned NOT NULL default '0',
676    `transship_ratio` float NOT NULL default '0.5',    `transship_ratio` float NOT NULL default '0.5',
# Line 760  CREATE TABLE `section_config` ( Line 681  CREATE TABLE `section_config` (
681    `ex_gen_tm` datetime default '0000-00-00 00:00:00',    `ex_gen_tm` datetime default '0000-00-00 00:00:00',
682    `ex_pack_tm` datetime default '0000-00-00 00:00:00',    `ex_pack_tm` datetime default '0000-00-00 00:00:00',
683    `ex_update` tinyint(1) unsigned NOT NULL default '0',    `ex_update` tinyint(1) unsigned NOT NULL default '0',
684    `access_user_level` smallint(6) NOT NULL default '0',    `read_user_level` smallint(6) NOT NULL default '0',
685      `write_user_level` smallint(6) NOT NULL default '0',
686    PRIMARY KEY  (`SID`),    PRIMARY KEY  (`SID`),
   KEY `sort_order` (`sort_order`),  
   KEY `public` (`public`),  
687    KEY `CID` (`CID`),    KEY `CID` (`CID`),
688    KEY `recommend` (`recommend`),    KEY `write_user_level` (`write_user_level`),
689    KEY `exp_get` (`exp_get`),    KEY `sort_order` (`sort_order`),
690    KEY `sname` (`sname`),    KEY `read_user_level` (`read_user_level`),
691    KEY `enable` (`enable`)    KEY `sname` (`sname`)
692  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
693    
694  # Host: localhost  # Host: localhost
695  # Database: leafok  # Database: leafok
# Line 781  CREATE TABLE `section_favorite` ( Line 701  CREATE TABLE `section_favorite` (
701    `SID` smallint(6) NOT NULL default '0',    `SID` smallint(6) NOT NULL default '0',
702    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
703    KEY `UID` (`UID`)    KEY `UID` (`UID`)
704  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
705    
706  # Host: localhost  # Host: localhost
707  # Database: leafok  # Database: leafok
# Line 799  CREATE TABLE `section_master` ( Line 719  CREATE TABLE `section_master` (
719    `memo` tinytext,    `memo` tinytext,
720    PRIMARY KEY  (`MID`),    PRIMARY KEY  (`MID`),
721    KEY `SID` (`SID`),    KEY `SID` (`SID`),
722    KEY `UID` (`UID`),    KEY `UID` (`UID`)
723    KEY `enable` (`enable`),  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   KEY `major` (`major`)  
 ) TYPE=MyISAM;  
724    
725  # Host: localhost  # Host: localhost
726  # Database: leafok  # Database: leafok
# Line 819  CREATE TABLE `section_master_apply` ( Line 737  CREATE TABLE `section_master_apply` (
737    `major` tinyint(1) unsigned NOT NULL default '0',    `major` tinyint(1) unsigned NOT NULL default '0',
738    `memo` tinytext,    `memo` tinytext,
739    PRIMARY KEY  (`AID`)    PRIMARY KEY  (`AID`)
740  ) TYPE=MyISAM;  ) 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    
755  # Host: localhost  # Host: localhost
756  # Database: leafok  # Database: leafok
# Line 832  CREATE TABLE `send_pass_log` ( Line 763  CREATE TABLE `send_pass_log` (
763    `ip` varchar(20) NOT NULL default '',    `ip` varchar(20) NOT NULL default '',
764    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
765    KEY `UID` (`UID`)    KEY `UID` (`UID`)
766  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
767    
768  # Host: localhost  # Host: localhost
769  # Database: leafok  # Database: leafok
# Line 850  CREATE TABLE `upload_file` ( Line 781  CREATE TABLE `upload_file` (
781    PRIMARY KEY  (`AID`),    PRIMARY KEY  (`AID`),
782    KEY `check` (`check`),    KEY `check` (`check`),
783    KEY `UID` (`UID`),    KEY `UID` (`UID`),
   KEY `deny` (`deny`),  
784    KEY `ref_AID` (`ref_AID`)    KEY `ref_AID` (`ref_AID`)
785  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
786    
787  # Host: localhost  # Host: localhost
788  # Database: leafok  # Database: leafok
# Line 872  CREATE TABLE `user_auth` ( Line 802  CREATE TABLE `user_auth` (
802    `auth_type` enum('PID','EMAIL','TRUST','SCORE') NOT NULL default 'TRUST',    `auth_type` enum('PID','EMAIL','TRUST','SCORE') NOT NULL default 'TRUST',
803    PRIMARY KEY  (`AUID`),    PRIMARY KEY  (`AUID`),
804    KEY `UID` (`UID`),    KEY `UID` (`UID`),
   KEY `enable` (`enable`),  
805    KEY `expire_dt` (`expire_dt`),    KEY `expire_dt` (`expire_dt`),
806    KEY `auth_type` (`auth_type`)    KEY `auth_type` (`auth_type`)
807  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
808    
809  # Host: localhost  # Host: localhost
810  # Database: leafok  # Database: leafok
# Line 888  CREATE TABLE `user_elect` ( Line 817  CREATE TABLE `user_elect` (
817    `invalid` tinyint(1) unsigned NOT NULL default '0',    `invalid` tinyint(1) unsigned NOT NULL default '0',
818    `voted` tinyint(1) unsigned NOT NULL default '0',    `voted` tinyint(1) unsigned NOT NULL default '0',
819    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
820    KEY `invalid` (`invalid`),    KEY `UID` (`UID`)
821    KEY `UID` (`UID`),  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   KEY `attend` (`attend`),  
   KEY `invalid_2` (`invalid`),  
   KEY `voted` (`voted`)  
 ) TYPE=MyISAM;  
822    
823  # Host: localhost  # Host: localhost
824  # Database: leafok  # Database: leafok
# Line 904  CREATE TABLE `user_elect_vote` ( Line 829  CREATE TABLE `user_elect_vote` (
829    `vote_UID` mediumint(9) NOT NULL default '0',    `vote_UID` mediumint(9) NOT NULL default '0',
830    KEY `elect_UID` (`elect_UID`),    KEY `elect_UID` (`elect_UID`),
831    KEY `vote_UID` (`vote_UID`)    KEY `vote_UID` (`vote_UID`)
832  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
833    
834  # Host: localhost  # Host: localhost
835  # Database: leafok  # Database: leafok
# Line 917  CREATE TABLE `user_err_login_log` ( Line 842  CREATE TABLE `user_err_login_log` (
842    `login_dt` datetime default NULL,    `login_dt` datetime default NULL,
843    `login_ip` varchar(20) default NULL,    `login_ip` varchar(20) default NULL,
844    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
845  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
846    
847  # Host: localhost  # Host: localhost
848  # Database: leafok  # Database: leafok
# Line 933  CREATE TABLE `user_life_log` ( Line 858  CREATE TABLE `user_life_log` (
858    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
859    KEY `set_UID` (`set_UID`),    KEY `set_UID` (`set_UID`),
860    KEY `UID` (`UID`)    KEY `UID` (`UID`)
861  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
862    
863  # Host: localhost  # Host: localhost
864  # Database: leafok  # Database: leafok
# Line 941  CREATE TABLE `user_life_log` ( Line 866  CREATE TABLE `user_life_log` (
866  #  #
867  CREATE TABLE `user_list` (  CREATE TABLE `user_list` (
868    `UID` mediumint(9) NOT NULL auto_increment,    `UID` mediumint(9) NOT NULL auto_increment,
869    `username` varchar(14) NOT NULL default '',    `username` varchar(20) NOT NULL default '',
870    `password` varchar(32) NOT NULL default '',    `password` varchar(32) NOT NULL default '',
871    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
872    `verified` tinyint(1) unsigned NOT NULL default '0',    `verified` tinyint(1) unsigned NOT NULL default '0',
# Line 953  CREATE TABLE `user_list` ( Line 878  CREATE TABLE `user_list` (
878    UNIQUE KEY `username` (`username`),    UNIQUE KEY `username` (`username`),
879    KEY `verified` (`verified`),    KEY `verified` (`verified`),
880    KEY `enable` (`enable`)    KEY `enable` (`enable`)
881  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
882    
883  # Host: localhost  # Host: localhost
884  # Database: leafok  # Database: leafok
# Line 967  CREATE TABLE `user_login_log` ( Line 892  CREATE TABLE `user_login_log` (
892    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
893    KEY `UID` (`UID`),    KEY `UID` (`UID`),
894    KEY `login_dt` (`login_dt`)    KEY `login_dt` (`login_dt`)
895  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
896    
897  # Host: localhost  # Host: localhost
898  # Database: leafok  # Database: leafok
# Line 985  CREATE TABLE `user_modify_email_verify` Line 910  CREATE TABLE `user_modify_email_verify`
910    UNIQUE KEY `verify_code` (`verify_code`),    UNIQUE KEY `verify_code` (`verify_code`),
911    KEY `UID` (`UID`),    KEY `UID` (`UID`),
912    KEY `complete` (`complete`)    KEY `complete` (`complete`)
913  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
914    
915  # Host: localhost  # Host: localhost
916  # Database: leafok  # Database: leafok
# Line 999  CREATE TABLE `user_modify_log` ( Line 924  CREATE TABLE `user_modify_log` (
924    `complete` tinyint(1) unsigned NOT NULL default '0',    `complete` tinyint(1) unsigned NOT NULL default '0',
925    PRIMARY KEY  (`MID`),    PRIMARY KEY  (`MID`),
926    KEY `UID` (`UID`)    KEY `UID` (`UID`)
927  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
928    
929  # Host: localhost  # Host: localhost
930  # Database: leafok  # Database: leafok
# Line 1018  CREATE TABLE `user_nickname` ( Line 943  CREATE TABLE `user_nickname` (
943    KEY `nickname` (`nickname`),    KEY `nickname` (`nickname`),
944    KEY `begin_dt` (`begin_dt`),    KEY `begin_dt` (`begin_dt`),
945    KEY `end_dt` (`end_dt`)    KEY `end_dt` (`end_dt`)
946  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
947    
948  # Host: localhost  # Host: localhost
949  # Database: leafok  # Database: leafok
950  # Table: 'user_online'  # Table: 'user_online'
951  #  #
952  CREATE TABLE `user_online` (  CREATE TABLE `user_online` (
953    `ID` mediumint(9) NOT NULL auto_increment,    `ID` int(9) NOT NULL auto_increment,
954    `SID` varchar(32) NOT NULL default '',    `SID` varchar(32) NOT NULL default '',
955    `UID` mediumint(9) NOT NULL default '0',    `UID` mediumint(9) NOT NULL default '0',
956    `ip` varchar(20) NOT NULL default '',    `ip` varchar(20) NOT NULL default '',
# Line 1038  CREATE TABLE `user_online` ( Line 963  CREATE TABLE `user_online` (
963    KEY `UID` (`UID`),    KEY `UID` (`UID`),
964    KEY `last_tm` (`last_tm`),    KEY `last_tm` (`last_tm`),
965    KEY `SID` (`SID`)    KEY `SID` (`SID`)
966  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
967    
968  # Host: localhost  # Host: localhost
969  # Database: leafok  # Database: leafok
# Line 1055  CREATE TABLE `user_prize` ( Line 980  CREATE TABLE `user_prize` (
980    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
981    KEY `UID` (`UID`),    KEY `UID` (`UID`),
982    KEY `PID` (`PID`),    KEY `PID` (`PID`),
983    KEY `process` (`process`),    KEY `process` (`process`)
984    KEY `complete` (`complete`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
985    
986  # Host: localhost  # Host: localhost
987  # Database: leafok  # Database: leafok
# Line 1097  CREATE TABLE `user_pubinfo` ( Line 1021  CREATE TABLE `user_pubinfo` (
1021    KEY `exp` (`exp`),    KEY `exp` (`exp`),
1022    KEY `last_login_dt` (`last_login_dt`),    KEY `last_login_dt` (`last_login_dt`),
1023    KEY `subscribe_jid` (`subscribe_jid`)    KEY `subscribe_jid` (`subscribe_jid`)
1024  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1025    
1026  # Host: localhost  # Host: localhost
1027  # Database: leafok  # Database: leafok
# Line 1106  CREATE TABLE `user_pubinfo` ( Line 1030  CREATE TABLE `user_pubinfo` (
1030  CREATE TABLE `user_reginfo` (  CREATE TABLE `user_reginfo` (
1031    `UID` mediumint(9) NOT NULL default '0',    `UID` mediumint(9) NOT NULL default '0',
1032    `name` varchar(10) default NULL,    `name` varchar(10) default NULL,
1033    `birthday` date default NULL,    `birthday` datetime default NULL,
1034    `address` varchar(80) default NULL,    `address` varchar(80) default NULL,
1035    `tel` varchar(20) default NULL,    `tel` varchar(20) default NULL,
1036    `postcode` varchar(6) default NULL,    `postcode` varchar(6) default NULL,
# Line 1118  CREATE TABLE `user_reginfo` ( Line 1042  CREATE TABLE `user_reginfo` (
1042    `signup_ip` varchar(20) default NULL,    `signup_ip` varchar(20) default NULL,
1043    `memo` text,    `memo` text,
1044    PRIMARY KEY  (`UID`)    PRIMARY KEY  (`UID`)
1045  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1046    
1047  # Host: localhost  # Host: localhost
1048  # Database: leafok  # Database: leafok
# Line 1138  CREATE TABLE `user_reginfo_log` ( Line 1062  CREATE TABLE `user_reginfo_log` (
1062    `city` varchar(10) default NULL,    `city` varchar(10) default NULL,
1063    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
1064    KEY `UID` (`UID`)    KEY `UID` (`UID`)
1065  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1066    
1067  # Host: localhost  # Host: localhost
1068  # Database: leafok  # Database: leafok
# Line 1150  CREATE TABLE `user_regverify` ( Line 1074  CREATE TABLE `user_regverify` (
1074    `complete` tinyint(1) unsigned NOT NULL default '0',    `complete` tinyint(1) unsigned NOT NULL default '0',
1075    `set_dt` datetime default NULL,    `set_dt` datetime default NULL,
1076    PRIMARY KEY  (`UID`),    PRIMARY KEY  (`UID`),
1077    UNIQUE KEY `verify_code` (`verify_code`),    UNIQUE KEY `verify_code` (`verify_code`)
1078    KEY `complete` (`complete`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
1079    
1080  # Host: localhost  # Host: localhost
1081  # Database: leafok  # Database: leafok
# Line 1166  CREATE TABLE `user_relation` ( Line 1089  CREATE TABLE `user_relation` (
1089    `last_exp` mediumint(9) NOT NULL default '0',    `last_exp` mediumint(9) NOT NULL default '0',
1090    PRIMARY KEY  (`RID`),    PRIMARY KEY  (`RID`),
1091    UNIQUE KEY `cUID` (`cUID`),    UNIQUE KEY `cUID` (`cUID`),
1092    KEY `pUID` (`pUID`),    KEY `pUID` (`pUID`)
1093    KEY `enable` (`enable`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 ) TYPE=MyISAM;  
1094    
1095  # Host: localhost  # Host: localhost
1096  # Database: leafok  # Database: leafok
# Line 1181  CREATE TABLE `user_score` ( Line 1103  CREATE TABLE `user_score` (
1103    `exp_left` mediumint(9) NOT NULL default '0',    `exp_left` mediumint(9) NOT NULL default '0',
1104    PRIMARY KEY  (`UID`),    PRIMARY KEY  (`UID`),
1105    KEY `score` (`score`)    KEY `score` (`score`)
1106  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1107    
1108  # Host: localhost  # Host: localhost
1109  # Database: leafok  # Database: leafok
# Line 1195  CREATE TABLE `user_score_log` ( Line 1117  CREATE TABLE `user_score_log` (
1117    `dt` datetime default NULL,    `dt` datetime default NULL,
1118    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
1119    KEY `UID` (`UID`)    KEY `UID` (`UID`)
1120  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1121    
1122  # Host: localhost  # Host: localhost
1123  # Database: leafok  # Database: leafok
# Line 1208  CREATE TABLE `user_switch_list` ( Line 1130  CREATE TABLE `user_switch_list` (
1130    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
1131    KEY `tUID` (`tUID`),    KEY `tUID` (`tUID`),
1132    KEY `UID` (`UID`)    KEY `UID` (`UID`)
1133  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1134    
1135  # Host: localhost  # Host: localhost
1136  # Database: leafok  # Database: leafok
# Line 1221  CREATE TABLE `user_trust_log` ( Line 1143  CREATE TABLE `user_trust_log` (
1143    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
1144    KEY `tUID` (`tUID`),    KEY `tUID` (`tUID`),
1145    KEY `UID` (`UID`)    KEY `UID` (`UID`)
1146  ) TYPE=MyISAM;  ) 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    
1160  # Host: localhost  # Host: localhost
1161  # Database: leafok  # Database: leafok
# Line 1232  CREATE TABLE `visit_log` ( Line 1166  CREATE TABLE `visit_log` (
1166    `dt` datetime default NULL,    `dt` datetime default NULL,
1167    `ip` varchar(20) default NULL,    `ip` varchar(20) default NULL,
1168    PRIMARY KEY  (`VID`)    PRIMARY KEY  (`VID`)
1169  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   
 # Host: localhost  
 # Database: leafok  
 # Table: 'vmail'  
 #  
 CREATE TABLE `vmail` (  
   `ID` smallint(6) NOT NULL auto_increment,  
   `UID` mediumint(9) NOT NULL default '0',  
   `name` varchar(10) default NULL,  
   `username` varchar(20) NOT NULL default '',  
   `enable` tinyint(1) unsigned NOT NULL default '0',  
   `begin_dt` datetime NOT NULL default '0000-00-00 00:00:00',  
   `end_dt` datetime NOT NULL default '0000-00-00 00:00:00',  
   `memo` text NOT NULL,  
   PRIMARY KEY  (`ID`),  
   KEY `username` (`username`),  
   KEY `enable` (`enable`)  
 ) TYPE=MyISAM;  
1170    
1171  # Host: localhost  # Host: localhost
1172  # Database: leafok  # Database: leafok
# Line 1263  CREATE TABLE `vote_answer` ( Line 1179  CREATE TABLE `vote_answer` (
1179    `count` smallint(6) NOT NULL default '0',    `count` smallint(6) NOT NULL default '0',
1180    PRIMARY KEY  (`AID`),    PRIMARY KEY  (`AID`),
1181    KEY `VID` (`VID`)    KEY `VID` (`VID`)
1182  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1183    
1184  # Host: localhost  # Host: localhost
1185  # Database: leafok  # Database: leafok
# Line 1277  CREATE TABLE `vote_config` ( Line 1193  CREATE TABLE `vote_config` (
1193    `end_dt` datetime default NULL,    `end_dt` datetime default NULL,
1194    `enable` tinyint(1) unsigned NOT NULL default '1',    `enable` tinyint(1) unsigned NOT NULL default '1',
1195    PRIMARY KEY  (`VID`),    PRIMARY KEY  (`VID`),
   KEY `enable` (`enable`),  
1196    KEY `begin_dt` (`begin_dt`),    KEY `begin_dt` (`begin_dt`),
1197    KEY `end_dt` (`end_dt`)    KEY `end_dt` (`end_dt`)
1198  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1199    
1200  # Host: localhost  # Host: localhost
1201  # Database: leafok  # Database: leafok
# Line 1297  CREATE TABLE `vote_log` ( Line 1212  CREATE TABLE `vote_log` (
1212    KEY `UID` (`UID`),    KEY `UID` (`UID`),
1213    KEY `VID` (`VID`),    KEY `VID` (`VID`),
1214    KEY `AID` (`AID`)    KEY `AID` (`AID`)
1215  ) TYPE=MyISAM;  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1216    

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1