diff options
author | Christian Grothoff <christian@grothoff.org> | 2020-04-30 00:25:17 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2020-04-30 00:25:17 +0200 |
commit | f5c484e625cde6b6822ea75c20cecf8f4db7c54d (patch) | |
tree | ca954d04bfca85d91198024e1f7cf59e5d0d421f /src/backenddb/merchant-0001.sql | |
parent | ce97f3d2e12b4da31eb0f611d401f56ce8052de5 (diff) | |
download | merchant-f5c484e625cde6b6822ea75c20cecf8f4db7c54d.tar.gz merchant-f5c484e625cde6b6822ea75c20cecf8f4db7c54d.tar.bz2 merchant-f5c484e625cde6b6822ea75c20cecf8f4db7c54d.zip |
sql-ing
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
-rw-r--r-- | src/backenddb/merchant-0001.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index 0682da96..77c79052 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -61,7 +61,7 @@ COMMENT ON COLUMN merchant_exchange_signing_keys.master_pub CREATE TABLE IF NOT EXISTS merchant_instances (merchant_serial BIGSERIAL PRIMARY KEY ,merchant_pub BYTEA NOT NULL UNIQUE CHECK (LENGTH(merchant_pub)=32) - ,merchant_id VARCHAR NOT NULL + ,merchant_id VARCHAR NOT NULL UNIQUE ,merchant_name VARCHAR NOT NULL ,address BYTEA NOT NULL ,jurisdiction BYTEA NOT NULL @@ -279,6 +279,7 @@ CREATE TABLE IF NOT EXISTS merchant_deposits (deposit_serial BIGSERIAL PRIMARY KEY ,order_serial BIGINT REFERENCES merchant_contract_terms (order_serial) ON DELETE CASCADE + ,deposit_timestamp INT8 NOT NULL ,coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32) ,exchange_url VARCHAR NOT NULL ,amount_with_fee_val INT8 NOT NULL @@ -292,7 +293,6 @@ CREATE TABLE IF NOT EXISTS merchant_deposits ,signkey_serial BIGINT NOT NULL REFERENCES merchant_exchange_signing_keys (signkey_serial) ON DELETE CASCADE ,exchange_sig BYTEA NOT NULL CHECK (LENGTH(exchange_sig)=64) - ,exchange_timestamp INT8 NOT NULL ,account_serial BIGINT NOT NULL REFERENCES merchant_accounts (account_serial) ON DELETE CASCADE ,UNIQUE (order_serial, coin_pub) @@ -301,6 +301,8 @@ COMMENT ON TABLE merchant_deposits IS 'Table with the deposit confirmations for each coin we deposited at the exchange'; COMMENT ON COLUMN merchant_deposits.signkey_serial IS 'Online signing key of the exchange on the deposit confirmation'; +COMMENT ON COLUMN merchant_deposits.deposit_timestamp + IS 'Time when we received the deposit confirmation from the exchange (not rounded)'; COMMENT ON COLUMN merchant_deposits.exchange_sig IS 'Signature of the exchange over the deposit confirmation'; COMMENT ON COLUMN merchant_deposits.wire_fee_val |