Lines Matching refs:KEY
29 CREATE TABLE p1(a PRIMARY KEY);
34 CREATE TABLE p1(a PRIMARY KEY);
38 CREATE TABLE p1(a PRIMARY KEY);
42 CREATE TABLE p1(a PRIMARY KEY);
47 CREATE TABLE p1(a PRIMARY KEY);
55 CREATE TABLE p1(a PRIMARY KEY);
56 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
61 CREATE TABLE p1(a PRIMARY KEY);
62 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
66 CREATE TABLE p1(a PRIMARY KEY);
67 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
71 CREATE TABLE p1(a PRIMARY KEY);
72 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
77 CREATE TABLE p1(a PRIMARY KEY);
81 CREATE TABLE p1(a PRIMARY KEY);
85 CREATE TABLE p1(a PRIMARY KEY);
89 CREATE TABLE p1(a PRIMARY KEY);
113 CREATE TABLE p1(a PRIMARY KEY, b) WITHOUT ROWID;
127 } {1 {FOREIGN KEY constraint failed}}
132 CREATE TABLE p2(a PRIMARY KEY, b);
134 x PRIMARY KEY,
150 CREATE TABLE p3(a PRIMARY KEY, b) WITHOUT ROWID;
165 } {1 {FOREIGN KEY constraint failed}}
171 a PRIMARY KEY, b, c, d, e,
172 FOREIGN KEY(b, c) REFERENCES t2(d, e)
182 } {1 {FOREIGN KEY constraint failed}}
186 c1 PRIMARY KEY,
188 FOREIGN KEY(c1) REFERENCES t1(c2)
195 } {1 {FOREIGN KEY constraint failed}}
205 p TEXT PRIMARY KEY
209 FOREIGN KEY(c) REFERENCES parent(p) DEFERRABLE INITIALLY DEFERRED
242 CREATE TABLE aux.p1(a INTEGER PRIMARY KEY);