From 73f1943342354f5a3922561ca7ebefad239ce153 Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Fri, 2 Nov 2012 18:44:36 +1300 Subject: Update config files (fix #74) --- setup/windows/windows.cfg | 31 ++++++++++++++++++++++++++----- 1 file changed, 26 insertions(+), 5 deletions(-) (limited to 'setup/windows') diff --git a/setup/windows/windows.cfg b/setup/windows/windows.cfg index f9ab829c8..fbe008aeb 100644 --- a/setup/windows/windows.cfg +++ b/setup/windows/windows.cfg @@ -25,7 +25,7 @@ <--> SELECT id, imei - FROM devices + FROM devices; @@ -33,7 +33,7 @@ <--> INSERT INTO devices (imei) - VALUES (:imei) + VALUES (:imei); @@ -43,7 +43,7 @@ UPDATE devices SET imei = :imei - WHERE id = :id + WHERE id = :id; @@ -51,7 +51,7 @@ <--> DELETE FROM devices - WHERE id = :id + WHERE id = :id; @@ -61,6 +61,7 @@ SELECT * FROM positions WHERE device_id = :device_id + ORDER by time DESC; @@ -76,7 +77,7 @@ <--> INSERT INTO positions (device_id, time, valid, latitude, longitude, speed, course, power) - VALUES (:device_id, :time, :valid, :latitude, :longitude, :speed, :course, :power) + VALUES (:device_id, :time, :valid, :latitude, :longitude, :speed, :course, :power); @@ -135,4 +136,24 @@ true 5011 + + true + 5012 + + + true + 5013 + + + true + 5014 + + + true + 5015 + + + true + 5016 + -- cgit v1.2.3