alter table svodnaya
add foreign key(dishes_id)
references dishes(id)
on delete cascade;

alter table svodnaya 
add foreign key(species_id)
references species(id)
on delete cascade;

CREATE TABLE `svodnaya` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dishes_id` int(11) NOT NULL,
  `species_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_svodnaya_dishes` (`dishes_id`),
  KEY `fk_svodnaya_species1` (`species_id`),
  CONSTRAINT `svodnaya_ibfk_2` FOREIGN KEY (`species_id`) REFERENCES `species` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_svodnaya_dishes` FOREIGN KEY (`dishes_id`) REFERENCES `dishes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_svodnaya_species1` FOREIGN KEY (`species_id`) REFERENCES `species` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `svodnaya_ibfk_1` FOREIGN KEY (`dishes_id`) REFERENCES `dishes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8$$