Lines Matching refs:KEY
20 a TEXT PRIMARY KEY,
22 FOREIGN KEY(b COLLATE nocase DESC) REFERENCES t1(a COLLATE binary ASC)
34 a TEXT PRIMARY KEY,
36 FOREIGN KEY(b) REFERENCES t1(a)
41 a TEXT PRIMARY KEY,
43 FOREIGN KEY(b COLLATE nocase) REFERENCES t1(a)
56 a TEXT PRIMARY KEY,
58 FOREIGN KEY(b ASC) REFERENCES t1(a)
88 CREATE TABLE t300(id INTEGER PRIMARY KEY);
90 id INTEGER PRIMARY KEY,
94 FOREIGN KEY(c1) REFERENCES t300(id) ON DELETE CASCADE ON UPDATE RESTRICT
96 FOREIGN KEY(c2) REFERENCES t300(id) ON DELETE CASCADE ON UPDATE RESTRICT