From 131152712d834b39f44ae94ab5d2db04520d3125 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Sun, 6 May 2012 08:56:39 +0000
Subject:

---
 default.cfg | 40 ++++++++++++++++++++++++++++++++++++++--
 1 file changed, 38 insertions(+), 2 deletions(-)

(limited to 'default.cfg')

diff --git a/default.cfg b/default.cfg
index e16223dfd..3c432d092 100644
--- a/default.cfg
+++ b/default.cfg
@@ -15,8 +15,8 @@
 
     <!-->
         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)
+        CREATE TABLE devices (id INT IDENTITY imei VARCHAR(16))
+        CREATE TABLE positions (device_id INT, time TIMESTAMP, valid BOOLEAN, latitude DOUBLE, longitude DOUBLE, speed DOUBLE, course DOUBLE, power DOUBLE)
     <-->
 
     <!-->
@@ -28,6 +28,41 @@
         FROM devices
     </entry>
 
+    <!-->
+        imei - String
+    <-->
+    <entry key="database.insertDevice">
+        INSERT INTO devices (imei)
+        VALUES (:imei)
+    </entry>
+
+    <!-->
+        id - Integer
+        imei - String
+    <-->
+    <entry key="database.updateDevice">
+        UPDATE devices
+        SET imei = :imei
+        WHERE id = :id
+    </entry>
+
+    <!-->
+        id - Integer
+    <-->
+    <entry key="database.deleteDevice">
+        DELETE FROM devices
+        WHERE id = :id
+    </entry>
+
+    <!-->
+        device_id - Integer
+    <-->
+    <entry key="database.selectPosition">
+        SELECT *
+        FROM positions
+        WHERE device_id = :device_id
+    </entry>
+
     <!-->
         device_id - Integer
         time - Date
@@ -45,6 +80,7 @@
     </entry>
 
     <!-- Web interface port -->
+    <entry key="http.enable">true</entry>
     <entry key="http.port">8082</entry>
 
     <!-- Logging options -->
-- 
cgit v1.2.3