diff options
author | Christian Grothoff <christian@grothoff.org> | 2020-05-02 17:52:13 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2020-05-02 17:52:13 +0200 |
commit | 74c5fa81d74ff5d239f49f74b2bb937c03b83bcb (patch) | |
tree | 18f69732b52bc6df4fac0a740f561f8bcfcfe5fd /src/backenddb/merchant-0001.sql | |
parent | dcc083c0959d395bcd4bcf9aee276eb96ea76dee (diff) | |
download | merchant-74c5fa81d74ff5d239f49f74b2bb937c03b83bcb.tar.gz merchant-74c5fa81d74ff5d239f49f74b2bb937c03b83bcb.tar.bz2 merchant-74c5fa81d74ff5d239f49f74b2bb937c03b83bcb.zip |
work on refund
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
-rw-r--r-- | src/backenddb/merchant-0001.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index 77c79052..e54e4781 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -323,6 +323,9 @@ COMMENT ON TABLE merchant_deposits IS 'Refunds approved by the merchant (backoffice) logic, excludes abort refunds'; COMMENT ON COLUMN merchant_refunds.rtransaction_id IS 'Needed for uniqueness in case a refund is increased for the same order'; +CREATE INDEX IF NOT EXISTS merchant_refunds_by_coin_and_order + ON merchant_refunds + (coin_pub,order_serial); CREATE TABLE IF NOT EXISTS merchant_refund_proofs (refund_serial BIGINT PRIMARY KEY |