diff options
author | Christian Grothoff <christian@grothoff.org> | 2024-04-15 11:10:18 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2024-04-15 11:10:18 +0200 |
commit | 570bb0303239b9f64311e5f40cba24f5cfe81ee1 (patch) | |
tree | 11f97bfccc1bcef660afe92eb27805c907ec723b /src/exchangedb | |
parent | bae916ea62e8947092ab084a48bca721b30d6fef (diff) |
API extension for challenger 0.11
Diffstat (limited to 'src/exchangedb')
-rw-r--r-- | src/exchangedb/0002-kyc_attributes.sql | 10 |
1 files changed, 0 insertions, 10 deletions
diff --git a/src/exchangedb/0002-kyc_attributes.sql b/src/exchangedb/0002-kyc_attributes.sql index 897aff561..66f3fc315 100644 --- a/src/exchangedb/0002-kyc_attributes.sql +++ b/src/exchangedb/0002-kyc_attributes.sql @@ -107,16 +107,6 @@ BEGIN ' ADD CONSTRAINT ' || table_name || '_serial_key ' 'UNIQUE (kyc_attributes_serial_id)' ); - -- The legitimization_serial is a foreign key. - -- But, due to partitioning by h_payto, we can not simply reference - -- the serial id of the legitimization_processes. Thus, the following - -- is commented out. - -- EXECUTE FORMAT ( - -- 'ALTER TABLE ' || table_name || - -- ' ADD CONSTRAINT ' || table_name || '_foreign_legitimization_processes' - -- ' FOREIGN KEY (legitimization_serial) ' - -- ' REFERENCES legitimization_processes (legitimization_process_serial_id)' -- ON DELETE CASCADE - -- ); -- To search similar users (e.g. during AML checks) EXECUTE FORMAT ( 'CREATE INDEX ' || table_name || '_similarity_index ' |