Database:Assets

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(Filled in missing information on asset types)
m (→‎Asset Fields: Added hallucinated types)
 
(7 intermediate revisions by 5 users not shown)
Line 2: Line 2:
 
{{Quicklinks}}
 
{{Quicklinks}}
 
<br />
 
<br />
−
 
  
 
The '''assets''' table records all assets including textures, notecards, scripts, and avatar parts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
The '''assets''' table records all assets including textures, notecards, scripts, and avatar parts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
−
<br /><br />
+
<br />
 +
<br />
  
 
== Asset Table Structure ==
 
== Asset Table Structure ==
−
 
−
The current(?) structure of the assets table is as follows:
 
−
<br />
 
−
<table>
 
−
<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 
−
<tr><td>&nbsp;</td></tr>
 
−
<tr><td>Name</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td>&nbsp;</td></tr>
 
−
<tr><td>description</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>Type</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>local</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
 
−
<tr><td>temporary</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>data</td><td>longblob</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>id</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td><td></td></tr>
 
−
<tr><td>create_time</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
 
−
<tr><td>access_time</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
 
−
</table>
 
−
<br /><br />
 
  
 
The structure of the assets table as of v0.7.1.1 is as follows:
 
The structure of the assets table as of v0.7.1.1 is as follows:
 
<br />
 
<br />
 +
 
