 
 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,

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 ONLY pathfinder_application
    ADD CONSTRAINT pk_pathfinder_application PRIMARY KEY (id);

ALTER TABLE ONLY pathfinder_user
    ADD CONSTRAINT pk_pathfinder_user PRIMARY KEY (id);

ALTER TABLE ONLY vehicle
    ADD CONSTRAINT pk_vehicle PRIMARY KEY (id);
