summaryrefslogtreecommitdiff
path: root/src/auditordb/auditor-0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <grothoff@gnunet.org>2022-07-25 22:49:59 +0200
committerChristian Grothoff <grothoff@gnunet.org>2022-07-25 22:49:59 +0200
commitd2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8 (patch)
tree437053864b5f9b86aa6178e536f9f6ee83af68bf /src/auditordb/auditor-0001.sql
parent6d2e6d80613e6f45d207f89bc25f6f507a131504 (diff)
downloadexchange-d2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8.tar.gz
exchange-d2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8.tar.bz2
exchange-d2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8.zip
move auditor database also into schema
Diffstat (limited to 'src/auditordb/auditor-0001.sql')
-rw-r--r--src/auditordb/auditor-0001.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/auditordb/auditor-0001.sql b/src/auditordb/auditor-0001.sql
index daefdc172..233ad6864 100644
--- a/src/auditordb/auditor-0001.sql
+++ b/src/auditordb/auditor-0001.sql
@@ -21,6 +21,12 @@ BEGIN;
SELECT _v.register_patch('auditor-0001', NULL, NULL);
+CREATE SCHEMA auditor;
+COMMENT ON SCHEMA auditor IS 'taler-auditor data';
+
+SET search_path TO auditor;
+
+
CREATE TABLE IF NOT EXISTS auditor_exchanges
(master_pub BYTEA PRIMARY KEY CHECK (LENGTH(master_pub)=32)
,exchange_url VARCHAR NOT NULL