36 lines
908 B
Plaintext
36 lines
908 B
Plaintext
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;
|