lib/sqlite/sqlite3.c

2133 ** the table has a column of type [INTEGER PRIMARY KEY] then that column
5152 ** <tr><td> 8th <td> int         <td> True if column is part of the PRIMARY KEY
5164 ** [INTEGER PRIMARY KEY] column has been explicitly declared, then the output
5166 ** explicitly declared [INTEGER PRIMARY KEY] column, then the output
9751   u8 isPrimKey;    /* True if this column is part of the PRIMARY KEY */
9901 ** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
9903 ** that the datatype of the PRIMARY KEY must be INTEGER for this field to
9904 ** be set.  An INTEGER PRIMARY KEY is used as the rowid for each row of
9905 ** the table.  If a table has no INTEGER PRIMARY KEY, then a random rowid
9907 ** the table has any PRIMARY KEY, INTEGER or otherwise.
9984 **       a INTEGER PRIMARY KEY,
10007     char *zCol;        /* Name of column in zTo.  If 0 use PRIMARY KEY */
21192 ** KEY:
71998             /* Substitute the rowid (column -1) for the INTEGER PRIMARY KEY */
74418 ** to be unique - either because it is an INTEGER PRIMARY KEY or it
74423 ** be used unless <column> is an INTEGER PRIMARY KEY or an index can
77440   /* Check that the new column is not specified as PRIMARY KEY or UNIQUE.
77445     sqlite3ErrorMsg(pParse, "Cannot add a PRIMARY KEY column");
78382 **     ATTACH DATABASE x AS y KEY z
78386 ** If the optional "KEY z" syntax is omitted, an SQL NULL is passed as the
78722 **     ATTACH p AS pDbname KEY pKey
79991   ** PRIMARY KEY or UNIQUE keywords are parsed.  Those keywords will cause
80254 ** Designate the PRIMARY KEY for the table.  pList is a list of names
80262 ** If the PRIMARY KEY is on a single column whose datatype is INTEGER,
80265 ** INTEGER PRIMARY KEY column.  Table.iPKey is set to -1 if there is
80266 ** no INTEGER PRIMARY KEY.
80268 ** If the key is not an INTEGER PRIMARY KEY, then create a unique
80316        "INTEGER PRIMARY KEY");
80371     /* If the column is declared as "<name> PRIMARY KEY COLLATE <type>",
81867     ** result of a PRIMARY KEY or UNIQUE clause on a column definition, or
81868     ** a PRIMARY KEY or UNIQUE clause following the column definitions.
81871     ** CREATE TABLE t(x PRIMARY KEY, y);
81879     ** Two UNIQUE or PRIMARY KEY constraints are considered equivalent
81985       /* An automatic index created by a PRIMARY KEY or UNIQUE constraint */
82114       "or PRIMARY KEY constraint cannot be dropped", 0);
85792 **     CREATE TABLE t1(a, b INTEGER PRIMARY KEY, c);
85803 ** table are collectively subject to a UNIQUE or PRIMARY KEY constraint.
85808 ** KEY column, then output variable *ppIdx is set to NULL. Otherwise, *ppIdx
85826 **      UNIQUE or PRIMARY KEY constraint, or
85830 **      PRIMARY KEY, or
85833 **      foreign key definition, and the PRIMARY KEY of the parent table
85859   ** maps to the INTEGER PRIMARY KEY of table pParent. If so, leave *ppIdx
85869     **   1) There is an INTEGER PRIMARY KEY column and the FK is implicitly
85872     **      PRIMARY KEY.
85887       /* pIdx is a UNIQUE index (or a PRIMARY KEY) and has the right number
85893         ** the PRIMARY KEY of table pParent. The PRIMARY KEY index may be
86007       /* If pIdx is NULL, then the parent key is the INTEGER PRIMARY KEY
86244 **   CREATE TABLE t1(a PRIMARY KEY);
86616 **   CREATE TABLE p(pk PRIMARY KEY);
87331   int keyColumn = -1;   /* Column that is the INTEGER PRIMARY KEY */
87584   ** If the table has an INTEGER PRIMARY KEY column and that column
87693     ** PRIMARY KEY into which a NULL is being inserted, that NULL will be
87758   ** except when the table has an INTEGER PRIMARY KEY column, in which
87783       /* If the PRIMARY KEY expression is NULL, then use OP_NewRowid
87813         /* The value of the INTEGER PRIMARY KEY column is always a NULL.
88111   /* If we have an INTEGER PRIMARY KEY, make sure the primary key
88136           pParse, onError, "PRIMARY KEY must be unique", P4_STATIC);
88589     return 0;   /* Both tables must have the same INTEGER PRIMARY KEY */
88650     /* If tables do not have an INTEGER PRIMARY KEY and there
88674         pParse, onError, "PRIMARY KEY must be unique", P4_STATIC);
91592     ** was created to be the PRIMARY KEY or to fulfill a UNIQUE
101691   ** as "x>NULL" if x is not an INTEGER PRIMARY KEY.  So construct a
103879 **   CREATE TABLE t1(a TEXT PRIMARY KEY, b);
104082       zMsg = sqlite3MAppendf(db, zMsg, "%s USING INTEGER PRIMARY KEY", zMsg);
106354    26,  /*        KEY => ID */
106460   "KEY",           "OF",            "OFFSET",        "PRAGMA",
106581  /*  64 */ "ccons ::= PRIMARY KEY sortorder onconf autoinc",
106611  /*  94 */ "tcons ::= PRIMARY KEY LP idxlist autoinc RP onconf",
106614  /*  97 */ "tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt",
106821  /* 304 */ "key_opt ::= KEY expr",
107789       case 64: /* ccons ::= PRIMARY KEY sortorder onconf autoinc */
107850       case 94: /* tcons ::= PRIMARY KEY LP idxlist autoinc RP onconf */
107859       case 97: /* tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt */
108530       case 304: /* key_opt ::= KEY expr */ yytestcase(yyruleno==304);
109183       testcase( i==7 ); /* KEY */
113472 ** KEY:
114802   zContentCols = sqlite3_mprintf("docid INTEGER PRIMARY KEY");
114817       "CREATE TABLE %Q.'%q_segments'(blockid INTEGER PRIMARY KEY, block BLOB);",
114828         "PRIMARY KEY(level, idx)"
114834         "CREATE TABLE %Q.'%q_docsize'(docid INTEGER PRIMARY KEY, size BLOB);",
114840         "CREATE TABLE %Q.'%q_stat'(id INTEGER PRIMARY KEY, value BLOB);",
123209 **   CREATE TABLE %_segments(blockid INTEGER PRIMARY KEY, block BLOB)
127056 **   CREATE TABLE %_node(nodeno INTEGER PRIMARY KEY, data BLOB)
127057 **   CREATE TABLE %_parent(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)
127058 **   CREATE TABLE %_rowid(rowid INTEGER PRIMARY KEY, nodeno INTEGER)
129939 "CREATE TABLE \"%w\".\"%w_node\"(nodeno INTEGER PRIMARY KEY, data BLOB);"
129940 "CREATE TABLE \"%w\".\"%w_rowid\"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);"
129941 "CREATE TABLE \"%w\".\"%w_parent\"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER);"