1: 2010-03-30 (火) 13:56:39 iseki |
現: 2010-04-01 (木) 10:17:22 iseki |
- | *** Presence [#p0dc22b9] | + | *** UserAccounts [#tdaaf7eb] |
- | - | + | - アバターアカウントの状態 |
- | mysql> show columns from Presence; | + | - create userコマンドでアバター登録時に作成される. |
- | +-----------------+--------------+------+-----+--------------------------------------+-------+ | + | |
- | | Field | Type | Null | Key | Default | Extra | | + | mysql> show columns from UserAccounts; |
- | +-----------------+--------------+------+-----+--------------------------------------+-------+ | + | +-------------+-------------+------+-----+---------+-------+ |
- | | UserID | varchar(255) | NO | MUL | NULL | | | + | | Field | Type | Null | Key | Default | Extra | |
- | | RegionID | char(36) | NO | | NULL | | | + | +-------------+-------------+------+-----+---------+-------+ |
- | | SessionID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | | | + | | PrincipalID | char(36) | NO | PRI | NULL | | |
- | | SecureSessionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | + | | ScopeID | char(36) | NO | | NULL | | |
- | | Online | char(5) | NO | | false | | | + | | FirstName | varchar(64) | NO | MUL | NULL | | |
- | | Login | char(16) | NO | | 0 | | | + | | LastName | varchar(64) | NO | MUL | NULL | | |
- | | Logout | char(16) | NO | | 0 | | | + | | Email | varchar(64) | YES | MUL | NULL | | |
- | | Position | char(64) | NO | | <0,0,0> | | | + | | ServiceURLs | text | YES | | NULL | | |
- | | LookAt | char(64) | NO | | <0,0,0> | | | + | | Created | int(11) | YES | | NULL | | |
- | | HomeRegionID | char(36) | NO | | NULL | | | + | | UserLevel | int(11) | NO | | 0 | | |
- | | HomePosition | char(64) | NO | | <0,0,0> | | | + | | UserFlags | int(11) | NO | | 0 | | |
- | | HomeLookAt | char(64) | NO | | <0,0,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 | | |
| + | +--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+ |