diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2022-03-23 12:25:22 +0100 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2022-03-23 12:25:45 +0100 |
commit | f0918084253f032ebc74b5a0a8ccac25cce11067 (patch) | |
tree | 48c8baa32668252248c726dc79361d5b94e9dbb9 /src/exchangedb/drop0001.sql | |
parent | 7d2a009e1b7d68a7a959c9a0bf53349fbeed582d (diff) | |
download | exchange-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.sql | 24 |
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; |