diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2015-04-25 20:51:38 +1200 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2015-04-25 20:51:38 +1200 |
| commit | b10cebd692b610a13ea27b6150a79726de59f40e (patch) | |
| tree | 31919802ddae807fa4887446addc9eb98d5fbe50 /default.cfg | |
| parent | 67dc1c43932bffaf9df2c9ec201cff879d0226d9 (diff) | |
| download | trackermap-server-b10cebd692b610a13ea27b6150a79726de59f40e.tar.gz trackermap-server-b10cebd692b610a13ea27b6150a79726de59f40e.tar.bz2 trackermap-server-b10cebd692b610a13ea27b6150a79726de59f40e.zip | |
Implement async position update
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 --> |