1: 2010-03-30 (火) 13:56:39 iseki  |
2: 2010-03-30 (火) 14:03:20 iseki |
| - | *** Presence [#p0dc22b9] | + | *** UserAccounts [#tdaaf7eb] |
| - | - | + | - アバターアカウントの状態 |
| - | mysql> show columns from Presence; | + | mysql> show columns from UserAccounts; |
| - | +-----------------+--------------+------+-----+--------------------------------------+-------+ | + | +-------------+-------------+------+-----+---------+-------+ |
| - | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
| - | +-----------------+--------------+------+-----+--------------------------------------+-------+ | + | +-------------+-------------+------+-----+---------+-------+ |
| - | | UserID | varchar(255) | NO | MUL | NULL | | | + | | PrincipalID | char(36) | NO | PRI | NULL | | |
| - | | RegionID | char(36) | NO | | NULL | | | + | | ScopeID | char(36) | NO | | NULL | | |
| - | | SessionID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | | | + | | FirstName | varchar(64) | NO | MUL | NULL | | |
| - | | SecureSessionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | + | | LastName | varchar(64) | NO | MUL | NULL | | |
| - | | Online | char(5) | NO | | false | | | + | | Email | varchar(64) | YES | MUL | NULL | | |
| - | | Login | char(16) | NO | | 0 | | | + | | ServiceURLs | text | YES | | NULL | | |
| - | | Logout | char(16) | NO | | 0 | | | + | | Created | int(11) | YES | | NULL | | |
| - | | Position | char(64) | NO | | <0,0,0> | | | + | | UserLevel | int(11) | NO | | 0 | | |
| - | | LookAt | char(64) | NO | | <0,0,0> | | | + | | UserFlags | int(11) | NO | | 0 | | |
| - | | HomeRegionID | char(36) | NO | | NULL | | | + | | UserTitle | varchar(64) | NO | | | | |
| - | | HomePosition | char(64) | NO | | <0,0,0> | | | + | +-------------+-------------+------+-----+---------+-------+ |
| - | | HomeLookAt | char(64) | NO | | <0,0,0> | | | + | |
| - | +-----------------+--------------+------+-----+--------------------------------------+-------+ | + | |
