|
Last change
on this file since ab298e7 was
c5c522c,
checked in by Edwin Eefting <edwin@datux.nl>, 9 years ago
|
|
initial commit, transferred from cleaned syn3 svn tree
|
-
Property mode set to
100644
|
|
File size:
422 bytes
|
| Line | |
|---|
| 1 | -- $Id: purge-2.sql,v 1.0 2009/12/22 12:25:59 sbajic Exp $ |
|---|
| 2 | delete from dspam_token_data |
|---|
| 3 | where (innocent_hits*2) + spam_hits < 5 |
|---|
| 4 | and date('now')-date(last_hit) > 30; |
|---|
| 5 | delete from dspam_token_data |
|---|
| 6 | where innocent_hits + spam_hits = 1 |
|---|
| 7 | and date('now')-date(last_hit) > 15; |
|---|
| 8 | delete from dspam_token_data |
|---|
| 9 | where date('now')-date(last_hit) > 90; |
|---|
| 10 | delete from dspam_signature_data |
|---|
| 11 | where date('now')-date(created_on) > 14; |
|---|
Note: See
TracBrowser
for help on using the repository browser.
