Discuz X3.1用户注册过程SQL

[topvip]

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

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';