Database:Assets
From OpenSimulator
assets Records all assets (back to Database Documentation)
including textures, notecards, scripts, and avatar parts
The current structure of the assets table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| Name | varchar(64) | NO | NULL | |||
| description | varchar(64) | NO | NULL | |||
| assetType | tinyint(4) | NO | NULL | |||
| local | tinyint(1) | NO | NULL | |||
| temporary | tinyint(1) | NO | NULL | |||
| data | longblob | NO | NULL | |||
| id | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 |
(back to Database Documentation)
name
Name of the asset as it would appear in inventory
description
Asset's description field, as it appears in various client-side editing widgets
assetType
Integer which designates the asset's inventory type
SecureSessionID
For Future Use
agentIP
IP address of logged-in agent?
Does not appear to be updated at this time
agentPort
Port the agent is connected on
Does not appear to be updated at this time
agentOnLine
Status of agent (Online/Offline)
loginTime
Time the agent logged in at
logoutTime
Time the agent logged out at
currentRegion
Region UUID for the region the av is presently resident within
currentHandle
Records the grid position of the region the av is presently resident within
currentPos
Records the av's current position with the region in which it is currently resident
(back to Database Documentation)
