DROP TABLE IF EXISTS `gameserv`.`monster`;
CREATE TABLE  `gameserv`.`monster` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `weaponname` varchar(45) NOT NULL,
  `strength` int(11) NOT NULL DEFAULT '0',
  `defense` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `experience` int(11) NOT NULL DEFAULT '0',
  `health` int(10) unsigned NOT NULL,
  `levelId` int(10) unsigned NOT NULL,
  `deathcry` varchar(256) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_monster_levelId_1` (`levelId`),
  CONSTRAINT `FK_monster_levelId_1` FOREIGN KEY (`levelId`) REFERENCES `level` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;