Database:Assets - Revision history

JeffKelley: /* Asset Fields */ Added hallucinated types

2023-06-01T21:32:42Z

‎Asset Fields: Added hallucinated types

Kcozens: Added some additional entries to the assetType list

2020-12-29T19:44:04Z

Added some additional entries to the assetType list

Ubit: /* Asset Fields */

2020-12-29T19:35:03Z

‎Asset Fields

Djphil: /* Asset Fields */

2016-12-30T11:06:45Z

‎Asset Fields

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T02:04:27Z

Minor formatting changes to match other database documentation pages

Kcozens: Removed unneeded
markups

2016-04-12T00:21:07Z

Removed unneeded <br/> markups

JeffKelley: fixed asset types, removed folder types and never seen assets like SoundWAV, ImageTGA, ImageJPEG

2014-01-18T17:59:14Z

fixed asset types, removed folder types and never seen assets like SoundWAV, ImageTGA, ImageJPEG

CiderJack: /* Asset Table Structure */ highlighted alternate lines in the table & moved the 'deprecated' table underneath

2014-01-02T22:44:31Z

‎Asset Table Structure: highlighted alternate lines in the table & moved the 'deprecated' table underneath

Kcozens: Filled in missing information on asset types

2013-08-08T21:21:37Z

Filled in missing information on asset types

MakoBot: Robot: Cosmetic changes

2012-03-04T02:55:10Z

Robot: Cosmetic changes

@@ Line 94: / Line 94: @@
 :Integer which designates the asset's type
 :* Valid values are (need help checking and filling these in):
-:** -2 - Material
+:** -2 - Material (Legacy)
 :** 0 - Texture in JPEG2000 J2C stream format
 :** 1 - Sound
@@ Line 102: / Line 102: @@
 :** 6 - Object
 :** 7 - Notecard
 :** 10 - LSLText (aka a script)
 :** 13 - Body Part
 :** 20 - Animation
 :** 21 - Gesture
 :** 24 - Link (to another inventory item)
 :** 25 - LinkFolder (to another inventory folder)
 :** 26 - Marketplace folder
 ;<div id="local">'''local'''</div>

@@ Line 102: / Line 102: @@
 :** 6 - Object
 :** 7 - Notecard
 :** 10 - LSLText (aka a script)
 :** 13 - Body Part
 :** 20 - Animation
 :** 21 - Gesture
 :** 49 - Mesh
 :** 56 - Setting

@@ Line 107: / Line 107: @@
 :** 21 - Gesture
 :** 49 - Mesh
 ;<div id="local">'''local'''</div>

@@ Line 94: / Line 94: @@
 :Integer which designates the asset's type
 :* Valid values are (need help checking and filling these in):
 :** 0 - Texture in JPEG2000 J2C stream format
 :** 1 - Sound

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
 <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]])
-<br /><br />
+<br />
 == Asset Table Structure ==
@@ Line 11: / Line 11: @@
 The structure of the assets table as of v0.7.1.1 is as follows:
 <br />
 {| style="border:1px solid #ccc;"
 |- style="background:#cce;"
@@ Line 43: / Line 44: @@
 | '''[[#CreatorID|CreatorID]]''' || varchar(128) || utf8_general_ci ||  || No ||  ||
 |}
 <br />
 <br />
@@ Line 49: / Line 49: @@
 The structure of the assets table in some deprecated versions is as follows:
 <br />
