-- -- This file is part of TALER -- Copyright (C) 2014--2022 Taler Systems SA -- -- TALER is free software; you can redistribute it and/or modify it under the -- terms of the GNU General Public License as published by the Free Software -- Foundation; either version 3, or (at your option) any later version. -- -- TALER is distributed in the hope that it will be useful, but WITHOUT ANY -- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR -- A PARTICULAR PURPOSE. See the GNU General Public License for more details. -- -- You should have received a copy of the GNU General Public License along with -- TALER; see the file COPYING. If not, see -- CREATE TABLE IF NOT EXISTS auditor_reserves (reserve_pub BYTEA NOT NULL CHECK(LENGTH(reserve_pub)=32) ,reserve_balance_val INT8 NOT NULL ,reserve_balance_frac INT4 NOT NULL ,reserve_loss_val INT8 NOT NULL ,reserve_loss_frac INT4 NOT NULL ,withdraw_fee_balance_val INT8 NOT NULL ,withdraw_fee_balance_frac INT4 NOT NULL ,close_fee_balance_val INT8 NOT NULL ,close_fee_balance_frac INT4 NOT NULL ,purse_fee_balance_val INT8 NOT NULL ,purse_fee_balance_frac INT4 NOT NULL ,open_fee_balance_val INT8 NOT NULL ,open_fee_balance_frac INT4 NOT NULL ,history_fee_balance_val INT8 NOT NULL ,history_fee_balance_frac INT4 NOT NULL ,expiration_date INT8 NOT NULL ,auditor_reserves_rowid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE ,origin_account TEXT ); COMMENT ON TABLE auditor_reserves IS 'all of the customer reserves and their respective balances that the auditor is aware of'; CREATE INDEX IF NOT EXISTS auditor_reserves_by_reserve_pub ON auditor_reserves (reserve_pub);