CREATE TABLE `creature_template` (
  `entry` int(10) unsigned NOT NULL default '0',
  `modelid_A` int(11) unsigned NOT NULL default '0',
  `modelid_A2` int(10) unsigned NOT NULL default '0',
  `modelid_H` int(11) unsigned NOT NULL default '0',
  `modelid_H2` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '0',
  `subname` varchar(100) default NULL,
  `minlevel` int(3) unsigned default '1',
  `maxlevel` int(3) unsigned default '1',
  `minhealth` int(5) unsigned default '0',
  `maxhealth` int(5) unsigned default '0',
  `minmana` int(5) unsigned default '0',
  `maxmana` int(5) unsigned default '0',
  `armor` int(10) unsigned NOT NULL default '0',
  `faction_A` int(4) unsigned NOT NULL default '0',
  `faction_H` int(4) unsigned NOT NULL default '0',
  `npcflag` int(4) unsigned NOT NULL default '0',
  `speed` float default '0',
  `rank` int(1) unsigned default '0',
  `mindmg` float default '0',
  `maxdmg` float default '0',
  `dmgschool` tinyint(1) NOT NULL default '0',
  `attackpower` int(10) unsigned NOT NULL default '0',
  `baseattacktime` int(4) unsigned default '0',
  `rangeattacktime` int(4) unsigned default '0',
  `flags` int(10) unsigned NOT NULL default '0',
  `dynamicflags` int(10) unsigned NOT NULL default '0',
  `family` int(11) default '0',
  `trainer_type` int(11) default '0',
  `trainer_spell` int(10) unsigned default '0',
  `class` int(10) unsigned default '0',
  `race` int(10) unsigned 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',
  `civilian` int(4) unsigned NOT NULL default '0',
  `flag1` int(10) unsigned default '0',
  `lootid` int(10) unsigned NOT NULL default '0',
  `pickpocketloot` int(10) unsigned NOT NULL default '0',
  `skinloot` int(10) unsigned NOT NULL default '0',
  `resistance1` int(10) unsigned NOT NULL default '0',
  `resistance2` int(10) unsigned NOT NULL default '0',
  `resistance3` int(10) unsigned NOT NULL default '0',
  `resistance4` int(10) unsigned NOT NULL default '0',
  `resistance5` int(10) unsigned NOT NULL default '0',
  `resistance6` int(10) unsigned NOT NULL default '0',
  `spell1` int(10) unsigned NOT NULL default '0',
  `spell2` int(10) unsigned NOT NULL default '0',
  `spell3` int(10) unsigned NOT NULL default '0',
  `spell4` int(10) unsigned NOT NULL default '0',
  `mingold` int(10) unsigned NOT NULL default '0',
  `maxgold` int(10) unsigned NOT NULL default '0',
  `AIName` varchar(128) NOT NULL default '',
  `MovementType` int(10) unsigned NOT NULL default '0',
  `InhabitType` tinyint(1) unsigned NOT NULL default '3',
  `RacialLeader` tinyint(1) unsigned NOT NULL default '0',
  `RegenHealth` tinyint(1) unsigned NOT NULL default '1',
  `equipment_id` int(11) unsigned NOT NULL default '0',
  `mechanic_immune_mask` int(11) NOT NULL default '0',
  `ScriptName` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`entry`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';