Lines Matching refs:log

204   CREATE TABLE log(op, r, a, b);
208     INSERT INTO log VALUES('insert', new.rowid, new.a, new.b);
211     INSERT INTO log VALUES('update', new.rowid, new.a, new.b);
224   SELECT * FROM log;
235   CREATE TEMP TABLE log(op,x,y);
237      INSERT INTO log(op,x,y) VALUES('I1',new.a,new.b);
240      INSERT INTO log(op,x,y) VALUES('D1',old.a,old.b);
243      INSERT INTO log(op,x,y) VALUES('U1',new.a,new.b);
246      INSERT INTO log(op,x,y) VALUES('I2',new.c,new.d);
249      INSERT INTO log(op,x,y) VALUES('D3',old.e,old.f);
252      INSERT INTO log(op,x,y) VALUES('U3',new.e,new.f);
263   SELECT * FROM log;
264   DELETE FROM log;
270   SELECT * FROM log;
271   DELETE FROM log;
279   SELECT * FROM log;
280   DELETE FROM log;