Database:Assets
From OpenSimulator
(Difference between revisions)
((including previous edits today) Added table for 0.7.1.1 and cleaned up page formatting) |
m (Robot: Cosmetic changes) |
||
| Line 7: | Line 7: | ||
<br /><br /> | <br /><br /> | ||
| − | ==Asset Table Structure== | + | == Asset Table Structure == |
The current(?) structure of the assets table is as follows: | The current(?) structure of the assets table is as follows: | ||
<br /> | <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> |
<tr><td> </td></tr> | <tr><td> </td></tr> | ||
<tr><td>Name</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td> </td></tr> | <tr><td>Name</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td> </td></tr> | ||
| Line 62: | Line 62: | ||
<br /> | <br /> | ||
<br /> | <br /> | ||
| − | ==Asset Fields== | + | == Asset Fields == |
;<div id="name">'''name'''</div> | ;<div id="name">'''name'''</div> | ||
| Line 130: | Line 130: | ||
: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 18:55, 3 March 2012
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 | 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 |
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
- 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)
