diff options
| author | Neels Hofmeyr <neels@hofmeyr.de> | 2017-07-04 23:08:44 +0200 |
|---|---|---|
| committer | Neels Hofmeyr <nhofmeyr@sysmocom.de> | 2017-07-12 23:17:10 +0000 |
| commit | 29b9206e804e8e5d5f6ea6f9d8c1f8af35332480 (patch) | |
| tree | 77eed5bde035b276b63f92c0f23e944049e59897 /contrib/hlr-remove-old.sql | |
| parent | 9e3c66b1814246f6c06a6f78975f54dfe9e2cf8c (diff) | |
move openbsc/* to repos root
This is the first step in creating this repository from the legacy openbsc.git.
Like all other Osmocom repositories, keep the autoconf and automake files in
the repository root. openbsc.git has been the sole exception, which ends now.
Change-Id: I9c6f2a448d9cb1cc088cf1cf6918b69d7e69b4e7
Diffstat (limited to 'contrib/hlr-remove-old.sql')
| -rw-r--r-- | contrib/hlr-remove-old.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/contrib/hlr-remove-old.sql b/contrib/hlr-remove-old.sql new file mode 100644 index 000000000..626a331e1 --- /dev/null +++ b/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; |