Friends
From OpenSimulator
(Difference between revisions)
m (Updated the table description) |
m (Added gray background to alternate lines of Table Structure table) |
||
| 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;" |
| '''[[#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;" |
| '''[[#offered|Offered]]''' || text || utf8_general_ci || || No || 0 || | | '''[[#offered|Offered]]''' || text || utf8_general_ci || || No || 0 || | ||
|} | |} | ||
Revision as of 16:05, 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 |
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)
