auth 
- 新しい認証用
- 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 | +--------------------------------------+----------------------------------+----------------------------------+--------------------------------------+-------------+
Counter: 889,
today: 2,
yesterday: 0
最終更新: 2013-01-20 (日) 12:09:44 (JST) (3968d) by iseki
