AryaWu/sqlite
0
1/* DO NOT EDIT!2** This file is automatically generated by the script at3** ../tool/mkpragmatab.tcl. To update the set of pragmas, edit4** that script and rerun it.5*/6 7/* The various pragma types */8#define PragTyp_ACTIVATE_EXTENSIONS 09#define PragTyp_ANALYSIS_LIMIT 110#define PragTyp_HEADER_VALUE 211#define PragTyp_AUTO_VACUUM 312#define PragTyp_FLAG 413#define PragTyp_BUSY_TIMEOUT 514#define PragTyp_CACHE_SIZE 615#define PragTyp_CACHE_SPILL 716#define PragTyp_CASE_SENSITIVE_LIKE 817#define PragTyp_COLLATION_LIST 918#define PragTyp_COMPILE_OPTIONS 1019#define PragTyp_DATA_STORE_DIRECTORY 1120#define PragTyp_DATABASE_LIST 1221#define PragTyp_DEFAULT_CACHE_SIZE 1322#define PragTyp_ENCODING 1423#define PragTyp_FOREIGN_KEY_CHECK 1524#define PragTyp_FOREIGN_KEY_LIST 1625#define PragTyp_FUNCTION_LIST 1726#define PragTyp_HARD_HEAP_LIMIT 1827#define PragTyp_INCREMENTAL_VACUUM 1928#define PragTyp_INDEX_INFO 2029#define PragTyp_INDEX_LIST 2130#define PragTyp_INTEGRITY_CHECK 2231#define PragTyp_JOURNAL_MODE 2332#define PragTyp_JOURNAL_SIZE_LIMIT 2433#define PragTyp_LOCK_PROXY_FILE 2534#define PragTyp_LOCKING_MODE 2635#define PragTyp_PAGE_COUNT 2736#define PragTyp_MMAP_SIZE 2837#define PragTyp_MODULE_LIST 2938#define PragTyp_OPTIMIZE 3039#define PragTyp_PAGE_SIZE 3140#define PragTyp_PRAGMA_LIST 3241#define PragTyp_SECURE_DELETE 3342#define PragTyp_SHRINK_MEMORY 3443#define PragTyp_SOFT_HEAP_LIMIT 3544#define PragTyp_SYNCHRONOUS 3645#define PragTyp_TABLE_INFO 3746#define PragTyp_TABLE_LIST 3847#define PragTyp_TEMP_STORE 3948#define PragTyp_TEMP_STORE_DIRECTORY 4049#define PragTyp_THREADS 4150#define PragTyp_WAL_AUTOCHECKPOINT 4251#define PragTyp_WAL_CHECKPOINT 4352#define PragTyp_LOCK_STATUS 4453#define PragTyp_STATS 4554 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 result66** or that return single-column results where the name of the67** result column is different from the name of the pragma68*/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 */ "name", /* Used by: function_list */87 /* 16 */ "builtin", 88 /* 17 */ "type", 89 /* 18 */ "enc", 90 /* 19 */ "narg", 91 /* 20 */ "flags", 92 /* 21 */ "schema", /* Used by: table_list */93 /* 22 */ "name", 94 /* 23 */ "type", 95 /* 24 */ "ncol", 96 /* 25 */ "wr", 97 /* 26 */ "strict", 98 /* 27 */ "seqno", /* Used by: index_xinfo */99 /* 28 */ "cid", 100 /* 29 */ "name", 101 /* 30 */ "desc", 102 /* 31 */ "coll", 103 /* 32 */ "key", 104 /* 33 */ "seq", /* Used by: index_list */105 /* 34 */ "name", 106 /* 35 */ "unique", 107 /* 36 */ "origin", 108 /* 37 */ "partial", 109 /* 38 */ "tbl", /* Used by: stats */110 /* 39 */ "idx", 111 /* 40 */ "wdth", 112 /* 41 */ "hght", 113 /* 42 */ "flgs", 114 /* 43 */ "table", /* Used by: foreign_key_check */115 /* 44 */ "rowid", 116 /* 45 */ "parent", 117 /* 46 */ "fkid", 118 /* 47 */ "busy", /* Used by: wal_checkpoint */119 /* 48 */ "log", 120 /* 49 */ "checkpointed",121 /* 50 */ "seq", /* Used by: database_list */122 /* 51 */ "name", 123 /* 52 */ "file", 124 /* index_info reuses 27 */125 /* 53 */ "database", /* Used by: lock_status */126 /* 54 */ "status", 127 /* collation_list reuses 33 */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#endif150 {/* 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#endif162#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#endif169#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#endif177#endif178 {/* 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#endif190#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#endif197#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#endif204 {/* 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#endif216#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)217 {/* zName: */ "collation_list",218 /* ePragTyp: */ PragTyp_COLLATION_LIST,219 /* ePragFlg: */ PragFlg_Result0,220 /* ColNames: */ 33, 2,221 /* iArg: */ 0 },222#endif223#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#endif230#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#endif237#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_OS_WIN238 {/* zName: */ "data_store_directory",239 /* ePragTyp: */ PragTyp_DATA_STORE_DIRECTORY,240 /* ePragFlg: */ PragFlg_NoColumns1,241 /* ColNames: */ 0, 0,242 /* iArg: */ 0 },243#endif244#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#endif251#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)252 {/* zName: */ "database_list",253 /* ePragTyp: */ PragTyp_DATABASE_LIST,254 /* ePragFlg: */ PragFlg_Result0,255 /* ColNames: */ 50, 3,256 /* iArg: */ 0 },257#endif258#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#endif265#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#endif273#endif274#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#endif281#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#endif288#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#endif295#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#endif302#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#endif310#endif311#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#endif318#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#endif330#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: */ 15, 6,336 /* iArg: */ 0 },337#endif338#endif339 {/* 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#endif352#endif353#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#endif360#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: */ 27, 3,365 /* iArg: */ 0 },366 {/* zName: */ "index_list",367 /* ePragTyp: */ PragTyp_INDEX_LIST,368 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,369 /* ColNames: */ 33, 5,370 /* iArg: */ 0 },371 {/* zName: */ "index_xinfo",372 /* ePragTyp: */ PragTyp_INDEX_INFO,373 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,374 /* ColNames: */ 27, 6,375 /* iArg: */ 1 },376#endif377#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#endif384#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#endif396#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#endif403#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_ENABLE_LOCKING_STYLE404 {/* zName: */ "lock_proxy_file",405 /* ePragTyp: */ PragTyp_LOCK_PROXY_FILE,406 /* ePragFlg: */ PragFlg_NoColumns1,407 /* ColNames: */ 0, 0,408 /* iArg: */ 0 },409#endif410#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#endif417#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#endif434#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#endif443#endif444#endif445 {/* 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#endif462#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#endif470#endif471#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#endif478#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#endif485#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#endif492#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#endif509#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#endif516#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#endif523#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#endif530 {/* 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#endif548#endif549#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: */ 38, 5,554 /* iArg: */ 0 },555#endif556#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#endif563#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: */ 21, 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#endif580#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#endif592 {/* 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#endif604#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#endif611#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#endif639#endif640#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: */ 47, 3,650 /* iArg: */ 0 },651#endif652#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#endif659};660/* Number of pragmas: 68 on by default, 78 total. */661