item_search_name

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
AllowableRace	bigint	signed		NO	0
Display	text			YES	NULL
OverallQualityID	tinyint	unsigned		NO	0
ExpansionID	int	signed		NO	0
MinFactionID	smallint	unsigned		NO	0
MinReputation	int	signed		NO	0
AllowableClass	int	signed		NO	0
RequiredLevel	tinyint	signed		NO	0
RequiredSkill	smallint	unsigned		NO	0
RequiredSkillRank	smallint	unsigned		NO	0
RequiredAbility	int	unsigned		NO	0
ItemLevel	smallint	unsigned		NO	0
Flags1	int	signed		NO	0
Flags2	int	signed		NO	0
Flags3	int	signed		NO	0
Flags4	int	signed		NO	0
Flags5	int	signed		NO	0
VerifiedBuild	int	signed	PRI	NO	0

Description of fields

ID

- no description -  

AllowableRace

- no description -  

Display

- no description -  

OverallQualityID

- no description -  

ExpansionID

- no description -  

MinFactionID

- no description -  

MinReputation

- no description -  

AllowableClass

- no description -  

RequiredLevel

- no description -  

RequiredSkill

- no description -  

RequiredSkillRank

- no description -  

RequiredAbility

- no description -  

ItemLevel

- no description -  

Flags1

- no description -  

Flags2

- no description -  

Flags3

- no description -  

Flags4

- no description -  

Flags5

- 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.