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