Presence
From OpenSimulator
(Difference between revisions)
(Created) |
m (Changed colour of table headers and alternate lines in Table Structure table) |
||
| Line 12: | Line 12: | ||
<br /> | <br /> | ||
{| style="border:1px solid #ccc;" | {| style="border:1px solid #ccc;" | ||
| − | |- style="background:# | + | |- style="background:#cce;" |
! Field | ! Field | ||
! Type | ! Type | ||
| Line 22: | Line 22: | ||
|- | |- | ||
| '''[[#userID|UserID]]''' || varchar(255) || utf8_general_ci || || No || NULL || | | '''[[#userID|UserID]]''' || varchar(255) || utf8_general_ci || || No || NULL || | ||
| − | |- | + | |- style="background:#eee;" |
| '''[[#regionID|RegionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 || | | '''[[#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 || | | '''[[#sessionID|SessionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 || | ||
| − | |- | + | |- style="background:#eee;" |
| '''[[#secureSessionID|SecureSessionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 || | | '''[[#secureSessionID|SecureSessionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 || | ||
|- | |- | ||
Revision as of 16:13, 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)
