diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2022-03-18 15:40:24 +0100 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2022-03-18 15:47:25 +0100 |
commit | badfde896217b1f1da3831872acbcda79f6b2cc9 (patch) | |
tree | 6fd8a61600ad1ffc92095199823935c10aa6b535 /src/exchangedb/drop0001.sql | |
parent | e909f5701bb787223f1947f988a1ffd741f2a1e0 (diff) | |
download | exchange-badfde896217b1f1da3831872acbcda79f6b2cc9.tar.gz exchange-badfde896217b1f1da3831872acbcda79f6b2cc9.tar.bz2 exchange-badfde896217b1f1da3831872acbcda79f6b2cc9.zip |
add deposits_by_coin table to speed-up certain queries (in theory)
Diffstat (limited to 'src/exchangedb/drop0001.sql')
-rw-r--r-- | src/exchangedb/drop0001.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/exchangedb/drop0001.sql b/src/exchangedb/drop0001.sql index 2b510cbae..aabfdb5e2 100644 --- a/src/exchangedb/drop0001.sql +++ b/src/exchangedb/drop0001.sql @@ -29,6 +29,8 @@ SELECT _v.unregister_patch('exchange-0001'); -- Drops for exchange-0001.sql DROP TRIGGER IF EXISTS reserves_out_on_insert ON reserves_out; DROP TRIGGER IF EXISTS reserves_out_on_delete ON reserves_out; +DROP TRIGGER IF EXISTS deposits_on_insert ON deposits; +DROP TRIGGER IF EXISTS deposits_on_delete ON deposits; DROP TABLE IF EXISTS revolving_work_shards CASCADE; DROP TABLE IF EXISTS extensions CASCADE; DROP TABLE IF EXISTS auditors CASCADE; |