aboutsummaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/auditordb/0002-auditor_misattribution_in_inconsistency.sql')
-rw-r--r--src/auditordb/0002-auditor_misattribution_in_inconsistency.sql5
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