8592 rows in this table. Schema below.
| Name | Type | Null | Key | Default |
|---|---|---|---|---|
| entry | mediumint(8) unsigned | NO | PRI | 0 |
| display_id1 | mediumint(8) unsigned | NO | MUL | 0 |
| display_id2 | mediumint(8) unsigned | NO | 0 | |
| display_id3 | mediumint(8) unsigned | NO | 0 | |
| display_id4 | mediumint(8) unsigned | NO | 0 | |
| mount_display_id | smallint(5) unsigned | NO | 0 | |
| name | char(100) | NO | MUL | '0' |
| subname | char(100) | YES | NULL | |
| static_flags | int(10) | NO | 0 | |
| gossip_menu_id | mediumint(8) unsigned | NO | 0 | |
| level_min | tinyint(3) unsigned | NO | 1 | |
| level_max | tinyint(3) unsigned | NO | 1 | |
| faction | smallint(5) unsigned | NO | 0 | |
| npc_flags | int(10) unsigned | NO | 0 | |
| speed_walk | float | NO | 1 | |
| speed_run | float | NO | 1.14286 | |
| scale | float | NO | 1 | |
| detection_range | float | NO | 20 | |
| call_for_help_range | float | NO | 5 | |
| leash_range | float | NO | 0 | |
| rank | tinyint(3) unsigned | NO | 0 | |
| xp_multiplier | float | NO | 1 | |
| damage_school | tinyint(4) | NO | 0 | |
| damage_variance | float | NO | 0.14 | |
| damage_multiplier | float | NO | 1 | |
| health_multiplier | float | NO | 1 | |
| mana_multiplier | float | NO | 1 | |
| armor_multiplier | float | NO | 1 | |
| base_attack_time | int(10) unsigned | NO | 2000 | |
| ranged_attack_time | int(10) unsigned | NO | 2000 | |
| unit_class | tinyint(3) unsigned | NO | 0 | |
| unit_flags | int(10) unsigned | NO | 0 | |
| dynamic_flags | int(10) unsigned | NO | 0 | |
| beast_family | tinyint(4) | NO | 0 | |
| trainer_type | tinyint(4) | NO | 0 | |
| trainer_spell | mediumint(8) unsigned | 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 | |
| loot_id | mediumint(8) unsigned | NO | 0 | |
| pickpocket_loot_id | mediumint(8) unsigned | NO | 0 | |
| skinning_loot_id | mediumint(8) unsigned | NO | 0 | |
| holy_res | smallint(5) | NO | 0 | |
| fire_res | smallint(5) | NO | 0 | |
| nature_res | smallint(5) | NO | 0 | |
| frost_res | smallint(5) | NO | 0 | |
| shadow_res | smallint(5) | NO | 0 | |
| arcane_res | smallint(5) | NO | 0 | |
| spell_id1 | mediumint(8) unsigned | NO | 0 | |
| spell_id2 | mediumint(8) unsigned | NO | 0 | |
| spell_id3 | mediumint(8) unsigned | NO | 0 | |
| spell_id4 | mediumint(8) unsigned | NO | 0 | |
| spell_list_id | int(11) unsigned | NO | 0 | |
| pet_spell_list_id | mediumint(8) unsigned | NO | 0 | |
| auras | text | YES | NULL | |
| gold_min | mediumint(8) unsigned | NO | 0 | |
| gold_max | mediumint(8) unsigned | NO | 0 | |
| ai_name | char(64) | NO | '' | |
| movement_type | tinyint(3) unsigned | NO | 0 | |
| inhabit_type | tinyint(3) unsigned | NO | 3 | |
| civilian | tinyint(3) unsigned | NO | 0 | |
| racial_leader | tinyint(3) unsigned | NO | 0 | |
| regeneration | tinyint(3) unsigned | NO | 3 | |
| equipment_id | mediumint(8) unsigned | NO | 0 | |
| trainer_id | mediumint(8) unsigned | NO | 0 | |
| vendor_id | mediumint(8) unsigned | NO | 0 | |
| mechanic_immune_mask | int(10) unsigned | NO | 0 | |
| school_immune_mask | int(10) unsigned | NO | 0 | |
| flags_extra | int(10) unsigned | NO | 0 | |
| script_name | char(64) | NO | '' |