Avatars
From OpenSimulator
(Difference between revisions)
(Created) |
m (Minor formatting changes to match other database documentation pages) |
||
(4 intermediate revisions by one user not shown) | |||
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;" |
| '''[[#name|Name]]''' || varchar(32) || utf8_general_ci || || No || ''None'' || | | '''[[#name|Name]]''' || varchar(32) || utf8_general_ci || || No || ''None'' || | ||
|- | |- | ||
| '''[[#value|Value]]''' || text || utf8_general_ci || || Yes || ''Null'' || | | '''[[#value|Value]]''' || text || utf8_general_ci || || Yes || ''Null'' || | ||
|} | |} | ||
+ | <br /> | ||
+ | (back to [[Database Documentation]]) | ||
<br /> | <br /> | ||
+ | |||
+ | ---- | ||
<br /> | <br /> | ||
Line 35: | Line 39: | ||
;<div id="principalID">'''PrincipalID'''</div> | ;<div id="principalID">'''PrincipalID'''</div> | ||
:The UUID of an avatar | :The UUID of an avatar | ||
− | |||
;<div id="name">'''Name'''</div> | ;<div id="name">'''Name'''</div> | ||
Line 59: | Line 62: | ||
:** AvatarType | :** AvatarType | ||
:** Wearable n:m | :** Wearable n:m | ||
− | |||
There can be multiple "Wearable n:m" lines in the table. The value of n | There can be multiple "Wearable n:m" lines in the table. The value of n | ||
Line 66: | Line 68: | ||
of m, if there are multiple attachments to the same body part. Higher values | of m, if there are multiple attachments to the same body part. Higher values | ||
of m represent wearables that are on top of wearables with lower values of m. | of m represent wearables that are on top of wearables with lower values of m. | ||
− | |||
<br /> | <br /> | ||
− | The valid values of n are shown below: | + | The valid values of n for new style wearables are shown below: |
:* 0 for BODY | :* 0 for BODY | ||
:* 1 for SKIN | :* 1 for SKIN | ||
Line 85: | Line 86: | ||
:* 13 for ALPHA | :* 13 for ALPHA | ||
:* 14 for TATTOO | :* 14 for TATTOO | ||
− | |||
;<div id="value">'''Value'''</div> | ;<div id="value">'''Value'''</div> | ||
:The data specific to the named avatar appearance property | :The data specific to the named avatar appearance property | ||
− | |||
− | |||
<br /> | <br /> | ||
Line 96: | Line 94: | ||
---- | ---- | ||
− | + | (back to [[Database Documentation]]) | |
− | + | ||
<br /> | <br /> | ||
[[Category:Database]] | [[Category:Database]] |
Latest revision as of 17:41, 11 April 2016
The Avatars table records information about an avatars appearance and wearables (back to Database Documentation)
[edit] Avatars Table Structure
The structure of the Avatars table as of v0.7.5-post-fixes is as follows:
Field | Type | Collation | Attributes | Null | Default | Extra |
---|---|---|---|---|---|---|
PrincipalID | char(36) | utf8_general_ci | No | None | ||
Name | varchar(32) | utf8_general_ci | No | None | ||
Value | text | utf8_general_ci | Yes | Null |
(back to Database Documentation)
[edit] Avatars Fields
- PrincipalID
- The UUID of an avatar
- Name
- The name of a wearable, or attachment, property
- Serial
- AvatarHeight - The height of the avatar (in meters)
- Legacy Wearables
- BodyItem
- SkinItem
- HairItem
- EyesItem
- ShirtItem
- PantsItem
- ShoesItem
- SocksItem
- JacketItem
- GlovesItem
- UnderShirtItem
- UnderPantsItem
- SkirtItem
- VisualParams
- New Style Wearables
- AvatarType
- Wearable n:m
There can be multiple "Wearable n:m" lines in the table. The value of n
indicates which body part the wearable is for. The value of m is normally 0.
There will be multiple records with the same value of n, but different values
of m, if there are multiple attachments to the same body part. Higher values
of m represent wearables that are on top of wearables with lower values of m.
The valid values of n for new style wearables are shown below:
- 0 for BODY
- 1 for SKIN
- 2 for HAIR
- 3 for EYES
- 4 for SHIRT
- 5 for PANTS
- 6 for SHOES
- 7 for SOCKS
- 8 for JACKET
- 9 for GLOVES
- 10 for UNDERSHIRT
- 11 for UNDERPANTS
- 12 for SKIRT
- 13 for ALPHA
- 14 for TATTOO
- Value
- The data specific to the named avatar appearance property
(back to Database Documentation)