aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0005-legitimization_outcomes.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/0005-legitimization_outcomes.sql')
-rw-r--r--src/exchangedb/0005-legitimization_outcomes.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/exchangedb/0005-legitimization_outcomes.sql b/src/exchangedb/0005-legitimization_outcomes.sql
index 642e7441f..d7d337c87 100644
--- a/src/exchangedb/0005-legitimization_outcomes.sql
+++ b/src/exchangedb/0005-legitimization_outcomes.sql
@@ -30,7 +30,7 @@ BEGIN
',jproperties TEXT'
',to_investigate BOOL NOT NULL'
',is_active BOOL NOT NULL DEFAULT(TRUE)'
- ',jnew_rules TEXT NOT NULL'
+ ',jnew_rules TEXT'
') %s ;'
,'legitimization_outcomes'
,'PARTITION BY HASH (h_payto)'
@@ -84,7 +84,7 @@ BEGIN
,partition_suffix
);
PERFORM comment_partitioned_column(
- 'JSON object of type LegitimizationRuleSet with rules to apply to the various operation types for this account; all KYC checks should first check if active new rules for a given account exist in this table (and apply specified measures); if not, it should check the default rules to decide if a measure is required'
+ 'JSON object of type LegitimizationRuleSet with rules to apply to the various operation types for this account; all KYC checks should first check if active new rules for a given account exist in this table (and apply specified measures); if not, it should check the default rules to decide if a measure is required; NULL if the default rules apply'
,'jnew_rules'
,'legitimization_outcomes'
,partition_suffix