DEDECMS database Structure table name: Dede_member_person

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

table name: Dede_member_person


(ENGINE=MYISAM/CHARSET=GBK) Description: Personal Details table field name Description Description specific Parameters Tel number varchar Not NULL, nature set (' Extrovert ', ' introverted ', ' lively and cheerful ', ' Uninhibited ', ' swayed ', ' impulsive ', ' humorous ', ' sedate ', ' frivolous ', ' taciturn ', ' sentimental ', ' happy when sad ', ' arty ', ' glib ', ' strong ', ' fragile ', ' naïve ', ' mature ', ' careless ', ' beggar-thy-neighbour ', ' cunning fickle ', ' Extensive communication ', ' indecision ', ' selfish ', ' sincerity ', ' independence ', ' reliance ', ' elusive ', ' pessimistic negative ', ' sullen ', ' timid ', ' optimistic ', ' willful ', ' conceited ', ' inferiority ', ' Gold digger ', ' gentle and thoughtful ', ' cautious ', ' violent tendencies ', ' Grin, ' sloppy ', ' grumpy ', ' stubborn ', ' forthright ', ' shy ', ' "", "Dare to do", ' helping others ', ' upright ', ' hypocrisy ', ' withdrawn ', ' honest ', ' old fashioned ', ' sensitive ', ' insensitive ', ' ' sissy ', ' arbitrary ', ' decisive ', ' mean ' DEFAULT null, House housing smallint (6) NOT null default ' 0 ', datingtype dating smallint (6) NOT null default ' 0 ', drink whether drinking smallint (6) Not null default ' 0 ', height height smallint (5) unsigned NOT null default ' 160 ', uhttp://www.aliyun.com/zixun/aggregation/ 11696.html ">name nickname char" not NULL, birthday birthday date not null default ' 1980-01-01 ', Blood blood type smallint (6) NOT NULL default ' 0 ', address home addresses varchar NOT NULL, star constellation smallint (6) unsigned NOT null DEFAULT ' 1 ', Vocation industry smallint (6) NOT NULL Defau LT ' 0 ', marital marriage smallint (6) NOT null default ' 0 ', QQ QQ number char (NOT NULL, uptime update time int (a) unsigned NOT null default ' 0 ', education Educational degree smallint (6) Not N ull default ' 0 ', bodytype body smallint (6) Not NULL DEFAULT ' 0 ', language language set (' Mandarin ', ' Shanghai dialect ', ' Cantonese ', ' English ', ' Japanese ', ' Korean ', ' French ', ' Italian ', ' German ', ' Spanish ', ' Russian ', ' Arabic ', DEFAULT null, mobile phone varchar NOT NULL, LOVEMSG life Maxim varchar (MB) NOT null, sex sex enum ( ' Male ', ' female ', ' confidential ', NOT null default ' man ', Mid Member ID mediumint (8) unsigned NOT NULL default ' 0 ', onlynet contact method limit tinyint (1) unsigned not Null default ' 1 ', MSN MSN char (not NULL, location is currently located smallint (5) unsigned NOT null default ' 0 ', Smoke smoke smallint (6) Not NU LL DEFAULT ' 0 ', income revenue smallint (6) NOT null default ' 0 ', Oldplace home smallint (5) unsigned NOT null default ' 0 ', index:


PRIMARY KEY (' mid ')