diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2022-07-25 22:49:59 +0200 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2022-07-25 22:49:59 +0200 |
commit | d2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8 (patch) | |
tree | 437053864b5f9b86aa6178e536f9f6ee83af68bf /src/auditordb/auditor-0001.sql | |
parent | 6d2e6d80613e6f45d207f89bc25f6f507a131504 (diff) | |
download | exchange-d2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8.tar.xz |
move auditor database also into schema
Diffstat (limited to 'src/auditordb/auditor-0001.sql')
-rw-r--r-- | src/auditordb/auditor-0001.sql | 6 |
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 |