commit a4b9be0cd05b50cf3f817b6b4c4ea41c5714dc00 parent d02ea7d66bb7dd5d82145d5888cb7877273a9d1b Author: Christian Grothoff <christian@grothoff.org> Date: Sat, 7 Feb 2026 18:26:08 +0100 expand merchant_exchange_keys table for better error reporting Diffstat:
| M | src/backenddb/Makefile.am | | | 1 | + |
| M | src/backenddb/merchant-0030.sql | | | 10 | ++++++++++ |
2 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/src/backenddb/Makefile.am b/src/backenddb/Makefile.am @@ -46,6 +46,7 @@ sql_DATA = \ merchant-0027.sql \ merchant-0028.sql \ merchant-0029.sql \ + merchant-0030.sql \ drop.sql BUILT_SOURCES = \ diff --git a/src/backenddb/merchant-0030.sql b/src/backenddb/merchant-0030.sql @@ -47,4 +47,14 @@ CREATE INDEX merchant_unclaim_signatures_by_expiration COMMENT ON INDEX merchant_unclaim_signatures_by_expiration IS 'For garbage collection of unclaim signatrues after payment deadlines have been passed.'; + +ALTER TABLE merchant_exchange_keys + ADD COLUMN exchange_http_status INT4 DEFAULT(0) + ,ADD COLUMN exchange_ec_code INT4 DEFAULT(0); + +COMMENT ON COLUMN merchant_exchange_keys.exchange_http_status + IS 'Last HTTP status code from trying to fetch /keys; 0 for timeout or not attempted yet'; +COMMENT ON COLUMN merchant_exchange_keys.exchange_ec_code + IS 'Error code from our last attempt to fetch /keys; 0 for no error in combination with an HTTP status of 200'; + COMMIT;