Friends
From OpenSimulator
(Difference between revisions)
(Created) |
m (Minor formatting changes to match other database documentation pages) |
||
| (5 intermediate revisions by one user not shown) | |||
| Line 3: | Line 3: | ||
<br /> | <br /> | ||
| − | The '''Friends''' table records | + | 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]]) |
<br /> | <br /> | ||
<br /> | <br /> | ||
| Line 12: | Line 12: | ||
<br /> | <br /> | ||
{| style="border:1px solid #ccc;" | {| style="border:1px solid #ccc;" | ||
| − | |- style="background:# | + | |- 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:#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:#eee;" |
| '''[[#offered|Offered]]''' || text || utf8_general_ci || || No || 0 || | | '''[[#offered|Offered]]''' || text || utf8_general_ci || || No || 0 || | ||
|} | |} | ||
<br /> | <br /> | ||
| + | |||
| + | (back to [[Database Documentation]]) | ||
| + | <br /> | ||
| + | |||
| + | ---- | ||
<br /> | <br /> | ||
| Line 37: | Line 42: | ||
;<div id="principalID">'''PrincipalID'''</div> | ;<div id="principalID">'''PrincipalID'''</div> | ||
:The UUID of an avatar | :The UUID of an avatar | ||
| − | |||
;<div id="friend">'''Friend'''</div> | ;<div id="friend">'''Friend'''</div> | ||
:The UUID of an avatars friend or requested friend | :The UUID of an avatars friend or requested friend | ||
| − | |||
;<div id="flags">'''Flags'''</div> | ;<div id="flags">'''Flags'''</div> | ||
| Line 50: | Line 53: | ||
:*If bit 1 is set the friend can see the location of the avatar on the map | :*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> | :*If bit 2 is set the friend can modify the ojects of the avatar </summary> | ||
| − | |||
| − | |||
;<div id="value">'''Offered'''</div> | ;<div id="value">'''Offered'''</div> | ||
| − | :Indicates if a friendship offer is pending | + | :Indicates if a friendship offer is pending |
| − | + | ||
| − | + | ||
<br /> | <br /> | ||
---- | ---- | ||
| − | + | (back to [[Database Documentation]]) | |
| − | + | ||
<br /> | <br /> | ||
[[Category:Database]] | [[Category:Database]] | ||
Latest revision as of 17: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)
