1 files changed, 5 insertions, 4 deletions
diff --git a/src/auditordb/0002-auditor_emergency.sql b/src/auditordb/0002-auditor_emergency.sql
index 5fcd3cd06..a97befc0b 100644
--- a/src/auditordb/0002-auditor_emergency.sql
+++ b/src/auditordb/0002-auditor_emergency.sql
@@ -20,12 +20,13 @@ 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,
-    denom_loss taler_amount,
-    deposit_start BIGINT,
+    denom_risk taler_amount NOT NULL,
+    denom_loss taler_amount NOT NULL,
+    deposit_start BIGINT NOT NULL,
     deposit_end BIGINT,
-    value taler_amount
+    value taler_amount NOT NULL
 );
 COMMENT ON TABLE auditor_emergency
     IS 'Report an emergency denomination.';