GridUser
From OpenSimulator
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)