https://owntracks.org/booklet/tech/http/

https://medium.com/@tech_18484/deploying-a-php-web-app-with-docker-compose-nginx-and-mariadb-d61a84239c0d

https://muetsch.io/open-source-self-hosted-location-tracking-with-owntracks-and-grafana.html

-- Adminer 4.8.1 MySQL 11.1.3-MariaDB-1:11.1.3+maria~ubu2204 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `recordings`;
CREATE TABLE `recordings` (
  `user` varchar(255) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `acc` int(11) DEFAULT NULL,
  `alt` int(11) DEFAULT NULL,
  `batt` int(11) DEFAULT NULL,
  `bs` int(11) DEFAULT NULL,
  `conn` char(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `t` char(255) DEFAULT NULL,
  `tst` bigint(20) DEFAULT NULL,
  `vac` int(11) DEFAULT NULL,
  `vel` int(11) DEFAULT NULL,
  `dt` timestamp NULL DEFAULT NULL,
  `tid` char(2) DEFAULT NULL,
  `lat` decimal(9,6) DEFAULT NULL,
  `lon` decimal(9,6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `recordings` (`user`, `device`, `acc`, `alt`, `batt`, `bs`, `conn`, `created_at`, `t`, `tst`, `vac`, `vel`, `dt`, `tid`, `lat`, `lon`) VALUES
('simono41',	'6193B679-AD67-4B93-9DF2-158501A055AF',	35,	80,	80,	1,	'm',	NULL,	NULL,	'1700663979',	20,	NULL,	NULL,	'AF',	52.252686,	10.500029),
('simono41',	'6193B679-AD67-4B93-9DF2-158501A055AF',	35,	80,	80,	1,	'm',	NULL,	NULL,	'1700664006',	18,	NULL,	NULL,	'AF',	52.252533,	10.500295);

-- 2023-11-22 14:40:35