1 drop table if exists t1;
3 a int not null references t2,
4 b int not null references t2 (c),
6 foreign key (a) references t3 match full,
7 foreign key (a) references t3 match partial,
8 foreign key (a,b) references t3 (c,d) on delete no action
10 foreign key (a,b) references t3 (c,d) on update cascade,
11 foreign key (a,b) references t3 (c,d) on delete set default,
12 foreign key (a,b) references t3 (c,d) on update set null);
13 create index a on t1 (a);
14 create unique index b on t1 (a,b);