Lines Matching refs:TRIGGER
56 CREATE TRIGGER tr1 AFTER $event ON t1 BEGIN SELECT r('temp.tr1') ; END;
60 CREATE TRIGGER tr1 BEFORE $event ON t2 BEGIN SELECT r('main.tr1') ; END;
61 CREATE TRIGGER tr2 AFTER $event ON t2 BEGIN SELECT r('main.tr2') ; END;
65 CREATE TRIGGER aux.tr1 BEFORE $event ON t3 BEGIN SELECT r('aux.tr1') ; END;
66 CREATE TRIGGER aux.tr2 AFTER $event ON t3 BEGIN SELECT r('aux.tr2') ; END;
67 CREATE TRIGGER aux.tr3 AFTER $event ON t3 BEGIN SELECT r('aux.tr3') ; END;
79 1 "DROP TRIGGER main.tr1"
81 2 "DROP TRIGGER IF EXISTS main.tr1"
83 3 "DROP TRIGGER tr1"
85 4 "DROP TRIGGER IF EXISTS tr1"
88 5 "DROP TRIGGER aux.tr1"
90 6 "DROP TRIGGER IF EXISTS aux.tr1"
93 7 "DROP TRIGGER IF EXISTS aux.xxx"
95 8 "DROP TRIGGER IF EXISTS aux.xxx"
99 # EVIDENCE-OF: R-61172-15671 The DROP TRIGGER statement removes a
100 # trigger created by the CREATE TRIGGER statement.
103 1 t1 "DROP TRIGGER tr1" {temp.tr1} {}
104 2 t2 "DROP TRIGGER tr1" {main.tr1 main.tr2} {main.tr1 main.tr2}
105 3 t3 "DROP TRIGGER tr1" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr3 aux.tr2}
107 4 t1 "DROP TRIGGER tr2" {temp.tr1} {temp.tr1}
108 5 t2 "DROP TRIGGER tr2" {main.tr1 main.tr2} {main.tr1}
109 6 t3 "DROP TRIGGER tr2" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr3 aux.tr2}
111 7 t1 "DROP TRIGGER tr3" {temp.tr1} {temp.tr1}
112 8 t2 "DROP TRIGGER tr3" {main.tr1 main.tr2} {main.tr1 main.tr2}
113 9 t3 "DROP TRIGGER tr3" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr2}
141 1 t1 "DROP TRIGGER tr1" {temp.tr1} {}
142 2 t2 "DROP TRIGGER tr1" {main.tr1 main.tr2} {main.tr1 main.tr2}
143 3 t3 "DROP TRIGGER tr1" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr3 aux.tr2}
145 4 t1 "DROP TRIGGER tr2" {temp.tr1} {temp.tr1}
146 5 t2 "DROP TRIGGER tr2" {main.tr1 main.tr2} {main.tr1}
147 6 t3 "DROP TRIGGER tr2" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr3 aux.tr2}
149 7 t1 "DROP TRIGGER tr3" {temp.tr1} {temp.tr1}
150 8 t2 "DROP TRIGGER tr3" {main.tr1 main.tr2} {main.tr1 main.tr2}
151 9 t3 "DROP TRIGGER tr3" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr2}
168 1 t1 "DROP TRIGGER tr1" {temp.tr1} {}
169 2 t2 "DROP TRIGGER tr1" {main.tr1 main.tr2} {main.tr1 main.tr2}
170 3 t3 "DROP TRIGGER tr1" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr3 aux.tr2}
172 4 t1 "DROP TRIGGER tr2" {temp.tr1} {temp.tr1}
173 5 t2 "DROP TRIGGER tr2" {main.tr1 main.tr2} {main.tr1}
174 6 t3 "DROP TRIGGER tr2" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr3 aux.tr2}
176 7 t1 "DROP TRIGGER tr3" {temp.tr1} {temp.tr1}
177 8 t2 "DROP TRIGGER tr3" {main.tr1 main.tr2} {main.tr1 main.tr2}
178 9 t3 "DROP TRIGGER tr3" {aux.tr1 aux.tr3 aux.tr2} {aux.tr1 aux.tr2}