From af8205cb3b609d4618691cd1ba81da34b341df3d Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Mon, 7 May 2012 21:08:44 +0400
Subject: Added database schema creation

---
 default.cfg | 22 +++++++++++-----------
 1 file changed, 11 insertions(+), 11 deletions(-)

(limited to 'default.cfg')

diff --git a/default.cfg b/default.cfg
index 77312d588..b5c76fd42 100644
--- a/default.cfg
+++ b/default.cfg
@@ -13,11 +13,11 @@
     <!-- Database refresh delay in seconds -->
     <entry key="database.refreshDelay">300</entry>
 
-    <!-->
-        Create database:
-        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)
-    <-->
+    <!-- Create database schema -->
+    <entry key="database.initialize">
+        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);
+    </entry>
 
     <!-->
         id - Integer
@@ -25,7 +25,7 @@
     <-->
     <entry key="database.selectDevice">
         SELECT id, imei
-        FROM devices
+        FROM devices;
     </entry>
 
     <!-->
@@ -33,7 +33,7 @@
     <-->
     <entry key="database.insertDevice">
         INSERT INTO devices (imei)
-        VALUES (:imei)
+        VALUES (:imei);
     </entry>
 
     <!-->
@@ -43,7 +43,7 @@
     <entry key="database.updateDevice">
         UPDATE devices
         SET imei = :imei
-        WHERE id = :id
+        WHERE id = :id;
     </entry>
 
     <!-->
@@ -51,7 +51,7 @@
     <-->
     <entry key="database.deleteDevice">
         DELETE FROM devices
-        WHERE id = :id
+        WHERE id = :id;
     </entry>
 
     <!-->
@@ -60,7 +60,7 @@
     <entry key="database.selectPosition">
         SELECT *
         FROM positions
-        WHERE device_id = :device_id
+        WHERE device_id = :device_id;
     </entry>
 
     <!-->
@@ -76,7 +76,7 @@
     <-->
     <entry key="database.insertPosition">
         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);
     </entry>
 
     <!-- Web interface port -->
-- 
cgit v1.2.3