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