Lines Matching refs:x1

62     CREATE TABLE x1(a, b, c, UNIQUE(a, b));
63     CREATE TABLE y1(a, b, c, FOREIGN KEY(b, a) REFERENCES x1(a, b));
66     CREATE INDEX 'y1_b_a' ON 'y1'('b', 'a'); --> x1(a,b)
70     CREATE TABLE x1(a COLLATE nocase, b, UNIQUE(a));
71     CREATE TABLE y1(a COLLATE rtrim REFERENCES x1(a));
73     CREATE INDEX 'y1_a' ON 'y1'('a' COLLATE nocase); --> x1(a)
77     CREATE TABLE x1(a PRIMARY KEY COLLATE nocase, b);
78     CREATE TABLE y1(a REFERENCES x1);
80     CREATE INDEX 'y1_a' ON 'y1'('a' COLLATE nocase); --> x1(a)
84     CREATE TABLE x1(a, b COLLATE nocase, c COLLATE rtrim, PRIMARY KEY(c, b, a));
85     CREATE TABLE y1(d, e, f, FOREIGN KEY(d, e, f) REFERENCES x1);
87     CREATE INDEX 'y1_d_e_f' ON 'y1'('d' COLLATE rtrim, 'e' COLLATE nocase, 'f'); --> x1(c,b,a)