mysql> show create table VEHICLE;
+---------+----------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------+
| Table   | Create Table
                                                                                                        |
+---------+----------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------+
| VEHICLE | CREATE TABLE `vehicle` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `VERSION` bigint(20) DEFAULT NULL,
  `CODE` varchar(64) NOT NULL,
  `TRAVELLED_DISTANCE` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `CODE` (`CODE`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 |
+---------+----------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table LOCATION;
+----------+---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
| Table    | Create Table


+----------+---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
| LOCATION | CREATE TABLE `location` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `VERSION` bigint(20) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `LATITUDE` double DEFAULT NULL,
  `LONGITUDE` double DEFAULT NULL,
  `MOVEMENT_STATUS` varchar(255) NOT NULL,
  `PLACE` longtext CHARACTER SET utf8,
  `SPEED` int(11) DEFAULT NULL,
  `TRAVELLED_DISTANCE` bigint(20) DEFAULT NULL,
  `VEHICLE_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `CREATIONDATE` (`CREATION_DATE`),
  KEY `VILID` (`CREATION_DATE`,`VEHICLE_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1736809 DEFAULT CHARSET=latin1 |
+----------+---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)