Database:Agents
From OpenSimulator
(Difference between revisions)
| Line 19: | Line 19: | ||
</table> | </table> | ||
<br> | <br> | ||
| + | <hr> | ||
| + | '''UUID''' | ||
| + | <br> | ||
| + | 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. | ||
| + | <br> | ||
| + | <br> | ||
| + | '''sessionID''' | ||
| + | <br> | ||
| + | |||
| + | |||
| + | secureSessionID | ||
| + | agentIP | ||
| + | agentPort | ||
| + | agentOnLine | ||
| + | loginTime | ||
| + | logoutTime | ||
| + | currentRegion | ||
| + | currentHandle | ||
| + | currentPos | ||
Revision as of 14:33, 21 July 2008
agents Records agent (Avatar/User) login details
The current structure of the agents table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| UUID | varchar(36) | NO | PRI | NULL | ||
| sessionID | varchar(36) | NO | UNI | NULL | ||
| secureSessionID | varchar(36) | NO | UNI | NULL | ||
| agentIP | varchar(16) | NO | NULL | |||
| agentPort | int(11) | NO | NULL | |||
| agentOnline | tinyint(4) | NO | NULL | |||
| loginTime | int(11) | NO | NULL | |||
| logoutTime | int(11) | NO | NULL | |||
| currentRegion | varchar(36) | NO | NULL | |||
| currentHandle | bigint(20) unsigned | NO | NULL | |||
| currentPos | varchar(64) | NO | NULL |
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
secureSessionID
agentIP
agentPort
agentOnLine
loginTime
logoutTime
currentRegion
currentHandle
currentPos
