Lines Matching refs:TRIGGER

16 # 1. CREATE and DROP TRIGGER tests
20 # trig-1.4: DROP TRIGGER removes trigger
38      CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
45      CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
55 	CREATE TRIGGER tr1 INSERT ON t1 BEGIN
61 	CREATE TRIGGER tr1 DELETE ON t1 BEGIN
70 	CREATE TRIGGER tr2 INSERT ON t1 BEGIN
73 	CREATE TRIGGER tr2 INSERT ON t1 BEGIN
80 	DROP TRIGGER tr1;
81 	CREATE TRIGGER tr1 DELETE ON t1 BEGIN
90 	DROP TRIGGER tr2;
92 	DROP TRIGGER tr2;
98 	DROP TRIGGER biggles;
105 	DROP TRIGGER tr1;
114 	CREATE TRIGGER temp_trig UPDATE ON temp_table BEGIN
123     CREATE TRIGGER tr1 AFTER UPDATE ON sqlite_master BEGIN
197     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
204     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
218     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
250     DROP TRIGGER r1;
251     CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
282     CREATE TEMP TRIGGER r1 BEFORE INSERT ON t1 BEGIN
324     CREATE TRIGGER t2 BEFORE DELETE ON t2 BEGIN
343     DROP TRIGGER t2;
363     CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
369     DROP TRIGGER 'trigger';
375     CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
381     DROP TRIGGER "trigger";
387     CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
393     DROP TRIGGER [trigger];
404     CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
450     CREATE TEMP TRIGGER trig1 AFTER INSERT ON t1 BEGIN 
453     CREATE TEMP TRIGGER trig2 AFTER INSERT ON t2 BEGIN 
456     CREATE TEMP TRIGGER trig3 AFTER INSERT ON t3 BEGIN