- ソース を表示
- OpenSim/DB/0.7.0/auth へ行く。
現: 2013-01-20 (日) 12:09:44 iseki ![]() |
|||
---|---|---|---|
Line 1: | Line 1: | ||
+ | *** 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 | | ||
+ | +--------------------------------------+----------------------------------+----------------------------------+--------------------------------------+-------------+ |
- OpenSim/DB/0.7.0/auth のバックアップ差分(No. All)
- 現: 2013-01-20 (日) 12:09:44 iseki