Database:Assets
From OpenSimulator
(Difference between revisions)
JeffKelley (Talk | contribs) m (fixed asset types, removed folder types and never seen assets like SoundWAV, ImageTGA, ImageJPEG) |
m (Removed unneeded <br/> markups) |
||
| Line 68: | Line 68: | ||
;<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 | ||
| − | |||
;<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 | ||
| − | |||
;<div id="assetType">'''assetType'''</div> | ;<div id="assetType">'''assetType'''</div> | ||
| Line 89: | Line 87: | ||
:** 21 - Gesture | :** 21 - Gesture | ||
:** 49 - Mesh | :** 49 - Mesh | ||
| − | |||
;<div id="local">'''local'''</div> | ;<div id="local">'''local'''</div> | ||
:For Future Use | :For Future Use | ||
| − | |||
;<div id="temporary">'''temporary'''</div> | ;<div id="temporary">'''temporary'''</div> | ||
:For Future Use | :For Future Use | ||
| − | |||
;<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 | ||
| − | |||
;<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 | ||
| − | |||
;<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 | ||
| − | |||
;<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 | ||
| − | |||
;<div id="asset_flags">'''asset_flags'''</div> | ;<div id="asset_flags">'''asset_flags'''</div> | ||
:Asset flags. | :Asset flags. | ||
| − | |||
;<div id="CreatorID">'''CreatorID'''</div> | ;<div id="CreatorID">'''CreatorID'''</div> | ||
:Creator avatar UUID | :Creator avatar UUID | ||
| + | |||
<br /> | <br /> | ||
| + | |||
---- | ---- | ||
| + | |||
(back to [[Database Documentation]]) | (back to [[Database Documentation]]) | ||
| + | |||
<br /> | <br /> | ||
[[Category:Database]] | [[Category:Database]] | ||
Revision as of 16:21, 11 April 2016
The assets table records all assets including textures, notecards, scripts, and avatar parts (back to Database Documentation)
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 | Null | Key | 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 | |||
| id | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | ||
| create_time | int(11) | YES | 0 | |||
| access_time | int(11) | YES | 0 |
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 - 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
- Valid values are (need help checking and filling these in):
- 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)
