commit ffecacae4b60206564f2278f260bc3c5a4077cea parent 5fff83e86d040fa43e6805255b7acacd6af72448 Author: Özgür Kesim <oec@kesim.org> Date: Sun, 18 Aug 2024 21:47:07 +0200 -fileformat dos->unix Diffstat:
| M | src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql | | | 62 | +++++++++++++++++++++++++++++++------------------------------- |
| M | src/auditordb/0002-auditor_bad_sig_losses.sql | | | 57 | ++++++++++++++++++++++++++++----------------------------- |
| M | src/auditordb/0002-auditor_closure_lags.sql | | | 57 | ++++++++++++++++++++++++++++----------------------------- |
| M | src/auditordb/0002-auditor_coin_inconsistency.sql | | | 61 | ++++++++++++++++++++++++++++++------------------------------- |
| M | src/auditordb/0002-auditor_denomination_key_validity_withdraw_inconsistency.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
| M | src/auditordb/0002-auditor_denominations_without_sigs.sql | | | 57 | ++++++++++++++++++++++++++++----------------------------- |
| M | src/auditordb/0002-auditor_emergency.sql | | | 63 | +++++++++++++++++++++++++++++++-------------------------------- |
| M | src/auditordb/0002-auditor_emergency_by_count.sql | | | 63 | +++++++++++++++++++++++++++++++-------------------------------- |
| M | src/auditordb/0002-auditor_fee_time_inconsistency.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
| M | src/auditordb/0002-auditor_misattribution_in_inconsistency.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
| M | src/auditordb/0002-auditor_purse_not_closed_inconsistencies.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
| M | src/auditordb/0002-auditor_refreshes_hanging.sql | | | 53 | ++++++++++++++++++++++++++--------------------------- |
| M | src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
| M | src/auditordb/0002-auditor_reserve_balance_summary_wrong_inconsistency.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
| M | src/auditordb/0002-auditor_reserve_in_inconsistency.sql | | | 61 | ++++++++++++++++++++++++++++++------------------------------- |
| M | src/auditordb/0002-auditor_reserve_not_closed_inconsistency.sql | | | 57 | ++++++++++++++++++++++++++++----------------------------- |
| M | src/auditordb/0002-auditor_row_inconsistency.sql | | | 54 | +++++++++++++++++++++++++++--------------------------- |
| M | src/auditordb/0002-auditor_row_minor_inconsistencies.sql | | | 53 | ++++++++++++++++++++++++++--------------------------- |
| M | src/auditordb/0002-auditor_wire_format_inconsistency.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
| M | src/auditordb/0002-auditor_wire_out_inconsistency.sql | | | 55 | +++++++++++++++++++++++++++---------------------------- |
20 files changed, 560 insertions(+), 578 deletions(-)
diff --git a/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql b/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql @@ -1,31 +1,31 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - --- TODO: The constraints of operation are just for testing - -CREATE TABLE auditor_amount_arithmetic_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, - -- TODO: correct constraintcheck, currently wrong - --operation BYTEA NOT NULL CHECK (LENGTH(operation)=16), - operation TEXT NOT NULL PRIMARY KEY, - exchange_amount taler_amount, - auditor_amount taler_amount, - profitable BOOLEAN, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_amount_arithmetic_inconsistency - IS 'Report a (serious) inconsistency in the exchange''s database with respect to calculations involving amounts'; +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +-- TODO: The constraints of operation are just for testing + +CREATE TABLE auditor_amount_arithmetic_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, + -- TODO: correct constraintcheck, currently wrong + --operation BYTEA NOT NULL CHECK (LENGTH(operation)=16), + operation TEXT NOT NULL PRIMARY KEY, + exchange_amount taler_amount, + auditor_amount taler_amount, + profitable BOOLEAN, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_amount_arithmetic_inconsistency + IS 'Report a (serious) inconsistency in the exchange''s database with respect to calculations involving amounts'; diff --git a/src/auditordb/0002-auditor_bad_sig_losses.sql b/src/auditordb/0002-auditor_bad_sig_losses.sql @@ -1,28 +1,28 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_bad_sig_losses -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, - operation TEXT, - loss taler_amount, - operation_specific_pub BYTEA NOT NULL CHECK (LENGTH(operation_specific_pub)=32), - suppressed BOOLEAN NOT NULL DEFAULT FALSE, - PRIMARY KEY (operation, operation_specific_pub) -); -COMMENT ON TABLE auditor_bad_sig_losses - IS 'Report a (serious) inconsistency with losses due to bad signatures'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_bad_sig_losses +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, + operation TEXT, + loss taler_amount, + operation_specific_pub BYTEA NOT NULL CHECK (LENGTH(operation_specific_pub)=32), + suppressed BOOLEAN NOT NULL DEFAULT FALSE, + PRIMARY KEY (operation, operation_specific_pub) +); +COMMENT ON TABLE auditor_bad_sig_losses + IS 'Report a (serious) inconsistency with losses due to bad signatures'; diff --git a/src/auditordb/0002-auditor_closure_lags.sql b/src/auditordb/0002-auditor_closure_lags.sql @@ -1,28 +1,28 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_closure_lags -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - amount taler_amount, - deadline BIGINT, - wtid BYTEA, - account BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_closure_lags - IS 'Report closure lags.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_closure_lags +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + amount taler_amount, + deadline BIGINT, + wtid BYTEA, + account BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_closure_lags + IS 'Report closure lags.'; diff --git a/src/auditordb/0002-auditor_coin_inconsistency.sql b/src/auditordb/0002-auditor_coin_inconsistency.sql @@ -1,30 +1,30 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_coin_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, - operation TEXT NOT NULL, - exchange_amount taler_amount, - auditor_amount taler_amount, - coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32), - profitable BOOLEAN, - suppressed BOOLEAN NOT NULL DEFAULT FALSE, - PRIMARY KEY (operation, coin_pub) -); -COMMENT ON TABLE auditor_coin_inconsistency - IS 'Report a (serious) inconsistency in the exchange''s database with respect to calculations involving amounts'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_coin_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, + operation TEXT NOT NULL, + exchange_amount taler_amount, + auditor_amount taler_amount, + coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32), + profitable BOOLEAN, + suppressed BOOLEAN NOT NULL DEFAULT FALSE, + PRIMARY KEY (operation, coin_pub) +); +COMMENT ON TABLE auditor_coin_inconsistency + IS 'Report a (serious) inconsistency in the exchange''s database with respect to calculations involving amounts'; diff --git a/src/auditordb/0002-auditor_denomination_key_validity_withdraw_inconsistency.sql b/src/auditordb/0002-auditor_denomination_key_validity_withdraw_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_denomination_key_validity_withdraw_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - execution_date BIGINT, - reserve_pub BYTEA, - denompub_h BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_denomination_key_validity_withdraw_inconsistency - IS 'Report a (serious) denomination key validity withdraw inconsistency in the exchange''s database'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_denomination_key_validity_withdraw_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + execution_date BIGINT, + reserve_pub BYTEA, + denompub_h BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_denomination_key_validity_withdraw_inconsistency + IS 'Report a (serious) denomination key validity withdraw inconsistency in the exchange''s database'; diff --git a/src/auditordb/0002-auditor_denominations_without_sigs.sql b/src/auditordb/0002-auditor_denominations_without_sigs.sql @@ -1,28 +1,28 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_denominations_without_sigs -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, - denompub_h BYTEA PRIMARY KEY, - value taler_amount, - start_time BIGINT, - end_time BIGINT, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_denominations_without_sigs - IS 'Report encountered denomination that auditor is not auditing.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_denominations_without_sigs +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, + denompub_h BYTEA PRIMARY KEY, + value taler_amount, + start_time BIGINT, + end_time BIGINT, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_denominations_without_sigs + IS 'Report encountered denomination that auditor is not auditing.'; diff --git a/src/auditordb/0002-auditor_emergency.sql b/src/auditordb/0002-auditor_emergency.sql @@ -1,31 +1,31 @@ - - --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_emergency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - denompub_h BYTEA CHECK (LENGTH(denompub_h)=64), - denom_risk taler_amount, - denom_loss taler_amount, - deposit_start BIGINT, - deposit_end BIGINT, - value taler_amount -); -COMMENT ON TABLE auditor_emergency - IS 'Report an emergency denomination.'; -\ No newline at end of file + + +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_emergency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + denompub_h BYTEA CHECK (LENGTH(denompub_h)=64), + denom_risk taler_amount, + denom_loss taler_amount, + deposit_start BIGINT, + deposit_end BIGINT, + value taler_amount +); +COMMENT ON TABLE auditor_emergency + IS 'Report an emergency denomination.'; diff --git a/src/auditordb/0002-auditor_emergency_by_count.sql b/src/auditordb/0002-auditor_emergency_by_count.sql @@ -1,31 +1,31 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_emergency_by_count -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - denompub_h BYTEA, - num_issued BIGINT, - num_known BIGINT, - risk taler_amount, - start BIGINT, - deposit_end BIGINT, - value taler_amount, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_emergency_by_count - IS 'Report an emergency denomination.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_emergency_by_count +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + denompub_h BYTEA, + num_issued BIGINT, + num_known BIGINT, + risk taler_amount, + start BIGINT, + deposit_end BIGINT, + value taler_amount, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_emergency_by_count + IS 'Report an emergency denomination.'; diff --git a/src/auditordb/0002-auditor_fee_time_inconsistency.sql b/src/auditordb/0002-auditor_fee_time_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_fee_time_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - type BYTEA, - time BIGINT, - diagnostic BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_fee_time_inconsistency - IS 'Report a (serious) fee time inconsistency in the exchange''s database'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_fee_time_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + type BYTEA, + time BIGINT, + diagnostic BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_fee_time_inconsistency + IS 'Report a (serious) fee time inconsistency in the exchange''s database'; diff --git a/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql b/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_misattribution_in_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - amount taler_amount, - bank_row BIGINT, - reserve_pub BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_misattribution_in_inconsistency - IS 'Report wire transfer that was smaller than it should have been.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_misattribution_in_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + amount taler_amount, + bank_row BIGINT, + reserve_pub BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_misattribution_in_inconsistency + IS 'Report wire transfer that was smaller than it should have been.'; diff --git a/src/auditordb/0002-auditor_purse_not_closed_inconsistencies.sql b/src/auditordb/0002-auditor_purse_not_closed_inconsistencies.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_purse_not_closed_inconsistencies -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE , - purse_pub BYTEA PRIMARY KEY, - amount taler_amount, - expiration_date BIGINT, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_purse_not_closed_inconsistencies - IS 'Report expired purses'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_purse_not_closed_inconsistencies +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE , + purse_pub BYTEA PRIMARY KEY, + amount taler_amount, + expiration_date BIGINT, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_purse_not_closed_inconsistencies + IS 'Report expired purses'; diff --git a/src/auditordb/0002-auditor_refreshes_hanging.sql b/src/auditordb/0002-auditor_refreshes_hanging.sql @@ -1,26 +1,26 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_refreshes_hanging -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, - amount taler_amount, - coin_pub BYTEA PRIMARY KEY, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_refreshes_hanging - IS 'Report a hanging refresh.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_refreshes_hanging +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, + amount taler_amount, + coin_pub BYTEA PRIMARY KEY, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_refreshes_hanging + IS 'Report a hanging refresh.'; diff --git a/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql b/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_reserve_balance_insufficient_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32), - inconsistency_gain BOOLEAN, - inconsistency_amount taler_amount, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_reserve_balance_insufficient_inconsistency - IS 'Report a (serious) balance insufficiency in the exchange''s database'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_reserve_balance_insufficient_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32), + inconsistency_gain BOOLEAN, + inconsistency_amount taler_amount, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_reserve_balance_insufficient_inconsistency + IS 'Report a (serious) balance insufficiency in the exchange''s database'; diff --git a/src/auditordb/0002-auditor_reserve_balance_summary_wrong_inconsistency.sql b/src/auditordb/0002-auditor_reserve_balance_summary_wrong_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_reserve_balance_summary_wrong_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - reserve_pub BYTEA, - exchange_amount taler_amount, - auditor_amount taler_amount, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_reserve_balance_summary_wrong_inconsistency - IS 'Report a (serious) reserve balance insufficiency.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_reserve_balance_summary_wrong_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + reserve_pub BYTEA, + exchange_amount taler_amount, + auditor_amount taler_amount, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_reserve_balance_summary_wrong_inconsistency + IS 'Report a (serious) reserve balance insufficiency.'; diff --git a/src/auditordb/0002-auditor_reserve_in_inconsistency.sql b/src/auditordb/0002-auditor_reserve_in_inconsistency.sql @@ -1,30 +1,30 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_reserve_in_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - amount_exchange_expected taler_amount, - amount_wired taler_amount, - reserve_pub BYTEA, - timestamp BIGINT, - account BYTEA, - diagnostic BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_reserve_in_inconsistency - IS 'Report an incoming wire transfer claimed by exchange not found.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_reserve_in_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + amount_exchange_expected taler_amount, + amount_wired taler_amount, + reserve_pub BYTEA, + timestamp BIGINT, + account BYTEA, + diagnostic BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_reserve_in_inconsistency + IS 'Report an incoming wire transfer claimed by exchange not found.'; diff --git a/src/auditordb/0002-auditor_reserve_not_closed_inconsistency.sql b/src/auditordb/0002-auditor_reserve_not_closed_inconsistency.sql @@ -1,28 +1,28 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_reserve_not_closed_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE , - reserve_pub BYTEA PRIMARY KEY, - balance taler_amount, - expiration_time BIGINT, - diagnostic BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_reserve_not_closed_inconsistency - IS 'Report a (serious) reserve balance insufficiency.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_reserve_not_closed_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE , + reserve_pub BYTEA PRIMARY KEY, + balance taler_amount, + expiration_time BIGINT, + diagnostic BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_reserve_not_closed_inconsistency + IS 'Report a (serious) reserve balance insufficiency.'; diff --git a/src/auditordb/0002-auditor_row_inconsistency.sql b/src/auditordb/0002-auditor_row_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_row_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - row_table TEXT NOT NULL, - diagnostic TEXT NOT NULL, - problem_row_id INT8 NOT NULL, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_row_inconsistency - IS 'Report a (serious) row inconsistency in the exchange''s database'; +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_row_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + row_table TEXT NOT NULL, + diagnostic TEXT NOT NULL, + problem_row_id INT8 NOT NULL, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_row_inconsistency + IS 'Report a (serious) row inconsistency in the exchange''s database'; diff --git a/src/auditordb/0002-auditor_row_minor_inconsistencies.sql b/src/auditordb/0002-auditor_row_minor_inconsistencies.sql @@ -1,26 +1,26 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_row_minor_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - row_table BYTEA, - diagnostic BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_row_minor_inconsistency - IS 'Report a (serious) row inconsistency in the exchange''s database.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_row_minor_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + row_table BYTEA, + diagnostic BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_row_minor_inconsistency + IS 'Report a (serious) row inconsistency in the exchange''s database.'; diff --git a/src/auditordb/0002-auditor_wire_format_inconsistency.sql b/src/auditordb/0002-auditor_wire_format_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_wire_format_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - amount taler_amount, - wire_offset BIGINT, - diagnostic BYTEA, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_wire_format_inconsistency - IS 'Report a (serious) format inconsistency.'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_wire_format_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + amount taler_amount, + wire_offset BIGINT, + diagnostic BYTEA, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_wire_format_inconsistency + IS 'Report a (serious) format inconsistency.'; diff --git a/src/auditordb/0002-auditor_wire_out_inconsistency.sql b/src/auditordb/0002-auditor_wire_out_inconsistency.sql @@ -1,27 +1,27 @@ --- --- This file is part of TALER --- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> --- - -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_wire_out_inconsistency -( - row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, - destination_account TEXT NOT NULL, - expected taler_amount, - claimed taler_amount, - suppressed BOOLEAN NOT NULL DEFAULT FALSE -); -COMMENT ON TABLE auditor_wire_out_inconsistency - IS 'Report a (serious) wire inconsistency in the exchange''s database'; -\ No newline at end of file +-- +-- This file is part of TALER +-- Copyright (C) 2014--2024 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 <http://www.gnu.org/licenses/> +-- + +SET search_path TO auditor; +CREATE TABLE IF NOT EXISTS auditor_wire_out_inconsistency +( + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY, + destination_account TEXT NOT NULL, + expected taler_amount, + claimed taler_amount, + suppressed BOOLEAN NOT NULL DEFAULT FALSE +); +COMMENT ON TABLE auditor_wire_out_inconsistency + IS 'Report a (serious) wire inconsistency in the exchange''s database';