src/pragma.h

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