diff options
| author | martin.von.loewis <devnull@localhost> | 2009-09-02 06:52:57 +0000 |
|---|---|---|
| committer | martin.von.loewis <devnull@localhost> | 2009-09-02 06:52:57 +0000 |
| commit | 3085535d9ac06446280ef0ebf506b1b28d0fcceb (patch) | |
| tree | 743db7d17a631dc61da2758d12814ca2a54be197 /tools | |
| parent | 0593c3bd015712b3d6b7d9f26612f97895f6560a (diff) | |
| download | decorator-3085535d9ac06446280ef0ebf506b1b28d0fcceb.tar.gz | |
Add daily SQL cronjob.
Diffstat (limited to 'tools')
| -rw-r--r-- | tools/daily.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/tools/daily.sql b/tools/daily.sql new file mode 100644 index 0000000..2cc57b0 --- /dev/null +++ b/tools/daily.sql @@ -0,0 +1,3 @@ +-- run as a cronjob: psql packages -f tools/daily.sql -o /dev/null +delete from cookies where last_seen < now()-INTERVAL'1day'; +delete from openid_sessions where expires > now();
\ No newline at end of file |