diff options
Diffstat (limited to 'bin/cleandb')
| -rwxr-xr-x | bin/cleandb | 3 |
1 files changed, 2 insertions, 1 deletions
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 |