cockroachdb-movr

First step

CREATE DATABASE movr;
USE movr;

CREATE TABLE vehicles (
        id UUID PRIMARY KEY,
        last_longitude FLOAT8,
        last_latitude FLOAT8,
        battery INT8,
        last_checkin TIMESTAMP,
        in_use BOOL,
        vehicle_type STRING NOT NULL
    );

INSERT INTO vehicles (id, last_longitude, last_latitude, battery, last_checkin, in_use, vehicle_type) VALUES
	('0001b16c-36b9-4b3f-a2ff-566061f36e03', (-73.91734), 40.61334, 89, '2020-04-30 12:59:15+00:00', false, 'scooter'),
	('00077691-3be2-4440-a34c-f604c9716f99', (-74.42406), 40.70211, 40, '2020-04-30 00:11:08+00:00', false, 'scooter');