Lines Matching refs:p2

179   CREATE TABLE p2(a PRIMARY KEY, b);
180   CREATE TABLE c2(x, y REFERENCES p2 ON DELETE RESTRICT ON UPDATE RESTRICT);
181   INSERT INTO p2 VALUES(1, 'one');
182   INSERT INTO p2 VALUES(2, 'two');
188     UPDATE p2 SET a=a-1;
195     UPDATE p2 SET a=a-1;
202     UPDATE p2 SET a=a-1;
210   CREATE TRIGGER p2t AFTER DELETE ON p2 BEGIN
211     INSERT INTO p2 VALUES(old.a, 'deleted!');
216     DELETE FROM p2 WHERE a=1;
223     DELETE FROM p2 WHERE a=1;
225   SELECT * FROM p2;