...
Field | Type | Attributes | Key | Null | Default | Extra | 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)name | char(200) | signed | NO | 0 | |||||
femaleName | char(200) | signed | NO | NULL | ||||||||||||||||||
subname | char(200) | signed | YES | NULL | ||||||||||||||||||
IconName | char(100) | signed | 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 | bigintint(2010) | 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||||||||||||||||||
dynamicflags | int(10) | unsigned | NO | 0 | ||||||||||||||||||
dynamicflagsfamily | inttinyint(104) | unsignedsigned | NO | 0family | ||||||||||||||||||
trainer_type | tinyint(4) | signed | NO | 0 | ||||||||||||||||||
trainer_class | tinyint(3) | unsigned | NO | 0 | ||||||||||||||||||
trainer_race | 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 | ||||||||||||||||||
skinloot | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
resistance1 | smallint(5) | signed | NO | 0 | ||||||||||||||||||
resistance2 | smallint(5) | signed | NO | 0 | ||||||||||||||||||
resistance3 | smallint(5) | signed | NO | 0 | ||||||||||||||||||
resistance4 | smallint(5) | signed | NO | 0 | ||||||||||||||||||
resistance5 | smallint(5) | signed | NO | 0 | ||||||||||||||||||
resistance6 | smallint(5) | signed | NO | 0 | ||||||||||||||||||
spell1 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
spell2 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
spell3 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
spell4 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
spell5 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
spell6 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
spell7 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
spell8 | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
VehicleId | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
mingold | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
maxgold | mediumint(8) | unsigned | NO | 0 | ||||||||||||||||||
AIName | varcharchar(64) | signed | NO | " | ||||||||||||||||||
MovementType | tinyint(3) | unsigned | NO | 0 | ||||||||||||||||||
tinyint(3) | unsigned | NO | 3 | removed and replaced by table creature_template_movement | ||||||||||||||||||
HoverHeight | float | unsigned | NO | 1 | ||||||||||||||||||
HealthModifier | float | signed | NO | 1 | ||||||||||||||||||
HealthModifierExtra | float | signed | NO | 1 | ||||||||||||||||||
ManaModifier | float | signed | NO | 1 | ||||||||||||||||||
ManaModifierExtra | float | signed | NO | 1 | ||||||||||||||||||
ArmorModifier | float | signed | NO | 1 | ||||||||||||||||||
DamageModifier | float | signed | NO | 1 | ||||||||||||||||||
ExperienceModifier | float | signed | NO | 1 | ||||||||||||||||||
RacialLeader | tinyint(3) | unsigned | NO | 0 | ||||||||||||||||||
movementID | int(11) | unsigned | NO | 0 | FadeRegionRadius | float | signed | NO | 0 | WidgetSetID | int(11) | signed | NO | 0 | WidgetSetUnitConditionID | int(11) | signedNO | 0 | ||||
RegenHealth | tinyint(3) | unsigned | NO | 1 | ||||||||||||||||||
mechanic_immune_mask | int(10) | unsigned | NO | 0 | ||||||||||||||||||
flags_extra | int(10) | unsigned | NO | 0 | ||||||||||||||||||
ScriptName | varcharchar(64) | signed | NO | " | ||||||||||||||||||
VerifiedBuild | intsmallint(115) | signed | YES | 0 |
Description of the fields
...
Flag | Type | ||
---|---|---|---|
1 | CREATURE_FLAG_EXTRA_INSTANCE_BIND | 0x00000001 | creature kill binds instance to killer and killer's group |
2 | CREATURE_FLAG_EXTRA_CIVILIAN | 0x00000002 | creature does not aggro (ignore faction/reputation hostility) |
4 | CREATURE_FLAG_EXTRA_NO_PARRY | 0x00000004 | creature does not parry |
8 | CREATURE_FLAG_EXTRA_NO_PARRY_HASTEN | 0x00000008 | creature does not counter-attack at parry |
16 | CREATURE_FLAG_EXTRA_NO_BLOCK | 0x00000010 | creature does not block |
32 | CREATURE_FLAG_EXTRA_NO_CRUSH | 0x00000020 | creature does not do crush-attacks |
64 | CREATURE_FLAG_EXTRA_NO_XP_AT_KILL | 0x00000040 | creature kill does not give XP |
128 | CREATURE_FLAG_EXTRA_TRIGGER | 0x00000080 | creature is trigger-NPC (invisible to players only) |
256 | CREATURE_FLAG_EXTRA_NO_TAUNT | 0x00000100 | creature is immune to taunt-auras and "attack me"-effects |
512 | CREATURE_FLAG_EXTRA_NO_MOVE_FLAGS_UPDATE | 0x00000200 | creature won't update movement flags |
1024 | CREATURE_FLAG_EXTRA_GHOST_VISIBILITY | 0x00000400 | creature will be only visible for dead players |
2048 | CREATURE_FLAG_EXTRA_USE_OFFHAND_ATTACK | 0x00000800 | creature will use offhand attacks |
4096 | CREATURE_FLAG_EXTRA_NO_SELL_VENDOR | 0x00001000 | players can't sell items to this vendor |
16384 | CREATURE_FLAG_EXTRA_WORLDEVENT | 0x00004000 | custom flag for world events (left room for merging) |
32768 | CREATURE_FLAG_EXTRA_GUARD | 0x00008000 | creature is a guard (Will ignore feign death and vanish) |
131072 | CREATURE_FLAG_EXTRA_NO_CRIT | 0x00020000 | creature does not do critical strikes |
262144 | CREATURE_FLAG_EXTRA_NO_SKILLGAIN | 0x00040000 | creature won't increase weapon skills |
524288 | CREATURE_FLAG_EXTRA_TAUNT_DIMINISH | 0x00080000 | creature taunt is subject to diminishing returns |
1048576 | CREATURE_FLAG_EXTRA_ALL_DIMINISH | 0x00100000 | Creature is subject to all diminishing returns |
2097152 | CREATURE_FLAG_EXTRA_NO_PLAYER_DAMAGE_REQ | 0x00200000 | NPCs can help with killing this creature and player will still be credited if he tags the creature |
268435456 | CREATURE_FLAG_EXTRA_DUNGEON_BOSS | 0x10000000 | Creature is a dungeon boss. This flag is generically set by core during runtime. Setting this in database will give you startup error. |
536870912 | CREATURE_FLAG_EXTRA_IGNORE_PATHFINDING | 0x20000000 | Creature will ignore pathfinding. This is like disabling Mmaps, only for one creature. |
1073741824 | CREATURE_FLAG_EXTRA_IMMUNITY_KNOCKBACK | 0x40000000 | creature will immune all knockback effects |
...