aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGábor Somogyi <gabor.g.somogyi@gmail.com>2016-04-27 22:52:15 +0200
committerGábor Somogyi <gabor.g.somogyi@gmail.com>2016-04-27 22:52:15 +0200
commit9d5b2230caa434db5bff773b4ffa980da2adc15c (patch)
treec6b7e9e071e68952315c7e753ec4f90bc00309be
parentbf68718e05f811ffeb2b4b57acab56dca3e7de56 (diff)
downloadtraccar-server-9d5b2230caa434db5bff773b4ffa980da2adc15c.tar.gz
traccar-server-9d5b2230caa434db5bff773b4ffa980da2adc15c.tar.bz2
traccar-server-9d5b2230caa434db5bff773b4ffa980da2adc15c.zip
Windows config fix
-rw-r--r--setup/windows/traccar.xml4
1 files changed, 4 insertions, 0 deletions
diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml
index bf1b216af..80351325b 100644
--- a/setup/windows/traccar.xml
+++ b/setup/windows/traccar.xml
@@ -161,6 +161,10 @@
SELECT * FROM positions WHERE id IN (SELECT positionId FROM devices);
</entry>
+ <entry key='database.selectLatestPosition'>
+ SELECT TOP 1 * FROM positions WHERE deviceId = :deviceId AND protocol IS NOT NULL;
+ </entry>
+
<entry key='database.updateLatestPosition'>
UPDATE devices SET positionId = :id WHERE id = :deviceId;
</entry>