Database:Assets

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
((including previous edits today) Added table for 0.7.1.1 and cleaned up page formatting)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 
{{Quicklinks}}
 
{{Quicklinks}}
 +
<br />
  
−
'''assets''' ''Records all assets''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
 
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;''including textures, notecards, scripts, and avatar parts''
+
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 />
−
The current(?) structure of the assets table is as follows:<br>
+
 
−
<br>
+
==Asset Table Structure==
 +
 
 +
The current(?) structure of the assets table is as follows:
 +
<br />
 
<table>
 
<table>
 
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
Line 21: Line 25:
 
</table>
 
</table>
 
<br /><br />
 
<br /><br />
−
The structure of the assets table as of v0.7.1.1 [[Diva Distribution]] 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;"
Line 33: Line 38:
 
! Extra
 
! Extra
 
|-
 
|-
−
| '''name''' || varchar(64) || utf8_general_ci || || No || ''None'' ||  
+
| '''[[#name|name]]''' || varchar(64) || utf8_general_ci || || No || ''None'' ||  
 
|-
 
|-
−
| '''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'' ||  
 
|-
 
|-
−
| '''local''' || tinyint(1) ||  ||  || No || ''None'' ||  
+
| '''[[#local|local]]''' || tinyint(1) ||  ||  || No || ''None'' ||  
 
|-
 
|-
−
| '''temporary''' || tinyint(1) ||  ||  || No || ''None'' ||  
+
| '''[[#temporary|temporary]]''' || tinyint(1) ||  ||  || No || ''None'' ||  
 
|-
 
|-
−
| '''data''' || longblob ||  || <code>BINARY</code> || No || ''None'' ||  
+
| '''[[#data|data]]''' || longblob ||  || <code>BINARY</code> || No || ''None'' ||  
 
|-
 
|-
−
| '''<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 ||  
 
|-
 
|-
−
| '''create_time''' || int(11) ||  ||  || Yes || 0 ||  
+
| '''[[#create_time|create_time]]''' || int(11) ||  ||  || Yes || 0 ||  
 
|-
 
|-
−
| '''access_time''' || int(11) ||  ||  || Yes || 0 ||  
+
| '''[[#access_time|access_time]]''' || int(11) ||  ||  || Yes || 0 ||  
 
|-
 
|-
−
| '''asset_flags''' || int(11) ||  ||  || No || 0 ||  
+
| '''[[#asset_flags|asset_flags]]''' || int(11) ||  ||  || No || 0 ||  
 
|-
 
|-
−
| '''[[CreatorID]]''' || varchar(128) || utf8_general_ci ||  || No ||  ||   
+
| '''[[#CreatorID|CreatorID]]''' || varchar(128) || utf8_general_ci ||  || No ||  ||   
 
|}
 
|}
−
<br>
+
<br />
−
<br>
+
<br />
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
==Asset Fields==
−
<hr>
+
 
−
'''name'''
+
;<div id="name">'''name'''</div>
−
<br>
+
:Name of the asset as it would appear in inventory
−
Name of the asset as it would appear in inventory<br>
+
<br />
−
<br>
+
 
−
'''description'''
+
;<div id="description">'''description'''</div>
−
<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>
+
 
−
<br>
+
;<div id="assetType">'''assetType'''</div>
−
<div id="assetType">'''Type'''</div>
+
:Integer which designates the asset's type
−
<br>
+
:* Valid values are (need help checking and filling these in):
−
Integer which designates the asset's type
+
:** 0 - Textures
−
* Valid values are (need help checking and filling these in):
+
:** 1 - Sound
−
** 0 - Textures
+
:** 2 - Calling Card
−
** 1 - Sound
+
:** 3 - Landmark
−
** 2 - Calling Card
+
:** 4 - ??
−
** 3 - Landmark
+
:** 5 - Clothing
−
** 4 - ??
+
:** 6 - Primitive
−
** 5 - Clothing
+
:** 7 - Note
−
** 6 - Primitive
+
:** 8 - ??
−
** 7 - Note
+
:** 9 - ??
−
** 8 - ??
+
:** 10 - Script
−
** 9 - ??
+
:** 11 - ??
−
** 10 - Script
+
:** 12 - ??
−
** 11 - ??
+
:** 13 - Body Part
−
** 12 - ??
+
:** 14 - ??
−
** 13 - Body Part
+
:** 15 - ??
−
** 14 - ??
+
:** 16 - ??
−
** 15 - ??
+
:** 17 - ??
−
** 16 - ??
+
:** 18 - ??
−
** 17 - ??
+
:** 19 - ??
−
** 18 - ??
+
:** 20 - Animation
−
** 19 - ??
+
:** 21 - Gesture
−
** 20 - Animation
+
<br />
−
** 21 - Gesture
+
 
−
<br>
+
;<div id="local">'''local'''</div>
−
'''local'''
+
:For Future Use
−
<br>
+
<br />
−
For Future Use
+
 
−
<br>
+
;<div id="temporary">'''temporary'''</div>
−
<br>
+
:For Future Use
−
'''temporary'''
+
<br />
−
<br>
+
 
−
For Future Use
+
;<div id="data">'''data'''</div>
−
<br>
+
:This is the blob which contains the actual script, notecard text, binary image (texture) or other data characterized by the "Type" column
−
<br>
+
<br />
−
'''data'''
+
 
−
<br>
+
;<div id="id">'''id'''</div>
−
This is the blob which contains the actual script, notecard text,<br>
+
:UUID which uniquely identifies the asset within the system
−
binary image (texture) or other data characterized by the "Type" column
+
<br />
−
<br>
+
 
−
<br>
+
;<div id="create_time">'''create_time'''</div>
−
'''id'''
+
:Date and time the asset was created in standard UNIX format
−
<br>
+
<br />
−
UUID which uniquely identifies the asset within the system
+
 
−
<br>
+
;<div id="access_time">'''access_time'''</div>
−
<br>
+
:Date and time the asset was last used in standard UNIX format
−
'''create_time'''
+
<br />
−
<br>
+
 
−
Date and time the asset was created in standard UNIX format
+
;<div id="asset_flags">'''asset_flags'''</div>
−
<br>
+
:Asset flags.
−
<br>
+
<br />
−
'''access_time'''
+
 
−
<br>
+
;<div id="CreatorID">'''CreatorID'''</div>
−
Date and time the asset was last used in standard UNIX format
+
:Creator avatar UUID
−
<br>
+
<br />
−
<br>
+
<hr />
−
<br>
+
      (back to [[Database Documentation]])
−
<hr>
+
<br />
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
 
[[Category:Database]]
 
[[Category:Database]]

Revision as of 22:23, 28 July 2011

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)

Asset Table Structure

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



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



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):
    • 0 - Textures
    • 1 - Sound
    • 2 - Calling Card
    • 3 - Landmark
    • 4 - ??
    • 5 - Clothing
    • 6 - Primitive
    • 7 - Note
    • 8 - ??
    • 9 - ??
    • 10 - Script
    • 11 - ??
    • 12 - ??
    • 13 - Body Part
    • 14 - ??
    • 15 - ??
    • 16 - ??
    • 17 - ??
    • 18 - ??
    • 19 - ??
    • 20 - Animation
    • 21 - Gesture


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=24996"
Personal tools
General
About This Wiki