Friends - Revision history

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T01:40:30Z

Minor formatting changes to match other database documentation pages

Kcozens: Minor changes to match formatting of other database documentation pages

2016-04-12T01:37:39Z

Minor changes to match formatting of other database documentation pages

Kcozens: Changed colour of table headers and alternate lines in Table Structure table

2016-04-12T00:11:13Z

Changed colour of table headers and alternate lines in Table Structure table

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

2016-04-12T00:05:56Z

Added gray background to alternate lines of Table Structure table

Kcozens: Updated the table description

2016-04-11T23:24:46Z

Updated the table description

Kcozens: Adjusted spacing between sections of field details

2016-04-11T23:08:01Z

Adjusted spacing between sections of field details

Kcozens: Created

2016-04-11T21:56:18Z

Created

New page

__NOTOC__
{{Quicklinks}}
<br />

The '''Friends''' table records information about an avatars friends and friendship requests       (back to [[Database Documentation]])
<br />
<br />

== Friends Table Structure ==

The structure of the Friends table is as follows:
<br />
{| style="border:1px solid #ccc;"
|- style="background:#eef;"
! Field
! Type
! Collation
! Attributes
! Null
! Default
! Extra
|-
| '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci || || No || ''None'' ||
|-
| '''[[#friend|Friend]]''' || varchar(255) || utf8_general_ci || || No || ''None'' ||
|-
| '''[[#flags|Flags]]''' || varchar(16) || utf8_general_ci || || No || 0 ||
|-
| '''[[#offered|Offered]]''' || text || utf8_general_ci || || No || 0 ||
|}

<br />
<br />

== Friends Fields ==

;<div id="principalID">'''PrincipalID'''</div>
:The UUID of an avatar
<br />

;<div id="friend">'''Friend'''</div>
:The UUID of an avatars friend or requested friend
<br />

;<div id="flags">'''Flags'''</div>
:A bit field that states the rights a friend has to items owned by the avatar

:*When this field is 0, the friend has not been given any rights
:*If bit 0 is set the friend can see the online status of the avatar
:*If bit 1 is set the friend can see the location of the avatar on the map
:*If bit 2 is set the friend can modify the ojects of the avatar </summary>

<br />

;<div id="value">'''Offered'''</div>
:Indicates if a friendship offer is pending (?)
<br />

<br />

----

(back to [[Database Documentation]])

<br />

[[Category:Database]]

@@ Line 3: / Line 3: @@
 <br />
-The '''Friends''' table records information about an avatars friends and friendship requests&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+The '''Friends''' table records a list of an avatars friends, friendship requests, and permissions that they have granted to their friends&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 <br />
 <br />

← Older revision		Revision as of 01:37, 12 April 2016
Line 31:		Line 31:

	<br />		<br />
		+
		+	(back to [[Database Documentation]])
		+	<br />
		+
		+	----
	<br />		<br />

@@ Line 12: / Line 12: @@
 <br />
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type
@@ Line 22: / Line 22: @@
 |-
 | '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci ||  || No || ''None'' ||
-|- style="background:#eef;"
+|- style="background:#eee;"
 | '''[[#friend|Friend]]''' || varchar(255) || utf8_general_ci ||  || No || ''None'' ||
 |-
 | '''[[#flags|Flags]]''' || varchar(16) || utf8_general_ci ||  || No || 0 ||
-|- style="background:#eef;"
+|- style="background:#eee;"
 | '''[[#offered|Offered]]''' || text || utf8_general_ci ||  || No || 0 ||
 |}

@@ Line 37: / Line 37: @@
 ;<div id="principalID">'''PrincipalID'''</div>
 :The UUID of an avatar
 ;<div id="friend">'''Friend'''</div>
 :The UUID of an avatars friend or requested friend
 ;<div id="flags">'''Flags'''</div>
@@ Line 50: / Line 48: @@
 :*If bit 1 is set the friend can see the location of the avatar on the map
 :*If bit 2 is set the friend can modify the ojects of the avatar </summary>
 ;<div id="value">'''Offered'''</div>
-:Indicates if a friendship offer is pending (?)
+:Indicates if a friendship offer is pending
-<br />
-−
 <br />