diff options
author | Gábor Somogyi <gabor.g.somogyi@gmail.com> | 2016-04-27 22:52:15 +0200 |
---|---|---|
committer | Gábor Somogyi <gabor.g.somogyi@gmail.com> | 2016-04-27 22:52:15 +0200 |
commit | 9d5b2230caa434db5bff773b4ffa980da2adc15c (patch) | |
tree | c6b7e9e071e68952315c7e753ec4f90bc00309be | |
parent | bf68718e05f811ffeb2b4b57acab56dca3e7de56 (diff) | |
download | traccar-server-9d5b2230caa434db5bff773b4ffa980da2adc15c.tar.gz traccar-server-9d5b2230caa434db5bff773b4ffa980da2adc15c.tar.bz2 traccar-server-9d5b2230caa434db5bff773b4ffa980da2adc15c.zip |
Windows config fix
-rw-r--r-- | setup/windows/traccar.xml | 4 |
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>
|