summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/mintdb/plugin_mintdb_postgres.c4
1 files changed, 3 insertions, 1 deletions
diff --git a/src/mintdb/plugin_mintdb_postgres.c b/src/mintdb/plugin_mintdb_postgres.c
index 163420b2e..16330e04a 100644
--- a/src/mintdb/plugin_mintdb_postgres.c
+++ b/src/mintdb/plugin_mintdb_postgres.c
@@ -287,7 +287,9 @@ postgres_create_tables (void *cls,
");");
/* Index blindcoins(reserve_pub) for get_reserves_out statement */
SQLEXEC_INDEX ("CREATE INDEX reserves_out_reserve_pub_index ON"
- " reserves_out (reserve_pub)");
+ " reserves_out (reserve_pub)");
+ SQLEXEC_INDEX ("CREATE INDEX reserves_out_h_blind_ev_index ON "
+ "reserves_out (h_blind_ev)");
/* Table with coins that have been (partially) spent, used to track
coin information only once.
TODO: maybe eliminate, this might be over-normalization (#3811) */