<?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:3306/[DATABASE]?allowMultiQueries=true</entry>
    <entry key='database.user'>[USER]</entry>
    <entry key='database.password'>[PASSWORD]</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.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, address)
            VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address);
        COMMIT;
    </entry>

    <entry key='database.updateLatestPosition'>
        DO 0;
    </entry>

    <!-- Web interface port -->
    <entry key='http.enable'>false</entry>

    <!-- Geocoder options -->
    <entry key='geocoder.enable'>true</entry>

    <!-- Logging options -->
    <entry key='logger.enable'>true</entry>
    <entry key='logger.file'>[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>

    <!-- TR20 server configuration -->
    <entry key='tr20.enable'>true</entry>
    <entry key='tr20.port'>5018</entry>

    <!-- Navis server configuration -->
    <entry key='navis.enable'>true</entry>
    <entry key='navis.port'>5019</entry>

    <!-- Meitrack server configuration -->
    <entry key='meitrack.enable'>true</entry>
    <entry key='meitrack.port'>5020</entry>

    <!-- Skypatrol server configuration -->
    <entry key='skypatrol.enable'>true</entry>
    <entry key='skypatrol.port'>5021</entry>

    <!-- GT02 server configuration -->
    <entry key='gt02.enable'>true</entry>
    <entry key='gt02.port'>5022</entry>

    <!-- GT06 server configuration -->
    <entry key='gt06.enable'>true</entry>
    <entry key='gt06.port'>5023</entry>

</properties>