1 files changed, 4 insertions, 3 deletions
diff --git a/src/auditordb/0002-auditor_coin_inconsistency.sql b/src/auditordb/0002-auditor_coin_inconsistency.sql
index ea5210d68..c9c1b02fc 100644
--- a/src/auditordb/0002-auditor_coin_inconsistency.sql
+++ b/src/auditordb/0002-auditor_coin_inconsistency.sql
@@ -18,11 +18,12 @@ SET search_path TO auditor;
 CREATE TABLE IF NOT EXISTS auditor_coin_inconsistency
 (
     row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
+    problem_row_id BIGINT NOT NULL,
     operation TEXT NOT NULL,
-    exchange_amount taler_amount,
-    auditor_amount taler_amount,
+    exchange_amount taler_amount NOT NULL,
+    auditor_amount taler_amount NOT NULL,
     coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32),
-    profitable BOOLEAN,
+    profitable BOOLEAN NOT NULL,
     suppressed BOOLEAN NOT NULL DEFAULT FALSE,
     PRIMARY KEY (operation, coin_pub)
 );