|
Last change
on this file since 1d748cb 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:
478 bytes
|
| Line | |
|---|
| 1 | -- $Id: purge-3.sql,v 1.1 2010/04/21 11:31:00 sbajic Exp $ |
|---|
| 2 | delete from dspam_token_data |
|---|
| 3 | where (innocent_hits*2) + spam_hits < 5 |
|---|
| 4 | and (julianday('now')-30) > julianday(last_hit); |
|---|
| 5 | delete from dspam_token_data |
|---|
| 6 | where innocent_hits + spam_hits = 1 |
|---|
| 7 | and (julianday('now')-15) > julianday(last_hit); |
|---|
| 8 | delete from dspam_token_data |
|---|
| 9 | where (julianday('now')-90) > julianday(last_hit); |
|---|
| 10 | delete from dspam_signature_data |
|---|
| 11 | where (julianday('now')-14) > julianday(created_on); |
|---|
| 12 | |
|---|
| 13 | vacuum; |
|---|
Note: See
TracBrowser
for help on using the repository browser.
