summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2021-11-06 19:46:00 +0100
committerChristian Grothoff <christian@grothoff.org>2021-11-06 19:46:00 +0100
commitbae7ddbf4efbcbafe00cd61da20a1ff905028f8b (patch)
tree20e6b4a15eb78fbdb9955934f7767540547e69d2
parent9d6e1040669435dfa2ab93abd4f1669c7bf90871 (diff)
downloadexchange-bae7ddbf4efbcbafe00cd61da20a1ff905028f8b.tar.gz
exchange-bae7ddbf4efbcbafe00cd61da20a1ff905028f8b.tar.bz2
exchange-bae7ddbf4efbcbafe00cd61da20a1ff905028f8b.zip
sql fix
-rw-r--r--src/exchangedb/exchange-0001.sql7
1 files changed, 5 insertions, 2 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql
index 692a9ce6f..379d4c1f7 100644
--- a/src/exchangedb/exchange-0001.sql
+++ b/src/exchangedb/exchange-0001.sql
@@ -366,6 +366,9 @@ CREATE TABLE IF NOT EXISTS extension_details
,extension_options VARCHAR);
COMMENT ON TABLE extension_details
IS 'Extensions that were provided with deposits (not yet used).';
+COMMENT ON COLUMN extension_details.extension_options
+ IS 'JSON object with options set that the exchange needs to consider when executing a deposit. Supported details depend on the extensions supported by the exchange.';
+
CREATE TABLE IF NOT EXISTS deposits
(deposit_serial_id BIGSERIAL PRIMARY KEY
@@ -399,8 +402,8 @@ COMMENT ON COLUMN deposits.done
IS 'Set to TRUE once we have included this deposit in some aggregate wire transfer to the merchant';
COMMENT ON COLUMN deposits.extension_blocked
IS 'True if the aggregation of the deposit is currently blocked by some extension mechanism. Used to filter out deposits that must not be processed by the canonical deposit logic.';
-COMMENT ON COLUMN deposits.extension_options
- IS 'JSON object with options set that the exchange needs to consider when executing the deposit. Supported details depend on the extensions supported by the exchange.';
+COMMENT ON COLUMN deposits.extension_details_serial_id
+ IS 'References extensions table, NULL if extensions are not used';
COMMENT ON COLUMN deposits.tiny
IS 'Set to TRUE if we decided that the amount is too small to ever trigger a wire transfer by itself (requires real aggregation)';