Vehicles Table II

CREATE DATABASE `trashfire` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `make` char(45) DEFAULT NULL,
  `model` char(45) DEFAULT NULL,
  `registration` char(12) DEFAULT NULL,
  `price_average` int(11) DEFAULT NULL COMMENT 'This is the price expected to be paid for this vehicle in average condition.',
  `price_forecourt` int(11) DEFAULT NULL COMMENT 'This is the price expected to be paid for this vehicle on the garage forecourt.',
  `mileage` int(11) DEFAULT NULL,
  `fuel_type` char(45) DEFAULT NULL,
  `colour` char(45) DEFAULT NULL,
  `mot_expiry_date` date DEFAULT NULL,
  `insurance_expiry_date` date DEFAULT NULL,
  `vin` char(17) DEFAULT NULL,
  `arrival_time` datetime DEFAULT NULL,
  `departure_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8mb4;