8082 ./web false google info ./logs/tracker-server.log true true 86400 true true true ./media web,mail https://www.traccar.org/analytics/ true true true ./schema/changelog-master.xml SELECT * FROM tc_users WHERE email = :email OR login = :email SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime BETWEEN :from AND :to ORDER BY fixTime SELECT tc_positions.* FROM tc_positions INNER JOIN tc_devices ON tc_positions.id = tc_devices.positionid; UPDATE tc_devices SET positionId = :id WHERE id = :deviceId SELECT * FROM tc_events WHERE deviceId = :deviceId AND serverTime BETWEEN :from AND :to ORDER BY serverTime SELECT * FROM tc_statistics WHERE captureTime BETWEEN :from AND :to ORDER BY captureTime