discuz 注册用户用到的几个表

通过开启记录:mysql记录日志,筛出如下信息:

INSERT INTO `userclub`.pre_ucenter_members SET  secques='', username='pthlp1', password='083ed412c755e19ab2669c298b215b64', email='qqqwew@qq.com', regip='127.0.0.1', regdate='1456454837', salt='57c4c8'
INSERT INTO `userclub`.pre_ucenter_memberfields SET uid='658'
REPLACE INTO pre_common_member SET `uid`='658' , `username`='pthlp1' , `password`='8f28cfb505f1b2d47e71caebc532cccc' , `email`='qqqwew@qq.com' , `adminid`='0' , `groupid`='10' , `regdate`='1456454837' , `emailstatus`='0' , `credits`='0' , `timeoffset`='9999'
REPLACE INTO pre_common_member_status SET `uid`='658' , `regip`='Manual Acting' , `lastip`='Manual Acting' , `lastvisit`='1456454837' , `lastactivity`='1456454837' , `lastpost`='0' , `lastsendmail`='0'
REPLACE INTO pre_common_member_count SET `uid`='658' , `extcredits1`='0' , `extcredits2`='0' , `extcredits3`='0' , `extcredits4`='0' , `extcredits5`='0' , `extcredits6`='0' , `extcredits7`='0' , `extcredits8`='0'
REPLACE INTO pre_common_member_profile SET `uid`='658'
REPLACE INTO pre_common_member_field_forum SET `uid`='658'
REPLACE INTO pre_common_member_field_home SET `uid`='658'

可以看到增加了:

ucenter两个表:pre_ucenter_members、pre_ucenter_memberfields

conmon_member部分:6个表;

如单独做个登录接口,比较有用;

原文地址:https://www.cnblogs.com/pthlp/p/5219734.html