Avatars - Revision history

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T01:41:25Z

Minor formatting changes to match other database documentation pages

Kcozens: Minor changes to match formatting of other database documentation pages

2016-04-12T01:36:22Z

Minor changes to match formatting of other database documentation pages

Kcozens: Changed colour of table headers in Table Structure table

2016-04-12T00:10:08Z

Changed colour of table headers in Table Structure table

Kcozens: Added gray background to alternate lines of Table Structure table

2016-04-12T00:05:13Z

Added gray background to alternate lines of Table Structure table

Kcozens: Adjusted spacing between sections of field details

2016-04-11T23:04:51Z

Adjusted spacing between sections of field details

Kcozens: Created

2013-05-29T22:10:31Z

Created

New page

__NOTOC__
{{Quicklinks}}
<br />

The '''Avatars''' table records information about an avatars appearance and wearables       (back to [[Database Documentation]])
<br />
<br />

== Avatars Table Structure ==

The structure of the Avatars table as of v0.7.5-post-fixes is as follows:
<br />
{| style="border:1px solid #ccc;"
|- style="background:#eef;"
! Field
! Type
! Collation
! Attributes
! Null
! Default
! Extra
|-
| '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci || || No || ''None'' ||
|-
| '''[[#name|Name]]''' || varchar(32) || utf8_general_ci || || No || ''None'' ||
|-
| '''[[#value|Value]]''' || text || utf8_general_ci || || Yes || ''Null'' ||
|}

<br />
<br />

== Avatars Fields ==

;<div id="principalID">'''PrincipalID'''</div>
:The UUID of an avatar
<br />

;<div id="name">'''Name'''</div>
: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
<br />

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.
<br />
<br />

The valid values of n 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
<br />

;<div id="value">'''Value'''</div>
:The data specific to the named avatar appearance property
<br />

<br />

----

(back to [[Database Documentation]])

<br />

[[Category:Database]]

@@ Line 94: / Line 94: @@
 ----
-       (back to [[Database Documentation]])
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-−
 <br />
 [[Category:Database]]

@@ Line 27: / Line 27: @@
 | '''[[#value|Value]]''' || text || utf8_general_ci ||  || Yes || ''Null'' ||
 |}
 <br />
 <br />

@@ Line 12: / Line 12: @@
 <br />
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type

@@ Line 22: / Line 22: @@
 |-
 | '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci ||  || No || ''None'' ||
-|-
+|- style="background:#eee;"
 | '''[[#name|Name]]''' || varchar(32) || utf8_general_ci ||  || No || ''None'' ||
 |-

@@ Line 35: / Line 35: @@
 ;<div id="principalID">'''PrincipalID'''</div>
 :The UUID of an avatar
 ;<div id="name">'''Name'''</div>
@@ Line 59: / Line 58: @@
 :** AvatarType
 :** Wearable n:m
 There can be multiple "Wearable n:m" lines in the table. The value of n
@@ Line 66: / Line 64: @@
 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.
 <br />
-The valid values of n are shown below:
+The valid values of n for new style wearables are shown below:
 :* 0 for BODY
 :* 1 for SKIN
@@ Line 85: / Line 82: @@
 :* 13 for ALPHA
 :* 14 for TATTOO
 ;<div id="value">'''Value'''</div>
 :The data specific to the named avatar appearance property
 <br />