CREATE TABLE IF NOT EXISTS `server2146_npc_spawns` ( `spawnId` int(11) NOT NULL AUTO_INCREMENT, `npcId` int(11) NOT NULL, `npcX` int(11) NOT NULL, `npcY` int(11) NOT NULL, `npcHeight` int(11) NOT NULL, `walkingType` int(11) NOT NULL, `npcHP` int(11) NOT NULL, `maxHit` int(11) NOT NULL, `attack` int(11) NOT NULL, `defence` int(11) NOT NULL, `npcAggressive` tinyint(1) NOT NULL, `spawnDesc` varchar(255) NOT NULL, PRIMARY KEY (`spawnId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;