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_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 */
  69 static 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 */
 134 typedef 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;
 142 static 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. */