GridUser

From OpenSimulator

Revision as of 15:00, 11 April 2016 by Kcozens (Talk | contribs)

Jump to: navigation, search


The GridUser table records information about avatars using the grid       (back to Database Documentation)

GridUser Table Structure

The structure of the GridUser table is as follows:

Field Type Collation Attributes Null Default Extra
UserID varchar(255) utf8_general_ci No NULL
HomeRegionID char(36) utf8_general_ci No 00000000-0000-0000-0000-000000000000
HomePosition char(64) utf8_general_ci No <0,0,0>
HomeLookAt char(64) utf8_general_ci No <0,0,0>
LastRegionID char(36) utf8_general_ci No 00000000-0000-0000-0000-000000000000
LastPosition char(64) utf8_general_ci No <0,0,0>
LastLookAt char(64) utf8_general_ci No <0,0,0>
Online char(5) utf8_general_ci No false
Login char(16) utf8_general_ci No 0
Logout char(16) utf8_general_ci No 0



GridUsers Fields

UserID
The UUID of an avatar


HomeRegionID
The UUID of the avatars home region


HomePosition
The UUID of the


HomeLookAt
The direction an avatar will be facing when they login to their home


LastRegionID
The UUID of the last region the avatar was in


LastPosition
The coordinates of the last position the avatar was in their last region


LastLookAt
The direction an avatar was last facing


Online
A boolean value indicating whether the avatar is currently logged in


Login
A unix timestamp indicating the last time the avatar logged in


Logout
A unix timestamp indicating the last time the avatar logged out




      (back to Database Documentation)


Personal tools
General
About This Wiki