CREATE TABLE `styles_to_yeasts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `yeasts_id` int(11) unsigned NOT NULL,
  `styles_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_yeasts_to_styles` (`yeasts_id`,`styles_id`) USING BTREE,
  KEY `index_styles_id` (`styles_id`) USING BTREE,
  KEY `index_yeasts_id` (`yeasts_id`) USING BTREE,
  CONSTRAINT `link_styles_to_yeasts` FOREIGN KEY (`yeasts_id`) REFERENCES `yeasts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `link_yeasts_to_styles` FOREIGN KEY (`styles_id`) REFERENCES `styles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6309 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci