aboutsummaryrefslogtreecommitdiff
path: root/setup
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2017-08-23 01:07:21 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2017-08-23 01:07:21 +1200
commitd5ad3af86c6faa5d45b8724219bf06cdd58e3eed (patch)
treec197879224006181510654511b505e496d5b833c /setup
parentebd193d4d5a98f7b53cc229f1c7287d05465b13e (diff)
downloadtraccar-server-d5ad3af86c6faa5d45b8724219bf06cdd58e3eed.tar.gz
traccar-server-d5ad3af86c6faa5d45b8724219bf06cdd58e3eed.tar.bz2
traccar-server-d5ad3af86c6faa5d45b8724219bf06cdd58e3eed.zip
Update clear positions SQL query
Diffstat (limited to 'setup')
-rw-r--r--setup/default.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/default.xml b/setup/default.xml
index 0047949eb..fea747c01 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -55,7 +55,7 @@
</entry>
<entry key='database.deletePositions'>
- DELETE FROM positions WHERE serverTime &lt; :serverTime AND id NOT IN (SELECT positionId FROM devices)
+ DELETE FROM positions WHERE serverTime &lt; :serverTime AND id NOT IN (SELECT positionId FROM devices WHERE positionId IS NOT NULL)
</entry>
<entry key='database.deleteEvents'>