mySQL创建表失败 error 1005
<P>其他表的创建略去了,最后的finish表创建失败,谁可以告诉我错哪了?<BR><BR>create table patron(patron_id int,<BR> userName varchar(20) not null unique,<BR> password varchar(20) not null,<BR> sex char(2),<BR> mobile int,<BR> email varchar(40),<BR> address varchar(100),<BR> remark varchar(255),<BR>constraint C1 primary key(patron_id));</P><P>create table answer(patron_id int,<BR> problem_id int,<BR> times int,<BR> isTrue int,<BR> time int,<BR>constraint C5 primary key(patron_id,problem_id,times),<BR>constraint C6 foreign key(patron_id) references patron(patron_id),<BR>constraint C7 foreign key(problem_id) references problem(problem_id)); <BR><BR>create table finish(patron_id int,<BR> times int,<BR> allTime int,<BR> isOver int,<BR>constraint C8 primary key(patron_id,times),<BR>constraint C9 foreign key(patron_id) references patron(patron_id),<BR>constraint C10 foreign key(times) references answer(times));</P>
页:
[1]