GridUser

From OpenSimulator

Jump to: navigation, search


The GridUser table contains information about everyone who uses this particular grid, both local and foreign. It includes their home region, last region, online status, and last login/logout.       (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


      (back to Database Documentation)



GridUser 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