1 files changed, 6 insertions, 8 deletions
diff --git a/src/auditordb/0002-auditor_emergency.sql b/src/auditordb/0002-auditor_emergency.sql
index 5fcd3cd06..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,16 +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,
     denompub_h BYTEA CHECK (LENGTH(denompub_h)=64),
-    denom_risk taler_amount,
-    denom_loss taler_amount,
-    deposit_start BIGINT,
-    deposit_end BIGINT,
-    value taler_amount
+    denom_risk taler_amount NOT NULL,
+    denom_loss taler_amount NOT NULL,
+    deposit_start BIGINT 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.';