Friends
From OpenSimulator
(Difference between revisions)
												
			m (Minor changes to match formatting of other database documentation pages)  | 
			m (Minor formatting changes to match other database documentation pages)  | 
			||
| Line 60: | Line 60: | ||
----  | ----  | ||
| − | + |       (back to [[Database Documentation]])  | |
| − | + | ||
<br />  | <br />  | ||
[[Category:Database]]  | [[Category:Database]]  | ||
Latest revision as of 17:40, 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)
[edit] 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 | 
      (back to Database Documentation)
[edit] 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)