use testdb;

create table t1 (
  id int primary key auto_increment,
  name varchar(40),
  unique key `name` (name)
) engine=InnoDB;

create table t2 (
  id int primary key auto_increment,
  t varchar(40),
  constraint `t` foreign key (`t`) references t1 (`name`) on delete cascade
) engine=InnoDB;