diff options
| author | Özgür Kesim <oec-taler@kesim.org> | 2023-07-23 15:57:37 +0200 |
|---|---|---|
| committer | Özgür Kesim <oec-taler@kesim.org> | 2023-07-23 15:57:37 +0200 |
| commit | 5b39ac9d8f7cf8c8a446fd51061b2d3bbaa31173 (patch) | |
| tree | c1b765e8d49a0f5fcea49a66d91cf2d032f0253b /src/exchangedb/0002-legitimization_requirements.sql | |
| parent | d189fccd790a36046e1191d7170f45feb3dfb122 (diff) | |
| download | exchange-5b39ac9d8f7cf8c8a446fd51061b2d3bbaa31173.tar.gz exchange-5b39ac9d8f7cf8c8a446fd51061b2d3bbaa31173.tar.bz2 exchange-5b39ac9d8f7cf8c8a446fd51061b2d3bbaa31173.zip | |
[kyc] put reserve_pub into legitimization_requirements
Diffstat (limited to 'src/exchangedb/0002-legitimization_requirements.sql')
| -rw-r--r-- | src/exchangedb/0002-legitimization_requirements.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/exchangedb/0002-legitimization_requirements.sql b/src/exchangedb/0002-legitimization_requirements.sql index 4879b7a27..892556aab 100644 --- a/src/exchangedb/0002-legitimization_requirements.sql +++ b/src/exchangedb/0002-legitimization_requirements.sql @@ -25,6 +25,7 @@ BEGIN 'CREATE TABLE %I' '(legitimization_requirement_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY' ',h_payto BYTEA NOT NULL CHECK (LENGTH(h_payto)=32)' + ',reserve_pub BYTEA' ',required_checks VARCHAR NOT NULL' ',UNIQUE (h_payto, required_checks)' ') %s ;' @@ -50,6 +51,12 @@ BEGIN ,partition_suffix ); PERFORM comment_partitioned_column( + 'if h_payto refers to a reserve, this is its public key, NULL otherwise. It allows to lookup the corresponding reserve when the KYC process is done.' + ,'reserve_pub' + ,'legitimization_requirements' + ,partition_suffix + ); + PERFORM comment_partitioned_column( 'space-separated list of required checks' ,'required_checks' ,'legitimization_requirements' |