Friends
From OpenSimulator
(Difference between revisions)
m (Changed colour of table headers and alternate lines in Table Structure table) |
m (Minor changes to match formatting of other database documentation pages) |
||
| Line 31: | Line 31: | ||
<br /> | <br /> | ||
| + | |||
| + | (back to [[Database Documentation]]) | ||
| + | <br /> | ||
| + | |||
| + | ---- | ||
<br /> | <br /> | ||
Revision as of 17:37, 11 April 2016
 |
Languages: |
|
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 |
(back to Database Documentation)
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)
