/*
 * Create a "runs" table to track statistics based on runs.
 */
BEGIN;
CREATE TABLE runs (
    meta_id text PRIMARY KEY,
    start_time timestamptz NOT NULL,
    vehicle text NOT NULL,
    vehicle_type text NOT NULL,
    run_type text,
    end_time timestamptz
);
CREATE INDEX runs_start_time ON runs (start_time);
COMMIT;

