Presence

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(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:#eef;"
+
|- 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 17:13, 11 April 2016


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)


Personal tools
General
About This Wiki