【求教】SQL语句注册法建立用户表-账号“1”密码“1”权限“4”
老端注册方式insert into account(username,sha_pass_hash,expansion,joindate,email) values('1',SHA1(CONCAT(UPPER('1'),':',UPPER('1'))),4,NOW(),'1@qq.com');
下面两句语句是通过其他注册方式导出的INSERT INTO `acore_auth`.`account` (`id`, `username`, `salt`, `verifier`, `session_key`, `totp_secret`, `email`, `reg_mail`, `joindate`, `last_ip`, `last_attempt_ip`, `failed_logins`, `locked`, `lock_country`, `last_login`, `online`, `expansion`, `mutetime`, `mutereason`, `muteby`, `locale`, `os`, `recruiter`, `totaltime`) VALUES (8, '1', 0x9E2A50A547E050DCFF1DCC9C842779D6E393CA3C15BA3AD27C43918F175D5F68, 0x618038D90E28686994997AAC0872F5C8A584CB089E0ADAF23EE49624D8B8CF7C, NULL, NULL, '', '', '2024-05-29 20:15:26', '127.0.0.1', '127.0.0.1', 0, 0, '00', NULL, 0, 2, 0, '', '', 0, '', 0, 0);
