CREATE TABLE  `cdsforward`.`filtered_gps` (
  `vehicleNumber` INT(11) NOT NULL,
  `dateTime` datetime NOT NULL COMMENT 'Date and Time of record sent',
  `latitude` DOUBLE NOT NULL COMMENT 'Latitude of record sent',
  `longitude` DOUBLE NOT NULL COMMENT 'Longitude of record sent',
  `speed` INT(11) NOT NULL COMMENT 'Vehicle speed of record sent',
  `azimuth` INT(11) NOT NULL COMMENT 'Vehicle azimuth in degrees',
  `run` INT(11) NOT NULL COMMENT 'Vehicle run of record sent',
  KEY `vehicleNumber_dateTime_index` (`vehicleNumber`,`dateTime`),
  KEY `fk_gps_vehicles1` (`vehicleNumber`),
  CONSTRAINT `fk_gps_vehicles10` FOREIGN KEY (`vehicleNumber`) REFERENCES `vehicles` (`vehicleNumber`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8