Avatarattachments
From OpenSimulator
(Difference between revisions)
(New page: {{Template:Quicklinks}} Category:Database '''avatarattachments''' ''Records details of items attached to avatars'' (back to [[Database Documentatio...) |
|||
| Line 12: | Line 12: | ||
<tr><td>UUID</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td> </td></tr> | <tr><td>UUID</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td> </td></tr> | ||
<tr><td>attachpoint</td><td>integer</td><td></td><td></td><td>NULL</td><td></td></tr> | <tr><td>attachpoint</td><td>integer</td><td></td><td></td><td>NULL</td><td></td></tr> | ||
| − | <tr><td>item</td><td>char(36)</td><td>NO</td><td> | + | <tr><td>item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr> |
<tr><td>asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr> | <tr><td>asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr> | ||
</table> | </table> | ||
Revision as of 22:57, 17 July 2009
 |
Languages: |
|
avatarattachments Records details of items attached to avatars (back to Database Documentation)
The current structure of the avatarattachments table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| UUID | char(36) | NO | NULL | |||
| attachpoint | integer | NULL | ||||
| item | char(36) | NO | NULL | |||
| asset | char(36) | NO | NULL | |||
(back to Database Documentation)
UUID
The UUID of the user holding the attachment. As a user can attach several items to different points and each attached item creates a new row in the table this is not a unique key.
Attachpoint
The point of the avatar to which the item is attached.
Item
The UUID of the inventory item attached.
Asset
The UUID of the asset referenced by the "item".
(back to Database Documentation)
