Skip to content

Instantly share code, notes, and snippets.

@jhannah

jhannah/gist:861451

Created March 9, 2011 00:34
Show Gist options
  • Save jhannah/861451 to your computer and use it in GitHub Desktop.
Save jhannah/861451 to your computer and use it in GitHub Desktop.
Download ZIP
mysql errno: 150
Raw
gistfile1.txt
alter table video_stats
ADD CONSTRAINT `video_stats_ibfk_1` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `video_stats_ibfk_2` FOREIGN KEY (`harvester_run_id`) REFERENCES `harvester_runs` (`id`) ON DELETE NO ACTION,
ADD CONSTRAINT `video_stats_ibfk_3` FOREIGN KEY (`raw_feed_id`) REFERENCES `raw_feeds` (`id`) ON DELETE NO ACTION;
ERROR 1005 (HY000): Can't create table 'channelmeter_staging.#sql-6c0a_1' (errno: 150)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment