Lines Matching full:create
57 {CREATE TEMP TABLE tbl (a, b);}
58 {CREATE TABLE tbl (a, b);}
59 {CREATE TABLE tbl (a INTEGER PRIMARY KEY, b);}
60 {CREATE TEMPORARY TABLE tbl (a INTEGER PRIMARY KEY, b);}
61 {CREATE TABLE tbl (a, b PRIMARY KEY);}
62 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
63 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
80 CREATE TABLE rlog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
81 CREATE TABLE clog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
83 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
91 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
99 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
126 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
134 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
154 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
162 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
173 CREATE TABLE other_tbl(a, b);
276 CREATE TABLE tbl(a PRIMARY KEY, b, c);
277 CREATE TABLE log(a, b, c);
289 execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
301 execsql "CREATE TRIGGER the_trigger AFTER [string range $statement 0 6]\
324 CREATE TABLE tbl (a, b, c, d);
325 CREATE TABLE log (a);
329 CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
354 CREATE TABLE tbl (a, b, c, d);
355 CREATE TABLE log (a);
360 execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
391 CREATE TABLE tblA(a, b);
392 CREATE TABLE tblB(a, b);
393 CREATE TABLE tblC(a, b);
395 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
399 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
419 CREATE TABLE tbl(a, b, c);
420 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
437 CREATE TABLE tbl(a, b, c);
438 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
459 CREATE TABLE tbl (a primary key, b, c);
460 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
514 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
574 CREATE TABLE ab(a, b);
575 CREATE TABLE cd(c, d);
580 CREATE TABLE tlog(ii INTEGER PRIMARY KEY,
583 CREATE VIEW abcd AS SELECT a, b, c, d FROM ab, cd;
585 CREATE TRIGGER before_update INSTEAD OF UPDATE ON abcd BEGIN
589 CREATE TRIGGER after_update INSTEAD OF UPDATE ON abcd BEGIN
594 CREATE TRIGGER before_delete INSTEAD OF DELETE ON abcd BEGIN
598 CREATE TRIGGER after_delete INSTEAD OF DELETE ON abcd BEGIN
603 CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
607 CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
663 CREATE TABLE t1(a,b,c);
665 CREATE VIEW v1 AS
672 CREATE TABLE v1log(a,b,c,d,e,f);
673 CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
696 CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
706 CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN