From 8b0652c02ec7ec219b1b3b3f901f86573fb1064a Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Tue, 8 May 2012 23:32:44 +0400 Subject: Added windows setup --- setup/windows/windows.cfg | 130 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 130 insertions(+) create mode 100644 setup/windows/windows.cfg (limited to 'setup/windows/windows.cfg') diff --git a/setup/windows/windows.cfg b/setup/windows/windows.cfg new file mode 100644 index 000000000..e804dacaa --- /dev/null +++ b/setup/windows/windows.cfg @@ -0,0 +1,130 @@ + + + + + + + + org.h2.Driver + jdbc:h2:[DATABASE] + sa + + + + 300 + + + + 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); + + + + id - Integer + imei - String + <--> + + SELECT id, imei + FROM devices + + + + imei - String + <--> + + INSERT INTO devices (imei) + VALUES (:imei) + + + + id - Integer + imei - String + <--> + + UPDATE devices + SET imei = :imei + WHERE id = :id + + + + id - Integer + <--> + + DELETE FROM devices + WHERE id = :id + + + + device_id - Integer + <--> + + SELECT * + FROM positions + WHERE device_id = :device_id + + + + device_id - Integer + time - Date + valid - Boolean + latitude - Double + longitude - Double + speed - Double + course - Double + power - Double (NULL for some protocols) + 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) + + + + true + 8082 + + + false + [LOG] + + + true + 5000 + 0 + + + true + 5001 + 0 + + + true + 5002 + 0 + + + true + 5003 + 0 + + + true + 5004 + 0 + + + true + 5005 + 0 + + + true + 5006 + 0 + + + true + 5007 + 0 + + -- cgit v1.2.3