Presence
From OpenSimulator
(Difference between revisions)
(Created page with "<pre> +-----------------+--------------+------+-----+--------------------------------------+-----------------------------+ | Field | Type | Null | Key | Default...") |
(Created) |
||
| Line 1: | Line 1: | ||
| − | < | + | __NOTOC__ |
| − | + | {{Quicklinks}} | |
| − | + | <br /> | |
| − | + | ||
| − | | UserID | + | The '''Presence''' table contains region and session information for currently logged in users. Used for IM routing amongst other things. (back to [[Database Documentation]]) |
| − | | RegionID | + | <br /> |
| − | | SessionID | + | <br /> |
| − | | SecureSessionID | char(36) | + | |
| − | | LastSeen | + | == Presence Table Structure == |
| − | + | ||
| − | </ | + | The structure of the Presence table is as follows: |
| + | <br /> | ||
| + | {| style="border:1px solid #ccc;" | ||
| + | |- style="background:#eef;" | ||
| + | ! Field | ||
| + | ! Type | ||
| + | ! Collation | ||
| + | ! Attributes | ||
| + | ! Null | ||
| + | ! Default | ||
| + | ! Extra | ||
| + | |- | ||
| + | | '''[[#userID|UserID]]''' || varchar(255) || utf8_general_ci || || No || NULL || | ||
| + | |- | ||
| + | | '''[[#regionID|RegionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 || | ||
| + | |- | ||
| + | | '''[[#sessionID|SessionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 || | ||
| + | |- | ||
| + | | '''[[#secureSessionID|SecureSessionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 || | ||
| + | |- | ||
| + | | '''[[#lastSeen|LastSeen]]''' || timestamp || utf8_general_ci || || No || CURRENT_TIMESTAMP || | ||
| + | |} | ||
| + | |||
| + | <br /> | ||
| + | <br /> | ||
| + | |||
| + | == Presence Fields == | ||
| + | |||
| + | ;<div id="userID">'''UserID'''</div> | ||
| + | :The UUID of an avatar | ||
| + | |||
| + | ;<div id="regionID">'''RegionID'''</div> | ||
| + | :The UUID of the region in which the avatar is currently located | ||
| + | |||
| + | ;<div id="sessionID">'''SessionID'''</div> | ||
| + | :A UUID for the avatars current session | ||
| + | |||
| + | ;<div id="lastSeen">'''LastSeen'''</div> | ||
| + | :The last time the avatar was seen online | ||
| + | |||
| + | <br /> | ||
| + | |||
| + | ---- | ||
| + | |||
| + | (back to [[Database Documentation]]) | ||
| + | |||
| + | <br /> | ||
| + | |||
| + | [[Category:Database]] | ||
Revision as of 16:55, 11 April 2016
 |
Languages: |
|
The Presence table contains region and session information for currently logged in users. Used for IM routing amongst other things. (back to Database Documentation)
Presence Table Structure
The structure of the Presence table is as follows:
| Field | Type | Collation | Attributes | Null | Default | Extra |
|---|---|---|---|---|---|---|
| UserID | varchar(255) | utf8_general_ci | No | NULL | ||
| RegionID | char(36) | utf8_general_ci | No | 00000000-0000-0000-0000-000000000000 | ||
| SessionID | char(36) | utf8_general_ci | No | 00000000-0000-0000-0000-000000000000 | ||
| SecureSessionID | char(36) | utf8_general_ci | No | 00000000-0000-0000-0000-000000000000 | ||
| LastSeen | timestamp | utf8_general_ci | No | CURRENT_TIMESTAMP |
Presence Fields
- UserID
- The UUID of an avatar
- RegionID
- The UUID of the region in which the avatar is currently located
- SessionID
- A UUID for the avatars current session
- LastSeen
- The last time the avatar was seen online
(back to Database Documentation)
