diff options
Diffstat (limited to 'default.cfg')
| -rw-r--r-- | default.cfg | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/default.cfg b/default.cfg index a97e4ec78..841d2168e 100644 --- a/default.cfg +++ b/default.cfg @@ -16,8 +16,8 @@ imei - String <--> <entry key='database.selectDevice'> - SELECT id, uniqueId as imei - FROM devices; + SELECT id, unique_id as imei + FROM device; </entry> <!--> @@ -32,8 +32,8 @@ extended_info - String (XML) <--> <entry key='database.insertPosition'> - INSERT INTO positions (device_id, time, valid, latitude, longitude, altitude, speed, course, power, address, other) - VALUES (:device_id, :time, :valid, :latitude, :longitude, :altitude, :speed, :course, :power, :address, :extended_info); + 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); </entry> <!--> @@ -41,7 +41,7 @@ id - Long <--> <entry key='database.updateLatestPosition'> - UPDATE devices SET latestPosition_id = :id WHERE id = :device_id; + UPDATE device SET position_id = :id WHERE id = :device_id; </entry> <!-- Web interface --> |