Lines Matching refs:KEY

49     CREATE TABLE t1(x INTEGER PRIMARY KEY AUTOINCREMENT, y);
289     CREATE TABLE t2(d, e INTEGER PRIMARY KEY AUTOINCREMENT, f);
308     CREATE TABLE t3(g INTEGER PRIMARY KEY AUTOINCREMENT, h);
358       CREATE TABLE t1(x INTEGER PRIMARY KEY AUTOINCREMENT, y);
359       CREATE TEMP TABLE t3(a INTEGER PRIMARY KEY AUTOINCREMENT, b);
416       CREATE TEMP TABLE t2(p INTEGER PRIMARY KEY AUTOINCREMENT, q);
440       CREATE TABLE t4(m INTEGER PRIMARY KEY AUTOINCREMENT, n);
441       CREATE TABLE t5(o, p INTEGER PRIMARY KEY AUTOINCREMENT);
479       CREATE TABLE t6(v INTEGER PRIMARY KEY AUTOINCREMENT, w);
488       CREATE TABLE t6(v INTEGER PRIMARY KEY AUTOINCREMENT, w);
501 # on a separate PRIMARY KEY designation.
505     CREATE TABLE t7(x INTEGER, y REAL, PRIMARY KEY(x AUTOINCREMENT));
518     CREATE TABLE t8(x TEXT PRIMARY KEY AUTOINCREMENT);
520 } {1 {AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY}}
534        x INTEGER PRIMARY KEY AUTOINCREMENT
540        x INTEGER PRIMARY KEY AUTOINCREMENT
558     CREATE TABLE t2(x INTEGER PRIMARY KEY AUTOINCREMENT, y);
560     CREATE TABLE t3(a INTEGER PRIMARY KEY AUTOINCREMENT, b);
575       CREATE TABLE t3928(a INTEGER PRIMARY KEY AUTOINCREMENT, b);
624       CREATE TABLE t3928c(y INTEGER PRIMARY KEY AUTOINCREMENT, z);
651       CREATE TABLE ta69637_1(x INTEGER PRIMARY KEY AUTOINCREMENT, y);
677   CREATE TABLE t10a(a INTEGER PRIMARY KEY AUTOINCREMENT, b UNIQUE);
679   CREATE TABLE t10b(x INTEGER PRIMARY KEY AUTOINCREMENT, y UNIQUE);
687   CREATE TABLE t11(a INTEGER PRIMARY KEY AUTOINCREMENT,b UNIQUE);
703     CREATE TABLE fake_sequence(name TEXT PRIMARY KEY,seq) WITHOUT ROWID;
714     CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b TEXT);
725    CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b TEXT);
752    CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b TEXT);
771     CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b TEXT);
773     CREATE TABLE fake(name TEXT PRIMARY KEY,seq) WITHOUT ROWID;
801     CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b TEXT);
821     CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b TEXT);
825        sql='CREATE TABLE sqlite_sequence(x,y INTEGER PRIMARY KEY)'
843     CREATE TABLE t1(a INTEGER PRIMARY KEY AUTOINCREMENT, b TEXT);
847        sql='CREATE TABLE sqlite_sequence(y INTEGER PRIMARY KEY,x)'
863   CREATE TABLE t1(i INTEGER PRIMARY KEY AUTOINCREMENT, j);
864   CREATE TABLE t2(i INTEGER PRIMARY KEY AUTOINCREMENT, j);
865   CREATE TABLE t3(i INTEGER PRIMARY KEY AUTOINCREMENT, j);