 
 drop table if exists pathfinder_application;
 
+drop table if exists pathfinder_user;
+
 drop table if exists vehicle;
 

ALTER TABLE ONLY commodity ALTER COLUMN id SET DEFAULT nextval('commodity_id_seq'::regclass);


ALTER TABLE ONLY vehicle ALTER COLUMN id SET DEFAULT nextval('vehicle_id_seq'::regclass);




ALTER TABLE pathfinder_application OWNER TO pathfinderwebserver;

CREATE TABLE pathfinder_user (
    username character varying(255) NOT NULL,
    password character varrying(255) NOT NULL,
    user_token bytea NOT NULL
);


ALTER TABLE pathfinder_user OWNER TO pathfinderwebserver;

CREATE SEQUENCE pathfinder_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER TABLE commodity_id_seq OWNER TO pathfinderwebserver;

ALTER SEQUENCE commodity_id_seq OWNED BY commodity.id;


CREATE TABLE vehicle (
    id bigint NOT NULL,
    latitude double precision NOT NULL,
