-- MySQL dump 10.13 Distrib 5.7.19, for Win64 (x86_64) -- -- Host: localhost Database: car_fuel -- ------------------------------------------------------ -- Server version 5.7.19-log /*!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 `car_make` -- DROP TABLE IF EXISTS `car_make`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `car_make` ( `make_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `make` varchar(50) NOT NULL, PRIMARY KEY (`make_id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `car_make` -- LOCK TABLES `car_make` WRITE; /*!40000 ALTER TABLE `car_make` DISABLE KEYS */; INSERT INTO `car_make` VALUES (1,'ACURA'),(2,'ASTON MARTIN'),(3,'AUDI'),(4,'BENTLEY'),(5,'BMW'),(6,'BUGATTI'),(7,'BUICK'),(8,'CADILLAC'),(9,'CHEVROLET'),(10,'CHRYSLER'),(11,'DODGE'),(12,'FIAT'),(13,'FORD'),(14,'GMC'),(15,'HONDA'),(16,'HYUNDAI'),(17,'INFINITI'),(18,'JAGUAR'),(19,'JEEP'),(20,'KIA'),(21,'LAMBORGHINI'),(22,'LAND ROVER'),(23,'LEXUS'),(24,'LINCOLN'),(25,'MASERATI'),(26,'MAZDA'),(27,'MERCEDES-BENZ'),(28,'MINI'),(29,'MITSUBISHI'),(30,'NISSAN'),(31,'PORSCHE'),(32,'RAM'),(33,'ROLLS-ROYCE'),(34,'SCION'),(35,'SMART'),(36,'SUBARU'),(37,'SUZUKI'),(38,'TOYOTA'),(39,'VOLKSWAGEN'),(40,'VOLVO'); /*!40000 ALTER TABLE `car_make` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `car_vehicle_class` -- DROP TABLE IF EXISTS `car_vehicle_class`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `car_vehicle_class` ( `class_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `vehicle_class` varchar(200) NOT NULL, PRIMARY KEY (`class_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `car_vehicle_class` -- LOCK TABLES `car_vehicle_class` WRITE; /*!40000 ALTER TABLE `car_vehicle_class` DISABLE KEYS */; INSERT INTO `car_vehicle_class` VALUES (1,'SUV'),(2,'MID-SIZE'),(3,'COMPACT'),(4,'MINICOMPACT'),(5,'SUBCOMPACT'),(6,'TWO-SEATER'),(7,'STATION WAGON - SMALL'),(8,'FULL-SIZE'),(9,'PICKUP TRUCK - STANDARD'),(10,'PICKUP TRUCK - SMALL'),(11,'VAN - CARGO'),(12,'VAN - PASSENGER'),(13,'MINIVAN'),(14,'SPECIAL PURPOSE VEHICLE'),(15,'STATION WAGON - MID-SIZE'); /*!40000 ALTER TABLE `car_vehicle_class` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fuel_consumption` -- DROP TABLE IF EXISTS `fuel_consumption`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fuel_consumption` ( `fuel_consumption_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `make_id` int(11) unsigned NOT NULL, `class_id` int(11) unsigned NOT NULL, `fuel_consumption` double NOT NULL, PRIMARY KEY (`fuel_consumption_id`), KEY `make_id` (`make_id`), KEY `class_id_idx` (`class_id`), CONSTRAINT `class_id` FOREIGN KEY (`class_id`) REFERENCES `car_vehicle_class` (`class_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fuel_consumption_ibfk_1` FOREIGN KEY (`make_id`) REFERENCES `car_make` (`make_id`) ON DELETE NO ACTION ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1093 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fuel_consumption` -- LOCK TABLES `fuel_consumption` WRITE; /*!40000 ALTER TABLE `fuel_consumption` DISABLE KEYS */; INSERT INTO `fuel_consumption` VALUES (1,1,1,14.8),(2,1,1,13.2),(3,1,2,13.7),(4,1,2,11.8),(5,1,2,12.9),(6,1,2,13.4),(7,1,3,10.6),(8,1,3,11.3),(9,1,3,12.1),(10,1,1,14.3),(11,2,4,18),(12,2,4,20.8),(13,2,4,20),(14,2,4,21.1),(15,2,5,18.6),(16,2,6,21.1),(17,2,6,17),(18,2,6,18.1),(19,2,6,17.3),(20,2,4,18.7),(21,3,7,10.8),(22,3,7,11.8),(23,3,7,11),(24,3,7,7.9),(25,3,3,10.2),(26,3,7,11.4),(27,3,3,11.4),(28,3,3,10.9),(29,3,5,11.4),(30,3,5,11.4),(31,3,5,10.9),(32,3,2,12.8),(33,3,2,12.9),(34,3,2,13.5),(35,3,8,13.5),(36,3,8,17.3),(37,3,1,12),(38,3,1,13),(39,3,1,15.2),(40,3,1,13.8),(41,3,6,18.1),(42,3,6,21.1),(43,3,6,18.8),(44,3,6,21.1),(45,3,6,18.1),(46,3,6,21.1),(47,3,6,18.8),(48,3,6,21.1),(49,3,3,13.6),(50,3,3,13.7),(51,3,5,14.5),(52,3,5,14.4),(53,3,5,16.8),(54,3,5,10.4),(55,3,6,10.4),(56,3,5,13.8),(57,3,5,11.5),(58,3,6,11.5),(59,4,2,21.1),(60,4,3,20.7),(61,4,5,21.1),(62,4,6,20.2),(63,4,6,20.7),(64,4,2,22.4),(65,5,5,12.9),(66,5,5,12.2),(67,5,5,12.8),(68,5,5,12.2),(69,5,5,13.2),(70,5,5,12.7),(71,5,5,13.1),(72,5,5,11.8),(73,5,5,12.9),(74,5,5,13.7),(75,5,5,12.8),(76,5,5,12.2),(77,5,5,13.4),(78,5,5,13.9),(79,5,7,13.4),(80,5,7,13.9),(81,5,5,13),(82,5,5,12.7),(83,5,5,13),(84,5,5,12.7),(85,5,5,12.8),(86,5,5,12.5),(87,5,5,13.8),(88,5,5,13.4),(89,5,5,13.8),(90,5,5,13.4),(91,5,2,9.9),(92,5,2,10.1),(93,5,2,11.1),(94,5,8,13),(95,5,2,15.1),(96,5,8,15.5),(97,5,3,15.2),(98,5,3,16.1),(99,5,3,15.5),(100,5,3,15.1),(101,5,8,17.1),(102,5,8,17.1),(103,5,8,18.5),(104,5,8,13.7),(105,5,8,17.3),(106,5,5,17.3),(107,5,5,17.4),(108,5,5,17.1),(109,5,5,16.9),(110,5,1,11.6),(111,5,1,12.3),(112,5,1,12.6),(113,5,1,18.7),(114,5,1,12.2),(115,5,1,14.7),(116,5,1,17),(117,5,1,18.7),(118,5,1,14.7),(119,5,1,17),(120,5,6,9.5),(121,5,6,10.6),(122,5,6,13.8),(123,5,6,12.7),(124,5,6,13.8),(125,6,6,28.5),(126,7,1,14.3),(127,7,1,14.7),(128,7,2,13.6),(129,7,2,18.5),(130,7,2,14.3),(131,7,2,19.3),(132,7,2,9.6),(133,7,2,12.8),(134,7,2,17.3),(135,7,2,11.9),(136,7,2,15.7),(137,7,2,12.1),(138,7,2,15.9),(139,7,2,9.6),(140,7,2,12.5),(141,7,2,12.6),(142,7,3,11.3),(143,7,3,15.6),(144,8,2,12.8),(145,8,2,14.7),(146,8,2,12.9),(147,8,2,13.4),(148,8,2,13.3),(149,8,7,12.8),(150,8,7,13.2),(151,8,7,13.4),(152,8,7,13.3),(153,8,2,19.6),(154,8,2,16.6),(155,8,7,19.6),(156,8,7,16.6),(157,8,1,17),(158,8,1,23.3),(159,8,1,18.8),(160,8,1,25.8),(161,8,1,11.8),(162,8,1,14.3),(163,8,1,18.9),(164,8,1,14.8),(165,8,1,19.7),(166,9,9,16),(167,9,9,21.5),(168,9,9,16.1),(169,9,9,21.5),(170,9,3,12.9),(171,9,3,13.9),(172,9,3,12.7),(173,9,3,15.1),(174,9,3,15),(175,9,3,19.6),(176,9,3,16.6),(177,9,10,12.8),(178,9,10,12.9),(179,9,10,14),(180,9,10,16.1),(181,9,10,13.5),(182,9,10,13.2),(183,9,10,14.5),(184,9,10,16.9),(185,9,10,15.4),(186,9,10,14.9),(187,9,10,12.8),(188,9,10,12.9),(189,9,10,14.2),(190,9,10,16.1),(191,9,10,14.9),(192,9,10,16.9),(193,9,6,16),(194,9,6,14.5),(195,9,6,16),(196,9,6,17.1),(197,9,2,9.1),(198,9,2,9.1),(199,9,2,10.5),(200,9,2,9.5),(201,9,2,8.9),(202,9,2,8.4),(203,9,1,10.5),(204,9,1,15.2),(205,9,1,13.9),(206,9,1,18.8),(207,9,1,11.5),(208,9,1,16),(209,9,1,14.5),(210,9,1,19.6),(211,9,11,15.7),(212,9,11,18),(213,9,11,23.5),(214,9,11,18.3),(215,9,11,25.3),(216,9,11,18.6),(217,9,11,23.9),(218,9,11,18.3),(219,9,11,25.3),(220,9,12,18.6),(221,9,12,23.9),(222,9,12,18.3),(223,9,12,25.3),(224,9,12,21.1),(225,9,12,28.3),(226,9,12,21.9),(227,9,12,30),(228,9,12,21.1),(229,9,12,28.3),(230,9,12,22.3),(231,9,12,30.4),(232,9,8,13.2),(233,9,8,17.2),(234,9,2,10.8),(235,9,2,15.7),(236,9,2,13.9),(237,9,1,12),(238,9,1,11.5),(239,9,9,15.7),(240,9,9,16.9),(241,9,9,22.3),(242,9,9,16),(243,9,9,21.5),(244,9,9,18.8),(245,9,9,25.5),(246,9,9,16.7),(247,9,9,17.7),(248,9,9,23.3),(249,9,9,16),(250,9,9,21.5),(251,9,9,19.6),(252,9,9,26.6),(253,9,9,11.5),(254,9,9,11.6),(255,9,9,15.3),(256,9,9,20.7),(257,9,3,8.5),(258,9,3,9.6),(259,9,3,8.9),(260,9,5,8.5),(261,9,5,9.6),(262,9,5,8.9),(263,9,1,16),(264,9,1,21.5),(265,9,1,16.1),(266,9,1,21.5),(267,9,1,22.8),(268,9,1,22.7),(269,9,1,16),(270,9,1,21.5),(271,9,1,16.1),(272,9,1,21.5),(273,9,1,11.5),(274,9,1,11.6),(275,9,1,14.3),(276,9,1,14.7),(277,10,2,11.3),(278,10,2,11.9),(279,10,8,12.3),(280,10,8,13.2),(281,10,2,11.7),(282,10,2,13),(283,10,2,12.5),(284,10,2,17),(285,10,2,12.5),(286,10,2,17),(287,10,8,12.9),(288,10,8,12.9),(289,10,8,17.3),(290,10,8,13.2),(291,10,8,18.3),(292,10,8,12.3),(293,10,8,16.8),(294,10,8,16.7),(295,10,8,15.1),(296,10,8,16.1),(297,10,13,13.7),(298,10,13,19.1),(299,11,2,11.3),(300,11,2,11.9),(301,11,2,12.5),(302,11,2,17),(303,11,2,10.3),(304,11,2,9.8),(305,11,2,10.9),(306,11,3,13.2),(307,11,3,15.6),(308,11,3,15.1),(309,11,3,16.8),(310,11,3,16.7),(311,11,8,12.3),(312,11,8,13.2),(313,11,8,15.1),(314,11,8,12.9),(315,11,8,16.1),(316,11,8,12.9),(317,11,8,17.3),(318,11,8,13.2),(319,11,8,18.3),(320,11,8,12.3),(321,11,8,16.8),(322,11,8,16.7),(323,11,1,18.4),(324,11,1,14.6),(325,11,1,19.1),(326,11,13,13.7),(327,11,13,19.1),(328,11,1,12.2),(329,11,1,14.6),(330,11,1,14.2),(331,11,1,18.8),(332,12,4,8.6),(333,12,4,7.9),(334,12,4,8.3),(335,13,11,17.9),(336,13,11,24.5),(337,13,11,19.3),(338,13,11,24.9),(339,13,12,18.6),(340,13,12,25.5),(341,13,12,19.9),(342,13,12,25.7),(343,13,12,24.2),(344,13,12,20.6),(345,13,12,26.7),(346,13,1,11.3),(347,13,1,12.6),(348,13,1,13.3),(349,13,1,13.7),(350,13,1,11.4),(351,13,1,10.4),(352,13,1,11.6),(353,13,1,13),(354,13,1,18),(355,13,1,12.3),(356,13,1,16.7),(357,13,1,6.9),(358,13,1,7.8),(359,13,1,18.2),(360,13,1,24.4),(361,13,1,11.8),(362,13,1,13.2),(363,13,1,14),(364,13,9,14.5),(365,13,9,14.5),(366,13,9,18.7),(367,13,9,15.6),(368,13,9,15.6),(369,13,9,20.4),(370,13,9,14.3),(371,13,9,19.3),(372,13,9,14.3),(373,13,9,19.3),(374,13,9,15.6),(375,13,9,20.8),(376,13,9,15.6),(377,13,9,20.8),(378,13,9,15),(379,13,9,20.3),(380,13,9,15),(381,13,9,20.3),(382,13,9,16.6),(383,13,9,22.1),(384,13,9,16.7),(385,13,9,22.1),(386,13,9,20.4),(387,13,5,8.1),(388,13,5,8.1),(389,13,5,8),(390,13,1,14.2),(391,13,1,14.8),(392,13,1,15),(393,13,3,8.5),(394,13,3,8.6),(395,13,3,9.1),(396,13,3,8.4),(397,13,2,10.3),(398,13,2,10.9),(399,13,2,10.8),(400,13,2,13.8),(401,13,2,12),(402,13,2,16.6),(403,13,2,13.4),(404,13,2,18.2),(405,13,2,5.7),(406,13,2,10.9),(407,13,5,12.5),(408,13,5,13.1),(409,13,5,13.2),(410,13,5,13.7),(411,13,5,16.2),(412,13,5,13.4),(413,13,8,13),(414,13,8,13.5),(415,13,8,13.7),(416,13,8,13.9),(417,13,14,11.3),(418,13,14,11),(419,14,1,14.3),(420,14,1,14.7),(421,14,10,12.8),(422,14,10,12.9),(423,14,10,14),(424,14,10,16.1),(425,14,10,13.5),(426,14,10,13.2),(427,14,10,14.5),(428,14,10,16.9),(429,14,10,15.4),(430,14,10,14.9),(431,14,10,12.8),(432,14,10,12.9),(433,14,10,14.2),(434,14,10,16.1),(435,14,10,14.9),(436,14,10,16.9),(437,14,11,15.7),(438,14,11,18),(439,14,11,23.5),(440,14,11,18.3),(441,14,11,25.3),(442,14,11,18.6),(443,14,11,23.9),(444,14,11,18.3),(445,14,11,25.3),(446,14,12,18.6),(447,14,12,23.9),(448,14,12,18.3),(449,14,12,25.3),(450,14,12,21.1),(451,14,12,28.3),(452,14,12,21.9),(453,14,12,30),(454,14,12,21.1),(455,14,12,28.3),(456,14,12,22.3),(457,14,12,30.4),(458,14,9,15.7),(459,14,9,16.9),(460,14,9,22.3),(461,14,9,16),(462,14,9,21.5),(463,14,9,18.8),(464,14,9,25.5),(465,14,9,16.7),(466,14,9,17.7),(467,14,9,23.3),(468,14,9,16),(469,14,9,21.5),(470,14,9,19.6),(471,14,9,26.6),(472,14,9,19.3),(473,14,9,26.3),(474,14,9,11.5),(475,14,9,11.6),(476,14,9,15.3),(477,14,9,20.7),(478,14,1,10.5),(479,14,1,15.2),(480,14,1,13.9),(481,14,1,18.8),(482,14,1,11.5),(483,14,1,16),(484,14,1,14.5),(485,14,1,19.6),(486,14,1,16),(487,14,1,21.5),(488,14,1,16.1),(489,14,1,21.5),(490,14,1,17),(491,14,1,23.3),(492,14,1,11.8),(493,14,1,11.5),(494,14,1,11.6),(495,14,1,16),(496,14,1,21.5),(497,14,1,16.1),(498,14,1,21.5),(499,14,1,22.8),(500,14,1,18.8),(501,14,1,25.8),(502,14,1,22.7),(503,15,3,10.5),(504,15,3,10.3),(505,15,3,12.1),(506,15,3,13.4),(507,15,8,10.3),(508,15,8,10.1),(509,15,8,11.7),(510,15,1,13.3),(511,15,3,8.4),(512,15,3,8.4),(513,15,3,11.4),(514,15,3,5.4),(515,15,1,10.3),(516,15,1,10.5),(517,15,6,6.7),(518,15,6,7.7),(519,15,7,8.3),(520,15,7,8.3),(521,15,3,5.8),(522,15,13,13.2),(523,15,13,12.3),(524,15,1,13.3),(525,15,1,13.8),(526,15,9,15.2),(527,16,3,8.3),(528,16,3,8.3),(529,16,2,8.4),(530,16,2,8.3),(531,16,7,10),(532,16,7,10.2),(533,16,8,15.3),(534,16,8,12.9),(535,16,5,11.9),(536,16,5,11.4),(537,16,5,13.7),(538,16,5,13.5),(539,16,8,15.1),(540,16,1,11.8),(541,16,1,12.5),(542,16,1,11.6),(543,16,1,12),(544,16,1,12),(545,16,8,10.5),(546,16,8,10),(547,16,8,10),(548,16,2,6.8),(549,16,1,10.6),(550,16,1,11.8),(551,16,1,11.1),(552,16,1,11.6),(553,16,3,8.5),(554,16,3,8.7),(555,16,1,14.3),(556,16,1,14.8),(557,17,7,13.8),(558,17,1,15),(559,17,1,16.3),(560,17,2,11.7),(561,17,2,12),(562,17,2,13.8),(563,17,5,13.4),(564,17,5,14.5),(565,17,5,12.5),(566,17,5,13.8),(567,17,2,13.2),(568,17,5,13.2),(569,17,2,8.7),(570,17,2,13.1),(571,17,2,13.5),(572,17,2,15.2),(573,17,2,15),(574,17,1,17.4),(575,18,2,14.7),(576,18,2,15.7),(577,18,8,14.7),(578,18,8,15.7),(579,18,8,15.7),(580,18,8,15.4),(581,18,8,15.7),(582,18,8,15.7),(583,18,4,15.1),(584,18,4,14.9),(585,18,4,15.7),(586,18,4,15.7),(587,18,4,15.7),(588,19,1,10.3),(589,19,1,10.4),(590,19,1,11),(591,19,1,10.3),(592,19,1,11.3),(593,19,1,10.5),(594,19,1,18.7),(595,19,1,14.6),(596,19,1,19.1),(597,19,1,18.9),(598,19,1,15.6),(599,19,1,10.3),(600,19,1,10.4),(601,19,1,11),(602,19,1,10.3),(603,19,1,11.3),(604,19,1,10.5),(605,19,1,14.2),(606,19,1,14.3),(607,19,1,14.8),(608,19,1,15),(609,20,2,9.3),(610,20,2,9.4),(611,20,2,10.3),(612,20,2,10.5),(613,20,3,9.3),(614,20,3,9.6),(615,20,3,10.3),(616,20,3,10.5),(617,20,2,10.5),(618,20,2,9.9),(619,20,2,10),(620,20,2,6.9),(621,20,3,8.3),(622,20,3,8.1),(623,20,15,12),(624,20,15,13),(625,20,13,13),(626,20,1,11.2),(627,20,1,12),(628,20,1,11.7),(629,20,1,11.7),(630,20,1,13),(631,20,7,9.4),(632,20,7,9.4),(633,20,7,10.1),(634,20,7,9.8),(635,20,7,8.9),(636,20,1,11.1),(637,20,1,11.7),(638,20,1,11.7),(639,20,1,11.6),(640,21,6,23.1),(641,21,6,23.1),(642,21,6,18),(643,21,6,20.6),(644,21,6,18.1),(645,21,6,22.1),(646,22,1,15.7),(647,22,1,18.9),(648,22,1,12.3),(649,22,1,19.1),(650,22,1,18.7),(651,22,1,20),(652,22,1,20.3),(653,23,3,5.5),(654,23,2,12.3),(655,23,1,15.7),(656,23,3,6.7),(657,23,5,10.9),(658,23,5,12.7),(659,23,5,11.9),(660,23,5,10.9),(661,23,5,12.7),(662,23,5,12.1),(663,23,5,12.8),(664,23,5,12.1),(665,23,5,14.6),(666,23,6,21.9),(667,23,2,14.5),(668,23,2,15.1),(669,23,2,15.1),(670,23,2,12),(671,23,1,13.3),(672,23,1,7.9),(673,24,8,13.7),(674,24,8,13.9),(675,24,8,14.4),(676,24,1,15),(677,24,1,14.3),(678,24,1,13.7),(679,24,2,13.5),(680,24,2,13.8),(681,24,2,5.7),(682,24,1,18.2),(683,24,1,24.4),(684,25,5,18.1),(685,25,5,18.1),(686,25,8,19.9),(687,26,1,14.3),(688,26,1,14.4),(689,26,3,8.3),(690,26,3,8),(691,26,3,10),(692,26,3,9.4),(693,26,3,10.5),(694,26,3,11.6),(695,26,3,8.3),(696,26,3,8.9),(697,26,2,8.3),(698,26,2,8.8),(699,26,13,10.9),(700,26,13,11.1),(701,26,2,10.8),(702,26,2,11.2),(703,26,2,13.4),(704,26,2,13),(705,26,6,11.5),(706,26,6,10.5),(707,26,6,11.1),(708,27,3,11),(709,27,3,13.9),(710,27,5,11.1),(711,27,3,13.3),(712,27,3,13.3),(713,27,3,18.1),(714,27,3,12.2),(715,27,3,12.1),(716,27,5,12.2),(717,27,5,12.3),(718,27,3,17.8),(719,27,5,17.9),(720,27,3,15.4),(721,27,3,20),(722,27,3,15.4),(723,27,3,19.3),(724,27,3,14.3),(725,27,3,15.2),(726,27,2,12.6),(727,27,2,12.5),(728,27,5,12.7),(729,27,15,12.7),(730,27,2,10.8),(731,27,5,12.8),(732,27,5,12.5),(733,27,2,14.5),(734,27,5,13.7),(735,27,5,13.5),(736,27,2,15.2),(737,27,15,15.4),(738,27,1,20.4),(739,27,1,14.3),(740,27,1,14.8),(741,27,1,14.6),(742,27,1,13.8),(743,27,1,11.9),(744,27,1,16.2),(745,27,1,17.3),(746,27,8,23.2),(747,27,8,22.8),(748,27,8,23.2),(749,27,8,22.8),(750,27,1,14.7),(751,27,1,13.2),(752,27,8,11.6),(753,27,8,12.7),(754,27,8,15.4),(755,27,8,15.4),(756,27,8,20.3),(757,27,8,15.4),(758,27,8,19.3),(759,27,6,17.3),(760,27,6,19.8),(761,27,6,10.4),(762,27,6,10.3),(763,27,6,11.9),(764,27,6,12.3),(765,27,6,17.3),(766,27,6,17.3),(767,28,4,8.5),(768,28,4,8),(769,28,5,8.8),(770,28,5,8.6),(771,28,4,8.8),(772,28,4,8.6),(773,28,3,9.4),(774,28,3,8.6),(775,28,6,8.5),(776,28,6,8),(777,28,6,8.8),(778,28,6,8.6),(779,28,4,9.2),(780,28,4,8.8),(781,28,5,9.2),(782,28,5,8.8),(783,28,4,9.2),(784,28,4,8.8),(785,28,3,9.4),(786,28,3,8.9),(787,28,3,10),(788,28,3,9.3),(789,28,6,9.2),(790,28,6,8.8),(791,28,6,9.2),(792,28,6,8.8),(793,28,4,9.5),(794,28,5,9.5),(795,28,4,9.5),(796,28,6,9.5),(797,28,6,9.5),(798,29,5,11.5),(799,29,5,12),(800,29,5,14.2),(801,29,5,14.7),(802,29,4,11.6),(803,29,4,12),(804,29,4,14.2),(805,29,4,14.7),(806,29,3,13.4),(807,29,3,9.2),(808,29,3,9.7),(809,29,3,10.4),(810,29,3,14.2),(811,29,3,13.9),(812,29,7,9.6),(813,29,7,9.7),(814,29,1,10.3),(815,29,1,10.4),(816,29,1,12.5),(817,29,1,9.9),(818,29,1,10),(819,29,1,9.9),(820,30,6,12.6),(821,30,6,13.3),(822,30,6,13.2),(823,30,6,13.4),(824,30,2,10),(825,30,2,10.1),(826,30,2,11.8),(827,30,5,10.2),(828,30,5,10.3),(829,30,5,11.6),(830,30,5,12.9),(831,30,1,19.1),(832,30,7,8.7),(833,30,7,9.4),(834,30,10,13.9),(835,30,10,12.1),(836,30,10,15.9),(837,30,10,16.6),(838,30,10,15.4),(839,30,5,14.6),(840,30,7,8.7),(841,30,7,9.5),(842,30,7,9.3),(843,30,2,12.3),(844,30,1,13.2),(845,30,1,16.6),(846,30,13,12.6),(847,30,1,10.3),(848,30,1,11),(849,30,2,8.8),(850,30,2,9.8),(851,30,2,10),(852,30,2,11.2),(853,30,9,17.9),(854,30,9,19.6),(855,30,3,7.9),(856,30,3,8.7),(857,30,3,9.8),(858,30,3,8.4),(859,30,3,9.2),(860,30,1,16.2),(861,30,1,15.3),(862,31,4,12.6),(863,31,4,12.8),(864,31,4,12.9),(865,31,4,12.9),(866,31,4,13),(867,31,4,12.9),(868,31,4,12.9),(869,31,4,13.1),(870,31,4,12.8),(871,31,4,13.4),(872,31,4,12.6),(873,31,4,12.8),(874,31,4,12.8),(875,31,4,12.8),(876,31,4,12.8),(877,31,4,12.8),(878,31,4,12.6),(879,31,4,13.1),(880,31,4,12.7),(881,31,4,13),(882,31,4,12.6),(883,31,4,13.1),(884,31,4,12.9),(885,31,4,13.1),(886,31,4,12.8),(887,31,4,13.4),(888,31,4,12.7),(889,31,4,13),(890,31,4,13),(891,31,4,12.9),(892,31,4,12.8),(893,31,4,13.4),(894,31,4,14.3),(895,31,4,14.3),(896,31,4,14.8),(897,31,4,14.7),(898,31,4,14.3),(899,31,4,14.8),(900,31,4,14.3),(901,31,4,14.8),(902,31,6,11.6),(903,31,6,12.7),(904,31,6,12),(905,31,6,12.6),(906,31,6,12),(907,31,6,12.6),(908,31,1,14.5),(909,31,1,15.7),(910,31,1,15),(911,31,1,15),(912,31,1,11.8),(913,31,1,16),(914,31,6,11.6),(915,31,6,12.7),(916,31,6,11.8),(917,31,6,12.2),(918,31,6,12),(919,31,6,12.6),(920,31,6,12),(921,31,6,12.6),(922,31,4,11.5),(923,31,4,12.5),(924,31,4,11.6),(925,31,4,12.3),(926,31,4,12),(927,31,4,12.6),(928,31,4,12.3),(929,31,4,12.7),(930,31,8,13.1),(931,31,8,13.3),(932,31,8,14.5),(933,31,8,14.5),(934,31,8,9.9),(935,31,8,15.7),(936,31,8,15.7),(937,32,9,16.7),(938,32,9,17.1),(939,32,9,17.6),(940,32,9,16.7),(941,32,9,24.1),(942,32,9,17),(943,32,9,24.1),(944,32,13,13.7),(945,32,13,19.1),(946,33,8,18),(947,33,8,18),(948,33,8,20.6),(949,33,3,20.6),(950,33,3,20.6),(951,33,8,20.6),(952,34,4,6.6),(953,34,3,10.2),(954,34,3,10.5),(955,34,7,10.9),(956,34,7,10.9),(957,34,5,8.8),(958,34,5,8.6),(959,35,6,6.9),(960,35,6,6.9),(961,36,1,12.5),(962,36,1,11.3),(963,36,1,11.3),(964,36,3,8.7),(965,36,7,8.7),(966,36,3,9.6),(967,36,7,9.6),(968,36,2,10.4),(969,36,2,13),(970,36,2,12),(971,36,2,13.3),(972,36,1,10.9),(973,36,1,12),(974,36,1,13.3),(975,36,1,14.7),(976,36,3,12.6),(977,36,7,12.6),(978,36,3,14.2),(979,36,7,14.2),(980,37,1,12.7),(981,37,3,10.6),(982,37,3,10.6),(983,37,7,10.3),(984,37,7,10.6),(985,37,7,9.5),(986,37,7,10.4),(987,37,7,10.1),(988,37,3,9.3),(989,37,3,10.3),(990,37,3,10.2),(991,37,3,10.4),(992,38,1,14.2),(993,38,8,12.1),(994,38,2,9.5),(995,38,2,11.1),(996,38,2,5.5),(997,38,2,5.8),(998,38,3,9.1),(999,38,3,8.6),(1000,38,3,10.8),(1001,38,3,10.8),(1002,38,7,9.4),(1003,38,7,8.9),(1004,38,7,11.6),(1005,38,7,11.2),(1006,38,7,10.9),(1007,38,1,13.9),(1008,38,1,15.6),(1009,38,1,11.8),(1010,38,1,14.2),(1011,38,1,7.8),(1012,38,2,4.7),(1013,38,3,4.5),(1014,38,15,5.3),(1015,38,1,10.9),(1016,38,1,12.1),(1017,38,1,11.1),(1018,38,1,12.3),(1019,38,1,17.3),(1020,38,1,19),(1021,38,13,11.8),(1022,38,13,12.8),(1023,38,13,13.8),(1024,38,10,12.3),(1025,38,10,11.4),(1026,38,10,13),(1027,38,10,13),(1028,38,10,14.7),(1029,38,10,15.3),(1030,38,9,15.9),(1031,38,9,17.6),(1032,38,9,16.7),(1033,38,9,18.4),(1034,38,1,11.4),(1035,38,1,12.6),(1036,38,1,11.6),(1037,38,1,12.9),(1038,38,3,8),(1039,38,3,7.8),(1040,39,5,11.3),(1041,39,5,11.7),(1042,39,5,10.9),(1043,39,5,11.3),(1044,39,3,11),(1045,39,3,11.5),(1046,39,3,14.3),(1047,39,5,10.9),(1048,39,3,10.4),(1049,39,3,11.3),(1050,39,3,12.3),(1051,39,3,7.9),(1052,39,3,7.9),(1053,39,7,10.4),(1054,39,7,11.3),(1055,39,7,8.2),(1056,39,7,7.9),(1057,39,3,10),(1058,39,3,11.3),(1059,39,3,10.1),(1060,39,3,10.6),(1061,39,3,10.4),(1062,39,3,11.2),(1063,39,3,10.4),(1064,39,3,11.3),(1065,39,3,7.9),(1066,39,3,7.9),(1067,39,2,11),(1068,39,2,11.5),(1069,39,2,12.3),(1070,39,2,8.1),(1071,39,2,8),(1072,39,13,13.7),(1073,39,1,11.1),(1074,39,1,13.5),(1075,39,1,11.2),(1076,39,1,13.8),(1077,39,1,12.7),(1078,40,3,11.5),(1079,40,3,11.6),(1080,40,5,13.3),(1081,40,3,11.9),(1082,40,3,12.8),(1083,40,2,11.8),(1084,40,2,12.8),(1085,40,1,12.7),(1086,40,1,13.1),(1087,40,1,13.6),(1088,40,1,12.7),(1089,40,1,13.1),(1090,40,1,13.6),(1091,40,1,14.5),(1092,40,1,14.8); /*!40000 ALTER TABLE `fuel_consumption` 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 2019-04-13 13:22:24