From 659b1aaac82b57ff25cb26fcf34ba3c9b333b653 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Thu, 8 Feb 2024 00:05:39 +0100 Subject: clean up SQL logic a bit more --- src/auditordb/0002-auditor_purses.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'src/auditordb/0002-auditor_purses.sql') diff --git a/src/auditordb/0002-auditor_purses.sql b/src/auditordb/0002-auditor_purses.sql index 7cebd8894..86b6494d1 100644 --- a/src/auditordb/0002-auditor_purses.sql +++ b/src/auditordb/0002-auditor_purses.sql @@ -14,8 +14,7 @@ -- TALER; see the file COPYING. If not, see -- -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_purses +CREATE TABLE auditor_purses (auditor_purses_rowid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE ,purse_pub BYTEA PRIMARY KEY CHECK(LENGTH(purse_pub)=32) ,balance taler_amount NOT NULL DEFAULT(0,0) -- cgit v1.2.3