aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-kyc_attributes.sql
diff options
context:
space:
mode:
authorÖzgür Kesim <oec-taler@kesim.org>2023-07-28 14:29:25 +0200
committerÖzgür Kesim <oec-taler@kesim.org>2023-07-28 14:29:25 +0200
commit1c923855a31b35e28706ba2fafa2d2bccc7ee775 (patch)
tree5df5f6ed6225d3d2990e5054a5bb12de05a8d62f /src/exchangedb/0002-kyc_attributes.sql
parent0d0494ee9117c89faeda64baf7413dee1cee46ca (diff)
downloadexchange-1c923855a31b35e28706ba2fafa2d2bccc7ee775.tar.gz
exchange-1c923855a31b35e28706ba2fafa2d2bccc7ee775.tar.bz2
exchange-1c923855a31b35e28706ba2fafa2d2bccc7ee775.zip
finalize v3/v4 -> v2 exchange schema merger
Diffstat (limited to 'src/exchangedb/0002-kyc_attributes.sql')
-rw-r--r--src/exchangedb/0002-kyc_attributes.sql10
1 files changed, 2 insertions, 8 deletions
diff --git a/src/exchangedb/0002-kyc_attributes.sql b/src/exchangedb/0002-kyc_attributes.sql
index 9b18b6c2f..d02e2568f 100644
--- a/src/exchangedb/0002-kyc_attributes.sql
+++ b/src/exchangedb/0002-kyc_attributes.sql
@@ -56,12 +56,6 @@ BEGIN
,partition_suffix
);
PERFORM comment_partitioned_column(
- 'birth date of the user, in format YYYY-MM-DD where a value of 0 is used to indicate unknown (in official documents); NULL if the birth date was not collected by the provider; used for KYC-driven age restrictions'
- ,'birthdate'
- ,table_name
- ,partition_suffix
- );
- PERFORM comment_partitioned_column(
'time when the attributes were collected by the provider'
,'collection_time'
,table_name
@@ -144,12 +138,12 @@ INSERT INTO exchange_tables
,by_range)
VALUES
('kyc_attributes'
- ,'exchange-0003'
+ ,'exchange-0002'
,'create'
,TRUE
,FALSE),
('kyc_attributes'
- ,'exchange-0003'
+ ,'exchange-0002'
,'constrain'
,TRUE
,FALSE);