text: CREATE DATABASE  IF NOT EXISTS `Performance` /*!40100 DEFAULT CHARACTER SET latin1 */;
  USE `Performance`;
  -- MySQL dump 10.13  Distrib 5.5.41, for debian-linux-gnu (i686)
  --
  -- Host: 127.0.0.1    Database: Performance
  -- ------------------------------------------------------
  -- Server version	5.5.41-0ubuntu0.14.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 `Avg_Measures`
  --
  
  DROP TABLE IF EXISTS `Avg_Measures`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Avg_Measures` (
    `idCounter` int(11) NOT NULL AUTO_INCREMENT,
    `rsuid` int(11) NOT NULL,
    `Movement` varchar(45) NOT NULL,
    `Avg_TT` int(11) NOT NULL,
    `Avg_Delay` float NOT NULL,
    `Avg_Stops` float NOT NULL,
    `Avg_Throughput` int(11) NOT NULL,
    PRIMARY KEY (`idCounter`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Avg_Measures`
  --
  
  LOCK TABLES `Avg_Measures` WRITE;
  /*!40000 ALTER TABLE `Avg_Measures` DISABLE KEYS */;
  INSERT INTO `Avg_Measures` VALUES (1,301,'NB',45,5.75,0.36,10),(2,301,'NBRT',33,7.69,0.41,7),(3,301,'EBLT',67,2.48,0.11,11),(4,301,'EB',52,9.64,0.49,8),(5,301,'EBRT',49,10.36,1.01,4),(6,301,'SBLT',36,1.53,0.05,2),(7,301,'SB',56,15.68,1.13,3),(8,301,'SBRT',79,5.64,0.49,2),(9,301,'WBLT',48,9.53,0.88,3),(10,301,'WB',50,39.79,1.76,4),(11,301,'WBRT',54,16.87,1.07,2),(12,301,'NBLT',41,10.95,0.93,0);
  /*!40000 ALTER TABLE `Avg_Measures` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `Daily_Det`
  --
  
  DROP TABLE IF EXISTS `Daily_Det`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Daily_Det` (
    `idCounter` int(11) NOT NULL AUTO_INCREMENT,
    `idDetector` int(11) NOT NULL,
    `time_stamp` int(11) NOT NULL,
    `Volume` int(11) NOT NULL,
    `Occupancy` int(11) NOT NULL,
    PRIMARY KEY (`idCounter`)
  ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Daily_Det`
  --
  
  LOCK TABLES `Daily_Det` WRITE;
  /*!40000 ALTER TABLE `Daily_Det` DISABLE KEYS */;
  INSERT INTO `Daily_Det` VALUES (1,1,0,15,0),(2,1,1,10,0),(3,1,2,20,0),(4,1,3,2,0),(5,1,4,5,0),(6,1,5,10,0),(7,1,6,50,0),(8,1,7,85,0),(9,1,8,120,0),(10,1,9,160,0),(11,1,10,140,0),(12,1,11,100,0),(13,1,12,95,0),(14,1,13,85,0),(15,1,14,90,0),(16,1,15,85,0),(17,1,16,100,0),(18,1,17,145,0),(19,1,18,130,0),(20,1,19,105,0),(21,1,20,70,0),(22,1,21,50,0),(23,1,22,35,0),(24,1,23,20,0),(25,1,0,15,0);
  /*!40000 ALTER TABLE `Daily_Det` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `Detector`
  --
  
  DROP TABLE IF EXISTS `Detector`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Detector` (
    `idCounter` int(11) NOT NULL AUTO_INCREMENT,
    `idDetector` int(11) NOT NULL,
    `time_stamp` int(11) NOT NULL,
    `Volume` int(11) NOT NULL,
    `Occupancy` int(11) NOT NULL,
    PRIMARY KEY (`idCounter`)
  ) ENGINE=InnoDB AUTO_INCREMENT=497 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Detector`
  --
  
  LOCK TABLES `Detector` WRITE;
  /*!40000 ALTER TABLE `Detector` DISABLE KEYS */;
  INSERT INTO `Detector` VALUES (1,1,1425499830,1,3),(2,2,1425499830,2,2),(3,6,1425499830,2,2),(4,7,1425499830,2,3),(5,8,1425499830,2,3),(6,21,1425499830,6,14),(7,22,1425499830,2,3),(8,23,1425499830,1,2),(9,1,1425499890,4,6),(10,2,1425499890,4,5),(11,6,1425499890,4,5),(12,7,1425499890,4,6),(13,8,1425499890,4,6),(14,21,1425499890,8,17),(15,22,1425499890,4,6),(16,23,1425499890,3,5),(17,1,1425499950,2,3),(18,2,1425499950,2,2),(19,6,1425499950,2,2),(20,7,1425499950,2,3),(21,8,1425499950,2,3),(22,21,1425499950,6,14),(23,22,1425499950,2,3),(24,23,1425499950,2,3),(25,1,1425500011,1,2),(26,2,1425500011,4,5),(27,6,1425500011,4,5),(28,7,1425500011,4,6),(29,8,1425500011,4,6),(30,21,1425500011,8,17),(31,22,1425500011,4,6),(32,23,1425500011,4,6),(33,1,1425500071,3,5),(34,2,1425500071,2,3),(35,6,1425500071,2,2),(36,7,1425500071,2,2),(37,8,1425500071,2,3),(38,21,1425500071,2,3),(39,22,1425500071,6,14),(40,23,1425500071,2,3),(41,1,1425500132,2,3),(42,2,1425500132,1,2),(43,6,1425500132,4,5),(44,7,1425500132,4,5),(45,8,1425500132,4,6),(46,21,1425500132,4,6),(47,22,1425500132,8,17),(48,23,1425500132,4,6),(49,1,1425500192,2,3),(50,2,1425500192,2,2),(51,6,1425500192,2,2),(52,7,1425500192,2,3),(53,8,1425500192,2,3),(54,21,1425500192,6,14),(55,22,1425500192,2,3),(56,23,1425500192,1,2),(57,1,1425500252,2,6),(58,2,1425500252,4,5),(59,6,1425500252,4,5),(60,7,1425500252,4,6),(61,8,1425500252,4,6),(62,21,1425500252,8,17),(63,22,1425500252,4,6),(64,23,1425500252,3,5),(65,1,1425500312,2,3),(66,2,1425500312,2,2),(67,6,1425500312,2,2),(68,7,1425500312,2,3),(69,8,1425500312,2,3),(70,21,1425500312,6,14),(71,22,1425500312,2,3),(72,23,1425500312,2,3),(73,1,1425500372,1,2),(74,2,1425500372,4,5),(75,6,1425500372,4,5),(76,7,1425500372,4,6),(77,8,1425500372,4,6),(78,21,1425500372,8,17),(79,22,1425500372,4,6),(80,23,1425500372,4,6),(81,1,1425500432,3,5),(82,2,1425500432,2,3),(83,6,1425500432,2,2),(84,7,1425500432,2,2),(85,8,1425500432,2,3),(86,21,1425500432,2,3),(87,22,1425500432,6,14),(88,23,1425500432,2,3),(89,1,1425500492,2,3),(90,2,1425500492,1,2),(91,6,1425500492,4,5),(92,7,1425500492,4,5),(93,8,1425500492,4,6),(94,21,1425500492,4,6),(95,22,1425500492,8,17),(96,23,1425500492,4,6),(97,1,1425500552,2,3),(98,2,1425500552,2,2),(99,6,1425500552,2,2),(100,7,1425500552,2,3),(101,8,1425500552,2,3),(102,21,1425500552,6,14),(103,22,1425500552,2,3),(104,23,1425500552,1,2),(105,1,1425500612,4,6),(106,2,1425500612,4,5),(107,6,1425500612,4,5),(108,7,1425500612,4,6),(109,8,1425500612,4,6),(110,21,1425500612,8,17),(111,22,1425500612,4,6),(112,23,1425500612,3,5),(113,1,1425500672,2,3),(114,2,1425500672,2,2),(115,6,1425500672,2,2),(116,7,1425500672,2,3),(117,8,1425500672,2,3),(118,21,1425500672,6,14),(119,22,1425500672,2,3),(120,23,1425500672,2,3),(121,1,1425500732,1,2),(122,2,1425500732,4,5),(123,6,1425500732,4,5),(124,7,1425500732,4,6),(125,8,1425500732,4,6),(126,21,1425500732,8,17),(127,22,1425500732,4,6),(128,23,1425500732,4,6),(129,1,1425500792,3,5),(130,2,1425500792,2,3),(131,6,1425500792,2,2),(132,7,1425500792,2,2),(133,8,1425500792,2,3),(134,21,1425500792,2,3),(135,22,1425500792,6,14),(136,23,1425500792,2,3),(137,1,1425500852,1,3),(138,2,1425500852,1,2),(139,6,1425500852,4,5),(140,7,1425500852,4,5),(141,8,1425500852,4,6),(142,21,1425500852,4,6),(143,22,1425500852,8,17),(144,23,1425500852,4,6),(145,1,1425500912,2,3),(146,2,1425500912,2,2),(147,6,1425500912,2,2),(148,7,1425500912,2,3),(149,8,1425500912,2,3),(150,21,1425500912,6,14),(151,22,1425500912,2,3),(152,23,1425500912,1,2),(153,1,1425500972,5,6),(154,2,1425500972,4,5),(155,6,1425500972,4,5),(156,7,1425500972,4,6),(157,8,1425500972,4,6),(158,21,1425500972,8,17),(159,22,1425500972,4,6),(160,23,1425500972,3,5),(161,1,1425501032,2,3),(162,2,1425501032,2,2),(163,6,1425501032,2,2),(164,7,1425501032,2,3),(165,8,1425501032,2,3),(166,21,1425501032,6,14),(167,22,1425501032,2,3),(168,23,1425501032,2,3),(169,1,1425501092,1,2),(170,2,1425501092,4,5),(171,6,1425501092,4,5),(172,7,1425501092,4,6),(173,8,1425501092,4,6),(174,21,1425501092,8,17),(175,22,1425501092,4,6),(176,23,1425501092,4,6),(177,1,1425501152,3,5),(178,2,1425501152,2,3),(179,6,1425501152,2,2),(180,7,1425501152,2,2),(181,8,1425501152,2,3),(182,21,1425501152,2,3),(183,22,1425501152,6,14),(184,23,1425501152,2,3),(185,1,1425501212,2,3),(186,2,1425501212,1,2),(187,6,1425501212,4,5),(188,7,1425501212,4,5),(189,8,1425501212,4,6),(190,21,1425501212,4,6),(191,22,1425501212,8,17),(192,23,1425501212,4,6),(193,1,1425501272,2,3),(194,2,1425501272,2,2),(195,6,1425501272,2,2),(196,7,1425501272,2,3),(197,8,1425501272,2,3),(198,21,1425501272,6,14),(199,22,1425501272,2,3),(200,23,1425501272,1,2),(201,1,1425501332,4,6),(202,2,1425501332,4,5),(203,6,1425501332,4,5),(204,7,1425501332,4,6),(205,8,1425501332,4,6),(206,21,1425501332,8,17),(207,22,1425501332,4,6),(208,23,1425501332,3,5),(209,1,1425501392,2,3),(210,2,1425501392,2,2),(211,6,1425501392,2,2),(212,7,1425501392,2,3),(213,8,1425501392,2,3),(214,21,1425501392,6,14),(215,22,1425501392,2,3),(216,23,1425501392,2,3),(217,1,1425501452,1,2),(218,2,1425501452,4,5),(219,6,1425501452,4,5),(220,7,1425501452,4,6),(221,8,1425501452,4,6),(222,21,1425501452,8,17),(223,22,1425501452,4,6),(224,23,1425501452,4,6),(225,1,1425501512,3,5),(226,2,1425501512,2,3),(227,6,1425501512,2,2),(228,7,1425501512,2,2),(229,8,1425501512,2,3),(230,21,1425501512,2,3),(231,22,1425501512,6,14),(232,23,1425501512,2,3),(233,1,1425501572,2,3),(234,2,1425501572,1,2),(235,6,1425501572,4,5),(236,7,1425501572,4,5),(237,8,1425501572,4,6),(238,21,1425501572,4,6),(239,22,1425501572,8,17),(240,23,1425501572,4,6),(241,1,1425501632,3,3),(242,2,1425501632,2,2),(243,6,1425501632,2,2),(244,7,1425501632,2,3),(245,8,1425501632,2,3),(246,21,1425501632,6,14),(247,22,1425501632,2,3),(248,23,1425501632,1,2),(249,1,1425501692,4,6),(250,2,1425501692,4,5),(251,6,1425501692,4,5),(252,7,1425501692,4,6),(253,8,1425501692,4,6),(254,21,1425501692,8,17),(255,22,1425501692,4,6),(256,23,1425501692,3,5),(257,1,1425501752,2,3),(258,2,1425501752,2,2),(259,6,1425501752,2,2),(260,7,1425501752,2,3),(261,8,1425501752,2,3),(262,21,1425501752,6,14),(263,22,1425501752,2,3),(264,23,1425501752,2,3),(265,1,1425501812,1,2),(266,2,1425501812,4,5),(267,6,1425501812,4,5),(268,7,1425501812,4,6),(269,8,1425501812,4,6),(270,21,1425501812,8,17),(271,22,1425501812,4,6),(272,23,1425501812,4,6),(273,1,1425501872,3,5),(274,2,1425501872,2,3),(275,6,1425501872,2,2),(276,7,1425501872,2,2),(277,8,1425501872,2,3),(278,21,1425501872,2,3),(279,22,1425501872,6,14),(280,23,1425501872,2,3),(281,1,1425501932,2,3),(282,2,1425501932,1,2),(283,6,1425501932,4,5),(284,7,1425501932,4,5),(285,8,1425501932,4,6),(286,21,1425501932,4,6),(287,22,1425501932,8,17),(288,23,1425501932,4,6),(289,1,1425501992,2,3),(290,2,1425501992,2,2),(291,6,1425501992,2,2),(292,7,1425501992,2,3),(293,8,1425501992,2,3),(294,21,1425501992,6,14),(295,22,1425501992,2,3),(296,23,1425501992,1,2),(297,1,1425502052,4,6),(298,2,1425502052,4,5),(299,6,1425502052,4,5),(300,7,1425502052,4,6),(301,8,1425502052,4,6),(302,21,1425502052,8,17),(303,22,1425502052,4,6),(304,23,1425502052,3,5),(305,1,1425502112,2,3),(306,2,1425502112,2,2),(307,6,1425502112,2,2),(308,7,1425502112,2,3),(309,8,1425502112,2,3),(310,21,1425502112,6,14),(311,22,1425502112,2,3),(312,23,1425502112,2,3),(313,1,1425502172,5,2),(314,2,1425502172,4,5),(315,6,1425502172,4,5),(316,7,1425502172,4,6),(317,8,1425502172,4,6),(318,21,1425502172,8,17),(319,22,1425502172,4,6),(320,23,1425502172,4,6),(321,1,1425502232,3,5),(322,2,1425502232,2,3),(323,6,1425502232,2,2),(324,7,1425502232,2,2),(325,8,1425502232,2,3),(326,21,1425502232,2,3),(327,22,1425502232,6,14),(328,23,1425502232,2,3),(329,1,1425502292,2,3),(330,2,1425502292,1,2),(331,6,1425502292,4,5),(332,7,1425502292,4,5),(333,8,1425502292,4,6),(334,21,1425502292,4,6),(335,22,1425502292,8,17),(336,23,1425502292,4,6),(337,1,1425502352,2,3),(338,2,1425502352,2,2),(339,6,1425502352,2,2),(340,7,1425502352,2,3),(341,8,1425502352,2,3),(342,21,1425502352,6,14),(343,22,1425502352,2,3),(344,23,1425502352,1,2),(345,1,1425502412,4,6),(346,2,1425502412,4,5),(347,6,1425502412,4,5),(348,7,1425502412,4,6),(349,8,1425502412,4,6),(350,21,1425502412,8,17),(351,22,1425502412,4,6),(352,23,1425502412,3,5),(353,1,1425502472,2,3),(354,2,1425502472,2,2),(355,6,1425502472,2,2),(356,7,1425502472,2,3),(357,8,1425502472,2,3),(358,21,1425502472,6,14),(359,22,1425502472,2,3),(360,23,1425502472,2,3),(361,1,1425502532,1,2),(362,2,1425502532,4,5),(363,6,1425502532,4,5),(364,7,1425502532,4,6),(365,8,1425502532,4,6),(366,21,1425502532,8,17),(367,22,1425502532,4,6),(368,23,1425502532,4,6),(369,1,1425502592,1,5),(370,2,1425502592,2,3),(371,6,1425502592,2,2),(372,7,1425502592,2,2),(373,8,1425502592,2,3),(374,21,1425502592,2,3),(375,22,1425502592,6,14),(376,23,1425502592,2,3),(377,1,1425502652,2,3),(378,2,1425502652,1,2),(379,6,1425502652,4,5),(380,7,1425502652,4,5),(381,8,1425502652,4,6),(382,21,1425502652,4,6),(383,22,1425502652,8,17),(384,23,1425502652,4,6),(385,1,1425502712,2,3),(386,2,1425502712,2,2),(387,6,1425502712,2,2),(388,7,1425502712,2,3),(389,8,1425502712,2,3),(390,21,1425502712,6,14),(391,22,1425502712,2,3),(392,23,1425502712,1,2),(393,1,1425502772,1,6),(394,2,1425502772,4,5),(395,6,1425502772,4,5),(396,7,1425502772,4,6),(397,8,1425502772,4,6),(398,21,1425502772,8,17),(399,22,1425502772,4,6),(400,23,1425502772,3,5),(401,1,1425502832,2,3),(402,2,1425502832,2,2),(403,6,1425502832,2,2),(404,7,1425502832,2,3),(405,8,1425502832,2,3),(406,21,1425502832,6,14),(407,22,1425502832,2,3),(408,23,1425502832,2,3),(409,1,1425502892,1,2),(410,2,1425502892,4,5),(411,6,1425502892,4,5),(412,7,1425502892,4,6),(413,8,1425502892,4,6),(414,21,1425502892,8,17),(415,22,1425502892,4,6),(416,23,1425502892,4,6),(417,1,1425502952,3,5),(418,2,1425502952,2,3),(419,6,1425502952,2,2),(420,7,1425502952,2,2),(421,8,1425502952,2,3),(422,21,1425502952,2,3),(423,22,1425502952,6,14),(424,23,1425502952,2,3),(425,1,1425503012,1,3),(426,2,1425503012,1,2),(427,6,1425503012,4,5),(428,7,1425503012,4,5),(429,8,1425503012,4,6),(430,21,1425503012,4,6),(431,22,1425503012,8,17),(432,23,1425503012,4,6),(433,1,1425503072,2,3),(434,2,1425503072,2,2),(435,6,1425503072,2,2),(436,7,1425503072,2,3),(437,8,1425503072,2,3),(438,21,1425503072,6,14),(439,22,1425503072,2,3),(440,23,1425503072,1,2),(441,1,1425503132,4,6),(442,2,1425503132,4,5),(443,6,1425503132,4,5),(444,7,1425503132,4,6),(445,8,1425503132,4,6),(446,21,1425503132,8,17),(447,22,1425503132,4,6),(448,23,1425503132,3,5),(449,1,1425503192,2,3),(450,2,1425503192,2,2),(451,6,1425503192,2,2),(452,7,1425503192,2,3),(453,8,1425503192,2,3),(454,21,1425503192,6,14),(455,22,1425503192,2,3),(456,23,1425503192,2,3),(457,1,1425503252,1,2),(458,2,1425503252,4,5),(459,6,1425503252,4,5),(460,7,1425503252,4,6),(461,8,1425503252,4,6),(462,21,1425503252,8,17),(463,22,1425503252,4,6),(464,23,1425503252,4,6),(465,1,1425503312,3,5),(466,2,1425503312,2,3),(467,6,1425503312,2,2),(468,7,1425503312,2,2),(469,8,1425503312,2,3),(470,21,1425503312,2,3),(471,22,1425503312,6,14),(472,23,1425503312,2,3),(473,1,1425503372,2,3),(474,2,1425503372,1,2),(475,6,1425503372,4,5),(476,7,1425503372,4,5),(477,8,1425503372,4,6),(478,21,1425503372,4,6),(479,22,1425503372,8,17),(480,23,1425503372,4,6),(481,1,1425503432,1,2),(482,2,1425503432,4,5),(483,6,1425503432,4,5),(484,7,1425503432,4,6),(485,8,1425503432,4,6),(486,21,1425503432,8,17),(487,22,1425503432,4,6),(488,23,1425503432,4,6),(489,1,1425503492,3,5),(490,2,1425503492,2,3),(491,6,1425503492,2,2),(492,7,1425503492,2,2),(493,8,1425503492,2,3),(494,21,1425503492,2,3),(495,22,1425503492,6,14),(496,23,1425503492,2,3);
  /*!40000 ALTER TABLE `Detector` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `Measures`
  --
  
  DROP TABLE IF EXISTS `Measures`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Measures` (
    `idCounter` int(11) NOT NULL AUTO_INCREMENT,
    `idMeasures` int(11) NOT NULL,
    `vehid` int(11) NOT NULL,
    `TT` float NOT NULL,
    `Delay` float NOT NULL,
    `Stops` float NOT NULL,
    `Distance` float NOT NULL,
    PRIMARY KEY (`idCounter`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Measures`
  --
  
  LOCK TABLES `Measures` WRITE;
  /*!40000 ALTER TABLE `Measures` DISABLE KEYS */;
  INSERT INTO `Measures` VALUES (1,301,1233,30,5.36,0,225.5),(2,301,1234,41,16.79,1,280.18),(3,301,1235,97,28.14,2,218.64),(4,301,1236,25,0,0,275.97),(5,301,1237,47,22.49,1,232.88);
  /*!40000 ALTER TABLE `Measures` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `Vehicles`
  --
  
  DROP TABLE IF EXISTS `Vehicles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Vehicles` (
    `idVehicles` int(11) NOT NULL AUTO_INCREMENT,
    `speed` float NOT NULL,
    `approach` int(11) NOT NULL,
    `lat` double NOT NULL,
    `long` double NOT NULL,
    `heading` int(11) NOT NULL,
    PRIMARY KEY (`idVehicles`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Vehicles`
  --
  
  LOCK TABLES `Vehicles` WRITE;
  /*!40000 ALTER TABLE `Vehicles` DISABLE KEYS */;
  /*!40000 ALTER TABLE `Vehicles` 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 2015-04-28  5:37:14
  