-fileformat dos->unix

20 files changed, 560 insertions, 560 deletions

diff --git a/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql b/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql
index 007f69ea1..69b64bc41 100644
--- 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
index a3b9b73dc..c5a222251 100644
--- 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
index 9556da788..93484f399 100644
--- 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
index 2e4b38356..ea5210d68 100644
--- 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
index 7bf4539ab..029bc90e0 100644
--- 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
index 4143beac4..94ea0a351 100644
--- 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
index b63b5fd00..5fcd3cd06 100644
--- 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
index c217a61d4..ff8ba405a 100644
--- 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
index 317c487a6..1cea6caa6 100644
--- 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
index 23bd90887..48050412d 100644
--- 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
index 80bc1e1f4..e7f6078f0 100644
--- 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
index 9d0152b7f..c42d17c6c 100644
--- 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
index e80a7bec8..533f35681 100644
--- 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
index 380d80ae8..12618d101 100644
--- 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
index 1a9e1c7f2..e2e8aed05 100644
--- 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
index d09a73225..ef0381bd1 100644
--- 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
index c56aace3a..6fae517bf 100644
--- 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
index 5e9116e80..d50828865 100644
--- 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
index cbb6bcce7..dc95f7956 100644
--- 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
index 5ee3211ab..484fd2ac6 100644
--- 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';