aboutsummaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_denomination_pending.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2024-02-08 00:05:39 +0100
committerChristian Grothoff <christian@grothoff.org>2024-02-08 00:05:39 +0100
commit659b1aaac82b57ff25cb26fcf34ba3c9b333b653 (patch)
treeb12e81e79d1cd418a0bdffdc777ceae71350df23 /src/auditordb/0002-auditor_denomination_pending.sql
parent97f3e30c3d4081a6765c914c94b6cbf3a75110f3 (diff)
downloadexchange-659b1aaac82b57ff25cb26fcf34ba3c9b333b653.tar.xz
clean up SQL logic a bit more
Diffstat (limited to 'src/auditordb/0002-auditor_denomination_pending.sql')
-rw-r--r--src/auditordb/0002-auditor_denomination_pending.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/src/auditordb/0002-auditor_denomination_pending.sql b/src/auditordb/0002-auditor_denomination_pending.sql
index 0dee6ecab..f9ba535b4 100644
--- a/src/auditordb/0002-auditor_denomination_pending.sql
+++ b/src/auditordb/0002-auditor_denomination_pending.sql
@@ -14,8 +14,7 @@
-- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/>
--
-SET search_path TO auditor;
-CREATE TABLE IF NOT EXISTS auditor_denomination_pending
+CREATE TABLE auditor_denomination_pending
(denom_pub_hash BYTEA PRIMARY KEY CHECK (LENGTH(denom_pub_hash)=64)
,denom_balance taler_amount NOT NULL
,denom_loss taler_amount NOT NULL