UserAccounts 
- アバターアカウントの状態
- create userコマンドでアバター登録時に作成される.
mysql> show columns from UserAccounts; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | PrincipalID | char(36) | NO | PRI | NULL | | | ScopeID | char(36) | NO | | NULL | | | FirstName | varchar(64) | NO | MUL | NULL | | | LastName | varchar(64) | NO | MUL | NULL | | | Email | varchar(64) | YES | MUL | NULL | | | ServiceURLs | text | YES | | NULL | | | Created | int(11) | YES | | NULL | | | UserLevel | int(11) | NO | | 0 | | | UserFlags | int(11) | NO | | 0 | | | UserTitle | varchar(64) | NO | | | | +-------------+-------------+------+-----+---------+-------+
mysql> select * from UserAccounts; +--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+ | PrincipalID | ScopeID | FirstName | LastName | Email | ServiceURLs | Created | UserLevel | UserFlags | UserTitle | +--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+ | 4a1d4c70-ab8c-47be-a4d1-c914fd42413d | 00000000-0000-0000-0000-000000000000 | TEST | TEST | | HomeURI= GatekeeperURI= InventoryServerURI= AssetServerURI= | 0 | 0 | 0 | | | 018fdfb4-3667-4d49-a5ad-10c21ad5c463 | 00000000-0000-0000-0000-000000000000 | AAAA | AAAA | eeeeeeeee@jp | HomeURI= GatekeeperURI= InventoryServerURI= AssetServerURI= | 0 | 0 | 0 | | +--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+
Counter: 1063,
today: 1,
yesterday: 0
最終更新: 2013-01-20 (日) 12:09:20 (JST) (4409d) by iseki