#----------------------------
# 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),