From f5e305c4ea89210a2e4daffa4e947acdc440fbe7 Mon Sep 17 00:00:00 2001 From: williamchitto Date: Tue, 31 Jul 2012 08:08:53 -0300 Subject: adicionando classes de testes --- setup/windows/windows.cfg | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) (limited to 'setup') diff --git a/setup/windows/windows.cfg b/setup/windows/windows.cfg index 273b0700b..3487189f6 100644 --- a/setup/windows/windows.cfg +++ b/setup/windows/windows.cfg @@ -16,7 +16,7 @@ CREATE TABLE IF NOT EXISTS devices (id INT IDENTITY, imei VARCHAR(16)); - CREATE TABLE IF NOT EXISTS positions (device_id INT, time TIMESTAMP, valid BOOLEAN, latitude DOUBLE, longitude DOUBLE, speed DOUBLE, course DOUBLE, power DOUBLE); + CREATE TABLE IF NOT EXISTS positions (device_id INT, time TIMESTAMP, valid BOOLEAN, latitude DOUBLE, longitude DOUBLE, speed DOUBLE, course DOUBLE, power DOUBLE, mode INT); @@ -72,11 +72,12 @@ speed - Double course - Double power - Double (NULL for some protocols) + mode - Integer extended_info - String (XML) <--> 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, :mode) @@ -84,7 +85,7 @@ 8082 - false + true [LOG] @@ -136,5 +137,10 @@ true 5009 0 + + + true + 5010 + 0 -- cgit v1.2.3