exchange

commit c6d7c6adb2075422087f8f6b1159f28a00bab276
parent aa563f3e4a6c5fb2a458b12a97dc130002ea3457
Author: Fournier Nicolas <nicolas.fournier@ensta-paristech.fr>
Date:   Fri, 31 Jul 2015 15:06:07 +0200

added index for deposits table

Diffstat:
M
src/mintdb/plugin_mintdb_postgres.c
 | 
3
+++

1 file changed, 3 insertions(+), 0 deletions(-)
diff --git a/src/mintdb/plugin_mintdb_postgres.c b/src/mintdb/plugin_mintdb_postgres.c
@@ -404,6 +404,9 @@ postgres_create_tables (void *cls,
           ",coin_sig BYTEA NOT NULL CHECK (LENGTH(coin_sig)=64)"
           ",wire TEXT NOT NULL"
           ")");
+  /* Index for get_deposit statement on coin_pub, transactiojn_id and merchant_pub */
+  SQLEXEC_INDEX("CREATE INDEX deposits_coin_pub_index "
+                "ON deposits(coin_pub, transaction_id, merchant_pub)");
 #undef SQLEXEC
 #undef SQLEXEC_INDEX