summaryrefslogtreecommitdiff
path: root/src/exchangedb/drop0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <grothoff@gnunet.org>2022-03-23 12:25:22 +0100
committerChristian Grothoff <grothoff@gnunet.org>2022-03-23 12:25:45 +0100
commitf0918084253f032ebc74b5a0a8ccac25cce11067 (patch)
tree48c8baa32668252248c726dc79361d5b94e9dbb9 /src/exchangedb/drop0001.sql
parent7d2a009e1b7d68a7a959c9a0bf53349fbeed582d (diff)
downloadexchange-f0918084253f032ebc74b5a0a8ccac25cce11067.tar.gz
exchange-f0918084253f032ebc74b5a0a8ccac25cce11067.tar.bz2
exchange-f0918084253f032ebc74b5a0a8ccac25cce11067.zip
more skeleton logic for P2P operations on DB
Diffstat (limited to 'src/exchangedb/drop0001.sql')
-rw-r--r--src/exchangedb/drop0001.sql24
1 files changed, 10 insertions, 14 deletions
diff --git a/src/exchangedb/drop0001.sql b/src/exchangedb/drop0001.sql
index c969286a0..60acc98a4 100644
--- a/src/exchangedb/drop0001.sql
+++ b/src/exchangedb/drop0001.sql
@@ -33,6 +33,7 @@ DROP TRIGGER IF EXISTS deposits_on_insert ON deposits;
DROP TRIGGER IF EXISTS deposits_on_delete ON deposits;
DROP TRIGGER IF EXISTS recoup_on_insert ON recoup;
DROP TRIGGER IF EXISTS recoup_on_delete ON recoup;
+
DROP TABLE IF EXISTS revolving_work_shards CASCADE;
DROP TABLE IF EXISTS extensions CASCADE;
DROP TABLE IF EXISTS auditors CASCADE;
@@ -85,50 +86,45 @@ DROP TABLE IF EXISTS recoup_by_reserve CASCADE;
DROP TABLE IF EXISTS partners CASCADE;
-DROP TABLE IF EXISTS mergers CASCADE;
+DROP TABLE IF EXISTS account_merges CASCADE;
+DROP TABLE IF EXISTS purse_merges CASCADE;
DROP TABLE IF EXISTS contracts CASCADE;
DROP TABLE IF EXISTS history_requests CASCADE;
DROP TABLE IF EXISTS close_requests CASCADE;
DROP TABLE IF EXISTS purse_requests CASCADE;
DROP TABLE IF EXISTS wads_out CASCADE;
-DROP TABLE IF EXISTS wads_out_entries CASCADE;
+DROP TABLE IF EXISTS wad_out_entries CASCADE;
DROP TABLE IF EXISTS wads_in CASCADE;
-DROP TABLE IF EXISTS wads_in_entries CASCADE;
+DROP TABLE IF EXISTS wad_in_entries CASCADE;
DROP TABLE IF EXISTS partner_accounts CASCADE;
DROP FUNCTION IF EXISTS exchange_do_withdraw;
DROP FUNCTION IF EXISTS exchange_do_withdraw_limit_check;
-
DROP FUNCTION IF EXISTS recoup_insert_trigger;
DROP FUNCTION IF EXISTS recoup_delete_trigger;
DROP FUNCTION IF EXISTS deposits_by_coin_insert_trigger;
DROP FUNCTION IF EXISTS deposits_by_coin_delete_trigger;
DROP FUNCTION IF EXISTS reserves_out_by_reserve_insert_trigger;
DROP FUNCTION IF EXISTS reserves_out_by_reserve_delete_trigger;
-
DROP FUNCTION IF EXISTS exchange_do_deposit;
-
DROP FUNCTION IF EXISTS exchange_do_melt;
-
DROP FUNCTION IF EXISTS exchange_do_refund;
-
DROP FUNCTION IF EXISTS exchange_do_recoup_to_coin;
-
DROP FUNCTION IF EXISTS exchange_do_recoup_to_reserve;
-
--- FIXME: drop other stored functions!
+DROP FUNCTION IF EXISTS exchange_do_purse_deposit;
+DROP FUNCTION IF EXISTS exchange_do_purse_merge;
+DROP FUNCTION IF EXISTS exchange_do_account_merge;
+DROP FUNCTION IF EXISTS exchange_do_history_request;
+DROP FUNCTION IF EXISTS exchange_do_close_request;
-- Unregister patch (partition-0001.sql)
-- SELECT _v.unregister_patch('partition-0001');
-- Drops for partition-0001.sql
DROP FUNCTION IF EXISTS create_table_partition;
-
DROP FUNCTION IF EXISTS create_partitions;
-
DROP FUNCTION IF EXISTS detach_default_partitions;
-
DROP FUNCTION IF EXISTS drop_default_partitions;