diff options
Diffstat (limited to 'src/auditordb/0002-auditor_purses.sql')
| -rw-r--r-- | src/auditordb/0002-auditor_purses.sql | 3 |
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'; |