· 7 years ago · Oct 31, 2018, 09:30 PM
1CREATE TABLE IF NOT EXISTS `creature_template` (
2 `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
3 `difficulty_entry_1` mediumint(8) unsigned NOT NULL DEFAULT '0',
4 `difficulty_entry_2` mediumint(8) unsigned NOT NULL DEFAULT '0',
5 `difficulty_entry_3` mediumint(8) unsigned NOT NULL DEFAULT '0',
6 `KillCredit1` int(10) unsigned NOT NULL DEFAULT '0',
7 `KillCredit2` int(10) unsigned NOT NULL DEFAULT '0',
8 `modelid1` mediumint(8) unsigned NOT NULL DEFAULT '0',
9 `modelid2` mediumint(8) unsigned NOT NULL DEFAULT '0',
10 `modelid3` mediumint(8) unsigned NOT NULL DEFAULT '0',
11 `modelid4` mediumint(8) unsigned NOT NULL DEFAULT '0',
12 `name` char(200) NOT NULL DEFAULT '0',
13 `femaleName` char(200) NOT NULL,
14 `subname` char(200) DEFAULT NULL,
15 `IconName` char(100) DEFAULT NULL,
16 `gossip_menu_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
17 `minlevel` smallint(5) NOT NULL DEFAULT '1',
18 `maxlevel` smallint(5) NOT NULL DEFAULT '1',
19 `HealthScalingExpansion` mediumint(5) NOT NULL DEFAULT '0',
20 `RequiredExpansion` mediumint(5) NOT NULL DEFAULT '0',
21 `VignetteID` mediumint(5) NOT NULL DEFAULT '0',
22 `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
23 `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0',
24 `speed_walk` float NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value',
25 `speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value',
26 `scale` float NOT NULL DEFAULT '1',
27 `rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
28 `dmgschool` tinyint(4) NOT NULL DEFAULT '0',
29 `BaseAttackTime` int(10) unsigned NOT NULL DEFAULT '0',
30 `RangeAttackTime` int(10) unsigned NOT NULL DEFAULT '0',
31 `BaseVariance` float NOT NULL DEFAULT '1',
32 `RangeVariance` float NOT NULL DEFAULT '1',
33 `unit_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
34 `unit_flags` int(10) unsigned NOT NULL DEFAULT '0',
35 `unit_flags2` int(10) unsigned NOT NULL DEFAULT '0',
36 `unit_flags3` int(10) unsigned NOT NULL DEFAULT '0',
37 `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0',
38 `family` tinyint(3) unsigned NOT NULL DEFAULT '0',
39 `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
40 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
41 `type_flags` int(10) unsigned NOT NULL DEFAULT '0',
42 `type_flags2` int(10) unsigned NOT NULL DEFAULT '0',
43 `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
44 `pickpocketloot` mediumint(8) unsigned NOT NULL DEFAULT '0',
45 `skinloot` mediumint(8) unsigned NOT NULL DEFAULT '0',
46 `resistance1` smallint(6) NOT NULL DEFAULT '0',
47 `resistance2` smallint(6) NOT NULL DEFAULT '0',
48 `resistance3` smallint(6) NOT NULL DEFAULT '0',
49 `resistance4` smallint(6) NOT NULL DEFAULT '0',
50 `resistance5` smallint(6) NOT NULL DEFAULT '0',
51 `resistance6` smallint(6) NOT NULL DEFAULT '0',
52 `spell1` mediumint(8) unsigned NOT NULL DEFAULT '0',
53 `spell2` mediumint(8) unsigned NOT NULL DEFAULT '0',
54 `spell3` mediumint(8) unsigned NOT NULL DEFAULT '0',
55 `spell4` mediumint(8) unsigned NOT NULL DEFAULT '0',
56 `spell5` mediumint(8) unsigned NOT NULL DEFAULT '0',
57 `spell6` mediumint(8) unsigned NOT NULL DEFAULT '0',
58 `spell7` mediumint(8) unsigned NOT NULL DEFAULT '0',
59 `spell8` mediumint(8) unsigned NOT NULL DEFAULT '0',
60 `VehicleId` mediumint(8) unsigned NOT NULL DEFAULT '0',
61 `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0',
62 `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
63 `AIName` char(64) NOT NULL DEFAULT '',
64 `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
65 `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
66 `HoverHeight` float NOT NULL DEFAULT '1',
67 `HealthModifier` float NOT NULL DEFAULT '1',
68 `HealthModifierExtra` float NOT NULL DEFAULT '1',
69 `ManaModifier` float NOT NULL DEFAULT '1',
70 `ManaModifierExtra` float NOT NULL DEFAULT '1',
71 `ArmorModifier` float NOT NULL DEFAULT '1',
72 `DamageModifier` float NOT NULL DEFAULT '1',
73 `ExperienceModifier` float NOT NULL DEFAULT '1',
74 `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0',
75 `movementId` int(11) unsigned NOT NULL DEFAULT '0',
76 `RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1',
77 `mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0',
78 `flags_extra` int(10) unsigned NOT NULL DEFAULT '0',
79 `flags_extra2` int(10) unsigned NOT NULL,
80 `flags_extra3` int(10) unsigned NOT NULL,
81 `ScriptName` char(64) NOT NULL DEFAULT '',
82 `VerifiedBuild` smallint(5) DEFAULT '0',
83 PRIMARY KEY (`entry`),
84 KEY `idx_name` (`name`),
85 KEY `difficulty_entry_1` (`difficulty_entry_1`) USING BTREE,
86 KEY `difficulty_entry_2` (`difficulty_entry_2`) USING BTREE,
87 KEY `difficulty_entry_3` (`difficulty_entry_3`) USING BTREE,
88 KEY `family` (`family`) USING BTREE,
89 KEY `gossip_menu_id` (`gossip_menu_id`) USING BTREE,
90 KEY `KillCredit1` (`KillCredit1`) USING BTREE,
91 KEY `KillCredit2` (`KillCredit2`) USING BTREE,
92 KEY `lootid` (`lootid`) USING BTREE,
93 KEY `modelid1` (`modelid1`) USING BTREE,
94 KEY `modelid1_2` (`modelid1`,`modelid2`,`modelid3`,`modelid4`) USING BTREE,
95 KEY `modelid2` (`modelid2`) USING BTREE,
96 KEY `modelid3` (`modelid3`) USING BTREE,
97 KEY `modelid4` (`modelid4`) USING BTREE,
98 KEY `spell1` (`spell1`) USING BTREE,
99 KEY `spell2` (`spell2`) USING BTREE,
100 KEY `spell3` (`spell3`) USING BTREE,
101 KEY `spell4` (`spell4`) USING BTREE,
102 KEY `spell5` (`spell5`) USING BTREE,
103 KEY `spell6` (`spell6`) USING BTREE,
104 KEY `spell7` (`spell7`) USING BTREE,
105 KEY `spell8` (`spell8`) USING BTREE,
106 KEY `subname` (`subname`) USING BTREE,
107 KEY `type` (`type`) USING BTREE,
108 KEY `VehicleId` (`VehicleId`) USING BTREE,
109 KEY `VignetteID` (`VignetteID`) USING BTREE
110) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';