added auditor reporting tables

1 files changed, 30 insertions, 0 deletions

diff --git a/src/auditordb/0002-auditor_emergency_by_count.sql b/src/auditordb/0002-auditor_emergency_by_count.sql
new file mode 100644
index 000000000..4daa994a7
--- /dev/null
+++ b/src/auditordb/0002-auditor_emergency_by_count.sql
@@ -0,0 +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_emergency_by_count

+(

+    row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,

+    denompub_h BYTEA,

+    num_issued integer,

+    num_known integer,

+    risk taler_amount,

+    start BIGINT,

+    deposit_end BIGINT,

+    value taler_amount

+);

+COMMENT ON TABLE auditor_emergency_by_count

+    IS 'Report an emergency denomination.';
\ No newline at end of file