diff options
author | Christian Grothoff <christian@grothoff.org> | 2021-10-14 14:45:10 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2021-10-14 14:45:10 +0200 |
commit | 7d62fa065bba408860a79fe121a62ef8f515159c (patch) | |
tree | e03053b30346fb0c6e90ccef7f57c5d63ef8d174 /src/exchangedb/drop0001.sql | |
parent | 1b119edd6225567419add05e0a92170ebfa457df (diff) | |
download | exchange-7d62fa065bba408860a79fe121a62ef8f515159c.tar.xz |
start with KYC support in DB
Diffstat (limited to 'src/exchangedb/drop0001.sql')
-rw-r--r-- | src/exchangedb/drop0001.sql | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/src/exchangedb/drop0001.sql b/src/exchangedb/drop0001.sql index f5a28192f..507393e57 100644 --- a/src/exchangedb/drop0001.sql +++ b/src/exchangedb/drop0001.sql @@ -22,6 +22,19 @@ BEGIN; -- Unlike the other SQL files, it SHOULD be updated to reflect the -- latest requirements for dropping tables. + +-- Drops for exchange-0003.sql +DROP TABLE IF EXISTS revolving_work_shards CASCADE; + + +-- Drops for exchange-0002.sql +DROP TABLE IF EXISTS auditors CASCADE; +DROP TABLE IF EXISTS auditor_denom_sigs CASCADE; +DROP TABLE IF EXISTS exchange_sign_keys CASCADE; +DROP TABLE IF EXISTS wire_accounts CASCADE; +DROP TABLE IF EXISTS signkey_revocations CASCADE; +DROP TABLE IF EXISTS work_shards CASCADE; + -- Drops for 0001.sql DROP TABLE IF EXISTS prewire CASCADE; DROP TABLE IF EXISTS recoup CASCADE; @@ -42,8 +55,15 @@ DROP TABLE IF EXISTS reserves CASCADE; DROP TABLE IF EXISTS denomination_revocations CASCADE; DROP TABLE IF EXISTS denominations CASCADE; --- Unregister patch (0001.sql) + +-- Unregister patch (exchange-0001.sql) SELECT _v.unregister_patch('exchange-0001'); +-- Unregister patch (exchange-0002.sql) +SELECT _v.unregister_patch('exchange-0002'); + +-- Unregister patch (exchange-0003.sql) +SELECT _v.unregister_patch('exchange-0003'); + -- And we're out of here... COMMIT; |