Database:Avatarappearance

Latest revision as of 18:55, 3 March 2012

Home

Download

News

Support

Admin

Dev

Screen Shots

Grid List

Bugs

Languages:

English

avatarappearance Records avatar appearance details, i.e., worn wearables (back to Database Documentation)

The current structure of the avatar appearance table is as follows:

Field	Type	Null	Key	Default	Extra

Owner	char(36)	NO	PRI	NULL
Serial	int(10) unsigned	NO		NULL
Visual_Params	blob	NO		NULL
Texture	blob	NO		NULL
Avatar_Height	float	NO		NULL
Body_Item	char(36)	NO		NULL
Body_Asset	char(36)	NO		NULL
Skin_Item	char(36)	NO	PRI	NULL
Skin_Asset	char(36)	NO		NULL
Hair_Item	char(36)	NO		NULL
Hair_Asset	char(36)	NO		NULL
Eyes_Item	char(36)	NO	PRI	NULL
Eyes_Asset	char(36)	NO	UNI	NULL
Shirt_Item	char(36)	NO	UNI	NULL
Shirt_Asset	char(36)	NO		NULL
Pants_Item	char(36)	NO		NULL
Pants_Asset	char(36)	NO		NULL
Shoes_Item	char(36)	NO		NULL
Shoes_Asset	char(36)	NO		NULL
Socks_Item	char(36)	NO		NULL
Socks_Asset	char(36)	NO		NULL
Jacket_Item	char(36)	NO		NULL
Jacket_Asset	char(36)	NO		NULL
Gloves_Item	char(36)	NO		NULL
Gloves_Asset	char(36)	NO		NULL
Undershirt_Item	char(36)	NO		NULL
Undershirt_Asset	char(36)	NO		NULL
Underpants_Item	char(36)	NO		NULL
Underpants_Asset	char(36)	NO		NULL
Skirt_Asset	char(36)	NO		NULL
Skirt_Item	char(36)	NO		NULL

(back to Database Documentation)

Owner
UUID of avatar's owner.

Serial
Monotonic counter gets incremented by 1 each time the avatar is updated.

Visual_Params
Byte array of some 240 or so numerically descriptive shape parameters describing the look of the avatar.

Texture
The avatar's 'baked' texture.

Avatar_Height
Height of the avatar in meters.

Body_Item
Refers to inventory item for Body

Body_Asset
Refers to item in assets for Body

Skin_Item
Refers to inventory item for Skin

Skin_Asset
Refers to item in assets for Skin

Hair_Item
Refers to inventory item for Hair

Hair_Asset
Refers to item in assets for Hair

Eyes_Item
Refers to inventory item for Eyes

Eyes_Asset
Refers to item in assets for Eyes

Shirt_Item
Refers to inventory item for Shirt

Shirt_Asset
Refers to item in assets for Shirt

Pants_Item
Refers to inventory item for Pants

Pants_Asset
Refers to item in assets for Pants

Shoes_Item
Refers to inventory item for Shoes

Shoes_Asset
Refers to item in assets for Shoes

Socks_Item
Refers to inventory item for Socks

Socks_Asset
Refers to item in assets for Socks

Jacket_Item
Refers to inventory item for Jacket

Jacket_Asset
Refers to item in assets for Jacket

Gloves_Item
Refers to inventory item for Gloves

Gloves_Asset
Refers to item in assets for Gloves

Undershirt_Item
Refers to inventory item for Undershirt

Undershirt_Asset
Refers to item in assets for Undershirt

Underpants_Item
Refers to inventory item for Underpants

Underpants_Asset
Refers to item in assets for Underpants

Skirt_Asset
Refers to item in assets for Skirt

Skirt_Item
Refers to inventory item for Skirt

(back to Database Documentation)

Views

Database:Avatarappearance

From OpenSimulator

Latest revision as of 18:55, 3 March 2012

Personal tools

General

For Administrators

For Developers

For Creators

For Grid Users

Related Links

About This Wiki

Search

Tools

@@ Line 1: / Line 1: @@
-'''avatarappearance'''	''Records avatar appearance details, i.e., worn wearables''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+__NOTOC__
-<br><br>
+{{Quicklinks}}
-The current structure of the avatar appearance table is as follows:<br>
-<br>
+'''avatarappearance'''	''Records avatar appearance details, i.e., worn wearables''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
+<br /><br />
+The current structure of the avatar appearance table is as follows:<br />
+<br />
 <table>
-<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 <tr><td>&nbsp;</td></tr>
 <tr><td>Owner</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td>&nbsp;</td></tr>
@@ Line 16: / Line 19: @@
 <tr><td>Skin_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 <tr><td>Hair_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
