rendered paste body#----------------------------
# Table structure for creature
#----------------------------
CREATE TABLE `creature` (
`guid` int(11) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
`map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`spawntimesecs` int(11) unsigned NOT NULL default '120',
`spawndist` float NOT NULL default '5',
`currentwaypoint` int(11) unsigned NOT NULL default '0',
`spawn_position_x` float NOT NULL default '0',
`spawn_position_y` float NOT NULL default '0',
`spawn_position_z` float NOT NULL default '0',
`spawn_orientation` float NOT NULL default '0',
`curhealth` int(11) unsigned NOT NULL default '1',
`curmana` int(11) unsigned NOT NULL default '0',
`DeathState` tinyint(3) unsigned NOT NULL default '0',
`MovementType` tinyint(3) unsigned NOT NULL default '0',
`auras` longtext,
PRIMARY KEY (`guid`),
KEY `idx_map` (`map`),
KEY `position_x` (`position_x`,`position_y`,`position_z`)
) ENGINE=MyISAM AUTO_INCREMENT=108866433 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System';
#----------------------------
# Records for table creature
#----------------------------
insert into creature values
(1, 3, 0, '-10427', '145.289', '36.742', '3.13', 250, '5', 0, '-10427', '145.289', '36.742', '3.13', 670, 0, 0, 1, null),
(2, 3, 0, '-10405', '244.954', '35.5', '5.495', 250, '5', 0, '-10405', '244.954', '35.5', '5.495', 670, 0, 0, 1, null),
(3, 3, 0, '-10356', '231.281', '33.086', '2.522', 250, '5', 0, '-10356', '231.281', '33.086', '2.522', 670, 0, 0, 1, null),
(4, 3, 0, '-10335', '239.154', '33.936', '4.722', 250, '5', 0, '-10335', '239.154', '33.936', '4.722', 670, 0, 0, 1, null),
(5, 3, 0, '-10300', '166.738', '38.619', '0.739', 250, '5', 0, '-10300', '166.738', '38.619', '0.739', 670, 0, 0, 1, null),