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

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

<properties>

    <!-- Global confiduration -->
    <entry key="database.driver">com.mysql.jdbc.Driver</entry>
    <entry key="database.url">jdbc:mysql://localhost/gts?allowMultiQueries=true</entry>
    <entry key="database.user">root</entry>
    <entry key="database.password">root</entry>

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

    <entry key="database.selectDevice">
        SELECT imeiNumber AS id, imeiNumber AS imei FROM Device WHERE imeiNumber &lt;&gt; '';
    </entry>

    <entry key="database.insertDevice">
        DO 0;
    </entry>

    <entry key="database.updateDevice">
        DO 0;
    </entry>

    <entry key="database.deleteDevice">
        DO 0;
    </entry>

    <entry key="database.selectPosition">
        DO 0;
    </entry>

    <entry key="database.insertPosition">
        START TRANSACTION;
            UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:time), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = :device_id;
            SELECT @accountID := accountID, @deviceID := deviceID FROM Device WHERE imeiNumber = :device_id;
            INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime)
            VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :course, :altitude, '', UNIX_TIMESTAMP(NOW()));
        COMMIT;
    </entry>

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

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

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

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

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

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

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

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

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

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

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

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

</properties>