Lines Matching refs:c1
30 CREATE TABLE c1(b REFERENCES p1);
35 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE);
39 CREATE TABLE c1(b REFERENCES p1 ON DELETE SET NULL);
43 CREATE TABLE c1(b REFERENCES p1 ON DELETE SET DEFAULT);
48 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE);
49 CREATE TRIGGER ct1 AFTER DELETE ON c1 BEGIN
56 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
57 CREATE TABLE cc1(d REFERENCES c1);
62 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
63 CREATE TABLE cc1(d REFERENCES c1 ON DELETE CASCADE);
67 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
68 CREATE TABLE cc1(d REFERENCES c1 ON DELETE SET NULL);
72 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
73 CREATE TABLE cc1(d REFERENCES c1 ON DELETE SET DEFAULT);
78 CREATE TABLE c1(b REFERENCES p1 ON UPDATE SET NULL, c);
82 CREATE TABLE c1(b REFERENCES p1 ON UPDATE SET NULL, c);
86 CREATE TABLE c1(b REFERENCES p1 ON UPDATE CASCADE, c);
90 CREATE TABLE c1(b NOT NULL REFERENCES p1 ON UPDATE SET NULL, c);
114 CREATE TABLE c1(x REFERENCES p1 DEFERRABLE INITIALLY DEFERRED);
118 INSERT INTO c1 VALUES(1);
119 INSERT INTO c1 VALUES(2);
186 c1 PRIMARY KEY,
188 FOREIGN KEY(c1) REFERENCES t1(c2)
190 CREATE INDEX t1c1 ON t1(c1);
236 CREATE TABLE c1(b);
237 INSERT INTO c1 VALUES(123);
243 CREATE TABLE aux.c1(b REFERENCES p1(a) ON DELETE RESTRICT);