Lines Matching refs:CREATE
2274 ** <dd> ^This option is used to enable or disable [CREATE TRIGGER | triggers].
2438 ** considered - auxiliary changes caused by [CREATE TRIGGER | triggers],
2550 ** well-formed CREATE TRIGGER statement. ^Semicolons that are embedded within
4363 ** CREATE TABLE t1(c1 VARIANT);
6250 ** zero in the order in which they appear within the CREATE TABLE statement
9086 ** executing "CREATE TABLE" statements) after this call is made, changes for
9090 ** defined as part of their CREATE TABLE statement. It does not matter if the
10572 ** tokenizer name as part of the CREATE VIRTUAL TABLE statement used
14698 int addColOffset; /* Offset in CREATE TABLE stmt to add a new column */
14714 ** followed by non-hidden columns. Example: "CREATE VIRTUAL TABLE x USING
14772 ** CREATE TABLE ex1(
14923 ** CREATE TABLE Ex1(c1 int, c2 int, c3 text);
14924 ** CREATE INDEX Ex2 ON Ex1(c3,c1);
14941 ** While parsing a CREATE TABLE or CREATE INDEX statement in order to
14966 unsigned idxType:2; /* 1==UNIQUE, 2==PRIMARY KEY, 0==CREATE INDEX */
14986 #define SQLITE_IDXTYPE_APPDEF 0 /* Created using CREATE INDEX */
15317 ** CREATE INDEX idx ON t(a,b,c);
15318 ** CREATE TRIGGER trig BEFORE UPDATE ON t(a,b,c) ...;
15506 #define NC_IdxExpr 0x0020 /* True if resolving columns of CREATE INDEX */
15793 int regRowid; /* Register holding rowid of CREATE TABLE entry */
15807 int addrCrTab; /* Address of OP_CreateTable opcode on CREATE TABLE */
15856 Table *pNewTable; /* A table being constructed by CREATE TABLE */
15857 Trigger *pNewTrigger; /* Trigger under construct by a CREATE TRIGGER */
35647 ** ReadWrite() -> (READWRITE | CREATE)
35649 ** OpenExclusive() -> (READWRITE | CREATE | EXCLUSIVE)
35703 ** (b) if CREATE is set, then READWRITE must also be set, and
35704 ** (c) if EXCLUSIVE is set, then CREATE must also be set.
35705 ** (d) if DELETEONCLOSE is set, then CREATE must also be set.
42011 OSTRACE(("SHM-MAP-CREATE pid=%lu, region=%d, size=%d, rc=%s\n",
42172 OSTRACE(("MAP-FILE-CREATE pid=%lu, pFile=%p, rc=%s\n",
42744 ** (b) if CREATE is set, then READWRITE must also be set, and
42745 ** (c) if EXCLUSIVE is set, then CREATE must also be set.
42746 ** (d) if DELETEONCLOSE is set, then CREATE must also be set.
46400 ** CREATE
46406 ** The CREATE and DESTROY primitives are the constructor and destructor,
54039 ** has been removed (CREATE INDEX needs to move a page when a statement
72077 ** * OP_CreateTable and OP_InitCoroutine (for CREATE TABLE AS SELECT ...)
83896 ** that is used to store tables create using CREATE TEMPORARY TABLE.
83956 ** that is used to store tables create using CREATE TEMPORARY TABLE.
86197 ** a VdbeCursor to sort large numbers of keys for CREATE INDEX statements
86216 ** in the case of a CREATE INDEX.
86233 ** CREATE UNIQUE INDEX statement.
87098 ** is used instead. This is used when sorting records for a CREATE INDEX
91124 ** CREATE TABLE t1(a);
92788 ** in a CREATE TABLE statement. The Walker.eCode value is 5 when parsing
92835 /* Silently convert bound parameters that appear inside of CREATE
92836 ** statements into a NULL when parsing the CREATE statement text out
92840 /* A bound parameter in a CREATE statement that originates from
93271 ** CREATE INDEX i1 ON t1(b, c, a);
94994 ** CREATE TABLE t1(a, b);
96321 ** ALTER TABLE command. The first argument is the text of a CREATE TABLE or
96322 ** CREATE INDEX command. The second is a table name. The table name in
96323 ** the CREATE TABLE or CREATE INDEX statement is replaced with the third
96326 ** sqlite_rename_table('CREATE TABLE abc(a, b, c)', 'def')
96327 ** -> 'CREATE TABLE def(a, b, c)'
96329 ** sqlite_rename_table('CREATE INDEX i ON abc(a)', 'def')
96330 ** -> 'CREATE INDEX i ON def(a, b, c)'
96350 /* The principle used to locate the table name in the CREATE TABLE
96387 ** 1) The complete text of the CREATE TABLE statement being modified,
96391 ** It returns the new CREATE TABLE statement. For example:
96393 ** sqlite_rename_parent('CREATE TABLE t1(a REFERENCES t2)', 't2', 't3')
96394 ** -> 'CREATE TABLE t1(a REFERENCES t3)'
96448 ** ALTER TABLE command. The first argument is the text of a CREATE TRIGGER
96449 ** statement. The second is a table name. The table name in the CREATE
96451 ** returned. This is analagous to renameTableFunc() above, except for CREATE
96452 ** TRIGGER, not CREATE INDEX and CREATE TABLE.
96472 /* The principle used to locate the table name in the CREATE TRIGGER
96505 ** "CREATE TRIGGER ... ON ON.ON BEGIN ..." etc.
96514 ** in the CREATE TRIGGER statement.
96795 /* If foreign-key support is enabled, rewrite the CREATE TABLE
96974 /* Modify the CREATE TABLE statement. */
97126 ** CREATE TABLE sqlite_stat1(tbl, idx, stat);
97127 ** CREATE TABLE sqlite_stat2(tbl, idx, sampleno, sample);
97128 ** CREATE TABLE sqlite_stat3(tbl, idx, nEq, nLt, nDLt, sample);
97129 ** CREATE TABLE sqlite_stat4(tbl, idx, nEq, nLt, nDLt, sample);
97322 ** side-effect of the CREATE TABLE statement is to leave the rootpage
97326 "CREATE TABLE %Q.%s(%s)", pDb->zDbSName, zTab, aTable[i].zCols
99898 ** CREATE TABLE
99900 ** CREATE INDEX
100241 ** CREATE, then check to see if it is the name of an virtual table that
100628 ** CREATE TABLE xxx.yyy (...);
100633 ** CREATE TABLE yyy(...);
100711 ** to a CREATE TABLE statement. In particular, this routine is called
100712 ** after seeing tokens "CREATE" and "TABLE" and the table name. The isTemp
100716 ** CREATE and TABLE.
100719 ** As more of the CREATE TABLE statement is parsed, additional action
100721 ** At the end of the CREATE TABLE statement, the sqlite3EndTable() routine
100928 ** in a CREATE TABLE statement. sqlite3StartTable() gets called
100991 ** parsing a CREATE TABLE statement. A "NOT NULL" constraint has
101098 ** parsing a CREATE TABLE statement.
101136 ** CREATE TABLE xyz(a,b,c,d,e,PRIMARY KEY('a'),UNIQUE('b','c' COLLATE trim)
101137 ** CREATE INDEX abc ON xyz('c','d' DESC,'e' COLLATE nocase DESC);
101414 ** Generate a CREATE TABLE statement appropriate for the given
101443 sqlite3_snprintf(n, zStmt, "CREATE TABLE ");
101544 ** This routine runs at the end of parsing a CREATE TABLE statement that
101640 ** code for a CREATE TABLE (not when parsing one as part of reading
101697 ** a CREATE TABLE statement.
101712 ** "CREATE TABLE ... AS SELECT ..." statement. The column names of
101718 Token *pEnd, /* The ')' before options in the CREATE TABLE */
101720 Select *pSelect /* Select from a "CREATE ... AS SELECT" */
101792 char *zStmt; /* Text of the CREATE TABLE or CREATE VIEW statement */
101814 /* If this is a CREATE TABLE xx AS SELECT ..., execute the SELECT
101870 /* Compute the complete text of the CREATE statement */
101878 "CREATE %s %.*s", zType2, n, pParse->sNameToken.z
101910 "CREATE TABLE %Q.sqlite_sequence(name,seq)",
101959 Token *pBegin, /* The CREATE token that begins the statement */
101997 /* Locate the end of the CREATE VIEW statement. Make sEnd point to
102058 ** CREATE VIEW one AS SELECT * FROM two;
102059 ** CREATE VIEW two AS SELECT * FROM one;
102065 ** CREATE TABLE main.ex1(a);
102066 ** CREATE TEMP VIEW ex1 AS SELECT a FROM ex1;
102099 /* CREATE VIEW name(arglist) AS ...
102114 /* CREATE VIEW name AS... without an argument list. Construct
102769 ** currently being constructed by a CREATE TABLE statement.
102782 Token *pStart, /* The CREATE token that begins this statement */
103134 ** CREATE TABLE t(x PRIMARY KEY, y);
103135 ** CREATE TABLE t(x, y, UNIQUE(x, y));
103170 ** constraint specified somewhere in the CREATE TABLE statement.
103211 /* If this is the initial CREATE INDEX statement (or CREATE TABLE if the
103220 ** or UNIQUE index in a CREATE TABLE statement. Since the table
103243 /* Gather the complete text of the CREATE INDEX statement into
103249 /* A named index with an explicit CREATE INDEX statement */
103250 zStmt = sqlite3MPrintf(db, "CREATE%s INDEX %.*s",
107733 ** CREATE TABLE t1(a, b INTEGER PRIMARY KEY, c);
108253 ** CREATE TABLE t1(a PRIMARY KEY);
108254 ** CREATE TABLE t2(b REFERENCES t1(a);
108754 ** CREATE TABLE p(pk PRIMARY KEY);
108755 ** CREATE TABLE c(ck REFERENCES p ON DELETE CASCADE);
108759 ** CREATE TRIGGER ... DELETE ON p BEGIN
115584 sqlite3StrAccumAppendAll(&acc, "CREATE TABLE x");
115900 ** argv[2] = SQL text for the CREATE statement.
115922 /* Call the parser to process a CREATE TABLE, INDEX or VIEW.
115959 ** constraint for a CREATE TABLE. The index should have already
115960 ** been created when we processed the CREATE TABLE. All we have
116012 azArg[2] = "CREATE TABLE x(type text,name text,tbl_name text,"
118056 ** original CREATE TABLE statement if the expression is a column. The
118128 ** CREATE TABLE t1(col INTEGER);
122862 ** This is called by the parser when it sees a CREATE TRIGGER statement
122870 Parse *pParse, /* The parse context of the CREATE TRIGGER statement */
122914 ** CREATE TRIGGER attached.demo AFTER INSERT ON attached.tab ....
123060 Token *pAll /* Token that describes the complete CREATE TRIGGER */
123099 "INSERT INTO %Q.%s VALUES('trigger',%Q,%Q,0,'CREATE TRIGGER %q')",
123207 ** sees an UPDATE statement inside the body of a CREATE TRIGGER.
123232 ** sees a DELETE statement inside the body of a CREATE TRIGGER.
123486 ** CREATE TRIGGER AFTER INSERT ON t1 BEGIN;
125005 db->init.iDb = nDb; /* force new CREATE statements into vacuum_db */
125450 ** The parser calls this routine when it first sees a CREATE VIRTUAL TABLE
125513 ** The parser calls this routine after the CREATE VIRTUAL TABLE statement
125525 /* If the CREATE VIRTUAL TABLE statement is being entered for the
125538 /* Compute the complete text of the CREATE VIRTUAL TABLE statement */
125542 zStmt = sqlite3MPrintf(db, "CREATE VIRTUAL TABLE %T", &pParse->sNameToken);
125598 ** of an argument to the module name in a CREATE VIRTUAL TABLE statement.
125608 ** in an argument to the module name in a CREATE VIRTUAL TABLE statement.
126259 ** module, and more importantly, does not require a CREATE VIRTUAL TABLE
127531 ** CREATE TABLE t1(a TEXT PRIMARY KEY, b);
127602 ** Ex: CREATE INDEX i1 ON t1(a,b,a); SELECT * FROM t1 WHERE a=0 AND b=0; */
128654 ** CREATE TABLE t1(a,b,c,d);
128655 ** CREATE INDEX i1 ON t1(a);
128656 ** CREATE INDEX i2 ON t1(b);
128657 ** CREATE INDEX i3 ON t1(c);
131781 ** CREATE INDEX i1 ON t1(a, b, c);
132765 ** CREATE INDEX ... ON (a, b, c, d, e)
134296 ** CREATE INDEX i1 ON t1(x, Y);
136457 0, /* CREATE => nothing */
136598 "TABLE", "CREATE", "IF", "NOT",
136679 /* 15 */ "createkw ::= CREATE",
137879 case 15: /* createkw ::= CREATE */
139687 testcase( i==70 ); /* CREATE */
140283 ** Special handling is require for CREATE TRIGGER statements.
140284 ** Whenever the CREATE TRIGGER keywords are seen, the statement
140301 ** (4) CREATE The keyword CREATE has been seen at the beginning of a
140338 /* A complex statement machine used to detect the end of a CREATE TRIGGER
140343 /* State: ** SEMI WS OTHER EXPLAIN CREATE TEMP TRIGGER END */
140348 /* 4 CREATE: */ { 1, 4, 2, 2, 2, 4, 5, 2, },
143435 testcase( (1<<(flags&7))==0x40 ); /* READWRITE | CREATE */
144484 ** run a single CREATE TABLE statement to construct the imposter table in
145422 ** the tokenizer clause of the CREATE VIRTUAL TABLE statement to the
145447 ** arguments passed to the "tokenizer" clause of the CREATE VIRTUAL
145451 ** CREATE .. USING fts3( ... , tokenizer <tokenizer-name> arg1 arg2)
145954 ** CREATE VIRTUAL TABLE ex1 USING fts3(a,b,c,d);
146557 /* Create the whole "CREATE TABLE" statement to pass to SQLite */
146559 "CREATE TABLE x(%s %Q HIDDEN, docid HIDDEN, %Q HIDDEN)",
146579 "CREATE TABLE IF NOT EXISTS %Q.'%q_stat'"
146617 "CREATE TABLE %Q.'%q_content'(%s)",
146625 "CREATE TABLE %Q.'%q_segments'(blockid INTEGER PRIMARY KEY, block BLOB);",
146629 "CREATE TABLE %Q.'%q_segdir'("
146642 "CREATE TABLE %Q.'%q_docsize'(docid INTEGER PRIMARY KEY, size BLOB);",
146909 ** (if any) specified as part of the CREATE VIRTUAL TABLE statement.
147252 ** 2. If no column names were specified as part of the CREATE VIRTUAL
151954 "CREATE TABLE x(term, col, documents, occurrences, languageid HIDDEN)"
151981 ** CREATE VIRTUAL TABLE xxx USING fts4aux(fts4-table);
151982 ** CREATE VIRTUAL TABLE xxx USING fts4aux(fts4-table-db, fts4-table);
155592 ** CREATE VIRTUAL TABLE <tbl> USING fts3tokenize(
155598 ** CREATE TABLE <tbl>(input, token, start, end, position)
155605 ** tokenizer specified by the arguments to the CREATE VIRTUAL TABLE
155722 #define FTS3_TOK_SCHEMA "CREATE TABLE x(input, token, start, end, position)"
155960 /* CREATE TABLE x(input, token, start, end, position) */
157202 ** CREATE TABLE %_segments(blockid INTEGER PRIMARY KEY, block BLOB)
161542 ** CREATE TABLE <table name>(
163540 ** As part of a tokenchars= or separators= option, the CREATE VIRTUAL TABLE
164214 ** CREATE TABLE %_node(nodeno INTEGER PRIMARY KEY, data BLOB)
164215 ** CREATE TABLE %_parent(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)
164216 ** CREATE TABLE %_rowid(rowid INTEGER PRIMARY KEY, nodeno INTEGER)
167265 ** Example: CREATE VIRTUAL TABLE bad USING rtree(x,y,CHECK(y>5));
167528 "CREATE TABLE \"%w\".\"%w_node\"(nodeno INTEGER PRIMARY KEY, data BLOB);"
167529 "CREATE TABLE \"%w\".\"%w_rowid\"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);"
167530 "CREATE TABLE \"%w\".\"%w_parent\"(nodeno INTEGER PRIMARY KEY,"
167652 int argc, const char *const*argv, /* Parameters to CREATE TABLE statement */
167708 char *zSql = sqlite3_mprintf("CREATE TABLE x(%s", argv[3]);
168935 ** CREATE INDEX commands. This extension allows it to be used to improve
168990 ** CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c UNIQUE);
168994 ** CREATE TABLE data_t1(a INTEGER, b TEXT, c, rbu_control);
169017 ** CREATE VIRTUAL TABLE x1 USING fts3(a, b);
169018 ** CREATE TABLE x1(a, b)
169022 ** CREATE TABLE data_x1(a, b, rbu_rowid, rbu_control);
169030 ** CREATE VIRTUAL TABLE ft1 USING fts4(a, b, languageid='langid');
169034 ** CREATE TABLE data_ft1(a, b, langid, rbu_rowid, rbu_control);
169035 ** CREATE TABLE data_ft1(a, b, rbu_rowid, rbu_control);
169365 ** CREATE TABLE rbu_count(tbl TEXT PRIMARY KEY, cnt INTEGER) WITHOUT ROWID;
169558 "CREATE TABLE IF NOT EXISTS %s.rbu_state(k INTEGER PRIMARY KEY, v)"
170500 ** }else if( sql for the entry starts with "CREATE VIRTUAL" ){
170780 ** CREATE INDEX i1 ON t1(c, b COLLATE nocase);
170933 ** CREATE TABLE t1(a, b, c, PRIMARY KEY(b, c));
171078 ** CREATE TABLE t1(a, b, c, PRIMARY KEY(b, a DESC)) WITHOUT ROWID
171136 ** CREATE TABLE t1(a, b TEXT, c REAL, PRIMARY KEY(b, c));
171140 ** CREATE TABLE rbu_imposter2(c1 TEXT, c2 REAL, id INTEGER) WITHOUT ROWID;
171190 "CREATE TABLE rbu_imposter2(%z, PRIMARY KEY(%z)) WITHOUT ROWID",
171254 rbuMPrintfExec(p, p->dbMain, "CREATE TABLE \"rbu_imp_%w\"(%z)%s",
171362 "CREATE TABLE \"rbu_imp_%w\"( %s, PRIMARY KEY( %s ) ) WITHOUT ROWID",
171470 "CREATE TABLE IF NOT EXISTS %s.'rbu_tmp_%q' AS "
171478 "CREATE TEMP TRIGGER rbu_delete_tr BEFORE DELETE ON \"%s%w\" "
171483 "CREATE TEMP TRIGGER rbu_update1_tr BEFORE UPDATE ON \"%s%w\" "
171488 "CREATE TEMP TRIGGER rbu_update2_tr AFTER UPDATE ON \"%s%w\" "
171499 "CREATE TEMP TRIGGER rbu_insert_tr AFTER INSERT ON \"%s%w\" "
172860 ** CREATE TABLE rbu_count(tbl TEXT PRIMARY KEY, cnt INTEGER) WITHOUT ROWID;
174254 "CREATE TABLE xx( " \
175088 ** in which columns were declared in the CREATE TABLE statement.
175128 ** table column, counting from left to right within the CREATE TABLE
175809 ** CREATE TABLE tbl1(w, x, y, z, PRIMARY KEY(w, z));
178194 ** CREATE TABLE x(a, b, c, d, PRIMARY KEY(a, c));
178263 ** CREATE TABLE x(a, b, c, d, PRIMARY KEY(a, c));
178359 ** CREATE TABLE x(a, b, c, d, PRIMARY KEY(a, c));
181477 "CREATE TABLE x(key,value,type,atom,id,parent,fullkey,path,"
182326 ** tokenizer name as part of the CREATE VIRTUAL TABLE statement used
182695 ** to parse the arguments passed to the CREATE VIRTUAL TABLE statement.
182702 ** be gleaned from the CREATE VIRTUAL TABLE statement.
186002 ** Parse a "special" CREATE VIRTUAL TABLE directive and update
186301 const char **azArg, /* Array of nArg CREATE VIRTUAL TABLE args */
186448 zSql = sqlite3Fts5Mprintf(&rc, "CREATE TABLE x(");
190154 ** CREATE TABLE %_data(id INTEGER PRIMARY KEY, block BLOB);
199580 rc = fts5ExecPrintf(pConfig->db, &zErr, "CREATE TABLE %Q.'%q_%q'(%s)%s",
202429 ** CREATE TABLE vocab(term, col, doc, cnt, PRIMARY KEY(term, col));
202437 ** CREATE TABLE vocab(term, doc, cnt, PRIMARY KEY(term));
202574 "CREATE TABlE vocab(" FTS5_VOCAB_COL_SCHEMA ")",
202575 "CREATE TABlE vocab(" FTS5_VOCAB_ROW_SCHEMA ")"