diff options
Diffstat (limited to 'src/datastore/plugin_datastore_sqlite.c')
-rw-r--r-- | src/datastore/plugin_datastore_sqlite.c | 18 |
1 files changed, 1 insertions, 17 deletions
diff --git a/src/datastore/plugin_datastore_sqlite.c b/src/datastore/plugin_datastore_sqlite.c index 2d539cb19..cc56f5959 100644 --- a/src/datastore/plugin_datastore_sqlite.c +++ b/src/datastore/plugin_datastore_sqlite.c | |||
@@ -355,40 +355,24 @@ database_setup (const struct GNUNET_CONFIGURATION_Handle *cfg, | |||
355 | (SQLITE_OK != | 355 | (SQLITE_OK != |
356 | sq_prepare (plugin->dbh, | 356 | sq_prepare (plugin->dbh, |
357 | "SELECT " RESULT_COLUMNS " FROM gn091 " | 357 | "SELECT " RESULT_COLUMNS " FROM gn091 " |
358 | #if SQLITE_VERSION_NUMBER >= 3007000 | ||
359 | "INDEXED BY idx_repl_rvalue " | ||
360 | #endif | ||
361 | "WHERE repl=?2 AND " " (rvalue>=?1 OR " | 358 | "WHERE repl=?2 AND " " (rvalue>=?1 OR " |
362 | " NOT EXISTS (SELECT 1 FROM gn091 " | 359 | " NOT EXISTS (SELECT 1 FROM gn091 " |
363 | #if SQLITE_VERSION_NUMBER >= 3007000 | ||
364 | "INDEXED BY idx_repl_rvalue " | ||
365 | #endif | ||
366 | "WHERE repl=?2 AND rvalue>=?1 LIMIT 1) ) " | 360 | "WHERE repl=?2 AND rvalue>=?1 LIMIT 1) ) " |
367 | "ORDER BY rvalue ASC LIMIT 1", | 361 | "ORDER BY rvalue ASC LIMIT 1", |
368 | &plugin->selRepl)) || | 362 | &plugin->selRepl)) || |
369 | (SQLITE_OK != | 363 | (SQLITE_OK != |
370 | sq_prepare (plugin->dbh, | 364 | sq_prepare (plugin->dbh, |
371 | "SELECT MAX(repl) FROM gn091" | 365 | "SELECT MAX(repl) FROM gn091", |
372 | #if SQLITE_VERSION_NUMBER >= 3007000 | ||
373 | " INDEXED BY idx_repl_rvalue" | ||
374 | #endif | ||
375 | "", | ||
376 | &plugin->maxRepl)) || | 366 | &plugin->maxRepl)) || |
377 | (SQLITE_OK != | 367 | (SQLITE_OK != |
378 | sq_prepare (plugin->dbh, | 368 | sq_prepare (plugin->dbh, |
379 | "SELECT " RESULT_COLUMNS " FROM gn091 " | 369 | "SELECT " RESULT_COLUMNS " FROM gn091 " |
380 | #if SQLITE_VERSION_NUMBER >= 3007000 | ||
381 | "INDEXED BY idx_expire " | ||
382 | #endif | ||
383 | "WHERE NOT EXISTS (SELECT 1 FROM gn091 WHERE expire < ?1 LIMIT 1) OR (expire < ?1) " | 370 | "WHERE NOT EXISTS (SELECT 1 FROM gn091 WHERE expire < ?1 LIMIT 1) OR (expire < ?1) " |
384 | "ORDER BY expire ASC LIMIT 1", | 371 | "ORDER BY expire ASC LIMIT 1", |
385 | &plugin->selExpi)) || | 372 | &plugin->selExpi)) || |
386 | (SQLITE_OK != | 373 | (SQLITE_OK != |
387 | sq_prepare (plugin->dbh, | 374 | sq_prepare (plugin->dbh, |
388 | "SELECT " RESULT_COLUMNS " FROM gn091 " | 375 | "SELECT " RESULT_COLUMNS " FROM gn091 " |
389 | #if SQLITE_VERSION_NUMBER >= 3007000 | ||
390 | "INDEXED BY idx_anon_type " | ||
391 | #endif | ||
392 | "WHERE _ROWID_ >= ? AND " | 376 | "WHERE _ROWID_ >= ? AND " |
393 | "anonLevel = 0 AND " | 377 | "anonLevel = 0 AND " |
394 | "type = ? " | 378 | "type = ? " |