<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

<properties>

    <!-- Global confiduration -->
    <entry key="database.driver">org.h2.Driver</entry>
    <entry key="database.url">jdbc:h2:/home/user/Documents/traccar/target/database</entry>
    <entry key="database.user">sa</entry>
    <entry key="database.password"></entry>

    <!-- Database refresh delay in seconds -->
    <entry key="database.refreshDelay">300</entry>

    <!-- 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
        imei - String
    <-->
    <entry key="database.selectDevice">
        SELECT id, imei
        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
        ORDER by time DESC;
    </entry>

    <!-->
        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)
    <-->
    <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);
    </entry>

    <!-- Web interface port -->
    <entry key="http.enable">true</entry>
    <!--<entry key="http.address"></entry>-->
    <entry key="http.port">8082</entry>

    <!-- Geocoder options -->
    <entry key="geocoder.enable">false</entry>

    <!-- Logging options -->
    <entry key="logger.enable">true</entry>
    <entry key="logger.file">/home/user/Documents/traccar/target/tracker-server.log</entry>

    <!-- Xexun server configuration -->
    <entry key="xexun.enable">true</entry>
    <entry key="xexun.port">5000</entry>

    <!-- Gps103 server configuration -->
    <entry key="gps103.enable">true</entry>
    <entry key="gps103.port">5001</entry>

    <!-- Tk103 server configuration -->
    <entry key="tk103.enable">true</entry>
    <entry key="tk103.port">5002</entry>

    <!-- Gl100 server configuration -->
    <entry key="gl100.enable">true</entry>
    <entry key="gl100.port">5003</entry>

    <!-- Gl200 server configuration -->
    <entry key="gl200.enable">true</entry>
    <entry key="gl200.port">5004</entry>

    <!-- T55 server configuration -->
    <entry key="t55.enable">true</entry>
    <entry key="t55.port">5005</entry>

    <!-- Xexun 2 server configuration -->
    <entry key="xexun2.enable">true</entry>
    <entry key="xexun2.port">5006</entry>

    <!-- AVL-08 server configuration -->
    <entry key="avl08.enable">true</entry>
    <entry key="avl08.port">5007</entry>

    <!-- Enfora server configuration -->
    <entry key="enfora.enable">true</entry>
    <entry key="enfora.port">5008</entry>

    <!-- Meiligao server configuration -->
    <entry key="meiligao.enable">true</entry>
    <entry key="meiligao.port">5009</entry>

    <!-- Maxon server configuration -->
    <entry key="maxon.enable">true</entry>
    <entry key="maxon.port">5010</entry>

    <!-- ST-210 server configuration -->
    <entry key="st210.enable">true</entry>
    <entry key="st210.port">5011</entry>

    <!-- Progress server configuration -->
    <entry key="progress.enable">true</entry>
    <entry key="progress.port">5012</entry>

    <!-- H02 server configuration -->
    <entry key="h02.enable">true</entry>
    <entry key="h02.port">5013</entry>

    <!-- JT600 server configuration -->
    <entry key="jt600.enable">true</entry>
    <entry key="jt600.port">5014</entry>

    <!-- EV603 server configuration -->
    <entry key="ev603.enable">true</entry>
    <entry key="ev603.port">5015</entry>

    <!-- V680 server configuration -->
    <entry key="v680.enable">true</entry>
    <entry key="v680.port">5016</entry>

    <!-- PT502 server configuration -->
    <entry key="pt502.enable">true</entry>
    <entry key="pt502.port">5017</entry>

</properties>