Friends

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Added gray background to alternate lines of Table Structure table)
m (Changed colour of table headers and alternate lines in Table Structure table)
Line 12: Line 12:
 
<br />
 
<br />
 
{| style="border:1px solid #ccc;"
 
{| style="border:1px solid #ccc;"
|- style="background:#eef;"
+
|- style="background:#cce;"
 
! Field
 
! Field
 
! Type
 
! Type
Line 22: Line 22:
 
|-
 
|-
 
| '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci ||  || No || ''None'' ||  
 
| '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci ||  || No || ''None'' ||  
|- style="background:#eef;"
+
|- style="background:#eee;"
 
| '''[[#friend|Friend]]''' || varchar(255) || utf8_general_ci ||  || No || ''None'' ||  
 
| '''[[#friend|Friend]]''' || varchar(255) || utf8_general_ci ||  || No || ''None'' ||  
 
|-
 
|-
 
| '''[[#flags|Flags]]''' || varchar(16) || utf8_general_ci ||  || No || 0 ||  
 
| '''[[#flags|Flags]]''' || varchar(16) || utf8_general_ci ||  || No || 0 ||  
|- style="background:#eef;"
+
|- style="background:#eee;"
 
| '''[[#offered|Offered]]''' || text || utf8_general_ci ||  || No || 0 ||  
 
| '''[[#offered|Offered]]''' || text || utf8_general_ci ||  || No || 0 ||  
 
|}
 
|}

Revision as of 17:11, 11 April 2016


The Friends table records a list of an avatars friends, friendship requests, and permissions that they have granted to their friends       (back to Database Documentation)

Friends Table Structure

The structure of the Friends table is as follows:

Field Type Collation Attributes Null Default Extra
PrincipalID char(36) utf8_general_ci No None
Friend varchar(255) utf8_general_ci No None
Flags varchar(16) utf8_general_ci No 0
Offered text utf8_general_ci No 0



Friends Fields

PrincipalID
The UUID of an avatar
Friend
The UUID of an avatars friend or requested friend
Flags
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>
Offered
Indicates if a friendship offer is pending



      (back to Database Documentation)


Personal tools
General
About This Wiki