-<table>
+{| style="border:1px solid #ccc;"
-<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+|- style="background:#cce;"
-<tr><td>&nbsp;</td></tr>
+! Field
-<tr><td>Name</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td>&nbsp;</td></tr>
+! Type
-<tr><td>description</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
+! Collation
-<tr><td>Type</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
+! Attributes
-<tr><td>local</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
+! Null
-<tr><td>temporary</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+! Default
-<tr><td>data</td><td>longblob</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+! Extra
-<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>
+| '''[[#name|Name]]''' || varchar(64) || NO || || NULL || &nbsp; ||
-<tr><td>access_time</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
+|- style="background:#eee;"
-</table>
+| '''[[#description|description]]''' || varchar(64) || NO || || NULL || ||
-<br /><br />
+|-
 == Asset Fields ==
@@ Line 116: / Line 135: @@
 ----
-       (back to [[Database Documentation]])
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-−
 <br />
 [[Category:Database]]

@@ Line 68: / Line 68: @@
 ;<div id="name">'''name'''</div>
 :Name of the asset as it would appear in inventory
 ;<div id="description">'''description'''</div>
 :Asset's description field, as it appears in various client-side editing widgets
 ;<div id="assetType">'''assetType'''</div>
@@ Line 89: / Line 87: @@
 :** 21 - Gesture
 :** 49 - Mesh
 ;<div id="local">'''local'''</div>
 :For Future Use
 ;<div id="temporary">'''temporary'''</div>
 :For Future Use
 ;<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
 ;<div id="id">'''id'''</div>
 :UUID which uniquely identifies the asset within the system
 ;<div id="create_time">'''create_time'''</div>
 :Date and time the asset was created in standard UNIX format
 ;<div id="access_time">'''access_time'''</div>
 :Date and time the asset was last used in standard UNIX format
 ;<div id="asset_flags">'''asset_flags'''</div>
 :Asset flags.
 ;<div id="CreatorID">'''CreatorID'''</div>
 :Creator avatar UUID
 <br />
 ----
         (back to [[Database Documentation]])
 <br />
 [[Category:Database]]

@@ Line 8: / Line 8: @@
 == Asset Table Structure ==
 The structure of the assets table as of v0.7.1.1 is as follows:
 <br />
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type
@@ Line 39: / Line 22: @@
 |-
 | '''[[#name|name]]''' || varchar(64) || utf8_general_ci || || No || ''None'' ||
-|-
+|- style="background:#eee;"
 | '''[[#description|description]]''' || varchar(64) || utf8_general_ci ||  || No || ''None'' ||
 |-
 | '''[[#assetType|assetType]]''' || tinyint(4) ||  ||  || No || ''None'' ||
-|-
+|- style="background:#eee;"
 | '''[[#local|local]]''' || tinyint(1) ||  ||  || No || ''None'' ||
 |-
 | '''[[#temporary|temporary]]''' || tinyint(1) ||  ||  || No || ''None'' ||
-|-
+|- style="background:#eee;"
 | '''[[#data|data]]''' || longblob ||  || <code>BINARY</code> || No || ''None'' ||
 |-
 | '''[[#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 ||
 |-
 | '''[[#access_time|access_time]]''' || int(11) ||  ||  || Yes || 0 ||
-|-
+|- style="background:#eee"
 | '''[[#asset_flags|asset_flags]]''' || int(11) ||  ||  || No || 0 ||
 |-
 | '''[[#CreatorID|CreatorID]]''' || varchar(128) || utf8_general_ci ||  || No ||  ||
 |}
 <br />
 <br />
 == Asset Fields ==

@@ Line 75: / Line 75: @@
 :Integer which designates the asset's type
 :* Valid values are (need help checking and filling these in):
-:** 0 - Textures
+:** 0 - Texture in JPEG2000 J2C stream format
 :** 1 - Sound
 :** 2 - Calling Card
 :** 3 - Landmark
-:** 4 - ??
+:** 4 - Script&nbsp;&nbsp;[Obsolete]
 :** 5 - Clothing
-:** 6 - Primitive
+:** 6 - Primitive that can contain textures, sounds, and more
-:** 7 - Note
+:** 7 - Notecard
-:** 8 - ??
+:** 8 - Folder
-:** 9 - ??
+:** 9 - Root Inventory Folder
-:** 10 - Script
+:** 10 - LSLText (aka a script)
-:** 11 - ??
+:** 11 - LSL bytecode for a script
-:** 12 - ??
+:** 12 - Texture in uncompressed TGA format
 :** 13 - Body Part
-:** 14 - ??
+:** 14 - Trash Folder
-:** 15 - ??
+:** 15 - Snapshot Folder
-:** 16 - ??
+:** 16 - Lost and Found Folder
-:** 17 - ??
+:** 17 - Sound file in uncompressed format
-:** 18 - ??
+:** 18 - Uncompressed TGA non-square image (not to be used as a texture)
-:** 19 - ??
+:** 19 - Compressed JPEG non-square image (not to be used as a texture)
 :** 20 - Animation
 :** 21 - Gesture
 <br />