Database:Avatarappearance
From OpenSimulator
| Line 1: | Line 1: | ||
| − | '''avatarappearance''' ''Records avatar appearance details'' (back to [[Database Documentation]])<br> | + | '''avatarappearance''' ''Records avatar appearance details, i.e., worn wearables'' (back to [[Database Documentation]])<br> |
<br><br> | <br><br> | ||
The current structure of the avatar appearance table is as follows:<br> | The current structure of the avatar appearance table is as follows:<br> | ||
| Line 48: | Line 48: | ||
'''Avatar_Height'''<br> | '''Avatar_Height'''<br> | ||
'''Body_Item'''<br> | '''Body_Item'''<br> | ||
| − | '''Body_Asset'''<br> | + | Refers to inventory item for Body<br> |
| − | '''Skin_Item'''<br> | + | '''Body_Asset'''<br><br> |
| − | '''Skin_Asset'''<br> | + | Refers to item in assets for Body<br> |
| − | '''Hair_Item'''<br> | + | '''Skin_Item'''<br><br> |
| − | '''Hair_Asset'''<br> | + | Refers to inventory item for Skin<br> |
| − | '''Eyes_Item'''<br> | + | '''Skin_Asset'''<br><br> |
| − | '''Eyes_Asset'''<br> | + | Refers to item in assets for Skin<br> |
| − | '''Shirt_Item'''<br> | + | '''Hair_Item'''<br><br> |
| − | '''Shirt_Asset'''<br> | + | Refers to inventory item for Hair<br> |
| − | '''Pants_Item'''<br> | + | '''Hair_Asset'''<br><br> |
| − | '''Pants_Asset'''<br> | + | Refers to item in assets for Hair<br> |
| − | '''Shoes_Item'''<br> | + | '''Eyes_Item'''<br><br> |
| − | '''Shoes_Asset'''<br> | + | Refers to inventory item for Eyes<br> |
| − | '''Socks_Item'''<br> | + | '''Eyes_Asset'''<br><br> |
| − | '''Socks_Asset'''<br> | + | Refers to item in assets for Eyes<br> |
| − | '''Jacket_Item'''<br> | + | '''Shirt_Item'''<br><br> |
| − | '''Jacket_Asset'''<br> | + | Refers to inventory item for Shirt<br> |
| − | '''Gloves_Item'''<br> | + | '''Shirt_Asset'''<br><br> |
| − | '''Gloves_Asset'''<br> | + | Refers to item in assets for Shirt<br> |
| − | '''Undershirt_Item'''<br> | + | '''Pants_Item'''<br><br> |
| − | '''Undershirt_Asset'''<br> | + | Refers to inventory item for Pants<br> |
| − | '''Underpants_Item'''<br> | + | '''Pants_Asset'''<br><br> |
| − | '''Skirt_Asset'''<br> | + | Refers to item in assets for Pants<br> |
| − | '''Skirt_Item'''<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> | <hr> | ||
(back to [[Database Documentation]])<br> | (back to [[Database Documentation]])<br> | ||
Revision as of 18:55, 25 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
Serial
Visual_Params
Texture
Avatar_Height
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)
