From f119326f307635dddc6306d4f5a4e349e808b48a Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Wed, 6 May 2015 23:33:12 +1200
Subject: Display markers on the map

---
 default.cfg | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'default.cfg')

diff --git a/default.cfg b/default.cfg
index 5401b93da..3bc523bf1 100644
--- a/default.cfg
+++ b/default.cfg
@@ -16,7 +16,7 @@
         imei - String
     <-->
     <entry key='database.selectDevice'>
-        SELECT id, unique_id as imei
+        SELECT id, uniqueId as imei
         FROM device;
     </entry>
 
@@ -32,8 +32,8 @@
         extended_info - String (XML)
     <-->
     <entry key='database.insertPosition'>
-        INSERT INTO position (device_id, server_time, device_time, fix_time, valid, latitude, longitude, altitude, speed, course, address, other)
-        VALUES (:device_id, NOW(), :time, :time, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :extended_info);
+        INSERT INTO position (deviceId, serverTime, deviceTime, fixTime, valid, latitude, longitude, altitude, speed, course, address, other)
+        VALUES (:deviceId, NOW(), :time, :time, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :other);
     </entry>
 
     <!-->
@@ -41,7 +41,7 @@
         id - Long
     <-->
     <entry key='database.updateLatestPosition'>
-        UPDATE device SET position_id = :id WHERE id = :device_id;
+        UPDATE device SET positionId = :id WHERE id = :deviceId;
     </entry>
 
     <!-- Web interface -->
-- 
cgit v1.2.3