creature_template (master)

The `creature_template` table

This table contains the description of creatures. Each spawned creature is an instance of a template present in this table, this means every creature MUST be defined in this table.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment

Field	Type	Attributes	Key	Null	Default	Comment
entry	mediumint(8)	unsigned	PRI	NO	0
difficulty_entry_1	mediumint(8)	unsigned		NO	0
difficulty_entry_2	mediumint(8)	unsigned		NO	0
difficulty_entry_3	mediumint(8)	unsigned		NO	0
KillCredit1	int(10)	unsigned		NO	0
KillCredit2	int(10)	unsigned		NO	0
modelid1	mediumint(8)	unsigned		NO	0	removed and replaced by creature_template_model
modelid2	mediumint(8)	unsigned		NO	0	removed and replaced by creature_template_model
modelid3	mediumint(8)	unsigned		NO	0	removed and replaced by creature_template_model
modelid4	mediumint(8)	unsigned		NO	0	removed and replaced by creature_template_model
name	text			YES
femaleName	text			YES
subname	text			YES
TitleAlt	text			YES
IconName	varchar(64)			YES	NULL
gossip_menu_id	mediumint(8)	unsigned		NO	0
minlevel	smallint(5)	signed		NO	1
maxlevel	smallint(5)	signed		NO	1
HealthScalingExpansion	mediumint(5)	signed		NO	0
RequiredExpansion	mediumint(5)	signed		NO	0
VignetteID	mediumint(5)	signed		NO	0
faction	smallint(5)	unsigned		NO	0
npcflag	bigint(20)	unsigned		NO	0
speed_walk	float	signed		NO	1	Result of 2.5/2.5, most common value
speed_run	float	signed		NO	1.14286	Result of 8.0/7.0, most common value
scale	float	signed		NO	1
rank	tinyint(3)	unsigned		NO	0
dmgschool	tinyint(4)	signed		NO	0
BaseAttackTime	int(10)	unsigned		NO	0
RangeAttackTime	int(10)	unsigned		NO	0
BaseVariance	float	signed		NO	1
RangeVariance	float	signed		NO	1
unit_class	tinyint(3)	unsigned		NO	0
unit_flags	int(10)	unsigned		NO	0
unit_flags2	int(10)	unsigned		NO	0
unit_flags3	int(10)	unsigned		NO	0
dynamicflags	int(10)	unsigned		NO	0
family	tinyint(4)	signed		NO	0
trainer_class	tinyint(3)	unsigned		NO	0
type	tinyint(3)	unsigned		NO	0
type_flags	int(10)	unsigned		NO	0
type_flags2	int(10)	unsigned		NO	0
lootid	mediumint(8)	unsigned		NO	0
pickpocketloot	mediumint(8)	unsigned		NO	0