Lines Matching refs:KEY
34 CREATE TABLE p1(a INTEGER PRIMARY KEY); INSERT INTO p1 VALUES(88),(89);
35 CREATE TABLE p2(a INT PRIMARY KEY); INSERT INTO p2 VALUES(77),(78);
36 CREATE TABLE p3(a TEXT PRIMARY KEY);
38 CREATE TABLE p4(a TEXT PRIMARY KEY COLLATE nocase);
40 CREATE TABLE p5(a INTEGER PRIMARY KEY, b, c, UNIQUE(b,c));
42 CREATE TABLE p6(a INTEGER PRIMARY KEY, b TEXT COLLATE nocase,
46 CREATE TABLE c1(x INTEGER PRIMARY KEY references p1);
47 CREATE TABLE c2(x INTEGER PRIMARY KEY references p2);
48 CREATE TABLE c3(x INTEGER PRIMARY KEY references p3);
49 CREATE TABLE c4(x INTEGER PRIMARY KEY references p4);
60 CREATE TABLE c15(x, y, FOREIGN KEY(x,y) REFERENCES p5(b,c));
61 CREATE TABLE c16(x, y, FOREIGN KEY(x,y) REFERENCES p5(c,b));
62 CREATE TABLE c17(x, y, FOREIGN KEY(x,y) REFERENCES p6(b,c));
63 CREATE TABLE c18(x, y, FOREIGN KEY(x,y) REFERENCES p6(c,b));
65 FOREIGN KEY(x,y) REFERENCES p5(b,c));
67 FOREIGN KEY(x,y) REFERENCES p5(c,b));
69 FOREIGN KEY(x,y) REFERENCES p6(b,c));
71 FOREIGN KEY(x,y) REFERENCES p6(c,b));
378 CREATE TABLE k2(x, y, FOREIGN KEY(x, y) REFERENCES s1(a, b));
396 # PRIMARY KEY as the parent key.
400 CREATE TABLE p30 (id INTEGER PRIMARY KEY);
404 PRIMARY KEY(master)
441 CREATE TABLE aux.t1(a INTEGER PRIMARY KEY, b TEXT REFERENCES t2);
442 CREATE TABLE main.t2(x TEXT PRIMARY KEY, y INT);
448 CREATE TABLE aux.t2(x TEXT PRIMARY KEY, y INT);
472 CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT REFERENCES t2);
473 CREATE TABLE t2(x TEXT PRIMARY KEY, y INT);