Friends
From OpenSimulator
(Difference between revisions)
m (Changed colour of table headers and alternate lines in Table Structure table) |
m (Minor formatting changes to match other database documentation pages) |
||
| (One intermediate revision by one user not shown) | |||
| Line 31: | Line 31: | ||
<br /> | <br /> | ||
| + | |||
| + | (back to [[Database Documentation]]) | ||
| + | <br /> | ||
| + | |||
| + | ---- | ||
<br /> | <br /> | ||
| Line 55: | Line 60: | ||
---- | ---- | ||
| − | + | (back to [[Database Documentation]]) | |
| − | + | ||
<br /> | <br /> | ||
[[Category:Database]] | [[Category:Database]] | ||
Latest revision as of 18:40, 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)
[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)
