View Single Post
  #1   IP: 222.184.47.72
Old 2013-12-19, 10:02 PM
topvip topvip is offline
超级版主
 
Join Date: 2006-01-04
Posts: 1206
topvip 正向着好的方向发展
Default Discuz X3.1用户注册过程SQL

Discuz X2用户注册时需要添加的记录,可以作为批量导入时的参考,以下是添加jack用户的SQL语句:

Code:
SET sql_mode='';

INSERT INTO pre_ucenter_members SET secques='', username='jack', password='e1d9f0cc14abba3ad6f543574d4b47e6', email='jack@0058.net', regip='127.0.0.1', regdate='1387443784', salt='873533';

INSERT INTO pre_ucenter_memberfields SET uid='4';

INSERT INTO pre_common_member SET uid ='4', username ='jack', password ='dfe208d07805d1d6481a5840e271a0ca', email ='jack@0058.net', adminid ='0', groupid ='10', regdate ='1387443784', credits ='0', timeoffset ='9999';

INSERT INTO pre_common_member_status SET uid ='4', regip ='127.0.0.1', lastip ='127.0.0.1', lastvisit ='1387443784', lastactivity ='1387443784', lastpost ='0', lastsendmail ='0';

INSERT INTO pre_common_member_profile SET uid ='4';
INSERT INTO pre_common_member_field_forum SET uid ='4';
INSERT INTO pre_common_member_field_home SET uid ='4';

INSERT INTO pre_common_member_count SET uid ='4', extcredits1 ='0', extcredits2 ='0', extcredits3 ='0', extcredits4 ='0', extcredits5 ='0', extcredits6 ='0', extcredits7 ='0', extcredits8 ='0';
Reply With Quote