OpenSim/DB/0.7.0/auth の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• OpenSim/DB/0.7.0/auth へ行く。
• OpenSim/DB/0.7.0/auth の差分を削除

#author("2024-09-02T04:33:48+00:00","default:iseki","iseki")
*** auth [#n8007951]
- 新しい認証用
- create user コマンドでアバター登録時に作成される．

 mysql> show columns from auth;
 +--------------+--------------+------+-----+-------------+-------+
 | Field        | Type         | Null | Key | Default     | Extra |
 +--------------+--------------+------+-----+-------------+-------+
 | UUID         | char(36)     | NO   | PRI | NULL        |       | 
 | passwordHash | char(32)     | NO   |     |             |       | 
 | passwordSalt | char(32)     | NO   |     |             |       | 
 | webLoginKey  | varchar(255) | NO   |     |             |       | 
 | accountType  | varchar(32)  | NO   |     | UserAccount |       | 
 +--------------+--------------+------+-----+-------------+-------+

 mysql> select * from auth;
 +--------------------------------------+----------------------------------+----------------------------------+--------------------------------------+-------------+
 | UUID                                 | passwordHash                     | passwordSalt                     | webLoginKey                          | accountType |
 +--------------------------------------+----------------------------------+----------------------------------+--------------------------------------+-------------+
 | 4a1d4c70-ab8c-47be-a4d1-c914fd42413d | aa684cbdbc9944292070345f72e44a9e | b9bfb4cf5916abdf1884a8c69fd5f79f | 00000000-0000-0000-0000-000000000000 | UserAccount |
 | 018fdfb4-3667-4d49-a5ad-10c21ad5c463 | ab0f3a090c293836459fef597ea82dfe | 84a9775d0815ae7730a3e19ff6a94b43 | 00000000-0000-0000-0000-000000000000 | UserAccount |
 +--------------------------------------+----------------------------------+----------------------------------+--------------------------------------+-------------+