diff options
| author | Neels Hofmeyr <neels@hofmeyr.de> | 2017-09-04 03:35:30 +0200 |
|---|---|---|
| committer | Neels Hofmeyr <neels@hofmeyr.de> | 2017-09-06 16:47:47 +0200 |
| commit | 1e52928ad9e87f2db0a9abe0ba37d2c9c2629463 (patch) | |
| tree | 21581a95387fb508d5ac12bfb62fb572be4aaffc /contrib/hlr-remove-old.sql | |
| parent | 075cac02b0e346e1fdb1176f7434a900999ec6f5 (diff) | |
drop files unrelated to osmo-sgsn
These either remain from openbsc.git or slipped in while applying recent
patches from openbsc.git and do not belong in osmo-sgsn.
Change-Id: Ie9dc7514c3850010d0e9b3ab716b4f4e8d83594f
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; |