Database:Agents

From OpenSimulator

Jump to: navigation, search

agents Records agent (Avatar/User) login details      (back to Database Documentation)


The current structure of the agents table is as follows:



Field
TypeNullKeyDefaultExtra
 
UUIDvarchar(36)NOPRINULL 
sessionIDvarchar(36)NOUNINULL
secureSessionIDvarchar(36)NOUNINULL
agentIPvarchar(16)NONULL
agentPortint(11)NONULL
agentOnlinetinyint(4)NONULL
loginTimeint(11)NONULL
logoutTimeint(11)NONULL
currentRegionvarchar(36)NONULL
currentHandlebigint(20) unsignedNONULL
currentPosvarchar(64)NONULL
currentLookAtvarchar(36)NONULL



      (back to Database Documentation)


UUID
The UUID uniquely identifies the avatar associated with the user's account. This master ID 'number' is used for everything the avatar interacts with - it is used to determine permissions, identify belongings, and route messages to and from system and other avatars.

sessionID
For Future Use

SecureSessionID
For Future Use

agentIP
IP address of logged-in agent?
Does not appear to be updated at this time

agentPort
Port the agent is connected on
Does not appear to be updated at this time

agentOnLine
Status of agent (Online/Offline)

loginTime
Time the agent last logged in

logoutTime
Time the agent last logged out

currentRegion
Region UUID for the region the av is presently resident within

currentHandle
Records the grid position of the region the av is presently resident within

currentPos
Records the av's current position with the region in which it is currently resident

currentLookAt
The direction the agent is facing given as x, y and z co-ordinates relative to "currentPos"


      (back to Database Documentation)

Personal tools
General
About This Wiki