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, 2 insertions, 3 deletions
diff --git a/src/auditordb/0002-auditor_bad_sig_losses.sql b/src/auditordb/0002-auditor_bad_sig_losses.sql index 8be983670..c5a222251 100644 --- a/src/auditordb/0002-auditor_bad_sig_losses.sql +++ b/src/auditordb/0002-auditor_bad_sig_losses.sql @@ -18,9 +18,8 @@ SET search_path TO auditor; CREATE TABLE IF NOT EXISTS auditor_bad_sig_losses ( row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, - problem_row_id BIGINT NOT NULL, - operation TEXT NOT NULL, - loss taler_amount NOT NULL, + operation TEXT, + loss taler_amount, operation_specific_pub BYTEA NOT NULL CHECK (LENGTH(operation_specific_pub)=32), suppressed BOOLEAN NOT NULL DEFAULT FALSE, PRIMARY KEY (operation, operation_specific_pub) |