Discuz! X2/3 SLQ 新增用戶，使用未使用的UID

波卡

• 前往「管理中心」→「站長」→「數據庫」→「升級」。
• 於「Discuz! 數據庫升級 - 請將數據庫升級語句粘貼在下面:」輸入SQL語法並執行。
  
  [SQL] 純文本查看 復制代碼

  SET sql_mode='';
  
  INSERT INTO pre_ucenter_members SET secques='', uid ='10', username='Skyey', password='047099adb883dc19616dae0ef2adc5b6', email='skyey@skyey.tw', regip='127.0.0.1', regdate='1387443784', salt='873533';
  
  INSERT INTO pre_ucenter_memberfields SET uid ='10';
  
  INSERT INTO pre_common_member SET uid ='10', username ='Skyey', password ='047099adb883dc19616dae0ef2adc5b6', email ='skyey@skyey.tw', adminid ='0', groupid ='10', regdate ='1387443784', credits ='0', timeoffset ='9999';
  
  INSERT INTO pre_common_member_status SET uid ='10', 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 ='10';
  INSERT INTO pre_common_member_field_forum SET uid ='10';
  INSERT INTO pre_common_member_field_home SET uid ='10';
  
  INSERT INTO pre_common_member_count SET uid ='10', extcredits1 ='0', extcredits2 ='0', extcredits3 ='0', extcredits4 ='0', extcredits5 ='0', extcredits6 ='0', extcredits7 ='0', extcredits8 ='0';

  
  

  註解：
  uid ='10' UID為10
  username ='Skyey' 用戶名為"Skyey"
  password ='047099adb883dc19616dae0ef2adc5b6' 密碼為"123456789"
  email ='skyey@skyey.tw' 信箱為"skyey@skyey.tw"

• 新增完畢。