diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2022-12-27 09:05:45 +0100 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2022-12-27 09:05:45 +0100 |
commit | 5dcad73d29bb431c7ae4529cc3755b56edbbb402 (patch) | |
tree | e7ac3573fce0e8b6e6a5ef0672ddd6b93d4fa8f9 /src/exchangedb/0003-aml_staff.sql | |
parent | 871d010637205965dabb7f29e43679756a4449a6 (diff) | |
download | exchange-5dcad73d29bb431c7ae4529cc3755b56edbbb402.tar.xz |
-prepare for AML staff PKI
Diffstat (limited to 'src/exchangedb/0003-aml_staff.sql')
-rw-r--r-- | src/exchangedb/0003-aml_staff.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/src/exchangedb/0003-aml_staff.sql b/src/exchangedb/0003-aml_staff.sql new file mode 100644 index 000000000..3c538df1d --- /dev/null +++ b/src/exchangedb/0003-aml_staff.sql @@ -0,0 +1,37 @@ +-- +-- This file is part of TALER +-- Copyright (C) 2014--2022 Taler Systems SA +-- +-- TALER is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 3, or (at your option) any later version. +-- +-- TALER is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along with +-- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> +-- + + +CREATE TABLE aml_staff + (aml_staff_uuid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE + ,decider_pub BYTEA PRIMARY KEY CHECK (LENGTH(decider_pub)=32) + ,master_sig BYTEA PRIMARY KEY CHECK (LENGTH(master_sig)=64) + ,decider_name VARCHAR NOT NULL + ,is_active BOOLEAN NOT NULL + ,last_change INT8 NOT NULL + ); +COMMENT ON TABLE aml_staff + IS 'Table with AML staff members the exchange uses or has used in the past. Entries never expire as we need to remember the last_change column indefinitely.'; +COMMENT ON COLUMN aml_staff.decider_pub + IS 'Public key of the AML staff member.'; +COMMENT ON COLUMN aml_staff.master_sig + IS 'The master public key signature on the AML staff member status.'; +COMMENT ON COLUMN aml_staff.decider_name + IS 'Name of the staff member.'; +COMMENT ON COLUMN aml_staff.is_active + IS 'true if we are currently supporting the use of this AML staff member.'; +COMMENT ON COLUMN aml_staff.last_change + IS 'Latest time when active status changed. Used to detect replays of old messages.'; |