попробуйте это
SET foreign_key_checks = 0; ALTER TABLE sourcecodes_tags ADD FOREIGN KEY (sourcecode_id) REFERENCES sourcecodes (id) ON DELETE CASCADE ON UPDATE CASCADE SET foreign_key_checks = 1;