f0VrwA7Q

1-- --------------------------------------------------------
2-- Värd:                         127.0.0.1
3-- Server version:               5.7.18-log - MySQL Community Server (GPL)
4-- Server OS:                    Win64
5-- HeidiSQL Version:             9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for tabell mangos.creature_template
15CREATE TABLE IF NOT EXISTS `creature_template` (
16  `Entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
17  `Name` char(100) NOT NULL DEFAULT '',
18  `SubName` char(100) DEFAULT NULL,
19  `IconName` char(100) DEFAULT NULL,
20  `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
21  `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
22  `HeroicEntry` mediumint(8) unsigned NOT NULL DEFAULT '0',
23  `ModelId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
24  `ModelId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
25  `ModelId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
26  `ModelId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
27  `FactionAlliance` smallint(5) unsigned NOT NULL DEFAULT '0',
28  `FactionHorde` smallint(5) unsigned NOT NULL DEFAULT '0',
29  `Scale` float NOT NULL DEFAULT '1',
30  `Family` tinyint(4) NOT NULL DEFAULT '0',
31  `CreatureType` tinyint(3) unsigned NOT NULL DEFAULT '0',
32  `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
33  `RegenerateStats` tinyint(3) unsigned NOT NULL DEFAULT '3',
34  `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0',
35  `NpcFlags` int(10) unsigned NOT NULL DEFAULT '0',
36  `UnitFlags` int(10) unsigned NOT NULL DEFAULT '0',
37  `DynamicFlags` int(10) unsigned NOT NULL DEFAULT '0',
38  `ExtraFlags` int(10) unsigned NOT NULL DEFAULT '0',
39  `CreatureTypeFlags` int(10) unsigned NOT NULL DEFAULT '0',
40  `SpeedWalk` float NOT NULL DEFAULT '0',
41  `SpeedRun` float NOT NULL DEFAULT '0',
42  `Detection` int(10) unsigned NOT NULL DEFAULT '20' COMMENT 'Detection range for proximity',
43  `CallForHelp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Range in which creature calls for help?',
44  `Pursuit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'When exceeded during pursuit creature evades?',
45  `Leash` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Leash range from combat start position',
46  `Timeout` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Time for refreshing leashing before evade?',
47  `UnitClass` tinyint(3) unsigned NOT NULL DEFAULT '0',
48  `Rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
49  `Expansion` tinyint(3) NOT NULL DEFAULT '-1',
50  `HealthMultiplier` float NOT NULL DEFAULT '1',
51  `PowerMultiplier` float NOT NULL DEFAULT '1',
52  `DamageMultiplier` float NOT NULL DEFAULT '1',
53  `DamageVariance` float NOT NULL DEFAULT '1',
54  `ArmorMultiplier` float NOT NULL DEFAULT '1',
55  `ExperienceMultiplier` float NOT NULL DEFAULT '1',
56  `MinLevelHealth` int(10) unsigned NOT NULL DEFAULT '0',
57  `MaxLevelHealth` int(10) unsigned NOT NULL DEFAULT '0',
58  `MinLevelMana` int(10) unsigned NOT NULL DEFAULT '0',
59  `MaxLevelMana` int(10) unsigned NOT NULL DEFAULT '0',
60  `MinMeleeDmg` float NOT NULL DEFAULT '0',
61  `MaxMeleeDmg` float NOT NULL DEFAULT '0',
62  `MinRangedDmg` float NOT NULL DEFAULT '0',
63  `MaxRangedDmg` float NOT NULL DEFAULT '0',
64  `Armor` mediumint(8) unsigned NOT NULL DEFAULT '0',
65  `MeleeAttackPower` int(10) unsigned NOT NULL DEFAULT '0',
66  `RangedAttackPower` smallint(5) unsigned NOT NULL DEFAULT '0',
67  `MeleeBaseAttackTime` int(10) unsigned NOT NULL DEFAULT '2000',
68  `RangedBaseAttackTime` int(10) unsigned NOT NULL DEFAULT '2000',
69  `DamageSchool` tinyint(4) NOT NULL DEFAULT '0',
70  `MinLootGold` mediumint(8) unsigned NOT NULL DEFAULT '0',
71  `MaxLootGold` mediumint(8) unsigned NOT NULL DEFAULT '0',
72  `LootId` mediumint(8) unsigned NOT NULL DEFAULT '0',
73  `PickpocketLootId` mediumint(8) unsigned NOT NULL DEFAULT '0',
74  `SkinningLootId` mediumint(8) unsigned NOT NULL DEFAULT '0',
75  `KillCredit1` int(11) unsigned NOT NULL DEFAULT '0',
76  `KillCredit2` int(11) unsigned NOT NULL DEFAULT '0',
77  `MechanicImmuneMask` int(10) unsigned NOT NULL DEFAULT '0',
78  `SchoolImmuneMask` int(10) unsigned NOT NULL DEFAULT '0',
79  `ResistanceHoly` smallint(5) NOT NULL DEFAULT '0',
80  `ResistanceFire` smallint(5) NOT NULL DEFAULT '0',
81  `ResistanceNature` smallint(5) NOT NULL DEFAULT '0',
82  `ResistanceFrost` smallint(5) NOT NULL DEFAULT '0',
83  `ResistanceShadow` smallint(5) NOT NULL DEFAULT '0',
84  `ResistanceArcane` smallint(5) NOT NULL DEFAULT '0',
85  `PetSpellDataId` mediumint(8) unsigned NOT NULL DEFAULT '0',
86  `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
87  `TrainerType` tinyint(4) NOT NULL DEFAULT '0',
88  `TrainerSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
89  `TrainerClass` tinyint(3) unsigned NOT NULL DEFAULT '0',
90  `TrainerRace` tinyint(3) unsigned NOT NULL DEFAULT '0',
91  `TrainerTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0',
92  `VendorTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0',
93  `EquipmentTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0',
94  `GossipMenuId` mediumint(8) unsigned NOT NULL DEFAULT '0',
95  `AIName` char(64) NOT NULL DEFAULT '',
96  `ScriptName` char(64) NOT NULL DEFAULT '',
97  PRIMARY KEY (`Entry`)
98) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
99
100-- Data exporting was unselected.
101/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
102/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
103/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;