diff options
Diffstat (limited to 'contrib/hlr-remove-old.sql')
-rw-r--r-- | contrib/hlr-remove-old.sql | 18 |
1 files changed, 0 insertions, 18 deletions
diff --git a/contrib/hlr-remove-old.sql b/contrib/hlr-remove-old.sql deleted file mode 100644 index 626a331e1..000000000 --- a/contrib/hlr-remove-old.sql +++ /dev/null @@ -1,18 +0,0 @@ --- Remove old data from the database -DELETE FROM Subscriber - WHERE id != 1 AND datetime('now', '-10 days') > updated AND authorized != 1; -DELETE FROM Equipment - WHERE datetime('now', '-10 days') > updated; -DELETE FROM EquipmentWatch - WHERE datetime('now', '-10 days') > updated; -DELETE FROM SMS - WHERE datetime('now', '-10 days') > created; -DELETE FROM VLR - WHERE datetime('now', '-10 days') > updated; -DELETE FROM ApduBlobs - WHERE datetime('now', '-10 days') > created; -DELETE FROM Counters - WHERE datetime('now', '-10 days') > timestamp; -DELETE FROM RateCounters - WHERE datetime('now', '-10 days') > timestamp; -VACUUM; |