GridUser
From OpenSimulator
(Difference between revisions)
(Updated to use structure of other database documentation pages) |
(Filled in details about the table fields. Corrected some C&P errors.) |
||
| Line 3: | Line 3: | ||
<br /> | <br /> | ||
| − | The '''GridUser''' table records information about | + | The '''GridUser''' table records information about avatars using the grid (back to [[Database Documentation]]) |
<br /> | <br /> | ||
<br /> | <br /> | ||
| − | == | + | == GridUser Table Structure == |
| − | The structure of the | + | The structure of the GridUser table is as follows: |
<br /> | <br /> | ||
{| style="border:1px solid #ccc;" | {| style="border:1px solid #ccc;" | ||
| Line 52: | Line 52: | ||
;<div id="homeRegion">'''HomeRegionID'''</div> | ;<div id="homeRegion">'''HomeRegionID'''</div> | ||
| − | : | + | :The UUID of the avatars home region |
<br /> | <br /> | ||
;<div id="homePos">'''HomePosition'''</div> | ;<div id="homePos">'''HomePosition'''</div> | ||
| − | : | + | :The UUID of the |
<br /> | <br /> | ||
;<div id="homeLookAt">'''HomeLookAt'''</div> | ;<div id="homeLookAt">'''HomeLookAt'''</div> | ||
| − | : | + | :The direction an avatar will be facing when they login to their home |
<br /> | <br /> | ||
;<div id="lastRegion">'''LastRegionID'''</div> | ;<div id="lastRegion">'''LastRegionID'''</div> | ||
| − | : | + | :The UUID of the last region the avatar was in |
<br /> | <br /> | ||
;<div id="lastLookAt">'''LastPosition'''</div> | ;<div id="lastLookAt">'''LastPosition'''</div> | ||
| − | : | + | :The coordinates of the last position the avatar was in their last region |
<br /> | <br /> | ||
;<div id="online">'''LastLookAt'''</div> | ;<div id="online">'''LastLookAt'''</div> | ||
| − | : | + | :The direction an avatar was last facing |
<br /> | <br /> | ||
;<div id="login">'''Online'''</div> | ;<div id="login">'''Online'''</div> | ||
| − | : | + | :A boolean value indicating whether the avatar is currently logged in |
<br /> | <br /> | ||
;<div id="login">'''Login'''</div> | ;<div id="login">'''Login'''</div> | ||
| − | : | + | :A unix timestamp indicating the last time the avatar logged in |
<br /> | <br /> | ||
;<div id="logout">'''Logout'''</div> | ;<div id="logout">'''Logout'''</div> | ||
| − | : | + | :A unix timestamp indicating the last time the avatar logged out |
<br /> | <br /> | ||
Revision as of 15:00, 11 April 2016
 |
Languages: |
|
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)
