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