-- MySQL dump 10.13  Distrib 5.7.20, for Linux (x86_64)
--
-- Host: localhost    Database: rimtrack_user_37
-- ------------------------------------------------------
-- Server version	5.7.20-0ubuntu0.16.04.1

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `action`
--

DROP TABLE IF EXISTS `action`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `action` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createdat` datetime DEFAULT NULL,
  `details` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKq7e8qgeirqpqadbcb2pqmsupi` (`user_id`),
  CONSTRAINT `FKq7e8qgeirqpqadbcb2pqmsupi` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `action`
--

LOCK TABLES `action` WRITE;
/*!40000 ALTER TABLE `action` DISABLE KEYS */;
/*!40000 ALTER TABLE `action` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alert_configurations`
--

DROP TABLE IF EXISTS `alert_configurations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alert_configurations` (
  `alert_alert_id` bigint(20) NOT NULL,
  `configurations_configuration_id` bigint(20) NOT NULL,
  PRIMARY KEY (`alert_alert_id`,`configurations_configuration_id`),
  UNIQUE KEY `UK_erfiqiljwl2uixve05pmoo2el` (`configurations_configuration_id`),
  CONSTRAINT `FKdkbrjlgv1xsp3452a2xmjvisa` FOREIGN KEY (`alert_alert_id`) REFERENCES `alert_` (`alert_id`),
  CONSTRAINT `FKib82ss73b9bmk7lshcolkqlyf` FOREIGN KEY (`configurations_configuration_id`) REFERENCES `configuration` (`configuration_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alert_configurations`
--

LOCK TABLES `alert_configurations` WRITE;
/*!40000 ALTER TABLE `alert_configurations` DISABLE KEYS */;
/*!40000 ALTER TABLE `alert_configurations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alertconfiguration`
--

DROP TABLE IF EXISTS `alertconfiguration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alertconfiguration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operator_id` int(11) DEFAULT NULL,
  `value1` varchar(255) COLLATE utf8_unicode_ci DEFAULT '0',
  `value2` varchar(255) COLLATE utf8_unicode_ci DEFAULT '0',
  `type` enum('SPEED','POI','INGNITION','RT','TOW','INSURANCE',' DRIVING_QUALITY','VISIT','ROAD_TAXES','OPERATIONAL_CERTIFICATION','PERMIT_CIRCULATION','DATE','CHARGER') COLLATE utf8_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `alert_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_useralert` (`alert_id`),
  KEY `FK_operator` (`operator_id`),
  CONSTRAINT `FK866n0lfam9y33ce62eet0t0ir` FOREIGN KEY (`alert_id`) REFERENCES `useralert` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alertconfiguration`
--

LOCK TABLES `alertconfiguration` WRITE;
/*!40000 ALTER TABLE `alertconfiguration` DISABLE KEYS */;
/*!40000 ALTER TABLE `alertconfiguration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alertconfigurationoperator`
--

DROP TABLE IF EXISTS `alertconfigurationoperator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alertconfigurationoperator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alertconfigurationoperator`
--

LOCK TABLES `alertconfigurationoperator` WRITE;
/*!40000 ALTER TABLE `alertconfigurationoperator` DISABLE KEYS */;
/*!40000 ALTER TABLE `alertconfigurationoperator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `assignment`
--

DROP TABLE IF EXISTS `assignment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assignment` (
  `date` datetime NOT NULL,
  `driver_driver_id` bigint(20) NOT NULL,
  `vehicule_vehicule_id` bigint(20) NOT NULL,
  `active` bit(1) DEFAULT NULL,
  PRIMARY KEY (`date`,`driver_driver_id`,`vehicule_vehicule_id`),
  KEY `FKg2806vicq76d3wtu7b6prolr2` (`driver_driver_id`),
  KEY `FKpea0fybdv9kcp3wgpnywycbur` (`vehicule_vehicule_id`),
  CONSTRAINT `FKg2806vicq76d3wtu7b6prolr2` FOREIGN KEY (`driver_driver_id`) REFERENCES `driver` (`driver_id`),
  CONSTRAINT `FKpea0fybdv9kcp3wgpnywycbur` FOREIGN KEY (`vehicule_vehicule_id`) REFERENCES `vehicule` (`vehicule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assignment`
--

LOCK TABLES `assignment` WRITE;
/*!40000 ALTER TABLE `assignment` DISABLE KEYS */;
/*!40000 ALTER TABLE `assignment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `authority`
--

DROP TABLE IF EXISTS `authority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `authority` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `authority`
--

LOCK TABLES `authority` WRITE;
/*!40000 ALTER TABLE `authority` DISABLE KEYS */;
INSERT INTO `authority` VALUES (1,'Temps r?el','ROLE_RT'),(2,'Historique','ROLE_PATH'),(3,'Gestion des donn?es','ROLE_DM'),(4,'Gestion du parc','ROLE_PM'),(5,'Gestion des alertes','ROLE_AM'),(6,'G?n?rateur de rapports','ROLE_RM'),(7,'Vue sur l\'ensemble','ROLE_OV'),(8,'Arret/Lancement moteur','ROLE_ENGINE_CONTROLE');
/*!40000 ALTER TABLE `authority` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `battery_maintenance`
--

DROP TABLE IF EXISTS `battery_maintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `battery_maintenance` (
  `amperage` bigint(20) DEFAULT NULL,
  `duration` bigint(20) DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `mark` varchar(255) DEFAULT NULL,
  `number` bigint(20) DEFAULT NULL,
  `serie_number` varchar(255) DEFAULT NULL,
  `voltage` bigint(20) DEFAULT NULL,
  `id_maintenance` bigint(20) NOT NULL,
  PRIMARY KEY (`id_maintenance`),
  CONSTRAINT `FK6pu3h6iyiahle1reyivrmxs3` FOREIGN KEY (`id_maintenance`) REFERENCES `maintenance` (`id_maintenance`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `battery_maintenance`
--

LOCK TABLES `battery_maintenance` WRITE;
/*!40000 ALTER TABLE `battery_maintenance` DISABLE KEYS */;
/*!40000 ALTER TABLE `battery_maintenance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `brake_maintenance`
--

DROP TABLE IF EXISTS `brake_maintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brake_maintenance` (
  `board_games` bit(1) DEFAULT NULL,
  `disk` bit(1) DEFAULT NULL,
  `oil` bit(1) DEFAULT NULL,
  `position` bit(1) DEFAULT NULL,
  `pump` bit(1) DEFAULT NULL,
  `id_maintenance` bigint(20) NOT NULL,
  `right_position` bit(1) DEFAULT NULL,
  `left_position` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id_maintenance`),
  CONSTRAINT `FKawbwgtjqwms4h9ptyjy8mfaw1` FOREIGN KEY (`id_maintenance`) REFERENCES `maintenance` (`id_maintenance`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brake_maintenance`
--

LOCK TABLES `brake_maintenance` WRITE;
/*!40000 ALTER TABLE `brake_maintenance` DISABLE KEYS */;
/*!40000 ALTER TABLE `brake_maintenance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cal_alert`
--

DROP TABLE IF EXISTS `cal_alert`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cal_alert` (
  `alert_id` bigint(20) NOT NULL DEFAULT '0',
  `last_id` bigint(20) DEFAULT '0',
  `last_time` timestamp NULL DEFAULT '2017-07-12 09:02:04',
  `last_state` varchar(45) DEFAULT 'nothingToReport',
  `last_reported_state` varchar(45) DEFAULT 'nothingToReport',
  `last_location_latitude` double DEFAULT '0',
  `last_location_longitude` double DEFAULT '0',
  `last_alert_begin_time` timestamp NULL DEFAULT '2017-07-12 09:02:04',
  `last_reported` tinyint(1) DEFAULT '0',
  `last_report_Alert` tinyint(1) DEFAULT '0',
  `last_alert_date` timestamp NULL DEFAULT '2017-07-12 09:02:04',
  `last_alert_location` varchar(255) DEFAULT 'NOTHING',
  `last_alert_referenced_value` varchar(5000) DEFAULT 'NOTHING',
  `last_alert_value` varchar(255) DEFAULT 'NOTHING',
  `last_alert_lock` tinyint(1) DEFAULT '0',
  `last_alert_type` varchar(45) DEFAULT 'NOTHING',
  `last_device_id` bigint(20) DEFAULT '0',
  `last_poi_id` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`alert_id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cal_alert`
--

LOCK TABLES `cal_alert` WRITE;
/*!40000 ALTER TABLE `cal_alert` DISABLE KEYS */;
/*!40000 ALTER TABLE `cal_alert` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cal_alert_commit`
--

DROP TABLE IF EXISTS `cal_alert_commit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cal_alert_commit` (
  `alert_id` bigint(20) NOT NULL DEFAULT '0',
  `last_id` bigint(20) DEFAULT '0',
  `last_time` timestamp NULL DEFAULT '2017-07-12 09:02:04',
  `last_state` varchar(45) DEFAULT 'nothingToReport',
  `last_reported_state` varchar(45) DEFAULT 'nothingToReport',
  `last_location_latitude` double DEFAULT '0',
  `last_location_longitude` double DEFAULT '0',
  `last_alert_begin_time` timestamp NULL DEFAULT '2017-07-12 09:02:04',
  `last_reported` tinyint(1) DEFAULT '0',
  `last_report_Alert` tinyint(1) DEFAULT '0',
  `last_alert_date` timestamp NULL DEFAULT '2017-07-12 09:02:04',
  `last_alert_location` varchar(255) DEFAULT 'NOTHING',
  `last_alert_referenced_value` varchar(5000) DEFAULT 'NOTHING',
  `last_alert_value` varchar(255) DEFAULT 'NOTHING',
  `last_alert_lock` tinyint(1) DEFAULT '0',
  `last_alert_type` varchar(45) DEFAULT 'NOTHING',
  `last_device_id` bigint(20) DEFAULT '0',
  `last_poi_id` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`alert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cal_alert_commit`
--

LOCK TABLES `cal_alert_commit` WRITE;
/*!40000 ALTER TABLE `cal_alert_commit` DISABLE KEYS */;
/*!40000 ALTER TABLE `cal_alert_commit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cal_option`
--

DROP TABLE IF EXISTS `cal_option`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cal_option` (
  `device_id` bigint(10) NOT NULL,
  `last_id` int(11) DEFAULT '0',
  `state` int(11) DEFAULT '0',
  `last_time` timestamp(6) NOT NULL DEFAULT '2017-01-01 00:00:00.000000',
  `last_FuelLevel` int(11) DEFAULT '-1',
  `last_Odo` double DEFAULT '0',
  `last_TFU` double DEFAULT '0',
  `consume_start_fuel_level` double DEFAULT '0',
  `consume_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `consume_start_odo` double DEFAULT '0',
  `consume_start_tfu` double DEFAULT '0',
  `appro_start_fuel_level` double DEFAULT '0',
  `appro_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `appro_start_odo` double DEFAULT '0',
  `appro_start_tfu` double DEFAULT '0',
  `appro_end_fuel_level` double DEFAULT '0',
  `appro_end_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `appro_end_odo` double DEFAULT '0',
  `appro_end_tfu` double DEFAULT '0',
  `val1` double DEFAULT '0',
  `val2` double DEFAULT '0',
  `val3` double DEFAULT '0',
  `val4` double DEFAULT '0',
  `val5` double DEFAULT '0',
  `activity_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `activity_start_lat` double NOT NULL DEFAULT '0',
  `activity_start_lon` double NOT NULL DEFAULT '0',
  `activity_start_odo` double NOT NULL DEFAULT '0',
  `activity_start_tfu` double NOT NULL DEFAULT '0',
  `activity_in_progress` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`device_id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cal_option`
--

LOCK TABLES `cal_option` WRITE;
/*!40000 ALTER TABLE `cal_option` DISABLE KEYS */;
/*!40000 ALTER TABLE `cal_option` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cal_option_commit`
--

DROP TABLE IF EXISTS `cal_option_commit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cal_option_commit` (
  `device_id` bigint(10) NOT NULL,
  `last_id` int(11) DEFAULT '0',
  `state` int(11) DEFAULT '0',
  `last_time` timestamp(6) NOT NULL DEFAULT '2017-01-01 00:00:00.000000',
  `last_FuelLevel` int(11) DEFAULT '-1',
  `last_Odo` double DEFAULT '0',
  `last_TFU` double DEFAULT '0',
  `consume_start_fuel_level` double DEFAULT '0',
  `consume_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `consume_start_odo` double DEFAULT '0',
  `consume_start_tfu` double DEFAULT '0',
  `appro_start_fuel_level` double DEFAULT '0',
  `appro_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `appro_start_odo` double DEFAULT '0',
  `appro_start_tfu` double DEFAULT '0',
  `appro_end_fuel_level` double DEFAULT '0',
  `appro_end_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `appro_end_odo` double DEFAULT '0',
  `appro_end_tfu` double DEFAULT '0',
  `val1` double DEFAULT '0',
  `val2` double DEFAULT '0',
  `val3` double DEFAULT '0',
  `val4` double DEFAULT '0',
  `val5` double DEFAULT '0',
  `activity_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `activity_start_lat` double NOT NULL DEFAULT '0',
  `activity_start_lon` double NOT NULL DEFAULT '0',
  `activity_start_odo` double NOT NULL DEFAULT '0',
  `activity_start_tfu` double NOT NULL DEFAULT '0',
  `activity_in_progress` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`device_id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cal_option_commit`
--

LOCK TABLES `cal_option_commit` WRITE;
/*!40000 ALTER TABLE `cal_option_commit` DISABLE KEYS */;
/*!40000 ALTER TABLE `cal_option_commit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cal_travel`
--

DROP TABLE IF EXISTS `cal_travel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cal_travel` (
  `device_id` bigint(20) NOT NULL,
  `last_id` bigint(20) NOT NULL DEFAULT '0',
  `state` int(11) NOT NULL DEFAULT '0',
  `last_time` timestamp NOT NULL DEFAULT '2010-01-01 00:00:00',
  `last_position_lat` double DEFAULT '0',
  `last_position_long` double DEFAULT '0',
  `last_path_start_time` timestamp NULL DEFAULT NULL,
  `last_start_position_lat` double DEFAULT '0',
  `last_start_position_long` double DEFAULT '0',
  `last_max_speed` int(4) DEFAULT '0',
  `last_distance_driven` double DEFAULT '0',
  `last_path_duration` bigint(20) NOT NULL DEFAULT '0',
  `doubt_end_path` timestamp NULL DEFAULT NULL,
  `report_start` int(1) DEFAULT '0',
  `last_stop_start_time` timestamp NULL DEFAULT NULL,
  `last_stop_position_lat` double DEFAULT '0',
  `last_stop_position_long` double DEFAULT '0',
  `last_stop_duration` bigint(20) NOT NULL DEFAULT '0',
  `doubt_end_stop` timestamp NULL DEFAULT NULL,
  `report_stop` int(1) DEFAULT '0',
  `last_mileage_distance_driven` double DEFAULT '0',
  `last_mileage_duration` bigint(20) DEFAULT '0',
  `last_mileage_start_time` timestamp NULL DEFAULT NULL,
  `last_mileage_end_time` timestamp NULL DEFAULT NULL,
  `last_activity_begin_time` timestamp NULL DEFAULT NULL,
  `last_activity_end_time` timestamp NULL DEFAULT NULL,
  `last_total_activity_duration` bigint(20) DEFAULT NULL,
  `last_activity_duration` bigint(20) DEFAULT NULL,
  `last_activity_driving_distance` double DEFAULT NULL,
  `last_activity_begin_location_lat` double DEFAULT '0',
  `last_activity_begin_location_long` double DEFAULT '0',
  `last_activity_stop_duration` bigint(20) DEFAULT NULL,
  `report_activity` int(1) DEFAULT NULL,
  `was_Ignition` int(1) DEFAULT NULL,
  `last_activity_end_location_lat` double DEFAULT NULL,
  `last_activity_end_location_long` double DEFAULT NULL,
  `accum_odo` double DEFAULT '0',
  `last_path_start_odo` double NOT NULL DEFAULT '0',
  `last_path_start_tfu` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`device_id`),
  KEY `FKdgf843sp9ammorctn7u2l564r` (`device_id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cal_travel`
--

LOCK TABLES `cal_travel` WRITE;
/*!40000 ALTER TABLE `cal_travel` DISABLE KEYS */;
INSERT INTO `cal_travel` VALUES (700351,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700352,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700353,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700354,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700355,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700356,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700357,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700358,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700359,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700360,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700361,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700362,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700363,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700364,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700365,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700366,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700367,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700368,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700369,0,0,'2010-01-01 00:00:00',0,0,NULL,0,0,0,0,0,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0);
/*!40000 ALTER TABLE `cal_travel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cal_travel_commit`
--

DROP TABLE IF EXISTS `cal_travel_commit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cal_travel_commit` (
  `device_id` bigint(20) NOT NULL,
  `last_id` bigint(20) DEFAULT '0',
  `state` int(11) DEFAULT '0',
  `last_time` timestamp NULL DEFAULT NULL,
  `last_position_lat` double DEFAULT '0',
  `last_position_long` double DEFAULT '0',
  `last_path_start_time` timestamp NULL DEFAULT NULL,
  `last_start_position_lat` double DEFAULT '0',
  `last_start_position_long` double DEFAULT '0',
  `last_max_speed` int(4) DEFAULT '0',
  `last_distance_driven` double DEFAULT '0',
  `last_path_duration` bigint(20) DEFAULT NULL,
  `doubt_end_path` timestamp NULL DEFAULT NULL,
  `report_start` int(1) DEFAULT '0',
  `last_stop_start_time` timestamp NULL DEFAULT NULL,
  `last_stop_position_lat` double DEFAULT '0',
  `last_stop_position_long` double DEFAULT '0',
  `last_stop_duration` bigint(20) DEFAULT '0',
  `doubt_end_stop` timestamp NULL DEFAULT NULL,
  `report_stop` int(1) DEFAULT '0',
  `last_mileage_distance_driven` double DEFAULT '0',
  `last_mileage_duration` bigint(20) DEFAULT '0',
  `last_mileage_start_time` timestamp NULL DEFAULT NULL,
  `last_mileage_end_time` timestamp NULL DEFAULT NULL,
  `last_activity_begin_time` timestamp NULL DEFAULT NULL,
  `last_activity_end_time` timestamp NULL DEFAULT NULL,
  `last_total_activity_duration` bigint(20) DEFAULT NULL,
  `last_activity_duration` bigint(20) DEFAULT NULL,
  `last_activity_driving_distance` double DEFAULT NULL,
  `last_activity_begin_location_lat` double DEFAULT '0',
  `last_activity_begin_location_long` double DEFAULT '0',
  `last_activity_stop_duration` bigint(20) DEFAULT NULL,
  `report_activity` int(1) DEFAULT NULL,
  `was_Ignition` int(1) DEFAULT NULL,
  `last_activity_end_location_lat` double DEFAULT NULL,
  `last_activity_end_location_long` double DEFAULT NULL,
  `accum_odo` double DEFAULT '0',
  `last_path_start_odo` double NOT NULL DEFAULT '0',
  `last_path_start_tfu` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`device_id`),
  KEY `FKdgf843sp9ammorctn7u2l564r` (`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cal_travel_commit`
--

LOCK TABLES `cal_travel_commit` WRITE;
/*!40000 ALTER TABLE `cal_travel_commit` DISABLE KEYS */;
INSERT INTO `cal_travel_commit` VALUES (700351,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700352,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700353,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700354,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700355,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700356,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700357,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700358,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700359,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700360,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700361,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700362,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700363,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700364,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700365,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700366,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700367,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700368,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0),(700369,0,0,NULL,0,0,NULL,0,0,0,0,NULL,NULL,0,NULL,0,0,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0);
/*!40000 ALTER TABLE `cal_travel_commit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `collect_setting`
--

DROP TABLE IF EXISTS `collect_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `collect_setting` (
  `id_collect_setting` bigint(20) NOT NULL AUTO_INCREMENT,
  `name_collect_setting` varchar(255) DEFAULT NULL,
  `device_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_collect_setting`),
  KEY `FK7c3b31us2foyjhob6biojh2jg` (`device_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `collect_setting`
--

LOCK TABLES `collect_setting` WRITE;
/*!40000 ALTER TABLE `collect_setting` DISABLE KEYS */;
/*!40000 ALTER TABLE `collect_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `configuration`
--

DROP TABLE IF EXISTS `configuration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `configuration` (
  `configuration_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `value` varchar(50) DEFAULT NULL,
  `information_id` bigint(20) DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`configuration_id`),
  KEY `FKmmbmwoa86pporgwrh6l3cypt5` (`information_id`),
  KEY `FK78ji38trvced3c6mbji929mkm` (`operator_id`),
  CONSTRAINT `FK78ji38trvced3c6mbji929mkm` FOREIGN KEY (`operator_id`) REFERENCES `operator` (`operator_id`),
  CONSTRAINT `FKmmbmwoa86pporgwrh6l3cypt5` FOREIGN KEY (`information_id`) REFERENCES `information` (`information_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `configuration`
--

LOCK TABLES `configuration` WRITE;
/*!40000 ALTER TABLE `configuration` DISABLE KEYS */;
/*!40000 ALTER TABLE `configuration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device`
--

DROP TABLE IF EXISTS `device`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device` (
  `id_device` bigint(20) NOT NULL,
  `vehicule_id` bigint(20) DEFAULT NULL,
  `realtimerecord_id` bigint(20) DEFAULT NULL,
  `device_number` bigint(20) DEFAULT NULL,
  `rawstream_id` int(11) NOT NULL DEFAULT '0',
  `stream_id` varchar(45) DEFAULT NULL,
  `imei` varchar(20) DEFAULT NULL,
  `icc` varchar(20) DEFAULT NULL,
  `serial` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_device`),
  KEY `FK7iubld493jmj6xk3x2pems53x` (`realtimerecord_id`),
  KEY `FKchqmtj446ldwskbobvbano9rp` (`vehicule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device`
--

LOCK TABLES `device` WRITE;
/*!40000 ALTER TABLE `device` DISABLE KEYS */;
INSERT INTO `device` VALUES (700351,28,NULL,700351,0,NULL,NULL,NULL,NULL),(700352,29,NULL,700352,0,NULL,NULL,NULL,NULL),(700353,30,NULL,700353,0,NULL,NULL,NULL,NULL),(700354,31,NULL,700354,0,NULL,NULL,NULL,NULL),(700355,32,NULL,700355,0,NULL,NULL,NULL,NULL),(700356,33,NULL,700356,0,NULL,NULL,NULL,NULL),(700357,34,NULL,700357,0,NULL,NULL,NULL,NULL),(700358,35,NULL,700358,0,NULL,NULL,NULL,NULL),(700359,36,NULL,700359,0,NULL,NULL,NULL,NULL),(700360,37,NULL,700360,0,NULL,NULL,NULL,NULL),(700361,38,NULL,700361,0,NULL,NULL,NULL,NULL),(700362,39,NULL,700362,0,NULL,NULL,NULL,NULL),(700363,40,NULL,700363,0,NULL,NULL,NULL,NULL),(700364,41,NULL,700364,0,NULL,NULL,NULL,NULL),(700365,42,NULL,700365,0,NULL,NULL,NULL,NULL),(700366,43,NULL,700366,0,NULL,NULL,NULL,NULL),(700367,44,NULL,700367,0,NULL,NULL,NULL,NULL),(700368,45,NULL,700368,0,NULL,NULL,NULL,NULL),(700369,46,NULL,700369,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `device` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device_carb`
--

DROP TABLE IF EXISTS `device_carb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device_carb` (
  `device_id` int(11) NOT NULL,
  `max` int(11) DEFAULT '100',
  `min` int(11) DEFAULT '0',
  `filtrage` int(11) DEFAULT '4',
  `volume` int(11) DEFAULT '100',
  `fuel_src` int(11) DEFAULT '0',
  `fuel_algo` int(11) DEFAULT '0',
  PRIMARY KEY (`device_id`),
  KEY `FKdgf843sp9ammorctn7u2l564r` (`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device_carb`
--

LOCK TABLES `device_carb` WRITE;
/*!40000 ALTER TABLE `device_carb` DISABLE KEYS */;
INSERT INTO `device_carb` VALUES (700351,100,0,4,100,0,0),(700352,100,0,4,100,0,0),(700353,100,0,4,100,0,0),(700354,100,0,4,100,0,0),(700355,100,0,4,100,0,0),(700356,100,0,4,100,0,0),(700357,100,0,4,100,0,0),(700358,100,0,4,100,0,0),(700359,100,0,4,100,0,0),(700360,100,0,4,100,0,0),(700361,100,0,4,100,0,0),(700362,100,0,4,100,0,0),(700363,100,0,4,100,0,0),(700364,100,0,4,100,0,0),(700365,100,0,4,100,0,0),(700366,100,0,4,100,0,0),(700367,100,0,4,100,0,0),(700368,100,0,4,100,0,0),(700369,100,0,4,100,0,0);
/*!40000 ALTER TABLE `device_carb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device_opt`
--

DROP TABLE IF EXISTS `device_opt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device_opt` (
  `device_id` int(11) NOT NULL,
  `use_ignition` int(1) DEFAULT '1',
  `use_fuel` int(1) DEFAULT '0',
  `use_temp` int(1) DEFAULT '0',
  `use_fms` int(1) DEFAULT '0',
  `use_j1708` int(1) DEFAULT '0',
  `use_id_driver` int(1) DEFAULT '0',
  `use_stop` int(1) DEFAULT '0',
  PRIMARY KEY (`device_id`),
  KEY `FKdgf843sp9ammorctn7u2l564r` (`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device_opt`
--

LOCK TABLES `device_opt` WRITE;
/*!40000 ALTER TABLE `device_opt` DISABLE KEYS */;
INSERT INTO `device_opt` VALUES (700351,1,0,0,0,0,0,0),(700352,1,0,0,0,0,0,0),(700353,1,0,0,0,0,0,0),(700354,1,0,0,0,0,0,0),(700355,1,0,0,0,0,0,0),(700356,1,0,0,0,0,0,0),(700357,1,0,0,0,0,0,0),(700358,1,0,0,0,0,0,0),(700359,1,0,0,0,0,0,0),(700360,1,0,0,0,0,0,0),(700361,1,0,0,0,0,0,0),(700362,1,0,0,0,0,0,0),(700363,1,0,0,0,0,0,0),(700364,1,0,0,0,0,0,0),(700365,1,0,0,0,0,0,0),(700366,1,0,0,0,0,0,0),(700367,1,0,0,0,0,0,0),(700368,1,0,0,0,0,0,0),(700369,1,0,0,0,0,0,0);
/*!40000 ALTER TABLE `device_opt` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `document`
--

DROP TABLE IF EXISTS `document`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `document` (
  `doc_type` varchar(31) NOT NULL,
  `id_document` bigint(20) NOT NULL AUTO_INCREMENT,
  `cost` double DEFAULT NULL,
  `date_operation` datetime DEFAULT NULL,
  `provider_id` bigint(20) DEFAULT NULL,
  `vehicule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_document`),
  KEY `FK9ep9a9o6nonqb98qu02mot7ys` (`provider_id`),
  KEY `FK29ktopfp8sk6c0o6qdvvhbiul` (`vehicule_id`),
  CONSTRAINT `FK29ktopfp8sk6c0o6qdvvhbiul` FOREIGN KEY (`vehicule_id`) REFERENCES `vehicule` (`vehicule_id`),
  CONSTRAINT `FK9ep9a9o6nonqb98qu02mot7ys` FOREIGN KEY (`provider_id`) REFERENCES `provider` (`id_provider`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `document`
--

LOCK TABLES `document` WRITE;
/*!40000 ALTER TABLE `document` DISABLE KEYS */;
/*!40000 ALTER TABLE `document` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `driver`
--

DROP TABLE IF EXISTS `driver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `driver` (
  `driver_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cin` varchar(50) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `blood_group` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`driver_id`),
  UNIQUE KEY `UK_fchuyotq64tagkwktlh4qttyy` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `driver`
--

LOCK TABLES `driver` WRITE;
/*!40000 ALTER TABLE `driver` DISABLE KEYS */;
/*!40000 ALTER TABLE `driver` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fueling`
--

DROP TABLE IF EXISTS `fueling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fueling` (
  `cost_unit` double DEFAULT NULL,
  `number_payment` bigint(20) DEFAULT NULL,
  `observation` varchar(255) DEFAULT NULL,
  `odometre` bigint(20) DEFAULT NULL,
  `quantity` double DEFAULT NULL,
  `id_document` bigint(20) NOT NULL,
  `payment_type_id` bigint(20) DEFAULT NULL,
  `cost_total` double DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `num_cart_fuel` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_document`),
  KEY `FKc5umqvld9dr2udmhhpvrm16hv` (`payment_type_id`),
  CONSTRAINT `FKc5umqvld9dr2udmhhpvrm16hv` FOREIGN KEY (`payment_type_id`) REFERENCES `type` (`id_type`),
  CONSTRAINT `FKgrxhtkq1pf59nj252exh5ih4d` FOREIGN KEY (`id_document`) REFERENCES `document` (`id_document`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fueling`
--

LOCK TABLES `fueling` WRITE;
/*!40000 ALTER TABLE `fueling` DISABLE KEYS */;
/*!40000 ALTER TABLE `fueling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `groupe`
--

DROP TABLE IF EXISTS `groupe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groupe` (
  `groupe_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url_image` varchar(100) DEFAULT NULL,
  `nom` varchar(50) NOT NULL,
  PRIMARY KEY (`groupe_id`),
  UNIQUE KEY `UK_b30fmcjbp89j49uc6qtdb4dni` (`nom`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `groupe`
--

LOCK TABLES `groupe` WRITE;
/*!40000 ALTER TABLE `groupe` DISABLE KEYS */;
INSERT INTO `groupe` VALUES (15,NULL,'tout');
/*!40000 ALTER TABLE `groupe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `information`
--

DROP TABLE IF EXISTS `information`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `information` (
  `information_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `icon_url` varchar(255) DEFAULT NULL,
  `information_type` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `symbol` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`information_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `information`
--

LOCK TABLES `information` WRITE;
/*!40000 ALTER TABLE `information` DISABLE KEYS */;
/*!40000 ALTER TABLE `information` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `information_operator`
--

DROP TABLE IF EXISTS `information_operator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `information_operator` (
  `information_id` bigint(20) NOT NULL,
  `operator_id` bigint(20) NOT NULL,
  PRIMARY KEY (`information_id`,`operator_id`),
  KEY `FK3vrafpslk7datgnv82yvtmht6` (`operator_id`),
  CONSTRAINT `FK3vrafpslk7datgnv82yvtmht6` FOREIGN KEY (`operator_id`) REFERENCES `operator` (`operator_id`),
  CONSTRAINT `FK88kta75amrjk6vhghsak0ofh6` FOREIGN KEY (`information_id`) REFERENCES `information` (`information_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `information_operator`
--

LOCK TABLES `information_operator` WRITE;
/*!40000 ALTER TABLE `information_operator` DISABLE KEYS */;
/*!40000 ALTER TABLE `information_operator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `information_suggestions`
--

DROP TABLE IF EXISTS `information_suggestions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `information_suggestions` (
  `information_information_id` bigint(20) NOT NULL,
  `suggestions_suggestion_id` bigint(20) NOT NULL,
  PRIMARY KEY (`information_information_id`,`suggestions_suggestion_id`),
  UNIQUE KEY `UK_4itbdoxkhneclwwulqh8k9b73` (`suggestions_suggestion_id`),
  CONSTRAINT `FKb98jt1dxr6p4c26fiajfc9vhb` FOREIGN KEY (`suggestions_suggestion_id`) REFERENCES `suggestion` (`suggestion_id`),
  CONSTRAINT `FKp8fckph6ylkp9bbaq54l63alm` FOREIGN KEY (`information_information_id`) REFERENCES `information` (`information_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `information_suggestions`
--

LOCK TABLES `information_suggestions` WRITE;
/*!40000 ALTER TABLE `information_suggestions` DISABLE KEYS */;
/*!40000 ALTER TABLE `information_suggestions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `maintenance`
--

DROP TABLE IF EXISTS `maintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintenance` (
  `maintenance_type` varchar(31) NOT NULL,
  `id_maintenance` bigint(20) NOT NULL AUTO_INCREMENT,
  `cost` double DEFAULT NULL,
  `observation` varchar(255) DEFAULT NULL,
  `date_operation` datetime DEFAULT NULL,
  `provider_id` bigint(20) DEFAULT NULL,
  `vehicule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_maintenance`),
  KEY `FKx7j5n055fa64ygw792gt1ono` (`provider_id`),
  KEY `FKprlafcxlm7a76e8mce92tuh8i` (`vehicule_id`),
  CONSTRAINT `FKprlafcxlm7a76e8mce92tuh8i` FOREIGN KEY (`vehicule_id`) REFERENCES `vehicule` (`vehicule_id`),
  CONSTRAINT `FKx7j5n055fa64ygw792gt1ono` FOREIGN KEY (`provider_id`) REFERENCES `provider` (`id_provider`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maintenance`
--

LOCK TABLES `maintenance` WRITE;
/*!40000 ALTER TABLE `maintenance` DISABLE KEYS */;
/*!40000 ALTER TABLE `maintenance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mileage`
--

DROP TABLE IF EXISTS `mileage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mileage` (
  `device_id` int(11) NOT NULL,
  `start_hour` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `end_hour` timestamp NULL DEFAULT NULL,
  `driving_distance` double DEFAULT '0',
  `driving_duration` bigint(20) DEFAULT '0',
  PRIMARY KEY (`device_id`,`start_hour`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mileage`
--

LOCK TABLES `mileage` WRITE;
/*!40000 ALTER TABLE `mileage` DISABLE KEYS */;
/*!40000 ALTER TABLE `mileage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification`
--

DROP TABLE IF EXISTS `notification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `alert_value` varchar(255) DEFAULT NULL,
  `alertid` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `device_id` bigint(20) DEFAULT NULL,
  `is_readed` tinyint(4) NOT NULL DEFAULT '0',
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `poi_id` varchar(255) DEFAULT NULL,
  `id_document` bigint(20) DEFAULT NULL,
  `message` varchar(2000) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `fuel_rate` double NOT NULL DEFAULT '0',
  `ignition` tinyint(1) DEFAULT NULL,
  `odo` double NOT NULL DEFAULT '0',
  `tfu` double NOT NULL DEFAULT '0',
  `temp_engine` int(11) DEFAULT NULL,
  `accum_odo` float DEFAULT NULL,
  `temp` varchar(5) DEFAULT NULL,
  `fuel` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK86uaicb374d362ai0t28hbv1q` (`alertid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification`
--

LOCK TABLES `notification` WRITE;
/*!40000 ALTER TABLE `notification` DISABLE KEYS */;
/*!40000 ALTER TABLE `notification` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `offense`
--

DROP TABLE IF EXISTS `offense`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `offense` (
  `paying` varchar(255) DEFAULT NULL,
  `place` varchar(255) DEFAULT NULL,
  `id_maintenance` bigint(20) NOT NULL,
  `offense_type` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_maintenance`),
  KEY `FKhq4ae95g4iprx5mv7q1insv0w` (`offense_type`),
  CONSTRAINT `FK2mq5t0cwnbed3i2e5q65v524` FOREIGN KEY (`id_maintenance`) REFERENCES `maintenance` (`id_maintenance`),
  CONSTRAINT `FKhq4ae95g4iprx5mv7q1insv0w` FOREIGN KEY (`offense_type`) REFERENCES `type` (`id_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `offense`
--

LOCK TABLES `offense` WRITE;
/*!40000 ALTER TABLE `offense` DISABLE KEYS */;
/*!40000 ALTER TABLE `offense` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oil_change`
--

DROP TABLE IF EXISTS `oil_change`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oil_change` (
  `air_f` bit(1) DEFAULT NULL,
  `engine_oil` bit(1) DEFAULT NULL,
  `fuel_f` bit(1) DEFAULT NULL,
  `oil_f` bit(1) DEFAULT NULL,
  `quantity` bigint(20) DEFAULT NULL,
  `separator_f` bit(1) DEFAULT NULL,
  `type_air_f` bigint(20) DEFAULT NULL,
  `type_engine_oil` bigint(20) DEFAULT NULL,
  `type_fuel_f` bigint(20) DEFAULT NULL,
  `type_oil_f` bigint(20) DEFAULT NULL,
  `type_separator_f` bigint(20) DEFAULT NULL,
  `id_maintenance` bigint(20) NOT NULL,
  `odometre` bigint(20) DEFAULT NULL,
  `air_conditioning_filter` bit(1) DEFAULT NULL,
  `oil_mark` varchar(255) DEFAULT NULL,
  `seal` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id_maintenance`),
  CONSTRAINT `FKl9a0v6vhemybvnt4e42bs675e` FOREIGN KEY (`id_maintenance`) REFERENCES `maintenance` (`id_maintenance`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oil_change`
--

LOCK TABLES `oil_change` WRITE;
/*!40000 ALTER TABLE `oil_change` DISABLE KEYS */;
/*!40000 ALTER TABLE `oil_change` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `operator`
--

DROP TABLE IF EXISTS `operator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `operator` (
  `operator_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `symbol` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`operator_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `operator`
--

LOCK TABLES `operator` WRITE;
/*!40000 ALTER TABLE `operator` DISABLE KEYS */;
/*!40000 ALTER TABLE `operator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `path`
--

DROP TABLE IF EXISTS `path`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `path` (
  `device_id` bigint(20) NOT NULL,
  `begin_path_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `end_path_time` timestamp NULL DEFAULT NULL,
  `begin_path_latitude` double DEFAULT NULL,
  `begin_path_longitude` double DEFAULT NULL,
  `end_path_latitude` double DEFAULT NULL,
  `end_path_longitude` double DEFAULT NULL,
  `max_speed` int(11) DEFAULT NULL,
  `path_duration` bigint(20) DEFAULT '0',
  `distance_driven` double DEFAULT NULL,
  `fuel_used` double NOT NULL DEFAULT '0',
  `start_fuel` double NOT NULL DEFAULT '0',
  `end_fuel` double NOT NULL DEFAULT '0',
  `start_odo` double NOT NULL DEFAULT '0',
  `end_odo` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`device_id`,`begin_path_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `path`
--

LOCK TABLES `path` WRITE;
/*!40000 ALTER TABLE `path` DISABLE KEYS */;
/*!40000 ALTER TABLE `path` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `path_config`
--

DROP TABLE IF EXISTS `path_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `path_config` (
  `device_id` int(11) NOT NULL,
  `path_min_speed` int(11) DEFAULT '5',
  `path_min_sec` int(11) DEFAULT '20',
  `stop_min_sec` int(11) DEFAULT '120',
  `pause_min_sec` int(11) DEFAULT '60',
  `distance_min_meter` double DEFAULT '10',
  PRIMARY KEY (`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `path_config`
--

LOCK TABLES `path_config` WRITE;
/*!40000 ALTER TABLE `path_config` DISABLE KEYS */;
INSERT INTO `path_config` VALUES (700351,5,90,120,60,10),(700352,5,90,120,60,10),(700353,5,90,120,60,10),(700354,5,90,120,60,10),(700355,5,90,120,60,10),(700356,5,90,120,60,10),(700357,5,90,120,60,10),(700358,5,90,120,60,10),(700359,5,90,120,60,10),(700360,5,90,120,60,10),(700361,5,90,120,60,10),(700362,5,90,120,60,10),(700363,5,90,120,60,10),(700364,5,90,120,60,10),(700365,5,90,120,60,10),(700366,5,90,120,60,10),(700367,5,90,120,60,10),(700368,5,90,120,60,10),(700369,5,90,120,60,10);
/*!40000 ALTER TABLE `path_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_type`
--

DROP TABLE IF EXISTS `payment_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_type` (
  `id_payment_type` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_payment_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_type`
--

LOCK TABLES `payment_type` WRITE;
/*!40000 ALTER TABLE `payment_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `point_interest`
--

DROP TABLE IF EXISTS `point_interest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `point_interest` (
  `point_interest_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `image_uri` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `niveau_zoom` bigint(20) DEFAULT NULL,
  `ray` int(11) DEFAULT NULL,
  `zoom_level` bigint(20) DEFAULT NULL,
  `adresse` varchar(255) DEFAULT NULL,
  `hash` longtext,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`point_interest_id`)
) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `point_interest`
--

LOCK TABLES `point_interest` WRITE;
/*!40000 ALTER TABLE `point_interest` DISABLE KEYS */;
/*!40000 ALTER TABLE `point_interest` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `provider`
--

DROP TABLE IF EXISTS `provider`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `provider` (
  `id_provider` bigint(20) NOT NULL AUTO_INCREMENT,
  `adresse` varchar(50) DEFAULT NULL,
  `codetva` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_provider`),
  UNIQUE KEY `UK_7pvp08p4hu0e5k4452khlhv78` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `provider`
--

LOCK TABLES `provider` WRITE;
/*!40000 ALTER TABLE `provider` DISABLE KEYS */;
/*!40000 ALTER TABLE `provider` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `real_time_dev`
--

DROP TABLE IF EXISTS `real_time_dev`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `real_time_dev` (
  `deviceid` bigint(20) NOT NULL AUTO_INCREMENT,
  `status` varchar(20) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `fuel` int(11) DEFAULT NULL,
  `ignition` bit(1) DEFAULT NULL,
  `mems_x` int(11) DEFAULT NULL,
  `mems_y` int(11) DEFAULT NULL,
  `mems_z` int(11) DEFAULT NULL,
  `power` int(11) DEFAULT NULL,
  `record_time` datetime DEFAULT NULL,
  `sat_in_view` int(11) DEFAULT NULL,
  `send_flag` int(11) DEFAULT NULL,
  `speed` int(11) DEFAULT NULL,
  `temperature` varchar(10) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `validity` bit(1) DEFAULT NULL,
  `signal` varchar(45) DEFAULT NULL,
  `rotation_angle` int(11) DEFAULT NULL,
  `rpm` int(11) NOT NULL DEFAULT '0',
  `fuel_rate` double NOT NULL DEFAULT '0',
  `tfu` double NOT NULL DEFAULT '0',
  `odo` double NOT NULL DEFAULT '0',
  `temp_engine` int(11) NOT NULL DEFAULT '0',
  `accum_odo` float NOT NULL DEFAULT '0',
  `last_raw_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  PRIMARY KEY (`deviceid`)
) ENGINE=MEMORY AUTO_INCREMENT=200321 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `real_time_dev`
--

LOCK TABLES `real_time_dev` WRITE;
/*!40000 ALTER TABLE `real_time_dev` DISABLE KEYS */;
/*!40000 ALTER TABLE `real_time_dev` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rep_activity`
--

DROP TABLE IF EXISTS `rep_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rep_activity` (
  `device_id` int(11) NOT NULL,
  `activity_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `activity_start_lat` double NOT NULL DEFAULT '0',
  `activity_start_lon` double NOT NULL DEFAULT '0',
  `start_adress` text CHARACTER SET utf8,
  `activity_start_odo` double NOT NULL DEFAULT '0',
  `activity_start_tfu` double NOT NULL DEFAULT '0',
  `activity_end_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `activity_end_lat` double NOT NULL DEFAULT '0',
  `activity_end_lon` double NOT NULL DEFAULT '0',
  `end_adress` text CHARACTER SET utf8,
  `activity_end_odo` double NOT NULL DEFAULT '0',
  `activity_end_tfu` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`device_id`,`activity_start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rep_activity`
--

LOCK TABLES `rep_activity` WRITE;
/*!40000 ALTER TABLE `rep_activity` DISABLE KEYS */;
/*!40000 ALTER TABLE `rep_activity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rep_fuel_variation`
--

DROP TABLE IF EXISTS `rep_fuel_variation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rep_fuel_variation` (
  `id_device` int(11) NOT NULL,
  `type` enum('APPRO','THIEF') NOT NULL DEFAULT 'APPRO',
  `consume_start_fuel_level` double DEFAULT '0',
  `consume_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `consume_start_odo` double DEFAULT '0',
  `consume_start_tfu` double DEFAULT '0',
  `appro_start_fuel_level` double DEFAULT '0',
  `appro_start_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `appro_start_odo` double DEFAULT '0',
  `appro_start_tfu` double DEFAULT '0',
  `appro_end_fuel_level` double DEFAULT '0',
  `appro_end_time` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00',
  `appro_end_odo` double DEFAULT '0',
  `appro_end_tfu` double DEFAULT '0',
  PRIMARY KEY (`id_device`,`appro_start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rep_fuel_variation`
--

LOCK TABLES `rep_fuel_variation` WRITE;
/*!40000 ALTER TABLE `rep_fuel_variation` DISABLE KEYS */;
/*!40000 ALTER TABLE `rep_fuel_variation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reparation`
--

DROP TABLE IF EXISTS `reparation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reparation` (
  `odometre` bigint(20) DEFAULT NULL,
  `quantity` bigint(20) DEFAULT NULL,
  `id_maintenance` bigint(20) NOT NULL,
  `reparation_type_id` bigint(20) DEFAULT NULL,
  `next_forecast_odometer` bigint(20) DEFAULT NULL,
  `odometer_repair` bigint(20) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_maintenance`),
  KEY `FK68yv48y1ejpqwmcb03nkcr5hq` (`reparation_type_id`),
  CONSTRAINT `FK68yv48y1ejpqwmcb03nkcr5hq` FOREIGN KEY (`reparation_type_id`) REFERENCES `type` (`id_type`),
  CONSTRAINT `FKcplenxtp421b7e3yooah4ude1` FOREIGN KEY (`id_maintenance`) REFERENCES `maintenance` (`id_maintenance`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reparation`
--

LOCK TABLES `reparation` WRITE;
/*!40000 ALTER TABLE `reparation` DISABLE KEYS */;
/*!40000 ALTER TABLE `reparation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `running_document`
--

DROP TABLE IF EXISTS `running_document`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `running_document` (
  `end_date` datetime DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `id_document` bigint(20) NOT NULL,
  `begin_date` date DEFAULT NULL,
  `maturity_amount` double DEFAULT NULL,
  `ref` varchar(255) DEFAULT NULL,
  `weight` double DEFAULT NULL,
  PRIMARY KEY (`id_document`),
  CONSTRAINT `FK2k8uj22hbx2bca4yvgusrbmm0` FOREIGN KEY (`id_document`) REFERENCES `document` (`id_document`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `running_document`
--

LOCK TABLES `running_document` WRITE;
/*!40000 ALTER TABLE `running_document` DISABLE KEYS */;
/*!40000 ALTER TABLE `running_document` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sinistre`
--

DROP TABLE IF EXISTS `sinistre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sinistre` (
  `description_damage` varchar(255) DEFAULT NULL,
  `place` varchar(255) DEFAULT NULL,
  `refund` bigint(20) DEFAULT NULL,
  `id_maintenance` bigint(20) NOT NULL,
  `cabinet_expertise` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_maintenance`),
  KEY `FKeilc805w5w929y5p17ano6woi` (`cabinet_expertise`),
  CONSTRAINT `FKeilc805w5w929y5p17ano6woi` FOREIGN KEY (`cabinet_expertise`) REFERENCES `type` (`id_type`),
  CONSTRAINT `FKfokbsoaujxfqycd2adig4671x` FOREIGN KEY (`id_maintenance`) REFERENCES `maintenance` (`id_maintenance`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sinistre`
--

LOCK TABLES `sinistre` WRITE;
/*!40000 ALTER TABLE `sinistre` DISABLE KEYS */;
/*!40000 ALTER TABLE `sinistre` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stop`
--

DROP TABLE IF EXISTS `stop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stop` (
  `stop_start` datetime NOT NULL,
  `device_id` int(11) NOT NULL,
  `stop_end` datetime DEFAULT NULL,
  `in_path` varchar(255) DEFAULT NULL,
  `stop_duration` bigint(20) DEFAULT '0',
  `stop_lat` double DEFAULT NULL,
  `stop_long` double DEFAULT NULL,
  `stop_adress` varchar(1000) DEFAULT NULL,
  `Adress_according_poi` text,
  PRIMARY KEY (`stop_start`,`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stop`
--

LOCK TABLES `stop` WRITE;
/*!40000 ALTER TABLE `stop` DISABLE KEYS */;
/*!40000 ALTER TABLE `stop` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suggestion`
--

DROP TABLE IF EXISTS `suggestion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suggestion` (
  `suggestion_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `value` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`suggestion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suggestion`
--

LOCK TABLES `suggestion` WRITE;
/*!40000 ALTER TABLE `suggestion` DISABLE KEYS */;
/*!40000 ALTER TABLE `suggestion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tire_maintenance`
--

DROP TABLE IF EXISTS `tire_maintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tire_maintenance` (
  `date_buy` datetime DEFAULT NULL,
  `km_montage` bigint(20) DEFAULT NULL,
  `mark` varchar(255) DEFAULT NULL,
  `max_km` bigint(20) DEFAULT NULL,
  `number` bigint(20) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `serie_number` varchar(255) DEFAULT NULL,
  `id_maintenance` bigint(20) NOT NULL,
  `balancing` bit(1) DEFAULT NULL,
  `calibration` bit(1) DEFAULT NULL,
  `parallelism` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id_maintenance`),
  CONSTRAINT `FKl6qdexteub4jxwi9402jhp26c` FOREIGN KEY (`id_maintenance`) REFERENCES `maintenance` (`id_maintenance`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tire_maintenance`
--

LOCK TABLES `tire_maintenance` WRITE;
/*!40000 ALTER TABLE `tire_maintenance` DISABLE KEYS */;
/*!40000 ALTER TABLE `tire_maintenance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type`
--

DROP TABLE IF EXISTS `type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type` (
  `id_type` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_type`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type`
--

LOCK TABLES `type` WRITE;
/*!40000 ALTER TABLE `type` DISABLE KEYS */;
/*!40000 ALTER TABLE `type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `typical_path`
--

DROP TABLE IF EXISTS `typical_path`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `typical_path` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `begin_path_time` datetime DEFAULT NULL,
  `device_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `typical_path`
--

LOCK TABLES `typical_path` WRITE;
/*!40000 ALTER TABLE `typical_path` DISABLE KEYS */;
/*!40000 ALTER TABLE `typical_path` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createdat` datetime DEFAULT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `enabled` bit(1) DEFAULT NULL,
  `lastpasswordresetdate` datetime DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_ob8kqyqqgmefl0aco34akdtpe` (`email`),
  UNIQUE KEY `UK_sb8bbouer5wak8vyiiy4pf2bx` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_authority`
--

DROP TABLE IF EXISTS `user_authority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_authority` (
  `user_id` bigint(20) NOT NULL,
  `authority_id` bigint(20) NOT NULL,
  KEY `FKgvxjs381k6f48d5d2yi11uh89` (`authority_id`),
  KEY `FKpqlsjpkybgos9w2svcri7j8xy` (`user_id`),
  CONSTRAINT `FKgvxjs381k6f48d5d2yi11uh89` FOREIGN KEY (`authority_id`) REFERENCES `authority` (`id`),
  CONSTRAINT `FKpqlsjpkybgos9w2svcri7j8xy` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_authority`
--

LOCK TABLES `user_authority` WRITE;
/*!40000 ALTER TABLE `user_authority` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_authority` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_group`
--

DROP TABLE IF EXISTS `user_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_group` (
  `user_id` bigint(20) NOT NULL,
  `group_id` bigint(20) NOT NULL,
  KEY `FKb0xhtx49263tfllv47gq517as` (`group_id`),
  KEY `FK1c1dsw3q36679vaiqwvtv36a6` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_group`
--

LOCK TABLES `user_group` WRITE;
/*!40000 ALTER TABLE `user_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_vehicule`
--

DROP TABLE IF EXISTS `user_vehicule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_vehicule` (
  `user_id` bigint(20) NOT NULL,
  `vehicule_id` bigint(20) NOT NULL,
  KEY `FK8lo1dg4cru47g3d6e3cn4bfuq` (`vehicule_id`),
  KEY `FKfti4gsuf6vcu63h35ay8xeslq` (`user_id`),
  CONSTRAINT `FK8lo1dg4cru47g3d6e3cn4bfuq` FOREIGN KEY (`vehicule_id`) REFERENCES `vehicule` (`vehicule_id`),
  CONSTRAINT `FKfti4gsuf6vcu63h35ay8xeslq` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_vehicule`
--

LOCK TABLES `user_vehicule` WRITE;
/*!40000 ALTER TABLE `user_vehicule` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_vehicule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `useralert`
--

DROP TABLE IF EXISTS `useralert`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `useralert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `device_id` bigint(20) DEFAULT NULL,
  `group_id` bigint(20) DEFAULT NULL,
  `name` enum('SPEED','INGNITION_V0','ZONE','POI','TOW','NO_POI','DRIVING_QUALITY','CHARGER','DOC') COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_to_realert` int(11) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `email_mode` tinyint(1) NOT NULL DEFAULT '0',
  `emails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `DEVICE_INDEX` (`device_id`),
  KEY `GROUP_INDEX` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `useralert`
--

LOCK TABLES `useralert` WRITE;
/*!40000 ALTER TABLE `useralert` DISABLE KEYS */;
/*!40000 ALTER TABLE `useralert` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicule`
--

DROP TABLE IF EXISTS `vehicule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehicule` (
  `vehicule_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mark` varchar(255) DEFAULT NULL,
  `matricule` varchar(50) NOT NULL,
  `path_gray_card` varchar(255) DEFAULT NULL,
  `alias` varchar(50) DEFAULT NULL,
  `emails` varchar(255) DEFAULT NULL,
  `max_speed` bigint(20) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  `circulation_at` datetime DEFAULT NULL,
  `last_odo_update` datetime DEFAULT NULL,
  `odo_offset` double DEFAULT NULL,
  `sub_mark` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`vehicule_id`),
  UNIQUE KEY `UK_b8fyikkqe8bflk5vh1r7mdlda` (`matricule`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicule`
--

LOCK TABLES `vehicule` WRITE;
/*!40000 ALTER TABLE `vehicule` DISABLE KEYS */;
INSERT INTO `vehicule` VALUES (28,'700351','700351',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(29,'700352','700352',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(30,'700353','700353',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(31,'700354','700354',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(32,'700355','700355',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(33,'700356','700356',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(34,'700357','700357',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(35,'700358','700358',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(36,'700359','700359',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(37,'700360','700360',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(38,'700361','700361',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(39,'700362','700362',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(40,'700363','700363',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(41,'700364','700364',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(42,'700365','700365',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(43,'700366','700366',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(44,'700367','700367',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(45,'700368','700368',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(46,'700369','700369',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `vehicule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicule_groupe`
--

DROP TABLE IF EXISTS `vehicule_groupe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehicule_groupe` (
  `groupe_id` bigint(20) NOT NULL,
  `vehicule_id` bigint(20) NOT NULL,
  PRIMARY KEY (`groupe_id`,`vehicule_id`),
  KEY `FKgvi1s0hdm04m77wxs0q0dg9sa` (`vehicule_id`),
  CONSTRAINT `FKgvi1s0hdm04m77wxs0q0dg9sa` FOREIGN KEY (`vehicule_id`) REFERENCES `vehicule` (`vehicule_id`),
  CONSTRAINT `FKhuni467k9bicyoty344j3tute` FOREIGN KEY (`groupe_id`) REFERENCES `groupe` (`groupe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicule_groupe`
--

LOCK TABLES `vehicule_groupe` WRITE;
/*!40000 ALTER TABLE `vehicule_groupe` DISABLE KEYS */;
INSERT INTO `vehicule_groupe` VALUES (15,28),(15,29),(15,30),(15,31),(15,32),(15,33),(15,34),(15,35),(15,36),(15,37),(15,38),(15,39),(15,40);
/*!40000 ALTER TABLE `vehicule_groupe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_setting`
--

DROP TABLE IF EXISTS `web_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_setting` (
  `id_web_setting` bigint(20) NOT NULL AUTO_INCREMENT,
  `name_web_setting` varchar(255) DEFAULT NULL,
  `device_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_web_setting`),
  KEY `FKnhhdjd587qk4k6aacrln9o4tb` (`device_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_setting`
--

LOCK TABLES `web_setting` WRITE;
/*!40000 ALTER TABLE `web_setting` DISABLE KEYS */;
/*!40000 ALTER TABLE `web_setting` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-08-17 12:38:52
