Database:Avatarappearance

From OpenSimulator

Revision as of 15:55, 22 July 2008 by Twitch (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

avatarappearance Records avatar appearance details      (back to Database Documentation)


The current structure of the avatar appearance 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



      (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 logged in at

logoutTime
Time the agent logged out at

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


      (back to Database Documentation)

Personal tools
General
About This Wiki