 ALTER SEQUENCE commodity_id_seq OWNED BY commodity.id;
 
 
-CREATE TABLE pathfinder_application (
-    id uuid NOT NULL,
-    name character varying(255),
-    token bytea,
-    cluster_id bigint
-);
-
-
-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 pathfinder_user.id;
 
 
 CREATE TABLE vehicle (

    ADD CONSTRAINT pk_commodity PRIMARY KEY (id);


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);


alter table commodity drop constraint if exists fk_commodity_cluster_id;
drop index if exists ix_commodity_cluster_id;

alter table vehicle drop constraint if exists fk_vehicle_cluster_id;
drop index if exists ix_vehicle_cluster_id;

