aboutsummaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_closure_lags.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/auditordb/0002-auditor_closure_lags.sql')
-rw-r--r--src/auditordb/0002-auditor_closure_lags.sql9
1 files changed, 4 insertions, 5 deletions
diff --git a/src/auditordb/0002-auditor_closure_lags.sql b/src/auditordb/0002-auditor_closure_lags.sql
index d41a55eae..93484f399 100644
--- a/src/auditordb/0002-auditor_closure_lags.sql
+++ b/src/auditordb/0002-auditor_closure_lags.sql
@@ -18,11 +18,10 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_closure_lags
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- amount taler_amount NOT NULL,
- deadline BIGINT NOT NULL,
- wtid BYTEA NOT NULL,
- account BYTEA NOT NULL,
+ amount taler_amount,
+ deadline BIGINT,
+ wtid BYTEA,
+ account BYTEA,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_closure_lags