merchant-0036-drop.sql.fragment (3918B)
1 -- 2 -- This file is part of TALER 3 -- Copyright (C) 2026 Taler Systems SA 4 -- 5 -- TALER is free software; you can redistribute it and/or modify it under the 6 -- terms of the GNU General Public License as published by the Free Software 7 -- Foundation; either version 3, or (at your option) any later version. 8 -- 9 -- TALER is distributed in the hope that it will be useful, but WITHOUT ANY 10 -- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR 11 -- A PARTICULAR PURPOSE. See the GNU General Public License for more details. 12 -- 13 -- You should have received a copy of the GNU General Public License along with 14 -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> 15 16 -- Drop the now-empty per-instance tables from the merchant schema. 17 -- CASCADE removes the (now obsolete) trigger attachments along with them. 18 -- The per-instance trigger functions in merchant.* (handle_category_changes, 19 -- merchant_*_statistics_trigger, ...) are kept around — they will be replaced 20 -- by the procedures.sql reload after the patch finishes. 21 22 DROP TABLE merchant.merchant_unclaim_signatures CASCADE; 23 DROP TABLE merchant.merchant_used_tokens CASCADE; 24 DROP TABLE merchant.merchant_issued_tokens CASCADE; 25 DROP TABLE merchant.merchant_token_family_keys CASCADE; 26 DROP TABLE merchant.merchant_token_families CASCADE; 27 DROP TABLE merchant.merchant_webhook CASCADE; 28 DROP TABLE merchant.merchant_transfer_signatures CASCADE; 29 DROP TABLE merchant.merchant_expected_transfer_to_coin CASCADE; 30 DROP TABLE merchant.merchant_transfers CASCADE; 31 DROP TABLE merchant.merchant_expected_transfers CASCADE; 32 DROP TABLE merchant.merchant_kyc CASCADE; 33 DROP TABLE merchant.merchant_deposits CASCADE; 34 DROP TABLE merchant.merchant_deposit_confirmations CASCADE; 35 DROP TABLE merchant.merchant_refund_proofs CASCADE; 36 DROP TABLE merchant.merchant_refunds CASCADE; 37 DROP TABLE merchant.merchant_order_token_blinded_sigs CASCADE; 38 DROP TABLE merchant.merchant_order_locks CASCADE; 39 DROP TABLE merchant.merchant_inventory_locks CASCADE; 40 DROP TABLE merchant.merchant_product_categories CASCADE; 41 DROP TABLE merchant.merchant_template CASCADE; 42 DROP TABLE merchant.merchant_otp_devices CASCADE; 43 DROP TABLE merchant.merchant_inventory CASCADE; 44 DROP TABLE merchant.merchant_product_groups CASCADE; 45 DROP TABLE merchant.merchant_money_pots CASCADE; 46 DROP TABLE merchant.merchant_categories CASCADE; 47 DROP TABLE merchant.merchant_contract_terms CASCADE; 48 DROP TABLE merchant.merchant_orders CASCADE; 49 DROP TABLE merchant.merchant_custom_units CASCADE; 50 DROP TABLE merchant.merchant_builtin_unit_overrides CASCADE; 51 DROP TABLE merchant.merchant_login_tokens CASCADE; 52 DROP TABLE merchant.merchant_donau_instances CASCADE; 53 DROP TABLE merchant.merchant_reports CASCADE; 54 DROP TABLE merchant.merchant_keys CASCADE; 55 DROP TABLE merchant.merchant_accounts CASCADE; 56 DROP TABLE merchant.merchant_statistic_amount_event CASCADE; 57 DROP TABLE merchant.merchant_statistic_counter_event CASCADE; 58 DROP TABLE merchant.merchant_statistic_interval_amount CASCADE; 59 DROP TABLE merchant.merchant_statistic_interval_counter CASCADE; 60 DROP TABLE merchant.merchant_statistic_interval_meta CASCADE; 61 DROP TABLE merchant.merchant_statistic_bucket_amount CASCADE; 62 DROP TABLE merchant.merchant_statistic_bucket_counter CASCADE; 63 DROP TABLE merchant.merchant_statistic_bucket_meta CASCADE;