Anonymous

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;