adding test scripts
[csql.git] / test / tools / csql / foreign143.ksh
blob8f46daab76700ef487f32901c5f468de7d6a3da9
1 echo CREATE TABLE t1(f1 INT, f2 INT, PRIMARY KEY(f1));
2 CREATE TABLE t1(f1 INT, f2 INT, PRIMARY KEY(f1));
3 echo CREATE TABLE t2(f3 INT, f4 INT, PRIMARY KEY(f4), FOREIGN KEY(f3) REFERENCES t1(f1));
4 CREATE TABLE t2(f3 INT, f4 INT, PRIMARY KEY(f4), FOREIGN KEY(f3) REFERENCES t1(f1));
5 echo CREATE TABLE t3(f5 INT, f6 INT, FOREIGN KEY(f5) REFERENCES t2(f4));
6 CREATE TABLE t3(f5 INT, f6 INT, FOREIGN KEY(f5) REFERENCES t2(f4));