Lines Matching refs:CREATE
71 CREATE TABLE collate4t1(a COLLATE NOCASE, b COLLATE TEXT);
77 CREATE INDEX collate4i1 ON collate4t1(a);
78 CREATE INDEX collate4i2 ON collate4t1(b);
102 CREATE TABLE collate4t2(
132 CREATE TABLE collate4t3(
163 CREATE TABLE collate4t4(a COLLATE NOCASE, b COLLATE TEXT);
169 CREATE INDEX collate4i3 ON collate4t4(a COLLATE TEXT);
170 CREATE INDEX collate4i4 ON collate4t4(b COLLATE NOCASE);
203 CREATE TABLE collate4t1(a COLLATE NOCASE, b COLLATE TEXT);
209 CREATE INDEX collate4i1 ON collate4t1(a, b);
233 CREATE TABLE collate4t2(
264 CREATE TABLE collate4t3(a COLLATE NOCASE, b COLLATE TEXT);
270 CREATE INDEX collate4i2 ON collate4t3(a COLLATE TEXT, b COLLATE NOCASE);
325 CREATE TABLE collate4t1(a COLLATE NOCASE);
326 CREATE TABLE collate4t2(b COLLATE TEXT);
350 CREATE INDEX collate4i1 ON collate4t1(a);
364 CREATE INDEX collate4i1 ON collate4t1(a COLLATE TEXT);
384 CREATE INDEX collate4i1 ON collate4t1(a);
398 CREATE INDEX collate4i1 ON collate4t1(a COLLATE TEXT);
414 CREATE TABLE collate4t1(a COLLATE nocase, b COLLATE text, c);
415 CREATE TABLE collate4t2(a COLLATE nocase, b COLLATE text, c COLLATE TEXT);
435 CREATE INDEX collate4i1 ON collate4t1(a, b, c);
444 CREATE INDEX collate4i1 ON collate4t1(a, b, c COLLATE text);
465 CREATE TABLE collate4t1(a PRIMARY KEY COLLATE NOCASE);
493 CREATE TABLE collate4t1(a COLLATE NOCASE UNIQUE);
521 CREATE TABLE collate4t1(a);
522 CREATE UNIQUE INDEX collate4i1 ON collate4t1(a COLLATE NOCASE);
570 CREATE TABLE collate4t1(a COLLATE TEXT);
590 CREATE INDEX collate4i1 ON collate4t1(a);
605 CREATE INDEX collate4i1 ON collate4t1(a COLLATE NUMERIC);
626 CREATE TABLE collate4t1(a COLLATE TEXT, b COLLATE NUMERIC);
673 # create another index on an INTEGER PRIMARY KEY column, so we don't have
679 CREATE TABLE collate4t1(a INTEGER PRIMARY KEY);
