1/* 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*/
6
7/* The various pragma types */
8#define PragTyp_ACTIVATE_EXTENSIONS 0
9#define PragTyp_ANALYSIS_LIMIT 1
10#define PragTyp_HEADER_VALUE 2
11#define PragTyp_AUTO_VACUUM 3
12#define PragTyp_FLAG 4
13#define PragTyp_BUSY_TIMEOUT 5
14#define PragTyp_CACHE_SIZE 6
15#define PragTyp_CACHE_SPILL 7
16#define PragTyp_CASE_SENSITIVE_LIKE 8
17#define PragTyp_COLLATION_LIST 9
18#define PragTyp_COMPILE_OPTIONS 10
19#define PragTyp_DATA_STORE_DIRECTORY 11
20#define PragTyp_DATABASE_LIST 12
21#define PragTyp_DEFAULT_CACHE_SIZE 13
22#define PragTyp_ENCODING 14
23#define PragTyp_FOREIGN_KEY_CHECK 15
24#define PragTyp_FOREIGN_KEY_LIST 16
25#define PragTyp_FUNCTION_LIST 17
26#define PragTyp_HARD_HEAP_LIMIT 18
27#define PragTyp_INCREMENTAL_VACUUM 19
28#define PragTyp_INDEX_INFO 20
29#define PragTyp_INDEX_LIST 21
30#define PragTyp_INTEGRITY_CHECK 22
31#define PragTyp_JOURNAL_MODE 23
32#define PragTyp_JOURNAL_SIZE_LIMIT 24
33#define PragTyp_LOCK_PROXY_FILE 25
34#define PragTyp_LOCKING_MODE 26
35#define PragTyp_PAGE_COUNT 27
36#define PragTyp_MMAP_SIZE 28
37#define PragTyp_MODULE_LIST 29
38#define PragTyp_OPTIMIZE 30
39#define PragTyp_PAGE_SIZE 31
40#define PragTyp_PRAGMA_LIST 32
41#define PragTyp_SECURE_DELETE 33
42#define PragTyp_SHRINK_MEMORY 34
43#define PragTyp_SOFT_HEAP_LIMIT 35
44#define PragTyp_SYNCHRONOUS 36
45#define PragTyp_TABLE_INFO 37
46#define PragTyp_TABLE_LIST 38
47#define PragTyp_TEMP_STORE 39
48#define PragTyp_TEMP_STORE_DIRECTORY 40
49#define PragTyp_THREADS 41
50#define PragTyp_WAL_AUTOCHECKPOINT 42
51#define PragTyp_WAL_CHECKPOINT 43
52#define PragTyp_LOCK_STATUS 44
53#define PragTyp_STATS 45
54
55/* Property flags associated with various pragma. */
56#define PragFlg_NeedSchema 0x01 /* Force schema load before running */
57#define PragFlg_NoColumns 0x02 /* OP_ResultRow called with zero columns */
58#define PragFlg_NoColumns1 0x04 /* zero columns if RHS argument is present */
59#define PragFlg_ReadOnly 0x08 /* Read-only HEADER_VALUE */
60#define PragFlg_Result0 0x10 /* Acts as query when no argument */
61#define PragFlg_Result1 0x20 /* Acts as query when has one argument */
62#define PragFlg_SchemaOpt 0x40 /* Schema restricts name search if present */
63#define PragFlg_SchemaReq 0x80 /* Schema required - "main" is default */
64
65/* Names of columns for pragmas that return multi-column result
66** or that return single-column results where the name of the
67** result column is different from the name of the pragma
68*/
69static const char *const pragCName[] = {
70 /* 0 */ "id", /* Used by: foreign_key_list */
71 /* 1 */ "seq",
72 /* 2 */ "table",
73 /* 3 */ "from",
74 /* 4 */ "to",
75 /* 5 */ "on_update",
76 /* 6 */ "on_delete",
77 /* 7 */ "match",
78 /* 8 */ "cid", /* Used by: table_xinfo */
79 /* 9 */ "name",
80 /* 10 */ "type",
81 /* 11 */ "notnull",
82 /* 12 */ "dflt_value",
83 /* 13 */ "pk",
84 /* 14 */ "hidden",
85 /* table_info reuses 8 */
86 /* 15 */ "schema", /* Used by: table_list */
87 /* 16 */ "name",
88 /* 17 */ "type",
89 /* 18 */ "ncol",
90 /* 19 */ "wr",
91 /* 20 */ "strict",
92 /* 21 */ "seqno", /* Used by: index_xinfo */
93 /* 22 */ "cid",
94 /* 23 */ "name",
95 /* 24 */ "desc",
96 /* 25 */ "coll",
97 /* 26 */ "key",
98 /* 27 */ "name", /* Used by: function_list */
99 /* 28 */ "builtin",
100 /* 29 */ "type",
101 /* 30 */ "enc",
102 /* 31 */ "narg",
103 /* 32 */ "flags",
104 /* 33 */ "tbl", /* Used by: stats */
105 /* 34 */ "idx",
106 /* 35 */ "wdth",
107 /* 36 */ "hght",
108 /* 37 */ "flgs",
109 /* 38 */ "seq", /* Used by: index_list */
110 /* 39 */ "name",
111 /* 40 */ "unique",
112 /* 41 */ "origin",
113 /* 42 */ "partial",
114 /* 43 */ "table", /* Used by: foreign_key_check */
115 /* 44 */ "rowid",
116 /* 45 */ "parent",
117 /* 46 */ "fkid",
118 /* index_info reuses 21 */
119 /* 47 */ "seq", /* Used by: database_list */
120 /* 48 */ "name",
121 /* 49 */ "file",
122 /* 50 */ "busy", /* Used by: wal_checkpoint */
123 /* 51 */ "log",
124 /* 52 */ "checkpointed",
125 /* collation_list reuses 38 */
126 /* 53 */ "database", /* Used by: lock_status */
127 /* 54 */ "status",
128 /* 55 */ "cache_size", /* Used by: default_cache_size */
129 /* module_list pragma_list reuses 9 */
130 /* 56 */ "timeout", /* Used by: busy_timeout */
131};
132
133/* Definitions of all built-in pragmas */
134typedef struct PragmaName {
135 const char *const zName; /* Name of pragma */
136 u8 ePragTyp; /* PragTyp_XXX value */
137 u8 mPragFlg; /* Zero or more PragFlg_XXX values */
138 u8 iPragCName; /* Start of column names in pragCName[] */
139 u8 nPragCName; /* Num of col names. 0 means use pragma name */
140 u64 iArg; /* Extra argument */
141} PragmaName;
142static const PragmaName aPragmaName[] = {
143#if defined(SQLITE_ENABLE_CEROD)
144 {/* zName: */ "activate_extensions",
145 /* ePragTyp: */ PragTyp_ACTIVATE_EXTENSIONS,
146 /* ePragFlg: */ 0,
147 /* ColNames: */ 0, 0,
148 /* iArg: */ 0 },
149#endif
150 {/* zName: */ "analysis_limit",
151 /* ePragTyp: */ PragTyp_ANALYSIS_LIMIT,
152 /* ePragFlg: */ PragFlg_Result0,
153 /* ColNames: */ 0, 0,
154 /* iArg: */ 0 },
155#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
156 {/* zName: */ "application_id",
157 /* ePragTyp: */ PragTyp_HEADER_VALUE,
158 /* ePragFlg: */ PragFlg_NoColumns1|PragFlg_Result0,
159 /* ColNames: */ 0, 0,
160 /* iArg: */ BTREE_APPLICATION_ID },
161#endif
162#if !defined(SQLITE_OMIT_AUTOVACUUM)
163 {/* zName: */ "auto_vacuum",
164 /* ePragTyp: */ PragTyp_AUTO_VACUUM,
165 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
166 /* ColNames: */ 0, 0,
167 /* iArg: */ 0 },
168#endif
169#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
170#if !defined(SQLITE_OMIT_AUTOMATIC_INDEX)
171 {/* zName: */ "automatic_index",
172 /* ePragTyp: */ PragTyp_FLAG,
173 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
174 /* ColNames: */ 0, 0,
175 /* iArg: */ SQLITE_AutoIndex },
176#endif
177#endif
178 {/* zName: */ "busy_timeout",
179 /* ePragTyp: */ PragTyp_BUSY_TIMEOUT,
180 /* ePragFlg: */ PragFlg_Result0,
181 /* ColNames: */ 56, 1,
182 /* iArg: */ 0 },
183#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
184 {/* zName: */ "cache_size",
185 /* ePragTyp: */ PragTyp_CACHE_SIZE,
186 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
187 /* ColNames: */ 0, 0,
188 /* iArg: */ 0 },
189#endif
190#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
191 {/* zName: */ "cache_spill",
192 /* ePragTyp: */ PragTyp_CACHE_SPILL,
193 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
194 /* ColNames: */ 0, 0,
195 /* iArg: */ 0 },
196#endif
197#if !defined(SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA)
198 {/* zName: */ "case_sensitive_like",
199 /* ePragTyp: */ PragTyp_CASE_SENSITIVE_LIKE,
200 /* ePragFlg: */ PragFlg_NoColumns,
201 /* ColNames: */ 0, 0,
202 /* iArg: */ 0 },
203#endif
204 {/* zName: */ "cell_size_check",
205 /* ePragTyp: */ PragTyp_FLAG,
206 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
207 /* ColNames: */ 0, 0,
208 /* iArg: */ SQLITE_CellSizeCk },
209#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
210 {/* zName: */ "checkpoint_fullfsync",
211 /* ePragTyp: */ PragTyp_FLAG,
212 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
213 /* ColNames: */ 0, 0,
214 /* iArg: */ SQLITE_CkptFullFSync },
215#endif
216#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
217 {/* zName: */ "collation_list",
218 /* ePragTyp: */ PragTyp_COLLATION_LIST,
219 /* ePragFlg: */ PragFlg_Result0,
220 /* ColNames: */ 38, 2,
221 /* iArg: */ 0 },
222#endif
223#if !defined(SQLITE_OMIT_COMPILEOPTION_DIAGS)
224 {/* zName: */ "compile_options",
225 /* ePragTyp: */ PragTyp_COMPILE_OPTIONS,
226 /* ePragFlg: */ PragFlg_Result0,
227 /* ColNames: */ 0, 0,
228 /* iArg: */ 0 },
229#endif
230#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
231 {/* zName: */ "count_changes",
232 /* ePragTyp: */ PragTyp_FLAG,
233 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
234 /* ColNames: */ 0, 0,
235 /* iArg: */ SQLITE_CountRows },
236#endif
237#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_OS_WIN
238 {/* zName: */ "data_store_directory",
239 /* ePragTyp: */ PragTyp_DATA_STORE_DIRECTORY,
240 /* ePragFlg: */ PragFlg_NoColumns1,
241 /* ColNames: */ 0, 0,
242 /* iArg: */ 0 },
243#endif
244#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
245 {/* zName: */ "data_version",
246 /* ePragTyp: */ PragTyp_HEADER_VALUE,
247 /* ePragFlg: */ PragFlg_ReadOnly|PragFlg_Result0,
248 /* ColNames: */ 0, 0,
249 /* iArg: */ BTREE_DATA_VERSION },
250#endif
251#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
252 {/* zName: */ "database_list",
253 /* ePragTyp: */ PragTyp_DATABASE_LIST,
254 /* ePragFlg: */ PragFlg_Result0,
255 /* ColNames: */ 47, 3,
256 /* iArg: */ 0 },
257#endif
258#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && !defined(SQLITE_OMIT_DEPRECATED)
259 {/* zName: */ "default_cache_size",
260 /* ePragTyp: */ PragTyp_DEFAULT_CACHE_SIZE,
261 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
262 /* ColNames: */ 55, 1,
263 /* iArg: */ 0 },
264#endif
265#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
266#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
267 {/* zName: */ "defer_foreign_keys",
268 /* ePragTyp: */ PragTyp_FLAG,
269 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
270 /* ColNames: */ 0, 0,
271 /* iArg: */ SQLITE_DeferFKs },
272#endif
273#endif
274#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
275 {/* zName: */ "empty_result_callbacks",
276 /* ePragTyp: */ PragTyp_FLAG,
277 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
278 /* ColNames: */ 0, 0,
279 /* iArg: */ SQLITE_NullCallback },
280#endif
281#if !defined(SQLITE_OMIT_UTF16)
282 {/* zName: */ "encoding",
283 /* ePragTyp: */ PragTyp_ENCODING,
284 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
285 /* ColNames: */ 0, 0,
286 /* iArg: */ 0 },
287#endif
288#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
289 {/* zName: */ "foreign_key_check",
290 /* ePragTyp: */ PragTyp_FOREIGN_KEY_CHECK,
291 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_Result1|PragFlg_SchemaOpt,
292 /* ColNames: */ 43, 4,
293 /* iArg: */ 0 },
294#endif
295#if !defined(SQLITE_OMIT_FOREIGN_KEY)
296 {/* zName: */ "foreign_key_list",
297 /* ePragTyp: */ PragTyp_FOREIGN_KEY_LIST,
298 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
299 /* ColNames: */ 0, 8,
300 /* iArg: */ 0 },
301#endif
302#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
303#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
304 {/* zName: */ "foreign_keys",
305 /* ePragTyp: */ PragTyp_FLAG,
306 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
307 /* ColNames: */ 0, 0,
308 /* iArg: */ SQLITE_ForeignKeys },
309#endif
310#endif
311#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
312 {/* zName: */ "freelist_count",
313 /* ePragTyp: */ PragTyp_HEADER_VALUE,
314 /* ePragFlg: */ PragFlg_ReadOnly|PragFlg_Result0,
315 /* ColNames: */ 0, 0,
316 /* iArg: */ BTREE_FREE_PAGE_COUNT },
317#endif
318#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
319 {/* zName: */ "full_column_names",
320 /* ePragTyp: */ PragTyp_FLAG,
321 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
322 /* ColNames: */ 0, 0,
323 /* iArg: */ SQLITE_FullColNames },
324 {/* zName: */ "fullfsync",
325 /* ePragTyp: */ PragTyp_FLAG,
326 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
327 /* ColNames: */ 0, 0,
328 /* iArg: */ SQLITE_FullFSync },
329#endif
330#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
331#if !defined(SQLITE_OMIT_INTROSPECTION_PRAGMAS)
332 {/* zName: */ "function_list",
333 /* ePragTyp: */ PragTyp_FUNCTION_LIST,
334 /* ePragFlg: */ PragFlg_Result0,
335 /* ColNames: */ 27, 6,
336 /* iArg: */ 0 },
337#endif
338#endif
339 {/* zName: */ "hard_heap_limit",
340 /* ePragTyp: */ PragTyp_HARD_HEAP_LIMIT,
341 /* ePragFlg: */ PragFlg_Result0,
342 /* ColNames: */ 0, 0,
343 /* iArg: */ 0 },
344#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
345#if !defined(SQLITE_OMIT_CHECK)
346 {/* zName: */ "ignore_check_constraints",
347 /* ePragTyp: */ PragTyp_FLAG,
348 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
349 /* ColNames: */ 0, 0,
350 /* iArg: */ SQLITE_IgnoreChecks },
351#endif
352#endif
353#if !defined(SQLITE_OMIT_AUTOVACUUM)
354 {/* zName: */ "incremental_vacuum",
355 /* ePragTyp: */ PragTyp_INCREMENTAL_VACUUM,
356 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_NoColumns,
357 /* ColNames: */ 0, 0,
358 /* iArg: */ 0 },
359#endif
360#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
361 {/* zName: */ "index_info",
362 /* ePragTyp: */ PragTyp_INDEX_INFO,
363 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
364 /* ColNames: */ 21, 3,
365 /* iArg: */ 0 },
366 {/* zName: */ "index_list",
367 /* ePragTyp: */ PragTyp_INDEX_LIST,
368 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
369 /* ColNames: */ 38, 5,
370 /* iArg: */ 0 },
371 {/* zName: */ "index_xinfo",
372 /* ePragTyp: */ PragTyp_INDEX_INFO,
373 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
374 /* ColNames: */ 21, 6,
375 /* iArg: */ 1 },
376#endif
377#if !defined(SQLITE_OMIT_INTEGRITY_CHECK)
378 {/* zName: */ "integrity_check",
379 /* ePragTyp: */ PragTyp_INTEGRITY_CHECK,
380 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_Result1|PragFlg_SchemaOpt,
381 /* ColNames: */ 0, 0,
382 /* iArg: */ 0 },
383#endif
384#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
385 {/* zName: */ "journal_mode",
386 /* ePragTyp: */ PragTyp_JOURNAL_MODE,
387 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
388 /* ColNames: */ 0, 0,
389 /* iArg: */ 0 },
390 {/* zName: */ "journal_size_limit",
391 /* ePragTyp: */ PragTyp_JOURNAL_SIZE_LIMIT,
392 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
393 /* ColNames: */ 0, 0,
394 /* iArg: */ 0 },
395#endif
396#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
397 {/* zName: */ "legacy_alter_table",
398 /* ePragTyp: */ PragTyp_FLAG,
399 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
400 /* ColNames: */ 0, 0,
401 /* iArg: */ SQLITE_LegacyAlter },
402#endif
403#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_ENABLE_LOCKING_STYLE
404 {/* zName: */ "lock_proxy_file",
405 /* ePragTyp: */ PragTyp_LOCK_PROXY_FILE,
406 /* ePragFlg: */ PragFlg_NoColumns1,
407 /* ColNames: */ 0, 0,
408 /* iArg: */ 0 },
409#endif
410#if defined(SQLITE_DEBUG) || defined(SQLITE_TEST)
411 {/* zName: */ "lock_status",
412 /* ePragTyp: */ PragTyp_LOCK_STATUS,
413 /* ePragFlg: */ PragFlg_Result0,
414 /* ColNames: */ 53, 2,
415 /* iArg: */ 0 },
416#endif
417#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
418 {/* zName: */ "locking_mode",
419 /* ePragTyp: */ PragTyp_LOCKING_MODE,
420 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
421 /* ColNames: */ 0, 0,
422 /* iArg: */ 0 },
423 {/* zName: */ "max_page_count",
424 /* ePragTyp: */ PragTyp_PAGE_COUNT,
425 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
426 /* ColNames: */ 0, 0,
427 /* iArg: */ 0 },
428 {/* zName: */ "mmap_size",
429 /* ePragTyp: */ PragTyp_MMAP_SIZE,
430 /* ePragFlg: */ 0,
431 /* ColNames: */ 0, 0,
432 /* iArg: */ 0 },
433#endif
434#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
435#if !defined(SQLITE_OMIT_VIRTUALTABLE)
436#if !defined(SQLITE_OMIT_INTROSPECTION_PRAGMAS)
437 {/* zName: */ "module_list",
438 /* ePragTyp: */ PragTyp_MODULE_LIST,
439 /* ePragFlg: */ PragFlg_Result0,
440 /* ColNames: */ 9, 1,
441 /* iArg: */ 0 },
442#endif
443#endif
444#endif
445 {/* zName: */ "optimize",
446 /* ePragTyp: */ PragTyp_OPTIMIZE,
447 /* ePragFlg: */ PragFlg_Result1|PragFlg_NeedSchema,
448 /* ColNames: */ 0, 0,
449 /* iArg: */ 0 },
450#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
451 {/* zName: */ "page_count",
452 /* ePragTyp: */ PragTyp_PAGE_COUNT,
453 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
454 /* ColNames: */ 0, 0,
455 /* iArg: */ 0 },
456 {/* zName: */ "page_size",
457 /* ePragTyp: */ PragTyp_PAGE_SIZE,
458 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
459 /* ColNames: */ 0, 0,
460 /* iArg: */ 0 },
461#endif
462#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
463#if defined(SQLITE_DEBUG)
464 {/* zName: */ "parser_trace",
465 /* ePragTyp: */ PragTyp_FLAG,
466 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
467 /* ColNames: */ 0, 0,
468 /* iArg: */ SQLITE_ParserTrace },
469#endif
470#endif
471#if !defined(SQLITE_OMIT_INTROSPECTION_PRAGMAS)
472 {/* zName: */ "pragma_list",
473 /* ePragTyp: */ PragTyp_PRAGMA_LIST,
474 /* ePragFlg: */ PragFlg_Result0,
475 /* ColNames: */ 9, 1,
476 /* iArg: */ 0 },
477#endif
478#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
479 {/* zName: */ "query_only",
480 /* ePragTyp: */ PragTyp_FLAG,
481 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
482 /* ColNames: */ 0, 0,
483 /* iArg: */ SQLITE_QueryOnly },
484#endif
485#if !defined(SQLITE_OMIT_INTEGRITY_CHECK)
486 {/* zName: */ "quick_check",
487 /* ePragTyp: */ PragTyp_INTEGRITY_CHECK,
488 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_Result1|PragFlg_SchemaOpt,
489 /* ColNames: */ 0, 0,
490 /* iArg: */ 0 },
491#endif
492#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
493 {/* zName: */ "read_uncommitted",
494 /* ePragTyp: */ PragTyp_FLAG,
495 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
496 /* ColNames: */ 0, 0,
497 /* iArg: */ SQLITE_ReadUncommit },
498 {/* zName: */ "recursive_triggers",
499 /* ePragTyp: */ PragTyp_FLAG,
500 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
501 /* ColNames: */ 0, 0,
502 /* iArg: */ SQLITE_RecTriggers },
503 {/* zName: */ "reverse_unordered_selects",
504 /* ePragTyp: */ PragTyp_FLAG,
505 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
506 /* ColNames: */ 0, 0,
507 /* iArg: */ SQLITE_ReverseOrder },
508#endif
509#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
510 {/* zName: */ "schema_version",
511 /* ePragTyp: */ PragTyp_HEADER_VALUE,
512 /* ePragFlg: */ PragFlg_NoColumns1|PragFlg_Result0,
513 /* ColNames: */ 0, 0,
514 /* iArg: */ BTREE_SCHEMA_VERSION },
515#endif
516#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
517 {/* zName: */ "secure_delete",
518 /* ePragTyp: */ PragTyp_SECURE_DELETE,
519 /* ePragFlg: */ PragFlg_Result0,
520 /* ColNames: */ 0, 0,
521 /* iArg: */ 0 },
522#endif
523#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
524 {/* zName: */ "short_column_names",
525 /* ePragTyp: */ PragTyp_FLAG,
526 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
527 /* ColNames: */ 0, 0,
528 /* iArg: */ SQLITE_ShortColNames },
529#endif
530 {/* zName: */ "shrink_memory",
531 /* ePragTyp: */ PragTyp_SHRINK_MEMORY,
532 /* ePragFlg: */ PragFlg_NoColumns,
533 /* ColNames: */ 0, 0,
534 /* iArg: */ 0 },
535 {/* zName: */ "soft_heap_limit",
536 /* ePragTyp: */ PragTyp_SOFT_HEAP_LIMIT,
537 /* ePragFlg: */ PragFlg_Result0,
538 /* ColNames: */ 0, 0,
539 /* iArg: */ 0 },
540#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
541#if defined(SQLITE_DEBUG)
542 {/* zName: */ "sql_trace",
543 /* ePragTyp: */ PragTyp_FLAG,
544 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
545 /* ColNames: */ 0, 0,
546 /* iArg: */ SQLITE_SqlTrace },
547#endif
548#endif
549#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS) && defined(SQLITE_DEBUG)
550 {/* zName: */ "stats",
551 /* ePragTyp: */ PragTyp_STATS,
552 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
553 /* ColNames: */ 33, 5,
554 /* iArg: */ 0 },
555#endif
556#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
557 {/* zName: */ "synchronous",
558 /* ePragTyp: */ PragTyp_SYNCHRONOUS,
559 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
560 /* ColNames: */ 0, 0,
561 /* iArg: */ 0 },
562#endif
563#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
564 {/* zName: */ "table_info",
565 /* ePragTyp: */ PragTyp_TABLE_INFO,
566 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
567 /* ColNames: */ 8, 6,
568 /* iArg: */ 0 },
569 {/* zName: */ "table_list",
570 /* ePragTyp: */ PragTyp_TABLE_LIST,
571 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1,
572 /* ColNames: */ 15, 6,
573 /* iArg: */ 0 },
574 {/* zName: */ "table_xinfo",
575 /* ePragTyp: */ PragTyp_TABLE_INFO,
576 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
577 /* ColNames: */ 8, 7,
578 /* iArg: */ 1 },
579#endif
580#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
581 {/* zName: */ "temp_store",
582 /* ePragTyp: */ PragTyp_TEMP_STORE,
583 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
584 /* ColNames: */ 0, 0,
585 /* iArg: */ 0 },
586 {/* zName: */ "temp_store_directory",
587 /* ePragTyp: */ PragTyp_TEMP_STORE_DIRECTORY,
588 /* ePragFlg: */ PragFlg_NoColumns1,
589 /* ColNames: */ 0, 0,
590 /* iArg: */ 0 },
591#endif
592 {/* zName: */ "threads",
593 /* ePragTyp: */ PragTyp_THREADS,
594 /* ePragFlg: */ PragFlg_Result0,
595 /* ColNames: */ 0, 0,
596 /* iArg: */ 0 },
597#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
598 {/* zName: */ "trusted_schema",
599 /* ePragTyp: */ PragTyp_FLAG,
600 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
601 /* ColNames: */ 0, 0,
602 /* iArg: */ SQLITE_TrustedSchema },
603#endif
604#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
605 {/* zName: */ "user_version",
606 /* ePragTyp: */ PragTyp_HEADER_VALUE,
607 /* ePragFlg: */ PragFlg_NoColumns1|PragFlg_Result0,
608 /* ColNames: */ 0, 0,
609 /* iArg: */ BTREE_USER_VERSION },
610#endif
611#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
612#if defined(SQLITE_DEBUG)
613 {/* zName: */ "vdbe_addoptrace",
614 /* ePragTyp: */ PragTyp_FLAG,
615 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
616 /* ColNames: */ 0, 0,
617 /* iArg: */ SQLITE_VdbeAddopTrace },
618 {/* zName: */ "vdbe_debug",
619 /* ePragTyp: */ PragTyp_FLAG,
620 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
621 /* ColNames: */ 0, 0,
622 /* iArg: */ SQLITE_SqlTrace|SQLITE_VdbeListing|SQLITE_VdbeTrace },
623 {/* zName: */ "vdbe_eqp",
624 /* ePragTyp: */ PragTyp_FLAG,
625 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
626 /* ColNames: */ 0, 0,
627 /* iArg: */ SQLITE_VdbeEQP },
628 {/* zName: */ "vdbe_listing",
629 /* ePragTyp: */ PragTyp_FLAG,
630 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
631 /* ColNames: */ 0, 0,
632 /* iArg: */ SQLITE_VdbeListing },
633 {/* zName: */ "vdbe_trace",
634 /* ePragTyp: */ PragTyp_FLAG,
635 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
636 /* ColNames: */ 0, 0,
637 /* iArg: */ SQLITE_VdbeTrace },
638#endif
639#endif
640#if !defined(SQLITE_OMIT_WAL)
641 {/* zName: */ "wal_autocheckpoint",
642 /* ePragTyp: */ PragTyp_WAL_AUTOCHECKPOINT,
643 /* ePragFlg: */ 0,
644 /* ColNames: */ 0, 0,
645 /* iArg: */ 0 },
646 {/* zName: */ "wal_checkpoint",
647 /* ePragTyp: */ PragTyp_WAL_CHECKPOINT,
648 /* ePragFlg: */ PragFlg_NeedSchema,
649 /* ColNames: */ 50, 3,
650 /* iArg: */ 0 },
651#endif
652#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
653 {/* zName: */ "writable_schema",
654 /* ePragTyp: */ PragTyp_FLAG,
655 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
656 /* ColNames: */ 0, 0,
657 /* iArg: */ SQLITE_WriteSchema|SQLITE_NoSchemaError },
658#endif
659};
660/* Number of pragmas: 68 on by default, 78 total. */
661