diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2022-03-24 13:06:04 +0100 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2022-03-24 13:06:04 +0100 |
commit | c782dfe2aadfd06e47ed354c1fb389fecc715433 (patch) | |
tree | a6acef08f5e15db421c20daf8ca0d1b35a581a21 /src/exchangedb/exchange-0001.sql | |
parent | 6ffc2c68a3af1a4321a8fcc7c1147b4967fabd68 (diff) | |
download | exchange-c782dfe2aadfd06e47ed354c1fb389fecc715433.tar.xz |
first draft of service API for p2p payments
Diffstat (limited to 'src/exchangedb/exchange-0001.sql')
-rw-r--r-- | src/exchangedb/exchange-0001.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql index 5acb8995b..e723a3677 100644 --- a/src/exchangedb/exchange-0001.sql +++ b/src/exchangedb/exchange-0001.sql @@ -1540,6 +1540,7 @@ COMMENT ON COLUMN close_requests.close_val CREATE TABLE IF NOT EXISTS purse_deposits (purse_deposit_serial_id BIGSERIAL UNIQUE + ,partner_serial_id INT8 REFERENCES partners(partner_serial_id) ON DELETE CASCADE ,purse_pub BYTEA NOT NULL CHECK (LENGTH(purse_pub)=32) ,coin_pub BYTEA NOT NULL REFERENCES known_coins (coin_pub) ON DELETE CASCADE ,amount_with_fee_val INT8 NOT NULL @@ -1549,6 +1550,8 @@ CREATE TABLE IF NOT EXISTS purse_deposits ); -- partition by purse_pub, plus a materialized index by coin_pub! COMMENT ON TABLE purse_deposits IS 'Requests depositing coins into a purse'; +COMMENT ON COLUMN purse_deposits.partner_serial_id + IS 'identifies the partner exchange, NULL in case the target purse lives at this exchange'; COMMENT ON COLUMN purse_deposits.purse_pub IS 'Public key of the purse'; COMMENT ON COLUMN purse_deposits.coin_pub |