{| style="border:1px solid #ccc;"
 
{| style="border:1px solid #ccc;"
−
|- style="background:#eef;"
+
|- style="background:#cce;"
 
! Field
 
! Field
 
! Type
 
! Type
Line 39: Line 23:
 
|-
 
|-
 
| '''[[#name|name]]''' || varchar(64) || utf8_general_ci || || No || ''None'' ||  
 
| '''[[#name|name]]''' || varchar(64) || utf8_general_ci || || No || ''None'' ||  
−
|-
+
|- style="background:#eee;"
 
| '''[[#description|description]]''' || varchar(64) || utf8_general_ci ||  || No || ''None'' ||  
 
| '''[[#description|description]]''' || varchar(64) || utf8_general_ci ||  || No || ''None'' ||  
 
|-
 
|-
 
| '''[[#assetType|assetType]]''' || tinyint(4) ||  ||  || No || ''None'' ||  
 
| '''[[#assetType|assetType]]''' || tinyint(4) ||  ||  || No || ''None'' ||  
−
|-
+
|- style="background:#eee;"
 
| '''[[#local|local]]''' || tinyint(1) ||  ||  || No || ''None'' ||  
 
| '''[[#local|local]]''' || tinyint(1) ||  ||  || No || ''None'' ||  
 
|-
 
|-
 
| '''[[#temporary|temporary]]''' || tinyint(1) ||  ||  || No || ''None'' ||  
 
| '''[[#temporary|temporary]]''' || tinyint(1) ||  ||  || No || ''None'' ||  
−
|-
+
|- style="background:#eee;"
 
| '''[[#data|data]]''' || longblob ||  || <code>BINARY</code> || No || ''None'' ||  
 
| '''[[#data|data]]''' || longblob ||  || <code>BINARY</code> || No || ''None'' ||  
 
|-
 
|-
 
| '''[[#id|<u>id</u>]]''' || char(36) || utf8_general_ci ||  || No || 000000-0000-0000-0000-000000000000 ||  
 
| '''[[#id|<u>id</u>]]''' || char(36) || utf8_general_ci ||  || No || 000000-0000-0000-0000-000000000000 ||  
−
|-
+
|- style="background:#eee;"
 
| '''[[#create_time|create_time]]''' || int(11) ||  ||  || Yes || 0 ||  
 
| '''[[#create_time|create_time]]''' || int(11) ||  ||  || Yes || 0 ||  
 
|-
 
|-
 
| '''[[#access_time|access_time]]''' || int(11) ||  ||  || Yes || 0 ||  
 
| '''[[#access_time|access_time]]''' || int(11) ||  ||  || Yes || 0 ||  
−
|-
+
|- style="background:#eee"
 
| '''[[#asset_flags|asset_flags]]''' || int(11) ||  ||  || No || 0 ||  
 
| '''[[#asset_flags|asset_flags]]''' || int(11) ||  ||  || No || 0 ||  
 
|-
 
|-
Line 62: Line 46:
 
<br />
 
<br />
 
<br />
 
<br />
 +
 +
The structure of the assets table in some deprecated versions is as follows:
 +
<br />
 +
{| style="border:1px solid #ccc;"
 +
|- style="background:#cce;"
 +
! Field
 +
! Type
 +
! Collation
 +
! Attributes
 +
! Null
 +
! Default
 +
! Extra
 +
|-
 +
| '''[[#name|Name]]''' || varchar(64) || NO || || NULL || &nbsp; ||
 +
|- style="background:#eee;"
 +
| '''[[#description|description]]''' || varchar(64) || NO || || NULL || ||
 +
|-
 +
| '''[[#assetType|Type]]''' || tinyint(4) || NO || || NULL || ||
 +
|- style="background:#eee;"
 +
| '''[[#local|local]]''' || tinyint(1) || NO || || NULL || ||
 +
|-
 +
| '''[[#temporary|temporary]]''' || tinyint(1) || NO || || NULL || || ||
 +
|- style="background:#eee;"
 +
| '''[[#data|data]]''' || longblob || NO || || NULL || || ||
 +
|-
 +
| '''[[#create_time|create_time]]''' || int(11) || YES || || 0 || ||
 +
|- style="background:#eee;"
 +
| '''[[#access_time|access_time]]''' || int(11) || YES || || 0 || ||
 +
|}
 +
<br />
 +
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 +
<br />
 +
 +
----
 +
<br />
 +
 
== Asset Fields ==
 
== Asset Fields ==
  
 
;<div id="name">'''name'''</div>
 
;<div id="name">'''name'''</div>
 
:Name of the asset as it would appear in inventory
 
:Name of the asset as it would appear in inventory
−
<br />
 
  
 
;<div id="description">'''description'''</div>
 
;<div id="description">'''description'''</div>
 
: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 />
 
  
 
;<div id="assetType">'''assetType'''</div>
 
;<div id="assetType">'''assetType'''</div>
 
:Integer which designates the asset's type
 
:Integer which designates the asset's type
 
:* Valid values are (need help checking and filling these in):
 
:* Valid values are (need help checking and filling these in):
 +
:** -2 - Material (Legacy)
 
:** 0 - Texture in JPEG2000 J2C stream format
 
:** 0 - Texture in JPEG2000 J2C stream format
 
:** 1 - Sound
 
:** 1 - Sound
 
:** 2 - Calling Card
 
:** 2 - Calling Card
 
:** 3 - Landmark
 
:** 3 - Landmark
−
:** 4 - Script&nbsp;&nbsp;[Obsolete]
 
 
:** 5 - Clothing
 
:** 5 - Clothing
−
:** 6 - Primitive that can contain textures, sounds, and more
+
:** 6 - Object
 
:** 7 - Notecard
 
:** 7 - Notecard
−
:** 8 - Folder
 
−
:** 9 - Root Inventory Folder
 
 
:** 10 - LSLText (aka a script)
 
:** 10 - LSLText (aka a script)
−
:** 11 - LSL bytecode for a script
 
−
:** 12 - Texture in uncompressed TGA format
 
 
:** 13 - Body Part
 
:** 13 - Body Part
−
:** 14 - Trash Folder
 
−
:** 15 - Snapshot Folder
 
−
:** 16 - Lost and Found Folder
 
−
:** 17 - Sound file in uncompressed format
 
−
:** 18 - Uncompressed TGA non-square image (not to be used as a texture)
 
−
:** 19 - Compressed JPEG non-square image (not to be used as a texture)
 
 
:** 20 - Animation
 
:** 20 - Animation
 
:** 21 - Gesture
 
:** 21 - Gesture
−
:** 22 - Sim state file
+
:** 49 - Mesh
−
<br />
+
:** 56 - Setting
 +
:** 57 - Material (PBR)
 +
:* Declared in openmetaverse but never seen in database :
 +
:** 8 - Folder
 +
:** 11 - LSLBytecode
 +
:** 17 - SoundWAV
 +
:** 18 - ImageTGA
 +
:** 19 - ImageJPEG
 +
:** 22 - Simstate
 +
:** 24 - Link (to another inventory item)
 +
:** 25 - LinkFolder (to another inventory folder)
 +
:** 26 - Marketplace folder
  
 
;<div id="local">'''local'''</div>
 
;<div id="local">'''local'''</div>
 
:For Future Use
 
:For Future Use
−
<br />
 
  
 
;<div id="temporary">'''temporary'''</div>
 
;<div id="temporary">'''temporary'''</div>
 
:For Future Use
 
:For Future Use
−
<br />
 
  
 
;<div id="data">'''data'''</div>
 
;<div id="data">'''data'''</div>
 
:This is the blob which contains the actual script, notecard text, binary image (texture) or other data characterized by the "Type" column
 
:This is the blob which contains the actual script, notecard text, binary image (texture) or other data characterized by the "Type" column
−
<br />
 
  
 
;<div id="id">'''id'''</div>
 
;<div id="id">'''id'''</div>
 
:UUID which uniquely identifies the asset within the system
 
:UUID which uniquely identifies the asset within the system
−
<br />
 
  
 
;<div id="create_time">'''create_time'''</div>
 
;<div id="create_time">'''create_time'''</div>
 
:Date and time the asset was created in standard UNIX format
 
:Date and time the asset was created in standard UNIX format
−
<br />
 
  
 
;<div id="access_time">'''access_time'''</div>
 
;<div id="access_time">'''access_time'''</div>
 
:Date and time the asset was last used in standard UNIX format
 
:Date and time the asset was last used in standard UNIX format
−
<br />
 
  
 
;<div id="asset_flags">'''asset_flags'''</div>
 
;<div id="asset_flags">'''asset_flags'''</div>
 
:Asset flags.
 
:Asset flags.
−
<br />
 
  
 
;<div id="CreatorID">'''CreatorID'''</div>
 
;<div id="CreatorID">'''CreatorID'''</div>
 
:Creator avatar UUID
 
:Creator avatar UUID
 +
 
<br />
 
<br />
 +
 
----
 
----
−
      (back to [[Database Documentation]])
+
 
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
<br />
 
<br />
  
 
[[Category:Database]]
 
[[Category:Database]]

Latest revision as of 14:32, 1 June 2023

Languages Languages: 

En.png English   De.png Deutsch   Fr.png Français


The assets table records all assets including textures, notecards, scripts, and avatar parts       (back to Database Documentation)

[edit] Asset Table Structure

The structure of the assets table as of v0.7.1.1 is as follows:

Field Type Collation Attributes Null Default Extra
name varchar(64) utf8_general_ci No None
description varchar(64) utf8_general_ci No None
assetType tinyint(4) No None
local tinyint(1) No None
temporary tinyint(1) No None
data longblob BINARY No None
id char(36) utf8_general_ci No 000000-0000-0000-0000-000000000000
create_time int(11) Yes 0
access_time int(11) Yes 0
asset_flags int(11) No 0
CreatorID varchar(128) utf8_general_ci No



The structure of the assets table in some deprecated versions is as follows:

Field Type Collation Attributes Null 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
create_time int(11) YES 0
access_time int(11) YES 0


      (back to Database Documentation)


[edit] Asset Fields

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 type
  • Valid values are (need help checking and filling these in):
    • -2 - Material (Legacy)
    • 0 - Texture in JPEG2000 J2C stream format
    • 1 - Sound
    • 2 - Calling Card
    • 3 - Landmark
    • 5 - Clothing
    • 6 - Object
    • 7 - Notecard
    • 10 - LSLText (aka a script)
    • 13 - Body Part
    • 20 - Animation
    • 21 - Gesture
    • 49 - Mesh
    • 56 - Setting
    • 57 - Material (PBR)
  • Declared in openmetaverse but never seen in database :
    • 8 - Folder
    • 11 - LSLBytecode
    • 17 - SoundWAV
    • 18 - ImageTGA
    • 19 - ImageJPEG
    • 22 - Simstate
    • 24 - Link (to another inventory item)
    • 25 - LinkFolder (to another inventory folder)
    • 26 - Marketplace folder
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
asset_flags
Asset flags.
CreatorID
Creator avatar UUID


      (back to Database Documentation)

Retrieved from "http://opensimulator.org/index.php?title=Database:Assets&oldid=53534"
Personal tools
General
About This Wiki