commit 2a5cfeefba54dfabafef36cd1e6418435dc5d725
parent 5521d156af02e11cf36b384a78e85c4e1a3f486b
Author: Christian Grothoff <grothoff@gnunet.org>
Date: Wed, 7 May 2025 17:24:59 +0200
drop dead tables
Diffstat:
4 files changed, 0 insertions(+), 152 deletions(-)
diff --git a/src/exchangedb/0002-aml_status.sql b/src/exchangedb/0002-aml_status.sql
@@ -1,101 +0,0 @@
---
--- This file is part of TALER
--- Copyright (C) 2014--2022 Taler Systems SA
---
--- TALER is free software; you can redistribute it and/or modify it under the
--- terms of the GNU General Public License as published by the Free Software
--- Foundation; either version 3, or (at your option) any later version.
---
--- TALER is distributed in the hope that it will be useful, but WITHOUT ANY
--- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
--- A PARTICULAR PURPOSE. See the GNU General Public License for more details.
---
--- You should have received a copy of the GNU General Public License along with
--- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/>
---
-
-CREATE OR REPLACE FUNCTION create_table_aml_status(
- IN partition_suffix TEXT DEFAULT NULL
-)
-RETURNS VOID
-LANGUAGE plpgsql
-AS $$
-DECLARE
- table_name TEXT DEFAULT 'aml_status';
-BEGIN
- PERFORM create_partitioned_table(
- 'CREATE TABLE IF NOT EXISTS %I'
- '(aml_status_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY'
- ',h_payto BYTEA PRIMARY KEY CHECK (LENGTH(h_payto)=32)'
- ',threshold taler_amount NOT NULL DEFAULT(0,0)'
- ',status INT4 NOT NULL DEFAULT(0)'
- ',kyc_requirement INT8 NOT NULL DEFAULT(0)'
- ') %s ;'
- ,table_name
- ,'PARTITION BY HASH (h_payto)'
- ,partition_suffix
- );
- PERFORM comment_partitioned_table(
- 'AML status for a particular payment destination'
- ,table_name
- ,partition_suffix
- );
- PERFORM comment_partitioned_column(
- 'hash of the payto://-URI this AML status is about'
- ,'h_payto'
- ,table_name
- ,partition_suffix
- );
- PERFORM comment_partitioned_column(
- 'monthly inbound transaction limit below which we are OK (if status is 1)'
- ,'threshold'
- ,table_name
- ,partition_suffix
- );
- PERFORM comment_partitioned_column(
- '0 for all OK, 1 for AML decision required, 2 for account is frozen (prevents further transactions)'
- ,'status'
- ,table_name
- ,partition_suffix
- );
-END $$;
-
-COMMENT ON FUNCTION create_table_aml_status
- IS 'Creates the aml_status table';
-
-
-CREATE OR REPLACE FUNCTION constrain_table_aml_status(
- IN partition_suffix TEXT
-)
-RETURNS void
-LANGUAGE plpgsql
-AS $$
-DECLARE
- table_name TEXT DEFAULT 'aml_status';
-BEGIN
- table_name = concat_ws('_', table_name, partition_suffix);
- EXECUTE FORMAT (
- 'ALTER TABLE ' || table_name ||
- ' ADD CONSTRAINT ' || table_name || '_serial_key '
- 'UNIQUE (aml_status_serial_id)'
- );
-END $$;
-
-
-INSERT INTO exchange_tables
- (name
- ,version
- ,action
- ,partitioned
- ,by_range)
- VALUES
- ('aml_status'
- ,'exchange-0002'
- ,'create'
- ,TRUE
- ,FALSE),
- ('aml_status'
- ,'exchange-0002'
- ,'constrain'
- ,TRUE
- ,FALSE);
diff --git a/src/exchangedb/0005-aml_status.sql b/src/exchangedb/0005-aml_status.sql
@@ -1,46 +0,0 @@
---
--- This file is part of TALER
--- Copyright (C) 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/>
---
-
-CREATE FUNCTION alter_table_aml_status5(
- IN partition_suffix TEXT DEFAULT NULL
-)
-RETURNS VOID
-LANGUAGE plpgsql
-AS $$
-DECLARE
- table_name TEXT DEFAULT 'aml_status';
-BEGIN
- PERFORM create_partitioned_table(
- 'DROP TABLE %I;'
- ,table_name
- ,''
- ,partition_suffix
- );
-END $$;
-
-
-INSERT INTO exchange_tables
- (name
- ,version
- ,action
- ,partitioned
- ,by_range)
- VALUES
- ('aml_status5'
- ,'exchange-0005'
- ,'alter'
- ,TRUE
- ,FALSE);
diff --git a/src/exchangedb/exchange-0002.sql.in b/src/exchangedb/exchange-0002.sql.in
@@ -111,7 +111,6 @@ COMMENT ON TYPE exchange_do_select_deposits_missing_wire_return_type
#include "0002-purse_actions.sql"
#include "0002-purse_deletion.sql"
#include "0002-kyc_attributes.sql"
-#include "0002-aml_status.sql"
#include "0002-aml_staff.sql"
#include "0002-aml_history.sql"
diff --git a/src/exchangedb/exchange-0005.sql.in b/src/exchangedb/exchange-0005.sql.in
@@ -27,9 +27,5 @@ SET search_path TO exchange;
#include "0005-kyc_events.sql"
#include "0005-kycauths_in.sql"
--- drops:
-#include "0005-aml_status.sql"
-#include "0005-legitimization_requirements.sql"
-
COMMIT;
