Lines Matching refs:CREATE

28     CREATE TABLE one(a int PRIMARY KEY, b text);
37     CREATE TABLE two(a int PRIMARY KEY, b text);
263   execsql {CREATE TABLE one(a text, b int)}
284 # Test commits and rollbacks of table CREATE TABLEs, CREATE INDEXs
297     CREATE TABLE t1(a int, b int, c int);
305     CREATE INDEX i1 ON t1(a);
322     CREATE TABLE t2(a int, b int, c int);
323     CREATE INDEX i2a ON t2(a);
324     CREATE INDEX i2b ON t2(b);
360     CREATE TABLE t2(x int, y int, z int);
361     CREATE INDEX i2x ON t2(x);
362     CREATE INDEX i2y ON t2(y);
419 # Try to DROP and CREATE tables and indices with the same name
427     CREATE TABLE t1(p,q,r);
437     CREATE TABLE t1(p,q,r);
452     CREATE TABLE t1(a,b,c);
468     CREATE TABLE t1(a,b,c);
485     CREATE TABLE t1(a unique,b,c);
489     CREATE TABLE t1(p unique,q,r);
498     CREATE TABLE t1(p unique,q,r);
513     CREATE TABLE t1(a unique,b,c);
529     CREATE TABLE t1(a unique,b,c);
544     CREATE TABLE t1(a integer primary key,b,c);
552     CREATE INDEX i1 ON t1(b);
582     CREATE INDEX i1 ON t1(c);
611     CREATE TABLE t1(a int unique,b,c);
620     CREATE INDEX i1 ON t1(b);
650     CREATE INDEX i1 ON t1(c);
737     CREATE TABLE t3 AS SELECT * FROM t2;
749     CREATE TEMP TABLE t3 AS SELECT * FROM t2;
761     CREATE TEMP TABLE t3 AS SELECT * FROM t2;
765     CREATE INDEX i3a ON t3(x);
797     CREATE TABLE t3 AS SELECT * FROM t2;
824     CREATE TABLE t3(x TEXT);