summaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_purse_merge.sql
diff options
context:
space:
mode:
authorChristian Grothoff <grothoff@gnunet.org>2023-10-17 11:10:34 +0200
committerChristian Grothoff <grothoff@gnunet.org>2023-10-17 11:10:34 +0200
commitf2a28c54cc05082acc02784e5e5e401ee6848413 (patch)
treeee1383b1ef9e4e5d811737f4f254d635693f6f00 /src/exchangedb/exchange_do_purse_merge.sql
parentc741c1fa718e144548b5508e85e469ec93f73b54 (diff)
downloadexchange-f2a28c54cc05082acc02784e5e5e401ee6848413.tar.gz
exchange-f2a28c54cc05082acc02784e5e5e401ee6848413.tar.bz2
exchange-f2a28c54cc05082acc02784e5e5e401ee6848413.zip
kill another dead index, beautify SQL
Diffstat (limited to 'src/exchangedb/exchange_do_purse_merge.sql')
-rw-r--r--src/exchangedb/exchange_do_purse_merge.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/src/exchangedb/exchange_do_purse_merge.sql b/src/exchangedb/exchange_do_purse_merge.sql
index 7f8af9ed7..946fd7e97 100644
--- a/src/exchangedb/exchange_do_purse_merge.sql
+++ b/src/exchangedb/exchange_do_purse_merge.sql
@@ -104,7 +104,7 @@ my_in_reserve_quota := rval.in_reserve_quota;
out_no_balance=FALSE;
-- Store purse merge signature, checks for purse_pub uniqueness
-INSERT INTO exchange.purse_merges
+INSERT INTO purse_merges
(partner_serial_id
,reserve_pub
,purse_pub
@@ -124,7 +124,7 @@ THEN
-- Note that by checking 'merge_sig', we implicitly check
-- identity over everything that the signature covers.
PERFORM
- FROM exchange.purse_merges
+ FROM purse_merges
WHERE purse_pub=in_purse_pub
AND merge_sig=in_merge_sig;
IF NOT FOUND
@@ -169,13 +169,13 @@ THEN
SET purses_active=purses_active-1
WHERE reserve_pub IN
(SELECT reserve_pub
- FROM exchange.purse_merges
+ FROM purse_merges
WHERE purse_pub=my_purse_pub
LIMIT 1);
END IF;
-- Store account merge signature.
-INSERT INTO exchange.account_merges
+INSERT INTO account_merges
(reserve_pub
,reserve_sig
,purse_pub