| -- 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; |