diff options
Diffstat (limited to 'src/auditordb/0002-auditor_emergency.sql')
-rw-r--r-- | src/auditordb/0002-auditor_emergency.sql | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/src/auditordb/0002-auditor_emergency.sql b/src/auditordb/0002-auditor_emergency.sql index a97befc0b..90f0ca8b8 100644 --- a/src/auditordb/0002-auditor_emergency.sql +++ b/src/auditordb/0002-auditor_emergency.sql @@ -1,5 +1,3 @@ - - -- -- This file is part of TALER -- Copyright (C) 2014--2024 Taler Systems SA @@ -16,17 +14,16 @@ -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> -- -SET search_path TO auditor; CREATE TABLE IF NOT EXISTS auditor_emergency ( row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - problem_row_id BIGINT NOT NULL, denompub_h BYTEA CHECK (LENGTH(denompub_h)=64), denom_risk taler_amount NOT NULL, denom_loss taler_amount NOT NULL, deposit_start BIGINT NOT NULL, - deposit_end BIGINT, - value taler_amount NOT NULL + deposit_end BIGINT NOT NULL, + value taler_amount NOT NULL, + suppressed BOOLEAN NOT NULL DEFAULT FALSE ); COMMENT ON TABLE auditor_emergency IS 'Report an emergency denomination.'; |