diff options
| author | Gábor Somogyi <gabor.g.somogyi@gmail.com> | 2016-05-03 23:15:27 +0200 |
|---|---|---|
| committer | Gábor Somogyi <gabor.g.somogyi@gmail.com> | 2016-05-03 23:15:27 +0200 |
| commit | 1a605980b1a120614ccaeb56faac37b05a81a4e9 (patch) | |
| tree | 1fa6bf7b360e4c829c8d1ddb51b4012e46f98933 /setup | |
| parent | 572db06a7bbe15bbf98cd695d06b701ff8652b77 (diff) | |
| download | trackermap-server-1a605980b1a120614ccaeb56faac37b05a81a4e9.tar.gz trackermap-server-1a605980b1a120614ccaeb56faac37b05a81a4e9.tar.bz2 trackermap-server-1a605980b1a120614ccaeb56faac37b05a81a4e9.zip | |
Removed database.selectLatestPosition
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/unix/traccar.xml | 4 | ||||
| -rw-r--r-- | setup/windows/traccar.xml | 4 |
2 files changed, 0 insertions, 8 deletions
diff --git a/setup/unix/traccar.xml b/setup/unix/traccar.xml index 8dfcf6386..2ddf6551f 100644 --- a/setup/unix/traccar.xml +++ b/setup/unix/traccar.xml @@ -152,10 +152,6 @@ SELECT * FROM positions WHERE deviceId = :deviceId AND fixTime BETWEEN :from AND :to ORDER BY fixTime; </entry> - <entry key='database.selectLatestPosition'> - SELECT TOP 1 * FROM positions WHERE deviceId = :deviceId AND protocol IS NOT NULL; - </entry> - <entry key='database.insertPosition'> INSERT INTO positions (deviceId, protocol, serverTime, deviceTime, fixTime, valid, latitude, longitude, altitude, speed, course, address, attributes) VALUES (:deviceId, :protocol, :now, :deviceTime, :fixTime, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :attributes); diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml index 80351325b..bf1b216af 100644 --- a/setup/windows/traccar.xml +++ b/setup/windows/traccar.xml @@ -161,10 +161,6 @@ 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>
|