Database:Avatarappearance

Revision as of 15: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	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
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)

@@ 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>&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>
 <br>
@@ Line 22: / Line 41: @@
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 <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>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>

Views

Database:Avatarappearance

From OpenSimulator

Revision as of 15:12, 22 July 2008

Personal tools

General

For Administrators

For Developers

For Creators

For Grid Users

Related Links

About This Wiki

Search

Tools