<?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>