-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : jeu. 04 avr. 2024 à 14:00
-- Version du serveur : 8.0.36-0ubuntu0.22.04.1
-- Version de PHP : 8.1.2-1ubuntu2.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données : `activefleet_default`
--

-- --------------------------------------------------------

--
-- Structure de la table `af_alerts`
--

CREATE TABLE `af_alerts` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `type` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `schedules` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notifications` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `af_alert_device`
--

CREATE TABLE `af_alert_device` (
  `alert_id` int UNSIGNED NOT NULL,
  `device_id` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `af_alert_geofence`
--

CREATE TABLE `af_alert_geofence` (
  `alert_id` int UNSIGNED NOT NULL,
  `geofence_id` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `af_apps`
--

CREATE TABLE `af_apps` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `description` text,
  `keyword` varchar(250) NOT NULL,
  `url` varchar(250) DEFAULT NULL,
  `icon` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_apps`
--

INSERT INTO `af_apps` (`id`, `name`, `description`, `keyword`, `url`, `icon`) VALUES
(1, 'Support', NULL, 'support', '../track/', 'assets/theme/media/img/apps/support_g.png'),
(2, 'Suivi', NULL, 'track', '../track/', 'assets/theme/media/img/apps/track_g.png'),
(3, 'Alertes', NULL, 'alerts', '../alerts/', 'assets/theme/media/img/apps/alerts_g.png'),
(4, 'Historique', NULL, 'history', '../history/', 'assets/theme/media/img/apps/history_g.png'),
(5, 'Rapports', NULL, 'reports', '../reports/', 'assets/theme/media/img/apps/reports_g.png'),
(6, 'Capteurs', NULL, 'sensors', '../sensors/', 'assets/theme/media/img/apps/sensors_g.png'),
(7, 'Entretiens et Rappels', NULL, 'maintenance', '../maintenance/', 'assets/theme/media/img/apps/maintenance_g.png'),
(8, 'Eco-Driving', NULL, 'ecodriving', '../ecodriving/', 'assets/theme/media/img/apps/ecodriving_g.png'),
(9, 'Gestion des conducteurs', NULL, 'drivers', '../drivers/', 'assets/theme/media/img/apps/drivers_g.png'),
(10, 'Gestion de Contrats LLD', NULL, 'lld', '../lld/', 'assets/theme/media/img/apps/lld_g.png'),
(11, 'Gestion des comptes', NULL, 'admin', '../admin/', 'assets/theme/media/img/apps/admin_g.png'),
(12, 'Parc Automobile', NULL, 'vehicles', '../vehicles/', 'assets/theme/media/img/apps/vehicles_g.png'),
(13, 'Gestion des coûts', NULL, 'costs', '../costs/', 'assets/theme/media/img/apps/costs_g.png'),
(14, 'Gestion des assurances', NULL, 'insurance', '../insurance/', 'assets/theme/media/img/apps/insurance_g.png');

-- --------------------------------------------------------

--
-- Structure de la table `af_apps_log`
--

