diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2022-07-25 22:49:59 +0200 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2022-07-25 22:49:59 +0200 |
commit | d2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8 (patch) | |
tree | 437053864b5f9b86aa6178e536f9f6ee83af68bf /src/auditordb/drop.sql | |
parent | 6d2e6d80613e6f45d207f89bc25f6f507a131504 (diff) | |
download | exchange-d2ec1bf3cf55f9dc8384a468c7f2bf5efb3db4d8.tar.xz |
move auditor database also into schema
Diffstat (limited to 'src/auditordb/drop.sql')
-rw-r--r-- | src/auditordb/drop.sql | 26 |
1 files changed, 1 insertions, 25 deletions
diff --git a/src/auditordb/drop.sql b/src/auditordb/drop.sql index 8e42c8094..37a50ee68 100644 --- a/src/auditordb/drop.sql +++ b/src/auditordb/drop.sql @@ -17,34 +17,10 @@ -- Everything in one big transaction BEGIN; --- This script DROPs all of the tables we create, including the --- versioning schema! --- --- Unlike the other SQL files, it SHOULD be updated to reflect the --- latest requirements for dropping tables. - --- Drops for 0001.sql -DROP TABLE IF EXISTS auditor_predicted_result; -DROP TABLE IF EXISTS auditor_historic_denomination_revenue; -DROP TABLE IF EXISTS auditor_balance_summary; -DROP TABLE IF EXISTS auditor_denomination_pending; -DROP TABLE IF EXISTS auditor_reserve_balance; -DROP TABLE IF EXISTS auditor_wire_fee_balance; -DROP TABLE IF EXISTS auditor_reserves; -DROP TABLE IF EXISTS auditor_progress_reserve; -DROP TABLE IF EXISTS auditor_progress_aggregation; -DROP TABLE IF EXISTS auditor_progress_deposit_confirmation; -DROP TABLE IF EXISTS auditor_progress_coin; -DROP TABLE IF EXISTS auditor_exchange_signkeys; -DROP TABLE IF EXISTS wire_auditor_progress; -DROP TABLE IF EXISTS wire_auditor_account_progress; -DROP TABLE IF EXISTS auditor_historic_reserve_summary CASCADE; -DROP TABLE IF EXISTS auditor_denominations CASCADE; -DROP TABLE IF EXISTS deposit_confirmations CASCADE; -DROP TABLE IF EXISTS auditor_exchanges CASCADE; -- Drop versioning (auditor-0001.sql) SELECT _v.unregister_patch('auditor-0001'); +DROP SCHEMA auditor CASCADE; -- And we're out of here... COMMIT; |