Lines Matching refs:CREATE

26     CREATE TABLE one(a int PRIMARY KEY, b text);
35     CREATE TABLE two(a int PRIMARY KEY, b text);
261   execsql {CREATE TABLE one(a text, b int)}
282 # Test commits and rollbacks of table CREATE TABLEs, CREATE INDEXs
295     CREATE TABLE t1(a int, b int, c int);
303     CREATE INDEX i1 ON t1(a);
320     CREATE TABLE t2(a int, b int, c int);
321     CREATE INDEX i2a ON t2(a);
322     CREATE INDEX i2b ON t2(b);
358     CREATE TABLE t2(x int, y int, z int);
359     CREATE INDEX i2x ON t2(x);
360     CREATE INDEX i2y ON t2(y);
417 # Try to DROP and CREATE tables and indices with the same name
425     CREATE TABLE t1(p,q,r);
435     CREATE TABLE t1(p,q,r);
450     CREATE TABLE t1(a,b,c);
466     CREATE TABLE t1(a,b,c);
483     CREATE TABLE t1(a unique,b,c);
487     CREATE TABLE t1(p unique,q,r);
496     CREATE TABLE t1(p unique,q,r);
511     CREATE TABLE t1(a unique,b,c);
527     CREATE TABLE t1(a unique,b,c);
542     CREATE TABLE t1(a integer primary key,b,c);
550     CREATE INDEX i1 ON t1(b);
580     CREATE INDEX i1 ON t1(c);
609     CREATE TABLE t1(a int unique,b,c);
618     CREATE INDEX i1 ON t1(b);
648     CREATE INDEX i1 ON t1(c);
735     CREATE TABLE t3 AS SELECT * FROM t2;
747     CREATE TEMP TABLE t3 AS SELECT * FROM t2;
759     CREATE TEMP TABLE t3 AS SELECT * FROM t2;
763     CREATE INDEX i3a ON t3(x);
795     CREATE TABLE t3 AS SELECT * FROM t2;
822     CREATE TABLE t3(x TEXT);