aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_gc.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/exchange_do_gc.sql')
-rw-r--r--src/exchangedb/exchange_do_gc.sql26
1 files changed, 13 insertions, 13 deletions
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 $$;
-
-
-