Database:Assets
From OpenSimulator
(New page: '''assets''' ''Records all assets'' (back to Database Documentation)<br> ''including text...) |
|||
| Line 32: | Line 32: | ||
<br> | <br> | ||
<br> | <br> | ||
| − | ''' | + | '''local''' |
<br> | <br> | ||
For Future Use | For Future Use | ||
<br> | <br> | ||
<br> | <br> | ||
| − | ''' | + | '''temporary''' |
<br> | <br> | ||
| − | + | For Future Use | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
<br> | <br> | ||
| − | |||
<br> | <br> | ||
| + | '''data''' | ||
| + | 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> | ||
<br> | <br> | ||
| − | ''' | + | '''id''' |
<br> | <br> | ||
| − | + | UUID which uniquely identifies the asset with in the system | |
<br> | <br> | ||
<br> | <br> | ||
<hr> | <hr> | ||
(back to [[Database Documentation]])<br> | (back to [[Database Documentation]])<br> | ||
Revision as of 15:50, 22 July 2008
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
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 with in the system
(back to Database Documentation)
