creature_equip_template

This table contains all the equipment combinations that can be set for each creature.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
CreatureID	int	unsigned	PRI	NO	0
ID	tinyint	unsigned	PRI	NO	1
ItemID1	int	unsigned		NO	0
ItemID2	int	unsigned		NO	0
ItemID3	int	unsigned		NO	0
VerifiedBuild	int	signed		YES	NULL

Description of fields

CreatureID

The immediate corresponding entryid to creature_template table.  

ID

An additional identifier for each individual entry, enabling multiple equipments for one creature entry. Counter must start with 1 and increment accordingly.  

ItemID1

This is the Item ID of the equipment used in the right hand slot.  

ItemID2

This is the Item ID of the equipment used in the left hand slot.  

ItemID3

This is the Item ID of the equipment used in the ranged slot.  

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.