From 037065deeed3d239a562bb7a900bb01e5146a09d Mon Sep 17 00:00:00 2001 From: Holger Hans Peter Freyther Date: Fri, 7 Sep 2012 19:09:10 +0200 Subject: contrib: Add some SQL statements to remove old subscribers --- openbsc/contrib/hlr-remove-old.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 openbsc/contrib/hlr-remove-old.sql (limited to 'openbsc') diff --git a/openbsc/contrib/hlr-remove-old.sql b/openbsc/contrib/hlr-remove-old.sql new file mode 100644 index 000000000..626a331e1 --- /dev/null +++ b/openbsc/contrib/hlr-remove-old.sql @@ -0,0 +1,18 @@ +-- 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; -- cgit v1.2.3