diff options
Diffstat (limited to 'src/auditordb/0002-auditor_closure_lags.sql')
-rw-r--r-- | src/auditordb/0002-auditor_closure_lags.sql | 9 |
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 |