blob: b854b4f38cd962c156d19fa1604fd8cdbc770f29 [file] [log] [blame]
drh67e65e52015-02-02 21:34:54 +00001/* DO NOT EDIT!
2** This file is automatically generated by the script at
3** ../tool/mkpragmatab.tcl. To update the set of pragmas, edit
4** that script and rerun it.
5*/
drhc232aca2016-12-15 16:01:17 +00006
7/* The various pragma types */
drh67e65e52015-02-02 21:34:54 +00008#define PragTyp_HEADER_VALUE 0
9#define PragTyp_AUTO_VACUUM 1
10#define PragTyp_FLAG 2
11#define PragTyp_BUSY_TIMEOUT 3
12#define PragTyp_CACHE_SIZE 4
drh9b0cf342015-11-12 14:57:19 +000013#define PragTyp_CACHE_SPILL 5
14#define PragTyp_CASE_SENSITIVE_LIKE 6
15#define PragTyp_COLLATION_LIST 7
16#define PragTyp_COMPILE_OPTIONS 8
17#define PragTyp_DATA_STORE_DIRECTORY 9
18#define PragTyp_DATABASE_LIST 10
19#define PragTyp_DEFAULT_CACHE_SIZE 11
20#define PragTyp_ENCODING 12
21#define PragTyp_FOREIGN_KEY_CHECK 13
22#define PragTyp_FOREIGN_KEY_LIST 14
23#define PragTyp_INCREMENTAL_VACUUM 15
24#define PragTyp_INDEX_INFO 16
25#define PragTyp_INDEX_LIST 17
26#define PragTyp_INTEGRITY_CHECK 18
27#define PragTyp_JOURNAL_MODE 19
28#define PragTyp_JOURNAL_SIZE_LIMIT 20
29#define PragTyp_LOCK_PROXY_FILE 21
30#define PragTyp_LOCKING_MODE 22
31#define PragTyp_PAGE_COUNT 23
32#define PragTyp_MMAP_SIZE 24
33#define PragTyp_PAGE_SIZE 25
34#define PragTyp_SECURE_DELETE 26
35#define PragTyp_SHRINK_MEMORY 27
36#define PragTyp_SOFT_HEAP_LIMIT 28
37#define PragTyp_STATS 29
38#define PragTyp_SYNCHRONOUS 30
39#define PragTyp_TABLE_INFO 31
40#define PragTyp_TEMP_STORE 32
41#define PragTyp_TEMP_STORE_DIRECTORY 33
42#define PragTyp_THREADS 34
43#define PragTyp_WAL_AUTOCHECKPOINT 35
44#define PragTyp_WAL_CHECKPOINT 36
45#define PragTyp_ACTIVATE_EXTENSIONS 37
46#define PragTyp_HEXKEY 38
47#define PragTyp_KEY 39
48#define PragTyp_REKEY 40
49#define PragTyp_LOCK_STATUS 41
50#define PragTyp_PARSER_TRACE 42
drhc232aca2016-12-15 16:01:17 +000051
52/* Property flags associated with various pragma. */
53#define PragFlg_NeedSchema 0x01 /* Force schema load before running */
54#define PragFlg_NoColumns 0x02 /* OP_ResultRow called with zero columns */
55#define PragFlg_ReadOnly 0x04 /* Read-only HEADER_VALUE */
56#define PragFlg_Result0 0x08 /* Acts as query when no argument */
57#define PragFlg_Result1 0x10 /* Acts as query when has one argument */
58#define PragFlg_SchemaOpt 0x20 /* Schema restricts name search if present */
59#define PragFlg_SchemaReq 0x40 /* Schema required - "main" is default */
60
61/* Names of columns for pragmas that return multi-column result
62** or that return single-column results where the name of the
63** result column is different from the name of the pragma
64*/
65static const char *const pragCName[] = {
66 /* 0 */ "cache_size", /* Used by: default_cache_size */
67 /* 1 */ "cid", /* Used by: table_info */
68 /* 2 */ "name",
69 /* 3 */ "type",
70 /* 4 */ "notnull",
71 /* 5 */ "dflt_value",
72 /* 6 */ "pk",
73 /* 7 */ "table", /* Used by: stats */
74 /* 8 */ "index",
75 /* 9 */ "width",
76 /* 10 */ "height",
77 /* 11 */ "seqno", /* Used by: index_info */
78 /* 12 */ "cid",
79 /* 13 */ "name",
80 /* 14 */ "seqno", /* Used by: index_xinfo */
81 /* 15 */ "cid",
82 /* 16 */ "name",
83 /* 17 */ "desc",
84 /* 18 */ "coll",
85 /* 19 */ "key",
86 /* 20 */ "seq", /* Used by: index_list */
87 /* 21 */ "name",
88 /* 22 */ "unique",
89 /* 23 */ "origin",
90 /* 24 */ "partial",
91 /* 25 */ "seq", /* Used by: database_list */
92 /* 26 */ "name",
93 /* 27 */ "file",
94 /* 28 */ "seq", /* Used by: collation_list */
95 /* 29 */ "name",
96 /* 30 */ "id", /* Used by: foreign_key_list */
97 /* 31 */ "seq",
98 /* 32 */ "table",
99 /* 33 */ "from",
100 /* 34 */ "to",
101 /* 35 */ "on_update",
102 /* 36 */ "on_delete",
103 /* 37 */ "match",
104 /* 38 */ "table", /* Used by: foreign_key_check */
105 /* 39 */ "rowid",
106 /* 40 */ "parent",
107 /* 41 */ "fkid",
108 /* 42 */ "busy", /* Used by: wal_checkpoint */
109 /* 43 */ "log",
110 /* 44 */ "checkpointed",
111 /* 45 */ "timeout", /* Used by: busy_timeout */
112 /* 46 */ "database", /* Used by: lock_status */
113 /* 47 */ "status",
114};
115
116/* Definitions of all built-in pragmas */
drh2fcc1592016-12-15 20:59:03 +0000117typedef struct PragmaName {
drhc232aca2016-12-15 16:01:17 +0000118 const char *const zName; /* Name of pragma */
119 u8 ePragTyp; /* PragTyp_XXX value */
120 u8 mPragFlg; /* Zero or more PragFlg_XXX values */
121 u8 iPragCName; /* Start of column names in pragCName[] */
122 u8 nPragCName; /* Num of col names. 0 means use pragma name */
123 u32 iArg; /* Extra argument */
drh2fcc1592016-12-15 20:59:03 +0000124} PragmaName;
125static const PragmaName aPragmaName[] = {
drh67e65e52015-02-02 21:34:54 +0000126#if defined(SQLITE_HAS_CODEC) || defined(SQLITE_ENABLE_CEROD)
drhc232aca2016-12-15 16:01:17 +0000127 {/* zName: */ "activate_extensions",
128 /* ePragTyp: */ PragTyp_ACTIVATE_EXTENSIONS,
129 /* ePragFlg: */ 0,
130 /* ColNames: */ 0, 0,
131 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000132#endif
133#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000134 {/* zName: */ "application_id",
135 /* ePragTyp: */ PragTyp_HEADER_VALUE,
136 /* ePragFlg: */ PragFlg_Result0,
137 /* ColNames: */ 0, 0,
138 /* iArg: */ BTREE_APPLICATION_ID },
drh67e65e52015-02-02 21:34:54 +0000139#endif
140#if !defined(SQLITE_OMIT_AUTOVACUUM)
drhc232aca2016-12-15 16:01:17 +0000141 {/* zName: */ "auto_vacuum",
142 /* ePragTyp: */ PragTyp_AUTO_VACUUM,
143 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
144 /* ColNames: */ 0, 0,
145 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000146#endif
147#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
148#if !defined(SQLITE_OMIT_AUTOMATIC_INDEX)
drhc232aca2016-12-15 16:01:17 +0000149 {/* zName: */ "automatic_index",
150 /* ePragTyp: */ PragTyp_FLAG,
151 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
152 /* ColNames: */ 0, 0,
153 /* iArg: */ SQLITE_AutoIndex },
drh67e65e52015-02-02 21:34:54 +0000154#endif
155#endif
drhc232aca2016-12-15 16:01:17 +0000156 {/* zName: */ "busy_timeout",
157 /* ePragTyp: */ PragTyp_BUSY_TIMEOUT,
158 /* ePragFlg: */ PragFlg_Result0,
159 /* ColNames: */ 45, 1,
160 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000161#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000162 {/* zName: */ "cache_size",
163 /* ePragTyp: */ PragTyp_CACHE_SIZE,
164 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
165 /* ColNames: */ 0, 0,
166 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000167#endif
168#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000169 {/* zName: */ "cache_spill",
170 /* ePragTyp: */ PragTyp_CACHE_SPILL,
171 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
172 /* ColNames: */ 0, 0,
173 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000174#endif
drhc232aca2016-12-15 16:01:17 +0000175 {/* zName: */ "case_sensitive_like",
176 /* ePragTyp: */ PragTyp_CASE_SENSITIVE_LIKE,
177 /* ePragFlg: */ 0,
178 /* ColNames: */ 0, 0,
179 /* iArg: */ 0 },
180 {/* zName: */ "cell_size_check",
181 /* ePragTyp: */ PragTyp_FLAG,
182 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
183 /* ColNames: */ 0, 0,
184 /* iArg: */ SQLITE_CellSizeCk },
drh67e65e52015-02-02 21:34:54 +0000185#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000186 {/* zName: */ "checkpoint_fullfsync",
187 /* ePragTyp: */ PragTyp_FLAG,
188 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
189 /* ColNames: */ 0, 0,
190 /* iArg: */ SQLITE_CkptFullFSync },
drh67e65e52015-02-02 21:34:54 +0000191#endif
192#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000193 {/* zName: */ "collation_list",
194 /* ePragTyp: */ PragTyp_COLLATION_LIST,
195 /* ePragFlg: */ PragFlg_Result0,
196 /* ColNames: */ 28, 2,
197 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000198#endif
199#if !defined(SQLITE_OMIT_COMPILEOPTION_DIAGS)
drhc232aca2016-12-15 16:01:17 +0000200 {/* zName: */ "compile_options",
201 /* ePragTyp: */ PragTyp_COMPILE_OPTIONS,
202 /* ePragFlg: */ PragFlg_Result0,
203 /* ColNames: */ 0, 0,
204 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000205#endif
206#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000207 {/* zName: */ "count_changes",
208 /* ePragTyp: */ PragTyp_FLAG,
209 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
210 /* ColNames: */ 0, 0,
211 /* iArg: */ SQLITE_CountRows },
drh67e65e52015-02-02 21:34:54 +0000212#endif
213#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_OS_WIN
drhc232aca2016-12-15 16:01:17 +0000214 {/* zName: */ "data_store_directory",
215 /* ePragTyp: */ PragTyp_DATA_STORE_DIRECTORY,
216 /* ePragFlg: */ 0,
217 /* ColNames: */ 0, 0,
218 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000219#endif
220#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000221 {/* zName: */ "data_version",
222 /* ePragTyp: */ PragTyp_HEADER_VALUE,
223 /* ePragFlg: */ PragFlg_Result0|PragFlg_ReadOnly,
224 /* ColNames: */ 0, 0,
225 /* iArg: */ BTREE_DATA_VERSION },
drh67e65e52015-02-02 21:34:54 +0000226#endif
227#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000228 {/* zName: */ "database_list",
229 /* ePragTyp: */ PragTyp_DATABASE_LIST,
230 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0,
231 /* ColNames: */ 25, 3,
232 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000233#endif
234#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && !defined(SQLITE_OMIT_DEPRECATED)
drhc232aca2016-12-15 16:01:17 +0000235 {/* zName: */ "default_cache_size",
236 /* ePragTyp: */ PragTyp_DEFAULT_CACHE_SIZE,
237 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
238 /* ColNames: */ 0, 1,
239 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000240#endif
241#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
242#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
drhc232aca2016-12-15 16:01:17 +0000243 {/* zName: */ "defer_foreign_keys",
244 /* ePragTyp: */ PragTyp_FLAG,
245 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
246 /* ColNames: */ 0, 0,
247 /* iArg: */ SQLITE_DeferFKs },
drh67e65e52015-02-02 21:34:54 +0000248#endif
249#endif
250#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000251 {/* zName: */ "empty_result_callbacks",
252 /* ePragTyp: */ PragTyp_FLAG,
253 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
254 /* ColNames: */ 0, 0,
255 /* iArg: */ SQLITE_NullCallback },
drh67e65e52015-02-02 21:34:54 +0000256#endif
257#if !defined(SQLITE_OMIT_UTF16)
drhc232aca2016-12-15 16:01:17 +0000258 {/* zName: */ "encoding",
259 /* ePragTyp: */ PragTyp_ENCODING,
260 /* ePragFlg: */ PragFlg_Result0,
261 /* ColNames: */ 0, 0,
262 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000263#endif
264#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
drhc232aca2016-12-15 16:01:17 +0000265 {/* zName: */ "foreign_key_check",
266 /* ePragTyp: */ PragTyp_FOREIGN_KEY_CHECK,
267 /* ePragFlg: */ PragFlg_NeedSchema,
268 /* ColNames: */ 38, 4,
269 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000270#endif
271#if !defined(SQLITE_OMIT_FOREIGN_KEY)
drhc232aca2016-12-15 16:01:17 +0000272 {/* zName: */ "foreign_key_list",
273 /* ePragTyp: */ PragTyp_FOREIGN_KEY_LIST,
274 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
275 /* ColNames: */ 30, 8,
276 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000277#endif
278#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
279#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
drhc232aca2016-12-15 16:01:17 +0000280 {/* zName: */ "foreign_keys",
281 /* ePragTyp: */ PragTyp_FLAG,
282 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
283 /* ColNames: */ 0, 0,
284 /* iArg: */ SQLITE_ForeignKeys },
drh67e65e52015-02-02 21:34:54 +0000285#endif
286#endif
287#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000288 {/* zName: */ "freelist_count",
289 /* ePragTyp: */ PragTyp_HEADER_VALUE,
290 /* ePragFlg: */ PragFlg_Result0|PragFlg_ReadOnly,
291 /* ColNames: */ 0, 0,
292 /* iArg: */ BTREE_FREE_PAGE_COUNT },
drh67e65e52015-02-02 21:34:54 +0000293#endif
294#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000295 {/* zName: */ "full_column_names",
296 /* ePragTyp: */ PragTyp_FLAG,
297 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
298 /* ColNames: */ 0, 0,
299 /* iArg: */ SQLITE_FullColNames },
300 {/* zName: */ "fullfsync",
301 /* ePragTyp: */ PragTyp_FLAG,
302 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
303 /* ColNames: */ 0, 0,
304 /* iArg: */ SQLITE_FullFSync },
drh67e65e52015-02-02 21:34:54 +0000305#endif
306#if defined(SQLITE_HAS_CODEC)
drhc232aca2016-12-15 16:01:17 +0000307 {/* zName: */ "hexkey",
308 /* ePragTyp: */ PragTyp_HEXKEY,
309 /* ePragFlg: */ 0,
310 /* ColNames: */ 0, 0,
311 /* iArg: */ 0 },
312 {/* zName: */ "hexrekey",
313 /* ePragTyp: */ PragTyp_HEXKEY,
314 /* ePragFlg: */ 0,
315 /* ColNames: */ 0, 0,
316 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000317#endif
318#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
319#if !defined(SQLITE_OMIT_CHECK)
drhc232aca2016-12-15 16:01:17 +0000320 {/* zName: */ "ignore_check_constraints",
321 /* ePragTyp: */ PragTyp_FLAG,
322 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
323 /* ColNames: */ 0, 0,
324 /* iArg: */ SQLITE_IgnoreChecks },
drh67e65e52015-02-02 21:34:54 +0000325#endif
326#endif
327#if !defined(SQLITE_OMIT_AUTOVACUUM)
drhc232aca2016-12-15 16:01:17 +0000328 {/* zName: */ "incremental_vacuum",
329 /* ePragTyp: */ PragTyp_INCREMENTAL_VACUUM,
330 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_NoColumns,
331 /* ColNames: */ 0, 0,
332 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000333#endif
334#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000335 {/* zName: */ "index_info",
336 /* ePragTyp: */ PragTyp_INDEX_INFO,
337 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
338 /* ColNames: */ 11, 3,
339 /* iArg: */ 0 },
340 {/* zName: */ "index_list",
341 /* ePragTyp: */ PragTyp_INDEX_LIST,
342 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
343 /* ColNames: */ 20, 5,
344 /* iArg: */ 0 },
345 {/* zName: */ "index_xinfo",
346 /* ePragTyp: */ PragTyp_INDEX_INFO,
347 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
348 /* ColNames: */ 14, 6,
349 /* iArg: */ 1 },
drh67e65e52015-02-02 21:34:54 +0000350#endif
351#if !defined(SQLITE_OMIT_INTEGRITY_CHECK)
drhc232aca2016-12-15 16:01:17 +0000352 {/* zName: */ "integrity_check",
353 /* ePragTyp: */ PragTyp_INTEGRITY_CHECK,
354 /* ePragFlg: */ PragFlg_NeedSchema,
355 /* ColNames: */ 0, 0,
356 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000357#endif
358#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000359 {/* zName: */ "journal_mode",
360 /* ePragTyp: */ PragTyp_JOURNAL_MODE,
361 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
362 /* ColNames: */ 0, 0,
363 /* iArg: */ 0 },
364 {/* zName: */ "journal_size_limit",
365 /* ePragTyp: */ PragTyp_JOURNAL_SIZE_LIMIT,
366 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
367 /* ColNames: */ 0, 0,
368 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000369#endif
370#if defined(SQLITE_HAS_CODEC)
drhc232aca2016-12-15 16:01:17 +0000371 {/* zName: */ "key",
372 /* ePragTyp: */ PragTyp_KEY,
373 /* ePragFlg: */ 0,
374 /* ColNames: */ 0, 0,
375 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000376#endif
377#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000378 {/* zName: */ "legacy_file_format",
379 /* ePragTyp: */ PragTyp_FLAG,
380 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
381 /* ColNames: */ 0, 0,
382 /* iArg: */ SQLITE_LegacyFileFmt },
drh67e65e52015-02-02 21:34:54 +0000383#endif
384#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_ENABLE_LOCKING_STYLE
drhc232aca2016-12-15 16:01:17 +0000385 {/* zName: */ "lock_proxy_file",
386 /* ePragTyp: */ PragTyp_LOCK_PROXY_FILE,
387 /* ePragFlg: */ 0,
388 /* ColNames: */ 0, 0,
389 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000390#endif
391#if defined(SQLITE_DEBUG) || defined(SQLITE_TEST)
drhc232aca2016-12-15 16:01:17 +0000392 {/* zName: */ "lock_status",
393 /* ePragTyp: */ PragTyp_LOCK_STATUS,
394 /* ePragFlg: */ PragFlg_Result0,
395 /* ColNames: */ 46, 2,
396 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000397#endif
398#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000399 {/* zName: */ "locking_mode",
400 /* ePragTyp: */ PragTyp_LOCKING_MODE,
401 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
402 /* ColNames: */ 0, 0,
403 /* iArg: */ 0 },
404 {/* zName: */ "max_page_count",
405 /* ePragTyp: */ PragTyp_PAGE_COUNT,
406 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
407 /* ColNames: */ 0, 0,
408 /* iArg: */ 0 },
409 {/* zName: */ "mmap_size",
410 /* ePragTyp: */ PragTyp_MMAP_SIZE,
411 /* ePragFlg: */ 0,
412 /* ColNames: */ 0, 0,
413 /* iArg: */ 0 },
414 {/* zName: */ "page_count",
415 /* ePragTyp: */ PragTyp_PAGE_COUNT,
416 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
417 /* ColNames: */ 0, 0,
418 /* iArg: */ 0 },
419 {/* zName: */ "page_size",
420 /* ePragTyp: */ PragTyp_PAGE_SIZE,
421 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
422 /* ColNames: */ 0, 0,
423 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000424#endif
drh35926802015-12-15 13:50:22 +0000425#if defined(SQLITE_DEBUG) && !defined(SQLITE_OMIT_PARSER_TRACE)
drhc232aca2016-12-15 16:01:17 +0000426 {/* zName: */ "parser_trace",
427 /* ePragTyp: */ PragTyp_PARSER_TRACE,
428 /* ePragFlg: */ 0,
429 /* ColNames: */ 0, 0,
430 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000431#endif
432#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000433 {/* zName: */ "query_only",
434 /* ePragTyp: */ PragTyp_FLAG,
435 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
436 /* ColNames: */ 0, 0,
437 /* iArg: */ SQLITE_QueryOnly },
drh67e65e52015-02-02 21:34:54 +0000438#endif
439#if !defined(SQLITE_OMIT_INTEGRITY_CHECK)
drhc232aca2016-12-15 16:01:17 +0000440 {/* zName: */ "quick_check",
441 /* ePragTyp: */ PragTyp_INTEGRITY_CHECK,
442 /* ePragFlg: */ PragFlg_NeedSchema,
443 /* ColNames: */ 0, 0,
444 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000445#endif
446#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000447 {/* zName: */ "read_uncommitted",
448 /* ePragTyp: */ PragTyp_FLAG,
449 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
450 /* ColNames: */ 0, 0,
451 /* iArg: */ SQLITE_ReadUncommitted },
452 {/* zName: */ "recursive_triggers",
453 /* ePragTyp: */ PragTyp_FLAG,
454 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
455 /* ColNames: */ 0, 0,
456 /* iArg: */ SQLITE_RecTriggers },
drh67e65e52015-02-02 21:34:54 +0000457#endif
458#if defined(SQLITE_HAS_CODEC)
drhc232aca2016-12-15 16:01:17 +0000459 {/* zName: */ "rekey",
460 /* ePragTyp: */ PragTyp_REKEY,
461 /* ePragFlg: */ 0,
462 /* ColNames: */ 0, 0,
463 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000464#endif
465#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000466 {/* zName: */ "reverse_unordered_selects",
467 /* ePragTyp: */ PragTyp_FLAG,
468 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
469 /* ColNames: */ 0, 0,
470 /* iArg: */ SQLITE_ReverseOrder },
drh67e65e52015-02-02 21:34:54 +0000471#endif
472#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000473 {/* zName: */ "schema_version",
474 /* ePragTyp: */ PragTyp_HEADER_VALUE,
475 /* ePragFlg: */ PragFlg_Result0,
476 /* ColNames: */ 0, 0,
477 /* iArg: */ BTREE_SCHEMA_VERSION },
drh67e65e52015-02-02 21:34:54 +0000478#endif
479#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000480 {/* zName: */ "secure_delete",
481 /* ePragTyp: */ PragTyp_SECURE_DELETE,
482 /* ePragFlg: */ PragFlg_Result0,
483 /* ColNames: */ 0, 0,
484 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000485#endif
486#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000487 {/* zName: */ "short_column_names",
488 /* ePragTyp: */ PragTyp_FLAG,
489 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
490 /* ColNames: */ 0, 0,
491 /* iArg: */ SQLITE_ShortColNames },
drh67e65e52015-02-02 21:34:54 +0000492#endif
drhc232aca2016-12-15 16:01:17 +0000493 {/* zName: */ "shrink_memory",
494 /* ePragTyp: */ PragTyp_SHRINK_MEMORY,
495 /* ePragFlg: */ 0,
496 /* ColNames: */ 0, 0,
497 /* iArg: */ 0 },
498 {/* zName: */ "soft_heap_limit",
499 /* ePragTyp: */ PragTyp_SOFT_HEAP_LIMIT,
500 /* ePragFlg: */ PragFlg_Result0,
501 /* ColNames: */ 0, 0,
502 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000503#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
504#if defined(SQLITE_DEBUG)
drhc232aca2016-12-15 16:01:17 +0000505 {/* zName: */ "sql_trace",
506 /* ePragTyp: */ PragTyp_FLAG,
507 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
508 /* ColNames: */ 0, 0,
509 /* iArg: */ SQLITE_SqlTrace },
drh67e65e52015-02-02 21:34:54 +0000510#endif
511#endif
512#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000513 {/* zName: */ "stats",
514 /* ePragTyp: */ PragTyp_STATS,
515 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
516 /* ColNames: */ 7, 4,
517 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000518#endif
519#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000520 {/* zName: */ "synchronous",
521 /* ePragTyp: */ PragTyp_SYNCHRONOUS,
522 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
523 /* ColNames: */ 0, 0,
524 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000525#endif
526#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000527 {/* zName: */ "table_info",
528 /* ePragTyp: */ PragTyp_TABLE_INFO,
529 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
530 /* ColNames: */ 1, 6,
531 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000532#endif
533#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000534 {/* zName: */ "temp_store",
535 /* ePragTyp: */ PragTyp_TEMP_STORE,
536 /* ePragFlg: */ PragFlg_Result0,
537 /* ColNames: */ 0, 0,
538 /* iArg: */ 0 },
539 {/* zName: */ "temp_store_directory",
540 /* ePragTyp: */ PragTyp_TEMP_STORE_DIRECTORY,
541 /* ePragFlg: */ 0,
542 /* ColNames: */ 0, 0,
543 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000544#endif
drhc232aca2016-12-15 16:01:17 +0000545 {/* zName: */ "threads",
546 /* ePragTyp: */ PragTyp_THREADS,
547 /* ePragFlg: */ PragFlg_Result0,
548 /* ColNames: */ 0, 0,
549 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000550#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000551 {/* zName: */ "user_version",
552 /* ePragTyp: */ PragTyp_HEADER_VALUE,
553 /* ePragFlg: */ PragFlg_Result0,
554 /* ColNames: */ 0, 0,
555 /* iArg: */ BTREE_USER_VERSION },
drh67e65e52015-02-02 21:34:54 +0000556#endif
557#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
558#if defined(SQLITE_DEBUG)
drhc232aca2016-12-15 16:01:17 +0000559 {/* zName: */ "vdbe_addoptrace",
560 /* ePragTyp: */ PragTyp_FLAG,
561 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
562 /* ColNames: */ 0, 0,
563 /* iArg: */ SQLITE_VdbeAddopTrace },
564 {/* zName: */ "vdbe_debug",
565 /* ePragTyp: */ PragTyp_FLAG,
566 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
567 /* ColNames: */ 0, 0,
568 /* iArg: */ SQLITE_SqlTrace|SQLITE_VdbeListing|SQLITE_VdbeTrace },
569 {/* zName: */ "vdbe_eqp",
570 /* ePragTyp: */ PragTyp_FLAG,
571 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
572 /* ColNames: */ 0, 0,
573 /* iArg: */ SQLITE_VdbeEQP },
574 {/* zName: */ "vdbe_listing",
575 /* ePragTyp: */ PragTyp_FLAG,
576 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
577 /* ColNames: */ 0, 0,
578 /* iArg: */ SQLITE_VdbeListing },
579 {/* zName: */ "vdbe_trace",
580 /* ePragTyp: */ PragTyp_FLAG,
581 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
582 /* ColNames: */ 0, 0,
583 /* iArg: */ SQLITE_VdbeTrace },
drh67e65e52015-02-02 21:34:54 +0000584#endif
585#endif
586#if !defined(SQLITE_OMIT_WAL)
drhc232aca2016-12-15 16:01:17 +0000587 {/* zName: */ "wal_autocheckpoint",
588 /* ePragTyp: */ PragTyp_WAL_AUTOCHECKPOINT,
589 /* ePragFlg: */ 0,
590 /* ColNames: */ 0, 0,
591 /* iArg: */ 0 },
592 {/* zName: */ "wal_checkpoint",
593 /* ePragTyp: */ PragTyp_WAL_CHECKPOINT,
594 /* ePragFlg: */ PragFlg_NeedSchema,
595 /* ColNames: */ 42, 3,
596 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000597#endif
598#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000599 {/* zName: */ "writable_schema",
600 /* ePragTyp: */ PragTyp_FLAG,
601 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns,
602 /* ColNames: */ 0, 0,
603 /* iArg: */ SQLITE_WriteSchema|SQLITE_RecoveryMode },
drh67e65e52015-02-02 21:34:54 +0000604#endif
605};
drh1421d982015-05-27 03:46:18 +0000606/* Number of pragmas: 60 on by default, 73 total. */