Lines Matching refs:CREATE

16 # 1. CREATE and DROP TRIGGER tests
38      CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
45      CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
52     CREATE TABLE t1(a);
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
81 	CREATE TRIGGER tr1 DELETE ON t1 BEGIN
110   CREATE TEMP TABLE temp_table(a);
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
215     CREATE TEMP TABLE t2(x,y);
218     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
243     CREATE TEMP TABLE t2(x,y);
251     CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
261     CREATE TABLE t2(x,y);
282     CREATE TEMP TRIGGER r1 BEFORE INSERT ON t1 BEGIN
324     CREATE TRIGGER t2 BEFORE DELETE ON t2 BEGIN
363     CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
375     CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
387     CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
402     CREATE TABLE t3(a,b);
403     CREATE TABLE t4(x UNIQUE, b);
404     CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
435   execsql {CREATE TABLE t3(a, b, c);} db2
443     CREATE TABLE t1(a, b, c);
444     CREATE temp TABLE t2(a, b, c);
445     CREATE TABLE insert_log(db, a, b, c);
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 
506     CREATE temp TABLE insert_log(db, d, e, f);