diff options
Diffstat (limited to 'src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql')
-rw-r--r-- | src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql b/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql index bbc0c8118..e80a7bec8 100644 --- a/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql +++ b/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql @@ -18,9 +18,10 @@ SET search_path TO auditor; CREATE TABLE IF NOT EXISTS auditor_reserve_balance_insufficient_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- reserve_pub BYTEA,
+ reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32),
inconsistency_gain BOOLEAN,
- inconsistency_amount taler_amount
+ inconsistency_amount taler_amount,
+ suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_reserve_balance_insufficient_inconsistency
IS 'Report a (serious) balance insufficiency in the exchange''s database';
\ No newline at end of file |