您当前的位置:首页 > 网站建设笔记 >

ecshop update_user_info更新会员信息

0
ecs_users 表的结构
名字类型整理属性默认额外注释
user_idmediumint(8)UNSIGNEDAUTO_INCREMENT会员ID
aite_idtextutf8_general_ci
emailvarchar(60)utf8_general_ci会员邮箱地址
user_namevarchar(60)utf8_general_ci用户名
passwordvarchar(32)utf8_general_ci登录密码
questionvarchar(255)utf8_general_ci安全问题
answervarchar(255)utf8_general_ci安全问题答案
sextinyint(1)UNSIGNED0性别(0保密,1男,2女)
birthdaydate0000-00-00生日日期
user_moneydecimal(10,2)0.00用户现有资金
frozen_moneydecimal(10,2)0.00用户冻结资金
pay_pointsint(10)UNSIGNED0消费积分
rank_pointsint(10)UNSIGNED0会员等级积分
address_idmediumint(8)UNSIGNED0收货信息ID,取值表ecs_user_address
reg_timeint(10)UNSIGNED0用户注册时间
last_loginint(11)UNSIGNED0用户最后一次登录时间
last_timedatetime0000-00-00 00:00:00
last_ipvarchar(15)utf8_general_ci用户最后一次登录IP
visit_countsmallint(5)UNSIGNED0登录次数
user_ranktinyint(3)UNSIGNED0会员等级ID,取值表ecs_user_rank
is_specialtinyint(3)UNSIGNED0
ec_saltvarchar(10)utf8_general_ciNULL
saltvarchar(10)utf8_general_ci0
parent_idmediumint(9)0推荐人会员ID
flagtinyint(3)UNSIGNED0
aliasvarchar(60)utf8_general_ci昵称
msnvarchar(60)utf8_general_ci
qqvarchar(20)utf8_general_ci
office_phonevarchar(20)utf8_general_ci
home_phonevarchar(20)utf8_general_ci
mobile_phonevarchar(20)utf8_general_ci
is_validatedtinyint(3)UNSIGNED0
credit_linedecimal(10,2)UNSIGNED信用额度(商店等给予顾客的赊账最高额)
passwd_questionvarchar(50)utf8_general_ciNULL
passwd_answervarchar(255)utf8_general_ciNULL
wxidchar(28)utf8_general_ci
wxch_bdchar(2)utf8_general_ci
nichengvarchar(255)utf8_general_ciNULL
password_xkflavarchar(40)utf8_general_ci
顶部中部底部