auditor-0002.sql.in (2657B)
1 -- 2 -- This file is part of TALER 3 -- Copyright (C) 2014--2025 Taler Systems SA 4 -- 5 -- TALER is free software; you can redistribute it and/or modify it under the 6 -- terms of the GNU General Public License as published by the Free Software 7 -- Foundation; either version 3, or (at your option) any later version. 8 -- 9 -- TALER is distributed in the hope that it will be useful, but WITHOUT ANY 10 -- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR 11 -- A PARTICULAR PURPOSE. See the GNU General Public License for more details. 12 -- 13 -- You should have received a copy of the GNU General Public License along with 14 -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> 15 -- 16 17 BEGIN; 18 19 SELECT _v.register_patch('auditor-0002', NULL, NULL); 20 21 SET search_path TO auditor; 22 23 DO $$ BEGIN 24 CREATE TYPE taler_amount 25 AS 26 (val INT8 27 ,frac INT4 28 ); 29 COMMENT ON TYPE taler_amount 30 IS 'Stores an amount, fraction is in units of 1/100000000 of the base value'; 31 EXCEPTION 32 WHEN duplicate_object THEN null; 33 END $$; 34 35 #include "0002-auditor_amount_arithmetic_inconsistency.sql" 36 #include "0002-auditor_bad_sig_losses.sql" 37 #include "0002-auditor_balances.sql" 38 #include "0002-auditor_closure_lags.sql" 39 #include "0002-auditor_coin_inconsistency.sql" 40 #include "0002-auditor_denomination_key_validity_withdraw_inconsistency.sql" 41 #include "0002-auditor_denomination_pending.sql" 42 #include "0002-auditor_denominations_without_sigs.sql" 43 #include "0002-auditor_deposit_confirmations.sql" 44 #include "0002-auditor_emergency.sql" 45 #include "0002-auditor_emergency_by_count.sql" 46 #include "0002-auditor_exchange_signkeys.sql" 47 #include "0002-auditor_fee_time_inconsistency.sql" 48 #include "0002-auditor_historic_denomination_revenue.sql" 49 #include "0002-auditor_historic_reserve_summary.sql" 50 #include "0002-auditor_misattribution_in_inconsistency.sql" 51 #include "0002-auditor_progress.sql" 52 #include "0002-auditor_purse_not_closed_inconsistencies.sql" 53 #include "0002-auditor_purses.sql" 54 #include "0002-auditor_refreshes_hanging.sql" 55 #include "0002-auditor_reserve_balance_insufficient_inconsistency.sql" 56 #include "0002-auditor_reserve_balance_summary_wrong_inconsistency.sql" 57 #include "0002-auditor_reserve_in_inconsistency.sql" 58 #include "0002-auditor_reserve_not_closed_inconsistency.sql" 59 #include "0002-auditor_reserves.sql" 60 #include "0002-auditor_row_inconsistency.sql" 61 #include "0002-auditor_row_minor_inconsistencies.sql" 62 #include "0002-auditor_wire_format_inconsistency.sql" 63 #include "0002-auditor_wire_out_inconsistency.sql" 64 #include "0002-auditor_pending_deposits.sql" 65 #include "0002-auditor_early_aggregation.sql" 66 67 COMMIT;