Here we go
Code:
-- ----------------------------
-- Table structure for creature_spawns
-- ----------------------------
DROP TABLE IF EXISTS `creature_spawns`;
CREATE TABLE `creature_spawns` (
`id` int(11) unsigned NOT NULL auto_increment,
`entry` int(30) NOT NULL,
`map` int(30) NOT NULL,
`position_x` float NOT NULL,
`position_y` float NOT NULL,
`position_z` float NOT NULL,
`orientation` float NOT NULL,
`movetype` int(30) NOT NULL default '0',
`displayid` int(30) unsigned NOT NULL default '0',
`faction` int(30) NOT NULL default '14',
`flags` int(30) NOT NULL default '0',
`bytes0` int(30) NOT NULL default '0',
`bytes1` int(30) NOT NULL default '0',
`bytes2` int(30) NOT NULL default '0',
`emote_state` int(30) NOT NULL default '0',
`npc_respawn_link` int(30) NOT NULL default '0',
`channel_spell` int(30) NOT NULL default '0',
`channel_target_sqlid` int(30) NOT NULL default '0',
`channel_target_sqlid_creature` int(30) NOT NULL default '0',
`standstate` int(10) NOT NULL default '0',
`mountdisplayid` int(10) unsigned NOT NULL default '0',
`slot1item` int(10) unsigned NOT NULL default '0',
`slot2item` int(10) unsigned NOT NULL default '0',
`slot3item` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spawn System';