aboutsummaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_emergency.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/auditordb/0002-auditor_emergency.sql')
-rw-r--r--src/auditordb/0002-auditor_emergency.sql9
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.';