1 echo CREATE TABLE t1
(f1 int
,f2 char
(1000));
3 echo CREATE TABLE t2
(f1 int
,f2 char
(1000));
5 echo CREATE INDEX idx1 ON t2
(f1
) HASH UNIQUE
;
7 echo CREATE TABLE t3
(f1 int
,f2 char
(1000));
9 echo CREATE INDEX idx2 ON t3
(f1
) TREE UNIQUE
;
11 echo CREATE TABLE t4
(f1 int
,f2 char
(1000),PRIMARY KEY
(f1
));
13 echo CREATE TABLE t5
(f1 int
,f2 int
,foreign key
(f1
) references t4
(f1
));
15 echo CREATE TABLE t6
(f1 int
,f2 char
(1000),PRIMARY KEY
(f2
));
17 echo CREATE TABLE t7
(f1 int
,f2 char
,foreign key
(f2
) references t6
(f2
));
19 echo CREATE TABLE t8
(f1 int
,f2 int
,f3 char
(1000),PRIMARY KEY
(f3
));
22 Statement Executed
: Rows Affected
= 2000