Holger Hans Peter Freyther | 037065d | 2012-09-07 19:09:10 +0200 | [diff] [blame] | 1 | -- Remove old data from the database |
| 2 | DELETE FROM Subscriber |
| 3 | WHERE id != 1 AND datetime('now', '-10 days') > updated AND authorized != 1; |
| 4 | DELETE FROM Equipment |
| 5 | WHERE datetime('now', '-10 days') > updated; |
| 6 | DELETE FROM EquipmentWatch |
| 7 | WHERE datetime('now', '-10 days') > updated; |
| 8 | DELETE FROM SMS |
| 9 | WHERE datetime('now', '-10 days') > created; |
| 10 | DELETE FROM VLR |
| 11 | WHERE datetime('now', '-10 days') > updated; |
| 12 | DELETE FROM ApduBlobs |
| 13 | WHERE datetime('now', '-10 days') > created; |
| 14 | DELETE FROM Counters |
| 15 | WHERE datetime('now', '-10 days') > timestamp; |
| 16 | DELETE FROM RateCounters |
| 17 | WHERE datetime('now', '-10 days') > timestamp; |
| 18 | VACUUM; |