-<tr><td>Hair_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><br>
+<tr><td>Hair_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><br />
 <tr><td>Eyes_Item</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td></td></tr>
 <tr><td>Eyes_Asset</td><td>char(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
@@ Line 34: / Line 37: @@
 <tr><td>Undershirt_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 <tr><td>Underpants_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
+<tr><td>Underpants_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 <tr><td>Skirt_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 <tr><td>Skirt_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
 </table>
-<br>
+<br />
-<br>
+<br />
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
-<hr>
+----
+'''Owner'''<br />
+UUID of avatar's owner.
+<br />
+<br />
+'''Serial'''<br />
+Monotonic counter gets incremented by 1 each time the avatar is updated.
+<br /><br />
+'''Visual_Params'''<br />
+Byte array of some 240 or so numerically descriptive shape parameters describing the look of the avatar.
+<br />
+<br />
+'''Texture'''<br />
+The avatar's 'baked' texture.
+<br />
+<br />
+'''Avatar_Height'''<br />
+Height of the avatar in meters.
+<br />
+<br />
+'''Body_Item'''<br />
+Refers to inventory item for Body
+<br />
+<br />
+'''Body_Asset'''<br />
+Refers to item in assets for Body
+<br />
+<br />
+'''Skin_Item'''<br />
+Refers to inventory item for Skin
+<br />
+<br />
+'''Skin_Asset'''<br />
+Refers to item in assets for Skin
+<br />
+<br />
+'''Hair_Item'''<br />
+Refers to inventory item for Hair
+<br />
+<br />
+'''Hair_Asset'''<br />
+Refers to item in assets for Hair
+<br />
+<br />
+'''Eyes_Item'''<br />
+Refers to inventory item for Eyes
+<br />
+<br />
+'''Eyes_Asset'''<br />
+Refers to item in assets for Eyes
+<br />
+<br />
+'''Shirt_Item'''<br />
+Refers to inventory item for Shirt
+<br />
+<br />
+'''Shirt_Asset'''<br />
+Refers to item in assets for Shirt
+<br />
+<br />
+'''Pants_Item'''<br />
+Refers to inventory item for Pants
+<br />
+<br />
+'''Pants_Asset'''<br />
+Refers to item in assets for Pants
+<br />
+<br />
+'''Shoes_Item'''<br />
+Refers to inventory item for Shoes
+<br />
+<br />
+'''Shoes_Asset'''<br />
+Refers to item in assets for Shoes
+<br />
+<br />
+'''Socks_Item'''<br />
+Refers to inventory item for Socks
+<br />
+<br />
+'''Socks_Asset'''<br />
+Refers to item in assets for Socks
+<br />
+<br />
+'''Jacket_Item'''<br />
+Refers to inventory item for Jacket
+<br />
+<br />
+'''Jacket_Asset'''<br />
+Refers to item in assets for Jacket
+<br />
+<br />
+'''Gloves_Item'''<br />
+Refers to inventory item for Gloves
+<br />
+<br />
+'''Gloves_Asset'''<br />
+Refers to item in assets for Gloves
+<br />
+<br />
+'''Undershirt_Item'''<br />
+Refers to inventory item for Undershirt
+<br />
+<br />
+'''Undershirt_Asset'''<br />
+Refers to item in assets for Undershirt
+<br />
+<br />
+'''Underpants_Item'''<br />
+Refers to inventory item for Underpants
+<br />
+<br />
+'''Underpants_Asset'''<br />
+Refers to item in assets for Underpants
+<br />
+<br />
+'''Skirt_Asset'''<br />
+Refers to item in assets for Skirt
+<br />
+<br />
+'''Skirt_Item'''<br />
+Refers to inventory item for Skirt
+----
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
-'''Owner'''<br>
+[[Category:Database]]
-'''Serial'''<br>
-'''Visual_Params'''<br>
-'''Texture'''<br>
-'''Avatar_Height'''<br>
-'''Body_Item'''<br>
-Refers to inventory item for Body<br>
-'''Body_Asset'''<br><br>
-Refers to item in assets for Body<br>
-'''Skin_Item'''<br><br>
-Refers to inventory item for Skin<br>
-'''Skin_Asset'''<br><br>
-Refers to item in assets for Skin<br>
-'''Hair_Item'''<br><br>
-Refers to inventory item for Hair<br>
-'''Hair_Asset'''<br><br>
-Refers to item in assets for Hair<br>
-'''Eyes_Item'''<br><br>
-Refers to inventory item for Eyes<br>
-'''Eyes_Asset'''<br><br>
-Refers to item in assets for Eyes<br>
-'''Shirt_Item'''<br><br>
-Refers to inventory item for Shirt<br>
-'''Shirt_Asset'''<br><br>
-Refers to item in assets for Shirt<br>
-'''Pants_Item'''<br><br>
-Refers to inventory item for Pants<br>
-'''Pants_Asset'''<br><br>
-Refers to item in assets for Pants<br>
-'''Shoes_Item'''<br><br>
-Refers to inventory item for Shoes<br>
-'''Shoes_Asset'''<br><br>
-Refers to item in assets for Shoes<br>
-'''Socks_Item'''<br><br>
-Refers to inventory item for Socks<br>
-'''Socks_Asset'''<br><br>
-Refers to item in assets for Socks<br>
-'''Jacket_Item'''<br><br>
-Refers to inventory item for Jacket<br>
-'''Jacket_Asset'''<br><br>
-Refers to item in assets for Jacket<br>
-'''Gloves_Item'''<br><br>
-Refers to inventory item for Gloves<br>
-'''Gloves_Asset'''<br><br>
-Refers to item in assets for Gloves<br>
-'''Undershirt_Item'''<br><br>
-Refers to inventory item for Undershirt<br>
-'''Undershirt_Asset'''<br><br>
-Refers to item in assets for Undershirt<br>
-'''Underpants_Item'''<br><br>
-Refers to inventory item for Underpants<br>
-'''Underpants_Asset'''<br><br>
-Refers to item in assets for Underpants<br>
-'''Skirt_Asset'''<br><br>
-Refers to item in assets for Skirt<br>
-'''Skirt_Item'''<br><br>
-Refers to inventory item for Skirt<br>
-<hr>
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>