MySQL strange FK error
===

Here are 2 tables. 

[Full size image][1]

![enter image description here][2]

I'm trying to create relationship between them by creating foreign keys `courses:parent<->child.parent_cid` <=> `courses.id` and  `courses:parent<->child.child_cid` <=> `courses.id` 



SQL looks like that

    ALTER TABLE `courses: parent<->child` ADD CONSTRAINT `cpc.parent_cid_courses.id` FOREIGN KEY (`parent_cid`) REFERENCES `courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
    
    ALTER TABLE `courses: parent<->child` ADD CONSTRAINT `cpc.child_cid_courses.id` FOREIGN KEY (`child_cid`) REFERENCES `courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

Getting this error message

![enter image description here][3]

What am I doing wrong? Any suggestions?

  [1]: http://content.screencast.com/users/TT13/folders/Jing/media/440e92fb-b2d1-44cf-9738-02a6f9bd8dd8/2012-07-25_1914.png
  [2]: http://i.stack.imgur.com/3uo1R.png
  [3]: http://i.stack.imgur.com/JNUY8.png