Lines Matching refs:TRIGGER

59     CREATE TRIGGER trig1 BEFORE INSERT ON t1 BEGIN
62     CREATE TRIGGER trig2 AFTER INSERT ON t1 BEGIN
65     CREATE TRIGGER trig3 BEFORE UPDATE ON t1 BEGIN
68     CREATE TRIGGER trig4 AFTER UPDATE ON t1 BEGIN
72     CREATE TRIGGER trig5 BEFORE DELETE ON t1 BEGIN
75     CREATE TRIGGER trig6 AFTER DELETE ON t1 BEGIN
112     CREATE TRIGGER t4t AFTER DELETE ON t4 BEGIN
128     CREATE TRIGGER au_tbl AFTER UPDATE ON t5 BEGIN
153     CREATE TRIGGER t1r1 AFTER UPDATE ON t1 BEGIN UPDATE cnt SET n=n+1; END;
177     CREATE TRIGGER t2_trig AFTER INSERT ON t2 WHEN (new.a>0) BEGIN
183     CREATE TRIGGER t2_trig AFTER INSERT ON t2 BEGIN
190     CREATE TRIGGER t2_trig BEFORE INSERT ON t2 WHEN (new.a>0) BEGIN
196     CREATE TRIGGER t2_trig BEFORE INSERT ON t2 BEGIN
203     CREATE TRIGGER t2_trig BEFORE INSERT ON t2 BEGIN
209     CREATE TRIGGER t2_trig AFTER INSERT ON t2 WHEN (new.a>0) BEGIN
215     CREATE TRIGGER t2_trig BEFORE INSERT ON t2 WHEN (new.a>0) BEGIN
221     catchsql { DROP TRIGGER t2_trig }
235     CREATE TRIGGER t22a AFTER INSERT ON t22 BEGIN
238     CREATE TRIGGER t22b BEFORE INSERT ON t22 BEGIN
253     CREATE TRIGGER t23a AFTER INSERT ON t23 BEGIN
257     CREATE TRIGGER t23b BEFORE INSERT ON t23 BEGIN
276     CREATE TRIGGER t3i AFTER INSERT ON t3 BEGIN
279     CREATE TRIGGER t3d AFTER DELETE ON t3 BEGIN
294     CREATE TRIGGER t3bi AFTER INSERT ON t3b WHEN new.x<[expr $SQLITE_MAX_TRIGGER_DEPTH * 2] BEGIN
412     CREATE TRIGGER t4bi BEFORE INSERT ON t4 BEGIN
419     CREATE TRIGGER t4ai AFTER INSERT ON t4 BEGIN
426     CREATE TRIGGER t4bd BEFORE DELETE ON t4 BEGIN
433     CREATE TRIGGER t4ad AFTER DELETE ON t4 BEGIN
440     CREATE TRIGGER t4bu BEFORE UPDATE ON t4 BEGIN
452     CREATE TRIGGER t4au AFTER UPDATE ON t4 BEGIN
570     CREATE TRIGGER t5t BEFORE DELETE ON t5 BEGIN
596     DROP TRIGGER t5t;
597     CREATE TRIGGER t5t AFTER DELETE ON t5 BEGIN
679     CREATE TRIGGER t7t BEFORE UPDATE ON t7 BEGIN
682     CREATE TRIGGER t7ta AFTER UPDATE ON t7 BEGIN
708     DROP TRIGGER t7t;
709     CREATE TRIGGER t7t BEFORE UPDATE ON t7 WHEN (old.rowid!=1 OR new.rowid!=8)
736     DROP TRIGGER t7t;
737     DROP TRIGGER t7ta;
738     CREATE TRIGGER t7t BEFORE DELETE ON t7 BEGIN
741     CREATE TRIGGER t7ta AFTER DELETE ON t7 BEGIN
781     CREATE TRIGGER t9r1 AFTER DELETE ON t9 BEGIN
805     CREATE TRIGGER t10_bu BEFORE UPDATE OF a ON t10 BEGIN
837     CREATE TRIGGER t11_bu BEFORE UPDATE OF c1 ON t11 BEGIN
878       CREATE TRIGGER tt1 BEFORE INSERT ON t1 BEGIN 
889       CREATE TRIGGER tt2 AFTER INSERT ON t1 BEGIN 
898     execsql { DROP TRIGGER tt1 }
912     CREATE TRIGGER tv2 INSTEAD OF INSERT ON v2 BEGIN
930     CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN SELECT 1 ; END ;
936     if {$a == 3} { execsql { DROP TRIGGER tr1 } }
945   CREATE TRIGGER tr12 AFTER UPDATE ON t12 BEGIN
981   CREATE TRIGGER trig BEFORE INSERT ON t4 BEGIN
1010   CREATE TRIGGER node_delete_referencing AFTER DELETE ON "node"
1033   CREATE TRIGGER x1ai AFTER INSERT ON x1 BEGIN
1065   CREATE TRIGGER xyz_tr BEFORE INSERT ON xyz BEGIN