网络营销电子商务研究中心 - 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';