CREATE TABLE `af_apps_log` (
  `id` int NOT NULL,
  `app_id` int NOT NULL,
  `user_id` int NOT NULL,
  `datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_apps_log`
--

INSERT INTO `af_apps_log` (`id`, `app_id`, `user_id`, `datetime`) VALUES
(1, 2, 1, '2024-04-04 13:53:43'),
(2, 11, 1, '2024-04-04 13:55:15');

-- --------------------------------------------------------

--
-- Structure de la table `af_carsharing`
--

CREATE TABLE `af_carsharing` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `device_id` int NOT NULL,
  `datetime_from` datetime DEFAULT NULL,
  `datetime_to` datetime DEFAULT NULL,
  `reservation_motive` text NOT NULL,
  `refuse_motive` text,
  `cancel_motive` text,
  `status` varchar(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_changelogs`
--

CREATE TABLE `af_changelogs` (
  `id` int NOT NULL,
  `version` varchar(250) NOT NULL,
  `date` date NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_changelogs`
--

INSERT INTO `af_changelogs` (`id`, `version`, `date`, `description`) VALUES
(1, 'v9.10.1', '2019-06-19', 'Bugs fixes & improvements');

-- --------------------------------------------------------

--
-- Structure de la table `af_chats`
--

CREATE TABLE `af_chats` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_chats_messages`
--

CREATE TABLE `af_chats_messages` (
  `id` int NOT NULL,
  `chat_id` int NOT NULL,
  `user_id` int NOT NULL,
  `content` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_client_finale`
--

CREATE TABLE `af_client_finale` (
  `id` int NOT NULL,
  `id_client_p` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_client_principale`
--

CREATE TABLE `af_client_principale` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_custom_apps`
--

CREATE TABLE `af_custom_apps` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `description` text,
  `modules` text,
  `url` varchar(250) DEFAULT NULL,
  `logo` varchar(250) DEFAULT NULL,
  `status` tinyint DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_custom_apps_users`
--

CREATE TABLE `af_custom_apps_users` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `app_id` int NOT NULL,
  `attributes` text NOT NULL,
  `status` tinyint DEFAULT NULL,
  `loged_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_device_costs`
--

CREATE TABLE `af_device_costs` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED DEFAULT NULL,
  `device_id` int UNSIGNED NOT NULL,
  `type_id` int UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `quantity` decimal(10,2) DEFAULT NULL,
  `unit_price` double(8,2) NOT NULL,
  `supplier` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `buyer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `additional` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `af_device_costs_types`
--

CREATE TABLE `af_device_costs_types` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Déchargement des données de la table `af_device_costs_types`
--

INSERT INTO `af_device_costs_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Vidange', '2019-12-23 16:19:06', '2019-12-23 16:19:06'),
(2, 'Entretien', '2019-12-23 16:19:22', '2019-12-23 16:19:22'),
(3, 'Carburant', '2019-12-23 16:19:32', '2019-12-23 16:27:02'),
(4, 'Autoroute', '2019-12-23 16:19:46', '2019-12-23 16:19:46'),
(5, 'Autre', '2019-12-23 16:26:36', '2019-12-23 16:26:36'),
(7, 'Vignette', '2019-12-23 16:27:11', '2019-12-23 16:27:11'),
(8, 'Assurance', '2020-07-02 13:15:28', '2020-07-02 13:15:28'),
(9, 'Franchise Assurance', '2020-07-02 13:15:43', '2020-07-02 13:15:43'),
(10, 'Remorquage', '2020-07-02 13:18:22', '2020-07-02 13:18:22'),
(11, 'Gardiennage', '2020-07-02 13:18:55', '2020-07-02 13:18:55'),
(12, 'Lavage', '2020-07-02 13:19:06', '2020-07-02 13:19:06'),
(13, 'Frais de déplacement', '2020-11-25 09:11:46', '2022-05-18 16:20:40');

-- --------------------------------------------------------

--
-- Structure de la table `af_device_drivers`
--

CREATE TABLE `af_device_drivers` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `device_id` int DEFAULT NULL,
  `device_port` varchar(10) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `rfid` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_device_infos`
--

CREATE TABLE `af_device_infos` (
  `id` int NOT NULL,
  `matricule` varchar(250) DEFAULT NULL,
  `flotte` varchar(250) DEFAULT NULL,
  `statut` varchar(250) DEFAULT NULL,
  `avenant` varchar(250) DEFAULT NULL,
  `duree_contrat` int DEFAULT NULL,
  `date_reception` date DEFAULT NULL,
  `montant_mensuel` float DEFAULT NULL,
  `km_debut` float DEFAULT NULL,
  `km_fin` float DEFAULT NULL,
  `d_pneu` varchar(250) DEFAULT NULL,
  `model_id` int DEFAULT NULL,
  `ww` varchar(250) DEFAULT NULL,
  `vin` varchar(250) DEFAULT NULL,
  `carburant` varchar(250) DEFAULT NULL,
  `vehicle_type_id` int DEFAULT NULL,
  `is_canbus` tinyint DEFAULT NULL,
  `is_carsharing` tinyint DEFAULT NULL,
  `is_privatelife` tinyint DEFAULT NULL,
  `driver` varchar(250) DEFAULT NULL,
  `creation_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_device_insurances`
--

CREATE TABLE `af_device_insurances` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `device_id` int NOT NULL,
  `usage_id` int NOT NULL,
  `company` varchar(250) DEFAULT NULL,
  `intermediary` varchar(250) DEFAULT NULL,
  `order_number` varchar(250) DEFAULT NULL,
  `policy_number` varchar(250) DEFAULT NULL,
  `warranty_start` timestamp NULL DEFAULT NULL,
  `warranty_end` timestamp NULL DEFAULT NULL,
  `insured_at` date DEFAULT NULL,
  `additional` text,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_device_insurances_usages`
--

CREATE TABLE `af_device_insurances_usages` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_device_insurances_usages`
--

INSERT INTO `af_device_insurances_usages` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'TRANSPORT DE MARCHANDISES', 1, '2024-01-31 11:25:36', '2024-01-31 11:25:36'),
(2, 'TOURISME', 1, '2024-01-31 11:25:36', '2024-01-31 11:25:36'),
(3, 'VEHICULE A DEUX OU TROIS ROUES', 1, '2024-01-31 11:25:36', '2024-01-31 11:25:36');

-- --------------------------------------------------------

--
-- Structure de la table `af_device_models`
--

CREATE TABLE `af_device_models` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `obj_prefix` varchar(250) NOT NULL,
  `description` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_device_models`
--

INSERT INTO `af_device_models` (`id`, `name`, `obj_prefix`, `description`, `created_at`, `updated_at`) VALUES
(1, 'FMA110', '110-S', NULL, '2022-04-01 10:18:23', '2022-04-01 10:18:23'),
(2, 'FMA120', '120-S', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00'),
(3, 'FMB110', '110-B', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00'),
(4, 'FMB120', '120-B', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00'),
(5, 'FMB140', '452-B', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00'),
(6, 'FM5300', '53-S', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00'),
(7, 'FMB640', '640-B', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00'),
(8, 'FMB920', '704-B', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00'),
(9, 'G1C', 'G1C', NULL, '2022-04-01 16:20:00', '2022-04-01 16:20:00');

-- --------------------------------------------------------

--
-- Structure de la table `af_device_odometer`
--

CREATE TABLE `af_device_odometer` (
  `device_id` int NOT NULL,
  `device_time` timestamp NULL DEFAULT NULL,
  `odometer` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_device_sensors`
--

CREATE TABLE `af_device_sensors` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `type` varchar(250) DEFAULT NULL,
  `icon` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_device_sensors`
--

INSERT INTO `af_device_sensors` (`id`, `name`, `type`, `icon`, `created_at`, `updated_at`) VALUES
(1, 'IGNITION', NULL, NULL, '2022-04-01 10:19:44', '2022-04-01 10:19:44'),
(2, 'RESTART', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(3, 'INTERNAL BATTERY', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(4, 'EXTERNAL BATTERY', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(5, 'GSM', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(6, 'GPS', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(7, 'ODOMETER', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(8, 'CAN SPEED', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(9, 'CAN RPM', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(10, 'CAN ODOMETER', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(11, 'CAN FUEL LEVEL %', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(12, 'CAN FUEL LEVEL L', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(13, 'CAN FUEL CONSUMPTION', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(14, 'CAN ENGINE TEMPERATURE', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(15, 'CAN DOORS STATUS', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(16, 'CAN PEDAL POSITION', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(17, 'DRIVER ID', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(18, 'TEMPERATURE SENSOR 1', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34'),
(19, 'ENGINE HOURS', NULL, NULL, '2022-04-01 16:34:34', '2022-04-01 16:34:34');

-- --------------------------------------------------------

--
-- Structure de la table `af_device_sensors_pivot`
--

CREATE TABLE `af_device_sensors_pivot` (
  `device_model_id` int NOT NULL,
  `device_sensor_id` int NOT NULL,
  `tag_name` varchar(250) NOT NULL,
  `type` varchar(200) DEFAULT NULL,
  `unit` varchar(200) DEFAULT NULL,
  `formula` varchar(200) DEFAULT NULL,
  `if_0_false` varchar(200) DEFAULT NULL,
  `if_1_true` varchar(200) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_device_sensors_pivot`
--

INSERT INTO `af_device_sensors_pivot` (`device_model_id`, `device_sensor_id`, `tag_name`, `type`, `unit`, `formula`, `if_0_false`, `if_1_true`, `created_at`, `updated_at`) VALUES
(1, 1, 'ignition', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 10:21:48', '2022-04-01 10:21:48'),
(1, 2, 'out2', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 3, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 4, 'battery', 'value', 'V', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 5, 'rssi', 'formula', '%', '*20', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 7, 'odometer', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 8, 'io81', 'value', 'km/h', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 9, 'io85', 'value', 'tr/min', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 10, 'io87', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 11, 'io89', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 12, 'io84', 'value', 'L', NULL, '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 13, 'io83', 'formula', 'L', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 14, 'coolantTemp', 'formula', '°C', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 15, 'io90', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 16, 'io82', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 17, 'driverUniqueId', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(1, 18, 'temp1', 'formula', '°C', '/10', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 1, 'ignition', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 2, 'out2', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 3, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 4, 'battery', 'value', 'V', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 5, 'rssi', 'formula', '%', '*20', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 7, 'odometer', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 8, 'io81', 'value', 'km/h', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 9, 'io85', 'value', 'tr/min', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 10, 'io87', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 11, 'io89', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 12, 'io84', 'value', 'L', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 13, 'io83', 'formula', 'L', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 14, 'coolantTemp', 'formula', '°C', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 15, 'io90', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 16, 'io82', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 17, 'driverUniqueId', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(2, 18, 'temp1', 'formula', '°C', '/10', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 1, 'ignition', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 2, 'out2', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 3, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 4, 'battery', 'value', 'V', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 5, 'rssi', 'formula', '%', '*20', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 7, 'odometer', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 8, 'io81', 'value', 'km/h', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 9, 'io85', 'value', 'tr/min', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 10, 'io87', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 11, 'io89', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 12, 'io84', 'value', 'L', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 13, 'io83', 'formula', 'L', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 14, 'coolantTemp', 'formula', '°C', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 15, 'io90', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 16, 'io82', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 17, 'driverUniqueId', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(3, 18, 'temp1', 'formula', '°C', '/10', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 1, 'ignition', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 2, 'out2', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 3, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 4, 'battery', 'value', 'V', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 5, 'rssi', 'formula', '%', '*20', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 7, 'odometer', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 8, 'io81', 'value', 'km/h', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 9, 'io85', 'value', 'tr/min', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 10, 'io87', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 11, 'io89', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 12, 'io84', 'value', 'L', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 13, 'io83', 'formula', 'L', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 14, 'coolantTemp', 'formula', '°C', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 15, 'io90', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 16, 'io82', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 17, 'driverUniqueId', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(4, 18, 'temp1', 'formula', '°C', '/10', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 1, 'ignition', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 2, 'out2', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 3, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 4, 'battery', 'value', 'V', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 5, 'rssi', 'formula', '%', '*20', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 7, 'odometer', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 8, 'io81', 'value', 'km/h', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 9, 'io85', 'value', 'tr/min', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 10, 'io87', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 11, 'io89', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 12, 'io84', 'value', 'L', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 13, 'io107', 'formula', 'L', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 14, 'coolantTemp', 'formula', '°C', '/10', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 15, 'io90', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 16, 'io82', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 17, 'driverUniqueId', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(5, 18, 'temp1', 'formula', '°C', '/10', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 1, 'di1', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 2, 'out2', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 3, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 4, 'battery', 'value', 'V', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 5, 'rssi', 'formula', '%', '*20', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 7, 'totalDistance', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(6, 10, 'io112', 'formula', 'km', '/1000', NULL, NULL, '2022-09-09 17:28:53', '2022-09-09 17:07:29'),
(6, 13, 'io86', 'formula', 'L', '/10', NULL, NULL, '2022-09-09 17:09:00', '2022-09-09 17:09:00'),
(8, 1, 'ignition', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(8, 2, 'out2', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(8, 3, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(8, 4, 'battery', 'value', 'V', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(8, 5, 'rssi', 'formula', '%', '*20', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(8, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(8, 7, 'odometer', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(9, 1, 'ignition', 'bool', NULL, NULL, 'on', 'off', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(9, 2, 'blocked', 'bool', NULL, NULL, 'autorized', 'blocked', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(9, 4, 'power', 'value', 'V', '', '', '', '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(9, 5, 'gsm', 'value', '%', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(9, 6, 'sat', 'value', NULL, NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(9, 7, 'odometer', 'formula', 'km', '/1000', NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53'),
(9, 19, 'enginehours', 'formula', 'hours', NULL, NULL, NULL, '2022-04-01 17:28:53', '2022-04-01 17:28:53');

-- --------------------------------------------------------

--
-- Structure de la table `af_device_services`
--

CREATE TABLE `af_device_services` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED DEFAULT NULL,
  `device_id` int UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `expiration_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `intervale` int NOT NULL DEFAULT '1',
  `last_service` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `trigger_event_left` int UNSIGNED NOT NULL DEFAULT '0',
  `renew_after_expiration` tinyint(1) NOT NULL DEFAULT '0',
  `expires` double UNSIGNED NOT NULL DEFAULT '0',
  `expires_date` date DEFAULT NULL,
  `remind` double UNSIGNED NOT NULL DEFAULT '0',
  `remind_date` date DEFAULT NULL,
  `event_sent` tinyint(1) NOT NULL DEFAULT '0',
  `expired` tinyint(1) NOT NULL DEFAULT '0',
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `mobile_phone` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `expiration_by_type` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `af_device_sinisters`
--

CREATE TABLE `af_device_sinisters` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `device_id` int NOT NULL,
  `insurance_id` int NOT NULL,
  `reference_number` varchar(250) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `filed_at` timestamp NULL DEFAULT NULL,
  `driver_name` varchar(250) DEFAULT NULL,
  `nature` varchar(250) DEFAULT NULL,
  `responsibility` int DEFAULT NULL,
  `percentage` int DEFAULT NULL,
  `additional` text,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_drivers`
--

CREATE TABLE `af_drivers` (
  `id` int NOT NULL,
  `manager_id` int NOT NULL,
  `device_id` int DEFAULT NULL,
  `email` varchar(250) NOT NULL,
  `username` varchar(250) NOT NULL,
  `password` varchar(128) NOT NULL,
  `salt` varchar(128) DEFAULT NULL,
  `name` varchar(250) NOT NULL,
  `token` varchar(250) DEFAULT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `company` varchar(250) DEFAULT NULL,
  `rfid` varchar(250) DEFAULT NULL,
  `loged_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_drivers_changed`
--

CREATE TABLE `af_drivers_changed` (
  `id` int NOT NULL,
  `device_id` int DEFAULT NULL,
  `devicetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `driverUniqueId` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_entretien`
--

CREATE TABLE `af_entretien` (
  `id` int NOT NULL,
  `date_evenement` date DEFAULT NULL,
  `date_operation` date DEFAULT NULL,
  `libelle` varchar(255) DEFAULT NULL,
  `type` varchar(2) DEFAULT NULL,
  `km_prevu` float DEFAULT NULL,
  `km_reel` float DEFAULT NULL,
  `garage` varchar(255) DEFAULT NULL,
  `cout` float DEFAULT NULL,
  `device_id` int DEFAULT NULL,
  `statut` int DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_events`
--

CREATE TABLE `af_events` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `device_id` int DEFAULT NULL,
  `geofence_id` int DEFAULT NULL,
  `position_id` int DEFAULT NULL,
  `alert_id` int DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `address` varchar(500) DEFAULT NULL,
  `altitude` double DEFAULT NULL,
  `course` double DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `speed` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `deleted` tinyint NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_global_log`
--

CREATE TABLE `af_global_log` (
  `id` int NOT NULL,
  `device_id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `date` date NOT NULL,
  `id_from` int DEFAULT NULL,
  `time_start` varchar(250) DEFAULT NULL,
  `latlng_start` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `addr_start` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `id_to` int DEFAULT NULL,
  `time_stop` varchar(250) NOT NULL,
  `latlng_stop` varchar(250) NOT NULL,
  `addr_stop` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `duration` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `max_speed` int NOT NULL,
  `distance` float NOT NULL,
  `driver_id` varchar(250) DEFAULT NULL,
  `overspeed` int DEFAULT NULL,
  `hard_acceleration` int DEFAULT NULL,
  `hard_braking` int DEFAULT NULL,
  `hard_cornering` int DEFAULT NULL,
  `fuel_used_start` float DEFAULT NULL,
  `fuel_used_stop` float DEFAULT NULL,
  `fuel_level_ltr_start` float DEFAULT NULL,
  `fuel_level_ltr_stop` float DEFAULT NULL,
  `fuel_level_pc_start` float DEFAULT NULL,
  `fuel_level_pc_stop` float DEFAULT NULL,
  `odometer_start` float DEFAULT NULL,
  `odometer_stop` float DEFAULT NULL,
  `overspeed_det` text,
  `hard_acceleration_det` text,
  `hard_braking_det` text,
  `hard_cornering_det` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_global_log_summary`
--

CREATE TABLE `af_global_log_summary` (
  `id` int NOT NULL,
  `device_id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `date` date NOT NULL,
  `time_start` varchar(250) DEFAULT NULL,
  `latlng_start` varchar(250) NOT NULL,
  `addr_start` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `time_stop` varchar(250) NOT NULL,
  `latlng_stop` varchar(250) NOT NULL,
  `addr_stop` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `duration` varchar(250) NOT NULL,
  `max_speed` int NOT NULL,
  `distance` float NOT NULL,
  `drivers` text,
  `overspeed` int DEFAULT NULL,
  `hard_acceleration` int DEFAULT NULL,
  `hard_braking` int DEFAULT NULL,
  `hard_cornering` int DEFAULT NULL,
  `fuel_used_start` float DEFAULT NULL,
  `fuel_used_stop` float DEFAULT NULL,
  `fuel_level_ltr_start` float DEFAULT NULL,
  `fuel_level_ltr_stop` float DEFAULT NULL,
  `fuel_level_pc_start` float DEFAULT NULL,
  `fuel_level_pc_stop` float DEFAULT NULL,
  `odometer_start` float DEFAULT NULL,
  `odometer_stop` float DEFAULT NULL,
  `distance_owt1` float DEFAULT NULL,
  `distance_owt2` float DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_map_icons`
--

CREATE TABLE `af_map_icons` (
  `id` int UNSIGNED NOT NULL,
  `path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `width` double(8,2) NOT NULL,
  `height` double(8,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Déchargement des données de la table `af_map_icons`
--

INSERT INTO `af_map_icons` (`id`, `path`, `width`, `height`) VALUES
(1, 'assets/images/map_icons/POI_219.png', 32.00, 32.00),
(2, 'assets/images/map_icons/POI_67.png', 32.00, 32.00),
(3, 'assets/images/map_icons/POI_114.png', 32.00, 32.00),
(4, 'assets/images/map_icons/POI_205.png', 32.00, 32.00),
(5, 'assets/images/map_icons/POI_30.png', 32.00, 32.00),
(6, 'assets/images/map_icons/POI_05.png', 32.00, 32.00),
(7, 'assets/images/map_icons/POI_115.png', 32.00, 32.00),
(8, 'assets/images/map_icons/POI_87.png', 32.00, 32.00),
(9, 'assets/images/map_icons/POI_28.png', 32.00, 32.00),
(10, 'assets/images/map_icons/POI_163.png', 32.00, 32.00),
(11, 'assets/images/map_icons/POI_201.png', 32.00, 32.00),
(12, 'assets/images/map_icons/POI_223.png', 32.00, 32.00),
(13, 'assets/images/map_icons/POI_69.png', 32.00, 32.00),
(14, 'assets/images/map_icons/POI_48.png', 32.00, 32.00),
(15, 'assets/images/map_icons/POI_157.png', 32.00, 32.00),
(16, 'assets/images/map_icons/POI_176.png', 32.00, 32.00),
(17, 'assets/images/map_icons/POI_204.png', 32.00, 32.00),
(18, 'assets/images/map_icons/POI_51.png', 32.00, 32.00),
(19, 'assets/images/map_icons/POI_68.png', 32.00, 32.00),
(20, 'assets/images/map_icons/POI_221.png', 32.00, 32.00),
(21, 'assets/images/map_icons/POI_155.png', 32.00, 32.00),
(22, 'assets/images/map_icons/POI_113.png', 32.00, 32.00),
(23, 'assets/images/map_icons/POI_160.png', 32.00, 32.00),
(24, 'assets/images/map_icons/POI_90.png', 32.00, 32.00),
(25, 'assets/images/map_icons/POI_99.png', 32.00, 32.00),
(26, 'assets/images/map_icons/POI_135.png', 32.00, 32.00),
(27, 'assets/images/map_icons/POI_138.png', 32.00, 32.00),
(28, 'assets/images/map_icons/POI_32.png', 32.00, 32.00),
(29, 'assets/images/map_icons/POI_03.png', 32.00, 32.00),
(30, 'assets/images/map_icons/POI_162.png', 32.00, 32.00),
(31, 'assets/images/map_icons/POI_142.png', 32.00, 32.00),
(32, 'assets/images/map_icons/POI_140.png', 32.00, 32.00),
(33, 'assets/images/map_icons/POI_218.png', 32.00, 32.00),
(34, 'assets/images/map_icons/POI_121.png', 32.00, 32.00),
(35, 'assets/images/map_icons/POI_07.png', 32.00, 32.00),
(36, 'assets/images/map_icons/POI_13.png', 32.00, 32.00),
(37, 'assets/images/map_icons/POI_11.png', 32.00, 32.00),
(38, 'assets/images/map_icons/POI_217.png', 32.00, 32.00),
(39, 'assets/images/map_icons/POI_47.png', 32.00, 32.00),
(40, 'assets/images/map_icons/POI_45.png', 32.00, 32.00),
(41, 'assets/images/map_icons/POI_33.png', 32.00, 32.00),
(42, 'assets/images/map_icons/POI_100.png', 32.00, 32.00),
(43, 'assets/images/map_icons/POI_154.png', 32.00, 32.00),
(44, 'assets/images/map_icons/POI_120.png', 32.00, 32.00),
(45, 'assets/images/map_icons/POI_92.png', 32.00, 32.00),
(46, 'assets/images/map_icons/POI_136.png', 32.00, 32.00),
(47, 'assets/images/map_icons/POI_70.png', 32.00, 32.00),
(48, 'assets/images/map_icons/POI_182.png', 32.00, 32.00),
(49, 'assets/images/map_icons/POI_44.png', 32.00, 32.00),
(50, 'assets/images/map_icons/POI_198.png', 32.00, 32.00),
(51, 'assets/images/map_icons/POI_93.png', 32.00, 32.00),
(52, 'assets/images/map_icons/POI_197.png', 32.00, 32.00),
(53, 'assets/images/map_icons/POI_91.png', 32.00, 32.00),
(54, 'assets/images/map_icons/POI_86.png', 32.00, 32.00),
(55, 'assets/images/map_icons/POI_159.png', 32.00, 32.00),
(56, 'assets/images/map_icons/POI_141.png', 32.00, 32.00),
(57, 'assets/images/map_icons/POI_49.png', 32.00, 32.00),
(58, 'assets/images/map_icons/POI_117.png', 32.00, 32.00),
(59, 'assets/images/map_icons/POI_203.png', 32.00, 32.00),
(60, 'assets/images/map_icons/POI_199.png', 32.00, 32.00),
(61, 'assets/images/map_icons/POI_71.png', 32.00, 32.00),
(62, 'assets/images/map_icons/POI_134.png', 32.00, 32.00),
(63, 'assets/images/map_icons/POI_174.png', 32.00, 32.00),
(64, 'assets/images/map_icons/POI_72.png', 32.00, 32.00),
(65, 'assets/images/map_icons/POI_31.png', 32.00, 32.00),
(66, 'assets/images/map_icons/POI_34.png', 32.00, 32.00),
(67, 'assets/images/map_icons/POI_112.png', 32.00, 32.00),
(68, 'assets/images/map_icons/POI_137.png', 32.00, 32.00),
(69, 'assets/images/map_icons/POI_116.png', 32.00, 32.00),
(70, 'assets/images/map_icons/POI_180.png', 32.00, 32.00),
(71, 'assets/images/map_icons/POI_161.png', 32.00, 32.00),
(72, 'assets/images/map_icons/POI_184.png', 32.00, 32.00),
(73, 'assets/images/map_icons/POI_53.png', 32.00, 32.00),
(74, 'assets/images/map_icons/POI_65.png', 32.00, 32.00),
(75, 'assets/images/map_icons/POI_46.png', 32.00, 32.00),
(76, 'assets/images/map_icons/POI_156.png', 32.00, 32.00),
(77, 'assets/images/map_icons/POI_17.png', 32.00, 32.00),
(78, 'assets/images/map_icons/POI_200.png', 32.00, 32.00),
(79, 'assets/images/map_icons/POI_96.png', 32.00, 32.00),
(80, 'assets/images/map_icons/POI_73.png', 32.00, 32.00),
(81, 'assets/images/map_icons/POI_143.png', 32.00, 32.00),
(82, 'assets/images/map_icons/POI_15.png', 32.00, 32.00),
(83, 'assets/images/map_icons/POI_139.png', 32.00, 32.00),
(84, 'assets/images/map_icons/POI_178.png', 32.00, 32.00),
(86, 'assets/images/map_icons/POI_183.png', 32.00, 32.00),
(87, 'assets/images/map_icons/POI_75.png', 32.00, 32.00),
(88, 'assets/images/map_icons/POI_98.png', 32.00, 32.00),
(89, 'assets/images/map_icons/POI_185.png', 32.00, 32.00),
(90, 'assets/images/map_icons/POI_74.png', 32.00, 32.00),
(91, 'assets/images/map_icons/POI_119.png', 32.00, 32.00),
(92, 'assets/images/map_icons/POI_181.png', 32.00, 32.00),
(93, 'assets/images/map_icons/POI_220.png', 32.00, 32.00),
(94, 'assets/images/map_icons/POI_122.png', 32.00, 32.00),
(95, 'assets/images/map_icons/POI_196.png', 32.00, 32.00),
(96, 'assets/images/map_icons/POI_94.png', 32.00, 32.00),
(97, 'assets/images/map_icons/POI_42.png', 32.00, 32.00),
(98, 'assets/images/map_icons/POI_101.png', 32.00, 32.00),
(99, 'assets/images/map_icons/POI_158.png', 32.00, 32.00),
(100, 'assets/images/map_icons/POI_43.png', 32.00, 32.00),
(101, 'assets/images/map_icons/POI_09.png', 32.00, 32.00),
(102, 'assets/images/map_icons/POI_179.png', 32.00, 32.00),
(103, 'assets/images/map_icons/POI_206.png', 32.00, 32.00),
(105, 'assets/images/map_icons/Status-dialog-error-icon.png', 32.00, 32.00),
(106, 'assets/images/map_icons/bus-marker.png', 32.00, 32.00),
(107, 'assets/images/map_icons/POI_SL_20.png', 32.00, 32.00),
(108, 'assets/images/map_icons/POI_SL_40.png', 32.00, 32.00),
(109, 'assets/images/map_icons/POI_SL_60.png', 32.00, 32.00),
(110, 'assets/images/map_icons/POI_SL_80.png', 32.00, 32.00),
(111, 'assets/images/map_icons/POI_SL_100.png', 32.00, 32.00);

-- --------------------------------------------------------

--
-- Structure de la table `af_marques`
--

CREATE TABLE `af_marques` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_marques`
--

INSERT INTO `af_marques` (`id`, `name`) VALUES
(1, 'AUDI'),
(2, 'BMW'),
(3, 'CITROEN'),
(4, 'FORD'),
(5, 'HYUNDAI'),
(6, 'JEEP'),
(7, 'LAND ROVER'),
(8, 'MERCEDES'),
(9, 'NISSAN'),
(10, 'OPEL'),
(11, 'PEUGEOT'),
(12, 'RENAULT'),
(13, 'SKODA'),
(14, 'VOLVO'),
(15, 'VOLKSWAGEN'),
(16, 'DACIA'),
(17, 'MAN'),
(18, 'KYMCO'),
(19, 'YAMAHA'),
(20, 'TAKADO'),
(21, 'FIAT'),
(22, 'TOYOTA'),
(23, 'DOCKER'),
(24, 'MITSUBISHI'),
(25, 'ISUZU'),
(26, 'OBC'),
(27, 'ALFA ROMEO'),
(28, 'CHEVROLET'),
(29, 'DAF'),
(30, 'DFSK'),
(32, 'DS'),
(33, 'FOTON'),
(35, 'GREAT WALL'),
(36, 'HINO'),
(37, 'HONDA'),
(38, 'IVECO'),
(39, 'JAGUAR'),
(40, 'KALMAR'),
(41, 'KIA'),
(42, 'LEXUS'),
(43, 'RANGE ROVER'),
(44, 'SCANIA'),
(45, 'SEAT'),
(46, 'SSANGYONG');

-- --------------------------------------------------------

--
-- Structure de la table `af_models`
--

CREATE TABLE `af_models` (
  `id` int NOT NULL,
  `marque_id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `reservoir` int NOT NULL,
  `co2` int NOT NULL,
  `annee` int NOT NULL,
  `estimated_fuel` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_models`
--

INSERT INTO `af_models` (`id`, `marque_id`, `name`, `reservoir`, `co2`, `annee`, `estimated_fuel`) VALUES
(1, 1, 'A4', 40, 0, 2021, 4),
(2, 1, 'Q5', 0, 0, 0, NULL),
(3, 2, 'SERIE 3', 0, 0, 0, NULL),
(4, 2, 'SERIE 5', 0, 0, 0, NULL),
(5, 2, 'X1', 0, 0, 0, NULL),
(6, 2, 'X3', 0, 0, 0, NULL),
(7, 2, 'X4', 0, 0, 0, NULL),
(8, 2, 'X5', 0, 0, 0, NULL),
(9, 3, 'BERLINGO', 0, 0, 0, NULL),
(10, 4, 'ECOSPORT', 0, 0, 0, NULL),
(11, 4, 'FIESTA', 0, 0, 0, NULL),
(12, 4, 'FOCUS', 0, 0, 0, NULL),
(13, 4, 'FUSION', 0, 0, 0, NULL),
(14, 4, 'KUGAA', 0, 0, 0, NULL),
(15, 5, 'I30', 0, 0, 0, NULL),
(16, 5, 'I40', 0, 0, 0, NULL),
(17, 5, 'SANTA FE', 0, 0, 0, NULL),
(18, 5, 'TUCSON', 54, 0, 2022, 4.8),
(19, 6, 'CHEROKEE', 0, 0, 0, NULL),
(20, 6, 'GRAND CHEROKEE', 0, 0, 0, NULL),
(21, 7, 'VOGUE', 0, 0, 0, NULL),
(22, 8, 'CLASSE E', 0, 0, 0, NULL),
(23, 8, 'GLC', 0, 0, 0, NULL),
(24, 8, 'GLE', 0, 0, 0, NULL),
(25, 9, 'QASHQAI', 0, 0, 0, NULL),
(26, 9, 'XTRAIL', 0, 0, 0, NULL),
(27, 10, 'ASTRA', 0, 0, 0, NULL),
(28, 10, 'CROSSLAND', 0, 0, 0, NULL),
(29, 11, '3008', 0, 0, 0, NULL),
(30, 11, '308', 0, 0, 0, NULL),
(31, 11, '508', 0, 0, 0, NULL),
(32, 11, 'PARTNER', 0, 0, 0, NULL),
(33, 12, 'FLUENCE', 0, 0, 0, NULL),
(34, 13, 'OCTAVIA', 0, 0, 0, NULL),
(35, 14, 'XC60', 0, 0, 0, NULL),
(36, 14, 'XC90', 0, 0, 0, NULL),
(37, 15, 'TOUAREG', 0, 0, 0, NULL),
(38, 16, 'LOGAN', 55, 90, 2017, 5.2),
(39, 16, 'DOKKER', 55, 118, 2015, 5.5),
(40, 17, 'LION\'S STAR', 0, 0, 0, 31),
(41, 5, 'COUNTY\r\n', 0, 0, 0, 15),
(42, 5, 'HD65\r\n', 0, 0, 0, NULL),
(43, 18, 'AGILITY', 0, 0, 0, NULL),
(44, 19, 'NEOS', 0, 0, 0, NULL),
(45, 20, 'E-DELIVERY', 0, 0, 0, NULL),
(46, 20, 'E-SPORTY', 0, 0, 0, NULL),
(47, 20, 'XINRI', 0, 0, 0, NULL),
(48, 1, 'A1', 0, 0, 0, NULL),
(49, 21, 'DOBLO', 0, 0, 0, NULL),
(50, 21, 'FULLBACK', 0, 0, 0, NULL),
(51, 22, 'COROLLA', 50, 87, 2020, 3.8),
(52, 15, 'CADDY', 0, 0, 0, NULL),
(53, 16, 'LODGY', 0, 0, 0, NULL),
(54, 1, 'A3', 0, 0, 0, NULL),
(56, 16, 'DUSTER', 0, 0, 0, NULL),
(57, 16, 'SANDERO', 0, 0, 0, NULL),
(58, 11, '208', 0, 0, 0, NULL),
(59, 12, 'MEGANE', 0, 0, 0, NULL),
(60, 15, 'TIGUAN', 58, 0, 2021, 6.1),
(61, 12, 'KANGOO', 0, 0, 0, NULL),
(62, 11, '301', 50, 112, 2020, 4.5),
(63, 11, '2008', 41, 97, 2020, 4.5),
(64, 11, '5008', 0, 0, 0, NULL),
(66, 23, 'C50', 0, 0, 0, NULL),
(67, 13, 'SUPERB', 66, 0, 2020, 5),
(68, 1, 'A5', 40, 0, 2020, 4.2),
(70, 25, 'NPR', 0, 0, 0, NULL),
(71, 1, 'A6', 0, 0, 0, NULL),
(72, 12, 'CLIO', 0, 0, 0, 4.4),
(75, 26, 'MOBILE', 0, 0, 0, NULL),
(76, 12, 'EXPRESS', 0, 0, 0, NULL),
(77, 27, 'GIULIA', 0, 0, 0, NULL),
(78, 27, 'GIULIETTA', 0, 0, 0, NULL),
(79, 27, 'STELVIO', 0, 0, 0, NULL),
(80, 1, 'Q7', 0, 0, 0, NULL),
(81, 1, 'Q8', 0, 0, 0, NULL),
(82, 2, 'BMW 318d', 0, 0, 0, NULL),
(83, 2, 'BMW 320d', 0, 0, 0, NULL),
(84, 2, 'BMW 420d', 0, 0, 0, NULL),
(85, 2, 'BMW 520d', 0, 0, 0, NULL),
(86, 28, 'CRUZE', 0, 0, 0, NULL),
(87, 3, 'C1', 0, 0, 0, NULL),
(88, 3, 'C3', 0, 0, 0, NULL),
(89, 3, 'C4', 0, 0, 0, NULL),
(90, 3, 'C-ELYSEE', 0, 0, 0, NULL),
(91, 3, 'JUMPER', 0, 0, 0, NULL),
(92, 29, '410', 0, 0, 0, NULL),
(93, 29, '430', 0, 0, 0, NULL),
(94, 29, ' CF', 0, 0, 0, NULL),
(95, 29, ' CF 480', 0, 0, 0, NULL),
(96, 30, 'SUPER CAB', 0, 0, 0, NULL),
(97, 32, 'DS7', 0, 0, 0, NULL),
(98, 21, '500', 0, 0, 0, NULL),
(99, 21, 'DOBLO CARGO', 0, 0, 0, NULL),
(100, 21, 'DOBLO MAXI', 0, 0, 0, NULL),
(101, 21, 'DUCATO', 0, 0, 0, NULL),
(102, 21, 'DUCATO MAXI', 0, 0, 0, NULL),
(103, 21, 'FIORINO', 0, 0, 0, NULL),
(104, 21, 'PUNTO', 0, 0, 0, NULL),
(105, 21, 'TALENTO', 0, 0, 0, NULL),
(106, 21, 'TIPO', 0, 0, 0, NULL),
(107, 4, '4136D', 0, 0, 0, NULL),
(108, 4, '4142D', 0, 0, 0, NULL),
(109, 4, 'TRANSIT', 0, 0, 0, NULL),
(110, 4, 'TRANSIT CUSTOM', 0, 0, 0, NULL),
(111, 33, 'TM', 0, 0, 0, NULL),
(113, 35, 'FLORID', 0, 0, 0, NULL),
(114, 35, 'HAVAL H5', 0, 0, 0, NULL),
(115, 36, '300', 0, 0, 0, NULL),
(116, 37, 'ACCORD', 0, 0, 0, NULL),
(117, 5, 'I20', 0, 0, 0, NULL),
(118, 5, 'I10', 0, 0, 0, NULL),
(119, 5, 'H100', 0, 0, 0, NULL),
(120, 5, 'ACCENT', 0, 0, 0, NULL),
(121, 5, 'CRETA', 0, 0, 0, NULL),
(122, 5, 'H-1', 0, 0, 0, NULL),
(123, 5, 'H350', 0, 0, 0, NULL),
(124, 25, 'D-MAX', 0, 0, 0, NULL),
(125, 25, 'EVR', 0, 0, 0, NULL),
(126, 25, 'FV', 0, 0, 0, NULL),
(127, 25, 'FVR', 0, 0, 0, NULL),
(128, 25, 'NKR', 0, 0, 0, NULL),
(129, 25, 'NN', 0, 0, 0, NULL),
(130, 25, 'NNR', 0, 0, 0, NULL),
(131, 25, 'NQR', 0, 0, 0, NULL),
(132, 38, 'ASTRA 1', 0, 0, 0, NULL),
(133, 38, 'CUBY', 0, 0, 0, NULL),
(134, 38, 'DAILY', 0, 0, 0, NULL),
(135, 38, 'EURO CARGO', 0, 0, 0, NULL),
(136, 38, 'STARLIS', 0, 0, 0, NULL),
(137, 38, 'TRAKKER 420', 0, 0, 0, NULL),
(138, 39, 'F-PACE', 0, 0, 0, NULL),
(139, 6, 'COMPASS', 0, 0, 0, NULL),
(140, 6, 'RENEGADE', 0, 0, 0, NULL),
(141, 6, 'WRANGLER', 0, 0, 0, NULL),
(142, 40, '6XLE3', 0, 0, 0, NULL),
(143, 41, 'CEED', 0, 0, 0, NULL),
(144, 41, 'K2500', 0, 0, 0, NULL),
(145, 41, 'PICANTO', 0, 0, 0, NULL),
(146, 41, 'SELTOS', 0, 0, 0, NULL),
(147, 41, 'SORENTO', 0, 0, 0, NULL),
(148, 41, 'SPORTAGE', 0, 0, 0, NULL),
(149, 7, 'DISCOVERY', 0, 0, 0, NULL),
(150, 7, 'FREELANDER', 0, 0, 0, NULL),
(151, 42, 'NX 300H', 0, 0, 0, NULL),
(152, 17, 'TGE 5.180', 0, 0, 0, NULL),
(153, 17, 'TGS', 0, 0, 0, NULL),
(154, 17, 'TGX', 0, 0, 0, NULL),
(155, 8, '220', 0, 0, 0, NULL),
(156, 8, 'A200', 0, 0, 0, NULL),
(157, 8, 'ACTROS', 0, 0, 0, NULL),
(158, 8, 'AXOR', 0, 0, 0, NULL),
(159, 8, 'B180', 0, 0, 0, NULL),
(160, 8, 'C200', 0, 0, 0, NULL),
(161, 8, 'CLASS V', 0, 0, 0, NULL),
(162, 8, 'E220', 0, 0, 0, NULL),
(163, 8, 'E220d', 0, 0, 0, NULL),
(164, 8, 'GLC 220d', 0, 0, 0, NULL),
(165, 8, 'GLE 300', 0, 0, 0, NULL),
(166, 8, 'IRIZAR', 0, 0, 0, NULL),
(167, 8, 'SPRINTER', 0, 0, 0, NULL),
(168, 8, 'VITO', 0, 0, 0, NULL),
(170, 24, '17T', 0, 0, 0, NULL),
(171, 24, '3.5T', 0, 0, 0, NULL),
(172, 24, '5.5T', 0, 0, 0, NULL),
(173, 24, '7.2T', 0, 0, 0, NULL),
(174, 24, 'FUSO CANTER', 0, 0, 0, NULL),
(175, 24, 'L200', 0, 0, 0, NULL),
(176, 24, 'PAJERO SPORT', 0, 0, 0, NULL),
(177, 24, 'FUSO FIGHTER', 0, 0, 0, NULL),
(178, 9, 'MICRA', 0, 0, 0, NULL),
(179, 10, 'COMBO', 0, 0, 0, NULL),
(180, 10, 'COMBO LIFE', 0, 0, 0, NULL),
(181, 10, 'CORSA', 0, 0, 0, NULL),
(182, 10, 'INSIGNIA', 0, 0, 0, NULL),
(183, 10, 'VIVARO', 0, 0, 0, NULL),
(184, 10, 'GRANDLAND', 0, 0, 0, NULL),
(185, 11, '206', 0, 0, 0, NULL),
(186, 11, 'BIPPER', 0, 0, 0, NULL),
(187, 11, 'BOXER', 0, 0, 0, NULL),
(188, 11, 'EXPERT', 0, 0, 0, NULL),
(189, 11, 'RIFTER', 0, 0, 0, NULL),
(190, 43, 'EVOQUE', 0, 0, 0, NULL),
(191, 43, 'SPORT', 0, 0, 0, NULL),
(192, 12, '280', 0, 0, 0, NULL),
(193, 12, '280 DXI', 0, 0, 0, NULL),
(194, 12, '340', 0, 0, 0, NULL),
(195, 12, '380 DXI', 0, 0, 0, NULL),
(196, 12, '440 DXI', 0, 0, 0, NULL),
(197, 12, 'C430', 0, 0, 0, NULL),
(198, 12, 'CAPTURE', 0, 0, 0, NULL),
(199, 12, 'KADJAR', 0, 0, 0, NULL),
(200, 12, 'KANGOO EVOLUTION', 0, 0, 0, NULL),
(201, 12, 'MASTER', 0, 0, 0, NULL),
(202, 12, 'MIDLUM', 0, 0, 0, NULL),
(203, 12, 'PREMIUM LANDER 440 DXI', 0, 0, 0, NULL),
(204, 12, 'TALISMAN', 0, 0, 0, NULL),
(205, 12, 'TRAFIC', 0, 0, 0, NULL),
(206, 14, 'XC40', 0, 0, 0, NULL),
(207, 14, 'S90', 0, 0, 0, NULL),
(208, 14, 'S60', 0, 0, 0, NULL),
(209, 14, 'FM 400', 0, 0, 0, NULL),
(210, 14, 'FM', 0, 0, 0, NULL),
(211, 14, 'FH 400', 0, 0, 0, NULL),
(212, 14, 'FH', 0, 0, 0, NULL),
(213, 14, 'F10', 0, 0, 0, NULL),
(214, 14, '420', 0, 0, 0, NULL),
(215, 44, 'G380', 0, 0, 0, NULL),
(216, 44, 'G410', 0, 0, 0, NULL),
(217, 44, 'P380', 0, 0, 0, NULL),
(218, 45, 'ATECA', 0, 0, 0, NULL),
(219, 13, 'FABIA', 0, 0, 0, NULL),
(220, 13, 'KAROQ', 0, 0, 0, NULL),
(221, 13, 'KODIAQ', 0, 0, 0, NULL),
(222, 46, 'REXTON', 0, 0, 0, NULL),
(223, 22, 'C-HR', 0, 0, 0, NULL),
(224, 22, 'COROLLA CRUISE', 0, 0, 0, NULL),
(225, 22, 'HIACE', 0, 0, 0, NULL),
(226, 22, 'HILUX', 0, 0, 0, NULL),
(227, 22, 'PRADO', 0, 0, 0, NULL),
(228, 22, 'RAV 4', 0, 0, 0, NULL),
(229, 22, 'YARIS', 0, 0, 0, NULL),
(230, 15, 'POLO', 0, 0, 0, NULL),
(231, 15, 'ARTEON', 0, 0, 0, NULL),
(232, 15, 'CRAFTER', 0, 0, 0, NULL),
(233, 15, 'GOLF', 0, 0, 0, NULL),
(234, 15, 'JETTA', 0, 0, 0, NULL),
(235, 15, 'PASSAT', 0, 0, 0, NULL),
(236, 15, 'T-ROC', 0, 0, 0, NULL),
(237, 24, 'FUSO', 0, 0, 0, NULL),
(238, 24, 'L300', 0, 0, 0, NULL),
(239, 11, '307', 0, 0, 0, NULL),
(240, 12, 'MAXITY', 0, 0, 0, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `af_models_datasheets`
--

CREATE TABLE `af_models_datasheets` (
  `id` int NOT NULL,
  `model_id` int NOT NULL,
  `reservoir` int DEFAULT NULL,
  `co2` int DEFAULT NULL,
  `annee` int DEFAULT NULL,
  `estimated_fuel` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_planner_clients`
--

CREATE TABLE `af_planner_clients` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `creation_date` datetime DEFAULT NULL,
  `modification_date` datetime DEFAULT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_planner_destinations`
--

CREATE TABLE `af_planner_destinations` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `client_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `address` text,
  `creation_date` datetime DEFAULT NULL,
  `modification_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_planner_numplaces`
--

CREATE TABLE `af_planner_numplaces` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `numplaces` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_planner_points`
--

CREATE TABLE `af_planner_points` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `address` text,
  `creation_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_planner_shifts`
--

CREATE TABLE `af_planner_shifts` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `client_id` int NOT NULL,
  `shift` int NOT NULL,
  `libelle` varchar(50) NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_planner_trips`
--

CREATE TABLE `af_planner_trips` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `shift_id` int NOT NULL,
  `no_places` int NOT NULL,
  `point_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_planner_trips_log`
--

CREATE TABLE `af_planner_trips_log` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `client_id` int NOT NULL,
  `shift_id` int NOT NULL,
  `destination_id` int NOT NULL,
  `stop_time` int NOT NULL,
  `date` datetime NOT NULL,
  `ip` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_proprivate_devices`
--

CREATE TABLE `af_proprivate_devices` (
  `id` int NOT NULL,
  `pro_id` int NOT NULL,
  `pro_uniqueid` varchar(128) NOT NULL,
  `pro_name` varchar(250) NOT NULL,
  `private_id` int NOT NULL,
  `private_uniqueid` varchar(128) NOT NULL,
  `private_name` varchar(250) NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_reports`
--

CREATE TABLE `af_reports` (
  `id` int NOT NULL,
  `group_id` int NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_reports_groups`
--

CREATE TABLE `af_reports_groups` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_reports_groups`
--

INSERT INTO `af_reports_groups` (`id`, `name`) VALUES
(1, 'Rapports de Synthèse'),
(2, 'Rapports des Trajets'),
(3, 'Vitesse'),
(4, 'Autres rapports');

-- --------------------------------------------------------

--
-- Structure de la table `af_reports_scheduled`
--

CREATE TABLE `af_reports_scheduled` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `app` varchar(250) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(200) NOT NULL,
  `format` varchar(10) NOT NULL,
  `daily` tinyint DEFAULT NULL,
  `weekly` tinyint DEFAULT NULL,
  `monthly` tinyint DEFAULT NULL,
  `emails` text,
  `time` varchar(7) NOT NULL,
  `fleets` text,
  `show_address` tinyint DEFAULT NULL,
  `price` int DEFAULT NULL,
  `status` tinyint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_reports_scheduled_devices`
--

CREATE TABLE `af_reports_scheduled_devices` (
  `report_id` int NOT NULL,
  `device_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_reports_scheduled_log`
--

CREATE TABLE `af_reports_scheduled_log` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `type` int NOT NULL,
  `format` int NOT NULL,
  `email` text,
  `filename` text NOT NULL,
  `is_auto` tinyint DEFAULT NULL,
  `status` varchar(250) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_reset_password`
--

CREATE TABLE `af_reset_password` (
  `user_id` int NOT NULL,
  `user_code` varchar(255) NOT NULL,
  `date_envoi` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_speedlimit_filtered_log`
--

CREATE TABLE `af_speedlimit_filtered_log` (
  `id` int NOT NULL,
  `device_id` int NOT NULL,
  `date` date NOT NULL,
  `device_time` datetime DEFAULT NULL,
  `speed` int DEFAULT NULL,
  `speed_limit` int DEFAULT NULL,
  `speed_limit_check` int DEFAULT NULL,
  `speed_minus_sl` int DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `osm_id` varchar(100) DEFAULT NULL,
  `driverUniqueId` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_speedlimit_log`
--

CREATE TABLE `af_speedlimit_log` (
  `id` int NOT NULL,
  `device_id` int NOT NULL,
  `date` date NOT NULL,
  `device_time` datetime DEFAULT NULL,
  `speed` int DEFAULT NULL,
  `speed_limit` int DEFAULT NULL,
  `speed_limit_check` int DEFAULT NULL,
  `speed_minus_sl` int DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `osm_id` varchar(100) DEFAULT NULL,
  `driverUniqueId` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_subscription_plans`
--

CREATE TABLE `af_subscription_plans` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_subscription_plans`
--

INSERT INTO `af_subscription_plans` (`id`, `name`) VALUES
(0, 'bronze'),
(1, 'silver'),
(2, 'gold'),
(3, 'platinum');

-- --------------------------------------------------------

--
-- Structure de la table `af_tasks`
--

CREATE TABLE `af_tasks` (
  `id` int UNSIGNED NOT NULL,
  `device_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `comment` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `priority` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '2',
  `status` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `invoice_number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pickup_address` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pickup_address_lat` double NOT NULL,
  `pickup_address_lng` double NOT NULL,
  `pickup_time` datetime DEFAULT NULL,
  `delivery_address` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `delivery_address_lat` double NOT NULL,
  `delivery_address_lng` double NOT NULL,
  `delivery_time` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `af_tasks_status`
--

CREATE TABLE `af_tasks_status` (
  `id` int UNSIGNED NOT NULL,
  `task_id` int UNSIGNED NOT NULL,
  `status` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `rating` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Déchargement des données de la table `af_tasks_status`
--

INSERT INTO `af_tasks_status` (`id`, `task_id`, `status`, `comment`, `rating`, `created_at`, `updated_at`) VALUES
(1, 1, 'new', NULL, NULL, '2023-11-29 14:47:03', '2023-11-29 14:47:03'),
(2, 1, 'pending', NULL, NULL, '2023-11-29 14:47:39', '2023-11-29 14:47:39'),
(3, 1, 'completed', NULL, 5, '2023-11-29 15:04:50', '2023-11-29 15:04:50'),
(4, 2, 'new', NULL, NULL, '2024-01-12 10:26:43', '2024-01-12 10:26:43');

-- --------------------------------------------------------

--
-- Structure de la table `af_tickets`
--

CREATE TABLE `af_tickets` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  `assigned_to` int NOT NULL,
  `subject` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `priority` varchar(255) NOT NULL,
  `status` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `af_tickets_groups`
--

CREATE TABLE `af_tickets_groups` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(250) NOT NULL,
  `service` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_tickets_groups`
--

INSERT INTO `af_tickets_groups` (`id`, `user_id`, `name`, `service`) VALUES
(1, 2, 'Général', 'Support'),
(2, 2, 'Problème logiciel / question', 'Service Technique'),
(3, 2, 'Problème d\'application mobile / question', 'Service Technique'),
(4, 2, 'Demander une nouvelle fonctionnalité (coût supplémentaire)', 'Service Développement'),
(5, 2, 'Demander une application mobile', 'Service Développement');

-- --------------------------------------------------------

--
-- Structure de la table `af_tickets_messages`
--

CREATE TABLE `af_tickets_messages` (
  `id` int NOT NULL,
  `ticket_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `attachment` varchar(255) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `af_tickets_reset_password`
--

CREATE TABLE `af_tickets_reset_password` (
  `user_id` int NOT NULL,
  `user_code` varchar(255) NOT NULL,
  `date_envoi` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_tickets_services`
--

CREATE TABLE `af_tickets_services` (
  `id` int NOT NULL,
  `name` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_user_apps`
--

CREATE TABLE `af_user_apps` (
  `user_id` int NOT NULL,
  `app_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_user_apps`
--

INSERT INTO `af_user_apps` (`user_id`, `app_id`) VALUES
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14);

-- --------------------------------------------------------

--
-- Structure de la table `af_user_device`
--

CREATE TABLE `af_user_device` (
  `user_id` int NOT NULL,
  `device_id` int NOT NULL,
  `group_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_user_log`
--

CREATE TABLE `af_user_log` (
  `user_id` int NOT NULL,
  `loged_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_user_options`
--

CREATE TABLE `af_user_options` (
  `user_id` int NOT NULL,
  `user_type` int DEFAULT NULL,
  `pl_usertype_id` int DEFAULT NULL,
  `manager_id` int DEFAULT NULL,
  `company` varchar(250) DEFAULT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `status` int NOT NULL,
  `attibutes` text NOT NULL,
  `maps` text NOT NULL,
  `subscription_plan` varchar(250) NOT NULL,
  `loged_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_user_options`
--

INSERT INTO `af_user_options` (`user_id`, `user_type`, `pl_usertype_id`, `manager_id`, `company`, `phone`, `status`, `attibutes`, `maps`, `subscription_plan`, `loged_at`) VALUES
(1, 1, 1, NULL, 'DEFAULT COMPANY', NULL, 1, '{\"groups\":[],\"map_zoom\":\"5\",\"map_type\":\"roadmap\",\"map_traffic\":\"0\",\"auto_update\":\"0\",\"status\":\"0\",\"geofences\":[\"1\",\"1\",\"1\"],\"map_labels\":\"0\"}', '{\"roadmap\":1,\"satellite\":1,\"hybrid\":1,\"terrain\":1}', 'platinum', '2024-04-04 13:55:01');

-- --------------------------------------------------------

--
-- Structure de la table `af_user_poi`
--

CREATE TABLE `af_user_poi` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `map_icon_id` int UNSIGNED NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `coordinates` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `af_user_reports`
--

CREATE TABLE `af_user_reports` (
  `user_id` int NOT NULL,
  `report_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `af_user_types`
--

CREATE TABLE `af_user_types` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_user_types`
--

INSERT INTO `af_user_types` (`id`, `name`) VALUES
(1, 'Super Administrateur'),
(2, 'Administrateur'),
(3, 'Directeur'),
(4, 'Utilisateur');

-- --------------------------------------------------------

--
-- Structure de la table `af_vehicle_status`
--

CREATE TABLE `af_vehicle_status` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_vehicle_status`
--

INSERT INTO `af_vehicle_status` (`id`, `name`) VALUES
(1, 'Roulant'),
(2, 'En maintenance'),
(3, 'Accidenté'),
(4, 'Épave');

-- --------------------------------------------------------

--
-- Structure de la table `af_vehicle_types`
--

CREATE TABLE `af_vehicle_types` (
  `id` int NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `af_vehicle_types`
--

INSERT INTO `af_vehicle_types` (`id`, `name`) VALUES
(1, '4x4'),
(2, 'Autocar/Bus'),
(3, 'Camion'),
(4, 'Engin'),
(5, 'Moto'),
(6, 'Tourisme'),
(7, 'Utilitaire léger'),
(8, 'Utilitaire lourd'),
(9, 'Pick up 2x4'),
(10, 'Pick up 4x4'),
(11, 'VAN');

-- --------------------------------------------------------

--
-- Structure de la table `af_vehicule_charges`
--

CREATE TABLE `af_vehicule_charges` (
  `id` int NOT NULL,
  `device_id` int NOT NULL,
  `date_charge` date NOT NULL,
  `type` char(1) NOT NULL,
  `montant` float NOT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `up_devices`
--

CREATE TABLE `up_devices` (
  `id` bigint NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `uniqueId` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `latestPosition_id` bigint DEFAULT NULL,
  `lastValidLatitude` double DEFAULT NULL,
  `lastValidLongitude` double DEFAULT NULL,
  `attributes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `speed` decimal(8,2) DEFAULT NULL,
  `device_time` datetime DEFAULT NULL,
  `fixTime` datetime DEFAULT NULL,
  `altitude` double DEFAULT NULL,
  `course` double DEFAULT NULL,
  `protocol` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `up_devices`
--

INSERT INTO `up_devices` (`id`, `name`, `uniqueId`, `latestPosition_id`, `lastValidLatitude`, `lastValidLongitude`, `attributes`, `speed`, `device_time`, `fixTime`, `altitude`, `course`, `protocol`) VALUES
(4, '62525-E-6', '356307049726697', 0, 33.5898706, -7.6126401, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":2,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":10.646,\"io68\":5,\"pdop\":0.0,\"hdop\":0.0,\"power\":11.625,\"io24\":0,\"tripOdometer\":97474136,\"operator\":60400,\"distance\":0.0,\"totalDistance\":0.0}', '0.00', '2024-04-04 14:00:00', '2024-04-04 14:00:00', 0, 0, 'teltonika'),
(82, '44576-B-72', '356307049731630', 0, 33.5414033, -7.6418, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":2.136,\"io68\":0,\"power\":12.583,\"distance\":0.0,\"totalDistance\":1143814.74}', '0.00', '2024-04-04 13:55:56', '2024-04-04 13:55:56', 0, 0, 'teltonika'),
(199, '35847-T-6', '356173060276065', 0, 32.6300543, -7.7945046, '{\"priority\":0,\"sat\":10,\"event\":250,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"io250\":0,\"battery\":10.632,\"io68\":1,\"pdop\":1.6,\"hdop\":0.8,\"power\":12.496,\"io24\":0,\"tripOdometer\":30774024,\"operator\":60400,\"distance\":0.0,\"totalDistance\":573007.39}', '0.00', '2024-04-04 13:59:33', '2024-04-04 13:59:33', 225, 0, 'teltonika'),
(210, '35848-T-6', '357454070527617', 0, 33.3721666, -7.577917, '{\"priority\":0,\"sat\":6,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":10.591000000000001,\"io68\":7,\"pdop\":2.2,\"hdop\":1.5,\"power\":12.068,\"io24\":0,\"tripOdometer\":54755335,\"operator\":60400,\"distance\":0.0,\"totalDistance\":8438510.64}', '0.00', '2024-04-04 13:59:26', '2024-04-04 13:59:26', 233, 0, 'teltonika'),
(263, '45805-B-72', '356307049735086', 0, 33.5693213, -7.6810583, '{\"priority\":0,\"sat\":7,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":3,\"io200\":0,\"battery\":10.523,\"io68\":39,\"pdop\":2.5,\"hdop\":1.3,\"power\":14.551,\"io24\":10,\"tripOdometer\":59082482,\"operator\":60400,\"distance\":21.78,\"totalDistance\":1108952.67}', '7.02', '2024-04-04 13:59:27', '2024-04-04 13:59:27', 78, 234, 'teltonika'),
(278, '1553-T-6', '356173060270266', 0, 33.583294, -7.6374355, '{\"priority\":0,\"sat\":17,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"battery\":9.212,\"io68\":0,\"pdop\":1.1,\"hdop\":0.6000000000000001,\"power\":14.007,\"io24\":6,\"tripOdometer\":109727001,\"operator\":60400,\"distance\":9.73,\"totalDistance\":955508.07}', '3.78', '2024-04-04 13:59:22', '2024-04-04 13:59:22', 40, 217, 'teltonika'),
(353, '202286WW', '350317176567877', 0, 33.542155, -7.64107, '{\"priority\":0,\"sat\":10,\"event\":0,\"ignition\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":58,\"io82\":18,\"io250\":1,\"power\":14.133000000000001,\"axisX\":31,\"axisY\":20,\"axisZ\":-12,\"io84\":80,\"io85\":1675,\"door\":0,\"io87\":9603800,\"io100\":13538,\"io105\":1470050,\"io107\":1244,\"distance\":29.42,\"totalDistance\":324126.3,\"motion\":true,\"hours\":54981820}', '29.70', '2024-04-04 14:00:00', '2024-04-04 14:00:00', 83, 342, 'teltonika'),
(361, '44077-B-72', '356173064848794', 0, 33.541722, -7.6427666, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":2,\"motion\":false,\"rssi\":2,\"io200\":0,\"battery\":9.169,\"io68\":0,\"pdop\":2.5,\"hdop\":1.0,\"power\":12.235,\"io24\":0,\"tripOdometer\":43951191,\"operator\":60400,\"distance\":0.0,\"totalDistance\":237642.91}', '0.00', '2024-04-04 13:59:00', '2024-04-04 13:59:00', 0, 0, 'teltonika'),
(385, '44645-B-72', '356307049088841', 0, 33.534796, -7.7158858, '{\"priority\":0,\"sat\":7,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"battery\":2.078,\"io68\":1,\"pdop\":2.5,\"hdop\":1.2000000000000002,\"power\":12.279,\"io24\":0,\"tripOdometer\":149888313,\"operator\":60400,\"distance\":0.0,\"totalDistance\":478153.31}', '0.00', '2024-04-04 13:59:38', '2024-04-04 13:59:38', 86, 0, 'teltonika'),
(424, '36125-T-6', '356173060472672', 0, 33.5395008, -7.648454, '{\"priority\":0,\"sat\":16,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":9.574,\"io68\":0,\"pdop\":1.1,\"hdop\":0.6000000000000001,\"power\":12.314,\"io24\":0,\"tripOdometer\":52216163,\"operator\":60400,\"distance\":0.0,\"totalDistance\":802132.71}', '0.00', '2024-04-04 13:59:16', '2024-04-04 13:59:16', 81, 4, 'teltonika'),
(446, '47804-B-72', '356307049452252', 0, 33.4744596, -7.6502585, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":2,\"motion\":false,\"rssi\":2,\"io200\":0,\"battery\":10.66,\"io68\":13,\"pdop\":4.5,\"hdop\":2.5,\"power\":12.528,\"io24\":0,\"tripOdometer\":31627908,\"operator\":60400,\"distance\":0.0,\"totalDistance\":808137.6}', '0.00', '2024-04-04 13:59:23', '2024-04-04 13:59:23', 0, 0, 'teltonika'),
(456, '46450-B-72', '356173065034386', 0, 33.5399415, -7.6472311, '{\"priority\":0,\"sat\":17,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":8.183,\"io68\":0,\"pdop\":1.1,\"hdop\":0.6000000000000001,\"power\":12.692,\"io24\":0,\"tripOdometer\":134748831,\"operator\":60400,\"distance\":0.0,\"totalDistance\":1089176.6}', '0.00', '2024-04-04 13:59:35', '2024-04-04 13:59:35', 75, 0, 'teltonika'),
(473, '46458-B-72', '356173064943900', 0, 33.541356, -7.6390503, '{\"priority\":0,\"sat\":18,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":9.234,\"io68\":0,\"pdop\":1.0,\"hdop\":0.6000000000000001,\"power\":12.428,\"io24\":0,\"tripOdometer\":135816737,\"operator\":60400,\"distance\":0.0,\"totalDistance\":679278.92}', '0.00', '2024-04-04 13:59:11', '2024-04-04 13:59:11', 73, 0, 'teltonika'),
(492, '6137-T-6', '356173060477440', 0, 33.5539961, -7.596258, '{\"priority\":0,\"sat\":16,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":9.188,\"io68\":0,\"pdop\":1.1,\"hdop\":0.6000000000000001,\"power\":12.313,\"io24\":0,\"tripOdometer\":66628123,\"operator\":60400,\"distance\":0.0,\"totalDistance\":377407.12}', '0.00', '2024-04-04 13:59:47', '2024-04-04 13:59:47', 77, 218, 'teltonika'),
(550, '49231-D-8', '356173060277006', 0, 33.5414916, -7.6426631, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":0.748,\"io68\":0,\"power\":12.478,\"distance\":0.0,\"totalDistance\":521986.38}', '0.00', '2024-04-04 13:56:01', '2024-04-04 13:56:01', 0, 0, 'teltonika'),
(553, '35004-T-6', '356307049730673', 0, 33.5415558, -7.6422661, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.200000000000001,\"io68\":0,\"power\":12.526,\"distance\":0.0,\"totalDistance\":564279.54}', '0.00', '2024-04-04 13:57:16', '2024-04-04 13:57:16', 0, 0, 'teltonika'),
(626, '44889-B-72', '357454070941065', 0, 28.4962945, -11.3305185, '{\"priority\":0,\"sat\":7,\"event\":250,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"io250\":0,\"battery\":7.642,\"io68\":0,\"pdop\":2.3000000000000003,\"hdop\":1.6,\"power\":12.444,\"io24\":0,\"tripOdometer\":55259636,\"operator\":60400,\"distance\":0.0,\"totalDistance\":387692.31}', '0.00', '2024-04-04 13:59:57', '2024-04-04 13:59:57', 31, 86, 'teltonika'),
(638, '19744-B/72', '356173064955730', 0, 35.7196701, -5.9225053, '{\"priority\":0,\"sat\":10,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":10.765,\"io68\":0,\"pdop\":1.5,\"hdop\":0.8,\"power\":12.252,\"io24\":0,\"tripOdometer\":93520080,\"operator\":60400,\"distance\":0.0,\"totalDistance\":305110.72}', '0.00', '2024-04-04 13:59:57', '2024-04-04 13:59:57', 13, 343, 'teltonika'),
(652, '35979-T-6', '356307046905500', 0, 33.5778071, -7.5631873, '{\"priority\":0,\"sat\":11,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":10.626,\"io68\":0,\"pdop\":1.4000000000000001,\"hdop\":0.8,\"power\":12.734,\"io24\":0,\"tripOdometer\":46471459,\"operator\":60400,\"distance\":0.0,\"totalDistance\":1204051.82}', '0.00', '2024-04-04 13:58:59', '2024-04-04 13:58:59', 74, 0, 'teltonika'),
(666, '44896-B-72', '356173065053527', 0, 31.687992, -7.9924856, '{\"priority\":0,\"sat\":17,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"battery\":9.134,\"io68\":0,\"pdop\":1.0,\"hdop\":0.6000000000000001,\"power\":13.645,\"io24\":27,\"tripOdometer\":78557158,\"operator\":60400,\"distance\":30.94,\"totalDistance\":1701075.37}', '14.58', '2024-04-04 13:59:53', '2024-04-04 13:59:53', 416, 177, 'teltonika'),
(671, '33498-B-72', '357454070549868', 0, 33.5413343, -7.6392226, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.14,\"io68\":0,\"power\":12.622,\"distance\":0.0,\"totalDistance\":2127641.47}', '0.00', '2024-04-04 13:57:55', '2024-04-04 13:57:55', 0, 0, 'teltonika'),
(672, '33497-D-72', '356173064928448', 0, 35.7636043, -5.855173, '{\"priority\":0,\"sat\":9,\"event\":250,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"io250\":0,\"battery\":9.336,\"io68\":0,\"pdop\":3.0,\"hdop\":1.6,\"power\":12.607000000000001,\"io24\":0,\"tripOdometer\":102697841,\"operator\":60400,\"distance\":0.0,\"totalDistance\":666932.12}', '0.00', '2024-04-04 13:59:42', '2024-04-04 13:59:42', 45, 200, 'teltonika'),
(690, '35845-T-6', '357454070532484', 0, 31.6566125, -8.0329366, '{\"priority\":0,\"sat\":10,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":5,\"io200\":0,\"battery\":10.742,\"io68\":1,\"pdop\":1.6,\"hdop\":0.9,\"power\":12.536,\"io24\":0,\"tripOdometer\":29598494,\"operator\":60400,\"distance\":0.0,\"totalDistance\":206733.43}', '0.00', '2024-04-04 13:59:06', '2024-04-04 13:59:06', 445, 244, 'teltonika'),
(694, '46719-D-8', '356173060468043', 0, 33.54153, -7.6423063, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.184000000000001,\"io68\":1,\"power\":12.239,\"distance\":0.0,\"totalDistance\":533733.67}', '0.00', '2024-04-04 13:58:03', '2024-04-04 13:58:03', 0, 0, 'teltonika'),
(703, '8083-T-6', '356173065041894', 0, 33.5421493, -7.6463643, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":2,\"motion\":true,\"rssi\":4,\"io200\":0,\"battery\":9.207,\"io68\":0,\"pdop\":12.3,\"hdop\":4.0,\"power\":11.936,\"io24\":0,\"tripOdometer\":41972700,\"operator\":60400,\"distance\":0.0,\"totalDistance\":744512.49}', '0.00', '2024-04-04 13:59:14', '2024-04-04 13:59:14', 0, 0, 'teltonika'),
(757, '41319-B-72', '357454070531668', 0, 33.4834958, -7.607322, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":7.234,\"io68\":0,\"power\":12.526,\"distance\":0.0,\"totalDistance\":424922.9}', '0.00', '2024-04-04 13:58:14', '2024-04-04 13:58:14', 0, 0, 'teltonika'),
(789, '113009WW', '350317176622961', 0, 31.6256933, -8.0133516, '{\"priority\":0,\"sat\":16,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":59,\"io82\":1,\"io89\":70,\"io250\":1,\"power\":14.087,\"axisX\":3,\"axisY\":-3,\"axisZ\":27,\"io85\":2379,\"door\":0,\"coolantTemp\":86.0,\"io87\":26042300,\"io100\":13163,\"io105\":3207930,\"io107\":2402,\"distance\":75.21,\"totalDistance\":666965.44,\"motion\":true,\"hours\":61305780}', '30.78', '2024-04-04 14:00:00', '2024-04-04 14:00:00', 484, 151, 'teltonika'),
(797, '35575-B-72', '357454070941131', 0, 33.4624085, -7.5164063, '{\"priority\":0,\"sat\":18,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":2,\"io200\":0,\"battery\":10.693,\"io68\":1,\"pdop\":1.0,\"hdop\":0.6000000000000001,\"power\":13.764000000000001,\"io24\":27,\"tripOdometer\":98530752,\"operator\":60400,\"distance\":31.05,\"totalDistance\":843572.32}', '14.58', '2024-04-04 13:59:54', '2024-04-04 13:59:54', 188, 209, 'teltonika'),
(823, '45867-B-72', '356307049695322', 0, 33.5416365, -7.6427956, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.15,\"io68\":0,\"power\":12.354000000000001,\"distance\":0.0,\"totalDistance\":314683.23}', '0.00', '2024-04-04 13:58:39', '2024-04-04 13:58:39', 0, 0, 'teltonika'),
(837, '45814-B-72', '356173060480634', 0, 33.541649, -7.642719, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.204,\"io68\":0,\"power\":12.497,\"distance\":0.0,\"totalDistance\":262303.57}', '0.00', '2024-04-04 13:56:14', '2024-04-04 13:56:14', 0, 0, 'teltonika'),
(854, '34567-T-6', '356173060275703', 0, 33.5419045, -7.6424345, '{\"priority\":0,\"sat\":16,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":10.619,\"io68\":7,\"pdop\":1.1,\"hdop\":0.6000000000000001,\"power\":12.312,\"io24\":0,\"tripOdometer\":18862551,\"operator\":60400,\"distance\":0.0,\"totalDistance\":79645.68}', '0.00', '2024-04-04 13:59:17', '2024-04-04 13:59:17', 86, 0, 'teltonika'),
(860, '35009-T-6', '357454070531957', 0, 0, 0, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":2,\"motion\":false,\"rssi\":3,\"io200\":0,\"battery\":10.698,\"io68\":1,\"pdop\":0.0,\"hdop\":0.0,\"power\":12.686,\"io24\":0,\"tripOdometer\":35000,\"operator\":60400,\"distance\":0.0,\"totalDistance\":0.0}', '0.00', '2015-04-18 19:01:46', '2015-04-18 19:01:46', 0, 0, 'teltonika'),
(865, '45868-B-72', '356173060467854', 0, 33.541594, -7.6429306, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.221,\"io68\":0,\"power\":12.21,\"distance\":0.0,\"totalDistance\":55233.53}', '0.00', '2024-04-04 13:57:21', '2024-04-04 13:57:21', 0, 0, 'teltonika'),
(943, '42931-B-72', '356307049233132', 0, 33.7809311, -7.1637121, '{\"priority\":0,\"sat\":14,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":10.623000000000001,\"io68\":2,\"pdop\":1.2000000000000002,\"hdop\":0.7000000000000001,\"power\":12.36,\"io24\":0,\"tripOdometer\":88894421,\"operator\":60400,\"distance\":0.0,\"totalDistance\":1470078.76}', '0.00', '2024-04-04 13:59:30', '2024-04-04 13:59:30', 60, 192, 'teltonika'),
(962, '287284WW', '350317176603896', 0, 31.6483366, -8.0132466, '{\"priority\":0,\"sat\":12,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":1,\"power\":14.064,\"axisX\":19,\"axisY\":27,\"axisZ\":-6,\"io84\":360,\"io85\":843,\"door\":0,\"io87\":10130200,\"io100\":13538,\"io105\":2910130,\"io107\":2657,\"distance\":0.0,\"totalDistance\":343240.68,\"motion\":false,\"hours\":66914630}', '0.00', '2024-04-04 13:56:24', '2024-04-04 13:56:24', 478, 332, 'teltonika'),
(980, '38585-T-6', '350544507307786', 0, 33.5399133, -7.6472816, '{\"priority\":0,\"sat\":15,\"event\":0,\"ignition\":false,\"motion\":false,\"workMode\":0,\"rssi\":5,\"di1\":0,\"io81\":0,\"io82\":0,\"io89\":0,\"io175\":0,\"io246\":0,\"io252\":0,\"power\":12.924,\"io24\":0,\"battery\":3.802,\"axisX\":35,\"axisY\":10,\"axisZ\":-33,\"io84\":0,\"io85\":0,\"door\":0,\"coolantTemp\":0.0,\"odometer\":4817274,\"io83\":0,\"io87\":0,\"io100\":13538,\"io107\":0,\"distance\":12788.55,\"totalDistance\":554451.15,\"hours\":42103990}', '0.00', '2024-04-04 12:25:21', '2024-04-04 12:25:21', 58, 0, 'teltonika'),
(986, '4191-T-6', '356173060479032', 0, 32.9860943, -7.592299, '{\"priority\":0,\"sat\":11,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":2,\"io200\":0,\"battery\":10.643,\"io68\":5,\"pdop\":1.4000000000000001,\"hdop\":0.8,\"power\":12.483,\"io24\":120,\"tripOdometer\":112168819,\"operator\":60400,\"distance\":100.62,\"totalDistance\":1206619.56}', '64.79', '2024-04-04 13:59:56', '2024-04-04 13:59:56', 415, 198, 'teltonika'),
(988, '853-T-6', '356307048877210', 0, 33.6053273, -7.5472316, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.773,\"io68\":0,\"power\":12.469,\"distance\":0.0,\"totalDistance\":849255.54}', '0.00', '2024-04-04 13:58:21', '2024-04-04 13:58:21', 0, 0, 'teltonika'),
(991, '40836-B-72', '356307049137549', 0, 33.5416476, -7.6428568, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.393,\"io68\":0,\"power\":12.755,\"distance\":0.0,\"totalDistance\":352092.34}', '0.00', '2024-04-04 13:56:57', '2024-04-04 13:56:57', 0, 0, 'teltonika'),
(1056, '34872-B-72', '356173060467110', 0, 31.654859, -8.0296876, '{\"priority\":0,\"sat\":15,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":7.277,\"io68\":0,\"pdop\":1.3,\"hdop\":0.7000000000000001,\"power\":12.827,\"io24\":0,\"tripOdometer\":87867441,\"operator\":60400,\"distance\":0.0,\"totalDistance\":1230093.79}', '0.00', '2024-04-04 13:59:07', '2024-04-04 13:59:07', 456, 0, 'teltonika'),
(1082, '45261-B-72', '356173065047453', 0, 0, 0, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":5,\"motion\":false,\"rssi\":2,\"io200\":0,\"battery\":1.375,\"io68\":0,\"pdop\":0.0,\"hdop\":0.0,\"power\":12.253,\"io24\":0,\"tripOdometer\":62181381,\"operator\":60400,\"distance\":0.0,\"totalDistance\":0.0}', '0.00', '2016-06-01 02:51:51', '2016-06-01 02:51:51', 0, 0, 'teltonika'),
(1096, '130999WW', '350544507308784', 0, 33.656725, -7.3866466, '{\"priority\":0,\"sat\":10,\"event\":0,\"ignition\":true,\"motion\":true,\"workMode\":1,\"rssi\":4,\"di1\":1,\"io81\":0,\"io82\":0,\"io89\":0,\"io175\":0,\"io246\":0,\"io252\":0,\"power\":14.266,\"io24\":6,\"battery\":4.204,\"axisX\":42,\"axisY\":-14,\"axisZ\":31,\"io84\":290,\"io85\":1039,\"door\":0,\"coolantTemp\":82.0,\"odometer\":16000,\"io83\":0,\"io87\":18067000,\"io100\":13793,\"io107\":11411,\"distance\":28.08,\"totalDistance\":1110.17,\"hours\":-2519010}', '3.24', '2024-04-01 11:46:18', '2024-04-01 11:46:18', 42, 158, 'teltonika'),
(1129, '5422-T-6', '356173060467755', 0, 33.5755314, -7.64913, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.16,\"io68\":0,\"power\":12.402000000000001,\"distance\":0.0,\"totalDistance\":289887.62}', '0.00', '2024-04-04 13:57:59', '2024-04-04 13:57:59', 0, 0, 'teltonika'),
(1139, '45262-B-72', '357454070531866', 0, 33.5701925, -7.6098121, '{\"priority\":0,\"sat\":14,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"battery\":10.737,\"io68\":1,\"pdop\":1.1,\"hdop\":0.7000000000000001,\"power\":12.63,\"io24\":0,\"tripOdometer\":187488292,\"operator\":60400,\"distance\":0.0,\"totalDistance\":747848.73}', '0.00', '2024-04-04 13:59:54', '2024-04-04 13:59:54', 56, 55, 'teltonika'),
(1153, '34752-T-6', '356307049666885', 0, 33.558324, -7.6450758, '{\"priority\":0,\"sat\":18,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":3,\"io200\":0,\"battery\":9.786,\"io68\":0,\"pdop\":1.0,\"hdop\":0.6000000000000001,\"power\":12.604000000000001,\"io24\":0,\"tripOdometer\":121881,\"operator\":60400,\"distance\":0.0,\"totalDistance\":899764.15}', '0.00', '2024-04-04 13:59:12', '2024-04-04 13:59:12', 61, 0, 'teltonika'),
(1157, '42992-D-8', '356307049684375', 0, 33.679808, -7.4242225, '{\"priority\":0,\"sat\":9,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":2,\"io200\":0,\"battery\":10.709,\"io68\":0,\"pdop\":1.6,\"hdop\":0.8,\"power\":12.504,\"io24\":0,\"tripOdometer\":75914189,\"operator\":60400,\"distance\":0.0,\"totalDistance\":769638.18}', '0.00', '2024-04-04 13:59:17', '2024-04-04 13:59:17', 38, 150, 'teltonika'),
(1168, '42879-D-8', '357454070531882', 0, 0, 0, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":6.651,\"io68\":0,\"power\":12.182,\"distance\":0.0,\"totalDistance\":0.0}', '0.00', '2024-04-04 13:56:18', '2024-04-04 13:56:18', 0, 0, 'teltonika'),
(1175, '43905-B-72', '357454070501661', 0, 33.541468, -7.64227, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.51,\"io68\":0,\"power\":12.354000000000001,\"distance\":0.0,\"totalDistance\":985898.25}', '0.00', '2024-04-04 13:56:32', '2024-04-04 13:56:32', 0, 0, 'teltonika'),
(1176, '46862-B-72', '356173065048014', 0, 33.5672533, -7.631668, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":2,\"motion\":false,\"rssi\":2,\"io200\":0,\"battery\":10.659,\"io68\":0,\"pdop\":6.7,\"hdop\":3.1,\"power\":12.137,\"io24\":0,\"tripOdometer\":29214764,\"operator\":60400,\"distance\":0.0,\"totalDistance\":237520.19}', '0.00', '2024-04-04 13:59:11', '2024-04-04 13:59:11', 0, 0, 'teltonika'),
(1181, '8412-T-6', '357454070276546', 0, 33.6113555, -7.4847271, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":7.755,\"io68\":0,\"power\":12.182,\"distance\":0.0,\"totalDistance\":582.17}', '0.00', '2024-04-04 13:57:34', '2024-04-04 13:57:34', 0, 0, 'teltonika'),
(1182, '35921-T-6', '357454070936024', 0, 33.5412873, -7.641658, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.469,\"io68\":0,\"power\":12.488,\"distance\":0.0,\"totalDistance\":369848.26}', '0.00', '2024-04-04 13:59:37', '2024-04-04 13:59:37', 0, 0, 'teltonika'),
(1184, '8693-T-6', '357454070501778', 0, 33.7174173, -7.3953811, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.198,\"io68\":0,\"power\":12.612,\"distance\":0.0,\"totalDistance\":873550.77}', '0.00', '2024-04-04 13:53:06', '2024-04-04 13:53:06', 0, 0, 'teltonika'),
(1186, '44892-B-72', '357454070528920', 0, 33.5407516, -7.6445946, '{\"priority\":0,\"sat\":19,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":6.375,\"io68\":0,\"pdop\":1.0,\"hdop\":0.6000000000000001,\"power\":11.765,\"io24\":0,\"tripOdometer\":43385354,\"operator\":60400,\"distance\":0.0,\"totalDistance\":8047267.14}', '0.00', '2024-04-04 13:59:52', '2024-04-04 13:59:52', 75, 0, 'teltonika'),
(1189, '42011-B-72', '357454070501422', 0, 33.5416618, -7.6427753, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":2,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":9.456,\"io68\":0,\"pdop\":0.0,\"hdop\":0.0,\"power\":12.289,\"io24\":0,\"tripOdometer\":23037455,\"operator\":60400,\"distance\":0.0,\"totalDistance\":191834.11}', '0.00', '2024-04-04 13:59:17', '2024-04-04 13:59:17', 0, 0, 'teltonika'),
(1192, '76827-E-6', '356173060475394', 0, 34.8820401, -6.2940023, '{\"priority\":0,\"sat\":16,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":3,\"io200\":0,\"battery\":9.318,\"io68\":0,\"pdop\":1.1,\"hdop\":0.6000000000000001,\"power\":12.289,\"io24\":0,\"tripOdometer\":97298932,\"operator\":60400,\"distance\":0.0,\"totalDistance\":872835.47}', '0.00', '2024-04-04 13:59:03', '2024-04-04 13:59:03', 51, 26, 'teltonika'),
(1193, '48860-E-1', '356173060478851', 0, 33.5416518, -7.6428585, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.305,\"io68\":0,\"power\":12.497,\"distance\":0.0,\"totalDistance\":245662.6}', '0.00', '2024-04-04 13:56:24', '2024-04-04 13:56:24', 0, 0, 'teltonika'),
(1194, '46451-B-72', '356173060468555', 0, 33.6084471, -7.5650015, '{\"priority\":0,\"sat\":9,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"battery\":9.503,\"io68\":0,\"pdop\":1.5,\"hdop\":1.0,\"power\":12.282,\"io24\":0,\"tripOdometer\":71034410,\"operator\":60400,\"distance\":0.0,\"totalDistance\":397013.89}', '0.00', '2024-04-04 13:59:34', '2024-04-04 13:59:34', 61, 67, 'teltonika'),
(1228, '01-GS-0029', '356449067723071', 0, 33.541344, -7.639722, '{\"sat\":8,\"hdop\":1.01,\"odometer\":2863266,\"hours\":367205000,\"power\":12.0,\"battery\":0.14,\"status\":65538,\"eventStatus\":\"0\",\"packetType\":\"1\",\"distance\":0.0,\"totalDistance\":99912.48,\"motion\":false}', '0.00', '2024-04-04 13:59:55', '2024-04-04 13:59:55', 71, 0, 'gosafe'),
(1295, '42381-B-72', '356307049731796', 0, 33.541573, -7.6421868, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":0.0,\"io68\":0,\"power\":12.229000000000001,\"distance\":0.0,\"totalDistance\":178267.31}', '0.00', '2024-04-04 13:57:22', '2024-04-04 13:57:22', 0, 0, 'teltonika'),
(1299, '46448-B-72', '356173060468225', 0, 31.6433335, -7.9945383, '{\"priority\":0,\"sat\":10,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":4,\"io200\":0,\"battery\":9.517,\"io68\":0,\"pdop\":1.5,\"hdop\":0.8,\"power\":13.647,\"io24\":58,\"tripOdometer\":130724446,\"operator\":60400,\"distance\":114.5,\"totalDistance\":672623.27}', '31.32', '2024-04-04 13:59:51', '2024-04-04 13:59:51', 462, 42, 'teltonika'),
(1300, '35003-T-6', '356173060467839', 0, 33.5257191, -7.6506565, '{\"priority\":0,\"sat\":11,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":5,\"io200\":0,\"battery\":10.625,\"io68\":15,\"pdop\":1.4000000000000001,\"hdop\":0.8,\"power\":13.723,\"io24\":0,\"tripOdometer\":56286631,\"operator\":60400,\"distance\":48.23,\"totalDistance\":1219300.73}', '0.00', '2024-04-04 13:59:51', '2024-04-04 13:59:51', 121, 273, 'teltonika'),
(1301, '24239-T-6', '356307049617821', 0, 33.5413621, -7.6419178, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":2,\"motion\":false,\"io200\":1,\"battery\":9.637,\"io68\":0,\"power\":12.354000000000001,\"distance\":0.0,\"totalDistance\":1336697.33}', '0.00', '2024-04-04 13:55:39', '2024-04-04 13:55:39', 0, 0, 'teltonika'),
(1304, '22906-T-6', '357454070559081', 0, 33.5413823, -7.6399001, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.584,\"io68\":0,\"power\":12.593,\"distance\":0.0,\"totalDistance\":580810.57}', '0.00', '2024-04-04 13:55:52', '2024-04-04 13:55:52', 0, 0, 'teltonika'),
(1305, '53738-E-6', '357454070940612', 0, 0, 0, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":2,\"motion\":true,\"rssi\":3,\"io200\":0,\"battery\":10.559000000000001,\"io68\":3,\"pdop\":0.0,\"hdop\":0.0,\"power\":12.177,\"io24\":0,\"tripOdometer\":54163633,\"operator\":60400,\"distance\":0.0,\"totalDistance\":0.0}', '0.00', '2015-01-01 20:37:58', '2015-01-01 20:37:58', 0, 4, 'teltonika'),
(1310, '35008-T-6', '356173065034428', 0, 33.5420076, -7.6427198, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.251,\"io68\":0,\"power\":12.344,\"distance\":0.0,\"totalDistance\":362544.9}', '0.00', '2024-04-04 13:57:56', '2024-04-04 13:57:56', 0, 0, 'teltonika'),
(1312, '34341-T-6', '356307048448400', 0, 33.541548, -7.6421538, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.224,\"io68\":0,\"power\":12.775,\"distance\":0.0,\"totalDistance\":5296933.74}', '0.00', '2024-04-04 13:56:25', '2024-04-04 13:56:25', 0, 0, 'teltonika'),
(1314, '53850-B-72', '350317176602690', 0, 31.6177683, -8.0654066, '{\"priority\":0,\"sat\":7,\"event\":0,\"ignition\":false,\"rssi\":4,\"io69\":1,\"di1\":0,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":0,\"power\":12.552,\"axisX\":-45,\"axisY\":24,\"axisZ\":-3,\"io84\":286,\"io85\":0,\"door\":0,\"coolantTemp\":87.0,\"io87\":2728000,\"io100\":11422,\"io105\":1464330,\"io107\":1350,\"distance\":0.0,\"totalDistance\":294761.27,\"motion\":false,\"hours\":23527920}', '0.00', '2024-04-04 13:35:26', '2024-04-04 13:35:26', 459, 322, 'teltonika'),
(1322, '179253WW', '350317170555639', 0, 33.5961066, -7.5997916, '{\"priority\":0,\"sat\":15,\"event\":0,\"ignition\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":1,\"power\":14.5,\"axisX\":19,\"axisY\":7,\"axisZ\":-43,\"io84\":360,\"io85\":790,\"door\":0,\"coolantTemp\":92.0,\"io87\":40705900,\"io100\":14146,\"io105\":0,\"io107\":6372,\"distance\":0.95,\"totalDistance\":737455.62,\"motion\":false,\"hours\":87647630}', '0.00', '2024-04-04 13:59:59', '2024-04-04 13:59:59', 23, 261, 'teltonika'),
(1328, '202269WW', '350544507314998', 0, 33.5102116, -7.610055, '{\"priority\":0,\"sat\":15,\"event\":0,\"ignition\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":96,\"io82\":7,\"io250\":1,\"power\":12.955,\"axisX\":73,\"axisY\":-1,\"axisZ\":-8,\"io84\":480,\"io85\":1747,\"door\":0,\"io87\":34549200,\"io100\":13538,\"io105\":7421485,\"io107\":4872,\"distance\":102.59,\"totalDistance\":1431658.59,\"motion\":true,\"hours\":146122660}', '49.14', '2024-04-04 14:00:00', '2024-04-04 14:00:00', 169, 63, 'teltonika'),
(1331, '179394WW', '350317176561987', 0, 33.5429699, -7.6414366, '{\"priority\":0,\"sat\":12,\"event\":0,\"ignition\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":14,\"io250\":1,\"power\":14.387,\"axisX\":-20,\"axisY\":-2,\"axisZ\":-2,\"io84\":140,\"io85\":1631,\"door\":0,\"coolantTemp\":58.800000000000004,\"io87\":13519600,\"io100\":14146,\"io105\":0,\"io107\":970,\"distance\":98.02,\"totalDistance\":143020.38,\"motion\":true,\"hours\":20835960}', '28.08', '2024-04-04 13:59:55', '2024-04-04 13:59:55', 80, 343, 'teltonika'),
(1336, '80352-E-6', '357454070506520', 0, 33.5783725, -7.6267721, '{\"priority\":0,\"sat\":7,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":9.205,\"io68\":0,\"pdop\":2.4000000000000004,\"hdop\":1.2000000000000002,\"power\":12.128,\"io24\":0,\"tripOdometer\":49396951,\"operator\":60400,\"distance\":0.0,\"totalDistance\":192692.26}', '0.00', '2024-04-04 13:59:18', '2024-04-04 13:59:18', 69, 164, 'teltonika'),
(1343, '24291-T-6', '357454070559842', 0, 33.5415428, -7.6421323, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":7.176,\"io68\":0,\"power\":12.555,\"distance\":0.0,\"totalDistance\":1163575.04}', '0.00', '2024-04-04 13:58:14', '2024-04-04 13:58:14', 0, 0, 'teltonika'),
(1348, '86480-E-6', '357454070531874', 0, 33.5517995, -7.5772276, '{\"priority\":0,\"sat\":14,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":3,\"io200\":0,\"battery\":10.629,\"io68\":2,\"pdop\":1.5,\"hdop\":0.8,\"power\":12.261000000000001,\"io24\":0,\"tripOdometer\":45000,\"operator\":60400,\"distance\":0.0,\"totalDistance\":270646.66}', '0.00', '2024-04-04 13:59:22', '2024-04-04 13:59:22', 151, 199, 'teltonika'),
(1352, '40690-D-8', '357454070531890', 0, 33.5414858, -7.6421841, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.547,\"io68\":0,\"power\":12.402000000000001,\"distance\":0.0,\"totalDistance\":367637.41}', '0.00', '2024-04-04 13:58:20', '2024-04-04 13:58:20', 0, 0, 'teltonika'),
(1356, '34633-E-1', '357454070559214', 0, 0, 0, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.97,\"io68\":0,\"power\":11.904,\"distance\":0.0,\"totalDistance\":3.447120438E7}', '0.00', '2024-04-04 13:56:33', '2024-04-04 13:56:33', 0, 0, 'teltonika'),
(1358, '41010-D-8', '356307049469033', 0, 33.708323, -7.3641258, '{\"priority\":0,\"sat\":8,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":6.6690000000000005,\"io68\":0,\"pdop\":1.9000000000000001,\"hdop\":1.0,\"power\":12.095,\"io24\":0,\"tripOdometer\":55299210,\"operator\":60400,\"distance\":0.0,\"totalDistance\":359270.88}', '0.00', '2024-04-04 13:59:35', '2024-04-04 13:59:35', 20, 275, 'teltonika'),
(1360, '290593WW', '350544507304858', 0, 33.9062483, -5.5255133, '{\"priority\":0,\"sat\":12,\"event\":250,\"ignition\":false,\"rssi\":5,\"io69\":1,\"di1\":0,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io89\":99,\"io250\":0,\"power\":12.669,\"axisX\":25,\"axisY\":70,\"axisZ\":-30,\"io85\":0,\"door\":0,\"coolantTemp\":78.0,\"io87\":1256000,\"io100\":13822,\"io105\":1226110,\"io107\":690,\"distance\":0.0,\"totalDistance\":976765.92,\"motion\":false,\"hours\":88022240}', '0.00', '2024-04-04 13:58:35', '2024-04-04 13:58:35', 530, 123, 'teltonika'),
(1361, '41806-E-1', '356173060469041', 0, 33.5416681, -7.6428195, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.918000000000001,\"io68\":0,\"power\":12.287,\"distance\":0.0,\"totalDistance\":1.949528631E7}', '0.00', '2024-04-04 13:55:35', '2024-04-04 13:55:35', 0, 0, 'teltonika'),
(1362, '96596-E-6', '357454070560279', 0, 33.581379, -7.6161466, '{\"priority\":0,\"sat\":12,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":10.643,\"io68\":1,\"pdop\":1.5,\"hdop\":0.7000000000000001,\"power\":11.922,\"io24\":0,\"tripOdometer\":60319425,\"operator\":60400,\"distance\":0.0,\"totalDistance\":291298.0}', '0.00', '2024-04-04 13:59:16', '2024-04-04 13:59:16', 52, 170, 'teltonika'),
(1363, '99254-B-72', '356173060469405', 0, 33.5419675, -7.6428741, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":4.624,\"io68\":0,\"power\":12.354000000000001,\"distance\":0.0,\"totalDistance\":341065.44}', '0.00', '2024-04-04 13:57:31', '2024-04-04 13:57:31', 0, 0, 'teltonika'),
(1364, '36365-B-72', '356307049701039', 0, 33.2786116, -7.5830521, '{\"priority\":0,\"sat\":15,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":3,\"io200\":0,\"battery\":10.646,\"io68\":3,\"pdop\":1.0,\"hdop\":0.6000000000000001,\"power\":12.451,\"io24\":0,\"tripOdometer\":146657882,\"operator\":60400,\"distance\":0.0,\"totalDistance\":1216493.75}', '0.00', '2024-04-04 13:59:05', '2024-04-04 13:59:05', 233, 0, 'teltonika'),
(1365, '4480-T-6', '357454070275712', 0, 33.5417926, -7.6383925, '{\"priority\":0,\"sat\":11,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":3,\"io200\":0,\"battery\":10.644,\"io68\":23,\"pdop\":2.8000000000000003,\"hdop\":1.5,\"power\":12.384,\"io24\":0,\"tripOdometer\":121176043,\"operator\":60400,\"distance\":0.0,\"totalDistance\":1168476.86}', '0.00', '2024-04-04 13:59:24', '2024-04-04 13:59:24', 88, 0, 'teltonika'),
(1370, '46967-D-8', '357454070700891', 0, 33.5419326, -7.6423251, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.144,\"io68\":0,\"power\":12.622,\"distance\":0.0,\"totalDistance\":242533.46}', '0.00', '2024-04-04 13:55:17', '2024-04-04 13:55:17', 0, 0, 'teltonika'),
(1371, '5831-T-6', '356307049468860', 0, 32.2296573, -7.943176, '{\"priority\":0,\"sat\":9,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":4,\"io200\":0,\"battery\":1.331,\"io68\":0,\"pdop\":1.6,\"hdop\":0.9,\"power\":12.243,\"io24\":0,\"tripOdometer\":122098656,\"operator\":60400,\"distance\":0.0,\"totalDistance\":693519.72}', '0.00', '2024-04-04 13:59:46', '2024-04-04 13:59:46', 490, 287, 'teltonika'),
(1376, '268109WW', '350544507305921', 0, 35.7710783, -5.7786583, '{\"priority\":0,\"sat\":16,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":1,\"power\":14.003,\"axisX\":-38,\"axisY\":26,\"axisZ\":-20,\"io84\":495,\"io85\":830,\"door\":0,\"io87\":5837400,\"io100\":13538,\"io105\":4061095,\"io107\":3508,\"distance\":0.0,\"totalDistance\":472345.41,\"motion\":false,\"hours\":74868810}', '0.00', '2024-04-04 13:59:56', '2024-04-04 13:59:56', 20, 300, 'teltonika'),
(1378, '022433WW', '354018110904087', 0, 33.5529983, -7.6058666, '{\"priority\":0,\"sat\":16,\"event\":0,\"ignition\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":21,\"io89\":11,\"io250\":1,\"power\":14.536,\"axisX\":-29,\"axisY\":-52,\"axisZ\":-27,\"io85\":898,\"door\":0,\"coolantTemp\":82.0,\"io87\":38316600,\"io100\":13124,\"io105\":3008245,\"io107\":1716,\"distance\":20.67,\"totalDistance\":623602.6,\"motion\":true,\"hours\":122822690}', '11.34', '2024-04-04 13:59:58', '2024-04-04 13:59:58', 87, 77, 'teltonika'),
(1379, '8848-T-6', '354018110627605', 0, 33.6935399, -7.3774716, '{\"priority\":0,\"sat\":14,\"event\":250,\"ignition\":false,\"rssi\":5,\"io69\":1,\"di1\":0,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io89\":32,\"io250\":0,\"power\":12.93,\"axisX\":60,\"axisY\":-28,\"axisZ\":-23,\"io85\":0,\"door\":0,\"coolantTemp\":79.0,\"io87\":114461300,\"io100\":13163,\"io105\":2574765,\"io107\":1757,\"distance\":0.0,\"totalDistance\":1642216.05,\"motion\":false,\"hours\":104865820}', '0.00', '2024-04-04 13:56:05', '2024-04-04 13:56:05', 31, 322, 'teltonika'),
(1396, '70342-E-1', '357454070941784', 0, 33.5416006, -7.6428323, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":0.267,\"io68\":0,\"power\":12.287,\"distance\":0.0,\"totalDistance\":137932.14}', '0.00', '2024-04-04 13:55:54', '2024-04-04 13:55:54', 0, 0, 'teltonika'),
(1399, '30450-T-6', '356307049730566', 0, 33.5603626, -7.5632515, '{\"priority\":0,\"sat\":18,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":5,\"io200\":0,\"battery\":10.625,\"io68\":6,\"pdop\":1.0,\"hdop\":0.6000000000000001,\"power\":13.692,\"io24\":22,\"tripOdometer\":74445549,\"operator\":60400,\"distance\":40.27,\"totalDistance\":1330082.62}', '11.88', '2024-04-04 13:59:36', '2024-04-04 13:59:36', 96, 97, 'teltonika'),
(1400, '071728WW', '356173060477804', 0, 33.3751061, -7.5803038, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.018,\"io68\":0,\"power\":12.268,\"distance\":0.0,\"totalDistance\":332263.16}', '0.00', '2024-04-04 13:57:21', '2024-04-04 13:57:21', 0, 0, 'teltonika'),
(1401, '30440-T-6', '356173060468431', 0, 34.6496551, -1.8690835, '{\"priority\":0,\"sat\":15,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":2,\"io200\":0,\"battery\":4.813,\"io68\":0,\"pdop\":1.2000000000000002,\"hdop\":0.7000000000000001,\"power\":12.521,\"io24\":0,\"tripOdometer\":73599800,\"operator\":60400,\"distance\":0.0,\"totalDistance\":583141.38}', '0.00', '2024-04-04 13:59:39', '2024-04-04 13:59:39', 639, 0, 'teltonika'),
(1402, '46929-B-72', '350544507317504', 0, 33.4776383, -7.5990499, '{\"priority\":0,\"sat\":16,\"event\":0,\"ignition\":true,\"motion\":true,\"workMode\":1,\"rssi\":4,\"di1\":1,\"io81\":0,\"io82\":0,\"io89\":0,\"io175\":0,\"io246\":0,\"io252\":0,\"power\":12.372,\"io24\":3,\"battery\":3.8120000000000003,\"axisX\":-7,\"axisY\":-15,\"axisZ\":24,\"io84\":760,\"io85\":708,\"door\":0,\"coolantTemp\":93.0,\"odometer\":2745108,\"io83\":0,\"io87\":23787000,\"io100\":12595,\"io107\":21072,\"distance\":4.1,\"totalDistance\":377217.65,\"hours\":299443990}', '3.78', '2024-04-04 13:56:46', '2024-04-04 13:56:46', 172, 167, 'teltonika'),
(1406, '47206-B-72', '350544507314733', 0, 33.5416866, -7.642885, '{\"priority\":0,\"sat\":0,\"event\":0,\"ignition\":false,\"rssi\":2,\"io69\":2,\"di1\":0,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":0,\"power\":12.813,\"axisX\":39,\"axisY\":-11,\"axisZ\":-49,\"io84\":340,\"io85\":0,\"door\":0,\"coolantTemp\":88.0,\"io87\":15536000,\"io100\":12595,\"io105\":1027330,\"io107\":876,\"distance\":0.0,\"totalDistance\":102656.38,\"motion\":false,\"hours\":19975960}', '0.00', '2024-04-04 12:22:02', '2024-04-04 12:22:02', 0, 0, 'teltonika'),
(1407, '35846-T-6', '356173065042207', 0, 33.9124901, -5.5600515, '{\"priority\":0,\"sat\":16,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":3,\"io200\":0,\"battery\":10.525,\"io68\":7,\"pdop\":1.1,\"hdop\":0.6000000000000001,\"power\":12.299,\"io24\":0,\"tripOdometer\":47078226,\"operator\":60400,\"distance\":0.0,\"totalDistance\":850257.9}', '0.00', '2024-04-04 13:59:12', '2024-04-04 13:59:12', 478, 139, 'teltonika'),
(1410, '47449-B-72', '357454070940877', 0, 34.0275731, -6.7113915, '{\"priority\":0,\"sat\":11,\"event\":0,\"di1\":1,\"io22\":3,\"io71\":3,\"motion\":true,\"rssi\":3,\"io200\":0,\"battery\":7.456,\"io68\":0,\"pdop\":1.4000000000000001,\"hdop\":0.8,\"power\":13.779,\"io24\":50,\"tripOdometer\":75391045,\"operator\":60400,\"distance\":101.95,\"totalDistance\":1829136.45}', '27.54', '2024-04-04 13:59:57', '2024-04-04 13:59:57', 123, 166, 'teltonika'),
(1411, '47666-B-72', '356173060480824', 0, 33.5413656, -7.639777, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":3.605,\"io68\":0,\"power\":12.258000000000001,\"distance\":0.0,\"totalDistance\":1469649.08}', '0.00', '2024-04-04 13:56:43', '2024-04-04 13:56:43', 0, 0, 'teltonika'),
(1414, '47811-B-72', '356173060272411', 0, 33.5416856, -7.6421385, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":9.353,\"io68\":0,\"power\":12.583,\"distance\":0.0,\"totalDistance\":323876.38}', '0.00', '2024-04-04 13:56:24', '2024-04-04 13:56:24', 0, 0, 'teltonika'),
(1415, '30451-T-6', '356307049466344', 0, 33.3751058, -7.5802878, '{\"priority\":0,\"sat\":0,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":4,\"motion\":false,\"io200\":1,\"battery\":8.936,\"io68\":0,\"power\":12.143,\"distance\":0.0,\"totalDistance\":335560.84}', '0.00', '2024-04-04 13:57:24', '2024-04-04 13:57:24', 0, 0, 'teltonika'),
(1416, '47813-B-72', '356173065013489', 0, 33.5566658, -7.6265031, '{\"priority\":0,\"sat\":10,\"event\":0,\"di1\":0,\"io22\":3,\"io71\":3,\"motion\":false,\"rssi\":5,\"io200\":0,\"battery\":9.408,\"io68\":0,\"pdop\":1.5,\"hdop\":0.9,\"power\":12.532,\"io24\":0,\"tripOdometer\":30987266,\"operator\":60400,\"distance\":0.0,\"totalDistance\":348453.06}', '0.00', '2024-04-04 13:59:53', '2024-04-04 13:59:53', 58, 65, 'teltonika'),
(1420, '44893-B-72', '352093081242116', 0, 30.4185333, -9.6005499, '{\"priority\":0,\"sat\":15,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":23,\"io82\":37,\"io250\":1,\"power\":14.17,\"axisX\":-19,\"axisY\":60,\"axisZ\":42,\"io84\":250,\"io85\":1695,\"door\":0,\"coolantTemp\":90.0,\"io87\":88168300,\"io100\":13149,\"io107\":3942,\"distance\":5.25,\"totalDistance\":1614910.67,\"motion\":true,\"hours\":92514830}', '9.72', '2024-04-04 13:59:57', '2024-04-04 13:59:57', 28, 24, 'teltonika'),
(1430, '33495-B-72', '350544507310004', 0, 32.8387199, -6.481435, '{\"priority\":0,\"sat\":15,\"event\":0,\"ignition\":true,\"motion\":true,\"workMode\":1,\"rssi\":3,\"di1\":1,\"io81\":54,\"io82\":12,\"io89\":0,\"io175\":0,\"io246\":0,\"io252\":0,\"power\":13.854000000000001,\"io24\":54,\"battery\":4.213,\"axisX\":-20,\"axisY\":-26,\"axisZ\":18,\"io84\":430,\"io85\":1278,\"door\":0,\"coolantTemp\":89.0,\"odometer\":7036044,\"io83\":0,\"io87\":123432000,\"io100\":13149,\"io107\":3179,\"distance\":7535.27,\"totalDistance\":1124916.13,\"hours\":61463970}', '29.16', '2024-04-04 13:51:11', '2024-04-04 13:51:11', 770, 125, 'teltonika'),
(1432, '73334-E-6', '350317176562043', 0, 33.5515383, -7.6191816, '{\"priority\":0,\"sat\":13,\"event\":0,\"ignition\":true,\"motion\":true,\"workMode\":1,\"rssi\":3,\"di1\":1,\"io81\":33,\"io82\":0,\"io89\":0,\"io175\":0,\"io246\":0,\"io252\":0,\"power\":15.009,\"io24\":33,\"battery\":3.9290000000000003,\"axisX\":29,\"axisY\":74,\"axisZ\":116,\"io84\":343,\"io85\":1370,\"door\":0,\"coolantTemp\":84.0,\"odometer\":2520637,\"io83\":0,\"io87\":87530700,\"io100\":13197,\"io107\":15412,\"distance\":2488.86,\"totalDistance\":297189.76,\"hours\":36036990}', '17.82', '2024-04-04 13:39:00', '2024-04-04 13:39:00', 84, 39, 'teltonika'),
(1433, '212555WW', '350317176610255', 0, 33.4552333, -7.5071866, '{\"priority\":0,\"sat\":14,\"event\":0,\"ignition\":false,\"rssi\":2,\"io69\":1,\"di1\":0,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":0,\"power\":12.927,\"axisX\":1,\"axisY\":17,\"axisZ\":-20,\"io84\":250,\"io85\":0,\"door\":0,\"coolantTemp\":90.0,\"io87\":15040800,\"io100\":13149,\"io105\":2423560,\"io107\":1592,\"distance\":0.0,\"totalDistance\":333495.72,\"motion\":false,\"hours\":62959890}', '0.00', '2024-04-04 13:25:11', '2024-04-04 13:25:11', 192, 222, 'teltonika'),
(1442, '22154-A-68', '354018110909631', 0, 27.157095, -13.2031383, '{\"priority\":0,\"sat\":17,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io250\":1,\"power\":14.313,\"axisX\":30,\"axisY\":7,\"axisZ\":-40,\"door\":0,\"io100\":11372,\"distance\":13.27,\"totalDistance\":594525.51,\"motion\":true,\"hours\":55141940}', '6.48', '2024-04-04 13:59:56', '2024-04-04 13:59:56', 83, 115, 'teltonika'),
(1443, '29076-A-68', '354018110757956', 0, 27.1527283, -13.2092833, '{\"priority\":0,\"sat\":15,\"event\":0,\"ignition\":false,\"rssi\":4,\"io69\":1,\"di1\":0,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io82\":0,\"io250\":0,\"power\":12.782,\"axisX\":-9,\"axisY\":29,\"axisZ\":35,\"io84\":500,\"io85\":0,\"door\":256,\"coolantTemp\":81.0,\"io87\":35085800,\"io100\":11372,\"io107\":2787,\"distance\":0.0,\"totalDistance\":383422.21,\"motion\":false,\"hours\":53830750}', '0.00', '2024-04-04 13:58:52', '2024-04-04 13:58:52', 84, 117, 'teltonika'),
(1444, '29077-A-68', '354018110889627', 0, 27.555455, -12.9460899, '{\"priority\":0,\"sat\":17,\"event\":0,\"ignition\":true,\"rssi\":3,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io82\":24,\"io250\":1,\"power\":14.202,\"axisX\":-7,\"axisY\":-25,\"axisZ\":-81,\"io84\":400,\"io85\":2004,\"door\":0,\"coolantTemp\":81.0,\"io87\":70032910,\"io100\":11372,\"io107\":4334,\"distance\":108.73,\"totalDistance\":1090953.98,\"motion\":true,\"hours\":64654790}', '52.38', '2024-04-04 13:59:56', '2024-04-04 13:59:56', 60, 194, 'teltonika'),
(1447, '29072-A-68', '354018110918574', 0, 22.0528366, -16.748895, '{\"priority\":0,\"sat\":13,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":22,\"io250\":1,\"power\":13.418000000000001,\"axisX\":10,\"axisY\":-110,\"axisZ\":23,\"io84\":460,\"io85\":1991,\"door\":0,\"coolantTemp\":66.0,\"io87\":54036580,\"io100\":11372,\"io105\":19144710,\"io107\":5296,\"distance\":19.99,\"totalDistance\":1429570.82,\"motion\":true,\"hours\":100137880}', '20.52', '2024-04-04 13:59:58', '2024-04-04 13:59:58', 32, 231, 'teltonika'),
(1448, '29070-A-68', '354018110980020', 0, 27.1566966, -13.2024133, '{\"priority\":0,\"sat\":17,\"event\":0,\"ignition\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io250\":1,\"power\":13.46,\"axisX\":-67,\"axisY\":9,\"axisZ\":-29,\"door\":0,\"io100\":11372,\"distance\":33.75,\"totalDistance\":303861.85,\"motion\":true,\"hours\":51975990}', '10.26', '2024-04-04 13:59:50', '2024-04-04 13:59:50', 86, 119, 'teltonika'),
(1464, '212553WW', '350317176561912', 0, 33.5874766, -7.6157966, '{\"priority\":0,\"sat\":12,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":1,\"power\":14.08,\"axisX\":-4,\"axisY\":23,\"axisZ\":-9,\"io84\":170,\"io85\":806,\"door\":0,\"coolantTemp\":83.0,\"io87\":26038000,\"io100\":13149,\"io105\":7025160,\"io107\":3900,\"distance\":0.81,\"totalDistance\":1091011.0,\"motion\":false,\"hours\":94412810}', '0.00', '2024-04-04 14:00:00', '2024-04-04 14:00:00', -17, 210, 'teltonika'),
(1480, '243484Ww', '350544507314907', 0, 34.2667516, -6.5752233, '{\"priority\":0,\"sat\":11,\"event\":0,\"ignition\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":23,\"io82\":0,\"io250\":1,\"power\":14.466000000000001,\"axisX\":2,\"axisY\":3,\"axisZ\":-31,\"io84\":130,\"io85\":1017,\"door\":0,\"coolantTemp\":91.0,\"io87\":30663000,\"io100\":13149,\"io105\":4830070,\"io107\":2802,\"distance\":7.57,\"totalDistance\":1220266.37,\"motion\":true,\"hours\":84237760}', '12.42', '2024-04-04 14:00:00', '2024-04-04 14:00:00', 24, 66, 'teltonika'),
(1482, '243485WW', '350317176567984', 0, 35.29124, -2.9412299, '{\"priority\":0,\"sat\":16,\"event\":0,\"ignition\":true,\"rssi\":2,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":27,\"io82\":21,\"io250\":1,\"power\":14.401,\"axisX\":-45,\"axisY\":-4,\"axisZ\":26,\"io84\":200,\"io85\":1269,\"door\":0,\"coolantTemp\":90.0,\"io87\":31669000,\"io100\":13149,\"io105\":7684230,\"io107\":4122,\"distance\":38.07,\"totalDistance\":1453184.72,\"motion\":true,\"hours\":94651680}', '12.96', '2024-04-04 13:56:37', '2024-04-04 13:56:37', 45, 250, 'teltonika'),
(1484, '51095-B-72', '350317176549826', 0, 33.5244516, -7.6603183, '{\"priority\":0,\"sat\":0,\"event\":0,\"ignition\":false,\"rssi\":3,\"io69\":2,\"di1\":0,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io250\":0,\"power\":12.870000000000001,\"axisX\":39,\"axisY\":33,\"axisZ\":-5,\"io84\":370,\"io85\":0,\"door\":0,\"coolantTemp\":79.0,\"io87\":26605000,\"io100\":13149,\"io105\":4446200,\"io107\":2529,\"distance\":0.0,\"totalDistance\":1358081.4,\"motion\":false,\"hours\":61222860}', '0.00', '2024-04-04 13:59:15', '2024-04-04 13:59:15', 0, 0, 'teltonika');
INSERT INTO `up_devices` (`id`, `name`, `uniqueId`, `latestPosition_id`, `lastValidLatitude`, `lastValidLongitude`, `attributes`, `speed`, `device_time`, `fixTime`, `altitude`, `course`, `protocol`) VALUES
(1492, '268108WW', '352625695034627', 0, 30.4251483, -9.6134516, '{\"priority\":0,\"sat\":14,\"event\":0,\"ignition\":true,\"rssi\":5,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":50,\"io82\":9,\"io250\":1,\"power\":13.122,\"axisX\":50,\"axisY\":18,\"axisZ\":-7,\"io84\":350,\"io85\":1536,\"door\":0,\"io87\":17120000,\"io100\":13538,\"io105\":8963730,\"io107\":5684,\"distance\":13.96,\"totalDistance\":2023573.31,\"motion\":true,\"hours\":95037790}', '23.76', '2024-04-04 13:59:49', '2024-04-04 13:59:49', 37, 292, 'teltonika'),
(1494, '330785WW', '350544507305848', 0, 30.65628, -9.2666283, '{\"priority\":0,\"sat\":14,\"event\":0,\"ignition\":true,\"motion\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":123,\"io82\":8,\"io89\":87,\"io252\":0,\"power\":13.947000000000001,\"io24\":125,\"battery\":4.083,\"io85\":2059,\"door\":0,\"coolantTemp\":90.0,\"odometer\":1458201,\"temp1\":0.0,\"io87\":1426900,\"io100\":14239,\"io105\":1401730,\"io107\":972,\"distance\":104.01,\"totalDistance\":966306.58,\"hours\":80407270}', '67.49', '2024-04-04 13:59:59', '2024-04-04 13:59:59', 931, 77, 'teltonika'),
(1495, '330786WW', '350544507305780', 0, 33.5735649, -7.614425, '{\"priority\":0,\"sat\":13,\"event\":0,\"ignition\":true,\"motion\":true,\"rssi\":4,\"io69\":1,\"di1\":1,\"out1\":false,\"di2\":0,\"di3\":0,\"out2\":false,\"io81\":0,\"io82\":0,\"io89\":82,\"io252\":0,\"power\":12.743,\"io24\":0,\"battery\":3.906,\"io85\":750,\"door\":0,\"coolantTemp\":90.0,\"odometer\":1822000,\"temp1\":0.0,\"io87\":1845800,\"io100\":14239,\"io105\":1825260,\"io107\":1075,\"distance\":10.01,\"totalDistance\":1211319.65,\"hours\":102655360}', '0.00', '2024-04-04 13:59:40', '2024-04-04 13:59:40', 62, 95, 'teltonika');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `af_alerts`
--
ALTER TABLE `af_alerts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `alerts_user_id_foreign` (`user_id`),
  ADD KEY `alerts_active_index` (`active`),
  ADD KEY `alerts_type_index` (`type`);

--
-- Index pour la table `af_alert_device`
--
ALTER TABLE `af_alert_device`
  ADD KEY `alert_device_alert_id_index` (`alert_id`),
  ADD KEY `alert_device_device_id_index` (`device_id`);

--
-- Index pour la table `af_alert_geofence`
--
ALTER TABLE `af_alert_geofence`
  ADD KEY `alert_geofence_alert_id_index` (`alert_id`),
  ADD KEY `alert_geofence_geofence_id_index` (`geofence_id`);

--
-- Index pour la table `af_apps`
--
ALTER TABLE `af_apps`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_apps_log`
--
ALTER TABLE `af_apps_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `af_apps_log_app_id_fk` (`app_id`),
  ADD KEY `af_apps_log_user_id_fk` (`user_id`);

--
-- Index pour la table `af_carsharing`
--
ALTER TABLE `af_carsharing`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_changelogs`
--
ALTER TABLE `af_changelogs`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_chats`
--
ALTER TABLE `af_chats`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_chats_messages`
--
ALTER TABLE `af_chats_messages`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_client_finale`
--
ALTER TABLE `af_client_finale`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_cp_id` (`id_client_p`);

--
-- Index pour la table `af_client_principale`
--
ALTER TABLE `af_client_principale`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_custom_apps`
--
ALTER TABLE `af_custom_apps`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_custom_apps_users`
--
ALTER TABLE `af_custom_apps_users`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_device_costs`
--
ALTER TABLE `af_device_costs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `device_expenses_user_id_index` (`user_id`),
  ADD KEY `device_expenses_device_id_index` (`device_id`),
  ADD KEY `device_expenses_type_id_index` (`type_id`);

--
-- Index pour la table `af_device_costs_types`
--
ALTER TABLE `af_device_costs_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_device_drivers`
--
ALTER TABLE `af_device_drivers`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_device_infos`
--
ALTER TABLE `af_device_infos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_device_id` (`id`),
  ADD KEY `fk_model_id` (`model_id`);

--
-- Index pour la table `af_device_insurances`
--
ALTER TABLE `af_device_insurances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_af_device_insurances_usage_id` (`usage_id`),
  ADD KEY `fk_af_device_insurances_user_id` (`user_id`),
  ADD KEY `fk_af_device_insurances_device_id` (`device_id`);

--
-- Index pour la table `af_device_insurances_usages`
--
ALTER TABLE `af_device_insurances_usages`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_device_models`
--
ALTER TABLE `af_device_models`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Index pour la table `af_device_odometer`
--
ALTER TABLE `af_device_odometer`
  ADD UNIQUE KEY `device_id_uniq` (`device_id`);

--
-- Index pour la table `af_device_sensors`
--
ALTER TABLE `af_device_sensors`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_device_sensors_pivot`
--
ALTER TABLE `af_device_sensors_pivot`
  ADD PRIMARY KEY (`device_model_id`,`device_sensor_id`),
  ADD KEY `fk_dsp_device_sensor_id` (`device_sensor_id`);

--
-- Index pour la table `af_device_services`
--
ALTER TABLE `af_device_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `device_services_user_id_index` (`user_id`),
  ADD KEY `device_services_device_id_index` (`device_id`),
  ADD KEY `device_services_event_sent_index` (`event_sent`),
  ADD KEY `device_services_expired_index` (`expired`);

--
-- Index pour la table `af_device_sinisters`
--
ALTER TABLE `af_device_sinisters`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_af_device_sinisters_insurance_id` (`insurance_id`),
  ADD KEY `fk_af_device_sinisters_user_id` (`user_id`),
  ADD KEY `fk_af_device_sinisters_device_id` (`device_id`);

--
-- Index pour la table `af_drivers`
--
ALTER TABLE `af_drivers`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_drivers_changed`
--
ALTER TABLE `af_drivers_changed`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_events_deviceid` (`device_id`);

--
-- Index pour la table `af_entretien`
--
ALTER TABLE `af_entretien`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Fk_entretien_devices` (`device_id`);

--
-- Index pour la table `af_events`
--
ALTER TABLE `af_events`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_global_log`
--
ALTER TABLE `af_global_log`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_global_log_summary`
--
ALTER TABLE `af_global_log_summary`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_map_icons`
--
ALTER TABLE `af_map_icons`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_marques`
--
ALTER TABLE `af_marques`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_models`
--
ALTER TABLE `af_models`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_models_datasheets`
--
ALTER TABLE `af_models_datasheets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `af_models_model_id_fk` (`model_id`) USING BTREE;

--
-- Index pour la table `af_planner_clients`
--
ALTER TABLE `af_planner_clients`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_planner_destinations`
--
ALTER TABLE `af_planner_destinations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_planner_numplaces`
--
ALTER TABLE `af_planner_numplaces`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_planner_points`
--
ALTER TABLE `af_planner_points`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_planner_shifts`
--
ALTER TABLE `af_planner_shifts`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_planner_trips`
--
ALTER TABLE `af_planner_trips`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_planner_trips_log`
--
ALTER TABLE `af_planner_trips_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `trips_log_client_id_foreign` (`client_id`),
  ADD KEY `trips_log_shift_id_foreign` (`shift_id`),
  ADD KEY `trips_log_destination_id_foreign` (`destination_id`);

--
-- Index pour la table `af_proprivate_devices`
--
ALTER TABLE `af_proprivate_devices`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_reports`
--
ALTER TABLE `af_reports`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_reports_groups`
--
ALTER TABLE `af_reports_groups`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_reports_scheduled`
--
ALTER TABLE `af_reports_scheduled`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_reports_scheduled_log`
--
ALTER TABLE `af_reports_scheduled_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id_fk` (`user_id`);

--
-- Index pour la table `af_reset_password`
--
ALTER TABLE `af_reset_password`
  ADD PRIMARY KEY (`user_code`);

--
-- Index pour la table `af_speedlimit_filtered_log`
--
ALTER TABLE `af_speedlimit_filtered_log`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_speedlimit_log`
--
ALTER TABLE `af_speedlimit_log`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_subscription_plans`
--
ALTER TABLE `af_subscription_plans`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_tasks`
--
ALTER TABLE `af_tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tasks_user_id_foreign` (`user_id`),
  ADD KEY `tasks_device_id_foreign` (`device_id`);

--
-- Index pour la table `af_tasks_status`
--
ALTER TABLE `af_tasks_status`
  ADD PRIMARY KEY (`id`),
  ADD KEY `af_mission_status_task_id_foreign` (`task_id`);

--
-- Index pour la table `af_tickets`
--
ALTER TABLE `af_tickets`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_tickets_groups`
--
ALTER TABLE `af_tickets_groups`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_tickets_messages`
--
ALTER TABLE `af_tickets_messages`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_tickets_reset_password`
--
ALTER TABLE `af_tickets_reset_password`
  ADD PRIMARY KEY (`user_code`);

--
-- Index pour la table `af_tickets_services`
--
ALTER TABLE `af_tickets_services`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_user_apps`
--
ALTER TABLE `af_user_apps`
  ADD PRIMARY KEY (`user_id`,`app_id`),
  ADD KEY `af_user_apps_user_id_index` (`user_id`),
  ADD KEY `af_user_apps_app_id_index` (`app_id`);

--
-- Index pour la table `af_user_device`
--
ALTER TABLE `af_user_device`
  ADD KEY `af_user_device_user_id_index` (`user_id`),
  ADD KEY `af_user_device_device_id_index` (`device_id`),
  ADD KEY `af_user_device_group_id_index` (`group_id`);

--
-- Index pour la table `af_user_options`
--
ALTER TABLE `af_user_options`
  ADD PRIMARY KEY (`user_id`);

--
-- Index pour la table `af_user_poi`
--
ALTER TABLE `af_user_poi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `af_user_poi_user_id_foreign` (`user_id`),
  ADD KEY `af_user_poi_map_icon_id_foreign` (`map_icon_id`),
  ADD KEY `af_user_poi_active_index` (`active`);

--
-- Index pour la table `af_user_types`
--
ALTER TABLE `af_user_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_vehicle_status`
--
ALTER TABLE `af_vehicle_status`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_vehicle_types`
--
ALTER TABLE `af_vehicle_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `af_vehicule_charges`
--
ALTER TABLE `af_vehicule_charges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_vc_di` (`device_id`);

--
-- Index pour la table `up_devices`
--
ALTER TABLE `up_devices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniqueId` (`uniqueId`),
  ADD KEY `FK5CF8ACDD7C6208C3` (`latestPosition_id`),
  ADD KEY `server_time` (`fixTime`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `af_alerts`
--
ALTER TABLE `af_alerts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_apps`
--
ALTER TABLE `af_apps`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT pour la table `af_apps_log`
--
ALTER TABLE `af_apps_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `af_carsharing`
--
ALTER TABLE `af_carsharing`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_changelogs`
--
ALTER TABLE `af_changelogs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT pour la table `af_chats`
--
ALTER TABLE `af_chats`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_chats_messages`
--
ALTER TABLE `af_chats_messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_client_finale`
--
ALTER TABLE `af_client_finale`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_client_principale`
--
ALTER TABLE `af_client_principale`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_custom_apps`
--
ALTER TABLE `af_custom_apps`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_custom_apps_users`
--
ALTER TABLE `af_custom_apps_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_device_costs`
--
ALTER TABLE `af_device_costs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_device_costs_types`
--
ALTER TABLE `af_device_costs_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT pour la table `af_device_drivers`
--
ALTER TABLE `af_device_drivers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_device_insurances`
--
ALTER TABLE `af_device_insurances`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_device_insurances_usages`
--
ALTER TABLE `af_device_insurances_usages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `af_device_models`
--
ALTER TABLE `af_device_models`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `af_device_sensors`
--
ALTER TABLE `af_device_sensors`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT pour la table `af_device_services`
--
ALTER TABLE `af_device_services`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_device_sinisters`
--
ALTER TABLE `af_device_sinisters`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_drivers`
--
ALTER TABLE `af_drivers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_drivers_changed`
--
ALTER TABLE `af_drivers_changed`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_entretien`
--
ALTER TABLE `af_entretien`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_events`
--
ALTER TABLE `af_events`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_global_log`
--
ALTER TABLE `af_global_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_global_log_summary`
--
ALTER TABLE `af_global_log_summary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_map_icons`
--
ALTER TABLE `af_map_icons`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT pour la table `af_marques`
--
ALTER TABLE `af_marques`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT pour la table `af_models`
--
ALTER TABLE `af_models`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241;

--
-- AUTO_INCREMENT pour la table `af_models_datasheets`
--
ALTER TABLE `af_models_datasheets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_planner_clients`
--
ALTER TABLE `af_planner_clients`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_planner_destinations`
--
ALTER TABLE `af_planner_destinations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_planner_numplaces`
--
ALTER TABLE `af_planner_numplaces`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_planner_points`
--
ALTER TABLE `af_planner_points`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_planner_shifts`
--
ALTER TABLE `af_planner_shifts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_planner_trips`
--
ALTER TABLE `af_planner_trips`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_planner_trips_log`
--
ALTER TABLE `af_planner_trips_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_proprivate_devices`
--
ALTER TABLE `af_proprivate_devices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_reports`
--
ALTER TABLE `af_reports`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_reports_groups`
--
ALTER TABLE `af_reports_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `af_reports_scheduled`
--
ALTER TABLE `af_reports_scheduled`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `af_reports_scheduled_log`
--
ALTER TABLE `af_reports_scheduled_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_speedlimit_filtered_log`
--
ALTER TABLE `af_speedlimit_filtered_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_speedlimit_log`
--
ALTER TABLE `af_speedlimit_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_subscription_plans`
--
ALTER TABLE `af_subscription_plans`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `af_tasks`
--
ALTER TABLE `af_tasks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_tasks_status`
--
ALTER TABLE `af_tasks_status`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `af_tickets`
--
ALTER TABLE `af_tickets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_tickets_groups`
--
ALTER TABLE `af_tickets_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `af_tickets_messages`
--
ALTER TABLE `af_tickets_messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_tickets_services`
--
ALTER TABLE `af_tickets_services`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_user_poi`
--
ALTER TABLE `af_user_poi`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `af_user_types`
--
ALTER TABLE `af_user_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `af_vehicle_status`
--
ALTER TABLE `af_vehicle_status`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `af_vehicle_types`
--
ALTER TABLE `af_vehicle_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT pour la table `af_vehicule_charges`
--
ALTER TABLE `af_vehicule_charges`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `up_devices`
--
ALTER TABLE `up_devices`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1496;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
