pvp_tier

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
Name	text			YES	NULL
ID	int	unsigned	PRI	NO	0
MinRating	smallint	signed		NO	0
MaxRating	smallint	signed		NO	0
PrevTier	int	signed		NO	0
NextTier	int	signed		NO	0
BracketID	tinyint	signed		NO	0
Rank	tinyint	signed		NO	0
RankIconFileDataID	int	signed		NO	0
VerifiedBuild	int	signed	PRI	NO	0

 

Description of fields

Name

- no description -
 

ID

- no description -
 

MinRating

- no description -
 

MaxRating

- no description -
 

PrevTier

- no description -
 

NextTier

- no description -
 

BracketID

- no description -
 

Rank

- no description -
 

RankIconFileDataID

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