Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for creature_template
-- ----------------------------
DROP TABLE IF EXISTS `creature_template`;
CREATE TABLE `creature_template` (
`entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
`difficulty_entry_1` mediumint(8) unsigned NOT NULL DEFAULT '0',
`difficulty_entry_2` mediumint(8) unsigned NOT NULL DEFAULT '0',
`difficulty_entry_3` mediumint(8) unsigned NOT NULL DEFAULT '0',
`KillCredit1` int(10) unsigned NOT NULL DEFAULT '0',
`KillCredit2` int(10) unsigned NOT NULL DEFAULT '0',
`modelid1` mediumint(8) unsigned NOT NULL DEFAULT '0',
`modelid2` mediumint(8) unsigned NOT NULL DEFAULT '0',
`modelid3` mediumint(8) unsigned NOT NULL DEFAULT '0',
`modelid4` mediumint(8) unsigned NOT NULL DEFAULT '0',
`name` char(100) NOT NULL DEFAULT '0',
`subname` char(100) DEFAULT NULL,
`IconName` char(100) DEFAULT NULL,
`gossip_menu_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`minlevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
`maxlevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
`exp` smallint(6) NOT NULL DEFAULT '0',
`exp_unk` smallint(2) NOT NULL DEFAULT '0',
`faction` smallint(5) unsigned NOT NULL DEFAULT '0',
`npcflag` int(10) unsigned NOT NULL DEFAULT '0',
`speed_walk` float NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value',
`speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value',
`scale` float NOT NULL DEFAULT '1',
`rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mindmg` float NOT NULL DEFAULT '0',
`maxdmg` float NOT NULL DEFAULT '0',
`dmgschool` tinyint(4) NOT NULL DEFAULT '0',
`attackpower` int(10) unsigned NOT NULL DEFAULT '0',
`dmg_multiplier` float NOT NULL DEFAULT '1',
`baseattacktime` int(10) unsigned NOT NULL DEFAULT '0',
`rangeattacktime` int(10) unsigned NOT NULL DEFAULT '0',
`unit_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
`unit_flags` int(10) unsigned NOT NULL DEFAULT '0',
`unit_flags2` int(10) unsigned NOT NULL DEFAULT '0',
`dynamicflags` int(10) unsigned NOT NULL DEFAULT '0',
`family` tinyint(4) NOT NULL DEFAULT '0',
`trainer_type` tinyint(4) NOT NULL DEFAULT '0',
`trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
`trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`minrangedmg` float NOT NULL DEFAULT '0',
`maxrangedmg` float NOT NULL DEFAULT '0',
`rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type_flags` int(10) unsigned NOT NULL DEFAULT '0',
`type_flags2` int(10) unsigned NOT NULL DEFAULT '0',
`lootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`pickpocketloot` mediumint(8) unsigned NOT NULL DEFAULT '0',
`skinloot` mediumint(8) unsigned NOT NULL DEFAULT '0',
`resistance1` smallint(6) NOT NULL DEFAULT '0',
`resistance2` smallint(6) NOT NULL DEFAULT '0',
`resistance3` smallint(6) NOT NULL DEFAULT '0',
`resistance4` smallint(6) NOT NULL DEFAULT '0',
`resistance5` smallint(6) NOT NULL DEFAULT '0',
`resistance6` smallint(6) NOT NULL DEFAULT '0',
`spell1` mediumint(8) unsigned NOT NULL DEFAULT '0',
`spell2` mediumint(8) unsigned NOT NULL DEFAULT '0',
`spell3` mediumint(8) unsigned NOT NULL DEFAULT '0',
`spell4` mediumint(8) unsigned NOT NULL DEFAULT '0',
`spell5` mediumint(8) unsigned NOT NULL DEFAULT '0',
`spell6` mediumint(8) unsigned NOT NULL DEFAULT '0',
`spell7` mediumint(8) unsigned NOT NULL DEFAULT '0',
`spell8` mediumint(8) unsigned NOT NULL DEFAULT '0',
`PetSpellDataId` mediumint(8) unsigned NOT NULL DEFAULT '0',
`VehicleId` mediumint(8) unsigned NOT NULL DEFAULT '0',
`mingold` mediumint(8) unsigned NOT NULL DEFAULT '0',
`maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
`AIName` char(64) NOT NULL DEFAULT '',
`MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
`HoverHeight` float NOT NULL DEFAULT '1',
`Health_mod` float NOT NULL DEFAULT '1',
`Mana_mod` float NOT NULL DEFAULT '1',
`Mana_mod_extra` float NOT NULL DEFAULT '1',
`Armor_mod` float NOT NULL DEFAULT '1',
`RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0',
`questItem1` int(10) unsigned NOT NULL DEFAULT '0',
`questItem2` int(10) unsigned NOT NULL DEFAULT '0',
`questItem3` int(10) unsigned NOT NULL DEFAULT '0',
`questItem4` int(10) unsigned NOT NULL DEFAULT '0',
`questItem5` int(10) unsigned NOT NULL DEFAULT '0',
`questItem6` int(10) unsigned NOT NULL DEFAULT '0',
`movementId` int(11) unsigned NOT NULL DEFAULT '0',
`RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1',
`mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0',
`flags_extra` int(10) unsigned NOT NULL DEFAULT '0',
`ScriptName` char(64) NOT NULL DEFAULT '',
`VerifiedBuild` smallint(5) DEFAULT '0',
PRIMARY KEY (`entry`),
KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
