diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2017-08-23 01:07:21 +1200 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2017-08-23 01:07:21 +1200 |
| commit | d5ad3af86c6faa5d45b8724219bf06cdd58e3eed (patch) | |
| tree | c197879224006181510654511b505e496d5b833c | |
| parent | ebd193d4d5a98f7b53cc229f1c7287d05465b13e (diff) | |
| download | traccar-server-d5ad3af86c6faa5d45b8724219bf06cdd58e3eed.tar.gz traccar-server-d5ad3af86c6faa5d45b8724219bf06cdd58e3eed.tar.bz2 traccar-server-d5ad3af86c6faa5d45b8724219bf06cdd58e3eed.zip | |
Update clear positions SQL query
| -rw-r--r-- | setup/default.xml | 2 |
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 < :serverTime AND id NOT IN (SELECT positionId FROM devices) + DELETE FROM positions WHERE serverTime < :serverTime AND id NOT IN (SELECT positionId FROM devices WHERE positionId IS NOT NULL) </entry> <entry key='database.deleteEvents'> |