From 852c46668f1c9f766de9473c50e787e32a0f8697 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Sun, 10 Sep 2023 19:13:49 +0200 Subject: major exchange DB schema change: store common properties of batch deposit in batch_deposits table, and coin-specific ones in coin_deposits table; plus minor cleanups --- src/exchangedb/exchange_do_gc.sql | 26 +++++++++++++------------- 1 file changed, 13 insertions(+), 13 deletions(-) (limited to 'src/exchangedb/exchange_do_gc.sql') diff --git a/src/exchangedb/exchange_do_gc.sql b/src/exchangedb/exchange_do_gc.sql index 75dd120d7..5758cb2d2 100644 --- a/src/exchangedb/exchange_do_gc.sql +++ b/src/exchangedb/exchange_do_gc.sql @@ -23,7 +23,7 @@ DECLARE reserve_uuid_min INT8; -- minimum reserve UUID still alive melt_min INT8; -- minimum melt still alive coin_min INT8; -- minimum known_coin still alive - deposit_min INT8; -- minimum deposit still alive + batch_deposit_min INT8; -- minimum deposit still alive reserve_out_min INT8; -- minimum reserve_out still alive denom_min INT8; -- minimum denomination still alive BEGIN @@ -104,22 +104,25 @@ SELECT ORDER BY known_coin_id ASC LIMIT 1; -DELETE FROM exchange.deposits - WHERE known_coin_id < coin_min; +DELETE FROM exchange.batch_deposits + WHERE wire_deadline < in_ancient_date; SELECT - deposit_serial_id + batch_deposit_serial_id INTO - deposit_min - FROM exchange.deposits - ORDER BY deposit_serial_id ASC + batch_deposit_min + FROM exchange.coin_deposits + ORDER BY batch_deposit_serial_id ASC LIMIT 1; DELETE FROM exchange.refunds - WHERE deposit_serial_id < deposit_min; - + WHERE batch_deposit_serial_id < batch_deposit_min; DELETE FROM exchange.aggregation_tracking - WHERE deposit_serial_id < deposit_min; + WHERE batch_deposit_serial_id < batch_deposit_min; +DELETE FROM exchange.coin_deposits + WHERE batch_deposit_serial_id < batch_deposit_min; + + SELECT denominations_serial @@ -133,6 +136,3 @@ DELETE FROM exchange.cs_nonce_locks WHERE max_denomination_serial <= denom_min; END $$; - - - -- cgit v1.2.3