Database:Avatarappearance

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(New page: '''avatarappearance''' ''Records avatar appearance details''      (back to Database Documentation)<br> <br><br> The current structure of the avatar appear...)
 
Line 6: Line 6:
 
<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>&nbsp;</td></tr>
<tr><td>UUID</td><td>varchar(36)</td><td>NO</td><td>PRI</td><td>NULL</td><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>
<tr><td>sessionID</td><td>varchar(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
+
<tr><td>Serial</td><td>int(10) unsigned</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>secureSessionID</td><td>varchar(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
+
<tr><td>Visual_Params</td><td>blob</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>agentIP</td><td>varchar(16)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
+
<tr><td>Texture</td><td>blob</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
<tr><td>agentPort</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Avatar_Height</td><td>float</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>agentOnline</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Body_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>loginTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Body_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>logoutTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Skin_Item</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td></td></tr>
<tr><td>currentRegion</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
+
<tr><td>Skin_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
<tr><td>currentHandle</td><td>bigint(20) unsigned</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>currentPos</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></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>
 +
<tr><td>Shirt_Item</td><td>char(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
 +
<tr><td>Shirt_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Pants_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Pants_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Shoes_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Shoes_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Socks_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Socks_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Jacket_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Jacket_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Gloves_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Gloves_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Undershirt_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<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>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>
 
</table>
 
<br>
 
<br>
Line 22: Line 41:
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 
<hr>
 
<hr>
'''UUID'''
+
 
<br>
+
'''Owner'''<br>
The UUID uniquely identifies the avatar associated with the user's account. This master ID 'number' is used for everything the avatar interacts with - it is used to determine permissions, identify belongings, and route messages to and from system and other avatars.
+
'''Serial'''<br>
<br>
+
'''Visual_Params'''<br>
<br>
+
'''Texture'''<br>
'''sessionID'''
+
'''Avatar_Height'''<br>
<br>
+
'''Body_Item'''<br>
For Future Use
+
'''Body_Asset'''<br>
<br>
+
'''Skin_Item'''<br>
<br>
+
'''Skin_Asset'''<br>
'''SecureSessionID'''
+
'''Hair_Item'''<br>
<br>
+
'''Hair_Asset'''<br>
For Future Use
+
'''Eyes_Item'''<br>
<br>
+
'''Eyes_Asset'''<br>
<br>
+
'''Shirt_Item'''<br>
'''agentIP'''
+
'''Shirt_Asset'''<br>
<br>
+
'''Pants_Item'''<br>
IP address of logged-in agent?<br>
+
'''Pants_Asset'''<br>
Does not appear to be updated at this time
+
'''Shoes_Item'''<br>
<br>
+
'''Shoes_Asset'''<br>
<br>
+
'''Socks_Item'''<br>
'''agentPort'''
+
'''Socks_Asset'''<br>
Port the agent is connected on<br>
+
'''Jacket_Item'''<br>
Does not appear to be updated at this time
+
'''Jacket_Asset'''<br>
<br>
+
'''Gloves_Item'''<br>
<br>
+
'''Gloves_Asset'''<br>
'''agentOnLine'''
+
'''Undershirt_Item'''<br>
<br>
+
'''Undershirt_Asset'''<br>
Status of agent (Online/Offline)
+
'''Underpants_Item'''<br>
<br>
+
'''Skirt_Asset'''<br>
<br>
+
'''Skirt_Item'''<br>
'''loginTime'''
+
<br>
+
Time the agent logged in at
+
<br>
+
<br>
+
'''logoutTime'''
+
<br>
+
Time the agent logged out at
+
<br>
+
<br>
+
'''currentRegion'''
+
<br>
+
Region UUID for the region the av is presently resident within
+
<br>
+
<br>
+
'''currentHandle'''
+
<br>
+
Records the grid position of the region the av is presently resident within
+
<br>
+
<br>
+
'''currentPos'''
+
<br>
+
Records the av's current position with the region in which it is currently resident
+
<br>
+
<br>
+
 
<hr>
 
<hr>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>

Revision as of 16:12, 22 July 2008

avatarappearance Records avatar appearance details      (back to Database Documentation)


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


Field
TypeNullKeyDefaultExtra
 
Ownerchar(36)NOPRINULL 
Serialint(10) unsignedNONULL
Visual_ParamsblobNONULL
TextureblobNONULL
Avatar_HeightfloatNONULL
Body_Itemchar(36)NONULL
Body_Assetchar(36)NONULL
Skin_Itemchar(36)NOPRINULL
Skin_Assetchar(36)NONULL
Hair_Itemchar(36)NONULL
Hair_Assetchar(36)NONULL
Eyes_Itemchar(36)NOPRINULL
Eyes_Assetchar(36)NOUNINULL
Shirt_Itemchar(36)NOUNINULL
Shirt_Assetchar(36)NONULL
Pants_Itemchar(36)NONULL
Pants_Assetchar(36)NONULL
Shoes_Itemchar(36)NONULL
Shoes_Assetchar(36)NONULL
Socks_Itemchar(36)NONULL
Socks_Assetchar(36)NONULL
Jacket_Itemchar(36)NONULL
Jacket_Assetchar(36)NONULL
Gloves_Itemchar(36)NONULL
Gloves_Assetchar(36)NONULL
Undershirt_Itemchar(36)NONULL
Undershirt_Assetchar(36)NONULL
Underpants_Itemchar(36)NONULL
Skirt_Assetchar(36)NONULL
Skirt_Itemchar(36)NONULL



      (back to Database Documentation)


Owner
Serial
Visual_Params
Texture
Avatar_Height
Body_Item
Body_Asset
Skin_Item
Skin_Asset
Hair_Item
Hair_Asset
Eyes_Item
Eyes_Asset
Shirt_Item
Shirt_Asset
Pants_Item
Pants_Asset
Shoes_Item
Shoes_Asset
Socks_Item
Socks_Asset
Jacket_Item
Jacket_Asset
Gloves_Item
Gloves_Asset
Undershirt_Item
Undershirt_Asset
Underpants_Item
Skirt_Asset
Skirt_Item


      (back to Database Documentation)

Personal tools
General
About This Wiki