GridUser - Revision history

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T01:43:45Z

Minor formatting changes to match other database documentation pages

Kcozens: Added gray background to alternate lines of Table Structure table

2016-04-12T00:08:04Z

Added gray background to alternate lines of Table Structure table

Kcozens: Updated the table description

2016-04-11T23:20:20Z

Updated the table description

Kcozens: Corrected a typo

2016-04-11T23:08:53Z

Corrected a typo

Kcozens: Adjusted spacing between sections of field details

2016-04-11T23:01:49Z

Adjusted spacing between sections of field details

Kcozens: Filled in details about the table fields. Corrected some C&P errors.

2016-04-11T23:00:08Z

Filled in details about the table fields. Corrected some C&P errors.

Kcozens: Updated to use structure of other database documentation pages

2016-04-11T22:18:49Z

Updated to use structure of other database documentation pages

Justincc at 01:02, 10 October 2012

2012-10-10T01:02:20Z

Justincc: Created page with "+--------------+--------------+------+-----+--------------------------------------+-------+ | Field | Type | Null | Key | Default | Ex..."

2012-10-10T01:02:09Z

New page

+--------------+--------------+------+-----+--------------------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+--------------------------------------+-------+
| UserID | varchar(255) | NO | PRI | NULL | |
| HomeRegionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | |
| HomePosition | char(64) | NO | | <0,0,0> | |
| HomeLookAt | char(64) | NO | | <0,0,0> | |
| LastRegionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | |
| LastPosition | char(64) | NO | | <0,0,0> | |
| LastLookAt | char(64) | NO | | <0,0,0> | |
| Online | char(5) | NO | | false | |
| Login | char(16) | NO | | 0 | |
| Logout | char(16) | NO | | 0 | |
+--------------+--------------+------+-----+--------------------------------------+-------+

@@ Line 43: / Line 43: @@
 <br />
 <br />
@@ Line 81: / Line 86: @@
 ----
-       (back to [[Database Documentation]])
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-−
 <br />
 [[Category:Database]]

@@ Line 12: / Line 12: @@
 <br />
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type
@@ Line 22: / Line 22: @@
 |-
 | '''[[#userID|UserID]]''' || varchar(255) || utf8_general_ci || || No || NULL ||
-|-
+|- style="background:#eee;"
 | '''[[#homeRegion|HomeRegionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||
 |-
 | '''[[#homePos|HomePosition]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||
-|-
+|- style="background:#eee;"
 | '''[[#homeLookAt|HomeLookAt]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||
 |-
 | '''[[#lastRegion|LastRegionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||
-|-
+|- style="background:#eee;"
 | '''[[#astPos|LastPosition]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||
 |-
 | '''[[#lastLookAt|LastLookAt]]''' || char(64) || utf8_general_ci || || No || <0,0,0> ||
-|-
+|- style="background:#eee;"
 | '''[[#online|Online]]''' || char(5) || utf8_general_ci || || No || false ||
 |-
 | '''[[#login|Login]]''' || char(16) || utf8_general_ci || || No || 0 ||
-|-
+|- style="background:#eee;"
 | '''[[#logout|Logout]]''' || char(16) || utf8_general_ci || || No || 0 ||
 |}

@@ Line 3: / Line 3: @@
 <br />
-The '''GridUser''' table records information about avatars using the grid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 <br />
 <br />

@@ Line 45: / Line 45: @@
 <br />
-== GridUsers Fields ==
+== GridUser Fields ==
 ;<div id="userID">'''UserID'''</div>

@@ Line 49: / Line 49: @@
 ;<div id="userID">'''UserID'''</div>
 :The UUID of an avatar
 ;<div id="homeRegion">'''HomeRegionID'''</div>
 :The UUID of the avatars home region
 ;<div id="homePos">'''HomePosition'''</div>
 :The UUID of the
 ;<div id="homeLookAt">'''HomeLookAt'''</div>
 :The direction an avatar will be facing when they login to their home
 ;<div id="lastRegion">'''LastRegionID'''</div>
 :The UUID of the last region the avatar was in
 ;<div id="lastLookAt">'''LastPosition'''</div>
 :The coordinates of the last position the avatar was in their last region
 ;<div id="online">'''LastLookAt'''</div>
 :The direction an avatar was last facing
 ;<div id="login">'''Online'''</div>
 :A boolean value indicating whether the avatar is currently logged in
 ;<div id="login">'''Login'''</div>
 :A unix timestamp indicating the last time the avatar logged in
 ;<div id="logout">'''Logout'''</div>
 :A unix timestamp indicating the last time the avatar logged out
 <br />

@@ 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