Database:Inventoryfolders
From OpenSimulator
m (Formatting changes to match other database documentation pages) |
m (Minor formatting changes to match other database documentation pages) |
||
| Line 33: | Line 33: | ||
| [[#parentFolderID|parentFolderID]] || char(36) || YES || MUL || NULL || | | [[#parentFolderID|parentFolderID]] || char(36) || YES || MUL || NULL || | ||
|} | |} | ||
| + | <br /> | ||
| + | (back to [[Database Documentation]]) | ||
<br /> | <br /> | ||
| + | |||
| + | ---- | ||
<br /> | <br /> | ||
== inventoryitems Fields == | == inventoryitems Fields == | ||
| − | '''folderName'''< | + | ;<div id="folderName">'''folderName'''</div> |
Text of the folder's name as it appears in the client inventory interface | Text of the folder's name as it appears in the client inventory interface | ||
<br /> | <br /> | ||
| − | < | + | |
| − | '''type'''< | + | <div id="type">'''type'''</div> |
Type of inventory folder. This is a subset of enum InventoryType for folders only. | Type of inventory folder. This is a subset of enum InventoryType for folders only. | ||
<br /> | <br /> | ||
| + | |||
<table> | <table> | ||
<tr><td>Value</td><td>Icon</td><td>Meaning</td></tr> | <tr><td>Value</td><td>Icon</td><td>Meaning</td></tr> | ||
| Line 72: | Line 77: | ||
<br /> | <br /> | ||
| − | '''version'''< | + | <div id="version">'''version'''</div> |
This item is incremented when an item is added to the folder. | This item is incremented when an item is added to the folder. | ||
| − | |||
NOTE: This appears to be a form of serial number that is updated when the contents of the folder is changed. A change in the number informs the viewer that it should refresh its copy of the folder contents. This needs to be verified. | NOTE: This appears to be a form of serial number that is updated when the contents of the folder is changed. A change in the number informs the viewer that it should refresh its copy of the folder contents. This needs to be verified. | ||
<br /> | <br /> | ||
| − | < | + | |
| − | '''folderID'''< | + | <div id="folderID">'''folderID'''</div> |
Uniquely identifies the folder. This facilitates the folder being claimed as a logical container by other folders, or the things in the inventoryitems table that are said to be 'in' the folder. | Uniquely identifies the folder. This facilitates the folder being claimed as a logical container by other folders, or the things in the inventoryitems table that are said to be 'in' the folder. | ||
<br /> | <br /> | ||
| − | < | + | |
| − | '''agentID'''< | + | <div id="agentID">'''agentID'''</div> |
Unique agent identifier - identifies the agent which owns the folder. | Unique agent identifier - identifies the agent which owns the folder. | ||
<br /> | <br /> | ||
| − | < | + | |
| − | '''parentFolderID'''< | + | <div id="parentFolderID">'''parentFolderID'''</div> |
This identifies the parent folder that contains this folder. Hence, it must match anGother inventory folders table entry which has that folderID. | This identifies the parent folder that contains this folder. Hence, it must match anGother inventory folders table entry which has that folderID. | ||
| Line 94: | Line 98: | ||
(back to [[Database Documentation]]) | (back to [[Database Documentation]]) | ||
| − | |||
<br /> | <br /> | ||
[[Category:Database]] | [[Category:Database]] | ||
Revision as of 18:21, 11 April 2016
 |
Languages: |
|
The inventoryfolders table records details concerning the avatar's inventory organisation, specifically the folders. No information about contents of the folders is in this table. (back to Database Documentation)
inventoryitems Table Structure
The structure of the inventoryitems table is as follows:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| folderName | varchar(64) | YES | NULL | ||
| type | smallint(6) | NO | 0 | ||
| version | int(11) | NO | 0 | ||
| folderID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | |
| agentID | char(36) | YES | MUL | NULL | |
| parentFolderID | char(36) | YES | MUL | NULL |
(back to Database Documentation)
inventoryitems Fields
- folderName
Text of the folder's name as it appears in the client inventory interface
Type of inventory folder. This is a subset of enum InventoryType for folders only.
| Value | Icon | Meaning |
| -1 |  | User Defined |
| 0 |  | Textures |
| 1 |  | Sounds |
| 2 |  | Calling Cards |
| 3 |  | Landmarks |
| 5 |  | Clothing |
| 6 |  | Objects |
| 7 |  | Notecards |
| 8 | | My Inventory |
| 9 | | |
| 10 |  | Scripts |
| 13 |  | Body Parts |
| 14 |  | Trash |
| 15 |  | Photo Album |
| 16 |  | Lost and Found |
| 20 |  | Animations |
| 21 |  | Gestures |
| 23 |  | Favorites |
| 46 |  | Current Outfit |
| 47 | | Outfits |
| 49 |  | Meshes |
| 100 | | My Suitcase |
This item is incremented when an item is added to the folder.
NOTE: This appears to be a form of serial number that is updated when the contents of the folder is changed. A change in the number informs the viewer that it should refresh its copy of the folder contents. This needs to be verified.
Uniquely identifies the folder. This facilitates the folder being claimed as a logical container by other folders, or the things in the inventoryitems table that are said to be 'in' the folder.
Unique agent identifier - identifies the agent which owns the folder.
This identifies the parent folder that contains this folder. Hence, it must match anGother inventory folders table entry which has that folderID.
(back to Database Documentation)
