CREATE DATABASE mileage_tracker;
USE mileage_tracker;

CREATE TABLE mileage_entries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    driver_name VARCHAR(100) NOT NULL,
    vehicle_reg VARCHAR(20) NOT NULL,
    start_time DATETIME NOT NULL,
    finish_time DATETIME NOT NULL,
    start_location VARCHAR(255) NOT NULL,
    finish_location VARCHAR(255) NOT NULL,
    total_mileage INT NOT NULL,
    total_travel_time TIME NOT NULL
);
