drop table if exists parentt1, childt2, childt3; create table parentt1( a int not null, b int not null, c int not null, unique key uk13(c) )engine=ndb; create table childt2( a int, b int, c int, d int, e int, foreign key fk21(a) references parentt1(c), foreign key fk22(b) references parentt1(c), foreign key fk23(c) references parentt1(c), foreign key fk24(d) references parentt1(c), foreign key fk25(e) references parentt1(c) )engine=ndb; create table childt3( a int, b int, c int, d int, e int, foreign key fk31(a) references parentt1(c), foreign key fk32(b) references parentt1(c), foreign key fk33(c) references parentt1(c), foreign key fk34(d) references parentt1(c), foreign key fk35(e) references parentt1(c) )engine=ndb; update childt2 set a=10000, b=10000, c=10000, d=10000, e=10000; update childt3 set a=10000, b=10000, c=10000, d=10000, e=10000; drop table childt2, childt3; drop table parentt1;