GridUser

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(Updated to use structure of other database documentation pages)
Line 1: Line 1:
−
<pre>
+
__NOTOC__
−
+--------------+--------------+------+-----+--------------------------------------+-------+
+
{{Quicklinks}}
−
| Field       | Type         | Null | Key | Default                             | Extra |
+
<br />
−
+--------------+--------------+------+-----+--------------------------------------+-------+
+
 
−
| UserID       | varchar(255) | NO  | PRI | NULL                                 |       |
+
The '''GridUser''' table records information about an avatars friends and friendship requests&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
−
| HomeRegionID | char(36)     | NO  |     | 00000000-0000-0000-0000-000000000000 |       |
+
<br />
−
| HomePosition | char(64)     | NO  |     | <0,0,0>                             |       |
+
<br />
−
| HomeLookAt   | char(64)     | NO  |     | <0,0,0>                             |       |
+
 
−
| LastRegionID | char(36)     | NO  |     | 00000000-0000-0000-0000-000000000000 |       |
+
== Friends Table Structure ==
−
| LastPosition | char(64)     | NO  |     | <0,0,0>                             |       |
+
 
−
| LastLookAt   | char(64)     | NO  |     | <0,0,0>                             |       |
+
The structure of the Friends table is as follows:
−
| Online       | char(5)     | NO  |     | false                               |       |
+
<br />
−
| Login       | char(16)     | NO  |     | 0                                   |       |
+
{| style="border:1px solid #ccc;"
−
| Logout       | char(16)     | NO  |     | 0                                   |       |
+
|- style="background:#eef;"
−
+--------------+--------------+------+-----+--------------------------------------+-------+
+
! Field
−
</pre>
+
! Type
 +
! Collation
 +
! Attributes
 +
! Null
 +
! Default
 +
! Extra
 +
|-
 +
| '''[[#userID|UserID]]''' || varchar(255) || utf8_general_ci || || No || NULL ||
 +
|-
 +
| '''[[#homeRegion|HomeRegionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||  
 +
|-
 +
| '''[[#homePos|HomePosition]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||  
 +
|-
 +
| '''[[#homeLookAt|HomeLookAt]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||
 +
|-
 +
| '''[[#lastRegion|LastRegionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||  
 +
|-
 +
| '''[[#astPos|LastPosition]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||  
 +
|-
 +
| '''[[#lastLookAt|LastLookAt]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||
 +
|-
 +
| '''[[#online|Online]]''' || char(5) || utf8_general_ci || || No || false ||  
 +
|-
 +
| '''[[#login|Login]]''' || char(16) || utf8_general_ci || || No || 0 ||  
 +
|-
 +
| '''[[#logout|Logout]]''' || char(16) || utf8_general_ci || || No || 0 ||  
 +
|}
 +
 
 +
<br />
 +
<br />
 +
 
 +
== GridUsers Fields ==
 +
 
 +
;<div id="userID">'''UserID'''</div>
 +
:The UUID of an avatar
 +
<br />
 +
 
 +
;<div id="homeRegion">'''HomeRegionID'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="homePos">'''HomePosition'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="homeLookAt">'''HomeLookAt'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="lastRegion">'''LastRegionID'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="lastLookAt">'''LastPosition'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="online">'''LastLookAt'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="login">'''Online'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="login">'''Login'''</div>
 +
:
 +
<br />
 +
 
 +
;<div id="logout">'''Logout'''</div>
 +
:
 +
<br />
 +
 
 +
<br />
 +
 
 +
----
 +
 
 +
      (back to [[Database Documentation]])
 +
 
 +
<br />
 +
 
 +
[[Category:Database]]

Revision as of 14:18, 11 April 2016

Languages Languages: 

En.png English


The GridUser table records information about an avatars friends and friendship requests       (back to Database Documentation)

Friends Table Structure

The structure of the Friends 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


HomePosition


HomeLookAt


LastRegionID


LastPosition


LastLookAt


Online


Login


Logout



      (back to Database Documentation)


Retrieved from "http://opensimulator.org/index.php?title=GridUser&oldid=42168"
Personal tools
General
About This Wiki