Database:Assets
From OpenSimulator
| Line 24: | Line 24: | ||
<br> | <br> | ||
'''description''' | '''description''' | ||
| + | <br> | ||
Asset's description field, as it appears in various client-side editing widgets | Asset's description field, as it appears in various client-side editing widgets | ||
<br> | <br> | ||
| Line 43: | Line 44: | ||
<br> | <br> | ||
'''data''' | '''data''' | ||
| + | <br> | ||
This is the blob which contains the actual script, notecard text,<br> | This is the blob which contains the actual script, notecard text,<br> | ||
| − | or binary image (texture) or other data characterized by the invType column<br> | + | or binary image (texture) or other data characterized by the invType column |
| + | <br> | ||
<br> | <br> | ||
'''id''' | '''id''' | ||
<br> | <br> | ||
UUID which uniquely identifies the asset within the system | UUID which uniquely identifies the asset within the system | ||
| + | <br> | ||
| + | <br> | ||
| + | '''create_time''' | ||
| + | <br> | ||
| + | Date and time the asset was created in standard UNIX format | ||
| + | <br> | ||
| + | <br> | ||
| + | '''access_time''' | ||
| + | <br> | ||
| + | Date and time the asset was last used in standard UNIX format | ||
| + | <br> | ||
<br> | <br> | ||
<br> | <br> | ||
Revision as of 12:01, 22 February 2009
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 | |||
| Type | 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 | ||
| create_time | int(11) | YES | 0 | |||
| access_time | int(11) | YES | 0 |
(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
Type
Integer which designates the asset's inventory type
local
For Future Use
temporary
For Future Use
data
This is the blob which contains the actual script, notecard text,
or binary image (texture) or other data characterized by the invType column
id
UUID which uniquely identifies the asset within the system
create_time
Date and time the asset was created in standard UNIX format
access_time
Date and time the asset was last used in standard UNIX format
(back to Database Documentation)
