|
Cur: 2013-01-20 (Sun) 12:09:20 iseki  |
| | + | *** UserAccounts [#k81079c2] |
| | + | - アバターアカウントの状態 |
| | + | - 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 | | |
| | + | +--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+ |
