Database:Avatarappearance
From OpenSimulator
| Line 43: | Line 43: | ||
'''Owner'''<br> | '''Owner'''<br> | ||
| + | UUID of avatar's owner. | ||
| + | <br> | ||
| + | <br> | ||
'''Serial'''<br> | '''Serial'''<br> | ||
| + | Monotonic counter gets incremented by 1 each time the avatar is updated. | ||
| + | <br><br> | ||
'''Visual_Params'''<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> | '''Texture'''<br> | ||
| − | '''Avatar_Height'''<br> | + | The avatar's 'baked' texture. |
| + | <br> | ||
| + | <br> | ||
| + | '''Avatar_Height''' | ||
| + | Height of the avatar in meters.<br> | ||
| + | <br> | ||
| + | <br> | ||
'''Body_Item'''<br> | '''Body_Item'''<br> | ||
| − | Refers to inventory item for Body<br> | + | Refers to inventory item for Body |
| − | '''Body_Asset''' | + | <br> |
| − | Refers to item in assets for Body<br> | + | <br> |
| − | '''Skin_Item''' | + | '''Body_Asset'''<br> |
| − | Refers to inventory item for Skin<br> | + | Refers to item in assets for Body |
| − | '''Skin_Asset''' | + | <br> |
| − | Refers to item in assets for Skin<br> | + | <br> |
| − | '''Hair_Item''' | + | '''Skin_Item'''<br> |
| − | Refers to inventory item for Hair<br> | + | Refers to inventory item for Skin |
| − | '''Hair_Asset''' | + | <br> |
| − | Refers to item in assets for Hair<br> | + | <br> |
| − | '''Eyes_Item''' | + | '''Skin_Asset'''<br> |
| − | Refers to inventory item for Eyes<br> | + | Refers to item in assets for Skin |
| − | '''Eyes_Asset''' | + | <br> |
| − | Refers to item in assets for Eyes<br> | + | <br> |
| − | '''Shirt_Item''' | + | '''Hair_Item'''<br> |
| − | Refers to inventory item for Shirt<br> | + | Refers to inventory item for Hair |
| − | '''Shirt_Asset''' | + | <br> |
| − | Refers to item in assets for Shirt<br> | + | <br> |
| − | '''Pants_Item''' | + | '''Hair_Asset'''<br> |
| − | Refers to inventory item for Pants<br> | + | Refers to item in assets for Hair |
| − | '''Pants_Asset''' | + | <br> |
| − | Refers to item in assets for Pants<br> | + | <br> |
| − | '''Shoes_Item''' | + | '''Eyes_Item'''<br> |
| − | Refers to inventory item for Shoes<br> | + | Refers to inventory item for Eyes |
| − | '''Shoes_Asset''' | + | <br> |
| − | Refers to item in assets for Shoes<br> | + | <br> |
| − | '''Socks_Item''' | + | '''Eyes_Asset'''<br> |
| − | Refers to inventory item for Socks<br> | + | Refers to item in assets for Eyes |
| − | '''Socks_Asset''' | + | <br> |
| − | Refers to item in assets for Socks<br> | + | <br> |
| − | '''Jacket_Item''' | + | '''Shirt_Item'''<br> |
| − | Refers to inventory item for Jacket<br> | + | Refers to inventory item for Shirt |
| − | '''Jacket_Asset''' | + | <br> |
| − | Refers to item in assets for Jacket<br> | + | <br> |
| − | '''Gloves_Item''' | + | '''Shirt_Asset'''<br> |
| − | Refers to inventory item for Gloves<br> | + | Refers to item in assets for Shirt |
| − | '''Gloves_Asset''' | + | <br> |
| − | Refers to item in assets for Gloves<br> | + | <br> |
| − | '''Undershirt_Item''' | + | '''Pants_Item'''<br> |
| − | Refers to inventory item for Undershirt<br> | + | Refers to inventory item for Pants |
| − | '''Undershirt_Asset''' | + | <br> |
| − | Refers to item in assets for Undershirt<br> | + | <br> |
| − | '''Underpants_Item''' | + | '''Pants_Asset'''<br> |
| − | Refers to inventory item for Underpants<br> | + | Refers to item in assets for Pants |
| − | '''Underpants_Asset''' | + | <br> |
| − | Refers to item in assets for Underpants<br> | + | <br> |
| − | '''Skirt_Asset''' | + | '''Shoes_Item'''<br> |
| − | Refers to item in assets for Skirt<br> | + | Refers to inventory item for Shoes |
| − | '''Skirt_Item''' | + | <br> |
| − | Refers to inventory item for Skirt | + | <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 | ||
<hr> | <hr> | ||
(back to [[Database Documentation]])<br> | (back to [[Database Documentation]])<br> | ||
Revision as of 11:17, 30 July 2008
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 | |||
| 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)