create table testsuite ( id int auto_increment, primary key (id) ) engine = innodb; create table testcase ( id int auto_increment, primary key (id) ) engine = innodb; create table testsuite_testcase ( testsuite_id int, testcase_id int, foreign key (testsuite_id) references testsuite(id), foreign key (testcase_id) references testcase(id), unique (testsuite_id, testcase_id) -- or primary key? ) engine = innodb;