summaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_purses.sql
diff options
context:
space:
mode:
authorNic <nic@eigel.ch>2023-11-02 23:48:08 +0100
committerNic <nic@eigel.ch>2023-11-02 23:48:08 +0100
commit0442c22857a83eb9291182a1a4d372f1ffb9203c (patch)
tree5c6f9ae6a39fb57a3022f650625d899be8141cff /src/auditordb/0002-auditor_purses.sql
parentf5cad7636211c03cf4c023df4e9275d603cd1770 (diff)
downloadexchange-0442c22857a83eb9291182a1a4d372f1ffb9203c.tar.gz
exchange-0442c22857a83eb9291182a1a4d372f1ffb9203c.tar.bz2
exchange-0442c22857a83eb9291182a1a4d372f1ffb9203c.zip
-fix 0002-auditordb-scripts
Diffstat (limited to 'src/auditordb/0002-auditor_purses.sql')
-rw-r--r--src/auditordb/0002-auditor_purses.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/auditordb/0002-auditor_purses.sql b/src/auditordb/0002-auditor_purses.sql
index 9ba5955eb..17fd5dde2 100644
--- a/src/auditordb/0002-auditor_purses.sql
+++ b/src/auditordb/0002-auditor_purses.sql
@@ -14,6 +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_purses
(auditor_purses_rowid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
,purse_pub BYTEA PRIMARY KEY CHECK(LENGTH(purse_pub)=32)
@@ -21,5 +22,5 @@ CREATE TABLE IF NOT EXISTS auditor_purses
,target taler_amount NOT NULL
,expiration_date INT8 NOT NULL
);
-COMMENT ON TABLE purses
+COMMENT ON TABLE auditor_purses
IS 'all of the purses and their respective balances that the auditor is aware of';