aboutsummaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_emergency_by_count.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/auditordb/0002-auditor_emergency_by_count.sql')
-rw-r--r--src/auditordb/0002-auditor_emergency_by_count.sql7
1 files changed, 4 insertions, 3 deletions
diff --git a/src/auditordb/0002-auditor_emergency_by_count.sql b/src/auditordb/0002-auditor_emergency_by_count.sql
index 4daa994a7..c217a61d4 100644
--- a/src/auditordb/0002-auditor_emergency_by_count.sql
+++ b/src/auditordb/0002-auditor_emergency_by_count.sql
@@ -19,12 +19,13 @@ CREATE TABLE IF NOT EXISTS auditor_emergency_by_count
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
denompub_h BYTEA,
- num_issued integer,
- num_known integer,
+ num_issued BIGINT,
+ num_known BIGINT,
risk taler_amount,
start BIGINT,
deposit_end BIGINT,
- value taler_amount
+ value taler_amount,
+ suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_emergency_by_count
IS 'Report an emergency denomination.'; \ No newline at end of file