OpenSim​/DB​/0.7.5​/Presence

Presence

• アバタのアクセス情報．

  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が作られる以前

  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>                              |       | 
  +-----------------+--------------+------+-----+--------------------------------------+-------+