From 8c6dad8c48d5d730b102d9de0079fee9752b0d35 Mon Sep 17 00:00:00 2001
From: winter
Date: Sun, 19 Jan 2025 22:17:12 +0000
Subject: implement notifications

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

(limited to 'bin')

diff --git a/bin/cleandb b/bin/cleandb
index b33f994..4aa7b37 100755
--- a/bin/cleandb
+++ b/bin/cleandb
@@ -12,8 +12,9 @@ DELETE FROM actor WHERE deleted = true;
 DELETE FROM note WHERE deleted = true;
 DELETE FROM interaction WHERE deleted = true;
 
--- remove old timeline items
+-- remove old timeline items and notifications
 DELETE FROM home_timeline_item WHERE modified < (current_timestamp - interval '6 months');
+DELETE FROM notification WHERE created < (current_timestamp - interval '1 month');
 
 END);
 $db->commit();
\ No newline at end of file
-- 
cgit v1.3