Database:Assets

From OpenSimulator

Revision as of 02:24, 20 March 2009 by Peetr maynard (Talk | contribs)

Jump to: navigation, search

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
TypeNullKeyDefaultExtra
 
Namevarchar(64)NONULL 
descriptionvarchar(64)NONULL
Typetinyint(4)NONULL
localtinyint(1)NONULL
temporarytinyint(1)NONULL
datalongblobNONULL
idchar(36)NOPRI00000000-0000-0000-0000-000000000000
create_timeint(11)YES0
access_timeint(11)YES0



      (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,
binary image (texture) or other data characterized by the "Type" 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)

Personal tools
General
About This Wiki