aboutsummaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_closure_lags.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2024-08-28 22:42:33 +0200
committerChristian Grothoff <christian@grothoff.org>2024-08-28 22:42:33 +0200
commitd16350ef1085bc16f2ef04eb8fe60edeb0f6978d (patch)
tree365d23207a023f47466b293f13080be274c11563 /src/auditordb/0002-auditor_closure_lags.sql
parent94339b2d73c6df0d61ee18f60e2a4b16bc56c750 (diff)
fix patch from Nic and also fix various other auditor bugs found during review
Diffstat (limited to 'src/auditordb/0002-auditor_closure_lags.sql')
-rw-r--r--src/auditordb/0002-auditor_closure_lags.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/src/auditordb/0002-auditor_closure_lags.sql b/src/auditordb/0002-auditor_closure_lags.sql
index d41a55eae..73743e8a1 100644
--- a/src/auditordb/0002-auditor_closure_lags.sql
+++ b/src/auditordb/0002-auditor_closure_lags.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_closure_lags
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
problem_row_id BIGINT NOT NULL,
amount taler_amount NOT NULL,
deadline BIGINT NOT NULL,
- wtid BYTEA NOT NULL,
+ wtid BYTEA NOT NULL CHECK (LENGTH(wtid)=32),
account BYTEA NOT NULL,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);