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个表;
如单独做个登录接口,比较有用;