aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-reserves.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-05-17 00:28:41 +0200
committerChristian Grothoff <christian@grothoff.org>2023-05-17 00:28:41 +0200
commitf7dc35e59e1dca795d51d22e85479eab025644a7 (patch)
tree79fe2d9a9fdb4952e7d790bc513f2237cfb28126 /src/exchangedb/0002-reserves.sql
parent755955de28cefb9b61c181630a861488bd0751c9 (diff)
downloadexchange-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.sql8
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
$$;