OpenSim/DB/0.7.5/auth

auth†[edit]

• 新しい認証用
• 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 |
+--------------------------------------+----------------------------------+----------------------------------+--------------------------------------+-------------+

最新の30件

[edit]