gistfile1.txt

-- Table: public.units

-- DROP TABLE public.units;

CREATE TABLE public.units
(
    id text COLLATE pg_catalog."default" NOT NULL,
    "position" geography NOT NULL,
    altitude double precision NOT NULL DEFAULT 0,
    type text COLLATE pg_catalog."default",
    name text COLLATE pg_catalog."default",
    pilot text COLLATE pg_catalog."default",
    "group" text COLLATE pg_catalog."default",
    coalition integer NOT NULL,
    heading integer,
    updated_at timestamp without time zone NOT NULL,
    deleted boolean,
    speed integer NOT NULL,
    CONSTRAINT units_pkey PRIMARY KEY (id)
)

TABLESPACE pg_default;

ALTER TABLE public.units
    OWNER to overlordbot;