Database:Inventoryfolders
From OpenSimulator
m (Added comments about version column in inventoryfolders table) |
|||
| Line 51: | Line 51: | ||
<br> | <br> | ||
'''version'''<br> | '''version'''<br> | ||
| − | + | This item is incremented when an item is added to the folder. | |
| + | |||
| + | NOTE: This appears to be a count of the items in a folder but there does not appear to be a corresponding decrement when items are deleted. A decrement of this column may exist but be buried in some other file. This needs to be verified. | ||
<br> | <br> | ||
<br> | <br> | ||
Revision as of 17:46, 18 November 2009
 |
Languages: |
|
inventoryfolders Records details concerning the avatar's inventory organisation, (back to Database Documentation)
specifically the folders. No information about contents of the folders is in this table.
The current structure of the avatar appearance 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)
folderName
Text of the folder's name as it appears in the client inventory interface
type
Numerically encoded inventory folder type:
| Value | Meaning | |
| -1 | User Defined | |
| 0 | Texture | |
| 1 | Sounds | |
| 2 | Calling Cards | |
| 3 | Landmarks | |
| 5 | Clothing | |
| 6 | Object | |
| 7 | Notecard | |
| 8 | Top Level | |
| 10 | Script | |
| 13 | Body Part | |
| 14 | Trash | |
| 15 | Snapshot | |
| 16 | Lost and Found | |
| 20 | Animation | |
| 21 | Gesture |
version
This item is incremented when an item is added to the folder.
NOTE: This appears to be a count of the items in a folder but there does not appear to be a corresponding decrement when items are deleted. A decrement of this column may exist but be buried in some other file. This needs to be verified.
folderID
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.
agentID
Unique agent identifier - identifies the agent which owns the folder.
parentFolderID
Unique folder identifier 'claims' the folder which is said to 'contain' this one in the same fashion as things in the inventoryitems table 'claim' the folder said to 'contain' them
(back to Database Documentation)
