aboutsummaryrefslogtreecommitdiffstats
path: root/contrib/hlr-remove-old.sql
diff options
context:
space:
mode:
authorNeels Hofmeyr <neels@hofmeyr.de>2017-09-04 04:16:57 +0200
committerNeels Hofmeyr <neels@hofmeyr.de>2017-09-06 16:33:43 +0200
commit47cd0d2687e9711644008f3d6d1b829d763c520e (patch)
tree39d013e979834b5faaf831d2a3e25229999dd26a /contrib/hlr-remove-old.sql
parentd6d90ce2597d9bbcc4dda23069cafb1794874fa7 (diff)
drop files unrelated to osmo-msc
These either remain from openbsc.git or slipped in while applying recent patches from openbsc.git and do not belong in osmo-msc. Empty out contrib: remove things that are either obviously unrelated to osmo-msc, or seem old and/or esoteric. Change-Id: I49957769e09eed6d723bf7c3777024b62b3480fd
Diffstat (limited to 'contrib/hlr-remove-old.sql')
-rw-r--r--contrib/hlr-remove-old.sql18
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;