blob: 072065892060a18ac0fc696395b96c1ab6d0f266 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
[Database Structure](Database-Structure) > [World-Database](World-Database) > [creature_template](creature_template)
Column | Type | Description
--- | --- | ---
Entry | mediumint(8) unsigned |
Difficulty_entry_1 | mediumint(8) unsigned |
Difficulty_entry_2 | mediumint(8) unsigned |
Difficulty_entry_3 | mediumint(8) unsigned |
KillCredit1 | int(10) unsigned |
KillCredit2 | int(10) unsigned |
Modelid1 | mediumint(8) unsigned |
Modelid2 | mediumint(8) unsigned |
Modelid3 | mediumint(8) unsigned |
Modelid4 | mediumint(8) unsigned |
Name | char(100) |
Subname | char(100) |
IconName | char(100) |
Gossip_menu_id | mediumint(8) unsigned |
Minlevel | tinyint(3) unsigned |
Maxlevel | tinyint(3) unsigned |
Exp | smallint(6) |
Faction | smallint(5) unsigned |
Npcflag | int(10) unsigned |
Speed_walk | float |
Speed_run | float |
Scale | float |
Rank | tinyint(3) unsigned |
Mindmg | float |
Maxdmg | float |
Dmgschool | tinyint(4) |
Attackpower | int(10) unsigned |
Dmg_multiplier | float |
Baseattacktime | int(10) unsigned |
Rangeattacktime | int(10) unsigned |
Unit_class | tinyint(3) unsigned |
Unit_flags | int(10) unsigned |
Unit_flags2 | int(10) unsigned |
Dynamicflags | int(10) unsigned |
Family | tinyint(4) |
Trainer_type | tinyint(4) |
Trainer_spell | mediumint(8) unsigned |
Trainer_class | tinyint(3) unsigned |
Trainer_race | tinyint(3) unsigned |
Minrangedmg | float |
Maxrangedmg | float |
Rangedattackpower | smallint(5) unsigned |
Type | tinyint(3) unsigned |
Type_flags | int(10) unsigned |
Lootid | mediumint(8) unsigned |
Pickpocketloot | mediumint(8) unsigned |
Skinloot | mediumint(8) unsigned |
Resistance1 | smallint(6) |
Resistance2 | smallint(6) |
Resistance3 | smallint(6) |
Resistance4 | smallint(6) |
Resistance5 | smallint(6) |
Resistance6 | smallint(6) |
Spell1 | mediumint(8) unsigned |
Spell2 | mediumint(8) unsigned |
Spell3 | mediumint(8) unsigned |
Spell4 | mediumint(8) unsigned |
Spell5 | mediumint(8) unsigned |
Spell6 | mediumint(8) unsigned |
Spell7 | mediumint(8) unsigned |
Spell8 | mediumint(8) unsigned |
PetSpellDataId | mediumint(8) unsigned |
VehicleId | mediumint(8) unsigned |
Mingold | mediumint(8) unsigned |
Maxgold | mediumint(8) unsigned |
AIName | char(64) |
MovementType | tinyint(3) unsigned |
InhabitType | tinyint(3) unsigned |
HoverHeight | float |
Health_mod | float |
Mana_mod | float |
Armor_mod | float |
RacialLeader | tinyint(3) unsigned |
MovementId | int(11) unsigned |
RegenHealth | tinyint(3) unsigned |
Mechanic_immune_mask | int(10) unsigned |
Flags_extra | int(10) unsigned |
ScriptName | char(64) |
VerifiedBuild | smallint(6) |
|
