diff options
Diffstat (limited to 'src/auditordb/0002-auditor_bad_sig_losses.sql')
| -rw-r--r-- | src/auditordb/0002-auditor_bad_sig_losses.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/auditordb/0002-auditor_bad_sig_losses.sql b/src/auditordb/0002-auditor_bad_sig_losses.sql index ac17a5120..e4e87f398 100644 --- a/src/auditordb/0002-auditor_bad_sig_losses.sql +++ b/src/auditordb/0002-auditor_bad_sig_losses.sql @@ -18,9 +18,10 @@ SET search_path TO auditor; CREATE TABLE IF NOT EXISTS auditor_bad_sig_losses
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- operation BYTEA,
+ operation VARCHAR(64),
loss taler_amount,
- operation_specific_pub BYTEA
+ operation_specific_pub BYTEA NOT NULL CHECK (LENGTH(operation_specific_pub)=32),
+ suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_bad_sig_losses
IS 'Report a (serious) inconsistency with losses due to bad signatures';
\ No newline at end of file |