Lines Matching full:create

59 	{CREATE TEMP TABLE tbl (a, b);} 
60 	{CREATE TABLE tbl (a, b);} 
61 	{CREATE TABLE tbl (a INTEGER PRIMARY KEY, b);} 
62 	{CREATE TEMPORARY TABLE tbl (a INTEGER PRIMARY KEY, b);} 
63         {CREATE TABLE tbl (a, b PRIMARY KEY);} 
64 	{CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);} 
65 	{CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);} 
82     CREATE TABLE rlog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
83     CREATE TABLE clog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
85     CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW 
93     CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW 
101     CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
128     CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
136     CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
156     CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
164     CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
175       CREATE TABLE other_tbl(a, b);
278       CREATE TABLE tbl(a PRIMARY KEY, b, c);
279       CREATE TABLE log(a, b, c);
291     execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
303     execsql "CREATE TRIGGER the_trigger AFTER [string range $statement 0 6]\
326   CREATE TABLE tbl (a, b, c, d);
327   CREATE TABLE log (a);
331   CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
356   CREATE TABLE tbl (a, b, c, d);
357   CREATE TABLE log (a);
362   execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
393   CREATE TABLE tblA(a, b);
394   CREATE TABLE tblB(a, b);
395   CREATE TABLE tblC(a, b);
397   CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
401   CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
421   CREATE TABLE tbl(a, b, c);
422   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl 
439   CREATE TABLE tbl(a, b, c);
440   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl 
461   CREATE TABLE tbl (a primary key, b, c);
462   CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
516   CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
576   CREATE TABLE ab(a, b);
577   CREATE TABLE cd(c, d);
582   CREATE TABLE tlog(ii INTEGER PRIMARY KEY, 
585   CREATE VIEW abcd AS SELECT a, b, c, d FROM ab, cd;
587   CREATE TRIGGER before_update INSTEAD OF UPDATE ON abcd BEGIN
591   CREATE TRIGGER after_update INSTEAD OF UPDATE ON abcd BEGIN
596   CREATE TRIGGER before_delete INSTEAD OF DELETE ON abcd BEGIN
600   CREATE TRIGGER after_delete INSTEAD OF DELETE ON abcd BEGIN
605   CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
609    CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
665     CREATE TABLE t1(a,b,c);
667     CREATE VIEW v1 AS
674     CREATE TABLE v1log(a,b,c,d,e,f);
675     CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
698     CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
708     CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN