rendered paste body#----------------------------
# Table structure for creature_template
#----------------------------
CREATE TABLE `creature_template` (
`entry` int(11) unsigned NOT NULL default '0',
`modelid_m` int(11) unsigned NOT NULL default '0',
`modelid_f` int(11) 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` 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',
`attackpower` int(10) unsigned NOT NULL default '0',
`baseattacktime` int(4) unsigned default '0',
`rangeattacktime` int(4) unsigned default '0',
`flags` int(11) unsigned NOT NULL default '0',
`dynamicflags` int(11) unsigned NOT NULL default '0',
`size` float default '0',
`family` int(11) default '0',
`bounding_radius` float default '0',
`trainer_type` int(11) default '0',
`trainer_spell` int(11) unsigned default '0',
`class` int(11) unsigned default '0',
`race` int(11) unsigned default '0',
`minrangedmg` float NOT NULL default '0',
`maxrangedmg` float NOT NULL default '0',
`rangedattackpower` smallint(5) unsigned NOT NULL default '0',
`combat_reach` float NOT NULL default '0',
`type` tinyint(3) unsigned NOT NULL default '0',
`civilian` int(4) unsigned NOT NULL default '0',
`flag1` int(11) unsigned default '0',
`equipmodel1` int(10) unsigned NOT NULL default '0',
`equipmodel2` int(10) unsigned NOT NULL default '0',
`equipmodel3` int(10) unsigned NOT NULL default '0',
`equipinfo1` int(10) unsigned NOT NULL default '0',
`equipinfo2` int(10) unsigned NOT NULL default '0',
`equipinfo3` int(10) unsigned NOT NULL default '0',
`equipslot1` int(11) NOT NULL default '0',
`equipslot2` int(11) NOT NULL default '0',
`equipslot3` int(11) NOT NULL 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(11) unsigned NOT NULL default '0',
`spell2` int(11) unsigned NOT NULL default '0',
`spell3` int(11) unsigned NOT NULL default '0',
`spell4` int(11) unsigned NOT NULL default '0',
`mingold` int(30) unsigned NOT NULL default '0',
`maxgold` int(30) unsigned NOT NULL default '0',
`AIName` varchar(128) NOT NULL default '',
`MovementType` int(11) unsigned NOT NULL default '0',
`InhabitType` tinyint(1) unsigned NOT NULL default '3',
`RacialLeader` tinyint(1) unsigned 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';
#----------------------------
# Records for table creature_template
#----------------------------
insert into creature_template values
(1, 10045, 0, 'Waypoint (Only GM can see it)', 'Visual', 1, 1, 64, 64, 0, 0, 0, 35, 0, '0.91', 0, '1', '3', 100, 2000, 2200, 4096, 0, '0.5', 8, '2', 0, 0, 0, 0, '1.76', '2.42', 100, '2.56', 8, 1, 5242886, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, ''),
(3, 987, 987, 'Flesh Eater', null, 24, 25, 670, 710, 0, 0, 0, 21, 0, '1.08', 0, '39', '55', 100, 2000, 0, 0, 0, '1', 0, '0.533', 0, 0, 0, 0, '42.1344', '57.9348', 100, '1.5', 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32, 47, '', 1, 3, 0, ''),
(6, 10913, 10913, 'Kobold Vermin', null, 1, 2, 42, 64, 0, 0, 20, 25, 0, '0.63', 0, '1', '3', 100, 2000, 0, 0, 0, '0.7', 0, '0.462', 0, 0, 0, 0, '1.76', '2.42', 100, '0.875', 7, 1, 0, 5010, 0, 0, 50268674, 0, 0, 529, 0, 0, 6, 6, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, '', 1, 3, 0, ''),
(25, 4465, 0, 'Mithril Mechanical Dragonling', null, 45, 45, 3375, 3375, 0, 0, 0, 2, 0, '0.91', 0, '72', '99', 100, 2000, 2000, 0, 0, '1', 0, '2', 0, 0, 0, 0, '72', '99', 100, '1.25', 9, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, ''),
(30, 382, 382, 'Forest Spider', null, 5, 6, 190, 210, 142, 142, 20, 22, 0, '0.39', 0, '5', '7', 100, 2000, 0, 0, 0, '0.416949', 3, '0.275186', 0, 0, 0, 0, '8.58', '11.7975', 100, '0.521186', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 0, 0, 0, 0, 0, 0, 0, 745, 744, 6751, 0, 0, 0, '', 1, 1, 0, 'generic_creature'),