From 0547ba1ab3337c382d0c9fca43c97c8f3c7817d7 Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Tue, 24 Apr 2012 18:59:31 +0000 Subject: --- default.cfg | 85 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 85 insertions(+) create mode 100644 default.cfg (limited to 'default.cfg') diff --git a/default.cfg b/default.cfg new file mode 100644 index 000000000..156ee860c --- /dev/null +++ b/default.cfg @@ -0,0 +1,85 @@ + + + + + + + + org.h2.Driver + jdbc:h2:/home/user/Documents/database + sa + + + + Create database: + CREATE TABLE devices (id INT, imei VARCHAR(16)) + CREATE TABLE positions (device_id INT, time TIMESTAMP, is_valid BOOLEAN, latitude DOUBLE, longitude DOUBLE, speed DOUBLE, course DOUBLE, power DOUBLE) + <--> + + + id - Integer + imei - String + <--> + + SELECT id, imei + FROM devices + + + + 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, is_valid, latitude, longitude, speed, course, power) + VALUES (:device_id, :time, :valid, :latitude, :longitude, :speed, :course, :power) + + + + 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