From 55433eeca50ff840cb0b660f8f9de44b2bc6825f Mon Sep 17 00:00:00 2001
From: winter
Date: Sun, 19 Jan 2025 23:49:31 +0000
Subject: allow old sessions to get cleaned up

---
 bin/cleandb | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'bin')

diff --git a/bin/cleandb b/bin/cleandb
index 4aa7b37..44f55f2 100755
--- a/bin/cleandb
+++ b/bin/cleandb
@@ -16,5 +16,8 @@ DELETE FROM interaction WHERE deleted = true;
 DELETE FROM home_timeline_item WHERE modified < (current_timestamp - interval '6 months');
 DELETE FROM notification WHERE created < (current_timestamp - interval '1 month');
 
+-- throw away old sessions that would be too old anyway
+DELETE FROM session WHERE created < (current_timestamp - interval '1 year');
+
 END);
 $db->commit();
\ No newline at end of file
-- 
cgit v1.3