From d0835367865b5a0ae941abcec2c1c2d067f10b25 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Fri, 28 Jul 2023 12:27:46 +0200 Subject: combine v3 and v4 of exchange schema into v2 due to major incompatible tuple change forthcoming --- src/exchangedb/0004-kyc_attributes.sql | 44 ---------------------------------- 1 file changed, 44 deletions(-) delete mode 100644 src/exchangedb/0004-kyc_attributes.sql (limited to 'src/exchangedb/0004-kyc_attributes.sql') diff --git a/src/exchangedb/0004-kyc_attributes.sql b/src/exchangedb/0004-kyc_attributes.sql deleted file mode 100644 index e45d46b3..00000000 --- a/src/exchangedb/0004-kyc_attributes.sql +++ /dev/null @@ -1,44 +0,0 @@ --- --- This file is part of TALER --- Copyright (C) 2023 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 --- - -CREATE OR REPLACE FUNCTION master_table_kyc_attributes_V2() -RETURNS VOID -LANGUAGE plpgsql -AS $$ -DECLARE - table_name VARCHAR DEFAULT 'kyc_attributes'; -BEGIN - EXECUTE FORMAT ( - 'ALTER TABLE ' || table_name || - ' DROP COLUMN birthdate;' - ); -END $$; - -COMMENT ON FUNCTION master_table_kyc_attributes_V2 - IS 'Removes birthdate column from the kyc_attributes table'; - -INSERT INTO exchange_tables - (name - ,version - ,action - ,partitioned - ,by_range) - VALUES - ('kyc_attributes_V2' - ,'exchange-0004' - ,'master' - ,TRUE - ,FALSE); -- cgit v1.2.3