Lines Matching refs:log

37     CREATE TABLE log(a,b,c,d,e);
39       INSERT INTO log VALUES('r1', new.rowid, new.oid, new._rowid_, new.x);
42       INSERT INTO log VALUES('r2', new.rowid, new.oid, new._rowid_, new.x);
45       INSERT INTO log VALUES('r3.old', old.rowid, old.oid, old._rowid_, old.x);
46       INSERT INTO log VALUES('r3.new', new.rowid, new.oid, new._rowid_, new.x);
49       INSERT INTO log VALUES('r4.old', old.rowid, old.oid, old._rowid_, old.x);
50       INSERT INTO log VALUES('r4.new', new.rowid, new.oid, new._rowid_, new.x);
53       INSERT INTO log VALUES('r5', old.rowid, old.oid, old._rowid_, old.x);
56       INSERT INTO log VALUES('r6', old.rowid, old.oid, old._rowid_, old.x);
63     SELECT * FROM log
68     DELETE FROM log;
70     SELECT * FROM log
75     DELETE FROM log;
77     SELECT * FROM log
89       INSERT INTO log VALUES('r1', new.rowid, new.oid, new._rowid_, new.x);
92       INSERT INTO log VALUES('r2', new.rowid, new.oid, new._rowid_, new.x);
95       INSERT INTO log VALUES('r3.old', old.rowid, old.oid, old._rowid_, old.x);
96       INSERT INTO log VALUES('r3.new', new.rowid, new.oid, new._rowid_, new.x);
99       INSERT INTO log VALUES('r4.old', old.rowid, old.oid, old._rowid_, old.x);
100       INSERT INTO log VALUES('r4.new', new.rowid, new.oid, new._rowid_, new.x);
103       INSERT INTO log VALUES('r5', old.rowid, old.oid, old._rowid_, old.x);
106       INSERT INTO log VALUES('r6', old.rowid, old.oid, old._rowid_, old.x);
112     DELETE FROM log;
114     SELECT * FROM log;
119     DELETE FROM log;
121     SELECT * FROM log
126     DELETE FROM log;
128     SELECT * FROM log
202     CREATE TABLE db2.log(z);
204       INSERT INTO log(z) VALUES(new.y);
207     SELECT * FROM log;
214     SELECT * FROM log;