ALTER TABLE vehicle_trips
    ADD COLUMN driver_id INTEGER,
    ADD COLUMN start_time TIMESTAMP,
    ADD COLUMN end_time TIMESTAMP,
    ADD COLUMN status VARCHAR(20) DEFAULT 'Draft',
    ADD COLUMN start_mileage INTEGER,
    ADD COLUMN end_mileage INTEGER;
CREATE INDEX vehicle_trips_driver_idx ON vehicle_trips(driver_id);
CREATE INDEX vehicle_trips_status_idx ON vehicle_trips(status);
