|
Cur: 2013-01-20 (Sun) 12:06:38 iseki  |
| | + | *** Presence [#m5984e5b] |
| | + | - アバタのアクセス情報． |
| | + | mysql> show columns from Presence; |
| | + | +-----------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +-----------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | UserID | varchar(255) | NO | MUL | NULL | | |
| | + | | RegionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| | + | | SessionID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | | |
| | + | | SecureSessionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| | + | +-----------------+--------------+------+-----+--------------------------------------+-------+ |
| | | | |
| | + | - [[GridUser>../GridUser]]が作られる以前 |
| | + | mysql> show columns from Presence; |
| | + | +-----------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +-----------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | UserID | varchar(255) | NO | MUL | NULL | | |
| | + | | RegionID | char(36) | NO | | NULL | | |
| | + | | SessionID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | | |
| | + | | SecureSessionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| | + | | Online | char(5) | NO | | false | | |
| | + | | Login | char(16) | NO | | 0 | | |
| | + | | Logout | char(16) | NO | | 0 | | |
| | + | | Position | char(64) | NO | | <0,0,0> | | |
| | + | | LookAt | char(64) | NO | | <0,0,0> | | |
| | + | | HomeRegionID | char(36) | NO | | NULL | | |
| | + | | HomePosition | char(64) | NO | | <0,0,0> | | |
| | + | | HomeLookAt | char(64) | NO | | <0,0,0> | | |
| | + | +-----------------+--------------+------+-----+--------------------------------------+-------+ |
