DedeCMS二次开发手册
|
||
dede_member|会员表
|
字段 |
类型 |
整理 |
属性 |
Null |
默认 |
额外 |
|
mid |
mediumint(8) |
|
UNSIGNED |
是 |
NULL |
会员ID |
|
mtype |
enum('个人','企业') |
utf8_general_ci |
|
是 |
个人 |
会员类型 |
|
userid |
char(20) |
utf8_general_ci |
|
是 |
|
注册用户名 |
|
pwd |
char(32) |
utf8_general_ci |
|
是 |
|
密码 |
|
uname |
char(36) |
utf8_general_ci |
|
是 |
|
昵称 |
|
sex |
enum('男','女','保密') |
utf8_general_ci |
|
是 |
保密 |
性别 |
|
rank |
smallint(5) |
|
UNSIGNED |
是 |
0 |
会员级别值 |
|
uprank |
smallint(5) |
|
UNSIGNED |
是 |
0 |
是否待升级 |
|
money |
mediumint(8) |
|
UNSIGNED |
是 |
0 |
会员金币 |
|
upmoney |
smallint(5) |
|
UNSIGNED |
是 |
0 |
是否待充值 |
|
|
char(50) |
utf8_general_ci |
|
是 |
|
|
|
scores |
mediumint(8) |
|
UNSIGNED |
是 |
0 |
积分 |
|
matt |
smallint(5) |
|
UNSIGNED |
是 |
0 |
推荐 |
|
spacesta |
smallint(6) |
|
|
是 |
0 |
会员空间状况 |
|
face |
char(50) |
utf8_general_ci |
|
是 |
|
头像 |
|
safequestion |
smallint(5) |
|
UNSIGNED |
是 |
0 |
安全提示问题 |
|
safeanswer |
char(30) |
utf8_general_ci |
|
是 |
|
安全提示问题答案 |
|
jointime |
int(10) |
|
UNSIGNED |
是 |
0 |
注册时间 |
|
joinip |
char(16) |
utf8_general_ci |
|
是 |
|
注册IP |
|
logintime |
int(10) |
|
UNSIGNED |
是 |
0 |
登陆时间 |
|
loginip |
char(16) |
utf8_general_ci |
|
是 |
|
登陆IP |