summaryrefslogtreecommitdiff
path: root/lib/Multi/Maintenance.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-10-03 12:40:24 +0200
committerYorhel <git@yorhel.nl>2019-10-03 15:08:56 +0200
commit97bfe01c28df6df181aa3fa6e4e9cecd983efb11 (patch)
tree96ed89d2df7b8927c60e800ca12041d34bda4bfb /lib/Multi/Maintenance.pm
parent89483d60d5df8346473a50734df4825210c70d3b (diff)
SQL: Change sessions.lastused into sessions.expires
This will be helpful when adding other types of sessions with different expiration.
Diffstat (limited to 'lib/Multi/Maintenance.pm')
-rw-r--r--lib/Multi/Maintenance.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Multi/Maintenance.pm b/lib/Multi/Maintenance.pm
index 4281ff67..1ef68dbf 100644
--- a/lib/Multi/Maintenance.pm
+++ b/lib/Multi/Maintenance.pm
@@ -90,7 +90,7 @@ my %dailies = (
WHERE NOT EXISTS(SELECT 1 FROM vn WHERE rgraph = vg.id)
AND NOT EXISTS(SELECT 1 FROM producers WHERE rgraph = vg.id)|,
- cleansessions => q|DELETE FROM sessions WHERE lastused < NOW()-'1 month'::interval|,
+ cleansessions => q|DELETE FROM sessions WHERE expires < NOW()|,
cleannotifications => q|DELETE FROM notifications WHERE read < NOW()-'1 month'::interval|,
cleannotifications2=> q|DELETE FROM notifications WHERE id IN (
SELECT id FROM (SELECT id, row_number() OVER (PARTITION BY uid ORDER BY id DESC) > 500 from notifications) AS x(id,del) WHERE x.del)|,