diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-05-17 00:28:41 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-05-17 00:28:41 +0200 |
commit | f7dc35e59e1dca795d51d22e85479eab025644a7 (patch) | |
tree | 79fe2d9a9fdb4952e7d790bc513f2237cfb28126 /src/exchangedb/0002-reserves.sql | |
parent | 755955de28cefb9b61c181630a861488bd0751c9 (diff) | |
download | exchange-f7dc35e59e1dca795d51d22e85479eab025644a7.tar.xz |
implement logic to conditionally trigger AML review based on KYC attributes
Diffstat (limited to 'src/exchangedb/0002-reserves.sql')
-rw-r--r-- | src/exchangedb/0002-reserves.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/src/exchangedb/0002-reserves.sql b/src/exchangedb/0002-reserves.sql index 03d17aee2..df5b6c3db 100644 --- a/src/exchangedb/0002-reserves.sql +++ b/src/exchangedb/0002-reserves.sql @@ -31,7 +31,7 @@ BEGIN ',current_balance_frac INT4 NOT NULL DEFAULT(0)' ',purses_active INT8 NOT NULL DEFAULT(0)' ',purses_allowed INT8 NOT NULL DEFAULT(0)' - ',max_age INT4 NOT NULL DEFAULT(120)' + ',max_age INT4 NOT NULL DEFAULT(0)' ',expiration_date INT8 NOT NULL' ',gc_date INT8 NOT NULL' ') %s ;' @@ -80,6 +80,12 @@ BEGIN ,table_name ,partition_suffix ); + PERFORM comment_partitioned_column( + 'Birthday of the user in days after 1970, or 0 if user is an adult and is not subject to age restrictions' + ,'max_age' + ,table_name + ,partition_suffix + ); END $$; |