item

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
ClassID	tinyint	unsigned		NO	0
SubclassID	tinyint	unsigned		NO	0
Material	tinyint	unsigned		NO	0
InventoryType	tinyint	signed		NO	0
SheatheType	tinyint	unsigned		NO	0
SoundOverrideSubclassID	tinyint	signed		NO	0
IconFileDataID	int	signed		NO	0
ItemGroupSoundsID	tinyint	unsigned		NO	0
ContentTuningID	int	signed		NO	0
ModifiedCraftingReagentItemID	int	signed		NO	0
CraftingQualityID	int	signed		NO	0
VerifiedBuild	int	signed	PRI	NO	0

 

Description of fields

ID

- no description -
 

ClassID

- no description -
 

SubclassID

- no description -
 

Material

- no description -
 

InventoryType

- no description -
 

SheatheType

- no description -
 

SoundOverrideSubclassID

- no description -
 

IconFileDataID

- no description -
 

ItemGroupSoundsID

- no description -
 

ContentTuningID

- no description -
 

ModifiedCraftingReagentItemID

- no description -
 

CraftingQualityID

- no description -
 

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.