aboutsummaryrefslogtreecommitdiff
path: root/setup
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2017-05-12 04:15:50 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2017-05-12 04:15:50 +1200
commitdd32e2d8d149f1394ac79d5178ad365892e7df76 (patch)
tree8cd4a15e1de9d875cd490e1ca4af3901266f93ce /setup
parentb5a311cad65f3be723981e9c338fadc33c20bcf6 (diff)
downloadtrackermap-server-dd32e2d8d149f1394ac79d5178ad365892e7df76.tar.gz
trackermap-server-dd32e2d8d149f1394ac79d5178ad365892e7df76.tar.bz2
trackermap-server-dd32e2d8d149f1394ac79d5178ad365892e7df76.zip
Clear event history (fix #3160)
Diffstat (limited to 'setup')
-rw-r--r--setup/default.xml4
1 files changed, 4 insertions, 0 deletions
diff --git a/setup/default.xml b/setup/default.xml
index 82f2798dd..e80c516dd 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -289,6 +289,10 @@
DELETE FROM positions WHERE serverTime &lt; :serverTime AND id NOT IN (SELECT positionId FROM devices)
</entry>
+ <entry key='database.deleteEvents'>
+ DELETE FROM events WHERE serverTime &lt; :serverTime
+ </entry>
+
<entry key='database.selectAttributeAliases'>
SELECT * FROM attribute_aliases
</entry>