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=6294 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci