Lines Matching refs:KEY

31     CREATE TABLE t1(x INTEGER PRIMARY KEY);
46 } {1 {FOREIGN KEY constraint failed}}
52 } {1 {FOREIGN KEY constraint failed}}
69     CREATE TABLE t1(x INTEGER PRIMARY KEY);
72     CREATE TABLE t2(y INTEGER PRIMARY KEY REFERENCES t1 (x) ON UPDATE SET NULL);
92     FOREIGN KEY(c, d) REFERENCES t3(a, b)
98 } {1 {FOREIGN KEY constraint failed}}
101 } {1 {FOREIGN KEY constraint failed}}
108 } {1 {FOREIGN KEY constraint failed}}
111   CREATE TABLE t5(a INTEGER PRIMARY KEY, b REFERENCES t5(a));
116 } {1 {FOREIGN KEY constraint failed}}
119   CREATE TABLE t6(a INTEGER PRIMARY KEY, b, c, d,
120     FOREIGN KEY(c, d) REFERENCES t6(a, b)
130 } {1 {FOREIGN KEY constraint failed}}
143   CREATE TABLE t7(a, b, c, d INTEGER PRIMARY KEY,
144     FOREIGN KEY(c, d) REFERENCES t7(a, b)
152 } {1 {FOREIGN KEY constraint failed}}
155 } {1 {FOREIGN KEY constraint failed}}
159   CREATE TABLE t8(a, b, c, d, e, FOREIGN KEY(c, d) REFERENCES t8(a, b));
166 } {1 {FOREIGN KEY constraint failed}}
172     id INTEGER PRIMARY KEY,
184 } {1 {FOREIGN KEY constraint failed}}