Lines Matching refs:c1

89     CREATE TABLE c1(a INTEGER PRIMARY KEY, b, c, d)
93     CREATE TABLE c1(a INT PRIMARY KEY, b, c, d) WITHOUT ROWID;
96   execsql { DROP TABLE IF EXISTS b1; DROP TABLE IF EXISTS c1; }
123     CREATE INDEX c1d ON c1(d, b);
124     CREATE UNIQUE INDEX c1c ON c1(c, b);
126     INSERT INTO c1 VALUES(1, 'a', 1,  1);
127     INSERT INTO c1 VALUES(2, 'a', 15, 2);
128     INSERT INTO c1 VALUES(3, 'a', 3,  3);
129     INSERT INTO c1 VALUES(4, 'a', 4,  4);
130     INSERT INTO c1 VALUES(5, 'a', 5,  5);
131     INSERT INTO c1 VALUES(6, 'a', 6,  6);
132     INSERT INTO c1 VALUES(7, 'a', 7,  7);
136     UPDATE OR REPLACE c1 SET c=c+10 WHERE d BETWEEN 4 AND 7;
137     SELECT * FROM c1 ORDER BY a;
152     DELETE FROM c1;
154     INSERT INTO c1 VALUES(1, 'a', 1,  1);
155     INSERT INTO c1 VALUES(2, 'a', 15, 2);
156     INSERT INTO c1 VALUES(3, 'a', 3,  3);
157     INSERT INTO c1 VALUES(4, 'a', 4,  4);
158     INSERT INTO c1 VALUES(5, 'a', 5,  5);
159     INSERT INTO c1 VALUES(6, 'a', 6,  6);
160     INSERT INTO c1 VALUES(7, 'a', 7,  7);
162     CREATE INDEX c1d ON c1(d);
163     CREATE UNIQUE INDEX c1c ON c1(c);
167     UPDATE OR REPLACE c1 SET c=c+10 WHERE d BETWEEN 4 AND 7;
168     SELECT * FROM c1 ORDER BY a;