diff options
Diffstat (limited to 'default.cfg')
-rw-r--r-- | default.cfg | 8 |
1 files changed, 4 insertions, 4 deletions
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 --> |