Database:Agents

From OpenSimulator

Revision as of 11:46, 21 July 2008 by Twitch (Talk | contribs)

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

agents Records agent (Avatar/User) login details
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
currentHandle | bigint(20) unsigned | NO | | NULL | |
currentPos | varchar(64) | NO | | NULL | |

</code>