--
-- Table structure for table `monsters`
--

CREATE TABLE IF NOT EXISTS `monsters` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `size` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `alignment` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `ac` int(2) NOT NULL,
  `armor_type` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `hp` int(4) NOT NULL,
  `hit_dice` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `speed` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `str` int(2) NOT NULL,
  `dex` int(2) NOT NULL,
  `con` int(2) NOT NULL,
  `intel` int(2) NOT NULL,
  `wis` int(2) NOT NULL,
  `cha` int(2) NOT NULL,
  `saves` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `skills` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `resist` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `vulnerable` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `immune` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `condition_immune` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `senses` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `passive` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `languages` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `cr` int(2) NOT NULL,
  `xp` int(9) NOT NULL,
  `source` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `spells` varchar(2000) COLLATE utf8_unicode_ci NOT NULL,
  `image_ref` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=456 ;

--
-- Dumping data for table `monsters`
--

INSERT INTO `monsters` (`id`, `name`, `size`, `type`, `alignment`, `ac`, `armor_type`, `hp`, `hit_dice`, `speed`, `str`, `dex`, `con`, `intel`, `wis`, `cha`, `saves`, `skills`, `resist`, `vulnerable`, `immune`, `condition_immune`, `senses`, `passive`, `languages`, `cr`, `xp`, `source`, `spells`, `image_ref`, `description`) VALUES
(1, 'Aboleth', 'Large', 'aberration', 'lawful evil', 17, 'natural armor', 13, ' 18d10 + 36', '10 ft., swim 40 ft.', 21, 9, 15, 18, 15, 18, '', '', '', '', '', '', 'darkvision 120 ft.', '20', 'Deep Speech, telepathy 120 ft.', 10, 5, 'MM 13', '', 'Aboleth.png', ''),
(2, 'Aarakocra', 'Medium', 'humanoid (aarakocra)', 'neutral good', 12, '', 13, ' 18d10 + 36', '20 ft., fly 50 ft.', 10, 14, 10, 11, 12, 11, '', '', '', '', '', '', '', '15', 'Auran', 1, 50, 'MM 12', '', 'Aarakocra.png', ''),
(3, 'Abominable Yeti', 'Huge', 'monstrosity', 'chaotic evil', 15, 'natural armor', 13, ' 11d12 + 66', '40 ft., climb 40 ft.', 24, 10, 22, 9, 13, 9, '', '', '', '', 'cold', '', 'darkvision 60 ft.', '15', 'Yeti', 9, 5, 'MM 306', '', 'Abominable Yeti.png', '');



--
-- Table structure for table `monster_traits`
--

CREATE TABLE IF NOT EXISTS `monster_traits` (
  `trait_id` int(6) NOT NULL AUTO_INCREMENT,
  `monster_id` int(6) NOT NULL,
  `trait_name` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `trait_description` varchar(2000) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`trait_id`),
  KEY `monster_id` (`monster_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1731 ;

--
-- Dumping data for table `monster_traits`
--

INSERT INTO `monster_traits` (`trait_id`, `monster_id`, `trait_name`, `trait_description`) VALUES
(866, 1, 'Amphibious', 'The aboleth can breathe air and water.'),
(867, 1, 'Mucous Cloud', 'While underwater, the aboleth is surrounded by transformative mucus. A creature that touches the aboleth or that hits it with a melee attack while within 5 ft. of it must make a DC 14 Constitution saving throw. On a failure, the creature is diseased for 1d4 hours. The diseased creature can breathe only underwater.'),
(868, 1, 'Probing Telepathy', 'If a creature communicates telepathically with the aboleth, the aboleth learns the creature''s greatest desires if the aboleth can see the creature.'),
(869, 2, 'Dive Attack', 'If the aarakocra is flying and dives at least 30 ft. straight toward a target and then hits it with a melee weapon attack, the attack deals an extra 3 (1d6) damage to the target.'),
(870, 3, 'Fear of Fire', 'If the yeti takes fire damage, it has disadvantage on attack rolls and ability checks until the end of its next turn.'),
(871, 3, 'Keen Smell', 'The yeti has advantage on Wisdom (Perception) checks that rely on smell.'),
(872, 3, 'Snow Camouflage', 'The yeti has advantage on Dexterity (Stealth) checks made to hide in snowy terrain.');

--
-- Constraints for table `monster_traits`
--
ALTER TABLE `monster_traits`
  ADD CONSTRAINT `monster_traits_ibfk_1` FOREIGN KEY (`monster_id`) REFERENCES `monsters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;