Lines Matching refs:p1
25 CREATE TABLE p1(a PRIMARY KEY, b);
26 CREATE TABLE c1(x, y REFERENCES p1);
28 CREATE INDEX 'c1_y' ON 'c1'('y'); --> p1(a)
32 CREATE TABLE p1(a PRIMARY KEY, b);
33 CREATE TABLE c2(x REFERENCES p1, y REFERENCES p1);
35 CREATE INDEX 'c2_y' ON 'c2'('y'); --> p1(a)
36 CREATE INDEX 'c2_x' ON 'c2'('x'); --> p1(a)
47 CREATE TABLE p1(a, 'b b b' PRIMARY KEY);
48 CREATE TABLE c1('x y z' REFERENCES p1);
54 CREATE TABLE p1(a, 'b b b' PRIMARY KEY);
55 CREATE TABLE c1('x y z' REFERENCES p1);
58 CREATE INDEX 'c1_x y z' ON 'c1'('x y z'); --> p1(b b b)
91 CREATE TABLE p1(a, b UNIQUE);
92 CREATE TABLE c1(x INTEGER PRIMARY KEY REFERENCES p1(b));