mysql外键关联主键时出错，求大神帮我看看啊

DROP TABLE IF EXISTS student;
--学生表

CREATE TABLE student (
id int(11) NOT NULL AUTO_INCREMENT,
name char(6) NOT NULL DEFAULT '',
pwd char(6) NOT NULL DEFAULT '',
age char(11) NOT NULL DEFAULT '',
PRIMARY KEY (id,name),
KEY(name)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
select * from student;
INSERT INTO student VALUES (1,'zfq','123','24');
INSERT INTO student VALUES (3,'zz','123','24');

-- 课程表
drop TABLE course
CREATE TABLE course (
id int(11) NOT NULL AUTO_INCREMENT,
name char(6) NOT NULL DEFAULT '',
info char(6) NOT NULL DEFAULT '',
period char(11) NOT NULL DEFAULT '',
PRIMARY KEY (id,name),
KEY (name)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;

INSERT INTO course VALUES ('1','java','50','5');
INSERT INTO course VALUES ('3','ssh','50','5');
INSERT INTO course VALUES ('4','xml','50','5');
INSERT INTO course VALUES ('5','c++','50','5');
INSERT INTO course VALUES ('6','zz','50','5');
select * from course

drop TABLE stucourse
--学生选课表
CREATE TABLE stucourse (
id int(11) NOT NULL AUTO_INCREMENT,
stuId char(6) NOT NULL DEFAULT '',
courseId char(6) NOT NULL DEFAULT '',
PRIMARY KEY (Id),
KEY stuId (stuId),
KEY courseId (courseId)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;

select * from  `stucourse`;

ALTER TABLE stucourse
ADD CONSTRAINT stuId FOREIGN KEY (stuId) REFERENCES student(name),
ADD CONSTRAINT courseId FOREIGN KEY (courseId)REFERENCES course (name);

错误信息在哪里？给个错误提示信息