diff options
Diffstat (limited to 'src/auditordb/0002-auditor_misattribution_in_inconsistency.sql')
-rw-r--r-- | src/auditordb/0002-auditor_misattribution_in_inconsistency.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql b/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql index d212f5768..a351f7dfd 100644 --- a/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql +++ b/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql @@ -14,14 +14,13 @@ -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> -- -SET search_path TO auditor; + CREATE TABLE IF NOT EXISTS auditor_misattribution_in_inconsistency ( row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - problem_row_id BIGINT NOT NULL, amount taler_amount NOT NULL, bank_row BIGINT NOT NULL, - reserve_pub BYTEA NOT NULL, + reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32), suppressed BOOLEAN NOT NULL DEFAULT FALSE ); COMMENT ON TABLE auditor_misattribution_in_inconsistency |