DEDECMS database Structure table name: Dede_member

DEDECMS database Structure table name: Dede_member field description is as follows:

table name: Dede_member


(ENGINE=MYISAM/CHARSET=GBK) Description: Member table field name description describes specific parameters uptime update time int (one) not NULL DEFAULT ' 0 ', safequestion security hint problem smallint (5) unsigned NOT NULL default ' 0 ', safeanswer security answer char (= NOT NULL, SPACESTA member space status smallint (6) NOT null default ' 0 ', Money member coin Mediumint (8) unsigned NOT NULL default ' 0 ', Matt recommends smallint (5) unsigned NOT null default ' 0 ', Loginip logon IP char (not NULL, u Serid http://www.aliyun.com/zixun/aggregation/10733.html "> registered username char (not NULL), Mid Member ID mediumint (8) unsigned Not NULL auto_increment, rank member level value smallint (5) unsigned NOT null default ' 0 ', sex sex enum (' Male ', ' female ', ' confidential ') NOT NULL default ' confidential ', Mtype member type varchar NOT NULL DEFAULT ' personal ', uname nickname char (+) not NULL, PWD user password char (m) not NULL, email mailbox char (NOT NULL) , Jointime registration time Int (a) unsigned NOT null default ' 0 ', scores integral Mediumint (8) unsigned NOT NULL default ' 0 ', logintime logon time int (1 0) unsigned not null DEFAULT ' 0 ', Joinip registered IP char (not NULL, face Avatar char () NOT NULL, EXPTIMe Expiration Time smallint (6) Not NULL DEFAULT ' 0 ', index:


PRIMARY KEY (' mid '),


KEY ' userid ' (' userid ', ' sex '),


KEY ' logintime ' (' logintime ')