From 41c46575a92f746622c61b07004b7a0832712a54 Mon Sep 17 00:00:00 2001
From: Abyss777 <abyss@fox5.ru>
Date: Tue, 31 May 2016 08:56:10 +0500
Subject: - Renamed eventTime to serverTime

- Fixed bracket indentation
---
 setup/unix/traccar.xml    | 6 +++---
 setup/windows/traccar.xml | 6 +++---
 2 files changed, 6 insertions(+), 6 deletions(-)

(limited to 'setup')

diff --git a/setup/unix/traccar.xml b/setup/unix/traccar.xml
index 22b71e204..a0233e601 100644
--- a/setup/unix/traccar.xml
+++ b/setup/unix/traccar.xml
@@ -177,12 +177,12 @@
     </entry>
 
     <entry key='database.insertEvent'>
-        INSERT INTO events (type, eventTime, deviceId, positionId, attributes)
-        VALUES (:type, :eventTime, :deviceId, :positionId, :attributes);
+        INSERT INTO events (type, serverTime, deviceId, positionId, attributes)
+        VALUES (:type, :serverTime, :deviceId, :positionId, :attributes);
     </entry>
 
     <entry key='database.selectEvents'>
-        SELECT * FROM events WHERE deviceId = :deviceId AND type LIKE :type AND eventTime BETWEEN :from AND :to ORDER BY eventTime DESC;
+        SELECT * FROM events WHERE deviceId = :deviceId AND type LIKE :type AND serverTime BETWEEN :from AND :to ORDER BY serverTime DESC;
     </entry>
 
     <!-- PROTOCOL CONFIG -->
diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml
index 649c3bb15..5748f3993 100644
--- a/setup/windows/traccar.xml
+++ b/setup/windows/traccar.xml
@@ -177,12 +177,12 @@
     </entry>
 
     <entry key='database.insertEvent'>
-        INSERT INTO events (type, eventTime, deviceId, positionId, attributes)
-        VALUES (:type, :eventTime, :deviceId, :positionId, :attributes);
+        INSERT INTO events (type, serverTime, deviceId, positionId, attributes)
+        VALUES (:type, :serverTime, :deviceId, :positionId, :attributes);
     </entry>
 
     <entry key='database.selectEvents'>
-        SELECT * FROM events WHERE deviceId = :deviceId AND type LIKE :type AND eventTime BETWEEN :from AND :to ORDER BY eventTime DESC;
+        SELECT * FROM events WHERE deviceId = :deviceId AND type LIKE :type AND serverTime BETWEEN :from AND :to ORDER BY serverTime DESC;
     </entry>
 
     <!-- PROTOCOL CONFIG -->
-- 
cgit v1.2.3