diff options
Diffstat (limited to 'src/auditordb/0002-auditor_refreshes_hanging.sql')
-rw-r--r-- | src/auditordb/0002-auditor_refreshes_hanging.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/auditordb/0002-auditor_refreshes_hanging.sql b/src/auditordb/0002-auditor_refreshes_hanging.sql index 5544bc0d8..9d0152b7f 100644 --- a/src/auditordb/0002-auditor_refreshes_hanging.sql +++ b/src/auditordb/0002-auditor_refreshes_hanging.sql @@ -17,9 +17,10 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_refreshes_hanging
(
- row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
+ row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
amount taler_amount,
- coin_pub BYTEA
+ coin_pub BYTEA PRIMARY KEY,
+ suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_refreshes_hanging
IS 'Report a hanging refresh.';
\ No newline at end of file |