updated table creation files

1 files changed, 5 insertions, 4 deletions

diff --git a/src/auditordb/0002-auditor_pending_deposits.sql b/src/auditordb/0002-auditor_pending_deposits.sql
index 5cef7bf8c..847885e48 100644
--- a/src/auditordb/0002-auditor_pending_deposits.sql
+++ b/src/auditordb/0002-auditor_pending_deposits.sql
@@ -17,9 +17,10 @@
 CREATE TABLE IF NOT EXISTS auditor_pending_deposits
 (
     row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
-    total_amount taler_amount,
-    wire_target_h_payto BYTEA,
-    batch_deposit_serial_id BIGINT,
-    deadline BIGINT,
+    problem_row_id BIGINT NOT NULL,
+    total_amount taler_amount NOT NULL,
+    wire_target_payto TEXT NOT NULL,
+    batch_deposit_serial_id BIGINT NOT NULL,
+    deadline BIGINT NOT NULL,
     suppressed BOOLEAN NOT NULL DEFAULT FALSE
 );