diff options
Diffstat (limited to 'src/backenddb/merchant-0010.sql')
| -rw-r--r-- | src/backenddb/merchant-0010.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/backenddb/merchant-0010.sql b/src/backenddb/merchant-0010.sql index 7f3504e9..e2839aa4 100644 --- a/src/backenddb/merchant-0010.sql +++ b/src/backenddb/merchant-0010.sql @@ -30,13 +30,13 @@ ALTER TABLE merchant_kyc DROP COLUMN aml_decision ,DROP COLUMN exchange_sig ,DROP COLUMN exchange_pub - ,ADD COLUMN access_token BLOB DEFAULT NULL + ,ADD COLUMN access_token BYTEA DEFAULT NULL ,ADD COLUMN exchange_http_status INT4 DEFAULT(0) ,ADD COLUMN exchange_ec_code INT4 DEFAULT(0) ,ADD COLUMN aml_review BOOL DEFAULT(FALSE) - ,ADD COLUMN deposit_threshold taler_amount_currency[] DEFAULT NULL - ,ADD COLUMN deposit_timeframe INT8[] DEFAULT NULL - ,ADD COLUMN deposit_limit_is_soft BOOL[] DEFAULT NULL + ,ADD COLUMN deposit_thresholds taler_amount_currency[] DEFAULT NULL + ,ADD COLUMN deposit_timeframes INT8[] DEFAULT NULL + ,ADD COLUMN deposit_limits_are_soft BOOL[] DEFAULT NULL ,ADD CONSTRAINT access_token_length_check CHECK (LENGTH(access_token) = 32); COMMENT ON COLUMN merchant_kyc.access_token @@ -47,11 +47,11 @@ COMMENT ON COLUMN merchant_kyc.exchange_ec_code IS 'Last Taler error code returned by the exchange when inquiring about our KYC status.'; COMMENT ON COLUMN merchant_kyc.aml_review IS 'True if our account is under AML review according to the exchange.'; -COMMENT ON COLUMN merchant_kyc.deposit_threshold +COMMENT ON COLUMN merchant_kyc.deposit_thresholds IS 'Maximum amount we are allowed to deposit in a given timeframe under current rules.'; -COMMENT ON COLUMN merchant_kyc.deposit_timeframe +COMMENT ON COLUMN merchant_kyc.deposit_timeframes IS 'Timeframe for which the deposit_threshold applies.'; -COMMENT ON COLUMN merchant_kyc.deposit_limit_is_soft +COMMENT ON COLUMN merchant_kyc.deposit_limits_are_soft IS 'True if this is a soft limit'; |